You could hack the add.cgi file to add posts to a table called something like Trouble_Tickets using the following table structure:



(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:



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