Thread move query

[Lee]

What I am looking to do is, via phpMyAdmin - select all threads, regardless of their current location and move them to node_id = x.

Anybody able to provide me with a query to do this? So I don't have to go in and move all threads manually.


Cheers,
Lee

 

[MattW]

Would this not do what you require? http://xenforo.com/community/resources/digital-point-mass-thread-move.1400/

 

[Paul B]

UPDATE xf_thread
SET node_id = x

 

[Lee]

Would this not do what you require? http://xenforo.com/community/resources/digital-point-mass-thread-move.1400/

Not quite, but looks useful anyway - thanks for the link.

UPDATE xf_thread
SET node_id = x

Thanks Brogan, that did the trick. Is there a way to rebuild user posts counts, as I have moved threads into a section that no longer counts against the post count.

 

[MattW]

Thanks Brogan, that did the trick. Is there a way to rebuild user posts counts, as I have moved threads into a section that no longer counts against the post count.

 

[Paul B]

http://xenforo.com/community/resources/rebuild-user-post-counts-query.363/

 

[MattW]

http://xenforo.com/community/resources/rebuild-user-post-counts-query.363/

So does the Cache rebuild not re-build all the post counts via the ACP then?

 

[Lee]

http://xenforo.com/community/resources/rebuild-user-post-counts-query.363/

Again, thanks Brogan.

So does the Cache rebuild not re-build all the post counts via the ACP then?

Nope, it doesn't.

 

[MattW]

Again, thanks Brogan.


Nope, it doesn't.

That's my education for today then