[ADMN] ModTRS v2.1 - Moderator Ticket Request System [1240]

Discussion in 'Inactive/Unsupported Plugins' started by Yetanotherx, Apr 4, 2011.

  1. Offline


    It's /check-id #. Never the less, it will no longer throw an error in future versions.

    It's /check t:closed.

    I have released version 1.1. This update brings loads of new features, and if you have auto_update on in your config, it will automatically download.

    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
    Last edited by a moderator: May 13, 2016
  2. Offline


    If there could be a cooldown time for how often people can submit, that'd be good
    Also if admins can /mod ban people to prevent them from using /modreq, that'd be good too.
  3. Offline


    A cooldown time seems doable. I'll put that in the TODO for the next version. Not sure about the banning. If someone is abusing the mod request plugin, I would kick/ban them. However, I do see the benefits of having a banlist. I'll consider the idea.
  4. Offline


    Has anyone implemented a web interface for this plugin yet? If not, I'll work on one.
  5. Offline


    I love it! Thank you very much :)
    btw, submit the to-do list, so if we want to suggest an idea, we can make sure we don't suggest the same one.
  6. Offline


    No, no one has yet. The SQLite structure is very simple, so if you want to do it, it's very easy!

    The todo list is the bug tracker on Github.

    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
    Last edited by a moderator: May 13, 2016
  7. Offline


    Sounds good. I'll get started and let you guys know what I come up with, if anyone's interested.
  8. Offline


    Hey there! I am very interested in this plugin. However I do request a few features.
    An ability to warp to where the ticket was submitted [the scene of the crime].
    MySQL support [I know you plan on adding this, just want to stress it]
    I'm not sure that closed tickets are erased from the database but maybe an auto deleter after x time?
    This one looks much easier to use than Petition.
  9. Offline


    • If you use Essentials, you can teleport to the coordinates using /tppos.
    • MySQL support is coming in a future version, as I've said. It's a slow process, as I based half my code around a specific database file (stupidly).
    • I hate to delete files, so I didn't implement this naturally. However, you can set up a cronjob or a batch script to automatically delete/rename the database file after a set amount of time and that'd do the job.

    Thanks for the feedback! Great to hear that people are interested; I wrote this with the intention of filling a void that no one had filled.
  10. Offline


    Just a quick notice, MySQL support is definitely coming in the next version. I've completely rewritten the SQL framework from the bottom up, and is no longer SQLite-based.

    Version 1.2 has been released. The main feature is MySQL support. You have to create the database; ModTRS does not do that yet.

    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
    Last edited by a moderator: May 13, 2016
  11. Offline


    Request: Support so admins could translate messages for their own players language
  12. Offline


    Think you can make it so moderators can reply to the tickets
  13. Offline


    Running this on CB 733 with mysql.
    2011-04-27 01:10:35 [SEVERE] com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value adjusted for column 'request_z' at row 1
    2011-04-27 01:10:35 [SEVERE]     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3591)
    2011-04-27 01:10:35 [SEVERE]     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
    2011-04-27 01:10:35 [SEVERE]     at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
    2011-04-27 01:10:35 [SEVERE]     at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
    2011-04-27 01:10:35 [SEVERE]     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626)
    2011-04-27 01:10:35 [SEVERE]     at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2111)
    2011-04-27 01:10:35 [SEVERE]     at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1362)
    2011-04-27 01:10:35 [SEVERE]     at yetanotherx.bukkitplugin.ModTRS.sql.ModTRSRequest.insert(ModTRSRequest.java:124)
    2011-04-27 01:10:35 [SEVERE]     at yetanotherx.bukkitplugin.ModTRS.command.ModreqCommand.onCommand(ModreqCommand.java:70)
    2011-04-27 01:10:35 [SEVERE]     at yetanotherx.bukkitplugin.ModTRS.command.CommandHandler.onCommand(CommandHandler.java:106)
    2011-04-27 01:10:35 [SEVERE]     at yetanotherx.bukkitplugin.ModTRS.ModTRS.onCommand(ModTRS.java:160)
    2011-04-27 01:10:35 [SEVERE]     at org.bukkit.command.PluginCommand.execute(PluginCommand.java:35)
    2011-04-27 01:10:35 [SEVERE]     at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:85)
    2011-04-27 01:10:35 [SEVERE]     at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:255)
    2011-04-27 01:10:35 [SEVERE]     at net.minecraft.server.NetServerHandler.handleCommand(NetServerHandler.java:675)
    2011-04-27 01:10:35 [SEVERE]     at net.minecraft.server.NetServerHandler.chat(NetServerHandler.java:638)
    2011-04-27 01:10:35 [SEVERE]     at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:632)
    2011-04-27 01:10:35 [SEVERE]     at net.minecraft.server.Packet3Chat.a(Packet3Chat.java:32)
    2011-04-27 01:10:35 [SEVERE]     at net.minecraft.server.NetworkManager.a(NetworkManager.java:195)
    2011-04-27 01:10:35 [SEVERE]     at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:74)
    2011-04-27 01:10:35 [SEVERE]     at net.minecraft.server.NetworkListenThread.a(SourceFile:100)
    2011-04-27 01:10:35 [SEVERE]     at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:370)
    2011-04-27 01:10:35 [SEVERE]     at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:285)
    2011-04-27 01:10:35 [SEVERE]     at net.minecraft.server.ThreadServerApplication.run(SourceFile:394)
    and my config

        databases: {}
        blacklist: []
        notify_mods: true
        autoupdate: true
        debug: true
            port: '3306'
            server: 'localhost'
            type: mysql
            user: 'minecraft'
            database: modtrs
            pass: 'minecraft22'
    There is little documentation about how to format the mysql values. [ie. use apostrophes or not] So maybe an example would be good :D
  14. Offline


    First of all, change your mysql password.
    Second of all, I've seen this bug, and will try to get it fixed in the next version. Until then, use SQLite.
  15. Offline


  16. Offline

    funky man

    Wondering if anyone can help,
    I had modTRS running fine with no problems, but installed and config'd logblock this morning and since then i now get an internal error for all modTRS commands .

    Not sure if this helps (i'm a noob if you havn't guessed lol)

    Caused by: java.lang.NoClassDefFoundError: yetanotherx/bukkitplugin/ModTRS/command/CommandHandler
    at yetanotherx.bukkitplugin.ModTRS.ModTRS.onCommand(ModTRS.java:160)
    at org.bukkit.command.PluginCommand.execute(PluginCommand.java:35)
    ... 12 more
    Caused by: java.lang.ClassNotFoundException: yetanotherx.bukkitplugin.ModTRS.command.CommandHandler
    at java.net.URLClassLoader$1.run(Unknown Source)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.net.URLClassLoader.findClass(Unknown Source)
    at org.bukkit.plugin.java.PluginClassLoader.findClass(PluginClassLoader.java:36)
    at org.bukkit.plugin.java.PluginClassLoader.findClass(PluginClassLoader.java:24)
    at java.lang.ClassLoader.loadClass(Unknown Source)
    at java.lang.ClassLoader.loadClass(Unknown Source)
    ... 14 more
  17. Offline


    That's really confusing..... That shouldn't be happening. Try re-downloading the ModTRS and LogBlock jars. I'm running both LogBlock and ModTRS on 3 of the 5 servers I run, and I've got no issues.
  18. Offline


    I just installed ModTRS and decided to use MySQL. ModTRS created the request and user tables successfully but I can't use the /modreq command. Maybe the data value type isn't correct for the request_x column? Here's the error I receive when using /modreq and my config below it:

    2011-04-30 12:16:59 [INFO] modreq test
    2011-04-30 12:16:59 [SEVERE] com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value for column 'request_x' at row 1
    2011-04-30 12:16:59 [SEVERE]     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3591)
    2011-04-30 12:16:59 [SEVERE]     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
    2011-04-30 12:16:59 [SEVERE]     at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
    2011-04-30 12:16:59 [SEVERE]     at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
    2011-04-30 12:16:59 [SEVERE]     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626)
    2011-04-30 12:16:59 [SEVERE]     at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2111)
    2011-04-30 12:16:59 [SEVERE]     at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1362)
    2011-04-30 12:16:59 [SEVERE]     at yetanotherx.bukkitplugin.ModTRS.sql.ModTRSRequest.insert(ModTRSRequest.java:124)
    2011-04-30 12:16:59 [SEVERE]     at yetanotherx.bukkitplugin.ModTRS.command.ModreqCommand.onCommand(ModreqCommand.java:70)
    2011-04-30 12:16:59 [SEVERE]     at yetanotherx.bukkitplugin.ModTRS.command.CommandHandler.onCommand(CommandHandler.java:113)
    2011-04-30 12:16:59 [SEVERE]     at yetanotherx.bukkitplugin.ModTRS.ModTRS.onCommand(ModTRS.java:160)
    2011-04-30 12:16:59 [SEVERE]     at org.bukkit.command.PluginCommand.execute(PluginCommand.java:35)
    2011-04-30 12:16:59 [SEVERE]     at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:85)
    2011-04-30 12:16:59 [SEVERE]     at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:255)
    2011-04-30 12:16:59 [SEVERE]     at net.minecraft.server.NetServerHandler.handleCommand(NetServerHandler.java:677)
    2011-04-30 12:16:59 [SEVERE]     at net.minecraft.server.NetServerHandler.chat(NetServerHandler.java:640)
    2011-04-30 12:16:59 [SEVERE]     at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:634)
    2011-04-30 12:16:59 [SEVERE]     at net.minecraft.server.Packet3Chat.a(Packet3Chat.java:32)
    2011-04-30 12:16:59 [SEVERE]     at net.minecraft.server.NetworkManager.a(NetworkManager.java:195)
    2011-04-30 12:16:59 [SEVERE]     at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:74)
    2011-04-30 12:16:59 [SEVERE]     at net.minecraft.server.NetworkListenThread.a(SourceFile:100)
    2011-04-30 12:16:59 [SEVERE]     at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:370)
    2011-04-30 12:16:59 [SEVERE]     at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:285)
    2011-04-30 12:16:59 [SEVERE]     at net.minecraft.server.ThreadServerApplication.run(SourceFile:394)
        databases: {}
        blacklist: []
        notify_mods: true
        log_commands: false
        autoupdate: true
        debug: false
            port: '3306'
            server: localhost
            type: mysql
            user: minecraft
            database: tickets
            pass: minecraft
    And yes I know the user/pass is simple, but this isn't confidential data nor can you connect to the MySQL db externally as well as the user is restricted to localhost only.

    Thanks for the GREAT plugin!!!
  19. Offline


    MySQL support has a few bugs in it. They SHOULD be fixed in the next version. Until then, use SQLite. (change type: sqlite and database: plugins/ModTRS/modtrs.db)
  20. Offline


    Great Plugin!
    But i like to see the mysql fixxed :S And some bug fixxes in:
    (Suggestion) When you claim somethings request: Example: /claim 1, the player gets a message "Moderator DurtyFree is now handle your request" (Or something like that)
    (Suggestion) When you type /done ID a message to all Moderators "Moderator DurtyFree completed request ID"
    (Suggestion) A shortcut for Mod Broadcast, something like /modb or /mb ...
    (Bug) When you do /claim ID and then /done ID and again /unclaim LastReqID the last request ist unclaim and undone, you must type again /done ID.
    (Bug) More than 2 Admins can claim a request, makes no sense.
    (Bug) You can type multiple times /done ID, /done SameID, /done SameID
    (Bug) You can reopen a request who is already open...
    (Bug) You can unclaim a request what you doesnt claim...

  21. Offline


    Great to hear feedback! All of those are coming in the next version. The code is written, just needs to send the messages.
  22. Offline

    funky man

    Thanks for the advice but still getting an internal error even though I uninstalled both and put modTRS on on its own and still getting an internal error :/

    2011-05-01 01:33:59 [SEVERE] null org.bukkit.command.CommandException: Unhandled exception executing command 'modreq' in plugin ModTRS v1.2
        at org.bukkit.command.PluginCommand.execute(PluginCommand.java:37)
        at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:85)
        at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:255)
        at net.minecraft.server.NetServerHandler.handleCommand(NetServerHandler.java:675)
        at net.minecraft.server.NetServerHandler.chat(NetServerHandler.java:638)
        at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:632)
        at net.minecraft.server.Packet3Chat.a(Packet3Chat.java:32)
        at net.minecraft.server.NetworkManager.a(NetworkManager.java:195)
        at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:74)
        at net.minecraft.server.NetworkListenThread.a(SourceFile:100)
        at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:370)
        at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:285)
        at net.minecraft.server.ThreadServerApplication.run(SourceFile:394)
    Caused by: java.lang.NoClassDefFoundError: yetanotherx/bukkitplugin/ModTRS/command/CommandHandler
  23. Offline


    If you unzip the JAR file, do you have a yetanotherx/bukkitplugin/ModTRS/command folder?
  24. Offline


    Hey, I love your plugin, had it working fine with 1.2, but now I've updated to 1.3 it doesn't seem to be loading and I'm getting the following error...

    Could not load 'plugins/ModTRS.jar' in folder 'plugins':
    java.util.zip.ZipException: error in opening zip file
        at java.util.zip.ZipFile.open(Native Method)
        at java.util.zip.ZipFile.<init>(ZipFile.java:131)
        at java.util.jar.JarFile.<init>(JarFile.java:150)
        at java.util.jar.JarFile.<init>(JarFile.java:114)
        at org.bukkit.plugin.java.JavaPluginLoader.loadPlugin(JavaPluginLoader.java:55)
        at org.bukkit.plugin.SimplePluginManager.loadPlugin(SimplePluginManager.java:160)
        at org.bukkit.plugin.SimplePluginManager.loadPlugins(SimplePluginManager.java:108)
        at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:85)
        at net.minecraft.server.MinecraftServer.e(MinecraftServer.java:217)
        at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:204)
        at net.minecraft.server.MinecraftServer.init(MinecraftServer.java:144)
        at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:259)
        at net.minecraft.server.ThreadServerApplication.run(SourceFile:394)
    It would appear i'm doing something wrong, but for the life of me I don't know...any ideas?

  25. Offline


    Try redownloading it.

  26. Offline

    Jonathan Bloom

    Will this let people know when they come online that their request hasa been fulfilled?
  27. Could you please add a visible online cue for tickets?

    Either color player names differently for online/offline, or add (online/offline) behind their name. Something like that, it's problematic having to /seen Name for each player's ticket.

    Alternatively make a listing commands for online players' tickets only.

  28. Offline


    Yeah, seems to be ok now :D [cake]
  29. Offline


    First, thanks for this great plugin.

    Once I get it working on MySQL it will be great (I can't stand sqlite).

    I get this error when trying /modreq <message> with MySQL:

    10:16:59 [SEVERE] com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value for column 'request_x' at row 1
    10:16:59 [SEVERE] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3591)
    10:16:59 [SEVERE] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
    10:16:59 [SEVERE] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
    10:16:59 [SEVERE] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
    10:16:59 [SEVERE] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626)
    10:16:59 [SEVERE] at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2111)
    10:16:59 [SEVERE] at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1362)
    10:16:59 [SEVERE] at yetanotherx.bukkitplugin.ModTRS.sql.ModTRSRequest.insert(ModTRSRequest.java:124)
    10:16:59 [SEVERE] at yetanotherx.bukkitplugin.ModTRS.command.ModreqCommand.onCommand(ModreqCommand.java:70)
    10:16:59 [SEVERE] at yetanotherx.bukkitplugin.ModTRS.command.CommandHandler.onCommand(CommandHandler.java:113)
    10:16:59 [SEVERE] at yetanotherx.bukkitplugin.ModTRS.ModTRS.onCommand(ModTRS.java:160)
    10:16:59 [SEVERE] at org.bukkit.command.PluginCommand.execute(PluginCommand.java:35)
    10:16:59 [SEVERE] at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:85)
    10:16:59 [SEVERE] at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:255)
    10:16:59 [SEVERE] at net.minecraft.server.NetServerHandler.handleCommand(NetServerHandler.java:677)
    10:16:59 [SEVERE] at net.minecraft.server.NetServerHandler.chat(NetServerHandler.java:640)
    10:16:59 [SEVERE] at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:634)
    10:16:59 [SEVERE] at net.minecraft.server.Packet3Chat.a(Packet3Chat.java:32)
    10:16:59 [SEVERE] at net.minecraft.server.NetworkManager.a(NetworkManager.java:195)
    10:16:59 [SEVERE] at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:74)
    10:16:59 [SEVERE] at net.minecraft.server.NetworkListenThread.a(SourceFile:100)
    10:16:59 [SEVERE] at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:370)
    10:16:59 [SEVERE] at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:285)
    10:16:59 [SEVERE] at net.minecraft.server.ThreadServerApplication.run(SourceFile:394)

    Also just a suggestion. I love that you have included the command /mod-broadcast.

    I however think this command is just a little to long type type. Think about typing that out like 7 times just to chat with other mods. Might I make a suggestion that you shorten it up to /ms? /ms = /modshout

    My config file below just incase: Password has been erased for security reasons.

    databases: {}
    blacklist: []
    notify_mods: true
    log_commands: false
    autoupdate: true
    debug: false
    port: '3306'
    server: 'localhost'
    type: mysql
    user: 'minecraft'
    database: 'minecraft'
    pass: 'password'

Share This Page