/** * Return Page Type * * @return array */ function oosGetPageType() { $page_type_array = array(); // Get database information $dbconn =& oosDBGetConn(); $oostable =& oosDBGetTables(); $page_type_sql = "SELECT page_type_id, page_type_name FROM " . $oostable['page_type'] . " WHERE page_type_languages_id = '" . intval($_SESSION['language_id']) . "' ORDER BY page_type_id"; $page_type_result = $dbconn->Execute($page_type_sql); while ($page_type = $page_type_result->fields) { $page_type_array[] = array('id' => $page_type['page_type_id'], 'text' => $page_type['page_type_name'] ); // Move that ADOdb pointer! $page_type_result->MoveNext(); } // Close result set $page_type_result->Close(); return $page_type_array; }
function create_plugin_instance() { // Get database information $dbconn =& oosDBGetConn(); $oostable =& oosDBGetTables(); if (isset($_SESSION['customer_id'])) { $wo_customer_id = $_SESSION['customer_id']; $wo_full_name = addslashes($_SESSION['customer_first_name'] . ' ' . $_SESSION['customer_lastname']); } else { $wo_customer_id = ''; $wo_full_name = 'Guest'; } $wo_session_id = oos_session_id(); $wo_ip_address = $_SESSION['session_ip_address']; $wo_last_page_url = addslashes(oos_server_get_var('REQUEST_URI')); $current_time = time(); $xx_mins_ago = $current_time - 900; // remove entries that have expired $whos_onlinetable = $oostable['whos_online']; $dbconn->Execute("DELETE FROM {$whos_onlinetable}\n WHERE time_last_click < '" . oos_db_input($xx_mins_ago) . "'"); $whos_onlinetable = $oostable['whos_online']; $query = "SELECT COUNT(*) AS total\n FROM {$whos_onlinetable}\n WHERE session_id = '" . oos_db_input($wo_session_id) . "'"; $stored_customer = $dbconn->Execute($query); if ($stored_customer->fields['total'] > 0) { $whos_onlinetable = $oostable['whos_online']; $query = "UPDATE {$whos_onlinetable}" . " SET customer_id = ?, full_name = ?, ip_address = ?, time_last_click = ?, last_page_url = ?" . " WHERE session_id = ?"; $result =& $dbconn->Execute($query, array((string) $wo_customer_id, (string) $wo_full_name, (string) $wo_ip_address, (string) $current_time, (string) $wo_last_page_url, (string) $wo_session_id)); } else { $whos_onlinetable = $oostable['whos_online']; $dbconn->Execute("INSERT INTO " . $whos_onlinetable . "\n (customer_id,\n full_name,\n session_id,\n ip_address,\n time_entry,\n time_last_click,\n last_page_url) VALUES ('" . oos_db_input($wo_customer_id) . "',\n '" . oos_db_input($wo_full_name) . "',\n '" . oos_db_input($wo_session_id) . "',\n '" . oos_db_input($wo_ip_address) . "',\n '" . oos_db_input($current_time) . "',\n '" . oos_db_input($current_time) . "',\n '" . oos_db_input($wo_last_page_url) . "')"); } return true; }
public function __construct() { $this->currencies = array(); // Get database information $dbconn =& oosDBGetConn(); $oostable =& oosDBGetTables(); $query = "SELECT code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value FROM " . $oostable['currencies']; $result =& $dbconn->Execute($query); while ($currencies = $result->fields) { $this->currencies[$currencies['code']] = array('title' => $currencies['title'], 'symbol_left' => $currencies['symbol_left'], 'symbol_right' => $currencies['symbol_right'], 'decimal_point' => $currencies['decimal_point'], 'thousands_point' => $currencies['thousands_point'], 'decimal_places' => $currencies['decimal_places'], 'value' => $currencies['value']); // Move that ADOdb pointer! $result->MoveNext(); } }
/** * 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(); } }
/** * Update the Customers GV account * * @param $customer_id * @param $gv_id */ function oos_gv_account_update($customer_id, $gv_id) { // Get database information $dbconn =& oosDBGetConn(); $oostable =& oosDBGetTables(); $coupon_gv_query = "SELECT coupon_amount FROM " . $oostable['coupons'] . " WHERE coupon_id = '" . $gv_id . "'"; $coupon_gv_result =& $dbconn->Execute($coupon_gv_query); $coupon_gv = $coupon_gv_result->fields; if ($customer_gv_result->RecordCount() > 0) { $customer_gv_query = "SELECT amount FROM " . $oostable['coupon_gv_customer'] . " WHERE customer_id = '" . $customer_id . "'"; $customer_gv_result =& $dbconn->Execute($customer_gv_query); $customer_gv = $customer_gv_result->fields; $new_gv_amount = $customer_gv['amount'] + $coupon_gv['coupon_amount']; $gv_query = "UPDATE " . $oostable['coupon_gv_customer'] . " SET amount = '" . $new_gv_amount . "'"; $result =& $dbconn->Execute($gv_query); } else { $gv_query = "INSERT INTO " . $oostable['coupon_gv_customer'] . " (customer_id, amount) VALUES ('" . $customer_id . "', '" . $coupon_gv['coupon_amount'] . "'"; $result =& $dbconn->Execute($gv_query); } }
/** * Auto expire products on special */ function oos_expire_spezials() { // Get database information $dbconn =& oosDBGetConn(); $oostable =& oosDBGetTables(); $specialstable = $oostable['specials']; $query = "SELECT specials_id FROM $specialstable WHERE status = '1' AND now() >= expires_date AND expires_date > 0"; if (USE_DB_CACHE == '1') { $result =& $dbconn->CacheExecute(3600, $query); } else { $result =& $dbconn->Execute($query); } if (!$result) {return;} if ($result->RecordCount() > 0) { while ($specials = $result->fields) { oos_set_specials_status($specials['specials_id'], '0'); // Move that ADOdb pointer! $result->MoveNext(); } } }
/** * This will return a list of customers with sessions. Handles * either the mysql or file ase * * Returns an empty array if the check sessions flag is not true * (empty array means same SQL statement can be used) !!!!! * * * @return string */ function _GetCustomerSessions() { $cust_ses_ids = 0; if (RCS_CHECK_SESSIONS == '1') { $dbconn =& oosDBGetConn(); $oostable =& oosDBGetTables(); // remove entries that have expired $xx_mins_ago = (time() - 900); $whos_onlinetable = $oostable['whos_online']; $dbconn->Execute("DELETE FROM $whos_onlinetable WHERE time_last_click < '" . $xx_mins_ago . "'"); $whos_onlinetable = $oostable['whos_online']; $sql = "SELECT customer_id FROM $whos_onlinetable"; $whos_online_result = $dbconn->Execute($sql); while ($whos_online = $whos_online_result->fields) { $cust_ses_ids .= ', ' . $whos_online['customer_id']; // Move that ADOdb pointer! $whos_online_result->MoveNext(); } # $cust_ses_ids = substr($cust_ses_ids, 2); } return $cust_ses_ids; }
/** * Smarty {oos_address_label} function plugin * * Type: function * Name: oos_address_label * Version: 1.0 * ------------------------------------------------------------- */ function smarty_function_oos_address_label($params, &$smarty) { $customers_id = ''; $address_id = 1; $html = true; $boln = ''; $eoln = '<br>'; MyOOS_CoreApi::requireOnce('lib/smarty/libs/plugins/shared.escape_special_chars.php'); MyOOS_CoreApi::requireOnce('lib/smarty-plugins/myoos/function.oos_address_format.php'); foreach($params as $_key => $_val) { $$_key = smarty_function_escape_special_chars($_val); } $dbconn =& oosDBGetConn(); $oostable =& oosDBGetTables(); $address_result = $dbconn->Execute("SELECT entry_firstname AS firstname, entry_lastname AS lastname, entry_company AS company, entry_street_address AS street_address, entry_suburb AS suburb, entry_city AS city, entry_postcode AS postcode, entry_state AS state, entry_zone_id AS zone_id, entry_country_id AS country_id FROM " . $oostable['address_book'] . " WHERE customers_id = '" . (int)$customers_id . "' AND address_book_id = '" . (int)$address_id . "'"); $address = $address_result->fields; $format_id = oos_get_address_format_id($address['country_id']); return smarty_function_oos_address_format(array('address_format_id' => $format_id, 'address' => $address, 'html' => $html), $smarty); }
function set($sLang = '') { if (!empty($sLang) && $this->exists($sLang) === true) { $this->language = $this->get($sLang); } else { $this->language = $this->get(DEFAULT_LANGUAGE); } /* if (!isset($_COOKIE['language']) || (isset($_COOKIE['language']) && ($_COOKIE['language'] != $this->language['iso_639_2']))) { oos_setcookie('language', $this->language['iso_639_2'], time()+60*60*24*90); } */ $_SESSION['language'] = $this->language['iso_639_2']; $_SESSION['language_id'] = $this->language['id']; $_SESSION['iso_639_1'] = $this->language['iso_639_1']; $_SESSION['languages_name'] = $this->language['name']; if (isset($_SESSION['customer_id'])) { $dbconn =& oosDBGetConn(); $oostable =& oosDBGetTables(); $sLanguage = oos_var_prep_for_os($this->language['iso_639_2']); $customerstable = $oostable['customers']; $query = "UPDATE {$customerstable} SET customers_language =? WHERE customers_id =?"; $result =& $dbconn->Execute($query, array($sLanguage, (int) $_SESSION['customer_id'])); } }
/** * Retreive server information * * @return array */ function oosGetSystemInformation() { // Get database information $dbconn =& oosDBGetConn(); $oostable =& oosDBGetTables(); $db_host = $dbconn->host; $db_database = $dbconn->database; $phpv = phpversion(); $db_result = $dbconn->ServerInfo($oostable['countries']); list($system, $host, $kernel) = preg_split('/[\s,]+/', @exec('uname -a'), 5); return array('date' => oos_datetime_short(date('Y-m-d H:i:s')), 'system' => $_ENV["OS"], 'kernel' => $kernel, 'host' => $host, 'ip' => gethostbyname($host), 'uptime' => @exec('uptime'), 'HTTP_SERVER' => $_SERVER['SERVER_SOFTWARE'], 'php' => $phpv, 'zend' => (function_exists('zend_version') ? zend_version() : ''), 'db_server' => $db_host, 'db_ip' => gethostbyname(OOS_DB_SERVER), 'db_version' => OOS_DB_TYPE . $db_result['description'], 'db_database' => $db_database); }
/** * Constructor */ public function __construct($nCurrentPageNumber, $max_rows_per_page, &$sql_result, &$query_num_rows) { $dbconn =& oosDBGetConn(); if (empty($nCurrentPageNumber) || !is_numeric($nCurrentPageNumber)) $nCurrentPageNumber = 1; $pos_to = strlen($sql_result); $pos_from = strpos($sql_result, ' FROM', 0); $pos_group_by = strpos($sql_result, ' GROUP BY', $pos_from); if (($pos_group_by < $pos_to) && ($pos_group_by != false)) $pos_to = $pos_group_by; $pos_having = strpos($sql_result, ' HAVING', $pos_from); if (($pos_having < $pos_to) && ($pos_having != false)) $pos_to = $pos_having; $pos_order_by = strpos($sql_result, ' ORDER BY', $pos_from); if (($pos_order_by < $pos_to) && ($pos_order_by != false)) $pos_to = $pos_order_by; $pos_limit = strpos($sql_result, ' LIMIT', $pos_from); if (($pos_limit < $pos_to) && ($pos_limit != false)) $pos_to = $pos_limit; $pos_procedure = strpos($sql_result, ' PROCEDURE', $pos_from); if (($pos_procedure < $pos_to) && ($pos_procedure != false)) $pos_to = $pos_procedure; $offset = ($max_rows_per_page * ($nCurrentPageNumber - 1)); if ($offset < 0) $offset = 0; $sql_result .= " LIMIT " . max($offset, 0) . ", " . $max_rows_per_page; $sql = "SELECT COUNT(*) AS total " . substr($sql_result, $pos_from, ($pos_to - $pos_from)); $reviews_count = $dbconn->Execute($sql); $query_num_rows = $reviews_count->fields['total']; }
/** * Return the number of products in a category * * @param $category_id * @param $include_inactive * @return string */ function oos_count_products_in_category($category_id, $include_inactive = false) { $products_count = 0; $dbconn =& oosDBGetConn(); $oostable =& oosDBGetTables(); $productstable = $oostable['products']; $products_to_categoriestable = $oostable['products_to_categories']; if ($include_inactive == true) { $products = $dbconn->Execute("SELECT COUNT(*) AS total FROM {$productstable} p, {$products_to_categoriestable} p2c WHERE p.products_id = p2c.products_id AND p2c.categories_id = '" . intval($category_id) . "'"); } else { $products = $dbconn->Execute("SELECT COUNT(*) AS total FROM {$productstable} p, {$products_to_categoriestable} p2c WHERE p.products_id = p2c.products_id AND p.products_status >= '1' AND p2c.categories_id = '" . intval($category_id) . "'"); } $products_count += $products->fields['total']; $nGroupID = intval($_SESSION['member']->group['id']); $categoriestable = $oostable['categories']; $child_categories_result = $dbconn->Execute("SELECT categories_id FROM {$categoriestable} WHERE ( access = '0' OR access = '" . intval($nGroupID) . "' ) AND parent_id = '" . intval($category_id) . "'"); if ($child_categories_result->RecordCount()) { while ($child_categories = $child_categories_result->fields) { $products_count += oos_count_products_in_category($child_categories['categories_id'], $include_inactive); // Move that ADOdb pointer! $child_categories_result->MoveNext(); } } return $products_count; }
/** * Output a form pull down menu with geo zones * * @param $parameters * @param $selected * @return string */ function oosGeoZonesPullDown($parameters, $selected = '') { $select_string = '<select ' . $parameters . '>'; // Get database information $dbconn =& oosDBGetConn(); $oostable =& oosDBGetTables(); $geo_zonestable = $oostable['geo_zones']; $zones_sql = "SELECT geo_zone_id, geo_zone_name FROM $geo_zonestable ORDER BY geo_zone_name"; $result = $dbconn->Execute($zones_sql); while ($zones = $result->fields) { $select_string .= '<option value="' . $zones['geo_zone_id'] . '"'; if ($selected == $zones['geo_zone_id']) $select_string .= ' selected="selected"'; $select_string .= '>' . $zones['geo_zone_name'] . '</option>'; // Move that ADOdb pointer! $result->MoveNext(); } // Close result set $result->Close(); $select_string .= '</select>'; return $select_string; }
function walk($item1) { $item1 = str_replace(' ', '|', $item1); $item1 = str_replace('"', '', $item1); $item1 = str_replace("\n", '', $item1); $item1 = str_replace("\r", '', $item1); //$item1 = str_replace("",'',$item1); $item1 = str_replace('"', '\\"', $item1); $item1 = str_replace("'", '\\"', $item1); // echo $item1."<br>"; $item1 = chop($item1); echo $item1 . "<br>"; $items = explode("|", $item1); $products_id = $items[0]; $products_model = $items[1]; $products_name = $items[2]; $products_tax_class_id = $items[3]; $products_status = $items[4]; $products_price = $items[5]; $dbconn =& oosDBGetConn(); $oostable =& oosDBGetTables(); $tax_ratestable = $oostable['tax_rates']; $query = "SELECT tax_rate FROM {$tax_ratestable} WHERE tax_class_id = '" . intval($products_tax_class_id) . "'"; $tax = $dbconn->GetOne($query); $price = $products_price / ($tax + 100) * 100; $productstable = $oostable['products']; $dbconn->Execute("UPDATE {$productstable} set products_price = '" . $price . "', products_status = '" . intval($products_status) . "' where products_id = '" . intval($products_id) . "'"); }
function remove() { $dbconn =& oosDBGetConn(); $oostable =& oosDBGetTables(); $configurationtable = $oostable['configuration']; $dbconn->Execute("DELETE FROM {$configurationtable} WHERE configuration_key in ('" . implode("', '", $this->config_item()) . "')"); return true; }
function remove() { // Get database information $dbconn =& oosDBGetConn(); $oostable =& oosDBGetTables(); $configurationtable = $oostable['configuration']; $dbconn->Execute("DELETE FROM {$configurationtable} WHERE configuration_key in ('" . implode("', '", $this->keys()) . "')"); }
function idxsql($idxname, $table, $idxflds) { // Get database information $dbconn =& oosDBGetConn(); $oostable =& oosDBGetTables(); $dict = NewDataDictionary($dbconn); $sqlarray = $dict->CreateIndexSQL($idxname, $table, $idxflds); $dict->ExecuteSQLArray($sqlarray); }
function remove() { $dbconn =& oosDBGetConn(); $oostable =& oosDBGetTables(); $blocktable = $oostable['block']; $dbconn->Execute("UPDATE {$blocktable} SET block_status = 0 WHERE block_file = 'wishlist'"); $configurationtable = $oostable['configuration']; $dbconn->Execute("DELETE FROM {$configurationtable} WHERE configuration_key in ('" . implode("', '", $this->config_item()) . "')"); return true; }
function oos_get_manufacturer_url($manufacturer_id, $lang_id = '') { if (!$lang_id) { $lang_id = $_SESSION['language_id']; } // Get database information $dbconn =& oosDBGetConn(); $oostable =& oosDBGetTables(); $manufacturers_infotable = $oostable['manufacturers_info']; $manufacturer = $dbconn->Execute("SELECT manufacturers_url FROM {$manufacturers_infotable} WHERE manufacturers_id = '" . $manufacturer_id . "' AND manufacturers_languages_id = '" . intval($lang_id) . "'"); return $manufacturer->fields['manufacturers_url']; }
function create_plugin_instance() { $aFilename = oos_get_filename(); $aModules = oos_get_modules(); if ($_GET['file'] != $aFilename['login'] && !isset($_SESSION['customer_id'])) { $cookie_url_array = parse_url((ENABLE_SSL == true ? OOS_HTTPS_SERVER : OOS_HTTP_SERVER) . substr(OOS_SHOP, 0, -1)); $cookie_path = $cookie_url_array['path']; if (isset($_COOKIE['email_address']) && isset($_COOKIE['password'])) { // Get database information $dbconn =& oosDBGetConn(); $oostable =& oosDBGetTables(); $customerstable = $oostable['customers']; $sql = "SELECT customers_id, customers_gender, customers_firstname, customers_lastname,\n customers_password, customers_wishlist_link_id, customers_language,\n customers_vat_id_status, customers_email_address, customers_default_address_id,\n customers_max_order\n FROM {$customerstable}\n WHERE customers_login = '******'\n AND customers_email_address = '" . oos_db_input($_COOKIE['email_address']) . "'"; $check_customer_result = $dbconn->Execute($sql); if ($check_customer_result->RecordCount()) { $check_customer = $check_customer_result->fields; if (oos_validate_password($_COOKIE['password'], $check_customer['customers_password'])) { $address_booktable = $oostable['address_book']; $sql = "SELECT entry_country_id, entry_zone_id\n FROM {$address_booktable}\n WHERE customers_id = '" . $check_customer['customers_id'] . "'\n AND address_book_id = '1'"; $check_country = $dbconn->GetRow($sql); if ($check_customer['customers_language'] == '') { $sLanguage = oos_var_prep_for_os($_SESSION['language']); $customerstable = $oostable['customers']; $dbconn->Execute("UPDATE {$customerstable}\n SET customers_language = '" . oos_db_input($sLanguage) . "'\n WHERE customers_id = '" . intval($check_customer['customers_id']) . "'"); } $_SESSION['customer_wishlist_link_id'] = $check_customer['customers_wishlist_link_id']; $_SESSION['customer_id'] = $check_customer['customers_id']; $_SESSION['customer_default_address_id'] = $check_customer['customers_default_address_id']; if (ACCOUNT_GENDER == '1') { $_SESSION['customer_gender'] = $check_customer['customers_gender']; } $_SESSION['customer_first_name'] = $check_customer['customers_firstname']; $_SESSION['customer_lastname'] = $check_customer['customers_lastname']; $_SESSION['customer_max_order'] = $check_customer['customers_max_order']; $_SESSION['customer_country_id'] = $check_country['entry_country_id']; $_SESSION['customer_zone_id'] = $check_country['entry_zone_id']; if (ACCOUNT_VAT_ID == '1') { $_SESSION['customers_vat_id_status'] = $check_customer['customers_vat_id_status']; } $_SESSION['member']->restore_group(); setcookie('email_address', $email_address, time() + 365 * 24 * 3600, $cookie_path, '', getenv('HTTPS') == 'on' ? 1 : 0); setcookie('password', $check_customer['customers_password'], time() + 365 * 24 * 3600, $cookie_path, '', getenv('HTTPS') == 'on' ? 1 : 0); $customers_infotable = $oostable['customers_info']; $dbconn->Execute("UPDATE {$customers_infotable}\n SET customers_info_date_of_last_logon = '" . date("Y-m-d H:i:s", time()) . "',\n customers_info_number_of_logons = customers_info_number_of_logons+1\n WHERE customers_info_id = '" . intval($_SESSION['customer_id']) . "'"); $_SESSION['cart']->restore_contents(); // restore cart contents } } } } return true; }
/** * */ function oos_get_tax_title_class_id($tax_class_title) { // Get database information $dbconn =& oosDBGetConn(); $oostable =& oosDBGetTables(); $query = "SELECT tax_class_id\n FROM " . $oostable['tax_class'] . "\n WHERE tax_class_title = '" . $tax_class_title . "'"; $result =& $dbconn->Execute($query); $tax_class_array = $result->fields; $tax_class_id = $tax_class_array['tax_class_id']; // Close result set $result->Close(); return $tax_class_id; }
/** * Return values name * * @param $values_id * @return string */ function oos_values_name($values_id) { // Get database information $dbconn =& oosDBGetConn(); $oostable =& oosDBGetTables(); $products_options_valuestable = $oostable['products_options_values']; $query = "SELECT products_options_values_name\n FROM {$products_options_valuestable}\n WHERE products_options_values_id = '" . $values_id . "'\n AND products_options_values_languages_id = '" . intval($_SESSION['language_id']) . "'"; $result =& $dbconn->Execute($query); $products_options_values_name = $result->fields['products_options_values_name']; // Close result set $result->Close(); return $products_options_values_name; }
function oos_set_login_status($man_info_id, $status) { // Get database information $dbconn =& oosDBGetConn(); $oostable = oosDBGetTables(); if ($status == '1') { return $dbconn->Execute("UPDATE " . $oostable['manual_info'] . " SET status = '1', expires_date = NULL, manual_last_modified = now(), date_status_change =now() WHERE man_info_id = '" . $man_info_id . "'"); } elseif ($status == '0') { return $dbconn->Execute("UPDATE " . $oostable['manual_info'] . " SET status = '0', man_key = '', man_key2 = '', manual_last_modified = now() WHERE man_info_id = '" . $man_info_id . "'"); } else { return -1; } }
/** * Return a product's catagory * * @param $products_id * @return string boolean */ function oos_get_product_path($products_id) { // Get database information $dbconn =& oosDBGetConn(); $oostable =& oosDBGetTables(); $products_to_categoriestable = $oostable['products_to_categories']; $sql = "SELECT categories_id\n FROM {$products_to_categoriestable}\n WHERE products_id = '" . $products_id . "'"; $cat_id_data = $dbconn->SelectLimit($sql, 1); if ($cat_id_data->RecordCount()) { return $cat_id_data->fields['categories_id']; } return false; }
function oos_get_languages_id($iso_639_2) { $dbconn =& oosDBGetConn(); $oostable =& oosDBGetTables(); $languagestable = $oostable['languages']; $languages_result = $dbconn->Execute("SELECT languages_id, iso_639_2 FROM {$languagestable} WHERE iso_639_2 = '" . oos_db_input($iso_639_2) . "'"); if (!$languages_result->RecordCount()) { $LangID = $_SESSION['language_id']; } else { $LangID = $languages_result->fields['languages_id']; } return $LangID; }
function oos_get_manufacturers($aManufacturers = '') { if (!is_array($aManufacturers)) { $aManufacturers = array(); } $dbconn =& oosDBGetConn(); $oostable = oosDBGetTables(); $manufacturers_result = $dbconn->Execute("SELECT manufacturers_id, manufacturers_name FROM " . $oostable['manufacturers'] . " ORDER BY manufacturers_name"); while ($manufacturers = $manufacturers_result->fields) { $aManufacturers[] = array('id' => $manufacturers['manufacturers_id'], 'text' => $manufacturers['manufacturers_name']); $manufacturers_result->MoveNext(); } return $aManufacturers; }
function currencies() { $this->currencies = array(); // Get database information $dbconn =& oosDBGetConn(); $oostable =& oosDBGetTables(); $currenciestable = $oostable['currencies']; $sql = "SELECT code, title, symbol_left, symbol_right, decimal_point,\n thousands_point, decimal_places, value\n FROM " . $currenciestable; if (USE_DB_CACHE == '1') { $this->currencies = $dbconn->CacheGetAssoc(3600 * 24, $sql); } else { $this->currencies = $dbconn->GetAssoc($sql); } }
function oos_set_featured_status($featured_id, $status) { // Get database information $dbconn =& oosDBGetConn(); $oostable =& oosDBGetTables(); if ($status == '1') { $featuredtable = $oostable['featured']; return $dbconn->Execute("UPDATE {$featuredtable} SET status = '1', expires_date = NULL, date_status_change = '" . date("Y-m-d H:i:s", time()) . "' WHERE featured_id = '" . (int) $featured_id . "'"); } elseif ($status == '0') { $featuredtable = $oostable['featured']; 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; } }
/** * Sets the status of a special * * @param $specials_id * @param $status * @return boolan */ function oos_set_specials_status($specials_id, $status) { // Get database information $dbconn =& oosDBGetConn(); $oostable =& oosDBGetTables(); if ($status == '1') { $specialstable = $oostable['specials']; return $dbconn->Execute("UPDATE {$specialstable} SET status = '1', expires_date = NULL, date_status_change = NULL WHERE specials_id = '" . $specials_id . "'"); } elseif ($status == '0') { $specialstable = $oostable['specials']; return $dbconn->Execute("UPDATE {$specialstable} SET status = '0', date_status_change = now() WHERE specials_id = '" . $specials_id . "'"); } else { return -1; } }
/** * Return Orders Status * * @param $products_units_id * @param $language * @return array */ function oos_get_products_units() { $products_units_array = array(); $dbconn =& oosDBGetConn(); $oostable =& oosDBGetTables(); $products_unitstable = $oostable['products_units']; $products_units_sql = "SELECT products_units_id, products_unit_name\n FROM {$products_unitstable}\n WHERE languages_id = '" . intval($_SESSION['language_id']) . "'\n ORDER BY products_units_id"; $products_units_result = $dbconn->Execute($products_units_sql); while ($products_units = $products_units_result->fields) { $products_units_array[] = array('id' => $products_units['products_units_id'], 'text' => $products_units['products_unit_name']); // Move that ADOdb pointer! $products_units_result->MoveNext(); } return $products_units_array; }