BANNED
|

01-18-2022
, 20:49
Re: [TF2 Stats/TF2Stats Redux] v1.0.0 (easy to setup multi-server stats)
|
#10
|
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?
|
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 20:50.
|
|