Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

PWA !!! mmm.....HELP


doodah

Recommended Posts

  • Replies 52
  • Created
  • Last Reply

Top Posters In This Topic

sorry to go on and on about this but if i delete the continue button on the checkout_success.php page will it effect anything i can't see why or how but you never know...........

 

Cheers peeps :thumbsup:

 

DooDah

Edited by doodah
Link to comment
Share on other sites

sorry to go on and on about this but if i delete the continue button on the checkout_success.php page will it effect anything i can't see why or how but you never know...........

 

Cheers peeps  :thumbsup:

 

DooDah

 

normally, the continue button redirects back to the success page with an "update command". that is for notifications and also PWA uses that. then in the top of success another redirect takes place to the index with or without notification updates.

 

if you remove the button, notification updates do not occur and pwa will not destroy the session and as such the pwa customer remains logged on.

 

what is your current code now? I mean the code before the :

 

<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">

Treasurer MFC

Link to comment
Share on other sites

This is what i got......

 

 

<?php
/*
 $Id: checkout_success.php,v 1.49 2003/06/09 23:03:53 hpdl Exp $

 osCommerce, Open Source E-Commerce Solutions
 http://www.oscommerce.com

 Copyright (c) 2003 osCommerce

 Released under the GNU General Public License
*/

 require('includes/application_top.php');

// if the customer is not logged on, redirect them to the shopping cart page
 if (!tep_session_is_registered('customer_id')) {
   tep_redirect(tep_href_link(FILENAME_SHOPPING_CART));
 }

 if (isset($HTTP_GET_VARS['action']) && ($HTTP_GET_VARS['action'] == 'update')) {
   $notify_string = 'action=notify&';
   $notify = $HTTP_POST_VARS['notify'];
   if (!is_array($notify)) $notify = array($notify);
   for ($i=0, $n=sizeof($notify); $i<$n; $i++) {
     $notify_string .= 'notify[]=' . $notify[$i] . '&';
   }
   if (strlen($notify_string) > 0) $notify_string = substr($notify_string, 0, -1);

//    tep_redirect(tep_href_link(FILENAME_DEFAULT, $notify_string));
// Added a check for a Guest checkout and cleared the session - 030411 
if (tep_session_is_registered('noaccount')) { 
tep_session_destroy(); 
tep_redirect(tep_href_link(FILENAME_DEFAULT, '', 'NONSSL')); 
} 
else { 
tep_redirect(tep_href_link(FILENAME_DEFAULT, $notify_string, 'SSL')); 
}
 }

 require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_CHECKOUT_SUCCESS);


 $breadcrumb->add(NAVBAR_TITLE_1);

 $global_query = tep_db_query("select global_product_notifications from " . TABLE_CUSTOMERS_INFO . " where customers_info_id = '" . (int)$customer_id . "'");
 $global = tep_db_fetch_array($global_query);

 if ($global['global_product_notifications'] != '1') {
   $orders_query = tep_db_query("select orders_id from " . TABLE_ORDERS . " where customers_id = '" . (int)$customer_id . "' order by date_purchased desc limit 1");
   $orders = tep_db_fetch_array($orders_query);

   $products_array = array();
   $products_query = tep_db_query("select products_id, products_name from " . TABLE_ORDERS_PRODUCTS . " where orders_id = '" . (int)$orders['orders_id'] . "' order by products_name");
   while ($products = tep_db_fetch_array($products_query)) {
     $products_array[] = array('id' => $products['products_id'],
                               'text' => $products['products_name']);
   }
 }
 
// PWA:  Added a check for a Guest checkout and cleared the session - 030411 v0.71
if (tep_session_is_registered('noaccount')) {
$order_update = array('purchased_without_account' => '1');
tep_db_perform(TABLE_ORDERS, $order_update, 'update', "orders_id = '".$orders['orders_id']."'");
//  tep_db_query("insert into " . TABLE_ORDERS . " (purchased_without_account) values ('1') where orders_id = '" . (int)$orders['orders_id'] . "'");
tep_db_query("delete from " . TABLE_ADDRESS_BOOK . " where customers_id = '" . tep_db_input($customer_id) . "'");
tep_db_query("delete from " . TABLE_CUSTOMERS . " where customers_id = '" . tep_db_input($customer_id) . "'");
tep_db_query("delete from " . TABLE_CUSTOMERS_INFO . " where customers_info_id = '" . tep_db_input($customer_id) . "'");
tep_db_query("delete from " . TABLE_CUSTOMERS_BASKET . " where customers_id = '" . tep_db_input($customer_id) . "'");
tep_db_query("delete from " . TABLE_CUSTOMERS_BASKET_ATTRIBUTES . " where customers_id = '" . tep_db_input($customer_id) . "'");
tep_db_query("delete from " . TABLE_WHOS_ONLINE . " where customer_id = '" . tep_db_input($customer_id) . "'");
tep_session_destroy();
}

?>
<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">

 

thx :blush:

Link to comment
Share on other sites

This is what i got......

<?php
/*
?$Id: checkout_success.php,v 1.49 2003/06/09 23:03:53 hpdl Exp $

?osCommerce, Open Source E-Commerce Solutions
?http://www.oscommerce.com

?Copyright (c) 2003 osCommerce

?Released under the GNU General Public License
*/

?require('includes/application_top.php');

// if the customer is not logged on, redirect them to the shopping cart page
?if (!tep_session_is_registered('customer_id')) {
? ?tep_redirect(tep_href_link(FILENAME_SHOPPING_CART));
?}

?if (isset($HTTP_GET_VARS['action']) && ($HTTP_GET_VARS['action'] == 'update')) {
? ?$notify_string = 'action=notify&';
? ?$notify = $HTTP_POST_VARS['notify'];
? ?if (!is_array($notify)) $notify = array($notify);
? ?for ($i=0, $n=sizeof($notify); $i<$n; $i++) {
? ? ?$notify_string .= 'notify[]=' . $notify[$i] . '&';
? ?}
? ?if (strlen($notify_string) > 0) $notify_string = substr($notify_string, 0, -1);

// ? ?tep_redirect(tep_href_link(FILENAME_DEFAULT, $notify_string));
// Added a check for a Guest checkout and cleared the session - 030411 
if (tep_session_is_registered('noaccount')) { 
tep_session_destroy(); 
tep_redirect(tep_href_link(FILENAME_DEFAULT, '', 'NONSSL')); 
} 
else { 
tep_redirect(tep_href_link(FILENAME_DEFAULT, $notify_string, 'SSL')); 
}
?}

?require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_CHECKOUT_SUCCESS);
?$breadcrumb->add(NAVBAR_TITLE_1);

?$global_query = tep_db_query("select global_product_notifications from " . TABLE_CUSTOMERS_INFO . " where customers_info_id = '" . (int)$customer_id . "'");
?$global = tep_db_fetch_array($global_query);

?if ($global['global_product_notifications'] != '1') {
? ?$orders_query = tep_db_query("select orders_id from " . TABLE_ORDERS . " where customers_id = '" . (int)$customer_id . "' order by date_purchased desc limit 1");
? ?$orders = tep_db_fetch_array($orders_query);

? ?$products_array = array();
? ?$products_query = tep_db_query("select products_id, products_name from " . TABLE_ORDERS_PRODUCTS . " where orders_id = '" . (int)$orders['orders_id'] . "' order by products_name");
? ?while ($products = tep_db_fetch_array($products_query)) {
? ? ?$products_array[] = array('id' => $products['products_id'],
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'text' => $products['products_name']);
? ?}
?}
?
// PWA: ?Added a check for a Guest checkout and cleared the session - 030411 v0.71
if (tep_session_is_registered('noaccount')) {
$order_update = array('purchased_without_account' => '1');
tep_db_perform(TABLE_ORDERS, $order_update, 'update', "orders_id = '".$orders['orders_id']."'");
// ?tep_db_query("insert into " . TABLE_ORDERS . " (purchased_without_account) values ('1') where orders_id = '" . (int)$orders['orders_id'] . "'");
tep_db_query("delete from " . TABLE_ADDRESS_BOOK . " where customers_id = '" . tep_db_input($customer_id) . "'");
tep_db_query("delete from " . TABLE_CUSTOMERS . " where customers_id = '" . tep_db_input($customer_id) . "'");
tep_db_query("delete from " . TABLE_CUSTOMERS_INFO . " where customers_info_id = '" . tep_db_input($customer_id) . "'");
tep_db_query("delete from " . TABLE_CUSTOMERS_BASKET . " where customers_id = '" . tep_db_input($customer_id) . "'");
tep_db_query("delete from " . TABLE_CUSTOMERS_BASKET_ATTRIBUTES . " where customers_id = '" . tep_db_input($customer_id) . "'");
tep_db_query("delete from " . TABLE_WHOS_ONLINE . " where customer_id = '" . tep_db_input($customer_id) . "'");
tep_session_destroy();
}

?>
<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">

 

thx :blush:

 

 

one of the problems I see here is that on first entry of this page when it is a PWA customer, you delete the records and destroy the session.

then when you come back after continue, you check to see if the noaccount is registered. But nothing is registered anymore since the session is gone.

 

 

 

this is my entire code above the <!doctype but I do not use notifications at checkout success anymore.

 

require('includes/application_top.php');

 

if (tep_session_is_registered('noaccount')) {

$pwa = true;

} else {

$pwa = false;

}

 

if (isset($HTTP_GET_VARS['action']) && ($HTTP_GET_VARS['action'] == 'update')) {

tep_redirect(tep_href_link(FILENAME_DEFAULT, '', 'NONSSL'));

} else {

if (!tep_session_is_registered('customer_id')) {

tep_redirect(tep_href_link(FILENAME_LOGIN, '', 'SSL'));

}

}

 

require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_CHECKOUT_SUCCESS);

 

$breadcrumb->add(NAVBAR_TITLE_1);

$breadcrumb->add(NAVBAR_TITLE_2);

 

$orders_query = tep_db_query("select orders_id from " . TABLE_ORDERS . " where customers_id = '" . (int)$customer_id . "' order by date_purchased desc limit 1");

$orders = tep_db_fetch_array($orders_query);

 

 

// PWA: Added a check for a Guest checkout and cleared the session - 030411 v0.71

if (tep_session_is_registered('noaccount')) {

$orders_ip = $browser_ip;

$order_update = array('purchased_without_account' => '1', 'orders_ip' => $orders_ip);

tep_db_perform(TABLE_ORDERS, $order_update, 'update', "orders_id = '".$orders['orders_id']."'");

tep_db_query("delete from " . TABLE_ADDRESS_BOOK . " where customers_id = '" . tep_db_input($customer_id) . "'");

tep_db_query("delete from " . TABLE_CUSTOMERS . " where customers_id = '" . tep_db_input($customer_id) . "'");

tep_db_query("delete from " . TABLE_CUSTOMERS_INFO . " where customers_info_id = '" . tep_db_input($customer_id) . "'");

tep_db_query("delete from " . TABLE_CUSTOMERS_BASKET . " where customers_id = '" . tep_db_input($customer_id) . "'");

tep_db_query("delete from " . TABLE_CUSTOMERS_BASKET_ATTRIBUTES . " where customers_id = '" . tep_db_input($customer_id) . "'");

tep_session_unregister('no_account');

tep_session_unregister('customer_id');

}

 

?>

Treasurer MFC

Link to comment
Share on other sites

cool i'll give it a whirl will post feedback soon and tell you if i can get it to work....

 

thx again :P

 

 

ok but if you use this :

 

$orders_ip = $browser_ip;

$order_update = array('purchased_without_account' => '1', 'orders_ip' => $orders_ip);

 

you have to create a field orders_ip in your orders database table.

 

otherwise use :

 

$order_update = array('purchased_without_account' => '1');

Treasurer MFC

Link to comment
Share on other sites

i trie d it and this is the error i got back

 

1054 - Unknown column 'orders_ip' in 'field list'

 

update orders set purchased_without_account = '1', orders_ip = '' where orders_id = '18'

 

[TEP STOP]

 

any ideas will try again to make sur it wasn't human error....... :huh:

Edited by doodah
Link to comment
Share on other sites

right have changed and now i've gone back to the origanal error

 

HTTP 404 - File not found

Internet Explorer

 

i'm confused ever so much .........

 

why doe sit work for you and not for me?

 

i gotta to sort this out cause i need to destroy the session at the end, also i've realised it's possible to edit the account whilst they are going throgh the purchase is there a way of disabling this?

 

cheers :'(

Link to comment
Share on other sites

:blink: PLEASE SOMEBODY MUST KNOW.........

 

if you have had this problem or are suffering like me post something up all help is welcome on this one its stumped me.......

 

DooDah :huh:

 

 

well, obviously it goes wrong here :

 

if (isset($HTTP_GET_VARS['action']) && ($HTTP_GET_VARS['action'] == 'update')) {

tep_redirect(tep_href_link(FILENAME_DEFAULT, '', 'NONSSL'));

} else {

if (!tep_session_is_registered('customer_id')) {

tep_redirect(tep_href_link(FILENAME_LOGIN, '', 'SSL'));

}

}

 

 

so when it redirects to FILENAME_DEFAULT, you get a 404.

 

what if you put in there 'index.php' like :

 

if (isset($HTTP_GET_VARS['action']) && ($HTTP_GET_VARS['action'] == 'update')) {

tep_redirect(tep_href_link('index.php', '', 'NONSSL'));

} else {

if (!tep_session_is_registered('customer_id')) {

tep_redirect(tep_href_link(FILENAME_LOGIN, '', 'SSL'));

}

}

Treasurer MFC

Link to comment
Share on other sites

Warning: Cannot modify header information - headers already sent by (output started at /home/wwwwnye/public_html/shoppingcart/includes/languages/english.php:336) in /home/wwwwnye/public_html/shoppingcart/includes/functions/general.php on line 29

 

I got the above error when I either added an item to cart (sometimes) or when I checked out.

 

Go to www.wnyelectronics.com/shoppingcart

 

Please tell me what I can do? What is wrong? what must I change?

Link to comment
Share on other sites

I got the above error when I either added an item to cart (sometimes) or when I checked out.

 

Go to www.wnyelectronics.com/shoppingcart

 

Please tell me what I can do? What is wrong? what must I change?

 

In addition to the above message the code for those 2 files are below

 

general.php is first

 

<?php

/*

 $Id: general.php,v 1.2 2004/07/29 08:34:05 jim Exp $

 

 osCommerce, Open Source E-Commerce Solutions

 http://www.oscommerce.com

 

 Copyright (c) 2003 osCommerce

 

 Released under the GNU General Public License

*/

 

////

// Stop from parsing any further PHP code

 function tep_exit() {

  tep_session_close();

  exit();

 }

 

////

// Redirect to another page or site

 function tep_redirect($url) {

   if ( (ENABLE_SSL == true) && (getenv('HTTPS') == 'on') ) { // We are loading an SSL page

     if (substr($url, 0, strlen(HTTP_SERVER)) == HTTP_SERVER) { // NONSSL url

       $url = HTTPS_SERVER . substr($url, strlen(HTTP_SERVER)); // Change it to SSL

     }

   }

 

   header('Location: ' . $url);

 

   tep_exit();

 }

 

////

// Parse the data used in the html tags to ensure the tags will not break

 function tep_parse_input_field_data($data, $parse) {

   return strtr(trim($data), $parse);

 }

 

 function tep_output_string($string, $translate = false, $protected = false) {

   if ($protected == true) {

     return htmlspecialchars($string);

   } else {

     if ($translate == false) {

       return tep_parse_input_field_data($string, array('"' => '"'));

     } else {

       return tep_parse_input_field_data($string, $translate);

     }

   }

 }

 

 function tep_output_string_protected($string) {

   return tep_output_string($string, false, true);

 }

 

 function tep_sanitize_string($string) {

   $string = ereg_replace(' +', ' ', trim($string));

 

   return preg_replace("/[<>]/", '_', $string);

 }

 

////

// Return a random row from a database query

 function tep_random_select($query) {

   $random_product = '';

   $random_query = tep_db_query($query);

   $num_rows = tep_db_num_rows($random_query);

   if ($num_rows > 0) {

     $random_row = tep_rand(0, ($num_rows - 1));

     tep_db_data_seek($random_query, $random_row);

     $random_product = tep_db_fetch_array($random_query);

   }

 

   return $random_product;

 }

 

////

// Return a product's name

// TABLES: products

 function tep_get_products_name($product_id, $language = '') {

   global $languages_id;

 

   if (empty($language)) $language = $languages_id;

 

   $product_query = tep_db_query("select products_name from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . (int)$product_id . "' and language_id = '" . (int)$language . "'");

   $product = tep_db_fetch_array($product_query);

 

   return $product['products_name'];

 }

 

////

// Return a product's special price (returns nothing if there is no offer)

// TABLES: products

 function tep_get_products_special_price($product_id) {

   $product_query = tep_db_query("select specials_new_products_price from " . TABLE_SPECIALS . " where products_id = '" . (int)$product_id . "' and status");

   $product = tep_db_fetch_array($product_query);

 

   return $product['specials_new_products_price'];

 }

 

////

// Return a product's stock

// TABLES: products

 function tep_get_products_stock($products_id) {

   $products_id = tep_get_prid($products_id);

   $stock_query = tep_db_query("select products_quantity from " . TABLE_PRODUCTS . " where products_id = '" . (int)$products_id . "'");

   $stock_values = tep_db_fetch_array($stock_query);

 

   return $stock_values['products_quantity'];

 }

 

////

// Check if the required stock is available

// If insufficent stock is available return an out of stock message

 function tep_check_stock($products_id, $products_quantity) {

   $stock_left = tep_get_products_stock($products_id) - $products_quantity;

   $out_of_stock = '';

 

   if ($stock_left < 0) {

     $out_of_stock = '<span class="markProductOutOfStock">' . STOCK_MARK_PRODUCT_OUT_OF_STOCK . '</span>';

   }

 

   return $out_of_stock;

 }

 

////

// Break a word in a string if it is longer than a specified length ($len)

 function tep_break_string($string, $len, $break_char = '-') {

   $l = 0;

   $output = '';

   for ($i=0, $n=strlen($string); $i<$n; $i++) {

     $char = substr($string, $i, 1);

     if ($char != ' ') {

       $l++;

     } else {

       $l = 0;

     }

     if ($l > $len) {

       $l = 1;

       $output .= $break_char;

     }

     $output .= $char;

   }

 

   return $output;

 }

 

////

// Return all HTTP GET variables, except those passed as a parameter

 function tep_get_all_get_params($exclude_array = '') {

   global $HTTP_GET_VARS;

 

   if (!is_array($exclude_array)) $exclude_array = array();

 

   $get_url = '';

   if (is_array($HTTP_GET_VARS) && (sizeof($HTTP_GET_VARS) > 0)) {

     reset($HTTP_GET_VARS);

     while (list($key, $value) = each($HTTP_GET_VARS)) {

       if ( (strlen($value) > 0) && ($key != tep_session_name()) && ($key != 'error') && (!in_array($key, $exclude_array)) && ($key != 'x') && ($key != 'y') ) {

         $get_url .= $key . '=' . rawurlencode(stripslashes($value)) . '&';

       }

     }

   }

 

   return $get_url;

 }

 

////

// Returns an array with countries

// TABLES: countries

 function tep_get_countries($countries_id = '', $with_iso_codes = false) {

   $countries_array = array();

   if (tep_not_null($countries_id)) {

     if ($with_iso_codes == true) {

       $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_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 {

     $countries = tep_db_query("select countries_id, countries_name from " . TABLE_COUNTRIES . " 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;

 }

 

////

// Alias function to tep_get_countries, which also returns the countries iso codes

 function tep_get_countries_with_iso_codes($countries_id) {

   return tep_get_countries($countries_id, true);

 }

 

////

// Generate a path to categories

 function tep_get_path($current_category_id = '') {

   global $cPath_array;

 

   if (tep_not_null($current_category_id)) {

     $cp_size = sizeof($cPath_array);

     if ($cp_size == 0) {

       $cPath_new = $current_category_id;

     } else {

       $cPath_new = '';

       $last_category_query = tep_db_query("select parent_id from " . TABLE_CATEGORIES . " where categories_id = '" . (int)$cPath_array[($cp_size-1)] . "'");

       $last_category = tep_db_fetch_array($last_category_query);

 

       $current_category_query = tep_db_query("select parent_id from " . TABLE_CATEGORIES . " where categories_id = '" . (int)$current_category_id . "'");

       $current_category = tep_db_fetch_array($current_category_query);

 

       if ($last_category['parent_id'] == $current_category['parent_id']) {

         for ($i=0; $i<($cp_size-1); $i++) {

           $cPath_new .= '_' . $cPath_array[$i];

         }

       } else {

         for ($i=0; $i<$cp_size; $i++) {

           $cPath_new .= '_' . $cPath_array[$i];

         }

       }

       $cPath_new .= '_' . $current_category_id;

 

       if (substr($cPath_new, 0, 1) == '_') {

         $cPath_new = substr($cPath_new, 1);

       }

     }

   } else {

     $cPath_new = implode('_', $cPath_array);

   }

 

   return 'cPath=' . $cPath_new;

 }

 

////

// Returns the clients browser

 function tep_browser_detect($component) {

   global $HTTP_USER_AGENT;

 

   return stristr($HTTP_USER_AGENT, $component);

 }

 

////

// Alias function to tep_get_countries()

 function tep_get_country_name($country_id) {

   $country_array = tep_get_countries($country_id);

 

   return $country_array['countries_name'];

 }

 

////

// Returns the zone (State/Province) name

// TABLES: zones

 function tep_get_zone_name($country_id, $zone_id, $default_zone) {

   $zone_query = tep_db_query("select zone_name from " . TABLE_ZONES . " where zone_country_id = '" . (int)$country_id . "' and zone_id = '" . (int)$zone_id . "'");

   if (tep_db_num_rows($zone_query)) {

     $zone = tep_db_fetch_array($zone_query);

     return $zone['zone_name'];

   } else {

     return $default_zone;

   }

 }

 

////

// Returns the zone (State/Province) code

// TABLES: zones

 function tep_get_zone_code($country_id, $zone_id, $default_zone) {

   $zone_query = tep_db_query("select zone_code from " . TABLE_ZONES . " where zone_country_id = '" . (int)$country_id . "' and zone_id = '" . (int)$zone_id . "'");

   if (tep_db_num_rows($zone_query)) {

     $zone = tep_db_fetch_array($zone_query);

     return $zone['zone_code'];

   } else {

     return $default_zone;

   }

 }

 

////

// Wrapper function for round()

 function tep_round($number, $precision) {

   if (strpos($number, '.') && (strlen(substr($number, strpos($number, '.')+1)) > $precision)) {

     $number = substr($number, 0, strpos($number, '.') + 1 + $precision + 1);

 

     if (substr($number, -1) >= 5) {

       if ($precision > 1) {

         $number = substr($number, 0, -1) + ('0.' . str_repeat(0, $precision-1) . '1');

       } elseif ($precision == 1) {

         $number = substr($number, 0, -1) + 0.1;

       } else {

         $number = substr($number, 0, -1) + 1;

       }

     } else {

       $number = substr($number, 0, -1);

     }

   }

 

   return $number;

 }

 

////

// Returns the tax rate for a zone / class

// TABLES: tax_rates, zones_to_geo_zones

 function tep_get_tax_rate($class_id, $country_id = -1, $zone_id = -1) {

   global $customer_zone_id, $customer_country_id;

 

   if ( ($country_id == -1) && ($zone_id == -1) ) {

     if (!tep_session_is_registered('customer_id')) {

       $country_id = STORE_COUNTRY;

       $zone_id = STORE_ZONE;

     } else {

       $country_id = $customer_country_id;

       $zone_id = $customer_zone_id;

     }

   }

 

   $tax_query = tep_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 = '" . (int)$country_id . "') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '" . (int)$zone_id . "') and tr.tax_class_id = '" . (int)$class_id . "' group by tr.tax_priority");

   if (tep_db_num_rows($tax_query)) {

     $tax_multiplier = 1.0;

     while ($tax = tep_db_fetch_array($tax_query)) {

       $tax_multiplier *= 1.0 + ($tax['tax_rate'] / 100);

     }

     return ($tax_multiplier - 1.0) * 100;

   } else {

     return 0;

   }

 }

 

////

// Return the tax description for a zone / class

// TABLES: tax_rates;

 function tep_get_tax_description($class_id, $country_id, $zone_id) {

   $tax_query = tep_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 = '" . (int)$country_id . "') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '" . (int)$zone_id . "') and tr.tax_class_id = '" . (int)$class_id . "' order by tr.tax_priority");

   if (tep_db_num_rows($tax_query)) {

     $tax_description = '';

     while ($tax = tep_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;

   }

 }

 

////

// Add tax to a products price

 function tep_add_tax($price, $tax) {

   global $currencies;

 

   if ( (DISPLAY_PRICE_WITH_TAX == 'true') && ($tax > 0) ) {

     return tep_round($price, $currencies->currencies[DEFAULT_CURRENCY]['decimal_places']) + tep_calculate_tax($price, $tax);

   } else {

     return tep_round($price, $currencies->currencies[DEFAULT_CURRENCY]['decimal_places']);

   }

 }

 

// Calculates Tax rounding the result

 function tep_calculate_tax($price, $tax) {

   global $currencies;

 

   return tep_round($price * $tax / 100, $currencies->currencies[DEFAULT_CURRENCY]['decimal_places']);

 }

 

////

// Return the number of products in a category

// TABLES: products, products_to_categories, categories

 function tep_count_products_in_category($category_id, $include_inactive = false) {

   $products_count = 0;

   if ($include_inactive == true) {

     $products_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_id = p2c.products_id and p2c.categories_id = '" . (int)$category_id . "'");

   } else {

     $products_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '" . (int)$category_id . "'");

   }

   $products = tep_db_fetch_array($products_query);

   $products_count += $products['total'];

 

   $child_categories_query = tep_db_query("select categories_id from " . TABLE_CATEGORIES . " where parent_id = '" . (int)$category_id . "'");

   if (tep_db_num_rows($child_categories_query)) {

     while ($child_categories = tep_db_fetch_array($child_categories_query)) {

       $products_count += tep_count_products_in_category($child_categories['categories_id'], $include_inactive);

     }

   }

 

   return $products_count;

 }

 

////

// Return true if the category has subcategories

// TABLES: categories

 function tep_has_category_subcategories($category_id) {

   $child_category_query = tep_db_query("select count(*) as count from " . TABLE_CATEGORIES . " where parent_id = '" . (int)$category_id . "'");

   $child_category = tep_db_fetch_array($child_category_query);

 

   if ($child_category['count'] > 0) {

     return true;

   } else {

     return false;

   }

 }

 

////

// Returns the address_format_id for the given country

// TABLES: countries;

 function tep_get_address_format_id($country_id) {

   $address_format_query = tep_db_query("select address_format_id as format_id from " . TABLE_COUNTRIES . " where countries_id = '" . (int)$country_id . "'");

   if (tep_db_num_rows($address_format_query)) {

     $address_format = tep_db_fetch_array($address_format_query);

     return $address_format['format_id'];

   } else {

     return '1';

   }

 }

 

////

// Return a formatted address

// TABLES: address_format

 function tep_address_format($address_format_id, $address, $html, $boln, $eoln) {

   $address_format_query = tep_db_query("select address_format as format from " . TABLE_ADDRESS_FORMAT . " where address_format_id = '" . (int)$address_format_id . "'");

   $address_format = tep_db_fetch_array($address_format_query);

 

   $company = tep_output_string_protected($address['company']);

   if (isset($address['firstname']) && tep_not_null($address['firstname'])) {

     $firstname = tep_output_string_protected($address['firstname']);

     $lastname = tep_output_string_protected($address['lastname']);

   } elseif (isset($address['name']) && tep_not_null($address['name'])) {

     $firstname = tep_output_string_protected($address['name']);

     $lastname = '';

   } else {

     $firstname = '';

     $lastname = '';

   }

   $street = tep_output_string_protected($address['street_address']);

   $suburb = tep_output_string_protected($address['suburb']);

   $city = tep_output_string_protected($address['city']);

   $state = tep_output_string_protected($address['state']);

   if (isset($address['country_id']) && tep_not_null($address['country_id'])) {

     $country = tep_get_country_name($address['country_id']);

 

     if (isset($address['zone_id']) && tep_not_null($address['zone_id'])) {

       $state = tep_get_zone_code($address['country_id'], $address['zone_id'], $state);

     }

   } elseif (isset($address['country']) && tep_not_null($address['country'])) {

     $country = tep_output_string_protected($address['country']);

   } else {

     $country = '';

   }

   $postcode = tep_output_string_protected($address['postcode']);

   $zip = $postcode;

 

   if ($html) {

// HTML Mode

     $HR = '<hr>';

     $hr = '<hr>';

     if ( ($boln == '') && ($eoln == "\n") ) { // Values not specified, use rational defaults

       $CR = '<br>';

       $cr = '<br>';

       $eoln = $cr;

     } else { // Use values supplied

       $CR = $eoln . $boln;

       $cr = $CR;

     }

   } else {

// Text Mode

     $CR = $eoln;

     $cr = $CR;

     $HR = '----------------------------------------';

     $hr = '----------------------------------------';

   }

 

   $statecomma = '';

   $streets = $street;

   if ($suburb != '') $streets = $street . $cr . $suburb;

   if ($country == '') $country = tep_output_string_protected($address['country']);

   if ($state != '') $statecomma = $state . ', ';

 

   $fmt = $address_format['format'];

   eval("\$address = \"$fmt\";");

 

   if ( (ACCOUNT_COMPANY == 'true') && (tep_not_null($company)) ) {

     $address = $company . $cr . $address;

   }

 

   return $address;

 }

 

////

// Return a formatted address

// TABLES: customers, address_book

 function tep_address_label($customers_id, $address_id = 1, $html = false, $boln = '', $eoln = "\n") {

   $address_query = tep_db_query("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 " . TABLE_ADDRESS_BOOK . " where customers_id = '" . (int)$customers_id . "' and address_book_id = '" . (int)$address_id . "'");

   $address = tep_db_fetch_array($address_query);

 

   $format_id = tep_get_address_format_id($address['country_id']);

 

   return tep_address_format($format_id, $address, $html, $boln, $eoln);

 }

 

 function tep_row_number_format($number) {

   if ( ($number < 10) && (substr($number, 0, 1) != '0') ) $number = '0' . $number;

 

   return $number;

 }

 

 function tep_get_categories($categories_array = '', $parent_id = '0', $indent = '') {

   global $languages_id;

 

   if (!is_array($categories_array)) $categories_array = array();

 

   $categories_query = tep_db_query("select c.categories_id, cd.categories_name from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where parent_id = '" . (int)$parent_id . "' and c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "' order by sort_order, cd.categories_name");

   while ($categories = tep_db_fetch_array($categories_query)) {

     $categories_array[] = array('id' => $categories['categories_id'],

                                 'text' => $indent . $categories['categories_name']);

 

     if ($categories['categories_id'] != $parent_id) {

       $categories_array = tep_get_categories($categories_array, $categories['categories_id'], $indent . '  ');

     }

   }

 

   return $categories_array;

 }

 

 function tep_get_manufacturers($manufacturers_array = '') {

   if (!is_array($manufacturers_array)) $manufacturers_array = array();

 

   $manufacturers_query = tep_db_query("select manufacturers_id, manufacturers_name from " . TABLE_MANUFACTURERS . " order by manufacturers_name");

   while ($manufacturers = tep_db_fetch_array($manufacturers_query)) {

     $manufacturers_array[] = array('id' => $manufacturers['manufacturers_id'], 'text' => $manufacturers['manufacturers_name']);

   }

 

   return $manufacturers_array;

 }

 

////

// Return all subcategory IDs

// TABLES: categories

 function tep_get_subcategories(&$subcategories_array, $parent_id = 0) {

   $subcategories_query = tep_db_query("select categories_id from " . TABLE_CATEGORIES . " where parent_id = '" . (int)$parent_id . "'");

   while ($subcategories = tep_db_fetch_array($subcategories_query)) {

     $subcategories_array[sizeof($subcategories_array)] = $subcategories['categories_id'];

     if ($subcategories['categories_id'] != $parent_id) {

       tep_get_subcategories($subcategories_array, $subcategories['categories_id']);

     }

   }

 }

 

// Output a raw date string in the selected locale date format

// $raw_date needs to be in this format: YYYY-MM-DD HH:MM:SS

 function tep_date_long($raw_date) {

   if ( ($raw_date == '0000-00-00 00:00:00') || ($raw_date == '') ) return false;

 

   $year = (int)substr($raw_date, 0, 4);

   $month = (int)substr($raw_date, 5, 2);

   $day = (int)substr($raw_date, 8, 2);

   $hour = (int)substr($raw_date, 11, 2);

   $minute = (int)substr($raw_date, 14, 2);

   $second = (int)substr($raw_date, 17, 2);

 

   return strftime(DATE_FORMAT_LONG, mktime($hour,$minute,$second,$month,$day,$year));

 }

 

////

// Output a raw date string in the selected locale date format

// $raw_date needs to be in this format: YYYY-MM-DD HH:MM:SS

// NOTE: Includes a workaround for dates before 01/01/1970 that fail on windows servers

 function tep_date_short($raw_date) {

   if ( ($raw_date == '0000-00-00 00:00:00') || empty($raw_date) ) return false;

 

   $year = substr($raw_date, 0, 4);

   $month = (int)substr($raw_date, 5, 2);

   $day = (int)substr($raw_date, 8, 2);

   $hour = (int)substr($raw_date, 11, 2);

   $minute = (int)substr($raw_date, 14, 2);

   $second = (int)substr($raw_date, 17, 2);

 

   if (@date('Y', mktime($hour, $minute, $second, $month, $day, $year)) == $year) {

     return date(DATE_FORMAT, mktime($hour, $minute, $second, $month, $day, $year));

   } else {

     return ereg_replace('2037' . '$', $year, date(DATE_FORMAT, mktime($hour, $minute, $second, $month, $day, 2037)));

   }

 }

 

////

// Parse search string into indivual objects

 function tep_parse_search_string($search_str = '', &$objects) {

   $search_str = trim(strtolower($search_str));

 

// Break up $search_str on whitespace; quoted string will be reconstructed later

   $pieces = split('[[:space:]]+', $search_str);

   $objects = array();

   $tmpstring = '';

   $flag = '';

 

   for ($k=0; $k<count($pieces); $k++) {

     while (substr($pieces[$k], 0, 1) == '(') {

       $objects[] = '(';

       if (strlen($pieces[$k]) > 1) {

         $pieces[$k] = substr($pieces[$k], 1);

       } else {

         $pieces[$k] = '';

       }

     }

 

     $post_objects = array();

 

     while (substr($pieces[$k], -1) == ')')  {

       $post_objects[] = ')';

       if (strlen($pieces[$k]) > 1) {

         $pieces[$k] = substr($pieces[$k], 0, -1);

       } else {

         $pieces[$k] = '';

       }

     }

 

// Check individual words

 

     if ( (substr($pieces[$k], -1) != '"') && (substr($pieces[$k], 0, 1) != '"') ) {

       $objects[] = trim($pieces[$k]);

 

       for ($j=0; $j<count($post_objects); $j++) {

         $objects[] = $post_objects[$j];

       }

     } else {

/* This means that the $piece is either the beginning or the end of a string.

  So, we'll slurp up the $pieces and stick them together until we get to the

  end of the string or run out of pieces.

*/

 

// Add this word to the $tmpstring, starting the $tmpstring

       $tmpstring = trim(ereg_replace('"', ' ', $pieces[$k]));

 

// Check for one possible exception to the rule. That there is a single quoted word.

       if (substr($pieces[$k], -1 ) == '"') {

// Turn the flag off for future iterations

         $flag = 'off';

 

         $objects[] = trim($pieces[$k]);

 

         for ($j=0; $j<count($post_objects); $j++) {

           $objects[] = $post_objects[$j];

         }

 

         unset($tmpstring);

 

// Stop looking for the end of the string and move onto the next word.

         continue;

       }

 

// Otherwise, turn on the flag to indicate no quotes have been found attached to this word in the string.

       $flag = 'on';

 

// Move on to the next word

       $k++;

 

// Keep reading until the end of the string as long as the $flag is on

 

       while ( ($flag == 'on') && ($k < count($pieces)) ) {

         while (substr($pieces[$k], -1) == ')') {

           $post_objects[] = ')';

           if (strlen($pieces[$k]) > 1) {

             $pieces[$k] = substr($pieces[$k], 0, -1);

           } else {

             $pieces[$k] = '';

           }

         }

 

// If the word doesn't end in double quotes, append it to the $tmpstring.

         if (substr($pieces[$k], -1) != '"') {

// Tack this word onto the current string entity

           $tmpstring .= ' ' . $pieces[$k];

 

// Move on to the next word

           $k++;

           continue;

         } else {

/* If the $piece ends in double quotes, strip the double quotes, tack the

  $piece onto the tail of the string, push the $tmpstring onto the $haves,

  kill the $tmpstring, turn the $flag "off", and return.

*/

           $tmpstring .= ' ' . trim(ereg_replace('"', ' ', $pieces[$k]));

 

// Push the $tmpstring onto the array of stuff to search for

           $objects[] = trim($tmpstring);

 

           for ($j=0; $j<count($post_objects); $j++) {

             $objects[] = $post_objects[$j];

           }

 

           unset($tmpstring);

 

// Turn off the flag to exit the loop

           $flag = 'off';

         }

       }

     }

   }

 

// add default logical operators if needed

   $temp = array();

   for($i=0; $i<(count($objects)-1); $i++) {

     $temp[] = $objects[$i];

     if ( ($objects[$i] != 'and') &&

          ($objects[$i] != 'or') &&

          ($objects[$i] != '(') &&

          ($objects[$i+1] != 'and') &&

          ($objects[$i+1] != 'or') &&

          ($objects[$i+1] != ')') ) {

       $temp[] = ADVANCED_SEARCH_DEFAULT_OPERATOR;

     }

   }

   $temp[] = $objects[$i];

   $objects = $temp;

 

   $keyword_count = 0;

   $operator_count = 0;

   $balance = 0;

   for($i=0; $i<count($objects); $i++) {

     if ($objects[$i] == '(') $balance --;

     if ($objects[$i] == ')') $balance ++;

     if ( ($objects[$i] == 'and') || ($objects[$i] == 'or') ) {

       $operator_count ++;

     } elseif ( ($objects[$i]) && ($objects[$i] != '(') && ($objects[$i] != ')') ) {

       $keyword_count ++;

     }

   }

 

   if ( ($operator_count < $keyword_count) && ($balance == 0) ) {

     return true;

   } else {

     return false;

   }

 }

 

////

// Check date

 function tep_checkdate($date_to_check, $format_string, &$date_array) {

   $separator_idx = -1;

 

   $separators = array('-', ' ', '/', '.');

   $month_abbr = array('jan','feb','mar','apr','may','jun','jul','aug','sep','oct','nov','dec');

   $no_of_days = array(31, 28, 31, 30, 31, 30, 31, 31, 30, 31, 30, 31);

 

   $format_string = strtolower($format_string);

 

   if (strlen($date_to_check) != strlen($format_string)) {

     return false;

   }

 

   $size = sizeof($separators);

   for ($i=0; $i<$size; $i++) {

     $pos_separator = strpos($date_to_check, $separators[$i]);

     if ($pos_separator != false) {

       $date_separator_idx = $i;

       break;

     }

   }

 

   for ($i=0; $i<$size; $i++) {

     $pos_separator = strpos($format_string, $separators[$i]);

     if ($pos_separator != false) {

       $format_separator_idx = $i;

       break;

     }

   }

 

   if ($date_separator_idx != $format_separator_idx) {

     return false;

   }

 

   if ($date_separator_idx != -1) {

     $format_string_array = explode( $separators[$date_separator_idx], $format_string );

     if (sizeof($format_string_array) != 3) {

       return false;

     }

 

     $date_to_check_array = explode( $separators[$date_separator_idx], $date_to_check );

     if (sizeof($date_to_check_array) != 3) {

       return false;

     }

 

     $size = sizeof($format_string_array);

     for ($i=0; $i<$size; $i++) {

       if ($format_string_array[$i] == 'mm' || $format_string_array[$i] == 'mmm') $month = $date_to_check_array[$i];

       if ($format_string_array[$i] == 'dd') $day = $date_to_check_array[$i];

       if ( ($format_string_array[$i] == 'yyyy') || ($format_string_array[$i] == 'aaaa') ) $year = $date_to_check_array[$i];

     }

   } else {

     if (strlen($format_string) == 8 || strlen($format_string) == 9) {

       $pos_month = strpos($format_string, 'mmm');

       if ($pos_month != false) {

         $month = substr( $date_to_check, $pos_month, 3 );

         $size = sizeof($month_abbr);

         for ($i=0; $i<$size; $i++) {

           if ($month == $month_abbr[$i]) {

             $month = $i;

             break;

           }

         }

       } else {

         $month = substr($date_to_check, strpos($format_string, 'mm'), 2);

       }

     } else {

       return false;

     }

 

     $day = substr($date_to_check, strpos($format_string, 'dd'), 2);

     $year = substr($date_to_check, strpos($format_string, 'yyyy'), 4);

   }

 

   if (strlen($year) != 4) {

     return false;

   }

 

   if (!settype($year, 'integer') || !settype($month, 'integer') || !settype($day, 'integer')) {

     return false;

   }

 

   if ($month > 12 || $month < 1) {

     return false;

   }

 

   if ($day < 1) {

     return false;

   }

 

   if (tep_is_leap_year($year)) {

     $no_of_days[1] = 29;

   }

 

   if ($day > $no_of_days[$month - 1]) {

     return false;

   }

 

   $date_array = array($year, $month, $day);

 

   return true;

 }

 

////

// Check if year is a leap year

 function tep_is_leap_year($year) {

   if ($year % 100 == 0) {

     if ($year % 400 == 0) return true;

   } else {

     if (($year % 4) == 0) return true;

   }

 

   return false;

 }

 

////

// Return table heading with sorting capabilities

 function tep_create_sort_heading($sortby, $colnum, $heading) {

   global $PHP_SELF;

 

   $sort_prefix = '';

   $sort_suffix = '';

 

   if ($sortby) {

     $sort_prefix = '<a href="' . tep_href_link(basename($PHP_SELF), tep_get_all_get_params(array('page', 'info', 'sort')) . 'page=1&sort=' . $colnum . ($sortby == $colnum . 'a' ? 'd' : 'a')) . '" title="' . tep_output_string(TEXT_SORT_PRODUCTS . ($sortby == $colnum . 'd' || substr($sortby, 0, 1) != $colnum ? TEXT_ASCENDINGLY : TEXT_DESCENDINGLY) . TEXT_BY . $heading) . '" class="productListing-heading">';

     $sort_suffix = (substr($sortby, 0, 1) == $colnum ? (substr($sortby, 1, 1) == 'a' ? '+' : '-') : '') . '</a>';

   }

 

   return $sort_prefix . $heading . $sort_suffix;

 }

 

////

// Recursively go through the categories and retreive all parent categories IDs

// TABLES: categories

 function tep_get_parent_categories(&$categories, $categories_id) {

   $parent_categories_query = tep_db_query("select parent_id from " . TABLE_CATEGORIES . " where categories_id = '" . (int)$categories_id . "'");

   while ($parent_categories = tep_db_fetch_array($parent_categories_query)) {

     if ($parent_categories['parent_id'] == 0) return true;

     $categories[sizeof($categories)] = $parent_categories['parent_id'];

     if ($parent_categories['parent_id'] != $categories_id) {

       tep_get_parent_categories($categories, $parent_categories['parent_id']);

     }

   }

 }

 

////

// Construct a category path to the product

// TABLES: products_to_categories

 function tep_get_product_path($products_id) {

   $cPath = '';

 

   $category_query = tep_db_query("select p2c.categories_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_id = '" . (int)$products_id . "' and p.products_status = '1' and p.products_id = p2c.products_id limit 1");

   if (tep_db_num_rows($category_query)) {

     $category = tep_db_fetch_array($category_query);

 

     $categories = array();

     tep_get_parent_categories($categories, $category['categories_id']);

 

     $categories = array_reverse($categories);

 

     $cPath = implode('_', $categories);

 

     if (tep_not_null($cPath)) $cPath .= '_';

     $cPath .= $category['categories_id'];

   }

 

   return $cPath;

 }

 

////

// Return a product ID with attributes

 function tep_get_uprid($prid, $params) {

   $uprid = $prid;

   if ( (is_array($params)) && (!strstr($prid, '{')) ) {

     while (list($option, $value) = each($params)) {

       $uprid = $uprid . '{' . $option . '}' . $value;

     }

   }

 

   return $uprid;

 }

 

////

// Return a product ID from a product ID with attributes

 function tep_get_prid($uprid) {

   $pieces = explode('{', $uprid);

 

   return $pieces[0];

 }

 

////

// Return a customer greeting

 function tep_customer_greeting() {

   global $customer_id, $customer_first_name;

 

   if (tep_session_is_registered('customer_first_name') && tep_session_is_registered('customer_id')) {

     $greeting_string = sprintf(TEXT_GREETING_PERSONAL, tep_output_string_protected($customer_first_name), tep_href_link(FILENAME_PRODUCTS_NEW));

   } else {

     $greeting_string = sprintf(TEXT_GREETING_GUEST, tep_href_link(FILENAME_LOGIN, '', 'SSL'), tep_href_link(FILENAME_CREATE_ACCOUNT, '', 'SSL'));

   }

 

   return $greeting_string;

 }

 

////

//! Send email (text/html) using MIME

// This is the central mail function. The SMTP Server should be configured

// correct in php.ini

// Parameters:

// $to_name           The name of the recipient, e.g. "Jan Wildeboer"

// $to_email_address  The eMail address of the recipient,

//                    e.g. [email protected]

// $email_subject     The subject of the eMail

// $email_text        The text of the eMail, may contain HTML entities

// $from_email_name   The name of the sender, e.g. Shop Administration

// $from_email_adress The eMail address of the sender,

//                    e.g. [email protected]

 

 function tep_mail($to_name, $to_email_address, $email_subject, $email_text, $from_email_name, $from_email_address) {

   if (SEND_EMAILS != 'true') return false;

 

   // Instantiate a new mail object

   $message = new email(array('X-Mailer: osCommerce Mailer'));

 

   // Build the text version

   $text = strip_tags($email_text);

   if (EMAIL_USE_HTML == 'true') {

     $message->add_html($email_text, $text);

   } else {

     $message->add_text($text);

   }

 

   // Send message

   $message->build_message();

   $message->send($to_name, $to_email_address, $from_email_name, $from_email_address, $email_subject);

 }

 

////

// Check if product has attributes

 function tep_has_product_attributes($products_id) {

   $attributes_query = tep_db_query("select count(*) as count from " . TABLE_PRODUCTS_ATTRIBUTES . " where products_id = '" . (int)$products_id . "'");

   $attributes = tep_db_fetch_array($attributes_query);

 

   if ($attributes['count'] > 0) {

     return true;

   } else {

     return false;

   }

 }

 

////

// Get the number of times a word/character is present in a string

 function tep_word_count($string, $needle) {

   $temp_array = split($needle, $string);

 

   return sizeof($temp_array);

 }

 

 function tep_count_modules($modules = '') {

   $cou

Link to comment
Share on other sites

I got the above error when I either added an item to cart (sometimes) or when I checked out.

 

Go to www.wnyelectronics.com/shoppingcart

 

Please tell me what I can do? What is wrong? what must I change?

 

 

you have "white space" i.e. spaces after your last ?> in your language file english.php.

 

so open that file, go to the bottom and make sure that ?> is the last text in there. so also remove any blanks (spaces) after the ?>

 

and believe me, you need not post whole code pages unless requested ofcourse, most have the same so we know what it looks like.

Treasurer MFC

Link to comment
Share on other sites

well, obviously it goes wrong here :

 

if (isset($HTTP_GET_VARS['action']) && ($HTTP_GET_VARS['action'] == 'update')) {

tep_redirect(tep_href_link(FILENAME_DEFAULT, '', 'NONSSL'));

} else {

if (!tep_session_is_registered('customer_id')) {

tep_redirect(tep_href_link(FILENAME_LOGIN, '', 'SSL'));

}

}

so when it redirects to FILENAME_DEFAULT, you get a 404.

 

what if you put in there 'index.php' like :

 

if (isset($HTTP_GET_VARS['action']) && ($HTTP_GET_VARS['action'] == 'update')) {

tep_redirect(tep_href_link('index.php', '', 'NONSSL'));

} else {

if (!tep_session_is_registered('customer_id')) {

tep_redirect(tep_href_link(FILENAME_LOGIN, '', 'SSL'));

}

}

 

i tried this it's the same error i don't think it's to do with which page i think theres a problem with the code when it tries to update!

 

:huh: its starting to hurt now :blink:

 

cheers again.....boxtel :thumbsup:

Edited by doodah
Link to comment
Share on other sites

has anyone got a copy of the checkout_success.php page which actually redirects them to there index or whatever just a working copy of the code ?

 

thx

 

 

but you mentioned before that even the original checkout_success did not work.

 

do you have access to the server access logs ?

Treasurer MFC

Link to comment
Share on other sites

but you mentioned before that even the original checkout_success did not work.

 

do you have access to the server access logs ?

 

 

i didn't try the origanal i just went straight for the PWA contribution!!!

 

the version i downloaded could have had errors cause it's never worked maybe a code problem. i have tried redirecting to diff pages but none of them work i just get the 404...........

 

...........i have also tried a couple of different checkout success pages maybe it is a permission/access prob i will check, god i hope it is......... ;)

 

thx

Link to comment
Share on other sites

i didn't try the origanal i just went straight for the PWA contribution!!!

 

the version i downloaded could have had errors cause it's never worked maybe a code problem. i have tried redirecting to diff pages but none of them work i just get the 404...........

 

...........i have also tried a couple of different checkout success pages maybe it is a permission/access prob i will check, god i hope it is......... ;)

 

thx

 

well, try the original first, it was posted earlier.

if that does not work, look at permissions and whether all the required files exist including the include files like languages.

Treasurer MFC

Link to comment
Share on other sites

hello again......

 

the error i'm having is the page i'm directing to isn't found and it's shopping_cart.php and it does exhist where it says it doesn't ???

 

require('includes/application_top.php');

 if (!tep_session_is_registered('customer_id')) {
   tep_redirect(tep_href_link(FILENAME_SHOPPING_CART));
 }

 if (isset($HTTP_GET_VARS['action']) && ($HTTP_GET_VARS['action'] == 'update')) {
   $notify_string = 'action=notify&';
   $notify = $HTTP_POST_VARS['notify'];
   if (!is_array($notify)) $notify = array($notify);
   for ($i=0, $n=sizeof($notify); $i<$n; $i++) {
     $notify_string .= 'notify[]=' . $notify[$i] . '&';
   }
   if (strlen($notify_string) > 0) $notify_string = substr($notify_string, 0, -1);

if (tep_session_is_registered('noaccount')) { 
tep_session_destroy(); 
tep_redirect(tep_href_link(FILENAME_DEFAULT, '', 'NONSSL')); 
} 
else { 
tep_redirect(tep_href_link(FILENAME_DEFAULT, $notify_string, 'SSL')); 
}
 }

 

this is the code i'm using, it could be the ssl because when it redirects it's still on my secure server and i don't think it's supposed to be but how do i get around this?

 

have tried a few different things now and nothing seems to be working... :'(

 

help............

Link to comment
Share on other sites

have been messing about again and i have realised this....

 

http://www.verywellthread.co.uk/shop/ - this is the shop url

 

 

https://web2.secure-secure.co.uk/verywellthread.co.uk/shop/ - this the secure shop url

 

 

https://web2.secure-secure.co.uk/shop/ - and this is where it's trying to go from the checkout_success.php

 

it is indeed correct in thinking it doesn't exhist because it doesn't not there where it is trying to xcall it from.....my code is above can anyone suggest any modifications to it which will overcome my prob......thx :thumbsup:

Link to comment
Share on other sites

I got the same problem...

 

 

The PWA kinda works... but when u get to the Success Page

 

it forwards you to the wrong folder to look the the page....

 

Im using a Shared SSL if that makes any difference....

 

 

Cheers

 

Mike :-"

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...