Run this querystring through a SQL statement that will do the following:
Go to the pyli_listuser record for this uid and update the listid from 3 (in this case) to 300
I am assuming most people do not have over 100 lists so by adding 00 to the end of the original list id will show that that person WAS on that list but now does not receive emails
Just my 2 cents. Please LMK any downside to this. If this sounds good I would LOVE to see it in an update so I do not need to add hacks to my code
I’m not exactly sure what you are asking. The idea of removing a subscriber from a list is feasible, but your suggested implementation of multiplying the list number by 100 is a bit weird.
What do you mean by this? The recommended approach is to get people to use their preferences to select the lists they want to belong to.
“I’m not exactly sure what you are asking. The idea of removing a
subscriber from a list is feasible, but your suggested implementation of
multiplying the list number by 100 is a bit weird.”
LOL.
Here is my reasoning.I am not actually multiplying by 100 but I am concatinating by adding a “00” (or it could be “000000000” for example) after the list id number.
This will allow the the list user to be identified as a member of a list who no longer wants to receive emails from that list. For example, list ID 3. As soon as you make that list id 300 the list user will no longer receive list 3 emails but the admin can easily see that the list user chose to unsubscribe because there is a “00” after the list id 3.
Code could fairly easily be written to remove the “00” and put the list user back on the subscribe side.
3.As for the preferences page I am having problems getting individual lists to unsubscribe. I just get the global blacklist. I have define(‘PREFERENCEPAGE_SHOW_PRIVATE_LISTS’, 1);
As an aside I did some format changes to the preferences page and It isn’t looking as nice as I would like!
@square1 I have added some code to the existing Subscribers plugin to provide placeholders and a page to unsubscribe from a list.
There are two placeholders [LISTUNSUBSCRIBE] which generates a link (an html a element) and [LISTUNSUBSCRIBEURL] which generates only the URL.
The text of the link can be customised on the Settings page in the Subscription settings group.
The main difference from your proposal is that it uses the message id, and removes the subscriber from all lists to which the message was sent. In most cases that will only be one list, but when there are several then the subscriber is removed from them all.