Support Request System Author: Melissa Peh -------------------------------------------------------------------------------- Overview Support Request System was originally designed for and used by a web hosting company. Basically, it gets input from the user, emails a unique ticket number for him/her and writes to a database which can be accessed both by the user (no email address is published) and support team (email address is published and entries can be deleted). The cgi-lib.pl library is required. Current version: 0.6.2, 10 January 1998 The Scripts support.cgi - gets input from client, generates a ticket and writes to database status.cgi - outputs database for clients to check their status admview.cgi - outputs database for support team with clients' email address and deletion of entry is enabled admdel.cgi - used together with admview.cgi to delete entries config.pl - keeps all the variables Installation Define the following variables found in config.pl: $datafile = '/home/melz/public_html/support/db.txt'; The full path to db.txt which keeps all the data $countfile = '/home/melz/public_html/support/count.txt'; The full path to count.txt which keeps track of the ticket number. It starts with 1000 but can be modified. $delurl = 'http://www.spunge.org/~melz/support/admdel.cgi'; The url to the admdel.cgi script $statusurl = 'http://www.spunge.org/~melz/support/status.cgi'; The url to the status.cgi script $mailprog = '/usr/sbin/sendmail'; The full path to the server's sendmail program $sender = 'melz@spunge.org'; The email address that sends the ticket number to the client $notify = '1'; Enter 1 if you want to be notified when there's a request and 0 if you don't want to Make sure that all your scripts point to the correct path where your config.pl and cgi-lib.pl resides. Some script require both and some config.pl. require '/home/melz/public_html/support/config.pl'; The full path to your config.pl require '/home/melz/public_html/lib/cgi-lib.pl'; The full path to your cgi-lib.pl Obtaining the Files All the source codes is available in zip format from: http://project99.xpression.net/files/support-062.zip ftp://ftp.spunge.org/pub/melz/support-062.zip To-do List Email script - reply to the client without using a external email client Dispatch a message to client when their request has been deleted. Release Notes Version: 0.6.2, 10 January 1999 Add url linking to domain address for status.cgi (opens new browser window) Included complete documentation for this script Version: 0.6, 05 January 1999 Changed date format (looks nicer!) Added file locking to all scripts Added close(DATA) to status.cgi and admview.cgi Added url linking to domain address for admview.cgi (opens new browser window) Version: 0.5, 03 January 1999 Initial release License This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation. Since this program was written for personal use, it is offered AS-IS with no warranties or guarantees. In other words, you are alone responsible for the use or misuse of this script. Feedback Let me know if you're using this script since I make changes quite frequently - send email to mpeh@iname.com. If you'd like to see a particular feature included in the script that's not already there, just drop me a note with the details. This site was designed to attain a first-generation webpage look. Every effort is taken to make it look as genuine as possible. -------------------------------------------------------------------------------- Copyright © 1999 Melissa Peh