Importing / Converting opt-in's to Double Opt-ins

[mike2]

Hi,

I'm looking for something to help with what I need...  I purchase a lot of opt-in email leads and I want to import them into a temporary table, send them an email asking them to double opt-in to our main/real list.

I envision in would do this (and If I knew PHP I'm sure it would be cake...):  The link in the email would be like a simple remove link, saying click this link to confirm your subscription, when clicked would open a webpage, subscribe them to our main list/send out the welcome message/then forward them to our main web page.

I've worked out a small solution, but it's very slow.  What I've done is on the import process, I changed it to make the imported users "uncomfirmed" and to send out the confirmation email right on import.  Like I said it works, but VERY slow...and sometimes times out with "Page Not Found" errors on big imports.


--

Mike Rogers - M&A Computer Services

Exposure to 100's of Thousands Each Month:
http://ExtremeMarketingProgram.com

1 Million Opt-In Email Leads Each Month:
http://ExtremeLeadProgram.com

[DW]

Mike,

I plan on implementing "confirm/welcome on import", utilizing SMTP, for the next release.

For now, you could get away with something as follows.  Import your users to a temporary list and send an email that includes a link  utilizing an email message code. ie:

---
To confirm your subscription, please click below:
http://yoursite.com/mail/signup.php?list=2&email=!email

!remove
---

You could also take advantage of the "signup-xtra.php" script which can run after each signup.  This file can be found in the /xtra folder of the ZIP.  If copied to the main ListMail folder it will run after each signup.  If your temporary list is list 3, then you would use the following code to remove users from list 3 when they subscribe to list 2.

Code: [Select]

if($list=='2'){
 mysql_query("delete from lm_users where email = '$email' and list = '3'");
}