pweighill
Junior Member
United Kingdom
453 Posts |
Posted - 05 October 2002 : 17:56:18
|
Suppose I have two forums, A & B.
If someone posts a message to forum A, then I move that topic to forum B.
I then go back to the main page and the last post link on forum A points to the topic that I have just moved to forum B.
A quick solution is to check if the F_LAST_POST_TOPIC_ID in the FORUM table is the same as the TOPIC_ID of the topic being moved and if it is, set F_LAST_POST_TOPIC_ID and F_LAST_POST_REPLY_ID to null.
A better soultion would be to have a subroutine which could workout the F_LAST_POST_AUTHOR, F_LAST_POST_TOPIC_ID and F_LAST_POST_REPLY_ID for the specified FORUM_ID and set the values as appropriate for both forums involved in the move.
|
|