World Zones
for osCommerce Online Merchant v2.2
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!
Legend: 
Download
Report
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.
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!
Add file to this package