[Timiditas]

_ _
0.4.2 --> 0.4.2.9, plugin taken over by Timiditas with permission from alliedmods user "r5053", original author of the TF2 port
0.5.2.3 --> 0.6 changed plugin name and version cvar

0.6.1a changes: added admin-command (rank_showdebug), which prints out mysql version string and table layout (defaults to player table if argument omitted)
new cvar: rank_nopanelGG, 1|0, default 1 - if 1, does not print out GG wins in session panel

This is a re-post (with new name and new version cvar) of 'n1g-css-ranking'.
Aside from bugfixes and improved debug logging, the following things have changed:

• The name
• The version cvar (from 'sm_css_stats_version' to 'dignatio_version')
• Plugin filename (from 'n1g-css-stats.smx/sp' to 'dignatio.smx/sp')
• Plugin config filename (dignatio.cfg)
• Translation filenames (dignatio.phrases.txt)
• Database.cfg section name (from 'cssstats' to 'dignatio')

All other cvars and the console command names were preserved.

Detailed information about this plugin will be added to this posting later.

I am still hunting for bugs and/or SQL syntax errors. If you find a file called 'dignatio.log' in sourcemods log directory, please post it!

Known bugs:

L 06/13/2010 - 13:44:15: [dignatio.smx] SQL Error: near "+": syntax error
L 06/13/2010 - 13:44:15: [dignatio.smx] Problematic query: Marker X_DEB_009: UPDATE Player SET POINTS = POINTS + 0, KILLS = KILLS + 1,  + 1 WHERE steamId = 'STEAM_0:0:11869369'

Format(query, sizeof(query), "UPDATE %s SET POINTS = POINTS + %i, KILLS = KILLS + 1, %s + 1 WHERE steamId = '%s'", tableplayer, i_pointvalue, sqlWeapon, steamIdattacker);

Weapon not detected (server was running Warcraft:Source, victim died because of augmented damage). Even if the query would be correct, attacker would get zero points.
__________________________________________________________

L 06/02/2010 - 20:35:49: [dignatio.smx] SQL Error: no such table: Map
L 06/02/2010 - 20:35:49: [dignatio.smx] Problematic query: Marker X_DEB_013: INSERT OR IGNORE INTO Map VALUES ('de_dust',0,1275503749,0,0)
L 06/02/2010 - 20:35:49: [dignatio.smx] SQL Error: no such table: Player
L 06/02/2010 - 20:35:49: [dignatio.smx] SQL Error: no such table: Map
L 06/02/2010 - 20:35:49: [dignatio.smx] Problematic query: Marker X_DEB_021: DELETE FROM Map WHERE LASTONTIME < 1274294149

It does this on existing databases. Cause unknown. pissing me off :down:
____________________________________________________________

L 06/02/2010 - 21:27:53: [dignatio.smx] SQL Error: near "SET": syntax error

Cause not found yet, need to add query logging to remaining query calls.

___________________________________________________________
 Database layout sucks. Yes, this is a bug. :)
___________________________________________________________
L 06/15/2010 - 16:57:05: [dignatio.smx] SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SET POINTS = POINTS - 10 WHERE LASTDEDUCT < 1276527424' at line 1
L 06/15/2010 - 16:57:05: [dignatio.smx] SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE LASTONTIME < 1275404224' at line 1
L 06/15/2010 - 16:57:05: [dignatio.smx] SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE LASTONTIME < 1275404224' at line 1
L 06/15/2010 - 16:57:05: [dignatio.smx] [SQLITE=0]Problematic query: Marker X_DEB_021: DELETE FROM  WHERE LASTONTIME < 1275404224
L 06/15/2010 - 17:21:54: [dignatio.smx] SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SET POINTS = POINTS - 10 WHERE LASTDEDUCT < 1276528914' at line 1
L 06/15/2010 - 17:21:54: [dignatio.smx] SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE LASTONTIME < 1275405714' at line 1
L 06/15/2010 - 17:21:54: [dignatio.smx] SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE LASTONTIME < 1275405714' at line 1
L 06/15/2010 - 17:21:54: [dignatio.smx] [SQLITE=0]Problematic query: Marker X_DEB_021: DELETE FROM  WHERE LASTONTIME < 1275405714

What the hell??? Propably the first (Update player SET POINTS = POINTS - 10 WHERE LASTDEDUCT < 1276527424;) is missing the table string too!)
Looks like an open DB connection before configuration is loaded
_______________________________________________________________
Not a bug but really annoying...: Plugin spamming error log if the database host server is not reachable. Need to add a five retries limit, then wait until mapchange for next retry.
_______________________________________________________________
L 07/07/2010 - 17:28:08: [SM] Plugin encountered error 15: Array index is out of bounds
L 07/07/2010 - 17:28:08: [SM] Displaying call stack trace for plugin "dignatio.smx":
L 07/07/2010 - 17:28:08: [SM]   [0]  Line 1186, dignatio.sp::Command_Say()

(Someone sent say command without arguments?)
____________________________________________________________________________________
L 07/07/2010 - 11:14:40: [dignatio.smx] SQL Error: Duplicate entry 'STEAM_0:1:33433295' for key 'PRIMARY'
L 07/07/2010 - 11:14:41: [dignatio.smx] Problematic query: Marker X_DEB_028: INSERT INTO Player (`NAME`,`STEAMID`,`LASTONTIME`,`LASTDEDUCT`,`country`) VALUES ('Blind-|','STEAM_0:1:33433295',1278494072,1278494072,'Germany')

This should never happen O.o
(Propably DB falsely returned no entry while player connected. Note to myself: Use reliable DB server for testing)

how2install it:

without mysql and webinterface:
1. Copy the *.smx file into your plugin's folder.
2. unzip the translations folder and upload it to /addons/sourcemod/

with mysql: (needed for the webinterface)

1. Enter the Database you would use into the source mod db config file

PHP Code:

"dignatio"
    {
        "driver"            "mysql"
        "host"                "hostname or IP"
        "database"            "database/scheme name"
        "user"                "username"
        "pass"                "password"
        //"timeout"            "0"
        "port"            "usually 3306"
    } 


Note: sourcemod requires a restart to read the new dbconfig

2. Copy the *.smx file into your plugin's folder.
3. Extract the translations.zip into the sourcemod folder via SSH or extract it on your local machine and upload the whole content of the translations folder over your sourcemod/translations folder on the gameserver.

(4. Webpanel)
Extract and upload the whole thing anywhere you wish. Navigate to cssstats/inc/ and edit dbconnect.php to enter your database connection.

Just browse through the cvar list for possible changes you can make:

// This file was auto-generated by SourceMod (v1.3.4)
// ConVars for plugin "dignatio_v0.6.1a.smx"


// Status announcement of the ranking each X seconds. Set < 30 to turn off
// -
// Default: "120.0"
rank_announcements_inverval "120.0"

// Set the points
// -
// Default: "5"
rank_bomb_defused "5"

// Set the points
// -
// Default: "3"
rank_bomb_exploded "3"

// Set the points
// -
// Default: "3"
rank_bomb_planted "3"

// Bots can steal or bring you points
// -
// Default: "0"
rank_bots_influence_rank "0"

// Factor to multiply normal points with if bot was involved
// -
// Default: "0.3333"
rank_bots_point_factor "0.3333"

// How many points a player gets taken for teamkilling a bot
// -
// Default: "0"
rank_botteamkill_malus "0"

// If 0, doesn't record the teamkill to the DB, if victim was a bot
// -
// Default: "0"
rank_botteamkill_record "0"

// Show bottop on round start - 0=disabled, 1=chat, 2=panel
// -
// Default: "0"
rank_bottop_show "0"

// Print to Chat when ranking is enabled/disabled
// -
// Default: "1"
rank_chatannounce "1"

// Set the Chattag
// -
// Default: "RANK"
rank_chattag "RANK"

// Prefix for the four ranking tables in the database
// -
// Default: ""
rank_dbtable_prefix ""

// Set the points a player lose on Death. If -1, the player will lose the same amount of points that the attacker gets.
// -
// Default: "-1"
rank_diepoints "-1"

// disable ranking between rounds
// -
// Default: "1"
rank_disableafterroundwin "1"

// General On/Off toggle
// -
// Default: "1"
rank_enable "1"

// Keep a maximum of X entries per map (0 = unlimited)
// -
// Default: "10000"
rank_heatmaps_countlimit_per_map "10000"

// Keep entries per map up to X days (0 = unlimited)
// -
// Default: "30"
rank_heatmaps_datelimit_per_map "30"

// Heatmap logging enabled (mysql only)
// -
// Default: "1"
rank_heatmaps_record "1"

// Show bot deaths on heatmaps
// -
// Default: "1"
rank_heatmaps_record_bots "1"

// Set the points
// -
// Default: "1"
rank_hostage_follows "1"

// Points to subtract from a CT for killing a hostage
// -
// Default: "4"
rank_hostage_killed_ct "4"

// Points to subtract from a T for killing a hostage
// -
// Default: "2"
rank_hostage_killed_t "2"

// Set the points
// -
// Default: "3"
rank_hostage_rescued "3"

// Set the points the attacker get
// -
// Default: "3"
rank_kill_ak47 "3"

// Set the points the attacker get
// -
// Default: "3"
rank_kill_aug "3"

// Set the points the attacker get
// -
// Default: "3"
rank_kill_awp "3"

// Set the points the attacker get
// -
// Default: "3"
rank_kill_deagle "3"

// Set the points the attacker get
// -
// Default: "3"
rank_kill_elite "3"

// Set the points the attacker get
// -
// Default: "3"
rank_kill_famas "3"

// Set the points the attacker get
// -
// Default: "3"
rank_kill_fiveseven "3"

// Set the points the attacker get
// -
// Default: "3"
rank_kill_g3sg1 "3"

// Set the points the attacker get
// -
// Default: "3"
rank_kill_galil "3"

// Set the points the attacker get
// -
// Default: "3"
rank_kill_glock "3"

// Set the points the attacker get
// -
// Default: "3"
rank_kill_hegrenade "3"

// Set the points the attacker get
// -
// Default: "3"
rank_kill_knife "3"

// Set the points the attacker get
// -
// Default: "3"
rank_kill_m249 "3"

// Set the points the attacker get
// -
// Default: "3"
rank_kill_m3 "3"

// Set the points the attacker get
// -
// Default: "3"
rank_kill_m4a1 "3"

// Set the points the attacker get
// -
// Default: "3"
rank_kill_mac10 "3"

// Set the points the attacker get
// -
// Default: "3"
rank_kill_mp5navy "3"

// Set the points the attacker get
// -
// Default: "3"
rank_kill_p228 "3"

// Set the points the attacker get
// -
// Default: "3"
rank_kill_p90 "3"

// Set the points the attacker get
// -
// Default: "3"
rank_kill_scout "3"

// Set the points the attacker get
// -
// Default: "3"
rank_kill_sg550 "3"

// Set the points the attacker get
// -
// Default: "3"
rank_kill_sg552 "3"

// Set the points the attacker get
// -
// Default: "3"
rank_kill_tmp "3"

// Set the points the attacker get
// -
// Default: "3"
rank_kill_ump45 "3"

// Set the points the attacker get
// -
// Default: "3"
rank_kill_usp "3"

// Set the points the attacker get
// -
// Default: "3"
rank_kill_xm1014 "3"

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

// Do not show gungame stats in session panel
// -
// Default: "1"
rank_nopanelGG "1"

// on point earned message 0 = disabled, 1 = all, 2 = only who earned
// -
// Default: "2"
rank_pointmsg "2"

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

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

// Enable Automatic Removing Player who doesn't conect a specific time on every Roundend
// -
// Default: "1"
rank_removeoldplayers "1"

// The time in days after a player get removed if he doesn't connect min 1 day
// -
// Default: "14"
rank_removeoldplayersdays "14"

// Same like rank_removeoldplayersdays in hours, but for players with 0 kills & 0 deaths & 0 points
// -
// Default: "2"
rank_removevoyeurhours "2"

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

// Shows Top 10 on Roundend
// -
// Default: "0"
rank_showrankonroundend "0"

// How many points a player gets taken on suicide (nade selfkill)
// -
// Default: "1"
rank_suicide_malus "1"

// How many points to take from player on suicide by world entity kill (falling off ledges, kill console command, crushed by a door etc.)
// -
// Default: "1"
rank_suicide_world_malus "1"

// All players of a team get this much points for winning a round
// -
// Default: "0"
rank_team_bonus "0"

// All players of a team lose this much points for losing a round
// -
// Default: "0"
rank_team_malus "0"

// How many points a player gets taken for a teamkill
// -
// Default: "5"
rank_teamkill_malus "5"

// autoclose rank panel on connection after x seconds
// -
// Default: "20"
rank_time_conpanel "20"

// autoclose info panel after x seconds
// -
// Default: "20"
rank_time_infopanel "20"

// autoclose session rank panel on connection after x seconds
// -
// Default: "20"
rank_time_sessionpanel "20"

// autoclose top10 panel after x seconds
// -
// Default: "20"
rank_time_toppanel "20"

// if > 0, deduct this amount of points from a player per day
// -
// Default: "5"
rank_timebase "5"

// Enable/Disable Webrank
// -
// Default: "0"
rank_webrank "0"

// URL to root folder of webpanel. Trailing slash needed!
// -
// Default: ""
rank_webrankurl ""

Addendum: Fixed pagination of webpanels main page, resulting in a minor version push to Webinterface Version 3.5.1.2. Just overwrite index.php on your webspace with the one in attached: 'index.zip'

[Carn]

appreciate you taking the time to try and update R5053's code
test server up and running no errors on anything from fresh install.

will report back once the server gets busy ;)

thx again


*edit forgot to mention using metamod 1.8.0 sourcemod 1.3.0 with webstats and mysql

[Gundamned]

May i ask how exactly to add this to the site? would be very kind of you if you added installation notes, step by step because im kind of new to sql and managing a website

[Timiditas]

You can use installation instructions here -> https://forums.alliedmods.net/showthread.php?t=77249
as its basically the same except of the section name in databases.cfg, which has to be "dignatio" now.

I'll add more details to the first posting when I have fixed some more bugs in the plugin, which I value rather important and annoying in the logs.

[Gundamned]

Well i dont know whats wrong but i still keep getting Database error on css

[thetwistedpanda]

@ Gundamned, it usually helps to post the specific error =P.

[Timiditas]

Logs please

[Gundamned]

L 06/15/2010 - 0681: Log file started (file "logs\L0615004.log") (game "D:\GungameDM\cstrike") (version "4044")
L 06/15/2010 - 0681: server_cvar: "mp_limitteams" "1"
L 06/15/2010 - 0681: server_cvar: "mp_autoteambalance" "1"
L 06/15/2010 - 0681: server_cvar: "mp_friendlyfire" "0"
L 06/15/2010 - 0681: server_cvar: "mp_hostagepenalty" "0"
L 06/15/2010 - 0681: server_cvar: "mp_c4timer" "35"
L 06/15/2010 - 0681: server_cvar: "mp_freezetime" "0"
L 06/15/2010 - 0681: server_cvar: "mp_flashlight" "1"
L 06/15/2010 - 0681: server_cvar: "mp_timelimit" "0"
L 06/15/2010 - 0681: server_cvar: "mp_startmoney" "800"
L 06/15/2010 - 0681: server_cvar: "mp_roundtime" "99"
L 06/15/2010 - 0681: server_cvar: "mp_dynamicpricing" "0"
L 06/15/2010 - 0681: server_cvar: "mp_buytime" "0.25"
L 06/15/2010 - 0681: server_cvar: "mp_weaponstay" "0"
L 06/15/2010 - 0681: server_cvar: "decalfrequency" "10"
L 06/15/2010 - 0681: server_cvar: "sm_ggdm_removeragdolls" "1"
couldn't exec sourcemod/sourcemod.cfg
L 06/15/2010 - 0681: server_cvar: "anticamp_css_version" "2.2"
L 06/15/2010 - 0681: server_cvar: "rank_webrankurl" "http://css-gun.x1.lt/stats"
--------------------------------------------------------
sv_pure set to 2.
Note: Changes to sv_pure take effect when the next map is loaded.
--------------------------------------------------------
****** Executing mani_server.cfg ******
L 06/15/2010 - 0681: server_cvar: "mani_reserve_slots" "1"
****** Finished executing mani_server.cfg ******
****** Executing mani_server.cfg ******
L 06/15/2010 - 0681: server_cvar: "mani_reserve_slots" "1"
****** Finished executing mani_server.cfg ******
--------------------------------------------------------
sv_pure set to 0.
Note: Changes to sv_pure take effect when the next map is loaded.
--------------------------------------------------------
L 06/15/2010 - 0681: World triggered "Round_Start"
CModelLoader::Map_IsValid: 'de_dust2002' is not a valid BSP file
CModelLoader::Map_IsValid: 'de_tuscan' is not a valid BSP file
CModelLoader::Map_IsValid: 'de_dust2002' is not a valid BSP file
CModelLoader::Map_IsValid: 'de_tuscan' is not a valid BSP file
L 06/15/2010 - 0684: [dignatio.smx] Failed to connect to 'dignatio': [2005]: Unknown MySQL server host 'localcost' (11004)
L 06/15/2010 - 0684: [SM] Native "SQL_TQuery" reported: Invalid database Handle 0 (error: 4)
L 06/15/2010 - 0684: [SM] Displaying call stack trace for plugin "dignatio.smx":
L 06/15/2010 - 0684: [SM] [0] Line 3974, /home/groups/alliedmodders/forums/files/5/2/4/4/5/67618.attach::createdbtables()
L 06/15/2010 - 0684: [SM] [1] Line 274, /home/groups/alliedmodders/forums/files/5/2/4/4/5/67618.attach::OnConfigsExecuted()
L 06/15/2010 - 0684: server_cvar: "sv_alltalk" "1"
L 06/15/2010 - 0684: server_cvar: "mp_friendlyfire" "0"
L 06/15/2010 - 0684: server_cvar: "mp_timelimit" "0"
L 06/15/2010 - 0684: World triggered "Round_Start"
L 06/15/2010 - 0689: " <6><BOT><>" entered the game
L 06/15/2010 - 0689: " <7><BOT><>" connected, address "none"
L 06/15/2010 - 0689: " <7><BOT><>" entered the game
L 06/15/2010 - 0689: " <6><BOT><Unassigned>" joined team "CT"
L 06/15/2010 - 0689: " <7><BOT><Unassigned>" joined team "TERRORIST"
L 06/15/2010 - 068:43: server_cvar: "sv_password" "***PROTECTED***"
Jei kyla problemu - admin skype: edenofjinx
Calculate Stats total time [0.000131]
Calculate Stats total time [0.000039]
L 06/15/2010 - 069:10: World triggered "Restart_Round_(1_second)"
L 06/15/2010 - 069:10: Team "CT" scored "0" with "1" players
L 06/15/2010 - 069:10: Team "TERRORIST" scored "0" with "1" players
L 06/15/2010 - 069:11: World triggered "Round_Start"
Musu serverio svetaine : css-gun.x1.lt
L 06/15/2010 - 069:25: [SM] Native "SQL_TQuery" reported: Invalid database Handle 0 (error: 4)
L 06/15/2010 - 069:25: [SM] Displaying call stack trace for plugin "dignatio.smx":
L 06/15/2010 - 069:25: [SM] [0] Line 695, /home/groups/alliedmodders/forums/files/5/2/4/4/5/67618.attach::refreshmaptime()
L 06/15/2010 - 069:25: [SM] [1] Line 618, /home/groups/alliedmodders/forums/files/5/2/4/4/5/67618.attach::sec60evnt()

So,i added mysql as the driver, my hostname is localhost ( dont know if it has to be like that ), then for my database - should i create a new sql database or use my webpages database which is cssgunxl_mysql?
Now for the user name and password - should i use the one with which i connect to cpanel or the one that i create on mysql?
And where should i put the webpanel folder in my host?
Sorry for being such a noob,but im just new to this and i still cant get hang of all this

[Timiditas]

Originally Posted by Gundamned L 06/15/2010 - 0681: Log file started (file "logs\L0615004.log") (game "D:\GungameDM\cstrike") (version "4044") L 06/15/2010 - 0684: [dignatio.smx] Failed to connect to 'dignatio': [2005]: Unknown MySQL server host 'localcost' (11004) L 06/15/2010 - 0684: [SM] Native "SQL_TQuery" reported: Invalid database Handle 0 (error: 4)

Wrong database configuration
By the way, you misspelled 'localcost' in the hostname. Try to correct that first and see if it works. The webpanel will propably not have access to that database if its hosted elsewhere.

Originally Posted by Gundamned my hostname is localhost ( dont know if it has to be like that )

That depends where the DB, you want to use, is located.

Originally Posted by Gundamned , then for my database - should i create a new sql database or use my webpages database which is cssgunxl_mysql?

If you can without additional costs, I'd go for a second database.
If that (or the db of your website) is not located on the same physical (or logical, network-wise) machine, then "localhost" is obviously the wrong hostname. You should use the top level domain of your website, without http or www prefix.
Some webhosts do not allow external database connections, so if that fails, you need another webhost or stick to sqllite.

Originally Posted by Gundamned Now for the user name and password - should i use the one with which i connect to cpanel or the one that i create on mysql?

You should use the one you are using for either the database of your website or the one you set if you create a new db. Not the login data for cpanel.

Originally Posted by Gundamned And where should i put the webpanel folder in my host?

That doesn't matter at all, it just depends where you want the path to the panel to be on your site.

Originally Posted by Gundamned Sorry for being such a noob,but im just new to this and i still cant get hang of all this

There are no stupid questions, just stupid answers.

[Timiditas]

If anyone else besides myself (we are running Warcraft:Source) is having this problem, I'd like to hear your opinions about this.

Originally Posted by Timiditas Known bugs: L 06/13/2010 - 13:44:15: [dignatio.smx] SQL Error: near "+": syntax error L 06/13/2010 - 13:44:15: [dignatio.smx] Problematic query: Marker X_DEB_009: UPDATE Player SET POINTS = POINTS + 0, KILLS = KILLS + 1, + 1 WHERE steamId = 'STEAM_0:0:11869369' Format(query, sizeof(query), "UPDATE %s SET POINTS = POINTS + %i, KILLS = KILLS + 1, %s + 1 WHERE steamId = '%s'", tableplayer, i_pointvalue, sqlWeapon, steamIdattacker); Weapon not detected (server was running Warcraft:Source, victim died because of augmented damage). Even if the query would be correct, attacker would get zero points.

STOP! Before you quit reading now, keep in mind that this bug COULD affect you too even if you don't use WCS. Any Plugin that amplifies damage could possibly trigger this bug.

A possible workaround for this would be to cache the very latest weapon fired for every player (or an exploded grenade, that is) and use the stored weapon to correctly handle augmented damage kills.
Pure Warcraft skill-kills - Ultimates, Items - could be handled seperately.
Including a time-to-live for the weapon cache, emtpy it after 0,5 seconds or something so these can be distinguished from CSS weapon kills.
Additionally, I'd like to add another points cvar for kills with empty weapon cache for that.
What do you think?