Support Ticket NPC

Support Ticket System (STS) v2.0
An advanced way of providing support to your players

Creator: [GM]Xeon
Version: 2.0

Features:
Players can post new support tickets, reply to them, and close them if it's self-resolved
*Players get a message when they log in about unread support tickets
*Players get a message if they're online and one of their tickets were replied to
*Players can attach URL's for files uploaded to speed up the support process and provide proof (Mostly based for PHP version yet to come)
*GM's can view tickets by their department, then status, then priority or date
*GM's can reply to, change status, priority or transfer department and also delete tickets
GM's can search tickets by using Title, Body, Ticket ID, Character Name, or Character ID
GM's can whisper anything to the npc to start conversation
The basic ticket status': Open, Closed, Waiting, On Hold
*Ticket priority rankings: Irrelevant, Minor, moderate, Urgent, Critical
*Department system, categories for where to post tickets
*Per-staff-based moderating permissions for each department
*Player and staff (<99 GM level) account ID, character ID, and IP address banning available
SQL injection protection
*=Indicates new to v2.x

Future Features:
A nice little php page to integrate the support ticket system to your web server as well (Perhaps a CeresCP patch)

Downloads: Engine, SQL script and 1.x->2.0 converter


Installation:
Step 1 (Optional): Run the MySQL script on your database using your favorite MySQL tool (I Recommend MySQL query browser) or MyPHPAdmin.
Step 2: Place the main engine (ST+.txt) it in your "./npc/custom/" folder.
Step 3: Add this line to your "./npc/scripts_custom.conf" file:
CODE
npc: npc/custom/ST+.txt

If you want to upgrade an old ST version, run the migrate script inside the rar with eA after the ST 2.0 MySQL db has been installed.

Change Log:
v1.0...v1.3: original outdated version.
v2.0: Complete remake, now supports tons of new features!

Note this is a work in progress, it hasn't been optimized yet and is sorta bare, probably has quite a few bugs. I'm not sure if I fully tested the GM search function, but I quick skimmed the script over and it seems to be there, so it might work? And for the converter, it has no syntax errors but has never been run a single time, so it might just blow up in your face...