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
- You put a console command into a MySQL Database,
- The plugin looks for commands in the database every minute (you can change the check time in the configuration file).
- If the plugin detects a new command, it will excute the command and remove the command from the database.
Setup
- Download the plugin, put it in your server's plugins directory, and restart/reload your server.
- Go from your plugins directory to the MySQLCommands directory which has been generated after step 1.
- 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.
- 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).
- 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
| Command | Subcommand | Alias(es) | Permission | Description |
|---|---|---|---|---|
| mysqlcommands.* | All MySQLCommands Commands | |||
| mysqlcommands | synchronize, sync | mysqlcmd, dbcmd | mysqlcommands.sync | Sync the plugin with the database |
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)
-
View User Profile
-
Send Message
Posted Mar 26, 2016@basdv98
Thank you!
but i have some error : http://pastebin.com/qhNRZ251 ;-)
-
View User Profile
-
Send Message
Posted Mar 24, 2016@ludgart
For multiple servers, just use multiple databases.
-
View User Profile
-
Send Message
Posted Mar 23, 2016@Gruniek
Plugin has been updated, the file is currently waiting for approval. (version number 1.1)
-
View User Profile
-
Send Message
Posted Mar 23, 2016@Gruniek
Will be done very shortly.
@ludgart
I'll take a look at that.
@leonfagan71
I'll see if I can make that possible for you.
-
View User Profile
-
Send Message
Posted Mar 9, 2016Please update to 1.9 !!!
-
View User Profile
-
Send Message
Posted Aug 28, 2015This is a great plugin, I've done a lot of scripting and set this up with our shop,
it would be great if you can set commands to run when a specific player joins but the complete integration system works amazingly.
-
View User Profile
-
Send Message
Posted Jun 21, 2015Need a function for multiple server.
-
View User Profile
-
Send Message
Posted Mar 10, 2015If anyone need it, I've made a php interface to send commands here's my github repository: https://github.com/J0ker98/MySQLCommands
-
View User Profile
-
Send Message
Posted Feb 8, 2015@SPGEARClub @Hyurst
It's up!
-
View User Profile
-
Send Message
Posted Oct 17, 2013@Hyurst I'm working on it, It will be up soon! I'm glad you're interessed :D
@SPGEARClub I'm working on it, It will be up soon! I'm glad you're interessed :D
-
View User Profile
-
Send Message
Posted Aug 2, 2013Up ?
-
View User Profile
-
Send Message
Posted Jul 19, 2013Hi,
he project is maintained ? I'm really interested in this plugin.
Thx
-
View User Profile
-
Send Message
Posted Jun 26, 2013Looks very useful, I really need it soon ;)