Developing a query for it should be just a matter of looking at your database then examine Acajooms tables.. add a user to a mailing list via acajoom.. see what tables change. Then make a query based off that change. I don't have a copy of Acajoom so can't be much of help in that aspect, sorry.
Kyle (Krileon) Community Builder Team Member Before posting on forums:
Read FAQ thoroughly
+
Read our Documentation
+
Search the forums CB links:
Documentation
-
Localization
-
CB Quickstart
-
CB Paid Subscriptions
-
Add-Ons
-
Forge
-- If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
-- If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please
send me a private message
with your thread and will reply when possible!
-- Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
-- My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
SELECT *
FROM `jos_acajoom_queue`
WHERE `subscriber_id` IN ( 268)
AND `list_id` =2
SELECT *
FROM `jos_acajoom_queue`
WHERE `subscriber_id` IN ( 268)
AND `list_id` =3
DELETE
FROM `jos_acajoom_queue`
WHERE `subscriber_id` = 268
AND `list_id` =3
SELECT *
FROM `jos_acajoom_queue`
WHERE `subscriber_id` IN ( 268)
AND `list_id` =4[/code:1]
This might be bad news since the subscriber ID is not the same as user_id. It's a unique ID given incrementally to each newsletter subscriber. How would this work?
TP, thanks for sharing your efforts to figure out how to add users to Acajoom lists. I, for one, abandoned that idea after test driving AcyMailing; it seems to me that it does everything Acajoom does and more. It even imports mailing lists from Acajoom for a smooth transition. Really great reviews on extensions.joomla.org too.
Here are the SQL Statements for adding/removing subscribers to AcyMailing lists courtesy of Nick and Kyle: