function __construct(&$current_page_number, $max_rows_per_page, &$sql_query, &$query_num_rows)
{
if (empty($current_page_number)) {
$current_page_number = 1;
}
// # scrub any white space found in incoming queries!
if ($sql_query) {
$sql_query = preg_replace("/\\s+/", " ", $sql_query);
}
//error_log(print_r($sql_query,1));
$pos_to = strlen($sql_query);
$pos_from = strripos($sql_query, ' from', 0);
$pos_order_by = strripos($sql_query, ' order by', $pos_from);
if ($pos_order_by < $pos_to && $pos_order_by != false) {
$pos_to = $pos_order_by;
}
$pos_limit = strripos($sql_query, ' limit', $pos_from);
if ($pos_limit < $pos_to && $pos_limit != false) {
$pos_to = $pos_limit;
}
$pos_procedure = strripos($sql_query, ' procedure', $pos_from);
if ($pos_procedure < $pos_to && $pos_procedure != false) {
$pos_to = $pos_procedure;
}
$offset = $max_rows_per_page * ($current_page_number - 1);
$sql_query .= " limit " . $offset . ", " . $max_rows_per_page;
$reviews_count_query = tep_db_query("select 0 " . substr($sql_query, $pos_from, $pos_to - $pos_from));
//$reviews_count = tep_db_fetch_array($reviews_count_query);
$query_num_rows = (int) tep_db_num_rows($reviews_count_query);
$this->current_page_number = $current_page_number;
$this->max_rows_per_page = $max_rows_per_page;
$this->query_num_rows = $query_num_rows;
}
function remove()
{
tep_db_query("delete from " . TABLE_CONFIGURATION . " where configuration_key in ('" . implode("', '", $this->keys()) . "')");
tep_db_query("alter table " . TABLE_CUSTOMERS . " drop `customers_guest`");
tep_db_query("alter table " . TABLE_ORDERS . " drop `customers_guest`");
tep_db_query("alter table " . TABLE_ADDRESS_BOOK . " drop `customers_guest`");
}
function tep_get_configuration_key_value($lookup)
{
$configuration_query_raw = tep_db_query("select configuration_value from " . TABLE_CONFIGURATION . " where configuration_key='" . $lookup . "'");
$configuration_query = tep_db_fetch_array($configuration_query_raw);
$lookup_value = $configuration_query['configuration_value'];
return $lookup_value;
}
function tep_update_whos_online()
{
global $customer_id;
if (tep_session_is_registered('customer_id')) {
$wo_customer_id = $customer_id;
$customer_query = tep_db_query("select customers_firstname, customers_lastname from " . TABLE_CUSTOMERS . " where customers_id = '" . (int) $customer_id . "'");
$customer = tep_db_fetch_array($customer_query);
$wo_full_name = $customer['customers_firstname'] . ' ' . $customer['customers_lastname'];
} else {
$wo_customer_id = '';
$wo_full_name = 'Guest';
}
$wo_session_id = tep_session_id();
$wo_ip_address = getenv('REMOTE_ADDR');
$wo_last_page_url = getenv('REQUEST_URI');
$current_time = time();
$xx_mins_ago = $current_time - 900;
// remove entries that have expired
tep_db_query("delete from " . TABLE_WHOS_ONLINE . " where time_last_click < '" . $xx_mins_ago . "'");
$stored_customer_query = tep_db_query("select count(*) as count from " . TABLE_WHOS_ONLINE . " where session_id = '" . tep_db_input($wo_session_id) . "'");
$stored_customer = tep_db_fetch_array($stored_customer_query);
if ($stored_customer['count'] > 0) {
tep_db_query("update " . TABLE_WHOS_ONLINE . " set customer_id = '" . (int) $wo_customer_id . "', full_name = '" . tep_db_input($wo_full_name) . "', ip_address = '" . tep_db_input($wo_ip_address) . "', time_last_click = '" . tep_db_input($current_time) . "', last_page_url = '" . tep_db_input($wo_last_page_url) . "' where session_id = '" . tep_db_input($wo_session_id) . "'");
} else {
tep_db_query("insert into " . TABLE_WHOS_ONLINE . " (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url) values ('" . (int) $wo_customer_id . "', '" . tep_db_input($wo_full_name) . "', '" . tep_db_input($wo_session_id) . "', '" . tep_db_input($wo_ip_address) . "', '" . tep_db_input($current_time) . "', '" . tep_db_input($current_time) . "', '" . tep_db_input($wo_last_page_url) . "')");
}
}
function query($order_id)
{
global $languages_id;
$order_query = tep_db_query("select o.*, s.orders_status_name from " . TABLE_ORDERS . " o, " . TABLE_ORDERS_STATUS . " s where o.orders_id = '" . (int) $order_id . "' and o.orders_status = s.orders_status_id and s.language_id = '" . (int) $languages_id . "'");
$order = tep_db_fetch_array($order_query);
$totals_query = tep_db_query("select title, text, class from " . TABLE_ORDERS_TOTAL . " where orders_id = '" . (int) $order_id . "' order by sort_order");
while ($totals = tep_db_fetch_array($totals_query)) {
$this->totals[] = array('title' => $totals['title'], 'text' => $totals['text'], 'class' => $totals['class']);
}
$this->info = array('total' => null, 'currency' => $order['currency'], 'currency_value' => $order['currency_value'], 'payment_method' => $order['payment_method'], 'cc_type' => $order['cc_type'], 'cc_owner' => $order['cc_owner'], 'cc_number' => $order['cc_number'], 'cc_expires' => $order['cc_expires'], 'date_purchased' => $order['date_purchased'], 'status' => $order['orders_status_name'], 'orders_status' => $order['orders_status'], 'last_modified' => $order['last_modified']);
foreach ($this->totals as $t) {
if ($t['class'] == 'ot_total') {
$this->info['total'] = $t['text'];
break;
}
}
$this->customer = array('name' => $order['customers_name'], 'company' => $order['customers_company'], 'street_address' => $order['customers_street_address'], 'suburb' => $order['customers_suburb'], 'city' => $order['customers_city'], 'postcode' => $order['customers_postcode'], 'state' => $order['customers_state'], 'country' => $order['customers_country'], 'format_id' => $order['customers_address_format_id'], 'telephone' => $order['customers_telephone'], 'email_address' => $order['customers_email_address']);
$this->delivery = array('name' => $order['delivery_name'], 'company' => $order['delivery_company'], 'street_address' => $order['delivery_street_address'], 'suburb' => $order['delivery_suburb'], 'city' => $order['delivery_city'], 'postcode' => $order['delivery_postcode'], 'state' => $order['delivery_state'], 'country' => $order['delivery_country'], 'format_id' => $order['delivery_address_format_id']);
$this->billing = array('name' => $order['billing_name'], 'company' => $order['billing_company'], 'street_address' => $order['billing_street_address'], 'suburb' => $order['billing_suburb'], 'city' => $order['billing_city'], 'postcode' => $order['billing_postcode'], 'state' => $order['billing_state'], 'country' => $order['billing_country'], 'format_id' => $order['billing_address_format_id']);
$index = 0;
$orders_products_query = tep_db_query("select orders_products_id, products_name, products_model, products_price, products_tax, products_quantity, final_price from " . TABLE_ORDERS_PRODUCTS . " where orders_id = '" . (int) $order_id . "'");
while ($orders_products = tep_db_fetch_array($orders_products_query)) {
$this->products[$index] = array('qty' => $orders_products['products_quantity'], 'name' => $orders_products['products_name'], 'model' => $orders_products['products_model'], 'tax' => $orders_products['products_tax'], 'price' => $orders_products['products_price'], 'final_price' => $orders_products['final_price']);
$subindex = 0;
$attributes_query = tep_db_query("select products_options, products_options_values, options_values_price, price_prefix from " . TABLE_ORDERS_PRODUCTS_ATTRIBUTES . " where orders_id = '" . (int) $order_id . "' and orders_products_id = '" . (int) $orders_products['orders_products_id'] . "'");
if (tep_db_num_rows($attributes_query)) {
while ($attributes = tep_db_fetch_array($attributes_query)) {
$this->products[$index]['attributes'][$subindex] = array('option' => $attributes['products_options'], 'value' => $attributes['products_options_values'], 'prefix' => $attributes['price_prefix'], 'price' => $attributes['options_values_price']);
$subindex++;
}
}
$index++;
}
}
function generateDesignsId($month)
{
// $dateObj = DateTime::createFromFormat('!m', $month);
// $month_name = $dateObj->format('F');
$month_name = date('F', mktime(0, 0, 0, $month, 10));
echo "<h3>{$month_name}</h3>";
$query = "SELECT designs_id, status_time FROM designs_status_history";
$query .= " WHERE status=9 AND YEAR(FROM_UNIXTIME(status_time)) = '2014' AND MONTH(FROM_UNIXTIME(status_time)) = '{$month}'";
$result = tep_db_query($query);
$c = array();
$c['no'] = 'No.';
$c['id'] = 'Designs ID';
$c['date'] = 'Finalized Date';
$table_des[] = $c;
while ($row = tep_db_fetch_array($result)) {
$no++;
$date = date('d-m-Y', $row['status_time']);
$c = array();
$c['no'] = $no;
$c['id'] = $row['designs_id'];
$c['date'] = $date;
$table_des[] = $c;
}
$table = tep_draw_table('main_center', $table_des, true);
echo $table;
}
/**
* Fetches the product and adds it as an article to the klarna class. No need to return any data.
* Articles need to be set for fraud purpose, incorrect article means no_risk invoice. Hereby klarna will not take any risks.
*
* @param mixed $mProductId The product identified. Either int or string. Adapted according shop functionality
* @param Klarna $oKlarna The Klarna class object. Used to set any articles
* @return void
*/
protected function fetchProduct($mProductId)
{
global $currencies, $currency;
include DIR_WS_CLASSES . 'language.php';
$lng = new language();
if (isset($HTTP_GET_VARS['language']) && tep_not_null($HTTP_GET_VARS['language'])) {
$lng->set_language($HTTP_GET_VARS['language']);
} else {
$lng->get_browser_language();
}
$language = $lng->language['directory'];
$languages_id = $lng->language['id'];
$product_info_query = tep_db_query("select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int) $mProductId . "' and pd.products_id = p.products_id and pd.language_id = '" . (int) $languages_id . "'");
$aProduct_info = tep_db_fetch_array($product_info_query);
$sArtNo = MODULE_PAYMENT_KLARNA_ARTNO == 'id' || MODULE_PAYMENT_KLARNA_ARTNO == '' ? $aProduct_info['id'] : $aProduct_info['name'];
$iTax = tep_get_tax_rate($aProduct_info['products_tax_class_id']);
if (DISPLAY_PRICE_WITH_TAX == 'true') {
$iPrice_with_tax = $currencies->get_value($currency) * $aProduct_info['products_price'];
} else {
$iPrice_with_tax = $currencies->get_value($currency) * $aProduct_info['products_price'] * ($iTax / 100 + 1);
}
// Add goods
$this->oKlarna->addArticle(1, $sArtNo, $aProduct_info['products_name'], $iPrice_with_tax, $iTax, 0, KlarnaFlags::INC_VAT);
$this->iSum += $iPrice_with_tax;
}
function getSetField()
{
global $languages_id;
$statuses_array = array();
$flags_query = tep_db_query("describe orders_status public_flag");
if (tep_db_num_rows($flags_query) == 1) {
$statuses_query = tep_db_query("select orders_status_id, orders_status_name from orders_status where language_id = '" . (int) $languages_id . "' and public_flag = '0' order by orders_status_name");
} else {
$statuses_query = tep_db_query("select orders_status_id, orders_status_name from orders_status where language_id = '" . (int) $languages_id . "' order by orders_status_name");
}
while ($statuses = tep_db_fetch_array($statuses_query)) {
$statuses_array[] = array('id' => $statuses['orders_status_id'], 'text' => $statuses['orders_status_name']);
}
$input = tep_draw_pull_down_menu('transactions_order_status_id', $statuses_array, OSCOM_APP_PAYPAL_TRANSACTIONS_ORDER_STATUS_ID, 'id="inputTransactionsOrderStatusId"');
$result = <<<EOT
<div>
<p>
<label for="inputTransactionsOrderStatusId">{$this->title}</label>
{$this->description}
</p>
<div>
{$input}
</div>
</div>
EOT;
return $result;
}
function getConfig($cfg)
{
global $db;
$config = tep_db_query("SELECT configuration_value FROM configuration WHERE configuration_key='{$cfg}'");
$config = mysql_fetch_assoc($config);
return $config["configuration_value"];
}
function setProductDescription2($products_id, $focus = null)
{
use_class('element');
$q = tep_db_query("SELECT * FROM products_description2 WHERE products_id={$products_id}");
$pd2 = tep_db_fetch_array($q);
$elements_used = $this->retrieveElementsUsed($products_id);
if (!is_null($focus) && !is_array($focus)) {
$focus = explode(',', $focus);
}
$need_tobe_filled_c = is_null($focus) || in_array('c', $focus) && ($pd2['clasp_type'] == '' || $pd2['clasp_type'] == 0) ? true : false;
$need_tobe_filled_s = is_null($focus) || in_array('s', $focus) && ($pd2['setting_type'] == '' || $pd2['setting_type'] == 0) ? true : false;
if ($need_tobe_filled_c || $need_tobe_filled_s) {
$sda = array();
foreach ($elements_used as $eid) {
$el = new element($eid);
if ($need_tobe_filled_c && !isset($sda['clasp_type']) && $sda['clasp_type'] == '') {
$sda['clasp_type'] = $el->attributes['clasp']['id'];
}
if ($need_tobe_filled_s && !isset($sda['setting_type']) && $sda['setting_type'] == '') {
$sda['setting_type'] = $el->attributes['setting']['id'];
}
}
if (count($sda) > 0) {
if (tep_db_num_rows($q) > 0) {
tep_db_perform('products_description2', $sda, 'update', "products_id={$products_id}");
} else {
$sda['products_id'] = $products_id;
tep_db_perform('products_description2', $sda);
}
}
}
}
private function get_subcategories($parent_id)
{
if (tep_has_category_subcategories($parent_id)) {
global $languages_id;
$categories_data = array();
// Retrieve the data on the subcategories
$categories_query_raw = "\n\t\t\t\tselect\n\t\t\t\t c.categories_id,\n\t\t\t\t c.parent_id,\n\t\t\t\t cd.categories_name\n\t\t\t\tfrom " . TABLE_CATEGORIES_DESCRIPTION . " cd\n\t\t\t\t join " . TABLE_CATEGORIES . " c\n\t\t\t\t\ton (c.categories_id = cd.categories_id)\n\t\t\t\twhere\n\t\t\t\t c.parent_id = '" . (int) $parent_id . "'\n\t\t\t\t and cd.language_id = '" . (int) $languages_id . "'\n\t\t\t\torder by\n\t\t\t\t c.sort_order,\n\t\t\t\t cd.categories_name\n\t\t\t ";
//print 'Categories Query: ' . $categories_query_raw . '<br />';
$categories_query = tep_db_query($categories_query_raw);
// Load the subcategory data into an array
$index = 0;
while ($categories = tep_db_fetch_array($categories_query)) {
$categories_id = (int) $categories['categories_id'];
$path_string = $this->get_category_path($categories_id);
if ($categories_id != 0) {
$categories_data[$index] = array('id' => $categories_id, 'name' => $categories['categories_name'], 'parent_id' => $categories['parent_id'], 'path' => $path_string);
// If the category has subcats, add them to the array
if (tep_has_category_subcategories($categories_id)) {
$categories_data[$index]['subcat'] = $this->get_subcategories($categories_id);
} else {
$categories_data[$index]['subcat'] = false;
}
}
// if( $categories_id
$index++;
}
//while ($categories
return $categories_data;
} else {
return false;
}
}
function datasCountByStatus()
{
global $tabs, $filter_type, $filter_owner, $filter_team, $filter_teamcat;
// if($filter_type=='0') {
// $filter = ($filter_team<=0) ? '' : "WHERE i.department=$filter_team ";
// if($filter_teamcat!='0') $filter .= (($filter!='') ? ' AND' : ' WHERE')." i.category='$filter_teamcat' ";
// } else {
// $filter = "WHERE i.owner=$filter_owner";
// }
$statuscount = array();
$q = "SELECT category, COUNT(id_promoboxes) AS total_datas";
$q .= " FROM promoboxes GROUP BY category";
$r = tep_db_query($q);
foreach ($tabs as $skey => $sval) {
$statuscount[$skey] = '0';
}
while ($row = tep_db_fetch_array($r)) {
$statuscount[$row['category']] = $row['total_datas'];
}
$dcArray = array();
foreach ($statuscount as $status => $dc) {
$dcArray[] = $status . '|' . $dc;
}
return implode('|||', $dcArray);
}
function query($order_id)
{
$order_query = tep_db_query("select * from " . TABLE_ORDERS . " where orders_id = '" . (int) $order_id . "'");
$order = tep_db_fetch_array($order_query);
$totals_query = tep_db_query("select * from " . TABLE_ORDERS_TOTAL . " where orders_id = '" . (int) $order_id . "' order by sort_order");
while ($totals = tep_db_fetch_array($totals_query)) {
$this->totals[] = array('title' => $totals['title'], 'text' => $totals['text'], 'class' => $totals['class'], 'value' => $totals['value'], 'sort_order' => $totals['sort_order'], 'orders_total_id' => $totals['orders_total_id']);
}
$this->info = array('currency' => $order['currency'], 'currency_value' => $order['currency_value'], 'payment_method' => $order['payment_method'], 'cc_type' => $order['cc_type'], 'cc_owner' => $order['cc_owner'], 'cc_number' => $order['cc_number'], 'cc_expires' => $order['cc_expires'], 'shipping_tax' => $order['shipping_tax'], 'date_purchased' => $order['date_purchased'], 'orders_status' => $order['orders_status'], 'last_modified' => $order['last_modified']);
$this->customer = array('name' => $order['customers_name'], 'company' => $order['customers_company'], 'street_address' => $order['customers_street_address'], 'suburb' => $order['customers_suburb'], 'city' => $order['customers_city'], 'postcode' => $order['customers_postcode'], 'state' => $order['customers_state'], 'country' => $order['customers_country'], 'format_id' => $order['customers_address_format_id'], 'telephone' => $order['customers_telephone'], 'email_address' => $order['customers_email_address']);
$this->delivery = array('name' => $order['delivery_name'], 'company' => $order['delivery_company'], 'street_address' => $order['delivery_street_address'], 'suburb' => $order['delivery_suburb'], 'city' => $order['delivery_city'], 'postcode' => $order['delivery_postcode'], 'state' => $order['delivery_state'], 'country' => $order['delivery_country'], 'format_id' => $order['delivery_address_format_id']);
$this->billing = array('name' => $order['billing_name'], 'company' => $order['billing_company'], 'street_address' => $order['billing_street_address'], 'suburb' => $order['billing_suburb'], 'city' => $order['billing_city'], 'postcode' => $order['billing_postcode'], 'state' => $order['billing_state'], 'country' => $order['billing_country'], 'format_id' => $order['billing_address_format_id']);
$countryid = tep_get_country_id($this->delivery["country"]);
$zoneid = tep_get_zone_id($countryid, $this->delivery["state"]);
$index = 0;
$orders_products_query = tep_db_query("\n SELECT \n\t op.orders_products_id, \n\t op.products_name, \n\t op.products_model, \n\t op.products_price,\n\t op.products_tax, \n\t op.products_quantity, \n\t op.final_price, \n\t p.products_tax_class_id,\n\t p.products_weight\n FROM " . TABLE_ORDERS_PRODUCTS . " op\n LEFT JOIN " . TABLE_PRODUCTS . " p\n ON op.products_id = p.products_id\n WHERE orders_id = '" . (int) $order_id . "'");
while ($orders_products = tep_db_fetch_array($orders_products_query)) {
$this->products[$index] = array('qty' => $orders_products['products_quantity'], 'name' => $orders_products['products_name'], 'model' => $orders_products['products_model'], 'tax' => $orders_products['products_tax'], 'tax_description' => tep_get_tax_description($orders_products['products_tax_class_id'], $countryid, $zoneid), 'price' => $orders_products['products_price'], 'final_price' => $orders_products['final_price'], 'weight' => $orders_products['products_weight'], 'orders_products_id' => $orders_products['orders_products_id']);
$subindex = 0;
$attributes_query = tep_db_query("select * from " . TABLE_ORDERS_PRODUCTS_ATTRIBUTES . " where orders_id = '" . (int) $order_id . "' and orders_products_id = '" . (int) $orders_products['orders_products_id'] . "'");
if (tep_db_num_rows($attributes_query)) {
while ($attributes = tep_db_fetch_array($attributes_query)) {
$this->products[$index]['attributes'][$subindex] = array('option' => $attributes['products_options'], 'value' => $attributes['products_options_values'], 'prefix' => $attributes['price_prefix'], 'price' => $attributes['options_values_price'], 'orders_products_attributes_id' => $attributes['orders_products_attributes_id']);
$subindex++;
}
}
$index++;
}
}
function processXMLFile($xml_file)
{
global $timestamp, $logger;
$xmlt = new xml_tools();
$xml = $xmlt->loadFile($xml_file);
$order_date = $timestamp;
$segments_id = (int) $xml->LOCAL_INFO->SEGMENT_ID;
$group_name = (string) $xml->LOCAL_INFO->GROUP_NAME;
$refill_orders = $xml->REFILL_ORDERS->ORDER;
$counter = 0;
foreach ($refill_orders as $ro) {
$products_id = (int) $ro->PRODUCTS_ID;
$articles_id = (int) $ro->ARTICLES_ID;
$products_ean = $ro->PRODUCTS_EAN;
$quantity = (int) $ro->QUANTITY;
$trans_type = (string) (strtoupper($ro->TRANS_TYPE) == 'NULL' ? '' : $ro->TRANS_TYPE);
$trans_id = (int) $ro->TRANS_ID;
//CREATE DEPOT ORDERS
$q_check = "SELECT depot_orders_id FROM depot_orders " . " WHERE segments_id = {$segments_id}" . " AND trans_type = '' AND trans_id = {$trans_id}";
$r_check = tep_db_query($q_check);
//ONLY CREATE ORDER WHICH NOT IMPORTED
if (tep_db_num_rows($r_check) == 0) {
$class_do = new depot_orders();
$class_do->newOrder($segments_id, $products_id, $articles_id, $products_ean, $quantity, $order_date, $trans_type, $trans_id, $group_name);
$counter++;
}
}
$logger->write("{$counter} orders imported");
unlink($xml_file);
$logger->write("xml deleted");
return $counter;
}
function calculate_price($products_price, $products_tax, $quantity = 1, $rate = "", $pid = "")
{
global $currency;
if (is_numeric($pid)) {
$dbres = tep_db_query("select categories_id from products_to_categories where products_id='" . $pid . "'");
$row = tep_db_fetch_array($dbres);
$cat_id = (int) $row['categories_id'];
if ($cat_id == 23) {
return tep_round(tep_add_tax($products_price, $products_tax), $this->currencies[$currency]['decimal_places']) * $quantity;
}
}
if ($rate == "") {
$rate = get_price_rate($_SESSION['customer_id']);
}
if (get_price_group_name($_SESSION['customer_id']) == "Interior Designer") {
$dbres = tep_db_query("select dn_price from products where products_id='{$pid}'");
$row = tep_db_fetch_array($dbres);
if ((double) $row['dn_price'] > 0) {
$products_price = $row['dn_price'];
$rate = "100";
}
}
return ceil(tep_add_tax($products_price * $rate / 100, $products_tax)) * $quantity;
// return tep_round(tep_add_tax(($products_price*$rate)/100, $products_tax), $this->currencies[$currency]['decimal_places']) * $quantity;
}
function tep_update_htpasswd_file()
{
$shops = array();
$shops_query = tep_db_query("select shops_id, shops_htpasswd_file from " . TABLE_SHOPS . " where shops_htpasswd_file <> ''");
while ($shops_array = tep_db_fetch_array($shops_query)) {
$shops[$shops_array['shops_id']] = $shops_array['shops_htpasswd_file'];
}
$passwords = array();
$users_query = tep_db_query("select u.users_id, u.users_password, ug.users_groups_shops from " . TABLE_USERS . " u, " . TABLE_USERS_GROUPS . " ug where u.users_status = '1' and u.users_groups_id = ug.users_groups_id");
while ($users = tep_db_fetch_array($users_query)) {
$available_shops = array();
if (empty($users['users_groups_shops'])) {
$available_shops = array_keys($shops);
} else {
$available_shops = explode(',', $users['users_groups_shops']);
}
reset($shops);
while (list($shop_id, $shops_htpasswd_file) = each($shops)) {
if (in_array($shop_id, $available_shops)) {
$passwords[$shops_htpasswd_file] .= $users['users_id'] . ':' . $users['users_password'] . "\r\n";
}
}
}
reset($passwords);
while (list($shops_htpasswd_file, $passwords_string) = each($passwords)) {
if ($fp = fopen($shops_htpasswd_file, "w")) {
fwrite($fp, $passwords_string);
fclose($fp);
}
}
}
function build_cds_list_menu($startid = 0, $ulstyle = '')
{
global $languages_id;
if ($ulstyle != '') {
$ulstyle = ' id="' . $ulstyle . '"';
}
$cds_menu = '';
//loop through category id to find all subcategories and pages
$cds_pages_query = tep_db_query("SELECT c.categories_id as 'ID', \r\n cd.categories_name as 'Name',\r\n c.categories_parent_id as 'ParentID',\r\n c.category_append_cdpath as 'Append',\r\n c.categories_url_override as 'URL',\r\n c.categories_url_override_target as 'Target',\r\n c.pages_group_access as 'Group', 'c' as 'type',\r\n c.categories_sort_order as 'Sort'\r\n FROM pages_categories c \r\n LEFT JOIN pages_categories_description cd \r\n ON c.categories_id = cd.categories_id \r\n WHERE c.categories_parent_id = '" . $startid . "' \r\n AND c.categories_status = '1'\r\n AND c.categories_in_menu = '1'\r\n AND cd.language_id = '" . (int) $languages_id . "'\r\n UNION\r\n SELECT p.pages_id as 'ID', \r\n pd.pages_menu_name as 'Name',\r\n p2c.categories_id as 'ParentID',\r\n p.pages_append_cdpath as 'Append',\r\n p.pages_url as 'URL',\r\n p.pages_url_target as 'Target',\r\n p.pages_group_access as 'Group', 'p' as 'type',\r\n p.pages_sort_order as 'Sort'\r\n FROM pages p, \r\n pages_description pd, \r\n pages_to_categories p2c \r\n WHERE p.pages_id = pd.pages_id \r\n AND pd.language_id ='" . (int) $languages_id . "'\r\n AND p.pages_id = p2c.pages_id \r\n AND p.pages_status = '1'\r\n AND pd.pages_menu_name <> ''\r\n AND p.pages_in_menu = '1'\r\n AND p2c.categories_id ='" . $startid . "'\r\n ORDER BY Sort ");
$rows_count = tep_db_num_rows($cds_pages_query);
if ($rows_count > 0) {
$cds_menu .= "\n" . ' <ul' . $ulstyle . '>' . "\n";
$ulstyle = '';
while ($cds_pages_data = tep_db_fetch_array($cds_pages_query)) {
$cds_menu .= ' <li>' . cds_build_menu_url($cds_pages_data['ID'], $cds_pages_data['Name'], $cds_pages_data['type'], $cds_pages_data['URL'], $cds_pages_data['Append'], $cds_pages_data['Target']);
if ($cds_pages_data['type'] == 'c' && $cds_pages_data['URL'] == '') {
//we found a subcategory, loop, loop, loop.......
$cds_menu .= build_cds_list_menu($cds_pages_data['ID']);
}
$cds_menu .= '</li>' . "\n";
}
$cds_menu .= ' </ul>' . "\n";
}
return $cds_menu;
}
function loadProduct($product_id, $products_price, $products_tax_class_id, $qtyBlocks = 1, $price_breaks_array = NULL, $min_order_qty = 1)
{
// Collect required data (show for retail only)
// in a preview read=only no data for the price break available
if (!tep_not_null($price_breaks_array)) {
$price_breaks_array = array();
$price_breaks_query = tep_db_query("select products_price, products_qty from " . TABLE_PRODUCTS_PRICE_BREAK . " where products_id = '" . (int) $product_id . "' and customers_group_id = '0' order by products_qty");
while ($price_break = tep_db_fetch_array($price_breaks_query)) {
$price_breaks_array[] = $price_break;
}
}
//Assign members
$this->thePrice = $products_price;
$this->taxClass = $products_tax_class_id;
$this->qtyBlocks = $qtyBlocks < 1 ? 1 : $qtyBlocks;
$this->price_breaks = $price_breaks_array;
$this->products_min_order_qty = $min_order_qty < 1 ? 1 : $min_order_qty;
//Custom
$this->hasQuantityPrice = false;
$this->hiPrice = $this->thePrice;
$this->lowPrice = $this->thePrice;
if (count($this->price_breaks) > 0) {
$this->hasQuantityPrice = true;
foreach ($this->price_breaks as $price_break) {
$this->hiPrice = max($this->hiPrice, $price_break['products_price']);
$this->lowPrice = min($this->lowPrice, $price_break['products_price']);
}
}
}
function _draw_stocked_attributes()
{
global $languages_id;
$out = '';
$attributes = $this->_build_attributes_array(true, false);
if (sizeof($attributes) <= 1) {
return parent::_draw_stocked_attributes();
}
// Check stock
$s = sizeof($attributes[0]['ovals']);
for ($a = 0; $a < $s; $a++) {
$attribute_stock_query = tep_db_query("select products_stock_quantity from " . TABLE_PRODUCTS_STOCK . " where products_id = '" . (int) $this->products_id . "' AND products_stock_attributes REGEXP '(^|,)" . (int) $attributes[0]['oid'] . "-" . (int) $attributes[0]['ovals'][$a]['id'] . "(,|\$)' AND products_stock_quantity > 0");
$out_of_stock = tep_db_num_rows($attribute_stock_query) == 0;
if ($out_of_stock) {
unset($attributes[0]['ovals'][$a]);
}
}
// Draw first option dropdown with all values
$out .= '<tr><td align="right" class=main><b>' . $attributes[0]['oname'] . ":</b></td><td class=main>" . tep_draw_pull_down_menu('id[' . $attributes[0]['oid'] . ']', array_merge(array(array('id' => 0, 'text' => 'First select ' . $attributes[0]['oname'])), $attributes[0]['ovals']), $attributes[0]['default'], "onchange=\"i" . $attributes[0]['oid'] . "(this.form);\"") . "</td></tr>\n";
// Draw second to next to last option dropdowns - no values, with onchange
for ($o = 1; $o < sizeof($attributes) - 1; $o++) {
$out .= '<tr><td align="right" class=main><b>' . $attributes[$o]['oname'] . ":</b></td><td class=main>" . tep_draw_pull_down_menu('id[' . $attributes[$o]['oid'] . ']', array(array('id' => 0, 'text' => 'Next select ' . $attributes[$o]['oname'])), '', "onchange=\"i" . $attributes[$o]['oid'] . "(this.form);\"") . "</td></tr>\n";
}
// Draw last option dropdown - no values, no onchange
$out .= '<tr><td align="right" class=main><b>' . $attributes[$o]['oname'] . ":</b></td><td class=main>" . tep_draw_pull_down_menu('id[' . $attributes[$o]['oid'] . ']', array(array('id' => 0, 'text' => 'Next select ' . $attributes[$o]['oname'])), '') . "</td></tr>\n";
$out .= $this->_draw_dropdown_sequence_js($attributes);
return $out;
}
function affiliate_insert($sql_data_array, $affiliate_parent = 0)
{
// LOCK TABLES
tep_db_query("LOCK TABLES " . TABLE_AFFILIATE . " WRITE");
if ($affiliate_parent > 0) {
$affiliate_root_query = tep_db_query("select affiliate_root, affiliate_rgt, affiliate_lft�from " . TABLE_AFFILIATE . " where affiliate_id = '" . $affiliate_parent . "' ");
// Check if we have a parent affiliate
if ($affiliate_root_array = tep_db_fetch_array($affiliate_root_query)) {
tep_db_query("update " . TABLE_AFFILIATE . " SET affiliate_lft = affiliate_lft + 2 WHERE affiliate_root = '" . $affiliate_root_array['affiliate_root'] . "' and affiliate_lft > " . $affiliate_root_array['affiliate_rgt'] . " AND affiliate_rgt >= " . $affiliate_root_array['affiliate_rgt'] . " ");
tep_db_query("update " . TABLE_AFFILIATE . " SET affiliate_rgt = affiliate_rgt + 2 WHERE affiliate_root = '" . $affiliate_root_array['affiliate_root'] . "' and affiliate_rgt >= " . $affiliate_root_array['affiliate_rgt'] . " ");
$sql_data_array['affiliate_root'] = $affiliate_root_array['affiliate_root'];
$sql_data_array['affiliate_lft'] = $affiliate_root_array['affiliate_rgt'];
$sql_data_array['affiliate_rgt'] = $affiliate_root_array['affiliate_rgt'] + 1;
tep_db_perform(TABLE_AFFILIATE, $sql_data_array);
$affiliate_id = tep_db_insert_id();
}
// no parent -> new root
} else {
$sql_data_array['affiliate_lft'] = '1';
$sql_data_array['affiliate_rgt'] = '2';
tep_db_perform(TABLE_AFFILIATE, $sql_data_array);
$affiliate_id = tep_db_insert_id();
tep_db_query("update " . TABLE_AFFILIATE . " set affiliate_root = '" . $affiliate_id . "' where affiliate_id = '" . $affiliate_id . "' ");
}
// UNLOCK TABLES
tep_db_query("UNLOCK TABLES");
return $affiliate_id;
}
function splitPageResults(&$current_page_number, $max_rows_per_page, &$sql_query, &$query_num_rows, $link = 'db_link')
{
if (empty($current_page_number)) {
$current_page_number = 1;
}
/*$pos_to = strlen($sql_query);
$pos_from = strpos($sql_query, ' from', 0);
$pos_group_by = strpos($sql_query, ' group by', $pos_from);
if (($pos_group_by < $pos_to) && ($pos_group_by != false)) $pos_to = $pos_group_by;
$pos_having = strpos($sql_query, ' having', $pos_from);
if (($pos_having < $pos_to) && ($pos_having != false)) $pos_to = $pos_having;
$pos_order_by = strpos($sql_query, ' order by', $pos_from);
if (($pos_order_by < $pos_to) && ($pos_order_by != false)) $pos_to = $pos_order_by;*/
$count_query = preg_replace("/SELECT(.*?)FROM/si", "SELECT count(*) AS total FROM", $sql_query);
$count_query = preg_replace("/HAVING.*\$/si", "", $count_query);
$count_query = preg_replace("/ORDER BY.*\$/si", "", $count_query);
$reviews_count_query = tep_db_query($count_query, $link);
$reviews_count = tep_db_fetch_array($reviews_count_query);
$query_num_rows = $reviews_count['total'];
$num_pages = ceil($query_num_rows / $max_rows_per_page);
if ($current_page_number > $num_pages) {
$current_page_number = $num_pages;
}
$offset = $max_rows_per_page * ($current_page_number - 1);
$sql_query .= " limit " . max($offset, 0) . ", " . $max_rows_per_page;
}
function tep_get_tax_title_class_id($tax_class_title)
{
$classes_query = tep_db_query("select tax_class_id from " . TABLE_TAX_CLASS . " WHERE tax_class_title = '" . $tax_class_title . "'");
$tax_class_array = tep_db_fetch_array($classes_query);
$tax_class_id = $tax_class_array['tax_class_id'];
return $tax_class_id;
}
function tep_values_name($values_id)
{
global $languages_id;
$values = tep_db_query("select products_options_values_name from " . TABLE_PRODUCTS_OPTIONS_VALUES . " where products_options_values_id = '" . (int) $values_id . "' and language_id = '" . (int) $languages_id . "'");
$values_values = tep_db_fetch_array($values);
return $values_values['products_options_values_name'];
}
function query($order_id)
{
// PWA BOF
// added customers_dummy_account
$order_query = tep_db_query("select customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, customers_dummy_account, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, delivery_date, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_address_format_id, payment_method, cc_type, cc_owner, cc_number, cc_expires, currency, currency_value, date_purchased, orders_status, last_modified from " . TABLE_ORDERS . " where orders_id = '" . (int) $order_id . "'");
// PWA EOF
$order = tep_db_fetch_array($order_query);
$totals_query = tep_db_query("select title, text from " . TABLE_ORDERS_TOTAL . " where orders_id = '" . (int) $order_id . "' order by sort_order");
while ($totals = tep_db_fetch_array($totals_query)) {
$this->totals[] = array('title' => $totals['title'], 'text' => $totals['text']);
}
$this->info = array('currency' => $order['currency'], 'currency_value' => $order['currency_value'], 'payment_method' => $order['payment_method'], 'cc_type' => $order['cc_type'], 'cc_owner' => $order['cc_owner'], 'cc_number' => $order['cc_number'], 'cc_expires' => $order['cc_expires'], 'date_purchased' => $order['date_purchased'], 'orders_status' => $order['orders_status'], 'last_modified' => $order['last_modified'], 'delivery_date' => $order['delivery_date']);
$this->customer = array('name' => $order['customers_name'], 'company' => $order['customers_company'], 'street_address' => $order['customers_street_address'], 'suburb' => $order['customers_suburb'], 'city' => $order['customers_city'], 'postcode' => $order['customers_postcode'], 'state' => $order['customers_state'], 'country' => $order['customers_country'], 'format_id' => $order['customers_address_format_id'], 'telephone' => $order['customers_telephone'], 'email_address' => $order['customers_email_address'], 'is_dummy_account' => $order['customers_dummy_account']);
// PWA EOF
$this->delivery = array('name' => $order['delivery_name'], 'company' => $order['delivery_company'], 'street_address' => $order['delivery_street_address'], 'suburb' => $order['delivery_suburb'], 'city' => $order['delivery_city'], 'postcode' => $order['delivery_postcode'], 'state' => $order['delivery_state'], 'country' => $order['delivery_country'], 'format_id' => $order['delivery_address_format_id']);
$this->billing = array('name' => $order['billing_name'], 'company' => $order['billing_company'], 'street_address' => $order['billing_street_address'], 'suburb' => $order['billing_suburb'], 'city' => $order['billing_city'], 'postcode' => $order['billing_postcode'], 'state' => $order['billing_state'], 'country' => $order['billing_country'], 'format_id' => $order['billing_address_format_id']);
$index = 0;
$orders_products_query = tep_db_query("select orders_products_id, products_name, products_model, products_code, products_price, products_tax, products_quantity, final_price from " . TABLE_ORDERS_PRODUCTS . " where orders_id = '" . (int) $order_id . "'");
while ($orders_products = tep_db_fetch_array($orders_products_query)) {
$this->products[$index] = array('qty' => $orders_products['products_quantity'], 'name' => $orders_products['products_name'], 'model' => $orders_products['products_model'], 'code' => $orders_products['products_code'], 'tax' => $orders_products['products_tax'], 'price' => $orders_products['products_price'], 'final_price' => $orders_products['final_price']);
$subindex = 0;
$attributes_query = tep_db_query("select products_options, products_options_values, options_values_price, price_prefix from " . TABLE_ORDERS_PRODUCTS_ATTRIBUTES . " where orders_id = '" . (int) $order_id . "' and orders_products_id = '" . (int) $orders_products['orders_products_id'] . "'");
if (tep_db_num_rows($attributes_query)) {
while ($attributes = tep_db_fetch_array($attributes_query)) {
$this->products[$index]['attributes'][$subindex] = array('option' => $attributes['products_options'], 'value' => $attributes['products_options_values'], 'prefix' => $attributes['price_prefix'], 'price' => $attributes['options_values_price']);
$subindex++;
}
}
$index++;
}
}
/**
* Call CONFIRMATION_DELIVER and updates order and item data
*/
public static function deliverAction()
{
$post = Globals::getPost();
$orderId = Globals::getPostEntry('order_number');
$order = new order($orderId);
$transactionId = Db::getRatepayOrderDataEntry($orderId, 'transaction_id');
$transactionShortId = Db::getRatepayOrderDataEntry($orderId, 'transaction_short_id');
$subType = Data::isFullDeliver(self::getDeliverPostData($post), $orderId) ? 'full-deliver' : 'partial-deliver';
$data = array('HeadInfo' => RequestMapper::getHeadInfoModel($order, $transactionId, $transactionShortId, $orderId, $subType), 'BasketInfo' => RequestMapper::getBasketInfoModel($order, $orderId, self::getDeliverPostData($post)));
$payment = Loader::getRatepayPayment($order->info['payment_method']);
$requestService = new RequestService($payment->sandbox, $data);
$result = $requestService->callConfirmationDeliver();
Db::xmlLog($order, $requestService->getRequest(), $orderId, $requestService->getResponse());
if (!array_key_exists('error', $result)) {
Session::setRpSessionEntry('message_css_class', 'messageStackSuccess');
Session::setRpSessionEntry('message', RATEPAY_ORDER_MESSAGE_DELIVER_SUCCESS);
Db::shipRpOrder(self::getDeliverPostData($post), $order);
Db::setRpHistoryEntrys($post, 'CONFIRMATION_DELIVER', $subType);
$flag = true;
foreach (Db::getRpItems($orderId) as $item) {
if ($item['ordered'] != $item['shipped']) {
$flag = false;
}
}
if ($flag) {
$sql = "UPDATE orders SET " . "orders_status = " . (int) 3 . " WHERE " . "orders_id = '" . tep_db_input($orderId) . "'";
tep_db_query($sql);
}
} else {
Session::setRpSessionEntry('message_css_class', 'messageStackError');
Session::setRpSessionEntry('message', RATEPAY_ORDER_MESSAGE_DELIVER_ERROR);
}
tep_redirect(tep_href_link("ratepay_order.php", 'oID=' . $orderId, 'SSL'));
}
/**
* @author Michael Hammelmann <*****@*****.**>
* @version 1
* @param $pID products_id
**/
function product($pID)
{
global $languages_id;
$product_info_query = tep_db_query("select p.products_distributor_id,p.products_id, pd.products_name, pd.products_description,pd.short_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id,p.products_weight from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . $pID . "' and pd.products_id = p.products_id and pd.language_id = '" . (int) $languages_id . "'");
$product_info = tep_db_fetch_array($product_info_query);
$this->price = $product_info['products_price'];
$this->tax = tep_get_tax_rate($product_info['products_tax_class_id']);
$tax_class_query = tep_db_query("select tax_class_title from " . TABLE_TAX_CLASS . " where tax_class_id=" . $product_info['products_tax_class_id']);
$tax_class = tep_db_fetch_array($tax_class_query);
$this->tax_title = $tax_class['tax_class_title'];
$this->weight = $product_info['products_weight'];
$this->short_description = $product_info['short_description'];
$this->name = $product_info['products_name'];
$this->image = $product_info['products_image'];
/**
* added for distributor specific data
**/
$distributor_path_query = tep_db_query("select * from " . TABLE_DISTRIBUTORS . " where distributor_id=" . $product_info['products_distributor_id']);
$distributor_path = tep_db_fetch_array($distributor_path_query);
$this->pdf_path = $distributor_path['pdf_prefix'];
$this->image_path = $distributor_path['image_prefix'];
if ($this->image_path == '') {
$this->image_path = DIR_WS_IMAGES;
}
if ($this->image == '') {
$this->image = 'empty.jpg';
$this->image_path = DIR_WS_IMAGES;
}
}
function splitPageResults(&$current_page_number, $max_rows_per_page, &$sql_query, &$query_num_rows)
{
if (empty($current_page_number)) {
$current_page_number = 1;
}
$pos_to = strlen($sql_query);
$pos_from = strpos($sql_query, ' from', 0);
$pos_group_by = strpos($sql_query, ' group by', $pos_from);
if ($pos_group_by < $pos_to && $pos_group_by != false) {
$pos_to = $pos_group_by;
}
$pos_having = strpos($sql_query, ' having', $pos_from);
if ($pos_having < $pos_to && $pos_having != false) {
$pos_to = $pos_having;
}
$pos_order_by = strpos($sql_query, ' order by', $pos_from);
if ($pos_order_by < $pos_to && $pos_order_by != false) {
$pos_to = $pos_order_by;
}
$reviews_count_query = tep_db_query("select count(*) as total " . substr($sql_query, $pos_from, $pos_to - $pos_from));
$reviews_count = tep_db_fetch_array($reviews_count_query);
$query_num_rows = $reviews_count['total'];
$num_pages = ceil($query_num_rows / $max_rows_per_page);
if ($current_page_number > $num_pages) {
$current_page_number = $num_pages;
}
$offset = $max_rows_per_page * ($current_page_number - 1);
$sql_query .= " limit " . max($offset, 0) . ", " . $max_rows_per_page;
}
function _draw_stocked_attributes()
{
global $languages_id;
$out = '';
$attributes = $this->_build_attributes_array(true, false);
if (sizeof($attributes) > 0) {
for ($o = 0; $o < sizeof($attributes); $o++) {
$s = sizeof($attributes[$o]['ovals']);
for ($a = 0; $a < $s; $a++) {
$attribute_stock_query = tep_db_query("select products_stock_quantity from " . TABLE_PRODUCTS_STOCK . " where products_id = '" . (int) $this->products_id . "' AND products_stock_attributes REGEXP '(^|,)" . (int) $attributes[$o]['oid'] . "-" . (int) $attributes[$o]['ovals'][$a]['id'] . "(,|\$)' AND products_stock_quantity > 0");
$out_of_stock = tep_db_num_rows($attribute_stock_query) == 0;
if ($out_of_stock && $this->show_out_of_stock == 'True') {
switch ($this->mark_out_of_stock) {
case 'Left':
$attributes[$o]['ovals'][$a]['text'] = TEXT_OUT_OF_STOCK . ' - ' . $attributes[$o]['ovals'][$a]['text'];
break;
case 'Right':
$attributes[$o]['ovals'][$a]['text'] .= ' - ' . TEXT_OUT_OF_STOCK;
break;
}
} elseif ($out_of_stock && $this->show_out_of_stock != 'True') {
unset($attributes[$o]['ovals'][$a]);
}
}
$out .= '<tr><td align="right" class="main"><b>' . $attributes[$o]['oname'] . ':</b></td><td class="main" align="left">' . tep_draw_pull_down_menu('id[' . $attributes[$o]['oid'] . ']', array_values($attributes[$o]['ovals']), $attributes[$o]['default'], 'onchange="stkmsg(this.form);"') . '</td></tr>';
}
$out .= $this->_draw_out_of_stock_message_js($attributes);
return $out;
}
}
function form_make($engine, $id_field, $date_field, $i)
{
$html = '<div class="createhead">' . constant("CREATE_" . strtoupper($engine) . "_" . $i) . '</div>';
$engine != "customers" ? $dateclause = ", MIN(UNIX_TIMESTAMP({$date_field})) as date_min, MAX(UNIX_TIMESTAMP({$date_field})) as date_max" : ($dateclause = "");
$sql = "SELECT COUNT(*), MIN({$id_field}), MAX({$id_field})" . $dateclause . " FROM " . constant("TABLE_" . strtoupper($engine)) . $this->where;
$result = tep_db_query($sql);
if ($myrow = tep_db_fetch_array($result)) {
$date_min = date('M j, Y g:i a', $myrow["date_min"]);
$date_max = date('M j, Y g:i a', $myrow["date_max"]);
$html .= '<span class="createlabel">' . CREATE_TOTAL . ":</span> " . $myrow["COUNT(*)"] . "<br />";
if ($myrow["COUNT(*)"] >= 1) {
$html .= '<span class="createlabel">' . CREATE_NUM_S . ":</span> " . $myrow["MIN({$id_field})"];
$myrow["COUNT(*)"] > 1 ? $html .= " " . CREATE_TO . " " . $myrow["MAX({$id_field})"] . "<br />" : ($html .= "<br />");
if ($engine != "customers") {
$html .= '<span class="createlabel">' . CREATE_DATE_S . ":</span> " . $date_min;
$myrow["COUNT(*)"] > 1 ? $html .= " " . CREATE_TO . " " . $date_max . "<br />" : ($html .= "<br />");
}
$html .= '<form action=' . $_SERVER[PHP_SELF] . ' method="post" name="' . $engine . $i . '">';
$html .= '<input name="engine" type="hidden" value="' . $engine . '" />';
$html .= '<input name="whereclause" type="hidden" value="' . $this->where . '" />';
$html .= '<input name="qbimported" type="hidden" value="' . $i . '" />';
$html .= '<input name="stage" type="hidden" value="process" />';
$html .= '<input name="submit" type="submit" value="' . CREATE_BUTTON . '" />';
$html .= '</form>';
$html .= '<br /><br />';
} else {
$html .= '<br />';
}
}
$this->form = $html;
}
function sbs_get_countries($countries_id = '', $with_iso_codes = false)
{
$countries_array = array();
if (tep_not_null($countries_id)) {
if ($with_iso_codes == true) {
// Ajax Country-state selector
//$countries = tep_db_query("select countries_name, countries_iso_code_2, countries_iso_code_3 from " . TABLE_COUNTRIES . " where countries_id = '" . (int)$countries_id . "' order by countries_name");
$countries = tep_db_query("select countries_name, countries_iso_code_2, countries_iso_code_3 from " . TABLE_COUNTRIES . " where countries_id = '" . (int) $countries_id . "' and active = 1 order by countries_name");
$countries_values = tep_db_fetch_array($countries);
$countries_array = array('countries_name' => $countries_values['countries_name'], 'countries_iso_code_2' => $countries_values['countries_iso_code_2'], 'countries_iso_code_3' => $countries_values['countries_iso_code_3']);
} else {
$countries = tep_db_query("select countries_name from " . TABLE_COUNTRIES . " where countries_id = '" . (int) $countries_id . "'");
$countries_values = tep_db_fetch_array($countries);
$countries_array = array('countries_name' => $countries_values['countries_name']);
}
} else {
// Ajax Country-state selector
//$countries = tep_db_query("select countries_id, countries_name from " . TABLE_COUNTRIES . " order by countries_name");
$countries = tep_db_query("select countries_id, countries_name from " . TABLE_COUNTRIES . " where active = 1 order by countries_name");
while ($countries_values = tep_db_fetch_array($countries)) {
$countries_array[] = array('countries_id' => $countries_values['countries_id'], 'countries_name' => $countries_values['countries_name']);
}
}
return $countries_array;
}
