So in the UPDATE post SET userid='xxx' WHERE username='Old Name'
Does 'Old Name' equal guest? Cause all the deleted posts are listed under "guest"
no if you run that query and put guest as the old name
it will over right all usernames that are set to guest
old name would be for instace if you had a member called "tommy" and deleted him, you could create a new "tommy" member account and run the query so that all of the old "tommy" posts are shown as the new "tommy" account