force all users to reconfirm

[jimlongo]

Hi, I can't find any post on this so I'll ask here . . .

On July 1st Canada has a new law which comes into effect requiring all users to reconfirm their subscription to your email list.

I know I could un-confirm them in the database, but then I couldn't send them an email.

Is there a way I can un-confirm all (confirmed) users, and send them an email asking them to reconfirm their subscription status?

Thanks,
Jim Longo

[AlanGeorge]

Hi Jim

a very simple hack in two parts

1. Activate the Reconcile Subscriber options that have been switched off
2. Then modiy the following reconcile option

Mark all subscribers on list xxxxx confirmed

in admin/reconcileusers.php find

Sql_Query("update {$tables["user"]} set confirmed = 1");

Change the 1 to 0
save the file and upload
When finished don't forget to reset this back to its original state.

Modify the message that is sent to unconfirmed users to reflect the changes to Canadian law, enter the date range and press the Click Here Button to send.

Always backup the database before making any changes.

Regards

Alan

ps will now test this on my test install

pps Tested and it works....

[duncanc]

I think that the way to handle this in phplist 3 is to use the invite plugin https://github.com/michield/phplist-plugin-invite.

You can send an ordinary campaign asking people to respond. Behind the scenes the plugin marks the subscribers as blacklisted, and only those who confirm have that status removed.
Being a campaign, your batch and throttle settings apply, avoiding what I think was a problem with the phplist 2.10.x approach of sending all confirmation requests immediately.

[jimlongo]

Thanks Alan and Duncan.

Duncan is there a way to provide a (prettier) html link, rather than use the rather long and ugly result that [CONFIRMATIONURL] gives in the body of the message?

[duncanc]

You should be able to use [CONFIRMATIONURL] as the href attribute in an a element.

If you are using CKEeditor or fckeditor then choose 'other' for the protocol when adding a link.