SQL Query Help

[IceBurn3000]

One of my Administrators had a lovers tiff with one of my active members and deleted their account.

Using phpMyAdmin, I have successfully restored this user's account, but obviously, all her threads are no longer linked to her account.

Is there an SQL Query I can run on the "user" table to find all posts by the username (lets say its "user101") which is still stored in the "username" column and change the "userid" from 0 (which i assume vBulletin does when an account is deleted) to 9 ?

Just on a side note the "userid" and "username" in the "threads" table still show the correct info, so she still has threads attached to her username, just no posts.

Thanks in advance,

[Hellcat]

The "username" value is still the correct one, but the "userid" is not?
The "user" table has not much to do with the posts....

Or is both still corretctly set for the old username (like you say later)?

If so, sou can just change the userid back to the original one (using PhpMyAdmin or such) and then run a "Update Postcounts" from the AdminCP....

[IceBurn3000]

My bad. I meant the "post" table, not the "users" table. Yesterday was too long a day.

In the "post" table it appears that it keeps the record of the "username" when you delete a user and not their posts, but makes the "userid" 0 so it won't link to a non-existant profile. What I want to do, if possible, is to run an SQL Query on the "post" table to find all records with a specific username (eg. user101) and change the "userid" for each of those records to 9.

I could do this manually with phpMyAdmin, but there's over 1000 posts, so I am hoping there is an SQL Query that can do this.

Thanks for trying to help with the wrong info I provided, Hellcat :P I just hope you or someone can help me now with the correct info.

[Paul M]

UPDATE post SET userid = 123 WHERE username='MemberName' ;

[IceBurn3000]

Originally Posted by Paul M

UPDATE post SET userid = 123 WHERE username='MemberName' ;

:banana: Legendary. Works like a charm.

Thankyou very much! It is greatly appreciated.