Official Sponsor: NetworkRedux
PHP-Fusion
February 09 2010 15:05:59
Navigation
Users Online
· Guests Online: 25

· Members Online: 0

· Total Members: 28,327
· Newest Member: darevil
IRC Channel
Got an IRC Client?
Join our new IRC channel at

irc.freenode.com/phpfusion

Free IRC Clients: Wikipedia
Support Sites
Last Seen Users
· Barspin< 5 mins
· Softovick00:07:14
· jikaka00:19:36
· Antonoff77700:21:20
· Gravis00:33:32
· afif02:00:56
· Boxes02:23:57
· Splash02:30:31
· bser02:33:30
· structor03:04:38
Donate
View Thread
PHP-Fusion :: PHP-Fusion Additions :: Modification Help
 Print Thread
Bulk uhm... what's the word.. migrate?
Chaddy
#1 Print Post
Posted on 08-05-2007 20:07
Junior Member


Posts: 14
Joined: 15.03.07

 Hi

I've got about 8 different forum categories on my site. Seeing that I don't have the traffic to support that many I would like an easy way to take all forum posts (keeping their replies with them) and move to just one general forum. Is there some code I can paste into a custom page that will take all the posts from the different forums then move them to one forum?
 
Matonor
#2 Print Post
Posted on 08-05-2007 20:59
Fusioneer


Posts: 1535
Joined: 17.06.04

 this should do the trick:
<?php
dbquery("UPDATE ".DB_PREFIX."posts SET forum_id = NEW_ID WHERE forum_id = OLD_ID");
dbquery("UPDATE ".DB_PREFIX."threads SET forum_id = NEW_ID WHERE forum_id = OLD_ID");
?>
Impossible things are there to be made possible

matonor.com/images/fusionbutton.gif
themes.matonor.com/themes/crispyice/images/matonor.gif
 
http://matonor.com
Chaddy
#3 Print Post
Posted on 10-05-2007 19:44
Junior Member


Posts: 14
Joined: 15.03.07

 You're a genius!! it worked like a charm!

Grin
 
Jump to Forum:
Login
Username

Password



Not a member yet?
Click here to register.

Forgotten your password?
Request a new one here.
RSS Feeds
- PHP-Fusion News
- SF File Releases
- SF News Releases
Latest Roadmap Items
Shoutbox
You must login to post a message.

afif
09 Feb 2010 13:05:02
My nick is my name! Haha Grin

Splash
09 Feb 2010 12:35:27
What yours nick mean? Mine mean nothing, it's a random nick. Pfft

Splash
09 Feb 2010 12:26:08
Welcome pitbull.

afif
09 Feb 2010 11:06:11
welcome pitbull!

pitbullkmikc
09 Feb 2010 07:02:29
Hello everybody, I'm a new member, have a good day everybody...

Fangree_Craig
08 Feb 2010 17:11:07
Hello Darchangel and erm Darchangel... Grin

Darchangel
08 Feb 2010 16:11:03
Hello guys and erm guys... Grin

Fangree_Craig
08 Feb 2010 15:47:37
@Sampler- English only Please!

Splash
08 Feb 2010 03:32:56
Tell me few, I like to listen bands from various countries. (Is "some", "few" or "a few"?) Pfft

slaughter
07 Feb 2010 22:28:01
Rammstein is nice, but I prefer some scandinavian bands Smile
Render time: 0.41 seconds 58,353,907 unique visits
All content on this site is Copyright © 2003-2009 PHP-Fusion and Nick Jones, all rights reserved.
Logos and trademarks are the property of their respective owners.


Powered by PHP-Fusion copyright © 2002 - 2010 by Nick Jones.
Released as free software without warranties under GNU Affero GPL v3.