Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

State not showing in account info-help


Recommended Posts

Well, I also have 2.1 and it's there alright. But it's not in Admin -> Configuration -> My Store, it's in Admin -> Configuration -> Customer details which is where I told you to look.

Link to comment
Share on other sites

This is a copy of my Application_top if that helps.




$Id: application_top.php,v 1.153 2002/11/03 23:53:47 hpdl Exp $


osCommerce, Open Source E-Commerce Solutions



Copyright © 2002 osCommerce


Released under the GNU General Public License



// Start the clock for the page parse time log

define('PAGE_PARSE_START_TIME', microtime());


// Set the level of error reporting

error_reporting(E_ALL & ~E_NOTICE);


// Check if register_globals is enabled.

// Since this is a temporary measure this message is hardcoded. The requirement will be removed before 2.2 is finalized.

if (function_exists('ini_get')) {

ini_get('register_globals') or exit('FATAL ERROR: register_globals is disabled in php.ini, please enable it!');



// Disable use_trans_sid as tep_href_link() does this manually

if (function_exists('ini_set')) {

ini_set('session.use_trans_sid', 0);



// Set the local configuration parameters - mainly for developers

if (file_exists('includes/local/configure.php')) include('includes/local/configure.php');


// Include application configuration parameters



// Define the project version

define('PROJECT_VERSION', 'Preview Release 2.2-CVS');


// Used in the "Backup Manager" to compress backups

define('LOCAL_EXE_GZIP', '/usr/bin/gzip');

define('LOCAL_EXE_GUNZIP', '/usr/bin/gunzip');

define('LOCAL_EXE_ZIP', '/usr/local/bin/zip');

define('LOCAL_EXE_UNZIP', '/usr/local/bin/unzip');


// define the filenames used in the project

define('FILENAME_BACKUP', 'backup.php');

define('FILENAME_BANNER_MANAGER', 'banner_manager.php');

define('FILENAME_BANNER_STATISTICS', 'banner_statistics.php');

define('FILENAME_CACHE', 'cache.php');

define('FILENAME_CATALOG_ACCOUNT_HISTORY_INFO', 'account_history_info.php');

define('FILENAME_CATEGORIES', 'categories.php');

define('FILENAME_CONFIGURATION', 'configuration.php');

define('FILENAME_COUNTRIES', 'countries.php');

define('FILENAME_CURRENCIES', 'currencies.php');

define('FILENAME_CUSTOMERS', 'customers.php');

define('FILENAME_DEFAULT', 'index.php');

define('FILENAME_DEFINE_LANGUAGE', 'define_language.php');

define('FILENAME_FILE_MANAGER', 'file_manager.php');

define('FILENAME_GEO_ZONES', 'geo_zones.php');

define('FILENAME_LANGUAGES', 'languages.php');

define('FILENAME_MAIL', 'mail.php');

define('FILENAME_MANUFACTURERS', 'manufacturers.php');

define('FILENAME_MODULES', 'modules.php');

define('FILENAME_NEWSLETTERS', 'newsletters.php');

define('FILENAME_ORDERS', 'orders.php');

define('FILENAME_ORDERS_INVOICE', 'invoice.php');

define('FILENAME_ORDERS_PACKINGSLIP', 'packingslip.php');

define('FILENAME_ORDERS_STATUS', 'orders_status.php');

define('FILENAME_POPUP_IMAGE', 'popup_image.php');

define('FILENAME_PRODUCTS_ATTRIBUTES', 'products_attributes.php');

define('FILENAME_PRODUCTS_EXPECTED', 'products_expected.php');

define('FILENAME_REVIEWS', 'reviews.php');

define('FILENAME_SERVER_INFO', 'server_info.php');

define('FILENAME_SHIPPING_MODULES', 'shipping_modules.php');

define('FILENAME_SPECIALS', 'specials.php');

define('FILENAME_STATS_CUSTOMERS', 'stats_customers.php');

define('FILENAME_STATS_PRODUCTS_PURCHASED', 'stats_products_purchased.php');

define('FILENAME_STATS_PRODUCTS_VIEWED', 'stats_products_viewed.php');

define('FILENAME_TAX_CLASSES', 'tax_classes.php');

define('FILENAME_TAX_RATES', 'tax_rates.php');

define('FILENAME_WHOS_ONLINE', 'whos_online.php');

define('FILENAME_ZONES', 'zones.php');


// define the database table names used in the project

define('TABLE_ADDRESS_BOOK', 'address_book');

define('TABLE_ADDRESS_FORMAT', 'address_format');

define('TABLE_BANNERS', 'banners');

define('TABLE_BANNERS_HISTORY', 'banners_history');

define('TABLE_CATEGORIES', 'categories');

define('TABLE_CATEGORIES_DESCRIPTION', 'categories_description');

define('TABLE_CONFIGURATION', 'configuration');

define('TABLE_CONFIGURATION_GROUP', 'configuration_group');

define('TABLE_COUNTRIES', 'countries');

define('TABLE_CURRENCIES', 'currencies');

define('TABLE_CUSTOMERS', 'customers');

define('TABLE_CUSTOMERS_BASKET', 'customers_basket');

define('TABLE_CUSTOMERS_BASKET_ATTRIBUTES', 'customers_basket_attributes');

define('TABLE_CUSTOMERS_INFO', 'customers_info');

define('TABLE_LANGUAGES', 'languages');

define('TABLE_MANUFACTURERS', 'manufacturers');

define('TABLE_MANUFACTURERS_INFO', 'manufacturers_info');

define('TABLE_NEWSLETTERS', 'newsletters');

define('TABLE_ORDERS', 'orders');

define('TABLE_ORDERS_PRODUCTS', 'orders_products');

define('TABLE_ORDERS_PRODUCTS_ATTRIBUTES', 'orders_products_attributes');

define('TABLE_ORDERS_PRODUCTS_DOWNLOAD', 'orders_products_download');

define('TABLE_ORDERS_STATUS', 'orders_status');

define('TABLE_ORDERS_STATUS_HISTORY', 'orders_status_history');

define('TABLE_ORDERS_TOTAL', 'orders_total');

define('TABLE_PRODUCTS', 'products');

define('TABLE_PRODUCTS_ATTRIBUTES', 'products_attributes');

define('TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD', 'products_attributes_download');

define('TABLE_PRODUCTS_DESCRIPTION', 'products_description');

define('TABLE_PRODUCTS_NOTIFICATIONS', 'products_notifications');

define('TABLE_PRODUCTS_OPTIONS', 'products_options');

define('TABLE_PRODUCTS_OPTIONS_VALUES', 'products_options_values');

define('TABLE_PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS', 'products_options_values_to_products_options');

define('TABLE_PRODUCTS_TO_CATEGORIES', 'products_to_categories');

define('TABLE_REVIEWS', 'reviews');

define('TABLE_REVIEWS_DESCRIPTION', 'reviews_description');

define('TABLE_SESSIONS', 'sessions');

define('TABLE_SPECIALS', 'specials');

define('TABLE_TAX_CLASS', 'tax_class');

define('TABLE_TAX_RATES', 'tax_rates');

define('TABLE_GEO_ZONES', 'geo_zones');

define('TABLE_ZONES_TO_GEO_ZONES', 'zones_to_geo_zones');

define('TABLE_WHOS_ONLINE', 'whos_online');

define('TABLE_ZONES', 'zones');


// customization for the design layout

define('TAX_DECIMAL_PLACES', 0); // Pad the tax value this amount of decimal places

define('DISPLAY_PRICE_WITH_TAX', true); // Display prices with tax (true) or without tax (false)

define('BOX_WIDTH', 125); // how wide the boxes should be in pixels (default: 125)


// Control what fields of the customer table are used

define('ACCOUNT_GENDER', false);

define('ACCOUNT_DOB', false);

define('ACCOUNT_COMPANY', false);

define('ACCOUNT_SUBURB', false);

define('ACCOUNT_STATE', true);


// Define how do we update currency exchange rates

// Possible values are 'oanda' 'xe' or ''

define('CURRENCY_SERVER_PRIMARY', 'oanda');



// include the database functions

require(DIR_WS_FUNCTIONS . 'database.php');


// make a connection to the database... now

tep_db_connect() or die('Unable to connect to database server!');


// set application wide parameters

$configuration_query = tep_db_query('select configuration_key as cfgKey, configuration_value as cfgValue from ' . TABLE_CONFIGURATION . '');

while ($configuration = tep_db_fetch_array($configuration_query)) {

define($configuration['cfgKey'], $configuration['cfgValue']);



// initialize the logger class

require(DIR_WS_CLASSES . 'logger.php');


// include shopping cart class

require(DIR_WS_CLASSES . 'shopping_cart.php');


// some code to solve compatibility issues

require(DIR_WS_FUNCTIONS . 'compatibility.php');


// check to see if php implemented session management functions - if not, include php3/php4 compatible session class

if (!function_exists('session_start')) {

define('PHP_SESSION_NAME', 'sID');

define('PHP_SESSION_SAVE_PATH', '/tmp');


include(DIR_WS_CLASSES . 'sessions.php');



// define how the session functions will be used

require(DIR_WS_FUNCTIONS . 'sessions.php');



// lets start our session


if (function_exists('session_set_cookie_params')) {

session_set_cookie_params(0, substr(DIR_WS_ADMIN, 0, -1));



// language

require(DIR_WS_FUNCTIONS . 'languages.php');

if ( (!$language) || ($HTTP_GET_VARS['language']) ) {

if (!$language) {





$language = tep_get_languages_directory($HTTP_GET_VARS['language']);

if (!$language) $language = tep_get_languages_directory(DEFAULT_LANGUAGE);



// include the language translations

require(DIR_WS_LANGUAGES . $language . '.php');

$current_page = split('\?', basename($PHP_SELF)); $current_page = $current_page[0]; // for BadBlue(Win32) webserver compatibility

if (file_exists(DIR_WS_LANGUAGES . $language . '/' . $current_page)) {

include(DIR_WS_LANGUAGES . $language . '/' . $current_page);



// define our general functions used application-wide

require(DIR_WS_FUNCTIONS . 'general.php');

require(DIR_WS_FUNCTIONS . 'html_output.php');


// define our localization functions

require(DIR_WS_FUNCTIONS . 'localization.php');


// setup our boxes

require(DIR_WS_CLASSES . 'table_block.php');

require(DIR_WS_CLASSES . 'box.php');


// initialize the message stack for output messages

require(DIR_WS_CLASSES . 'message_stack.php');

$messageStack = new messageStack;


// split-page-results

require(DIR_WS_CLASSES . 'split_page_results.php');


// entry/item info classes

require(DIR_WS_CLASSES . 'object_info.php');


// email classes

require(DIR_WS_CLASSES . 'mime.php');

require(DIR_WS_CLASSES . 'email.php');


// calculate category path

$cPath = $HTTP_GET_VARS['cPath'];

if (strlen($cPath) > 0) {

$cPath_array = explode('_', $cPath);

$current_category_id = $cPath_array[(sizeof($cPath_array)-1)];

} else {

$current_category_id = 0;



// default open navigation box

if (!tep_session_is_registered('selected_box')) {


$selected_box = 'configuration';


if ($HTTP_GET_VARS['selected_box']) {

$selected_box = $HTTP_GET_VARS['selected_box'];



// the following cache blocks are used in the Tools->Cache section

// ('language' in the filename is automatically replaced by available languages)

$cache_blocks = array(array('title' => TEXT_CACHE_CATEGORIES, 'code' => 'categories', 'file' => 'categories_box-language.cache', 'multiple' => true),

array('title' => TEXT_CACHE_MANUFACTURERS, 'code' => 'manufacturers', 'file' => 'manufacturers_box-language.cache', 'multiple' => true),

array('title' => TEXT_CACHE_ALSO_PURCHASED, 'code' => 'also_purchased', 'file' => 'also_purchased-language.cache', 'multiple' => true)



// check if a default currency is set

if (!defined('DEFAULT_CURRENCY')) {

$messageStack->add(ERROR_NO_DEFAULT_CURRENCY_DEFINED, 'error');



// check if a default language is set

if (!defined('DEFAULT_LANGUAGE')) {

$messageStack->add(ERROR_NO_DEFAULT_LANGUAGE_DEFINED, 'error');



Link to comment
Share on other sites

I do not have customer details in admin-configuration and I've looked many times.

Thank you for being patient.

Well, I don't know why you wouldn't have it. Actually, I just thought, I don't have 2.1, I have 2.2 CVS (I assume you are looking in the actual admin side of oscommerce and not in the admin files . . .)


It might be possible to alter your configuration group in the database to include it. Mine has:


Edit Delete 1 My Store General information about my store 1 1

Edit Delete 2 Minimum Values The minimum values for functions / data 2 1

Edit Delete 3 Maximum Values The maximum values for functions / data 3 1

Edit Delete 4 Images Image parameters 4 1

Edit Delete 5 Customer Details Customer account configuration 5 1

Edit Delete 6 Module Options Hidden from configuration 6 0

Edit Delete 7 Shipping/Packaging Shipping options available at my store 7 1

Edit Delete 8 Product Listing Product Listing configuration options 8 1

Edit Delete 9 Stock Stock configuration options 9 1

Edit Delete 10 Logging Logging configuration options 10 1

Edit Delete 11 Cache Caching configuration options 11 1

Edit Delete 12 E-Mail Options General setting for E-Mail transport and HTML E-Ma... 12 1

Edit Delete 13 Download Downloadable products options 13 1

Edit Delete 14 GZip Compression GZip compression options 14 1


Probably if you just add the customer details option, it might work. Back up first though as I don't know for certain.


Click on insert new row. Set configuration_group_id to one up from the last one. So, if you don't have customer details already, then GZip might be 13. So youo would set it to 14. You could set it as 5, but then you'd have the change all the others as well. Set configuration_group_title to 'Customer details'. Set configuration_group_description to 'Customer account configuration'. Set Sort Order to the same as you set configuration_group_id to. Set visible to '1'


You will also have to add rows to 'configuration' in the database.


Fields you will need to add are:

configuration_id configuration_title configuration_key configuration_value configuration_description configuration_group_id sort_order set_function


62 Gender ACCOUNT_GENDER false Display gender in the customers account 5 1 tep_cfg_select_option(array('true', 'false'),


63 Date of Birth ACCOUNT_DOB false Display date of birth in the customers account 5 2 tep_cfg_select_option(array('true', 'false'),


64 Company ACCOUNT_COMPANY false Display company in the customers account 5 3 tep_cfg_select_option(array('true', 'false'),


65 Suburb ACCOUNT_SUBURB false Display suburb in the customers account 5 4 tep_cfg_select_option(array('true', 'false'),


66 State ACCOUNT_STATE true Display state in the customers account 5 5 tep_cfg_select_option(array('true', 'false'),


Someone who knows more than me might be able to writwe an appropriate SQL query which woud be easier than inserting all the fields manually. But that is what, in my database, tells the software to insert the customer details, which include the option to have "state" in the address.

Link to comment
Share on other sites

You would have to make the changes directly to the database. I assume you have phpMyAdmin or something similar. Go to the main page and scroll down until you see configuration_group. Click on browse and it will show you what it has in there.


If it doesn't have customer details, as mine does then you will need to add it as per my instructions.


It is a bit scary making changes in the database directly but when you've done it once, it gets easier.


Remember to back up first.

Link to comment
Share on other sites


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

  • Create New...