Text only | Text with Images

TinyPortal

Development => Support => Topic started by: brianjw on January 12, 2007, 06:09:45 PM

Title: Guest Post changing needs to be done!
Post by: brianjw on January 12, 2007, 06:09:45 PM
Some people may know that one of my admins accidentally deleted my account :o 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 :D
Title: Re: Guest Post changing needs to be done!
Post by: IchBin on January 12, 2007, 10:00:56 PM
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. ;)
Title: Re: Guest Post changing needs to be done!
Post by: brianjw on January 12, 2007, 10:04:28 PM
I saw this:
Quote from: Grudge on July 04, 2004, 07:50:43 PM
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?
Title: Re: Guest Post changing needs to be done!
Post by: G6Cad on January 12, 2007, 10:28:58 PM
Also to be found eather on http://www.mysql.com/support/ or on Simplemachines.org DOC section
Title: Re: Guest Post changing needs to be done!
Post by: brianjw on January 12, 2007, 10:42:02 PM
I looked all over smf docs and couldnt find it :(
Title: Re: Guest Post changing needs to be done!
Post by: G6Cad on January 12, 2007, 10:48:02 PM
That was pretty much a very offencive act Brian.
I gave you the best help and support thread ever for you questions.

Title: Re: Guest Post changing needs to be done!
Post by: brianjw on January 12, 2007, 10:52:20 PM
Oh im sorry!  ;)
Title: Re: Guest Post changing needs to be done!
Post by: IchBin on January 13, 2007, 12:28:21 AM
Brian, take a read at this link. If you have phpMyAdmin on your site.

http://www.simplemachines.org/community/index.php?topic=21919.0
Title: Re: Guest Post changing needs to be done!
Post by: brianjw on January 13, 2007, 02:08:35 PM
Thank you IchBin :)
I do use phpmyadmin and that topic was very useful :)

Brianjw
Title: Re: Guest Post changing needs to be done!
Post by: brianjw on January 13, 2007, 02:23:51 PM
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 ???
Title: Re: Guest Post changing needs to be done!
Post by: IchBin on January 15, 2007, 03:52:09 AM
Did you use the right email for the account?
Title: Re: Guest Post changing needs to be done!
Post by: brianjw on January 15, 2007, 01:07:36 PM
Yes. but the weird thing is. The email hasnt changed from guest account to me. So it's very confusing/
Text only | Text with Images