SQLScheduler

Ever wanted a to store commands in a database and then run them in the server after a set period of time? Well now you can do it, (almost) hassle free with this new plugin which connects and fetches commands stored in a database, executes them and then remembers the last ones ID, so that no commands would be executed twice! It also has minimal impact on server performance.

Source files included in the .jar

Config

Drag and drop it into your /plugins folder, run the server once and stop it. After that a folder named SQLScheduler will be created which contains the config.yml. In there fill out all the details necessary.

People with the "sqls.admin" permission node will see notifications in chat when command fetching/execution fails or succeeds.

• id_col - Database column which houses the ID's for each commands. necessary in order to avoid duplicate commands
• com_col - Database column which has the command to be run in it
• database - Name of your database
• db_name - Name of the table where the commands are
• server - Name of the host server. Also enter the port here if required so by your hosting company. Usually "yourserver.com" is enough
• user - Username to access the database
• pass - Password for that username
• debug - Show extra debug info (Should be fixed now, i hope)
• last - ID of the last command run, don't touch this, it will break everything

Bugs

• None at the moment. If you find any, notify immediately

Sample uses

• Have a web registration form to receive builder rank
• Use a sms service to sell, for say, pickaxes to users
• Whatever needs remote command execution!

Features yet to be added

• Date support
• Ingame command scheduling

Donate

If you're feeling generous, then why not support. Every penny is appreciated :)