"Force reactivation" for all users.

King Rhyono · Post by **King Rhyono** » Fri Jan 07, 2011 7:05 pm

In phpMyAdmin go to the SQL tab to enter code and enter this

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.

robra · Post by **robra** » Sat Mar 05, 2011 4:09 pm

It coulb be called "Force reactivate mass" or "Mass reactivation".

ddejc · Post by **ddejc** » Tue Nov 29, 2011 3:07 am

King Rhyono does SET `user_type` = '1' mean that users will become inactive until they will reactivate their user account over email?

robra · Post by **robra** » Thu Oct 30, 2014 9:26 pm

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.

advertisements