Print Page | Close Window

Active topics mod

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=2165
Printed Date: 31 March 2026 at 11:59am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: Active topics mod
Posted By: Zamal
Subject: Active topics mod
Date Posted: 26 April 2003 at 11:32am

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 Smile

The following you'll have to change 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 )"

One requirement for this to work correctly is that you must set the permissions for all groups. Only grouppermissions will be looked at.

Sorry for the SQL users but this is Access only.




Replies:
Posted By: Zamal
Date Posted: 26 April 2003 at 1:17pm

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.

ps. I would have posted this in the mod forum, but I couldn't.




Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net