function olc_activate_banners()
{
$banners_query = olc_db_query("select banners_id, date_scheduled from " . TABLE_BANNERS . " where date_scheduled != ''");
if (olc_db_num_rows($banners_query)) {
while ($banners = olc_db_fetch_array($banners_query)) {
if (date('Y-m-d H:i:s') >= $banners['date_scheduled']) {
olc_set_banner_status($banners['banners_id'], '1');
}
}
}
}
function olc_expire_banners()
{
$banners_query = olc_db_query("select b.banners_id, b.expires_date, b.expires_impressions, sum(bh.banners_shown) as banners_shown from " . TABLE_BANNERS . " b, " . TABLE_BANNERS_HISTORY . " bh where b.status = '1' and b.banners_id = bh.banners_id group by b.banners_id");
if (olc_db_num_rows($banners_query)) {
while ($banners = olc_db_fetch_array($banners_query)) {
if (olc_not_null($banners['expires_date'])) {
if (date('Y-m-d H:i:s') >= $banners['expires_date']) {
olc_set_banner_status($banners['banners_id'], '0');
}
} elseif (olc_not_null($banners['expires_impressions'])) {
if ($banners['banners_shown'] >= $banners['expires_impressions']) {
olc_set_banner_status($banners['banners_id'], '0');
}
}
}
}
}
Copyright (c) 2002 - 2003 osCommerce
Copyright (c) 2003 netz-designer
Copyright (c) 2005 OL-Commerce , 2006 Dipl.-Ing.(TH) Winfried Kaiser (w.kaiser@fortune.de, info@seifenparadies.de)
Copyright (c) 2002 - 2003 osCommerce
Released under the GNU General Public License
---------------------------------------------------------------------------*/
$div_field = '<div id="spiffycalendar" class="text"></div>';
require 'includes/application_top.php';
$affiliate_banner_extension = olc_banner_image_extension();
if ($_GET['action']) {
switch ($_GET['action']) {
case 'setaffiliate_flag':
if ($_GET['affiliate_flag'] == '0' || $_GET['affiliate_flag'] == '1') {
olc_set_banner_status($_GET['abID'], $_GET['affiliate_flag']);
$messageStack->add_session(SUCCESS_BANNER_STATUS_UPDATED, 'success');
} else {
$messageStack->add_session(ERROR_UNKNOWN_STATUS_FLAG, 'error');
}
olc_redirect(olc_href_link(FILENAME_AFFILIATE_BANNER_MANAGER, 'page=' . $_GET['page'] . '&abID=' . $_GET['abID']));
break;
case 'insert':
case 'update':
$affiliate_banners_id = olc_db_prepare_input($_POST['affiliate_banners_id']);
$affiliate_banners_title = olc_db_prepare_input($_POST['affiliate_banners_title']);
$affiliate_products_id = olc_db_prepare_input($_POST['affiliate_products_id']);
$new_affiliate_banners_group = olc_db_prepare_input($_POST['new_affiliate_banners_group']);
$affiliate_banners_group = empty($new_affiliate_banners_group) ? olc_db_prepare_input($_POST['affiliate_banners_group']) : $new_affiliate_banners_group;
$affiliate_banners_image_target = olc_db_prepare_input($_POST['affiliate_banners_image_target']);
$affiliate_banners_image_local = olc_db_prepare_input($_POST['affiliate_banners_image_local']);
Released under the GNU General Public License
--------------------------------------------------------------*/
$div_field = '<div id="spiffycalendar" class="text"></div>';
require 'includes/application_top.php';
$banner_extension = olc_banner_image_extension();
$page = $_GET['page'];
$page_parameter = 'page=' . $page;
$action = $_GET['action'];
$flag = $_GET['flag'];
$bID = olc_db_prepare_input($_GET['bID']);
if ($action) {
switch ($action) {
case 'setflag':
if ($flag == '0' || $flag == '1') {
olc_set_banner_status($bID, $flag);
$messageStack->add_session(SUCCESS_BANNER_STATUS_UPDATED, 'success');
} else {
$messageStack->add_session(ERROR_UNKNOWN_STATUS_FLAG, 'error');
}
olc_redirect(olc_href_link(FILENAME_BANNER_MANAGER, $page_parameter . '&bID=' . $bID));
break;
case 'insert':
case 'update':
$banners_id = olc_db_prepare_input($_POST['banners_id']);
$banners_title = olc_db_prepare_input($_POST['banners_title']);
$banners_url = olc_db_prepare_input($_POST['banners_url']);
$new_banners_group = olc_db_prepare_input($_POST['new_banners_group']);
$banners_group = empty($new_banners_group) ? olc_db_prepare_input($_POST['banners_group']) : $new_banners_group;
$html_text = olc_db_prepare_input($_POST['html_text']);
$banners_image_local = olc_db_prepare_input($_POST['banners_image_local']);
