How to assign deleted user posts to new member?

[Ricardo Torrent]

Hello,

I made a mistake and deleted one of my moderators user account instead of removing him from the group. He has re-registered with a new username. 
Is there any way to assign his old posts to this new account?

I would have no problem in editing mysql tables if someone explains it enough

 

[Aaron M]

I believe if it's deleted it is gone for good, hence the differentiation between hiding and deletion.

[pisaldi]

What do you want ? The counter or the post name assignement?

If it is the counter you can modify manually

Users --> Users --> name of user --> Account information --> Content items

If it is the second option you should know the name which has been assigned once the old user was deleted and you will have to do a manually query

 

 

[W4L]

hmm i searched this up aswell and could only find an outdated tutorial on how to do it .

http://www.invisionize.eu/Invision-Resources-Articles/0530-Tips-and-Tricks-gt-Rebuilding-a-deleted-user-account-if-posts-are-intact-using-phpMyAdmin.html

does anyone have an updated tutorial?

[wmarcy]

Might try Jose's Change Author plugin.

[ABGenc]

There is a kb for this but written for IPB 3+ . Need to be checked for use in IPS4

https://www.invisionpower.com/support/kb/_/changing-post-authors-r48