function tep_expire_featured()
{
$featured_query = tep_db_query("select featured_id from " . TABLE_FEATURED . " where status = '1' and now() >= expires_date and expires_date > 0");
if (tep_db_num_rows($featured_query)) {
while ($featured = tep_db_fetch_array($featured_query)) {
tep_set_featured_status($featured['featured_id'], '0');
}
}
}
function tep_expire_featured()
{
$featured_query = tep_db_query("SELECT products_id from " . TABLE_PRODUCTS . " where products_featured = '1' and now() >= products_featured_until and products_featured_until > 0");
if (tep_db_num_rows($featured_query)) {
while ($featured = tep_db_fetch_array($featured_query)) {
tep_set_featured_status($featured['products_id'], '0');
}
}
}
require 'includes/application_top.php';
function tep_set_featured_status($featured_id, $status)
{
if ($status == '1') {
return tep_db_query("update " . TABLE_FEATURED . " set status = '1', expires_date = NULL, date_status_change = NULL where featured_id = '" . $featured_id . "'");
} elseif ($status == '0') {
return tep_db_query("update " . TABLE_FEATURED . " set status = '0', date_status_change = now() where featured_id = '" . $featured_id . "'");
} else {
return -1;
}
}
require DIR_WS_CLASSES . 'currencies.php';
$currencies = new currencies();
switch ($_GET['action']) {
case 'setflag':
tep_set_featured_status($_GET['id'], $_GET['flag']);
tep_redirect(tep_href_link(FILENAME_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'];
}
tep_db_query("insert into " . TABLE_FEATURED . " (products_id, featured_date_added, expires_date, status) values ('" . $_POST['products_id'] . "', now(), '" . $expires_date . "', '1')");
tep_redirect(tep_href_link(FILENAME_FEATURED, 'page=' . $_GET['page']));
break;
case 'update':
$expires_date = '';
if ($_POST['day'] && $_POST['month'] && $_POST['year']) {
