Is there a way to return deleted users?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Assim
    Senior Member
    • Oct 2006
    • 336
    • 3.8.x

    Is there a way to return deleted users?

    I know there isn't an official way but is there a way to return a user who I know his user ID and I know the name he used to have before his posts are shown as guest?

    Well, how can I create a new user with ID 125 and give him his old name back, and at the same time, I want to assign all his posts back to that user.
  • Steve Machol
    Former Customer Support Manager
    • Jul 2000
    • 154488

    #2
    Add a new user then run this query:

    UPDATE post SET userid='xxx' WHERE username='Old Name';

    ...with 'xxx' being the userid number of his new account and 'Old Name' being the username on his old account.

    Then rebuild the thread and forum counters in that order:

    Admin CP -> Maintenance -> Update Counters
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment

    widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
    Working...