I think my PhpMyAdmin is dead... It seems that your plugin killed it because I never see this error... As soon as I run a command on my site, SQL panel has crashed There is no more wired logs, all other are known before. timtower EDIT by Moderator: merged posts, please use the edit button instead of double posting.
To175 1. Please don't double post, use the edit button instead. 2. That wasn't the complete error, this is: Spoiler (Move your mouse to the spoiler area to reveal the content) Show Spoiler Hide Spoiler Code: The last packet successfully received from the server was 47 milliseconds ago. The last packet sent successfully to the server was 14 milliseconds ago. [22:10:43 WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) [22:10:43 WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) [22:10:43 WARN]: at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) [22:10:43 WARN]: at java.lang.reflect.Constructor.newInstance(Unknown Source) [22:10:43 WARN]: at com.mysql.jdbc.Util.handleNewInstance(Util.java:407) [22:10:43 WARN]: at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116) [22:10:43 WARN]: at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3082) [22:10:43 WARN]: at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2968) [22:10:43 WARN]: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3516) [22:10:43 WARN]: at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986) [22:10:43 WARN]: at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140) [22:10:43 WARN]: at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620) [22:10:43 WARN]: at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1662) [22:10:43 WARN]: at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1581) [22:10:43 WARN]: at nl.timdebrouwer.webcommand.WebCommand.remove(WebCommand.java:68) [22:10:43 WARN]: at nl.timdebrouwer.webcommand.WebCommand.check(WebCommand.java:114) [22:10:43 WARN]: at nl.timdebrouwer.webcommand.Runner.run(Runner.java:15) [22:10:43 WARN]: at org.bukkit.craftbukkit.v1_7_R1.scheduler.CraftTask.run(CraftTask.java:53) [22:10:43 WARN]: at org.bukkit.craftbukkit.v1_7_R1.scheduler.CraftAsyncTask.run(CraftAsyncTask.java:53) [22:10:43 WARN]: at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [22:10:43 WARN]: at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [22:10:43 WARN]: at java.lang.Thread.run(Unknown Source) [22:10:43 WARN]: Caused by: java.net.SocketException: socket closed [22:10:43 WARN]: at java.net.SocketInputStream.socketRead0(Native Method) [22:10:43 WARN]: at java.net.SocketInputStream.read(Unknown Source) [22:10:43 WARN]: at java.net.SocketInputStream.read(Unknown Source) [22:10:43 WARN]: at com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:114) [22:10:43 WARN]: at com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:161) [22:10:43 WARN]: at com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:189) [22:10:43 WARN]: at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2526) [22:10:43 WARN]: at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2979) [22:10:43 WARN]: ... 15 more [22:10:43 WARN]: java.sql.SQLException: Operation not allowed after ResultSet closed [22:10:43 WARN]: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073) [22:10:43 WARN]: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987) [22:10:43 WARN]: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982) [22:10:43 WARN]: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927) [22:10:43 WARN]: at com.mysql.jdbc.ResultSetImpl.checkClosed(ResultSetImpl.java:794) [22:10:43 WARN]: at com.mysql.jdbc.ResultSetImpl.next(ResultSetImpl.java:7145) [22:10:43 WARN]: at nl.timdebrouwer.webcommand.WebCommand.check(WebCommand.java:110) [22:10:43 WARN]: at nl.timdebrouwer.webcommand.Runner.run(Runner.java:15) [22:10:43 WARN]: at org.bukkit.craftbukkit.v1_7_R1.scheduler.CraftTask.run(CraftTask.java:53) [22:10:43 WARN]: at org.bukkit.craftbukkit.v1_7_R1.scheduler.CraftAsyncTask.run(CraftAsyncTask.java:53) [22:10:43 WARN]: at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [22:10:43 WARN]: at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [22:10:43 WARN]: at java.lang.Thread.run(Unknown Source) https://www.dropbox.com/s/kpbz72uvs67ochy/WebCommand.jar
Ok thanks, Can you had something please to do features ? Or maybe I can ask someone else to do more config ? Thanks you very much for the plugin
@timetower No that was just that • Reload command /ws reload • /ws receive command <something> to read the database now ! Row : "id" and "command". • /ws send code <something> and this line is not read by the plugin, just inserted. And add the "player" which did it ! Thanks
To175 1. Reload is kinda impossible as it disables itself when not fully configured. And then you also edit the time I think. 2. Doable. 3. I can't tell the plugin to stop reading certain messages
timtower Ok thanks. Can you make something like this ?? => WHERE player!=0 ?? Like that the row that I create with website has empty "player" and is not read ? No ? Thanks
Minestats can do this, plus (i believe) its still free. Minestats went inactive a few months back but it been started up again and currently in beta. http://dev.bukkit.org/bukkit-plugins/minestats/
To175 https://www.dropbox.com/s/kpbz72uvs67ochy/WebCommand.jar Code: commands: WebCommand: permission: webcommand.use permission-message: You dont have permission to use this permissions: webcommand.use: default: false Command usage: /webcommand = checks the database /webcommand <args> = puts the row in the database
To175 Minestats doesn't use a local webserver. The Plugin Checks the Minestats web-server (that serves the data to the plugin)
timtower thanks youu ! So you can't do "WHERE ..." ? in the request ? EDIT : And can you add permission to do the command /websend and NOT /websend <arg> Goblom I don't understand what do you say sorry
I added the where stuff. And will add the permission when i have time for it and feel like adding stuff
timtower So, I spoke about 2 differents "WHERE" : • one to check database with user x if to175 do /websend it will check all row where player=to175 • the other to check every x seconds (like I configured it) where player != ' ' like that it will not run the command if the colum is empty !
You just said the same thing twice in my opinion. First you said that you wanted an extra column that if it wasnt empty then it wouldn't check it. Now you say the opposit of that. I won't modify the command to work per player, just don't like it, command is still running from console so you won't have any gain with it. You got a check command, you got a command to input lines. I am done with this.
timtower I think I understood thanks ! timtower So if I have this : • || id:1 | command:something | player:to175 || it will be NOT be red But if I do that : • || id:1 | command:say something | player: || it will be red ?! Ho yes I rember what I needed that for => Did you do something to add a row with the name of the player(!) ? /websend <command> Thanks EDIT by Moderator: merged posts, please use the edit button instead of double posting.
timtower To drop ? to drop where ? I have these errors but mysql works on my website ! Yes I need that plugin read the database where player==' ' Like that is player do /websend <arg> his name is recorded in "player" ! Thanks
Don't really think that this is even worth creating a project for, and if somebody does it than it would be me
timtower ha d'accord timtower the plugin doesn't check anymore the database... EDIT by Moderator: merged posts, please use the edit button instead of double posting.