New Member
|
05-02-2024
, 19:21
Re: [TF2 Stats/TF2Stats Redux] v1.0.0 (easy to setup multi-server stats)
|
#15
|
Quote:
Originally Posted by iandWE
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?
|
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.
|
|