File: CMF/Web/application/helpers/province_city_installer_helper.php

Recommend this page to a friend!
  Classes of Burge Lab  >  BurgeATS  >  CMF/Web/application/helpers/province_city_installer_helper.php  >  Download  
File: CMF/Web/application/helpers/province_city_installer_helper.php
Role: Example script
Content type: text/plain
Description: Example script
Class: BurgeATS
CRM, Ticketing system, and employee manangement
Author: By
Last change:
Date: 4 years ago
Size: 33,326 bytes
 

Contents

Class file image Download
<?php  if ( ! defined('BASEPATH')) exit('No direct script access allowed');

function insert_Iran_provinces_and_cities_to_db()
{
	$CI=&get_instance();
	$table=$CI->db->dbprefix("province"); 
	$CI->db->query("
		CREATE TABLE IF NOT EXISTS `$table` (
			`province_id` int(11) NOT NULL
			,`province_lang` char(2) NOT NULL
			,`province_name` varchar(100) NOT NULL
			,PRIMARY KEY (`province_id`, `province_lang`)
		) ENGINE=InnoDB DEFAULT CHARSET=utf8;
	");

	$CI->db->query("
		INSERT INTO `$table` (`province_id`, `province_lang`, `province_name`) VALUES
			(1, 'en', 'East Azerbaijan'),
			(1, 'fa', '????????? ????'),
			(2, 'en', 'West Azerbaijan'),
			(2, 'fa', '????????? ????'),
			(3, 'en', 'Ardabil'),
			(3, 'fa', '??????'),
			(4, 'en', 'Isfahan'),
			(4, 'fa', '??????'),
			(5, 'en', 'Alborz'),
			(5, 'fa', '?????'),
			(6, 'en', 'Ilam'),
			(6, 'fa', '?????'),
			(7, 'en', 'Bushehr'),
			(7, 'fa', '?????'),
			(8, 'en', 'Tehran'),
			(8, 'fa', '?????'),
			(9, 'en', 'Chahar Mahal and Bakhtiari'),
			(9, 'fa', '???????? ? ???????'),
			(10, 'en', 'South Korasan'),
			(10, 'fa', '?????? ?????'),
			(11, 'en', 'Razavi Korasan'),
			(11, 'fa', '?????? ????'),
			(12, 'en', 'North Korasan'),
			(12, 'fa', '?????? ?????'),
			(13, 'en', 'Khuzestan'),
			(13, 'fa', '???????'),
			(14, 'en', 'Zanjan'),
			(14, 'fa', '?????'),
			(15, 'en', 'Semnan'),
			(15, 'fa', '?????'),
			(16, 'en', 'Sistan and Baluchestan'),
			(16, 'fa', '?????? ? ????????'),
			(17, 'en', 'Fars'),
			(17, 'fa', '????'),
			(18, 'en', 'Qazvin'),
			(18, 'fa', '?????'),
			(19, 'en', 'Qom'),
			(19, 'fa', '??'),
			(20, 'en', 'Kurdistan'),
			(20, 'fa', '???????'),
			(21, 'en', 'Kerman'),
			(21, 'fa', '?????'),
			(22, 'en', 'Kermanshah'),
			(22, 'fa', '????????'),
			(23, 'en', 'Kohgiluye and Boyer Ahmad'),
			(23, 'fa', '???????? ? ????????'),
			(24, 'en', 'Golestan'),
			(24, 'fa', '??????'),
			(25, 'en', 'Gilan'),
			(25, 'fa', '?????'),
			(26, 'en', 'Lorestan'),
			(26, 'fa', '??????'),
			(27, 'en', 'Mazandaran'),
			(27, 'fa', '????????'),
			(28, 'en', 'Markazi'),
			(28, 'fa', '?????'),
			(29, 'en', 'Hormozgan'),
			(29, 'fa', '???????'),
			(30, 'en', 'Hamadan'),
			(30, 'fa', '?????'),
			(31, 'en', 'Yazd'),
			(31, 'fa', '???');
	");

	$table=$CI->db->dbprefix("city"); 
	$CI->db->query("
		CREATE TABLE IF NOT EXISTS `$table` (
		  `city_id` int(11) NOT NULL
		  ,`city_province_id` int(11) 
		  ,`city_lang` char(2) NOT NULL
		  ,`city_name` varchar(255) DEFAULT NULL
		  ,PRIMARY KEY (`city_id`, `city_lang`)
		) ENGINE=InnoDB DEFAULT CHARSET=utf8;
	");

	$CI->db->query("
		INSERT INTO `$table` (`city_id`, `city_province_id`, `city_lang`, `city_name`) VALUES
			(1, 1, 'en', 'Azarshahr'),
			(1, 1, 'fa', '??? ???'),
			(2, 1, 'en', 'Osku'),
			(2, 1, 'fa', '????'),
			(3, 1, 'en', 'Ahar'),
			(3, 1, 'fa', '???'),
			(4, 1, 'en', 'Bostan Abad'),
			(4, 1, 'fa', '????? ????'),
			(5, 1, 'en', 'Bonab'),
			(5, 1, 'fa', '????'),
			(6, 1, 'en', 'Bandar Sharafkhane'),
			(6, 1, 'fa', '???? ???????'),
			(7, 1, 'en', 'Tabriz'),
			(7, 1, 'fa', '?????'),
			(8, 1, 'en', 'Tasuj'),
			(8, 1, 'fa', '????'),
			(9, 1, 'en', 'Jolfa'),
			(9, 1, 'fa', '????'),
			(10, 1, 'en', 'Sarab'),
			(10, 1, 'fa', '????'),
			(11, 1, 'en', 'Shabestar'),
			(11, 1, 'fa', '?????'),
			(12, 1, 'en', 'Sufian'),
			(12, 1, 'fa', '??????'),
			(13, 1, 'en', 'Ajabshir'),
			(13, 1, 'fa', '??????'),
			(14, 1, 'en', 'Qarah Aghaj'),
			(14, 1, 'fa', '??? ????'),
			(15, 1, 'en', 'Kaleybar'),
			(15, 1, 'fa', '?????'),
			(16, 1, 'en', 'Kandovan'),
			(16, 1, 'fa', '??????'),
			(17, 1, 'en', 'Maraqe'),
			(17, 1, 'fa', '?????'),
			(18, 1, 'en', 'Marand'),
			(18, 1, 'fa', '????'),
			(19, 1, 'en', 'Malekan'),
			(19, 1, 'fa', '?????'),
			(20, 1, 'en', 'Mamqan'),
			(20, 1, 'fa', '?????'),
			(21, 1, 'en', 'Miane'),
			(21, 1, 'fa', '?????'),
			(22, 1, 'en', 'Hadishahr'),
			(22, 1, 'fa', '???????'),
			(23, 1, 'en', 'Haris'),
			(23, 1, 'fa', '????'),
			(24, 1, 'en', 'Hashtrud'),
			(24, 1, 'fa', '??????'),
			(25, 1, 'en', 'Varzaqan'),
			(25, 1, 'fa', '??????'),
			(26, 2, 'en', 'Urmia'),
			(26, 2, 'fa', '??????'),
			(27, 2, 'en', 'Oshnavie'),
			(27, 2, 'fa', '??????'),
			(28, 2, 'en', 'Bazargan'),
			(28, 2, 'fa', '???????'),
			(29, 2, 'en', 'Bukan'),
			(29, 2, 'fa', '?????'),
			(30, 2, 'en', 'Poldasht'),
			(30, 2, 'fa', '?????'),
			(31, 2, 'en', 'PiranShahr'),
			(31, 2, 'fa', '????????'),
			(32, 2, 'en', 'Takab'),
			(32, 2, 'fa', '????'),
			(33, 2, 'en', 'Khooy'),
			(33, 2, 'fa', '???'),
			(34, 2, 'en', 'Sardasht'),
			(34, 2, 'fa', '?????'),
			(35, 2, 'en', 'Salmas'),
			(35, 2, 'fa', '?????'),
			(36, 2, 'en', 'Siah Chesmeh and Chaldoran'),
			(36, 2, 'fa', '??? ???? ? ???????'),
			(37, 2, 'en', 'Simine'),
			(37, 2, 'fa', '??????'),
			(38, 2, 'en', 'Shahin Dezh'),
			(38, 2, 'fa', '????? ??'),
			(39, 2, 'en', 'Showt'),
			(39, 2, 'fa', '???'),
			(40, 2, 'en', 'Maku'),
			(40, 2, 'fa', '????'),
			(41, 2, 'en', 'Mahabad'),
			(41, 2, 'fa', '??????'),
			(42, 2, 'en', 'Miandoab'),
			(42, 2, 'fa', '????????'),
			(43, 2, 'en', 'Naqde'),
			(43, 2, 'fa', '????'),
			(44, 3, 'en', 'Ardabil'),
			(44, 3, 'fa', '??????'),
			(45, 3, 'en', 'Bile Savar'),
			(45, 3, 'fa', '???? ????'),
			(46, 3, 'en', 'Pars Abad'),
			(46, 3, 'fa', '???? ????'),
			(47, 3, 'en', 'Khalkhal'),
			(47, 3, 'fa', '?????'),
			(48, 3, 'en', 'Sarein'),
			(48, 3, 'fa', '?????'),
			(49, 3, 'en', 'Kivi Kowsar'),
			(49, 3, 'fa', '???? ????'),
			(50, 3, 'en', 'Garmi Moqan'),
			(50, 3, 'fa', '???? ????'),
			(51, 3, 'en', 'Meshgin Shahr'),
			(51, 3, 'fa', '????? ???'),
			(52, 3, 'en', 'Namin'),
			(52, 3, 'fa', '????'),
			(53, 3, 'en', 'Naier'),
			(53, 3, 'fa', '???'),
			(54, 4, 'en', 'Aran and Bidgol'),
			(54, 4, 'fa', '???? ? ?????'),
			(55, 4, 'en', 'Ardestan'),
			(55, 4, 'fa', '???????'),
			(56, 4, 'en', 'Isfahan'),
			(56, 4, 'fa', '??????'),
			(57, 4, 'en', 'Baq Bahadoran'),
			(57, 4, 'fa', '??? ???????'),
			(58, 4, 'en', 'Tiran'),
			(58, 4, 'fa', '?????'),
			(59, 4, 'en', 'Khomeini Shahr'),
			(59, 4, 'fa', '????? ???'),
			(60, 4, 'en', 'Khansar'),
			(60, 4, 'fa', '???????'),
			(61, 4, 'en', 'Dehaqan'),
			(61, 4, 'fa', '??????'),
			(62, 4, 'en', 'Dolat Aabad'),
			(62, 4, 'fa', '???? ????'),
			(63, 4, 'en', 'Zarin Shahr'),
			(63, 4, 'fa', '???? ???'),
			(64, 4, 'en', 'Zibashahr'),
			(64, 4, 'fa', '???????'),
			(65, 4, 'en', 'Semirom'),
			(65, 4, 'fa', '?????'),
			(66, 4, 'en', 'Shahin Shahr'),
			(66, 4, 'fa', '????? ???'),
			(67, 4, 'en', 'Shahreza'),
			(67, 4, 'fa', '?????'),
			(68, 4, 'en', 'Fereidan'),
			(68, 4, 'fa', '?????'),
			(69, 4, 'en', 'Fereidun Shahr'),
			(69, 4, 'fa', '?????? ???'),
			(70, 4, 'en', 'Felavarjan'),
			(70, 4, 'fa', '????????'),
			(71, 4, 'en', 'Fulad Shahr'),
			(71, 4, 'fa', '????? ???'),
			(72, 4, 'en', 'Qahderijan'),
			(72, 4, 'fa', '????????'),
			(73, 4, 'en', 'Kashan'),
			(73, 4, 'fa', '?????'),
			(74, 4, 'en', 'Golpaigan'),
			(74, 4, 'fa', '????????'),
			(75, 4, 'en', 'Mobarake'),
			(75, 4, 'fa', '?????? '),
			(76, 4, 'en', 'Mahabad'),
			(76, 4, 'fa', '??????'),
			(77, 4, 'en', 'Nain'),
			(77, 4, 'fa', '?????'),
			(78, 4, 'en', 'Nadjaf Aabd'),
			(78, 4, 'fa', '??? ????'),
			(79, 4, 'en', 'Natanz'),
			(79, 4, 'fa', '????'),
			(80, 4, 'en', 'Harand'),
			(80, 4, 'fa', '????'),
			(81, 5, 'en', 'Asara'),
			(81, 5, 'fa', '?????'),
			(82, 5, 'en', 'Eshtehard'),
			(82, 5, 'fa', '???????'),
			(83, 5, 'en', 'Hashtgerd'),
			(83, 5, 'fa', '??????'),
			(84, 5, 'en', 'Taleqan'),
			(84, 5, 'fa', '??????'),
			(85, 5, 'en', 'Karaj'),
			(85, 5, 'fa', '???'),
			(86, 5, 'en', 'Nazar Aabd'),
			(86, 5, 'fa', '???????'),
			(87, 6, 'en', 'Abdanan'),
			(87, 6, 'fa', '???????'),
			(88, 6, 'en', 'Ilam'),
			(88, 6, 'fa', '?????'),
			(89, 6, 'en', 'Ivan'),
			(89, 6, 'fa', '?????'),
			(90, 6, 'en', 'Dare Shahr'),
			(90, 6, 'fa', '??? ???'),
			(91, 6, 'en', 'Dehloran'),
			(91, 6, 'fa', '??????'),
			(92, 6, 'en', 'Sarable'),
			(92, 6, 'fa', '??????'),
			(93, 6, 'en', 'Shirvan'),
			(93, 6, 'fa', '?????? ??????'),
			(94, 6, 'en', 'Mehran'),
			(94, 6, 'fa', '?????'),
			(95, 7, 'en', 'Abpakhsh'),
			(95, 7, 'fa', '?????'),
			(96, 7, 'en', 'Ahram'),
			(96, 7, 'fa', '????'),
			(97, 7, 'en', 'Borazjan'),
			(97, 7, 'fa', '???????'),
			(98, 7, 'en', 'Bandar Dayer'),
			(98, 7, 'fa', '???? ???'),
			(99, 7, 'en', 'Bandar Deylam'),
			(99, 7, 'fa', '???? ????'),
			(100, 7, 'en', 'Bandar Kangan'),
			(100, 7, 'fa', '???? ?????'),
			(101, 7, 'en', 'Bandar Genave'),
			(101, 7, 'fa', '???? ?????'),
			(102, 7, 'en', 'Bushehr'),
			(102, 7, 'fa', '?????'),
			(103, 7, 'en', 'Tangestan'),
			(103, 7, 'fa', '???????'),
			(104, 7, 'en', 'Khark'),
			(104, 7, 'fa', '????? ????'),
			(105, 7, 'en', 'Jam'),
			(105, 7, 'fa', '??'),
			(106, 7, 'en', 'Khurmoj'),
			(106, 7, 'fa', '??????'),
			(107, 7, 'en', 'Dashtestan'),
			(107, 7, 'fa', '???????'),
			(108, 7, 'en', 'Delvar'),
			(108, 7, 'fa', '?????'),
			(109, 7, 'en', 'Asaluye'),
			(109, 7, 'fa', '??????'),
			(110, 8, 'en', 'Islam Shahr'),
			(110, 8, 'fa', '????????'),
			(111, 8, 'en', 'Bumehen'),
			(111, 8, 'fa', '?????'),
			(112, 8, 'en', 'Pakdasht'),
			(112, 8, 'fa', '??????'),
			(113, 8, 'en', 'Tehran'),
			(113, 8, 'fa', '?????'),
			(114, 8, 'en', 'Chahar Dange'),
			(114, 8, 'fa', '?????????'),
			(115, 8, 'en', 'Damavnd'),
			(115, 8, 'fa', '??????'),
			(116, 8, 'en', 'Rudehen'),
			(116, 8, 'fa', '?????'),
			(117, 8, 'en', 'Rei'),
			(117, 8, 'fa', '??'),
			(118, 8, 'en', 'Sharif Abad'),
			(118, 8, 'fa', '???? ????'),
			(119, 8, 'en', 'Robat Karim'),
			(119, 8, 'fa', '???? ????'),
			(120, 8, 'en', 'Shahriar'),
			(120, 8, 'fa', '??????'),
			(121, 8, 'en', 'Fasham'),
			(121, 8, 'fa', '???'),
			(122, 8, 'en', 'Firuzkuh'),
			(122, 8, 'fa', '????????'),
			(123, 8, 'en', 'Quds'),
			(123, 8, 'fa', '???'),
			(124, 8, 'en', 'Kahrizak'),
			(124, 8, 'fa', '??????'),
			(125, 8, 'en', 'Lavasan'),
			(125, 8, 'fa', '??????'),
			(126, 8, 'en', 'Malard'),
			(126, 8, 'fa', '?????'),
			(127, 8, 'en', 'Varamin'),
			(127, 8, 'fa', '??????'),
			(128, 9, 'en', 'Ardal'),
			(128, 9, 'fa', '????'),
			(129, 9, 'en', 'Brujen'),
			(129, 9, 'fa', '?????'),
			(130, 9, 'en', 'Chelgerd and Kuhrang'),
			(130, 9, 'fa', '????? ? ??????'),
			(131, 9, 'en', 'Saman'),
			(131, 9, 'fa', '?????'),
			(132, 9, 'en', 'Shahrekord'),
			(132, 9, 'fa', '??????'),
			(133, 9, 'en', 'Farsan'),
			(133, 9, 'fa', '??????'),
			(134, 9, 'en', 'Lordegan'),
			(134, 9, 'fa', '??????'),
			(135, 10, 'en', 'Boshruye'),
			(135, 10, 'fa', '??????'),
			(136, 10, 'en', 'Birjand'),
			(136, 10, 'fa', '??????'),
			(137, 10, 'en', 'Khezri'),
			(137, 10, 'fa', '????'),
			(138, 10, 'en', 'Khusf'),
			(138, 10, 'fa', '????'),
			(139, 10, 'en', 'Sarayan'),
			(139, 10, 'fa', '??????'),
			(140, 10, 'en', 'Sarbishe'),
			(140, 10, 'fa', '??????'),
			(141, 10, 'en', 'Tabas'),
			(141, 10, 'fa', '???'),
			(142, 10, 'en', 'Ferdos'),
			(142, 10, 'fa', '?????'),
			(143, 10, 'en', 'Qaen'),
			(143, 10, 'fa', '????'),
			(144, 10, 'en', 'Nehbandan'),
			(144, 10, 'fa', '???????'),
			(145, 11, 'en', 'Bajestan'),
			(145, 11, 'fa', '??????'),
			(146, 11, 'en', 'Bardeskan'),
			(146, 11, 'fa', '??????'),
			(147, 11, 'en', 'Taybad'),
			(147, 11, 'fa', '??????'),
			(148, 11, 'en', 'Torbate Jam'),
			(148, 11, 'fa', '???? ???'),
			(149, 11, 'en', 'Torbate Heidaried'),
			(149, 11, 'fa', '???? ??????'),
			(150, 11, 'en', 'Joqatai'),
			(150, 11, 'fa', '?????'),
			(151, 11, 'en', 'Jovein'),
			(151, 11, 'fa', '????'),
			(152, 11, 'en', 'Chenaran'),
			(152, 11, 'fa', '??????'),
			(153, 11, 'en', 'Khalil Abad'),
			(153, 11, 'fa', '???? ????'),
			(154, 11, 'en', 'Khaf'),
			(154, 11, 'fa', '????'),
			(155, 11, 'en', 'Dargaz'),
			(155, 11, 'fa', '????'),
			(156, 11, 'en', 'Roshtkhar'),
			(156, 11, 'fa', '???????'),
			(157, 11, 'en', 'Sabzevar'),
			(157, 11, 'fa', '??????'),
			(158, 11, 'en', 'Sarakhs'),
			(158, 11, 'fa', '????'),
			(159, 11, 'en', 'Torqabe'),
			(159, 11, 'fa', '?????'),
			(160, 11, 'en', 'Fariman'),
			(160, 11, 'fa', '??????'),
			(161, 11, 'en', 'Quchan'),
			(161, 11, 'fa', '?????'),
			(162, 11, 'en', 'Kashmar'),
			(162, 11, 'fa', '?????'),
			(163, 11, 'en', 'Kalat'),
			(163, 11, 'fa', '????'),
			(164, 11, 'en', 'Gonabad'),
			(164, 11, 'fa', '??????'),
			(165, 11, 'en', 'Mashad'),
			(165, 11, 'fa', '????'),
			(166, 11, 'en', 'Neishabur'),
			(166, 11, 'fa', '???????'),
			(167, 12, 'en', 'Ashkhane and Mane and Samarqan'),
			(167, 12, 'fa', '?????? ? ???? ? ??????'),
			(168, 12, 'en', 'Esfaraien'),
			(168, 12, 'fa', '???????'),
			(169, 12, 'en', 'Bojnurd'),
			(169, 12, 'fa', '??????'),
			(170, 12, 'en', 'Jajarm'),
			(170, 12, 'fa', '?????'),
			(171, 12, 'en', 'Shirvan'),
			(171, 12, 'fa', '??????'),
			(172, 12, 'en', 'Farooj'),
			(172, 12, 'fa', '?????'),
			(173, 13, 'en', 'Abadan'),
			(173, 13, 'fa', '??????'),
			(174, 13, 'en', 'Omidie'),
			(174, 13, 'fa', '??????'),
			(175, 13, 'en', 'Andimeshk'),
			(175, 13, 'fa', '???????'),
			(176, 13, 'en', 'Ahvaz'),
			(176, 13, 'fa', '?????'),
			(177, 13, 'en', 'Ieze'),
			(177, 13, 'fa', '????'),
			(178, 13, 'en', 'Bagh Malek'),
			(178, 13, 'fa', '??? ???'),
			(179, 13, 'en', 'Bostan Abad'),
			(179, 13, 'fa', '?????'),
			(180, 13, 'en', 'Bandar Mahshahr'),
			(180, 13, 'fa', '???? ??????'),
			(181, 13, 'en', 'Bandar Imam Khomeini'),
			(181, 13, 'fa', '???????? ?????'),
			(182, 13, 'en', 'Behbahan'),
			(182, 13, 'fa', '??????'),
			(183, 13, 'en', 'Khoram Shahr'),
			(183, 13, 'fa', '??????'),
			(184, 13, 'en', 'Dezful'),
			(184, 13, 'fa', '?????'),
			(185, 13, 'en', 'Ramshir'),
			(185, 13, 'fa', '??????'),
			(186, 13, 'en', 'Ramhormoz'),
			(186, 13, 'fa', '???????'),
			(187, 13, 'en', 'Susangerd'),
			(187, 13, 'fa', '???????'),
			(188, 13, 'en', 'Shadegan'),
			(188, 13, 'fa', '??????'),
			(189, 13, 'en', 'Shush'),
			(189, 13, 'fa', '???'),
			(190, 13, 'en', 'Shushtar'),
			(190, 13, 'fa', '?????'),
			(191, 13, 'en', 'Lali'),
			(191, 13, 'fa', '????'),
			(192, 13, 'en', 'Masjed Soleiman'),
			(192, 13, 'fa', '???? ??????'),
			(193, 13, 'en', 'Hendijan'),
			(193, 13, 'fa', '???????'),
			(194, 13, 'en', 'Hoveize'),
			(194, 13, 'fa', '?????'),
			(195, 14, 'en', 'Ab Bar and Tarem'),
			(195, 14, 'fa', '?? ?? ? ????'),
			(196, 14, 'en', 'Abhar'),
			(196, 14, 'fa', '????'),
			(197, 14, 'en', 'Khoram Dare'),
			(197, 14, 'fa', '??????'),
			(198, 14, 'en', 'Zarin Abad'),
			(198, 14, 'fa', '???? ????'),
			(199, 14, 'en', 'Zanjan'),
			(199, 14, 'fa', '?????'),
			(200, 14, 'en', 'Qeydar and Khoda Bande'),
			(200, 14, 'fa', '????? ? ??? ????'),
			(201, 14, 'en', 'Mahneshan'),
			(201, 14, 'fa', '???????'),
			(202, 15, 'en', 'Eivanaki'),
			(202, 15, 'fa', '???????'),
			(203, 15, 'en', 'Bastam'),
			(203, 15, 'fa', '?????'),
			(204, 15, 'en', 'Damqan'),
			(204, 15, 'fa', '??????'),
			(205, 15, 'en', 'Sorkhe'),
			(205, 15, 'fa', '????'),
			(206, 15, 'en', 'Semnan'),
			(206, 15, 'fa', '?????'),
			(207, 15, 'en', 'Shahrud'),
			(207, 15, 'fa', '??????'),
			(208, 15, 'en', 'Shahmirzad'),
			(208, 15, 'fa', '????????'),
			(209, 15, 'en', 'Garmsar'),
			(209, 15, 'fa', '??????'),
			(210, 15, 'en', 'Mehdi Shahr'),
			(210, 15, 'fa', '???????'),
			(211, 16, 'en', 'Iran Shahr'),
			(211, 16, 'fa', '????????'),
			(212, 16, 'en', 'Chabahar'),
			(212, 16, 'fa', '??????'),
			(213, 16, 'en', 'Khash'),
			(213, 16, 'fa', '???'),
			(214, 16, 'en', 'Rask'),
			(214, 16, 'fa', '????'),
			(215, 16, 'en', 'Zabol'),
			(215, 16, 'fa', '????'),
			(216, 16, 'en', 'Zahedan'),
			(216, 16, 'fa', '??????'),
			(217, 16, 'en', 'Saravan'),
			(217, 16, 'fa', '??????'),
			(218, 16, 'en', 'Sarbaz'),
			(218, 16, 'fa', '?????'),
			(219, 16, 'en', 'Mirjave'),
			(219, 16, 'fa', '???????'),
			(220, 16, 'en', 'Nik Shahr'),
			(220, 16, 'fa', '??????'),
			(221, 17, 'en', 'Abade'),
			(221, 17, 'fa', '?????'),
			(222, 17, 'en', 'Abade Tashak'),
			(222, 17, 'fa', '????? ???'),
			(223, 17, 'en', 'Ardakan'),
			(223, 17, 'fa', '??????'),
			(224, 17, 'en', 'Arsanjan'),
			(224, 17, 'fa', '???????'),
			(225, 17, 'en', 'Estahban'),
			(225, 17, 'fa', '???????'),
			(226, 17, 'en', 'Eshkenan'),
			(226, 17, 'fa', '??????'),
			(227, 17, 'en', 'Eqlid'),
			(227, 17, 'fa', '?????'),
			(228, 17, 'en', 'Evaz'),
			(228, 17, 'fa', '???'),
			(229, 17, 'en', 'Iej'),
			(229, 17, 'fa', '???'),
			(230, 17, 'en', 'Izad Khast'),
			(230, 17, 'fa', '???? ?????'),
			(231, 17, 'en', 'Bab Anar'),
			(231, 17, 'fa', '??? ????'),
			(232, 17, 'en', 'Balade'),
			(232, 17, 'fa', '??????'),
			(233, 17, 'en', 'Banaruye'),
			(233, 17, 'fa', '???????'),
			(234, 17, 'en', 'Bahaman'),
			(234, 17, 'fa', '????'),
			(235, 17, 'en', 'Bavanat'),
			(235, 17, 'fa', '??????'),
			(236, 17, 'en', 'Beiram'),
			(236, 17, 'fa', '????'),
			(237, 17, 'en', 'Beiza'),
			(237, 17, 'fa', '????'),
			(238, 17, 'en', 'Janat Shahr'),
			(238, 17, 'fa', '??? ???'),
			(239, 17, 'en', 'Jahrom'),
			(239, 17, 'fa', '????'),
			(240, 17, 'en', 'Haji Abad and Zarin Dasht'),
			(240, 17, 'fa', '???? ???? ? ???? ???'),
			(241, 17, 'en', 'Khavaran'),
			(241, 17, 'fa', '??????'),
			(242, 17, 'en', 'Kharame'),
			(242, 17, 'fa', '?????'),
			(243, 17, 'en', 'Khesht'),
			(243, 17, 'fa', '???'),
			(244, 17, 'en', 'Khonj'),
			(244, 17, 'fa', '???'),
			(245, 17, 'en', 'Khur'),
			(245, 17, 'fa', '???'),
			(246, 17, 'en', 'Darab'),
			(246, 17, 'fa', '?????'),
			(247, 17, 'en', 'Runiz'),
			(247, 17, 'fa', '?????'),
			(248, 17, 'en', 'Zahed Shahr'),
			(248, 17, 'fa', '???????'),
			(249, 17, 'en', 'Zarqan'),
			(249, 17, 'fa', '?????'),
			(250, 17, 'en', 'Sede'),
			(250, 17, 'fa', '???'),
			(251, 17, 'en', 'Sarvestan'),
			(251, 17, 'fa', '???????'),
			(252, 17, 'en', 'Saadat Shahr'),
			(252, 17, 'fa', '????? ???'),
			(253, 17, 'en', 'Sourmoq'),
			(253, 17, 'fa', '?????'),
			(254, 17, 'en', 'Sheshdeh'),
			(254, 17, 'fa', '????'),
			(255, 17, 'en', 'Shiraz'),
			(255, 17, 'fa', '?????'),
			(256, 17, 'en', 'Soghad'),
			(256, 17, 'fa', '????'),
			(257, 17, 'en', 'Safa Shahr'),
			(257, 17, 'fa', '??????'),
			(258, 17, 'en', 'Ala and Marvdasht'),
			(258, 17, 'fa', '???? ? ??????'),
			(259, 17, 'en', 'Ambar'),
			(259, 17, 'fa', '????'),
			(260, 17, 'en', 'Farshband'),
			(260, 17, 'fa', '???????'),
			(261, 17, 'en', 'Fasa'),
			(261, 17, 'fa', '???'),
			(262, 17, 'en', 'Firuz Abad'),
			(262, 17, 'fa', '????? ????'),
			(263, 17, 'en', 'Qaemie'),
			(263, 17, 'fa', '??????'),
			(264, 17, 'en', 'Qader Abad'),
			(264, 17, 'fa', '???? ????'),
			(265, 17, 'en', 'Qotb Abad'),
			(265, 17, 'fa', '??? ????'),
			(266, 17, 'en', 'Qir'),
			(266, 17, 'fa', '???'),
			(267, 17, 'en', 'Kazeroon'),
			(267, 17, 'fa', '??????'),
			(268, 17, 'en', 'Kenar Takhte'),
			(268, 17, 'fa', '???? ????'),
			(269, 17, 'en', 'Gerash'),
			(269, 17, 'fa', '????'),
			(270, 17, 'en', 'Laar'),
			(270, 17, 'fa', '???'),
			(271, 17, 'en', 'Lamerd'),
			(271, 17, 'fa', '?????'),
			(272, 17, 'en', 'Lepuie'),
			(272, 17, 'fa', '?????'),
			(273, 17, 'en', 'Latifi'),
			(273, 17, 'fa', '?????'),
			(274, 17, 'en', 'Marvdasht'),
			(274, 17, 'fa', '??????'),
			(275, 17, 'en', 'Meshkan'),
			(275, 17, 'fa', '?????'),
			(276, 17, 'en', 'Masiri'),
			(276, 17, 'fa', '?????'),
			(277, 17, 'en', 'Mehr'),
			(277, 17, 'fa', '???'),
			(278, 17, 'en', 'Meimand'),
			(278, 17, 'fa', '?????'),
			(279, 17, 'en', 'Nobandegan'),
			(279, 17, 'fa', '????????'),
			(280, 17, 'en', 'Nudan'),
			(280, 17, 'fa', '?????'),
			(281, 17, 'en', 'Nurabad'),
			(281, 17, 'fa', '???????'),
			(282, 17, 'en', 'Neiriz'),
			(282, 17, 'fa', '?? ???'),
			(283, 17, 'en', 'Kovar'),
			(283, 17, 'fa', '????'),
			(284, 18, 'en', 'Abyek'),
			(284, 18, 'fa', '????'),
			(285, 18, 'en', 'Alborz'),
			(285, 18, 'fa', '?????'),
			(286, 18, 'en', 'Buien Zahra'),
			(286, 18, 'fa', '????? ????'),
			(287, 18, 'en', 'Takstan'),
			(287, 18, 'fa', '???????'),
			(288, 18, 'en', 'Qazvin'),
			(288, 18, 'fa', '?????'),
			(289, 18, 'en', 'Mahmud Abad'),
			(289, 18, 'fa', '????? ???? ?????'),
			(290, 19, 'en', 'Qom'),
			(290, 19, 'fa', '??'),
			(291, 20, 'en', 'Bane'),
			(291, 20, 'fa', '????'),
			(292, 20, 'en', 'Bijar'),
			(292, 20, 'fa', '?????'),
			(293, 20, 'en', 'Dehgolan'),
			(293, 20, 'fa', '??????'),
			(294, 20, 'en', 'Divandare'),
			(294, 20, 'fa', '????????'),
			(295, 20, 'en', 'Saqez'),
			(295, 20, 'fa', '???'),
			(296, 20, 'en', 'Sanandaj'),
			(296, 20, 'fa', '?????'),
			(297, 20, 'en', 'Qarve'),
			(297, 20, 'fa', '????'),
			(298, 20, 'en', 'Kamyaran'),
			(298, 20, 'fa', '????????'),
			(299, 20, 'en', 'Marivan'),
			(299, 20, 'fa', '??????'),
			(300, 21, 'en', 'babak'),
			(300, 21, 'fa', '????'),
			(301, 21, 'en', 'Baft'),
			(301, 21, 'fa', '????'),
			(302, 21, 'en', 'Bardesir'),
			(302, 21, 'fa', '??????'),
			(303, 21, 'en', 'Bam'),
			(303, 21, 'fa', '??'),
			(304, 21, 'en', 'Jiroft'),
			(304, 21, 'fa', '?????'),
			(305, 21, 'en', 'Raver'),
			(305, 21, 'fa', '????'),
			(306, 21, 'en', 'Rafsanjan'),
			(306, 21, 'fa', '???????'),
			(307, 21, 'en', 'Zarand'),
			(307, 21, 'fa', '????'),
			(308, 21, 'en', 'Sirjan'),
			(308, 21, 'fa', '??????'),
			(309, 21, 'en', 'Kerman'),
			(309, 21, 'fa', '?????'),
			(310, 21, 'en', 'Kahnuj'),
			(310, 21, 'fa', '?????'),
			(311, 21, 'en', 'Manujan'),
			(311, 21, 'fa', '??????'),
			(312, 22, 'en', 'West Islam Abad '),
			(312, 22, 'fa', '????? ???? ???'),
			(313, 22, 'en', 'Pve'),
			(313, 22, 'fa', '????'),
			(314, 22, 'en', 'Taze Abad and Solase Babajani'),
			(314, 22, 'fa', '???? ???? ? ???? ????????'),
			(315, 22, 'en', 'Javanrud'),
			(315, 22, 'fa', '???????'),
			(316, 22, 'en', 'Sar Pole Zahab'),
			(316, 22, 'fa', '?? ?? ????'),
			(317, 22, 'en', 'Sonqor'),
			(317, 22, 'fa', '????'),
			(318, 22, 'en', 'Sahne'),
			(318, 22, 'fa', '????'),
			(319, 22, 'en', 'Qasre Shirin'),
			(319, 22, 'fa', '??? ?????'),
			(320, 22, 'en', 'Kermanshah'),
			(320, 22, 'fa', '????????'),
			(321, 22, 'en', 'Kangavar'),
			(321, 22, 'fa', '??????'),
			(322, 22, 'en', 'Wes Gilan'),
			(322, 22, 'fa', '????? ???'),
			(323, 22, 'en', 'Harsin'),
			(323, 22, 'fa', '?????'),
			(324, 23, 'en', 'Dehdasht'),
			(324, 23, 'fa', '?????'),
			(325, 23, 'en', 'Do Gonbadan'),
			(325, 23, 'fa', '????????'),
			(326, 23, 'en', 'Sisakht and Dena'),
			(326, 23, 'fa', '?? ??? ? ???'),
			(327, 23, 'en', 'Gachsaran'),
			(327, 23, 'fa', '???????'),
			(328, 23, 'en', 'Yasuj'),
			(328, 23, 'fa', '?????'),
			(329, 24, 'en', 'Azad Shahr'),
			(329, 24, 'fa', '???? ???'),
			(330, 24, 'en', 'Aq Ghala'),
			(330, 24, 'fa', '?? ???'),
			(331, 24, 'en', 'Ambar Alum'),
			(331, 24, 'fa', '?????????'),
			(332, 24, 'en', 'Inche Borun'),
			(332, 24, 'fa', '????? ????'),
			(333, 24, 'en', 'Bandar Gaz'),
			(333, 24, 'fa', '???? ??'),
			(334, 24, 'en', 'Torkaman'),
			(334, 24, 'fa', '?????'),
			(335, 24, 'en', 'Jelin'),
			(335, 24, 'fa', '????'),
			(336, 24, 'en', 'Khan Bebin'),
			(336, 24, 'fa', '??? ????'),
			(337, 24, 'en', 'Ramian'),
			(337, 24, 'fa', '??????'),
			(338, 24, 'en', 'Sarkhankalate'),
			(338, 24, 'fa', '?????????'),
			(339, 24, 'en', 'Simin Shahr'),
			(339, 24, 'fa', '????? ???'),
			(340, 24, 'en', 'Ali Abade Katool'),
			(340, 24, 'fa', '??? ???? ????'),
			(341, 24, 'en', 'Fazel Abad'),
			(341, 24, 'fa', '???? ????'),
			(342, 24, 'en', 'Kord Kuy'),
			(342, 24, 'fa', '??????'),
			(343, 24, 'en', 'Kalale'),
			(343, 24, 'fa', '?????'),
			(344, 24, 'en', 'Galikesh'),
			(344, 24, 'fa', '??????'),
			(345, 24, 'en', 'Gorgan'),
			(345, 24, 'fa', '?????'),
			(346, 24, 'en', 'Gamish Tape'),
			(346, 24, 'fa', '???? ???'),
			(347, 24, 'en', 'Gonbad Kavus'),
			(347, 24, 'fa', '???? ?????'),
			(348, 24, 'en', 'Marave Tape'),
			(348, 24, 'fa', '????? ???'),
			(349, 24, 'en', 'Minudasht'),
			(349, 24, 'fa', '???? ???'),
			(350, 24, 'en', 'Negin Shahr'),
			(350, 24, 'fa', '???? ???'),
			(351, 24, 'en', 'Nude khanduz'),
			(351, 24, 'fa', '???? ??????'),
			(352, 24, 'en', 'NoKande'),
			(352, 24, 'fa', '??????'),
			(353, 25, 'en', 'Astara'),
			(353, 25, 'fa', '??????'),
			(354, 25, 'en', 'Astane Ashrafie'),
			(354, 25, 'fa', '?????? ??????'),
			(355, 25, 'en', 'Amlash'),
			(355, 25, 'fa', '????'),
			(356, 25, 'en', 'Bandar Anzali'),
			(356, 25, 'fa', '?????????'),
			(357, 25, 'en', 'Khomam'),
			(357, 25, 'fa', '????'),
			(358, 25, 'en', 'Rasht'),
			(358, 25, 'fa', '???'),
			(359, 25, 'en', 'Rezvan Shahr'),
			(359, 25, 'fa', '????? ???'),
			(360, 25, 'en', 'Rudsar'),
			(360, 25, 'fa', '?????'),
			(361, 25, 'en', 'Rudbar'),
			(361, 25, 'fa', '??????'),
			(362, 25, 'en', 'Siahkal'),
			(362, 25, 'fa', '??????'),
			(363, 25, 'en', 'Shaft'),
			(363, 25, 'fa', '???'),
			(364, 25, 'en', 'Sume Sara'),
			(364, 25, 'fa', '????? ???'),
			(365, 25, 'en', 'Fuman'),
			(365, 25, 'fa', '????'),
			(366, 25, 'en', 'Kolachay'),
			(366, 25, 'fa', '??????'),
			(367, 25, 'en', 'Lahijan'),
			(367, 25, 'fa', '???????'),
			(368, 25, 'en', 'Langrud'),
			(368, 25, 'fa', '??????'),
			(369, 25, 'en', 'Lushan'),
			(369, 25, 'fa', '?????'),
			(370, 25, 'en', 'Masal'),
			(370, 25, 'fa', '?????'),
			(371, 25, 'en', 'Masule'),
			(371, 25, 'fa', '??????'),
			(372, 25, 'en', 'Manjil'),
			(372, 25, 'fa', '?????'),
			(373, 25, 'en', 'Hashtpar'),
			(373, 25, 'fa', '?????'),
			(374, 26, 'en', 'Azna'),
			(374, 26, 'fa', '????'),
			(375, 26, 'en', 'Aleshtar'),
			(375, 26, 'fa', '?????'),
			(376, 26, 'en', 'Aligudarz'),
			(376, 26, 'fa', '????????'),
			(377, 26, 'en', 'Brujerd'),
			(377, 26, 'fa', '??????'),
			(378, 26, 'en', 'Poldokhtar'),
			(378, 26, 'fa', '??????'),
			(379, 26, 'en', 'Khoram Abad'),
			(379, 26, 'fa', '??? ????'),
			(380, 26, 'en', 'Dorud'),
			(380, 26, 'fa', '?????'),
			(381, 26, 'en', 'Sepiddasht'),
			(381, 26, 'fa', '???????'),
			(382, 26, 'en', 'Kuhdasht'),
			(382, 26, 'fa', '??????'),
			(383, 26, 'en', 'Nurabad'),
			(383, 26, 'fa', '???????'),
			(384, 27, 'en', 'Amol'),
			(384, 27, 'fa', '???'),
			(385, 27, 'en', 'Babol'),
			(385, 27, 'fa', '????'),
			(386, 27, 'en', 'Babolsar'),
			(386, 27, 'fa', '??????'),
			(387, 27, 'en', 'Balade'),
			(387, 27, 'fa', '????'),
			(388, 27, 'en', 'Behshahr'),
			(388, 27, 'fa', '?????'),
			(389, 27, 'en', 'Pol Sefid'),
			(389, 27, 'fa', '?? ????'),
			(390, 27, 'en', 'Tonkabon'),
			(390, 27, 'fa', '??????'),
			(391, 27, 'en', 'Juibar'),
			(391, 27, 'fa', '??????'),
			(392, 27, 'en', 'Chalus'),
			(392, 27, 'fa', '?????'),
			(393, 27, 'en', 'Khoram Abad'),
			(393, 27, 'fa', '??? ????'),
			(394, 27, 'en', 'Ramsar'),
			(394, 27, 'fa', '?????'),
			(395, 27, 'en', 'Rostam Kola'),
			(395, 27, 'fa', '???? ???'),
			(396, 27, 'en', 'Sari'),
			(396, 27, 'fa', '????'),
			(397, 27, 'en', 'Salman Shahr'),
			(397, 27, 'fa', '????????'),
			(398, 27, 'en', 'Savadkuh'),
			(398, 27, 'fa', '???????'),
			(399, 27, 'en', 'Fereidun Kenar'),
			(399, 27, 'fa', '?????? ????'),
			(400, 27, 'en', 'Qaem Shahr'),
			(400, 27, 'fa', '???? ???'),
			(401, 27, 'en', 'Galugah'),
			(401, 27, 'fa', '??????'),
			(402, 27, 'en', 'Mahmud Abad'),
			(402, 27, 'fa', '?????????'),
			(403, 27, 'en', 'Marzan Abad'),
			(403, 27, 'fa', '???? ????'),
			(404, 27, 'en', 'Neka'),
			(404, 27, 'fa', '???'),
			(405, 27, 'en', 'Nurabad'),
			(405, 27, 'fa', '???'),
			(406, 27, 'en', 'Noshahr'),
			(406, 27, 'fa', '?????'),
			(407, 28, 'en', 'Ashtian'),
			(407, 28, 'fa', '??????'),
			(408, 28, 'en', 'Arak'),
			(408, 28, 'fa', '????'),
			(409, 28, 'en', 'Tafresh'),
			(409, 28, 'fa', '????'),
			(410, 28, 'en', 'Khomein'),
			(410, 28, 'fa', '????'),
			(411, 28, 'en', 'Delijan'),
			(411, 28, 'fa', '??????'),
			(412, 28, 'en', 'Save'),
			(412, 28, 'fa', '????'),
			(413, 28, 'en', 'Shazand'),
			(413, 28, 'fa', '?????'),
			(414, 28, 'en', 'Mahalat'),
			(414, 28, 'fa', '?????'),
			(415, 28, 'en', 'Komijan'),
			(415, 28, 'fa', '??????'),
			(416, 29, 'en', 'Abumusa'),
			(416, 29, 'fa', '???????'),
			(417, 29, 'en', 'Bastak'),
			(417, 29, 'fa', '????'),
			(418, 29, 'en', 'Bandar Jask'),
			(418, 29, 'fa', '???? ????'),
			(419, 29, 'en', 'Bandar Lenge'),
			(419, 29, 'fa', '???? ????'),
			(420, 29, 'en', 'Bandar Abbas'),
			(420, 29, 'fa', '????????'),
			(421, 29, 'en', 'Parsian'),
			(421, 29, 'fa', '???????'),
			(422, 29, 'en', 'Haji Abad'),
			(422, 29, 'fa', '???? ????'),
			(423, 29, 'en', 'Dashti'),
			(423, 29, 'fa', '????'),
			(424, 29, 'en', 'Dehbarez and Rudan'),
			(424, 29, 'fa', '?????? ? ?????'),
			(425, 29, 'en', 'Qeshm'),
			(425, 29, 'fa', '???'),
			(426, 29, 'en', 'Kish'),
			(426, 29, 'fa', '???'),
			(427, 29, 'en', 'Minab'),
			(427, 29, 'fa', '?????'),
			(428, 30, 'en', 'Asadabad'),
			(428, 30, 'fa', '???????'),
			(429, 30, 'en', 'Bahar'),
			(429, 30, 'fa', '????'),
			(430, 30, 'en', 'Toiserkan'),
			(430, 30, 'fa', '????????'),
			(431, 30, 'en', 'Razan'),
			(431, 30, 'fa', '???'),
			(432, 30, 'en', 'Kabudarahang'),
			(432, 30, 'fa', '????? ????'),
			(433, 30, 'en', 'Malyer'),
			(433, 30, 'fa', '?????'),
			(434, 30, 'en', 'Nahavand'),
			(434, 30, 'fa', '??????'),
			(435, 30, 'en', 'Hamadan'),
			(435, 30, 'fa', '?????'),
			(436, 31, 'en', 'Abarkuh'),
			(436, 31, 'fa', '??????'),
			(437, 31, 'en', 'Ardekan'),
			(437, 31, 'fa', '??????'),
			(438, 31, 'en', 'Ashkezar'),
			(438, 31, 'fa', '?????'),
			(439, 31, 'en', 'Bafq'),
			(439, 31, 'fa', '????'),
			(440, 31, 'en', 'Taft'),
			(440, 31, 'fa', '???'),
			(441, 31, 'en', 'Mehriz'),
			(441, 31, 'fa', '?????'),
			(442, 31, 'en', 'Meibod'),
			(442, 31, 'fa', '????'),
			(443, 31, 'en', 'Harat'),
			(443, 31, 'fa', '????'),
			(444, 31, 'en', 'Yazd'),
			(444, 31, 'fa', '???'),
			(445, 17, 'en', 'Larestan'),
			(445, 17, 'fa', '???????'),
			(446, 25, 'en', 'Talesh'),
			(446, 25, 'fa', '????'),
			(447, 4,  'en', 'Chadegan'),
			(447, 4,  'fa', '??????'),
			(448, 9,  'en', 'Kiar'),
			(448, 9,  'fa', '????'),
			(449, 17, 'en', 'Mamasani'),
			(449, 17, 'fa', '?????'),
			(450, 17, 'en', 'Sepidan'),
			(450, 17, 'fa', '??????'),
			(451, 9,  'en', 'Ben'),
			(451, 9,  'fa', '??'),
			(452, 29, 'en', 'Bashagard'),
			(452, 29, 'fa', '??????'),
			(453, 7,  'en', 'Dashti'),
			(453, 7,  'fa', '????')
			

	");
	
	return;	
}

For more information send a message to info at phpclasses dot org.