Announcement

Collapse
No announcement yet.

Deleted a user but want them back

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

  • vijayninel
    replied
    Originally posted by borbole View Post
    I don''t think that does work for the posts of deleted users. At least from what I could see at that mod''s description thread.
    I am talking about this mod http://www.vbulletin.org/forum/showt...ghlight=Change

    Leave a comment:


  • borbole
    replied
    Originally posted by vijayninel View Post
    If the number of posts are less then you can do it with the change posts owner mod available at vb.org
    I don''t think that does work for the posts of deleted users. At least from what I could see at that mod''s description thread.

    Leave a comment:


  • vijayninel
    replied
    If the number of posts are less then you can do it with the change posts owner mod available at vb.org

    Leave a comment:


  • borbole
    replied
    Originally posted by WurkAnimal View Post
    Thanks for your reply.

    Anyway I could merge these threads/post to his new account?
    Yes you can. It will take a couple of queries. Run them at the SQL tab in the phpmyadmin and change the fields to match your version as they are from the vb 4 version which I use.

    Anyway, after you have registered the user again to reassign all his/her posts back run this query:

    Code:
    UPDATE post SET userid = 'newuserid' WHERE username = 'oldusernameofdeleteduser';
    To reassingn all his/her threads back, run the following query:

    Code:
    UPDATE thread SET postuserid = 'newuserid' WHERE postusername =  'oldusernameofdeleteduser';
    If your db tables have a prefix, include it in your queries and replace the newuserid and oldusernameofdeleteduser accordingly.

    Let me know how it will go.

    Leave a comment:


  • borbole
    replied
    Originally posted by thinkfast View Post
    i have same problem too, but i use VB4

    it came out like this
    #1054 - Unknown column 'postuserid' in 'where clause'

    can you help me please
    Have a look at my mod. It does just that.

    http://www.vbulletin.org/forum/showthread.php?t=236861

    Leave a comment:


  • thinkfast
    replied
    i have same problem too, but i use VB4

    it came out like this
    #1054 - Unknown column 'postuserid' in 'where clause'

    can you help me please

    Leave a comment:


  • WurkAnimal
    replied
    Thanks for your reply.

    Anyway I could merge these threads/post to his new account?
    Last edited by WurkAnimal; Sat 30th Jan '10, 4:07pm.

    Leave a comment:


  • BBR-APBT
    replied
    Not unless you had a SQL backup to retrieve his account from.
    Once you deleted the account it was gone.

    Leave a comment:


  • WurkAnimal
    started a topic Deleted a user but want them back

    Deleted a user but want them back

    Hi there.

    I deleted a user from my forum due to the member being very argumentative. We have sorted this issue out now and I would like the member to come back on the forum. I have deleted his account but the posts/threads are still in the forum.

    Anyway possible I can get his account back? if not, merge his threads/posts with his new account?

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