function query($order_id)
{
$order_query = olc_db_query("\n\t\tselect\n\t\tcustomers_name,\n\t\tcustomers_cid,\n\t\tcustomers_id,\n\t\tcustomers_company,\n\t\tcustomers_street_address,\n\t\tcustomers_suburb,\n\t\tcustomers_city,\n\t\tcustomers_postcode,\n\t\tcustomers_state,\n\t\tcustomers_country,\n\t\tcustomers_telephone,\n\t\tcustomers_email_address,\n\t\tcustomers_address_format_id,\n\t\tdelivery_name,\n\t\tdelivery_company,\n\t\tdelivery_street_address,\n\t\tdelivery_suburb,\n\t\tdelivery_city,\n\t\tdelivery_postcode,\n\t\tdelivery_state,\n\t\tdelivery_country,\n\t\tdelivery_address_format_id,\n\t\tbilling_name,\n\t\tbilling_company,\n\t\tbilling_street_address,\n\t\tbilling_suburb,\n\t\tbilling_city,\n\t\tbilling_postcode,\n\t\tbilling_state,\n\t\tbilling_country,\n\t\tbilling_address_format_id,\n\t\tbilling_invoice_number,\n\t\tpayment_method,\n\t\tcc_type,\n\t\tcc_owner,\n\t\tcc_number,\n\t\tcc_expires,\n\t\tcomments,\n\t\tcurrency,\n\t\tcurrency_value,\n\t\tdate_purchased,\n\t\torders_status,\n\t\torders_trackcode,\n\t\tlast_modified,\n\t\tpayment_id,\n\t\tcustomers_status,\n\t\tcustomers_status_name,\n\t\tcustomers_status_image,\n\t\tcustomers_ip,\n\t\tlanguage,\n\t\tcustomers_status_discount\n\t\tfrom " . TABLE_ORDERS . " where\n\t\torders_id = '" . olc_db_input($order_id) . APOS);
$order = olc_db_fetch_array($order_query);
$totals_query = olc_db_query("select title, text from " . TABLE_ORDERS_TOTAL . " where orders_id = '" . olc_db_input($order_id) . "' order by sort_order");
while ($totals = olc_db_fetch_array($totals_query)) {
$this->totals[] = array('title' => $totals['title'], 'text' => $totals['text']);
}
$this->info = array('order_id' => $order_id, 'currency' => $order['currency'], 'currency_value' => $order['currency_value'], 'payment_method' => $order['payment_method'], 'status' => $order['customers_status'], 'status_name' => $order['customers_status_name'], 'status_image' => $order['customers_status_image'], 'status_discount' => $order['customers_status_discount'], 'cc_type' => $order['cc_type'], 'cc_owner' => $order['cc_owner'], 'cc_number' => $order['cc_number'], 'cc_expires' => $order['cc_expires'], 'comments' => $order['comments'], 'language' => $order['language'], 'date_purchased' => $order['date_purchased'], 'payment_id' => $order['payment_id'], 'orders_status' => $order['orders_status'], 'orders_trackcode' => $order['orders_trackcode'], 'last_modified' => $order['last_modified']);
$this->customer = array('name' => $order['customers_name'], 'id' => $order['customers_id'], 'company' => $order['customers_company'], 'csID' => $order['customers_cid'], 'shop_id' => $order['shop_id'], 'id' => $order['customers_id'], 'cIP' => $order['customers_ip'], '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'], 'billing_invoice_number' => $order['billing_invoice_number']);
$index = 0;
$orders_products_query = olc_db_query("\n\t\t\tselect\n\t\t\torders_products_id,\n\t\t\tproducts_name,\n\t\t\tproducts_id,\n\t\t\tproducts_model,\n\t\t\tproducts_price,\n\t\t\tproducts_tax,\n\t\t\tproducts_quantity,\n\t\t\tfinal_price,\n\t\t\tallow_tax,\n\t\t\tproducts_discount_made\n\t\t\tfrom " . TABLE_ORDERS_PRODUCTS . "\n\t\t\twhere\n\t\t\torders_id ='" . olc_db_input($order_id) . APOS);
while ($orders_products = olc_db_fetch_array($orders_products_query)) {
$this->products[$index] = array('id' => $orders_products['products_id'], 'orders_products_id' => $orders_products['orders_products_id'], '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'], 'discount' => $orders_products['products_discount_made'], 'final_price' => $orders_products['final_price'], 'allow_tax' => $orders_products['allow_tax'], 'auctionid' => $orders_products['auctionid']);
$subindex = 0;
$attributes_query = olc_db_query("\n\t\t\t\tselect\n\t\t\t\tproducts_options,\n\t\t\t\tproducts_options_values,\n\t\t\t\tproducts_options_id,\n\t\t\t\tproducts_options_values_id,\n\t\t\t\toptions_values_price,\n\t\t\t\tprice_prefix from " . TABLE_ORDERS_PRODUCTS_ATTRIBUTES . " where orders_id = '" . olc_db_input($order_id) . "' and orders_products_id = '" . $orders_products['orders_products_id'] . APOS);
if (olc_db_num_rows($attributes_query)) {
while ($attributes = olc_db_fetch_array($attributes_query)) {
$this->products[$index]['attributes'][$subindex] = array('option' => $attributes['products_options'], 'value' => $attributes['products_options_values'], 'option_id' => $attributes['products_options_id'], 'value_id' => $attributes['products_options_values_id'], 'prefix' => $attributes['price_prefix'], 'price' => $attributes['options_values_price']);
$subindex++;
}
}
$index++;
}
}
function olc_display_banner($action, $identifier)
{
if ($action == 'dynamic') {
$banners_query = olc_db_query(SELECT_COUNT . " as count from " . TABLE_BANNERS . " where status = '1' and banners_group = '" . $identifier . APOS);
$banners = olc_db_fetch_array($banners_query);
if ($banners['count'] > 0) {
$banner = olc_random_select("select banners_id, banners_title, banners_image, banners_html_text from " . TABLE_BANNERS . " where status = '1' and banners_group = '" . $identifier . APOS);
} else {
return '<b>OLC ERROR! (olc_display_banner(' . $action . ', ' . $identifier . ') -> No banners with group \'' . $identifier . '\' found!</b>';
}
} elseif ($action == 'static') {
if (is_array($identifier)) {
$banner = $identifier;
} else {
$banner_query = olc_db_query("select banners_id, banners_title, banners_image, banners_html_text from " . TABLE_BANNERS . " where status = '1' and banners_id = '" . $identifier . APOS);
if (olc_db_num_rows($banner_query)) {
$banner = olc_db_fetch_array($banner_query);
} else {
return '<b>OLC ERROR! (olc_display_banner(' . $action . ', ' . $identifier . ') -> Banner with id \'' . $identifier . '\' not found, or status inactive</b>';
}
}
} else {
return '<b>OLC ERROR! (olc_display_banner(' . $action . ', ' . $identifier . ') -> Unknown $action parameter value - it must be either \'dynamic\' or \'static\'' . HTML_B_END;
}
if (olc_not_null($banner['banners_html_text'])) {
$banner_string = $banner['banners_html_text'];
} else {
$banner_string = HTML_A_START . olc_href_link(FILENAME_REDIRECT, 'action=banner&goto=' . $banner['banners_id']) . '" target="_blank">' . olc_image(DIR_WS_IMAGES . 'banner/' . $banner['banners_image'], $banner['banners_title']) . HTML_A_END;
}
olc_update_banner_display_count($banner['banners_id']);
return $banner_string;
}
function olc_random_select($query, $rows = 1)
{
global $random_rows;
$random_product = '';
$random_query = olc_db_query($query);
$num_rows = olc_db_num_rows($random_query);
if ($num_rows > 1) {
$num_rows1 = $num_rows - 1;
for ($row = 1; $row <= $rows; $row++) {
$tries = 0;
$random_row = olc_rand(0, $num_rows1);
$random_row_store = "|" . $random_row . "|";
$include_row = true;
while (!(strpos($random_rows, $random_row_store) === false)) {
$tries++;
if ($tries > 10) {
$include_row = false;
break;
} else {
$random_row = olc_rand(0, $num_rows1);
}
}
if ($include_row) {
$random_rows .= $random_row_store;
olc_db_data_seek($random_query, $random_row);
$random_product[] = olc_db_fetch_array($random_query);
}
}
} else {
if ($num_rows > 0) {
$random_product[] = olc_db_fetch_array($random_query);
}
}
return $random_product;
}
function check()
{
if (!isset($this->_check)) {
$check_query = olc_db_query("select configuration_value from " . TABLE_CONFIGURATION . " where configuration_key = 'MODULE_ORDER_TOTAL_SUBTOTAL_NO_TAX_STATUS'");
$this->_check = olc_db_num_rows($check_query);
}
return $this->_check;
}
function olc_expire_specials()
{
$specials_query = olc_db_query("select specials_id from " . TABLE_SPECIALS . " where status = '1' and now() >= expires_date and expires_date > 0");
if (olc_db_num_rows($specials_query)) {
while ($specials = olc_db_fetch_array($specials_query)) {
olc_set_specials_status($specials['specials_id'], '0');
}
}
}
function olc_currency_exists($code)
{
$currency_code = olc_db_query("select currencies_id from " . TABLE_CURRENCIES . " where code = '" . $code . APOS);
if (olc_db_num_rows($currency_code)) {
return $code;
} else {
return false;
}
}
function olc_get_address_format_id($country_id)
{
$address_format_query = olc_db_query("select address_format_id as format_id from " . TABLE_COUNTRIES . " where countries_id = '" . $country_id . APOS);
if (olc_db_num_rows($address_format_query)) {
$address_format = olc_db_fetch_array($address_format_query);
return $address_format['format_id'];
} else {
return '1';
}
}
function olc_get_zone_name($country_id, $zone_id, $default_zone = '')
{
$zone_query = olc_db_query("select zone_name from " . TABLE_ZONES . " where zone_country_id = '" . $country_id . "' and zone_id = '" . $zone_id . APOS);
if (olc_db_num_rows($zone_query)) {
$zone = olc_db_fetch_array($zone_query);
return $zone['zone_name'];
} else {
return $default_zone;
}
}
function olc_get_languages_directory($code)
{
$language_query = olc_db_query("select languages_id, directory from " . TABLE_LANGUAGES . " where code = '" . $code . APOS);
if (olc_db_num_rows($language_query)) {
$lang = olc_db_fetch_array($language_query);
$_SESSION['languages_id'] = $lang['languages_id'];
return $lang['directory'];
} else {
return false;
}
}
function olc_activate_banners()
{
$banners_query = olc_db_query("select banners_id, date_scheduled from " . TABLE_BANNERS . " where date_scheduled != ''");
if (olc_db_num_rows($banners_query)) {
while ($banners = olc_db_fetch_array($banners_query)) {
if (date('Y-m-d H:i:s') >= $banners['date_scheduled']) {
olc_set_banner_status($banners['banners_id'], '1');
}
}
}
}
function olc_get_affiliate_tax_rate($class_id, $country_id, $zone_id)
{
$tax_query = olc_db_query("select SUM(tax_rate) as tax_rate from " . TABLE_TAX_RATES . " tr left join " . TABLE_ZONES_TO_GEO_ZONES . " za ON tr.tax_zone_id = za.geo_zone_id left join " . TABLE_GEO_ZONES . " tz ON tz.geo_zone_id = tr.tax_zone_id\n \tWHERE (za.zone_country_id IS NULL OR za.zone_country_id = '0' OR za.zone_country_id = '" . $country_id . "') AND (za.zone_id IS NULL OR za.zone_id = '0' OR za.zone_id = '" . $zone_id . "') AND tr.tax_class_id = '" . $class_id . "' GROUP BY tr.tax_priority");
if (olc_db_num_rows($tax_query)) {
$tax_multiplier = 0;
while ($tax = olc_db_fetch_array($tax_query)) {
$tax_multiplier += $tax['tax_rate'];
}
return $tax_multiplier;
} else {
return 0;
}
}
function olc_get_manufacturers($manufacturers_array = '')
{
$manufacturers_query = olc_db_query("select manufacturers_id, manufacturers_name from " . TABLE_MANUFACTURERS . " order by manufacturers_name");
if (olc_db_num_rows($manufacturers_query)) {
if (!is_array($manufacturers_array)) {
$manufacturers_array = array();
}
$manufacturers_array[] = array('id' => EMPTY_STRING, 'text' => TEXT_ALL_MANUFACTURERS);
while ($manufacturers = olc_db_fetch_array($manufacturers_query)) {
$manufacturers_array[] = array('id' => $manufacturers['manufacturers_id'], 'text' => $manufacturers['manufacturers_name']);
}
}
return $manufacturers_array;
}
function olc_get_tax_description($class_id, $country_id, $zone_id)
{
$tax_query = olc_db_query("select tax_description from " . TABLE_TAX_RATES . " tr left join " . TABLE_ZONES_TO_GEO_ZONES . " za on (tr.tax_zone_id = za.geo_zone_id) left join " . TABLE_GEO_ZONES . " tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '" . $country_id . "') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '" . $zone_id . "') and tr.tax_class_id = '" . $class_id . "' order by tr.tax_priority");
if (olc_db_num_rows($tax_query)) {
$tax_description = '';
while ($tax = olc_db_fetch_array($tax_query)) {
$tax_description .= $tax['tax_description'] . ' + ';
}
$tax_description = substr($tax_description, 0, -3);
return $tax_description;
} else {
return TEXT_UNKNOWN_TAX_RATE;
}
}
function olc_findTitle($current_pid, $languageFilter)
{
$query = "SELECT * FROM " . TABLE_PRODUCTS_DESCRIPTION . " where language_id = '" . SESSION_LANGUAGE_ID . "' AND products_id = '" . $current_pid . APOS;
$result = olc_db_query($query);
$matches = olc_db_num_rows($result);
if ($matches) {
while ($line = olc_db_fetch_array($result, olc_db_ASSOC)) {
$productName = $line['products_name'];
}
return $productName;
} else {
return "Something isn't right....";
}
}
function olc_gv_account_update($customer_id, $gv_id)
{
$customer_gv_query = olc_db_query("select amount from " . TABLE_COUPON_GV_CUSTOMER . " where customer_id = '" . $customer_id . APOS);
$coupon_gv_query = olc_db_query("select coupon_amount from " . TABLE_COUPONS . " where coupon_id = '" . $gv_id . APOS);
$coupon_gv = olc_db_fetch_array($coupon_gv_query);
if (olc_db_num_rows($customer_gv_query) > 0) {
$customer_gv = olc_db_fetch_array($customer_gv_query);
$new_gv_amount = $customer_gv['amount'] + $coupon_gv['coupon_amount'];
// new code bugfix
$gv_query = olc_db_query(SQL_UPDATE . TABLE_COUPON_GV_CUSTOMER . " set amount = '" . $new_gv_amount . "' where customer_id = '" . $customer_id . APOS);
// original code $gv_query = olc_db_query(SQL_UPDATE . TABLE_COUPON_GV_CUSTOMER . " set amount = '" . $new_gv_amount . APOS);
} else {
$gv_query = olc_db_query(INSERT_INTO . TABLE_COUPON_GV_CUSTOMER . " (customer_id, amount) values ('" . $customer_id . "', '" . $coupon_gv['coupon_amount'] . "')");
}
}
function checkAttribute($current_value_id, $current_pid, $current_product_option_id)
{
global $attribute_value_price, $sortorder, $attribute_value_weight, $attribute_value_weight_prefix, $attribute_value_prefix, $attribute_value_model, $attribute_value_stock, $posCheck, $negCheck, $posCheck_weight, $negCheck_weight;
$query = "SELECT * FROM " . TABLE_PRODUCTS_ATTRIBUTES . " where options_values_id = '" . $current_value_id . "' AND products_id = ' " . $current_pid . "' AND options_id = '" . $current_product_option_id . APOS;
$result = olc_db_query($query);
$isFound = olc_db_num_rows($result);
if ($isFound) {
while ($line = olc_db_fetch_array($result, olc_db_ASSOC)) {
$attribute_value_price = $line['options_values_price'];
$sortorder = $line['sortorder'];
$attribute_value_prefix = $line['price_prefix'];
$attribute_value_weight_prefix = $line['weight_prefix'];
$attribute_value_model = $line['attributes_model'];
$attribute_value_stock = $line['attributes_stock'];
$attribute_value_weight = $line['options_values_weight'];
if ($attribute_value_prefix == '+') {
$posCheck = ' SELECTED';
$negCheck = '';
} else {
$posCheck = '';
$negCheck = ' SELECTED';
}
if ($attribute_value_weight_prefix == '+') {
$posCheck_weight = ' SELECTED';
$negCheck_weight = '';
} else {
$posCheck_weight = '';
$negCheck_weight = ' SELECTED';
}
}
return true;
} else {
$attribute_value_price = '';
$sortorder = '';
$attribute_value_weight = '';
$attribute_value_prefix = '';
$attribute_value_weight_prefix = '';
$attribute_value_model = '';
$attribute_value_stock = '';
$posCheck = '';
$negCheck = '';
$posCheck_weight = '';
$negCheck_weight = '';
return false;
}
}
function olc_expire_banners()
{
$banners_query = olc_db_query("select b.banners_id, b.expires_date, b.expires_impressions, sum(bh.banners_shown) as banners_shown from " . TABLE_BANNERS . " b, " . TABLE_BANNERS_HISTORY . " bh where b.status = '1' and b.banners_id = bh.banners_id group by b.banners_id");
if (olc_db_num_rows($banners_query)) {
while ($banners = olc_db_fetch_array($banners_query)) {
if (olc_not_null($banners['expires_date'])) {
if (date('Y-m-d H:i:s') >= $banners['expires_date']) {
olc_set_banner_status($banners['banners_id'], '0');
}
} elseif (olc_not_null($banners['expires_impressions'])) {
if ($banners['banners_shown'] >= $banners['expires_impressions']) {
olc_set_banner_status($banners['banners_id'], '0');
}
}
}
}
}
function paypal_remove_order($order_id)
{
include_once PAYPAL_IPN_DIR . 'inc.php';
$ipn_query = olc_db_query("select payment_id from " . TABLE_ORDERS . " where orders_id = '" . (int) $order_id . APOS);
if (olc_db_num_rows($ipn_query)) {
// this is a ipn order (PayPal or StormPay)
$ipn_order = olc_db_fetch_array($ipn_query);
$paypal_id = $ipn_order['payment_id'];
$txn_query = olc_db_query("select txn_id from " . TABLE_PAYPAL . " where paypal_id ='" . (int) $paypal_id . APOS);
$txn = olc_db_fetch_array($txn_query);
olc_db_query(DELETE_FROM . TABLE_PAYPAL . " where paypal_id = '" . (int) $paypal_id . APOS);
olc_db_query(DELETE_FROM . TABLE_PAYPAL . " where parent_txn_id = '" . olc_db_input($txn['txn_id']) . APOS);
if (defined('TABLE_PAYPAL_AUCTION')) {
olc_db_query(DELETE_FROM . TABLE_PAYPAL_AUCTION . " where paypal_id = '" . (int) $paypal_id . APOS);
}
}
olc_db_query(DELETE_FROM . TABLE_ORDERS_SESSION_INFO . " where orders_id = '" . (int) $order_id . APOS);
}
function olc_get_product_path($products_id)
{
$cPath = EMPTY_STRING;
$category_query = olc_db_query("\n\tselect\n\tp2c.categories_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c\n\twhere\n\tp.products_id = '" . (int) $products_id . "' and\n\tp.products_status = '1' and\n\tp.products_id = p2c.products_id\n\tlimit 1");
if (olc_db_num_rows($category_query)) {
$category = olc_db_fetch_array($category_query);
$categories_id = $category['categories_id'];
$categories = array();
olc_get_parent_categories($categories, $categories_id);
$categories = array_reverse($categories);
$cPath = implode(UNDERSCORE, $categories);
if ($cPath) {
$cPath .= UNDERSCORE;
}
$cPath .= $categories_id;
}
return $cPath;
}
function olc_get_tax_rate_export($class_id, $country_id = -1, $zone_id = -1)
{
global $currency;
// calculate currencies
if ($country_id == -1 && $zone_id == -1) {
$country_id = STORE_COUNTRY;
$zone_id = STORE_ZONE;
}
$tax_query = olc_db_query("select sum(tax_rate) as tax_rate from " . TABLE_TAX_RATES . " tr left join " . TABLE_ZONES_TO_GEO_ZONES . " za on (tr.tax_zone_id = za.geo_zone_id) left join " . TABLE_GEO_ZONES . " tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '" . $country_id . "') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '" . $zone_id . "') and tr.tax_class_id = '" . $class_id . "' group by tr.tax_priority");
if (olc_db_num_rows($tax_query)) {
$tax_multiplier = 1.0;
while ($tax = olc_db_fetch_array($tax_query)) {
$tax_multiplier *= 1.0 + $tax['tax_rate'] / 100;
}
return ($tax_multiplier - 1.0) * 100;
} else {
return 0;
}
}
function olc_count_products_in_category($category_id, $include_inactive = false)
{
$products_count = 0;
if (SHOW_COUNTS == TRUE_STRING_S) {
if (!$include_inactive) {
$products_status = "\n\t\tp.products_status = '1' and\n";
}
$products_query = olc_db_query("select count(*) as total from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c\n\t\twhere\t" . $products_status . "\n\t\tp.products_id = p2c.products_id and\n\t\tp2c.categories_id = '" . $category_id . APOS);
$products = olc_db_fetch_array($products_query);
$products_count += $products['total'];
$child_categories_query = olc_db_query("select categories_id from " . TABLE_CATEGORIES . " where parent_id = '" . $category_id . APOS);
if (olc_db_num_rows($child_categories_query)) {
while ($child_categories = olc_db_fetch_array($child_categories_query)) {
$products_count += olc_count_products_in_category($child_categories['categories_id'], $include_inactive);
}
}
}
return $products_count;
}
function create_coupon_code($salt = "secret", $length = SECURITY_CODE_LENGTH)
{
$ccid = md5(uniqid("", "salt"));
$ccid .= md5(uniqid("", "salt"));
$ccid .= md5(uniqid("", "salt"));
$ccid .= md5(uniqid("", "salt"));
srand((double) microtime() * 1000000);
// seed the random number generator
$random_start = @rand(0, 128 - $length);
$good_result = 0;
while ($good_result == 0) {
$id1 = substr($ccid, $random_start, $length);
$query = olc_db_query("select coupon_code from " . TABLE_COUPONS . " where coupon_code = '" . $id1 . APOS);
if (olc_db_num_rows($query) == 0) {
$good_result = 1;
}
}
return $id1;
}
function parse_sql_file($file_name, $is_olc_file, &$tables, &$text_array, &$insert_array, &$text_array_search, &$keys_array, &$table_charset, $default_charset, &$struct_count, &$data_count)
{
if (defined('TABLE_PREFIX_COMMON')) {
$error0 = 'Fehler beim Öffnen der Datei "#"!';
$fp = @fopen($file_name, 'r');
if ($fp) {
$not_is_olc_file = !$is_olc_file;
$check_charset = true;
$not_is_olc_file && $not_is_version_5;
$charset_len = strlen(DEFAULT_CHARSET);
$not_found_charset = true;
$file_offset = 0;
$not_insert_into_found = true;
while ($line = fgets($fp)) {
$line = trim($line);
$struct_count++;
if ($line) {
$char1 = substr($line, 0, 1);
if (strpos(COMMENTS, $char1) !== false) {
continue;
} elseif (strpos($line, SEMI_COLON) !== false) {
if ($not_is_olc_file) {
if ($check_charset) {
$pos = strpos($line, DEFAULT_CHARSET);
if ($pos !== false) {
$pos += $charset_len;
$pos1 = strpos($line, BLANK, $pos);
if ($pos1 === false) {
$pos1 = strpos($line, SEMI_COLON, $pos);
}
$charset = strtolower(substr($line, $pos, $pos1 - $pos));
$table_charset[$table_name] = $charset;
}
}
}
} else {
$uc_line = strtoupper($line);
if (strpos($uc_line, MY_INSERT_INTO) === false) {
if (strpos($uc_line, DROP_TABLE) === false) {
$pos = strpos($uc_line, CREATE_TABLE);
if ($pos !== false) {
//Set new table name
$line = rtrim(str_replace(LPAREN, EMPTY_STRING, $line));
$pos = strrpos($line, BLANK);
$table_name = substr($line, $pos + 1);
if (REMOVE_PREFIX) {
$table_name_p = $table_name;
$table_name = str_replace(TABLE_PREFIX_COMMON, EMPTY_STRING, $table_name);
}
$table_name = strtolower(str_replace(APOS_S, EMPTY_STRING, $table_name));
if ($is_olc_file) {
$tables[] = $table_name;
if ($check_charset) {
$status_query = str_replace(HASH, $table_name_p, SHOW_TABLE_STATUS);
$status = olc_db_query($status_query);
if (olc_db_num_rows($status) > 0) {
$status = olc_db_fetch_array($status);
$charset = $status[COLLATION_FIELD];
$table_charset[$table_name] = $charset;
}
}
}
} else {
if (strpos($line, KEY) !== false) {
if ($not_is_olc_file) {
$keys_array[$table_name][] = $line;
}
} else {
//Found field, extract field name
$line = str_replace(APOS_S, EMPTY_STRING, $line);
if (substr($line, -1) == COMMA) {
$line = substr($line, 0, strlen($line) - 1);
}
$line = TILDE . $line;
if ($not_is_olc_file) {
$text_array[] = $table_name . $line;
}
$pos = strpos($line, BLANK);
if ($pos !== false) {
$line = substr($line, 0, $pos);
}
$line = $table_name . $line;
if ($is_olc_file) {
$text_array[] = $line;
} else {
$text_array_search[] = $line;
}
}
}
}
}
}
/*
else
{
$not_insert_into_found=false;
break;
}
*/
}
//$file_offset=ftell($fp); //Get current file pointer position
}
if ($is_olc_file) {
sort($text_array);
}
$open_new_file = $is_olc_file || $not_insert_into_found;
if ($open_new_file) {
fclose($fp);
if ($is_olc_file) {
$file_name = OLCOMMERCE_SQL;
} else {
global $import_data_file_name;
$file_name = $import_data_file_name;
}
} else {
fseek($fp, $file_offset);
//reposition file to last line
}
//Identify/remove "INSERT INTO"s, which must not be applied from the import data!
if ($open_new_file) {
$fp = @fopen($file_name, 'r');
}
if ($fp) {
if ($not_is_olc_file) {
//sort($text_array_search);
$data_for_table_len = strlen(DATA_FOR_TABLE);
$data_for_table_len_1 = strlen(DATA_FOR_TABLE_1);
$pos = strrpos($file_name, DOT);
$fp1 = substr($file_name, $pos);
$file_name_1 = str_replace($fp1, '_neu' . $fp1, $file_name);
@unlink($file_name_1);
$fp1 = @fopen($file_name_1, 'w');
if ($fp1) {
$insert_into_active = false;
fputs($fp1, NEW_LINE);
} else {
return str_replace(HASH, str_replace(ADMIN_PATH_PREFIX, EMPTY_STRING, $file_name_1), $error0);
}
}
$insert_into_len = strlen(MY_INSERT_INTO);
while ($line = fgets($fp)) {
$data_count++;
if ($line) {
$pos = strpos($line, MY_INSERT_INTO);
$tline = trim($line);
if ($pos === false || $insert_into_active) {
if ($not_is_olc_file) {
if ($insert_into_active) {
$insert_into_active = substr($tline, -1) != SEMI_COLON;
} elseif (REMOVE_PREFIX) {
$pos = strpos($line, DATA_FOR_TABLE);
if ($pos === false) {
$pos = strpos($line, DATA_FOR_TABLE_1);
$len = $data_for_table_len_1;
} else {
$len = $data_for_table_len;
}
if ($pos !== false) {
$s = trim(substr($line, $pos + $len));
$s1 = str_replace(APOS_S, EMPTY_STRING, $s);
if (binary_search($tables, $s1)) {
//Only apply prefix to tables belonging to OL-Commerce!
$line = str_replace($s1, TABLE_PREFIX_COMMON . $s1, $line);
}
}
}
if ($not_is_in_ignore_table) {
fputs($fp1, $line);
}
}
} else {
$pos += $insert_into_len;
$pos1 = strpos($line, BLANK, $pos);
$table_name = substr($line, $pos, $pos1 - $pos);
if ($is_olc_file) {
$table_name = str_replace(INSTALL_TABLE_PREFIX_COMMON, EMPTY_STRING, $table_name);
} else {
if (REMOVE_PREFIX) {
$line = str_replace(TABLE_PREFIX_COMMON, EMPTY_STRING, $line);
}
}
$table_name = str_replace(APOS_S, EMPTY_STRING, $table_name);
$is_in_ignore_table = binary_search($insert_array, $table_name);
//in_array($table_name,$insert_array);
$not_is_in_ignore_table = !$is_in_ignore_table;
if ($not_is_olc_file) {
if ($is_in_ignore_table) {
$not_is_in_ignore_table = strpos(ALLOW_IMPORT_TABLES, $table_name) !== false;
if ($not_is_in_ignore_table) {
$is_in_ignore_table = false;
$s = $table_name;
if (REMOVE_PREFIX) {
$s = TABLE_PREFIX_COMMON . $s;
}
fputs($fp1, TRUNCATE_TABLE . APOS_S . $s . APOS_S . SEMI_COLON . NEW_LINE);
}
}
}
if ($is_in_ignore_table) {
if ($insert_into_active) {
$insert_into_active = substr($tline, -1) != SEMI_COLON;
}
} else {
if ($is_olc_file) {
//Identify "INSERT INTO"s, which must not be applied from the import data!
$insert_array[] = $table_name;
} else {
//Modify "INSERT INTO"s!
$insert_into_active = substr($tline, -1) != SEMI_COLON;
$line = str_replace(MY_INSERT_INTO, INSERT_IGNORE_INTO, $line);
if (REMOVE_PREFIX) {
if (binary_search($tables, $table_name)) {
//Only apply prefix to tables belonging to OL-Commerce!
$pos = strpos($line, $table_name);
$line = substr($line, 0, $pos) . TABLE_PREFIX_COMMON . substr($line, $pos);
}
}
fputs($fp1, $line);
}
}
}
}
}
if ($is_olc_file) {
sort($insert_array);
} else {
fclose($fp1);
$import_data_file_name = $file_name_1;
}
return true;
} else {
$show_error = true;
}
} else {
$show_file_error = true;
}
if ($show_file_error) {
$error = str_replace(HASH, str_replace(ADMIN_PATH_PREFIX, EMPTY_STRING, $file_name), $error0);
}
} else {
$error = 'Unzulässiges System';
}
return $error;
}
*/
olc_smarty_init($module_smarty, $cache_id);
$basket_query = olc_db_query(SELECT_ALL . TABLE_CUSTOMERS_BASKET_SAVE_BASKETS . $where_cid . ' order by basket_date_added DESC');
if (olc_db_num_rows($basket_query)) {
require_once DIR_FS_INC . 'olc_draw_radio_field.inc.php';
require_once DIR_FS_INC . 'olc_draw_checkbox_field.inc.php';
require_once DIR_FS_INC . 'olc_get_prid.inc.php';
require_once DIR_FS_INC . 'olc_get_smarty_config_variable.inc.php';
$module_content = array();
while ($basket = olc_db_fetch_array($basket_query)) {
$basket_id = $basket['customers_basket_id'];
$show_order_details = $basket_id == $bid;
if ($show_order_details) {
$where_bid = $sql_where . "customers_basket_id='" . $basket_id . APOS;
$products_basket_query = olc_db_query(SELECT_ALL . TABLE_CUSTOMERS_BASKET_SAVE . $where_bid);
if (olc_db_num_rows($products_basket_query) > 0) {
$products_query_sql0 = olc_standard_products_query();
/*
$products_query_sql0="
select
p.products_id,
pd.products_name,
p.products_image,
p.products_model,
p.products_price,
p.products_discount_allowed,
p.products_weight,
p.products_tax_class_id
from " .
TABLE_PRODUCTS . " p, " .
TABLE_PRODUCTS_DESCRIPTION . " pd
function check()
{
if (!isset($this->_check)) {
$check_query = olc_db_query("select configuration_value from " . TABLE_CONFIGURATION . " where configuration_key = 'MODULE_PAYMENT_2CHECKOUT_STATUS'");
$this->_check = olc_db_num_rows($check_query);
}
return $this->_check;
}
break;
}
$from_date = mktime(0, 0, 0, $month_f, $day_f, $year_f);
$date_from = date($date_format, $from_date);
$to_date = mktime(0, 0, 0, $month_t, $day_t, $year_t);
$date_to = date($date_format, $to_date);
if ($show_add_data) {
$text .= $lparen . strftime($date_format_text, $from_date) . $rparen;
}
if ($show_date_range) {
$text .= HTML_BR . ltrim($lparen . strftime($date_format_1, $from_date)) . $sep . ltrim(strftime($date_format_1, $to_date)) . $rparen;
}
$conv_query = str_replace($param1, $date_from, $conv_query_raw);
$conv_query = str_replace($param2, $date_to, $conv_query);
$conv_query = olc_db_query($conv_query);
if (olc_db_num_rows($conv_query)) {
$have_no_entry = true;
$current_content .= '
<tr>
' . str_replace(HASH, $text, $line);
while ($conv = olc_db_fetch_array($conv_query)) {
$count = $conv[$count_text];
if ($count) {
$have_no_entry = false;
$current_content .= str_replace(HASH, olc_format_price($conv[$value_text], 1, 1), $line_right) . str_replace(HASH, olc_format_price($conv[$avg_text], 1, 1), $line_right) . str_replace(HASH, $count, $line_right);
} else {
break;
}
}
if ($have_no_entry) {
$current_content .= $no_entry_line;
$where_str .= $sql_and . "<= " . $pto_to_check / CURRENCY_VALUE . RPAREN;
}
$order_str = ' group by pd.products_name order by pd.products_name';
$products_listing_sql_main = $select_str . $from_str . $where_str . $order_str;
if (defined("MODULE_TAG_CLOUD_STATUS") && MODULE_TAG_CLOUD_STATUS == TRUE_STRING_L && !olc_not_null($_GET['categories_id']) && !olc_not_null($_GET['manufacturers_id']) && !strlen($_GET['pfrom']) && !strlen($_GET['pto']) && ($cloudTag = $keywords) != EMPTY_STRING) {
$s = 'tag_cloud_tags';
if (!isset($_SESSION[$s])) {
$_SESSION[$s] = array();
}
$cloudTag = substr($cloudTag, 0, 64);
if (!in_array($cloudTag, $_SESSION[$s])) {
$_SESSION[$s][] = $cloudTag;
$cloudTag = addslashes($cloudTag);
$cloudLang = SESSION_LANGUAGE_ID;
$tagTest = olc_db_fetch_array(olc_db_query(SELECT_COUNT . "AS count " . "FROM \n\t\t\t\tmodule_tag_cloud " . "WHERE \n\t\t\t\ttag = '" . $cloudTag . "' AND language_id = " . $cloudLang));
$prodTest = olc_db_num_rows(olc_db_query("SELECT 1 " . $from_str . $where_str . " LIMIT 1"));
if ($prodTest) {
if (!isset($_GET["searchTagCloud"])) {
if ($tagTest["count"]) {
olc_db_query("UPDATE module_tag_cloud " . "SET searches = searches + 1, not_found = 0 " . "WHERE tag = '" . $cloudTag . "' AND language_id = " . $cloudLang);
} else {
$cloudInfos = olc_db_fetch_array(olc_db_query("SELECT AVG(searches + offset) AS offset " . "FROM module_tag_cloud " . "WHERE language_id = " . $cloudLang));
$minSearches = (int) MODULE_TAG_CLOUD_MIN_SEARCHES;
if ($minSearches < 1) {
$minSearches = 1;
}
olc_db_query("INSERT INTO module_tag_cloud " . "SET " . "tag = '" . $cloudTag . "'," . (isset($cloudInfos["offset"]) ? "offset = " . round($cloudInfos["offset"] - 1) . "," : "") . "language_id = " . $cloudLang . "," . "inserted = NOW()");
$deleteQuery = olc_db_query("SELECT tag " . "FROM module_tag_cloud " . "WHERE language_id = " . $cloudLang . " " . "ORDER BY searches + offset DESC, inserted DESC " . "LIMIT " . (int) MODULE_TAG_CLOUD_MAX_TAGS . ", 1000");
while ($delTag = olc_db_fetch_array($deleteQuery)) {
olc_db_query("DELETE FROM module_tag_cloud " . "WHERE tag = '" . addslashes($delTag["tag"]) . "' AND language_id = " . $cloudLang);
}
</td>
<td class="dataTableContent"><?php
if (eregi('^(.*)' . olc_session_name() . '=[a-f,0-9]+[&]*(.*)', $whos_online['last_page_url'], $array)) {
echo $array[1] . $array[2];
} else {
echo $whos_online['last_page_url'];
}
?>
</td>
</tr>
<?php
}
?>
<tr>
<td class="smallText" colspan="7"><?php
echo sprintf(TEXT_NUMBER_OF_CUSTOMERS, olc_db_num_rows($whos_online_query));
?>
</td>
</tr>
</table></td>
<?php
$heading = array();
$contents = array();
if ($info) {
$heading[] = array('text' => HTML_B_START . TABLE_HEADING_SHOPPING_CART . HTML_B_END);
if (STORE_SESSIONS == 'mysql') {
$session_data = olc_db_query("select value from " . TABLE_SESSIONS . " WHERE sesskey = '" . $info . APOS);
$session_data = olc_db_fetch_array($session_data);
$session_data = trim($session_data['value']);
} else {
if (file_exists(olc_session_save_path() . '/sess_' . $info) && filesize(olc_session_save_path() . '/sess_' . $info) > 0) {
function general_db_conct($query_1)
{
$result_1 = olc_db_query($query_1);
$num_of_rows = olc_db_num_rows($result_1);
for ($i = 0; $i < $num_of_rows; $i++) {
$fields = olc_db_fetch_row($result_1);
$a_to_pass[$i] = $fields[$y = 0];
$b_to_pass[$i] = $fields[++$y];
$c_to_pass[$i] = $fields[++$y];
$d_to_pass[$i] = $fields[++$y];
$e_to_pass[$i] = $fields[++$y];
$f_to_pass[$i] = $fields[++$y];
$g_to_pass[$i] = $fields[++$y];
$h_to_pass[$i] = $fields[++$y];
$i_to_pass[$i] = $fields[++$y];
$j_to_pass[$i] = $fields[++$y];
$k_to_pass[$i] = $fields[++$y];
$l_to_pass[$i] = $fields[++$y];
$m_to_pass[$i] = $fields[++$y];
$n_to_pass[$i] = $fields[++$y];
$o_to_pass[$i] = $fields[++$y];
}
return array($a_to_pass, $b_to_pass, $c_to_pass, $d_to_pass, $e_to_pass, $f_to_pass, $g_to_pass, $h_to_pass, $i_to_pass, $j_to_pass, $k_to_pass, $l_to_pass, $m_to_pass, $n_to_pass, $o_to_pass);
}
</td>
</tr>
<?php
}
?>
</table></td>
<?php
$heading = array();
$contents = array();
$coupon_description_query = olc_db_query("select coupon_name from " . TABLE_COUPONS_DESCRIPTION . " where coupon_id = '" . $_GET['cid'] . "' and language_id = '" . SESSION_LANGUAGE_ID . APOS);
$coupon_desc = olc_db_fetch_array($coupon_description_query);
$count_customers = olc_db_query("select * from " . TABLE_COUPON_REDEEM_TRACK . " where coupon_id = '" . $_GET['cid'] . "' and customer_id = '" . $cInfo->customer_id . APOS);
$heading[] = array('text' => '<b>[' . $_GET['cid'] . ']' . COUPON_NAME . BLANK . $coupon_desc['coupon_name'] . HTML_B_END);
$contents[] = array('text' => HTML_B_START . TEXT_REDEMPTIONS . HTML_B_END);
$contents[] = array('text' => TEXT_REDEMPTIONS_TOTAL . '=' . olc_db_num_rows($cc_query));
$contents[] = array('text' => TEXT_REDEMPTIONS_CUSTOMER . '=' . olc_db_num_rows($count_customers));
$contents[] = array('text' => '');
?>
<td width="25%" valign="top">
<?php
$box = new box();
echo $box->infoBox($heading, $contents);
echo ' </td>' . NEW_LINE;
break;
case 'preview_email':
$coupon_query = olc_db_query("select coupon_code from " . TABLE_COUPONS . " where coupon_id = '" . $_GET['cid'] . APOS);
$coupon_result = olc_db_fetch_array($coupon_query);
$coupon_name_query = olc_db_query("select coupon_name from " . TABLE_COUPONS_DESCRIPTION . " where coupon_id = '" . $_GET['cid'] . "' and language_id = '" . SESSION_LANGUAGE_ID . APOS);
$coupon_name = olc_db_fetch_array($coupon_name_query);
switch ($_POST['customers_email_address']) {
case '***':
