Simple Help Tickets

Table of Contents

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.

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.

Installation:
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:
• ~~Add config options for customizing messages.~~Done.
• ~~Add SQLite support, expand ticket communication and logging.~~Done.
• ~~Add MySQL Support.~~Done.
• ~~Add resolve ticket feature.~~Done.
• ~~Add ticket expiration.~~Done.
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

_ForgeUser7843409
- Join Date: 11/10/2011
- Posts: 60
- Member Details
#305 _ForgeUser7843409

View User Profile

Send Message

Posted Jan 13, 2015
Hi!! plz fix the link to Web GUI. This broken = (.

Rollback Post to Revision RollBack
Tjwmagic
- Join Date: 5/28/2013
- Posts: 5
- Member Details
#304 Tjwmagic

View User Profile

Send Message

Posted Dec 9, 2014
I wish I could summit a ticket for a ticket plugin. :( I was wanting to use the Web GUI for Simple Help Tickets, but the link does not work and returns invalid. Is the Web GUI available still and where at?

Rollback Post to Revision RollBack
Forge_User_80075269
- Join Date: 2/9/2012
- Posts: 433
- Member Details
#303 Forge_User_80075269

View User Profile

Send Message

Posted Nov 9, 2014
Hi

Could you add a permission to be able to have more tickets ? (have a less tickets' limit)

For instance, all players can open 5 tickets, and VIP 10 thanks to "sht.limit.10" (we can choose the number)

Last edited by Forge_User_80075269: Nov 9, 2014

Rollback Post to Revision RollBack

rautamiekka

Location: Ulvila
Join Date: 4/1/2011
Posts: 204
Member Details

#302 Posted Nov 6, 2014

[16:59:35 INFO]: §7[SimpleHelpTickets] §cError:§f com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 34,363,292 milliseconds ago.  The last packet sent successfully to the server was 34,363,292 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.

wait_timeout=28,800
lock_wait_timeout=31,536,000

Last edited by rautamiekka: Nov 6, 2014

_ForgeUser17303897
- Join Date: 10/6/2014
- Posts: 11
- Member Details
#301 _ForgeUser17303897

View User Profile

Send Message

Posted Oct 10, 2014
Ok, i did get if work. But how do i get utf8 work in the ticket boxs?

Rollback Post to Revision RollBack
_ForgeUser17303897
- Join Date: 10/6/2014
- Posts: 11
- Member Details
#300 _ForgeUser17303897

View User Profile

Send Message

Posted Oct 10, 2014
Does the SHT web gui work still?

Rollback Post to Revision RollBack
rautamiekka
- Location: Ulvila
- Join Date: 4/1/2011
- Posts: 204
- Member Details
#299 rautamiekka

View User Profile

Send Message

Posted Sep 7, 2014
SHT is the only plugin which gives the following complaint everytime someone joins:

[12:59:14 INFO]: §7[SimpleHelpTickets] §cError:§f com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException No operations allowed after connection closed.Connection was implicitly closed by the driver.

EDIT: An Admin gave this screenshot: http://prntscr.com/4kijm7, which means the plugin doesn't work until this is fixed.

Last edited by rautamiekka: Sep 7, 2014

Rollback Post to Revision RollBack
_ForgeUser7069321
- Join Date: 6/26/2011
- Posts: 53
- Member Details
#298 _ForgeUser7069321

View User Profile

Send Message

Posted Sep 3, 2014
Plugin needs to be updated to support UUIDs

Rollback Post to Revision RollBack
_ForgeUser9153247
- Join Date: 7/7/2012
- Posts: 2
- Member Details
#297 _ForgeUser9153247

View User Profile

Send Message

Posted Aug 24, 2014
Can you this plugin OpenSource?

Rollback Post to Revision RollBack
_ForgeUser15829748
- Join Date: 6/8/2014
- Posts: 4
- Member Details
#296 _ForgeUser15829748

View User Profile

Send Message

Posted Aug 19, 2014
Dear plugin author,

I love your plugin and I'm using it continually. Are you accepting feature-requests? If yes, I would like to submit this suggestion:

BungeeCord (multi)world support : Unfortunately the already-intergrated Multiworld-feature is not enough any more for my server, since we migrated to BungeeCord.

Could you please add this feature in the next update? I'll very appreciate it!

-iChillings Sorry for my bad English, I'm Dutch.

Rollback Post to Revision RollBack
_ForgeUser15660139
- Join Date: 5/29/2014
- Posts: 3
- Member Details
#295 _ForgeUser15660139

View User Profile

Send Message

Posted Jul 21, 2014
When somebody creates a ticket, no ID # is listed. Here is a screenshot of the problem.

http://puu.sh/alCb8/0b34920cf0.jpg

Rollback Post to Revision RollBack
_ForgeUser11966532
- Join Date: 8/2/2013
- Posts: 58
- Member Details
#294 _ForgeUser11966532

View User Profile

Send Message

Posted May 23, 2014
@modzmarvin

dw i found the one that comes with it lol and also your ones pretty good dan :) thanks both

Rollback Post to Revision RollBack
_ForgeUser11966532
- Join Date: 8/2/2013
- Posts: 58
- Member Details
#293 _ForgeUser11966532

View User Profile

Send Message

Posted May 23, 2014
@dan_t3h_man

Great work! i was just about to do this as soon as i saw the plugin till i saw yours XD Time saver! Il post when iv installed it with a review :P

P.s Odiumxxx think this is something that should be added with the plugin :P got to love sql!

Rollback Post to Revision RollBack
_ForgeUser7632323
- Join Date: 10/1/2011
- Posts: 825
- Member Details
#292 _ForgeUser7632323

View User Profile

Send Message

Posted May 16, 2014
I would like to have a way to delay the login ticket prompt by a few seconds so it doesn't get swept up in the other random login things.

Rollback Post to Revision RollBack
_ForgeUser8694973
- Join Date: 4/5/2012
- Posts: 15
- Member Details
#291 _ForgeUser8694973

View User Profile

Send Message

Posted May 15, 2014
Could you change the color and formmating codes in output.yml to default? Would be really useful, now I have to search for the code to use all the time.

Rollback Post to Revision RollBack
_ForgeUser14127270
- Join Date: 4/17/2014
- Posts: 6
- Member Details
#290 _ForgeUser14127270

View User Profile

Send Message

Posted May 5, 2014
Please update this plugin to support UUIDs if you need help coding it i can help because i know how. But simply put you just change the plugin to use players uuid instead of their name (so log uuid instead of name in sq-lite or MySQL database).

Rollback Post to Revision RollBack
_ForgeUser11241424
- Join Date: 5/13/2013
- Posts: 1
- Member Details
#289 _ForgeUser11241424

View User Profile

Send Message

Posted Apr 27, 2014
Using this locally on the server works fine.

But using MySQL only works for a short period of time - roughly 10 mins. After that, performing commands like /tickets, returns this error: [SimpleHelp Tickets] Error n: No operations allowed after connection closed. Connection was implicitly closed by the driver.

What are the timeout on the connection in the .class file? And how to change that - maybe even use the C3P0 way..

Rollback Post to Revision RollBack
_ForgeUser7496257
- Join Date: 9/4/2011
- Posts: 84
- Member Details
#288 _ForgeUser7496257

View User Profile

Send Message

Posted Apr 27, 2014
Does this support UUIDs instead of player names? I really need this because I don't want to install plugins that don't support this (so that I can easily upgrade to the higher MC versions later)

- Mike_x1

Rollback Post to Revision RollBack
_ForgeUser6899836
- Join Date: 5/26/2011
- Posts: 5
- Member Details
#287 _ForgeUser6899836

View User Profile

Send Message

Posted Apr 26, 2014
If anyone needs it, I made a new web page for this plugin, it's not pretty, but it works.

What it looks like: http://i.imgur.com/OOdhqo6.png

Download: https://www.dropbox.com/s/rwa2evf97qp5hjj/SHT-web.rar

To install it just put the tickets folder into your website root directory

Rollback Post to Revision RollBack
_ForgeUser10184112
- Join Date: 12/8/2012
- Posts: 706
- Member Details
#286 _ForgeUser10184112

View User Profile

Send Message

Posted Apr 15, 2014
pls update to 1.7.8 uuid

Rollback Post to Revision RollBack
To post a comment, please login or register a new account.

Project ID

37713
Created

Mar 18, 2012
Last Released File

Jun 22, 2017
Total Downloads

34,181

Bukkit

Simple Help Tickets

Bukkit Plugins