qspider

I found what was causing the problem. It was the FWR Tax Exempt add on. In particular this piece of code on the checkout_confirmation.php <div id="CheckoutConfirmationTotalPrice"><?php // FWR TAX EXEMPT ?> <?php if (MODULE_ORDER_TOTAL_INSTALLED) { $order_total_modules->process(); echo $order_total_modules->output(); } if (tep_session_is_registered('customers_tax_exempt') && $_SESSION['customers_tax_exempt'] == 1) { echo '<div class="main"><br /><span style="color: green;">' . TAX_EXEMPT_PAYMENT_TEXT . $_SESSION['customers_tax_exempt_id'] . '</span></td> '; } ?> <?php // END FWR TAX EXEMPT ?> </div> </code> In particular this line $order_total_modules->process(); If I remove it; it will display tax and calculate everything correctly and it also removes tax if the customer is registered as tax exempt but without this code it will not display that the customer is tax exempt; it will still remove the tax though if customer is exempt so it still works somewhat. This $order_total code was used twice on the page so this sort of makes sense. Just thought I would share in case somebody else had the same type of problem.

We are back in business! I don't know what happened. I ended up toying around with all the settings until I finally gave up and just restored a previous version of the checkout_confirmation.php. I'll go back later and compare the two different checkout_confirmation files I have. I did install the Advanced Address Management Add On and also Ultimate HTML emails and purchase without account after the Table Discounts add on so maybe it was one of those that caused it to not output properly. Overall, Table Discounts is a great add on. Thanks swguy! Sub-Total: $1,050.00 United Parcel Service (UPS Next Day Air): $46.92 Sales Tax: $65.81 Quantity Discount: -$180.00 Total: $982.73

Hello, I'm not sure what happened but it's not adding correctly. It worked before. I've changed the sort order around to where Quantity Discounts is before Total. The cart shows the correct price but when you get to the checkout it subtracts too much. Cart: Sub-Total: $1,050.00 Quantity Discount: -$180.00 Subtotal After Discount: $870.00 Checkout: Sub-Total: $1,050.00 Quantity Discount: -$180.00 United Parcel Service (1 pkg x 8 lbs total) (UPS Ground (billed dimensional weight 8 LBS)): $12.96 Total: $702.96 Total should be $882 if my math is correct.

I am just removing the FWR Tax Exempt add on from this page. Not sure why it's not working but since this is the administration part I can change the values in the database myself instead of having the add on do it.

Thanks!

I was able to fix the 1064 SQL ERROR by placing an (int) before the $cInfo but now I'm getting the same error as before... It's supposed to return an array. Warning: reset() expects parameter 1 to be array, boolean given in /public_html/admin/includes/classes/object_info.php on line 17 Warning: Variable passed to each() is not an array or object in /public_html/admin/includes/classes/object_info.php on line 18

I think I found the problem and it appears to have to do with the Tax Exempt code. After playing around with it for a while I get an error on /admin/customers.php 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 select org_type_title from organization_type where org_type_id= catalog/admin/customers.php $org_type_query = tep_db_query("select org_type_title from " . TABLE_ORGANIZATION_TYPE . " where org_type_id=" . $cInfo->customers_org_type); I am thinking that is why I received the other error. Here is the data I used to alter the SQL Tables alter table customers add column customers_tax_exempt int(1) not null default 0; alter table customers add column customers_tax_exempt_id char(32); alter table customers add column customers_org_type int not null; alter table orders add column customers_tax_exempt int(1) not null default 0; alter table orders add column customers_tax_exempt_id char(32); alter table orders add column customers_org_type int not null; CREATE TABLE organization_type ( org_type_id int(11) NOT NULL auto_increment, org_type_title varchar(32) NOT NULL default '', org_type_description varchar(255) NOT NULL default '', last_modified datetime default NULL, date_added datetime NOT NULL, org_type_discount tinyint(1) not null default 0, PRIMARY KEY (org_type_id) ) TYPE=MyISAM; INSERT INTO `organization_type` (`org_type_id`, `org_type_title`, `org_type_description`, `last_modified`, `date_added`, `org_type_discount`) VALUES (0, 'None', 'Not Applicable', NULL, NOW(), 0);

Hi all! I just installed the address management add on. Then I installed a tax exempt add on. While in the administration, customers and editing a customers account by clicking on an address i receive these errors. Warning: reset() expects parameter 1 to be array, boolean given in /public_html/admin/includes/classes/object_info.php on line 17 Warning: Variable passed to each() is not an array or object in /home/timerco/public_html/admin/includes/classes/object_info.php on line 18 I look in objects_info.php and I don't see anything wrong but i see it is calling an array. <?php /* $Id$ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2003 osCommerce Released under the GNU General Public License */ class objectInfo { // class constructor function objectInfo($object_array) { reset($object_array); while (list($key, $value) = each($object_array)) { $this->$key = tep_db_prepare_input($value); } } } ?> I then go to look in /admin/customers.php because that's the page where the error happens but I'm not really sure what I'm looking for. I decided to look for object and I found some object arrays and (cinfo). Not really sure what to do. It appears that an array is supposed to be sent but instead it is sending a boolean value. <?php /* $Id$ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2010 osCommerce Released under the GNU General Public License */ require('includes/application_top.php'); function format_US_Canada_phone($phone) { $temp = ''; for ($x = 0; $x < strlen($phone); $x++) { // strip non-digits $c = substr($phone, $x, 1); if (($c >= '0') && ($c <= '9')) $temp .= $c; } if (substr($temp, 0, 1) == '1') $temp = substr($temp, 1); // strip leading 1, long distance indicator if (strlen($temp) == 7) // phone number without area code return substr($temp, 0, 3) . '-' . substr($temp, 3); if (strlen($temp) < 10) return false; // phone number too short if (strlen($temp) > 10) { // phone number includes extension return '(' . substr($temp, 0, 3) . ') ' . substr($temp, 3, 3) . '-' . substr($temp, 6, 4) . ' ext. ' . substr($temp, 10); } else { // standard phone number with area code return '(' . substr($temp, 0, 3) . ') ' . substr($temp, 3, 3) . '-' . substr($temp, 6, 4); } } function address_label($customers_id, $address_id = 1) { if (is_array($address_id) && !empty($address_id)) { return tep_address_format($address_id['address_format_id'], $address_id, true, '', '<br />'); } $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_address2 as address2, 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); $address_format_query = tep_db_query("select address_format_id from " . TABLE_COUNTRIES . " where countries_id = '" . (int)$address['country_id'] . "'"); if (tep_db_num_rows($address_format_query) == 1) { $address_format = tep_db_fetch_array($address_format_query); $format_id = $address_format['address_format_id']; } else { $format_id = '1'; } return tep_address_format($format_id, $address, true, '', '<br />'); } $action = (isset($HTTP_GET_VARS['action']) ? $HTTP_GET_VARS['action'] : ''); $error = false; $processed = false; $customers_id = tep_db_prepare_input($HTTP_GET_VARS['cID']); $check = tep_db_query("select customers_default_address_id, customers_default_billing_address_id, customers_default_shipping_address_id from " . TABLE_CUSTOMERS . " where customers_id = " . (int)$customers_id); $default_addresses = tep_db_fetch_array($check); $address_id = (isset($HTTP_GET_VARS['aid']) ? $HTTP_GET_VARS['aid'] : $default_addresses['customers_default_address_id']); if (tep_not_null($action)) { switch ($action) { case 'savepwd': require('includes/functions/password_funcs.php'); $newpwd = tep_db_prepare_input($HTTP_POST_VARS['pwd']); tep_db_query("update " . TABLE_CUSTOMERS . " set customers_password = '" . tep_encrypt_password($newpwd) . "' where customers_id = '" . (int)$customers_id . "'"); $check_customer_query = tep_db_query("select customers_firstname, customers_lastname, customers_password, customers_email_address from " . TABLE_CUSTOMERS . " where customers_id = '" . (int)$customers_id . "'"); $check_customer = tep_db_fetch_array($check_customer_query); if (tep_validate_password($newpwd, $check_customer['customers_password'])) { tep_mail($check_customer['customers_firstname'] . ' ' . $check_customer['customers_lastname'], $check_customer['customers_email_address'], EMAIL_PASSWORD_REMINDER_SUBJECT, sprintf(EMAIL_PASSWORD_REMINDER_BODY, $newpwd, strlen($newpwd)), STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS); $messageStack->add_session(SUCCESS_PASSWORD_SENT, 'success'); } else { $messageStack->add_session(ERROR_PWD, 'error'); } tep_redirect(tep_href_link(FILENAME_CUSTOMERS, tep_get_all_get_params(array('action')))); break; case 'setdefault': $type = $HTTP_GET_VARS['type']; $check_query = tep_db_query("select count(*) as total from " . TABLE_CUSTOMERS . " where customers_id = " . (int)$customers_id); $check = tep_db_fetch_array($check_query); if ($check['total'] != 1) tep_redirect(tep_href_link(FILENAME_CUSTOMERS)); // no such customer $check_query = tep_db_query("select count(*) as total from " . TABLE_ADDRESS_BOOK . " where customers_id = '" . (int)$customers_id . "' and address_book_id = '" . (int)$address_id . "'"); $check = tep_db_fetch_array($check_query); if ($check['total'] != 1) // no such address for customer tep_redirect(tep_href_link(FILENAME_CUSTOMERS), tep_get_all_get_params(array('action', 'aid'))); if ($type == 'M') { tep_db_query(" update " . TABLE_CUSTOMERS . " set customers_default_address_id = " . (int)$address_id . " where customers_id = " . (int)$customers_id); } elseif ($type == 'B') { tep_db_query(" update " . TABLE_CUSTOMERS . " set customers_default_billing_address_id = " . (int)$address_id . " where customers_id = " . (int)$customers_id); } elseif ($type == 'S') { tep_db_query(" update " . TABLE_CUSTOMERS . " set customers_default_shipping_address_id = " . (int)$address_id . " where customers_id = " . (int)$customers_id); } tep_redirect(tep_href_link(FILENAME_CUSTOMERS, tep_get_all_get_params(array('action', 'type')) . 'action=edit')); break; case 'confirmaddressdelete': if (!isset($HTTP_GET_VARS['cID']) || !isset($HTTP_GET_VARS['aid'])) // if either id not set tep_redirect(tep_href_link(FILENAME_CUSTOMERS, tep_get_all_get_params(array('action')))); $check_default_query = tep_db_query("select customers_default_address_id, customers_default_billing_address_id, customers_default_shipping_address_id from " . TABLE_CUSTOMERS . " where customers_id = '" . (int)$customers_id . "'"); if ($defaults = tep_db_fetch_array($check_default_query)) { if (in_array($address_id, $defaults)) { // may not delete a default address tep_redirect(tep_href_link(FILENAME_CUSTOMERS, tep_get_all_get_params(array('action')) . 'action=edit')); } else { tep_db_query("delete from " . TABLE_ADDRESS_BOOK . " where customers_id = '" . (int)$customers_id . "' and address_book_id = '" . (int)$address_id . "'"); tep_redirect(tep_href_link(FILENAME_CUSTOMERS, tep_get_all_get_params(array('action', 'aid')) . 'action=edit')); } } else { // no match on cID tep_redirect(tep_href_link(FILENAME_CUSTOMERS, tep_get_all_get_params(array('cID', 'action', 'aid')))); } break; case 'update': $customers_firstname = tep_db_prepare_input($HTTP_POST_VARS['customers_firstname']); $customers_lastname = tep_db_prepare_input($HTTP_POST_VARS['customers_lastname']); $entry_firstname = tep_db_prepare_input($HTTP_POST_VARS['entry_firstname']); $entry_lastname = tep_db_prepare_input($HTTP_POST_VARS['entry_lastname']); $customers_email_address = tep_db_prepare_input($HTTP_POST_VARS['customers_email_address']); $customers_telephone = tep_db_prepare_input($HTTP_POST_VARS['customers_telephone']); $customers_alternate_telephone = tep_db_prepare_input($HTTP_POST_VARS['customers_alternate_telephone']); $customers_fax = tep_db_prepare_input($HTTP_POST_VARS['customers_fax']); $customers_newsletter = tep_db_prepare_input($HTTP_POST_VARS['customers_newsletter']); // FWR TAX EXEMPT $customers_tax_exempt = tep_db_prepare_input($HTTP_POST_VARS['tax_exempt']); $customers_tax_exempt_id = tep_db_prepare_input($HTTP_POST_VARS['tax_exempt_id']); $customers_org_type = tep_db_prepare_input($HTTP_POST_VARS['org_type']); // END FWR TAX EXEMPT $customers_gender = tep_db_prepare_input($HTTP_POST_VARS['customers_gender']); $customers_dob = tep_db_prepare_input($HTTP_POST_VARS['customers_dob']); $entry_street_address = tep_db_prepare_input($HTTP_POST_VARS['entry_street_address']); $entry_address2 = tep_db_prepare_input($HTTP_POST_VARS['entry_address2']); $entry_suburb = tep_db_prepare_input($HTTP_POST_VARS['entry_suburb']); $entry_postcode = strtoupper(tep_db_prepare_input($HTTP_POST_VARS['entry_postcode'])); $entry_city = tep_db_prepare_input($HTTP_POST_VARS['entry_city']); $entry_country_id = tep_db_prepare_input($HTTP_POST_VARS['entry_country_id']); $entry_company = tep_db_prepare_input($HTTP_POST_VARS['entry_company']); if (isset($HTTP_POST_VARS['entry_state'])) { $entry_state = tep_db_prepare_input($HTTP_POST_VARS['entry_state']); } else { $entry_state = ''; } if (isset($HTTP_POST_VARS['entry_zone_id'])) { $entry_zone_id = tep_db_prepare_input($HTTP_POST_VARS['entry_zone_id']); } else { $entry_zone_id = 0; } if (strlen($customers_firstname) < ENTRY_FIRST_NAME_MIN_LENGTH) { $error = true; $entry_firstname_error = true; } else { $entry_firstname_error = false; } if (strlen($customers_lastname) < ENTRY_LAST_NAME_MIN_LENGTH) { $error = true; $entry_lastname_error = true; } else { $entry_lastname_error = false; } if (strlen($entry_firstname) < ENTRY_FIRST_NAME_MIN_LENGTH) { $error = true; $entry_entry_firstname_error = true; } else { $entry_entry_firstname_error = false; } if (strlen($entry_lastname) < ENTRY_LAST_NAME_MIN_LENGTH) { $error = true; $entry_entry_lastname_error = true; } else { $entry_entry_lastname_error = false; } if (ACCOUNT_DOB == 'true') { if ((strlen($customers_dob) >= ENTRY_DOB_MIN_LENGTH) && ((is_numeric(tep_date_raw($customers_dob)) && @checkdate(substr(tep_date_raw($customers_dob), 4, 2), substr(tep_date_raw($customers_dob), 6, 2), substr(tep_date_raw($customers_dob), 0, 4))) || empty($customers_dob))) { $entry_date_of_birth_error = false; } else { $error = true; $entry_date_of_birth_error = true; } } if (strlen($customers_email_address) < ENTRY_EMAIL_ADDRESS_MIN_LENGTH) { $error = true; $entry_email_address_error = true; } else { $entry_email_address_error = false; } if (!tep_validate_email($customers_email_address)) { $error = true; $entry_email_address_check_error = true; } else { $entry_email_address_check_error = false; } if (strlen($entry_street_address) < ENTRY_STREET_ADDRESS_MIN_LENGTH) { $error = true; $entry_street_address_error = true; } else { $entry_street_address_error = false; } if (strlen($entry_city) < ENTRY_CITY_MIN_LENGTH) { $error = true; $entry_city_error = true; } else { $entry_city_error = false; } $check_query = tep_db_query("select * from " . TABLE_COUNTRIES . " where countries_id = " . (int)$entry_country_id); if (tep_db_num_rows($check_query) == 0) { $error = true; $entry_country_error = true; } else { $country = tep_db_fetch_array($check_query); $entry_country_error = false; } $entry_post_code_error = $entry_country_error; if (tep_not_null($country['countries_postal_validation'])) { if (!preg_match($country['countries_postal_validation'], $entry_postcode)) { $error = true; $entry_post_code_error = sprintf(ENTRY_ERROR_POSTCODE, strtolower($country['countries_iso_code_3']), $country['countries_name']); } } if (ACCOUNT_STATE == 'true') { if ($entry_country_error == true) { $entry_state_error = true; } else { $entry_state_error = false; $check_query = tep_db_query("select count(*) as total from " . TABLE_ZONES . " where zone_country_id = '" . (int)$entry_country_id . "'"); $check_value = tep_db_fetch_array($check_query); $entry_state_has_zones = ($check_value['total'] > 0); if ($entry_state_has_zones == true) { $zone_query = tep_db_query("select zone_name from " . TABLE_ZONES . " where zone_country_id = '" . (int)$entry_country_id . "' and zone_id = '" . (int)$entry_zone_id . "'"); if (tep_db_num_rows($zone_query) == 1) { $zone = tep_db_fetch_array($zone_query); $entry_state = $zone['zone_name']; } elseif ($country['requires_state'] == 1) { $error = true; $entry_state_error = true; } } else { if (($country['requires_state'] == 1) && (strlen($entry_state) < ENTRY_STATE_MIN_LENGTH)) { $error = true; $entry_state_error = true; } } } } if (strlen($customers_telephone) < ENTRY_TELEPHONE_MIN_LENGTH) { $error = true; $entry_telephone_error = ENTRY_TELEPHONE_NUMBER_ERROR; } else { $entry_telephone_error = false; } $entry_alt_telephone_error = $entry_fax_error = false; $check_query = tep_db_query("select customers_default_address_id from " . TABLE_CUSTOMERS . " where customers_id = " . (int)$customers_id); $cdaid = tep_db_fetch_array($check_query); if ($cdaid['customers_default_address_id'] != $address_id) { $check_query = tep_db_query("select c.countries_iso_code_2 from " . TABLE_COUNTRIES . " c join " . TABLE_ADDRESS_BOOK . " ab where c.countries_id = ab.entry_country_id and ab.customers_id = '" . (int)$customers_id . "' and ab.address_book_id = '" . (int)$cdaid['customers_default_address_id'] . "'"); $country = tep_db_fetch_array($check_query); } if (($country['countries_iso_code_2'] == 'US') || ($country['countries_iso_code_2'] == 'CA')) { // format US/Canada phone numbers $customers_telephone = format_US_Canada_phone($customers_telephone); if ($customers_telephone === false) { $error = true; $entry_telephone_error = ENTRY_ERROR_US_CANADA_PHONE; } if (strlen($customers_alternate_telephone) > 0) $customers_alternate_telephone = format_US_Canada_phone($customers_alternate_telephone); if ($customers_alternate_telephone === false) { $error = true; $entry_alt_telephone_error = ENTRY_ERROR_US_CANADA_PHONE; } if (strlen($customers_fax) > 0) $customers_fax = format_US_Canada_phone($customers_fax); if ($customers_fax === false) { $error = true; $entry_fax_error = ENTRY_ERROR_US_CANADA_PHONE; } } if ($customers_alternate_telephone == $customers_telephone) $customers_alternate_telephone = ''; // dispose of duplicate phone number $check_email = tep_db_query("select customers_email_address from " . TABLE_CUSTOMERS . " where customers_email_address = '" . tep_db_input($customers_email_address) . "' and customers_id != '" . (int)$customers_id . "'"); if (tep_db_num_rows($check_email)) { $error = true; $entry_email_address_exists = true; } else { $entry_email_address_exists = false; } if ($error == false) { $sql_data_array = array('customers_firstname' => $customers_firstname, 'customers_lastname' => $customers_lastname, 'customers_email_address' => $customers_email_address, 'customers_telephone' => $customers_telephone, 'customers_alternate_telephone' => (tep_not_null($customers_alternate_telephone) ? $customers_alternate_telephone : 'null'), 'customers_fax' => (tep_not_null($customers_fax) ? $customers_fax : 'null'), // FWR TAX EXEMPT 'customers_tax_exempt' => $customers_tax_exempt, 'customers_tax_exempt_id' => $customers_tax_exempt_id, 'customers_org_type' => $customers_org_type, // END FWR TAX EXEMPT 'customers_newsletter' => $customers_newsletter); if (ACCOUNT_GENDER == 'true') $sql_data_array['customers_gender'] = $customers_gender; if (ACCOUNT_DOB == 'true') $sql_data_array['customers_dob'] = tep_date_raw($customers_dob); tep_db_perform(TABLE_CUSTOMERS, $sql_data_array, 'update', "customers_id = '" . (int)$customers_id . "'"); tep_db_query("update " . TABLE_CUSTOMERS_INFO . " set customers_info_date_account_last_modified = now() where customers_info_id = '" . (int)$customers_id . "'"); if ($entry_state == '') $entry_state = 'null'; $sql_data_array = array('entry_firstname' => $entry_firstname, 'entry_lastname' => $entry_lastname, 'entry_street_address' => $entry_street_address, 'entry_address2' => (tep_not_null($entry_address2) ? $entry_address2 : 'null'), 'entry_postcode' => $entry_postcode, 'entry_city' => $entry_city, 'entry_country_id' => $entry_country_id); if (ACCOUNT_COMPANY == 'true') $sql_data_array['entry_company'] = (tep_not_null($entry_company) ? $entry_company : 'null'); if (ACCOUNT_SUBURB == 'true') $sql_data_array['entry_suburb'] = (tep_not_null($entry_suburb) ? $entry_suburb : 'null'); if (ACCOUNT_STATE == 'true') { if ($entry_zone_id > 0) { $sql_data_array['entry_zone_id'] = $entry_zone_id; $sql_data_array['entry_state'] = $entry_state; } else { $sql_data_array['entry_zone_id'] = '0'; $sql_data_array['entry_state'] = $entry_state; } } tep_db_perform(TABLE_ADDRESS_BOOK, $sql_data_array, 'update', "customers_id = '" . (int)$customers_id . "' and address_book_id = '" . (int)$address_id . "'"); tep_redirect(tep_href_link(FILENAME_CUSTOMERS, tep_get_all_get_params(array('cID', 'action', 'aid')) . 'cID=' . $customers_id)); } else if ($error == true) { $cInfo = new objectInfo($HTTP_POST_VARS); $processed = true; } break; case 'deleteconfirm': $customers_id = tep_db_prepare_input($HTTP_GET_VARS['cID']); if (isset($HTTP_POST_VARS['delete_reviews']) && ($HTTP_POST_VARS['delete_reviews'] == 'on')) { $reviews_query = tep_db_query("select reviews_id from " . TABLE_REVIEWS . " where customers_id = '" . (int)$customers_id . "'"); while ($reviews = tep_db_fetch_array($reviews_query)) { tep_db_query("delete from " . TABLE_REVIEWS_DESCRIPTION . " where reviews_id = '" . (int)$reviews['reviews_id'] . "'"); } tep_db_query("delete from " . TABLE_REVIEWS . " where customers_id = '" . (int)$customers_id . "'"); } else { tep_db_query("update " . TABLE_REVIEWS . " set customers_id = null where customers_id = '" . (int)$customers_id . "'"); } tep_db_query("delete from " . TABLE_ADDRESS_BOOK . " where customers_id = '" . (int)$customers_id . "'"); tep_db_query("delete from " . TABLE_CUSTOMERS . " where customers_id = '" . (int)$customers_id . "'"); tep_db_query("delete from " . TABLE_CUSTOMERS_INFO . " where customers_info_id = '" . (int)$customers_id . "'"); tep_db_query("delete from " . TABLE_CUSTOMERS_BASKET . " where customers_id = '" . (int)$customers_id . "'"); tep_db_query("delete from " . TABLE_CUSTOMERS_BASKET_ATTRIBUTES . " where customers_id = '" . (int)$customers_id . "'"); // Wishlist addition to delete products from the wishlist when customer deleted // tep_db_query("delete from " . TABLE_WISHLIST . " where customers_id = " . (int)$customers_id); // tep_db_query("delete from " . TABLE_WISHLIST_ATTRIBUTES . " where customers_id = " . (int)$customers_id); // tep_db_query("delete from " . TABLE_WHOS_ONLINE . " where customer_id = '" . (int)$customers_id . "'"); tep_redirect(tep_href_link(FILENAME_CUSTOMERS, tep_get_all_get_params(array('cID', 'action')))); break; default: $customers_query = tep_db_query("select c.customers_id, c.customers_gender, c.customers_firstname, c.customers_lastname, c.customers_dob, c.customers_email_address, a.entry_firstname, a.entry_lastname, a.entry_company, a.entry_street_address, a.entry_address2, a.entry_suburb, a.entry_postcode, a.entry_city, a.entry_state, a.entry_zone_id, a.entry_country_id, c.customers_telephone, c.customers_alternate_telephone, c.customers_fax, c.customers_newsletter, c.customers_default_address_id, c.customers_default_billing_address_id, c.customers_default_shipping_address_id from " . TABLE_CUSTOMERS . " c left join " . TABLE_ADDRESS_BOOK . " a on a.customers_id = c.customers_id where a.address_book_id = " . (int)$address_id . " and c.customers_id = '" . (int)$customers_id . "'"); $customers = tep_db_fetch_array($customers_query); $cInfo = new objectInfo($customers); } } require(DIR_WS_INCLUDES . 'template_top.php'); ?> <table border="0" width="100%" cellspacing="0" cellpadding="2"> <?php if ($action == 'newpwd') { ?> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td class="pageHeading"><?php echo HEADING_TITLE; ?></td> <td class="pageHeading" align="right"><?php echo tep_draw_separator('pixel_trans.gif', HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td> </tr> </table></td> </tr> <tr> <td class="main"><?php echo '<strong>' . HEADING_CHANGE_PWD . $cInfo->customers_firstname . ' ' . $cInfo->customers_lastname . '</strong><br />' . $cInfo->customers_email_address; ?></td> </tr> <tr> <td class="main"><?php echo tep_draw_form('newpwd', FILENAME_CUSTOMERS, tep_get_all_get_params(array('action')) . 'action=savepwd', 'post') . ENTRY_NEW_PWD . tep_draw_input_field('pwd', null, 'size="32"'); ?></td> </tr> <tr> <td class="main"><?php echo TEXT_PWD_WARNING; ?></td> </tr> <tr> <td class="main"><?php echo tep_draw_button(IMAGE_SAVE, 'disk') . tep_draw_button(IMAGE_CANCEL, 'cancel', tep_href_link(FILENAME_CUSTOMERS, tep_get_all_get_params(array('action', 'aid'))), 'primary'); ?></td> </tr> <?php } elseif ($action == 'edit' || $action == 'update') { // FWR TAX EXEMPT $customers_query = tep_db_query("select c.customers_gender, c.customers_firstname, c.customers_org_type, c.customers_lastname, c.customers_tax_exempt, c.customers_tax_exempt_id, c.customers_dob, c.customers_email_address, a.entry_company, a.entry_street_address, a.entry_suburb, a.entry_postcode, a.entry_city, a.entry_state, a.entry_zone_id, a.entry_country_id, c.customers_telephone, c.customers_fax, c.customers_newsletter, c.customers_default_address_id from " . TABLE_CUSTOMERS . " c left join " . TABLE_ADDRESS_BOOK . " a on c.customers_default_address_id = a.address_book_id where a.customers_id = c.customers_id and c.customers_id = '" . $HTTP_GET_VARS['cID'] . "'"); $customers = tep_db_fetch_array($customers_query); $cInfo = new objectInfo($customers); // END FWR TAX EXEMPT $newsletter_array = array(array('id' => '1', 'text' => ENTRY_NEWSLETTER_YES), array('id' => '0', 'text' => ENTRY_NEWSLETTER_NO)); // FWR TAX EXEMPT $tax_exempt_array = array( array('id' => '0', 'text' => ENTRY_TAX_EXEMPT_NO), array('id' => '1', 'text' => ENTRY_TAX_EXEMPT_YES)); // END FWR TAX EXEMPT ?> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td class="pageHeading"><?php echo HEADING_TITLE; ?></td> <td class="pageHeading" align="right"><?php echo tep_draw_separator('pixel_trans.gif', HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td> </tr> </table></td> </tr> <?php $customer_address_query = tep_db_query("select address_book_id as id from " . TABLE_ADDRESS_BOOK . " where customers_id = '" . (int)$customers_id . "'"); if (tep_db_num_rows($customer_address_query) > 1) { ?> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td> </tr> <tr> <td class="formAreaTitle"><?php echo TEXT_CLICK_TO_EDIT; ?></td> </tr> <tr> <td class="formArea"><table border="0" cellspacing="2" cellpadding="2"> <tr> <?php $col = 0; while ($address = tep_db_fetch_array($customer_address_query)) { $col++; if ($col > 4) { $col = 1; echo "</tr>\n<tr>"; } if ($address['id'] == $address_id) { echo '<td class="smallText" style="border: 1px solid red; padding: 2px;">'; } else { echo '<td class="smallText" style="border: 1px solid black; padding: 2px;">'; } if ($address['id'] == $default_addresses['customers_default_address_id']) echo '<em style="color: blue">' . TEXT_DEFAULT . TEXT_MAILING . '</em><br />'; if ($address['id'] == $default_addresses['customers_default_billing_address_id']) echo '<em style="color: blue">' . TEXT_DEFAULT . TEXT_BILLING . '</em><br />'; if ($address['id'] == $default_addresses['customers_default_shipping_address_id']) echo '<em style="color: blue">' . TEXT_DEFAULT . TEXT_SHIPPING . '</em><br />'; echo '<a href="' . tep_href_link(FILENAME_CUSTOMERS, tep_get_all_get_params(array('cID', 'action', 'aid')) . 'cID=' . $cInfo->customers_id . '&action=edit&aid=' . $address['id']) . (($address['id'] == $address_id) ? '" style="color: red">' : '">') . address_label($customers_id, $address['id']) . '</a>'; if ($address['id'] != $default_addresses['customers_default_address_id']) echo '<br /><a style="color: blue" href="' . tep_href_link(FILENAME_CUSTOMERS, tep_get_all_get_params(array('cID', 'action', 'aid')) . 'cID=' . $cInfo->customers_id . '&action=setdefault&type=M&aid=' . $address['id']) . '">' . TEXT_SET_DEFAULT . TEXT_MAILING . '</a>'; if ($address['id'] != $default_addresses['customers_default_billing_address_id']) echo '<br /><a style="color: blue" href="' . tep_href_link(FILENAME_CUSTOMERS, tep_get_all_get_params(array('cID', 'action', 'aid')) . 'cID=' . $cInfo->customers_id . '&action=setdefault&type=B&aid=' . $address['id']) . '">' . TEXT_SET_DEFAULT . TEXT_BILLING . '</a>'; if ($address['id'] != $default_addresses['customers_default_shipping_address_id']) echo '<br /><a style="color: blue" href="' . tep_href_link(FILENAME_CUSTOMERS, tep_get_all_get_params(array('cID', 'action', 'aid')) . 'cID=' . $cInfo->customers_id . '&action=setdefault&type=S&aid=' . $address['id']) . '">' . TEXT_SET_DEFAULT . TEXT_SHIPPING . '</a>'; if (!in_array($address['id'], $default_addresses)) echo '<br /><br /><a style="color: maroon" href="' . tep_href_link(FILENAME_CUSTOMERS, tep_get_all_get_params(array('cID', 'action', 'aid')) . 'cID=' . $cInfo->customers_id . '&action=deladdress&aid=' . $address['id']) . '">' . TEXT_DELETE_ADDRESS . '</a>'; echo "</td>\n"; } ?> </tr> </table></td> </tr> <?php } ?> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td> </tr> <tr><?php echo tep_draw_form('customers', FILENAME_CUSTOMERS, tep_get_all_get_params(array('action', 'aid')) . 'action=update&aid=' . (tep_not_null($address_id) ? $address_id : $cInfo->customers_default_address_id), 'post'); ?> <td class="formAreaTitle"><?php echo CATEGORY_PERSONAL; ?></td> </tr> <tr> <td class="formArea"><table border="0" cellspacing="2" cellpadding="2"> <?php if (ACCOUNT_GENDER == 'true') { ?> <tr> <td class="main"><?php echo ENTRY_GENDER; ?></td> <td class="main"> <?php if ($error == true) { if ($entry_gender_error == true) { echo tep_draw_radio_field('customers_gender', 'm', false, $cInfo->customers_gender) . ' ' . MALE . ' ' . tep_draw_radio_field('customers_gender', 'f', false, $cInfo->customers_gender) . ' ' . FEMALE . ' ' . ENTRY_GENDER_ERROR; } else { echo ($cInfo->customers_gender == 'm') ? MALE : FEMALE; echo tep_draw_hidden_field('customers_gender'); } } else { echo tep_draw_radio_field('customers_gender', 'm', false, $cInfo->customers_gender) . ' ' . MALE . ' ' . tep_draw_radio_field('customers_gender', 'f', false, $cInfo->customers_gender) . ' ' . FEMALE; } ?></td> </tr> <?php } ?> <tr> <td class="main"><?php echo ENTRY_FIRST_NAME; ?></td> <td class="main"> <?php if ($error == true) { if ($entry_firstname_error == true) { echo tep_draw_input_field('customers_firstname', $cInfo->customers_firstname, 'size="64"') . ' ' . ENTRY_FIRST_NAME_ERROR; } else { echo $cInfo->customers_firstname . tep_draw_hidden_field('customers_firstname'); } } else { echo tep_draw_input_field('customers_firstname', $cInfo->customers_firstname, 'size="64"', true); } ?></td> </tr> <tr> <td class="main"><?php echo ENTRY_LAST_NAME; ?></td> <td class="main"> <?php if ($error == true) { if ($entry_lastname_error == true) { echo tep_draw_input_field('customers_lastname', $cInfo->customers_lastname, 'size="64"') . ' ' . ENTRY_LAST_NAME_ERROR; } else { echo $cInfo->customers_lastname . tep_draw_hidden_field('customers_lastname'); } } else { echo tep_draw_input_field('customers_lastname', $cInfo->customers_lastname, 'size="64"', true); } ?></td> </tr> <?php if (ACCOUNT_DOB == 'true') { ?> <tr> <td class="main"><?php echo ENTRY_DATE_OF_BIRTH; ?></td> <td class="main"> <?php if ($error == true) { if ($entry_date_of_birth_error == true) { echo tep_draw_input_field('customers_dob', tep_date_short($cInfo->customers_dob), 'size="64"') . ' ' . ENTRY_DATE_OF_BIRTH_ERROR; } else { echo $cInfo->customers_dob . tep_draw_hidden_field('customers_dob'); } } else { echo tep_draw_input_field('customers_dob', tep_date_short($cInfo->customers_dob), 'size="64" id="customers_dob"', true); } ?> <script type="text/javascript">$('#customers_dob').datepicker({dateFormat: '<?php echo JQUERY_DATEPICKER_FORMAT; ?>', changeMonth: true, changeYear: true, yearRange: '-100:+0'});</script> </td> </tr> <?php } ?> <tr> <td class="main"><?php echo ENTRY_EMAIL_ADDRESS; ?></td> <td class="main"> <?php if ($error == true) { if ($entry_email_address_error == true) { echo tep_draw_input_field('customers_email_address', $cInfo->customers_email_address, 'size="64"') . ' ' . ENTRY_EMAIL_ADDRESS_ERROR; } elseif ($entry_email_address_check_error == true) { echo tep_draw_input_field('customers_email_address', $cInfo->customers_email_address, 'size="64"') . ' ' . ENTRY_EMAIL_ADDRESS_CHECK_ERROR; } elseif ($entry_email_address_exists == true) { echo tep_draw_input_field('customers_email_address', $cInfo->customers_email_address, 'size="64"') . ' ' . ENTRY_EMAIL_ADDRESS_ERROR_EXISTS; } else { echo $customers_email_address . tep_draw_hidden_field('customers_email_address'); } } else { echo tep_draw_input_field('customers_email_address', $cInfo->customers_email_address, 'size="64"', true); } ?></td> </tr> </table></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td> </tr> <tr> <td class="formAreaTitle"><?php echo CATEGORY_ADDRESS; ?></td> </tr> <tr> <td class="formArea"><table border="0" cellspacing="2" cellpadding="2"> <tr> <td class="main"><?php echo ENTRY_FIRST_NAME; ?></td> <td class="main"> <?php if ($error == true) { if ($entry_entry_firstname_error == true) { echo tep_draw_input_field('entry_firstname', $cInfo->entry_firstname, 'size="64"') . ' ' . ENTRY_FIRST_NAME_ERROR; } else { echo $cInfo->entry_firstname . tep_draw_hidden_field('entry_firstname'); } } else { echo tep_draw_input_field('entry_firstname', $cInfo->entry_firstname, 'size="64"', true); } ?></td> </tr> <tr> <td class="main"><?php echo ENTRY_LAST_NAME; ?></td> <td class="main"> <?php if ($error == true) { if ($entry_entry_lastname_error == true) { echo tep_draw_input_field('entry_lastname', $cInfo->entry_lastname, 'size="64"') . ' ' . ENTRY_LAST_NAME_ERROR; } else { echo $cInfo->entry_lastname . tep_draw_hidden_field('entry_lastname'); } } else { echo tep_draw_input_field('entry_lastname', $cInfo->entry_lastname, 'size="64"', true); } ?></td> </tr> <?php if (ACCOUNT_COMPANY == 'true') { ?> <tr> <td class="main"><?php echo ENTRY_COMPANY; ?></td> <td class="main"> <?php if ($error == true) { echo $cInfo->entry_company . tep_draw_hidden_field('entry_company'); } else { echo tep_draw_input_field('entry_company', $cInfo->entry_company, 'size="64"'); } ?></td> <?php //FWR TAX EXEMPT ?> </tr> <tr> <td class="main"><?php echo ENTRY_TAX_EXEMPT; ?></td> <td class="main"><?php echo tep_draw_pull_down_menu('tax_exempt', $tax_exempt_array, $cInfo->customers_tax_exempt); ?></td> </tr> <tr> <td class="main"><?php echo ENTRY_TAX_EXEMPT_ID; ?></td> <td class="main"><?php echo tep_draw_input_field('tax_exempt_id', $cInfo->customers_tax_exempt_id); ?></td> </tr> <tr> <td class="main"><?php echo ENTRY_ORG_TYPE; ?></td> <td class="main"> <?php $org_type_query = tep_db_query("select org_type_id, org_type_title from " . TABLE_ORGANIZATION_TYPE . " order by org_type_title"); while ($org_type_row = tep_db_fetch_array($org_type_query)) { $org_type_array[] = array('id' => $org_type_row['org_type_id'], 'text' => $org_type_row['org_type_title']); } echo tep_draw_pull_down_menu('org_type', $org_type_array, $cInfo->customers_org_type ); ?> <?php // END FWR TAX EXEMPT ?> </tr> <?php } ?> <tr> <td class="main"><?php echo ENTRY_STREET_ADDRESS; ?></td> <td class="main"> <?php if ($error == true) { if ($entry_street_address_error == true) { echo tep_draw_input_field('entry_street_address', $cInfo->entry_street_address, 'size="64"') . ' ' . ENTRY_STREET_ADDRESS_ERROR; } else { echo $cInfo->entry_street_address . tep_draw_hidden_field('entry_street_address'); } } else { echo tep_draw_input_field('entry_street_address', $cInfo->entry_street_address, 'size="64"', true); } ?></td> </tr> <tr> <td class="main"><?php echo ENTRY_ADDRESS2; ?></td> <td class="main"> <?php if ($error == true) { echo $cInfo->entry_address2 . tep_draw_hidden_field('entry_address2'); } else { echo tep_draw_input_field('entry_address2', $cInfo->entry_address2, 'size="64"'); } ?></td> </tr> <?php if (ACCOUNT_SUBURB == 'true') { ?> <tr> <td class="main"><?php echo ENTRY_SUBURB; ?></td> <td class="main"> <?php if ($error == true) { echo $cInfo->entry_suburb . tep_draw_hidden_field('entry_suburb'); } else { echo tep_draw_input_field('entry_suburb', $cInfo->entry_suburb, 'size="64"'); } ?></td> </tr> <?php } $countries_query = tep_db_query("select countries_id, countries_name, requires_state, countries_postal_validation from " . TABLE_COUNTRIES . " order by countries_name"); $countries = $cl = $rs = array(); $rpc = ''; while ($country = tep_db_fetch_array($countries_query)) { $cl[] = $country['countries_id']; $rs[$country['countries_id']] = $country['requires_state']; $rpc .= '<span id="pc' . $country['countries_id'] . '"' . ($country['countries_id'] == $cInfo->entry_country_id ? '' : ' style="display:none"') . '>' . (tep_not_null($country['countries_postal_validation']) ? TEXT_FIELD_REQUIRED : '') . "</span>\n"; $countries[] = array('id' => $country['countries_id'], 'text' => $country['countries_name']); } ?> <tr> <td class="main"><?php echo ENTRY_POST_CODE; ?></td> <td class="main"> <?php if ($error == true) { if ($entry_post_code_error !== false) { echo tep_draw_input_field('entry_postcode', $cInfo->entry_postcode, 'size="64"') . ' ' . $entry_post_code_error; } else { echo $cInfo->entry_postcode . tep_draw_hidden_field('entry_postcode'); } } else { echo tep_draw_input_field('entry_postcode', $cInfo->entry_postcode, 'size="64"'); } echo $rpc; ?></td> </tr> <tr> <td class="main"><?php echo ENTRY_CITY; ?></td> <td class="main"> <?php if ($error == true) { if ($entry_city_error == true) { echo tep_draw_input_field('entry_city', $cInfo->entry_city, 'size="64"') . ' ' . ENTRY_CITY_ERROR; } else { echo $cInfo->entry_city . tep_draw_hidden_field('entry_city'); } } else { echo tep_draw_input_field('entry_city', $cInfo->entry_city, 'size="64"', true); } ?></td> </tr> <?php if (ACCOUNT_STATE == 'true') { ?> <tr> <td class="main"><?php echo ENTRY_STATE; ?></td> <td class="main"> <?php $entry_state = tep_get_zone_name($cInfo->entry_country_id, $cInfo->entry_zone_id, $cInfo->entry_state); if ($error == true) { if ($entry_state_error == true) { if ($entry_state_has_zones == true) { $zones_array = array(); $zones_query = tep_db_query("select zone_name, zone_id from " . TABLE_ZONES . " where zone_country_id = '" . tep_db_input($cInfo->entry_country_id) . "' order by zone_name"); while ($zones_values = tep_db_fetch_array($zones_query)) { $zones_array[] = array('id' => $zones_values['zone_id'], 'text' => $zones_values['zone_name']); } echo tep_draw_pull_down_menu('entry_zone_id', $zones_array, $cInfo->entry_zone_id) . ' ' . ENTRY_STATE_ERROR; } else { echo tep_draw_input_field('entry_state', $entry_state, 'size="64"') . ' ' . ENTRY_STATE_ERROR; } } else { echo $entry_state . tep_draw_hidden_field('entry_zone_id') . tep_draw_hidden_field('entry_state'); } } else { foreach ($cl as $id) { if ($id != $cInfo->entry_country_id) { //if current list is not for selected country set list to not displayed and disabled $parms = 'disabled="disabled" '; $span = '<span style="display:none" id="sp' . $id .'">'; } else { $parms = ''; $span = '<span id="sp' . $id .'">'; } $parms .= 'id="' . $id . '"'; // set id for list for javascript show/hide process echo $span; $zones_array = array(); $zones_query = tep_db_query("select zone_name, zone_id from " . TABLE_ZONES . " where zone_country_id = '" . (int)$id . "' order by zone_name"); if (tep_db_num_rows($zones_query) == 0) { // if no zones for country draw text field echo tep_draw_input_field('entry_state', $entry_state, $parms . ' size="64"'); } else { // otherwise draw pulldown list of zones while ($zones_values = tep_db_fetch_array($zones_query)) { $zones_array[] = array('id' => $zones_values['zone_id'], 'text' => $zones_values['zone_name']); } echo tep_draw_pull_down_menu('entry_zone_id', $zones_array, $cInfo->entry_zone_id, $parms); } if ($rs[$id] == 1) echo TEXT_FIELD_REQUIRED; echo "</span>\n"; } } ?></td> </tr> <?php } ?> <!-- hide and disable all state lists and postal code requirements before showing list pertaining to currently chosen country //--> <script language="Javascript"> function ShowNewList(){ var id = new Array(<?php echo implode(', ', $cl); ?>); var x, item; for (x = 0; x < id.length; x++) { <?php if (ACCOUNT_STATE == 'true') { ?> item = document.getElementById(id[x]); if (item) { item.disabled = true; } item = document.getElementById('sp' + id[x]); if (item) { item.style.display = 'none'; } <?php } ?> item = document.getElementById('pc' + id[x]); if (item) { item.style.display = 'none'; } } var pm = document.getElementById('ctry'); id = pm.value; <?php if (ACCOUNT_STATE == 'true') { ?> item = document.getElementById(id); item.disabled = false; item = document.getElementById('sp' + id); item.style.display = ''; <?php } ?> item = document.getElementById('pc' + id); item.style.display = ''; } </script> <tr> <td class="main"><?php echo ENTRY_COUNTRY; ?></td> <td class="main"> <?php if ($error == true) { if ($entry_country_error == true) { echo tep_draw_pull_down_menu('entry_country_id', $countries, $cInfo->entry_country_id, 'id="ctry" onchange="ShowNewList()"', true) . ' ' . ENTRY_COUNTRY_ERROR; } else { echo tep_get_country_name($cInfo->entry_country_id) . tep_draw_hidden_field('entry_country_id'); } } else { echo tep_draw_pull_down_menu('entry_country_id', $countries, $cInfo->entry_country_id, 'id="ctry" onchange="ShowNewList()"', true); } ?></td> </tr> </table></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td> </tr> <tr> <td class="formAreaTitle"><?php echo CATEGORY_CONTACT; ?></td> </tr> <tr> <td class="formArea"><table border="0" cellspacing="2" cellpadding="2"> <tr> <td class="main"><?php echo ENTRY_TELEPHONE_NUMBER; ?></td> <td class="main"> <?php if ($error == true) { if ($entry_telephone_error !== false) { echo tep_draw_input_field('customers_telephone', $cInfo->customers_telephone, 'size="32"') . ' ' . $entry_telephone_error; } else { echo $cInfo->customers_telephone . tep_draw_hidden_field('customers_telephone'); } } else { echo tep_draw_input_field('customers_telephone', $cInfo->customers_telephone, 'size="32"', true); } ?></td> </tr> <tr> <td class="main"><?php echo ENTRY_ALTERNATE_TELEPHONE; ?></td> <td class="main"> <?php if ($error == true) { if ($entry_alt_telephone_error !== false) { echo tep_draw_input_field('customers_alternate_telephone', $cInfo->customers_alternate_telephone, 'size="32"') . ' ' . $entry_alt_telephone_error; } else { echo $cInfo->customers_alternate_telephone . tep_draw_hidden_field('customers_alternate_telephone'); } } else { echo tep_draw_input_field('customers_alternate_telephone', $cInfo->customers_alternate_telephone, 'size="32"'); } ?></td> </tr> <tr> <td class="main"><?php echo ENTRY_FAX_NUMBER; ?></td> <td class="main"> <?php if ($error == true) { if ($entry_fax_error !== false) { echo tep_draw_input_field('customers_fax', $cInfo->customers_fax, 'size="32"') . ' ' . $entry_fax_error; } else { echo $cInfo->customers_fax . tep_draw_hidden_field('customers_fax'); } } else { echo tep_draw_input_field('customers_fax', $cInfo->customers_fax, 'size="32"'); } ?></td> </tr> </table></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td> </tr> <tr> <td class="formAreaTitle"><?php echo CATEGORY_OPTIONS; ?></td> </tr> <tr> <td class="formArea"><table border="0" cellspacing="2" cellpadding="2"> <tr> <td class="main"><?php echo ENTRY_NEWSLETTER; ?></td> <td class="main"> <?php if ($processed == true) { if ($cInfo->customers_newsletter == '1') { echo ENTRY_NEWSLETTER_YES; } else { echo ENTRY_NEWSLETTER_NO; } echo tep_draw_hidden_field('customers_newsletter'); } else { echo tep_draw_pull_down_menu('customers_newsletter', $newsletter_array, (($cInfo->customers_newsletter == '1') ? '1' : '0')); } ?></td> </tr> </table></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td> </tr> <tr> <td align="right" class="smallText"><?php echo tep_draw_button(IMAGE_SAVE, 'disk', null, 'primary') . tep_draw_button(IMAGE_CANCEL, 'close', tep_href_link(FILENAME_CUSTOMERS, tep_get_all_get_params(array('action', 'aid')))); ?></td> </tr></form> <?php } else { ?> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr><?php echo tep_draw_form('search', FILENAME_CUSTOMERS, '', 'get'); ?> <td class="pageHeading"><?php echo HEADING_TITLE; ?></td> <td class="pageHeading" align="right"><?php echo tep_draw_separator('pixel_trans.gif', 1, HEADING_IMAGE_HEIGHT); ?></td> <td class="smallText" align="right"><?php echo HEADING_TITLE_SEARCH . ' ' . tep_draw_input_field('search'); ?></td> <?php echo tep_hide_session_id(); ?></form></tr> </table></td> </tr> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr class="dataTableHeadingRow"> <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_LASTNAME; ?></td> <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_FIRSTNAME; ?></td> <?php //FWR TAX EXEMPT ?> <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_COMPANY; ?></td> <?php // END FWR TAX EXEMPT ?> <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_EMAIL; ?></td> <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_ACCOUNT_CREATED; ?></td> <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_ACTION; ?> </td> </tr> <?php $search = ''; if (isset($HTTP_GET_VARS['search']) && tep_not_null($HTTP_GET_VARS['search'])) { $keywords = tep_db_input(tep_db_prepare_input($HTTP_GET_VARS['search'])); $search = "where c.customers_lastname like '%" . $keywords . "%' or c.customers_firstname like '%" . $keywords . "%' or c.customers_email_address like '%" . $keywords . "%'"; } // FWR TAX EXEMPT $customers_query_raw = "select c.customers_id, c.customers_lastname, c.customers_firstname, c.customers_org_type, c.customers_email_address, a.entry_country_id from " . TABLE_CUSTOMERS . " c left join " . TABLE_ADDRESS_BOOK . " a on c.customers_id = a.customers_id and c.customers_default_address_id = a.address_book_id " . $search . " order by c.customers_lastname, c.customers_firstname"; // END FWR TAX EXEMPT $customers_split = new splitPageResults($HTTP_GET_VARS['page'], MAX_DISPLAY_SEARCH_RESULTS, $customers_query_raw, $customers_query_numrows); $customers_query = tep_db_query($customers_query_raw); while ($customers = tep_db_fetch_array($customers_query)) { $info_query = tep_db_query("select customers_info_date_account_created as date_account_created, customers_info_date_account_last_modified as date_account_last_modified, customers_info_date_of_last_logon as date_last_logon, customers_info_number_of_logons as number_of_logons from " . TABLE_CUSTOMERS_INFO . " where customers_info_id = '" . $customers['customers_id'] . "'"); $info = tep_db_fetch_array($info_query); // FWR TAX EXEMPT $abook_query = tep_db_query("select entry_company from " . TABLE_ADDRESS_BOOK . " where customers_id = " . $customers['customers_id']); $abook = tep_db_fetch_array($abook_query); // END FWR TAX EXEMPT if ((!isset($HTTP_GET_VARS['cID']) || (isset($HTTP_GET_VARS['cID']) && ($HTTP_GET_VARS['cID'] == $customers['customers_id']))) && !isset($cInfo)) { $country_query = tep_db_query("select countries_name from " . TABLE_COUNTRIES . " where countries_id = '" . (int)$customers['entry_country_id'] . "'"); $country = tep_db_fetch_array($country_query); $reviews_query = tep_db_query("select count(*) as number_of_reviews from " . TABLE_REVIEWS . " where customers_id = '" . (int)$customers['customers_id'] . "'"); $reviews = tep_db_fetch_array($reviews_query); $customer_info = array_merge($country, $info, $reviews); $cInfo_array = array_merge($customers, $customer_info); $cInfo = new objectInfo($cInfo_array); } if (isset($cInfo) && is_object($cInfo) && ($customers['customers_id'] == $cInfo->customers_id)) { echo ' <tr id="defaultSelected" class="dataTableRowSelected" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="document.location.href=\'' . tep_href_link(FILENAME_CUSTOMERS, tep_get_all_get_params(array('cID', 'action')) . 'cID=' . $cInfo->customers_id . '&action=edit') . '\'">' . "\n"; } else { echo ' <tr class="dataTableRow" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="document.location.href=\'' . tep_href_link(FILENAME_CUSTOMERS, tep_get_all_get_params(array('cID')) . 'cID=' . $customers['customers_id']) . '\'">' . "\n"; } ?> <td class="dataTableContent"><?php echo $customers['customers_lastname']; ?></td> <td class="dataTableContent"><?php echo $customers['customers_firstname']; ?></td> <?php //FWR TAX EXEMPT ?> <td class="dataTableContent"><?php echo $abook['entry_company']; ?></td> <?php // END FWR TAX EXEMPT ?> <td class="dataTableContent"><?php echo $customers['customers_email_address']; ?></td> <td class="dataTableContent" align="right"><?php echo tep_date_short($info['date_account_created']); ?></td> <td class="dataTableContent" align="right"><?php if (isset($cInfo) && is_object($cInfo) && ($customers['customers_id'] == $cInfo->customers_id)) { echo tep_image(DIR_WS_IMAGES . 'icon_arrow_right.gif', ''); } else { echo '<a href="' . tep_href_link(FILENAME_CUSTOMERS, tep_get_all_get_params(array('cID')) . 'cID=' . $customers['customers_id']) . '">' . tep_image(DIR_WS_IMAGES . 'icon_info.gif', IMAGE_ICON_INFO) . '</a>'; } ?> </td> </tr> <?php } ?> <tr> <td colspan="4"><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td class="smallText" valign="top"><?php echo $customers_split->display_count($customers_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, $HTTP_GET_VARS['page'], TEXT_DISPLAY_NUMBER_OF_CUSTOMERS); ?></td> <td class="smallText" align="right"><?php echo $customers_split->display_links($customers_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, MAX_DISPLAY_PAGE_LINKS, $HTTP_GET_VARS['page'], tep_get_all_get_params(array('page', 'info', 'x', 'y', 'cID'))); ?></td> </tr> <?php if (isset($HTTP_GET_VARS['search']) && tep_not_null($HTTP_GET_VARS['search'])) { ?> <tr> <td class="smallText" align="right" colspan="2"><?php echo tep_draw_button(IMAGE_RESET, 'arrowrefresh-1-w', tep_href_link(FILENAME_CUSTOMERS)); ?></td> </tr> <?php } ?> </table></td> </tr> </table></td> <?php $heading = array(); $contents = array(); switch ($action) { case 'confirm': $heading[] = array('text' => '<strong>' . TEXT_INFO_HEADING_DELETE_CUSTOMER . '</strong>'); $contents = array('form' => tep_draw_form('customers', FILENAME_CUSTOMERS, tep_get_all_get_params(array('cID', 'action')) . 'cID=' . $cInfo->customers_id . '&action=deleteconfirm')); $contents[] = array('text' => TEXT_DELETE_INTRO . '<br /><br /><strong>' . $cInfo->customers_firstname . ' ' . $cInfo->customers_lastname . '</strong>'); if (isset($cInfo->number_of_reviews) && ($cInfo->number_of_reviews) > 0) $contents[] = array('text' => '<br />' . tep_draw_checkbox_field('delete_reviews', 'on', true) . ' ' . sprintf(TEXT_DELETE_REVIEWS, $cInfo->number_of_reviews)); $contents[] = array('align' => 'center', 'text' => '<br />' . tep_draw_button(IMAGE_DELETE, 'trash', null, 'primary') . tep_draw_button(IMAGE_CANCEL, 'close', tep_href_link(FILENAME_CUSTOMERS, tep_get_all_get_params(array('cID', 'action')) . 'cID=' . $cInfo->customers_id))); break; case 'deladdress': $heading[] = array('text' => '<strong>' . TEXT_DELETE_ADDRESS . '</strong>'); if (isset($HTTP_GET_VARS['aid']) && (!in_array($address_id, array($cInfo->customers_default_address_id, $cInfo->customers_default_billing_address_id, $cInfo->customers_default_shipping_address_id)))) { // if not default address $contents = array('form' => tep_draw_form('customersaddress', FILENAME_CUSTOMERS, tep_get_all_get_params(array('cID', 'action','aid')) . 'cID=' . $cInfo->customers_id . '&action=confirmaddressdelete&aid=' . $address_id)); $contents[] = array('text' => TEXT_DELETE_ADDRESS_INTRO . '<br /><br /><strong>' . $cInfo->customers_firstname . ' ' . $cInfo->customers_lastname . '</strong><br /><br />' . address_label($cInfo->customers_id, $address_id)); $contents[] = array('align' => 'center', 'text' => '<br />' . tep_draw_button(IMAGE_DELETE, 'trash') . tep_draw_button(IMAGE_CANCEL, 'cancel', tep_href_link(FILENAME_CUSTOMERS, tep_get_all_get_params(array('cID', 'action')) . 'action=edit&cID=' . $cInfo->customers_id), 'primary')); } else { $contents[] = array('text' => '<strong>' . TEXT_DELETE_ADDRESS_ERROR . '<strong><br />'); $contents[] = array('align' => 'center', 'text' => tep_draw_button(IMAGE_CANCEL, 'cancel', tep_href_link(FILENAME_CUSTOMERS, tep_get_all_get_params(array('cID', 'action')) . 'action=edit&cID=' . $cInfo->customers_id), 'primary')); } break; default: if (isset($cInfo) && is_object($cInfo)) { $heading[] = array('text' => '<strong>' . $cInfo->customers_firstname . ' ' . $cInfo->customers_lastname . '</strong>'); $contents[] = array('align' => 'center', 'text' => tep_draw_button(IMAGE_EDIT, 'document', tep_href_link(FILENAME_CUSTOMERS, tep_get_all_get_params(array('cID', 'action')) . 'cID=' . $cInfo->customers_id . '&action=edit')) . tep_draw_button(IMAGE_DELETE, 'trash', tep_href_link(FILENAME_CUSTOMERS, tep_get_all_get_params(array('cID', 'action')) . 'cID=' . $cInfo->customers_id . '&action=confirm')) . tep_draw_button(IMAGE_ORDERS, 'cart', tep_href_link(FILENAME_ORDERS, 'cID=' . $cInfo->customers_id)) . tep_draw_button(IMAGE_EMAIL, 'mail-closed', tep_href_link(FILENAME_MAIL, 'customer=' . $cInfo->customers_email_address)) . tep_draw_button(BUTTON_NEW_PWD, 'key', tep_href_link(FILENAME_CUSTOMERS, tep_get_all_get_params(array('cID', 'action')) . 'cID=' . $cInfo->customers_id . '&action=newpwd'))); $contents[] = array('text' => '<br />' . TEXT_DATE_ACCOUNT_CREATED . ' ' . tep_date_short($cInfo->date_account_created)); $contents[] = array('text' => '<br />' . TEXT_DATE_ACCOUNT_LAST_MODIFIED . ' ' . tep_date_short($cInfo->date_account_last_modified)); $contents[] = array('text' => '<br />' . TEXT_INFO_DATE_LAST_LOGON . ' ' . tep_date_short($cInfo->date_last_logon)); $contents[] = array('text' => '<br />' . TEXT_INFO_NUMBER_OF_LOGONS . ' ' . $cInfo->number_of_logons); $query = tep_db_query("select count(orders_id) as total from " . TABLE_ORDERS . " where customers_id = " . (int)$cInfo->customers_id); $orders = tep_db_fetch_array($query); $contents[] = array('text' => TEXT_INFO_NUMBER_OF_ORDERS . ' ' . $orders['total']); $contents[] = array('text' => '<br />' . TEXT_INFO_COUNTRY . ' ' . $cInfo->countries_name); $contents[] = array('text' => '<br />' . TEXT_INFO_NUMBER_OF_REVIEWS . ' ' . $cInfo->number_of_reviews); // FWR TAX EXEMPT $org_type_query = tep_db_query("select org_type_title from " . TABLE_ORGANIZATION_TYPE . " where org_type_id=" . $cInfo->customers_org_type); $org_type_row = tep_db_fetch_array($org_type_query); $contents[] = array('text' => '<br>' . TEXT_INFO_ORGANIZATION_TYPE . ' ' . $org_type_row['org_type_title']); // END FWR TAX EXEMPT $defaults = array_unique(array($cInfo->customers_default_address_id, $cInfo->customers_default_billing_address_id, $cInfo->customers_default_shipping_address_id)); foreach ($defaults as $id) { $text = '<br /><em>'; if ($id == $cInfo->customers_default_address_id) $text .= TEXT_DEFAULT . TEXT_MAILING . '<br />'; if ($id == $cInfo->customers_default_billing_address_id) $text .= TEXT_DEFAULT . TEXT_BILLING . '<br />'; if ($id == $cInfo->customers_default_shipping_address_id) $text .= TEXT_DEFAULT . TEXT_SHIPPING . '<br />'; $contents[] = array('text' => $text . '</em>' . address_label($cInfo->customers_id, $id)); } } break; } if ( (tep_not_null($heading)) && (tep_not_null($contents)) ) { echo ' <td width="25%" valign="top">' . "\n"; $box = new box; echo $box->infoBox($heading, $contents); echo ' </td>' . "\n"; } ?> </tr> </table></td> </tr> <?php } ?> </table> <?php require(DIR_WS_INCLUDES . 'template_bottom.php'); require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

Hello, I am working with the Advanced Address Management Add on and Purchase Without Account and the both alter the create_account.php file. I installed PWA before the Address Management. I cannot get the PWA to work correctly anymore for the create_account.php file. I am wondering if i can just change the login.php page to point to a new create_account page called without_account.php, instead of going the the new create_account.php page where Address Management addon has been added. I tried to configure the PWA to work correctly but it's just not working for create_account.php. I figured I could just use the old create_account page and rename it to without_account.php and direct it there. The code I am trying to alter is <?php echo tep_draw_button(IMAGE_BUTTON_CHECKOUT, 'triangle-1-e', tep_href_link(FILENAME_CREATE_ACCOUNT, 'guest=guest', 'SSL'), 'primary'); ?> I replace it with <?php echo tep_draw_button(IMAGE_BUTTON_CHECKOUT, 'triangle-1-e', tep_href_link(FILENAME_WITHOUT_ACCOUNT, 'guest=guest', 'SSL'), 'primary'); ?> I go refresh the page and click the button and a 404 error happens. It's not outputting without_account.php in the link. It shows FILENAME_WITHOUT_ACCOUNT?guest=guest There must be a place I can define FILENAME_WITHOUT_ACCOUNT. I'm looking everywhere for FILENAME_CREATE_ACCOUNT. I've checked login.php in languages and could not find it.

It was a css error that I corrected. I just don't understand why I was getting those parse errors when I was just refreshing the page after editing some php code. Once I got the error I would refresh the page again and it not display the error again.

Hello, I just installed the Advanced Address Management add on and while I was testing it on the create_account.php page the submit button at the bottom of the form does not show up. Also the Password text is cut off on the right. I think it has to do with css code but I'm not sure. Sometimes when I change the code and save it, then do a refresh I get a syntax parse error unexpected end of file but when I refresh again it goes away. I'm pretty perplexed.

It works!

I'm having an issue with one of the modifications. 16.in catalog/includes/header.php ***FIND: <?php echo tep_draw_button(HEADER_TITLE_CART_CONTENTS . ($cart->count_contents() > 0 ? ' (' . $cart->count_contents() . ')' : ''), 'cart', tep_href_link(FILENAME_SHOPPING_CART)) . tep_draw_button(HEADER_TITLE_CHECKOUT, 'triangle-1-e', tep_href_link(FILENAME_CHECKOUT_SHIPPING, '', 'SSL')) . tep_draw_button(HEADER_TITLE_MY_ACCOUNT, 'person', tep_href_link(FILENAME_ACCOUNT, '', 'SSL')); if (tep_session_is_registered('customer_id')) { echo tep_draw_button(HEADER_TITLE_LOGOFF, null, tep_href_link(FILENAME_LOGOFF, '', 'SSL')); } ?> ***REPLACE WITH: <!-- PWA BOF --> <?php if (tep_session_is_registered('customer_id')) { ?><a href="<?php echo tep_href_link(FILENAME_LOGOFF, '', 'SSL'); ?>" class="headerNavigation"><?php echo HEADER_TITLE_LOGOFF; ?></a> | <?php } ?><?php if (tep_session_is_registered('customer_id') && (!isset($HTTP_GET_VARS['guest']) && !isset($HTTP_POST_VARS['guest'])) && !$order->customer['is_dummy_account']) { ?><a href="<?php echo tep_href_link(FILENAME_ACCOUNT, '', 'SSL'); ?>" class="headerNavigation"><?php echo HEADER_TITLE_MY_ACCOUNT; ?></a> | <?php } ?><a href="<?php echo tep_href_link(FILENAME_SHOPPING_CART); ?>" class="headerNavigation"><?php echo HEADER_TITLE_CART_CONTENTS; ?></a> | <a href="<?php echo tep_href_link(FILENAME_CHECKOUT_SHIPPING, '', 'SSL'); ?>" class="headerNavigation"><?php echo HEADER_TITLE_CHECKOUT; ?></a> <!-- PWA EOF --> Yet in catalog/includes/header.php there is no find for what's asked for. Where should I put the replacement code? I am using a template as well so that's probably what's causing this issue I imagine. I was just thinking about placing the modification at the top. header.php <?php if (isset($HTTP_GET_VARS['error_message']) && tep_not_null($HTTP_GET_VARS['error_message'])) { ?> <div> <div class="headerError"> <div class="headerError"><?php echo htmlspecialchars(stripslashes(urldecode($HTTP_GET_VARS['error_message']))); ?></div> </div> </div> <?php } if (isset($HTTP_GET_VARS['info_message']) && tep_not_null($HTTP_GET_VARS['info_message'])) { ?> <div> <div class="headerInfo"> <div class="headerInfo"><?php echo htmlspecialchars(stripslashes(urldecode($HTTP_GET_VARS['info_message']))); ?></div> </div> </div> <?php } ?> <link rel="shortcut icon" href="includes/favicon.ico">

This is great. Looks like most of it is the same edits so I didn't have to restore a backup and start over. Keeping fingers crossed. Thanks for the help again!

Yes, thank you. After manually installing the other add on I came to a dead end where the instructions ask to alter a column_right.php file yet there is no column_right.php file. I should have known a plugin that's nearly 4 years old and says 2.2 with no info given on 2.3 would not work. I'll give this one a go. Thanks!