Please Log in to join the conversation.
Please Log in to join the conversation.
INSERT INTO `#__acymailing_listsub` ( `listid`, `subid`, `subdate`, `status` ) VALUES ( 8, ( SELECT `subid` FROM `#__acymailing_subscriber` WHERE `userid` = [user_id] ), UNIX_TIMESTAMP( NOW() ), 1 )
DELETE FROM `#__acymailing_listsub` WHERE ( (`listid` = 8) AND (`status` = 1) AND (`subid` = (SELECT `subid` FROM `#__acymailing_subscriber` WHERE `userid` = [user_id] ) ) )
Please Log in to join the conversation.