[ecca]

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:

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:

- WebInterface comming today or tomorrow

Plugin Changelog:

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:

Webinterface 1.0 - Initial release

Download here: Github

[Drixevel]

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.

[ecca]

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 ;)

[Drixevel]

Thank ya kindly.

[loranger]

can we have a simple guide on how to add maps to mysql mapcycle plz

[ecca]

use the webinterface^^

[Archey]

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)

[ecca]

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

[ecca]

Confirmed that the plugin will be in the Sourcemod Webadmin in the next update ;)

[snelvuur]

Same method could be used for UMC mapchooser too, but uses a different format.