Previous Thread
Next Thread
Print Thread
Rate Thread
Joined: Nov 2001
Posts: 10,369
I type Like navaho
I type Like navaho
Joined: Nov 2001
Posts: 10,369
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.



Last edited by JoshPet; 09/11/2003 11:49 AM.
Sponsored Links
Entire Thread
Subject Posted By Posted
Useful MySQL Queries for UBB.Threads JoshPet 09/11/2003 9:25 AM
Re: Useful MySQL Queries for UBB.Threads AllenAyres 04/03/2007 7:56 PM
Re: Useful MySQL Queries for UBB.Threads Ian_W 05/05/2007 10:49 AM
Re: Useful MySQL Queries for UBB.Threads Beentheredonethat 09/27/2003 6:32 AM
Re: Useful MySQL Queries for UBB.Threads JoshPet 09/27/2003 9:25 AM
Re: Useful MySQL Queries for UBB.Threads AllenAyres 10/06/2003 7:58 AM
Re: Useful MySQL Queries for UBB.Threads JoshPet 10/06/2003 8:23 AM
Re: Useful MySQL Queries for UBB.Threads AllenAyres 10/06/2003 9:07 AM
Re: Useful MySQL Queries for UBB.Threads Sapphy 10/10/2003 4:04 PM
Re: Useful MySQL Queries for UBB.Threads Dave_L_dup1 10/10/2003 5:40 PM
Re: Useful MySQL Queries for UBB.Threads Sapphy 10/10/2003 9:45 PM
Re: Useful MySQL Queries for UBB.Threads Gardener 10/12/2003 12:11 PM
Re: Useful MySQL Queries for UBB.Threads Dave_L_dup1 10/12/2003 6:56 PM
Re: Useful MySQL Queries for UBB.Threads Gardener 10/15/2003 12:46 PM
Re: Useful MySQL Queries for UBB.Threads Beentheredonethat 11/16/2003 5:20 AM
Re: Useful MySQL Queries for UBB.Threads Gardener 11/16/2003 9:02 AM
Re: Useful MySQL Queries for UBB.Threads Beentheredonethat 11/21/2003 1:27 AM
Re: Useful MySQL Queries for UBB.Threads Gardener 11/23/2003 12:06 AM
Re: Useful MySQL Queries for UBB.Threads JoshPet 11/26/2003 2:54 AM
Re: Useful MySQL Queries for UBB.Threads Gardener 11/26/2003 3:25 AM
Re: Useful MySQL Queries for UBB.Threads Beentheredonethat 11/26/2003 5:34 PM
Re: Useful MySQL Queries for UBB.Threads Beentheredonethat 01/02/2004 11:25 AM
Re: Useful MySQL Queries for UBB.Threads omegatron 01/02/2004 7:46 PM
Re: Useful MySQL Queries for UBB.Threads Beentheredonethat 01/06/2004 2:38 AM
Re: Useful MySQL Queries for UBB.Threads Storm_dup1 01/06/2004 4:20 AM
Re: Useful MySQL Queries for UBB.Threads omegatron 01/06/2004 4:50 AM
Re: Useful MySQL Queries for UBB.Threads Pasqualist 01/08/2004 1:20 AM
Re: Useful MySQL Queries for UBB.Threads omegatron 01/08/2004 2:02 AM
Re: Useful MySQL Queries for UBB.Threads JoshPet 01/08/2004 2:38 AM
Re: Useful MySQL Queries for UBB.Threads Pasqualist 01/08/2004 10:20 AM
Re: Useful MySQL Queries for UBB.Threads scroungr 01/08/2004 4:29 PM
Re: Useful MySQL Queries for UBB.Threads omegatron 01/08/2004 4:34 PM
Re: Useful MySQL Queries for UBB.Threads scroungr 01/08/2004 4:35 PM
Re: Useful MySQL Queries for UBB.Threads omegatron 01/08/2004 5:02 PM
Re: Useful MySQL Queries for UBB.Threads scroungr 01/08/2004 5:10 PM
Re: Useful MySQL Queries for UBB.Threads CurlGirl 01/08/2004 9:03 PM
Re: Useful MySQL Queries for UBB.Threads scroungr 01/08/2004 9:27 PM
Re: Useful MySQL Queries for UBB.Threads omegatron 01/09/2004 12:14 AM
Re: Useful MySQL Queries for UBB.Threads scroungr 01/09/2004 12:38 AM
Re: Useful MySQL Queries for UBB.Threads omegatron 01/09/2004 1:11 AM
Re: Useful MySQL Queries for UBB.Threads CurlGirl 01/09/2004 6:14 PM
Re: Useful MySQL Queries for UBB.Threads omegatron 01/09/2004 6:20 PM
Re: Useful MySQL Queries for UBB.Threads CurlGirl 01/09/2004 6:30 PM
Re: Useful MySQL Queries for UBB.Threads Storm_dup1 01/14/2004 8:53 PM
Re: Useful MySQL Queries for UBB.Threads Storm_dup1 01/14/2004 9:01 PM
Re: Useful MySQL Queries for UBB.Threads dman_dup1 02/09/2004 12:54 AM
Re: Useful MySQL Queries for UBB.Threads scroungr 02/09/2004 3:31 AM
Re: Useful MySQL Queries for UBB.Threads dman_dup1 02/09/2004 4:18 AM
Re: Useful MySQL Queries for UBB.Threads smoknz28 02/16/2004 10:21 PM
Re: Useful MySQL Queries for UBB.Threads scroungr 02/17/2004 12:31 AM
Re: Useful MySQL Queries for UBB.Threads smoknz28 02/17/2004 3:58 AM
Re: Useful MySQL Queries for UBB.Threads scroungr 02/17/2004 4:55 AM
Re: Useful MySQL Queries for UBB.Threads AllenAyres 03/03/2004 6:47 PM
Re: Useful MySQL Queries for UBB.Threads JoshPet 03/03/2004 7:46 PM
Re: Useful MySQL Queries for UBB.Threads JoshPet 03/03/2004 7:55 PM
Re: Useful MySQL Queries for UBB.Threads AllenAyres 03/03/2004 8:47 PM
Re: Useful MySQL Queries for UBB.Threads JoshPet 03/04/2004 2:25 AM
Re: Useful MySQL Queries for UBB.Threads JoshPet 03/04/2004 2:26 AM
Re: Useful MySQL Queries for UBB.Threads AllenAyres 03/04/2004 4:09 AM
Re: Useful MySQL Queries for UBB.Threads JoshPet 03/04/2004 4:15 AM
Re: Useful MySQL Queries for UBB.Threads JoshPet 03/04/2004 6:20 AM
Re: Useful MySQL Queries for UBB.Threads AllenAyres 03/04/2004 7:09 AM
Re: Useful MySQL Queries for UBB.Threads AKD96 04/07/2004 11:42 PM
Re: Useful MySQL Queries for UBB.Threads omegatron 04/10/2004 5:21 AM
Re: Useful MySQL Queries for UBB.Threads AKD96 04/10/2004 9:35 PM
Re: Useful MySQL Queries for UBB.Threads AKD96 04/15/2004 8:52 PM
Re: Useful MySQL Queries for UBB.Threads scroungr 04/15/2004 11:46 PM
Re: Useful MySQL Queries for UBB.Threads AKD96 04/16/2004 2:15 AM
Re: Useful MySQL Queries for UBB.Threads JoshPet 04/16/2004 5:08 AM
Re: Useful MySQL Queries for UBB.Threads omegatron 04/17/2004 8:59 PM
Re: Useful MySQL Queries for UBB.Threads Ohmu 04/18/2004 4:08 AM
Re: Useful MySQL Queries for UBB.Threads scroungr 04/18/2004 5:20 AM
Re: Useful MySQL Queries for UBB.Threads Ohmu 04/19/2004 9:31 AM
Re: Useful MySQL Queries for UBB.Threads scroungr 04/19/2004 3:10 PM
Re: Useful MySQL Queries for UBB.Threads scroungr 04/19/2004 3:17 PM
Re: Useful MySQL Queries for UBB.Threads Ohmu 04/23/2004 2:48 AM
Re: Useful MySQL Queries for UBB.Threads msula 05/01/2004 8:35 PM
Re: Useful MySQL Queries for UBB.Threads Astaran 05/01/2004 9:26 PM
Re: Useful MySQL Queries for UBB.Threads scroungr 05/02/2004 5:05 AM
Re: Useful MySQL Queries for UBB.Threads Astaran 05/02/2004 5:06 PM
Re: Useful MySQL Queries for UBB.Threads msula 05/03/2004 9:57 PM
Re: Useful MySQL Queries for UBB.Threads Slawek_L 05/13/2004 9:48 PM
Re: Useful MySQL Queries for UBB.Threads oceanwest 05/27/2004 9:30 PM
Re: Useful MySQL Queries for UBB.Threads scroungr 05/27/2004 9:38 PM
Re: Useful MySQL Queries for UBB.Threads oceanwest 05/27/2004 11:00 PM
Re: Useful MySQL Queries for UBB.Threads Deejay_dup1 05/29/2004 1:20 AM
Re: Useful MySQL Queries for UBB.Threads AKD96 05/29/2004 2:57 AM
Re: Useful MySQL Queries for UBB.Threads IOGCadam 06/07/2004 8:43 PM
Re: Useful MySQL Queries for UBB.Threads scroungr 06/08/2004 2:06 AM
Re: Useful MySQL Queries for UBB.Threads DrChaos 07/06/2004 2:47 PM
Re: Useful MySQL Queries for UBB.Threads scroungr 07/06/2004 2:53 PM
Re: Useful MySQL Queries for UBB.Threads DrChaos 07/06/2004 10:59 PM
Re: Useful MySQL Queries for UBB.Threads scroungr 07/06/2004 11:58 PM
Review Forum Rules ChAoS_dup1 10/28/2004 8:42 AM
Re: Review Forum Rules JoshPet 10/28/2004 9:47 AM
Re: Review Forum Rules ChAoS_dup1 10/28/2004 12:25 PM
Re: Useful MySQL Queries for UBB.Threads PDOstrander 10/28/2004 6:12 PM
Re: Useful MySQL Queries for UBB.Threads Anno 10/28/2004 10:40 PM
Re: Useful MySQL Queries for UBB.Threads PDOstrander 10/29/2004 7:07 AM
Re: Useful MySQL Queries for UBB.Threads PDOstrander 10/29/2004 6:01 PM
Re: Useful MySQL Queries for UBB.Threads AKD96 11/16/2004 2:24 PM
Re: Useful MySQL Queries for UBB.Threads dparvin 11/21/2004 1:37 PM
Re: Useful MySQL Queries for UBB.Threads dimopoulos 11/22/2004 12:36 AM
Re: Useful MySQL Queries for UBB.Threads dparvin 11/22/2004 1:11 AM
Re: Useful MySQL Queries for UBB.Threads Astaran 12/02/2004 2:45 AM
Re: Useful MySQL Queries for UBB.Threads MattUK 01/25/2005 11:18 PM
Re: Review Forum Rules MattUK 01/30/2005 9:44 PM
Re: Review Forum Rules BWilliams_dup1 03/22/2005 7:47 AM
Re: Review Forum Rules scroungr 03/22/2005 8:36 PM
Re: Review Forum Rules jamesholst 04/15/2005 4:56 AM
Re: Review Forum Rules scroungr 04/15/2005 5:55 AM
Re: Review Forum Rules jamesholst 04/15/2005 5:09 PM
Re: More advanced query for deleting PM's ? Pasqualist 08/08/2005 2:52 PM
Re: More advanced query for deleting PM's ? Pasqualist 08/09/2005 12:09 AM
Re: More advanced query for deleting PM's ? AllenAyres 11/28/2006 8:14 AM
How to select U_Username twice? PaNTerSan 01/07/2007 6:46 PM
Re: How to select U_Username twice? PaNTerSan 01/07/2007 7:29 PM
Re: How to select U_Username twice? AllenAyres 01/08/2007 12:10 AM
Re: How to select U_Username twice? PaNTerSan 01/08/2007 12:31 PM
Re: How to select U_Username twice? AllenAyres 01/10/2007 7:15 AM

Link Copied to Clipboard
Donate Today!
Donate via PayPal

Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.

Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
Recommended Hosts
We have personally worked with and recommend the following Web Hosts:
Stable Host
bluehost
InterServer
Visit us on Facebook
Member Spotlight
Posts: 70
Joined: January 2007
Forum Statistics
Forums63
Topics37,573
Posts293,925
Members13,849
Most Online5,166
Sep 15th, 2019
Today's Statistics
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
Top Posters
AllenAyres 21,079
JoshPet 10,369
LK 7,394
Lord Dexter 6,708
Gizmo 5,833
Greg Hard 4,625
Top Posters(30 Days)
Top Likes Received
isaac 82
Gizmo 20
Brett 7
Morgan 2
Top Likes Received (30 Days)
None yet
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2024 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20221218)