Comment to 'How to send message to all members?'
  • Hello Finn from EducatedSingles !

    Well, it's possible only if make all users refused to get newsletters as agreed to get those letters :-)

    It's possible to do with the following MySQL queries (backup the `sys_accounts` table first):

    UPDATE `sys_accounts` SET `changed` = 1 WHERE `receive_updates`=0;

    UPDATE `sys_accounts` SET `receive_updates`=1 WHERE `changed` = 1;

    Then make mass mailer performance.

    Then it will need to back the "opportunists":

    UPDATE `sys_accounts` SET `receive_updates`=0 WHERE `changed` = 1;

    UPDATE `sys_accounts` SET `changed` = `added`+3600 WHERE `receive_updates`=0;