SMF Support > SMF 1.1.x Support

A user deleted himself accidentally

(1/5) > >>

NukeWorker.com:
With the OLD Yabb.pl, they could just sign back up under the old user name, and poof, all the messages were re-atributed to that users.

I have a user that was the #1 poster, over 3000 messages posted.  I would like to get them their user account back, co 3,000 messages don't say guest.  What can I do?

[Unknown]:
It's actually not that hard.  What you do is find the new ID_MEMBER for this user.  To do this, find a link to their profile, and check what the link goes to.  For example, my profile is at:

http://www.simplemachines.org/community/index.php?action=profile;u=2

That "u=2" part is what you are looking for.  Once you have the number, you can reattribute posts with a query in phpMyAdmin.

UPDATE yabbse_messages
SET ID_MEMBER = their new ID_MEMBER
WHERE posterEmail = 'the email they had';

So, if I had deleted myself I would do this:

UPDATE yabbse_messages
SET ID_MEMBER = 2
WHERE posterEmail = 'unknown@simplemachines.org';

-[Unknown]

NukeWorker.com:

--- Quote from: [Unknown] on January 12, 2004, 10:27:13 PM ---So, if I had deleted myself I would do this:

UPDATE yabbse_messages
SET ID_MEMBER = 2
WHERE posterEmail = 'unknown@simplemachines.org';

-[Unknown]

--- End quote ---

Thank you.  This would be a great one for a faq.

nil:
Someone with over 3000 posts of experience deleted them selves?  Shouldn't they know better than to do that?

Tilton53:
Lol that funny!

Navigation

[0] Message Index

[#] Next page