Raised This Month: $154 Target: $400
 38% 

[ANY] MySQL Mapcycle


Post New Thread Reply   
 
Thread Tools Display Modes
Author
ecca
Sexy Santa
Join Date: Jan 2011
Plugin ID:
2817
Plugin Version:
1.2
Plugin Category:
Server Management
Plugin Game:
Any
Plugin Dependencies:
    Servers with this Plugin:
    2 
    Plugin Description:
    Allows you to control your mapcycle through MySQL
    Old 02-25-2012 , 11:22   [ANY] MySQL Mapcycle
    Reply With Quote #1

    MySQL Mapcycle

    A simple plugin that allows you to setup your mapcycle through MySQL.

    Installation:
    • Copy the mysql_mapcycle.smx to your plugins directory
    • *OPTIONAL* Webinterface: included in the zip file.
    Cvars:
    • None
    Command:
    sm_reloadmapcycle - root flag

    Setup:

    Quote:
    Databases.cfg:
    "mapcycle"
    {
    "driver" "mysql"
    "host" "YourHost"
    "database" "YourDatabase"
    "user" "YourUser"
    "pass" "YourPassword"
    //"timeout" "0"
    //"port" "0"
    }

    MySQL Table: (Note: Change mapcycle to the new one if you changed the table prefix in the plugin)

    CREATE TABLE IF NOT EXISTS `mapcycle` (
    `mapname` varchar(64) NOT NULL DEFAULT ''
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1;

    Webinterface:
    Just download it, edit the mysql connection and upload it into your webhost, be sure to hide it or just delete it after use
    ToDo:
    Quote:
    - WebInterface comming today or tomorrow
    Plugin Changelog:
    Quote:
    MySQL Mapcycle 1.2
    - Optimized plugin to only recreate mapcycle on pluginstart / admin command
    - Added admin commando sm_reloadmapcycle to redownload the mapcycle
    - Fixed issues listed by approver
    - Webinterface released again

    MySQL Mapcycle 1.1
    - Fixed ConVar letting you use multiple servers on one database using table prefix

    MySQL Mapcycle 1.0
    - Initial release
    WebbInterface Changelog:
    Quote:
    Webinterface 1.0
    - Initial release
    Download here: Github

    Last edited by ecca; 03-24-2015 at 04:40. Reason: Updated link
    ecca is offline
    Drixevel
    AlliedModders Donor
    Join Date: Sep 2009
    Old 02-25-2012 , 11:50   Re: [ANY] MySQL Mapcycle
    Reply With Quote #2

    Well shit, knocks one idea off my list to make. Thanks for the plugin. lol

    You should ask HSFighter to integrate this with his sourcemod webadmin script.
    __________________
    Taking private requests: http://steamcommunity.com/id/Drixevel/
    Drixevel is offline
    ecca
    Sexy Santa
    Join Date: Jan 2011
    Old 02-25-2012 , 12:46   Re: [ANY] MySQL Mapcycle
    Reply With Quote #3

    Done, i pm'ed HSFigher, also done with webinterface that allows you to copy paste WHOLE your mapcycle so it will go fast to convert into this plugin ;)
    ecca is offline
    Drixevel
    AlliedModders Donor
    Join Date: Sep 2009
    Old 02-25-2012 , 17:40   Re: [ANY] MySQL Mapcycle
    Reply With Quote #4

    Thank ya kindly.
    __________________
    Taking private requests: http://steamcommunity.com/id/Drixevel/
    Drixevel is offline
    loranger
    Senior Member
    Join Date: Jun 2011
    Old 02-26-2012 , 00:25   Re: [ANY] MySQL Mapcycle
    Reply With Quote #5

    can we have a simple guide on how to add maps to mysql mapcycle plz
    loranger is offline
    ecca
    Sexy Santa
    Join Date: Jan 2011
    Old 02-26-2012 , 01:07   Re: [ANY] MySQL Mapcycle
    Reply With Quote #6

    use the webinterface^^
    ecca is offline
    Archey
    Member
    Join Date: Aug 2009
    Old 02-26-2012 , 02:28   Re: [ANY] MySQL Mapcycle
    Reply With Quote #7

    This is actaully a great idea, do you think it would work with multiple servers?

    (not sure why someone would wan't multiple servers with the same maplist)
    __________________

    Archey is offline
    ecca
    Sexy Santa
    Join Date: Jan 2011
    Old 02-26-2012 , 02:56   Re: [ANY] MySQL Mapcycle
    Reply With Quote #8

    Ye it will work with multiple servers if you use the same connection, i can update so you can select the table prefix instead letting you have multiple servers connected to same database but with diffrent mapcycles

    EDIT: Updated 1.1

    Last edited by ecca; 02-26-2012 at 03:07.
    ecca is offline
    ecca
    Sexy Santa
    Join Date: Jan 2011
    Old 03-01-2012 , 12:21   Re: [ANY] MySQL Mapcycle
    Reply With Quote #9

    Confirmed that the plugin will be in the Sourcemod Webadmin in the next update ;)
    ecca is offline
    snelvuur
    Veteran Member
    Join Date: Jun 2008
    Location: Netherlands
    Old 03-02-2012 , 08:02   Re: [ANY] MySQL Mapcycle
    Reply With Quote #10

    Same method could be used for UMC mapchooser too, but uses a different format.
    __________________
    Arguing with a fool only proves there are two
    snelvuur 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 05:49.


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