Raymond,
Thank you for your kind comment and for your excellent questions.
I have a reminder email that I send out to a list every sunday evening. I have poured over all the options and read all the docs and if it's there I missed it. Is there a way to schedule a re-occuring email that happens at a given time to a given list? (I read something about some new features in the next release that sounded like this)
This is not currently possible from within the program, but it is possible with a custom addition. The recent v1.77b update contains the following code at the end of dailymail:
if(file_exists('./daily-xtra.php')){
include('./daily-xtra.php');
}
So, if you wanted a message sent every Sunday what you could do is set up a daily-xtra.php script in your main Listmail folder that inserts a scheduled message on Saturday, like so:
<?php
// Check if it's Saturday with the PHP date() function
if(date("l")=='Saturday'){
$list = '1';
$subject = "My message subject";
$message = "This is a test message to be sent every Sunday
Enter your message text, including codes, etc. Escape \"double quotes\" with a backslash.
End of message";
$fdate = '0000-00-00'; // date in the past, will be sent next dailymail
$html_msg='';
$files='';
$cmd = "insert into $qtable (date,list,subject,message,htmessage,fattach) values('$fdate','$list','".addslashes($subject)."','".addslashes($message)."','".addslashes($html_msg)."','$files');";
mysql_query($cmd);
}
?>The main downside to this approach is it is difficult to modify the message you would like sent. It will need to be entered in the PHP above, in the $message variable, with any double quotes "escaped" with backslashes, ie: \" \".
I want to setup a list that 'repeats itself'. Meaning it gets through the entire follow-up series and then starts over again at message # x (not necessarily the first one).
This is also possible with the daily-xtra.php script with the following addition. The example provides functionality to loop users at the end of a list (14) to be reset to the beginning. It should be fairly straightforward how to modify this code to set users to be on another Sequence # instead of the first one when looping. (See: $firstfup variable)
<?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
?>Hopefully you are somewhat knowledgeable in PHP, otherwise this could be quite tricky for you! :-)
Good luck!
