|
|
| Re: Merging two forums posts. [message #16834 is a reply to message #16833] |
Mon, 23 February 2004 14:50   |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
You could either move them manually, or run an sql query to update the forum_id for the topics inside the old forum and then run the consistency checker.
FUDforum Core Developer
|
|
|
|
 Re: Merging two forums posts. [message #16839 is a reply to message #16834] |
Mon, 23 February 2004 16:05 |
glennog
Messages: 1
Registered: February 2004
Location: Liverpool UK
Karma: 0
|
Junior Member |
|
|
Yup, we managed it... Thanks for the info Ilia.
For everybody else, this is how I did it...
First of all, you need the Forum ID of the source and destination forums. You can find out the IDs of your forums using the following SQL statement.
SELECT id,name FROM fud25_forum;
Armed with this info, you can now start moving stuff around. This is usually a good point to take a backup of your forum (and a mysqldump for the clinically paranoid).
Now for the actual move. It's not hard, really. In fact, it's dead simple. Say, for example, that the previous SQL statement returned the following results...
+----+--------------------------------+
| id | name |
+----+--------------------------------+
| 23 | Super Bike |
| 24 | Honda Twins |
+----+--------------------------------+
... and you wanted to move everything from Honda Twins to Super Bike. The SQL would be as follows...
UPDATE fud25_thread SET forum_id=23 WHERE forum_id=24;
That's it. Dead simple. Now all you need to do, as Ilia suggested above, is run the consistency checker to make sure that everything else mirrors the fact that these threads have moved.
Life's too short for humourous signatures...
|
|
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]