XF 1.1 Mass move specific user threads to specific forum...

[vVv]

I'm assuming, a database query like this, is correct? .. I'd like to mass move all MY threads to a specific forum to sort them out, and then I'll move them back once sorted.

UPDATE xf_thread SET node_id = '<forum desination>' WHERE user_id = '1'

I seen this, but not really looking for a paid resource for what I'm doing lol.
http://xenforo.com/community/resources/sonnb-messages-mass-actions.824

 

[Chris D]

That should do it. You may want to then go to ACP > Tools > Rebuild Caches > Rebuild Forum Information.

 

[vVv]

That should do it. You may want to then go to ACP > Tools > Rebuild Caches > Rebuild Forum Information.

Thanks Chris, I got that "idea" or basic query from this resource listing I had bookmarked forever ago lol.
http://xenforo.com/community/resources/mass-move-deleted-threads-sql-query.856/

 

[vVv]

I'm thinking what I really want, is a way to move a specific user's threads from one node to another node. It would be easier to sort/weed out duplicates and merge if needed .. instead of having thousands of my own messages in one node.. which would make pages and pages to sort through and find things. I know this from FAQ.. just need tweak it, to include "user_id = 1"

 

[vVv]

This is it:

UPDATE xf_thread SET node_id = 'Y' WHERE node_id = 'X' AND user_id = '1'

Is there a way of mass moving a specific user's threads from one forum to another? - Yes!

Replace 'X' with the node ID of the existing forum and 'Y' with the node ID of the new forum, and '1' with user's ID/number. Note that the thread information, forum cache and search index should be rebuilt in the ACP -> Tools -> Rebuild Caches.