function vam_activate_banners() { $banners_query = vam_db_query("select banners_id, date_scheduled from " . TABLE_BANNERS . " where date_scheduled != ''"); if (vam_db_num_rows($banners_query)) { while ($banners = vam_db_fetch_array($banners_query)) { if (date('Y-m-d H:i:s') >= $banners['date_scheduled']) { vam_set_banner_status($banners['banners_id'], '1'); } } } }
function vam_expire_banners() { $banners_query = vam_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 (vam_db_num_rows($banners_query)) { while ($banners = vam_db_fetch_array($banners_query)) { if (vam_not_null($banners['expires_date'])) { if (date('Y-m-d H:i:s') >= $banners['expires_date']) { vam_set_banner_status($banners['banners_id'], '0'); } } elseif (vam_not_null($banners['expires_impressions'])) { if ($banners['banners_shown'] >= $banners['expires_impressions']) { vam_set_banner_status($banners['banners_id'], '0'); } } } } }
-------------------------------------------------------------- based on: (c) 2000-2001 The Exchange Project (earlier name of osCommerce) (c) 2002-2003 osCommerce(banner_manager.php,v 1.70 2003/03/22); www.oscommerce.com (c) 2003 nextcommerce (banner_manager.php,v 1.9 2003/08/18); www.nextcommerce.org (c) 2004 xt:Commerce (banner_manager.php,v 1.9 2003/08/18); xt-commerce.com Released under the GNU General Public License --------------------------------------------------------------*/ require 'includes/application_top.php'; $banner_extension = vam_banner_image_extension(); if ($_GET['action']) { switch ($_GET['action']) { case 'setflag': if ($_GET['flag'] == '0' || $_GET['flag'] == '1') { vam_set_banner_status($_GET['bID'], $_GET['flag']); $messageStack->add_session(SUCCESS_BANNER_STATUS_UPDATED, 'success'); } else { $messageStack->add_session(ERROR_UNKNOWN_STATUS_FLAG, 'error'); } vam_redirect(vam_href_link(FILENAME_BANNER_MANAGER, 'page=' . $_GET['page'] . '&bID=' . (int) $_GET['bID'])); break; case 'insert': case 'update': $banners_id = vam_db_prepare_input($_POST['banners_id']); $banners_title = vam_db_prepare_input($_POST['banners_title']); $banners_url = vam_db_prepare_input($_POST['banners_url']); $new_banners_group = vam_db_prepare_input($_POST['new_banners_group']); $banners_group = empty($new_banners_group) ? vam_db_prepare_input($_POST['banners_group']) : $new_banners_group; $html_text = vam_db_prepare_input($_POST['html_text']); $banners_image_local = vam_db_prepare_input($_POST['banners_image_local']);
Contribution based on: osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2002 - 2003 osCommerce Released under the GNU General Public License ---------------------------------------------------------------------------*/ require 'includes/application_top.php'; $affiliate_banner_extension = vam_banner_image_extension(); if ($_GET['action']) { switch ($_GET['action']) { case 'setaffiliate_flag': if ($_GET['affiliate_flag'] == '0' || $_GET['affiliate_flag'] == '1') { vam_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'); } vam_redirect(vam_href_link(FILENAME_AFFILIATE_BANNER_MANAGER, 'page=' . $_GET['page'] . '&abID=' . $_GET['abID'])); break; case 'insert': case 'update': $affiliate_banners_id = vam_db_prepare_input($_POST['affiliate_banners_id']); $affiliate_banners_title = vam_db_prepare_input($_POST['affiliate_banners_title']); $affiliate_products_id = vam_db_prepare_input($_POST['affiliate_products_id']); $new_affiliate_banners_group = vam_db_prepare_input($_POST['new_affiliate_banners_group']); $affiliate_banners_group = empty($new_affiliate_banners_group) ? vam_db_prepare_input($_POST['affiliate_banners_group']) : $new_affiliate_banners_group; $affiliate_banners_image_target = vam_db_prepare_input($_POST['affiliate_banners_image_target']); $affiliate_banners_image_local = vam_db_prepare_input($_POST['affiliate_banners_image_local']);