[TF2 Stats] With Web Ranking and Item Logger [v9.1.0] - Page 38

halbblah · 02-04-2010 , 20:40 Re: [TF2 Stats] With Web Ranking and Item Logger [v6.1/6.5.5]

Please! could you add an entry to the config where you can specify the table name ? I want to have separate rankings for my servers !

edit: fearing this small request could be read over, so making this post bigger

Mr_Orange · *Last edited by Mr_Orange; 02-05-2010 at 00:48.*

Quote:

Please! could you add an entry to the config where you can specify the table name ? I want to have separate rankings for my servers !

If you have access to the sql server, you could do multiple databases and specify a different database for each server. I know 5 different tables are created by this plugin. One for data (this just contains the version number), one for founditems, one for kill logging, one for map data and the last for player data. This would make it kind of hard to have multiple servers store separate data in one database.

Just my 2 cents.

Mr_Orange · 02-05-2010 , 01:00 Re: [TF2 Stats] With Web Ranking and Item Logger [v6.1/6.5.5]

Actually, I just looked at the code. If you were willing to edit the code (not hard, code is decently readable), you could compile a different "version" of the plugin for each server you use and changed the coded names for the tables. The pertinent lines are 297 for the players table, 442 for the kill log, 460 for the maps, and 3274 for the items found. The database version could probably stay the same since I can't find the right line.

Then, if you use the web interface for this stuff, that's when the fun begins.

halbblah · *Last edited by halbblah; 02-05-2010 at 06:49.*

I didn't look into sourcemodcoding before. it's c++, right ? if visual studio can do it, I might give it a try. where to get the sourcecode ?
about the different databases: I may only have 2 databases at the same time :/

the 5 tables: just give em a unique prefix for each ranked server and it would be no problem imo. Doing this in the web interface, too, should be no problem as well

toddstallard · 02-05-2010 , 10:34 Re: [TF2 Stats] With Web Ranking and Item Logger [v6.1/6.5.5]

Is there a stetting not to track Bots in your rankings?
If not can you add that to the list.
Also how do you clear or reset the stats?
Thanks

Mr_Orange · 02-05-2010 , 13:41 Re: [TF2 Stats] With Web Ranking and Item Logger [v6.1/6.5.5]

Quote:

Also how do you clear or reset the stats?

Drop the tables or empty them.

Quote:

where to get the sourcecode ?

It's in the zip file under scripting, you can just open them in any text editor, though I recommend Notepad++ for convenience.

Quote:

the 5 tables: just give em a unique prefix for each ranked server and it would be no problem imo. Doing this in the web interface, too, should be no problem as well

Yeah it shouldn't be too hard, just a little bit of coding and tweaking.

OranjeHazelnoot · 02-07-2010 , 04:51 Re: [TF2 Stats] With Web Ranking and Item Logger [v6.1/6.5.5]

Thx Mr_Orange. the server changes for the apache.conf are working

Diavu · *Last edited by Diavu; 02-09-2010 at 06:02.*

heres those demo/soldier founditem icons for you.

http://thefortress.clanservers.com/t...ound/targe.png
http://thefortress.clanservers.com/t...d/scottish.png
http://thefortress.clanservers.com/t.../eyelander.png
http://thefortress.clanservers.com/t.../equalizer.png
http://thefortress.clanservers.com/t.../directhit.png
http://thefortress.clanservers.com/t...buffbanner.png
http://thefortress.clanservers.com/t...hats/boots.png

i made them myself incase anyones wondering.
seems like i forgot to remove the outline around most of them, damn im lazy ;p gotta remove that, just a sec.

so i made the changes to them, overwrote the exsisting images, and nothing happens...
if you need them i will upload a .zip somewhere ;_;

cybersquare420 · 02-09-2010 , 09:46 Re: [TF2 Stats] With Web Ranking and Item Logger [v6.1/6.5.5]

well... i got everything working by recoding all the links to ignore .htaccess... and in doing so i did some research... and it turns out that file is used by a server process on apache web servers... and this process is very easy to exploit giving the user root access to the web server... they own it... im obviously not gonna explain any further than that here... but suffice to say that if u r using apache u should disable that function and hard code all the links to protect your server. this included apache for windows as well... (especially apache for windows!!)

hextasy · *Last edited by hextasy; 02-12-2010 at 22:47.*

just fyi I had to change a the header and footer php code related to the map.php stats.php etc. they were linking to 404's

no big deal really if you know some basic stuff so I won't bother to post exactly what. that and I'm lazy

i'm getting a slew of other errors too with the web pannel

but I can get ranks and such from IN GAME

Quote:

[Fri Feb 12 21

7

5 2010] [error] [client 67.247.91.17] PHP Notice: Undefined index: steamid in /var/www/html/stats/player.php on line 12, referer: http://hob-games.com/stats/map_ranking.php
[Fri Feb 12 21

7

6 2010] [error] [client 67.247.91.17] PHP Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /var/www/html/stats/player.php on line 36, referer: http://hob-games.com/stats/map_ranking.php
[Fri Feb 12 21

7:40 2010] [error] [client 67.247.91.17] PHP Notice: Undefined variable: fromplayer in /var/www/html/stats/top10.php on line 37, referer: http://hob-games.com/stats/map_ranking.php
[Fri Feb 12 21

7:40 2010] [error] [client 67.247.91.17] PHP Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /var/www/html/stats/top10.php on line 38, referer: http://hob-games.com/stats/map_ranking.php
[Fri Feb 12 21

7:40 2010] [error] [client 67.247.91.17] PHP Notice: Undefined variable: fromplayer in /var/www/html/stats/top10.php on line 136, referer: http://hob-games.com/stats/map_ranking.php
[Fri Feb 12 21

7:40 2010] [error] [client 67.247.91.17] PHP Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /var/www/html/stats/top10.php on line 137, referer: http://hob-games.com/stats/map_ranking.php
[Fri Feb 12 21

9

6 2010] [error] [client 67.247.91.17] PHP Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /var/www/html/stats/map_ranking.php on line 33, referer: http://hob-games.com/stats/top10.php
[Fri Feb 12 21

9

6 2010] [error] [client 67.247.91.17] File does not exist: /var/www/html/default.css, referer: http://hob-games.com/stats/map_ranking.php
[Fri Feb 12 21

9

6 2010] [error] [client 67.247.91.17] File does not exist: /var/www/html/var, referer: http://hob-games.com/stats/map_ranking.php
[Fri Feb 12 21:43:53 2010] [error] [client 67.247.91.17] PHP Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /var/www/html/stats/map_ranking.php on line 33, referer: http://hob-games.com/stats/index.php
[Fri Feb 12 21:43:53 2010] [error] [client 67.247.91.17] File does not exist: /var/www/html/default.css, referer: http://hob-games.com/stats/map_ranking.php
[Fri Feb 12 21:43:53 2010] [error] [client 67.247.91.17] File does not exist: /var/www/html/var, referer: http://hob-games.com/stats/map_ranking.php
[Fri Feb 12 21:43:56 2010] [error] [client 67.247.91.17] PHP Notice: Undefined index: steamid in /var/www/html/stats/player.php on line 12, referer: http://hob-games.com/stats/map_ranking.php
[Fri Feb 12 21:43:56 2010] [error] [client 67.247.91.17] PHP Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /var/www/html/stats/player.php on line 36, referer: http://hob-games.com/stats/map_ranking.php
[Fri Feb 12 21:44:00 2010] [error] [client 67.247.91.17] PHP Notice: Undefined variable: fromplayer in /var/www/html/stats/top10.php on line 37, referer: http://hob-games.com/stats/map_ranking.php
[Fri Feb 12 21:44:00 2010] [error] [client 67.247.91.17] PHP Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /var/www/html/stats/top10.php on line 38, referer: http://hob-games.com/stats/map_ranking.php
[Fri Feb 12 21:44:00 2010] [error] [client 67.247.91.17] PHP Notice: Undefined variable: fromplayer in /var/www/html/stats/top10.php on line 136, referer: http://hob-games.com/stats/map_ranking.php
[Fri Feb 12 21:44:00 2010] [error] [client 67.247.91.17] PHP Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /var/www/html/stats/top10.php on line 137, referer: http://hob-games.com/stats/map_ranking.php
[root@server stats]#