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
|