Quick UK Localisation - Bootstrap version?

[sigspace]

hello,

is there an oscommerce 2.3.4 bootstrap add-on for Quick UK Localisation feature yet?

 

i can only find this add-on for earlier oscommerce version:  http://addons.oscommerce.com/info/7845

Help to get a UK oscommerce 2.3.4 bootstrap store base set would be appreciated.

Thanks!

[Hotclutch]

Have you tried installing it? It's only the front end that's bootstrap, and that addon looks like it might be a backend mod.

[sigspace]

can see front end files "create_account.php" and files inside "includes/modules/" that need changing.
i remember reading on this forum about DB changes for 2.3.4 bootstrap, so are all of these update/insert SQL commands valid for the new 2.3.4 bootstrap DB?

# UK Additions to the database follow
SET NAMES latin1;
UPDATE configuration SET configuration_value='222' WHERE configuration_key = 'SHIPPING_ORIGIN_COUNTRY';
UPDATE configuration SET configuration_value='222' WHERE configuration_key = 'STORE_COUNTRY';
UPDATE configuration SET configuration_value='0' WHERE configuration_key = 'STORE_ZONE';
UPDATE configuration SET configuration_value='GBP' WHERE configuration_key = 'DEFAULT_CURRENCY';
UPDATE tax_rates SET tax_rate=20.0000, tax_description='VAT (20%)' WHERE tax_rates_id=1;
UPDATE geo_zones SET geo_zone_name='European Countries', geo_zone_description='EU VAT zone' WHERE geo_zone_id = 1;
INSERT INTO address_format VALUES (NULL, '$firstname $lastname$cr$streets$cr$city$cr$postcode$cr$country','$city / $country');
UPDATE countries SET address_format_id = last_insert_id() WHERE countries_id = 222;
DELETE FROM zones_to_geo_zones WHERE geo_zone_id =1;
INSERT INTO zones_to_geo_zones (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (32, 117, 0, 1, NULL, now());
INSERT INTO zones_to_geo_zones (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (31, 105, 0, 1, NULL, now());
INSERT INTO zones_to_geo_zones (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (30, 103, 0, 1, NULL, now());
INSERT INTO zones_to_geo_zones (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (29, 98, 0, 1, NULL, now());
INSERT INTO zones_to_geo_zones (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (28, 97, 0, 1, NULL, now());
INSERT INTO zones_to_geo_zones (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (27, 84, 0, 1, NULL, now());
INSERT INTO zones_to_geo_zones (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (25, 81, 0, 1, NULL, now());
INSERT INTO zones_to_geo_zones (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (24, 73, 0, 1, NULL, now());
INSERT INTO zones_to_geo_zones (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (23, 72, 0, 1, NULL, now());
INSERT INTO zones_to_geo_zones (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (22, 67, 0, 1, NULL, now());
INSERT INTO zones_to_geo_zones (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (21, 57, 0, 1, NULL, now());
INSERT INTO zones_to_geo_zones (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (20, 56, 0, 1, NULL, now());
INSERT INTO zones_to_geo_zones (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (19, 55, 0, 1, NULL, now());
INSERT INTO zones_to_geo_zones (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (18, 21, 0, 1, NULL, now());
INSERT INTO zones_to_geo_zones (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (17, 14, 0, 1, NULL, now());
INSERT INTO zones_to_geo_zones (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (33, 123, 0, 1, NULL, now());
INSERT INTO zones_to_geo_zones (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (34, 124, 0, 1, NULL, now());
INSERT INTO zones_to_geo_zones (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (35, 132, 0, 1, NULL, now());
INSERT INTO zones_to_geo_zones (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (36, 150, 0, 1, NULL, now());
INSERT INTO zones_to_geo_zones (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (37, 160, 0, 1, NULL, now());
INSERT INTO zones_to_geo_zones (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (38, 170, 0, 1, NULL, now());
INSERT INTO zones_to_geo_zones (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (46, 171, 0, 1, NULL, now());
INSERT INTO zones_to_geo_zones (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (47, 189, 0, 1, NULL, now());
INSERT INTO zones_to_geo_zones (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (48, 190, 0, 1, NULL, now());
INSERT INTO zones_to_geo_zones (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (49, 195, 0, 1, NULL, now());
INSERT INTO zones_to_geo_zones (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (50, 203, 0, 1, NULL, now());
INSERT INTO zones_to_geo_zones (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (51, 204, 0, 1, NULL, now());
INSERT INTO zones_to_geo_zones (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (52, 222, 0, 1, NULL, now());
UPDATE currencies SET title ='UK Pound', code='GBP' WHERE currencies_id = 1;
UPDATE currencies SET symbol_left='£' WHERE currencies_id = 1;

[Hotclutch]

I can't see those as being a problem. Perhaps somebody who uses this addon can confirm.

[♥bruyndoncx]

these sql are fine for bootstrap too - nothing different in the configuration table

[♥kymation]

This line is a problem:

SET NAMES latin1;

The Bootstrap database is UTF-8, not latin1. Remove that line and it should work.

 

Regards

Jim