<?php /** * Side Box Template * * @package templateSystem * @copyright Copyright 2003-2005 Zen Cart Development Team * @copyright Portions Copyright 2003 osCommerce * @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0 * @version $Id: tpl_banner_box_all.php 2982 2006-02-07 07:56:41Z birdbrain $ */ $content = ''; $content .= '<div id="' . str_replace('_', '-', $box_id . 'Content') . '" class="sideBoxContent centeredContent">'; // select banners_group to be used $new_banner_search = zen_build_banners_group(SHOW_BANNERS_GROUP_SET_ALL); // secure pages switch ($request_type) { case 'SSL': $my_banner_filter = " and banners_on_ssl= " . "1 "; break; case 'NONSSL': $my_banner_filter = ''; break; } $sql = "select banners_id from " . TABLE_BANNERS . " where status = 1 " . $new_banner_search . $my_banner_filter . " order by banners_sort_order"; $banners_all = $db->Execute($sql); // if no active banner in the specified banner group then the box will not show $banner_cnt = 0; while (!$banners_all->EOF) { $banner_cnt++; $banner = zen_banner_exists('dynamic', SHOW_BANNERS_GROUP_SET_ALL);
function zen_banner_exists($action, $identifier) { global $db; $my_page_ssl = $_SERVER['HTTPS']; switch (true) { case $my_page_ssl == 'on': $my_banner_filter = " and banners_on_ssl= " . "'1' "; break; case $my_page_ssl == 'off': $my_banner_filter = ''; break; } if ($action == 'dynamic') { $new_banner_search = zen_build_banners_group($identifier); return $db->Execute("select banners_id, banners_title, banners_image, banners_html_text, banners_open_new_windows\r\n from " . TABLE_BANNERS . "\r\n where status = '1' " . $new_banner_search . $my_banner_filter . " order by rand()"); } elseif ($action == 'static') { $banner_query = "select banners_id, banners_title, banners_image, banners_html_text, banners_open_new_windows\r\n from " . TABLE_BANNERS . "\r\n where status = '1'\r\n and banners_id = '" . (int) $identifier . "'" . $my_banner_filter; return $banner = $db->Execute($banner_query); } else { return false; } }
function zen_banner_exists($action, $identifier) { global $db, $request_type; switch ($request_type) { case 'SSL': $my_banner_filter = " and banners_on_ssl= " . "1 "; break; case 'NONSSL': $my_banner_filter = ''; break; } if ($action == 'dynamic') { $new_banner_search = zen_build_banners_group($identifier); return $db->Execute("select banners_id, banners_title, banners_image, banners_html_text, banners_open_new_windows, banners_url\n from " . TABLE_BANNERS . "\n where status = 1 " . $new_banner_search . $my_banner_filter . " order by rand()"); } elseif ($action == 'static') { $banner_query = "select banners_id, banners_title, banners_image, banners_html_text, banners_open_new_windows, banners_url\n from " . TABLE_BANNERS . "\n where status = 1\n and banners_id = '" . (int) $identifier . "'" . $my_banner_filter; return $banner = $db->Execute($banner_query); } else { return false; } }
function zen_banner_exists($action, $identifier) { global $gBitDb; if (!empty($_SERVER['HTTPS']) && $_SERVER['HTTPS'] == 'on') { $my_banner_filter = " and `banners_on_ssl`= " . "'1' "; } else { $my_banner_filter = ''; } if ($action == 'dynamic') { $new_banner_search = zen_build_banners_group($identifier); return $gBitDb->Execute("SELECT `banners_id`, `banners_title`, `banners_image`, `banners_html_text`, `banners_open_new_windows`\n FROM " . TABLE_BANNERS . "\n WHERE `status` = '1' " . $new_banner_search . $my_banner_filter . " order by " . $gBitDb->convertSortmode('random')); } elseif ($action == 'static') { $banner_query = "select `banners_id`, `banners_title`, `banners_image`, `banners_html_text`, `banners_open_new_windows`\n from " . TABLE_BANNERS . "\n where `status` = '1'\n and `banners_id` = '" . (int) $identifier . "'" . $my_banner_filter; return $banner = $gBitDb->Execute($banner_query); } else { return false; } }