Bukkit MySQL-Reader

Table of Contents

General:

This plugin reads commands from a MySQL database and performs them with operating rights to the console.

GitHub: http://github.com/mrpixeldream/MySQL-Reader

Features:

Automated extraction of commands from a table
Login data configurable
Interval: Configurable (defined in minutes)
Query on the port which is defined in config (by default, it is 3306)
Deleting commands from the table after execution if you want to

Installation and configuration:

To install the plugin you just have to specify the login data to the MySQL server in the plugin's configuration file which is found in "plugins/MySQL-Reader/config.yml". After that, you have to reload your server. Now, create a column with that name you have specified in the configuration file. This column has to contain items of the SQL type "VARCHAR". Now, just enter your commands and have fun :D

Upcoming Features:

Ingame commands to add and remove tasks
Ingame commands to change the configuration

Known Bugs:

No bugs are actually known! Feel free to report some!

Changelog:

1.0:

Initial release

2.0:

Added configuration option for interval in minutes
Added adjustable column name
Added adjustable port
Renamed some classes
Added description to the plugin.yml file

3.0:

Added configuration option for using the commands just once
Fixed connection not closing properly

Sample config:

Config:
  server: localhost
  table: bukkit
  database: bukkit
  user: root
  password: password
  port: 3306
  column_name: commands
  interval: 5
  singleuse: false

Comments

_ForgeUser15880441
- Join Date: 6/12/2014
- Posts: 1
- Member Details
#23 _ForgeUser15880441

View User Profile

Send Message

Posted Dec 31, 2014
Hi! I don't know why, when I run the server on my own computer, and I use XAMPP to database, it works. But when I upload to a hosting and I sign up to a mysql hosting...

Rollback Post to Revision RollBack
_ForgeUser3913259
- Join Date: 1/26/2010
- Posts: 16
- Member Details
#22 _ForgeUser3913259

View User Profile

Send Message

Posted Jan 9, 2014
Does'nt there exist a MySQL-writer?

Rollback Post to Revision RollBack
_ForgeUser8362408
- Join Date: 2/3/2012
- Posts: 2
- Member Details
#21 _ForgeUser8362408

View User Profile

Send Message

Posted May 16, 2013
i really like your plugin but can you please add that there didnt appear a message when it runs a task

Rollback Post to Revision RollBack
_ForgeUser9835700
- Join Date: 10/19/2012
- Posts: 17
- Member Details
#20 _ForgeUser9835700

View User Profile

Send Message

Posted Mar 23, 2013
I've brought out an update which should be approved soon. It's fixed in it.

Rollback Post to Revision RollBack
_ForgeUser10671245
- Join Date: 3/3/2013
- Posts: 5
- Member Details
#19 _ForgeUser10671245

View User Profile

Send Message

Posted Mar 14, 2013
This is cool plugin, but I have a problem: plugin don't remove a string from database after using a command. I tested with parameter "singleuse: false" and "singleuse: true". P.S. In my DB was a table with 3 columns, but after I made 1 column and got the same result: a string was not removed from DB...

Rollback Post to Revision RollBack
_ForgeUser10485286
- Join Date: 1/31/2013
- Posts: 0
- Member Details
#18 _ForgeUser10485286

View User Profile

Send Message

Posted Feb 1, 2013
12:23:27 [INFO] [MySQL-Reader] Running the task! Execution number: 2
12:23:27 [SEVERE] [MySQL-Reader] CAN'T EXECUTE QUERY! ERROR:
12:23:27 [SEVERE] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Tab
le 'bukkit.bukkit' doesn't exist
12:23:27 [SEVERE] at sun.reflect.NativeConstructorAccessorImpl.newInstance
0(Native Method)
12:23:27 [SEVERE] at sun.reflect.NativeConstructorAccessorImpl.newInstance
(Unknown Source)
12:23:27 [SEVERE] at sun.reflect.DelegatingConstructorAccessorImpl.newInst
ance(Unknown Source)
12:23:27 [SEVERE] at java.lang.reflect.Constructor.newInstance(Unknown Sou
rce)
12:23:27 [SEVERE] at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
12:23:27 [SEVERE] at com.mysql.jdbc.Util.getInstance(Util.java:382)
12:23:27 [SEVERE] at com.mysql.jdbc.SQLError.createSQLException(SQLError.j
ava:1052)
12:23:27 [SEVERE] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:
3593)
12:23:27 [SEVERE] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:
3525)
12:23:27 [SEVERE] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)

12:23:27 [SEVERE] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:21
40)
12:23:27 [SEVERE] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.
java:2620)
12:23:27 [SEVERE] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.
java:2570)
12:23:27 [SEVERE] at com.mysql.jdbc.StatementImpl.executeQuery(StatementIm
pl.java:1474)
12:23:27 [SEVERE] at de.mrpixeldream.mysqlreader.SQLConnector.query(SQLCon
nector.java:187)
12:23:27 [SEVERE] at de.mrpixeldream.mysqlreader.ExecutorTask.run(Executor
Task.java:67)
12:23:27 [SEVERE] at org.bukkit.craftbukkit.v1_4_6.scheduler.CraftTask.run
(CraftTask.java:53)
12:23:27 [SEVERE] at org.bukkit.craftbukkit.v1_4_6.scheduler.CraftSchedule
r.mainThreadHeartbeat(CraftScheduler.java:345)
12:23:27 [SEVERE] at net.minecraft.server.v1_4_6.MinecraftServer.r(Minecra
ftServer.java:530)
12:23:27 [SEVERE] at net.minecraft.server.v1_4_6.DedicatedServer.r(Dedicat
edServer.java:224)
12:23:27 [SEVERE] at net.minecraft.server.v1_4_6.MinecraftServer.q(Minecra
ftServer.java:494)
12:23:27 [SEVERE] at net.minecraft.server.v1_4_6.MinecraftServer.run(Minec
raftServer.java:427)
12:23:27 [SEVERE] at net.minecraft.server.v1_4_6.ThreadServerApplication.r
un(SourceFile:849)
12:23:27 [SEVERE] [MySQL-Reader] FEHLER IN DER MYSQL-KLASSE!

Rollback Post to Revision RollBack
_ForgeUser9835700
- Join Date: 10/19/2012
- Posts: 17
- Member Details
#17 _ForgeUser9835700

View User Profile

Send Message

Posted Jan 29, 2013
I'm working on it by now. Thanks for the report! Should be fixed in about one week.

Rollback Post to Revision RollBack

_ForgeUser8221212

Join Date: 1/8/2012
Posts: 3
Member Details

#16 Posted Jan 25, 2013

Heya bud! Having an issue trying to get the reader to even connect to my database. Here's the stack trace:

6:35:44 PM MySQL-Reader: Running the task! Execution number: 1
6:35:44 PM CONSOLE: [SEVERE] [MySQL-Reader] CAN'T EXECUTE QUERY! ERROR:
6:35:44 PM CONSOLE: [SEVERE] java.sql.SQLException: Can not issue data manipulation statements with executeQuery().
6:35:44 PM CONSOLE: [SEVERE] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
6:35:44 PM CONSOLE: [SEVERE] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
6:35:44 PM CONSOLE: [SEVERE] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
6:35:44 PM CONSOLE: [SEVERE] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
6:35:44 PM CONSOLE: [SEVERE] at com.mysql.jdbc.StatementImpl.checkForDml(StatementImpl.java:434)
6:35:44 PM CONSOLE: [SEVERE] at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1388)
6:35:44 PM CONSOLE: [SEVERE] at de.mrpixeldream.mysqlreader.SQLConnector.query(SQLConnector.java:187)
6:35:44 PM CONSOLE: [SEVERE] at de.mrpixeldream.mysqlreader.ExecutorTask.run(ExecutorTask.java:89)
6:35:44 PM CONSOLE: [SEVERE] at org.bukkit.craftbukkit.v1_4_R1.scheduler.CraftTask.run(CraftTask.java:53)
6:35:44 PM CONSOLE: [SEVERE] at org.bukkit.craftbukkit.v1_4_R1.scheduler.CraftScheduler.mainThreadHeartbeat(CraftScheduler.java:345)
6:35:44 PM CONSOLE: [SEVERE] at net.minecraft.server.v1_4_R1.MinecraftServer.r(MinecraftServer.java:530)
6:35:44 PM CONSOLE: [SEVERE] at net.minecraft.server.v1_4_R1.DedicatedServer.r(DedicatedServer.java:224)
6:35:44 PM CONSOLE: [SEVERE] at net.minecraft.server.v1_4_R1.MinecraftServer.q(MinecraftServer.java:494)
6:35:44 PM CONSOLE: [SEVERE] at net.minecraft.server.v1_4_R1.MinecraftServer.run(MinecraftServer.java:427)
6:35:44 PM CONSOLE: [SEVERE] at net.minecraft.server.v1_4_R1.ThreadServerApplication.run(SourceFile:849)

After doing some searching, it looks like you're trying to use executeQuery when you should be using executeUpdate. I'm not savvy in that field; that's just what I read.

Anyhow, any chance you could get an update going? We have a Minecraft community that uses this and we're in need of a fix! :D

Thanks bud.

_ForgeUser9835700
- Join Date: 10/19/2012
- Posts: 17
- Member Details
#15 _ForgeUser9835700

View User Profile

Send Message

Posted Jan 20, 2013
I closed the connection before the plugin had finished the task. Update is out, sorry for that.

Rollback Post to Revision RollBack
_ForgeUser7244533
- Join Date: 7/22/2011
- Posts: 20
- Member Details
#14 _ForgeUser7244533

View User Profile

Send Message

Posted Jan 10, 2013
Also can you please add a posibility to set interval in seconds?

Rollback Post to Revision RollBack

_ForgeUser7244533

Join Date: 7/22/2011
Posts: 20
Member Details

#13 Posted Jan 10, 2013

Doesn't work for me. Any thoughts?

13:04:34 [INFO] [MySQL-Reader] Running the task! Execution number: 1
13:04:35 [SEVERE] java.sql.SQLException: Operation not allowed after ResultSet closed
13:04:35 [SEVERE] 	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
13:04:35 [SEVERE] 	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
13:04:35 [SEVERE] 	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
13:04:35 [SEVERE] 	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
13:04:35 [SEVERE] 	at com.mysql.jdbc.ResultSetImpl.checkClosed(ResultSetImpl.java:794)
13:04:35 [SEVERE] 	at com.mysql.jdbc.ResultSetImpl.next(ResultSetImpl.java:7145)
13:04:35 [SEVERE] 	at de.mrpixeldream.mysqlreader.ExecutorTask.run(ExecutorTask.java:82)
13:04:35 [SEVERE] 	at org.bukkit.craftbukkit.v1_4_6.scheduler.CraftTask.run(CraftTask.java:53)
13:04:35 [SEVERE] 	at org.bukkit.craftbukkit.v1_4_6.scheduler.CraftScheduler.mainThreadHeartbeat(CraftScheduler.java:345)
13:04:35 [SEVERE] 	at net.minecraft.server.v1_4_6.MinecraftServer.r(MinecraftServer.java:517)
13:04:35 [SEVERE] 	at net.minecraft.server.v1_4_6.DedicatedServer.r(DedicatedServer.java:224)
13:04:35 [SEVERE] 	at net.minecraft.server.v1_4_6.MinecraftServer.q(MinecraftServer.java:481)
13:04:35 [SEVERE] 	at net.minecraft.server.v1_4_6.MinecraftServer.run(MinecraftServer.java:416)
13:04:35 [SEVERE] 	at net.minecraft.server.v1_4_6.ThreadServerApplication.run(SourceFile:849)

_ForgeUser9835700
- Join Date: 10/19/2012
- Posts: 17
- Member Details
#12 _ForgeUser9835700

View User Profile

Send Message

Posted Dec 10, 2012
Working on it. I thought that I maybe should add an configuration option to only execute the commands once. But you can put more than one command in you database.

Rollback Post to Revision RollBack
_ForgeUser9970302
- Join Date: 11/12/2012
- Posts: 22
- Member Details
#11 _ForgeUser9970302

View User Profile

Send Message

Posted Dec 9, 2012
Can you make it so that it doesn't execute the same command, only when it changes?

Rollback Post to Revision RollBack
_ForgeUser9970302
- Join Date: 11/12/2012
- Posts: 22
- Member Details
#10 _ForgeUser9970302

View User Profile

Send Message

Posted Dec 2, 2012
Hello, I really need a bukit plugin so I want to pay for it. This plugin looks alot like it, maybe you can make it! Please look at this video for more information http://www.youtube.com/watch?v=kNllPaLsbCY Thanks, Koen

Rollback Post to Revision RollBack
_ForgeUser9835700
- Join Date: 10/19/2012
- Posts: 17
- Member Details
#9 _ForgeUser9835700

View User Profile

Send Message

Posted Nov 27, 2012
To you first remark: It was my goal to let the server repeat them but i'll add a configuration option to change this. Second thing: that's strange. I'll check this and make an update if possible!

Thank you!

Rollback Post to Revision RollBack
_ForgeUser7078306
- Join Date: 6/27/2011
- Posts: 5
- Member Details
#8 _ForgeUser7078306

View User Profile

Send Message

Posted Nov 27, 2012
Also I think their may be an issue with the connections closing properly. AFter running this plugin overnight my mysql server hit the max open connections threshold and nothing more could connect to my database. This is the only time this has ever happened on our server.

Rollback Post to Revision RollBack
_ForgeUser7078306
- Join Date: 6/27/2011
- Posts: 5
- Member Details
#7 _ForgeUser7078306

View User Profile

Send Message

Posted Nov 25, 2012
Could you add an option to mark a command as completed in some way. Either have it delete that row in the table or add another column that flags it as completed. The server just keeps running the same commands over and over. Or am I missing something?

Last edited by _ForgeUser7078306: Nov 25, 2012

Rollback Post to Revision RollBack
_ForgeUser9835700
- Join Date: 10/19/2012
- Posts: 17
- Member Details
#6 _ForgeUser9835700

View User Profile

Send Message

Posted Nov 21, 2012
It should work for it. If not, please let me know the exception which occurred.

Rollback Post to Revision RollBack
_ForgeUser8329234
- Join Date: 1/28/2012
- Posts: 18
- Member Details
#5 _ForgeUser8329234

View User Profile

Send Message

Posted Nov 18, 2012
Update pls 1.4.4

Last edited by _ForgeUser8329234: Nov 18, 2012

Rollback Post to Revision RollBack
_ForgeUser9835700
- Join Date: 10/19/2012
- Posts: 17
- Member Details
#4 _ForgeUser9835700

View User Profile

Send Message

Posted Nov 8, 2012
Next version released and approved! Have fun and suggest some features if you like to!

Rollback Post to Revision RollBack
To post a comment, please login or register a new account.

Project ID

46811
Created

Nov 3, 2012
Last Released File

Mar 23, 2013
Total Downloads

4,907
License

GNU General Public License ver...

Bukkit

Bukkit MySQL-Reader

Bukkit Plugins