Raised This Month: $344 Target: $400
 86%   Almost there!

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


Post New Thread Reply   
 
Thread Tools Display Modes
Author
xiaoli
New Member
Join Date: Jan 2022
Location: Hong Kong
Plugin ID:
7908
Plugin Version:
1.00
Plugin Category:
Statistical
Plugin Game:
Team Fortress 2
Plugin Dependencies:
    Servers with this Plugin:
     
    Plugin Description:
    Multi-server easy to setup version of TF2 Stats plugin with bunch of fixes!
    Old 01-03-2022 , 09:10   [TF2 Stats/TF2Stats Redux] v1.0.0 (easy to setup multi-server stats)
    Reply With Quote #1


    TF2 Stats Simplified Redux

    original plugin can be found here in case my thread is not detailed enough :
    https://forums.alliedmods.net/showthread.php?p=987696


    Description:
    This is modified version of TF2 Stats plugin I have done for my community that shut down while back.


    Changes:
    - automatic setup for multiple servers (only one database per multiple servers, each server will automatically have ip:port based table entry).
    - fixed nasty bug with newly added weapons not being registered in stats and not giving points to players.
    - removed sqlite support for obvious reasons.



    Chat commands:
    - "rank" to display your rank to the server.
    - "top10" to view the top 10 ranked players.
    - "players" to view a list of ingame players.
    - "webrank" to get your webrank
    - "webtop" to get the webtop
    - "session" to get information about your session
    - "hidepoints" to hide the points you get
    -"unhidepoints" to show the points you get



    Admin commands:
    - sm_rankadmin - opens the rank admin menu
    - rank_givepoints <client> <value> - give points client(s)
    - rank_removepoints <client> <value> - remove points from client(s)
    - rank_setpoints <client> <value> - sets the client's points to <value>



    CVars:
    See tf/cfg/tf2-stats.cfg for complete list



    Installation
    1. Upload all files to their appropriate folders from zip file
    2. create new entry in databases.cfg named tf2stats_redux (not tf2stats as old version)
    example:
    Code:
        "tf2stats_redux"
        {
            "driver"            "mysql"
            "host"                "6.6.6.6"
            "database"            "tf2stats_redux"
            "user"                "xiao"
            "pass"                "niaoniao"
            "timeout"            "4"
            "port"            "3306"
        }
    3. optionally adjust settings to your liking before uploading to all servers in tf2-stats.cfg in tf/cfg folder
    4. setup web interface (instructions can be found in original thread?)
    5. enjoy



    To-Do:
    - custom chatcolors support with cvar for showing next to nick person's rank.
    - finish and release custom node.js web panel for TF2 Stats
    - add global playtime, global kills, global deaths, etc commands. (across all servers)
    - discord support


    Credits:
    - I take no credit as I just fixed the plugin a bit up, original thread authors and respective people still rock


    Please don't be harsh on my code or changes, I'm just edits of plugin I personally enjoyed. Report any issues you find!
    Attached Files
    File Type: zip tf2stats redux.zip (1.57 MB, 157 views)

    Last edited by xiaoli; 01-03-2022 at 09:55.
    xiaoli is offline
    Teamkiller324
    Senior Member
    Join Date: Feb 2014
    Location: m_bTeamKiller
    Old 01-05-2022 , 08:55   Re: [TF2 Stats/TF2Stats Redux] v1.0.0 (easy to setup multi-server stats)
    Reply With Quote #2

    You could add updater support & set up github repository, just a tip
    __________________
    Steam - GitHub - Tk Libraries - Updater
    No private plugin requests.
    Teamkiller324 is offline
    Send a message via Skype™ to Teamkiller324
    Teamkiller324
    Senior Member
    Join Date: Feb 2014
    Location: m_bTeamKiller
    Old 01-07-2022 , 00:01   Re: [TF2 Stats/TF2Stats Redux] v1.0.0 (easy to setup multi-server stats)
    Reply With Quote #3

    Updated the code throughout to be in new syntax in which decreased the file size by 10mb and made the cvars easier to manage, aswell changed to version 1.01. (Version cvar was changed to rank_version)

    Edit: Fixed cvar handle error (lol)
    Attached Files
    File Type: sp Get Plugin or Get Source (tf2stats_redux.sp - 69 views - 231.0 KB)
    __________________
    Steam - GitHub - Tk Libraries - Updater
    No private plugin requests.

    Last edited by Teamkiller324; 01-12-2022 at 06:59. Reason: Fixed cvar handle error
    Teamkiller324 is offline
    Send a message via Skype™ to Teamkiller324
    USER555
    Junior Member
    Join Date: Aug 2020
    Location: Thailand
    Old 01-08-2022 , 08:45   Re: [TF2 Stats/TF2Stats Redux] v1.0.0 (easy to setup multi-server stats)
    Reply With Quote #4

    Thanks
    USER555 is offline
    USER555
    Junior Member
    Join Date: Aug 2020
    Location: Thailand
    Old 01-08-2022 , 23:35   Re: [TF2 Stats/TF2Stats Redux] v1.0.0 (easy to setup multi-server stats)
    Reply With Quote #5

    when i typed "session" it shows [tf2stats_redux.smx] Query failed! You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ':1:572252498 WHERE STEAMID = 'srv_103_23_210_150__27015'' at line 1

    Last edited by USER555; 01-09-2022 at 00:10.
    USER555 is offline
    TF2CutContentWiki
    ( ͡ ͜ʖ ͡)
    Join Date: Dec 2011
    Old 01-12-2022 , 05:13   Re: [TF2 Stats/TF2Stats Redux] v1.0.0 (easy to setup multi-server stats)
    Reply With Quote #6

    I had been working on a rewrite of the original plugin a few years ago but it was overall too huge for me to finish myself. Glad to see someone came along and fixed it up.
    TF2CutContentWiki is offline
    Teamkiller324
    Senior Member
    Join Date: Feb 2014
    Location: m_bTeamKiller
    Old 01-15-2022 , 13:13   Re: [TF2 Stats/TF2Stats Redux] v1.0.0 (easy to setup multi-server stats)
    Reply With Quote #7

    It's rather worth just rewrite the whole thing from scratch in new syntax. There's bunch of unnecessary code.
    __________________
    Steam - GitHub - Tk Libraries - Updater
    No private plugin requests.
    Teamkiller324 is offline
    Send a message via Skype™ to Teamkiller324
    TF2CutContentWiki
    ( ͡ ͜ʖ ͡)
    Join Date: Dec 2011
    Old 01-16-2022 , 21:14   Re: [TF2 Stats/TF2Stats Redux] v1.0.0 (easy to setup multi-server stats)
    Reply With Quote #8

    Quote:
    Originally Posted by Teamkiller324 View Post
    It's rather worth just rewrite the whole thing from scratch in new syntax. There's bunch of unnecessary code.
    Yeah, I agree. I had been rewriting it from scratch in new syntax as well as rewriting all the SQL queries. Got the queries complete and then just lost all interest in SourceMod programming and running TF2 servers.
    TF2CutContentWiki is offline
    iandWE
    New Member
    Join Date: Jan 2022
    Old 01-17-2022 , 04: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:	49
Size:	11.8 KB
ID:	193156  

    Last edited by iandWE; 01-17-2022 at 05:09. Reason: upd
    iandWE is offline
    TF2CutContentWiki
    ( ͡ ͜ʖ ͡)
    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 TF2CutContentWiki; 01-18-2022 at 19:50.
    TF2CutContentWiki 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 00:58.


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