Loop users in a followup sequence

[DW]

This script is redundant as of ListMail v1.86 when it was added as an option on the List Settings page.
-----
This is possible with a custom script that runs after dailymail simply by adding the file "daily-xtra.php" to your main ListMail folder (v1.77b)

In this file, place the following: (example for list 14)

Code: [Select]

<?php
/* Start LOOP LIST 14 */

 // set list to move users from
 $looplist = '14';

 // get last followup on the list  list($lastfup)=mysql_fetch_row(mysql_query("select seq from lm_follow where list = '$looplist' order by seq desc limit 1",$link));

 // increment by one to match users who are the end of the sequence  $lastfup = $lastfup + 1;

 // get first followup seq and delay  list($firstfup,$firstdel)=mysql_fetch_row(mysql_query("select seq,del from lm_follow where list = '$looplist' order by seq limit 1",$link));

 // update users
 mysql_query("update lm_users set cseq = '$firstfup', cdel = '$firstdel' where list = '$looplist' and cseq = '$lastfup'",$link);

/* End LOOP LIST 14 */
?>

[AlanT]

It looks like this kind of script can also move a subscriber from one list to another list after the first sequence is finished.  Am I right on this?

I'd like to be able to have my broadcasts go out to only those users who have finished the basic followup sequence (to avoid annoying anyone with 'excessive' marketing), and the easiest way would be to have the subscribers of the basic sequence moved to a 'broadcast list'.

Just to make sure I understand what to do here, it looks like I would use the daily-xtra.php script to do a MySQL update on all subscribers to list #1 (the basic sequence), last followup, and edit them to be the first followup on the broadcast list (list #2).

So, here is the edited code as I have it:

Code: [Select]

<?php 
/* Start Switch List */ 

 // set list to move users from 
 $oldlist= '1'; 
 $newlist= '2';

 // get last followup on the list  
list($lastfup)=mysql_fetch_row(mysql_query("select seq from lm_follow where list = '$oldlist' order by seq desc limit 1",$link)); 

 // increment by one to match users who are the end of the sequence
$lastfup = $lastfup + 1; 

 // get first followup seq and delay  
list($firstfup,$firstdel)=mysql_fetch_row(mysql_query("select seq,del from lm_follow where list = '$newlist' order by seq limit 1",$link)); 

 // update users 
 mysql_query("update lm_users set cseq = '$firstfup', cdel = '$firstdel', list = '$newlist' where list = '$looplist' and cseq = '$lastfup'",$link); 

/* End Switch List */ 
?>

Do I have it edited correctly?

- Alan

[DW]

Yes, this appears correct!

[alice]

Hello I'm not quite sure I follow how to implement this. Do I add this code to the dailymail.php or put this code into a new file and name it daily-xtra.php and then set up a cron for it to run after dailymail runs? I tried doing the 2nd way and running the file straight from my browser and it gets errors.

[DW]

Alice,

Paste the code into a file named daily-xtra.php and simply upload it to your ListMail folder.   ListMail's dailymail script will automatically detect and execute it.

Regards!