Originally Posted by Gizmo
By default should anything added to your Watch Lists be emailed to you?
Code
UPDATE `ubbt_USER_PROFILE` SET `USER_NOTIFY_ON_PM` = 'yes';


that would be PM's smile

Code
ALTER TABLE `ubbt_USER_PROFILE` CHANGE `USER_EMAIL_WATCHLISTS` `USER_EMAIL_WATCHLISTS` TINYINT( 1 ) NOT NULL DEFAULT '1'

Would set the watchlist e-mails default on for new users.

Code
ALTER TABLE `ubbt_USER_PROFILE` CHANGE `USER_NOTIFY_ON_PM` `USER_NOTIFY_ON_PM` CHAR( 3 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'yes'

Would set the wachlist e-mail stuff default on for new users.

As for adding users to the watchlist, it depends. Do you want to force it on again if they turn it off themselves?

[Linked Image from siemons.org]