Please Log in to join the conversation.
Please Log in to join the conversation.
ThePiston, thanks so much for your code - does this mean you have it working now on your site?
I have NO IDEA with SQL, so I'm nervous about playing with this on my live site...
I'm wondering if [email] will take the email address from the user's community builder profile? Or do I need to change this as it suggests on the joobi website?
Post edited by: coachnet, at: 2010/01/07 00:20
Please Log in to join the conversation.
INSERT IGNORE INTO `jos_acajoom_queue` (`type`, `subscriber_id`, `list_id`, `mailing_id`, `issue_nb`, `send_date`, `suspend`, `delay`, `acc_level`, `published`) SELECT A.`list_type`, ( SELECT S.`id` FROM `jos_acajoom_subscribers` as S WHERE S.`email` = '[email]' LIMIT 1), A.`id`, 0 , 0, NOW(), 0, 0, A.`acc_level`, 1 FROM `jos_acajoom_lists` as A WHERE A.id = '2' LIMIT 1;
DELETE Q.* FROM `jos_acajoom_subscribers` as S LEFT JOIN `jos_acajoom_queue` as Q ON S.`id` = Q.`subscriber_id` WHERE Q.`list_id` = '2' AND S.`email` = '[email]';
Please Log in to join the conversation.
Please Log in to join the conversation.
Please Log in to join the conversation.