I have a number of users that need to be activated - I selected activate by Admin and never received email notification.

What needs to be done directly in the xoops_users table to activate these users? I'd like to just execute a single SQL query and do it in bulk.

I'm on XOOPS 2.0.x.

cheers,
-Robert

I only have XOOPS 2.2.4 installed, but I think it works the same way in 2.0.x.

You need to change the column users.level from 0 to 1 for those users. I suggest testing it on one user first.

Note that this will not send an email to the user telling him that he's activated.

To do it with a single query, you would need to provide a WHERE-condition, such as a range or list of user IDs, or a range of registration dates.

Or if you wanted to activate everyone who's inactivated, you could use this query, where xxxx is your table prefix: (backup your database first)

Excellent - after I posted my message here I noticed the Level field incremented to 1 after I activated a user. Appreciate the confirmation and the SQL syntax.

Cheers,
-Robert