SQL to change all notifications: WSN Support Forums

SQL to change all notifications
from instant to daily digest

Comments on SQL to change all notifications

•peumus Forum Regular Usergroup: Customer Joined: Aug 09, 2004 Location: Chile Total Topics: 172 Total Comments: 462	•peumus #1 - Quote - Permalink Posted Jul 20, 2008 - 11:25 AM: Paul, Can you please advice me the SQL code to insert into SQL phpmyadmin in order to : Update selection to daily digest for all members that have already selected to receive any kind of notifications. I need to change all instant notifications in favour to daily digest.
•Paul developer Usergroup: Administrator Joined: Dec 20, 2001 Location: Diamond Springs, California Total Topics: 61 Total Comments: 7868	•Paul #2 - Quote - Permalink Posted Jul 21, 2008 - 5:40 AM: UPDATE wsnlinks_members SET notifymethod='digest';
•peumus Forum Regular Usergroup: Customer Joined: Aug 09, 2004 Location: Chile Total Topics: 172 Total Comments: 462	•peumus #3 - Quote - Permalink Posted Jul 21, 2008 - 6:10 AM: Paul, But at the same time I need also not to change the ones that have not selected to receive any notification.
•mariow Forum Regular Usergroup: Customer Joined: Jul 09, 2008 Total Topics: 22 Total Comments: 110	•mariow #4 - Quote - Permalink Posted Jul 21, 2008 - 7:47 AM: something like this i guess... UPDATE `wsnlinks_members` SET `notifymethod` = 'digest' WHERE `notifymethod` = 'instant';
•peumus Forum Regular Usergroup: Customer Joined: Aug 09, 2004 Location: Chile Total Topics: 172 Total Comments: 462	•peumus #5 - Quote - Permalink Posted Jul 21, 2008 - 9:05 PM: Thanks mariow.
•Paul developer Usergroup: Administrator Joined: Dec 20, 2001 Location: Diamond Springs, California Total Topics: 61 Total Comments: 7868	•Paul #6 - Quote - Permalink Posted Jul 22, 2008 - 1:39 AM: That particular selection doesn't have a "never" option. The decision to not get anything is a differnet unrelated field.

Sorry, you don't have permission to post posts. Log in, or register if you haven't yet.