search

muukis / l4dstats

SourceMod plugin (Custom Player Stats) for collecting statistics and creating player ranking in Left 4 Dead and Left 4 Dead 2 games
https://forums.alliedmods.net/showthread.php?t=115965
17 stars 9 forks source link

New plugin version (v1.4B120) breaks google maps #1

Closed el-psycho closed 4 years ago

el-psycho commented 12 years ago

The new plugin version (v1.4B120) breaks Google maps for some reason. Had to go back to the old version.

EDIT: It's happening with the old version too! I think the problem is the new GeoIPCountryCSV.zip Going back to a backup of the database solved the problem.

muukis commented 12 years ago

It is most likely not about the plugin itself, but very likely about the database and/or the webstats? Maybe the GeoIPCountryCSV has altered somehow? I'll check on this soon. Thanks for reporting!

muukis commented 12 years ago

Are you sure you downloaded the IPv4 format CSV files, and not the IPv6? Are you sure the installation of the database tables finished properly and your ip2country tables are good? My old data is working just fine and looking at the difference between my old CSV files and the ones I downloaded from the site are pretty much the same.

el-psycho commented 12 years ago

Thats strange. Started with a fresh database installed. i made a backup and erased the one i had. i downloaded GeoIPCountryCSV.zip from http://www.maxmind.com/download/geoip/database/ the install.php finishes correctly and it says the installation completed succesfully. Beyond that i didnt check anymore.

muukis commented 12 years ago

I'll do an installation with the new files...

el-psycho commented 12 years ago

I'm doing the same right now to give you more info.

el-psycho commented 12 years ago

Doesn't work. here is the output of install.php http://pastebin.com/TwW15pMW

el-psycho commented 12 years ago

Got it to work. I had to install with GeoLiteCity-Blocks.csv and GeoLiteCity-Location.csv or maps are broken. I guess that makes sense now that i think about it but it's not clear in the config.php that you need ALL $showmap, $showplayerflags AND $showplayercity to be true for maps to show up on the index page.

However, the page is really slow. EDIT: Nevermind, its back to normal. had to do: ALTER TABLE table_name ENGINE = MyISAM; for each table. It was using Innodb. maybe MyISAM is a good default to add to the install.php?

muukis commented 11 years ago

Yes, the location data should probably locate in a MyISAM table. I'll fix it to the next version. InnoDB supports transactions and that's why I chose it as a generic option for the engine. Location data is read-only so transactions are not required. Thanks for the find!

Created a separate issue for this.