Location: PHPKode > projects > HikaShop > back/helpers/update.php
<?php
/**
 * @package		HikaShop for Joomla!
 * @version		1.4.3
 * @author		hikashop.com
 * @copyright	(C) 2010 HIKARI SOFTWARE. All rights reserved.
 * @license		GNU/GPLv3 http://www.gnu.org/licenses/gpl-3.0.html
 */
defined('_JEXEC') or die('Restricted access');
?>
<?php
class hikashopUpdateHelper{
	var $db;
	function hikashopUpdateHelper(){
		$this->db =& JFactory::getDBO();
		jimport('joomla.filesystem.folder');
		jimport('joomla.filesystem.file');
		$this->update = JRequest::getBool('update');		
	}
	function addDefaultModules(){
	}
	function createUploadFolders(){
		$file = hikashop::get('class.file');
		$path = $file->getPath('file');
		if(!JFile::exists($path.'.htaccess')){
			$text = 'deny from all';
			JFile::write($path.'.htaccess',$text);
		}
		$path = $file->getPath('image');
	}


















	function installExtensions(){
		$path = HIKASHOP_BACK.'extensions';
		$dirs = JFolder::folders( $path );
		if(version_compare(JVERSION,'1.6.0') < ''){
			$query = "SELECT CONCAT(`folder`,`element`) FROM #__plugins WHERE `folder` IN ( 'hikashop','hikashoppayment','hikashopshipping' )  OR `element` LIKE '%hikashop%'";
			$query .= " UNION SELECT `module` FROM #__modules WHERE `module` LIKE '%hikashop%'";
			$this->db->setQuery($query);
			$existingExtensions = $this->db->loadResultArray();
		}else{
			$this->db->setQuery("SELECT CONCAT(`folder`,`element`) FROM #__extensions WHERE `folder` IN ( 'hikashop','hikashoppayment','hikashopshipping' ) OR `element` LIKE '%hikashop%'");
			$existingExtensions = $this->db->loadResultArray();
		}
		$success = array();
		$plugins = array();
		$modules = array();
		$extensioninfo = array(); //array('name','ordering','required table or published')
		$extensioninfo['mod_hikashop'] = array('HikaShop Content Module');
		$extensioninfo['mod_hikashop_cart'] = array('HikaShop Cart Module');
		$extensioninfo['mod_hikashop_currency'] = array('HikaShop Currency Switcher Module');
		$extensioninfo['plg_acymailing_hikashop'] = array('AcyMailing : HikaShop integration',0,1,1);
		$extensioninfo['plg_community_hikashop'] = array('JomSocial HikaShop integration',0,1,1);
		$extensioninfo['plg_hikashop_acymailing'] = array('HikaShop trigger for AcyMailing filters',0,1);
		$extensioninfo['plg_hikashop_history'] = array('HikaShop order history plugin',0,1);
		$extensioninfo['plg_hikashop_license'] = array('HikaShop license plugin',0,1);
		$extensioninfo['plg_hikashop_rates'] = array('HikaShop rates auto update plugin',0,1);
		$extensioninfo['plg_hikashoppayment_atos'] = array('HikaShop SIPS Atos payment plugin',0,0);
		$extensioninfo['plg_hikashoppayment_authorize'] = array('HikaShop Authorize.net payment plugin',0,0);
		$extensioninfo['plg_hikashoppayment_banktransfer'] = array('HikaShop bank transfer payment plugin',0,0);
		$extensioninfo['plg_hikashoppayment_bluepaid'] = array('HikaShop Bluepaid payment plugin',0,0);
		$extensioninfo['plg_hikashoppayment_check'] = array('HikaShop check payment plugin',0,0);
		$extensioninfo['plg_hikashoppayment_collectondelivery'] = array('HikaShop collect on delivery payment plugin',0,0);
		$extensioninfo['plg_hikashoppayment_moneybookers'] = array('HikaShop Moneybookers payment plugin',0,0);
		$extensioninfo['plg_hikashoppayment_paypal'] = array('HikaShop Paypal payment plugin',0,0);
		$extensioninfo['plg_hikashoppayment_creditcard'] = array('HikaShop credit card payment plugin',0,0);
		$extensioninfo['plg_hikashoppayment_quickbooks'] = array('HikaShop Quickbooks payment plugin',0,0);
		$extensioninfo['plg_hikashopshipping_aupost'] = array('HikaShop Australia Post shipping plugin',0,0);
		$extensioninfo['plg_hikashopshipping_manual'] = array('HikaShop manual shipping plugin',0,0);
		$extensioninfo['plg_search_hikashop_categories'] = array('HikaShop categories search plugin',0,1);
		$extensioninfo['plg_search_hikashop_products'] = array('HikaShop products search plugin',0,1);
		$extensioninfo['plg_system_hikashopaffiliate'] = array('HikaShop affiliate plugin',0,1);
		$extensioninfo['plg_system_hikashopgeolocation'] = array('HikaShop geolocation plugin',0,1);
		$extensioninfo['plg_user_hikashop'] = array('HikaShop user synchronization plugin',0,1);
		$listTables = $this->db->getTableList();
		$this->errors=array();
		foreach($dirs as $oneDir){
			$arguments = explode('_',$oneDir);
			$report = true;
			if(!empty($extensioninfo[$oneDir][3])){
				$report = false;
			}
			if($arguments[0] == 'plg'){
				$newPlugin = null;
				$newPlugin->name = $oneDir;
				if(isset($extensioninfo[$oneDir][0])) $newPlugin->name = $extensioninfo[$oneDir][0];
				$newPlugin->type = 'plugin';
				$newPlugin->folder = $arguments[1];
				if(isset($arguments[3])){
					$arguments[2].='_'.$arguments[3];
				}
				$newPlugin->element = $arguments[2];
				$newPlugin->enabled = 1;
				if(isset($extensioninfo[$oneDir][2])){
					if(is_numeric($extensioninfo[$oneDir][2])) $newPlugin->enabled = $extensioninfo[$oneDir][2];
				}
				$newPlugin->params = '{}';
				$newPlugin->ordering = 0;
				if(isset($extensioninfo[$oneDir][1])) $newPlugin->ordering = $extensioninfo[$oneDir][1];
				if(!hikashop::createDir(HIKASHOP_ROOT.'plugins'.DS.$newPlugin->folder,$report)) continue;
				if(version_compare(JVERSION,'1.6.0','<')){
					$destinationFolder = HIKASHOP_ROOT.'plugins'.DS.$newPlugin->folder;
				}else{
					$destinationFolder = HIKASHOP_ROOT.'plugins'.DS.$newPlugin->folder.DS.$newPlugin->element;
					if(!hikashop::createDir($destinationFolder)) continue;
				}
				if(!$this->copyFolder($path.DS.$oneDir,$destinationFolder)) continue;
				if(in_array($newPlugin->folder.$newPlugin->element,$existingExtensions)) continue;
				$plugins[] = $newPlugin;
			}elseif($arguments[0] == 'mod'){
				$newModule = null;
				$newModule->name = $oneDir;
				if(isset($extensioninfo[$oneDir][0])) $newModule->name = $extensioninfo[$oneDir][0];
				$newModule->type = 'module';
				$newModule->folder = '';
				$newModule->element = $oneDir;
				$newModule->enabled = 1;
				$newModule->params = '{}';
				$newModule->ordering = 0;
				if(isset($extensioninfo[$oneDir][1])) $newModule->ordering = $extensioninfo[$oneDir][1];
				$destinationFolder = HIKASHOP_ROOT.'modules'.DS.$oneDir;
				if(!hikashop::createDir($destinationFolder)) continue;
				if(!$this->copyFolder($path.DS.$oneDir,$destinationFolder)) continue;
				if(in_array($newModule->element,$existingExtensions)) continue;
				$modules[] = $newModule;
			}else{
				hikashop::display('Could not handle : '.$oneDir,'error');
			}
		}
		if(!empty($this->errors)) hikashop::display($this->errors,'error');
		if(version_compare(JVERSION,'1.6.0','<')){
			$extensions = $plugins;
		}else{
			$extensions = array_merge($plugins,$modules);
		}
		$success = array();
		if(!empty($extensions)){
			if(version_compare(JVERSION,'1.6.0','<')){
				$queryExtensions = 'INSERT INTO `#__plugins` (`name`,`element`,`folder`,`published`,`ordering`) VALUES ';
			}else{
				$queryExtensions = 'INSERT INTO `#__extensions` (`name`,`element`,`folder`,`enabled`,`ordering`,`type`) VALUES ';
			}
			foreach($extensions as $oneExt){
				$queryExtensions .= '('.$this->db->Quote($oneExt->name).','.$this->db->Quote($oneExt->element).','.$this->db->Quote($oneExt->folder).','.$oneExt->enabled.','.$oneExt->ordering;
				if(version_compare(JVERSION,'1.6.0','>=')) $queryExtensions .= ','.$this->db->Quote($oneExt->type);
				$queryExtensions .= '),';
				if($oneExt->type!='module'){
					$success[] = JText::sprintf('PLUG_INSTALLED',$oneExt->name);
				}
			}
			$queryExtensions = trim($queryExtensions,',');
			$this->db->setQuery($queryExtensions);
			$this->db->query();
		}
		if(!empty($modules)){
			foreach($modules as $oneModule){
				if(version_compare(JVERSION,'1.6.0','<')){
					$queryModule = 'INSERT INTO `#__modules` (`title`,`position`,`published`,`module`) VALUES ';
					$queryModule .= '('.$this->db->Quote($oneModule->name).",'left',0,".$this->db->Quote($oneModule->element).")";
				}else{
					$queryModule = 'INSERT INTO `#__modules` (`title`,`position`,`published`,`module`,`access`,`language`) VALUES ';
					$queryModule .= '('.$this->db->Quote($oneModule->name).",'position-7',0,".$this->db->Quote($oneModule->element).",1,'*')";
				}
				$this->db->setQuery($queryModule);
				$this->db->query();
				$moduleId = $this->db->insertid();
				$this->db->setQuery('INSERT IGNORE INTO `#__modules_menu` (`moduleid`,`menuid`) VALUES ('.$moduleId.',0)');
				$this->db->query();
				$success[] = JText::sprintf('MODULE_INSTALLED',$oneModule->name);
			}
		}
		if(!empty($success)) hikashop::display('<ul><li>'.implode('</li><li>',$success).'</li></ul>','success');
	}
	function copyFolder($from,$to){
		$return = true;
		$allFiles = JFolder::files($from);
		foreach($allFiles as $oneFile){
			if(file_exists($to.DS.'index.html') AND $oneFile == 'index.html') continue;
			if(JFile::copy($from.DS.$oneFile,$to.DS.$oneFile) !== true){
				$this->errors[] = 'Could not copy the file from '.$from.DS.$oneFile.' to '.$to.DS.$oneFile;
				$return = false;
			}
		}
		$allFolders = JFolder::folders($from);
		if(!empty($allFolders)){
			foreach($allFolders as $oneFolder){
				if(!hikashop::createDir($to.DS.$oneFolder)) continue;
				if(!$this->copyFolder($from.DS.$oneFolder,$to.DS.$oneFolder)) $return = false;
			}
		}
		return $return;
	}
	function installMenu($code = ''){
		if(empty($code)){
			$lang =& JFactory::getLanguage();
			$code = $lang->getTag();
		}
		$path = JLanguage::getLanguagePath(JPATH_ROOT).DS.$code.DS.$code.'.com_hikashop.ini';
		if(!file_exists($path)) return;
		$content = file_get_contents($path);
		if(empty($content)) return;
		$menuFileContent = 'COM_HIKASHOP="HikaShop"'."\r\n".'HIKASHOP="HikaShop"'."\r\n";
		$menuStrings = array('PRODUCTS','CATEGORIES','USERS','ORDERS','CONFIGURATION','DISCOUNTS','HELP','UPDATE_ABOUT');
		foreach($menuStrings as $oneString){
			preg_match('#(\n|\r)(HIKA_)?'.$oneString.'="(.*)"#i',$content,$matches);
			if(empty($matches[3])) continue;
			if(version_compare(JVERSION,'1.6.0','<')){
				$menuFileContent .= 'COM_HIKASHOP.'.$oneString.'="'.$matches[3].'"'."\r\n";
			}else{
				$menuFileContent .= $oneString.'="'.$matches[3].'"'."\r\n";
			}
		}
		if(version_compare(JVERSION,'1.6.0','<')){
			$menuPath = HIKASHOP_ROOT.'administrator'.DS.'language'.DS.$code.DS.$code.'.com_hikashop.menu.ini';
		}else{
			$menuPath = HIKASHOP_ROOT.'administrator'.DS.'language'.DS.$code.DS.$code.'.com_hikashop.sys.ini';
		}
		if(!JFile::write($menuPath, $menuFileContent)){
			hikashop::display(JText::sprintf('FAIL_SAVE',$menuPath),'error');
		}
	}
	function _installOne($folder){
		if(empty($folder)) return false;
		unset($GLOBALS['_JREQUEST']['installtype']);
		unset($GLOBALS['_JREQUEST']['install_directory']);
		JRequest::setVar('installtype','folder');
		JRequest::setVar('install_directory',$folder);
		$_REQUEST['installtype']='folder';
		$_REQUEST['install_directory']=$folder;
		$controller = new JController(array('base_path'=>
		HIKASHOP_ROOT.'administrator'.DS.'components'.DS.'com_installer','name'=>'Installer','default_task'
		=> 'installform'));
		$model  = $controller->getModel('Install');
		return $model->install();
	}
	function getUrl(){
		$urls = parse_url(HIKASHOP_LIVE);
		$lurl = preg_replace('#^www2?\.#Ui','',$urls['host'],1);
		if(!empty($urls['path'])) $lurl .= $urls['path'];
		return strtolower(rtrim($lurl,'/'));
	}
	function addJoomfishElements(){
		$dstFolder = rtrim(JPATH_ADMINISTRATOR,DS).DS.'components'.DS.'com_joomfish'.DS.'contentelements'.DS;
		if(JFolder::exists($dstFolder)){
			$srcFolder = HIKASHOP_BACK.'translations'.DS;
			$files = JFolder::files($srcFolder);
			if(!empty($files)){
				foreach($files as $file){
					JFile::copy($srcFolder.$file,$dstFolder.$file);
				}
			}
		}
		return true;
	}
	function addDefaultData(){
		if(version_compare(JVERSION,'1.6','<')){
			$query = 'DELETE FROM `#__components` WHERE `admin_menu_link` LIKE \'%option=com\_hikashop%\' AND `parent`!=0';
			$this->db->setQuery($query);
			$this->db->query();
			$query = 'SELECT id FROM `#__components` WHERE `option`=\'com_hikashop\' AND `parent`=0';
			$this->db->setQuery($query);
			$parent = (int)$this->db->loadResult();
			$query  = "INSERT IGNORE INTO `#__components` (`admin_menu_link`,`admin_menu_img`,`admin_menu_alt`,`name`,`ordering`,`parent`) VALUES
			('option=com_hikashop&amp;ctrl=product','../includes/js/ThemeOffice/document.png','Products','Products',1,".$parent."),
			('option=com_hikashop&amp;ctrl=category&amp;filter_id=product','../includes/js/ThemeOffice/sections.png','Categories','Categories',2,".$parent."),
			('option=com_hikashop&amp;ctrl=user&amp;filter_partner=0','../includes/js/ThemeOffice/user.png','Users','Users',3,".$parent."),
			('option=com_hikashop&amp;ctrl=order&amp;order_type=sale&amp;filter_partner=0','../includes/js/ThemeOffice/content.png','Orders','Orders',4,".$parent."),
			('option=com_hikashop&amp;ctrl=config','../includes/js/ThemeOffice/config.png','Configuration','Configuration',5,".$parent."),
			('option=com_hikashop&amp;ctrl=discount','../includes/js/ThemeOffice/credits.png','Discounts','Discounts',6,".$parent."),
			('option=com_hikashop&amp;ctrl=documentation','../includes/js/ThemeOffice/help.png','Help','Help',7,".$parent."),
			('option=com_hikashop&amp;ctrl=update','../includes/js/ThemeOffice/install.png','Update / About','Update / About',8,".$parent.");";
			$this->db->setQuery($query);
			$this->db->query();
		}else{
			$query = 'SELECT * FROM `#__menu` WHERE `title` IN (\'com_hikashop\',\'hikashop\',\'HikaShop\') AND `parent_id`=1 AND menutype IN (\'main\',\'mainmenu\',\'menu\')';
			$this->db->setQuery($query);
			$parentData = $this->db->loadObject();
			$parent = $parentData->id;
			$query = 'SELECT id FROM `#__menu` WHERE `parent_id`='.$parent;
			$this->db->setQuery($query);
			$submenu = $this->db->loadResultArray();
			$old=count($submenu);
			$query = 'DELETE FROM `#__menu` WHERE `parent_id`='.$parent;
			$this->db->setQuery($query);
			$this->db->query();
			$query = 'UPDATE `#__menu` SET `rgt`=`rgt`-'.($old*2).' WHERE `rgt`>='.$parentData->rgt;
			$this->db->setQuery($query);
			$this->db->query();
			$query = 'UPDATE `#__menu` SET `rgt`=`rgt`+16 WHERE `rgt`>='.$parentData->rgt;
			$this->db->setQuery($query);
			$this->db->query();
			$left = $parentData->lft;
			$cid = $parentData->component_id;
			$query  = "INSERT IGNORE INTO `#__menu` (`type`,`link`,`menutype`,`img`,`alias`,`title`,`client_id`,`parent_id`,`level`,`language`,`lft`,`rgt`,`component_id`) VALUES
			('component','index.php?option=com_hikashop&ctrl=product','menu','./templates/bluestork/images/menu/icon-16-article.png','Products','Products',1,".$parent.",2,'*',".($left+1).",".($left+2).",".$cid."),
			('component','index.php?option=com_hikashop&ctrl=category&filter_id=product','menu','./templates/bluestork/images/menu/icon-16-category.png','Categories','Categories',1,".$parent.",2,'*',".($left+3).",".($left+4).",".$cid."),
			('component','index.php?option=com_hikashop&ctrl=user&filter_partner=0','menu','./templates/bluestork/images/menu/icon-16-user.png','Users','Users',1,".$parent.",2,'*',".($left+5).",".($left+6).",".$cid."),
			('component','index.php?option=com_hikashop&ctrl=order&order_type=sale&filter_partner=0','menu','./templates/bluestork/images/menu/icon-16-content.png','Orders','Orders',1,".$parent.",2,'*',".($left+7).",".($left+8).",".$cid."),
			('component','index.php?option=com_hikashop&ctrl=config','menu','./templates/bluestork/images/menu/icon-16-config.png','Configuration','Configuration',1,".$parent.",2,'*',".($left+9).",".($left+10).",".$cid."),
			('component','index.php?option=com_hikashop&ctrl=discount','menu','./templates/bluestork/images/menu/icon-16-default.png','Discounts','Discounts',1,".$parent.",2,'*',".($left+11).",".($left+12).",".$cid."),
			('component','index.php?option=com_hikashop&ctrl=documentation','menu','./templates/bluestork/images/menu/icon-16-help.png','Help','Help',1,".$parent.",2,'*',".($left+13).",".($left+14).",".$cid."),
			('component','index.php?option=com_hikashop&ctrl=update','menu','./templates/bluestork/images/menu/icon-16-help-jrd.png','Update / About','Update / About',1,".$parent.",2,'*',".($left+15).",".($left+16).",".$cid.");
			";
			$this->db->setQuery($query);
			$this->db->query();
		}
		$query = 'INSERT IGNORE INTO `#__hikashop_user` (`user_email`,`user_cms_id`,`user_created`) SELECT `email`, `id`,'.time().' FROM `#__users`';
		$this->db->setQuery($query);
		$this->db->query();
		$query="INSERT IGNORE INTO `#__hikashop_category` (`category_id`, `category_parent_id`, `category_type`, `category_name`, `category_description`, `category_published`, `category_ordering`, `category_left`, `category_right`, `category_depth`, `category_namekey`) VALUES
(1, 0, 'root', 'ROOT', '', 0, 0, 1, 18, 0, 'root'),
(2, 1, 'product', 'product category', '', 1, 1, 2, 3, 1, 'product'),
(3, 1, 'tax', 'taxation category', '', 1, 2, 4, 5, 1, 'tax'),
(4, 1, 'status', 'order status', '', 1, 3, 6, 17, 1, 'status'),
(5, 4, 'status', 'created', 'When a customer finishes a checkout, an order is created with the status created', 1, 1, 7, 8, 2, 'created'),
(6, 4, 'status', 'confirmed', 'When the payment is confirmed or that the payment is done at delivery the order becomes confirmed', 1, 2, 9, 10, 2, 'confirmed'),
(7, 4, 'status', 'cancelled', 'When an order is cancelled before receiving a payment', 1, 3, 11, 12, 2, 'cancelled'),
(8, 4, 'status', 'refunded', 'When an order is cancelled after receiving a payment', 1, 4, 13, 14, 2, 'refunded'),
(9, 4, 'status', 'shipped', 'When an order has been shipped', 1, 5, 15, 16, 2, 'shipped');";
		$this->db->setQuery($query);
		$this->db->query();
		$query=<<<EOD
INSERT IGNORE INTO `#__hikashop_field` (`field_table`, `field_realname`, `field_namekey`, `field_type`, `field_value`, `field_published`, `field_ordering`, `field_options`, `field_core`, `field_required`, `field_backend`, `field_frontcomp`, `field_default`, `field_backend_listing`) VALUES
('address', 'Title', 'address_title', 'singledropdown', 'Mr::Mr\nMrs::Mrs\nMiss::Miss\nMs::Ms\nDr::Dr', 1, 1, 'a:5:{s:12:"errormessage";s:0:"";s:4:"cols";s:0:"";s:4:"rows";s:0:"";s:4:"size";s:0:"";s:6:"format";s:0:"";}', 1, 1, 1, 1, '', 0),
('address', 'Firstname', 'address_firstname', 'text', '', 1, 2, 'a:5:{s:12:"errormessage";s:0:"";s:4:"cols";s:0:"";s:4:"rows";s:0:"";s:4:"size";s:0:"";s:6:"format";s:0:"";}', 1, 1, 1, 1, '', 0),
('address', 'Middle name', 'address_middle_name', 'text', '', 0, 3, 'a:5:{s:12:"errormessage";s:0:"";s:4:"cols";s:0:"";s:4:"rows";s:0:"";s:4:"size";s:0:"";s:6:"format";s:0:"";}', 1, 0, 1, 1, '', 0),
('address', 'Lastname', 'address_lastname', 'text', '', 1, 4, 'a:5:{s:12:"errormessage";s:0:"";s:4:"cols";s:0:"";s:4:"rows";s:0:"";s:4:"size";s:0:"";s:6:"format";s:0:"";}', 1, 1, 1, 1, '', 0),
('address', 'Company', 'address_company', 'text', '', 0, 5, 'a:5:{s:12:"errormessage";s:0:"";s:4:"cols";s:0:"";s:4:"rows";s:0:"";s:4:"size";s:0:"";s:6:"format";s:0:"";}', 1, 0, 1, 1, '', 0),
('address', 'Street', 'address_street', 'text', '', 1, 6, 'a:5:{s:12:"errormessage";s:0:"";s:4:"cols";s:0:"";s:4:"rows";s:0:"";s:4:"size";s:0:"";s:6:"format";s:0:"";}', 1, 1, 1, 1, '', 0),
('address', 'Post code', 'address_post_code', 'text', '', 1, 7, 'a:5:{s:12:"errormessage";s:0:"";s:4:"cols";s:0:"";s:4:"rows";s:0:"";s:4:"size";s:0:"";s:6:"format";s:0:"";}', 1, 0, 1, 1, '', 0),
('address', 'City', 'address_city', 'text', '', 1, 8, 'a:5:{s:12:"errormessage";s:0:"";s:4:"cols";s:0:"";s:4:"rows";s:0:"";s:4:"size";s:0:"";s:6:"format";s:0:"";}', 1, 1, 1, 1, '', 0),
('address', 'Telephone', 'address_telephone', 'text', '', 1, 9, 'a:5:{s:12:"errormessage";s:0:"";s:4:"cols";s:0:"";s:4:"rows";s:0:"";s:4:"size";s:0:"";s:6:"format";s:0:"";}', 1, 1, 1, 1, '', 0),
('address', 'Telephone', 'address_telephone2', 'text', '', 0, 10, 'a:5:{s:12:"errormessage";s:0:"";s:4:"cols";s:0:"";s:4:"rows";s:0:"";s:4:"size";s:0:"";s:6:"format";s:0:"";}', 1, 0, 1, 1, '', 0),
('address', 'Fax', 'address_fax', 'text', '', 0, 11, 'a:5:{s:12:"errormessage";s:0:"";s:4:"cols";s:0:"";s:4:"rows";s:0:"";s:4:"size";s:0:"";s:6:"format";s:0:"";}', 1, 0, 1, 1, '', 0),
('address', 'State', 'address_state', 'zone', '', 1, 13, 'a:6:{s:12:"errormessage";s:0:"";s:4:"cols";s:0:"";s:4:"rows";s:0:"";s:9:"zone_type";s:5:"state";s:4:"size";s:0:"";s:6:"format";s:0:"";}', 1, 1, 1, 1, 'state_Rh__ne_1375', 0),
('address', 'Country', 'address_country', 'zone', '', 1, 14, 'a:6:{s:12:"errormessage";s:0:"";s:4:"cols";s:0:"";s:4:"rows";s:0:"";s:9:"zone_type";s:7:"country";s:4:"size";s:0:"";s:6:"format";s:0:"";}', 1, 1, 1, 1, 'country_France_73', 0),
('address', 'VAT number', 'address_vat', 'text', '', 0, 15, 'a:6:{s:12:"errormessage";s:0:"";s:4:"cols";s:0:"";s:4:"rows";s:0:"";s:9:"zone_type";s:7:"country";s:4:"size";s:0:"";s:6:"format";s:0:"";}', 1, 0, 1, 1, '', 0);
EOD;
		$this->db->setQuery($query);
		$this->db->query();
		$query = <<<EOD
INSERT IGNORE INTO `#__hikashop_currency` (`currency_id`, `currency_symbol`, `currency_code`, `currency_format`, `currency_name`, `currency_published`, `currency_displayed`, `currency_locale`) VALUES
(1, '€', 'EUR', '%n', 'Euro', 1,1, 'a:13:{s:17:"mon_decimal_point";s:1:",";s:17:"mon_thousands_sep";s:1:".";s:12:"mon_grouping";s:1:"3";s:13:"positive_sign";s:0:"";s:13:"negative_sign";s:1:"-";s:15:"int_frac_digits";i:2;s:11:"frac_digits";i:2;s:13:"p_cs_precedes";i:0;s:14:"p_sep_by_space";i:1;s:13:"n_cs_precedes";i:0;s:14:"n_sep_by_space";i:1;s:11:"p_sign_posn";i:1;s:11:"n_sign_posn";i:1;}'),
(2, '\$', 'USD', '%n', 'United States dollar', 1, 1, 'a:13:{s:17:"mon_decimal_point";s:1:".";s:17:"mon_thousands_sep";s:1:",";s:12:"mon_grouping";s:1:"3";s:13:"positive_sign";s:0:"";s:13:"negative_sign";s:1:"-";s:15:"int_frac_digits";i:2;s:11:"frac_digits";i:2;s:13:"p_cs_precedes";i:1;s:14:"p_sep_by_space";i:0;s:13:"n_cs_precedes";i:1;s:14:"n_sep_by_space";i:0;s:11:"p_sign_posn";i:4;s:11:"n_sign_posn";i:4;}'),
(3, 'Â¥', 'JPY', '%n', 'Japanese yen', 0, 0, 'a:13:{s:17:"mon_decimal_point";s:1:",";s:17:"mon_thousands_sep";s:1:" ";s:12:"mon_grouping";s:1:"4";s:13:"positive_sign";s:0:"";s:13:"negative_sign";s:1:"-";s:15:"int_frac_digits";i:0;s:11:"frac_digits";i:0;s:13:"p_cs_precedes";i:0;s:14:"p_sep_by_space";i:1;s:13:"n_cs_precedes";i:0;s:14:"n_sep_by_space";i:1;s:11:"p_sign_posn";i:1;s:11:"n_sign_posn";i:1;}'),
(4, '£', 'GBP', '%n', 'British pound', 0, 0, 'a:13:{s:17:"mon_decimal_point";s:1:",";s:17:"mon_thousands_sep";s:1:" ";s:12:"mon_grouping";s:1:"3";s:13:"positive_sign";s:0:"";s:13:"negative_sign";s:1:"-";s:15:"int_frac_digits";i:2;s:11:"frac_digits";i:2;s:13:"p_cs_precedes";i:1;s:14:"p_sep_by_space";i:1;s:13:"n_cs_precedes";i:1;s:14:"n_sep_by_space";i:1;s:11:"p_sign_posn";i:1;s:11:"n_sign_posn";i:1;}'),
(5, '\$', 'CAD', '%i', 'Canadian dollar', 0, 0, ''),
(6, '\$', 'AUD', '%i', 'Australian dollar', 0, 0, ''),
(7, '\$', 'NZD', '%i', 'New Zealand dollar', 0, 0, ''),
(8, '؋', 'AFN', '%i', 'Afghan afghani', 0, 0, ''),
(9, 'Lek', 'ALL', '%i', 'Albanian lek', 0, 0, ''),
(10, 'د.ج', 'DZD', '%i', 'Algerian dinar', 0, 0, ''),
(11, 'Kz ', 'AOA', '%i', 'Angolan kwanza', 0, 0, ''),
(12, '\$', 'ARS', '%i', 'Argentine peso', 0, 0, ''),
(13, 'դր.', 'AMD', '%i', 'Armenian dram', 0, 0, ''),
(14, 'ƒ', 'AWG', '%i', 'Aruban florin', 0, 0, ''),
(15, 'ман', 'AZN', '%i', 'Azerbaijani manat', 0, 0, ''),
(16, '\$', 'BSD', '%i', 'Bahamian dollar', 0, 0, ''),
(17, 'ب.د', 'BHD', '%i', 'Bahraini dinar', 0, 0, ''),
(18, '৳', 'BDT', '%i', 'Bangladeshi taka', 0, 0, ''),
(19, '\$', 'BBD', '%i', 'Barbadian dollar', 0, 0, ''),
(20, 'p.', 'BYR', '%i', 'Belarusian ruble', 0, 0, ''),
(21, 'BZ\$', 'BZD', '%i', 'Belize dollar', 0, 0, ''),
(22, '\$', 'BMD', '%i', 'Bermudian dollar', 0, 0, ''),
(23, 'BTN', 'BTN', '%i', 'Bhutanese ngultrum', 0, 0, ''),
(24, '\$b', 'BOB', '%i', 'Bolivian boliviano', 0, 0, ''),
(25, 'XBA', 'XBA', '%i', 'Bond Markets', 0, 0, ''),
(26, 'KM', 'BAM', '%i', 'Bosnia and Herzegovina convert', 0, 0, ''),
(27, 'P', 'BWP', '%i', 'Botswana pula', 0, 0, ''),
(28, 'R$', 'BRL', '%i', 'Brazilian real', 0, 0, ''),
(29, '\$', 'BND', '%i', 'Brunei dollar', 0, 0, ''),
(30, 'лв', 'BGN', '%i', 'Bulgarian lev', 0, 0, ''),
(31, 'Fr ', 'BIF', '%i', 'Burundian franc', 0, 0, ''),
(32, '៛', 'KHR', '%i', 'Cambodian riel', 0, 0, ''),
(33, '\$', 'CVE', '%i', 'Cape Verdean escudo', 0, 0, ''),
(34, '\$', 'KYD', '%i', 'Cayman Islands dollar', 0, 0, ''),
(35, 'Fr ', 'XAF', '%i', 'Central African CFA franc', 0, 0, ''),
(36, 'Fr ', 'XPF', '%i', 'CFP franc', 0, 0, ''),
(37, '\$', 'CLP', '%i', 'Chilean peso', 0, 0, ''),
(38, '元', 'CNY', '%i', 'Chinese renminbi yuan', 0, 0, ''),
(39, 'XTS', 'XTS', '%i', 'Codes specif', 0, 0, ''),
(40, '\$', 'COP', '%i', 'Colombian peso', 0, 0, ''),
(41, 'Fr ', 'KMF', '%i', 'Comorian franc', 0, 0, ''),
(42, 'Fr ', 'CDF', '%i', 'Congolese franc', 0, 0, ''),
(43, '₡', 'CRC', '%i', 'Costa Rican colón', 0, 0, ''),
(44, 'kn', 'HRK', '%i', 'Croatian kuna', 0, 0, ''),
(45, '₱', 'CUP', '%i', 'Cuban peso', 0, 0, ''),
(46, 'Kč', 'CZK', '%i', 'Czech koruna', 0, 0, ''),
(47, 'kr', 'DKK', '%i', 'Danish krone', 0, 0, ''),
(48, 'Fr ', 'DJF', '%i', 'Djiboutian franc', 0, 0, ''),
(49, 'RD\$', 'DOP', '%i', 'Dominican peso', 0, 0, ''),
(50, '\$', 'XCD', '%i', 'East Caribbean dollar', 0, 0, ''),
(51, '£', 'EGP', '%i', 'Egyptian pound', 0, 0, ''),
(52, 'Nfk ', 'ERN', '%i', 'Eritrean nakfa', 0, 0, ''),
(53, 'kr', 'EEK', '%i', 'Estonian kroon', 0, 0, ''),
(54, 'ETB', 'ETB', '%i', 'Ethiopian birr', 0, 0, ''),
(55, 'XBB', 'XBB', '%i', 'European Mon', 0, 0, ''),
(56, 'XBD', 'XBD', '%i', 'European Uni', 0, 0, ''),
(57, 'XBC', 'XBC', '%i', 'European Uni', 0, 0, ''),
(58, '£', 'FKP', '%i', 'Falkland pound', 0, 0, ''),
(59, '$', 'FJD', '%i', 'Fijian dollar', 0, 0, ''),
(60, 'D ', 'GMD', '%i', 'Gambian dalasi', 0, 0, ''),
(61, 'ლ', 'GEL', '%i', 'Georgian lari', 0, 0, ''),
(62, '₵', 'GHS', '%i', 'Ghanaian cedi', 0, 0, ''),
(63, '£', 'GIP', '%i', 'Gibraltar pound', 0, 0, ''),
(64, 'Gold', 'XAU', '%i', 'Gold', 0, 0, ''),
(65, 'Q', 'GTQ', '%i', 'Guatemalan quetzal', 0, 0, ''),
(66, 'GWP', 'GWP', '%i', 'Guinea-Bissa', 0, 0, ''),
(67, 'Fr ', 'GNF', '%i', 'Guinean franc', 0, 0, ''),
(68, '$', 'GYD', '%i', 'Guyanese dollar', 0, 0, ''),
(69, 'G ', 'HTG', '%i', 'Haitian gourde', 0, 0, ''),
(70, 'L', 'HNL', '%i', 'Honduran lempira', 0, 0, ''),
(71, '元', 'HKD', '%i', 'Hong Kong dollar', 0, 0, ''),
(72, 'Ft', 'HUF', '%i', 'Hungarian forint', 0, 0, ''),
(73, 'kr', 'ISK', '%i', 'Icelandic króna', 0, 0, ''),
(74, '₨', 'INR', '%i', 'Indian rupee', 0, 0, ''),
(75, 'Rp', 'IDR', '%i', 'Indonesian rupiah', 0, 0, ''),
(76, 'ï·¼', 'IRR', '%i', 'Iranian rial', 0, 0, ''),
(77, 'ع.د', 'IQD', '%i', 'Iraqi dinar', 0, 0, ''),
(78, '₪', 'ILS', '%i', 'Israeli new sheqel', 0, 0, ''),
(79, 'J$', 'JMD', '%i', 'Jamaican dollar', 0, 0, ''),
(80, 'د.ا', 'JOD', '%i', 'Jordanian dinar', 0, 0, ''),
(81, 'лв', 'KZT', '%i', 'Kazakhstani tenge', 0, 0, ''),
(82, 'Sh ', 'KES', '%i', 'Kenyan shilling', 0, 0, ''),
(83, 'د.ك', 'KWD', '%i', 'Kuwaiti dinar', 0, 0, ''),
(84, 'лв', 'KGS', '%i', 'Kyrgyzstani som', 0, 0, ''),
(85, '₭', 'LAK', '%i', 'Lao kip', 0, 0, ''),
(86, 'Ls', 'LVL', '%i', 'Latvian lats', 0, 0, ''),
(87, '£', 'LBP', '%i', 'Lebanese pound', 0, 0, ''),
(88, 'L ', 'LSL', '%i', 'Lesotho loti', 0, 0, ''),
(89, '$', 'LRD', '%i', 'Liberian dollar', 0, 0, ''),
(90, 'ل.د', 'LYD', '%i', 'Libyan dinar', 0, 0, ''),
(91, 'Lt', 'LTL', '%i', 'Lithuanian litas', 0, 0, ''),
(92, 'P ', 'MOP', '%i', 'Macanese pataca', 0, 0, ''),
(93, 'ден', 'MKD', '%i', 'Macedonian denar', 0, 0, ''),
(94, 'MGA', 'MGA', '%i', 'Malagasy ariary', 0, 0, ''),
(95, 'MK ', 'MWK', '%i', 'Malawian kwacha', 0, 0, ''),
(96, 'RM', 'MYR', '%i', 'Malaysian ringgit', 0, 0, ''),
(97, 'ރ.', 'MVR', '%i', 'Maldivian rufiyaa', 0, 0, ''),
(98, 'UM ', 'MRO', '%i', 'Mauritanian ouguiya', 0, 0, ''),
(99, '₨', 'MUR', '%i', 'Mauritian rupee', 0, 0, ''),
(100, '\$', 'MXN', '%i', 'Mexican peso', 0, 0, ''),
(101, 'MXV', 'MXV', '%i', 'Mexican Unid', 0, 0, ''),
(102, 'L ', 'MDL', '%i', 'Moldovan leu', 0, 0, ''),
(103, '₮', 'MNT', '%i', 'Mongolian tögrög', 0, 0, ''),
(104, 'د.م.', 'MAD', '%i', 'Moroccan dirham', 0, 0, ''),
(105, 'MT', 'MZN', '%i', 'Mozambican metical', 0, 0, ''),
(106, 'BOV', 'BOV', '%i', 'Mvdol', 0, 0, ''),
(107, 'K ', 'MMK', '%i', 'Myanmar kyat', 0, 0, ''),
(108, '\$', 'NAD', '%i', 'Namibian dollar', 0, 0, ''),
(109, '₨', 'NPR', '%i', 'Nepalese rupee', 0, 0, ''),
(110, 'ƒ', 'ANG', '%i', 'Netherlands Antillean gulden', 0, 0, ''),
(111, 'NT\$', 'TWD', '%i', 'New Taiwan dollar', 0, 0, ''),
(112, 'C\$', 'NIO', '%i', 'Nicaraguan córdoba', 0, 0, ''),
(113, '₦', 'NGN', '%i', 'Nigerian naira', 0, 0, ''),
(114, '₩', 'KPW', '%i', 'North Korean won', 0, 0, ''),
(115, 'kr', 'NOK', '%i', 'Norwegian krone', 0, 0, ''),
(116, 'ï·¼', 'OMR', '%i', 'Omani rial', 0, 0, ''),
(117, '₨', 'PKR', '%i', 'Pakistani rupee', 0, 0, ''),
(118, 'XPD', 'XPD', '%i', 'Palladium', 0, 0, ''),
(119, 'B/.', 'PAB', '%i', 'Panamanian balboa', 0, 0, ''),
(120, 'K ', 'PGK', '%i', 'Papua New Guinean kina', 0, 0, ''),
(121, '₲', 'PYG', '%i', 'Paraguayan guaraní', 0, 0, ''),
(122, 'S/.', 'PEN', '%i', 'Peruvian nuevo sol', 0, 0, ''),
(123, '₱', 'PHP', '%i', 'Philippine peso', 0, 0, ''),
(124, 'XPT', 'XPT', '%i', 'Platinum', 0, 0, ''),
(125, 'zł', 'PLN', '%i', 'Polish Złoty', 0, 0, ''),
(126, 'ï·¼', 'QAR', '%i', 'Qatari riyal', 0, 0, ''),
(127, 'lei', 'RON', '%i', 'Romanian leu', 0, 0, ''),
(128, 'руб', 'RUB', '%i', 'Russian ruble', 0, 0, ''),
(129, 'Fr ', 'RWF', '%i', 'Rwandan franc', 0, 0, ''),
(130, '£', 'SHP', '%i', 'Saint Helenian pound', 0, 0, ''),
(131, '$', 'SVC', '%i', 'Salvadoran colón', 0, 0, ''),
(132, 'T ', 'WST', '%i', 'Samoan tala', 0, 0, ''),
(133, 'Db ', 'STD', '%i', 'São Tomé and Príncipe dobra', 0, 0, ''),
(134, 'ï·¼', 'SAR', '%i', 'Saudi riyal', 0, 0, ''),
(135, 'XDR', 'XDR', '%i', 'SDR', 0, 0, ''),
(136, 'Дин.', 'RSD', '%i', 'Serbian dinar', 0, 0, ''),
(137, '₨', 'SCR', '%i', 'Seychellois rupee', 0, 0, ''),
(138, 'Le ', 'SLL', '%i', 'Sierra Leonean leone', 0, 0, ''),
(139, 'XAG', 'XAG', '%i', 'Silver', 0, 0, ''),
(140, '\$', 'SGD', '%i', 'Singapore dollar', 0, 0, ''),
(141, 'Sk ', 'SKK', '%i', 'Slovak koruna', 0, 0, ''),
(142, '\$', 'SBD', '%i', 'Solomon Islands dollar', 0, 0, ''),
(143, 'S', 'SOS', '%i', 'Somali shilling', 0, 0, ''),
(144, 'R', 'ZAR', '%i', 'South African rand', 0, 0, ''),
(145, '₩', 'KRW', '%i', 'South Korean won', 0, 0, ''),
(146, '₨', 'LKR', '%i', 'Sri Lankan rupee', 0, 0, ''),
(147, '£ ', 'SDG', '%i', 'Sudanese pound', 0, 0, ''),
(148, '$', 'SRD', '%i', 'Surinamese dollar', 0, 0, ''),
(149, 'L ', 'SZL', '%i', 'Swazi lilangeni', 0, 0, ''),
(150, 'kr', 'SEK', '%i', 'Swedish krona', 0, 0, ''),
(151, 'CHF', 'CHF', '%i', 'Swiss franc', 0, 0, ''),
(152, '£', 'SYP', '%i', 'Syrian pound', 0, 0, ''),
(153, 'ЅМ', 'TJS', '%i', 'Tajikistani somoni', 0, 0, ''),
(154, 'Sh ', 'TZS', '%i', 'Tanzanian shilling', 0, 0, ''),
(155, '฿', 'THB', '%i', 'Thai baht', 0, 0, ''),
(156, 'XXX', 'XXX', '%i', 'The codes as', 0, 0, ''),
(157, 'T$ ', 'TOP', '%i', 'Tongan paʻanga', 0, 0, ''),
(158, 'TT$', 'TTD', '%i', 'Trinidad and Tobago dollar', 0, 0, ''),
(159, 'د.ت', 'TND', '%i', 'Tunisian dinar', 0, 0, ''),
(160, 'YTL', 'TRY', '%i', 'Turkish new lira', 0, 0, ''),
(161, 'm ', 'TMM', '%i', 'Turkmenistani manat', 0, 0, ''),
(162, 'Sh ', 'UGX', '%i', 'Ugandan shilling', 0, 0, ''),
(163, 'XFU', 'XFU', '%i', 'UIC-Franc', 0, 0, ''),
(164, '₴', 'UAH', '%i', 'Ukrainian hryvnia', 0, 0, ''),
(165, 'COU', 'COU', '%i', 'Unidad de Va', 0, 0, ''),
(166, 'CLF', 'CLF', '%i', 'Unidades de ', 0, 0, ''),
(167, 'د.إ', 'AED', '%i', 'United Arab Emirates dirham', 0, 0, ''),
(168, 'UYI', 'UYI', '%i', 'Uruguay Peso', 0, 0, ''),
(169, '\$', 'UYU', '%i', 'Uruguayan peso', 0, 0, ''),
(170, '\$', 'USN', '%i', 'US Dollar (Next Day)', 0, 0, ''),
(171, '\$', 'USS', '%i', 'US Dollar (Second Day)', 0, 0, ''),
(172, 'лв', 'UZS', '%i', 'Uzbekistani som', 0, 0, ''),
(173, 'Vt ', 'VUV', '%i', 'Vanuatu vatu', 0, 0, ''),
(174, 'Bs', 'VEF', '%i', 'Venezuelan bolívar', 0, 0, ''),
(175, '₫', 'VND', '%i', 'Vietnamese Dong', 0, 0, ''),
(176, 'Fr ', 'XOF', '%i', 'West African CFA franc', 0, 0, ''),
(177, '€', 'CHE', '%i', 'WIR Euro', 0, 0, ''),
(178, 'CHW', 'CHW', '%i', 'WIR Franc', 0, 0, ''),
(179, 'ï·¼', 'YER', '%i', 'Yemeni rial', 0, 0, ''),
(180, 'ZK ', 'ZMK', '%i', 'Zambian kwacha', 0, 0, ''),
(181, 'Z\$', 'ZWD', '%i', 'Zimbabwean dollar', 0, 0, '');
EOD;
		$this->db->setQuery($query);
		$this->db->query();
		$query="
INSERT IGNORE INTO `#__hikashop_zone` (`zone_id`, `zone_namekey`, `zone_name`, `zone_name_english`, `zone_code_2`, `zone_code_3`, `zone_type`, `zone_published`) VALUES
(1, 'country_Afghanistan_1', 'افغانستان', 'Afghanistan', 'AF', 'AFG', 'country', 1),
(2, 'country_Albania_2', 'Shqipëria', 'Albania', 'AL', 'ALB', 'country', 1),
(3, 'country_Algeria_3', 'الجزائر', 'Algeria', 'DZ', 'DZA', 'country', 1),
(4, 'country_American_Samoa_4', 'American Samoa', 'American Samoa', 'AS', 'ASM', 'country', 1),
(5, 'country_Andorra_5', 'Andorra', 'Andorra', 'AD', 'AND', 'country', 1),
(6, 'country_Angola_6', 'Angola', 'Angola', 'AO', 'AGO', 'country', 1),
(7, 'country_Anguilla_7', 'Anguilla', 'Anguilla', 'AI', 'AIA', 'country', 1),
(8, 'country_Antarctica_8', 'Antarctica', 'Antarctica', 'AQ', 'ATA', 'country', 1),
(9, 'country_Antigua_and_Barbuda_9', 'Antigua and Barbuda', 'Antigua and Barbuda', 'AG', 'ATG', 'country', 1),
(10, 'country_Argentina_10', 'Argentina', 'Argentina', 'AR', 'ARG', 'country', 1),
(11, 'country_Armenia_11', 'Հայաստան', 'Armenia', 'AM', 'ARM', 'country', 1),
(12, 'country_Aruba_12', 'Aruba', 'Aruba', 'AW', 'ABW', 'country', 1),
(13, 'country_Australia_13', 'Australia', 'Australia', 'AU', 'AUS', 'country', 1),
(14, 'country_Austria_14', 'Österreich', 'Austria', 'AT', 'AUT', 'country', 1),
(15, 'country_Azerbaijan_15', 'Azərbaycan', 'Azerbaijan', 'AZ', 'AZE', 'country', 1),
(16, 'country_Bahamas_16', 'Bahamas', 'Bahamas', 'BS', 'BHS', 'country', 1),
(17, 'country_Bahrain_17', 'البحرين', 'Bahrain', 'BH', 'BHR', 'country', 1),
(18, 'country_Bangladesh_18', 'বাংলাদেশ''', 'Bangladesh', 'BD', 'BGD', 'country', 1),
(19, 'country_Barbados_19', 'Barbados', 'Barbados', 'BB', 'BRB', 'country', 1),
(20, 'country_Belarus_20', 'Беларусь', 'Belarus', 'BY', 'BLR', 'country', 1),
(21, 'country_Belgium_21', 'België • Belgique • Belgien', 'Belgium', 'BE', 'BEL', 'country', 1),
(22, 'country_Belize_22', 'Belize', 'Belize', 'BZ', 'BLZ', 'country', 1),
(23, 'country_Benin_23', 'Bénin', 'Benin', 'BJ', 'BEN', 'country', 1),
(24, 'country_Bermuda_24', 'Bermuda', 'Bermuda', 'BM', 'BMU', 'country', 1),
(25, 'country_Bhutan_25', 'འབྲུག་ཡུལ་', 'Bhutan', 'BT', 'BTN', 'country', 1),
(26, 'country_Bolivia_26', 'Wuliwya • Volívia • Buliwya', 'Bolivia', 'BO', 'BOL', 'country', 1),
(27, 'country_Bosnia_and_Herzegowina_27', 'Bosna i Hercegovina', 'Bosnia and Herzegowina', 'BA', 'BIH', 'country', 1),
(28, 'country_Botswana_28', 'Botswana', 'Botswana', 'BW', 'BWA', 'country', 1),
(29, 'country_Bouvet_Island_29', 'Bouvet Island', 'Bouvet Island', 'BV', 'BVT', 'country', 1),
(30, 'country_Brazil_30', 'Brazil', 'Brazil', 'BR', 'BRA', 'country', 1),
(31, 'country_British_Indian_Ocean_Territory_31', 'British Indian Ocean Territory', 'British Indian Ocean Territory', 'IO', 'IOT', 'country', 1),
(32, 'country_Brunei_Darussalam_32', 'Brunei Darussalam', 'Brunei Darussalam', 'BN', 'BRN', 'country', 1),
(33, 'country_Bulgaria_33', 'България', 'Bulgaria', 'BG', 'BGR', 'country', 1),
(34, 'country_Burkina_Faso_34', 'Burkina Faso', 'Burkina Faso', 'BF', 'BFA', 'country', 1),
(35, 'country_Burundi_35', 'Uburundi', 'Burundi', 'BI', 'BDI', 'country', 1),
(36, 'country_Cambodia_36', 'កម្ពុជា', 'Cambodia', 'KH', 'KHM', 'country', 1),
(37, 'country_Cameroon_37', 'Cameroun', 'Cameroon', 'CM', 'CMR', 'country', 1),
(38, 'country_Canada_38', 'Canada', 'Canada', 'CA', 'CAN', 'country', 1),
(39, 'country_Cape_Verde_39', 'Cabo Verde', 'Cape Verde', 'CV', 'CPV', 'country', 1),
(40, 'country_Cayman_Islands_40', 'Cayman Islands', 'Cayman Islands', 'KY', 'CYM', 'country', 1),
(41, 'country_Central_African_Republic_41', 'Centrafrique • Bêafrîka', 'Central African Republic', 'CF', 'CAF', 'country', 1),
(42, 'country_Chad_42', 'Tchad • تشاد', 'Chad', 'TD', 'TCD', 'country', 1),
(43, 'country_Chile_43', 'Chile', 'Chile', 'CL', 'CHL', 'country', 1),
(44, 'country_China_44', '中國 • 中国', 'China', 'CN', 'CHN', 'country', 1),
(45, 'country_Christmas_Island_45', 'Christmas Island', 'Christmas Island', 'CX', 'CXR', 'country', 1),
(46, 'country_Cocos__Keeling__Islands_46', 'Cocos (Keeling) Islands', 'Cocos (Keeling) Islands', 'CC', 'CCK', 'country', 1),
(47, 'country_Colombia_47', 'Colombia', 'Colombia', 'CO', 'COL', 'country', 1),
(48, 'country_Comoros_48', 'Komori • Comores • جزر القمر', 'Comoros', 'KM', 'COM', 'country', 1),
(49, 'country_Congo_49', 'Congo', 'Congo', 'CG', 'COG', 'country', 1),
(50, 'country_Cook_Islands_50', 'Cook Islands', 'Cook Islands', 'CK', 'COK', 'country', 1),
(51, 'country_Costa_Rica_51', 'Costa Rica', 'Costa Rica', 'CR', 'CRI', 'country', 1),
(52, 'country_Cote_D_Ivoire_52', 'Cote D''Ivoire', 'Cote D''Ivoire', 'CI', 'CIV', 'country', 1),
(53, 'country_Croatia_53', 'Hrvatska', 'Croatia', 'HR', 'HRV', 'country', 1),
(54, 'country_Cuba_54', 'Cuba', 'Cuba', 'CU', 'CUB', 'country', 1),
(55, 'country_Cyprus_55', 'Κύπρος • Kıbrıs', 'Cyprus', 'CY', 'CYP', 'country', 1),
(56, 'country_Czech_Republic_56', 'Česko', 'Czech Republic', 'CZ', 'CZE', 'country', 1),
(57, 'country_Denmark_57', 'Danmark', 'Denmark', 'DK', 'DNK', 'country', 1),
(58, 'country_Djibouti_58', 'جيبوتي', 'Djibouti', 'DJ', 'DJI', 'country', 1),
(59, 'country_Dominica_59', 'Dominica', 'Dominica', 'DM', 'DMA', 'country', 1),
(60, 'country_Dominican_Republic_60', 'República Dominicana', 'Dominican Republic', 'DO', 'DOM', 'country', 1),
(61, 'country_East_Timor_61', 'Timór-Leste', 'East Timor', 'TP', 'TMP', 'country', 1),
(62, 'country_Ecuador_62', 'Ecuador', 'Ecuador', 'EC', 'ECU', 'country', 1),
(63, 'country_Egypt_63', 'مصر', 'Egypt', 'EG', 'EGY', 'country', 1),
(64, 'country_El_Salvador_64', 'El Salvador', 'El Salvador', 'SV', 'SLV', 'country', 1),
(65, 'country_Equatorial_Guinea_65', 'Guinée équatoriale', 'Equatorial Guinea', 'GQ', 'GNQ', 'country', 1),
(66, 'country_Eritrea_66', 'ኤርትራ • إرتريا', 'Eritrea', 'ER', 'ERI', 'country', 1),
(67, 'country_Estonia_67', 'Eesti', 'Estonia', 'EE', 'EST', 'country', 1),
(68, 'country_Ethiopia_68', 'ኢትዮጵያ', 'Ethiopia', 'ET', 'ETH', 'country', 1),
(69, 'country_Falkland_Islands__Malvinas__69', 'Falkland Islands (Malvinas)', 'Falkland Islands (Malvinas)', 'FK', 'FLK', 'country', 1),
(70, 'country_Faroe_Islands_70', 'Faroe Islands', 'Faroe Islands', 'FO', 'FRO', 'country', 1),
(71, 'country_Fiji_71', 'Viti • फ़िजी', 'Fiji', 'FJ', 'FJI', 'country', 1),
(72, 'country_Finland_72', 'Suomi', 'Finland', 'FI', 'FIN', 'country', 1),
(73, 'country_France_73', 'France', 'France', 'FR', 'FRA', 'country', 1),
(74, 'country_France__Metropolitan_74', 'France, Metropolitan', 'France, Metropolitan', 'FX', 'FXX', 'country', 0),
(75, 'country_French_Guiana_75', 'French Guiana', 'French Guiana', 'GF', 'GUF', 'country', 1),
(76, 'country_French_Polynesia_76', 'French Polynesia', 'French Polynesia', 'PF', 'PYF', 'country', 1),
(77, 'country_French_Southern_Territories_77', 'French Southern Territories', 'French Southern Territories', 'TF', 'ATF', 'country', 1),
(78, 'country_Gabon_78', 'Gabon', 'Gabon', 'GA', 'GAB', 'country', 1),
(79, 'country_Gambia_79', 'Gambia', 'Gambia', 'GM', 'GMB', 'country', 1),
(80, 'country_Georgia_80', 'საქართველო', 'Georgia', 'GE', 'GEO', 'country', 1),
(81, 'country_Germany_81', 'Deutschland', 'Germany', 'DE', 'DEU', 'country', 1),
(82, 'country_Ghana_82', 'Ghana', 'Ghana', 'GH', 'GHA', 'country', 1),
(83, 'country_Gibraltar_83', 'Gibraltar', 'Gibraltar', 'GI', 'GIB', 'country', 1),
(84, 'country_Greece_84', 'Ελλάδα', 'Greece', 'GR', 'GRC', 'country', 1),
(85, 'country_Greenland_85', 'Greenland', 'Greenland', 'GL', 'GRL', 'country', 1),
(86, 'country_Grenada_86', 'Grenada', 'Grenada', 'GD', 'GRD', 'country', 1),
(87, 'country_Guadeloupe_87', 'Guadeloupe', 'Guadeloupe', 'GP', 'GLP', 'country', 1),
(88, 'country_Guam_88', 'Guam', 'Guam', 'GU', 'GUM', 'country', 1),
(89, 'country_Guatemala_89', 'Guatemala', 'Guatemala', 'GT', 'GTM', 'country', 1),
(90, 'country_Guinea_90', 'Guinée', 'Guinea', 'GN', 'GIN', 'country', 1),
(91, 'country_Guinea_Bissau_91', 'Guiné-Bissau', 'Guinea-Bissau', 'GW', 'GNB', 'country', 1),
(92, 'country_Guyana_92', 'Guyana', 'Guyana', 'GY', 'GUY', 'country', 1),
(93, 'country_Haiti_93', 'Haïti • Ayiti', 'Haiti', 'HT', 'HTI', 'country', 1),
(94, 'country_Heard_and_McDonald_Islands_94', 'Heard and McDonald Islands', 'Heard and McDonald Islands', 'HM', 'HMD', 'country', 1),
(95, 'country_Honduras_95', 'Honduras', 'Honduras', 'HN', 'HND', 'country', 1),
(96, 'country_Hong_Kong_96', '香港', 'Hong Kong', 'HK', 'HKG', 'country', 1),
(97, 'country_Hungary_97', 'Magyarország', 'Hungary', 'HU', 'HUN', 'country', 1),
(98, 'country_Iceland_98', 'Ísland', 'Iceland', 'IS', 'ISL', 'country', 1),
(99, 'country_India_99', 'भारत', 'India', 'IN', 'IND', 'country', 1),
(100, 'country_Indonesia_100', 'Indonesia', 'Indonesia', 'ID', 'IDN', 'country', 1),
(101, 'country_Iran_101', 'ايران', 'Iran', 'IR', 'IRN', 'country', 1),
(102, 'country_Iraq_102', 'عێراق • العراق', 'Iraq', 'IQ', 'IRQ', 'country', 1),
(103, 'country_Ireland_103', 'Éire', 'Ireland', 'IE', 'IRL', 'country', 1),
(104, 'country_Israel_104', 'إسرائيل • ישראל', 'Israel', 'IL', 'ISR', 'country', 1),
(105, 'country_Italy_105', 'Italia', 'Italy', 'IT', 'ITA', 'country', 1),
(106, 'country_Jamaica_106', 'Jamaica', 'Jamaica', 'JM', 'JAM', 'country', 1),
(107, 'country_Japan_107', '日本', 'Japan', 'JP', 'JPN', 'country', 1),
(108, 'country_Jordan_108', 'الأردنّ', 'Jordan', 'JO', 'JOR', 'country', 1),
(109, 'country_Kazakhstan_109', 'Қазақстан', 'Kazakhstan', 'KZ', 'KAZ', 'country', 1),
(110, 'country_Kenya_110', 'Kenya', 'Kenya', 'KE', 'KEN', 'country', 1),
(111, 'country_Kiribati_111', 'Kiribati', 'Kiribati', 'KI', 'KIR', 'country', 1),
(112, 'country_Korea__North_112', '북조선', 'Korea, North', 'KP', 'PRK', 'country', 1),
(113, 'country_Korea__South_113', '한국', 'Korea, South', 'KR', 'KOR', 'country', 1),
(114, 'country_Kuwait_114', 'الكويت', 'Kuwait', 'KW', 'KWT', 'country', 1),
(115, 'country_Kyrgyzstan_115', 'Кыргызстан', 'Kyrgyzstan', 'KG', 'KGZ', 'country', 1),
(116, 'country_Laos_116', 'ເມືອງລາວ', 'Laos', 'LA', 'LAO', 'country', 1),
(117, 'country_Latvia_117', 'Latvija', 'Latvia', 'LV', 'LVA', 'country', 1),
(118, 'country_Lebanon_118', 'لبنان', 'Lebanon', 'LB', 'LBN', 'country', 1),
(119, 'country_Lesotho_119', 'Lesotho', 'Lesotho', 'LS', 'LSO', 'country', 1),
(120, 'country_Liberia_120', 'Liberia', 'Liberia', 'LR', 'LBR', 'country', 1),
(121, 'country_Libyan_Arab_Jamahiriya_121', 'Libyan Arab Jamahiriya', 'Libyan Arab Jamahiriya', 'LY', 'LBY', 'country', 1),
(122, 'country_Liechtenstein_122', 'Liechtenstein', 'Liechtenstein', 'LI', 'LIE', 'country', 1),
(123, 'country_Lithuania_123', 'Lietuva', 'Lithuania', 'LT', 'LTU', 'country', 1),
(124, 'country_Luxembourg_124', 'Luxemburg • Lëtzebuerg', 'Luxembourg', 'LU', 'LUX', 'country', 1),
(125, 'country_Macau_125', '澳门 • 澳門', 'Macau', 'MO', 'MAC', 'country', 1),
(126, 'country_Macedonia_126', 'Македонија', 'Macedonia', 'MK', 'MKD', 'country', 1),
(127, 'country_Madagascar_127', 'Madagasikara', 'Madagascar', 'MG', 'MDG', 'country', 1),
(128, 'country_Malawi_128', 'Malaŵi', 'Malawi', 'MW', 'MWI', 'country', 1),
(129, 'country_Malaysia_129', 'Malaysia', 'Malaysia', 'MY', 'MYS', 'country', 1),
(130, 'country_Maldives_130', 'ދިވެހިރާއްޖެ', 'Maldives', 'MV', 'MDV', 'country', 1),
(131, 'country_Mali_131', 'Mali', 'Mali', 'ML', 'MLI', 'country', 1),
(132, 'country_Malta_132', 'Malta', 'Malta', 'MT', 'MLT', 'country', 1),
(133, 'country_Marshall_Islands_133', 'Aelōn̄ in M̧ajeļ', 'Marshall Islands', 'MH', 'MHL', 'country', 1),
(134, 'country_Martinique_134', 'Martinique', 'Martinique', 'MQ', 'MTQ', 'country', 1),
(135, 'country_Mauritania_135', 'موريتانيا • Mauritanie', 'Mauritania', 'MR', 'MRT', 'country', 1),
(136, 'country_Mauritius_136', 'Maurice', 'Mauritius', 'MU', 'MUS', 'country', 1),
(137, 'country_Mayotte_137', 'Mayotte', 'Mayotte', 'YT', 'MYT', 'country', 1),
(138, 'country_Mexico_138', 'México • Mēxihco', 'Mexico', 'MX', 'MEX', 'country', 1),
(139, 'country_Micronesia_139', 'Micronesia', 'Micronesia', 'FM', 'FSM', 'country', 1),
(140, 'country_Moldova_140', 'Moldova', 'Moldova', 'MD', 'MDA', 'country', 1),
(141, 'country_Monaco_141', 'Monaco', 'Monaco', 'MC', 'MCO', 'country', 1),
(142, 'country_Mongolia_142', 'Монгол улс', 'Mongolia', 'MN', 'MNG', 'country', 1),
(143, 'country_Montserrat_143', 'Montserrat', 'Montserrat', 'MS', 'MSR', 'country', 1),
(144, 'country_Morocco_144', 'المغرب', 'Morocco', 'MA', 'MAR', 'country', 1),
(145, 'country_Mozambique_145', 'Moçambique', 'Mozambique', 'MZ', 'MOZ', 'country', 1),
(146, 'country_Myanmar_146', 'Myanmar', 'Myanmar', 'MM', 'MMR', 'country', 1),
(147, 'country_Namibia_147', 'Namibia', 'Namibia', 'NA', 'NAM', 'country', 1),
(148, 'country_Nauru_148', 'Nauru', 'Nauru', 'NR', 'NRU', 'country', 1),
(149, 'country_Nepal_149', 'नेपाल', 'Nepal', 'NP', 'NPL', 'country', 1),
(150, 'country_Netherlands_150', 'Nederland', 'Netherlands', 'NL', 'NLD', 'country', 1),
(151, 'country_Netherlands_Antilles_151', 'Netherlands Antilles', 'Netherlands Antilles', 'AN', 'ANT', 'country', 1),
(152, 'country_New_Caledonia_152', 'Nouvelle-Calédonie', 'New Caledonia', 'NC', 'NCL', 'country', 1),
(153, 'country_New_Zealand_153', 'Aotearoa', 'New Zealand', 'NZ', 'NZL', 'country', 1),
(154, 'country_Nicaragua_154', 'Nicaragua', 'Nicaragua', 'NI', 'NIC', 'country', 1),
(155, 'country_Niger_155', 'Niger', 'Niger', 'NE', 'NER', 'country', 1),
(156, 'country_Nigeria_156', 'Nigeria', 'Nigeria', 'NG', 'NGA', 'country', 1),
(157, 'country_Niue_157', 'Niue', 'Niue', 'NU', 'NIU', 'country', 1),
(158, 'country_Norfolk_Island_158', 'Norfolk Island', 'Norfolk Island', 'NF', 'NFK', 'country', 1),
(159, 'country_Northern_Mariana_Islands_159', 'Northern Mariana Islands', 'Northern Mariana Islands', 'MP', 'MNP', 'country', 1),
(160, 'country_Norway_160', 'Norge / Noreg', 'Norway', 'NO', 'NOR', 'country', 1),
(161, 'country_Oman_161', 'عمان', 'Oman', 'OM', 'OMN', 'country', 1),
(162, 'country_Pakistan_162', 'پاکستان', 'Pakistan', 'PK', 'PAK', 'country', 1),
(163, 'country_Palau_163', 'Belau', 'Palau', 'PW', 'PLW', 'country', 1),
(164, 'country_Panama_164', 'Panamá', 'Panama', 'PA', 'PAN', 'country', 1),
(165, 'country_Papua_New_Guinea_165', 'Papua Niugini', 'Papua New Guinea', 'PG', 'PNG', 'country', 1),
(166, 'country_Paraguay_166', 'Paraguái', 'Paraguay', 'PY', 'PRY', 'country', 1),
(167, 'country_Peru_167', 'Perú', 'Peru', 'PE', 'PER', 'country', 1),
(168, 'country_Philippines_168', 'Pilipinas', 'Philippines', 'PH', 'PHL', 'country', 1),
(169, 'country_Pitcairn_169', 'Pitcairn', 'Pitcairn', 'PN', 'PCN', 'country', 1),
(170, 'country_Poland_170', 'Polska', 'Poland', 'PL', 'POL', 'country', 1),
(171, 'country_Portugal_171', 'Portugal', 'Portugal', 'PT', 'PRT', 'country', 1),
(172, 'country_Puerto_Rico_172', 'Puerto Rico', 'Puerto Rico', 'PR', 'PRI', 'country', 1),
(173, 'country_Qatar_173', 'دولة قطر', 'Qatar', 'QA', 'QAT', 'country', 1),
(174, 'country_Reunion_174', 'Reunion', 'Reunion', 'RE', 'REU', 'country', 1),
(175, 'country_Romania_175', 'România', 'Romania', 'RO', 'ROM', 'country', 1),
(176, 'country_Russia_176', 'Россия', 'Russia', 'RU', 'RUS', 'country', 1),
(177, 'country_Rwanda_177', 'Rwanda', 'Rwanda', 'RW', 'RWA', 'country', 1),
(178, 'country_Saint_Kitts_and_Nevis_178', 'Saint Kitts and Nevis', 'Saint Kitts and Nevis', 'KN', 'KNA', 'country', 1),
(179, 'country_Saint_Lucia_179', 'Saint Lucia', 'Saint Lucia', 'LC', 'LCA', 'country', 1),
(180, 'country_Saint_Vincent_and_the_Grenadines_180', 'Saint Vincent and the Grenadines', 'Saint Vincent and the Grenadines', 'VC', 'VCT', 'country', 1),
(181, 'country_Samoa_181', 'Sāmoa', 'Samoa', 'WS', 'WSM', 'country', 1),
(182, 'country_San_Marino_182', 'San Marino', 'San Marino', 'SM', 'SMR', 'country', 1),
(183, 'country_Sao_Tome_and_Principe_183', 'São Tomé e Príncipe', 'Sao Tome and Principe', 'ST', 'STP', 'country', 1),
(184, 'country_Saudi_Arabia_184', 'العربية السعودية', 'Saudi Arabia', 'SA', 'SAU', 'country', 1),
(185, 'country_Senegal_185', 'Sénégal', 'Senegal', 'SN', 'SEN', 'country', 1),
(186, 'country_Seychelles_186', 'Sesel', 'Seychelles', 'SC', 'SYC', 'country', 1),
(187, 'country_Sierra_Leone_187', 'Sierra Leone', 'Sierra Leone', 'SL', 'SLE', 'country', 1),
(188, 'country_Singapore_188', '新加坡 • Singapura • சிங்கப்பூர்', 'Singapore', 'SG', 'SGP', 'country', 1),
(189, 'country_Slovakia_189', 'Slovensko', 'Slovakia', 'SK', 'SVK', 'country', 1),
(190, 'country_Slovenia_190', 'Slovenija', 'Slovenia', 'SI', 'SVN', 'country', 1),
(191, 'country_Solomon_Islands_191', 'Solomon Islands', 'Solomon Islands', 'SB', 'SLB', 'country', 1),
(192, 'country_Somalia_192', 'Soomaaliya • الصومال', 'Somalia', 'SO', 'SOM', 'country', 1),
(193, 'country_South_Africa_193', 'Suid-Afrika', 'South Africa', 'ZA', 'ZAF', 'country', 1),
(194, 'country_South_Georgia_and_the_South_Sandwich_Islands_194', 'South Georgia and the South Sandwich Islands', 'South Georgia and the South Sandwich Islands', 'GS', 'SGS', 'country', 0),
(195, 'country_Spain_195', 'España', 'Spain', 'ES', 'ESP', 'country', 1),
(196, 'country_Sri_Lanka_196', 'ශ්‍රී ලංකාව • இலங்கை', 'Sri Lanka', 'LK', 'LKA', 'country', 1),
(197, 'country_St__Helena_197', 'St. Helena', 'St. Helena', 'SH', 'SHN', 'country', 1),
(198, 'country_St__Pierre_and_Miquelon_198', 'St. Pierre and Miquelon', 'St. Pierre and Miquelon', 'PM', 'SPM', 'country', 1),
(199, 'country_Sudan_199', 'السودان', 'Sudan', 'SD', 'SDN', 'country', 1),
(200, 'country_Suriname_200', 'Suriname', 'Suriname', 'SR', 'SUR', 'country', 1),
(201, 'country_Svalbard_and_Jan_Mayen_Islands_201', 'Svalbard and Jan Mayen Islands', 'Svalbard and Jan Mayen Islands', 'SJ', 'SJM', 'country', 1),
(202, 'country_Swaziland_202', 'eSwatini', 'Swaziland', 'SZ', 'SWZ', 'country', 1),
(203, 'country_Sweden_203', 'Sverige', 'Sweden', 'SE', 'SWE', 'country', 1),
(204, 'country_Switzerland_204', 'Schweiz • Suisse • Svizzera • Svizra', 'Switzerland', 'CH', 'CHE', 'country', 1),
(205, 'country_Syrian_Arab_Republic_205', 'سورية‎', 'Syrian Arab Republic', 'SY', 'SYR', 'country', 1),
(206, 'country_Taiwan_206', '臺灣 • 台灣', 'Taiwan', 'TW', 'TWN', 'country', 1),
(207, 'country_Tajikistan_207', 'Тоҷикистон', 'Tajikistan', 'TJ', 'TJK', 'country', 1),
(208, 'country_Tanzania_208', 'Tanzania', 'Tanzania', 'TZ', 'TZA', 'country', 1),
(209, 'country_Thailand_209', 'ประเทศไทย', 'Thailand', 'TH', 'THA', 'country', 1),
(210, 'country_Togo_210', 'Togo', 'Togo', 'TG', 'TGO', 'country', 1),
(211, 'country_Tokelau_211', 'Tokelau', 'Tokelau', 'TK', 'TKL', 'country', 1),
(212, 'country_Tonga_212', 'Tonga', 'Tonga', 'TO', 'TON', 'country', 1),
(213, 'country_Trinidad_and_Tobago_213', 'Trinidad and Tobago', 'Trinidad and Tobago', 'TT', 'TTO', 'country', 1),
(214, 'country_Tunisia_214', 'تونس‎', 'Tunisia', 'TN', 'TUN', 'country', 1),
(215, 'country_Turkey_215', 'Türkiye', 'Turkey', 'TR', 'TUR', 'country', 1),
(216, 'country_Turkmenistan_216', 'Türkmenistan', 'Turkmenistan', 'TM', 'TKM', 'country', 1),
(217, 'country_Turks_and_Caicos_Islands_217', 'Turks and Caicos Islands', 'Turks and Caicos Islands', 'TC', 'TCA', 'country', 1),
(218, 'country_Tuvalu_218', 'Tuvalu', 'Tuvalu', 'TV', 'TUV', 'country', 1),
(219, 'country_Uganda_219', 'Uganda', 'Uganda', 'UG', 'UGA', 'country', 1),
(220, 'country_Ukraine_220', 'Україна', 'Ukraine', 'UA', 'UKR', 'country', 1),
(221, 'country_United_Arab_Emirates_221', 'الإمارات العربية المتحدة', 'United Arab Emirates', 'AE', 'ARE', 'country', 1),
(222, 'country_United_Kingdom_222', 'United Kingdom', 'United Kingdom', 'GB', 'GBR', 'country', 1),
(223, 'country_United_States_of_America_223', 'United States of America', 'United States of America', 'US', 'USA', 'country', 1),
(224, 'country_United_States_Minor_Outlying_Islands_224', 'United States Minor Outlying Islands', 'United States Minor Outlying Islands', 'UM', 'UMI', 'country', 1),
(225, 'country_Uruguay_225', 'Uruguay', 'Uruguay', 'UY', 'URY', 'country', 1),
(226, 'country_Uzbekistan_226', 'Oʻzbekiston', 'Uzbekistan', 'UZ', 'UZB', 'country', 1),
(227, 'country_Vanuatu_227', 'Vanuatu', 'Vanuatu', 'VU', 'VUT', 'country', 1),
(228, 'country_Vatican_City_State__Holy_See__228', 'Vaticanum', 'Vatican City State', 'VA', 'VAT', 'country', 1),
(229, 'country_Venezuela_229', 'Venezuela', 'Venezuela', 'VE', 'VEN', 'country', 1),
(230, 'country_Vietnam_230', 'Việt Nam', 'Vietnam', 'VN', 'VNM', 'country', 1),
(231, 'country_Virgin_Islands__British__231', 'Virgin Islands (British)', 'Virgin Islands (British)', 'VG', 'VGB', 'country', 1),
(232, 'country_Virgin_Islands__U_S___232', 'Virgin Islands (U.S.)', 'Virgin Islands (U.S.)', 'VI', 'VIR', 'country', 1),
(233, 'country_Wallis_and_Futuna_Islands_233', 'Wallis and Futuna Islands', 'Wallis and Futuna Islands', 'WF', 'WLF', 'country', 1),
(234, 'country_Western_Sahara_234', 'الصحراء الغربية', 'Western Sahara', 'EH', 'ESH', 'country', 1),
(235, 'country_Yemen_235', 'اليمن', 'Yemen', 'YE', 'YEM', 'country', 1),
(236, 'country_Yugoslavia_236', 'Yugoslavia', 'Yugoslavia', 'YU', 'YUG', 'country', 0),
(237, 'country_Zaire_237', 'Zaire', 'Zaire', 'ZR', 'ZAR', 'country', 1),
(238, 'country_Zambia_238', 'Zambia', 'Zambia', 'ZM', 'ZMB', 'country', 1),
(239, 'country_Zimbabwe_239', 'Zimbabwe', 'Zimbabwe', 'ZW', 'ZWE', 'country', 1),
(240, 'state_______________240', 'بد خشان', 'بد خشان', '', 'BDS', 'state', 1),
(241, 'state______________241', 'بادغیس', 'بادغیس', '', 'BDG', 'state', 1),
(242, 'state____________242', 'بغلان', 'بغلان', '', 'BGL', 'state', 1),
(243, 'state________243', 'بلخ', 'بلخ', '', 'BAL', 'state', 1),
(244, 'state______________244', 'بامیان', 'بامیان', '', 'BAM', 'state', 1),
(245, 'state________________245', 'دایکندی', 'دایکندی', '', 'DAY', 'state', 1),
(246, 'state__________246', 'فراه', 'فراه', '', 'FRA', 'state', 1),
(247, 'state______________247', 'فارياب', 'فارياب', '', 'FYB', 'state', 1),
(248, 'state__________248', 'غزنى', 'غزنى', '', 'GHA', 'state', 1),
(249, 'state________249', 'غور', 'غور', '', 'GHO', 'state', 1),
(250, 'state____________250', 'هلمند', 'هلمند', '', 'HEL', 'state', 1),
(251, 'state__________251', 'هرات', 'هرات', '', 'HER', 'state', 1),
(252, 'state______________252', 'جوزجان', 'جوزجان', '', 'JOW', 'state', 1),
(253, 'state__________253', 'کابل', 'کابل', '', 'KAB', 'state', 1),
(254, 'state______________254', 'قندھار', 'قندھار', '', 'KAN', 'state', 1),
(255, 'state______________255', 'کاپيسا', 'کاپيسا', '', 'KAP', 'state', 1),
(256, 'state__________256', 'خوست', 'خوست', '', 'KHO', 'state', 1),
(257, 'state____________257', 'کُنَر', 'کُنَر', '', 'KNR', 'state', 1),
(258, 'state____________258', 'كندوز', 'كندوز', '', 'KDZ', 'state', 1),
(259, 'state____________259', 'لغمان', 'لغمان', '', 'LAG', 'state', 1),
(260, 'state__________260', 'لوګر', 'لوګر', '', 'LOW', 'state', 1),
(261, 'state________________261', 'ننگرهار', 'ننگرهار', '', 'NAN', 'state', 1),
(262, 'state______________262', 'نیمروز', 'نیمروز', '', 'NIM', 'state', 1),
(263, 'state________________263', 'نورستان', 'نورستان', '', 'NUR', 'state', 1),
(264, 'state________________264', 'ؤروزگان', 'ؤروزگان', '', 'ORU', 'state', 1),
(265, 'state____________265', 'پکتیا', 'پکتیا', '', 'PIA', 'state', 1),
(266, 'state______________266', 'پکتيکا', 'پکتيکا', '', 'PKA', 'state', 1),
(267, 'state_______________267', 'پنج شیر', 'پنج شیر', '', 'PAN', 'state', 1),
(268, 'state____________268', 'پروان', 'پروان', '', 'PAR', 'state', 1),
(269, 'state______________269', 'سمنگان', 'سمنگان', '', 'SAM', 'state', 1),
(270, 'state___________270', 'سر پل', 'سر پل', '', 'SAR', 'state', 1),
(271, 'state__________271', 'تخار', 'تخار', '', 'TAK', 'state', 1),
(272, 'state__________272', 'وردک', 'وردک', '', 'WAR', 'state', 1),
(273, 'state__________273', 'زابل', 'زابل', '', 'ZAB', 'state', 1),
(274, 'state_Beratit_274', 'Beratit', 'Beratit', '', 'BR', 'state', 1),
(275, 'state_Bulqiz__s_275', 'Bulqizës', 'Bulqizës', '', 'BU', 'state', 1),
(276, 'state_Dibr__s_276', 'Dibrës', 'Dibrës', '', 'DI', 'state', 1),
(277, 'state_Delvin__s_277', 'Delvinës', 'Delvinës', '', 'DL', 'state', 1),
(278, 'state_Durr__sit_278', 'Durrësit', 'Durrësit', '', 'DR', 'state', 1),
(279, 'state_Devollit_279', 'Devollit', 'Devollit', '', 'DV', 'state', 1),
(280, 'state_Elbasanit_280', 'Elbasanit', 'Elbasanit', '', 'EL', 'state', 1),
(281, 'state_Kolonj__s_281', 'Kolonjës', 'Kolonjës', '', 'ER', 'state', 1),
(282, 'state_Fierit_282', 'Fierit', 'Fierit', '', 'FR', 'state', 1),
(283, 'state_Gjirokastr__s_283', 'Gjirokastrës', 'Gjirokastrës', '', 'GJ', 'state', 1),
(284, 'state_Gramshit_284', 'Gramshit', 'Gramshit', '', 'GR', 'state', 1),
(285, 'state_Hasit_285', 'Hasit', 'Hasit', '', 'HA', 'state', 1),
(286, 'state_Kavaj__s_286', 'Kavajës', 'Kavajës', '', 'KA', 'state', 1),
(287, 'state_Kurbinit_287', 'Kurbinit', 'Kurbinit', '', 'KB', 'state', 1),
(288, 'state_Ku__ov__s_288', 'Kuçovës', 'Kuçovës', '', 'KC', 'state', 1),
(289, 'state_Kor____s_289', 'Korçës', 'Korçës', '', 'KO', 'state', 1),
(290, 'state_Kruj__s_290', 'Krujës', 'Krujës', '', 'KR', 'state', 1),
(291, 'state_Kuk__sit_291', 'Kukësit', 'Kukësit', '', 'KU', 'state', 1),
(292, 'state_Librazhdit_292', 'Librazhdit', 'Librazhdit', '', 'LB', 'state', 1),
(293, 'state_Lezh__s_293', 'Lezhës', 'Lezhës', '', 'LE', 'state', 1),
(294, 'state_Lushnj__s_294', 'Lushnjës', 'Lushnjës', '', 'LU', 'state', 1),
(295, 'state_Mallakastr__s_295', 'Mallakastrës', 'Mallakastrës', '', 'MK', 'state', 1),
(296, 'state_Mal__sis___s___Madhe_296', 'Malësisë së Madhe', 'Malësisë së Madhe', '', 'MM', 'state', 1),
(297, 'state_Mirdit__s_297', 'Mirditës', 'Mirditës', '', 'MR', 'state', 1),
(298, 'state_Matit_298', 'Matit', 'Matit', '', 'MT', 'state', 1),
(299, 'state_Pogradecit_299', 'Pogradecit', 'Pogradecit', '', 'PG', 'state', 1),
(300, 'state_Peqinit_300', 'Peqinit', 'Peqinit', '', 'PQ', 'state', 1),
(301, 'state_P__rmetit_301', 'Përmetit', 'Përmetit', '', 'PR', 'state', 1),
(302, 'state_Puk__s_302', 'Pukës', 'Pukës', '', 'PU', 'state', 1),
(303, 'state_Shkodr__s_303', 'Shkodrës', 'Shkodrës', '', 'SH', 'state', 1),
(304, 'state_Skraparit_304', 'Skraparit', 'Skraparit', '', 'SK', 'state', 1),
(305, 'state_Sarand__s_305', 'Sarandës', 'Sarandës', '', 'SR', 'state', 1),
(306, 'state_Tepelen__s_306', 'Tepelenës', 'Tepelenës', '', 'TE', 'state', 1),
(307, 'state_Tropoj__s_307', 'Tropojës', 'Tropojës', '', 'TP', 'state', 1),
(308, 'state_Tiran__s_308', 'Tiranës', 'Tiranës', '', 'TR', 'state', 1),
(309, 'state_Vlor__s_309', 'Vlorës', 'Vlorës', '', 'VL', 'state', 1),
(310, 'state_______________________310', 'ولاية أدرار', 'ولاية أدرار', '', '01', 'state', 1),
(311, 'state_______________________311', 'ولاية الشلف', 'ولاية الشلف', '', '02', 'state', 1),
(312, 'state___________________________312', 'ولاية الأغواط', 'ولاية الأغواط', '', '03', 'state', 1),
(313, 'state________________________________313', 'ولاية أم البواقي', 'ولاية أم البواقي', '', '04', 'state', 1),
(314, 'state_______________________314', 'ولاية باتنة', 'ولاية باتنة', '', '05', 'state', 1),
(315, 'state_______________________315', 'ولاية بجاية', 'ولاية بجاية', '', '06', 'state', 1),
(316, 'state_______________________316', 'ولاية بسكرة', 'ولاية بسكرة', '', '07', 'state', 1),
(317, 'state_____________________317', 'ولاية بشار', 'ولاية بشار', '', '08', 'state', 1),
(318, 'state___________________318', 'البليدة‎', 'البليدة‎', '', '09', 'state', 1),
(319, 'state___________________________319', 'ولاية البويرة', 'ولاية البويرة', '', '10', 'state', 1),
(320, 'state___________________________320', 'ولاية تمنراست', 'ولاية تمنراست', '', '11', 'state', 1),
(321, 'state_____________________321', 'ولاية تبسة', 'ولاية تبسة', '', '12', 'state', 1),
(322, 'state______________322', 'تلمسان', 'تلمسان', '', '13', 'state', 1),
(323, 'state_______________________323', 'ولاية تيارت', 'ولاية تيارت', '', '14', 'state', 1),
(324, 'state_________________324', 'تيزي وزو', 'تيزي وزو', '', '15', 'state', 1),
(325, 'state___________________________325', 'ولاية الجزائر', 'ولاية الجزائر', '', '16', 'state', 1),
(326, 'state________________________________326', 'ولاية عين الدفلى', 'ولاية عين الدفلى', '', '17', 'state', 1),
(327, 'state_____________________327', 'ولاية جيجل', 'ولاية جيجل', '', '18', 'state', 1),
(328, 'state_____________________328', 'ولاية سطيف', 'ولاية سطيف', '', '19', 'state', 1),
(329, 'state_______________________329', 'ولاية سعيدة', 'ولاية سعيدة', '', '20', 'state', 1),
(330, 'state__________________330', 'السكيكدة', 'السكيكدة', '', '21', 'state', 1),
(331, 'state__________________________________331', 'ولاية سيدي بلعباس', 'ولاية سيدي بلعباس', '', '22', 'state', 1),
(332, 'state_______________________332', 'ولاية عنابة', 'ولاية عنابة', '', '23', 'state', 1),
(333, 'state_______________________333', 'ولاية قالمة', 'ولاية قالمة', '', '24', 'state', 1),
(334, 'state________________334', 'قسنطينة', 'قسنطينة', '', '25', 'state', 1),
(335, 'state_________________________335', 'ولاية المدية', 'ولاية المدية', '', '26', 'state', 1),
(336, 'state___________________________336', 'ولاية مستغانم', 'ولاية مستغانم', '', '27', 'state', 1),
(337, 'state___________________________337', 'ولاية المسيلة', 'ولاية المسيلة', '', '28', 'state', 1),
(338, 'state_______________________338', 'ولاية معسكر', 'ولاية معسكر', '', '29', 'state', 1),
(339, 'state____________339', 'ورقلة', 'ورقلة', '', '30', 'state', 1),
(340, 'state____________340', 'وهران', 'وهران', '', '31', 'state', 1),
(341, 'state_______________________341', 'ولاية البيض', 'ولاية البيض', '', '32', 'state', 1),
(342, 'state_______________________342', 'ولاية اليزي', 'ولاية اليزي', '', '33', 'state', 1),
(343, 'state____________________________________343', 'ولاية برج بوعريريج', 'ولاية برج بوعريريج', '', '34', 'state', 1),
(344, 'state___________________________344', 'ولاية بومرداس', 'ولاية بومرداس', '', '35', 'state', 1),
(345, 'state_________________________345', 'ولاية الطارف', 'ولاية الطارف', '', '36', 'state', 1),
(346, 'state____________346', 'تندوف', 'تندوف', '', '37', 'state', 1),
(347, 'state___________________________347', 'ولاية تسمسيلت', 'ولاية تسمسيلت', '', '38', 'state', 1),
(348, 'state_________________________348', 'ولاية الوادي', 'ولاية الوادي', '', '39', 'state', 1),
(349, 'state_______________________349', 'ولاية خنشلة', 'ولاية خنشلة', '', '40', 'state', 1),
(350, 'state______________________________350', 'ولاية سوق أهراس', 'ولاية سوق أهراس', '', '41', 'state', 1),
(351, 'state_________________________351', 'ولاية تيبازة', 'ولاية تيبازة', '', '42', 'state', 1),
(352, 'state_____________________352', 'ولاية ميلة', 'ولاية ميلة', '', '43', 'state', 1),
(353, 'state________________________________353', 'ولاية عين الدفلى', 'ولاية عين الدفلى', '', '44', 'state', 1),
(354, 'state___________________________354', 'ولاية النعامة', 'ولاية النعامة', '', '45', 'state', 1),
(355, 'state________________________________355', 'ولاية عين تموشنت', 'ولاية عين تموشنت', '', '46', 'state', 1),
(356, 'state_________________________356', 'ولاية غرداية', 'ولاية غرداية', '', '47', 'state', 1),
(357, 'state_________________________357', 'ولاية غليزان', 'ولاية غليزان', '', '48', 'state', 1),
(358, 'state_Eastern_358', 'Eastern', 'Eastern', '', 'EA', 'state', 1),
(359, 'state_Manu_a_359', 'Manu''a', 'Manu''a', '', 'MA', 'state', 1),
(360, 'state_Rose_Island_360', 'Rose Island', 'Rose Island', '', 'RI', 'state', 1),
(361, 'state_Swains_Island_361', 'Swains Island', 'Swains Island', '', 'SI', 'state', 1),
(362, 'state_Western_362', 'Western', 'Western', '', 'WE', 'state', 1),
(363, 'state_Andorra_la_Vella_363', 'Andorra la Vella', 'Andorra la Vella', '', 'AN', 'state', 1),
(364, 'state_Canillo_364', 'Canillo', 'Canillo', '', 'CA', 'state', 1),
(365, 'state_Encamp_365', 'Encamp', 'Encamp', '', 'EN', 'state', 1),
(366, 'state_Escaldes_Engordany_366', 'Escaldes-Engordany', 'Escaldes-Engordany', '', 'LE', 'state', 1),
(367, 'state_La_Massana_367', 'La Massana', 'La Massana', '', 'LM', 'state', 1),
(368, 'state_Ordino_368', 'Ordino', 'Ordino', '', 'OR', 'state', 1),
(369, 'state_Sant_Juli___de_L__ria_369', 'Sant Juliá de Lória', 'Sant Juliá de Lória', '', 'SJ', 'state', 1),
(370, 'state_Bengo_370', 'Bengo', 'Bengo', '', 'BGO', 'state', 1),
(371, 'state_Benguela_371', 'Benguela', 'Benguela', '', 'BGU', 'state', 1),
(372, 'state_Bi___372', 'Bié', 'Bié', '', 'BIE', 'state', 1),
(373, 'state_Cabinda_373', 'Cabinda', 'Cabinda', '', 'CAB', 'state', 1),
(374, 'state_Cuando_Cubango_374', 'Cuando Cubango', 'Cuando Cubango', '', 'CCU', 'state', 1),
(375, 'state_Cuanza_Norte_375', 'Cuanza Norte', 'Cuanza Norte', '', 'CNO', 'state', 1),
(376, 'state_Cuanza_Sul_376', 'Cuanza Sul', 'Cuanza Sul', '', 'CUS', 'state', 1),
(377, 'state_Cunene_377', 'Cunene', 'Cunene', '', 'CNN', 'state', 1),
(378, 'state_Huambo_378', 'Huambo', 'Huambo', '', 'HUA', 'state', 1),
(379, 'state_Hu__la_379', 'Huíla', 'Huíla', '', 'HUI', 'state', 1),
(380, 'state_Luanda_380', 'Luanda', 'Luanda', '', 'LUA', 'state', 1),
(381, 'state_Lunda_Norte_381', 'Lunda Norte', 'Lunda Norte', '', 'LNO', 'state', 1),
(382, 'state_Lunda_Sul_382', 'Lunda Sul', 'Lunda Sul', '', 'LSU', 'state', 1),
(383, 'state_Malanje_383', 'Malanje', 'Malanje', '', 'MAL', 'state', 1),
(384, 'state_Moxico_384', 'Moxico', 'Moxico', '', 'MOX', 'state', 1),
(385, 'state_Namibe_385', 'Namibe', 'Namibe', '', 'NAM', 'state', 1),
(386, 'state_U__ge_386', 'Uíge', 'Uíge', '', 'UIG', 'state', 1),
(387, 'state_Zaire_387', 'Zaire', 'Zaire', '', 'ZAI', 'state', 1),
(388, 'state_Barbuda_388', 'Barbuda', 'Barbuda', '', 'BAR', 'state', 1),
(389, 'state_Saint_George_389', 'Saint George', 'Saint George', '', 'SGE', 'state', 1),
(390, 'state_Saint_John_390', 'Saint John', 'Saint John', '', 'SJO', 'state', 1),
(391, 'state_Saint_Mary_391', 'Saint Mary', 'Saint Mary', '', 'SMA', 'state', 1),
(392, 'state_Saint_Paul_392', 'Saint Paul', 'Saint Paul', '', 'SPA', 'state', 1),
(393, 'state_Saint_Peter_393', 'Saint Peter', 'Saint Peter', '', 'SPE', 'state', 1),
(394, 'state_Saint_Philip_394', 'Saint Philip', 'Saint Philip', '', 'SPH', 'state', 1),
(395, 'state_Salta_395', 'Salta', 'Salta', '', 'A', 'state', 1),
(396, 'state_Buenos_Aires_Province_396', 'Buenos Aires Province', 'Buenos Aires Province', '', 'B', 'state', 1),
(397, 'state_Capital_Federal_397', 'Capital Federal', 'Capital Federal', '', 'C', 'state', 1),
(398, 'state_San_Luis_398', 'San Luis', 'San Luis', '', 'D', 'state', 1),
(399, 'state_Entre_R__os_399', 'Entre Ríos', 'Entre Ríos', '', 'E', 'state', 1),
(400, 'state_La_Rioja_400', 'La Rioja', 'La Rioja', '', 'F', 'state', 1),
(401, 'state_Santiago_del_Estero_401', 'Santiago del Estero', 'Santiago del Estero', '', 'G', 'state', 1),
(402, 'state_Chaco_402', 'Chaco', 'Chaco', '', 'H', 'state', 1),
(403, 'state_San_Juan_403', 'San Juan', 'San Juan', '', 'J', 'state', 1),
(404, 'state_Catamarca_404', 'Catamarca', 'Catamarca', '', 'K', 'state', 1),
(405, 'state_La_Pampa_405', 'La Pampa', 'La Pampa', '', 'L', 'state', 1),
(406, 'state_Mendoza_406', 'Mendoza', 'Mendoza', '', 'M', 'state', 1),
(407, 'state_Misiones_407', 'Misiones', 'Misiones', '', 'N', 'state', 1),
(408, 'state_Formosa_408', 'Formosa', 'Formosa', '', 'P', 'state', 1),
(409, 'state_Neuqu__n_409', 'Neuquén', 'Neuquén', '', 'Q', 'state', 1),
(410, 'state_R__o_Negro_410', 'Río Negro', 'Río Negro', '', 'R', 'state', 1),
(411, 'state_Santa_Fe_411', 'Santa Fe', 'Santa Fe', '', 'S', 'state', 1),
(412, 'state_Tucum__n_412', 'Tucumán', 'Tucumán', '', 'T', 'state', 1),
(413, 'state_Chubut_413', 'Chubut', 'Chubut', '', 'U', 'state', 1),
(414, 'state_Tierra_del_Fuego_414', 'Tierra del Fuego', 'Tierra del Fuego', '', 'V', 'state', 1),
(415, 'state_Corrientes_415', 'Corrientes', 'Corrientes', '', 'W', 'state', 1),
(416, 'state_C__rdoba_416', 'Córdoba', 'Córdoba', '', 'X', 'state', 1),
(417, 'state_Jujuy_417', 'Jujuy', 'Jujuy', '', 'Y', 'state', 1),
(418, 'state_Santa_Cruz_418', 'Santa Cruz', 'Santa Cruz', '', 'Z', 'state', 1),
(419, 'state____________________419', 'Արագածոտն', 'Արագածոտն', '', 'AG', 'state', 1),
(420, 'state______________420', 'Արարատ', 'Արարատ', '', 'AR', 'state', 1),
(421, 'state________________421', 'Արմավիր', 'Արմավիր', '', 'AV', 'state', 1),
(422, 'state____________422', 'Երևան', 'Երևան', '', 'ER', 'state', 1),
(423, 'state________________________423', 'Գեղարքունիք', 'Գեղարքունիք', '', 'GR', 'state', 1),
(424, 'state______________424', 'Կոտայք', 'Կոտայք', '', 'KT', 'state', 1),
(425, 'state__________425', 'Ô¼Õ¸Õ¼Õ«', 'Ô¼Õ¸Õ¼Õ«', '', 'LO', 'state', 1),
(426, 'state____________426', 'Շիրակ', 'Շիրակ', '', 'SH', 'state', 1),
(427, 'state________________427', 'Սյունիք', 'Սյունիք', '', 'SU', 'state', 1),
(428, 'state______________428', 'Տավուշ', 'Տավուշ', '', 'TV', 'state', 1),
(429, 'state___________________429', 'Վայոց Ձոր', 'Վայոց Ձոր', '', 'VD', 'state', 1),
(430, 'state_Australian_Capital_Territory_430', 'Australian Capital Territory', 'Australian Capital Territory', '', 'ACT', 'state', 1),
(431, 'state_New_South_Wales_431', 'New South Wales', 'New South Wales', '', 'NSW', 'state', 1),
(432, 'state_Northern_Territory_432', 'Northern Territory', 'Northern Territory', '', 'NT', 'state', 1),
(433, 'state_Queensland_433', 'Queensland', 'Queensland', '', 'QLD', 'state', 1),
(434, 'state_South_Australia_434', 'South Australia', 'South Australia', '', 'SA', 'state', 1),
(435, 'state_Tasmania_435', 'Tasmania', 'Tasmania', '', 'TAS', 'state', 1),
(436, 'state_Victoria_436', 'Victoria', 'Victoria', '', 'VIC', 'state', 1),
(437, 'state_Western_Australia_437', 'Western Australia', 'Western Australia', '', 'WA', 'state', 1),
(438, 'state_Burgenland_438', 'Burgenland', 'Burgenland', '', '1', 'state', 1),
(439, 'state_K__rnten_439', 'Kärnten', 'Kärnten', '', '2', 'state', 1),
(440, 'state_Nieder__sterreich_440', 'Niederösterreich', 'Niederösterreich', '', '3', 'state', 1),
(441, 'state_Ober__sterreich_441', 'Oberösterreich', 'Oberösterreich', '', '4', 'state', 1),
(442, 'state_Salzburg_442', 'Salzburg', 'Salzburg', '', '5', 'state', 1),
(443, 'state_Steiermark_443', 'Steiermark', 'Steiermark', '', '6', 'state', 1),
(444, 'state_Tirol_444', 'Tirol', 'Tirol', '', '7', 'state', 1),
(445, 'state_Voralberg_445', 'Voralberg', 'Voralberg', '', '8', 'state', 1),
(446, 'state_Wien_446', 'Wien', 'Wien', '', '9', 'state', 1),
(447, 'state___li_Bayraml___447', 'Əli Bayramlı', 'Əli Bayramlı', '', 'AB', 'state', 1),
(448, 'state_Ab__eron_448', 'Abşeron', 'Abşeron', '', 'ABS', 'state', 1),
(449, 'state_A__cab__di_449', 'Ağcabədi', 'Ağcabədi', '', 'AGC', 'state', 1),
(450, 'state_A__dam_450', 'Ağdam', 'Ağdam', '', 'AGM', 'state', 1),
(451, 'state_A__da___451', 'Ağdaş', 'Ağdaş', '', 'AGS', 'state', 1),
(452, 'state_A__stafa_452', 'Ağstafa', 'Ağstafa', '', 'AGA', 'state', 1),
(453, 'state_A__su_453', 'Ağsu', 'Ağsu', '', 'AGU', 'state', 1),
(454, 'state_Astara_454', 'Astara', 'Astara', '', 'AST', 'state', 1),
(455, 'state_Bak___455', 'Bakı', 'Bakı', '', 'BA', 'state', 1),
(456, 'state_Bab__k_456', 'Babək', 'Babək', '', 'BAB', 'state', 1),
(457, 'state_Balak__n_457', 'Balakən', 'Balakən', '', 'BAL', 'state', 1),
(458, 'state_B__rd___458', 'Bərdə', 'Bərdə', '', 'BAR', 'state', 1),
(459, 'state_Beyl__qan_459', 'Beyləqan', 'Beyləqan', '', 'BEY', 'state', 1),
(460, 'state_Bil__suvar_460', 'Biləsuvar', 'Biləsuvar', '', 'BIL', 'state', 1),
(461, 'state_C__bray__l_461', 'Cəbrayıl', 'Cəbrayıl', '', 'CAB', 'state', 1),
(462, 'state_C__lilabab_462', 'Cəlilabab', 'Cəlilabab', '', 'CAL', 'state', 1),
(463, 'state_Julfa_463', 'Julfa', 'Julfa', '', 'CUL', 'state', 1),
(464, 'state_Da__k__s__n_464', 'Daşkəsən', 'Daşkəsən', '', 'DAS', 'state', 1),
(465, 'state_D__v____i_465', 'Dəvəçi', 'Dəvəçi', '', 'DAV', 'state', 1),
(466, 'state_F__zuli_466', 'Füzuli', 'Füzuli', '', 'FUZ', 'state', 1),
(467, 'state_G__nc___467', 'Gəncə', 'Gəncə', '', 'GA', 'state', 1),
(468, 'state_G__d__b__y_468', 'Gədəbəy', 'Gədəbəy', '', 'GAD', 'state', 1),
(469, 'state_Goranboy_469', 'Goranboy', 'Goranboy', '', 'GOR', 'state', 1),
(470, 'state_G__y__ay_470', 'Göyçay', 'Göyçay', '', 'GOY', 'state', 1),
(471, 'state_Hac__qabul_471', 'Hacıqabul', 'Hacıqabul', '', 'HAC', 'state', 1),
(472, 'state___mi__li_472', 'İmişli', 'İmişli', '', 'IMI', 'state', 1),
(473, 'state___smay__ll___473', 'İsmayıllı', 'İsmayıllı', '', 'ISM', 'state', 1),
(474, 'state_K__lb__c__r_474', 'Kəlbəcər', 'Kəlbəcər', '', 'KAL', 'state', 1),
(475, 'state_K__rd__mir_475', 'Kürdəmir', 'Kürdəmir', '', 'KUR', 'state', 1),
(476, 'state_L__nk__ran_476', 'Lənkəran', 'Lənkəran', '', 'LA', 'state', 1),
(477, 'state_La____n_477', 'Laçın', 'Laçın', '', 'LAC', 'state', 1),
(478, 'state_L__nk__ran_478', 'Lənkəran', 'Lənkəran', '', 'LAN', 'state', 1),
(479, 'state_Lerik_479', 'Lerik', 'Lerik', '', 'LER', 'state', 1),
(480, 'state_Masall___480', 'Masallı', 'Masallı', '', 'MAS', 'state', 1),
(481, 'state_Ming____evir_481', 'Mingəçevir', 'Mingəçevir', '', 'MI', 'state', 1),
(482, 'state_Naftalan_482', 'Naftalan', 'Naftalan', '', 'NA', 'state', 1),
(483, 'state_Neft__ala_483', 'Neftçala', 'Neftçala', '', 'NEF', 'state', 1),
(484, 'state_O__uz_484', 'Oğuz', 'Oğuz', '', 'OGU', 'state', 1),
(485, 'state_Ordubad_485', 'Ordubad', 'Ordubad', '', 'ORD', 'state', 1),
(486, 'state_Q__b__l___486', 'Qəbələ', 'Qəbələ', '', 'QAB', 'state', 1),
(487, 'state_Qax_487', 'Qax', 'Qax', '', 'QAX', 'state', 1),
(488, 'state_Qazax_488', 'Qazax', 'Qazax', '', 'QAZ', 'state', 1),
(489, 'state_Qobustan_489', 'Qobustan', 'Qobustan', '', 'QOB', 'state', 1),
(490, 'state_Quba_490', 'Quba', 'Quba', '', 'QBA', 'state', 1),
(491, 'state_Qubadl___491', 'Qubadlı', 'Qubadlı', '', 'QBI', 'state', 1),
(492, 'state_Qusar_492', 'Qusar', 'Qusar', '', 'QUS', 'state', 1),
(493, 'state_____ki_493', 'Şəki', 'Şəki', '', 'SA', 'state', 1),
(494, 'state_Saatl___494', 'Saatlı', 'Saatlı', '', 'SAT', 'state', 1),
(495, 'state_Sabirabad_495', 'Sabirabad', 'Sabirabad', '', 'SAB', 'state', 1),
(496, 'state_S__d__r__k_496', 'Sədərək', 'Sədərək', '', 'SAD', 'state', 1),
(497, 'state___ahbuz_497', 'Şahbuz', 'Şahbuz', '', 'SAH', 'state', 1),
(498, 'state_____ki_498', 'Şəki', 'Şəki', '', 'SAK', 'state', 1),
(499, 'state_Salyan_499', 'Salyan', 'Salyan', '', 'SAL', 'state', 1);";
		$this->db->setQuery($query);
		$this->db->query();
		$query="
INSERT IGNORE INTO `#__hikashop_zone` (`zone_id`, `zone_namekey`, `zone_name`, `zone_name_english`, `zone_code_2`, `zone_code_3`, `zone_type`, `zone_published`) VALUES
(500, 'state_Sumq