Can anyone explain the advanced bounce rule difference between blacklisting a user, and blacklisting an email address?
I was looking through the code, and it’s not clear to me what’s done and where…
Is there a ‘do not send list’? I don’t see one, just a table containing blacklisted email addresses.
In the end, I’d like to generate a list of all blacklisted email addresses (from phplist) that I can ‘back annotate’ to an external database. Right now I am using two selects… but it seems to be missing some of the blacklisted contacts…
INSERT INTO external_schema.table (email)
SELECT phpList_schema.phplist_user_user.email
FROM phpList_schema.phplist_user_user WHERE
phpList_schema.phplist_user_user.blacklisted = 1 ;
INSERT INTO external_schema.table (email)
SELECT phpList_schema.phplist_user_blacklist.email
FROM phpList_schema.phplist_user_blacklist;