Query to move all topics from board A to board B

Started by Biology Forums, May 15, 2014, 09:08:14 PM

Previous topic - Next topic

Biology Forums

Hey everyone, I would like to move all the topics found in board 61 into board 10, but I don't want to move 40 at a time (the messageindex limit) - takes far too long. Can someone provide a query that I can use in PHPmyadmin that will make this request in one shot?

Side note: All of these topics being moved have no replies.

Shambles

Is this a programmatic requirement or one-off exercise within SMF 2.0.*? If the latter, you could use the supplied Admin controls to move topics from one board to another.

Admin > Maintenance > Forum Maintenance > Topics > Move Topics...

Illori

Quote from: Shambles on May 16, 2014, 04:53:09 AM
Is this a programmatic requirement or one-off exercise within SMF 2.0.*? If the latter, you could use the supplied Admin controls to move topics from one board to another.

Admin > Maintenance > Forum Maintenance > Topics > Move Topics...


i believe that Liam still uses 1.1.* where this does not exist.

Biology Forums

Quote from: Illori on May 16, 2014, 05:29:55 AM
Quote from: Shambles on May 16, 2014, 04:53:09 AM
Is this a programmatic requirement or one-off exercise within SMF 2.0.*? If the latter, you could use the supplied Admin controls to move topics from one board to another.

Admin > Maintenance > Forum Maintenance > Topics > Move Topics...


i believe that Liam still uses 1.1.* where this does not exist.

Cool feature, and yes it's for 1.x.

I'll look @ the code and see what I can make from it.

Advertisement: