FUDforum: How To » Merging two forums posts.

Home » FUDforum » How To » Merging two forums posts.

Show: Today's Messages :: Polls :: Message Navigator

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:

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...

Report message to a moderator

[Message index]

		Merging two forums posts. By: andy_scouser on Mon, 23 February 2004 11:26
		Re: Merging two forums posts. By: Ilia on Mon, 23 February 2004 14:50
		Re: Merging two forums posts. By: glennog on Mon, 23 February 2004 16:05
		Re: Merging two forums posts. By: andy_scouser on Mon, 23 February 2004 16:26

Previous Topic:	Spell Checker.
Next Topic:	Forum Management

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 23:00:15 GMT 2024

Total time taken to generate the page: 0.22274 seconds