[blitzzz]

can someone help? i'm getting this on my error log

L 08/04/2010 - 04:05:07: [l4d_stats.smx] Failed to connect to database: [2003]: Can't connect to MySQL server on 'mysql16.000webhost.com' (10060)
L 08/04/2010 - 04:05:07: [SM] Plugin encountered error 25: Call was aborted
L 08/04/2010 - 04:05:07: [SM] Native "SetFailState" reported: Connecting to database failed. Read error log for further details.
L 08/04/2010 - 04:05:07: [SM] Displaying call stack trace for plugin "l4d_stats.smx":
L 08/04/2010 - 04:05:07: [SM] [0] Line 948, /home/groups/alliedmodders/forums/files/5/2/0/8/2/66015.attach::OnConfigsExecuted()
L 08/04/2010 - 04:05:10: Error log file session closed.

Just to add, i registered for a free mysql server i randomly encountered in the internet. It also offers a free website. I was able to set up the webstats on the website nicely. but somehow my error log says it cant connect to mysql server...

[Ja-Forces]

code cleanup ( fixed warning 213: tag mismatch )

[Crotan]

Originally Posted by Ja-Forces code cleanup ( fixed errors )

What plugin is this? It doesn't have the smx extension like that posted for the stats mod?

Ninja edit: yes it does , but why are you posting it not muukis?

On another note, I'm trying to get this set up on a server and have the web side of it up and running yet the game server doesn't seem to be recognizing the plugin. When using the command

sm plugins list

I get:

"Admin File Reader" (1.3.4) by AlliedModders LLC
"Admin Help" (1.3.4) by AlliedModders LLC
"Admin Menu" (1.3.4) by AlliedModders LLC
"Anti-Flood" (1.3.4) by AlliedModders LLC
"Basic Chat" (1.3.4) by AlliedModders LLC
"Basic Comm Control" (1.3.4) by AlliedModders LLC
"Basic Commands" (1.3.4) by AlliedModders LLC
"Basic Info Triggers" (1.3.4) by AlliedModders LLC
"Basic Votes" (1.3.4) by AlliedModders LLC
"Client Preferences" (1.3.4) by AlliedModders LLC
To see more, type "sm plugins 12"
] sm plugins 12
"Fun Votes" (1.3.4) by AlliedModders LLC
"Player Commands" (1.3.4) by AlliedModders LLC
"Reserved Slots" (1.3.4) by AlliedModders LLC
"Sound Commands" (1.3.4) by AlliedModders LLC
"SourceBans" (1.4.6) by InterWave Studios Development Team

You can see l4d_stats isn't listed there yet I have the l4d_stats.smx file in the same exact directory as my Sourcebans smx

/left4dead2/left4dead2/addons/sourcemod/plugins

Any help?

[Mentol]

Someone can help me
I have problems when me run createtable.php an error appears like this

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in D:\wamp\www\L4D\createtable.php on line 18 No database selected No database selected No database selected All tables cereated successfully!

[muukis]

Originally Posted by ki1418z Can this plugins save the players data based on player id not steam id?

What is this player id you are talking about? If you mean by player name, no it cannot. Someone made a hack that does this, but I would not recommend it. The stats will very likely get "corrupted" by player name changes etc.

Originally Posted by realdreams A bug: in some addon maps, no survivors incaped in panic event shows right after panic event starts (zombies not even close yet).

That problem is likely caused by SM or the map itself. The panic event is not triggered by the plugin, but the engine. The "no survivors incapped" -message is shown after an panic event end -event is triggered. Not sure how I could fix this? Thanks for reporting anyways

Originally Posted by realdreams BTH in the config there's a setting to read ip-country from another DB,does it also work for ip-city info?

Yes it does.

Originally Posted by blitzzz can someone help? i'm getting this on my error log L 08/04/2010 - 04:05:07: [l4d_stats.smx] Failed to connect to database: [2003]: Can't connect to MySQL server on 'mysql16.000webhost.com' (10060) L 08/04/2010 - 04:05:07: [SM] Plugin encountered error 25: Call was aborted L 08/04/2010 - 04:05:07: [SM] Native "SetFailState" reported: Connecting to database failed. Read error log for further details. L 08/04/2010 - 04:05:07: [SM] Displaying call stack trace for plugin "l4d_stats.smx": L 08/04/2010 - 04:05:07: [SM] [0] Line 948, /home/groups/alliedmodders/forums/files/5/2/0/8/2/66015.attach::OnConfigsExecuted() L 08/04/2010 - 04:05:10: Error log file session closed. Just to add, i registered for a free mysql server i randomly encountered in the internet. It also offers a free website. I was able to set up the webstats on the website nicely. but somehow my error log says it cant connect to mysql server...

It is likely that the DB server does not allow remote connections... Google "mysql remote access".

Originally Posted by Crotan On another note, I'm trying to get this set up on a server and have the web side of it up and running yet the game server doesn't seem to be recognizing the plugin. When using the command sm plugins list I get: "Admin File Reader" (1.3.4) by AlliedModders LLC "Admin Help" (1.3.4) by AlliedModders LLC "Admin Menu" (1.3.4) by AlliedModders LLC "Anti-Flood" (1.3.4) by AlliedModders LLC "Basic Chat" (1.3.4) by AlliedModders LLC "Basic Comm Control" (1.3.4) by AlliedModders LLC "Basic Commands" (1.3.4) by AlliedModders LLC "Basic Info Triggers" (1.3.4) by AlliedModders LLC "Basic Votes" (1.3.4) by AlliedModders LLC "Client Preferences" (1.3.4) by AlliedModders LLC To see more, type "sm plugins 12" ] sm plugins 12 "Fun Votes" (1.3.4) by AlliedModders LLC "Player Commands" (1.3.4) by AlliedModders LLC "Reserved Slots" (1.3.4) by AlliedModders LLC "Sound Commands" (1.3.4) by AlliedModders LLC "SourceBans" (1.4.6) by InterWave Studios Development Team You can see l4d_stats isn't listed there yet I have the l4d_stats.smx file in the same exact directory as my Sourcebans smx /left4dead2/left4dead2/addons/sourcemod/plugins Any help?

You will have to check your game server logs. Most likely your game server is unable to connect to your DB server and for that reason is unloaded.

Originally Posted by Mentol Someone can help me I have problems when me run createtable.php an error appears like this

Check the config.php and particularly the database section. Make sure the settings are correct.

[Crotan]

Originally Posted by muukis You will have to check your game server logs. Most likely your game server is unable to connect to your DB server and for that reason is unloaded.

left4dead2\left4dead2\addons\sourcemod\logs\

Not seeing any log files created there that I would expect to find for the stats mod?

A file such as l4d_stats.log would be what I would expect no? If so I have nothing. Would it be created under another name? In another location?

[Sable]

Hi,

Everything looks fine and I am not getting any immediate errors however the Players Online section is not showing anyone online when there are people on the server and the Server Stats page is showing the following:

Warning: Template::include(./templates/) [function.Template-include]: failed to open stream: Success in /home/Sable/public_html/left4dead2/stats/class_template.php on line 35

Warning: Template::include(./templates/) [function.Template-include]: failed to open stream: Success in /home/Sable/public_html/left4dead2/stats/class_template.php on line 35

Warning: Template::include() [function.include]: Failed opening './templates/' for inclusion (include_path='.:/usr/local/lib/php/PEAR:/usr/lib/php:/usr/local/lib/php') in /home/Sable/public_html/left4dead2/stats/class_template.php on line 35

Edit: So it seems even though I have set my server up to receive external connections from my L4D2 server, its still not connecting.

Any suggestions on what I may have missed?

[muukis]

Originally Posted by Crotan left4dead2\left4dead2\addons\sourcemod\logs\ Not seeing any log files created there that I would expect to find for the stats mod? A file such as l4d_stats.log would be what I would expect no? If so I have nothing. Would it be created under another name? In another location?

It looks something like this: errors_20100804.log. The location is correct. If you try to load the plugin manually from the game server console, does it not say anything about why it is unable to load?

Originally Posted by Sable Hi, Everything looks fine and I am not getting any immediate errors however the Players Online section is not showing anyone online when there are people on the server and the Server Stats page is showing the following: Warning: Template::include(./templates/) [function.Template-include]: failed to open stream: Success in /home/Sable/public_html/left4dead2/stats/class_template.php on line 35 Warning: Template::include(./templates/) [function.Template-include]: failed to open stream: Success in /home/Sable/public_html/left4dead2/stats/class_template.php on line 35 Warning: Template::include() [function.include]: Failed opening './templates/' for inclusion (include_path='.:/usr/local/lib/php/PEAR:/usr/lib/php:/usr/local/lib/php') in /home/Sable/public_html/left4dead2/stats/class_template.php on line 35 Edit: So it seems even though I have set my server up to receive external connections from my L4D2 server, its still not connecting. Any suggestions on what I may have missed?

Ask your service provider if the DB is blocked from outside via firewall. Templates: Check if the files are there and if they are, make sure the web user has read access to all of them. The awards cache file should have write access in addition to read access.

[Crotan]

If i type in sm plugins load l4d_stats it will just return the list of plugins installed on the server

left4dead2\left4dead2\addons\sourcemod\logs\e rrors_20100805.log

L 08/05/2010 - 00:192: [l4d_stats.smx] Failed to connect to database: [1045]: Access denied for user 'flot_l4dstat'@'208.122.52.130' (using password: YES) L 08/05/2010 - 00:192: [SM] Plugin encountered error 25: Call was aborted L 08/05/2010 - 00:192: [SM] Native "SetFailState" reported: Connecting to database failed. Read error log for further details. L 08/05/2010 - 00:192: [SM] Displaying call stack trace for plugin "l4d_stats.smx": L 08/05/2010 - 00:192: [SM] [0] Line 948, /home/groups/alliedmodders/forums/files/5/6/0/8/6/71121.attach::OnConfigsExecuted()

Ok, hmm we had this working before on other servers and I thought I copied over the correct password for the mysql database, What's the significance of [1045]

Thanks for the continuing help

EDIT:

Doing some digging it appears my MySQL host might not like the new IP Address of this new server, and I may have to add access for it explicitly

I get the following error: Database failure: [1044/1045/1130/2002/2003] Submitted by Michiel on Thu, 08/13/2009 - 16:26 Your MySQL server does not allow incoming connections from your gameserver. To fix this, you can do either of the following: * Go into your webserver's control panel and check if there's a section called MySQL Access Hosts or something named similar. There you can add the IP address mentioned in the error. This is usually the IP of your gameserver, but it can also be slightly different, so make sure you copy and paste it exactly from the error. * The other option is to run the following query on your SourceBans database (for example using phpMyAdmin): GRANT ALL ON database.* TO 'username'@'ip'; You will have to replace "database" with your SourceBans database name, and "username" and "ip" with those mentioned in the error.

Well The database user already has full privileges, and I'm pretty sure the password is correct, but don't know how to verify passwords from cpanel. So I'm still stumped on why it's denying access

Now im positive that the password is correct because if I change it to a wrong one in both databases.cfg and the config.cfg for the web portion a wrong password will make the web stats display out the errors.

[LordTurbat]

Hi all i have it done but i have reinstal windows and i have a probleme that i dont hnow haw to fix it

http://img830.**************/i/67356577.jpg/
What i have to do ?