Minor bug: Email notification not deleted

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.


Edited by sfd19 - 20 June 2005 at 7:02am

Also polls and poll choices get not deleted when you move the last remaining post of a topic with a poll somwhere else.