[hextasy]

nevermind it, I didn't have my database config set

but I'm still having problems. The in command game 'webrank' opens up a window that 404's.

[Tue Feb 16 02:28:53 2010] [error] [client 67.247.91.17] File does not exist: /var/www/html/statsid/STEAM_0:1:9663453 [Tue Feb 16 02:28:53 2010] [error] [client 67.247.91.17] File does not exist: /var/www/html/var

I assume this has something to do with the .httaccess file.

ideas?

[DarthNinja]

Originally Posted by hextasy nevermind it, I didn't have my database config set but I'm still having problems. The in command game 'webrank' opens up a window that 404's. I assume this has something to do with the .httaccess file. ideas?

It's broken and needs fixing.

[hextasy]

oh hey, thanks for the quick response. I got it working with a bit of tweaking.

Another config error on my part I just added a trailing / to the end of my rank_webrankurl in tf/cfg/tf2-stats.cfg and a bit of tweaking to the a href tags in the header/footers and a couple of the mian pages (player_ranking.php for example) Nothing too major, I just had to sit and think about it a while

seems to be working just dandy now.

[`666]

Originally Posted by DarthNinja Cool. Common enough mistake, just takes a little trouble shooting. Heres the fix (for anyone else that doesn't know): Double brackets end the file, anything after is ignored.

Image got deleted, can you re-upload again please

[gnarf]

Can anyone link or give me directions like they would their grandma? I've got zero experience with mysql (installed it tonight just for this) and only slightly more with php/apache. I've tried to modify settings.php and do all the steps in the first post but I get "DB Query failed" on the main page and none of the other pages load. For top10 it redirects to top.php but the included file is top10.php going to top10.php manually i get "Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /var/www/top10.php on line 138"

http://idle.no-ip.org is where its hosted, the gameserver and webserver are the same box

[DarthNinja]

Originally Posted by gnarf Can anyone link or give me direction

"DB Query failed" means the php page cannot find the database.
Make sure you have everything posted correctly in the config.
If you do, your server may have connection issues.

Need more info on your (web)server/config etc.

Note: you'll also get that error if the database you have the page connecting to has nothing in it.
This would be caused by an issue with the plugin connecting to the mysql server.

Make sure there is ranking data in the database, if not, check the plugin.
If the plugin has ranking data but the database doesnt, the plugin is using sqlite on the server: Check your plugin config.

[eraserhead]

Originally Posted by gnarf Can anyone link or give me directions like they would their grandma?

I made a guide that should be easy to follow for everyone. Here it is: https://forums.alliedmods.net/showpo...&postcount=152

[`666]

thanks for the tutorial.

[gnarf]

Yes thank you very much

however

Load Errors:
[TF2] Player Stats: Error detected in plugin startup (see error logs)
sm plugins unload 23
[SM] Plugin [TF2] Player Stats unloaded successfully.
sm plugins refresh
Failed to connect: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 02/18/2010 - 12:05:19: [SM] Native "SQL_TQuery" reported: Invalid database Handle 0 (error: 4)
L 02/18/2010 - 12:05:19: [SM] Displaying call stack trace for plugin "n1g-tf2-stats.smx":
L 02/18/2010 - 12:05:19: [SM]   [0]  Line 2915, C:\sourcemod compile\addons\sourcemod\scripting\n1g-tf2-stats.sp::createdbtables()
L 02/18/2010 - 12:05:19: [SM]   [1]  Line 189, C:\sourcemod compile\addons\sourcemod\scripting\n1g-tf2-stats.sp::OnPluginStart()

the last two lines puzzle me as I'm using a linux server.

[hextasy]

compile the plugin from source, see if that resolves