AlliedModders

AlliedModders (https://forums.alliedmods.net/index.php)
-   Plugins (https://forums.alliedmods.net/forumdisplay.php?f=108)
-   -   [TF2 Stats/TF2Stats Redux] v1.0.0 (easy to setup multi-server stats) (https://forums.alliedmods.net/showthread.php?t=335778)

xiaoli 01-03-2022 09:10

[TF2 Stats/TF2Stats Redux] v1.0.0 (easy to setup multi-server stats)
 
1 Attachment(s)
https://media.springernature.com/w50..._Figa_HTML.png
TF2 Stats Simplified Redux

original plugin can be found here in case my thread is not detailed enough :crab::
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:
Code:

    "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 :bacon!:


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 01-05-2022 08:55

Re: [TF2 Stats/TF2Stats Redux] v1.0.0 (easy to setup multi-server stats)
 
You could add updater support & set up github repository, just a tip

Teamkiller324 01-07-2022 00:01

Re: [TF2 Stats/TF2Stats Redux] v1.0.0 (easy to setup multi-server stats)
 
1 Attachment(s)
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 01-08-2022 08:45

Re: [TF2 Stats/TF2Stats Redux] v1.0.0 (easy to setup multi-server stats)
 
Thanks

USER555 01-08-2022 23:35

Re: [TF2 Stats/TF2Stats Redux] v1.0.0 (easy to setup multi-server stats)
 
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

TF2CutContentWiki 01-12-2022 05:13

Re: [TF2 Stats/TF2Stats Redux] v1.0.0 (easy to setup multi-server stats)
 
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 01-15-2022 13:13

Re: [TF2 Stats/TF2Stats Redux] v1.0.0 (easy to setup multi-server stats)
 
It's rather worth just rewrite the whole thing from scratch in new syntax. There's bunch of unnecessary code.

TF2CutContentWiki 01-16-2022 21:14

Re: [TF2 Stats/TF2Stats Redux] v1.0.0 (easy to setup multi-server stats)
 
Quote:

Originally Posted by Teamkiller324 (Post 2768501)
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 01-17-2022 04:59

Re: [TF2 Stats/TF2Stats Redux] v1.0.0 (easy to setup multi-server stats)
 
1 Attachment(s)
Hello guys, I have a little problem with this plug-in...

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

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:
Code:

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?

TF2CutContentWiki 01-18-2022 19:49

Re: [TF2 Stats/TF2Stats Redux] v1.0.0 (easy to setup multi-server stats)
 
Quote:

Originally Posted by iandWE (Post 2768621)
Hello guys, I have a little problem with this plug-in...

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

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:
Code:

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.


All times are GMT -4. The time now is 00:23.

Powered by vBulletin®
Copyright ©2000 - 2022, vBulletin Solutions, Inc.