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!

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

Woops!  I made a mistake.  Your solution actually brought me back to a previous version.   it appears we’re back to the Messages from the SSC appearing under the weekly message archive.  Only the weekly messages should appear in the weekly message section and archives.
And weekly messages are also appearing in the newsletter achive, when only Messages from the SSC (Owls nest) and 706 on the move! newsletters should be in the newsletter archive.

So, no it did not work.

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.