Joobi

terryatpace · 30 Nov 2008 11:41:13

Hello.

I would like to drop email addresses who have unsubscribed from the mailings, currently I believe their profile (including name and email addresses) is still stored in the jos_acajoom_subscribers table. I am on Joomla 1.0.15, using Acajoom Pro 3.0.6.

If not currently available, should I post a separate thread to the enhancements request area of the forum? I believe it is more appropriate for a person who has unsubscribed to have their email address removed entirely from the backend, as opposed to just having a flag that the person has declined to receive future emails. It also is one less thing for the admin to worry about.

Any suggestions as to how to run a db query to retrieve all the people who have unsubscribed would be welcome. At the moment the only obvious route which I see is to go through the unsubscribe requests.

Thanks, Terry

Adrien · 01 Dec 2008 15:49:26

This query will show you all your Acajoom Subscribers which are unsubscribed from all your lists.

Code:

SELECT S.* FROM jos_acajoom_subscribers AS S
LEFT JOIN  jos_acajoom_queue AS Q on S.id = Q.subscriber_id
WHERE Q.qid IS NULL ;

So you may want to delete those users using the query :

Code:

DELETE S.* FROM jos_acajoom_subscribers AS S
LEFT JOIN jos_acajoom_queue AS Q on S.id = Q.subscriber_id
WHERE Q.qid IS NULL ;

terryatpace · 01 Dec 2008 15:54:24

Many thanks for the resolution Adrien, I'll be sure to keep the queries handy.

Joobi

Joomla components

#1 30 Nov 2008 11:41:13

deleting unsubscribed users from db

#2 01 Dec 2008 15:49:26

Re: deleting unsubscribed users from db

Code:

Code:

Sorry. You have to be registered to access this content.

#3 01 Dec 2008 15:54:24

Re: deleting unsubscribed users from db

Forum Tools