Newsletter Builder Archive Issues - Draft newsletters

Hi Ragi,

Can you try replacing the code on line 28:

'where'       => $where,

with this code:

'where'       =>  "send IN ('all','archive')"

Let me know if that works for you.

Thanks!

That worked perfectly!

Thanks Damon.

Damon:  I just realized I also have the file weeklyMessage.php which only lists the weekly messages.  It has the same issue as the archive.php file, but in this case its a bit more convoluted.  Can you provide me a hint?

Ragi

Hi again,

For the weeklyMessage.php file, on line 22, can you replace this:

 'where'     => "to_list = '" . coalesce(mysql_escape(@$_REQUEST['to_list']), '2') . "' AND " . $whereMessageNumIs,

with this:

'where'       => "send IN ('all','archive') AND " . whereRecordNumberInUrl(1), // If no record # is specified then latest record is shown

Let me know if that works for you.

Thanks!

Damon:  again, great!  

Ragi

Hi Ragi,

You do need this code:

'where'       => "send IN ('all','archive') AND " . whereRecordNumberInUrl(1),

so that only newsletters that have been sent and archived (all) or just archived (archive) will be displayed. Otherwise newsletters that set as drafts (none) are displayed as well. 

Can you add your additional mySQL filtering to the where statement?

Damon:  Not exactly how I would do that....  would this work?

'where' => "to_list = '" . coalesce(mysql_escape(@$_REQUEST['to_list']), '2') . "' AND " . $whereMessageNumIs . " AND " . "send IN ('all','archive') AND " . whereRecordNumberInUrl(1),

Ragi

P.S.  It worked!  Thanks Damon.

It worked! 

My two favorite words!  :)

Thanks for the update.