Big Problem (admin account)

[brianjw]

The problem is I don't want to delete an account or posts. I have all the posts I've made except for todays say "Guest" under them. I want to keep those posts and I want it to say I am a member with the image etc. on all the posts.

...
Brianjw

[Thurnok]

IchBin's SQL statement updates the id of the poster to your id.  Basically, if your id is now 1 and the id for guests is 0, then you simply use those values in the SQL statement IchBin provided (within your phpMyAdmin) and it will change all those guest posts to say they are from you.

[akulion]

brilliant query! I must note this one down somewhere