Page 2 of 2

Re: "Force reactivation" for all users.

Posted: Fri Jan 07, 2011 7:05 pm
by King Rhyono
In phpMyAdmin go to the SQL tab to enter code and enter this

Code: Select all

UPDATE  `DATABASE_NAME`.`phpbb_users` SET  `user_type` =  '1' WHERE  `phpbb_users`.`user_id` != 2 AND user_type != 2;
Change DATABASE_NAME to the name of the db your forum is in. This will also not deactivate user 2 (should be you) and won't deactivate bots.

Re: "Force reactivation" for all users.

Posted: Sat Mar 05, 2011 4:09 pm
by robra
It coulb be called "Force reactivate mass" or "Mass reactivation". ;)

Re: "Force reactivation" for all users.

Posted: Tue Nov 29, 2011 3:07 am
by ddejc
King Rhyono does SET `user_type` = '1' mean that users will become inactive until they will reactivate their user account over email?

Re: "Force reactivation" for all users.

Posted: Thu Oct 30, 2014 9:26 pm
by robra
Hi guys.
Sorry to delay after many past time since I open this thread but only now I needed to return this issue and now my doubt is small.
I did what the King Rhyono said and the test user has deactivated, but when I tried generate a new reactivation link, a message appears saying that I cannot do that because my register was deactivated manually an only administrator could activate it. I change too the user_inactive_reason field of 1 to 0 but this not worked. I only need to solve the issue of get the reativation link when the users are deactivated by SQL.
Any idea how to do that?

Thanks.