Official Sponsor: NetworkRedux
PHP-Fusion
July 31 2010 17:06:20
Navigation
Users Online
· Guests Online: 12

· Members Online: 0

· Total Members: 35,722
· Newest Member: siliesse
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
· Falcon< 5 mins
· johnmonroe00:15:58
· kamfengeren00:19:46
· siliesse00:20:51
· bartek12400:33:27
· Fangree_Craig00:41:58
· Joci196800:45:04
· gittedl00:47:17
· Barspin00:59:51
· MerlinSt01:11:29
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: 1532
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
 
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.
Member Poll
Which PHP version are you using?











You must login to vote.
RSS Feeds
- PHP-Fusion News
- SF File Releases
- SF News Releases
Shoutbox
You must login to post a message.

Fangree_Craig
31 Jul 2010 15:47:15
Hey Polarfox, look here. http://www.fangre.
../index.php

PolarFox
31 Jul 2010 15:34:55
Where I can find the list of differences of 7.00 and 7.01?

Fangree_Craig
31 Jul 2010 15:18:16
What's the news? Is 7.01 getting released tomorrow?

seraphine
31 Jul 2010 11:53:26
heelo everyone

OrbitaL-S2D
31 Jul 2010 05:04:21
I agree

Fangree_Craig
30 Jul 2010 19:08:21
It's better to just stay .co.uk all the time now, it looks great. Wink

mpkossen
30 Jul 2010 19:04:27
Because we do not know when we can fix the problems with phpfusion-mods.com
.

Keturkaimis
30 Jul 2010 18:48:40
Hello! Pfft

Fangree_Craig
30 Jul 2010 16:14:37
Really why's that? It's better to be on the .co.uk domain anyway. Shock

Falcon
30 Jul 2010 16:09:48
No, the news has been edited, mods is up and running as a subdomain of php-fusion.co.uk
Render time: 0.10 seconds 70,451,907 unique visits
All content on this site is Copyright © 2003-2010 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.