Page 2 of 2

PostPosted: 3:36am, Tue 04 Mar, 2008
by 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.

PostPosted: 5:56pm, Tue 24 Feb, 2009
by woolef
chewblocka wrote: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?

Re: [mod] Automatically send last list message to new subscriber

PostPosted: 11:54pm, Sun 10 May, 2009
by 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

Re: [mod] Automatically send last list message to new subscriber

PostPosted: 5:15am, Mon 11 May, 2009
by 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

Re: [mod] Automatically send last list message to new subscriber

PostPosted: 10:39pm, Mon 27 Jul, 2009
by 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?

Re: [mod] Automatically send last list message to new subscriber

PostPosted: 11:23am, Sun 26 Jun, 2011
by 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

Re: [mod] Automatically send last list message to new subscriber

PostPosted: 1:30pm, Sun 26 Jun, 2011
by CISIUM
Hi,

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

Thanks
Cisium