1 reply to this topic

[Golden Legacy]

What is the easiest way this can be done? The thread in question on my forum has 5500+ pages (it is actually several smaller topics merged together), and we have been trying to figure out a way to break it up into smaller entities.

I know that you can go and select posts manually, one by one, and split them off into newer threads, but there has to be a more efficient way to do this. (We're literally talking about 70,000+ replies.)

Any help would be so appreciated, thank you.

Edited by Golden Legacy, 19 April 2010 - 02:25 AM.

[Aloha]

Since no one answers here.

You can actually create new topics and then change the post record to one of the new topic numbers. I am using 8 topics for 80k records but you can of course make it what you like.

Let's say you have 80,000 replies for that thread and you create 7 associated topics so now there are 8 topics for the content.

you can run 9 sql queries in sql toolbox in acp or phpMyadmin in cpanel. You will need to know the old topicid and the 9 new topicids.

update ibf_posts set topic_id=newtopicid7 where topic_id=oldtopicid order by pid desc LIMIT 10000  ;
update ibf_posts set topic_id=newtopicid6 where topic_id=oldtopicid order by pid desc LIMIT 10000  ;
update ibf_posts set topic_id=newtopicid5 where topic_id=oldtopicid order by pid desc LIMIT 10000  ;
update ibf_posts set topic_id=newtopicid4 where topic_id=oldtopicid order by pid desc LIMIT 10000  ;
update ibf_posts set topic_id=newtopicid3 where topic_id=oldtopicid order by pid desc LIMIT 10000  ;
update ibf_posts set topic_id=newtopicid2 where topic_id=oldtopicid order by pid desc LIMIT 10000  ;
update ibf_posts set topic_id=newtopicid1 where topic_id=oldtopicid order by pid desc LIMIT 10000  ;

Always backup your database (or at least the posts table) before using sql commands.

Edited by Aloha, 19 April 2010 - 06:20 PM.