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

siddis

"rank_connectcountry" doesnt work and
I get this error in the log after the last ver.(7.0.0) installed;

Code:

L 10/16/2010 - 16:32:36: [SM]   [0]  Line 3607, C:\sourcemod compile 1.3.5 hg3053\scripting\TF2_Stats.sp::T_ShowrankConnectingUsr2()

galadril · *Last edited by galadril; 10-17-2010 at 06:51.*

Quote:

Originally Posted by ltgenkd

I may be wrong but, on the new demo page listed above its version# is 7.1.1
After downloading and extracting the Webui zip 7.1.1, the 2nd folder says
TF2 Ranking Web Interface v7.1.0 ?
After installing, the version # is 7.1.0 not 7.1.1.
Maybe that's why i am getting the errors on that page.
Just wondering if there is a file missing.

The queries looks oke:
SELECT sum(KW_Axe) as Sum FROM `player`

can you run this query on your mysql server?
It retrieves the total kills for one weapon on a server..

the real error is; Table 'usmcclan_tf2stats.player' doesn't exist

ltgenkd · *Last edited by ltgenkd; 10-17-2010 at 07:26. Reason: added url*

I found the error

Its on line 29 of weapon_ranking.php

Existing line:

Code:

$sqlweapondetail = "SELECT sum(".$w['WEAPON'].") as Sum FROM `player`";

Should be:

Code:

$sqlweapondetail = "SELECT sum(".$w['WEAPON'].") as Sum FROM `Player`";

Small p in player. All fixed now

http://usmcclan2.com/tf2stats/weapon_ranking.php

galadril

Quote:

Originally Posted by ltgenkd

I found the error

Its on line 29 of weapon_ranking.php

Existing line:

Code:

$sqlweapondetail = "SELECT sum(".$w['WEAPON'].") as Sum FROM `player`";

Should be:

Code:

$sqlweapondetail = "SELECT sum(".$w['WEAPON'].") as Sum FROM `Player`";

Small p in player. All fixed now

http://usmcclan2.com/tf2stats/weapon_ranking.php

Oke cool.. But the plugin created all tables with small characters on my mysql server.. :-)

Tema · *Last edited by Tema; 10-17-2010 at 07:58.*

After install the Webui v7.1.1 I incorrectly shows the Player History, best classes and Class information.
http://box.iptel.by/tf2/stats/player...M_0:0:23448722
and
http://box.iptel.by/tf2/stats/player_class.php

ltgenkd · *Last edited by ltgenkd; 10-17-2010 at 08:21.*

Quote:

Originally Posted by galadril

Oke cool.. But the plugin created all tables with small characters on my mysql server.. :-)

Ok but, look @ line 29 then look @ line 60.

29 is player
60 is Player

My Player table is:
Player not player

Hmm, wonder how your table is player and mine is Player

Also, when you go to the weapon_ranking page, It shows Map Ranking in title. No biggie that is a easy fix, just wanted you to know.

EDIT:
My database tables all begin with small letters except Map and Player

**DarthNinja**

Quote:

Originally Posted by siddis

"rank_connectcountry" doesnt work and
I get this error in the log after the last ver.(7.0.0) installed;

Code:

L 10/16/2010 - 16:32:36: [SM]   [0]  Line 3607, C:\sourcemod compile 1.3.5 hg3053\scripting\TF2_Stats.sp::T_ShowrankConnectingUsr2()

rank_connectcountry works fine.
What is the state of your GeoIP database?

eraserhead

Galadril, i don't understand the class ranking. How can we see who is the best scout, spy or w/e class?

Because it sorts the player with total kills on top but that way you still can't see who is the top ranking scout.

So what i suggest is either sortable columns for each class or a sub-navigation bar with the 9 classes or just replace the compare buttons with class buttons.

McDean

Im finding that turning top10wav sound off wont stop it :S i got:

rank_connectsoundtop10 "0" //Play a special sound for players in the Top 10
rank_connectsoundfiletop10 "tf2stats/top10.wav" //Sound to play for Top10s

Thats what i got in my tf2stats.ctg file.

Everytime someone connects it comes up with the download bar down bottom right waits there for about 5sec then goes away. Is that meant to happen or is something stuffing up. I thought having it to zero it just wouldnt bother like with the connecting sound

galadril

Quote:

Originally Posted by eraserhead

Galadril, i don't understand the class ranking. How can we see who is the best scout, spy or w/e class?

Because it sorts the player with total kills on top but that way you still can't see who is the top ranking scout.

So what i suggest is either sortable columns for each class or a sub-navigation bar with the 9 classes or just replace the compare buttons with class buttons.

I added sorting..
http://www.heinisblog.nl/tf2stats/player_class.php

Please check it out and click on the column headers..