Raised This Month: $252 Target: $400
 63% 

[L4D1/2] HxStats Coop (Versus?) Remastered


Post New Thread Reply   
 
Thread Tools Display Modes
Author
Dragokas
Veteran Member
Join Date: Nov 2017
Location: Ukraine
Plugin ID:
6850
Plugin Version:
1.0.22
Plugin Category:
Statistical
Plugin Game:
Left 4 Dead
Plugin Dependencies:
    Servers with this Plugin:
    2 
    Plugin Description:
    Gameplay statistics for L4D coop
    Old 12-11-2019 , 19:33   [L4D1/2] HxStats Coop (Versus?) Remastered
    Reply With Quote #1

    Description:
    It's extended and improved version of HxStats: Coop statistics with MySQL database.

    Basic differences & features:

    * L4D1 support
    * Integration with VIP Core by R1KO (optional).
    * Multi-threaded database (not freeze server anymore)
    * New stat points awards
    * Stat of week / month / VIP of week / month
    * Menu
    * ConVars
    * Useful commands
    * Natives
    * Translation
    * Backup ability
    * Many fixes
    Dependency:
    - (optional) VIP Core by R1KO
    Compatibility:
    - L4D1.
    - L4D2.

    - Coop only.
    - Versus is planned - waiting for your comments here, what statistics points do you want to see...
    Commands:
    Spoiler


    Settings (ConVars):
    Spoiler


    Natives & Usage sample:
    Spoiler


    Using (Installation):
    Spoiler


    Credits:
    * MAKS - original author
    Related topics:
    L4D2 HxStats
    Languages:
    - English
    - Russian
    ChangeLog


    TODO:
    - change column type from blob to name and find out why Russian letters recognized incorrectly in php using such type
    - Read online admins from admins-simple.cfg / admins.cfg to populate "hide" option (for "sm_hx_unhide" command)
    Attached Images
    File Type: jpg 1.jpg (51.7 KB, 577 views)
    File Type: jpg 2.jpg (38.8 KB, 425 views)
    File Type: jpg 3.jpg (38.6 KB, 387 views)
    File Type: jpg 4.jpg (43.0 KB, 382 views)
    Attached Files
    File Type: zip hx_stats.zip (85.7 KB, 4 views)
    __________________
    Expert of CMD/VBS/VB6. Malware analyst. L4D fun (Bloody Witch)
    [My plugins] [My tools] [GitHub] [Articles]

    Last edited by Dragokas; 09-23-2020 at 05:31.
    Dragokas is offline
    Dragokas
    Veteran Member
    Join Date: Nov 2017
    Location: Ukraine
    Old 12-15-2019 , 03:51   Re: [L4D1/2] HxStats Coop Remastered
    Reply With Quote #2

    Quote:
    1.0.5 (15-Dec-2019)
    - Fixed hardcoded string not allowing to use "sm_hx_upgrade".

    1.0.4 (14-Dec-2019)
    - Added penalties:
    * Survivor death
    * Survivor Incap
    * Friendly-fire

    - Added ability to see "Rank of other player"

    * DataBase Table version is now 2.2. Use "sm_hx_upgrade" to upgrade.
    __________________
    Expert of CMD/VBS/VB6. Malware analyst. L4D fun (Bloody Witch)
    [My plugins] [My tools] [GitHub] [Articles]

    Last edited by Dragokas; 12-15-2019 at 04:19.
    Dragokas is offline
    tlch0324
    Senior Member
    Join Date: Jan 2007
    Old 12-15-2019 , 12:06   Re: [L4D1/2] HxStats Coop Remastered
    Reply With Quote #3

    HI, I'm newbie how do I run it after setup a mysql server
    Does it automatically create a database on the mysql server?
    tlch0324 is offline
    ur5efj
    Member
    Join Date: Jan 2006
    Old 12-15-2019 , 12:57   Re: [L4D1/2] HxStats Coop Remastered
    Reply With Quote #4

    Code:
    L 12/15/2019 - 19:49:52: SourceMod error session started
    L 12/15/2019 - 19:49:52: Info (map "c2m3_coaster") (file "C:\SteamCMD\SteamApps\common\Left 4 Dead 2 Dedicated Server\left4dead2\addons\sourcemod\logs\errors_20191215.log")
    L 12/15/2019 - 19:49:52: [l4d2_hx_stats.smx] Field 'Name' doesn't have a default value
    L 12/15/2019 - 19:55:15: Error log file session closed.
    ur5efj is offline
    Dragokas
    Veteran Member
    Join Date: Nov 2017
    Location: Ukraine
    Old 12-15-2019 , 13:28   Re: [L4D1/2] HxStats Coop Remastered
    Reply With Quote #5

    Quote:
    Originally Posted by tlch0324 View Post
    HI, I'm newbie how do I run it after setup a mysql server
    Does it automatically create a database on the mysql server?
    You must have database name, user name and password.
    Plugin automatically creates the table.

    If, for some reason, it doesn't create one, use "sm_hx_sqlcreate" command.
    __________________
    Expert of CMD/VBS/VB6. Malware analyst. L4D fun (Bloody Witch)
    [My plugins] [My tools] [GitHub] [Articles]

    Last edited by Dragokas; 12-15-2019 at 13:29.
    Dragokas is offline
    Dragokas
    Veteran Member
    Join Date: Nov 2017
    Location: Ukraine
    Old 12-15-2019 , 13:29   Re: [L4D1/2] HxStats Coop Remastered
    Reply With Quote #6

    ur5efj, does that error repeat for you?
    __________________
    Expert of CMD/VBS/VB6. Malware analyst. L4D fun (Bloody Witch)
    [My plugins] [My tools] [GitHub] [Articles]
    Dragokas is offline
    ur5efj
    Member
    Join Date: Jan 2006
    Old 12-15-2019 , 14:45   Re: [L4D1/2] HxStats Coop Remastered
    Reply With Quote #7

    This error on every map ( MySQL 5.7.28 )
    Code:
    L 12/15/2019 - 20:17:40: SourceMod error session started
    L 12/15/2019 - 20:17:40: Info (map "c1m1_hotel") (file "C:\SteamCMD\SteamApps\common\Left 4 Dead 2 Dedicated Server\left4dead2\addons\sourcemod\logs\errors_20191215.log")
    L 12/15/2019 - 20:17:40: [l4d2_hx_stats.smx] Field 'Name' doesn't have a default value
    L 12/15/2019 - 20:20:48: Error log file session closed.
    L 12/15/2019 - 20:20:56: SourceMod error session started
    L 12/15/2019 - 20:20:56: Info (map "c1m2_streets") (file "C:\SteamCMD\SteamApps\common\Left 4 Dead 2 Dedicated Server\left4dead2\addons\sourcemod\logs\errors_20191215.log")
    L 12/15/2019 - 20:20:56: [l4d2_hx_stats.smx] Field 'Name' doesn't have a default value
    L 12/15/2019 - 20:28:35: Error log file session closed.
    L 12/15/2019 - 20:28:43: SourceMod error session started
    L 12/15/2019 - 20:28:43: Info (map "c1m3_mall") (file "C:\SteamCMD\SteamApps\common\Left 4 Dead 2 Dedicated Server\left4dead2\addons\sourcemod\logs\errors_20191215.log")
    L 12/15/2019 - 20:28:43: [l4d2_hx_stats.smx] Field 'Name' doesn't have a default value
    L 12/15/2019 - 20:32:55: Error log file session closed.
    L 12/15/2019 - 20:33:03: SourceMod error session started
    L 12/15/2019 - 20:33:03: Info (map "c1m4_atrium") (file "C:\SteamCMD\SteamApps\common\Left 4 Dead 2 Dedicated Server\left4dead2\addons\sourcemod\logs\errors_20191215.log")
    L 12/15/2019 - 20:33:03: [l4d2_hx_stats.smx] Field 'Name' doesn't have a default value
    L 12/15/2019 - 20:41:29: Error log file session closed.
    ur5efj is offline
    Dragokas
    Veteran Member
    Join Date: Nov 2017
    Location: Ukraine
    Old 12-16-2019 , 03:09   Re: [L4D1/2] HxStats Coop Remastered
    Reply With Quote #8

    Thank you.
    Looks like, this happened because your MySQL strictly follow standards.
    Try this one:
    Attached Files
    File Type: sp Get Plugin or Get Source (l4d2_hx_stats.sp - 233 views - 64.5 KB)
    __________________
    Expert of CMD/VBS/VB6. Malware analyst. L4D fun (Bloody Witch)
    [My plugins] [My tools] [GitHub] [Articles]

    Last edited by Dragokas; 12-16-2019 at 03:22.
    Dragokas is offline
    tlch0324
    Senior Member
    Join Date: Jan 2007
    Old 12-16-2019 , 08:34   Re: [L4D1/2] HxStats Coop Remastered
    Reply With Quote #9

    Quote:
    Originally Posted by Dragokas View Post
    You must have database name, user name and password.
    Plugin automatically creates the table.

    If, for some reason, it doesn't create one, use "sm_hx_sqlcreate" command.
    thanks, I input below in the database.cfg, is it correct?

    "l4d2_stats"
    {
    "driver" "mysql"
    "host" "127.0.0.1"
    "database" "l4d2_stats"
    "user" "root"
    "pass" "mypass"
    }
    tlch0324 is offline
    Dragokas
    Veteran Member
    Join Date: Nov 2017
    Location: Ukraine
    Old 12-16-2019 , 09:34   Re: [L4D1/2] HxStats Coop Remastered
    Reply With Quote #10

    It is intended to work with external MySQL database only.
    If 127.0.0.1 not work for you, try to set server's public IP there.
    I'm not completely sure. Still learning sm database stuff. This is my first experience.

    Also, are you sure "database" "l4d2_stats" schema is exist on your server?
    If you don't know what is it, it's better to read some manuals. I don't think this topic is appropriate place for such discussion. It's better you open separate thread in General forum and leave here a link.
    __________________
    Expert of CMD/VBS/VB6. Malware analyst. L4D fun (Bloody Witch)
    [My plugins] [My tools] [GitHub] [Articles]
    Dragokas 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 15:32.


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