/**
* Auto expire banners
*/
function oos_expire_banners()
{
// Get database information
$dbconn =& oosDBGetConn();
$oostable =& oosDBGetTables();
$bannerstable = $oostable['banners'];
$banners_historytable = $oostable['banners_history'];
$banners_result = $dbconn->Execute("SELECT b.banners_id, b.expires_date, b.expires_impressions, sum(bh.banners_shown) as banners_shown FROM {$bannerstable} b, {$banners_historytable} bh WHERE b.status = '1' AND b.banners_id = bh.banners_id GROUP BY b.banners_id, b.expires_date, b.expires_impressions");
if ($banners_result->RecordCount() > 0) {
while ($banners = $banners_result->fields) {
if (oos_is_not_null($banners['expires_date'])) {
if (date('Y-m-d H:i:s') >= $banners['expires_date']) {
oos_set_banner_status($banners['banners_id'], '0');
}
} elseif (oos_is_not_null($banners['expires_impressions'])) {
if ($banners['banners_shown'] >= $banners['expires_impressions']) {
oos_set_banner_status($banners['banners_id'], '0');
}
}
// Move that ADOdb pointer!
$banners_result->MoveNext();
}
}
}
osCommerce, Open Source E-Commerce Solutions
http://www.oscommerce.com
Copyright (c) 2003 osCommerce
----------------------------------------------------------------------
Released under the GNU General Public License
---------------------------------------------------------------------- */
define('OOS_VALID_MOD', 'yes');
require 'includes/oos_main.php';
$banner_extension = oos_banner_image_extension();
$action = isset($_GET['action']) ? $_GET['action'] : '';
if (!empty($action)) {
switch ($action) {
case 'setflag':
if ($_GET['flag'] == '0' || $_GET['flag'] == '1') {
oos_set_banner_status($_GET['bID'], $_GET['flag']);
$messageStack->add_session(SUCCESS_BANNER_STATUS_UPDATED, 'success');
} else {
$messageStack->add_session(ERROR_UNKNOWN_STATUS_FLAG, 'error');
}
oos_redirect_admin(oos_href_link_admin($aFilename['banner_manager'], 'page=' . $_GET['page'] . '&bID=' . $_GET['bID']));
break;
case 'insert':
case 'update':
$banners_group = empty($new_banners_group) ? oos_db_prepare_input($_POST['banners_group']) : $new_banners_group;
$banners_image = oos_get_uploaded_file('banners_image');
$db_image_location = '';
$image_directory = oos_get_local_path(OOS_ABSOLUTE_PATH . OOS_IMAGES . $banners_image_target);
$banner_error = false;
if (empty($banners_title)) {
$messageStack->add(ERROR_BANNER_TITLE_REQUIRED, 'error');
