Backup your database first to be safe. 1) Query the DB to see how many members will allow the Admin to send them bulk emails. SELECT COUNT(*) FROM w3t_Users WHERE U_AdminEmails='On'
2) Query to set all users to the default aged threads to be displayed (what is set per forum as that forum's default). UPDATE w3t_Users
SET U_ActiveThread = "999"
3) Query to set all users to the default parent posts per page shown. UPDATE w3t_Users
SET U_PostsPer = "10"
4) Query to set all users to the default total posts per page shown (when in flat mode). UPDATE w3t_Users
SET U_FlatPosts = "10"
5) Query to allow all members to receive email from admins. UPDATE w3t_Users SET U_AdminEmails = 'On' WHERE U_Number > 1
6) Query to set all members to receive an email notification when they receive a private message. UPDATE w3t_Users
SET U_Notify = 'On'
7) Query to change the displayed date that a post was made. UPDATE w3t_Posts SET B_Posted = UNIX_TIMESTAMP('2003-06-14 20:05:00') WHERE B_Number = 123456
Note: Depending on whether it's the last post in a thread or board, you'd have to do similar updates for the main post in the thread and the board that contains the thread.
8) Query to make ALL forums members only. UPDATE w3t_Boards
SET Bo_Read_Perm = '-1-2-3-', Bo_Write_Perm = '-1-2-3-', Bo_Reply_Perm = '-1-2-3-'
"But if you have any boards that are only supposed to be accessible to admins, mods or other special groups, their permissions would get reset, unless you add an appropriate WHERE clause. "
9) Query to delete all users that have not logged-in since they registered. Submitted by Akd96
DELETE FROM w3t_Users WHERE `U_Laston` = `U_Registered`
10) Query to Update All Users to use the default stylesheet that you've defined in the Theme file Submitted by JoshPet
UPDATE w3t_Users
SET U_StyleSheet = 'usedefault'
11) Query to manually approve a user if the user hasn't verified the account yet. UPDATE w3t_Users SET U_Approved='yes' WHERE U_Username='whatever'
(whatever would be the username)
Thanks to all who have posted these in the past. (Dave_L, Rick, me, etc...
) and to Mr.CSS for the idea.