SQL Query

[Ozzy47]

Anyone have a query I can run in the DB that would change all forum posts and threads of user X to userY?

 

[puertoblack2003]

Anyone have a query I can run in the DB that would change all forum posts and threads of user X to userY?

UPDATE database name SET settings = REPLACE(value,'old','new');

 

[puertoblack2003]

so you know that info was given to me when i had to change from old domain to new. I assume same concept will work

 

[briansol]

The admin panel has a merge users option... might be what you are looking for.

 

[Ozzy47]

The admin panel has a merge users option... might be what you are looking for.

No, I only need the posts and threads transfer, nothing else.

 

[Ozzy47]

UPDATE database name SET settings = REPLACE(value,'old','new');

That may be a bit too generic for my use case.

 

[Seeker-Smith]

Can't you just change the username? I'd think xenforo on cleanup would do that.

 

[Ozzy47]

That’s not what the client wants. They want user X to stay the same except that their posts and threads get assigned to user Y.

 

[Seeker-Smith]

Ohhhh, that may be a challenge.

 

[Seeker-Smith]

Merge to user Y create new user X

 

[Ozzy47]

That would change to original persons id#

 

[Seeker-Smith]

Yup. I'm running out of suggestions. What about create user Y batch update?

 

[Rhodium]

What about:

UPDATE xf_post SET user_id = xxxxxx WHERE username ='xxxxxx';

UPDATE xf_thread SET user_id = xxxxxx WHERE username ='xxxxxx';

I use to restore deleted users, a rebuilt search/post count is needed.

 

[Ozzy47]

Any repercussions using those?

 

[Rhodium]

I didn't see any issue in my board, but you can test in a backup to be sure.

 

[briansol]

things like post counts, titles, promotions from having x posts, etc will all be out of wack.. there's a lot more to update i think

 

[Ozzy47]

I’d think rebuilding the proper caches would solve that.

 

[Mr Lucky]

Not quite the same but the query here:

XF 2.1 - Possible to reinstate a deleted account

We have someone who requested an account deletion, which they got and were warned it is final, but now want to rejoin. Is it possible to undelete the deleted account? OR If they rejoin , is it possible to merge their deleted account so their old posts get connected to the reopened account...

xenforo.com

Might be adapted

 

[Ozzy47]

All seems like a giant pain in the butt.

 

[Itworx4me]

Maybe this might work

Unmaintained - Change Content Owner or Date

Change Content Owner or Date for XenForo 2.0.10+ Description This add-on allows you to change the owner of content or the timestamp content. Requirements PHP 7.1.0+ Options Change content owner NameDescription Default time interval...

xenforo.com