Moving a thread with php and mysql

[PH03N1X]

I changed the forumid to the thread to 8 (which is the forum I am sending it to) and it keeped the post count, thread count, and last post in the thread the same which it should bring down to the right amount of thread count and post count and also it should change the last post to the one before the one that got moved. it did move it except for those things.

--------------- Added [DATE]1209330989[/DATE] at [TIME]1209330989[/TIME] ---------------

I guess I can run this sql command to get the last post for the forum and put the info in the last post of the forum.

SELECT lastpostid FROM vb_thread WHERE forumid = 2 ORDER BY lastpost DESC LIMIT 1;

and minus how many post there where from the thread from the forum and get the post count stuff right