For all running Zen-Cart 1.3.8a in german: If you would like to have the countries translated into german, you can run this two sql-scripts within your database-table "countries".
The first script will replace all english country-names into german names:
The second sql-script will delete three countries: AQ (Antarktis), YU (Jugoslawien) und FX (Metropolitan-Frankreich). I guess they will never be needed (again):Code:UPDATE countries SET countries_name='Aaland Inseln' WHERE countries_iso_code_2='AX'; UPDATE countries SET countries_name='Afghanistan' WHERE countries_iso_code_2='AF'; UPDATE countries SET countries_name='Albanien' WHERE countries_iso_code_2='AL'; UPDATE countries SET countries_name='Algerien' WHERE countries_iso_code_2='DZ'; UPDATE countries SET countries_name='Samoa (amerikanischer Teil)' WHERE countries_iso_code_2='AS'; UPDATE countries SET countries_name='Andorra' WHERE countries_iso_code_2='AD'; UPDATE countries SET countries_name='Angola' WHERE countries_iso_code_2='AO'; UPDATE countries SET countries_name='Anguilla' WHERE countries_iso_code_2='AI'; UPDATE countries SET countries_name='Antarktis' WHERE countries_iso_code_2='AQ'; UPDATE countries SET countries_name='Antigua und Barbuda' WHERE countries_iso_code_2='AG'; UPDATE countries SET countries_name='Argentinien' WHERE countries_iso_code_2='AR'; UPDATE countries SET countries_name='Armenien' WHERE countries_iso_code_2='AM'; UPDATE countries SET countries_name='Aruba' WHERE countries_iso_code_2='AW'; UPDATE countries SET countries_name='Australien' WHERE countries_iso_code_2='AU'; UPDATE countries SET countries_name='Österreich' WHERE countries_iso_code_2='AT'; UPDATE countries SET countries_name='Aserbaidschan' WHERE countries_iso_code_2='AZ'; UPDATE countries SET countries_name='Bahamas' WHERE countries_iso_code_2='BS'; UPDATE countries SET countries_name='Bahrain' WHERE countries_iso_code_2='BH'; UPDATE countries SET countries_name='Bangladesh' WHERE countries_iso_code_2='BD'; UPDATE countries SET countries_name='Barbados' WHERE countries_iso_code_2='BB'; UPDATE countries SET countries_name='Belarus' WHERE countries_iso_code_2='BY'; UPDATE countries SET countries_name='Belgien' WHERE countries_iso_code_2='BE'; UPDATE countries SET countries_name='Belize' WHERE countries_iso_code_2='BZ'; UPDATE countries SET countries_name='Benin' WHERE countries_iso_code_2='BJ'; UPDATE countries SET countries_name='Bermuda' WHERE countries_iso_code_2='BM'; UPDATE countries SET countries_name='Bhutan' WHERE countries_iso_code_2='BT'; UPDATE countries SET countries_name='Bolivien' WHERE countries_iso_code_2='BO'; UPDATE countries SET countries_name='Bosnien-Herzegowina' WHERE countries_iso_code_2='BA'; UPDATE countries SET countries_name='Botswana' WHERE countries_iso_code_2='BW'; UPDATE countries SET countries_name='Bouvet Insel' WHERE countries_iso_code_2='BV'; UPDATE countries SET countries_name='Brasilien' WHERE countries_iso_code_2='BR'; UPDATE countries SET countries_name='Britische Territorium im Indischen Ozean' WHERE countries_iso_code_2='IO'; UPDATE countries SET countries_name='Brunei Darussalam' WHERE countries_iso_code_2='BN'; UPDATE countries SET countries_name='Bulgarien' WHERE countries_iso_code_2='BG'; UPDATE countries SET countries_name='Burkina Faso' WHERE countries_iso_code_2='BF'; UPDATE countries SET countries_name='Burundi' WHERE countries_iso_code_2='BI'; UPDATE countries SET countries_name='Kambodscha' WHERE countries_iso_code_2='KH'; UPDATE countries SET countries_name='Kamerun' WHERE countries_iso_code_2='CM'; UPDATE countries SET countries_name='Kanada' WHERE countries_iso_code_2='CA'; UPDATE countries SET countries_name='Kapverdische Inseln' WHERE countries_iso_code_2='CV'; UPDATE countries SET countries_name='Cayman Islands' WHERE countries_iso_code_2='KY'; UPDATE countries SET countries_name='Zentralafrika' WHERE countries_iso_code_2='CF'; UPDATE countries SET countries_name='Tschad' WHERE countries_iso_code_2='TD'; UPDATE countries SET countries_name='Chile' WHERE countries_iso_code_2='CL'; UPDATE countries SET countries_name='China' WHERE countries_iso_code_2='CN'; UPDATE countries SET countries_name='Weihnachtsinsel' WHERE countries_iso_code_2='CX'; UPDATE countries SET countries_name='Kokos-Inseln' WHERE countries_iso_code_2='CC'; UPDATE countries SET countries_name='Kolumbien' WHERE countries_iso_code_2='CO'; UPDATE countries SET countries_name='Komoren' WHERE countries_iso_code_2='KM'; UPDATE countries SET countries_name='Kongo, Republik' WHERE countries_iso_code_2= 'CG'; UPDATE countries SET countries_name='Cookinseln' WHERE countries_iso_code_2='CK'; UPDATE countries SET countries_name='Costa Rica' WHERE countries_iso_code_2='CR'; UPDATE countries SET countries_name='Elvenbeinküste' WHERE countries_iso_code_2='CI'; UPDATE countries SET countries_name='Kroatien' WHERE countries_iso_code_2='HR'; UPDATE countries SET countries_name='Kuba' WHERE countries_iso_code_2='CU'; UPDATE countries SET countries_name='Zypern' WHERE countries_iso_code_2='CY'; UPDATE countries SET countries_name='Tschechische Republik' WHERE countries_iso_code_2='CZ'; UPDATE countries SET countries_name='Dänemark' WHERE countries_iso_code_2='DK'; UPDATE countries SET countries_name='Djibouti' WHERE countries_iso_code_2='DJ'; UPDATE countries SET countries_name='Dominica' WHERE countries_iso_code_2='DM'; UPDATE countries SET countries_name='Dominikanische Republik' WHERE countries_iso_code_2='DO'; UPDATE countries SET countries_name='Osttimor' WHERE countries_iso_code_2='TP'; UPDATE countries SET countries_name='Ekuador' WHERE countries_iso_code_2='EC'; UPDATE countries SET countries_name='Ägypten' WHERE countries_iso_code_2='EG'; UPDATE countries SET countries_name='El Salvador' WHERE countries_iso_code_2='SV'; UPDATE countries SET countries_name='Äquatorial-Guinea' WHERE countries_iso_code_2='GQ'; UPDATE countries SET countries_name='Eritrea' WHERE countries_iso_code_2='ER'; UPDATE countries SET countries_name='Estland' WHERE countries_iso_code_2='EE'; UPDATE countries SET countries_name='Äthiopien' WHERE countries_iso_code_2='ET'; UPDATE countries SET countries_name='Falkland' WHERE countries_iso_code_2='FK'; UPDATE countries SET countries_name='Färöer' WHERE countries_iso_code_2='FO'; UPDATE countries SET countries_name='Fidschi' WHERE countries_iso_code_2='FJ'; UPDATE countries SET countries_name='Finnland' WHERE countries_iso_code_2='FI'; UPDATE countries SET countries_name='Frankreich' WHERE countries_iso_code_2='FR'; UPDATE countries SET countries_name='Metropolitan-Frankreich' WHERE countries_iso_code_2= 'FX'; UPDATE countries SET countries_name='Französisch-Guayana' WHERE countries_iso_code_2='GF'; UPDATE countries SET countries_name='Französisch-Polynesien' WHERE countries_iso_code_2='PF'; UPDATE countries SET countries_name='Französische Südgebiete' WHERE countries_iso_code_2='TF'; UPDATE countries SET countries_name='Gabun' WHERE countries_iso_code_2='GA'; UPDATE countries SET countries_name='Gambia' WHERE countries_iso_code_2='GM'; UPDATE countries SET countries_name='Georgien' WHERE countries_iso_code_2='GE'; UPDATE countries SET countries_name='Deutschland' WHERE countries_iso_code_2='DE'; UPDATE countries SET countries_name='Ghana' WHERE countries_iso_code_2='GH'; UPDATE countries SET countries_name='Gibraltar' WHERE countries_iso_code_2='GI'; UPDATE countries SET countries_name='Griechenland' WHERE countries_iso_code_2='GR'; UPDATE countries SET countries_name='Grönland' WHERE countries_iso_code_2='GL'; UPDATE countries SET countries_name='Grenada' WHERE countries_iso_code_2='GD'; UPDATE countries SET countries_name='Guadeloupe' WHERE countries_iso_code_2='GP'; UPDATE countries SET countries_name='Guam' WHERE countries_iso_code_2='GU'; UPDATE countries SET countries_name='Guatemala' WHERE countries_iso_code_2='GT'; UPDATE countries SET countries_name='Guinea, Republik' WHERE countries_iso_code_2= 'GN'; UPDATE countries SET countries_name='Guinea-Bissau' WHERE countries_iso_code_2='GW'; UPDATE countries SET countries_name='Guyana' WHERE countries_iso_code_2='GY'; UPDATE countries SET countries_name='Haiti' WHERE countries_iso_code_2='HT'; UPDATE countries SET countries_name='Heard und die Mc Donald Inseln' WHERE countries_iso_code_2='HM'; UPDATE countries SET countries_name='Honduras' WHERE countries_iso_code_2='HN'; UPDATE countries SET countries_name='Hongkong' WHERE countries_iso_code_2='HK'; UPDATE countries SET countries_name='Ungarn' WHERE countries_iso_code_2='HU'; UPDATE countries SET countries_name='Island' WHERE countries_iso_code_2='IS'; UPDATE countries SET countries_name='Indien' WHERE countries_iso_code_2='IN'; UPDATE countries SET countries_name='Indonesien' WHERE countries_iso_code_2='ID'; UPDATE countries SET countries_name='Iran' WHERE countries_iso_code_2='IR'; UPDATE countries SET countries_name='Irak' WHERE countries_iso_code_2='IQ'; UPDATE countries SET countries_name='Irland' WHERE countries_iso_code_2='IE'; UPDATE countries SET countries_name='Israel' WHERE countries_iso_code_2='IL'; UPDATE countries SET countries_name='Italien' WHERE countries_iso_code_2='IT'; UPDATE countries SET countries_name='Jamaika' WHERE countries_iso_code_2='JM'; UPDATE countries SET countries_name='Japan' WHERE countries_iso_code_2='JP'; UPDATE countries SET countries_name='Jordanien' WHERE countries_iso_code_2='JO'; UPDATE countries SET countries_name='Kasachstan' WHERE countries_iso_code_2='KZ'; UPDATE countries SET countries_name='Kenya' WHERE countries_iso_code_2='KE'; UPDATE countries SET countries_name='Kiribati' WHERE countries_iso_code_2='KI'; UPDATE countries SET countries_name='Korea, Demo. Volksrepublik (Nordkorea)' WHERE countries_iso_code_2= 'KP'; UPDATE countries SET countries_name='Korea, Republik (Südkorea)' WHERE countries_iso_code_2= 'KR'; UPDATE countries SET countries_name='Kuwait' WHERE countries_iso_code_2='KW'; UPDATE countries SET countries_name='Kirgisistan' WHERE countries_iso_code_2='KG'; UPDATE countries SET countries_name='Laos' WHERE countries_iso_code_2='LA'; UPDATE countries SET countries_name='Lettland' WHERE countries_iso_code_2='LV'; UPDATE countries SET countries_name='Libanon' WHERE countries_iso_code_2='LB'; UPDATE countries SET countries_name='Lesotho' WHERE countries_iso_code_2='LS'; UPDATE countries SET countries_name='Liberia' WHERE countries_iso_code_2='LR'; UPDATE countries SET countries_name='Libyen' WHERE countries_iso_code_2='LY'; UPDATE countries SET countries_name='Liechtenstein' WHERE countries_iso_code_2='LI'; UPDATE countries SET countries_name='Litauen' WHERE countries_iso_code_2='LT'; UPDATE countries SET countries_name='Luxemburg' WHERE countries_iso_code_2='LU'; UPDATE countries SET countries_name='Macau' WHERE countries_iso_code_2='MO'; UPDATE countries SET countries_name='Mazedonien (ehemalige jugoslawische Republik)' WHERE countries_iso_code_2='MK'; UPDATE countries SET countries_name='Madagaskar' WHERE countries_iso_code_2='MG'; UPDATE countries SET countries_name='Malawi' WHERE countries_iso_code_2='MW'; UPDATE countries SET countries_name='Malaysia' WHERE countries_iso_code_2='MY'; UPDATE countries SET countries_name='Malediven' WHERE countries_iso_code_2='MV'; UPDATE countries SET countries_name='Mali' WHERE countries_iso_code_2='ML'; UPDATE countries SET countries_name='Malta' WHERE countries_iso_code_2='MT'; UPDATE countries SET countries_name='Marshallinseln' WHERE countries_iso_code_2='MH'; UPDATE countries SET countries_name='Martinique' WHERE countries_iso_code_2='MQ'; UPDATE countries SET countries_name='Mauretanien' WHERE countries_iso_code_2='MR'; UPDATE countries SET countries_name='Mauritius' WHERE countries_iso_code_2='MU'; UPDATE countries SET countries_name='Mayotte' WHERE countries_iso_code_2='YT'; UPDATE countries SET countries_name='Mexiko' WHERE countries_iso_code_2='MX'; UPDATE countries SET countries_name='Mikronesien' WHERE countries_iso_code_2='FM'; UPDATE countries SET countries_name='Moldova' WHERE countries_iso_code_2='MD'; UPDATE countries SET countries_name='Monaco' WHERE countries_iso_code_2='MC'; UPDATE countries SET countries_name='Mongolei' WHERE countries_iso_code_2='MN'; UPDATE countries SET countries_name='Montserrat' WHERE countries_iso_code_2='MS'; UPDATE countries SET countries_name='Marokko' WHERE countries_iso_code_2='MA'; UPDATE countries SET countries_name='Mosambik' WHERE countries_iso_code_2='MZ'; UPDATE countries SET countries_name='Myanmar (Union)' WHERE countries_iso_code_2='MM'; UPDATE countries SET countries_name='Namibia' WHERE countries_iso_code_2='NA'; UPDATE countries SET countries_name='Nauru' WHERE countries_iso_code_2='NR'; UPDATE countries SET countries_name='Nepal' WHERE countries_iso_code_2='NP'; UPDATE countries SET countries_name='Niederlande' WHERE countries_iso_code_2='NL'; UPDATE countries SET countries_name='Niederländische Antillen' WHERE countries_iso_code_2='AN'; UPDATE countries SET countries_name='Neukaledonien' WHERE countries_iso_code_2='NC'; UPDATE countries SET countries_name='Neuseeland' WHERE countries_iso_code_2='NZ'; UPDATE countries SET countries_name='Nikaragua' WHERE countries_iso_code_2='NI'; UPDATE countries SET countries_name='Niger' WHERE countries_iso_code_2='NE'; UPDATE countries SET countries_name='Nigeria' WHERE countries_iso_code_2='NG'; UPDATE countries SET countries_name='Niue' WHERE countries_iso_code_2='NU'; UPDATE countries SET countries_name='Norfolk' WHERE countries_iso_code_2='NF'; UPDATE countries SET countries_name='Marianen, nördliche' WHERE countries_iso_code_2= 'MP'; UPDATE countries SET countries_name='Norwegen' WHERE countries_iso_code_2= 'NO'; UPDATE countries SET countries_name='Oman' WHERE countries_iso_code_2='OM'; UPDATE countries SET countries_name='Pakistan' WHERE countries_iso_code_2='PK'; UPDATE countries SET countries_name='Palau' WHERE countries_iso_code_2='PW'; UPDATE countries SET countries_name='Panama' WHERE countries_iso_code_2='PA'; UPDATE countries SET countries_name='Papua-Neuguinea' WHERE countries_iso_code_2='PG'; UPDATE countries SET countries_name='Paraguay' WHERE countries_iso_code_2='PY'; UPDATE countries SET countries_name='Peru' WHERE countries_iso_code_2='PE'; UPDATE countries SET countries_name='Philippines' WHERE countries_iso_code_2='PH'; UPDATE countries SET countries_name='Pitcairn' WHERE countries_iso_code_2='PN'; UPDATE countries SET countries_name='Polen' WHERE countries_iso_code_2='PL'; UPDATE countries SET countries_name='Portugal' WHERE countries_iso_code_2='PT'; UPDATE countries SET countries_name='Puerto Rico' WHERE countries_iso_code_2='PR'; UPDATE countries SET countries_name='Qatar' WHERE countries_iso_code_2='QA'; UPDATE countries SET countries_name='Réunion' WHERE countries_iso_code_2='RE'; UPDATE countries SET countries_name='Rumänien' WHERE countries_iso_code_2='RO'; UPDATE countries SET countries_name='Russische Föderation' WHERE countries_iso_code_2='RU'; UPDATE countries SET countries_name='Rwanda' WHERE countries_iso_code_2='RW'; UPDATE countries SET countries_name='St. Christoph und Nevis' WHERE countries_iso_code_2='KN'; UPDATE countries SET countries_name='Saint Lucia' WHERE countries_iso_code_2='LC'; UPDATE countries SET countries_name='St. Vincent und die Grenadinen' WHERE countries_iso_code_2='VC'; UPDATE countries SET countries_name='West Samoa (Savaii, Upola)' WHERE countries_iso_code_2= 'WS'; UPDATE countries SET countries_name='San Marino' WHERE countries_iso_code_2='SM'; UPDATE countries SET countries_name='St. Thomas und Principe' WHERE countries_iso_code_2='ST'; UPDATE countries SET countries_name='Saudi-Arabien' WHERE countries_iso_code_2='SA'; UPDATE countries SET countries_name='Senegal' WHERE countries_iso_code_2='SN'; UPDATE countries SET countries_name='Seychellen' WHERE countries_iso_code_2='SC'; UPDATE countries SET countries_name='Sierra Leone' WHERE countries_iso_code_2='SL'; UPDATE countries SET countries_name='Singapur' WHERE countries_iso_code_2='SG'; UPDATE countries SET countries_name='Slowakische Republik' WHERE countries_iso_code_2='SK'; UPDATE countries SET countries_name='Slowenien' WHERE countries_iso_code_2='SI'; UPDATE countries SET countries_name='Salomon-Inseln' WHERE countries_iso_code_2='SB'; UPDATE countries SET countries_name='Somalia' WHERE countries_iso_code_2='SO'; UPDATE countries SET countries_name='Südafrika' WHERE countries_iso_code_2='ZA'; UPDATE countries SET countries_name='Südgeorgien und die südlichen Sandwichinseln' WHERE countries_iso_code_2='GS'; UPDATE countries SET countries_name='Spanien' WHERE countries_iso_code_2='ES'; UPDATE countries SET countries_name='Sri Lanka' WHERE countries_iso_code_2='LK'; UPDATE countries SET countries_name='St. Helena' WHERE countries_iso_code_2='SH'; UPDATE countries SET countries_name='St. Pierre und Miquelon' WHERE countries_iso_code_2='PM'; UPDATE countries SET countries_name='Sudan' WHERE countries_iso_code_2='SD'; UPDATE countries SET countries_name='Suriname' WHERE countries_iso_code_2='SR'; UPDATE countries SET countries_name='Svalbard und Jan Mayen Inseln' WHERE countries_iso_code_2='SJ'; UPDATE countries SET countries_name='Swasiland' WHERE countries_iso_code_2='SZ'; UPDATE countries SET countries_name='Schweden' WHERE countries_iso_code_2='SE'; UPDATE countries SET countries_name='Schweiz' WHERE countries_iso_code_2='CH'; UPDATE countries SET countries_name='Syrien' WHERE countries_iso_code_2='SY'; UPDATE countries SET countries_name='Taiwan' WHERE countries_iso_code_2='TW'; UPDATE countries SET countries_name='Tadschikistan' WHERE countries_iso_code_2='TJ'; UPDATE countries SET countries_name='Tansania' WHERE countries_iso_code_2='TZ'; UPDATE countries SET countries_name='Thailand' WHERE countries_iso_code_2='TH'; UPDATE countries SET countries_name='Togo' WHERE countries_iso_code_2='TG'; UPDATE countries SET countries_name='Tokelau' WHERE countries_iso_code_2='TK'; UPDATE countries SET countries_name='Tonga' WHERE countries_iso_code_2='TO'; UPDATE countries SET countries_name='Trinidad und Tobago' WHERE countries_iso_code_2='TT'; UPDATE countries SET countries_name='Tunesien' WHERE countries_iso_code_2='TN'; UPDATE countries SET countries_name='Türkei' WHERE countries_iso_code_2='TR'; UPDATE countries SET countries_name='Turkmenistan' WHERE countries_iso_code_2='TM'; UPDATE countries SET countries_name='Turks und Caicos' WHERE countries_iso_code_2='TC'; UPDATE countries SET countries_name='Tuvalu' WHERE countries_iso_code_2='TV'; UPDATE countries SET countries_name='Uganda' WHERE countries_iso_code_2='UG'; UPDATE countries SET countries_name='Ukraine' WHERE countries_iso_code_2='UA'; UPDATE countries SET countries_name='Vereinigte Arabische Emirate' WHERE countries_iso_code_2='AE'; UPDATE countries SET countries_name='Grossbritannien' WHERE countries_iso_code_2='GB'; UPDATE countries SET countries_name='Vereinigte Staaten von Amerika' WHERE countries_iso_code_2='US'; UPDATE countries SET countries_name='Amerikanische Überseeinseln, kleinere' WHERE countries_iso_code_2= 'UM'; UPDATE countries SET countries_name='Uruguay' WHERE countries_iso_code_2='UY'; UPDATE countries SET countries_name='Usbekistan' WHERE countries_iso_code_2='UZ'; UPDATE countries SET countries_name='Vanuatu' WHERE countries_iso_code_2='VU'; UPDATE countries SET countries_name='Vatikan' WHERE countries_iso_code_2='VA'; UPDATE countries SET countries_name='Venezuela' WHERE countries_iso_code_2='VE'; UPDATE countries SET countries_name='Vietnam' WHERE countries_iso_code_2='VN'; UPDATE countries SET countries_name='Britischen Jungferninseln ' WHERE countries_iso_code_2='VG'; UPDATE countries SET countries_name='Amerikanische Jungferninseln' WHERE countries_iso_code_2='VI'; UPDATE countries SET countries_name='Wallis und Futuna' WHERE countries_iso_code_2='WF'; UPDATE countries SET countries_name='West Sahara' WHERE countries_iso_code_2='EH'; UPDATE countries SET countries_name='Jemen' WHERE countries_iso_code_2='YE'; UPDATE countries SET countries_name='Jugoslawien' WHERE countries_iso_code_2='YU'; UPDATE countries SET countries_name='Zaire' WHERE countries_iso_code_2='ZR'; UPDATE countries SET countries_name='Sambia' WHERE countries_iso_code_2='ZM'; UPDATE countries SET countries_name='Simbabwe' WHERE countries_iso_code_2='ZW';
PinkCode:DELETE FROM countries WHERE countries_iso_code_2= 'AQ'; DELETE FROM countries WHERE countries_iso_code_2= 'YU'; DELETE FROM countries WHERE countries_iso_code_2= 'FX';



