customizing thread view
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=26599
Printed Date: 29 March 2026 at 6:02am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: customizing thread view
Posted By: DoctorB
Subject: customizing thread view
Date Posted: 30 November 2008 at 1:02pm
|
We have to run a patient support forum with a structure so that a patient is able to see/access only the thread started by himself and not those by other patients. But the professionals/physicians should be able to see/access all patient threads. We have built memberships 'patient' and 'professional'. They are non-incrementing. Any guidance how we can make the above modification would be highly appreciated. Thank you. Manish |
Replies:
Posted By: Scotty32
Date Posted: 30 November 2008 at 1:45pm
|
Would you not be better off using a Support Ticket program rather than a discussion forum? As Support Ticket software will work exactly how you want without need for alterations. ------------- 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: DoctorB
Date Posted: 02 December 2008 at 1:13pm
| That would indeed be ideal but people don't like to login to different applications for different reasons. If they are already visiting the forums, they prefer to post on the forums rather than loggin on to another application for giving free advice. |
Posted By: 123Simples
Date Posted: 02 December 2008 at 7:51pm
|
As I see it, and that is if I even understand what you are trying to put across, is that you would near enough to allocate individual permissions to each patient, so they could only see their own thread. You could either do this by "manually" allocating the individual permissions of each patient, or issuing each and every patient with their own unique password to their own thread, but that would probably be too much to do as each professional would need to have access or know every individual password
------------- http://www.123simples.com/" rel="nofollow - Visit 123 Simples Web Design |
Posted By: DoctorB
Date Posted: 04 December 2008 at 6:19am
|
Well what I am looking for is something like this: While displaying threads check if the forum-id is equal to the patient forum id If yes read the username/id from the cookie If the user belongs to group 'Patient' fetch from db threads which were started by this user display threads End if else normal webwiz forum code end if |
Posted By: 123Simples
Date Posted: 04 December 2008 at 6:33am
Okay - we can have a look at this later for you. Right now I'm off to work  
------------- http://www.123simples.com/" rel="nofollow - Visit 123 Simples Web Design |
Posted By: DoctorB
Date Posted: 07 January 2009 at 6:50am
|
I tried to play with the sql on the forum topics page but I am not good at it so getting an error. Can somebody tell me how to do it right? This is the code that I changed on the fourm topics page: -------------------------------------- 'Select which topics to get ' ** Begin Patient Forum Mod ** If intForumID=40 and intGroupID=15 then strSQLFromWhere = strSQLFromWhere & "AND Topic.Start_Thread_ID = lngLoggedInUserID " End if ' ** End Patient Forum Mod ** strSQLFromWhere = strSQLFromWhere & "AND (" & strDbTable & "Topic.Priority = 3 " & _ "OR " & strDbTable & "Topic.Moved_ID = " & intForumID & " " & _ "OR " & strDbTable & "Topic.Forum_ID = " & intForumID & ") " & _ ") " 'If this isn't a moderator only display hidden posts if the user posted them If blnModerator = false AND blnAdmin = false Then strSQLFromWhere = strSQLFromWhere & "AND (" & strDbTable & "Topic.Hide = " & strDBFalse & " " 'Don't display hidden posts if guest If intGroupID <> 2 Then strSQLFromWhere = strSQLFromWhere & "OR " & strDbTable & "Thread.Author_ID = " & lngLoggedInUserID strSQLFromWhere = strSQLFromWhere & ") " End If ---------------------------------------- What I am trying to do is - If the forum is 'patient forum' and the user belongs to group 'Patient' then modify the query fetching the topics so that it only fetches the topics where the topic_start_id=the id of the logged in patient end if Now I get this error when a patient goes to the patient forum: Server Error in Forum Application An error has occurred while executing SQL query on database. Please contact the forum administrator. Support Error Code:- err_SQLServer_topic_count File Name:- forum_topics.asp Error details:- Microsoft OLE DB Provider for SQL Server The multi-part identifier "Topic.Start_Thread_ID" could not be bound. ------------------------------------------ I know my sql query is defective. I would appreciate your help in correcting it. Thank you. |
Posted By: DoctorB
Date Posted: 08 January 2009 at 4:39am
| Anybody having knowledge of sql? |
Posted By: WebWiz-Bruce
Date Posted: 08 January 2009 at 8:30am
|
Customising the forum to work as a support ticket system will take allot more than just editing a few of the SQL Queries as to keep the post completely private many other sections like searching, RSS Feeds, latest posts, etc. also need to be customised. This would be a BIG job to do and get it completely right with allot of work involved and if you are not familiar with ASP and SQL you should look at hiring a web development company to make build a customised forum for you. You maybe better off looking for a support ticket system as many of these work in exactly the way you are describing, including SmarterTrack from SmarterTools which we use here for our own support ticket system and find to be very good. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: slog
Date Posted: 20 September 2009 at 4:13am
| Maybe it is a problem already solved, but for me a good option is to give member permissions to that specific topic. When you create your member patient, you make a topic with his name and give him permissions on that topic only. The same can be done for the docs, you can give permissions for each doc to only have access to their patients topics... |