View Single Post
iandWE
New Member
Join Date: Jan 2022
Old 01-17-2022 , 05:59   Re: [TF2 Stats/TF2Stats Redux] v1.0.0 (easy to setup multi-server stats)
Reply With Quote #9

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?
Attached Thumbnails
Click image for larger version

Name:	Screenshot_4.png
Views:	64
Size:	11.8 KB
ID:	193156  

Last edited by iandWE; 01-17-2022 at 06:09. Reason: upd
iandWE is offline