View Single Post
404UserNotFound
BANNED
Join Date: Dec 2011
Old 01-18-2022 , 19:49   Re: [TF2 Stats/TF2Stats Redux] v1.0.0 (easy to setup multi-server stats)
Reply With Quote #10

Quote:
Originally Posted by iandWE View Post
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.

Last edited by 404UserNotFound; 01-18-2022 at 19:50.
404UserNotFound is offline