Customer Relationship: PHP Support Tickets

PHP Support Tickets is a simple, powerful and secure application. PHP Support Tickets is written in PHP5 and utilises a MySQL database both are required on your web server to operate this application.

This application was written following design pattern principles and Object Oriented design. Developers delving into the code may be a bit disorientated at first, because the code doesn\'t follow the common php/template pattern. The design is instead focused on expandability and ease of maintenance. Most of the visual aspect of the application is controlled by css stylesheets, while the internal workings are neatly and coherently organised in logical classes and methods.

Although modifying the application certainly requires an understanding of Object-Oriented design, the PHP language and SQL, the installation is extremely straigh-forward, although a minimum understanding of web server technologies is essential. This script is set up to use a MySQL database by default, but can easily be modified to support all major types of databases, including MS Access, PostGreSQL and Oracle.

You will also need some knowledge of how to upload a database schema into your MySQL installation. This can be done very easily through PHPMyAdmin. At some point we will be providing an install program; but in some ways I think that takes away some of the flexibility of the software.

The administration section is secured through a username and password. The default entry is administrator / password. You may change this once you have logged in.

You may have unlimited Moderators / Admins assigned to take care of incoming tickets. These are all entered through an intuitive user admin page.

Admins are allowed to view all tickets and perform all admin tasks, moderators can see the tickets assigned to their department only.

Manageable departments allow you to edit / delete / add new departments at will.

Reply to tickets through the response section and an email will automatically be sent to the User who posted the ticket with a full history of the message thread.

Admins can see and view Attachments made by the User, and also add attachments to the replies. The type of files allowed are configured within the config.php file and is unlimited.

Newly posted tickets will be emailed to the Admin\'s email address, response by the User will also continue to be emailed with a full history of the message thread.

Many other configurable features are contained within the config.php file

Requirements

For versions >= 2.0 : PHP 5+, Database server

For earlier versions:

• PHP v4.2+ - For the security measures within this release.
• File uploads switched on for the use of attachments. Also the directory must be given the correct permissions to write the attachment to the disk.
• Will run on Linux or Windows.
• MySQL 3.23+
• SMTP server to send Email through the system.