Welcome, Guest. Please Login or Register.
August 18, 2025, 11:23:32 PM
Home Help Search Log in Register
News: SMF is the next generation in forum software, almost completely re-written from the ground up, make sure you don't fall for cheap imitations that suffer from feature bloat!

YaBB SE Community  |  English User Help  |  English Help  |  how do I restore a deleted member/user « previous next »
Pages: [1] Reply Ignore Print
Author Topic: how do I restore a deleted member/user  (Read 622 times)
searanch
Noobie
*
Posts: 33
how do I restore a deleted member/user
« on: August 24, 2002, 10:13:50 PM »		 Reply with quote
I had a member delete himself - is their a way as the admin to restore his profile and return his access?
« Last Edit: August 24, 2002, 10:14:48 PM by searanch » Logged
medizinmann
Guest
Re:how do I restore a deleted member/user
« Reply #1 on: August 24, 2002, 10:29:58 PM »		 Reply with quote
he has to register anotherone and you have to change the member id to the old one (with phpmyadmin)!

m.
Logged
searanch
Noobie
*
Posts: 33
Re:how do I restore a deleted member/user
« Reply #2 on: August 24, 2002, 10:34:31 PM »		 Reply with quote
where do I find phpmyadmin?
Logged
mediman
Support Team
YaBB God
*****
Posts: 2858


WWW
Re:how do I restore a deleted member/user
« Reply #3 on: August 24, 2002, 10:50:21 PM »		 Reply with quote
have you a database service tool on your host?
if not install phpmyadmin!

http://www.phpmyadmin.net

mediman
Logged
mainComm Dev Team
David
Destroyer Dave
Global Moderator
YaBB God
*****
Posts: 5761


I'm not a llama!

WWW
Re:how do I restore a deleted member/user
« Reply #4 on: August 25, 2002, 01:54:11 AM »		 Reply with quote
Except that when a member is deleted all their posts are set to being made by a guest.
Logged

Forum-Forum.com, A Forum For Forum Owners and Enthusiasts!
mediman
Support Team
YaBB God
*****
Posts: 2858


WWW
Re:how do I restore a deleted member/user
« Reply #5 on: August 25, 2002, 05:30:59 PM »		 Reply with quote
Quote from: David on August 25, 2002, 01:54:11 AMExcept that when a member is deleted all their posts are set to being made by a guest.

Then all postings with the membername has to change from member id -1 to the old member id! easy with a good script!

mediman
Logged
mainComm Dev Team
Jeff Lewis
Global Moderator
YaBB God
*****
Posts: 10149


I'm a llama!

WWW
Re:how do I restore a deleted member/user
« Reply #6 on: August 26, 2002, 03:18:24 PM »		 Reply with quote
yes it's very easy query, I did it here when I accidently removed my account once :)
Logged

My Amazon Wishlist
My Blog
Ben_S
Disciple of Joe
Support Team
YaBB God
*****
Posts: 1586


I Love YaBB SE!

WWW
Re:how do I restore a deleted member/user
« Reply #7 on: August 26, 2002, 10:55:21 PM »		 Reply with quote
so did I when some idiot deleted himself by accident... Running this in phpmyadmin should do the trick

Code Select
UPDATE yabbse_messages SET id_member = xxx WHERE postername = 'BOB';
Obviously id_member is the member ID number of the person and BOB is the username...

And if it messes up dont blame me...

Oh, you might wanna apply the members cant delete themselves mod too ;)
« Last Edit: August 26, 2002, 11:01:24 PM by Scotty_B » Logged
Jeff Lewis
Global Moderator
YaBB God
*****
Posts: 10149


I'm a llama!

WWW
Re:how do I restore a deleted member/user
« Reply #8 on: August 27, 2002, 02:12:32 PM »		 Reply with quote
Quote from: Scotty_B on August 26, 2002, 10:55:21 PMso did I when some idiot deleted himself by accident...

Hey, what are you saying? ;)
Logged

My Amazon Wishlist
My Blog
charlottezweb
Sr. Member
****
Posts: 446


charlottezweb.com

ICQ - 101387162 WWW
Re:how do I restore a deleted member/user
« Reply #9 on: September 24, 2002, 01:59:35 AM »		 Reply with quote
yay that worked!  thanks

btw, where's this "user's can't delete their accounts" mod that you speak of?   ;)
Logged
"yabb-sense makes the heart grow fonder"
-----------------------------------------------------
Charlottezweb.com
Reliable, well-supported & affordable hosting and design.  Free Yabbse installs.
charlottezweb
Sr. Member
****
Posts: 446


charlottezweb.com

ICQ - 101387162 WWW
Re:how do I restore a deleted member/user
« Reply #10 on: January 20, 2003, 04:35:48 PM »		 Reply with quote
sorry, had to dig this one up again  :)

just to refresh myself, or see if anything has changed since I did this the last time...

I'm going through the members db right now and I can't find the deleted person's entry any more...I thought I had to the find that, and then use that id number and convert their new acct to that number?

Where can I find the old accts' id number?

Or, do i only need to use the id of the new acct with the actual name of the old one?  I'm guessing that's the way to do it?
« Last Edit: January 20, 2003, 04:37:26 PM by maddness » Logged
"yabb-sense makes the heart grow fonder"
-----------------------------------------------------
Charlottezweb.com
Reliable, well-supported & affordable hosting and design.  Free Yabbse installs.
Ben_S
Disciple of Joe
Support Team
YaBB God
*****
Posts: 1586


I Love YaBB SE!

WWW
Re:how do I restore a deleted member/user
« Reply #11 on: January 20, 2003, 07:17:00 PM »		 Reply with quote
find the old id by looking at one of his posts in the db
Logged
charlottezweb
Sr. Member
****
Posts: 446


charlottezweb.com

ICQ - 101387162 WWW
Re:how do I restore a deleted member/user
« Reply #12 on: January 20, 2003, 08:48:47 PM »		 Reply with quote
i found her OLD id and it's -1 according to the db...it's like it doesn't show the original number.

and when i run the query using the number id for the new account she has and her old name, it removed "guest" from her old posts, but when i click on her name, it's says

QuoteThe user whose profile you are trying to view does not exist.

i've done this before, but that was back on 1.3 i think...
Logged
"yabb-sense makes the heart grow fonder"
-----------------------------------------------------
Charlottezweb.com
Reliable, well-supported & affordable hosting and design.  Free Yabbse installs.
Pages: [1] Reply Ignore Print 
YaBB SE Community  |  English User Help  |  English Help  |  how do I restore a deleted member/user « previous - next »
 


Powered by MySQL Powered by PHP YaBB SE Community | Powered by YaBB SE
© 2001-2003, YaBB SE Dev Team. All Rights Reserved.
SMF 2.1.4 © 2023, Simple Machines
 Valid XHTML 1.0! Valid CSS

Page created in 0.034 seconds with 21 queries.