SQLScheduler
Works with Craftbukkit 1.3.2 R0.1
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 :)
Looks cool: Interval it runs by and custom message to user it is run towards?
I as well would be curious on the interval it runs, it would be nice if it was configurable. Also any cahnce of changing the way it remembers what it runs, maybe instead mark it as completed by addind a completed column in the table. This way the webserver can see if the command was ran and also less susceptible to breaking. I guess the only disadvantage is that the mysql user would need write perms as well.
ehhmmm how to add commands? interval?
@idiotonastic
Yup, new version just got accepted by bukkit too.
Work for 1.3.1?
@vegan88 Read the description, it says, source in the .jar file.
Claims to be GPL but doesn't provide source code?
@MineCraftPhiL
You create the tables yourself and then specify them in the config. It's meant more for those who want to incorporate a web interface/service/database into their server.
Adding support for ingame command scheduling is currently in the todo list.
how work's? create own tables?
Marry me?