Is this common for many others? - 11/09/2003 1:53 AM
When posts get moved, someone replying during the move replies and the reply becomes detached and belongs to the original forum still. If the new forum is hidden, users can search and still access to the reply, and in threaded mode see the subjects of the posts in the forum they don't have access to.
Here is a select I made to check how many posts were suffering from main and replies having different forums:
select r.B_Board, m.B_Board, r.B_Parent, r.B_Main, r.B_Number from w3t_Posts as r, w3t_Posts as m
WHERE r.B_Main = m.B_Number
AND m.B_Topic = 1
AND r.B_Board <> m.B_Board;
I'm just wondering if many other boards that do a lot of moving of posts from forum to forum have this problem?
Here is a select I made to check how many posts were suffering from main and replies having different forums:
select r.B_Board, m.B_Board, r.B_Parent, r.B_Main, r.B_Number from w3t_Posts as r, w3t_Posts as m
WHERE r.B_Main = m.B_Number
AND m.B_Topic = 1
AND r.B_Board <> m.B_Board;
I'm just wondering if many other boards that do a lot of moving of posts from forum to forum have this problem?