Minor bug: Email notification not deleted
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=15517
Printed Date: 13 April 2026 at 7:10am Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Minor bug: Email notification not deleted
Posted By: sfd19
Subject: Minor bug: Email notification not deleted
Date Posted: 20 June 2005 at 4:47am
I found a minor bug in the code, when deleting a category, a forum, a
topic or the last post in a topic then the email notifications for the
topic or forum do not get deleted.
Something like this will fix it in delete_category.asp and delete_forum.asp:
strSQL = "DELETE FROM " & strDbTable & "EmailNotify WHERE "
& strDbTable & "EmailNotify.Topic_ID=" & lngTopicID
& " OR " & strDbTable & "EmailNotify.Forum_ID="
& intForumID & ","
adoCon.Execute(strSQL)
In delete_topic.asp and delete_post.asp use the same code without the check for intForumID.
It is not really a bug but can slow down the forum a little when you
have thousands of entries in tblEmailNotify that are not needed
anymore, like we had.
Maybe boRg wants to update the code.
------------- Politics, economy & social issues: http://www.studentsfordemocracy.net - StudentsforDemocracy.net
|
Replies:
Posted By: sfd19
Date Posted: 20 June 2005 at 6:12am
Also move_post.asp is concerned when the last remaining post in a topic gets moved.
------------- Politics, economy & social issues: http://www.studentsfordemocracy.net - StudentsforDemocracy.net
|
Posted By: sfd19
Date Posted: 20 June 2005 at 6:18am
Also polls and poll choices get not deleted when you move the last remaining post of a topic with a poll somwhere else.
------------- Politics, economy & social issues: http://www.studentsfordemocracy.net - StudentsforDemocracy.net
|
|