Previous Thread
Next Thread
Print Thread
Hop To
Joined: Dec 2003
Posts: 6,286
Likes: 45
Ruben Offline OP
OP Offline
Joined: Dec 2003
Posts: 6,286
Likes: 45
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,825
Likes: 108
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Apr 2004
Posts: 1,825
Likes: 108
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 // Work In Progress: soon
isaac @ id242.com // my forum @ CelicaHobby.com
Joined: Apr 2004
Posts: 1,825
Likes: 108
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Apr 2004
Posts: 1,825
Likes: 108
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 6:54 PM.

Current developer of UBB.threads PHP Forum Software
Current Release: UBBT 7.7.5 // Work In Progress: soon
isaac @ id242.com // my forum @ CelicaHobby.com
Joined: Dec 2003
Posts: 6,286
Likes: 45
Ruben Offline OP
OP Offline
Joined: Dec 2003
Posts: 6,286
Likes: 45
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
PM limits
by jjjjj - 01/07/2021 12:59 PM
FAQ is blank?
by Bad Frog - 01/06/2021 12:01 PM
IP Addresses Of Users
by tinker123 - 01/03/2021 3:07 PM
User display name gets chopped
by - 12/25/2020 1:08 PM
Who's Online Now
2 members (Justin1524, UBBSystems), 61 guests, and 56 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
gallery test
gallery test
by Mors, September 23
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Powered by UBB.threads™ PHP Forum Software 7.7.5