[PatriotGames]

Originally Posted by Dawg1 Ok after hours a arguing with my host and sorting out ip issues I know get this error? [l4d_stats.smx] Database is missing required table or tables. Native "SetFailState" reported: Connecting to database failed. Also says to read logs for more info, but there is no more info than this?

Dawg1,

The tables are not setup in your database. Since your website is with a hosting provider you probably have a control panel of some sort to use when installing a MySQL databases for your website. If you already installed a database for l4d2 stats and are having issues, it is probably best to go back to your website control panel and use the option to wipe the database, or delete it entirely and create a new one. It is fine to use the same name for the new database used for the old one.

Now, having done that and assuming that you have entered the correct connection information for your database in the config_example.php file that comes with L4D2 Stats, and then renamed the file to config.php, you simply load install.php in your browser and it will automatically setup the tables in your database.

You get install.php to load by entering the full address to the file in your web browser address bar and hitting enter. Let's say the name of the folder on your web server for the l4d2 stats files is "l4d2stats" and your website URL is "www.dawgone.com", then you would type in your web browser address bar:

http://www.dawgone.com/l4d2stats/install.php

and hit enter!

Install.php will then create the tables in your MySQL database and show you the output info right there in you browser. That's all you have to do. Then make sure you've edited the databases.cfg file in your sourcemod/configs directory to add the connection information for your l4d2 stats MySQL database.

Tip: if you want players' country flags shown next to their names in the stats, you should upload the GeoIPCountryWhois.csv file to your l4d2 stats folder BEFORE running install.php

1. Download and extract http://www.maxmind.com/download/geoi...CountryCSV.zip and then upload it to your l4d2 stats folder.
2. Execute install.php per the above instructions using your web browser - BE PATIENT AND WAIT FOR THE EXECUTION TO FINISH!
3. Delete files GeoIPCountryCSV.zip and GeoIPCountryWhois.csv when installation is successful

This way the country data is automatically incorporated when your tables are created the first time.

Hope this is helpful.

Regards,

Patriot

[mcpan313]

Tag mismatch fixed.

[WolfGang]

Someone tell me how I can create my own web for this? I'd have the SQL dump file install, but the only thing I have left is the website. I know the web is OPTIONAL but I want to try something new out. Someone please help on this?

[yokomo]

Hi, already installed this on my server, use all file from the 1st post, everything works fine in game, but i notice 1 problem on webpage, a massive error report:

Notice: Undefined variable: game_version in C:\x\x\l4d2\common.php on line 127

Notice: Undefined variable: game_version in C:\x\x\l4d2\common.php on line 142

Notice: Undefined variable: game_version in C:\x\x\l4d2\common.php on line 239

Notice: Undefined variable: game_version in C:\x\x\l4d2\common.php on line 239

Notice: Undefined variable: game_version in C:\x\x\l4d2\common.php on line 239

Notice: Undefined variable: game_version in C:\x\x\l4d2\common.php on line 239

Notice: Undefined variable: game_version in C:\x\x\l4d2\common.php on line 127

How do i fix this? already try this method https://forums.alliedmods.net/showpo...postcount=1489 but the error still there. I'm using Xampp and use local host (in the same machine).

[el_psycho]

Did you restart Xampp or your computer? the fact you are seeing that means error reporting is still on. Also did you change the existing line or added a new one?

[yokomo]

Originally Posted by el_psycho Did you restart Xampp or your computer? the fact you are seeing that means error reporting is still on. Also did you change the existing line or added a new one?

Now it work fine, yea it need to restart the Xampp first. No more error notice spams.

[Kahl_Drogo]

I have got this error on my stats

Deprecated: Function split() is deprecated in /home/xxxx/xxxx/xxxx/public_html/l4d2stats/common.php on line 741

Deprecated: Function split() is deprecated in /home/xxxx/xxxx/xxxx/public_html/l4d2stats/common.php on line 743

Anybody Know what is this mean ?

This error show when I set $showplayerflags = 1;

(I install GeoIPCountryWhois.csv , GeoLiteCity-Blocks.csv and GeoLiteCity-Location.csv succesfull)

[muukis]

Originally Posted by Kahl_Drogo I have got this error on my stats Deprecated: Function split() is deprecated in /home/xxxx/xxxx/xxxx/public_html/l4d2stats/common.php on line 741 Deprecated: Function split() is deprecated in /home/xxxx/xxxx/xxxx/public_html/l4d2stats/common.php on line 743 Anybody Know what is this mean ? This error show when I set $showplayerflags = 1; (I install GeoIPCountryWhois.csv , GeoLiteCity-Blocks.csv and GeoLiteCity-Location.csv succesfull)

It means you're running PHP version that looks split as deprecated function. You can fix it for yourself by applying this to those two lines listed by your post - maybe?

[muukis]

Originally Posted by PatriotGames ...

Originally Posted by el_psycho ...

Your help for people in need is greatly appreciated - Thanks!

My knowledge on Xampp and also pretty much everything else but a clean PHP install on an IIS server is limited at best.

[muukis]

Originally Posted by mcpan313 Tag mismatch fixed.

Thanks! Never bothered to look it up myself, but I will merge your fixes to the code on the next update. I'd like to also do something else to the code before I will do an update, so I don't know when it will be available at the first post.