Raised This Month: $12 Target: $400
 3% 

[L4D1 & L4D2] DragoStats Coop


Post New Thread Reply   
 
Thread Tools Display Modes
Author
Dragokas
Veteran Member
Join Date: Nov 2017
Location: Ukraine on fire
Plugin ID:
6850
Plugin Version:
1.0.30
Plugin Category:
Statistical
Plugin Game:
Left 4 Dead
Plugin Dependencies:
    Servers with this Plugin:
    12 
    Plugin Description:
    Gameplay statistics for L4D coop
    Old 12-11-2019 , 19:33   [L4D1 & L4D2] DragoStats Coop
    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


    Troubleshooting (mostly Linux)
    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)

    Donate
    Donates are very appreciated and welcomed for further inspiration, make me happy, and make next updates came out more often:
    - Patreon (Paypal)
    - BitCoin
    - Ю.Money
    Attached Images
    File Type: jpg 1.jpg (51.7 KB, 2281 views)
    File Type: jpg 2.jpg (38.8 KB, 1570 views)
    File Type: jpg 3.jpg (38.6 KB, 1458 views)
    File Type: jpg 4.jpg (43.0 KB, 1496 views)
    Attached Files
    File Type: zip drago_stats.zip (92.7 KB, 885 views)
    __________________
    Expert of CMD/VBS/VB6. Malware analyst. L4D fun (Bloody Witch & FreeZone)
    [My plugins] [My tools] [GitHub] [Articles] [HiJackThis+] [Donate]

    Last edited by Dragokas; 01-05-2024 at 13:09.
    Dragokas is offline
    Dragokas
    Veteran Member
    Join Date: Nov 2017
    Location: Ukraine on fire
    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 & FreeZone)
    [My plugins] [My tools] [GitHub] [Articles] [HiJackThis+] [Donate]

    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 on fire
    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 & FreeZone)
    [My plugins] [My tools] [GitHub] [Articles] [HiJackThis+] [Donate]

    Last edited by Dragokas; 12-15-2019 at 13:29.
    Dragokas is offline
    Dragokas
    Veteran Member
    Join Date: Nov 2017
    Location: Ukraine on fire
    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 & FreeZone)
    [My plugins] [My tools] [GitHub] [Articles] [HiJackThis+] [Donate]
    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 on fire
    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 - 957 views - 64.5 KB)
    __________________
    Expert of CMD/VBS/VB6. Malware analyst. L4D fun (Bloody Witch & FreeZone)
    [My plugins] [My tools] [GitHub] [Articles] [HiJackThis+] [Donate]

    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 on fire
    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 & FreeZone)
    [My plugins] [My tools] [GitHub] [Articles] [HiJackThis+] [Donate]
    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 19:34.


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