Possible to reactivate a deactivated user ?

Client Joined: Dec 04, 2004 Posts: 757

Hello all, some time ago I deactivated one of my users and was wondering if its possible to reactivate them? all their topics / posts are still in place.
Thanks all
mrix

Posted: Tue Feb 15, 2011 9:09 am

Unless there is some other more elegant way:

In the user table, select the user in question in the DB, locate "user_level" and change it to "1" and "user_active" change it to "1". The only problem is that the username will remain "Deactivated User".

Edit: "username" should be "Real Name".

Posted: Tue Feb 15, 2011 9:54 am

Thanks for a solution, unfortunately with 10,000+ members is will be very difficult to locate the username, unless there is some kind of search system?
Thanks
mrix

Posted: Tue Feb 15, 2011 10:00 am

Using PHPMYAdmin, bring up your DB and click on the "Search" tab. Enter the username, then from the dropdown list, select the "users" table, then click GO.

Posted: Tue Feb 15, 2011 10:04 am

Fantastic! and big thanks.
mrix

Posted: Tue Feb 15, 2011 10:12 am

mrix wrote:

Fantastic! and big thanks.
mrix

I assume "success"?

Dance-Y

Posted: Tue Feb 15, 2011 10:27 am

Hi there, yes worked totally fine.
Thanks
mrix

Posted: Tue Feb 15, 2011 10:30 am

Maybe a "Reactivate User" button?! Something for the "back burner" as I can't remember ever reactivating a user.

Cheers

Posted: Tue Feb 15, 2011 11:25 am

If there is a possibility of reactivating a user he should only be suspended. The only point of "deactivating" a user is so that his/her email is banned. I am currently working on YA and looking at removing the "deactivate" option. it really servers no purpose. I figure when deleting a user we will ask if the username and email should be added to the ban list.

Posted: Tue Feb 15, 2011 1:00 pm

Whatever it takes to permanently disallow access, I'm all for it, no matter the method. "Suspending" a user only allows for the suspend period to expire after which the user can simply carry on with whatever activity that caused the suspension. I never believed in "suspension" for that reason. They're either gone or not.

Cheers, thanks for the efforts.

Posted: Tue Feb 15, 2011 1:17 pm

We do not have time based suspensions. Suspension in the terms that I am using it is essentially deactivation in the normal sense.

Posted: Tue Feb 15, 2011 1:22 pm

Ok, but I think of being suspended like being suspended for three days at school. Smile

But in that case, we need to arrive at a single term of usage to effect termination of account. Such as, "Your Account Has Been Terminated" not suspended or deactivated, IMHO of course.

Posted: Tue Feb 15, 2011 3:17 pm

Quote:

. I am currently working on YA and looking at removing the "deactivate" option. it really servers no purpose

That would be a great improvement Palbin. Just a single delete function would be fine. While you are in there ( Smile

) if you could find a way to distinguish between a waiting user who has been approved and awaiting activation from one who is pending approval it would be a great service. I think we need some kind of field in users_temp that indicates date of approval and then some fixes to the waiting content box and the waiting users tab of YA to let us know which users are waiting approval versus those who just haven't responded to activation email.

Posted: Tue Feb 15, 2011 3:25 pm

Good suggestion. As it stands now I have to go to "Resend Email" to delete a pending activation rather than use "Deny" in the "Edit Users" menu with some sort of reason why their applicaiton is no longer pending.

I get a large number of "pending" users that don't follow directions to respond to the activation email.

Posted: Tue Feb 15, 2011 4:01 pm

My fellow admin and I on my site use a "pending users" block that is only visible to admins. We stick it center down. Each time we approve a user we go in and stick their username and the date and our initials. When they activate or if they fail to do so and get deleted we go in and update the block. This would be a p.i.t.a. if you got a lot of pending users but we don't and it's better than approving them two or three times cause you forget which ones you approved and which you didn't. Having this function "automated" through RNYA would be great. I'll defer to Palbin on how to do this but I think it will require a table change or two in order to store the status data.

Posted: Tue Feb 15, 2011 4:23 pm

Ooo .. where is that block?? Wink

Edit: Found one but appears Drupal only. Is there one for RN?

Posted: Wed Feb 16, 2011 6:42 am

I just created my own block, named it "approved users", made it visible to admins only and I use the block editor to keep it up to date.

Posted: Tue Apr 05, 2011 6:07 pm

fkelly wrote:

I just created my own block, named it "approved users", made it visible to admins only and I use the block editor to keep it up to date.

care to share? Wink

Posted: Tue Apr 05, 2011 6:28 pm

myrtletrees wrote:

care to share? Wink

Ditto!!

Posted: Tue Apr 05, 2011 8:33 pm

Not really much to share. You just go into the ACP and open up the blocks editor. Create a new block. Make it admin only. I position it center down as far down as I can. Whenever you get a new waiting user you go in and edit the block and put in the username and the date and, on my site the initials of the admin who approves the user. Separately you approve the user through RNYA. Then when the user activates his/her username you erase them from the block. Likewise, if the user never gets around to activating their username eventually they will get deleted from waiting users. In that case you also delete them from the block. You can call the block anything you want -- I use "users approved" but it doesn't matter what the name of it is.

This comes in handy when you have more than one admin approving waiting users.