Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

spencermjax

Pioneers
  • Posts

    354
  • Joined

  • Last visited

Posts posted by spencermjax

  1. -OScommerce payment module (COCARD)-

     

    I have an existing oscommerce site using Authorize.net

     

    My client has changed gateway merchants to COCARD (cocard.net)

     

    I have Gateway API Documentation and sample code available for COCARD.

     

    any ideas on where would be the fastest place to get a payment module created for this?

  2. I just don't understand how so many people can have so many problems with this. It should be pretty straight forward to give the proper instructions to get it set up.

     

    I am getting the same errors (your card cannot be processed for this reason..." ) but my page seems to load forever before giving me the error. If anyone is willing to get it working for me please let me know ( $$ ) I just do not have the time to do it.

  3. well, That issue seems to be fixed????? I think it may have had to do with my Sessions settings. I changed those up and it seems to be fine now. Before, When I looked at who was on line I was listed there about 8 times.

     

    Now my new problem is that when I have items in my cart, if I log out, then log in again, it will delete all but o1 or 2 of the items I had in the cart.

     

    This never ends! Any thoughts on this?

  4. I have SPPC installed and when I use a text area option, it shows the retail price for that text area But when I am logged in as a wholesaler, the price that shows is still the retail price.

     

    It functions properly, it adds the correct wholesale attribute price, it just doesn't show the correct group price.

     

    Anyone know how to fix this?

  5. I believe I may be having an MYSQL 5 problem.

     

    ERROR:

    Warning: reset() [function.reset]: Passed variable is not an array or object in /home/onsmedia/public_html/products/admin/includes/classes/object_info.php on line 17

     

    Warning: Variable passed to each() is not an array or object in /home/onsmedia/public_html/products/admin/includes/classes/object_info.php on line 18

     

     

     

     

    I found another post that said to do this:

    change this:

    $customers = tep_db_fetch_array($customers_query);

    $cInfo = new objectInfo($customers);

     

    to this:

    $customer_info = array_merge((array)$country, (array)$info, (array)$reviews);

    $cInfo_array = array_merge((array)$customers, (array)$customer_info);

     

     

    the problem is , when I make the change, if I click on a member and click edit or activate, the fields are blank

  6. Has anyone had this problem....

     

    I am installing PWA in a store with SPPC, Member approval, hide categories. The problem is when I go from the shopping cart to checkout, it directs me to the login page...so far so good.....I then select to checkout without an account and it directs me to the modified create_account page...still so far so good......I fill out the form and click the continue button and I am redirected to the login page again. I have tried several versions of this mod and always the same problem.

     

    If it helps, here is my create_account.php page:

     

    <?php
    /*
     $Id: create_account.php,v 1.65 2003/06/09 23:03:54 hpdl Exp $
     adapted for Separate Pricing Per Customer 2007/08/04
    
     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');
    
    // PWA EOF
     if (isset($HTTP_GET_VARS['guest']) && $cart->count_contents() < 1) tep_redirect(tep_href_link(FILENAME_SHOPPING_CART));
    // PWA BOF
    
    // needs to be included earlier to set the success message in the messageStack
     require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_CREATE_ACCOUNT);
    
     $process = false;
     if (isset($HTTP_POST_VARS['action']) && ($HTTP_POST_VARS['action'] == 'process')) {
    $process = true;
    
    if (ACCOUNT_GENDER == 'true') {
      if (isset($HTTP_POST_VARS['gender'])) {
    	$gender = tep_db_prepare_input($HTTP_POST_VARS['gender']);
      } else {
    	$gender = false;
      }
    }
    $firstname = tep_db_prepare_input($HTTP_POST_VARS['firstname']);
    $lastname = tep_db_prepare_input($HTTP_POST_VARS['lastname']);
    if (ACCOUNT_DOB == 'true') $dob = tep_db_prepare_input($HTTP_POST_VARS['dob']);
    $email_address = tep_db_prepare_input($HTTP_POST_VARS['email_address']);
    // BOF Separate Pricing Per Customer, added: field for tax id number
    if (ACCOUNT_COMPANY == 'true') {
    $company = tep_db_prepare_input($_POST['company']);
    $company_tax_id = tep_db_prepare_input($_POST['company_tax_id']);
    }
    // EOF Separate Pricing Per Customer, added: field for tax id number
    $street_address = tep_db_prepare_input($HTTP_POST_VARS['street_address']);
    if (ACCOUNT_SUBURB == 'true') $suburb = tep_db_prepare_input($HTTP_POST_VARS['suburb']);
    $postcode = tep_db_prepare_input($HTTP_POST_VARS['postcode']);
    $city = tep_db_prepare_input($HTTP_POST_VARS['city']);
    if (ACCOUNT_STATE == 'true') {
      $state = tep_db_prepare_input($HTTP_POST_VARS['state']);
      if (isset($HTTP_POST_VARS['zone_id'])) {
    	$zone_id = tep_db_prepare_input($HTTP_POST_VARS['zone_id']);
      } else {
    	$zone_id = false;
      }
    }
    $country = tep_db_prepare_input($HTTP_POST_VARS['country']);
    $telephone = tep_db_prepare_input($HTTP_POST_VARS['telephone']);
    $fax = tep_db_prepare_input($HTTP_POST_VARS['fax']);
    if (isset($HTTP_POST_VARS['newsletter'])) {
      $newsletter = tep_db_prepare_input($HTTP_POST_VARS['newsletter']);
    } else {
      $newsletter = false;
    }
    $password = tep_db_prepare_input($HTTP_POST_VARS['password']);
    $confirmation = tep_db_prepare_input($HTTP_POST_VARS['confirmation']);
    
    $error = false;
    
    if (ACCOUNT_GENDER == 'true') {
      if ( ($gender != 'm') && ($gender != 'f') ) {
    	$error = true;
    
    	$messageStack->add('create_account', ENTRY_GENDER_ERROR);
      }
    }
    
    if (strlen($firstname) < ENTRY_FIRST_NAME_MIN_LENGTH) {
      $error = true;
    
      $messageStack->add('create_account', ENTRY_FIRST_NAME_ERROR);
    }
    
    if (strlen($lastname) < ENTRY_LAST_NAME_MIN_LENGTH) {
      $error = true;
    
      $messageStack->add('create_account', ENTRY_LAST_NAME_ERROR);
    }
    
    if (ACCOUNT_DOB == 'true') {
      if (checkdate(substr(tep_date_raw($dob), 4, 2), substr(tep_date_raw($dob), 6, 2), substr(tep_date_raw($dob), 0, 4)) == false) {
    	$error = true;
    
    	$messageStack->add('create_account', ENTRY_DATE_OF_BIRTH_ERROR);
      }
    }
    
    if (strlen($email_address) < ENTRY_EMAIL_ADDRESS_MIN_LENGTH) {
      $error = true;
    
      $messageStack->add('create_account', ENTRY_EMAIL_ADDRESS_ERROR);
    } elseif (tep_validate_email($email_address) == false) {
      $error = true;
    
      $messageStack->add('create_account', ENTRY_EMAIL_ADDRESS_CHECK_ERROR);
    } else {
      $check_email_query = tep_db_query("select count(*) as total from " . TABLE_CUSTOMERS . " where customers_email_address = '" . tep_db_input($email_address) . "'");
      $check_email = tep_db_fetch_array($check_email_query);
      if ($check_email['total'] > 0) {
    	$error = true;
    
    	$messageStack->add('create_account', ENTRY_EMAIL_ADDRESS_ERROR_EXISTS);
      }
    }
    
    if (strlen($street_address) < ENTRY_STREET_ADDRESS_MIN_LENGTH) {
      $error = true;
    
      $messageStack->add('create_account', ENTRY_STREET_ADDRESS_ERROR);
    }
    
    if (strlen($postcode) < ENTRY_POSTCODE_MIN_LENGTH) {
      $error = true;
    
      $messageStack->add('create_account', ENTRY_POST_CODE_ERROR);
    }
    
    if (strlen($city) < ENTRY_CITY_MIN_LENGTH) {
      $error = true;
    
      $messageStack->add('create_account', ENTRY_CITY_ERROR);
    }
    
    if (is_numeric($country) == false) {
      $error = true;
    
      $messageStack->add('create_account', ENTRY_COUNTRY_ERROR);
    }
    
    if (ACCOUNT_STATE == 'true') {
      $zone_id = 0;
      $check_query = tep_db_query("select count(*) as total from " . TABLE_ZONES . " where zone_country_id = '" . (int)$country . "'");
      $check = tep_db_fetch_array($check_query);
      $entry_state_has_zones = ($check['total'] > 0);
      if ($entry_state_has_zones == true) {
    	$zone_query = tep_db_query("select distinct zone_id from " . TABLE_ZONES . " where zone_country_id = '" . (int)$country . "' and (zone_name = '" . tep_db_input($state) . "' or zone_code = '" . tep_db_input($state) . "')");
    	if (tep_db_num_rows($zone_query) == 1) {
    	  $zone = tep_db_fetch_array($zone_query);
    	  $zone_id = $zone['zone_id'];
    	} else {
    	  $error = true;
    
    	  $messageStack->add('create_account', ENTRY_STATE_ERROR_SELECT);
    	}
      } else {
    	if (strlen($state) < ENTRY_STATE_MIN_LENGTH) {
    	  $error = true;
    
    	  $messageStack->add('create_account', ENTRY_STATE_ERROR);
    	}
      }
    }
    
    if (strlen($telephone) < ENTRY_TELEPHONE_MIN_LENGTH) {
      $error = true;
    
      $messageStack->add('create_account', ENTRY_TELEPHONE_NUMBER_ERROR);
    }
    
    // PWA BOF
    if (!isset($HTTP_GET_VARS['guest']) && !isset($HTTP_POST_VARS['guest'])) {
    // PWA EOF
    
    if (strlen($password) < ENTRY_PASSWORD_MIN_LENGTH) {
      $error = true;
    
      $messageStack->add('create_account', ENTRY_PASSWORD_ERROR);
    } elseif ($password != $confirmation) {
      $error = true;
    
      $messageStack->add('create_account', ENTRY_PASSWORD_ERROR_NOT_MATCHING);
    }
    // PWA BOF
    } 
    // PWA EOF
    
    if ($error == false) {
      $sql_data_array = array('customers_firstname' => $firstname,
    						  'customers_lastname' => $lastname,
    						  'customers_email_address' => $email_address,
    						  'customers_telephone' => $telephone,
    						  'customers_fax' => $fax,
    						  'customers_newsletter' => $newsletter,
    						  'customers_password' => tep_encrypt_password($password),
    							   'customers_language_id' => $languages_id);
    
      if (ACCOUNT_GENDER == 'true') $sql_data_array['customers_gender'] = $gender;
      if (ACCOUNT_DOB == 'true') $sql_data_array['customers_dob'] = tep_date_raw($dob);
      // BOF Separate Pricing Per Customer
      // if you would like to have an alert in the admin section when either a company name has been entered in
      // the appropriate field or a tax id number, or both then uncomment the next line and comment the default
      // setting: only alert when a tax_id number has been given
      if ( (ACCOUNT_COMPANY == 'true' && tep_not_null($company) ) || (ACCOUNT_COMPANY == 'true' && tep_not_null($company_tax_id) ) ) { 
     // if ( ACCOUNT_COMPANY == 'true' && tep_not_null($company_tax_id)  ) { 
      $sql_data_array['customers_group_ra'] = '1';
    // entry_company_tax_id moved from table address_book to table customers in version 4.2.0
      $sql_data_array['entry_company_tax_id'] = $company_tax_id; 
    }
    // EOF Separate Pricing Per Customer
    
    // PWA BOF
      if ((isset($HTTP_GET_VARS['guest'])) or (isset($HTTP_POST_VARS['guest'])) && (defined('PURCHASE_WITHOUT_ACCOUNT') && (PURCHASE_WITHOUT_ACCOUNT == 'ja' || PURCHASE_WITHOUT_ACCOUNT == 'yes'))) {
    	$pwa_array_customer = $sql_data_array;
    	$customer_id = 0;
    	tep_session_register('pwa_array_customer');
      } else {
    // PWA EOF
      tep_db_perform(TABLE_CUSTOMERS, $sql_data_array);
    
      $customer_id = tep_db_insert_id();
    
    // PWA BOF
    } 
    // PWA EOF
    
      $sql_data_array = array('customers_id' => $customer_id,
    						  'entry_firstname' => $firstname,
    						  'entry_lastname' => $lastname,
    						  'entry_street_address' => $street_address,
    						  'entry_postcode' => $postcode,
    						  'entry_city' => $city,
    						  'entry_country_id' => $country);
    
      if (ACCOUNT_GENDER == 'true') $sql_data_array['entry_gender'] = $gender;
      if (ACCOUNT_COMPANY == 'true') { // BOF adapted for Separate Pricing Per Customer
      $sql_data_array['entry_company'] = $company;
      $sql_data_array['entry_company_tax_id'] = $company_tax_id;
      } // EOF adapted for Separate Pricing Per Customer
      if (ACCOUNT_SUBURB == 'true') $sql_data_array['entry_suburb'] = $suburb;
      if (ACCOUNT_STATE == 'true') {
    	if ($zone_id > 0) {
    	  $sql_data_array['entry_zone_id'] = $zone_id;
    	  $sql_data_array['entry_state'] = '';
    	} else {
    	  $sql_data_array['entry_zone_id'] = '0';
    	  $sql_data_array['entry_state'] = $state;
    	}
      }
    
    // PWA BOF
     if (isset($HTTP_GET_VARS['guest']) or isset($HTTP_POST_VARS['guest'])) {
       $pwa_array_address = $sql_data_array;
       tep_session_register('pwa_array_address');
       $address_id = 0;
     } else {
    // PWA EOF
    
      tep_db_perform(TABLE_ADDRESS_BOOK, $sql_data_array);
    
      $address_id = tep_db_insert_id();
    
      tep_db_query("update " . TABLE_CUSTOMERS . " set customers_default_address_id = '" . (int)$address_id . "' where customers_id = '" . (int)$customer_id . "'");
    
      tep_db_query("insert into " . TABLE_CUSTOMERS_INFO . " (customers_info_id, customers_info_number_of_logons, customers_info_date_account_created) values ('" . (int)$customer_id . "', '0', now())");
    
    // PWA BOF
    } 
    // PWA EOF
    
      if (SESSION_RECREATE == 'True') {
    	tep_session_recreate();
      }
    // BOF Separate Pricing Per Customer
    // register SPPC session variables for the new customer
    // if there is code above that puts new customers directly into another customer group (default is retail)
    // then the below code need not be changed, it uses the newly inserted customer group
      $check_customer_group_info = tep_db_query("select c.customers_group_id, cg.customers_group_show_tax, cg.customers_group_tax_exempt, cg.group_specific_taxes_exempt from " . TABLE_CUSTOMERS . " c left join " . TABLE_CUSTOMERS_GROUPS . " cg using(customers_group_id) where c.customers_id = '" . $customer_id . "'");
      $customer_group_info = tep_db_fetch_array($check_customer_group_info);
      $sppc_customer_group_id = $customer_group_info['customers_group_id'];
      $sppc_customer_group_show_tax = (int)$customer_group_info['customers_group_show_tax'];
      $sppc_customer_group_tax_exempt = (int)$customer_group_info['customers_group_tax_exempt'];
      $sppc_customer_specific_taxes_exempt = '';
      if (tep_not_null($customer_group_info['group_specific_taxes_exempt'])) {
    	$sppc_customer_specific_taxes_exempt = $customer_group_info['group_specific_taxes_exempt'];
      }
    // EOF Separate Pricing Per Customer
    
      $customer_first_name = $firstname;
      $customer_default_address_id = $address_id;
      $customer_country_id = $country;
      $customer_zone_id = $zone_id;
     // tep_session_register('customer_id');
      //tep_session_register('customer_first_name');
      //tep_session_register('customer_default_address_id');
      //tep_session_register('customer_country_id');
      //tep_session_register('customer_zone_id');
    // BOF Separate Pricing Per Customer
      tep_session_register('sppc_customer_group_id');
      tep_session_register('sppc_customer_group_show_tax');
      tep_session_register('sppc_customer_group_tax_exempt');
      tep_session_register('sppc_customer_specific_taxes_exempt');
    // EOF Separate Pricing Per Customer
    // PWA BOF
      if (isset($HTTP_GET_VARS['guest']) or isset($HTTP_POST_VARS['guest'])) tep_redirect(tep_href_link(FILENAME_CHECKOUT_SHIPPING));
    // PWA EOF
    
    // restore cart contents
     // $cart->restore_contents();
    
    // build the message content
      $name = $firstname . ' ' . $lastname;
    
      if (ACCOUNT_GENDER == 'true') {
    	 if ($gender == 'm') {
    	   $email_text = sprintf(EMAIL_GREET_MR, $lastname);
    	 } else {
    	   $email_text = sprintf(EMAIL_GREET_MS, $lastname);
    	 }
      } else {
      $email_text = sprintf(EMAIL_GREET_NONE, $firstname);
    }
     //}
    // customer email notification 
    $email_text .= EMAIL_WELCOME . EMAIL_TEXT . EMAIL_CONTACT . EMAIL_WARNING;
    tep_mail($name, $email_address, EMAIL_SUBJECT, nl2br($email_text), STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS);
    
    
    
    // BOF Separate Pricing Per Customer: alert shop owner of account created by a company
    // if you would like to have an email when either a company name has been entered in
    // the appropriate field or a tax id number, or both then uncomment the next line and comment the default
    // setting: only email when a tax_id number has been given
    if ( (ACCOUNT_COMPANY == 'true' && tep_not_null($company) ) || (ACCOUNT_COMPANY == 'true' && tep_not_null($company_tax_id) ) ) {
     // if ( ACCOUNT_COMPANY == 'true' && tep_not_null($company_tax_id) ) {
      $alert_email_text = "Please note that " . $firstname . " " . $lastname . " of the company: " . $company . " has created an account.";
      tep_mail(STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS, 'Company account created', $alert_email_text, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS);
      }
    // EOF Separate Pricing Per Customer: alert shop owner of account created by a company
    
      tep_redirect(tep_href_link(FILENAME_CREATE_ACCOUNT_SUCCESS, '', 'SSL'));
    }
     }
    
    // PWA BOF
     if (tep_session_is_registered('pwa_array_customer') && tep_session_is_registered('pwa_array_address')) {
    $gender = isset($pwa_array_customer['customers_gender'])?$pwa_array_customer['customers_gender']:'';
    $company = isset($pwa_array_address['entry_company'])? $pwa_array_address['entry_company']:'';
    $firstname = isset($pwa_array_customer['customers_firstname'])? $pwa_array_customer['customers_firstname']:'';
    $lastname = isset($pwa_array_customer['customers_lastname'])? $pwa_array_customer['customers_lastname']:'';
    $dob = isset($pwa_array_customer['customers_dob'])? substr($pwa_array_customer['customers_dob'],-2).'.'.substr($pwa_array_customer['customers_dob'],4,2).'.'.substr($pwa_array_customer['customers_dob'],0,4):'';
    $email_address = isset($pwa_array_customer['customers_email_address'])? $pwa_array_customer['customers_email_address']:'';
    $street_address = isset($pwa_array_address['entry_street_address'])? $pwa_array_address['entry_street_address']:'';
    $suburb = isset($pwa_array_address['entry_suburb'])? $pwa_array_address['entry_suburb']:'';
    $postcode = isset($pwa_array_address['entry_postcode'])? $pwa_array_address['entry_postcode']:'';
    $city = isset($pwa_array_address['entry_city'])? $pwa_array_address['entry_city']:'';
    $state = isset($pwa_array_address['entry_state'])? $pwa_array_address['entry_state']:'0';
    $country = isset($pwa_array_address['entry_country_id'])? $pwa_array_address['entry_country_id']:'';
    $telephone = isset($pwa_array_customer['customers_telephone'])? $pwa_array_customer['customers_telephone']:'';
    $fax = isset($pwa_array_customer['customers_fax'])? $pwa_array_customer['customers_fax']:'';
     }
    // PWA EOF
    
     $breadcrumb->add(NAVBAR_TITLE, tep_href_link(FILENAME_CREATE_ACCOUNT, '', 'SSL'));
    ?>
    <!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">
    <html <?php echo HTML_PARAMS; ?>>
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">
    <?php require(DIR_WS_INCLUDES . 'meta_tags.php'); ?>
    <title><?php echo META_TAG_TITLE; ?></title>
    <meta name="description" content="<?php echo META_TAG_DESCRIPTION; ?>">
    <meta name="keywords" content="<?php echo META_TAG_KEYWORDS; ?>">
    <base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>">
    <link rel="stylesheet" type="text/css" href="stylesheet.css">
    <?php require('includes/form_check.js.php'); ?>
    </head>
    <body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0">
    <!-- header //-->
    <?php require(DIR_WS_INCLUDES . 'header.php'); ?>
    <!-- header_eof //-->
    
    <!-- body //-->
    <table border="0" width="100%" cellspacing="0" cellpadding="0">
     <tr>
    <!-- body_text //-->
    <!-- PWA BOF -->
    <td width="100%" valign="top"><?php echo tep_draw_form('create_account', tep_href_link(FILENAME_CREATE_ACCOUNT, (isset($HTTP_GET_VARS['guest'])? 'guest=guest':''), 'SSL'), 'post', 'onSubmit="return check_form(create_account);"') . tep_draw_hidden_field('action', 'process'); ?><table border="0" width="100%" cellspacing="0" cellpadding="0">
    <!-- PWA EOF -->
      <tr>
    	<td><table border="0" width="100%" cellspacing="0" cellpadding="0">
    	  <tr>
    		<td class="pageHeading"><?php echo HEADING_TITLE; ?></td>
    	  </tr>
    	</table></td>
      </tr>
      <tr>
    	<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
      </tr>
      <tr>
    	<td class="smallText"><br><?php echo sprintf(TEXT_ORIGIN_LOGIN, tep_href_link(FILENAME_LOGIN, tep_get_all_get_params(), 'SSL')); ?></td>
      </tr>
      <tr>
    	<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
      </tr>
    <?php
     if ($messageStack->size('create_account') > 0) {
    ?>
      <tr>
    	<td><?php echo $messageStack->output('create_account'); ?></td>
      </tr>
      <tr>
    	<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
      </tr>
    <?php
     }
    ?>
      <tr>
    	<td><table border="0" width="100%" cellspacing="0" cellpadding="2">
    	  <tr>
    		<td class="main"><b><?php echo CATEGORY_PERSONAL; ?></b></td>
    	   <td class="inputRequirement" align="right"><?php echo FORM_REQUIRED_INFORMATION; ?></td>
    	  </tr>
    	</table></td>
      </tr>
      <tr>
    	<td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox">
    	  <tr class="infoBoxContents">
    		<td><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 echo tep_draw_radio_field('gender', 'm') . '  ' . MALE . '  ' . tep_draw_radio_field('gender', 'f') . '  ' . FEMALE . ' ' . (tep_not_null(ENTRY_GENDER_TEXT) ? '<span class="inputRequirement">' . ENTRY_GENDER_TEXT . '</span>': ''); ?></td>
    		  </tr>
    <?php
     }
    ?>
    		  <tr>
    			<td class="main"><?php echo ENTRY_FIRST_NAME; ?></td>
    			<td class="main"><?php echo tep_draw_input_field('firstname') . ' ' . (tep_not_null(ENTRY_FIRST_NAME_TEXT) ? '<span class="inputRequirement">' . ENTRY_FIRST_NAME_TEXT . '</span>': ''); ?></td>
    		  </tr>
    		  <tr>
    			<td class="main"><?php echo ENTRY_LAST_NAME; ?></td>
    			<td class="main"><?php echo tep_draw_input_field('lastname') . ' ' . (tep_not_null(ENTRY_LAST_NAME_TEXT) ? '<span class="inputRequirement">' . ENTRY_LAST_NAME_TEXT . '</span>': ''); ?></td>
    		  </tr>
    <?php
     if (ACCOUNT_DOB == 'true') {
    ?>
    		  <tr>
    			<td class="main"><?php echo ENTRY_DATE_OF_BIRTH; ?></td>
    			<td class="main"><?php echo tep_draw_input_field('dob') . ' ' . (tep_not_null(ENTRY_DATE_OF_BIRTH_TEXT) ? '<span class="inputRequirement">' . ENTRY_DATE_OF_BIRTH_TEXT . '</span>': ''); ?></td>
    		  </tr>
    <?php
     }
    ?>
    		  <tr>
    			<td class="main"><?php echo ENTRY_EMAIL_ADDRESS; ?></td>
    			<td class="main"><?php echo tep_draw_input_field('email_address') . ' ' . (tep_not_null(ENTRY_EMAIL_ADDRESS_TEXT) ? '<span class="inputRequirement">' . ENTRY_EMAIL_ADDRESS_TEXT . '</span>': ''); ?></td>
    		  </tr>
    		</table></td>
    	  </tr>
    	</table></td>
      </tr>
    <?php
     if (ACCOUNT_COMPANY == 'true') {
    ?>
      <tr>
    	<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
      </tr>
      <tr>
    	<td class="main"><b><?php echo CATEGORY_COMPANY; ?></b></td>
      </tr>
      <tr>
    	<td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox">
    	  <tr class="infoBoxContents">
    		<td><table border="0" cellspacing="2" cellpadding="2">
    		  <tr>
    			<td class="main"><?php echo ENTRY_COMPANY; ?></td>
    			<td class="main"><?php echo tep_draw_input_field('company') . ' ' . (tep_not_null(ENTRY_COMPANY_TEXT) ? '<span class="inputRequirement">' . ENTRY_COMPANY_TEXT . '</span>': ''); ?></td>
    		  </tr>
    <!-- BOF Separate Pricing Per Customer: field for tax id number -->
    		  <tr>
    			<td class="main"><?php echo ENTRY_COMPANY_TAX_ID; ?></td>
    			<td class="main"><?php echo tep_draw_input_field('company_tax_id') . ' ' . (tep_not_null(ENTRY_COMPANY_TAX_ID_TEXT) ? '<span class="inputRequirement">' . ENTRY_COMPANY_TAX_ID_TEXT . '</span>': ''); ?></td>
    		  </tr>
    <!-- EOF Separate Pricing Per Customer: field for tax id number -->
    		</table></td>
    	  </tr>
    	</table></td>
      </tr>
    <?php
     }
    ?>
      <tr>
    	<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
      </tr>
      <tr>
    	<td class="main"><b><?php echo CATEGORY_ADDRESS; ?></b></td>
      </tr>
      <tr>
    	<td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox">
    	  <tr class="infoBoxContents">
    		<td><table border="0" cellspacing="2" cellpadding="2">
    		  <tr>
    			<td class="main"><?php echo ENTRY_STREET_ADDRESS; ?></td>
    			<td class="main"><?php echo tep_draw_input_field('street_address') . ' ' . (tep_not_null(ENTRY_STREET_ADDRESS_TEXT) ? '<span class="inputRequirement">' . ENTRY_STREET_ADDRESS_TEXT . '</span>': ''); ?></td>
    		  </tr>
    <?php
     if (ACCOUNT_SUBURB == 'true') {
    ?>
    		  <tr>
    			<td class="main"><?php echo ENTRY_SUBURB; ?></td>
    			<td class="main"><?php echo tep_draw_input_field('suburb') . ' ' . (tep_not_null(ENTRY_SUBURB_TEXT) ? '<span class="inputRequirement">' . ENTRY_SUBURB_TEXT . '</span>': ''); ?></td>
    		  </tr>
    <?php
     }
    ?>
    		  <tr>
    			<td class="main"><?php echo ENTRY_POST_CODE; ?></td>
    			<td class="main"><?php echo tep_draw_input_field('postcode') . ' ' . (tep_not_null(ENTRY_POST_CODE_TEXT) ? '<span class="inputRequirement">' . ENTRY_POST_CODE_TEXT . '</span>': ''); ?></td>
    		  </tr>
    		  <tr>
    			<td class="main"><?php echo ENTRY_CITY; ?></td>
    			<td class="main"><?php echo tep_draw_input_field('city') . ' ' . (tep_not_null(ENTRY_CITY_TEXT) ? '<span class="inputRequirement">' . ENTRY_CITY_TEXT . '</span>': ''); ?></td>
    		  </tr>
    <?php
     if (ACCOUNT_STATE == 'true') {
    ?>
    		  <tr>
    			<td class="main"><?php echo ENTRY_STATE; ?></td>
    			<td class="main">
    <?php
    if ($process == true) {
      if ($entry_state_has_zones == true) {
    	$zones_array = array();
    	$zones_query = tep_db_query("select zone_name from " . TABLE_ZONES . " where zone_country_id = '" . (int)$country . "' order by zone_name");
    	while ($zones_values = tep_db_fetch_array($zones_query)) {
    	  $zones_array[] = array('id' => $zones_values['zone_name'], 'text' => $zones_values['zone_name']);
    	}
    	echo tep_draw_pull_down_menu('state', $zones_array);
      } else {
    	echo tep_draw_input_field('state');
      }
    } else {
      echo tep_draw_input_field('state');
    }
    
    if (tep_not_null(ENTRY_STATE_TEXT)) echo ' <span class="inputRequirement">' . ENTRY_STATE_TEXT;
    ?>
    			</td>
    		  </tr>
    <?php
     }
    ?>
    		  <tr>
    			<td class="main"><?php echo ENTRY_COUNTRY; ?></td>
    			<td class="main"><?php echo tep_get_country_list('country') . ' ' . (tep_not_null(ENTRY_COUNTRY_TEXT) ? '<span class="inputRequirement">' . ENTRY_COUNTRY_TEXT . '</span>': ''); ?></td>
    		  </tr>
    		</table></td>
    	  </tr>
    	</table></td>
      </tr>
      <tr>
    	<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
      </tr>
      <tr>
    	<td class="main"><b><?php echo CATEGORY_CONTACT; ?></b></td>
      </tr>
      <tr>
    	<td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox">
    	  <tr class="infoBoxContents">
    		<td><table border="0" cellspacing="2" cellpadding="2">
    		  <tr>
    			<td class="main"><?php echo ENTRY_TELEPHONE_NUMBER; ?></td>
    			<td class="main"><?php echo tep_draw_input_field('telephone') . ' ' . (tep_not_null(ENTRY_TELEPHONE_NUMBER_TEXT) ? '<span class="inputRequirement">' . ENTRY_TELEPHONE_NUMBER_TEXT . '</span>': ''); ?></td>
    		  </tr>
    		  <tr>
    			<td class="main"><?php echo ENTRY_FAX_NUMBER; ?></td>
    			<td class="main"><?php echo tep_draw_input_field('fax') . ' ' . (tep_not_null(ENTRY_FAX_NUMBER_TEXT) ? '<span class="inputRequirement">' . ENTRY_FAX_NUMBER_TEXT . '</span>': ''); ?></td>
    		  </tr>
    		</table></td>
    	  </tr>
    	</table></td>
      </tr>
      <tr>
    	<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
      </tr>
    <?php
    // PWA BOF
     if (!isset($HTTP_GET_VARS['guest']) && !isset($HTTP_POST_VARS['guest'])) {
    // PWA EOF
    ?>
      <tr>
    	<td class="main"><b><?php echo CATEGORY_OPTIONS; ?></b></td>
      </tr>
      <tr>
    	<td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox">
    	  <tr class="infoBoxContents">
    		<td><table border="0" cellspacing="2" cellpadding="2">
    		  <tr>
    			<td class="main"><?php echo ENTRY_NEWSLETTER; ?></td>
    			<td class="main"><?php echo tep_draw_checkbox_field('newsletter', '1') . ' ' . (tep_not_null(ENTRY_NEWSLETTER_TEXT) ? '<span class="inputRequirement">' . ENTRY_NEWSLETTER_TEXT . '</span>': ''); ?></td>
    		  </tr>
    		</table></td>
    	  </tr>
    	</table></td>
      </tr>
      <tr>
    	<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
      </tr>
      <tr>
    	<td class="main"><b><?php echo CATEGORY_PASSWORD; ?></b></td>
      </tr>
      <tr>
    	<td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox">
    	  <tr class="infoBoxContents">
    		<td><table border="0" cellspacing="2" cellpadding="2">
    		  <tr>
    			<td class="main"><?php echo ENTRY_PASSWORD; ?></td>
    			<td class="main"><?php echo tep_draw_password_field('password') . ' ' . (tep_not_null(ENTRY_PASSWORD_TEXT) ? '<span class="inputRequirement">' . ENTRY_PASSWORD_TEXT . '</span>': ''); ?></td>
    		  </tr>
    		  <tr>
    			<td class="main"><?php echo ENTRY_PASSWORD_CONFIRMATION; ?></td>
    			<td class="main"><?php echo tep_draw_password_field('confirmation') . ' ' . (tep_not_null(ENTRY_PASSWORD_CONFIRMATION_TEXT) ? '<span class="inputRequirement">' . ENTRY_PASSWORD_CONFIRMATION_TEXT . '</span>': ''); ?></td>
    		  </tr>
    		</table></td>
    	  </tr>
    	</table></td>
      </tr>
    <?php
     // PWA BOF
     }
     else
     { // Ingo PWA Ende
    ?>
    <tr>
      <td><?php echo tep_draw_hidden_field('guest', 'guest'); ?></td>
    </tr>
    <?php } 
    // PWA EOF
    ?>
      <tr>
    	<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
      </tr>
      <tr>
    	<td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox">
    	  <tr class="infoBoxContents">
    		<td><table border="0" width="100%" cellspacing="0" cellpadding="2">
    		  <tr>
    			<td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>
    			<td><?php echo tep_image_submit('button_continue.gif', IMAGE_BUTTON_CONTINUE); ?></td>
    			<td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>
    		  </tr>
    		</table></td>
    	  </tr>
    	</table></td>
      </tr>
    </table></form></td>
    <!-- body_text_eof //-->
     </tr>
    </table>
    <!-- body_eof //-->
    
    <!-- footer //-->
    <?php include(DIR_WS_INCLUDES . 'footer.php'); ?>
    <!-- footer_eof //-->
    </body>
    </html>
    <?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

  7. I am having a problem. The problem is when someone was entering text into a text field and they used a comma, it produced an error. On the site I have SPPC (Separate Pricing Per Customer). There are no problems for not logged in and for accounts categorized as retailers but for the other account type (wholesaler) the error is still occurring.

     

    I typed in : Savannah November 12, 2006

     

    and got this error:

     

    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 '2006) and pg.customers_group_id = '2'' at line 1

     

    select pg.products_id, customers_group_price, products_price1, products_price2, products_price3, products_price4, products_price5, products_price6, products_price7, products_price8, products_price1_qty, products_price2_qty, products_price3_qty, products_price4_qty, products_price5_qty, products_price6_qty, products_price7_qty, products_price8_qty, products_qty_blocks from products_groups pg where pg.products_id in (209, 12 2006) and pg.customers_group_id = '2'

     

    [TEP STOP]

  8. I have a text box that is creating an error. The error is occurring when I type a comma into the text box (ex: atlanta, Ga or Smith, Jeff). Any ideas why this would be happening?

     

    Here is the error:

     

    1054 - Unknown column 'hhvs' in 'where clause'
    
    select pd.products_name, p.products_model, p.products_image, p.products_id, p.products_price, p.products_weight, p.products_quantity, p.products_price1, p.products_price2, p.products_price3, p.products_price4, p.products_price5, p.products_price6, p.products_price7, p.products_price8, p.products_price1_qty, p.products_price2_qty, p.products_price3_qty, p.products_price4_qty, p.products_price5_qty, p.products_price6_qty, p.products_price7_qty, p.products_price8_qty, p.products_qty_blocks, p.products_tax_class_id, NULL as specials_new_products_price from products_description pd, products p where p.products_status = '1' and p.products_id in (282, 282, 322, hhvs) and pd.products_id = p.products_id and pd.language_id = '1'
    
    [TEP STOP]

×
×
  • Create New...