"Force reactivation" for all users.

[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.

[robra]

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

[ddejc]

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

[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.