Guest Post changing needs to be done!

[brianjw]

Some people may know that one of my admins accidentally deleted my account But thats fixed
My posts are still there except now they show:
admin
Guest
under each post i made b4 it was deleted.

Is there someway I could make this guest post be a real post from me showing my avatar my email, my website, my im, my online status, etc.

Thanks.
Brianjw

[IchBin]

This thread should have all the info you need.
http://www.simplemachines.org/community/index.php?topic=13451.0

Of course, had you searched SMF you would have found that out.

[brianjw]

I saw this:

They will have to register I'm afraid. You can however attribute all their posts back to them with a SQL command. When they reregister find out their ID_MEMBER and then run a query like this:

UPDATE smf_messages SET ID_MEMBER = *THEIR_ID_MEMBER_HERE* WHERE posterEmail = '*THEIR OLD EMAIL ADDRESS*'

But how do you run a query?

[G6Cad]

Also to be found eather on http://www.mysql.com/support/ or on Simplemachines.org DOC section

[brianjw]

I looked all over smf docs and couldnt find it

[G6Cad]

That was pretty much a very offencive act Brian.
I gave you the best help and support thread ever for you questions.

[brianjw]

Oh im sorry! 

[IchBin]

Brian, take a read at this link. If you have phpMyAdmin on your site.

http://www.simplemachines.org/community/index.php?topic=21919.0

[brianjw]

Thank you IchBin
I do use phpmyadmin and that topic was very useful

Brianjw

[brianjw]

I got a message that said this:
UPDATE smf_messages SET ID_MEMBER =1 WHERE posterEmail = 'brianjw@verizon.net'
was successful except it still shows the Guest Posts