// 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');
$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');