Web Wiz Forums Modifications - FAQ tutorial for me. Helpful for many users.

Print Page | Close Window

FAQ tutorial for me. Helpful for many users.

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums Modifications
Forum Description: Mod's and Add-on's for Web Wiz Forums.
URL: https://forums.webwiz.net/forum_posts.asp?TID=23577
Printed Date: 30 March 2026 at 4:18am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: FAQ tutorial for me. Helpful for many users.

Posted By: Praveen
Subject: FAQ tutorial for me. Helpful for many users.
Date Posted: 21 June 2007 at 9:52am

Hi. I want to create a small script in the default.asp file. For example, if I have a seperate forum for FAQ / Questions to be asked. Then there will be many unanswered posts. I need to give a link with the list in the main page.

Ex:

FAQ

Unanswered Topics

F What is WWF?

F I need some help.

F It is not working.

Answered But Not Closed Topics

F Account help.

F Pls suggest me some ideas.

Resolved Topics

F How to post?

F What is the meaning of ...

Here F is the forum icon. I mean the default way the forums are listed.

Unanswered topics are the topics where a user has posted the question and there are no replies or the user has replied himself but nobody else.

Answered but not closed are the open topics where the questionner has posted and other users have also posted their opinion to the question.

Resolved topics are the ones where the user has got the best answer out of it. The topic is closed by the forum admin.

Can this be done. Please this is helpful for my site. Also can be of use to many people.

Please suggest / rate my idea about this. What you users say about this idea. Actually now Iam doing my second year CSE engineering and now my touch with ASP is very less. Thats the problem Iam facing now. So that why I am posting this question and if you have the answers, it may be helpful for many users too.

Thanking You

Faithfully

Praveen Kumar

-------------

Replies:

Posted By: Scotty32
Date Posted: 21 June 2007 at 9:59pm

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:

Unanswered Topics

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

Answered But Not Closed Topics

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

Resolved Topics

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)

-------------
S2H.co.uk - http://www.s2h.co.uk/wwf/" rel="nofollow - WebWiz Mods and Skins

For support on my mods + skins, please use http://www.s2h.co.uk/forum/" rel="nofollow - my forum .

Posted By: Praveen
Date Posted: 22 June 2007 at 3:12am

Hi. Thanks for your kind help. I am sorry Iam not able to use this code. I don't know how to. But is this code for MS Access 2000 database?? Iam using the version 8.04.

-------------

Posted By: Scotty32
Date Posted: 22 June 2007 at 1:07pm

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

-------------
S2H.co.uk - http://www.s2h.co.uk/wwf/" rel="nofollow - WebWiz Mods and Skins

For support on my mods + skins, please use http://www.s2h.co.uk/forum/" rel="nofollow - my forum .

Posted By: Praveen
Date Posted: 22 June 2007 at 4:35pm

Thanks. Let me do it manually. If possible I will try my best to paste the code here. Thank you once again.

-------------

Posted By: StarDust
Date Posted: 22 June 2007 at 7:43pm

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 - http://forums.webwiz.net/forum_posts.asp?TID=23511

-------------
http://board.ebizbd.net/">

Tips, mods and skins for WWF v9.x