Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Community Forums
 Community Discussions (All other subjects)
 move all topics from one forum to another		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

MarcelG
Retired Support Moderator

Netherlands
2625 Posts
Posted - 20 April 2009 :  08:24:39  Show Profile  Visit MarcelG's Homepage  Reply with Quote
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?
portfolio - linkshrinker - oxle - twitter

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 20 April 2009 :  08:35:07  Show Profile  Send ruirib a Yahoo! Message  Reply with Quote
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...

Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

MarcelG
Retired Support Moderator

Netherlands
2625 Posts
Posted - 20 April 2009 :  08:43:53  Show Profile  Visit MarcelG's Homepage  Reply with Quote
I'm using SQL (2000).
portfolio - linkshrinker - oxle - twitter
Go to Top of Page

SiSL
Average Member

Turkey
671 Posts
Posted - 20 April 2009 :  08:48:47  Show Profile  Visit SiSL's Homepage  Reply with Quote
Check out my signature

http://forum.snitz.com/forum/topic.asp?TOPIC_ID=64453
CHIP Online Forum

My Mods
Select All Code | Fix a vulnerability for your private messages | Avatar Categories W/ Avatar Gallery Mod | Complaint Manager
Admin Level Revisited | Merge Forums | No More Nested Quotes Mod
Edited by - SiSL on 20 April 2009 08:50:03
Go to Top of Page

MarcelG
Retired Support Moderator

Netherlands
2625 Posts
Posted - 20 April 2009 :  09:04:19  Show Profile  Visit MarcelG's Homepage  Reply with Quote
I knew it was floating around somewhere! Thanks!

edit
Move completed!
Now updating the forum counts.
portfolio - linkshrinker - oxle - twitter
Edited by - MarcelG on 20 April 2009 09:10:02
Go to Top of Page

SiSL
Average Member

Turkey
671 Posts
Posted - 20 April 2009 :  09:26:44  Show Profile  Visit SiSL's Homepage  Reply with Quote
quote:
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.
CHIP Online Forum

My Mods
Select All Code | Fix a vulnerability for your private messages | Avatar Categories W/ Avatar Gallery Mod | Complaint Manager
Admin Level Revisited | Merge Forums | No More Nested Quotes Mod
Edited by - SiSL on 20 April 2009 09:30:40
Go to Top of Page

MarcelG
Retired Support Moderator

Netherlands
2625 Posts
Posted - 20 April 2009 :  09:39:24  Show Profile  Visit MarcelG's Homepage  Reply with Quote
Updating the counts took less than 4 minutes, so that's pretty ok for nearly 40k posts.
portfolio - linkshrinker - oxle - twitter
Go to Top of Page

SiSL
Average Member

Turkey
671 Posts
Posted - 20 April 2009 :  10:14:36  Show Profile  Visit SiSL's Homepage  Reply with Quote
quote:
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.
CHIP Online Forum

My Mods
Select All Code | Fix a vulnerability for your private messages | Avatar Categories W/ Avatar Gallery Mod | Complaint Manager
Admin Level Revisited | Merge Forums | No More Nested Quotes Mod
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.18 seconds. Powered By: Snitz Forums 2000 Version 3.4.07