[xiaoli]

TF2 Stats Simplified Redux

original plugin can be found here in case my thread is not detailed enough :
https://forums.alliedmods.net/showthread.php?p=987696


Description:
This is modified version of TF2 Stats plugin I have done for my community that shut down while back.


Changes:
- automatic setup for multiple servers (only one database per multiple servers, each server will automatically have ip:port based table entry).
- fixed nasty bug with newly added weapons not being registered in stats and not giving points to players.
- removed sqlite support for obvious reasons.



Chat commands:
- "rank" to display your rank to the server.
- "top10" to view the top 10 ranked players.
- "players" to view a list of ingame players.
- "webrank" to get your webrank
- "webtop" to get the webtop
- "session" to get information about your session
- "hidepoints" to hide the points you get
-"unhidepoints" to show the points you get



Admin commands:
- sm_rankadmin - opens the rank admin menu
- rank_givepoints <client> <value> - give points client(s)
- rank_removepoints <client> <value> - remove points from client(s)
- rank_setpoints <client> <value> - sets the client's points to <value>



CVars:
See tf/cfg/tf2-stats.cfg for complete list



Installation
1. Upload all files to their appropriate folders from zip file
2. create new entry in databases.cfg named tf2stats_redux (not tf2stats as old version)
example:

    "tf2stats_redux"
    {
        "driver"            "mysql"
        "host"                "6.6.6.6"
        "database"            "tf2stats_redux"
        "user"                "xiao"
        "pass"                "niaoniao"
        "timeout"            "4"
        "port"            "3306"
    }

3. optionally adjust settings to your liking before uploading to all servers in tf2-stats.cfg in tf/cfg folder
4. setup web interface (instructions can be found in original thread?)
5. enjoy



To-Do:
- custom chatcolors support with cvar for showing next to nick person's rank.
- finish and release custom node.js web panel for TF2 Stats
- add global playtime, global kills, global deaths, etc commands. (across all servers)
- discord support


Credits:
- I take no credit as I just fixed the plugin a bit up, original thread authors and respective people still rock


Please don't be harsh on my code or changes, I'm just edits of plugin I personally enjoyed. Report any issues you find!

[Teamkiller324]

You could add updater support & set up github repository, just a tip

[Teamkiller324]

Updated the code throughout to be in new syntax in which decreased the file size by 10mb and made the cvars easier to manage, aswell changed to version 1.01. (Version cvar was changed to rank_version)

Edit: Fixed cvar handle error (lol)

[USER555]

Thanks

[USER555]

when i typed "session" it shows [tf2stats_redux.smx] Query failed! 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 ':1:572252498 WHERE STEAMID = 'srv_103_23_210_150__27015'' at line 1

[404UserNotFound]

I had been working on a rewrite of the original plugin a few years ago but it was overall too huge for me to finish myself. Glad to see someone came along and fixed it up.

[Teamkiller324]

It's rather worth just rewrite the whole thing from scratch in new syntax. There's bunch of unnecessary code.

[404UserNotFound]

Originally Posted by Teamkiller324 It's rather worth just rewrite the whole thing from scratch in new syntax. There's bunch of unnecessary code.

Yeah, I agree. I had been rewriting it from scratch in new syntax as well as rewriting all the SQL queries. Got the queries complete and then just lost all interest in SourceMod programming and running TF2 servers.

[iandWE]

Hello guys, I have a little problem with this plug-in...

I successfully connected the plugin to the database....

L 01/17/2022 - 12:43:48: [tf2stats_redux.smx] TF2_Stats connected to MySQL Database!

But points, kills, assists, deaths, etc. are not increase, so is the problem...
Only the time spent on the server is working OK.
I hope you can help me, because this is my only hope for statistics on server
________________
UPD
I downloaded mysql table and found it:

CREATE TABLE `srv_46_174_52_25__27238` (
  `STEAMID` varchar(25) NOT NULL,
  `NAME` varchar(30) NOT NULL,
  `POINTS` int(25) NOT NULL DEFAULT '0',
  `PLAYTIME` int(25) NOT NULL DEFAULT '0',
  `LASTONTIME` int(25) NOT NULL DEFAULT '0',
  `KILLS` int(11) NOT NULL DEFAULT '0',
  `Death` int(11) NOT NULL DEFAULT '0',
  `KillAssist` int(11) NOT NULL DEFAULT '0',
  `KillAssistMedic` int(11) NOT NULL DEFAULT '0',
  `BuildSentrygun` int(11) NOT NULL DEFAULT '0',
  `BuildDispenser` int(11) NOT NULL DEFAULT '0',
  `HeadshotKill` int(11) NOT NULL DEFAULT '0',
  `KOSentrygun` int(11) NOT NULL DEFAULT '0',
  `Domination` int(11) NOT NULL DEFAULT '0',
  `Overcharge` int(11) NOT NULL DEFAULT '0',
  `KOSapper` int(11) NOT NULL DEFAULT '0',
  `BOTeleporterentrace` int(11) NOT NULL DEFAULT '0',
  `KODispenser` int(11) NOT NULL DEFAULT '0',
  `BOTeleporterExit` int(11) NOT NULL DEFAULT '0',
  `CPBlocked` int(11) NOT NULL DEFAULT '0',
  `CPCaptured` int(11) NOT NULL DEFAULT '0',
  `FileCaptured` int(11) NOT NULL DEFAULT '0',
  `ADCaptured` int(11) NOT NULL DEFAULT '0',
  `KOTeleporterExit` int(11) NOT NULL DEFAULT '0',
  `KOTeleporterEntrace` int(11) NOT NULL DEFAULT '0',
  `BOSapper` int(11) NOT NULL DEFAULT '0',
  `Revenge` int(11) NOT NULL DEFAULT '0',
  `KW_Axe` int(11) NOT NULL DEFAULT '0',
  `KW_Bnsw` int(11) NOT NULL DEFAULT '0',
  `KW_Bt` int(11) NOT NULL DEFAULT '0',
  `KW_Bttl` int(11) NOT NULL DEFAULT '0',
  `KW_Cg` int(11) NOT NULL DEFAULT '0',
  `KW_Fsts` int(11) NOT NULL DEFAULT '0',
  `KW_Ft` int(11) NOT NULL DEFAULT '0',
  `KW_Gl` int(11) NOT NULL DEFAULT '0',
  `KW_Kn` int(11) NOT NULL DEFAULT '0',
  `KW_Mctte` int(11) NOT NULL DEFAULT '0',
  `KW_Mgn` int(11) NOT NULL DEFAULT '0',
  `KW_Ndl` int(11) NOT NULL DEFAULT '0',
  `KW_Pistl` int(11) NOT NULL DEFAULT '0',
  `KW_Rkt` int(11) NOT NULL DEFAULT '0',
  `KW_Sg` int(11) NOT NULL DEFAULT '0',
  `KW_Sky` int(11) NOT NULL DEFAULT '0',
  `KW_Smg` int(11) NOT NULL DEFAULT '0',
  `KW_Spr` int(11) NOT NULL DEFAULT '0',
  `KW_Stgn` int(11) NOT NULL DEFAULT '0',
  `KW_Wrnc` int(11) NOT NULL DEFAULT '0',
  `KW_Sntry` int(11) NOT NULL DEFAULT '0',
  `KW_SntryL1` int(11) NOT NULL DEFAULT '0',
  `KW_SntryL2` int(11) NOT NULL DEFAULT '0',
  `KW_SntryL3` int(11) NOT NULL DEFAULT '0',
  `KW_Shvl` int(11) NOT NULL DEFAULT '0',
  `KW_Ubersaw` int(11) NOT NULL DEFAULT '0',
  `KW_Flaregun` int(11) NOT NULL DEFAULT '0',
  `KW_Axtinguisher` int(11) NOT NULL DEFAULT '0',
  `KW_taunt_pyro` int(11) NOT NULL DEFAULT '0',
  `KW_taunt_heavy` int(11) NOT NULL DEFAULT '0',
  `KW_gloves` int(11) NOT NULL DEFAULT '0',
  `KW_backburner` int(11) NOT NULL DEFAULT '0',
  `KW_natascha` int(11) NOT NULL DEFAULT '0',
  `KW_blutsauger` int(11) NOT NULL DEFAULT '0',
  `KW_deflect_rocket` int(11) NOT NULL DEFAULT '0',
  `KW_deflect_promode` int(11) NOT NULL DEFAULT '0',
  `KW_deflect_sticky` int(11) NOT NULL DEFAULT '0',
  `KW_world` int(11) NOT NULL DEFAULT '0',
  `KW_bat_wood` int(11) NOT NULL DEFAULT '0',
  `player_stunned` int(11) NOT NULL DEFAULT '0',
  `drunk_bonk` int(11) NOT NULL DEFAULT '0',
  `player_stealsandvich` int(11) NOT NULL DEFAULT '0',
  `chat_status` int(11) NOT NULL DEFAULT '0',
  `KW_tf_projectile_arrow` int(11) NOT NULL DEFAULT '0',
  `KW_ambassador` int(11) NOT NULL DEFAULT '0',
  `KW_taunt_sniper` int(11) NOT NULL DEFAULT '0',
  `KW_taunt_spy` int(11) NOT NULL DEFAULT '0',
  `player_extinguished` int(11) NOT NULL DEFAULT '0',
  `player_teleported` int(11) NOT NULL DEFAULT '0',
  `player_feigndeath` int(11) NOT NULL DEFAULT '0',
  `KW_force_a_nature` int(11) NOT NULL DEFAULT '0',
  `KW_sandman` int(11) NOT NULL DEFAULT '0',
  `K_backstab` int(11) NOT NULL DEFAULT '0',
  `KW_compound_bow` int(11) NOT NULL DEFAULT '0',
  `KW_taunt_scout` int(11) NOT NULL DEFAULT '0',
  `KW_deflect_arrow` int(11) NOT NULL DEFAULT '0',
  `KW_rocketlauncher_directhit` int(11) NOT NULL DEFAULT '0',
  `KW_telefrag` int(11) NOT NULL DEFAULT '0',
  `KW_deflect_flare` int(11) NOT NULL DEFAULT '0',
  `KW_taunt_soldier` int(11) NOT NULL DEFAULT '0',
  `KW_pickaxe` int(11) NOT NULL DEFAULT '0',
  `KW_demoshield` int(11) NOT NULL DEFAULT '0',
  `KW_sword` int(11) NOT NULL DEFAULT '0',
  `KW_taunt_demoman` int(11) NOT NULL DEFAULT '0',
  `KW_sticky_resistance` int(11) NOT NULL DEFAULT '0',
  `KW_tribalkukri` int(11) NOT NULL DEFAULT '0',
  `KW_battleaxe` int(11) NOT NULL DEFAULT '0',
  `KW_ball` int(11) NOT NULL DEFAULT '0',
  `KW_paintrain` int(11) NOT NULL DEFAULT '0',
  `KW_sledgehammer` int(11) NOT NULL DEFAULT '0',
  `KW_unique_pickaxe` int(11) NOT NULL DEFAULT '0',
  `KW_pumpkin` int(11) NOT NULL DEFAULT '0',
  `KW_goomba` int(11) NOT NULL DEFAULT '0',
  `IPAddress` varchar(50) NOT NULL DEFAULT '0',
  `KW_frontier_justice` int(11) NOT NULL DEFAULT '0',
  `KW_wrangler_kill` int(11) NOT NULL DEFAULT '0',
  `KW_robot_arm` int(11) NOT NULL DEFAULT '0',
  `KW_maxgun` int(11) NOT NULL DEFAULT '0',
  `KW_southern_hospitality` int(11) NOT NULL DEFAULT '0',
  `KW_bleed_kill` int(11) NOT NULL DEFAULT '0',
  `KW_robot_arm_blender_kill` int(11) NOT NULL DEFAULT '0',
  `KW_taunt_guitar_kill` int(11) NOT NULL DEFAULT '0',
  `KW_samrevolver` int(11) NOT NULL DEFAULT '0',
  `KW_powerjack` int(11) NOT NULL DEFAULT '0',
  `KW_degreaser` int(11) NOT NULL DEFAULT '0',
  `KW_battleneedle` int(11) NOT NULL DEFAULT '0',
  `KW_eternal_reward` int(11) NOT NULL DEFAULT '0',
  `KW_letranger` int(11) NOT NULL DEFAULT '0',
  `KW_short_stop` int(11) NOT NULL DEFAULT '0',
  `KW_holy_mackerel` int(11) NOT NULL DEFAULT '0',
  `KW_bushwacka` int(11) NOT NULL DEFAULT '0',
  `KW_urgentgloves` int(11) NOT NULL DEFAULT '0',
  `KW_sleeperrifle` int(11) NOT NULL DEFAULT '0',
  `KW_blackbox` int(11) NOT NULL DEFAULT '0',
  `ScoutDeaths` int(11) NOT NULL DEFAULT '0',
  `SoldierDeaths` int(11) NOT NULL DEFAULT '0',
  `PyroDeaths` int(11) NOT NULL DEFAULT '0',
  `DemoDeaths` int(11) NOT NULL DEFAULT '0',
  `HeavyDeaths` int(11) NOT NULL DEFAULT '0',
  `EngiDeaths` int(11) NOT NULL DEFAULT '0',
  `MedicDeaths` int(11) NOT NULL DEFAULT '0',
  `SniperDeaths` int(11) NOT NULL DEFAULT '0',
  `SpyDeaths` int(11) NOT NULL DEFAULT '0',
  `ScoutKills` int(11) NOT NULL DEFAULT '0',
  `SoldierKills` int(11) NOT NULL DEFAULT '0',
  `PyroKills` int(11) NOT NULL DEFAULT '0',
  `DemoKills` int(11) NOT NULL DEFAULT '0',
  `HeavyKills` int(11) NOT NULL DEFAULT '0',
  `EngiKills` int(11) NOT NULL DEFAULT '0',
  `MedicKills` int(11) NOT NULL DEFAULT '0',
  `SniperKills` int(11) NOT NULL DEFAULT '0',
  `SpyKills` int(11) NOT NULL DEFAULT '0',
  `MedicHealing` int(11) NOT NULL DEFAULT '0',
  `KW_robot_arm_combo_kill` int(11) NOT NULL DEFAULT '0',
  `KW_fryingpan` int(11) NOT NULL DEFAULT '0',
  `KW_headtaker` int(11) NOT NULL DEFAULT '0',
  `KW_iron_curtain` int(11) NOT NULL DEFAULT '0',
  `KW_amputator` int(11) NOT NULL DEFAULT '0',
  `KW_healingcrossbow` int(11) NOT NULL DEFAULT '0',
  `KW_brassbeast` int(11) NOT NULL DEFAULT '0',
  `KW_bearclaws` int(11) NOT NULL DEFAULT '0',
  `KW_steelfists` int(11) NOT NULL DEFAULT '0',
  `KW_ullapool_caber` int(11) NOT NULL DEFAULT '0',
  `KW_ullapool_caber_explosion` int(11) NOT NULL DEFAULT '0',
  `KW_minisentry` int(11) NOT NULL DEFAULT '0',
  `KW_lochnload` int(11) NOT NULL DEFAULT '0',
  `KW_candy_cane` int(11) NOT NULL DEFAULT '0',
  `KW_boston_basher` int(11) NOT NULL DEFAULT '0',
  `KW_back_scratcher` int(11) NOT NULL DEFAULT '0',
  `KW_wrench_jag` int(11) NOT NULL DEFAULT '0',
  `KW_claidheamohmor` int(11) NOT NULL DEFAULT '0',
  `KW_worms_grenade` int(11) NOT NULL DEFAULT '0',
  `KW_lava_axe` int(11) NOT NULL DEFAULT '0',
  `KW_sun_bat` int(11) NOT NULL DEFAULT '0',
  `KW_jar` int(11) NOT NULL DEFAULT '0',
  `KW_warfan` int(11) NOT NULL DEFAULT '0',
  `KW_katana` int(11) NOT NULL DEFAULT '0',
  `KW_kunai` int(11) NOT NULL DEFAULT '0',
  `KW_witcher_sword` int(11) NOT NULL DEFAULT '0',
  `KW_maul` int(11) NOT NULL DEFAULT '0',
  `KW_soda_popper` int(11) NOT NULL DEFAULT '0',
  `KW_the_winger` int(11) NOT NULL DEFAULT '0',
  `KW_atomizer` int(11) NOT NULL DEFAULT '0',
  `KW_liberty_launcher` int(11) NOT NULL DEFAULT '0',
  `KW_reserve_shooter` int(11) NOT NULL DEFAULT '0',
  `KW_disciplinary_action` int(11) NOT NULL DEFAULT '0',
  `KW_market_gardener` int(11) NOT NULL DEFAULT '0',
  `KW_mantreads` int(11) NOT NULL DEFAULT '0',
  `KW_detonator` int(11) NOT NULL DEFAULT '0',
  `KW_persian_persuader` int(11) NOT NULL DEFAULT '0',
  `KW_splendid_screen` int(11) NOT NULL DEFAULT '0',
  `KW_tomislav` int(11) NOT NULL DEFAULT '0',
  `KW_family_business` int(11) NOT NULL DEFAULT '0',
  `KW_eviction_notice` int(11) NOT NULL DEFAULT '0',
  `KW_proto_syringe` int(11) NOT NULL DEFAULT '0',
  `KW_solemn_vow` int(11) NOT NULL DEFAULT '0',
  `KW_bazaar_bargain` int(11) NOT NULL DEFAULT '0',
  `KW_shahanshah` int(11) NOT NULL DEFAULT '0',
  `KW_enforcer` int(11) NOT NULL DEFAULT '0',
  `KW_big_earner` int(11) NOT NULL DEFAULT '0',
  `KW_mailbox` int(11) NOT NULL DEFAULT '0',
  `KW_golfclub` int(11) NOT NULL DEFAULT '0',
  `KW_bison` int(11) NOT NULL DEFAULT '0',
  `KW_mangler` int(11) NOT NULL DEFAULT '0',
  `KW_QuakeRL` int(11) NOT NULL DEFAULT '0',
  `TotalPlayersTeleported` int(11) NOT NULL DEFAULT '0',
  `KW_ManglerReflect` int(11) NOT NULL DEFAULT '0',
  `KW_Widowmaker` int(11) NOT NULL DEFAULT '0',
  `KW_Short_Circuit` int(11) NOT NULL DEFAULT '0',
  `KW_Machina` int(11) NOT NULL DEFAULT '0',
  `KW_Machina_DoubleKill` int(11) NOT NULL DEFAULT '0',
  `KW_Diamondback` int(11) NOT NULL DEFAULT '0',
  `KW_UnarmedCombat` int(11) NOT NULL DEFAULT '0',
  `KW_WangaPrick` int(11) NOT NULL DEFAULT '0',
  `KW_ScottishHandshake` int(11) NOT NULL DEFAULT '0',
  `KW_ConscientiousObjector` int(11) NOT NULL DEFAULT '0',
  `KW_Saxxy` int(11) NOT NULL DEFAULT '0',
  `EyeBossStuns` int(11) NOT NULL DEFAULT '0',
  `EyeBossKills` int(11) NOT NULL DEFAULT '0',
  `KW_phlogistinator` int(11) NOT NULL DEFAULT '0',
  `KW_manmelter` int(11) NOT NULL DEFAULT '0',
  `KW_thirddegree` int(11) NOT NULL DEFAULT '0',
  `KW_holiday_punch` int(11) NOT NULL DEFAULT '0',
  `KW_pomson` int(11) NOT NULL DEFAULT '0',
  `KW_eureka_effect` int(11) NOT NULL DEFAULT '0',
  `KW_sharp_dresser` int(11) NOT NULL DEFAULT '0',
  `KW_spy_cicle` int(11) NOT NULL DEFAULT '0',
  `KW_wrap_assassin` int(11) NOT NULL DEFAULT '0',
  `KW_apocofists` int(11) NOT NULL DEFAULT '0',
  `KW_black_rose` int(11) NOT NULL DEFAULT '0',
  `pep_brawlerblaster` int(11) NOT NULL DEFAULT '0',
  `pep_pistol` int(11) NOT NULL DEFAULT '0',
  `dumpster_device` int(11) NOT NULL DEFAULT '0',
  `unique_pickaxe_escape` int(11) NOT NULL DEFAULT '0',
  `rainblower` int(11) NOT NULL DEFAULT '0',
  `scorchshot` int(11) NOT NULL DEFAULT '0',
  `lollichop` int(11) NOT NULL DEFAULT '0',
  `armageddon` int(11) NOT NULL DEFAULT '0',
  `pro_rifle` int(11) NOT NULL DEFAULT '0',
  `pro_smg` int(11) NOT NULL DEFAULT '0',
  `long_heatmaker` int(11) NOT NULL DEFAULT '0',
  `annihilator` int(11) NOT NULL DEFAULT '0',
  `guillotine` int(11) NOT NULL DEFAULT '0',
  `recorder` int(11) NOT NULL DEFAULT '0',

I think, all parameters is '0' and that is reason why kills,deaths,assists not increase?

[404UserNotFound]

Originally Posted by iandWE Hello guys, I have a little problem with this plug-in... I successfully connected the plugin to the database.... L 01/17/2022 - 12:43:48: [tf2stats_redux.smx] TF2_Stats connected to MySQL Database! But points, kills, assists, deaths, etc. are not increase, so is the problem... Only the time spent on the server is working OK. I hope you can help me, because this is my only hope for statistics on server ________________ UPD I downloaded mysql table and found it: CREATE TABLE `srv_46_174_52_25__27238` ( `STEAMID` varchar(25) NOT NULL, `NAME` varchar(30) NOT NULL, `POINTS` int(25) NOT NULL DEFAULT '0', `PLAYTIME` int(25) NOT NULL DEFAULT '0', `LASTONTIME` int(25) NOT NULL DEFAULT '0', `KILLS` int(11) NOT NULL DEFAULT '0', `Death` int(11) NOT NULL DEFAULT '0', `KillAssist` int(11) NOT NULL DEFAULT '0', `KillAssistMedic` int(11) NOT NULL DEFAULT '0', `BuildSentrygun` int(11) NOT NULL DEFAULT '0', `BuildDispenser` int(11) NOT NULL DEFAULT '0', `HeadshotKill` int(11) NOT NULL DEFAULT '0', `KOSentrygun` int(11) NOT NULL DEFAULT '0', `Domination` int(11) NOT NULL DEFAULT '0', `Overcharge` int(11) NOT NULL DEFAULT '0', `KOSapper` int(11) NOT NULL DEFAULT '0', `BOTeleporterentrace` int(11) NOT NULL DEFAULT '0', `KODispenser` int(11) NOT NULL DEFAULT '0', `BOTeleporterExit` int(11) NOT NULL DEFAULT '0', `CPBlocked` int(11) NOT NULL DEFAULT '0', `CPCaptured` int(11) NOT NULL DEFAULT '0', `FileCaptured` int(11) NOT NULL DEFAULT '0', `ADCaptured` int(11) NOT NULL DEFAULT '0', `KOTeleporterExit` int(11) NOT NULL DEFAULT '0', `KOTeleporterEntrace` int(11) NOT NULL DEFAULT '0', `BOSapper` int(11) NOT NULL DEFAULT '0', `Revenge` int(11) NOT NULL DEFAULT '0', `KW_Axe` int(11) NOT NULL DEFAULT '0', `KW_Bnsw` int(11) NOT NULL DEFAULT '0', `KW_Bt` int(11) NOT NULL DEFAULT '0', `KW_Bttl` int(11) NOT NULL DEFAULT '0', `KW_Cg` int(11) NOT NULL DEFAULT '0', `KW_Fsts` int(11) NOT NULL DEFAULT '0', `KW_Ft` int(11) NOT NULL DEFAULT '0', `KW_Gl` int(11) NOT NULL DEFAULT '0', `KW_Kn` int(11) NOT NULL DEFAULT '0', `KW_Mctte` int(11) NOT NULL DEFAULT '0', `KW_Mgn` int(11) NOT NULL DEFAULT '0', `KW_Ndl` int(11) NOT NULL DEFAULT '0', `KW_Pistl` int(11) NOT NULL DEFAULT '0', `KW_Rkt` int(11) NOT NULL DEFAULT '0', `KW_Sg` int(11) NOT NULL DEFAULT '0', `KW_Sky` int(11) NOT NULL DEFAULT '0', `KW_Smg` int(11) NOT NULL DEFAULT '0', `KW_Spr` int(11) NOT NULL DEFAULT '0', `KW_Stgn` int(11) NOT NULL DEFAULT '0', `KW_Wrnc` int(11) NOT NULL DEFAULT '0', `KW_Sntry` int(11) NOT NULL DEFAULT '0', `KW_SntryL1` int(11) NOT NULL DEFAULT '0', `KW_SntryL2` int(11) NOT NULL DEFAULT '0', `KW_SntryL3` int(11) NOT NULL DEFAULT '0', `KW_Shvl` int(11) NOT NULL DEFAULT '0', `KW_Ubersaw` int(11) NOT NULL DEFAULT '0', `KW_Flaregun` int(11) NOT NULL DEFAULT '0', `KW_Axtinguisher` int(11) NOT NULL DEFAULT '0', `KW_taunt_pyro` int(11) NOT NULL DEFAULT '0', `KW_taunt_heavy` int(11) NOT NULL DEFAULT '0', `KW_gloves` int(11) NOT NULL DEFAULT '0', `KW_backburner` int(11) NOT NULL DEFAULT '0', `KW_natascha` int(11) NOT NULL DEFAULT '0', `KW_blutsauger` int(11) NOT NULL DEFAULT '0', `KW_deflect_rocket` int(11) NOT NULL DEFAULT '0', `KW_deflect_promode` int(11) NOT NULL DEFAULT '0', `KW_deflect_sticky` int(11) NOT NULL DEFAULT '0', `KW_world` int(11) NOT NULL DEFAULT '0', `KW_bat_wood` int(11) NOT NULL DEFAULT '0', `player_stunned` int(11) NOT NULL DEFAULT '0', `drunk_bonk` int(11) NOT NULL DEFAULT '0', `player_stealsandvich` int(11) NOT NULL DEFAULT '0', `chat_status` int(11) NOT NULL DEFAULT '0', `KW_tf_projectile_arrow` int(11) NOT NULL DEFAULT '0', `KW_ambassador` int(11) NOT NULL DEFAULT '0', `KW_taunt_sniper` int(11) NOT NULL DEFAULT '0', `KW_taunt_spy` int(11) NOT NULL DEFAULT '0', `player_extinguished` int(11) NOT NULL DEFAULT '0', `player_teleported` int(11) NOT NULL DEFAULT '0', `player_feigndeath` int(11) NOT NULL DEFAULT '0', `KW_force_a_nature` int(11) NOT NULL DEFAULT '0', `KW_sandman` int(11) NOT NULL DEFAULT '0', `K_backstab` int(11) NOT NULL DEFAULT '0', `KW_compound_bow` int(11) NOT NULL DEFAULT '0', `KW_taunt_scout` int(11) NOT NULL DEFAULT '0', `KW_deflect_arrow` int(11) NOT NULL DEFAULT '0', `KW_rocketlauncher_directhit` int(11) NOT NULL DEFAULT '0', `KW_telefrag` int(11) NOT NULL DEFAULT '0', `KW_deflect_flare` int(11) NOT NULL DEFAULT '0', `KW_taunt_soldier` int(11) NOT NULL DEFAULT '0', `KW_pickaxe` int(11) NOT NULL DEFAULT '0', `KW_demoshield` int(11) NOT NULL DEFAULT '0', `KW_sword` int(11) NOT NULL DEFAULT '0', `KW_taunt_demoman` int(11) NOT NULL DEFAULT '0', `KW_sticky_resistance` int(11) NOT NULL DEFAULT '0', `KW_tribalkukri` int(11) NOT NULL DEFAULT '0', `KW_battleaxe` int(11) NOT NULL DEFAULT '0', `KW_ball` int(11) NOT NULL DEFAULT '0', `KW_paintrain` int(11) NOT NULL DEFAULT '0', `KW_sledgehammer` int(11) NOT NULL DEFAULT '0', `KW_unique_pickaxe` int(11) NOT NULL DEFAULT '0', `KW_pumpkin` int(11) NOT NULL DEFAULT '0', `KW_goomba` int(11) NOT NULL DEFAULT '0', `IPAddress` varchar(50) NOT NULL DEFAULT '0', `KW_frontier_justice` int(11) NOT NULL DEFAULT '0', `KW_wrangler_kill` int(11) NOT NULL DEFAULT '0', `KW_robot_arm` int(11) NOT NULL DEFAULT '0', `KW_maxgun` int(11) NOT NULL DEFAULT '0', `KW_southern_hospitality` int(11) NOT NULL DEFAULT '0', `KW_bleed_kill` int(11) NOT NULL DEFAULT '0', `KW_robot_arm_blender_kill` int(11) NOT NULL DEFAULT '0', `KW_taunt_guitar_kill` int(11) NOT NULL DEFAULT '0', `KW_samrevolver` int(11) NOT NULL DEFAULT '0', `KW_powerjack` int(11) NOT NULL DEFAULT '0', `KW_degreaser` int(11) NOT NULL DEFAULT '0', `KW_battleneedle` int(11) NOT NULL DEFAULT '0', `KW_eternal_reward` int(11) NOT NULL DEFAULT '0', `KW_letranger` int(11) NOT NULL DEFAULT '0', `KW_short_stop` int(11) NOT NULL DEFAULT '0', `KW_holy_mackerel` int(11) NOT NULL DEFAULT '0', `KW_bushwacka` int(11) NOT NULL DEFAULT '0', `KW_urgentgloves` int(11) NOT NULL DEFAULT '0', `KW_sleeperrifle` int(11) NOT NULL DEFAULT '0', `KW_blackbox` int(11) NOT NULL DEFAULT '0', `ScoutDeaths` int(11) NOT NULL DEFAULT '0', `SoldierDeaths` int(11) NOT NULL DEFAULT '0', `PyroDeaths` int(11) NOT NULL DEFAULT '0', `DemoDeaths` int(11) NOT NULL DEFAULT '0', `HeavyDeaths` int(11) NOT NULL DEFAULT '0', `EngiDeaths` int(11) NOT NULL DEFAULT '0', `MedicDeaths` int(11) NOT NULL DEFAULT '0', `SniperDeaths` int(11) NOT NULL DEFAULT '0', `SpyDeaths` int(11) NOT NULL DEFAULT '0', `ScoutKills` int(11) NOT NULL DEFAULT '0', `SoldierKills` int(11) NOT NULL DEFAULT '0', `PyroKills` int(11) NOT NULL DEFAULT '0', `DemoKills` int(11) NOT NULL DEFAULT '0', `HeavyKills` int(11) NOT NULL DEFAULT '0', `EngiKills` int(11) NOT NULL DEFAULT '0', `MedicKills` int(11) NOT NULL DEFAULT '0', `SniperKills` int(11) NOT NULL DEFAULT '0', `SpyKills` int(11) NOT NULL DEFAULT '0', `MedicHealing` int(11) NOT NULL DEFAULT '0', `KW_robot_arm_combo_kill` int(11) NOT NULL DEFAULT '0', `KW_fryingpan` int(11) NOT NULL DEFAULT '0', `KW_headtaker` int(11) NOT NULL DEFAULT '0', `KW_iron_curtain` int(11) NOT NULL DEFAULT '0', `KW_amputator` int(11) NOT NULL DEFAULT '0', `KW_healingcrossbow` int(11) NOT NULL DEFAULT '0', `KW_brassbeast` int(11) NOT NULL DEFAULT '0', `KW_bearclaws` int(11) NOT NULL DEFAULT '0', `KW_steelfists` int(11) NOT NULL DEFAULT '0', `KW_ullapool_caber` int(11) NOT NULL DEFAULT '0', `KW_ullapool_caber_explosion` int(11) NOT NULL DEFAULT '0', `KW_minisentry` int(11) NOT NULL DEFAULT '0', `KW_lochnload` int(11) NOT NULL DEFAULT '0', `KW_candy_cane` int(11) NOT NULL DEFAULT '0', `KW_boston_basher` int(11) NOT NULL DEFAULT '0', `KW_back_scratcher` int(11) NOT NULL DEFAULT '0', `KW_wrench_jag` int(11) NOT NULL DEFAULT '0', `KW_claidheamohmor` int(11) NOT NULL DEFAULT '0', `KW_worms_grenade` int(11) NOT NULL DEFAULT '0', `KW_lava_axe` int(11) NOT NULL DEFAULT '0', `KW_sun_bat` int(11) NOT NULL DEFAULT '0', `KW_jar` int(11) NOT NULL DEFAULT '0', `KW_warfan` int(11) NOT NULL DEFAULT '0', `KW_katana` int(11) NOT NULL DEFAULT '0', `KW_kunai` int(11) NOT NULL DEFAULT '0', `KW_witcher_sword` int(11) NOT NULL DEFAULT '0', `KW_maul` int(11) NOT NULL DEFAULT '0', `KW_soda_popper` int(11) NOT NULL DEFAULT '0', `KW_the_winger` int(11) NOT NULL DEFAULT '0', `KW_atomizer` int(11) NOT NULL DEFAULT '0', `KW_liberty_launcher` int(11) NOT NULL DEFAULT '0', `KW_reserve_shooter` int(11) NOT NULL DEFAULT '0', `KW_disciplinary_action` int(11) NOT NULL DEFAULT '0', `KW_market_gardener` int(11) NOT NULL DEFAULT '0', `KW_mantreads` int(11) NOT NULL DEFAULT '0', `KW_detonator` int(11) NOT NULL DEFAULT '0', `KW_persian_persuader` int(11) NOT NULL DEFAULT '0', `KW_splendid_screen` int(11) NOT NULL DEFAULT '0', `KW_tomislav` int(11) NOT NULL DEFAULT '0', `KW_family_business` int(11) NOT NULL DEFAULT '0', `KW_eviction_notice` int(11) NOT NULL DEFAULT '0', `KW_proto_syringe` int(11) NOT NULL DEFAULT '0', `KW_solemn_vow` int(11) NOT NULL DEFAULT '0', `KW_bazaar_bargain` int(11) NOT NULL DEFAULT '0', `KW_shahanshah` int(11) NOT NULL DEFAULT '0', `KW_enforcer` int(11) NOT NULL DEFAULT '0', `KW_big_earner` int(11) NOT NULL DEFAULT '0', `KW_mailbox` int(11) NOT NULL DEFAULT '0', `KW_golfclub` int(11) NOT NULL DEFAULT '0', `KW_bison` int(11) NOT NULL DEFAULT '0', `KW_mangler` int(11) NOT NULL DEFAULT '0', `KW_QuakeRL` int(11) NOT NULL DEFAULT '0', `TotalPlayersTeleported` int(11) NOT NULL DEFAULT '0', `KW_ManglerReflect` int(11) NOT NULL DEFAULT '0', `KW_Widowmaker` int(11) NOT NULL DEFAULT '0', `KW_Short_Circuit` int(11) NOT NULL DEFAULT '0', `KW_Machina` int(11) NOT NULL DEFAULT '0', `KW_Machina_DoubleKill` int(11) NOT NULL DEFAULT '0', `KW_Diamondback` int(11) NOT NULL DEFAULT '0', `KW_UnarmedCombat` int(11) NOT NULL DEFAULT '0', `KW_WangaPrick` int(11) NOT NULL DEFAULT '0', `KW_ScottishHandshake` int(11) NOT NULL DEFAULT '0', `KW_ConscientiousObjector` int(11) NOT NULL DEFAULT '0', `KW_Saxxy` int(11) NOT NULL DEFAULT '0', `EyeBossStuns` int(11) NOT NULL DEFAULT '0', `EyeBossKills` int(11) NOT NULL DEFAULT '0', `KW_phlogistinator` int(11) NOT NULL DEFAULT '0', `KW_manmelter` int(11) NOT NULL DEFAULT '0', `KW_thirddegree` int(11) NOT NULL DEFAULT '0', `KW_holiday_punch` int(11) NOT NULL DEFAULT '0', `KW_pomson` int(11) NOT NULL DEFAULT '0', `KW_eureka_effect` int(11) NOT NULL DEFAULT '0', `KW_sharp_dresser` int(11) NOT NULL DEFAULT '0', `KW_spy_cicle` int(11) NOT NULL DEFAULT '0', `KW_wrap_assassin` int(11) NOT NULL DEFAULT '0', `KW_apocofists` int(11) NOT NULL DEFAULT '0', `KW_black_rose` int(11) NOT NULL DEFAULT '0', `pep_brawlerblaster` int(11) NOT NULL DEFAULT '0', `pep_pistol` int(11) NOT NULL DEFAULT '0', `dumpster_device` int(11) NOT NULL DEFAULT '0', `unique_pickaxe_escape` int(11) NOT NULL DEFAULT '0', `rainblower` int(11) NOT NULL DEFAULT '0', `scorchshot` int(11) NOT NULL DEFAULT '0', `lollichop` int(11) NOT NULL DEFAULT '0', `armageddon` int(11) NOT NULL DEFAULT '0', `pro_rifle` int(11) NOT NULL DEFAULT '0', `pro_smg` int(11) NOT NULL DEFAULT '0', `long_heatmaker` int(11) NOT NULL DEFAULT '0', `annihilator` int(11) NOT NULL DEFAULT '0', `guillotine` int(11) NOT NULL DEFAULT '0', `recorder` int(11) NOT NULL DEFAULT '0', I think, all parameters is '0' and that is reason why kills,deaths,assists not increase?

No that's just setting the default value of those table entries to 0. That query only gets run once to create the table. Your issue lies elsewhere. Probably the plugin. Check your addons/sourcemod/logs folder for an "errors" txt and see if there are any errors being logged from this plugin. If so, post the error here.