MySQLCommands

MySQLCommands

MySQLCommands makes it possible to excute console commands from a MySQL Database, this is very useful if you need to automatically promote players after they registered on your website.

How it works

1. You put a console command into a MySQL Database,
   
2. The plugin looks for commands in the database every minute (you can change the check time in the configuration file).
   
3. If the plugin detects a new command, it will excute the command and remove the command from the database.
   
   

Setup

1. Download the plugin, put it in your server's plugins directory, and restart/reload your server.
   
2. Go from your plugins directory to the MySQLCommands directory which has been generated after step 1.
   
3. Edit the config.yml as you want it to have, fill in the right MySQL details, and restart/reload your server, this will generate the MySQL table and columns.
   
4. Now add a command to the MySQL database in the MySQLCommands table. (Don't fill in the ID field but just add a command without slash to the command column).
   
5. The command you added will be excuted in your server's console in max. the time you specified in the configuration file under Schedule, you can also sync the plugin with the database to directly excute the commands using /mysqlcommands sync.
   
   

Online Web Interface

MySQLCommands also has an online web interface where you can easilly add commands to your MySQLCommands database, when a command is added, it will be executed on your server soon (how long it takes until the command will be executed depends on the interval setting of the plugin)
Click here to access the online web interface

Commands and Permissions

Configuration

MySQL:
    Host: localhost              #The IP of the MySQL Server
    Port: 3306                   #The port of the MySQL Server
    Database: minecraft          #The database name
    Username: minecraft          #The username of the MySQL Database
    Password: password           #The password of the MySQL User

Checker:
    Schedule: 60                 #The check interval in seconds (the lower this value is, the more lag it will cause)