You could hack the
add.cgi file to add posts to a table called something like
Trouble_Tickets using the following table structure:
Code:
ID
UserID (from the Users table)
AdminID (from the Users table)
TroubleCategoryID (from Trouble_Category)
Subject
Problem
Addressed (Yes/No)
Add_Date
Mod_Date (1->M connection, meaning that Users can post multiple trouble tickets)
You would also have to hack the
modify.cgi to allow users to edit their trouble tickets.
You would have to create another table called
Trouble_Category which would contain the categories you would like to use for the Trouble Tickets. This could mirror the CatLink table.
Like the following:
Then you could hack jerry su's
forum.cgi or
review.cgi that would add threaded or flat view replies from the Administrator. You would have to create another table called
Trouble_Replies and the structure should be the following:
Code:
TicketID (from Trouble_Ticket table)
Reply
Add_Date
Mod_Date The "view" script would call data from the following tables:
1) Trouble_Ticket
2) Trouble_Category
3) Trouble_Replies
Then you would also have to use the
authentication sub in the various scripts to allow only people who have access to their trouble ticket can access them.
Basically, this is a hack of the "Private Message" utility of WWWThreads that could be integrated into
Links SQL NG.
Sorry that I do not have codes for you to copy and paste, but this should at least get you started.
Good luck!
Regards,
Eliot Lee