can't get into teh default,php file!

tordeman · June 11, 2003

you can find my webshop here:

www.smallville-fan.com/webshop/

admin = /webshop/admin

catalog = /webshop/catalog

the admin fils is protected

pass: 12345678

username: test

It is really inportent to get this to work as fast as possible..

i have changed all the files so they have the right MySQL information my server have PHP VERSION: 4.2.2 and mySQL VERSION: 3.23.55.

hope to get an answer back soon..

tordeman · June 11, 2003

I did also add all the information to the database maually this was what I added:

SQL-sp?rring :

CREATE TABLE address_book (

address_book_id int(5) NOT NULL auto_increment,

entry_gender char(1) NOT NULL,

entry_firstname varchar(32) NOT NULL,

entry_lastname varchar(32) NOT NULL,

entry_street_address varchar(64) NOT NULL,

entry_suburb varchar(32),

entry_postcode varchar(10) NOT NULL,

entry_city varchar(32) NOT NULL,

entry_state varchar(32),

entry_country_id int(5) NOT NULL,

entry_zone_id int(5) NOT NULL,

PRIMARY KEY (address_book_id)

);

CREATE TABLE address_book_to_customers (

address_book_to_customers_id int(5) NOT NULL auto_increment,

address_book_id int(5) NOT NULL,

customers_id int(5) NOT NULL,

PRIMARY KEY (address_book_to_customers_id)

);

CREATE TABLE address_format (

address_format_id int(5) NOT NULL auto_increment,

address_format varchar(128) NOT NULL,

address_summary varchar(48) NOT NULL,

PRIMARY KEY (address_format_id)

);

CREATE TABLE categories (

categories_id int(5) NOT NULL auto_increment,

categories_name varchar(32) NOT NULL,

categories_image varchar(64),

parent_id int(5),

sort_order int(3),

PRIMARY KEY (categories_id),

KEY IDX_CATEGORIES_NAME (categories_name)

);

CREATE TABLE configuration (

configuration_id int(5) NOT NULL auto_increment,

configuration_title varchar(64) NOT NULL,

configuration_key varchar(64) NOT NULL,

configuration_value varchar(255) NOT NULL,

configuration_description varchar(255) NOT NULL,

configuration_group_id int(5) NOT NULL,

sort_order int(5) NULL,

last_modified timestamp(14) NULL,

date_added timestamp(14) NOT NULL,

use_function varchar(32) NULL,

PRIMARY KEY (configuration_id)

);

CREATE TABLE configuration_group (

configuration_group_id int(5) NOT NULL auto_increment,

configuration_group_title varchar(64) NOT NULL,

configuration_group_description varchar(255) NOT NULL,

sort_order int(5) NULL,

PRIMARY KEY (configuration_group_id)

);

CREATE TABLE counter (

startdate char(8),

counter int(12)

);

CREATE TABLE counter_history (

month char(8),

counter int(12)

);

CREATE TABLE countries (

countries_id int(5) NOT NULL auto_increment,

countries_name varchar(64) NOT NULL,

countries_iso_code_2 char(2) NOT NULL,

countries_iso_code_3 char(3) NOT NULL,

address_format_id int(5) NOT NULL,

PRIMARY KEY (countries_id),

KEY IDX_COUNTRIES_NAME (countries_name)

);

CREATE TABLE currencies (

currencies_id int(5) NOT NULL auto_increment,

title varchar(32) NOT NULL,

code char(3) NOT NULL,

symbol_left varchar(12),

symbol_right varchar(12),

decimal_point char(1),

thousands_point char(1),

decimal_places char(1),

PRIMARY KEY (currencies_id)

);

CREATE TABLE customers (

customers_id int(5) NOT NULL auto_increment,

customers_gender char(1) NOT NULL,

customers_firstname varchar(32) NOT NULL,

customers_lastname varchar(32) NOT NULL,

customers_dob varchar(8) NOT NULL,

customers_email_address varchar(96) NOT NULL,

customers_street_address varchar(64) NOT NULL,

customers_suburb varchar(32),

customers_postcode varchar(10) NOT NULL,

customers_city varchar(32) NOT NULL,

customers_state varchar(32),

customers_telephone varchar(32) NOT NULL,

customers_fax varchar(32),

customers_password varchar(40) NOT NULL,

customers_country_id int(5) NOT NULL,

customers_zone_id int(5) NOT NULL,

PRIMARY KEY (customers_id)

);

CREATE TABLE customers_basket (

customers_basket_id int(5) NOT NULL auto_increment,

customers_id int(5) NOT NULL,

products_id int(5) NOT NULL,

customers_basket_quantity int(2) NOT NULL,

final_price decimal(6,2) NOT NULL,

customers_basket_date_added char(8),

PRIMARY KEY (customers_basket_id)

);

CREATE TABLE customers_basket_attributes (

customers_basket_attributes_id int(5) NOT NULL auto_increment,

customers_id int(5) NOT NULL,

products_id int(5) NOT NULL,

products_options_id int(5) NOT NULL,

products_options_value_id int(5) NOT NULL,

PRIMARY KEY (customers_basket_attributes_id)

);

CREATE TABLE customers_info (

customers_info_id int(5) NOT NULL,

customers_info_date_of_last_logon char(8),

customers_info_number_of_logons int(5),

customers_info_date_account_created char(8),

customers_info_date_account_last_modified char(8),

PRIMARY KEY (customers_info_id)

);

CREATE TABLE languages (

languages_id int(5) NOT NULL auto_increment,

name varchar(32) NOT NULL,

code char(2) NOT NULL,

image varchar(64),

directory varchar(32),

sort_order int(3),

PRIMARY KEY (languages_id),

KEY IDX_LANGUAGES_NAME (name)

);

CREATE TABLE manufacturers (

manufacturers_id int(5) NOT NULL auto_increment,

manufacturers_name varchar(32) NOT NULL,

manufacturers_image varchar(64),

PRIMARY KEY (manufacturers_id),

KEY IDX_MANUFACTURERS_NAME (manufacturers_name)

);

CREATE TABLE orders (

orders_id int(5) NOT NULL auto_increment,

customers_id int(5) NOT NULL,

customers_name varchar(64) NOT NULL,

customers_street_address varchar(64) NOT NULL,

customers_suburb varchar(32),

customers_city varchar(32) NOT NULL,

customers_postcode varchar(10) NOT NULL,

customers_state varchar(32),

customers_country varchar(32) NOT NULL,

customers_telephone varchar(32) NOT NULL,

customers_email_address varchar(96) NOT NULL,

customers_address_format_id int(5) NOT NULL,

delivery_name varchar(64) NOT NULL,

delivery_street_address varchar(64) NOT NULL,

delivery_suburb varchar(32),

delivery_city varchar(32) NOT NULL,

delivery_postcode varchar(10) NOT NULL,

delivery_state varchar(32),

delivery_country varchar(32) NOT NULL,

delivery_address_format_id int(5) NOT NULL,

payment_method varchar(12) NOT NULL,

cc_type varchar(20),

cc_owner varchar(64),

cc_number varchar(32),

cc_expires varchar(4),

last_modified timestamp(14),

date_purchased timestamp(14),

shipping_cost decimal(8,2) NOT NULL,

shipping_method varchar(32),

orders_status varchar(10) NOT NULL,

orders_date_finished timestamp(14),

comments text,

currency char(3),

currency_value decimal(14,6),

PRIMARY KEY (orders_id)

);

CREATE TABLE orders_products (

orders_products_id int(5) NOT NULL auto_increment,

orders_id int(5) NOT NULL,

products_id int(5) NOT NULL,

products_name varchar(64) NOT NULL,

products_price decimal(8,2) NOT NULL,

final_price decimal(8,2) NOT NULL,

products_tax decimal(7,4) NOT NULL,

products_quantity int(2) NOT NULL,

PRIMARY KEY (orders_products_id)

);

CREATE TABLE orders_products_attributes (

orders_products_attributes_id int(5) NOT NULL auto_increment,

orders_id int(5) NOT NULL,

orders_products_id int(5) NOT NULL,

products_options varchar(32) NOT NULL,

products_options_values varchar(32) NOT NULL,

options_values_price decimal(8,2) NOT NULL,

price_prefix char(1) NOT NULL,

PRIMARY KEY (orders_products_attributes_id)

);

CREATE TABLE products (

products_id int(5) NOT NULL auto_increment,

products_name varchar(32) NOT NULL,

products_description text,

products_quantity int(4) NOT NULL,

products_model varchar(12),

products_image varchar(64),

products_url varchar(255),

products_price decimal(8,2) NOT NULL,

products_date_added varchar(8),

products_viewed int(5),

products_weight decimal(5,2) NOT NULL,

products_status tinyint(1) NOT NULL,

products_tax_class_id int(5) NOT NULL,

manufacturers_id int(5) NULL,

PRIMARY KEY (products_id),

KEY products_name (products_name)

);

CREATE TABLE products_attributes (

products_attributes_id int(5) NOT NULL auto_increment,

products_id int(5) NOT NULL,

options_id int(5) NOT NULL,

options_values_id int(5) NOT NULL,

options_values_price decimal(8,2) NOT NULL,

price_prefix char(1) NOT NULL,

PRIMARY KEY (products_attributes_id)

);

CREATE TABLE products_expected (

products_expected_id int(5) NOT NULL auto_increment,

products_name varchar(255) NOT NULL,

date_expected varchar(8),

PRIMARY KEY (products_expected_id)

);

CREATE TABLE products_options (

products_options_id int(5) NOT NULL auto_increment,

products_options_name varchar(32) NOT NULL,

PRIMARY KEY (products_options_id)

);

CREATE TABLE products_options_values (

products_options_values_id int(5) NOT NULL auto_increment,

products_options_values_name varchar(64) NOT NULL,

PRIMARY KEY (products_options_values_id)

);

CREATE TABLE products_options_values_to_products_options (

products_options_values_to_products_options_id int(5) NOT NULL auto_increment,

products_options_id int(5) NOT NULL,

products_options_values_id int(5) NOT NULL,

PRIMARY KEY (products_options_values_to_products_options_id)

);

CREATE TABLE products_to_categories (

products_id int(5) NOT NULL auto_increment,

categories_id int(5) NOT NULL,

PRIMARY KEY (products_id,categories_id)

);

CREATE TABLE reviews (

reviews_id int(5) NOT NULL auto_increment,

reviews_text text NOT NULL,

reviews_rating int(1),

PRIMARY KEY (reviews_id)

);

CREATE TABLE reviews_extra (

reviews_id int(5) NOT NULL,

products_id int(5) NOT NULL,

customers_id int(5) NOT NULL,

date_added char(8) NOT NULL,

reviews_read int(5)

);

CREATE TABLE specials (

specials_id int(5) NOT NULL auto_increment,

products_id int(5) NOT NULL,

specials_new_products_price decimal(8,2) NOT NULL,

specials_date_added char(8),

PRIMARY KEY (specials_id)

);

CREATE TABLE tax_class (

tax_class_id int(5) NOT NULL auto_increment,

tax_class_title varchar(32) NOT NULL,

tax_class_description varchar(255) NOT NULL,

last_modified timestamp(14) NULL,

date_added timestamp(14) NOT NULL,

PRIMARY KEY (tax_class_id)

);

CREATE TABLE tax_rates (

tax_rates_id int(5) NOT NULL auto_increment,

tax_zone_id int(5) NOT NULL,

tax_class_id int(5) NOT NULL,

tax_rate decimal(7,4) NOT NULL,

tax_description varchar(255) NOT NULL,

last_modified timestamp(14) NULL,

date_added timestamp(14) NOT NULL,

PRIMARY KEY (tax_rates_id)

);

CREATE TABLE zones (

zone_id int(5) NOT NULL auto_increment,

zone_country_id int(5) NOT NULL,

zone_code varchar(5) NOT NULL,

zone_name varchar(32) NOT NULL,

PRIMARY KEY (zone_id)

);

# data

# 1 - Default, 2 - USA, 3 - Spain, 4 - Singapore

INSERT INTO address_format VALUES (1, '$firstname $lastname$cr$streets$cr$city, $postcode$cr$statecomma$country','$city / $country');

INSERT INTO address_format VALUES (2, '$firstname $lastname$cr$streets$cr$city, $state $postcode$cr$country','$city, $state / $country');

INSERT INTO address_format VALUES (3, '$firstname $lastname$cr$streets$cr$city$cr$postcode - $statecomma$country','$city / $country');

INSERT INTO address_format VALUES (4, '$firstname $lastname$cr$streets$cr$city ($postcode)$cr$country', '$postcode / $country');

INSERT INTO categories VALUES (1,'Hardware','images/category_hardware.gif',0,1);

INSERT INTO categories VALUES (2,'Software','images/category_software.gif',0,2);

INSERT INTO categories VALUES (3,'DVD Movies','images/category_dvd_movies.gif',0,3);

INSERT INTO categories VALUES (4,'Graphics Cards','images/subcategory_graphic_cards.gif',1,0);

INSERT INTO categories VALUES (5,'Printers','images/subcategory_printers.gif',1,0);

INSERT INTO categories VALUES (6,'Monitors','images/subcategory_monitors.gif',1,0);

INSERT INTO categories VALUES (7,'Speakers','images/subcategory_speakers.gif',1,0);

INSERT INTO categories VALUES (8,'Keyboards','images/subcategory_keyboards.gif',1,0);

INSERT INTO categories VALUES (9,'Mice','images/subcategory_mice.gif',1,0);

INSERT INTO categories VALUES (10,'Action','images/subcategory_action.gif',3,0);

INSERT INTO categories VALUES (11,'Science Fiction','images/subcategory_science_fiction.gif',3,0);

INSERT INTO categories VALUES (12,'Comedy','images/subcategory_comedy.gif',3,0);

INSERT INTO categories VALUES (13,'Cartoons','images/subcategory_cartoons.gif',3,0);

INSERT INTO categories VALUES (14,'Thriller','images/subcategory_thriller.gif',3,0);

INSERT INTO categories VALUES (15,'Drama','images/subcategory_drama.gif',3,0);

INSERT INTO categories VALUES (16,'Memory','images/subcategory_memory.gif',1,0);

INSERT INTO categories VALUES (17,'CDROM Drives','images/subcategory_cdrom_drives.gif',1,0);

INSERT INTO categories VALUES (18,'Simulation','images/subcategory_simulation.gif',2,0);

INSERT INTO categories VALUES (19,'Action','images/subcategory_action_games.gif',2,0);

INSERT INTO categories VALUES (20,'Strategy','images/subcategory_strategy.gif',2,0);

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Store Name', 'STORE_NAME', 'The Exchange Project', 'The name of my store', '1', '1', now());

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Store Owner', 'STORE_OWNER', 'Harald Ponce de Leon', 'The name of my store owner', '1', '2', now());

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('E-Mail Address', 'STORE_OWNER_EMAIL_ADDRESS', '[email protected]', 'The e-mail address of my store owner', '1', '3', now());

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('E-Mail From', 'EMAIL_FROM', 'The Exchange Project <[email protected]>', 'The e-mail address used in (sent) e-mails', '1', '4', now());

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, date_added) VALUES ('Country', 'STORE_COUNTRY', '81', 'The country my store is located in', '1', '5', 'tep_get_country_name', now());

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Expected Sort Order', 'EXPECTED_PRODUCTS_SORT', 'DESC', 'This is the sort order used in the "expected products" box. It can be either ASC (ascending) or DESC (descending, the default).', '1', '6', now());

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Expected Sort Field', 'EXPECTED_PRODUCTS_FIELD', 'date_expected', 'The column to sort by in the "expected products" box. Can be "products_name" or "date_expected" (the default)', '1', '7', now());

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('First Name', 'ENTRY_FIRST_NAME_MIN_LENGTH', '3', 'Minimum length of first name', '2', '1', now());

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Last Name', 'ENTRY_LAST_NAME_MIN_LENGTH', '3', 'Minimum length of last name', '2', '2', now());

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Date of Birth', 'ENTRY_DOB_MIN_LENGTH', '10', 'Minimum length of date of birth', '2', '3', now());

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('E-Mail Address', 'ENTRY_EMAIL_ADDRESS_MIN_LENGTH', '6', 'Minimum length of e-mail address', '2', '4', now());

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Street Address', 'ENTRY_STREET_ADDRESS_MIN_LENGTH', '5', 'Minimum length of street address', '2', '5', now());

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Post Code', 'ENTRY_POSTCODE_MIN_LENGTH', '4', 'Minimum length of post code', '2', '6', now());

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('City', 'ENTRY_CITY_MIN_LENGTH', '4', 'Minimum length of city', '2', '7', now());

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('State', 'ENTRY_STATE_MIN_LENGTH', '4', 'Minimum length of state', '2', '7', now());

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Telephone Number', 'ENTRY_TELEPHONE_MIN_LENGTH', '3', 'Minimum length of telephone number', '2', '8', now());

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Password', 'ENTRY_PASSWORD_MIN_LENGTH', '5', 'Minimum length of password', '2', '9', now());

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Credit Card Owner Name', 'CC_OWNER_MIN_LENGTH', '3', 'Minimum length of credit card owner name', '2', '10', now());

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Credit Card Number', 'CC_NUMBER_MIN_LENGTH', '10', 'Minimum length of credit card number', '2', '11', now());

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Review Text', 'REVIEW_TEXT_MIN_LENGTH', '50', 'Minimum length of review text', '2', '13', now());

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Address Book Entries', 'MAX_ADDRESS_BOOK_ENTRIES', '5', 'Maximum address book entries a customer is allowed to have', '3', '1', now());

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Search Results', 'MAX_DISPLAY_SEARCH_RESULTS', '20', 'Amount of products to list', '3', '2', now());

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Page Links', 'MAX_DISPLAY_PAGE_LINKS', '5', 'Number of 'number' links use for page-sets', '3', '3', now());

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Special Products', 'MAX_DISPLAY_SPECIAL_PRODUCTS', '9', 'Maximum number of products on special to display', '3', '4', now());

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('New Products', 'MAX_DISPLAY_NEW_PRODUCTS', '9', 'Maximum number of new products to display in a category', '3', '5', now());

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Products Expected', 'MAX_DISPLAY_UPCOMING_PRODUCTS', '10', 'Maximum number of products expected to display', '3', '6', now());

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Manufacturers List', 'MAX_DISPLAY_MANUFACTURERS_IN_A_LIST', '0', 'Used in manufacturers box; when the number of manufacturers exceeds this number, a drop-down list will be displayed instead of the default list', '3', '7', now());

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Length of Manufacturers Name', 'MAX_DISPLAY_MANUFACTURER_NAME_LEN', '15', 'Used in manufacturers box; maximum length of manufacturers name to display', '3', '8', now());

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('New Reviews', 'MAX_DISPLAY_NEW_REVIEWS', '6', 'Maximum number of new reviews to display', '3', '9', now());

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Selection of Random Reviews', 'MAX_RANDOM_SELECT_REVIEWS', '10', 'How many records to select from to choose one random product review', '3', '10', now());

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Selection of Random New Products', 'MAX_RANDOM_SELECT_NEW', '10', 'How many records to select from to choose one random new product to display', '3', '11', now());

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Selection of Products on Special', 'MAX_RANDOM_SELECT_SPECIALS', '10', 'How many records to select from to choose one random product special to display', '3', '12', now());

insert into configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Categories To List Per Row', 'MAX_DISPLAY_CATEGORIES_PER_ROW', '3', 'How many categories to list per row', '3', '13', now());

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Small Image Width', 'SMALL_IMAGE_WIDTH', '100', 'The pixel width of small images', '4', '1', now());

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Small Image Height', 'SMALL_IMAGE_HEIGHT', '80', 'The pixel height of small images', '4', '2', now());

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Heading Image Width', 'HEADING_IMAGE_WIDTH', '85', 'The pixel width of heading images', '4', '3', now());

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Heading Image Height', 'HEADING_IMAGE_HEIGHT', '60', 'The pixel height of heading images', '4', '4', now());

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Subcategory Image Width', 'SUBCATEGORY_IMAGE_WIDTH', '100', 'The pixel width of subcategory images', '4', '5', now());

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Subcategory Image Height', 'SUBCATEGORY_IMAGE_HEIGHT', '57', 'The pixel height of subcategory images', '4', '6', now());

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Calculate Image Size', 'CONFIG_CALCULATE_IMAGE_SIZE', '1', 'Calculate the size of images?', '4', '7', now());

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Image Required', 'IMAGE_REQUIRED', '1', 'Enable to display broken images. Good for development.', '4', '8', now());

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('General', 'FONT_STYLE_MAIN', '', 'General font style', '5', '1', now());

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Small Text', 'FONT_STYLE_SMALL_TEXT', '', 'Small Text font style', '5', '2', now());

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Navigation Bar', 'FONT_STYLE_HEADER_NAVIGATION_BAR', '', 'Header Navigation Bar font style', '5', '3', now());

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Top Bar', 'FONT_STYLE_TOP_BAR', '', 'Top Bar font style', '5', '4', now());

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Heading', 'FONT_STYLE_HEADING', '', 'Heading font style', '5', '5', now());

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Sub Bar', 'FONT_STYLE_SUB_BAR', '', 'Sub Bar font style', '5', '6', now());

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Table Heading', 'FONT_STYLE_TABLE_HEADING', '', 'Table Heading font style', '5', '7', now());

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Footer', 'FONT_STYLE_FOOTER', '', 'Footer font style', '5', '8', now());

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Info-Box Headings', 'FONT_STYLE_INFO_BOX_HEADING', '', 'Font style for info-box headings', '5', '9', now());

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Info-Box Contents', 'FONT_STYLE_INFO_BOX_BODY', '', 'Font style for info-box contents', '5', '10', now());

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Listing Headings', 'FONT_STYLE_LIST_BOX_HEADING', '', 'Font style for listing box headings', '5', '11', now());

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Listing Contents', 'FONT_STYLE_LIST_BOX_BODY', '', 'Font style for listing box contents', '5', '12', now());

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Account Categories', 'FONT_STYLE_ACCOUNT_CATEGORY', '', 'Account Category font style', '5', '13', now());

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Field Entry', 'FONT_STYLE_FIELD_ENTRY', '', 'Field Entry font style', '5', '14', now());

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Field Value', 'FONT_STYLE_FIELD_VALUE', '', 'Field Value font style', '5', '15', now());

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('New Item In Cart', 'FONT_STYLE_NEW_CART_ITEM', '', 'Font style for new items added to the cart', '5', '16', now());

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Installed Payment Modules', 'PAYMENT_MODULES', 'cc.php;cod.php;paypal.php', 'List of payment module filenames separated by a semi-colon. This is automatically updated. No need to edit. (Example: cc.php;cod.php;paypal.php)', '6', '0', now());

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Allow Cash On Delivery (COD)', 'PAYMENT_SUPPORT_COD', '1', 'Do you want to accept COD (Cash On Delevery) payments?', '6', '1', now());

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Allow Credit Card', 'PAYMENT_SUPPORT_CC', '1', 'Do you want to accept credit card payments?', '6', '2', now());

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Allow PayPal', 'PAYMENT_SUPPORT_PAYPAL', '1', 'Do you want to accept PayPal payments?', '6', '3', now());

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('PayPal ID', 'PAYPAL_ID', '[email protected]', 'Your buisness ID at PayPal. Usually the email address you signed up with. You can create a free PayPal account <a href="http://www.paypal.com" target="_blank">here</a>.', '6', '4', now());

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Credit Card TP email address', 'PAYMENT_EMAIL_CC', 'NONE', 'If this email address is not NONE then the middle digits of any stored cc numbers will be X-ed out and emailed with the order id.', '6', '5', now());

insert into configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Shipping Methods to offer to customer', 'SHIPPING_MODULES', '', 'List of shipping module filenames separated by a semi-colon. This is automatically updated. No need to edit. (Example: ups.php;flat.php;item.php)', '7', '1', now());

insert into configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Package Tare weight.', 'SHIPPING_BOX_WEIGHT', '3', 'What is the weight of typical packaging of small to medium packages?', '7', '2', now());

insert into configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Larger packages - percentage increase.', 'SHIPPING_BOX_PADDING', '10', 'For 10% enter 10', '7', '3', now());

insert into configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Handling Fee', 'SHIPPING_HANDLING', '5.00', 'Enter the handling fee you may charge.', '7', '4', now());

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Display Product Image', 'PRODUCT_LIST_IMAGE', '0', 'Do you want to display the Product Image?', '8', '1', now());

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Display Product Manufaturer Name','PRODUCT_LIST_MANUFACTURER', '0', 'Do you want to display the Product Manufacturer Name?', '8', '2', now());

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Display Product Model', 'PRODUCT_LIST_MODEL', '0', 'Do you want to display the Product Model?', '8', '3', now());

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Display Product Name', 'PRODUCT_LIST_NAME', '1', 'Do you want to display the Product Name?', '8', '4', now());

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Display Product Price', 'PRODUCT_LIST_PRICE', '2', 'Do you want to display the Product Price', '8', '5', now());

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Display Product Quantity', 'PRODUCT_LIST_QUANTITY', '0', 'Do you want to display the Product Quantity?', '8', '6', now());

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Display Product Weight', 'PRODUCT_LIST_WEIGHT', '0', 'Do you want to display the Product Weight?', '8', '7', now());

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Display Buy Now column', 'PRODUCT_LIST_BUY_NOW', '0', 'Do you want to display the Buy Now column?', '8', '8', now());

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Display Category/Manufacturer Filter (0=disable; 1=enable)', 'PRODUCT_LIST_FILTER', '1', 'Do you want to display the Category/Manufacturer Filter?', '8', '9', now());

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Location of Prev/Next Navigation Bar (1-top, 2-bottom, 3-both)', 'PREV_NEXT_BAR_LOCATION', '2', 'Sets the location of the Prev/Next Navigation Bar (1-top, 2-bottom, 3-both)', '8', '10', now());

insert into configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Flat Cost', 'SHIPPING_FLAT_COST', '5.00', 'What is the Shipping cost? The Handling fee will also be added.', '7', '5', now());

insert into configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Per Item shipping cost', 'SHIPPING_ITEM_COST', '2.50', 'How much will be charged for each item ordered?', '7', '6', now());

insert into configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('UPS Pickup Method', 'SHIPPING_UPS_PICKUP', 'CC', 'How do you give packages to UPS? CC - Customer Counter, RDP - Daily Pickup, OTP - One Time Pickup, LC - Letter Center, OCA - On Call Air', '7', '5', now());

insert into configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('UPS Packaging?', 'SHIPPING_UPS_PACKAGE', 'CP', 'CP - Your Packaging, ULE - UPS Letter, UT - UPS Tube, UBE - UPS Express Box', '7', '6', now());

insert into configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Residential Delivery?', 'SHIPPING_UPS_RES', 'RES', 'Quote for Residential (RES) or Commerical Delivery (COM)', '7', '7', now());

insert into configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Enter the USPS USERID', 'SHIPPING_USPS_USERID', 'NONE', 'Enter the USPS USERID assigned to you. Register at http://www.uspsprioritymail.com/et_regcert.html and also tell them you are an end user not developer.', '7', '11', now());

insert into configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Enter the USPS Password', 'SHIPPING_USPS_PASSWORD', 'NONE', 'See USERID, above.', '7', '12', now());

insert into configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Enter the USPS URL of the production Server', 'SHIPPING_USPS_SERVER', 'NONE', 'See above', '7', '13', now());

insert into configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Enter the Maximum Package Weight you will ship', 'SHIPPING_MAX_WEIGHT', '50', 'Carriers have a max weight limit for a single package. This is a common one for all.', '7', '14', now());

insert into configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Postal Code', 'STORE_ORIGIN_ZIP', 'NONE', 'Enter the Postal Code (ZIP) of the Store to be used in shipping quotes.', '1', '8', now());

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Country Code', 'STORE_ORIGIN_COUNTRY', 'NONE', 'Enter the "ISO 3166" Country Code of the Store to be used in shipping quotes. To find your country code, visit the <A HREF="http://www.din.de/gremien/nas/nabd/iso3166ma/codlstp1/index.html" TARGET="_blank">ISO 3166 Maintenance Agency</A>.', '1', '9', now());

INSERT INTO configuration_group VALUES ('1', 'My Store', 'General information about my store', '1');

INSERT INTO configuration_group VALUES ('2', 'Minimum Values', 'The minimum values for functions / data', '2');

INSERT INTO configuration_group VALUES ('3', 'Maximum Values', 'The maximum values for functions / data', '3');

INSERT INTO configuration_group VALUES ('4', 'Images', 'Image parameters', '4');

INSERT INTO configuration_group VALUES ('5', 'Font Styles', 'Font stlyes used for text output', '5');

INSERT INTO configuration_group VALUES ('6', 'Payment Options', 'Payment options available at my store', '6');

INSERT INTO configuration_group VALUES ('7', 'Shipping Options', 'Shipping options available at my store', '7');

INSERT INTO configuration_group VALUES ('8', 'Product Listing', 'Product Listing configuration options', '8');

INSERT INTO countries VALUES (1,'Afghanistan','AF','AFG','1');

INSERT INTO countries VALUES (2,'Albania','AL','ALB','1');

INSERT INTO countries VALUES (3,'Algeria','DZ','DZA','1');

INSERT INTO countries VALUES (4,'American Samoa','AS','ASM','1');

INSERT INTO countries VALUES (5,'Andorra','AD','AND','1');

INSERT INTO countries VALUES (6,'Angola','AO','AGO','1');

INSERT INTO countries VALUES (7,'Anguilla','AI','AIA','1');

INSERT INTO countries VALUES (8,'Antarctica','AQ','ATA','1');

INSERT INTO countries VALUES (9,'Antigua and Barbuda','AG','ATG','1');

INSERT INTO countries VALUES (10,'Argentina','AR','ARG','1');

INSERT INTO countries VALUES (11,'Armenia','AM','ARM','1');

INSERT INTO countries VALUES (12,'Aruba','AW','ABW','1');

INSERT INTO countries VALUES (13,'Australia','AU','AUS','1');

INSERT INTO countries VALUES (14,'Austria','AT','AUT','1');

INSERT INTO countries VALUES (15,'Azerbaijan','AZ','AZE','1');

INSERT INTO countries VALUES (16,'Bahamas','BS','BHS','1');

INSERT INTO countries VALUES (17,'Bahrain','BH','BHR','1');

INSERT INTO countries VALUES (18,'Bangladesh','BD','BGD','1');

INSERT INTO countries VALUES (19,'Barbados','BB','BRB','1');

INSERT INTO countries VALUES (20,'Belarus','BY','BLR','1');

INSERT INTO countries VALUES (21,'Belgium','BE','BEL','1');

INSERT INTO countries VALUES (22,'Belize','BZ','BLZ','1');

INSERT INTO countries VALUES (23,'Benin','BJ','BEN','1');

INSERT INTO countries VALUES (24,'Bermuda','BM','BMU','1');

INSERT INTO countries VALUES (25,'Bhutan','BT','BTN','1');

INSERT INTO countries VALUES (26,'Bolivia','BO','BOL','1');

INSERT INTO countries VALUES (27,'Bosnia and Herzegowina','BA','BIH','1');

INSERT INTO countries VALUES (28,'Botswana','BW','BWA','1');

INSERT INTO countries VALUES (29,'Bouvet Island','BV','BVT','1');

INSERT INTO countries VALUES (30,'Brazil','BR','BRA','1');

INSERT INTO countries VALUES (31,'British Indian Ocean Territory','IO','IOT','1');

INSERT INTO countries VALUES (32,'Brunei Darussalam','BN','BRN','1');

INSERT INTO countries VALUES (33,'Bulgaria','BG','BGR','1');

INSERT INTO countries VALUES (34,'Burkina Faso','BF','BFA','1');

INSERT INTO countries VALUES (35,'Burundi','BI','BDI','1');

INSERT INTO countries VALUES (36,'Cambodia','KH','KHM','1');

INSERT INTO countries VALUES (37,'Cameroon','CM','CMR','1');

INSERT INTO countries VALUES (38,'Canada','CA','CAN','1');

INSERT INTO countries VALUES (39,'Cape Verde','CV','CPV','1');

INSERT INTO countries VALUES (40,'Cayman Islands','KY','CYM','1');

INSERT INTO countries VALUES (41,'Central African Republic','CF','CAF','1');

INSERT INTO countries VALUES (42,'Chad','TD','TCD','1');

INSERT INTO countries VALUES (43,'Chile','CL','CHL','1');

INSERT INTO countries VALUES (44,'China','CN','CHN','1');

INSERT INTO countries VALUES (45,'Christmas Island','CX','CXR','1');

INSERT INTO countries VALUES (46,'Cocos (Keeling) Islands','CC','CCK','1');

INSERT INTO countries VALUES (47,'Colombia','CO','COL','1');

INSERT INTO countries VALUES (48,'Comoros','KM','COM','1');

INSERT INTO countries VALUES (49,'Congo','CG','COG','1');

INSERT INTO countries VALUES (50,'Cook Islands','CK','COK','1');

INSERT INTO countries VALUES (51,'Costa Rica','CR','CRI','1');

INSERT INTO countries VALUES (52,'Cote D'Ivoire','CI','CIV','1');

INSERT INTO countries VALUES (53,'Croatia','HR','HRV','1');

INSERT INTO countries VALUES (54,'Cuba','CU','CUB','1');

INSERT INTO countries VALUES (55,'Cyprus','CY','CYP','1');

INSERT INTO countries VALUES (56,'Czech Republic','CZ','CZE','1');

INSERT INTO countries VALUES (57,'Denmark','DK','DNK','1');

INSERT INTO countries VALUES (58,'Djibouti','DJ','DJI','1');

INSERT INTO countries VALUES (59,'Dominica','DM','DMA','1');

INSERT INTO countries VALUES (60,'Dominican Republic','DO','DOM','1');

INSERT INTO countries VALUES (61,'East Timor','TP','TMP','1');

INSERT INTO countries VALUES (62,'Ecuador','EC','ECU','1');

INSERT INTO countries VALUES (63,'Egypt','EG','EGY','1');

INSERT INTO countries VALUES (64,'El Salvador','SV','SLV','1');

INSERT INTO countries VALUES (65,'Equatorial Guinea','GQ','GNQ','1');

INSERT INTO countries VALUES (66,'Eritrea','ER','ERI','1');

INSERT INTO countries VALUES (67,'Estonia','EE','EST','1');

INSERT INTO countries VALUES (68,'Ethiopia','ET','ETH','1');

INSERT INTO countries VALUES (69,'Falkland Islands (Malvinas)','FK','FLK','1');

INSERT INTO countries VALUES (70,'Faroe Islands','FO','FRO','1');

INSERT INTO countries VALUES (71,'Fiji','FJ','FJI','1');

INSERT INTO countries VALUES (72,'Finland','FI','FIN','1');

INSERT INTO countries VALUES (73,'France','FR','FRA','1');

INSERT INTO countries VALUES (74,'France, MEtropolitan','FX','FXX','1');

INSERT INTO countries VALUES (75,'French Guiana','GF','GUF','1');

INSERT INTO countries VALUES (76,'French Polynesia','PF','PYF','1');

INSERT INTO countries VALUES (77,'French Southern Territories','TF','ATF','1');

INSERT INTO countries VALUES (78,'Gabon','GA','GAB','1');

INSERT INTO countries VALUES (79,'Gambia','GM','GMB','1');

INSERT INTO countries VALUES (80,'Georgia','GE','GEO','1');

INSERT INTO countries VALUES (81,'Germany','DE','DEU','1');

INSERT INTO countries VALUES (82,'Ghana','GH','GHA','1');

INSERT INTO countries VALUES (83,'Gibraltar','GI','GIB','1');

INSERT INTO countries VALUES (84,'Greece','GR','GRC','1');

INSERT INTO countries VALUES (85,'Greenland','GL','GRL','1');

INSERT INTO countries VALUES (86,'Grenada','GD','GRD','1');

INSERT INTO countries VALUES (87,'Guadeloupe','GP','GLP','1');

INSERT INTO countries VALUES (88,'Guam','GU','GUM','1');

INSERT INTO countries VALUES (89,'Guatemala','GT','GTM','1');

INSERT INTO countries VALUES (90,'Guinea','GN','GIN','1');

INSERT INTO countries VALUES (91,'Guinea-bissau','GW','GNB','1');

INSERT INTO countries VALUES (92,'Guyana','GY','GUY','1');

INSERT INTO countries VALUES (93,'Haiti','HT','HTI','1');

INSERT INTO countries VALUES (94,'Heard and Mc Donald Islands','HM','HMD','1');

INSERT INTO countries VALUES (95,'Honduras','HN','HND','1');

INSERT INTO countries VALUES (96,'Hong Kong','HK','HKG','1');

INSERT INTO countries VALUES (97,'Hungary','HU','HUN','1');

INSERT INTO countries VALUES (98,'Iceland','IS','ISL','1');

INSERT INTO countries VALUES (99,'India','IN','IND','1');

INSERT INTO countries VALUES (100,'Indonesia','ID','IDN','1');

INSERT INTO countries VALUES (101,'Iran (Islamic Republic of)','IR','IRN','1');

INSERT INTO countries VALUES (102,'Iraq','IQ','IRQ','1');

INSERT INTO countries VALUES (103,'Ireland','IE','IRL','1');

INSERT INTO countries VALUES (104,'Israel','IL','ISR','1');

INSERT INTO countries VALUES (105,'Italy','IT','ITA','1');

INSERT INTO countries VALUES (106,'Jamaica','JM','JAM','1');

INSERT INTO countries VALUES (107,'Japan','JP','JPN','1');

INSERT INTO countries VALUES (108,'Jordan','JO','JOR','1');

INSERT INTO countries VALUES (109,'Kazakhstan','KZ','KAZ','1');

INSERT INTO countries VALUES (110,'Kenya','KE','KEN','1');

INSERT INTO countries VALUES (111,'Kiribati','KI','KIR','1');

INSERT INTO countries VALUES (112,'Korea, Democratic People's Republic of','KP','PRK','1');

INSERT INTO countries VALUES (113,'Korea, Republic of','KR','KOR','1');

INSERT INTO countries VALUES (114,'Kuwait','KW','KWT','1');

INSERT INTO countries VALUES (115,'Kyrgyzstan','KG','KGZ','1');

INSERT INTO countries VALUES (116,'Lao People's Democratic Republic','LA','LAO','1');

INSERT INTO countries VALUES (117,'Latvia','LV','LVA','1');

INSERT INTO countries VALUES (118,'Lebanon','LB','LBN','1');

INSERT INTO countries VALUES (119,'Lesotho','LS','LSO','1');

INSERT INTO countries VALUES (120,'Liberia','LR','LBR','1');

INSERT INTO countries VALUES (121,'Libyan Arab Jamahiriya','LY','LBY','1');

INSERT INTO countries VALUES (122,'Liechtenstein','LI','LIE','1');

INSERT INTO countries VALUES (123,'Lithuania','LT','LTU','1');

INSERT INTO countries VALUES (124,'Luxembourg','LU','LUX','1');

INSERT INTO countries VALUES (125,'Macau','MO','MAC','1');

INSERT INTO countries VALUES (126,'Macedonia, The Former Yugoslav Republic of','MK','MKD','1');

INSERT INTO countries VALUES (127,'Madagascar','MG','MDG','1');

INSERT INTO countries VALUES (128,'Malawi','MW','MWI','1');

INSERT INTO countries VALUES (129,'Malaysia','MY','MYS','1');

INSERT INTO countries VALUES (130,'Maldives','MV','MDV','1');

INSERT INTO countries VALUES (131,'Mali','ML','MLI','1');

INSERT INTO countries VALUES (132,'Malta','MT','MLT','1');

INSERT INTO countries VALUES (133,'Marshall Islands','MH','MHL','1');

INSERT INTO countries VALUES (134,'Martinique','MQ','MTQ','1');

INSERT INTO countries VALUES (135,'Mauritania','MR','MRT','1');

INSERT INTO countries VALUES (136,'Mauritius','MU','MUS','1');

INSERT INTO countries VALUES (137,'Mayotte','YT','MYT','1');

INSERT INTO countries VALUES (138,'Mexico','MX','MEX','1');

INSERT INTO countries VALUES (139,'Micronesia, Federated States of','FM','FSM','1');

INSERT INTO countries VALUES (140,'Moldova, Republic of','MD','MDA','1');

INSERT INTO countries VALUES (141,'Monaco','MC','MCO','1');

INSERT INTO countries VALUES (142,'Mongolia','MN','MNG','1');

INSERT INTO countries VALUES (143,'Montserrat','MS','MSR','1');

INSERT INTO countries VALUES (144,'Morocco','MA','MAR','1');

INSERT INTO countries VALUES (145,'Mozambique','MZ','MOZ','1');

INSERT INTO countries VALUES (146,'Myanmar','MM','MMR','1');

INSERT INTO countries VALUES (147,'Namibia','NA','NAM','1');

INSERT INTO countries VALUES (148,'Nauru','NR','NRU','1');

INSERT INTO countries VALUES (149,'Nepal','NP','NPL','1');

INSERT INTO countries VALUES (150,'Netherlands','NL','NLD','1');

INSERT INTO countries VALUES (151,'Netherlands Antilles','AN','ANT','1');

INSERT INTO countries VALUES (152,'New Caledonia','NC','NCL','1');

INSERT INTO countries VALUES (153,'New Zealand','NZ','NZL','1');

INSERT INTO countries VALUES (154,'Nicaragua','NI','NIC','1');

INSERT INTO countries VALUES (155,'Niger','NE','NER','1');

INSERT INTO countries VALUES (156,'Nigeria','NG','NGA','1');

INSERT INTO countries VALUES (157,'Niue','NU','NIU','1');

INSERT INTO countries VALUES (158,'Norfolk Island','NF','NFK','1');

INSERT INTO countries VALUES (159,'Northern Mariana Islands','MP','MNP','1');

INSERT INTO countries VALUES (160,'Norway','NO','NOR','1');

INSERT INTO countries VALUES (161,'Oman','OM','OMN','1');

INSERT INTO countries VALUES (162,'Pakistan','PK','PAK','1');

INSERT INTO countries VALUES (163,'Palau','PW','PLW','1');

INSERT INTO countries VALUES (164,'Panama','PA','PAN','1');

INSERT INTO countries VALUES (165,'Papua New Guinea','PG','PNG','1');

INSERT INTO countries VALUES (166,'Paraguay','PY','PRY','1');

INSERT INTO countries VALUES (167,'Peru','PE','PER','1');

INSERT INTO countries VALUES (168,'Philippines','PH','PHL','1');

INSERT INTO countries VALUES (169,'Pitcairn','PN','PCN','1');

INSERT INTO countries VALUES (170,'Poland','PL','POL','1');

INSERT INTO countries VALUES (171,'Portugal','PT','PRT','1');

INSERT INTO countries VALUES (172,'Puerto Rico','PR','PRI','1');

INSERT INTO countries VALUES (173,'Qatar','QA','QAT','1');

INSERT INTO countries VALUES (174,'Reunion','RE','REU','1');

INSERT INTO countries VALUES (175,'Romania','RO','ROM','1');

INSERT INTO countries VALUES (176,'Russian Federation','RU','RUS','1');

INSERT INTO countries VALUES (177,'Rwanda','RW','RWA','1');

INSERT INTO countries VALUES (178,'Saint Kitts and Nevis','KN','KNA','1');

INSERT INTO countries VALUES (179,'Saint Lucia','LC','LCA','1');

INSERT INTO countries VALUES (180,'Saint Vincent and the Grenadines','VC','VCT','1');

INSERT INTO countries VALUES (181,'Samoa','WS','WSM','1');

INSERT INTO countries VALUES (182,'San Marino','SM','SMR','1');

INSERT INTO countries VALUES (183,'Sao Tome and Principe','ST','STP','1');

INSERT INTO countries VALUES (184,'Saudi Arabia','SA','SAU','1');

INSERT INTO countries VALUES (185,'Senegal','SN','SEN','1');

INSERT INTO countries VALUES (186,'Seychelles','SC','SYC','1');

INSERT INTO countries VALUES (187,'Sierra Leone','SL','SLE','1');

INSERT INTO countries VALUES (188,'Singapore','SG','SGP', '4');

INSERT INTO countries VALUES (189,'Slovakia (Slovak Republic)','SK','SVK','1');

INSERT INTO countries VALUES (190,'Slovenia','SI','SVN','1');

INSERT INTO countries VALUES (191,'Solomon Islands','SB','SLB','1');

INSERT INTO countries VALUES (192,'Somalia','SO','SOM','1');

INSERT INTO countries VALUES (193,'south Africa','ZA','ZAF','1');

INSERT INTO countries VALUES (194,'South Georgia and the South Sandwich Islands','GS','SGS','1');

INSERT INTO countries VALUES (195,'Spain','ES','ESP','3');

INSERT INTO countries VALUES (196,'Sri Lanka','LK','LKA','1');

INSERT INTO countries VALUES (197,'St. Helena','SH','SHN','1');

INSERT INTO countries VALUES (198,'St. Pierre and Miquelon','PM','SPM','1');

INSERT INTO countries VALUES (199,'Sudan','SD','SDN','1');

INSERT INTO countries VALUES (200,'Suriname','SR','SUR','1');

INSERT INTO countries VALUES (201,'Svalbard and Jan Mayen Islands','SJ','SJM','1');

INSERT INTO countries VALUES (202,'Swaziland','SZ','SWZ','1');

INSERT INTO countries VALUES (203,'Sweden','SE','SWE','1');

INSERT INTO countries VALUES (204,'Switzerland','CH','CHE','1');

INSERT INTO countries VALUES (205,'Syrian Arab Republic','SY','SYR','1');

INSERT INTO countries VALUES (206,'Taiwan, Province of China','TW','TWN','1');

INSERT INTO countries VALUES (207,'Tajikistan','TJ','TJK','1');

INSERT INTO countries VALUES (208,'Tanzania, United Republic of','TZ','TZA','1');

INSERT INTO countries VALUES (209,'Thailand','TH','THA','1');

INSERT INTO countries VALUES (210,'Togo','TG','TGO','1');

INSERT INTO countries VALUES (211,'Tokelau','TK','TKL','1');

INSERT INTO countries VALUES (212,'Tonga','TO','TON','1');

INSERT INTO countries VALUES (213,'Trinidad and Tobago','TT','TTO','1');

INSERT INTO countries VALUES (214,'Tunisia','TN','TUN','1');

INSERT INTO countries VALUES (215,'Turkey','TR','TUR','1');

INSERT INTO countries VALUES (216,'Turkmenistan','TM','TKM','1');

INSERT INTO countries VALUES (217,'Turks and Caicos Islands','TC','TCA','1');

INSERT INTO countries VALUES (218,'Tuvalu','TV','TUV','1');

INSERT INTO countries VALUES (219,'Uganda','UG','UGA','1');

INSERT INTO countries VALUES (220,'Ukraine','UA','UKR','1');

INSERT INTO countries VALUES (221,'United Arab Emirates','AE','ARE','1');

INSERT INTO countries VALUES (222,'United Kingdom','GB','GBR','1');

INSERT INTO countries VALUES (223,'United States','US','USA', '2');

INSERT INTO countries VALUES (224,'United States Minor Outlying Islands','UM','UMI','1');

INSERT INTO countries VALUES (225,'Uruguay','UY','URY','1');

INSERT INTO countries VALUES (226,'Uzbekistan','UZ','UZB','1');

INSERT INTO countries VALUES (227,'Vanuatu','VU','VUT','1');

INSERT INTO countries VALUES (228,'Vatican City State (Holy See)','VA','VAT','1');

INSERT INTO countries VALUES (229,'Venezuela','VE','VEN','1');

INSERT INTO countries VALUES (230,'Viet Nam','VN','VNM','1');

INSERT INTO countries VALUES (231,'Virgin Islands (British)','VG','VGB','1');

INSERT INTO countries VALUES (232,'Virgin Islands (U.S.)','VI','VIR','1');

INSERT INTO countries VALUES (233,'Wallis and Futuna Islands','WF','WLF','1');

INSERT INTO countries VALUES (234,'Western Sahara','EH','ESH','1');

INSERT INTO countries VALUES (235,'Yemen','YE','YEM','1');

INSERT INTO countries VALUES (236,'Yugoslavia','YU','YUG','1');

INSERT INTO countries VALUES (237,'Zaire','ZR','ZAR','1');

INSERT INTO countries VALUES (238,'Zambia','ZM','ZMB','1');

INSERT INTO countries VALUES (239,'Zimbabwe','ZW','ZWE','1');

INSERT INTO currencies VALUES (1,'US Dollar','USD','$','USD','.',',','2');

INSERT INTO currencies VALUES (2,'Deutsche Mark','DEM','','DM',',','.','2');

INSERT INTO currencies VALUES (3,'Spanish Peseta','ESP','','Pts','.',',','0');

INSERT INTO currencies VALUES (4,'Euro','EUR','?','','.',',','2');

INSERT INTO languages VALUES (1,'English','en','flag_en.gif','english',1);

INSERT INTO languages VALUES (2,'Deutsch','de','flag_de.gif','german',2);

INSERT INTO languages VALUES (3,'Esp?nol','es','flag_es.gif','espanol',3);

INSERT INTO manufacturers VALUES (1,'Matrox','images/manufacturer_matrox.gif');

INSERT INTO manufacturers VALUES (2,'Microsoft','images/manufacturer_microsoft.gif');

INSERT INTO manufacturers VALUES (3,'Warner','images/manufacturer_warner.gif');

INSERT INTO manufacturers VALUES (4,'Fox','images/manufacturer_fox.gif');

INSERT INTO manufacturers VALUES (5,'Logitech','images/manufacturer_logitech.gif');

INSERT INTO manufacturers VALUES (6,'Canon','images/manufacturer_canon.gif');

INSERT INTO manufacturers VALUES (7,'Sierra','images/manufacturer_sierra.gif');

INSERT INTO manufacturers VALUES (8,'GT Interactive','images/manufacturer_gt_interactive.gif');

INSERT INTO manufacturers VALUES (9,'Hewlett Packard','images/manufacturer_hewlett_packard.gif');

INSERT INTO products VALUES (1,'Matrox G200 MMS','Reinforcing its position as a multi-monitor trailblazer, Matrox Graphics Inc. has once again developed the most flexible and highly advanced solution in the industry. Introducing the new Matrox G200 Multi-Monitor Series; the first graphics card ever to support up to four DVI digital flat panel displays on a single 8" PCI board. With continuing demand for digital flat panels in the financial workplace, the Matrox G200 MMS is the ultimate in flexible solutions. The Matrox G200 MMS also supports the new digital video interface (DVI) created by the Digital Display Working Group (DDWG) designed to ease the adoption of digital flat panels. Other configurations include composite video capture ability and onboard TV tuner, making the Matrox G200 MMS the complete solution for business needs. Based on the award-winning MGA-G200 graphics chip, the Matrox G200 Multi-Monitor Series provides superior 2D/3D graphics acceleration to meet the demanding needs of business applications such as real-time stock quotes (Versus), live video feeds (Reuters & Bloombergs), multiple windows applications, word processing, spreadsheets and CAD.',32,'MG200MMS','images/matrox/mg200mms.gif','www.matrox.com/mga/feat_story/jun99/mms_g200.htm',299.99,'19991217',219,23.00,1,1,1);

INSERT INTO products VALUES (2,'Matrox G400 32MB','Dramatically Different High Performance Graphics Introducing the Millennium G400 Series - a dramatically different, high performance graphics experience. Armed with the industry's fastest graphics chip, the Millennium G400 Series takes explosive acceleration two steps further by adding unprecedented image quality, along with the most versatile display options for all your 3D, 2D and DVD applications. As the most powerful and innovative tools in your PC's arsenal, the Millennium G400 Series will not only change the way you see graphics, but will revolutionize the way you use your computer. Key features:<ul><li>New Matrox G400 256-bit DualBus graphics chip</li><li>Explosive 3D, 2D and DVD performance</li><li>DualHead Display</li><li>Superior DVD and TV output</li><li>3D Environment-Mapped Bump Mapping</li><li>Vibrant Color Quality rendering </li><li>UltraSharp DAC of up to 360 MHz</li><li>3D Rendering Array Processor</li><li>Support for 16 or 32 MB of memory</li></ul>',32,'MG400-32MB','images/matrox/mg400-32mb.gif','www.matrox.com/mga/products/mill_g400/home.htm',499.99,'19991217',228,23.00,1,1,1);

INSERT INTO products VALUES (4,'The Replacement Killers','Regional Code: 2 (Japan, Europe, Middle East, South Africa). Languages: English, Deutsch. Subtitles: English, Deutsch, Spanish. Audio: Dolby Surround 5.1. Picture Format: 16:9 Wide-Screen. Length: (approx) 80 minutes. Other: Interactive Menus, Chapter Selection, Subtitles (more languages).',13,'DVD-RPMK','images/dvd/replacement_killers.gif','www.replacement-killers.com',42.00,'20000109',15,23.00,1,1,2);

INSERT INTO products VALUES (3,'Microsoft IntelliMouse Pro','Every element of IntelliMouse Pro - from its unique arched shape to the texture of the rubber grip around its base - is the product of extensive customer and ergonomic research. Microsoft's popular wheel control, which now allows zooming and universal scrolling functions, gives IntelliMouse Pro outstanding comfort and efficiency.',32,'MSIMPRO','images/microsoft/msimpro.gif','www.microsoft.com/products/hardware/mouse/impro/default.htm',49.99,'20000105',346,7.00,1,1,3);

INSERT INTO products VALUES (5,'Blade Runner - Director's Cut','Regional Code: 2 (Japan, Europe, Middle East, South Africa). Languages: English, Deutsch. Subtitles: English, Deutsch, Spanish. Audio: Dolby Surround 5.1. Picture Format: 16:9 Wide-Screen. Length: (approx) 112 minutes. Other: Interactive Menus, Chapter Selection, Subtitles (more languages).',17,'DVD-BLDRNDC','images/dvd/blade_runner.gif','www.bladerunner.com',35.99,'20000109',217,7.00,1,1,3);

INSERT INTO products VALUES (7,'You've Got Mail','Regional Code: 2 (Japan, Europe, Middle East, South Africa).r nLanguages: English, Deutsch, Spanish.r nSubtitles: English, Deutsch, Spanish, French, Nordic, Polish.r nAudio: Dolby Digital 5.1.r nPicture Format: 16:9 Wide-Screen.r nLength: (approx) 115 minutes.r nOther: Interactive Menus, Chapter Selection, Subtitles (more languages).',10,'DVD-YGEM','images/dvd/youve_got_mail.gif','www.youvegotemail.com',34.99,'20000115',94,7.00,1,1,3);

INSERT INTO products VALUES (6,'The Matrix','Regional Code: 2 (Japan, Europe, Middle East, South Africa).r nLanguages: English, Deutsch.r nSubtitles: English, Deutsch.r nAudio: Dolby Surround.r nPicture Format: 16:9 Wide-Screen.r nLength: (approx) 131 minutes.r nOther: Interactive Menus, Chapter Selection, Making Of.',10,'DVD-MATR','images/dvd/the_matrix.gif','www.thematrix.com',39.99,'20000115',443,7.00,1,1,3);

INSERT INTO products VALUES (8,'A Bug's Life','Regional Code: 2 (Japan, Europe, Middle East, South Africa).r nLanguages: English, Deutsch.r nSubtitles: English, Deutsch, Spanish.r nAudio: Dolby Digital 5.1 / Dobly Surround Stereo.r nPicture Format: 16:9 Wide-Screen.r nLength: (approx) 91 minutes.r nOther: Interactive Menus, Chapter Selection, Subtitles (m

June 11, 2003

Maybe you should restart your installation and follow the step by step here

http://wiki.oscommerce.com/helpInstallNew

HTH

The_Bear

tordeman · June 11, 2003

don't have the configure.php anywhere, do you know somewhere i can get that one from? nad i dont have the install fils either, tahnks for any help!

June 11, 2003

If you dont have configure.php you have install ver2.1 wich is not supported no more

install ver2.2MS1

HTH

The_Bear

tordeman · June 11, 2003

If you dont have configure.php you have install ver2.1 wich is not supported no more
install ver2.2MS1

HTH

The_Bear

okay, thanks.

Got a new problem, during the installation, in step 5 i got this message:

Warning: Unable to access /usr/local/psa/home/vhosts/smallville-fan.com/httpdocs/webshop/catalog/admin/includes/configure.php in /usr/local/psa/home/vhosts/smallville-fan.com/httpdocs/webshop/catalog/install/templates/pages/install_5.php on line 164



Warning: fopen("/usr/local/psa/home/vhosts/smallville-fan.com/httpdocs/webshop/catalog/admin/includes/configure.php", "w") - No such file or directory in /usr/local/psa/home/vhosts/smallville-fan.com/httpdocs/webshop/catalog/install/templates/pages/install_5.php on line 164



Warning: fputs(): supplied argument is not a valid File-Handle resource in /usr/local/psa/home/vhosts/smallville-fan.com/httpdocs/webshop/catalog/install/templates/pages/install_5.php on line 165



Warning: fclose(): supplied argument is not a valid File-Handle resource in /usr/local/psa/home/vhosts/smallville-fan.com/httpdocs/webshop/catalog/install/templates/pages/install_5.php on line 166

bot the configure.php fils have 706 i have also tried 777, know how to help me?

can't get into teh default,php file!

Recommended Posts

tordeman

tordeman

Guest

tordeman

Guest

tordeman

Archived

Browse

Activity