PHP xos_set_banner_status Examples

Example #1

File: banner.php Project: bamper/xos_shop_system

function xos_expire_banners()
{
    $banners_query = xos_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 (xos_db_num_rows($banners_query)) {
        while ($banners = xos_db_fetch_array($banners_query)) {
            if (xos_not_null($banners['expires_date'])) {
                if (date('Y-m-d H:i:s') >= $banners['expires_date']) {
                    xos_set_banner_status($banners['banners_id'], '0');
                }
            } elseif (xos_not_null($banners['expires_impressions'])) {
                if ($banners['expires_impressions'] > 0 && $banners['banners_shown'] >= $banners['expires_impressions']) {
                    xos_set_banner_status($banners['banners_id'], '0');
                }
            }
        }
    }
}

Example #2

File: banner_manager.php Project: bamper/xos_shop_system

//              osCommerce, Open Source E-Commerce Solutions
//              http://www.oscommerce.com
//              Copyright (c) 2003 osCommerce
//              filename: banner_manager.php
//
//              Released under the GNU General Public License
////////////////////////////////////////////////////////////////////////////////
require 'includes/application_top.php';
if (!(@(include DIR_FS_SMARTY . 'admin/templates/' . ADMIN_TPL . '/php/' . FILENAME_BANNER_MANAGER) == 'overwrite_all')) {
    $action = isset($_GET['action']) ? $_GET['action'] : '';
    $banner_extension = xos_banner_image_extension();
    if (xos_not_null($action)) {
        switch ($action) {
            case 'setflag':
                if ($_GET['flag'] == '0' || $_GET['flag'] == '1') {
                    xos_set_banner_status($_GET['bID'], $_GET['flag']);
                    $messageStack->add_session('header', SUCCESS_BANNER_STATUS_UPDATED, 'success');
                } else {
                    $messageStack->add_session('header', ERROR_UNKNOWN_STATUS_FLAG, 'error');
                }
                xos_redirect(xos_href_link(FILENAME_BANNER_MANAGER, 'page=' . $_GET['page'] . '&bID=' . $_GET['bID']));
                break;
            case 'insert':
            case 'update':
                if (isset($_POST['banners_id'])) {
                    $banners_id = xos_db_prepare_input($_POST['banners_id']);
                }
                $banners_title = xos_db_prepare_input($_POST['banners_title']);
                $banners_url = xos_db_prepare_input($_POST['banners_url']);
                $new_banners_group = xos_db_prepare_input($_POST['new_banners_group']);
                $banners_group = empty($new_banners_group) ? xos_db_prepare_input($_POST['banners_group']) : $new_banners_group;