Announcement

Collapse
No announcement yet.

Relink Delete User posts to current user, sorta kinda

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Relink Delete User posts to current user, sorta kinda

    I'm looking for a way to re-connect posts and threads made by a deleted user with a currently active user.

    I'm assuming it can be done through 1-2 SQL querries, but don't know the syntax.

    Thanks!
    Bob Hubbard
    WebMaster, SilverStar WebDesigns Inc.

  • #2
    UPDATE post SET userid='xxx' WHRE username='Old Name'

    ...with 'xxx' being the new userid number and 'Old Name' being the username on those posts.

    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

    Loading...
    Working...
    X