/**
 * 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();
    }
}
Esempio n. 2
0
        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 = '';