/** * Auto expire featured products */ function oos_expire_featured() { // Get database information $dbconn =& oosDBGetConn(); $oostable =& oosDBGetTables(); $featuredtable = $oostable['featured']; $sql = "SELECT featured_id\n FROM {$featuredtable}\n WHERE status = '1'\n AND now() >= expires_date\n AND expires_date > 0"; if (USE_DB_CACHE == '1') { $featured_result = $dbconn->CacheExecute(15, $sql); } else { $featured_result = $dbconn->Execute($sql); } if (!$featured_result) { return; } if ($featured_result->RecordCount() > 0) { while ($featured = $featured_result->fields) { oos_set_featured_status($featured['featured_id'], '0'); // Move that ADOdb pointer! $featured_result->MoveNext(); } // Close result set $featured_result->Close(); } }
return $dbconn->Execute("UPDATE {$featuredtable} SET status = '0', date_status_change = '" . date("Y-m-d H:i:s", time()) . "' WHERE featured_id = '" . (int) $featured_id . "'"); } else { return -1; } } $language = $_SESSION['language']; require 'includes/classes/class_currencies.php'; $currencies = new currencies(); if (!isset($_GET['page']) || isset($_GET['page']) && !is_numeric($_GET['page'])) { $_GET['page'] = 1; } $action = isset($_GET['action']) ? $_GET['action'] : ''; if (!empty($action)) { switch ($action) { case 'setflag': oos_set_featured_status($_GET['id'], $_GET['flag']); oos_redirect_admin(oos_href_link_admin($aFilename['featured'], '', 'NONSSL')); break; case 'insert': $expires_date = ''; if ($_POST['day'] && $_POST['month'] && $_POST['year']) { $expires_date = $_POST['year']; $expires_date .= strlen($_POST['month']) == 1 ? '0' . $_POST['month'] : $_POST['month']; $expires_date .= strlen($_POST['day']) == 1 ? '0' . $_POST['day'] : $_POST['day']; } $featuredtable = $oostable['featured']; $dbconn->Execute("INSERT INTO {$featuredtable} (products_id, featured_date_added, expires_date, status) VALUES ('" . $_POST['products_id'] . "', '" . date("Y-m-d H:i:s", time()) . "', '" . $expires_date . "', '1')"); oos_redirect_admin(oos_href_link_admin($aFilename['featured'], 'page=' . $_GET['page'])); break; case 'update': $expires_date = '';