Community Add-Ons

The included sql file will delete your zone table and replace it with
an exhaustive listing of world zones for the following countries:

in this version were added to the missing areas of Slovenia and correct the wrong Italian provinces.

Because the World Zones contribution uses HTML characters for the various accented characters used in some countries it WILL cause problems with osCommerce if a customer attempts to use this contribution by itself. osCommerce wasn't written to handle the special characters in state names and the drop down menus it will create don't allow for these HTML characters. If you use this contribution you should also install the Auto State Dropdowns contribution found at http://addons.oscommerce.com/info/6304

Version 1.2 of the Auto States Dropdown contribution will allow you to use any type of character you may need in the state name. File is attached here is the same as in the previous post.

Found a few errors in the names for zones in Spain and Switzerland. Corrected file attached here.

Added zones for Anguilla, Aruba, Faroe Islands, French Guiana, Gibraltar, Guadeloupe, Guam, Lebanon, Macedonia, Martinique, Mayotte, Netherlands Antilles, Niue, Puerto Rico as taken from Countries and Zones contribution dated June 20, 2008 by tuxatoons and adjusted for HTML special characters.

Just a fix for the spelling of the ACT in Australia in the sql file, details in the install file.

I've updated the Italian zones to list the provinces instead of the regions. The previous version would've created inaccurate addresses.

- Czech names are now in HTML special chars
- Replaced '' to NULL for compatibility with MySQL 5.0
- Changed size of zone_name to 56, MySQL 5.0 reported error size error before and some names was trucated

This file is built on World zones 2.4.

Corrected spelling and added HTML names for norwegian zones.

Install instruktions are included.

This file is built on World zones 2.3.

It includes Html based names for Sweden and the changed and corrected letters for the zones (landskap).

Please do NOT destroy this again. Unnessesary work.

Install instruktions are included.

Updated Malaysia zones according to avoid overlapping in codes.

Indonesia zones update 32 province

Es el mismo archivo que puso hobbzilla, solo que arregle un error que decía Distrito Federal, en lugar de Capital Federal.
El resto de las provincias me parecen que están bien.

v2.1 - 01/06/2007 (hobbzilla)
Updated Mexican zone codes & added Aguascalientes.
Included Turkish zones updates

If you're getting the "Duplicate entry" error with this contrib, this should fix it. Basically it changes the zone_id from '' to NULL, so that MySQL properly does the auto-increment.

Other than that, it's the same as the latest version.

This file is built on World zones 1.9A.

It includes Html based names for Sweden and the changed and corrected letters for the zones (landskap).

Install instruktions are included.

Swedish zones correct spelled but I have not fixed the swedish letters with special characters.

I change same spelling mistake and orders

Update zone within New Zealand. Added from 1.9 zones.
Simply as normal run SQL File.

v1.9 - 07/05/05 merged 1.8a & 1.8b - 1.8b didn't include the
changes listed in 1.8a.
Match Zones for Germany, Austria, Spain with osC stock.
Updated Canada zones.
Added too many zones to name!
Added Ecuador zones (Alex Paul Rodriguez)

Corrected names of Bulgarian zones. But in Bulgaria there isn't alphabetical zone codes.

Corrected names and codes of Romanian zones

Updated other users Character Codes to HTML special codes.
Updated German & Austrian codes to match oscommerce install.sql file.
Added Vargas Venezuela (thanks to Mario Ochoa)

Portuguese Zones Update
Correcção dos nomes das zonas com acentos e cedilhas

Flag of the following countries:

Afghanistan,Albania,Algeria,American Samoa,Andorra,Angola,
,China,Colombia,Costa Rica,Croatia,Cuba,Czech Republic,
Denmark,El Salvador,Estonia,Finland,France,Germany,Greece,Guatemala,Hungary,
India,Indonesia,Ireland,Israel,Italy,Japan,Jordan,Kazakhstan,Kenya,Korea,
Kuwait,Luxembourg,Malaysia,Mexico,Netherlands,New Zealand,Nicaragua,Niger,
Nigeria,Norway,Pakistan,Philippines,Poland,Portugal,Romania,
Russian Federation,Slovakia,South Africa,Spain,Sri Lanka,St. Helena,Sweden,
Switzerland,Thailand,Tunisia,Turkey,Ukraine,United Kingdom,United States,
Uruguay,Venezuela,Yemen,Yugoslavia,Zambia,Zimbabwe

v1.7 - 12/07/04

Updated Swiss and French Zones with correct names.
Changes by Jonas Vonlanthen

v1.6 - 11/29/04
Changed "Baja California" to "Baja California Norte"
and it's corresponding BC to BN because I found that
nobody could register with the old method. OSC just
kept asking user to select from the menu.
BN is a Mexican state.
Changes by Carlos Urbieta C. <carlos@urbieta.com>

Converted two-character codes into full-name for Thailand zones because we generally use full state name in Thailand.

And full credit will go to Ryan Hobbs.

Updated Czech Republic zones.

Updated UK zones.

The initial upload of this contribution was corrupted. My apologies to the osC community.

This is an update to World Zones v1.2 correcting the zone codes for Australia, which are a mixture of two- and three-character codes.

i update the list of indonesian zones

The included sql file will delete your zone table and replace it with
an exhaustive listing of world zones for the following countries:

Afghanistan,Albania,Algeria,American Samoa,Andorra,Angola,
Antigua and Barbuda,Argentina,Armenia,Australia,Austria,Azerbaijan,
Bahamas,Bahrain,Bangladesh,Barbados,Belarus,Belgium,Belize,Benin,Bermuda,
Bhutan,Bolivia,Botswana,Brazil,Brunei Darussalam,Bulgaria,Burkina Faso,
Burundi,Canada,Chile,China,Colombia,Costa Rica,Croatia,Cuba,Czech Republic,
Denmark,El Salvador,Estonia,Finland,France,Germany,Greece,Guatemala,Hungary,
India,Indonesia,Ireland,Israel,Italy,Japan,Jordan,Kazakhstan,Kenya,Korea,
Kuwait,Luxembourg,Malaysia,Mexico,Netherlands,New Zealand,Nicaragua,Niger,
Nigeria,Norway,Pakistan,Philippines,Poland,Portugal,Romania,
Russian Federation,Slovakia,South Africa,Spain,Sri Lanka,St. Helena,Sweden,
Switzerland,Thailand,Tunisia,Turkey,Ukraine,United Kingdom,United States,
Uruguay,Venezuela,Yemen,Yugoslavia,Zambia,Zimbabwe


If you know of a more complete zone file, USE IT!