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 // create paginating for newsletter if(isset($_GET['c'])) { $_SESSION['list_newsletter_count'] = $_GET['c'] == 'all' ? '99999' : intval($_GET['c']); } // set default values for paginating if(empty($_SESSION['list_newsletter_count'])) { $_SESSION['list_newsletter_count'] = 10; } // set page if(isset($_GET['page'])) { $_SESSION['newsletter_page'] = intval($_GET['page']); } // start at page 1 if(empty($_SESSION['newsletter_page']) || $_SESSION['newsletter_page'] < 1) { $_SESSION['newsletter_page'] = 1; } $_newsletter['count_total'] = _dbQuery("SELECT COUNT(*) FROM ".DB_PREPEND."phpwcms_newsletter WHERE newsletter_trashed=0", 'COUNT'); $_newsletter['pages_total'] = ceil($_newsletter['count_total'] / $_SESSION['list_newsletter_count']); if($_SESSION['newsletter_page'] > $_newsletter['pages_total']) { $_SESSION['newsletter_page'] = $_newsletter['pages_total']; } ?>

1) { echo ''; echo ''; echo ''; echo '

'; if($_SESSION['newsletter_page'] > 1) { echo ''; echo '

'; } else { echo '

'; } echo '

/'.$_newsletter['pages_total'].'

'; if($_SESSION['newsletter_page'] < $_newsletter['pages_total']) { echo ''; echo '

'; } else { echo '

'; } echo '

'; } else { echo ' '; } ?>

5 10 25 50 100

'.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 ''; } else { echo ''; } 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 ''; } echo '	'; // duplicate echo ''; // edit echo ''; // delete echo ''; echo ''; echo "
no newsletter available