N1G-TF2-RANK - TF2 Ranking with optional Webinterface

[r5053]

Plugin Name: N1G-TF2-RANK

This is a Stats Plugin for TF2 with optional MYSQL and optional webinterface

Servers Using this Plugin: http://www.game-monitor.com/search.php?vars=sm_tf2_stats_version or ingame with the sv_tag n1grank

If Somebody want to Contact the Author of this Plugin directly or want to get Plugin Update News on Steam join this Group: http://steamcommunity.com/groups/TF2STATS


http://compactaim.de/downloads/cp_dustbowl0023.jpg

http://www.compactaim.de/downloads/cp_dustbowl0146.jpg

how2install it:

without mysql and webinterface:
1. Copy the *.smx file into your plugin's folder.
2. Play

with mysql: (needed for the webinterface)

1. Enter the Database you would use into the source mod db config file
"tf2stats"
{
"driver" "mysql"
"host" "127.0.0.1"
"database" "tf2_stats"
"user" "tf2st_usr"
"pass" "dbpassword"
//"timeout" "0"
"port" "3306"
}
Note: sourcemod needs a restart to read the new dbconfig

2. Copy the *.smx file into your plugin's folder.
3. Play

Cvars:

//////////////// Settings /////////////////////

// enable disabling of the Ranking after roundwin
rank_disableafterroundwin "1"

// enable / disable the Extendedlogging
rank_extendetlogging "0"

// "Defines the time until a entry in the Kill log gets removed in hours 0 = disabled"
rank_extlogcleanuptime "72"


// How many clients are needed to start ranking
rank_neededplayers "0"

// Enable Automatic Removing Maps who wasn't played a specific time on every Roundend
rank_removeoldmaps "1"

// The time in days after a map get removed, min 1 day
rank_removeoldmapsdays "14"

// Enable Automatic Removing Player who haven't conected a specific time on every Roundend
rank_removeoldplayers "1"

// The time in days after a player get removed if he havn't connected, min 1 day
rank_removeoldplayersdays "14"

// Show Rank on connect, 0=disabled, 1=clientchat, 2=allchat, 3=panel, 4=panel + all chat
rank_show "4"

// Show Top 10 on Roundend
rank_showrankonroundend "1"

// Enable/Disable Webrank
rank_webrank "0"

// Webrank url like http://compactaim.de/tf2stats/
rank_webrankurl "http://compactaim.de/tf2stats/"

// Display points add message 0 = disabled, 1 = all, 2 = only who earned
rank_pointmsg "2"

//Play a sound if a player connects? 1= Yes 0 = No
rank_connectsound "1"

//Set the Soundfile who get played if someone connects
rank_connectsoundfile "buttons/blip1.wav"

//show the rankchatcommands to every one 1 = yes 2= no
rank_showchatcommands "1"

//show rank to all players if someone type rank
rank_showranktoall "1"

//Set the Chattag
rank_chattag "RANK"
//////////////// Event points /////////////////////

// Set the points the blocker get
rank_blockcapturepoints "4"

// Set the points the capturing team get
rank_capturepoints "4"

// Set the points the capturing team get
rank_filecapturepoints "4"

// Set the points the medic get if he overcharge someone
rank_overchargepoints "1"

rank_stealsandvichpoints "1"

//////////////// Building destroy points /////////////////////

rank_killdisppoints "2"
rank_killsapperpoints "1"
rank_killsentrypoints "3"
rank_killteleinpoints "1"
rank_killteleoutpoints "1"

//////////////// Kill points /////////////////////

// Set the points a player lose on Death
rank_Scoutdiepoints "2"
rank_Soldierdiepoints "2"
rank_Pyrodiepoints "2"
rank_Medicdiepoints "2"
rank_Sniperdiepoints "2"
rank_Spydiepoints "2"
rank_Demomandiepoints "2"
rank_Heavydiepoints "2"
rank_Engineerdiepoints "2"

// Set the points the medic assister get on a kill
rank_killasimedicpoints "2"

// Set the points the assister get on a kill
rank_killasipoints "2"

// Set the points the extingushing get
rank_extingushingpoints "1"

//////////////// Weapon kill points /////////////////////

// Set the points the attacker get

rank_axtinguisherpoints "4"
rank_backburnerpoints "2"
rank_batpoints "4"
rank_bat_woodpoints "4"
rank_blutsaugerpoints "2"
rank_bonesawpoints "4"
rank_bottlepoints "4"
rank_clubpoints "4"
rank_deflect_promodepoints "2"
rank_deflect_rocketpoints "2"
rank_deflect_stickypoints "2"
rank_fireaxepoints "4"
rank_fistspoints "4"
rank_flamethrowerpoints "2"
rank_flaregunpoints "3"
rank_killingglovespoints "4"
rank_knifepoints "2"
rank_minigunpoints "1"
rank_nataschapoints "1"
rank_obj_sentrygunpoints "3"
rank_pistolpoints "3"
rank_revolverpoints "3"
rank_scattergunpoints "2"
rank_shotgunpoints "2"
rank_shovelpoints "4"
rank_smgpoints "3"
rank_sniperriflepoints "1"
rank_syringegun_medicpoints "2"
rank_taunt_heavypoints "6"
rank_taunt_pyropoints "6"
rank_tf_projectile_pipe_remotepoints "2"
rank_tf_projectile_pipepoints "2"
rank_tf_projectile_rocketpoints "2"
rank_ubersawpoints "4"
rank_worldpoints "4"
rank_wrenchpoints "4"
rank_tf_projectile_arrowpoints "1"
rank_taunt_spypoints "6"
rank_ambassadorpoints "2"
rank_taunt_sniperpoints "6"
rank_force_a_naturepoints "2"
rank_sandmanpoints "3"
rank_compound_bowpoints "2"
rank_taunt_scoutpoints "6"
rank_deflect_arrowpoints "6"

IngameUsage:

Type into Ingame chat:
"rank" to get your rank
"top10" to get the top 10
"players" to get a list of ingame players
"webrank" to get your webrank
"webtop" to get the webtop
"session" to get informations about your session
"hidepoints" to hide the points you get
"unhidepoints" to show the points you get

Webinterface Demos:
http://compactaim.de/tf2stats/ <--demo


Webinterface: version 5.5.0

Webinterface Changes:

*moved into the Zip file*


Plugin: version 5.0

Plugin Changes:

*moved into the Zip file*
Planed Features:


Post feature requests and maybe i will add it

Plugin update is possible without restarting the gameserver in 2 simple steps:

1. replace the smx plugin file
2. rcon command: sm plugins reload n1g-tf2-stats

or get the Pluginmanager: http://forums.alliedmods.net/showthread.php?p=719212

Announcement:
Development is now splitet :)

I (R_Hehl aka R5053) Code the Plugin
and : Smokestormx (http://forums.alliedmods.net/member.php?u=54392) Code / Design the Webinterface (Thank You :))

[imported_Anth0ny]

hmmm.. so interesting...
will look to this plugin closely.

[r5053]

hm any idea what to implement into next version ?

[imported_Anth0ny]

can u show a working stats page?

[r5053]

you mean a script like hlstats for a website ?

[imported_Anth0ny]

yes =)
u right...

because now HLStatsX's webface haven't support of TF2.

[r5053]

this evening i will look @ this and create a litle webinteface
edit: I will do it tomorow evening

[imported_Anth0ny]

this evening i will look @ this and create a litle webinteface
edit: I will do it tomorow evening

thanks! =)

[r5053]

i'm sorry this evening 2 no time

[r5053]

I woking on a complete redesign of the plugin supported with ideas and help on Testing by a Member of Krawall Gamin Network

[imported_Anth0ny]

I woking on a complete redesign of the plugin supported with ideas and help on Testing by a Member of Krawall Gamin Network

nice news! =)

[r5053]

new version will record events like point captured capture blocked and much more

you can preview it on my server n1g.de:27050 type into chat "!rank2" (it's ,my rank command 4 debuging)

[imported_Anth0ny]

any news about web-stats-page? =)

[r5053]

any news about web-stats-page? =)
hi anthony i contacted you over icq but you don't answered me :)

[imported_Anth0ny]

oops... please send me info again...
=)

[SaintK]

Someone has tried this yet?

[cozmicshredder]

Someone has tried this yet?

I loaded on my TF2 server wouldn't start said Error...

I have the database set up and have been using it for admins and I loaded the user database info but it wouldn't load...

[Solltex]

this plugin work to lan servers, by name?

[r5053]

It work's on TF2 and MYSQL it's running on 2-3 server's with no problem's.
But tell me the error message

[cozmicshredder]

L 11/26/2007 - 03:48:44: [SM] Native "SQL_Query" reported: Invalid database Handle 0 (error: 4)
L 11/26/2007 - 03:48:44: [SM] Debug mode is not enabled for "TF2statsnew.smx"

[r5053]

L 11/26/2007 - 03:48:44: [SM] Native "SQL_Query" reported: Invalid database Handle 0 (error: 4)
L 11/26/2007 - 03:48:44: [SM] Debug mode is not enabled for "TF2statsnew.smx"

sm version ? database type ?

[riuthamus]

r5, if i have the knowhow of php cant i just access your values and create my own stats page? Also... if you could leak some of the user table to me so i can set up the tables proplery im already making my stats page so i can view and display the values. Thanks in advance!

[SaintK]

Hi,

Can some one post a link to a working stats page from this plugin? I want to have a look what it looks like...

[r5053]

r5, if i have the knowhow of php cant i just access your values and create my own stats page? Also... if you could leak some of the user table to me so i can set up the tables proplery im already making my stats page so i can view and display the values. Thanks in advance!

if you wan't to create a stats page for this plugin please contact me i can support you and upload it as the official stats page for this plugin (i've too the know how but at the moment not enough time to create a good stats page)

[imported_Anth0ny]

yes-yes!!
we need stats page... =)

[riuthamus]

Send me an email at [email protected]

we can go over how best to do this and get a chat setup.... im more then willing to help you with this ranking system.

[r5053]

Send me an email at [email protected]

we can go over how best to do this and get a chat setup.... im more then willing to help you with this ranking system.

Please enter this steam communitygroup:

http://steamcommunity.com/groups/smdevel

[wildem]

I installed the plugin . It worked beautifully. Thanks.
I noticed one thing, if this plugin is loaded on two server on same ip, but different ports and it connects to mysql on localhost, then stats from server 1 gameplay affect the ranking on server 2. This happens as there is a

Am i correct ? If this is true, and this plugin uses the "default" database in database config file , - is there a way to avoid this issue.

[Gonz]

it´s working, thx man!!!

[r5053]

I installed the plugin . It worked beautifully. Thanks.
I noticed one thing, if this plugin is loaded on two server on same ip, but different ports and it connects to mysql on localhost, then stats from server 1 gameplay affect the ranking on server 2. This happens as there is a

Am i correct ? If this is true, and this plugin uses the "default" database in database config file , - is there a way to avoid this issue.

yes in the next version this will bw fixed, but the next version will be released after valve updates the servers.

[imported_Anth0ny]

how about php stats page? =)
like HLStatsX but for TF only....

[Fatal Cleric]

I made a stats loader v0.3 hope it helps youguys get started, here it is XD:

http://www.judopenguin.com/domains/psychoticfreaks/upload/data/mods/TF2-stats-webface-v0_3.zip

Please Enjoy :)

[Fatal Cleric]

I made a stats loader v0.3 hope it helps youguys get started, here it is XD:

http://www.judopenguin.com/domains/psychoticfreaks/upload/data/mods/TF2-stats-webface-v0_3.zip

Please Enjoy :)

this will load your stats in to a webpage, also when editing the pphstats in the database to find out how the rank listed the players, upon logging in to the server I noticed that 40 points dissapeared off of the score, this could be a major bug - if people are loging in to your server and loosing rank points, they wont be happy :cry:, soI call this a bug for now,ohyea was a linux server running mani and meta mods with no errors :)

[Fatal Cleric]

The bug that drops points is based on the plugin calculating 'points per hour' but it fails to retain the MAX points per hour earned by a given player - therefore if you log in and get 0 points in 1 hour then your rank will fall to the bottom of the list, as the rank is bassed o the 'points per hour' can this bug be fixed XD would be awsome :)

[Fatal Cleric]

can tell by the feedback your all in a rush LOL...

[r5053]

contact me over steam http://steamcommunity.com/id/r_hehl

[Fatal Cleric]

servers crashing with this:

L 12/15/2007 - 16:34:10: SourceMod error session started
L 12/15/2007 - 16:34:10: Info (map "ctf_2fort") (file "errors_20071215.log")
L 12/15/2007 - 16:34:10: [SM] Native "SQL_FetchRow" reported: Invalid query Handle 0 (error: 4)
L 12/15/2007 - 16:34:10: [SM] Debug mode is not enabled for "TF2statsnew.smx"
L 12/15/2007 - 16:34:10: [SM] To enable debug mode, edit plugin_settings.cfg, or type: sm plugins debug 1 on

[nizoo]

I need someone to help me settings this up, I don't understand db that much and idk what user.sql is :(

[Fatal Cleric]

Hi nizo
do you have a dtabase with access via PHPMyAdmin if so your going to need the details for that in order to set up the plugin, the bd.sql or user.sql is imported into phpmyadmin (helps adminyour database) for example to tell the database what tables and rows it needs to create, that the plugin can use.

heres the latest errors im getting for the plugin:

http://www.judopenguin.com/domains/psychoticfreaks/upload/data/mods/errors_20071217.zip

[BrutalGoerge]

how does it calculate rank?
it it just by points?

[BrutalGoerge]

Both my servers crashed after installing this plugin. They did not immediately crash, and it seemed to be working before they did.
It was writing to the database just fine, then SRCDS would just lock up, freeze. I'd have to manually close it, and restart the servers. =\
I did not see anything in the logs that would hint as to why it happened.

[r5053]

how does it calculate rank?
it it just by points?

it calculates rank with point's per hour

[T3mp]

the mod develop is died ?

[r5053]

the mod develop is died ?
no only freezed to give valve time to fix the bug's in tf2 it has make no fun to code plugins if the server crashes on every restart an server starting was the same like russian roulet. but now valve fixed it and i will Continue coding this plugin

[BrutalGoerge]

I look forward to future releases.

[r5053]

web interface coding is started

http://compactaim.de/tf2stats/

[BrutalGoerge]

neato
would it be possible for an option to change the way rank is calculated to just points, or maybe points plus play time?

[r5053]

yes this is planed already to change the rank calculating to points

[BrutalGoerge]

I tried running the plugin again, just on one server this time, and it crashed.
I saved this SM log
http://www.fpsbanana.com/blog/12931
I duno if will help, or if you need it. but whatever.

[r5053]

I tried running the plugin again, just on one server this time, and it crashed.
I saved this SM log
http://www.fpsbanana.com/blog/12931
I duno if will help, or if you need it. but whatever.

i added you in ICQ and Steam , i think it's maybe a problem with the mysql server

[r5053]

i need some one who can make tf2 weapon icon's (the must be copyright free) for the webinterface

[ThatGuy]

would it be possible to remove "Deaths" from the stats if you wanted to? I love stats and ranking systems, but I hate that feature becasue it comes with whoring and team stacking and whatnot.

[r5053]

so now i code first the webinterface and after finishing the wi i code the plugin complet new

[Solltex]

maybe next version suport stat by name not id?

[r5053]

maybe next version suport stat by name not id?
no it need's the steam id to identifikate the players

[Solltex]

for lan server in mysql table write one first player name, and STEAM_ID_LAN. And write to some name all stats

[r5053]

for lan server in mysql table write one first player name, and STEAM_ID_LAN. And write to some name all stats
ok i know this problem i think in future version i patch the compatibility for lan stats in writing the ip instead of the steam id into the steamid database array if it run's @lan

[BrutalGoerge]

I updated the old database with the new one, but the new plugin won't load. I duno what's wrong.

I have no sql experience before this, so it's probably something dumb.

16:39:47 Failed to connect: Configuration "tf2stats" not found
16:39:47 L 01/01/2008 - 17:40:00: [SM] Native "SQL_Query" reported: Invalid database Handle 0 (error: 4)
16:39:47 L 01/01/2008 - 17:40:00: [SM] Debug mode is not enabled for "tf2statsalpha.smx"
16:39:47 L 01/01/2008 - 17:40:00: [SM] To enable debug mode, edit plugin_settings.cfg, or type: sm plugins debug 25 on

[r5053]

you have to edit the databases.cfg file and add you db config like this

"tf2stats"
{
"driver" "mysql"
"host" "127.0.0.1"
"database" "tf2_stats"
"user" "tf2st_usr"
"pass" "dbpass"
//"timeout" "0"
"port" "3306"
}

[Fatal Cleric]

Heya
I just updated to the alpha version XD, but have a few problems :(
The 'rank' and 'top10' say command isn't showing up any results and althou I can see names being added to the database, it seems to not be recording any results, just in case its a stupid error of mine, here is how I have the database.cfg:

"Databases"
{
"driver_default" "mysql"
"default"
{
"driver" "default"
"host" "THE DEFAULT IS HERE"
"database" "THE DEFAULT IS HERE"
"user" "THE DEFAULT IS HERE"
"pass" ""
//"timeout" "0"
//"port" "0"
}
"storage-local"
{
"driver" "sqlite"
"database" "sourcemod-local"
}
"tf2stats"
{
"driver" "mysql"
"host" "MY DATABASE HOST"
"database" "MY DATABASE"
"user" "MY USER"
"pass" "MY PASS"
//"timeout" "0"
"port" "3306"
}
}

the player names appear in there but no output in game, and no logging of scores whatsoever :(, I have left the default database settings in the database.cfg alone.

Thank you in advance for any help XD

[BrutalGoerge]

yeah, I have the same deal happening.
I think he mentioned something about a bug in sourcemod that once fixed should make his plugin work.

[r5053]

this is right if you reed the first page of this thread you can see the actual status and actauly this are the only functions implemented yet
i ' m waiting for a bug fix to continue coding with the stats recording function

[Fatal Cleric]

Hey dudes!
Agh sorry guys if I missed that ><, but for now the server hasn't crashed for a while, its becoming difficault with source not releasing the code required to mod down the line, trying to debug the server with bailopans help but its been quite a pain without the instruction manual :/, not to mention the updates making us rewrite plugins every ten minuits :).

Thanks comp for your help so far, you been great XD

[r5053]

sry don't know what you want to say

[BrutalGoerge]

his reply doesn't seem to match the thread. lol
I hope everything goes smooth for you tomorrow. I look forward to getting this running. :)

[Fatal Cleric]

Read page 6 then it makes sense, basically the mod failstowork anymore, but my server ccrashes have ceased!!

[r5053]

Read page 6 then it makes sense, basically the mod failstowork anymore, but my server ccrashes have ceased!!

error log ?
i think he doesn't crash he only need's longer to change the map
actualy there's a array who is to large to fix a bug temporary

[r5053]

fixed the crash bug

[BrutalGoerge]

It seems to be working
One of my servers crashed, duno if it's related to the plugin though. With the previous version of the plugin that caused crashes, it would lockup srcds complretely, this time, my server restarted itself.

I did notice some error logs.

L 01/05/2008 - 17:01:02: SourceMod error session started
L 01/05/2008 - 17:01:02: Info (map "cp_dustbowl") (file "errors_20080105.log")
L 01/05/2008 - 17:01:02: [SM] Native "GetClientAuthString" reported: Client index 0 is invalid
L 01/05/2008 - 17:01:02: [SM] Debug mode is not enabled for "tf2statsalpha.smx"
L 01/05/2008 - 17:01:02: [SM] To enable debug mode, edit plugin_settings.cfg, or type: sm plugins debug 1 on
L 01/05/2008 - 17:10:09: [SM] Native "GetClientAuthString" reported: Client index 0 is invalid

Other than that, it's looking better and better.

Keep up the good work.

[r5053]

all crash bug's are now fixet in v.0.2.1 the problem was an multidimensional string array

[BrutalGoerge]

Awesome awesome awesome.
It's working great.
I customized my web interface with a stylesheet a made a while ago.
lol
http://gs1.1.fpsbanana.com/tf2_stats

[BrutalGoerge]

never mind, not quite so awesome.
You said that it updates every 60 seconds? Well, every 60 seconds my servers lag.
I have paused the plugin for the time being.

Maybe have it update at the end of rounds instead?

[r5053]

never mind, not quite so awesome.
You said that it updates every 60 seconds? Well, every 60 seconds my servers lag.
I have paused the plugin for the time being.

Maybe have it update at the end of rounds instead?

to fix it i split the tasks into 2 timers that updates the events all 60 sec's but first 1. task and after 30 sec the next
if it don't fix it.
i make it on player disconnect or round end

[Solltex]

PLUGIN_VERSION "0.2.1"?

[r5053]

L 01/07/2008 - 17:35:22: [SM] Native "SQL_Query" reported: Invalid database Handle 0 (error: 4)
L 01/07/2008 - 17:35:22: [SM] Debug mode is not enabled for "tf2statsalpha.smx"
L 01/07/2008 - 17:35:22: [SM] To enable debug mode, edit plugin_settings.cfg, or type: sm plugins debug 27 on

i need some infos:

plugin version ?
debug log?
mysql db version?
os?
smversion?
metamodversion?
mod? (no joke i see my tf2 stats plugin running on a CS:S server :))
http://www.game-monitor.com/search.php?rulename=sm_tf2_stats_version

[Solltex]

ok work, need restart server :)
but version 0.2.1

[r5053]

ok work, need restart server :)
but version 0.2.1

ok i forgot to write on the first page that after a change of the dbconfig file sourcmod need's a server restart

p.s.

would be nice if the people who use this plugin with the optional webinterface post a link to the webinterface

[Solltex]

anywai not work with lan server, all kills write to one player :(

[r5053]

anywai not work with lan server, all kills write to one player :(
i know i never said it goes now.
but if you have a legal version and internet the easy's version is to say the server he is a internet server you must not open any port to let external players connect.

[T3mp]

tomorrow i try to setup the stats :)

good work!!!!

[r5053]

but note actualy the player time and last connected time don't get updated to fix a lag issue and first on weekend i have time to fix it with threaded sql

[BrutalGoerge]

i notice now some stuttering again. I duno if it's cuz I changed to sourcemod 1845, cuz it seemed to be working fine after you released that temp fix. The CPU usage for srcds spikes by a factor of two every 10 seconds or so. So if it's at 40%, it'll spike to 80% for a fraction of a second, if it's at 30%, it'll spike to 60%
if it's above 50%, then it will spike to 98%.

When i disable the plugin with sm plugins unload tf2statsalpha, the spikes go away.

Maybe this too will be cured with your new algorithms for writing to the database. =]

[r5053]

yes i think it will be better if i rewrite it to threaded sql

[BrutalGoerge]

Updated plugin is working great.
good job.
:D

[riuthamus]

Im having a very tough time setting this up. Perhaps im doing or going about this the wrong way. I cant seem to get it to connect or write to the database. Everything seems to be in place but I do have one small issue. My server puts a server name in front of all databases, this is something I cannot avoid so my db is actually

db14844_tf2stats

Is this a problem?

[r5053]

No the Db name is no matter how you must only set it correct in the config

[r5053]

If somebody wants to contact me or get Plugin update news over steam join this group http://steamcommunity.com/groups/TF2STATS

[riuthamus]

Im at work right now, perhaps you can email me?

otherwise youll have to wait till i get home to talk to you over steam

this is what my config file looks like


"Databases"
{
"driver_default" "mysql"

"default"
{
"driver" "default"
"host" "localhost"
"database" "sourcemod"
"user" "root"
"pass" ""
//"timeout" "0"
//"port" "0"
}

"storage-local"
{
"driver" "sqlite"
"database" "sourcemod-local"
}
"tf2stats"
{
"driver" "mysql"
"host" "external-db.s14844.gridserver.com"
"database" "db14844_tf2stats"
"user" "*****"
"pass" "*****"
//"timeout" "0"
"port" "3306"
}
}

[r5053]

Seems looking ok, but note you must have access to the mysql server over tcp

maybe in your mysql config you have skip-networking enabled.

P.S. If you don't wan't to get spammed by a automatic spam bot you have to remove your email adress from the post :D

[riuthamus]

my MySQL is ran through www.mediatemple.net (http://www.mediatemple.net) and is pre-setup. Not sure how I would go about changing its settings... perhaps you can walk me through that? Perhaps I can take some screenshots of what the panel looks like and you can guess what should be done, again im not sure about all this, i do know how to use MySQL just need to be directed on what needs to be done to get this working.

[riuthamus]

The information to log into your MySQL and PostgreSQL databases is the same and is listed in the above section. Please use the Manage Databases (https://ac.mediatemple.net/services/manage/grid/databases/index.mt?id=166328) panel if you wish to change your database password, the username cannot be changed. The Manage Databases panel may also be used to create new MySQL/PostgreSQL databases.

PHPMyAdmin and PgMyAdmin are both available through the Manage Databases (https://ac.mediatemple.net/services/manage/grid/databases/index.mt?id=166328) panel, simply click the 'admin' link next to any of your existing databases.

By default you may only connect to your databases from your (gs) Grid-Service. All local connections to your databases via scripts or other methods must use the Internal Host URL above. To allow outside hosts to connect to your databases please add the IP address of the external host in the 'External IP Access' section of the Manage Databases (https://ac.mediatemple.net/services/manage/grid/databases/index.mt?id=166328) panel. Once you have entered the IP address of your outside host, it may connect to your databases by using the External Host URL.


thats in the help guide of my host

[r5053]

To allow outside hosts to connect to your databases please add the IP address of the external host in the 'External IP Access' section of the Manage Databases (https://ac.mediatemple.net/services/manage/grid/databases/index.mt?id=166328) panel. Once you have entered the IP address of your outside host, it may connect to your databases by using the External Host URL add there the ip of your tf2 server

[riuthamus]

this has been done,

8.6.15.135

do i need to add anything special other then that? And im at work right now is there anyway you can get on the server and test yourself to see if its working, i would really appreciate the help and would be inclined to help you with some graphics if you wanted them.

[r5053]

No sorry now It's in germany 23:45 and i must go to bed to wake up in 6 hours :D

But you can test it with hlsw if you reload the plugin it should display "Connected"

[riuthamus]

whats the command to reload the plugin?

[BrutalGoerge]

sm plugins load tf2stats

[riuthamus]

Failed to connect: Configuration "tf2stats" not found
L 01/14/2008 - 17:26:31: [SM] Native "SQL_Query" reported: Invalid database Handle 0 (error: 4)
L 01/14/2008 - 17:26:31: [SM] Debug mode is not enabled for "tf2stats.smx"
L 01/14/2008 - 17:26:31: [SM] To enable debug mode, edit plugin_settings.cfg, or type: sm plugins debug 3 on
[SM] Loaded plugin tf2stats.smx successfully.


I think i saw you have this issue before!!

[r5053]

Yes if you read the first page you see that you must restart sourcemod or the server to load the modified db config.

[riuthamus]

I have restarted the server and sourcemod, the only thing im unsure of is if im using an out of date sourcemod or.... if perhaps there are other plugins which are dependant upon this one, that I might have disabled. Anyway for me to check?

[mtrxsol]

Awesome plugin, can you please attach the sql script for the db.

[riuthamus]

can you update the first post with the cfg file.. because i cant seem to find it!

[BrutalGoerge]

it should auto-gen the cfg in your modname/cfg/sourcemod folder.
make sure you have the latest version of the plugin.
If you do, then do "rcon cvarlist rank"
then all the commands should come up.

[phpspy]

my tF2 STATS cant working
http://img137.**************/img137/1126/snap1wo3.jpg

[BrutalGoerge]

it looks like you may not have the right version of the database + the correct version of the plugin.

[mtrxsol]

Can you please attach database script.

[phpspy]

it looks like you may not have the right version of the database + the correct version of the plugin.
my mysql version is mysql-essential-5.0.41-win32.msi
sourcemod is sourcemod-r1854
what can i do for it?

[r5053]

no the problem is the dbconfig file from sourcemod

[r5053]

can you update the first post with the cfg file.. because i cant seem to find it!

0.2.7
-Now the Plugin Create a Config file if the file doesn't exist, he is located in cfg/sourcemod and there you can edit the Settings

[phpspy]

my mysql version is mysql-essential-5.0.41-win32.msi
sourcemod is sourcemod-r1854
what can i do for it?
need help:shock:

[r5053]

http://steamcommunity.com/groups/TF2STATS <-- help

and if you read my post you know your problem

[k4rnage]

Only for TF2 ?

[BrutalGoerge]

nah, it says "TF2 STATS" just to trick people.... ;P
I don't think he's quite done with this plugin yet. I don't think he has threaded all parts that he intended to, and some things are not recorded yet, such as domination, revenge, and uber charge.
And the weaps page of the web interface doesn't do anything yet.

[r5053]

Only for TF2 ?
actualy yes
but if there are enough request maybe i release rank plugins for other mods

[xmantou]

actualy yes
nah, it says "TF2 STATS" just to trick people.... ;P
I don't think he's quite done with this plugin yet. I don't think he has threaded all parts that he intended to, and some things are not recorded yet, such as domination, revenge, and uber charge.
And the weaps page of the web interface doesn't do anything yet.


I agree with you.

it is very important!!

[phpspy]

i created nosteam id Game Servers!
when i used tf2stats.smx and mysql in my TF2 servers on lan,
it tell me my steam id in used!i think thats reason with tf2stats record steamid to mysql,how to not reacord steam id.only used player name?
thanks!

[phpspy]

anyone konws?thanks!

[BrutalGoerge]

I don't think he has set this up for lan.

[r5053]

crash bug's are known fix will be released in the next 24h

[phpspy]

problem about webinteface,tf2stats.sma works ok,and it can sent the BD data To mysql,but the tf2 webstats have some trouble,when i intervier player_ranking.php and map_ranking.php it tell me Fatal error: Call to undefined function mysql_connect() in D:\www\tf2stats\inc\dbconnect.php on line 2
after that i check dbconnect.php
my dbconnect.php code is
<?
mysql_connect("localhost","how","12345") or die ("No Connection Possible");
mysql_select_db("tf2") or die ("The Database Does not exist");
?>
,all looks fine!what can i do! thanks!

[xmantou]

revenge, domination, uber charge, are not recorded

[phpspy]

revenge, domination, uber charge, are not recorded
How to fixed it

[bzz0]

Webinterface Demo does not work :(

[BrutalGoerge]

his server is having hd problems i think.
here is my interface...
http://gs1.1.fpsbanana.com/tf2_stats

I dont think revenge, domination, ubercharge, are coded into the plugin yet.

[r5053]

yes and my hoster (server4you) is to stupid or easy not interested in fix this problem / give me a new server an put in my backups i made 2 h ago.

edit.:

Now the sixt day my server is offline ... so i can't do anything , i planed a integration of the steam community and a player online display for the Webinterface

[BrutalGoerge]

thanks for the wi update, keep up the progress.:)

I have no clue why this is happening though.

The plugin crashes my server (id #1) and my other server (id #4) is just fine with it.

The two servers are pretty much clones of each other, except #1 runs all the default maps, and #4 runs only 2fort and dustbowl.

I disabled tf2stats on #1 for two days, never crashed.
I turned it on today, then it crashed within hours.

[misfit]

Getting the same error as a few other people, but I didn't see anything posted for a fix:

L 02/04/2008 - 23:01:08: [SM] Native "SQL_Query" reported: Invalid database Handle 0 (error: 4)
L 02/04/2008 - 23:01:08: [SM] Debug mode is not enabled for "tf2stats.smx"
L 02/04/2008 - 23:01:08: [SM] To enable debug mode, edit plugin_settings.cfg, or type: sm plugins debug 1 on


Here's my databases.cfg:

"Databases"
{
"driver_default" "mysql"

"default"
{
"driver" "default"
"host" "localhost"
"database" "sourcemod"
"user" "root"
"pass" ""
//"timeout" "0"
//"port" "0"
}

"storage-local"
{
"driver" "sqlite"
"database" "sourcemod-local"
}

"tf2stats"
{
"driver" "mysql"
"host" "192.168.2.7"
"database" "weclann_tf2stats"
"user" "******"
"pass" "******"
//"timeout" "0"
"port" "3306"
}
}

Yes, on a TF2 server. SM version 1875. MySQL client version: 5.0.45

I have every SM plugin disabled except this one.

Thanks

[r5053]

post the debug log

[misfit]

This is as far as I could get:

08:29:49 [SM] Could not toggle debug mode on plugin tf2stats.smx.
[SM] Plugin returned error: Plugin is not runnable.

[riuthamus]

Just so you know, i have added a search feature to the web interface, for fast finding of people you want to look for, works just like steamcommunity.com

http:\\slaughterhouse.clanservers.com\ranking

[ColdFire]

Webinterface Demo does not work :(

Did you configure the DB info in inc\dbconnect.php?

[misfit]

post the debug log

This is as far as I could get:

08:29:49 [SM] Could not toggle debug mode on plugin tf2stats.smx.
[SM] Plugin returned error: Plugin is not runnable.

Any idea why I'm getting this error?

Thanks.

[ColdFire]

It would be great (but is it possible?) to get points for CP defense, CP capture, intelligence defense & capture and über charges.
And is it possible changing kill points values in a config file or do we have to modify the source and recompile it?

[BrutalGoerge]

fix the crash bugs then add new feature to it.
I've been able to run all my servers straight for a week w/o them crashing since I disabled the plugin.

[qcg33k]

Hello,

I'm brand new to source mod and very interested in this rank plugin. I have a website that has MySql, and I have a TF2 game server. I'm usually never tinker with the database, so I'm a little lost.

Your install directions seem to be vague to a new user, or I'm just clueless. But here is where I'm running into problems. Which files go where, the only one I understand is the .smx file needs to go into the plugin folder.

What does import the sql file mean? What folder does that file go to?

Also, what database information do I need? I never setup a database on the website. But I do have access to phpMyAdmin.

P.S.- I added you to my Steam friends list a.k.a. ][STA][Hybrid][777][

[r5053]

if i have time i write new instalation How to (or if somebody wan't to do that write me a message)

[r5053]

a complete recode is planned

[qcg33k]

Sweet, just making a ranking system for SM that does not even use a website would still be great and awesome! I use mani-mod only for it's stupid ranking system.

[r5053]

i recode the plugin at this moment i upload a new version in 1-2 h than mysql is optional too.

[BrutalGoerge]

looks good.
couple small problems I noticed, but I don't think they will be hard to fix.
No lag, no crashes. :D

[r5053]

yes 1-2 small bug's in the code i know like the missing check if assister exist but no critical bug's, send me your bug report with debug enabled then it's easyer to fix

[ColdFire]

After your script update (and thanks to allow us to choose how many points we want for each action), I've questions:

How about points for:
- kill assist
- partial capture
- über charge

And for intelligence on ctf maps, successfully capturing the intelligence is counted with CP capture ?

Thank you!

And I'm waiting for your multilanguage support, I'll be happy to help you with a french translation

[fattitj]

where to put the cvars?
it doesnt read my old cfg-file and it doesnt auto create a new one anymore.

and another thing:
lets say a players rank shows 2 in top10 and in the webinterface, but when u view the players detailed stats it says rank 344

[BrutalGoerge]

As for the cfg.
I just made a stats.cfg and put "exec stats.cfg" in server cfg.
Works gud

[riuthamus]

"Databases"
{
"driver_default" "mysql"

"default"
{
"driver" "default"
"host" "localhost"
"database" "sourcemod"
"user" "root"
"pass" ""
//"timeout" "0"
//"port" "0"
}

"tf2stats"
{
"driver" "mysql"
"host" "external-db.s14844.gridserver.com"
"database" "****_tf2stats"
"user" "****"
"pass" "****"
//"timeout" "0"
"port" "3306"
}
"storage-local"
{
"driver" "sqlite"
"database" "sourcemod-local"
}
}


I am not at home and cant get any full information just yet, other then what I can pull from the rcon tool. Right now the plugin (after using sm plugins list) says <error> then the plugin name.... not sure if its working or what, but if i try to enable debug mode for the plugin it says it cant.

I have also placed a stats.cfg in my main cfg folder and linked it to the server.cfg at the end. Please let me know if there is something I am missing as I have been waiting for this server crash update forever!!

Stats.cfg

rank_batpoints "2"
rank_blockcapturepoints "1"
rank_bonesawpoints "2"
rank_bottlepoints "2"
rank_capturepoints "3"
rank_clubpoints "2"
rank_diepoints "1"
rank_fireaxepoints "2"
rank_fistspoints "2"
rank_flamethrowerpoints "1"
rank_killasipoints "2"
rank_killdisppoints "1"
rank_killsapperpoints "1"
rank_killsentrypoints "3"
rank_killteleinpoints "1"
rank_killteleoutpoints "1"
rank_knifepoints "2"
rank_minigunpoints "1"
rank_obj_sentrygunpoints "2"
rank_pistolpoints "2"
rank_removeoldplayers "1"
rank_removeoldplayersdays "14"
rank_revolverpoints "3"
rank_scattergunpoints "2"
rank_shotgunpoints "2"
rank_shovelpoints "2"
rank_showtop10onroundend "0"
rank_smgpoints "1"
rank_sniperriflepoints "2"
rank_syringegun_medicpoints "4"
rank_tf_projectile_pipe_remotepoints "2"
rank_tf_projectile_pipepoints "3"
rank_tf_projectile_rocketpoints "1"
rank_wrenchpoints "2"

[BrutalGoerge]

what's your sourcemod and metamod version?

[riuthamus]

Sourcemod is up to date 904, metamod, im not sure... was there an update recently?

[riuthamus]

and im home now... WOOT! so i can get more diagnostic information if told how to

[fattitj]

I miss the /rankmenu command, hope u'll add it back :)

[r5053]

yes will be readded

[riuthamus]

Okay... well im almost there. I got it to store data to the database.. but the website will not diplsay it due to the following message

Warning: mysql_connect() [function.mysql-connect (http://www.bhslaughter.com/stats/function.mysql-connect)]: Host 'cl19.gs01.gridserver.com' is not allowed to connect to this MySQL server in /mnt/gs01/herd03/14844/domains/bhslaughter.com/html/stats/inc/dbconnect.php on line 2
Keine Verbindung moeglich

The website is not hosted off of the same location as the mysql db, that db is hooked into the server itself....so....not sure what this code means.... is it being denied on the server end... by the server thatas attempting to connect? or what?

[xmantou]

How about points for uber charge

[misfit]

Got the plugin successfully loaded, yet it does not create tables in the db.

sm version 1904
no other sm plugins running

databases.cfg:
"Databases"
{

"driver_default" "mysql"

"default"
{
"driver" "default"
"host" "192.168.2.7"
"database" "***_tf2stats"
"user" "***_misfit1"
"pass" "***"
//"timeout" "0"
"port" "3306"
}

"storage-local"
{
"driver" "sqlite"
"database" "sourcemod-local"
}
}

Where am I getting this wrong that it won't create the db tables?

Thanks

[r5053]

server ip?
btw by problems like that contact someone in the tf2stats community group :D

[r5053]

How about points for uber charge

i wrote a feature request to valve

[misfit]

server ip?
btw by problems like that contact someone in the tf2stats community group :D

Server IP is 74.63.66.126:27015.

Will do.

[Extreme_One]

i wrote a feature request to valve

The event is in the logs since HLstatsX can award you for Ubers.

[r5053]

The event is in the logs since HLstatsX can award you for Ubers.
yes but this plugin is not so inefective like hlstatsx it get's the datas direct from the server events and not from the log

[fattitj]

not all the kills/deaths gets counted.
i got 100 kills in one map, but it still say i got 70 in total.
dunno how or why, but alot of my kills doesnt count as kills, but i get points for them.

[r5053]

if you got points you got kills too it's one mysql query

[fattitj]

atm it says i got 118 kills in total, and 347 points.
I know for a fact that i've killed more than 118, i killed more than that only today, and the ranking is for 3 days now.
dunno what causes this

[r5053]

ok then post your sourcemod log, on every sql error therer will be a entry

[r5053]

atm it says i got 118 kills in total, and 347 points.
I know for a fact that i've killed more than 118, i killed more than that only today, and the ranking is for 3 days now.
dunno what causes this
if you have a link to your webinterface please post a link else please upload a database dump

[fattitj]

this is the only sql error from the log:
L 02/26/2008 - 23:52:40: [n1g-tf2-stats.smx] Last Connect SQL Error: Unknown column 'FileCaptured' in 'field list'it appears many times a minute.

my webinterface:
http://stats.pulkai.com

there were no problems with this plugin before the new version

[r5053]

delete the database table Player this will fix it,

[fattitj]

delete the database table Player this will fix it,I did, but its still not working, most of my kills doesnt count. seems that only my shotgun kills counts or something.

as u can see on my screenshots, i got 17 kills and 9 deaths, but the rank system shows 5 - 3.
and i dont gain or lose points from kills/deaths.

i edited the cvars to give 1 points per primary weapon and 2 per melee. and 1 per death.

[r5053]

i know this bug there will be a fix in 1 h

[r5053]

i know this bug there will be a fix in 1 h
but it will help if you post your sourcemod error log

[fattitj]

here

[Zoidbergh]

Eya peeps!

First of all, thanks r5053 for making this ranking system ;)

Second, i got a small problem, the same as fattitj, i used the latest version of the mod. Everything gets registered but the kills / deaths?

I included the error log.

Hope you can reply, furthermore, if you have a api of your md, maybe i could help a bit if you need any?

Greetings,

Zoid.

[r5053]

please set debug on for the a error log
and post the serverip

[r5053]

update the plugin and join the tf2stats steam community group

[alexera]

A have problem with web interface:

http://eds.f74.ru/tf2stats/

can you help me? Please.

[BrutalGoerge]

If you're using linux, find out the user/group that has www access, and give that user ownership of tf2 stats wi.
If you're using a windows server, then I am not sure, but it may be a permissions issue still.

[MjrNuT]

For the case of not using mysql/web interface, the stats are calculated per map, per round? Are there minimum number of players it needs?

I ask b/c I just followed your instructions of placing the .smx and the .txt file in the appropriate places, plugins and translations folders, respectively.

The menus display when typing rank or top10. However, I only had 3 players ingame, and so not sure if they was the reason that no stats were being calculated etc. The plugin loaded when I did a map change. Am I missing anything?

[rubexcube]

I have installed the latest version on my 3 linux servers and I love the plug-in everything seems to be working except I have two troubles that I was hoping I could find help for: The first is that at the end of a round ever since I have started using stats there is a 10 second lag for everyone that is in the server. You will actually see the red text Connection Warning in the upper right hand corner. After about 10 seconds this goes away and the map completes and loads the next. The second question I have is SourceTV is being calculated somehow into the Stats and showing up as a player on the end round stats post. I was wondering if there is something I can do to omit this from being calculated.

[r5053]

which server hardware and which software is on this server and how many gameservers and how many slots are there and post the ip's.

[rubexcube]

Two of the three servers are linux machines hosted at a data center that I have no way of telling what hardware is installed. The third machine (sandbox) is a Pentium 4 2ghz, IDE, Ubuntu 6, with 2 gigs of ram using a Intel Pro 1000 nic card.

The IPS for the Public and the Private game server are:

64.156.14.127:27015 = Public

8.3.7.101:27015 = Private

[r5053]

this seems to be a problem with th server cfg or hardware.

[rubexcube]

Okay... well one of the machines that has this issue is here locally and I have access to it so if you would maybe give me a lead on where to start looking that would be a big help.

[r5053]

for these 3dparty problems contact me over the steam community

[Rat]

Wait, I cant get the ranks to work. It says everyone has 0 points. Do I put the cvars in the translations file?

[BrutalGoerge]

the vars go in a cfg file.

you can put em in ur server cfg, or make a rank.cfg, and put exec rank.cfg in ur server.cfg.

If you're not changing them though, then you don't need to put them in a file, since they will just use the default settings.

[r5053]

the plugin dosn't need a config file exept of a db config file (later this is too optional by using default sqllite) (actualy ther's a bug in using sql lite)

[Rat]

This is kinda confusing...I put the shit where its supposed to go but when I type "ranks" everyone has 0 points. Anyone know what Im doing wrong?

[r5053]

there's a output if you load it it shoult be somethink like connected with config, the with config is important

[Solltex]

maybe work to lan servers?

[defproc]

Are you guys aware that the web interface linked here is vulnerable to SQL injection when run on a server without gpc_magic_quotes set?

A quick fix would be to add a .htaccess file to the web interface distribution (in the documentroot) containing:

php_flag magic_quotes_gpc on

I fixed it on my own server by pass any $_GET variable that's sent through a query through mysql_real_escape_string() but I wouldn't expect everyone to have PHP/MySQL experience.

[r5053]

It's no heavy problem because magicquotes have been turned off by default since PHP 4.3 and php4 isn't anymore suported and will be totally removed in PHP 6, but yes i should fix it.

[Arkuu]

Hi!

I tried to make this plugin work on my server, but I failed. I moved the .smx file and translation in right folders, as in the first post was told but when I am in game and I type "rank" I get empty skill table: all stats are 0 and theres no names. I am just wondering what did I do wrong? :?: And where does the plugin log the ranks... :O

PS: when I start my server, this message appears:

'L 04/12/2008 - 02:55:42: [n1g-tf2-stats.smx] Last Connect SQL Error: near "IGNORE": syntax error' :shock:

Any ideas? I'd like to get this working asap.

Arkuu.

[Rat]

"tf2stats"
{
"driver" "mysql"
"host" "127.0.0.1"
"database" "tf2_stats"
"user" "tf2st_usr"
"pass" "dbpassword"
//"timeout" "0"
"port" "3306"
}

For web interface, should you modify this at all?

[shubhishubhi]

Please let me if this plugin can also be used for player authentication??

[BrutalGoerge]

For web interface, should you modify this at all?
For the web interface, you edit the php file in the INC folder for the web interface so it matches the information for your DB

db name, address, user, password.

[r5053]

Please let me if this plugin can also be used for player authentication??

notrealy :D

[shubhishubhi]

That saves me a lot of work in trying to understand the working of this plugin... Thanks a bunch Friend.

[r5053]

:wink: Ranking! ... :D but of course it can be modifyed to do it, easy remove the newplayer into db adding function , and insert a on player connect function that kicks players who wasn't listed in the db. The result will be a Player authentifikate plugin with ranking :avast:

[shubhishubhi]

With that as the input I am being tempted to plunge into the code of this plugin.. :-)

[r5053]

with the new version its really easy, there you must only force the sql lite player insert, and replace the sql insert command after the player in db check with a kick or something else you want to do with the player.

[shubhishubhi]

Please pardon me hif I am asking something very stupid, but I am not a scripter and hence do not understand this code at the first glance.

I haveaken the n1g-tf2-stats.sp from here and there is a function called
OnClientAuthorized, what do I need to edit here so as to achieve the authentication related functionality that I am looking it.

Also I am not able to see an event that leads to OnClientAuthorized.

Please help.

[r5053]

the best way will be you join the tf2stats communitygroup and contact me directly

[scumbucket]

Is this plugin working currently with no issues?

[shubhishubhi]

how do I join the tf2stats community?

[r5053]

http://steamcommunity.com/groups/TF2STATS

[r3dh3adkid]

Is there any way to reset the ranks?

[qcg33k]

Question... I am able to install it onto a server that I never installed manimod on, and it works. However, installing it onto a server that mani-mod is on, it doesn't work. (typing in rank, top10, nothing happens)

[Switchie]

Thx dude this is working nice , i am using it with beetlesmod and sourcemod
Maybe you can make it when you type rank its shows it in the chat like all the other rankings work ( amxx , manimod , ... )

Keep up the good work

[r5053]

Is there any way to reset the ranks?
in the next release with a command, and now: delete the tf2stats file in the sourcemod/data/sqllite folder

[r3dh3adkid]

Yea sorry I posted that before I talked to you on steam :-P

[shubhishubhi]

I could not find anybody in the TF2stats community chat room. Please let me know the time when you will be available...so that I can understand how this plugin can be used for authentication with MYSQL DB.

[r5053]

I could not find anybody in the TF2stats community chat room. Please let me know the time when you will be available...so that I can understand how this plugin can be used for authentication with MYSQL DB.

contact someone of the group admins

[toazron1]

I'm not sure if you fixed this for the next version, but it doesn't separate knife kills and back stab kills (customkill = 1 for knife)

[r5053]

1. make it "player say rank- you are rank %numberrank our of %totalplayers"
3. make "playersay _ playerinfo, shows a list online players"
4. in the rank_admin make admins able to reset a specific players rank.

[BrutalGoerge]

I don't think the player name updating is working.

Mp pruning is though.

[r5053]

it's a bug in sourcemod it also doesn't insert new players, i have a version with a workaround it will be released soon i implement some new features

[msleeper]

I have had the issue with the new players not being inserted as well, I am glad it is a known bug and is going to be fixed soon.

If you are going to make the stats be displayed in chat so that all players can see the output when someone says "rank" or "top10", could you make this feature optional? The players on my server do not like how obtrusive that stats like HLStatsX are and don't want to be bombarded with stats info unless they personally want it.

As we spoke on Steam and I got your permission, I have completely re-written your Web Stats interface for my gaming community's needs. You can see our version here: http://www.f7lans.com/statstf2.html

I'll be adding a search feature here in the next couple days, but more importantly this feature removes some of the security holes and other checks to the page. I also have some mod_rewrite going on so that search engines pick up on my site but that isn't required. If there is enough interest I would be willing to make a public version of this updated web interface.

I do have a request - could you make it optional so that if there are less than X number of players on the server, the stats do not track? I have had a problem with people who come into my servers to farm Medic Achievements go way up in the ranking and knock out legitimate players.

[r5053]

:D
the bug will be fixed this weekend
it must be a bug located in sourcmod.

please contact me @steam :D i wan't your webinterface as the oficial one, the actual one i made quick and dirty because out of time, only with the goal having a working webinterface.

P.S.: Ad capture can be removed because it was a reservation for the goldrush capture event, but it usese cp.

[msleeper]

Sounds good. If I may make another suggestion, "proper" mysql syntax would be to have all of the table and column names as lowercase, and you have them as uppercase or mixed case. If you would like I can post an updated mysql table creation and insertion syntax for you.

I am not on Steam right now but I will be later. I will have to re-design the stats interface to be more generic, but I would be more than happy to create an official web interface for you.

[r5053]

thats too a point on my Code Cleaning Todo list, but not shure

[KhyrOO]

Hi!
I have try to setup this plugin for me and get this error mess:

L 05/22/2008 - 19:57:26: [SM] Error (line 0, column 0): Stream failed to open
L 05/22/2008 - 19:57:26: [SM] Native "SQL_FastQuery" reported: Invalid database Handle 0 (error: 4)
L 05/22/2008 - 19:57:26: [SM] Debug mode is not enabled for "n1g-tf2-stats.smx"
L 05/22/2008 - 19:57:26: [SM] To enable debug mode, edit plugin_settings.cfg, or type: sm plugins debug 27 on


db config is:


"Databases"
{
"driver_default" "mysql"

"default"
{
"driver" "default"
"host" "localhost"
"database" "sourcemod"
"user" "root"
"pass" ""
//"timeout" "0"
//"port" "0"
}

"storage-local"
{
"driver" "sqlite"
"database" "sourcemod-local"
}

"watchlist"
{
"driver" "sqlite"
"database" "watchlist"
}

"tf2stats"
{
"driver" "mysql"
"host" "*****"
"database" "*****"
"user" "******"
"pass" "******"
//"timeout" "0"
"port" "3306"
}
}


All of my settings in db are the same values that provided by my whp.


I use Snapshot 1.1
Sourcemod 2124
Metamod 1.6.1.671
MySql 5.0.51a-3-log

[msleeper]

Make sure that you have the correct settings on your MySQL database, I ran into a very similar issue. By default, MySQL does not allow non-localhost connections and you will need to edit your my.cnf to enable it.

[KhyrOO]

Make sure that you have the correct settings on your MySQL database, I ran into a very similar issue. By default, MySQL does not allow non-localhost connections and you will need to edit your my.cnf to enable it.

Thx I will try it! Im a bit noob in SQL but i learn very fast! :D :D :D

[msleeper]

I am fairly certain the line you need to add is this:

skip-external-locking

Add that anywhere in the "mysqld" section.

[r5053]

or nonetworking

[xYx]

Is this plugin working fully under linux with latest sourcemod?

[msleeper]

I have been using it for almost a month without any issues.

http://www.f7lans.com/statstf2.html

[moyiwei]

Help~

databases.cfg

"tf2stats"
{
"driver" "mysql"
"host" "127.0.0.1"
"database" "tf2_stats"
"user" "moyiwei"
"pass" "10502320.."
//"timeout" "0"
"port" "3306"
}


srcds console

L 06/03/2008 - 17:28:27: -------- Mapchange to duel_duel2 --------
L 06/03/2008 - 17:28:27: [n1g-tf2-stats..smx] DatabaseInit SQLLITE (CONNECTED)
L 06/03/2008 - 17:28:39: [n1g-tf2-stats..smx] Last Connect SQL Error: near "IGNORE": syntax error


web

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in D:\www\tf2stats\index.php on line 28


:cry::cry:

[SEKTOR_TFK]

Why webinterface don't want to select database?! tf2_stats database created. Help me please ))) ICQ 288852720

[SEKTOR_TFK]

And... "user" "moyiwei"
"pass" "10502320.."
Where i can create user? And how?

[KhyrOO]

How can I change the points for kill or capture? Should I put thoose cvars into a .cfg file?

[KhyrOO]

Hallo ???

[msleeper]

If you read the first post, there is the necessary information for a rank.cfg file. Those values control how many points someone gets for each type of weapon and/or event.

[KhyrOO]

Thx! :D

[msleeper]

Is anyone having problems with this plugin after the Pyro update? I am getting this error.

[n1g-tf2-stats.smx] DatabaseInit (CONNECTED) with db config
[SM] Native "SQL_FetchRow" reported: Invalid query Handle 0 (error: 4)
[SM] Debug mode is not enabled for "n1g-tf2-stats.smx"
[SM] To enable debug mode, edit plugin_settings.cfg, or type: sm plugins debug 18 onI have changed nothing whatsoever for either the servers, or the mysql/web server. Thanks.

EDIT
The updates in this thread are confirmed to fix the problems!
http://forums.alliedmods.net/showthread.php?t=72972

[willy1234x1]

K on my site I'm getting this
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /var/www/sites/legends/wgs/stats/player_ranking.php on line 61How do I fix it?

[msleeper]

It should be noted that this plugin needs to be updated to include the new weapon types for the Pyro - "backburner" and "flare_gun" I believe. The Shotgun has also been changed to "shotgun_pyro", and the Haiduken taunt kill is "taunt".

[cr0sis]

Ok I have it installed and so far so good but two problems.

In tf2stats/index.php you have used the variable $fromplayers without defining it, strangely.

Giving Error: Notice: Undefined variable: fromplayer in C:\HostingSpaces\affinity\affinitygamers.com\ wwwroot\tf2stats\index.php on line 20


And also in tf2stats/player_ranking.php I get the following error:
Notice: Undefined index: page in C:\HostingSpaces\affinity\affinitygamers.com\ wwwroot\tf2stats\player_ranking.php on line 3

Notice: Undefined index: ppp in C:\HostingSpaces\affinity\affinitygamers.com\ wwwroot\tf2stats\player_ranking.php on line 4


Using the latest Sourcemod, Latest Version of this file included in the very first post, upto date mysql and php.

www.affinitygamers.com/tf2stats

see for yourself, the data works but those errors spoil it.

EDIT: I see that in player_ranking.php $fromplayer is assigned, how can I integrate that into index.php

[msleeper]

I am working on an updated, more secure version of the Web Stats page. I'm hoping to have it done soon, you can see it live at http://www.f7lans.com/statstf2.html

[Cooltad]

Could you include a different point amount if the player gets a headshot?

[Cooltad]

(bump)
Also maybe include the person's kill:death ratio below kills and deaths in they're rank?

Also something that would make it just like hlstatsx: Make it so there can be a cvar, when you want to use it, so that when you go above "1" in the cvar, if you kill someone who has more points then you, then your points are multiplied by whatever you set "1" to, and how many points higher (or lower) needed to get different points could be set with a different cvar, but not as a static point number, but as a percentage, like if it is "1.1" then if the person i kill has 1.1x more points than i do, then it will multiply how many points i get from killing him with my weapon, so if imma sniper and i kill him and i would normally get 1 point, and I set the multiplier cvar to 2, I would then get 2 points instead of 1. I know you all would think this to be a great idea as it would make the stats more realistic in who is in the top 10.

It would make it harder to get higher up in the stats. Also, for when you kill someone who has 0.9 points lower than you (in which "0.9" would be set as a different cvar than "1.1") you would do (if you have the "2" cvar still set to "2" half the amount of points.

This calculation would also apply vice-versa if you get killed by someone stronger you would lose half points normal (normal == 2, to now it is 1).

[SEKTOR_TFK]

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /srv/www/vhosts/tf2stats.s86.ru/tf2stats/index.php on line 21

How do I fix it? oO

[SEKTOR_TFK]

Hmmmm... Where can i download old versions?

[Sgt-Mess]

Will you ever consider compiling a version of this for use in counter-strike:source?

[toazron1]

This would require and almost total rewrite to work on CSS... I feel that it would just be easier to use one of the many other stats options for it.

[msleeper]

This would require and almost total rewrite to work on CSS... I feel that it would just be easier to use one of the many other stats options for it.

As far as I am aware, there is not a MYSQL-based, multi-server Counter-Strike stats option (that isn't HLStats).

[Sgt-Mess]

I just really like the way this stats plugin is set up and we use it on our tf2 servers.

[Cameron:D]

I am having a problem with this plugin complete crashing Steam (NOT the server but steam) with a whole lot of errors about textures not begin found... why would this be happening? I have other plugins that are working fine.....

[1Man]

What do I need to do if I just want it to be used as a plugin without SQL/WEB, I have loaded the plugin but comes up with the SQL connect syntax error. If there a way to disable the SQL portion of the plugin!

[Cameron:D]

You need the SQL I think, as it uses it to store the player stats.

[1Man]

I cannot find the .db file for this plugin, I have never created tables in MYSQL before so if anyone has the file that creates the tables via phpmyadmin I would really appreciate it.

Thanks

http://74.219.89.83/tf2stats/

http://www.1manstanding.com/tf2stats

[1Man]

Also the plugin did not create a .cfg for the plugin can someone also attach this file as well? Please make sure to include the actual file name and I believe its suppose to go in cfg/sourcemod

[1Man]

Just in case you want to know which versions Im running here is a list.
meta list
Listing 3 plugins:
[01] SourceMod (1.0.4-svn) by AlliedModders LLC
[02] TF2 Tools (1.0.4-svn) by AlliedModders LLC
[03] SDK Tools (1.0.4-svn) by AlliedModders LLC
sm plugins list
[SM] Listing 28 plugins:
01 "Admin File Reader" (1.0.4-svn) by AlliedModders LLC
02 "Admin Help" (1.0.4-svn) by AlliedModders LLC
03 "Admin Menu" (1.0.4-svn) by AlliedModders LLC
04 "TF2 Ammopacks" (1.1.0) by Hunter
05 "Anti-Flood" (1.0.4-svn) by AlliedModders LLC
06 "Basic Ban Commands" (1.0.4-svn) by AlliedModders LLC
07 "Basic Chat" (1.0.4-svn) by AlliedModders LLC
08 "Basic Comm Control" (1.0.4-svn) by AlliedModders LLC
09 "Basic Commands" (1.0.4-svn) by AlliedModders LLC
10 "Basic Info Triggers" (1.0.4-svn) by AlliedModders LLC
11 "Basic Votes" (1.0.4-svn) by AlliedModders LLC
12 "SM Crits chance" (0.1) by pRED*
13 "Custom Tab Work Around" (0.3) by The-Killer
14 "FakeClients" (1.0) by LouLoubizou
15 "Fun Commands" (1.0.4-svn) by AlliedModders LLC
16 "Fun Votes" (1.0.4-svn) by AlliedModders LLC
17 "MapChooser" (1.0.4-svn) by AlliedModders LLC
18 "TF2 Medipacks" (1.1.0) by Hunter
19 "TF2 Stats" (1.5.0) by R-Hehl
20 "Nextmap" (1.0.4-svn) by AlliedModders LLC
21 "SlapSlay Commands" (1.0.4-svn) by AlliedModders LLC
22 "Quake Sounds" (1.8) by dalto
23 "RandomCycle" (1.0.4-svn) by AlliedModders LLC
24 "Reserved Slots" (1.0.4-svn) by AlliedModders LLC
25 "Rock The Vote" (1.0.4-svn) by AlliedModders LLC
26 "TF2 Capper Regeneration" (1.1) by deltron
27 "Fun Cvars" (1.0.0) by Wild1234
28 "TF2 Fast Respawns" (1.0.5) by WoZeR
meta version
Metamod:Source version 1.6.2.703
Loaded As: GameDLL (gameinfo.txt)
Compiled on: Jul 25 2008
Plugin interface version: 14:14
SourceHook version: 5:5
http://www.metamodsource.net/