Spigot MySQL Reports 1.6

This plugin allows players to report other players, and uses a MySQL or SQLite database.

  1. HeyMan7 submitted a new resource:

    [1.8.*-1.9.*] Reports - This plugin allows players to report other players.

    Read more about this resource...
     
  2. Suggestions time!
    1. A FlatFile database file that it can save to for people who don't want to setup a MySQL Database
    2. More config options! Being able to change the colors of reports so its not a Silver/Red
    More suggestions will come as i think of them! Overall, Great plugin keep up the hard work HeyMan!

    Also question, Are you able to view closed reports?
     
  3. Yes. All planned features. Thanks for the suggestions. I'll add viewing of closed reports in the future. For now you can just see what number is missing in viewall.
     
  4. You should add a sub command for /report delete add a sub /report del!
     
  5. No, just a suggestion to have constant support for 1.8. Having the no MySQL would be awesome but.
     
  6. Ah, yeah, I don't plan on removing 1.8 support.
     
    • Like Like x 1
  7. HeyMan7 updated [1.8-1.9] Reports with a new update entry:

    Version 1.3

    Read the rest of this update entry...
     
    • Like Like x 1
  8. HeyMan7 updated MySQL Reports with a new update entry:

    Another minor update

    Read the rest of this update entry...
     
  9. Update to 1.10 plz.
     
  10. Code (Text):
    21.08 04:29:58 [Server] INFO ToastJambon issued server command: /reports view toastjr
    21.08 04:29:58 [Server] WARN java.lang.NullPointerException
    21.08 04:29:58 [Server] WARN at space.heyman.Reports.onCommand(Reports.java:260)
    21.08 04:29:58 [Server] WARN at org.bukkit.command.PluginCommand.execute(PluginCommand.java:44)
    21.08 04:29:58 [Server] WARN at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:141)
    21.08 04:29:58 [Server] WARN at org.bukkit.craftbukkit.v1_8_R3.CraftServer.dispatchCommand(CraftServer.java:641)
    21.08 04:29:58 [Server] WARN at net.minecraft.server.v1_8_R3.PlayerConnection.handleCommand(PlayerConnection.java:1162)
    21.08 04:29:58 [Server] WARN at net.minecraft.server.v1_8_R3.PlayerConnection.a(PlayerConnection.java:997)
    21.08 04:29:58 [Server] WARN at net.minecraft.server.v1_8_R3.PacketPlayInChat.a(PacketPlayInChat.java:45)
    21.08 04:29:58 [Server] WARN at net.minecraft.server.v1_8_R3.PacketPlayInChat.a(PacketPlayInChat.java:1)
    21.08 04:29:58 [Server] WARN at net.minecraft.server.v1_8_R3.PlayerConnectionUtils$1.run(SourceFile:13)
    21.08 04:29:58 [Server] WARN at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
    21.08 04:29:58 [Server] WARN at java.util.concurrent.FutureTask.run(FutureTask.java:266)
    21.08 04:29:58 [Server] WARN at net.minecraft.server.v1_8_R3.SystemUtils.a(SourceFile:44)
    21.08 04:29:58 [Server] WARN at net.minecraft.server.v1_8_R3.MinecraftServer.B(MinecraftServer.java:715)
    21.08 04:29:58 [Server] WARN at net.minecraft.server.v1_8_R3.DedicatedServer.B(DedicatedServer.java:374)
    21.08 04:29:58 [Server] WARN at net.minecraft.server.v1_8_R3.MinecraftServer.A(MinecraftServer.java:654)
    21.08 04:29:58 [Server] WARN at net.minecraft.server.v1_8_R3.MinecraftServer.run(MinecraftServer.java:557)
    21.08 04:29:58 [Server] WARN at java.lang.Thread.run(Thread.java:745)
     
  11. @JonathanV What version of the plugin are you using? If you're not using a MySQL database make sure mysql: is set to false, by default it is set to true.
     
  12. Zuerst hatte ich das Plugin und alles war gut , es ist zudem gut gecooded.
     
  13. Ich würde mir wünschen, dass man die einzelenen Report Messages besser einstellen kann.
    Beispiel:

    Report_Message:
    - '----------------------------------'
    -'&4Spieler &6xxx &4hat &axxx &6wegen &exxx &4reportet
    '--------------------'
    sowas in der art
     
  14. [17:42:35 INFO]: [Reports] Enabling Reports v1.6
    [17:42:35 ERROR]: [Reports] Error creating the reports SQL tables!
    [17:42:35 WARN]: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-reports.Reports(`ID` INT(8) NOT NULL AUTO_INCREMENT, `ReportedUUID` VARCHAR(45)' at line 1
    [17:42:35 WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    [17:42:35 WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    [17:42:35 WARN]: at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    [17:42:35 WARN]: at java.lang.reflect.Constructor.newInstance(Unknown Source)
    [17:42:35 WARN]: at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    [17:42:35 WARN]: at com.mysql.jdbc.Util.getInstance(Util.java:382)
    [17:42:35 WARN]: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
    [17:42:35 WARN]: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
    [17:42:35 WARN]: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
    [17:42:35 WARN]: at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
    [17:42:35 WARN]: at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
    [17:42:35 WARN]: at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626)
    [17:42:35 WARN]: at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2111)
    [17:42:35 WARN]: at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2407)
    [17:42:35 WARN]: at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2325)
    [17:42:35 WARN]: at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2310)
    [17:42:35 WARN]: at space.heyman.MySQL.formatReportsDatabase(MySQL.java:96)
    [17:42:35 WARN]: at space.heyman.MySQL.setupReports(MySQL.java:66)
    [17:42:35 WARN]: at space.heyman.Main.onEnable(Main.java:18)
    [17:42:35 WARN]: at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:321)
    [17:42:35 WARN]: at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:340)
    [17:42:35 WARN]: at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:405)
    [17:42:35 WARN]: at com.rylinaux.plugman.util.PluginUtil.load(PluginUtil.java:285)
    [17:42:35 WARN]: at com.rylinaux.plugman.util.PluginUtil.load(PluginUtil.java:238)
    [17:42:35 WARN]: at com.rylinaux.plugman.util.PluginUtil.reload(PluginUtil.java:299)
    [17:42:35 WARN]: at com.rylinaux.plugman.command.ReloadCommand.execute(ReloadCommand.java:122)
    [17:42:35 WARN]: at com.rylinaux.plugman.PlugManCommandHandler.onCommand(PlugManCommandHandler.java:104)
    [17:42:35 WARN]: at org.bukkit.command.PluginCommand.execute(PluginCommand.java:44)
    [17:42:35 WARN]: at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:141)
    [17:42:35 WARN]: at org.bukkit.craftbukkit.v1_8_R3.CraftServer.dispatchCommand(CraftServer.java:641)
    [17:42:35 WARN]: at org.bukkit.craftbukkit.v1_8_R3.CraftServer.dispatchServerCommand(CraftServer.java:627)
    [17:42:35 WARN]: at net.minecraft.server.v1_8_R3.DedicatedServer.aO(DedicatedServer.java:412)
    [17:42:35 WARN]: at net.minecraft.server.v1_8_R3.DedicatedServer.B(DedicatedServer.java:375)
    [17:42:35 WARN]: at net.minecraft.server.v1_8_R3.MinecraftServer.A(MinecraftServer.java:654)
    [17:42:35 WARN]: at net.minecraft.server.v1_8_R3.MinecraftServer.run(MinecraftServer.java:557)
    [17:42:35 WARN]: at java.lang.Thread.run(Unknown Source)
    [17:42:35 INFO]: [Reports] Connection to the MySQL successful!


    What its happening?