Ok here is my question one of my administrators has deleted one of my members, and since then I have added that member back with the exact same username, but my question is how do I change all of his previous posts that he made back to senior member or whatever because at this time they all say guest?

Thanks in advance for all of your help

I personally don't know how to do it, but I'm sure an SQL Query can be ran to do it.

I have done this a few times, you have to manually run a query to do this.

I think KuraFire helped me back then, I will poke him to read this thread.

Thank you very much... :p

i think youd be required to change his userid to match the old one..

i think youd be required to change his userid to match the old one..
This would by far be the easiest solution, yep.

Just change his userid in the user table back to his old id.
If you don't know his old userid anymore, see if it still exists in the post table in threads where you have posts of his.

I can't find out what member # he was before he was deleted... :*(

I'm really sorry to bother you guys with this crazy problem but I just can't seem to figure out a way to fix this...

EDIT: I found his old user id# but now how do I go in and change his new id# to the old one?

Use phpMyAdmin (or similar) to open your database. Find the User table, use Select to search for the User's name, then edit the appropriate record to change the userid field to the old one. Save it, then update your counters in vbulletin.