// obligate check for phpwcms constants
if (!defined('PHPWCMS_ROOT')) {
    die("You Cannot Access This Script Directly, Have a Nice Day.");
}
// ----------------------------------------------------------------
if (isset($_GET["s"])) {
    include_once PHPWCMS_ROOT . '/include/inc_lib/newsletter.form.inc.php';
    if (isset($_GET['edit'])) {
        include_once PHPWCMS_ROOT . '/include/inc_tmpl/newsletter.form.tmpl.php';
    }
    if (isset($_GET['send']) && $show_nl_send) {
        include_once PHPWCMS_ROOT . '/include/inc_tmpl/newsletter.send.tmpl.php';
    }
} else {
    if (isset($_GET['duplicate_nl'])) {
        @_dbDuplicateRow('phpwcms_newsletter', 'newsletter_id', intval($_GET['duplicate_nl']), array('newsletter_active' => 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']);
    }
    $_newsletter['count_total'] = _dbQuery("SELECT COUNT(*) FROM " . DB_PREPEND . "phpwcms_newsletter WHERE newsletter_trashed=0", 'COUNT');
Example #2
0
         $sql = 'UPDATE ' . DB_PREPEND . 'phpwcms_ads_campaign SET ';
         $sql .= "adcampaign_status=" . (intval($_GET['verify']) ? 1 : 0) . " ";
         $sql .= "WHERE adcampaign_id=" . intval($_GET['editid']);
         @_dbQuery($sql, 'UPDATE');
         headerRedirect(decode_entities(MODULE_HREF) . '&listcampaign=1');
     } elseif (isset($_GET['delete'])) {
         $adcampaign_id = intval($_GET['delete']);
         // delete
         $sql = 'UPDATE ' . DB_PREPEND . 'phpwcms_ads_campaign SET ';
         $sql .= "adcampaign_status=9 WHERE adcampaign_id=" . $adcampaign_id;
         @_dbQuery($sql, 'UPDATE');
         //rename deleted campaign
         @rename(PHPWCMS_CONTENT . 'ads/' . $adcampaign_id, PHPWCMS_CONTENT . 'ads/_deleted_' . time() . '_' . $adcampaign_id);
         headerRedirect(decode_entities(MODULE_HREF) . '&listcampaign=1');
     } elseif (isset($_GET['duplicate'])) {
         @_dbDuplicateRow('phpwcms_ads_campaign', 'adcampaign_id', intval($_GET['duplicate']), array('adcampaign_title' => '--SELF-- (' . generic_string(3) . ')', 'adcampaign_created' => 'SQL:NOW()', 'adcampaign_changed' => 'SQL:NOW()', 'adcampaign_curview' => '0', 'adcampaign_curclick' => '0', 'adcampaign_curviewuser' => '0'));
         headerRedirect(decode_entities(MODULE_HREF) . '&listcampaign=1');
     }
     // edit ad place
 } elseif (!empty($_GET['adplace'])) {
     if (isset($_GET['edit'])) {
         // handle posts and read data
         include_once $phpwcms['modules'][$module]['path'] . 'inc/processing.adplace.inc.php';
         // edit campaign form
         include_once $phpwcms['modules'][$module]['path'] . 'backend.form.adplace.php';
     } elseif (isset($_GET['verify'])) {
         // active/inactive
         $sql = 'UPDATE ' . DB_PREPEND . 'phpwcms_ads_place SET ';
         $sql .= "adplace_status=" . (intval($_GET['verify']) ? 1 : 0) . " ";
         $sql .= "WHERE adplace_id=" . intval($_GET['editid']);
         @_dbQuery($sql, 'UPDATE');