Raised This Month: $ Target: $400
 0% 

[TF2 Stats/TF2Stats Redux] v1.0.0 (easy to setup multi-server stats)


Post New Thread Reply   
 
Thread Tools Display Modes
MlG M8O
Junior Member
Join Date: May 2015
Old 04-12-2022 , 21:59   Re: [TF2 Stats/TF2Stats Redux] v1.0.0 (easy to setup multi-server stats)
Reply With Quote #11

Quote:
Originally Posted by TF2CutContentWiki View Post
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.
__________________
MlG M8O is offline
Slash The Mighty
Member
Join Date: May 2006
Location: Vault 13
Old 06-02-2022 , 14:57   Re: [TF2 Stats/TF2Stats Redux] v1.0.0 (easy to setup multi-server stats)
Reply With Quote #12

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.
__________________
---
Slash The Mighty is offline
Send a message via AIM to Slash The Mighty Send a message via MSN to Slash The Mighty Send a message via Skype™ to Slash The Mighty
miza_bmdgg
New Member
Join Date: Sep 2023
Old 03-07-2024 , 13:53   Re: [TF2 Stats/TF2Stats Redux] v1.0.0 (easy to setup multi-server stats)
Reply With Quote #13

can someone give a guide how setup database for this plugin?
miza_bmdgg is offline
Edgaras
Junior Member
Join Date: May 2019
Old 04-13-2024 , 19:54   Re: [TF2 Stats/TF2Stats Redux] v1.0.0 (easy to setup multi-server stats)
Reply With Quote #14

Need help with this plugin cause commands doesnt run
__________________
Edgaras is offline
Send a message via Skype™ to Edgaras
creed_enjoyer
New Member
Join Date: May 2024
Old 05-02-2024 , 19:21   Re: [TF2 Stats/TF2Stats Redux] v1.0.0 (easy to setup multi-server stats)
Reply With Quote #15

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?
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.
Attached Files
File Type: smx tf2stats_redux.smx (69.9 KB, 26 views)
File Type: sp Get Plugin or Get Source (tf2stats_redux.sp - 222 views - 249.8 KB)
creed_enjoyer is offline
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 19:09.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode