MyBB Community Forums

MyBB Community Forums > Community Archive > Archived Forums > Archived Development and Support > MyBB 1.2 Series > MyBB 1.2 General Support > User management options
Full Version: User management options
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

bacanak

2005-12-27, 06:24 PM
I searched the forum but cannot find so my question is:

Is there a way I can mass move or mass delete registered users and or users awating email confirmation?

Or can you please write me the SQL codes for the fallowing operations please!

Move registered users with 100 messages to this usergroup for exaple moderators?

delete all registered users with 0 messages?

Delete all awating email confirmation?

laie_techie

2005-12-27, 08:42 PM
Most of that information is stored in {PREFIX}users. Here are the relavent fields: uid, username, postnum (number of posts), usergroup, additionalgroups, displaygroup (check {PREFIX}usergroups for the IDs), regdate. Users awaiting activation are found in {PREFIX}awaitingactivation. {PREFIX} is mybb_ by default.

If you delete all users with zero posts, please also specify a regdate, say a 2 week grace period.
MyBB Community Forums > Community Archive > Archived Forums > Archived Development and Support > MyBB 1.2 Series > MyBB 1.2 General Support > User management options