Raised This Month: $159 Target: $400
 39% 

[CS:GO/JB] JailBreak/Last-Request: LEADERBOARD


Post New Thread Reply   
 
Thread Tools Display Modes
Author
IT_KILLER
Member
Join Date: Jul 2017
Plugin ID:
5959
Plugin Version:
1.0
Plugin Category:
Statistical
Plugin Game:
Counter-Strike: GO
Plugin Dependencies:
    Servers with this Plugin:
     
    Plugin Description:
    The plugin collects data at LR and presents it in a top list of those that have performed best.
    Old 12-28-2017 , 13:22   [CS:GO/JB] JailBreak/Last-Request: LEADERBOARD
    Reply With Quote #1

    [CS:GO/JB] JailBreak/Last-Request: LEADERBOARD 1.0

    >>Github<<


    An addons to SM Hosties. The plugin collects data at LR and presents it in a top list of those that have performed best.

    Commands
    • !lrtop- Admin room menu (Leaderboard menu).
    • !clearlrtop- Emptying the leaderboard (ONLY SERVER).

    Requires
    Please read the installation instructions on github, it is super easy and the one thing that just needs to be configured.

    >>Github SOURCE CODE + DOWNLOAD<<
    __________________
    If you have any suggestions for improvement, let me know. I appreciate all feedback.
    >>> GITHUB <<<

    Last edited by IT_KILLER; 12-28-2017 at 16:44.
    IT_KILLER is offline
    Fastmancz
    Senior Member
    Join Date: Jul 2013
    Location: Czech Republic
    Old 12-29-2017 , 13:50   Re: [CS:GO/JB] JailBreak/Last-Request: LEADERBOARD
    Reply With Quote #2

    Hello,

    thanks for your interesting plugin. I use MySQL and I have a problem - no table is created. I manually tried the SQL query.

    CREATE TABLE IF NOT EXISTS leaderboard (id INTEGER PRIMARY KEY AUTOINCREMENT, name varchar(64) NOT NULL DEFAULT ' ', steamid varchar(64) NOT NULL UNIQUE, eligible_lr INTEGER DEFAULT '0', start_lr INTEGER DEFAULT '0', won_lr INTEGER DEFAULT '0', most_lr INTEGER DEFAULT '0', guards_beaten INTEGER DEFAULT '0')

    #1064 - 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 'AUTOINCREMENT, name varchar(64) NOT NULL DEFAULT ' ', steamid varchar(64) NOT NU' at line 1

    Thanks for the quick fix.
    __________________


    Main owner of the CMG portal.
    ---------------------------------------
    My plugins:
    [CS:GO] Panorama - Timeleft
    [CS:GO] JailBreak - Be quiet, please!

    Last edited by Fastmancz; 12-29-2017 at 13:50.
    Fastmancz is offline
    IT_KILLER
    Member
    Join Date: Jul 2017
    Old 12-29-2017 , 14:13   Re: [CS:GO/JB] JailBreak/Last-Request: LEADERBOARD
    Reply With Quote #3

    Quote:
    Originally Posted by Fastmancz View Post
    Hello,

    thanks for your interesting plugin. I use MySQL and I have a problem - no table is created. I manually tried the SQL query.

    CREATE TABLE IF NOT EXISTS leaderboard (id INTEGER PRIMARY KEY AUTOINCREMENT, name varchar(64) NOT NULL DEFAULT ' ', steamid varchar(64) NOT NULL UNIQUE, eligible_lr INTEGER DEFAULT '0', start_lr INTEGER DEFAULT '0', won_lr INTEGER DEFAULT '0', most_lr INTEGER DEFAULT '0', guards_beaten INTEGER DEFAULT '0')

    #1064 - 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 'AUTOINCREMENT, name varchar(64) NOT NULL DEFAULT ' ', steamid varchar(64) NOT NU' at line 1

    Thanks for the quick fix.
    Thank you for your comment.

    The changes you make in database.cfg sometimes take two map changes or a server reboot to work.

    My syntax is written for Sqlite. The syntax needs to be changed to work with mysql.

    Change to sqlite, it should work. Tell me if you got it working or if you need help.

    addons\sourcemod\configs\databases.cfg
    PHP Code:
    "lr-leaderboard"
    {
         
    "driver"   "sqlite"
         "host      "
    localhost"
         "
    database" "lr-leaderboard-sqlite"
         "
    user"     "root"
         "
    pass"     ""

    __________________
    If you have any suggestions for improvement, let me know. I appreciate all feedback.
    >>> GITHUB <<<
    IT_KILLER is offline
    paulo_crash
    AlliedModders Donor
    Join Date: May 2016
    Location: Brazil
    Old 10-24-2018 , 23:59   Re: [CS:GO/JB] JailBreak/Last-Request: LEADERBOARD
    Reply With Quote #4

    Would it be possible to make it compatible with this version of Hosties? Or would it already be the case?
    __________________
    paulo_crash is offline
    Send a message via Skype™ to paulo_crash
    S4muRaY
    BANNED
    Join Date: Oct 2018
    Old 10-25-2018 , 02:03   Re: [CS:GO/JB] JailBreak/Last-Request: LEADERBOARD
    Reply With Quote #5

    Looks good but how is it useful?
    S4muRaY 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 04:51.


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