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

galadril

Quote:

Originally Posted by McDean

How did you do that?

Here is a new version
http://www.megaupload.com/?d=O9NDC3NZ

Little update:
- Added a setting to specify if you want Europe or US date/time format
- Added the nr of dominations on the player_ranking page

**DarthNinja**

Quote:

Originally Posted by cybersquare420

nice! you know what would be nice? if you could sort the player ranking page by the column by clicking the column name, so clicking the column name would sort results by the values in that column...
just a thought

Um, it does that already.

Cadav0r

Sorting by Time played and Last connection doesn't work!!!

cybersquare420 · *Last edited by cybersquare420; 09-13-2010 at 11:30.*

DOH!!! im sorry, it was not loading earlier for some reason... it is working now.

so in conclusion... IM A MORON.... or something.. lol

ignore the earlier statements all together... in fact ima just delete them to avoid confusion...

edit: it only sorts the results from the current page though... :/ i think this has been mentioned before once... a while ago... now that i think of it, but ill mention it again in case it was forgotten...

galadril

Quote:

Originally Posted by cybersquare420

it only sorts the results from the current page though...

This was a simple solution

, i'll look into this multiple page sorting..

**DarthNinja**

Its come to my attention that the GeoIP.dat included with SM releases/snapshots are not updated, and have not been for quite a while.

I attached a new version to the OP that should help/eliminate "Unknown" location errors, just download and upload it, you will most likely have to restart your server to install it.

You can also get the latest binary version from here:
http://www.maxmind.com/app/geoip_country
It's currently the same as the attached version.

I'm going to start including the latest GeoIP.dat within the plugin release file, just make sure you don't overwrite the new version with SM's old one when you update your SM build.
-I'm going to try to get them to include an updated file.

ltgenkd · *Last edited by ltgenkd; 09-14-2010 at 08:09. Reason: added stats link*

Nice plugin, I am getting some errors.

Code:

L 09/13/2010 - 00:55:04: SourceMod error session started
L 09/13/2010 - 00:55:04: Info (map "cp_dustbowl") (file "errors_20100913.log")
L 09/13/2010 - 00:55:04: [SM] Native "SQL_TQuery" reported: Invalid database Handle 0 (error: 4)
L 09/13/2010 - 00:55:04: [SM] Displaying call stack trace for plugin "TF2_Stats.smx":
L 09/13/2010 - 00:55:04: [SM]   [0]  Line 3761, C:\sourcemod compile 1.3.4 hg3003\scripting\TF2_Stats.sp::createdbtables()
L 09/13/2010 - 00:55:04: [SM]   [1]  Line 333, C:\sourcemod compile 1.3.4 hg3003\scripting\TF2_Stats.sp::OnPluginStart()

Here is line 3761:

Code:

SQL_TQuery(db, T_CheckDBUptodate1, query)

Here is line 333:

Code:

createdbtables()

http://usmcclan2.com/tf2stats/

Also having problems accessing "webrank" in-game.
CFG Settings:

Code:

rank_webrank                                "1"        //Enable ingame viewing of webrank <1/0>
rank_webrankurl                                "http://usmcclan2.com/tf2stats/"        //Webrank URL, example: http://yoursite.com/stats/  (Remember the ending slash!)

**DarthNinja**

Quote:

Originally Posted by ltgenkd

Nice plugin, I am getting some errors.

Code:

L 09/13/2010 - 00:55:04: SourceMod error session started
L 09/13/2010 - 00:55:04: Info (map "cp_dustbowl") (file "errors_20100913.log")
L 09/13/2010 - 00:55:04: [SM] Native "SQL_TQuery" reported: Invalid database Handle 0 (error: 4)
L 09/13/2010 - 00:55:04: [SM] Displaying call stack trace for plugin "TF2_Stats.smx":
L 09/13/2010 - 00:55:04: [SM]   [0]  Line 3761, C:\sourcemod compile 1.3.4 hg3003\scripting\TF2_Stats.sp::createdbtables()
L 09/13/2010 - 00:55:04: [SM]   [1]  Line 333, C:\sourcemod compile 1.3.4 hg3003\scripting\TF2_Stats.sp::OnPluginStart()

Here is line 3761:

Code:

SQL_TQuery(db, T_CheckDBUptodate1, query)

Here is line 333:

Code:

createdbtables()

Here is line 3:
L 09/13/2010 - 00:55:04: [SM] Native "SQL_TQuery" reported: Invalid database Handle 0 (error: 4)

(of your error)

ltgenkd

Quote:

Originally Posted by DarthNinja

Here is line 3:
L 09/13/2010 - 00:55:04: [SM] Native "SQL_TQuery" reported: Invalid database Handle 0 (error: 4)

(of your error)

Would you be so kind as to enlighten me on a fix for this?

Than You

**DarthNinja**

Quote:

Originally Posted by ltgenkd

Would you be so kind as to enlighten me on a fix for this?

Than You

"Invalid database Handle"
Your database handle is invalid.

Check your database.cfg and/or database user (IP) permissions.