Transfer user to another list with the followup sequence #

[paulbeestonuk]

Hi,
I have 2 lists (of approx 200 users on each) that I want to send a 14 email follow up sequence to e.g. both list A and list B will receive 14 emails in the same order, with the same delay. Email #1 on list A will be very similar to email #1 on list B, just slightly customised.

What I want (ultimately!!) is for users of list B to join list A but I don't want them to start back at the beginning of the sequence because they would have already received a very similar email as a user on list B!

My question is: how can I copy over the sequence number so that the user who has just received email #5 list B next receives email #6 on list A?
Thanks,
Paul.

[DW]

Paul,

There is an includable script at xtra/signup-xtra.php.  When copied to your main ListMail folder it will run after signup or optionally during manual signup and import. You can try the following custom code.  If the user subscribes to List 2 their followup and seq will be copied from List 1 and they will be set to seq 999 on list 1.

Code: [Select]

if($list=='2'){
 // get info from list 1 if exists
 list($cseq,$cdel)=@mysql_fetch_row(mysql_query("select cseq,cdel from $utable where email like '$email' and list = '1';"));
 if($cseq){
  // copy from list 1 to new subscriber
  mysql_query("update $utable set cseq = '$cseq', cdel = '$cdel' where uid = '$uid';");
  // set to 999 on list 1
  mysql_query("update $utable set cseq = '999', cdel = '0' where email like '$email' and list = '1';");
 }
}
Regards

[paulbeestonuk]

Paul,
There is an includable script at xtra/signup-xtra.php.  When copied to your main ListMail folder it will run after signup or optionally during manual signup and import.

Hi Dean,
Thanks for this - looks like this will do the trick!
One of the things I really like about LMP is that you can always find a way to do the most obscure things!
Thanks,
Paul.