Home »
FUDforum »
How To »
Imported into wrong Forum
Imported into wrong Forum [message #33640] |
Mon, 11 September 2006 19:28 |
aleman
Messages: 40 Registered: May 2006 Location: Blackpool UK
Karma:
|
Member |
|
|
Doh!
Ok I'm in the process of using Fudbox.php to import 5years worth of MBOX archives into our nice new shiny forum, month by month Anyway just over half way in I forgot to change the Forum that I wanted the emails imported into with the consequence that Jan, Feb and A little bit of Mar 2004 ended up being posted in the 2003 archive.
What I need to do is to move these from the wrong forum and put them in the right one. I've had a quick squiz at the tables but can't see where the forumId is in the msg table, all I need to do is to change the ForumId from 6 to 7 where the Date is in the range Jan 01 2004 to March 05 2004.
Simple Update statement should do it or am I being too simplistic?
TIA
--
Aleman
|
|
|
Goto Forum:
Current Time: Mon Nov 25 20:37:25 GMT 2024
Total time taken to generate the page: 0.06700 seconds