Mod req: search function ?
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=21011
Printed Date: 29 March 2026 at 10:57pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Mod req: search function ?
Posted By: FoLo
Subject: Mod req: search function ?
Date Posted: 12 August 2006 at 8:57pm
Hi, can it really be right that it is not possible to hide topics/posts in the search function, if a forum is hidden or private forum ?
I only found this about it: http://forums.webwiz.net/forum_posts.asp?TID=18945&KW - http://forums.webwiz.net/forum_posts.asp?TID=18945&KW
please help...
Also I found this in a readme file from a old mod (version 7 I think, not sure who did it):
I've seen quite a few people mentioning the fact that you see all topics in the active topics page, even those in forums you may not access. Personally I found that a greater problem then some speed loss with an extra permission check. So I made a little mod
One requirement for this to work correctly is that you must set the permissions for all groups. Only grouppermissions will be looked at. Not at userpermissions or passworded forums. This was to make the performance impact not to big
Installing: just copy active_topics.asp and search.asp in your forum directory, or apply the changes if you have already modified versions of those files.
The following changes are made in active_topics.asp:
On line 261 add the following after directly topic , " & strDbTable & "Permissions "
Insert after line 262 the following line:
strSQL = strSQL & "AND (" & strDbTable & "Forum.Forum_ID = " & strDbTable & "Permissions.Forum_ID AND " & strDbTable & "Permissions.Group_ID = " & intGroupID & " AND " & strDbTable & "Permissions.[Read] = TRUE )"
Sorry for the SQL users but this is Access only.
And the same mod for search.asp
On line 196 add between topic and WHERE , " & strDbTable & "Permissions
On line 224 add directly after topic , " & strDbTable & "Permissions "
On line 264 add directly after thread.topic_ID , " & strDbTable & "Permissions "
Insert at line 272 the following line:
strSQLResultsQuery = strSQLResultsQuery & "AND (" & strDbTable & "Topic.Forum_ID = " & strDbTable & "Permissions.Forum_ID AND " & strDbTable & "Permissions.Group_ID = " & intGroupID & " AND " & strDbTable & "Permissions.[Read] = TRUE )"
This one might actually alos work for SQL since this query hasn't got a stored procedure version afaik.
|
|
Replies:
Posted By: FoLo
Date Posted: 15 August 2006 at 7:49pm
|
hmm.. I guess nobody knows ?
|
Posted By: Mikey
Date Posted: 15 August 2006 at 9:43pm
By default the forum software will only find in a search, posts that the person doing the searching, has permission to see/read. No need for a mod.
-------------
Handyman man?
|
Posted By: FoLo
Date Posted: 16 August 2006 at 1:13pm
Hi Mikey, thanks for replying, I just found out that my permissions system got f**ked up in my conversion to version 8.
Please close this topic, thx
|
|