[mod] Automatically send last list message to new subscriber

[scarecrow1]

Thank you very much - made the changes you recommended and it worked like a charm. Now i just need to work out how to get my rss feed working inside a message and get a cron job going - and then just sit back and enjoy this wonderful software.

[woolef]

I got this working with multiple mailing lists. Really, the way I did it is probably the more correct... <snip>

Would it be safe to use these instructions to mod the index.php file of the latest version (2.10.9) of phplist?

If so I'm struggling to see where I add the second code segment into the 'while' statement, could anyone point me in the right direction please?

[taydeko]

I did this for the latest version of the software, 2.10.10. The correct file to modify was Subscriberlib2.php. The first query has already been changed to "select *" in this version so no modification of that query was required. All I did was add this query on line 518 as part of the while loop:

Code: Select all

      Sql_Query("update {$GLOBALS[$tables]["message"]} set status = \"submitted\" where embargo <= now() and id = (select max(messageid) from {$GLOBALS[$tables]["listmessage"]} where listid = ".$row["listid"].")");


I have only done this once but it seems to be working exactly as advertised.

I suspect the next steps in this process would be to put a flag in the listmessage table that indicates what message should be sent to new users. Then the query above would select the flagged message for the list required. A setting could be set to send either the last message sent or the one selected or none for a given list, depending on the needs of the list admin.

Then an autoresponder with campaigns would be nice.

Ted

[taydeko]

One other thing to note about this. If you import email addresses, this doesn't work, but then of course, you would just requeue the last message sent and it would go to them anyway.

Ted

[lge]

In conclusion to this work (Automatically send last list message to new subscriber) in PHPList version 2.10.10
1. Which pages should be modified?
2. What needs to change/add, and where exactly

Please help?

[CISIUM]

Hi chewblocka,

I implemented as per your advice "Postby chewblocka » 1:48pm, Wed 23 Jan, 2008". It work so far that he add the subscriber to the send list, but it does not send the message automatically after the subscription is confirmed.

embargo 2011-06-23 05:16:00
repeatinterval 0
repeatuntil 2011-06-23 05:16:25
status inprocess

Is it because the repeatinterval is 0?

Thanks in Advance
cisium

[CISIUM]

Hi,

I would like to program automatic "process queue" for new subscriber. Anyone an idea how to do it straight forward?

Thanks
Cisium