Simple Help Tickets
Simple Help Tickets
Description:Simple Help Tickets provides a simple and effective system for users to request the assistance of an admin. Starting out as a rather lightweight plugin I threw together for personal use and decided to share, it has continued to expand due to popular demand. By using /ticket a user can open a help ticket, which can then be reviewed and dealt with by an administrator. Both users and admin are able to reply to tickets to further dialogue regarding a ticket. If a user logs in and an open ticket has received a reply from an admin, they will be notified of the change.
Installation:Updating to 1.0
If you are updating to 1.0 you will need to start with a fresh database.
If you're using SQLite simply delete Tickets.db in SimpleHelpTickets plugin directory
MySQL users, delete the table SHT_Tickets in your database, it will be replaced on server start.
1. Download the .jar
2. Place the .jar in your plugins directory
3. Restart the server
Configuration:
• MaxTickets
Maximum number of tickets per user.
• TicketExpiration
Number of days before a closed ticket expires
• NotifyAdminOnTicketClose
Users with the sht.admin permission will receive a message when a ticket is closed.
• MultiWorld
If using more than one world, take/check ticket will display the appropriate world name in ticket details
• OnJoin
Display number of personal tickets to user / total tickets to admin upon join
• USE_MYSQL
Whether to use MySQL instead of SQLite output.yml
• Use to customize plugin output (Language / Formatting)
Commands:
• /helptickets - SimpleHelpTickets Menu.
• /ticket (description) - Open a help ticket.
• /tickets [-a/-c] - List Open/All/Closed tickets.
• /checkticket <#> - Check the details of a ticket.
• /taketicket <#> - Assign self to a ticket. (and be teleported to the location is was set)
• /replyticket <#> <reply> - Reply to a ticket
• /closeticket [-r] <#> - Close a help ticket.
• /delticket (#) - Delete a help ticket.
• /purgetickets [-c/-a] - Purge expired, Closed or All tickets
Permissions:
• sht.ticket - Open a help ticket.
• sht.admin - Administrate help tickets.
• sht.reload - Reload SimpleHelpTickets.
To Do:
•
•
•
•
•
Web GUI
By popular demand, a Web GUI is available for SimpleHelpTickets.
You can download it below. • SimpleHelpTickets Web GUI
Thankyou for your support! :D Recent Change-Log:
1.4
- Updated for Spigot API 1.10.2
- UPDATED: Updated for new UUID system
(Caveats: UUID not translated to player name)
- Fixed: bug when reopening a ticket
1.3.6
- FIXED: MaxTickets not limiting the amount of tickets a user can open
- FIXED: User OnJoin notification of open tickets repeating itself
- FIXED: MySQL Connection Check. (Merged PR: TheCutter)
1.3.5
- Updated extra formatting to not interfere with colour codes
- Recoded ticket.class
- Fixed "CONSOLE has opened a ticket" bug for MySQL users
- Fixed notification of admin reply on user join
1.3.4
- Added bold/italic/underline/strike/reset to output.yml
- Fixed typo in output.yml
- Added check to getconnection in mysqlconnection.java to ensure connection is established, and if not re-stablish connection before continuing.
1.3.3
- minor bugfix: Users rceiving notification about open tickets even if tickt is/are closed
- minor bugfix: Prefix removed from 'No Tickets To Display' message
- minor bugfix: Instances of getDisplayName changed to getName in closeticket & taketicket (Fronix)
- minor bugfix: A few typos in output.yml have been fixed (if your output.yml is unchanged, delete it before starting your server to generate a new one)
Comments
-
_ForgeUser8170698 Owner
-
View User Profile
-
Send Message
Posted Jan 22, 2013Would you be able to add my request of changing the colour of a ticket in /tickets for admins if an admin is already assigned to it, to your to do list? If not, I can get another developer to it and give you the source to add to the plugin, as a list resort only though.
-
View User Profile
-
Send Message
Posted Jan 21, 2013@yungeinstein
Good point, updated.
If using more than one world, take/check ticket will display the appropriate world name in ticket
@ImpactCP
Well of course, by restarting your SQL server you disconnect any connections bukkit was holding to it. Restarting bukkit re-established the connections.
This is expected behaviour
@MrREOM
View the list of open ticket with /tickets
-
View User Profile
-
Send Message
Posted Jan 18, 2013How can we tell the number of the ticket when one sends it?
-
View User Profile
-
Send Message
Posted Jan 17, 2013Very nice plugin!
I have a Issue if the SQL server restarts (Bukkit was running and i needed to restart my sql-system. After this every time the same error comes, only a /reload of bukkit fix this)
com.mysql.jdbc.execptions.jdbc4.MySQLNonTransientConnectionExcpetion: No operations allowed after connection closed. Connection was implicitly closed by the driver.
-
View User Profile
-
Send Message
Posted Jan 14, 2013I'm looking at the default config generated by SHT. What does the MultiWorld setting enable? It isn't listed in the config section above.
-
View User Profile
-
Send Message
Posted Jan 7, 2013@xxtreepuncherxx
It would appear SimpleHelpTickets cannot access your MySQL database.
Confirm you have setup your MySQL database and settings in config.yml correctly.
-
View User Profile
-
Send Message
Posted Jan 5, 2013Im getting this error on /ticket command http://pastebin.com/0TuXJg0c
-
View User Profile
-
Send Message
Posted Jan 3, 2013Can you add a feature that sends a message to all admins who are not assigned to a ticket when there is tickets which have no one assigned to them? E.g. 'There are open tickets, please type /tickets to view them' every e.g. minute which could be configurable as well as the actual message the players with the sht.admin permission would receive.
-
View User Profile
-
Send Message
Posted Jan 1, 2013@Speedrookie
I'm going to need alot more information than that.
Please open a ticket.
EDIT: Off the top of my head, I suspect you've enabled MySQL however are not connecting to your MySQL server properly.
Thus, when a user logs in it returns the error you are seeing. Check the console log when your server is enabled, it will likely reflect that SimpleHelpTickets is unable to connect to your MySQL database.
-
View User Profile
-
Send Message
Posted Dec 31, 2012Hello i am having an error: Java.lang.nullpointer dont know why please help! Thanks
-
View User Profile
-
Send Message
Posted Dec 27, 2012Hello,
A feature request that I think larger servers would appreciate. As tickets pile on and on, and players sign off, we tend to get a pile of tickets that we can't solve until the player comes back online. We just accumulate a group of open tickets with offline players. Right now the player name is "green" in all open tickets, would it be possible to color the names of offline players gray or red (or configurable) for open tickets?
Thank you for your consideration!
-
View User Profile
-
Send Message
Posted Dec 26, 2012@Asip
What are you talking about? SHT-1.3.3 works fine with Bukkit-1.4.6
Next time, try it out before complaining please. :)
-
View User Profile
-
Send Message
Posted Dec 25, 2012UPDATE PREEZ
-
View User Profile
-
Send Message
Posted Dec 22, 2012@cuddyier
I wouldn't call that broken, it's just a typo. Regardless cheers for the notification.
Remember that output.yml exists so that you can change it yourself, thus customizing the output to your liking.
As for changing the colour of a ticket that an admin has reviewed but not replied to, I'll look into it.
All the varying colours may get confusing, so the addition of a key of some sort to outline the different colours and their meanings may be necessary.
Either way, I'll look into it.
-
View User Profile
-
Send Message
Posted Dec 22, 2012@Odiumxxx
Also, the output messages are still broken, this is the message when an admin closes a ticket that isn't mine, http://puu.sh/1DZx9 Also, can you add it so that when an admin assigns them self to a ticket, the ticket changes colour in /tickets so other admins know the ticket is already taken without doing /checkticket.
-
View User Profile
-
Send Message
Posted Dec 21, 2012@cuddyier
Currently, no.
However I'll throw it in the next release along with other chat formatting. (italic/underline/ etc)
-
View User Profile
-
Send Message
Posted Dec 21, 2012Is it possible to use bold fonts in the outputs?
-
View User Profile
-
Send Message
Posted Dec 18, 2012@Odiumxxx
Said user must be confused, I'm unable to replicate the error or find anything in the code which would cause that.
Most likely the case :D Nevertheless I'm sure your next patch will resolve all those problems. Thank you!
-
View User Profile
-
Send Message
Posted Dec 18, 2012@kbryantLA24
"There's a glitch where after an admin closes a ticket that a player opened, if the player relogs it still says he has an open ticket."
This is indeed a bug, thanks for reporting.
Will be fixed in next release.
"Furthermore, if the player types "/tickets", he sees the ticket as "open", even though it's closed."
Actually, you'll notice that the closed ticket is in grey, and if you check the ticket with /checkticket # you'll see the status reflects that it is indeed closed.
"For some reason even after I purge all the tickets (both open and closed, so that no tickets at all exist), a player reported he got the "You currently have 1 open help ticket" prompt."
Said user must be confused, I'm unable to replicate the error or find anything in the code which would cause that.
-
View User Profile
-
Send Message
Posted Dec 17, 2012@Odiumxxx
There's a glitch where after an admin closes a ticket that a player opened, if the player relogs it still says he has an open ticket. If the player tries to close the ticket, it says that ticket is already closed, even though it says he has an open ticket at log in. Furthermore, if the player types "/tickets", he sees the ticket as "open", even though it's closed. I'm using SimpleHelpTickets-1.3.2 and CB 1.4.5-r0.2.
EDIT: For some reason even after I purge all the tickets (both open and closed, so that no tickets at all exist), a player reported he got the "You currently have 1 open help ticket" prompt.