[MlG M8O]

Originally Posted by TF2CutContentWiki 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.

Not to revive a pretty dead post but the plugin shows no errors from my side and this is still an issue.

On another note, I am personally working on upgrading the previous TF2stats webpanel and updating it to PHP 7.0 syntax and it's been going well so far albeit having little to no prior experience with web development. However, there are pretty big roadblocks, and this issue is one of them as the kills section in the "Player Ranking" page of the old panel is not updating at all.

[Slash The Mighty]

Any chance someone's able to compile this for TF2C? I tried using the TF2Classic-Tools, but it gives me errors and that's when I gotta declare defeat
https://github.com/Scags/TF2Classic-Tools

Would be even more amazing if the civilian class could be included in the stats too, but I get that might be a major mod.

[miza_bmdgg]

can someone give a guide how setup database for this plugin?

[Edgaras]

Need help with this plugin cause commands doesnt run

[creed_enjoyer]

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?

So I figured out the issue. There are a few errors in the existing script. I have attached a fixed version of the plugin source code along with a re-compiled version.