AlliedModders - [ANY] MySQL Mapcycle

AlliedModders (https://forums.alliedmods.net/index.php)

- Plugins (https://forums.alliedmods.net/forumdisplay.php?f=108)

- - [ANY] MySQL Mapcycle (https://forums.alliedmods.net/showthread.php?t=179086)

[ANY] MySQL Mapcycle

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

Re: [ANY] MySQL Mapcycle

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.

Re: [ANY] MySQL Mapcycle

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

Re: [ANY] MySQL Mapcycle

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

Re: [ANY] MySQL Mapcycle

use the webinterface^^

Re: [ANY] MySQL Mapcycle

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) :P

Re: [ANY] MySQL Mapcycle

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

Re: [ANY] MySQL Mapcycle

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

Re: [ANY] MySQL Mapcycle

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