Ok, another contribution:

This one subscribes a user to a specific Acajoom list (newsletter or smart-newsletter - autoresponder is not supported by this query) with listid number = <listid> (you need to look at your backend Components -> Acajoom -> Lists area to find the listid of your list. Make sure you substitute <listid> with your listid value.

[code:1]
INSERT INTO `#__acajoom_queue` ( `type`, `subscriber_id`, `list_id`, `acc_level` ) VALUES ( (SELECT `list_type` FROM `#__acajoom_lists` WHERE `id` = <list_id> ), ( SELECT `id` FROM `#__acajoom_subscribers` WHERE `user_id` = [user_id] ), <listid> , (SELECT `acc_id` FROM `#__acajoom_lists` WHERE `id` = <list_id> ) )
[/code:1]

And this one removes the subscription (once again remember to replace <listid> with your listid:

[code:1]DELETE FROM `#__acajoom_queue` WHERE ( (`list_id` = <listid> ) AND (`subsciber_id` = (SELECT `id` FROM `#__acajoom_subscribers` WHERE `user_id` = [user_id] ) ) )
[/code:1]

As always, please backup first and test.

Also please note that all these SQL integration depend on the specific database scheme - if the component changes database tables, then the integration might not work.

Post edited by: nant, at: 2010/01/13 18:21

Yes - fixed typo.

fixed copy paste error