How to copy a user? Or move posts to a different username?

[oldford]

I have an odd situation where I need to split up a user into two accounts. Some posts need to stay with the old account and some with the new.

Is there a way (through phpMyAdmin I'm guessing) to duplicate a user? I could then go back and delete the posts for each.

Or is there a way to move posts from one account to another?

Thanks!

[blind-eddie]

No way to do what you are after that I am aware of.

You can however create another account.
Install Change Threads/Posts Owner/Date for vB3.8 (https://vborg.vbsupport.ru/showthread.php?t=200952&highlight=change+owner) read description, instructions change all the threads/post you want in the new accounts name.
Have fun!

[Dave]

You can use the "Merge Users" functionality in the admincp (which will move all data to the other account) or update the thread/post table in the database manually.

Thead table needs the postuserid and postusername changed and the post table needs the userid and username changed.

[blind-eddie]

Merging accounts wont do what he/she is wanting to do, he/she wants to more or less split an account and move some data, not all.

[AnonymousHC]

Might have to use the database & copy all the users posts to the new user on phpmyadmin or navicat.

[oldford]

You can however create another account.
Install Change Threads/Posts Owner/Date for vB3.8 (https://vborg.vbsupport.ru/showthread.php?t=200952&highlight=change+owner) read description, instructions change all the threads/post you want in the new accounts name.
Have fun!
Excellent! That works perfectly. Thanks!

I did search for a mod, but I guess I wasn't using the right search terms. :o