move all topics from one forum to another - Postet den (1109 Views)
Retired Support Moderator
MarcelG
Innlegg: 2625
2625
Guys, perhaps this has been asked (and answered) before, but I'm looking for a quick script to move all topics (including their replies) from one forum to another forum (within one site). In my case it's from forum ID 50 to forum ID 20.
It concerns 328 topics with 2218 replies. Does anyone have a nice script laying around for that?
   
 Sidestørrelse 
Postet den
Snitz Forums Admin
ruirib
Innlegg: 26364
26364
What database are you using?
I can write you one that will work with MySQL and SQL Server, except for the update counts part, but you can run that manually afterwards...
Postet den
Retired Support Moderator
MarcelG
Innlegg: 2625
2625
I'm using SQL (2000).
Postet den
Average Member
SiSL
Innlegg: 671
671
Postet den
Retired Support Moderator
MarcelG
Innlegg: 2625
2625
I knew it was floating around somewhere! bigsmile Thanks!
edit Move completed! Now updating the forum counts.
Postet den
Average Member
SiSL
Innlegg: 671
671
Originally posted by MarcelG Now updating the forum counts.

Heh, suprised you even posted in it :P

May patience of the prophets be with you on updating counts if you have huge number of posts. Without Rui, I would not have such opportunity to update my counts or archive my posts EVER.
Postet den
Retired Support Moderator
MarcelG
Innlegg: 2625
2625
Updating the counts took less than 4 minutes, so that's pretty ok for nearly 40k posts.
Postet den
Average Member
SiSL
Innlegg: 671
671
Originally posted by MarcelG
Updating the counts took less than 4 minutes, so that's pretty ok for nearly 40k posts.

Lucky you, over 400k here and it either times out server side or client side :p It never ends normally.
Thanks to Rui, supplied me a SQL procedure to ease up pain down to 15 seconds.
 
Du må legge inn en melding