Gossamer Forum
Home : Products : Gossamer Links : Discussions :

ticket support

Quote Reply
ticket support
Hello
An Idea:

For Links-SQL an option like websupport where users can post questions to administrator/editors and posted in a database.

Is there such scripts/plugins that can be used for links-SQL
NG ??????

Quote Reply
Re: ticket support In reply to
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:

Code:

ID
Name


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