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

ModTRS - Moderator Ticket Request System:
Version: v2.1

On very large servers, people often require help from a mod. People find griefing, want to place a banned item, or want something moved. However, during peak hours, when people are requesting help constantly, it can be hard to keep track of the fast-moving chat. ModTRS aims to solve this issue. ModTRS allows users to file requests to the moderators, and have them saved in an organized manner until a mod has a chance to respond.

This plugin is currently used on some very large, high-profile servers, including the Reddit Public servers, where it is being used effectively and easily by the mods.

Download ModTRS v2.1 - Plain JAR - Source Code

Features:

• Easy installation: Just install ModTRS.jar, and it takes care of the rest!
• Logs username, time of day, location of request, a message, and more information
• Ability to claim requests to prevent mods stepping on each others' toes
• Send a private message to all the mods online
• Teleport to the location of the request
• List all online moderators
• Useful help: /modreq help only shows commands you have permission for
• Many more features...

Usage:

• Installation
• Usage
• Permissions
• Configuration
• Changelog

(Thanks, CyberSick99!)

Please update to latest recommended 617

I have updated the plugin to version 617. It is pretty much complete, and it just needs some real world testing before I declare it stable.

I see potential in this. I think there was a similar plugin too... just can't remember the name.

I can't seem to get it to work.
CB 617
Using any commands results in no response from the server. I'm using group manager and I have all the permissions.../check, /mod-broadcast, /modreq test just all do nothing.

Is anything reported in the console? Do you get a "Unknown console command" when you do them? Or is it just that nothing is happening?

Absolutely nothing is happening.

Edit:
Figured it out. It's looking for the SQLite library.
Many other plugins use that, and I have it in my main minecraft directory. Perhaps you could look there as well since other plugins do that too?

i used the helpticket plugin so far, but this sounds way better.
I havn't tried it yet because I am at work, so therefore I do not know if it does what i want:
Does it display new tickets/requests?
I mean, if there is a new ticket that it automatically displays.
Or at least that it tells every 5 minutes that there is an open request.
Thanks in advance

A way to view it through a browser would be amazing. Like how milkAdmin used to function. It would load up a page whenever the server was loading and bind it to a certain port. It would be useful for large servers as you wouldn't have to sort through all of them ingame.

I don't know how it worked exactly, but couldn't you just have them call the same database?

I do not have a web interface at the moment. However, it is stored in a SQLite database with a very simple table structure, so an amateur programmer could write an interface for this.

When a request is filed, it notifies all the mods. When a request is completed, it notifies the user and all the mods. When a request is claimed/unclaimed/held, all the mods are notified. When a mod logs on with new requests available, they are notified that there are open requests.

There's a lot of notification.

I've updated it using LWC's updater code. Please let me know if this works.

An amateur programmer I am not...

thanks I use it

Can you please upload v0.1? I still run CB617.

It should still work on CB617, as I didn't have to make any changes to upgrade to CB670. I would strongly advise that you update ASAP, as CB669 and before have a critical security hole that was recently used to exploit a large number of servers. Link

Problem, when I give my mod group their commands, it says they have no permission to use it. Admins with all permissions can use it though. Was there a change in the permission nodes, or could it be group manager. I doubt its Groupmanager though because they have access to all the other commands I give them plus Admins, once again, have access to ModTRS.

I've pushed a stable version. If you downloaded a late beta, it should automatically download the ModTRS jar and update itself.

Nice! It works on CB617. Thanks alot! Is there anyway to reset the list back to #1? I had like 5 test requests and would not like the requests to start at #6.

This is intentional. It's useful to have an archive, so someone can always go back to read past requests. What more, from a programming standpoint, it's much more logical to do it this way. If you want to come up with a temporary solution, moving the plugins/ModTRS/modtrs.db file to another location should clear all the requests. Just do it when the server is stopped.

A side note, version 1.1 will have the ability to move the database file while the server is running.

Thank you for this plugin! I have some questions =)

1) What is the use on hold? for me it seems that it is an alias for /done cause if i set a request on hold it is hidden from the open request list. On hold should be visible in the list but marked as hold?

With /claim its possible to make it visible again in the open-request list .. but then i must know the id.

A /checkhold would be nice

2) What about mysql support? In my opinion there should be an option for that.

Hold is designed to keep stuff off the short queue (say someone logs off and you need to ask them clarification). You can see all held requests by doing "/check t:held".

MySQL support is coming in a future version.

Aahh okay ^^ thank you for pointing that out. Well, there is a modifier! Nice 0) That was all i need to know. (Maybe you could add this to your Usage Section in your Startpost ^^)

MySQL support in a future version? Ill keep that in mind. I cant wait to play with it .. Imagine if someone wants to include this into a track frontend (like svn trac) and answer those tickets remotely

Just barely updated it to link to the new usage page.

One could also write a SQLite frontend. Although I do agree MySQL would be better. SQLite is just easier.

Perhaps this is an issue with the GroupManager interface. I use Permissions for the most part, so I don't know what's working on GroupManager and what's not. I'll look into this. Do you use multiple worlds on GM?

Actually got it to work, you should incorpirate gm, its actually not that different then permissions.

I tested it with GM once, so I assumed it was working. But because I never use it, I wasn't sure.

Yeah, I searched for a long time, and couldn't find anything. This is turning out really well, so I'm optimistic about how this plugin will be used.

Yeah "could" Personally i prefer mysql over sqlite espacially if you want to store more than 100 lines in it. For a simple guestbook (if that diff applies) you probbably dont need the power of mysql but in case of accessing a huge amount of data sqlite slows down the process.

Im not familiar with java and mysql implementation but differs sqlite and mysql that much? In my opinion sqlite is a smaller version of sql. The Querys should be the same i think (the Database is then a socket instead of a file handler). So implementing mysql should not be that hard. Okay .. you have to instruct the user to create a database manually and so on .. i babble .. thanks for your reply looking forward to see more ^^

All the SQL queries I use are likely to work on MySQL too. The issue with MySQL is that I have to use config values for username, password, etc. While that isn't difficult, when I was starting the plugin, I didn't have a config file set yet, so I just used SQLite to make life easier. Like I said, MySQL in a future version.