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

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

  1. Offline

    spunkiie

    REQ: A way to add a moderators list, and modtrs distribute among then (when online) the modreqs :D

    Would be GREAT!

    It's pretty sucks use /claim, again, and again and again :D
     
  2. Offline

    silthus

    Got the same error.
    Change the size of x,y and z colom in the database to int from tinyint. That should fix the problem.
     
  3. Offline

    Yetanotherx

    Already done. Will be in the next version.
     
  4. Offline

    Joy

    Will you be able to get the online status thing in? Really invaluable for us!

    Would also like to be able to change page size, but that is less important.
     
  5. Offline

    _knot_

    Just a little something I saw from sk89q that I thought would be GREAT for this plugin.
    http://www.sk89q.com/tempxfer/2011-05-10_00.37.53.png

    It's a server bulletin board. /post [msg]. You can remove with the numbers on the left. I would really love this for relaying messages after / before the motd. So. Permission group based. And maybe the option to have different boards for different groups.

    Let me know what you think and I look forward to your next release!
     
    jeffreylec likes this.
  6. Offline

    jeffreylec

    wow that's a really stupid idea.
     
  7. Offline

    NeatMonster

    Can you add the possibility to answer to tickets ? And maybe more notifications (when someone answers to the ticket).

    This plugin is better than Request but it is missing fonctionnalities. Any one has an other suggest ?
     
  8. Offline

    Yetanotherx

    I've provided functionality to close a request with a message, if that's what you're looking for.
     
  9. Offline

    Daniel Few

    Oh excellent, I came here to request this feature. Will this be implemented into the next update? If so, do you have a rough release date? Don't worry if you don't this plugin is very useful!
    -DanJames
     
  10. Offline

    Yetanotherx

    Release date should be by this weekend.
     
  11. Offline

    Daniel Few

    Thank You. Looking forward to it :)
    -DanJames
     
  12. Offline

    Yetanotherx


    The weekend came sooner than expected. I've pushed version 1.4, full of new features and bugfixes. Here's a list: https://github.com/yetanotherx/ModTRS/wiki/Changelog

    Stuff like this:
    • Online users have green text, offline users have red text in /check and /check-id
    • Allow mods to close a request with a closing message
    • Add a /done -silent option when closing a request - does not notify the user
    • Make MySQL actually work
     
  13. Offline

    NeatMonster

    No, what I want is to add the possibility to reply to request, for moderators and users. Look at the Request plugin. For example, if the moderator needs more info, he simply answers to the ticket and then the user too.
     
  14. Offline

    Yetanotherx

    Probably not going to happen. There are mail plugins, but this is a request system, not a conference system.
     
  15. Offline

    NeatMonster

    Yes, but responding to the ticket for giving users some infos or asking them for some infos is very useful.

    I will use the "Request" plugin because I realy need to answer to my players.

    Not conference *sad*.
     
  16. Offline

    _knot_

    Still getting errors with mysql.
    Code:
    2011-05-13 00:12:24 [SEVERE] java.sql.SQLException: Column 'request_server' not found.
    2011-05-13 00:12:24 [SEVERE]     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
    2011-05-13 00:12:24 [SEVERE]     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
    2011-05-13 00:12:24 [SEVERE]     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
    2011-05-13 00:12:24 [SEVERE]     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
    2011-05-13 00:12:24 [SEVERE]     at com.mysql.jdbc.ResultSetImpl.findColumn(ResultSetImpl.java:1144)
    2011-05-13 00:12:24 [SEVERE]     at com.mysql.jdbc.ResultSetImpl.getString(ResultSetImpl.java:5616)
    2011-05-13 00:12:24 [SEVERE]     at yetanotherx.bukkitplugin.ModTRS.sql.ModTRSRequestTable.getOpenRequests(ModTRSRequestTable.java:85)
    2011-05-13 00:12:24 [SEVERE]     at yetanotherx.bukkitplugin.ModTRS.command.CheckCommand.onCommand(CheckCommand.java:65)
    2011-05-13 00:12:24 [SEVERE]     at yetanotherx.bukkitplugin.ModTRS.command.CommandHandler.onCommand(CommandHandler.java:147)
    2011-05-13 00:12:24 [SEVERE]     at yetanotherx.bukkitplugin.ModTRS.ModTRS.onCommand(ModTRS.java:153)
    2011-05-13 00:12:24 [SEVERE]     at org.bukkit.command.PluginCommand.execute(PluginCommand.java:35)
    2011-05-13 00:12:24 [SEVERE]     at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:85)
    2011-05-13 00:12:24 [SEVERE]     at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:278)
    2011-05-13 00:12:24 [SEVERE]     at net.minecraft.server.NetServerHandler.handleCommand(NetServerHandler.java:682)
    2011-05-13 00:12:24 [SEVERE]     at net.minecraft.server.NetServerHandler.chat(NetServerHandler.java:645)
    2011-05-13 00:12:24 [SEVERE]     at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:639)
    2011-05-13 00:12:24 [SEVERE]     at net.minecraft.server.Packet3Chat.a(Packet3Chat.java:32)
    2011-05-13 00:12:24 [SEVERE]     at net.minecraft.server.NetworkManager.a(NetworkManager.java:196)
    2011-05-13 00:12:24 [SEVERE]     at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:75)
    2011-05-13 00:12:24 [SEVERE]     at net.minecraft.server.NetworkListenThread.a(SourceFile:100)
    2011-05-13 00:12:24 [SEVERE]     at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:372)
    2011-05-13 00:12:24 [SEVERE]     at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:287)
    2011-05-13 00:12:24 [SEVERE]     at net.minecraft.server.ThreadServerApplication.run(SourceFile:394)
    Code:
    2011-05-13 00:16:05 [SEVERE] com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value adjusted for column 'request_z' at row 1
    2011-05-13 00:16:05 [SEVERE]     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3591)
    2011-05-13 00:16:05 [SEVERE]     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
    2011-05-13 00:16:05 [SEVERE]     at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
    2011-05-13 00:16:05 [SEVERE]     at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
    2011-05-13 00:16:05 [SEVERE]     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626)
    2011-05-13 00:16:05 [SEVERE]     at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2111)
    2011-05-13 00:16:05 [SEVERE]     at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1362)
    2011-05-13 00:16:05 [SEVERE]     at yetanotherx.bukkitplugin.ModTRS.sql.ModTRSRequest.insert(ModTRSRequest.java:142)
    2011-05-13 00:16:05 [SEVERE]     at yetanotherx.bukkitplugin.ModTRS.command.ModreqCommand.onCommand(ModreqCommand.java:81)
    2011-05-13 00:16:05 [SEVERE]     at yetanotherx.bukkitplugin.ModTRS.command.CommandHandler.onCommand(CommandHandler.java:124)
    2011-05-13 00:16:05 [SEVERE]     at yetanotherx.bukkitplugin.ModTRS.ModTRS.onCommand(ModTRS.java:153)
    2011-05-13 00:16:05 [SEVERE]     at org.bukkit.command.PluginCommand.execute(PluginCommand.java:35)
    2011-05-13 00:16:05 [SEVERE]     at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:85)
    2011-05-13 00:16:05 [SEVERE]     at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:278)
    2011-05-13 00:16:05 [SEVERE]     at net.minecraft.server.NetServerHandler.handleCommand(NetServerHandler.java:682)
    2011-05-13 00:16:05 [SEVERE]     at net.minecraft.server.NetServerHandler.chat(NetServerHandler.java:645)
    2011-05-13 00:16:05 [SEVERE]     at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:639)
    2011-05-13 00:16:05 [SEVERE]     at net.minecraft.server.Packet3Chat.a(Packet3Chat.java:32)
    2011-05-13 00:16:05 [SEVERE]     at net.minecraft.server.NetworkManager.a(NetworkManager.java:196)
    2011-05-13 00:16:05 [SEVERE]     at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:75)
    2011-05-13 00:16:05 [SEVERE]     at net.minecraft.server.NetworkListenThread.a(SourceFile:100)
    2011-05-13 00:16:05 [SEVERE]     at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:372)
    2011-05-13 00:16:05 [SEVERE]     at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:287)
    2011-05-13 00:16:05 [SEVERE]     at net.minecraft.server.ThreadServerApplication.run(SourceFile:394)
     
  17. Offline

    Yetanotherx

    Is this a new database or one that was made in the last version?
     
  18. Offline

    _knot_

    I tried a few different databases. I can try a new one.
     
  19. Offline

    chlitto

    could you add an option to uncheck multiple items ?
    /done #1 #2 #3

    btw the "conference system" is a good idea :) but if you dont like it maybe just a comment option... "/hold # too litle info" "/hold # rtfm" "/hold # talk with an admin about this" ;]
     
  20. Offline

    spunkiie

    Please add Custom Messages (So I can make the plugin talk my users native language)

    TY
     
    chlitto likes this.
  21. Offline

    ConsoleView

    Can you do that i can open a chat for a ticket which i can only wirte with the person from the ticket?
     
  22. Offline

    Yetanotherx

    I've said it above that I won't do this. If you have to talk privately to the person, there's a bunch of other plugins that provide private messaging.
     
  23. Offline

    leslieliang

    Updated to the latest version, and it's giving me internal errors when I use /check. I'm running CB 766.
     
  24. Offline

    Yetanotherx

    What's the errors?
     
  25. Offline

    leslieliang

    It says an internal error has occur. Contact an administrator.
     
  26. Offline

    Yetanotherx

    I meant in the console.
     
  27. Offline

    MiHo

    Nice! Exactly that, I was looking for. Will give it a try.
     
  28. Offline

    leslieliang

    Code:
    2011-05-15 20:39:28 [SEVERE] java.sql.SQLException: no such column: 'request_server'
    2011-05-15 20:39:28 [SEVERE]     at org.sqlite.RS.findColumn(RS.java:121)
    2011-05-15 20:39:28 [SEVERE]     at org.sqlite.RS.getString(RS.java:317)
    2011-05-15 20:39:28 [SEVERE]     at yetanotherx.bukkitplugin.ModTRS.sql.ModTRSRequestTable.getOpenRequests(ModTRSRequestTable.java:85)
    2011-05-15 20:39:28 [SEVERE]     at yetanotherx.bukkitplugin.ModTRS.command.CheckCommand.onCommand(CheckCommand.java:65)
    2011-05-15 20:39:28 [SEVERE]     at yetanotherx.bukkitplugin.ModTRS.command.CommandHandler.onCommand(CommandHandler.java:147)
    2011-05-15 20:39:28 [SEVERE]     at yetanotherx.bukkitplugin.ModTRS.ModTRS.onCommand(ModTRS.java:153)
    2011-05-15 20:39:28 [SEVERE]     at org.bukkit.command.PluginCommand.execute(PluginCommand.java:35)
    2011-05-15 20:39:28 [SEVERE]     at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:85)
    2011-05-15 20:39:28 [SEVERE]     at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:278)
    2011-05-15 20:39:28 [SEVERE]     at net.minecraft.server.NetServerHandler.handleCommand(NetServerHandler.java:682)
    2011-05-15 20:39:28 [SEVERE]     at net.minecraft.server.NetServerHandler.chat(NetServerHandler.java:645)
    2011-05-15 20:39:28 [SEVERE]     at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:639)
    2011-05-15 20:39:28 [SEVERE]     at net.minecraft.server.Packet3Chat.a(Packet3Chat.java:32)
    2011-05-15 20:39:28 [SEVERE]     at net.minecraft.server.NetworkManager.a(NetworkManager.java:196)
    2011-05-15 20:39:28 [SEVERE]     at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:75)
    2011-05-15 20:39:28 [SEVERE]     at net.minecraft.server.NetworkListenThread.a(SourceFile:100)
    2011-05-15 20:39:28 [SEVERE]     at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:372)
    2011-05-15 20:39:28 [SEVERE]     at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:287)
    2011-05-15 20:39:28 [SEVERE]     at net.minecraft.server.ThreadServerApplication.run(SourceFile:394)
     
  29. Offline

    MiHo

    Works fine!
     
  30. Offline

    Yetanotherx

    You may have to start over with a fresh database, as it sounds like the update was not triggered. Could you post your config file?
     

Share This Page