0, 'newsletter_changed' => 'SQL:NOW()', 'newsletter_lastsending' => '0000-00-00 00:00:00', 'newsletter_created' => 'SQL:NOW()', 'newsletter_subject' => '--SELF-- (copy)')); } // check if subscription should be edited ?>
   Add
'.LF; echo ''.LF; echo '\n"; // create date echo ''; // last sending echo ''; echo ''; // buttons echo '\n\n"; $row_count++; } } else { echo ''; } ?>
  ', $BL['be_last_sending']) ?> '.$BL['be_cnt_queued'].'/
'.$BL['be_msg_senttop'] ?>		  
'; // sent/queue status $count_sent = _dbQuery('SELECT COUNT(*) FROM '.DB_PREPEND.'phpwcms_newsletterqueue WHERE queue_status=1 AND queue_pid='.$row["newsletter_id"], 'COUNT'); $count_queue = _dbQuery('SELECT COUNT(*) FROM '.DB_PREPEND.'phpwcms_newsletterqueue WHERE queue_status=0 AND queue_pid='.$row["newsletter_id"], 'COUNT'); $count_recipient = countNewsletterRecipients($row['newsletter_vars']['subscription']); if(empty($row["newsletter_active"]) || !$count_queue) { echo 'NL'; } else { echo 'Send'; } echo ''.html_specialchars($row["newsletter_subject"])." '.@date($BL['be_shortdatetime'], strtotime($row['newsletter_changed'])).'  '.@date($BL['be_shortdatetime'], strtotime($row['newsletter_lastsending'])).' '.$count_recipient.'/'.$count_queue.'/'.$count_sent; if($count_sent && !$count_queue && $row["newsletter_active"]) { echo 'valid'; } echo ' '; // duplicate echo 'Duplicate'; // edit echo 'Edit'; // delete echo ''; echo 'Delete'; echo "
 no newsletter available