WEB Vbulletin user info

Discussion in 'OT Technology' started by jeff2577, Apr 2, 2010.

  1. jeff2577

    jeff2577 OT OG

    Joined:
    Jul 30, 2001
    Messages:
    2,711
    Likes Received:
    4
    Location:
    Seattle/Bellevue
    Generic question on users.

    1) User ABC had 4,000 posts over x amount of time
    2) Moderators delete user account ABC
    3) Moderators allow ABC back on the forum
    4) ABC signs up again with the same user account


    Is there any way to re-associate any of the previous data?
     
  2. kingtoad

    kingtoad OT Supporter

    Joined:
    Sep 2, 2003
    Messages:
    55,923
    Likes Received:
    11
    Location:
    Los Angeles
    Not if the data was actually deleted from the database. However, if Vbulletin doesn't delete data (Just updates the info so it's not usable), then programmatically, yes it's possible. But does Vbulletin support that? I would not know.
     
  3. Insert Tokens

    Insert Tokens Making Cancer My Bitch OT Supporter

    Joined:
    Jan 12, 2006
    Messages:
    8,329
    Likes Received:
    75
    Location:
    Tasmania
    From memory vB "moves" posts of a deleted user to a specific "deleted user" account of sorts. If there's been other deleted users, it'd be hard to just move that specific deleted users posts back to their account.

    I may be wrong, haven't looked at the DB in ages.
     
  4. Naturally Baked

    Naturally Baked Active Member

    Joined:
    Sep 24, 2007
    Messages:
    27,942
    Likes Received:
    0
    Location:
    Detroit, Murder Mitten
    you could just edit his post count.
     
  5. crazybenf

    crazybenf Active Member

    Joined:
    Nov 14, 2001
    Messages:
    15,575
    Likes Received:
    2
    only delete spam accounts.

    ban user group works well on trolls. (along with tachy goes to conventry or whatever its called)
     
  6. jeff2577

    jeff2577 OT OG

    Joined:
    Jul 30, 2001
    Messages:
    2,711
    Likes Received:
    4
    Location:
    Seattle/Bellevue

    It's not the post count, but the way the information is sorted in the search. When you search on the name, nothing comes up in the archives, even though the posts still exist. It just says user "ABC" and labeled as Guest. Basically trying to tie it back in so the information is readily searchable.
     
  7. trev.the.enemy

    trev.the.enemy New Member

    Joined:
    Jun 26, 2006
    Messages:
    10,939
    Likes Received:
    0
    Location:
    Midwest
    Those mods = n00bs
     
  8. cdoyle

    cdoyle I finally changed this!

    Joined:
    Aug 5, 2001
    Messages:
    1,233
    Likes Received:
    0
    You might have to go into the tables and see how VB stores the data.

    My assumption is in the table that the posts/threads are kept, there is a column that says something like 'userid' or something relating the post to the person who posted it.

    So if you could find out what the 'userid' was for his original ID, you could then go to the user table and find his new account and update his ID to match the one you found in the posts table.

    but backup your db before doing anything like that, just incase it screws something up.

    I could be way off on how VB stores the data too, I've never actually looked at the table structure.

    edit... The more I think of it, that might not work.
    when they deleted the user, does it actually delete his ID from the user table?
     
  9. LOLZILLA

    LOLZILLA New Member

    Joined:
    Jul 11, 2004
    Messages:
    97,923
    Likes Received:
    0
    Depends how it's handled.

    So yes and no.
     
  10. LOLZILLA

    LOLZILLA New Member

    Joined:
    Jul 11, 2004
    Messages:
    97,923
    Likes Received:
    0
    Tachy goes to coventry is global ignore.
     
  11. LOLZILLA

    LOLZILLA New Member

    Joined:
    Jul 11, 2004
    Messages:
    97,923
    Likes Received:
    0
    You can merge accounts, so if previous user is there, you can merge with new user.


    Thus all posts/info is still there.
     
  12. LOLZILLA

    LOLZILLA New Member

    Joined:
    Jul 11, 2004
    Messages:
    97,923
    Likes Received:
    0
    LMK if you need help, I've been managing VB forums for 8 years now.
     
  13. LOLZILLA

    LOLZILLA New Member

    Joined:
    Jul 11, 2004
    Messages:
    97,923
    Likes Received:
    0
    The origin of this phrase is pretty cool, btw. :o

    It's a British term.
     
  14. retorq

    retorq What up bitch??

    Joined:
    Dec 14, 2006
    Messages:
    6,061
    Likes Received:
    0
    Location:
    Mohave Desert
    I've done this 1000s of times on PHPBB. You just alter the user ID on the posts in question thru an SQL query.
     
  15. HYBR|D

    HYBR|D Beep Beeeeee'p

    Joined:
    May 5, 2006
    Messages:
    2,009
    Likes Received:
    0
    Location:
    Ozz
    why do your moderators have ability's to delete user accounts? they would have to have administrator access to do that?

    anyhow if you have a previous DB backup from when the user still had access to the account prior to the deletion or even a backup when the account still existed then create a fresh DB, import the old DB backup.

    and copy the relevant table/s into the live DB that the forums are using via phpMYAdmin.

    then merge the old account with the new account and depended on your version of VB you may need to run the re-index stuff after the merge.
     

Share This Page