Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Customer Number?


yanos

Recommended Posts

not to sure what you mean by this? sorry

Check out the add ons in the contributions area (community tab at top of page, then contributions).

Link to comment
Share on other sites

When i run:

 

ALTER TABLE `adress_book` ADD `entry_acct` VARCHAR( 32 ) DEFAULT NULL AFTER `entry_gender` ;

 

in the sql querie window i get this error messege:

 

#1146 - Table 'posterhoster.adress_book' doesn't exist

 

 

anyone know whats happninig here?

Link to comment
Share on other sites

When i run:

 

ALTER TABLE `adress_book` ADD `entry_acct` VARCHAR( 32 ) DEFAULT NULL AFTER `entry_gender` ;

 

in the sql querie window i get this error messege:

 

#1146 - Table 'posterhoster.adress_book' doesn't exist

 

 

anyone know whats happninig here?

Try

 

ALTER TABLE `address_book` ADD `entry_acct` VARCHAR( 32 ) DEFAULT NULL AFTER `entry_gender` ;

Link to comment
Share on other sites

in the admin controlled text file i have go to this part and cannot find this section in the code, has anyone else added this contribution? has the code been changed since this contribution was made?

 

 

Around line 253 find this:

 

if ($HTTP_GET_VARS['action'] == 'edit') {

$customers_query = tep_db_query("select c.customers_gender, c.customers_firstname, c.customers_lastname, 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);

 

Change it to this:

 

if ($HTTP_GET_VARS['action'] == 'edit') {

$customers_query = tep_db_query("select c.customers_gender, c.customers_firstname, c.customers_lastname, c.customers_dob, c.customers_email_address, a.entry_acct, 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);

//added a.entry_acct to query

Link to comment
Share on other sites

  • 1 month later...

I'm still having trouble with adding the customer number contribution. is there anyone who can do this? i am willing to pay for this to be done as i need it added to my site.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...