function tep_expire_specials() { $specials_query = tep_db_query("select specials_id from " . TABLE_SPECIALS . " where status = '1' and now() >= expires_date and expires_date > 0"); if (tep_db_num_rows($specials_query)) { while ($specials = tep_db_fetch_array($specials_query)) { tep_set_specials_status($specials['specials_id'], '0'); } } }
function tep_expire_specials() { $OSCOM_Db = Registry::get('Db'); $Qspecials = $OSCOM_Db->query('select specials_id from :table_specials where status = 1 and now() >= expires_date and expires_date > 0'); if ($Qspecials->fetch() !== false) { do { tep_set_specials_status($Qspecials->valueInt('specials_id'), 0); } while ($Qspecials->fetch()); } }
osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2003 osCommerce Released under the GNU General Public License */ require 'includes/application_top.php'; require DIR_WS_CLASSES . 'currencies.php'; $currencies = new currencies(); $action = isset($HTTP_GET_VARS['action']) ? $HTTP_GET_VARS['action'] : ''; if (tep_not_null($action)) { switch ($action) { case 'setflag': tep_set_specials_status($HTTP_GET_VARS['id'], $HTTP_GET_VARS['flag']); tep_redirect(tep_href_link(FILENAME_SPECIALS, (isset($HTTP_GET_VARS['page']) ? 'page=' . $HTTP_GET_VARS['page'] . '&' : '') . 'sID=' . $HTTP_GET_VARS['id'], 'NONSSL')); break; case 'insert': $products_id = tep_db_prepare_input($HTTP_POST_VARS['products_id']); $products_price = tep_db_prepare_input($HTTP_POST_VARS['products_price']); $specials_price = tep_db_prepare_input($HTTP_POST_VARS['specials_price']); $day = tep_db_prepare_input($HTTP_POST_VARS['day']); $month = tep_db_prepare_input($HTTP_POST_VARS['month']); $year = tep_db_prepare_input($HTTP_POST_VARS['year']); if (substr($specials_price, -1) == '%') { $new_special_insert_query = tep_db_query("select products_id, products_price from " . TABLE_PRODUCTS . " where products_id = '" . (int) $products_id . "'"); $new_special_insert = tep_db_fetch_array($new_special_insert_query); $products_price = $new_special_insert['products_price']; $specials_price = $products_price - $specials_price / 100 * $products_price; }
osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2014 osCommerce Released under the GNU General Public License */ require 'includes/application_top.php'; require DIR_WS_CLASSES . 'currencies.php'; $currencies = new currencies(); $action = isset($_GET['action']) ? $_GET['action'] : ''; if (tep_not_null($action)) { switch ($action) { case 'setflag': tep_set_specials_status($_GET['id'], $_GET['flag']); tep_redirect(tep_href_link(FILENAME_SPECIALS, (isset($_GET['page']) ? 'page=' . $_GET['page'] . '&' : '') . 'sID=' . $_GET['id'])); break; case 'insert': $products_id = tep_db_prepare_input($_POST['products_id']); $products_price = tep_db_prepare_input($_POST['products_price']); $specials_price = tep_db_prepare_input($_POST['specials_price']); $expdate = tep_db_prepare_input($_POST['expdate']); if (substr($specials_price, -1) == '%') { $new_special_insert_query = tep_db_query("select products_id, products_price from " . TABLE_PRODUCTS . " where products_id = '" . (int) $products_id . "'"); $new_special_insert = tep_db_fetch_array($new_special_insert_query); $products_price = $new_special_insert['products_price']; $specials_price = $products_price - $specials_price / 100 * $products_price; } $expires_date = ''; if (tep_not_null($expdate)) {
if (tep_db_field_exists(TABLE_SPECIALS_TYPES, $field)) { $type_info_query = tep_db_query("select " . tep_db_input($field) . " as field from " . TABLE_SPECIALS_TYPES . " where specials_types_id = '" . (int) $specials_types_id . "' and language_id = '" . (int) $language_id . "'"); $type_info = tep_db_fetch_array($type_info_query); return $type_info['field']; } else { return false; } } if (tep_not_null($action)) { switch ($action) { case 'setflag': $new_status = (int) $HTTP_GET_VARS['flag']; if (isset($HTTP_GET_VARS['tID'])) { tep_db_query("update " . TABLE_SPECIALS_TYPES . " set specials_types_status = '" . $new_status . "', last_modified = now(), specials_last_modified = now() where specials_types_id = '" . (int) $HTTP_GET_VARS['tID'] . "'"); } elseif (isset($HTTP_GET_VARS['sID'])) { tep_set_specials_status($HTTP_GET_VARS['sID'], $new_status); } tep_redirect(tep_href_link(FILENAME_SPECIALS, tep_get_all_get_params(array('action', 'flag')))); break; case 'update': case 'insert': $products_id = tep_db_prepare_input($HTTP_POST_VARS['products_id']); $specials_price = tep_db_prepare_input($HTTP_POST_VARS['specials_price']); $specials_price = str_replace(',', '.', $specials_price); $day = tep_db_prepare_input($HTTP_POST_VARS['day']); $month = tep_db_prepare_input($HTTP_POST_VARS['month']); $year = tep_db_prepare_input($HTTP_POST_VARS['year']); if ($action == 'update') { $specials_id = tep_db_prepare_input($HTTP_POST_VARS['specials_id']); } else { $max_id_query = tep_db_query("select max(specials_id) as max_id from " . TABLE_SPECIALS . "");