Previous Thread
Next Thread
Print Thread
Hop To
Joined: Dec 2003
Posts: 6,560
Likes: 78
Joined: Dec 2003
Posts: 6,560
Likes: 78
I just migrated a old site and upgraded to 7.7.2.
Question is a lot of watched item notifications bounce back to the main email account for invalid email accounts.

I would like to clear out all watched item notifications so they all start over.
Where would I do that or is there a simple query to clean them all out?
I see:
ubbt_WATCH_LISTS
can I just empty all the entries?
Or I see a field called:
WATCH_NOTIFY_IMMEDIATE
But it has values of like 0,1,2
My immediate need is to stop the emails for all members
And let current visitors elect to email themselves again.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Joined: Apr 2004
Posts: 1,945
Likes: 145
UBB.threads Developer
UBB.threads Developer
Joined: Apr 2004
Posts: 1,945
Likes: 145
1. Control Panel > Members (Member Search)

2. Search for the user by entering the bounced email address in the "Real Email Address" box.

3. There should only be one user result returned. Click the user name to edit that user.

4. Now go to the "Preferences" tab, and update the "Email and Private Message Preferences" items you want to disable for that bad email address.

Click "Update Member," and you're done.


Current developer of UBB.threads PHP Forum Software
Current Release: UBBT 7.7.5 // Preview: UBBT 8.0.0
isaac @ id242.com // my forum @ CelicaHobby.com
Joined: Apr 2004
Posts: 1,945
Likes: 145
UBB.threads Developer
UBB.threads Developer
Joined: Apr 2004
Posts: 1,945
Likes: 145
If you wanted to reset the default settings for all of the users, you could run this from the SQL Command page.

Set all users forum display preferences to default.
Code
update ubbt_USER_PROFILE
set	USER_START_VIEW = "cfrm",
	USER_FAVORITES_TAB = "forums",
	USER_FAVORITES_SORT = "reply",
	USER_TOPIC_VIEW_TYPE = "flat",
	USER_TOPICS_PER_PAGE = null,
	USER_NOTIFY_ON_PM = "yes",
	USER_SHOW_AVATARS = 1,
	USER_EMAIL_WATCHLISTS = 1,
	USER_POSTS_PER_TOPIC = null,
	USER_SHOW_SIGNATURES = null,
	USER_TIME_FORMAT = null,
	USER_STYLE = 0,
	USER_TEXT_EDITOR = "standard",
	USER_HIDE_LEFT_COLUMN = 0,
	USER_HIDE_RIGHT_COLUMN = 0,
	USER_POST_LAYOUT = null,
	USER_SHOW_ALL_GRAEMLINS = 0,
	USER_SHOW_LEFT_MYSTUFF = 1

These are the default settings from a new UBB.threads 7.7.x install.

EDIT:
You could customize that SQL query to fit exactly as you'd like. If you wanted to set those defaults for just one single user, you'd add the following single line to the end of your query

Code
where USER_ID = 99999

Update "99999" to the user number you want to update. Or set it to "1" so that all future users will have those set defaults upon new account creation.

NOTE:
These are already the defaults for a fresh UBB.threads 7.7.x install.

Last edited by isaac; 07/31/2019 7:54 PM.

Current developer of UBB.threads PHP Forum Software
Current Release: UBBT 7.7.5 // Preview: UBBT 8.0.0
isaac @ id242.com // my forum @ CelicaHobby.com
Joined: Dec 2003
Posts: 6,560
Likes: 78
Joined: Dec 2003
Posts: 6,560
Likes: 78
got it thanks.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
spam issues
by ECNet - 03/19/2024 11:45 PM
Looking for a forum
by azr - 03/15/2024 11:26 PM
Editing Links in Post
by Outdoorking - 03/15/2024 9:31 AM
Question on barkrowler and the like
by Mors - 02/29/2024 6:51 PM
Member Permissions Help
by domspeak - 02/27/2024 6:31 PM
Who's Online Now
0 members (), 744 guests, and 147 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20230217)