FAQ tutorial for me. Helpful for many users.

it would be very hard to impliment into WWF as it wasnt designed as a support ticket software, but this is how i would do it.


now, i dont know the database structure off the top of my head, but wouldnt it just be a case of getting a "Latest Posts" mod and changing the SQL for the following:

strSQL = "select * from tblTopics where tblTopics.Replies = 0 and tblTopics.closed = false order by last_post_date desc" strSQL = "select * from tblTopics where tblTopics.Replies > 0 and tblTopics.closed = false order by last_post_date desc" strSQL = "select * from tblTopics where tblTopics.closed = true order by last_post_date desc"

now, these are completely wrong table and field names as am not sure. but you get the jist of it.

(will edit with correct table and field names tomorrow)


Edited by Scotty32 - 21 June 2007 at 10:01pm

As i said, this isnt exact, as i wasnt sure of the table and field names.

you will need to adapt it for your own use.

which forum are you using?

this is with the correct field names:

Unanswered Topics strSQL = "select * from " & strDBTable & "Topic where " & strDBTable & "Topic.No_of_Replies = 0 and " & strDBTable & "Topic.Locked = false  and Forum_ID = 1 order by " & strDBTable & "Topic.Topic_ID desc"   Answered But Not Closed Topics strSQL = "select * from " & strDBTable & "Topic where " & strDBTable & "Topics.No_of_Replies > 0 and tblTopics.Locked = false  and " & strDBTable & "Topic.Forum_ID = 1 order by tblTopic.Topic_ID DESC"   Resolved Topics strSQL = "select * from tblTopic where tblTopic.Locked = true  and Forum_ID = 1 order by tblTopic.Topic_ID DESC"

you will need to improve this, and change the red 1 to the id of your "FAQ" forum

as i said before, this is just the SQL to be used with a "Latest Posts" mod

Thanks Pravven but its not what I am looking for. I am looking for a complete HelpDesk Mod for WWF. Any body here to help me?

here: http://forums.webwiz.net/forum_posts.asp?TID=23511