View Single Post
  #5  
Old 07-24-2007, 02:29 AM
  chamberinternet's Avatar 
chamberinternet chamberinternet is offline
 

X-Wizard
  
Join Date: Sep 2005
Location: Lancashire, UK
Posts: 1,471
 

Default Re: UK Shipping Countries Nothern Ireland & Channel Islands

Here is how I did it in 4.1.8:

INSERT INTO xcart_countries VALUES ('IM','IMN',833,'EU','iso-8859-1','Y','D','Y');
INSERT INTO xcart_languages VALUES ('US','country_IM','Isle of Man','Countries');
INSERT INTO xcart_languages VALUES ('US','language_IM','Language of Isle of Man','Languages');

INSERT INTO xcart_countries VALUES ('ZZ','ZZZ',999,'EU','iso-8859-1','Y','D','Y');
INSERT INTO xcart_languages VALUES ('US','country_ZZ','Northern Ireland','Countries');
INSERT INTO xcart_languages VALUES ('US','language_ZZ','Language of Northern Ireland','Languages');

INSERT INTO xcart_countries VALUES ('JE','JEY',832,'EU','iso-8859-1','Y','D','Y');
INSERT INTO xcart_languages VALUES ('US','country_JE','Jersey','Countries');
INSERT INTO xcart_languages VALUES ('US','language_JE','Language of Jersey','Languages');

INSERT INTO xcart_countries VALUES ('GG','GGY',831,'EU','iso-8859-1','Y','D','Y');
INSERT INTO xcart_languages VALUES ('US','country_GG','Guernsey','Countries');
INSERT INTO xcart_languages VALUES ('US','language_GG','Language of Guernsey','Languages');

Regards

Shafiq :sK
__________________
Developing in 4.7.x now (Dipping into v5 - Slowly!)
Have used 4.1.x, 4.2.x, 4.4.x, 4.5.x, 4.6.x & 4.7.x
Multiple Instances of X-Cart
MySQL 5.6.37
CentOS 7.4


Chamber Internet
- Lancashire, United Kingdom
http://www.chamberelancs.co.uk
Reply With Quote