-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `halalhos_halal`
--

-- --------------------------------------------------------

--
-- Table structure for table `bookings`
--

CREATE TABLE `bookings` (
  `id` int(11) NOT NULL,
  `id_item` int(20) NOT NULL DEFAULT '0',
  `the_date` date NOT NULL DEFAULT '0000-00-00',
  `id_state` int(11) NOT NULL DEFAULT '0',
  `id_booking` int(10) NOT NULL DEFAULT '0',
  `PropId` varchar(255) NOT NULL,
  `price` float(10,2) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bookings`
--

INSERT INTO `bookings` (`id`, `id_item`, `the_date`, `id_state`, `id_booking`, `PropId`, `price`) VALUES
(895, 1, '2018-09-06', 1, 0, '187', 0.00),
(894, 1, '2018-09-05', 1, 0, '187', 0.00),
(893, 1, '2018-09-04', 1, 0, '187', 0.00),
(892, 1, '2018-09-03', 1, 0, '187', 0.00),
(891, 1, '2018-09-02', 1, 0, '187', 0.00),
(890, 1, '2018-09-01', 1, 0, '187', 0.00),
(889, 1, '2018-09-03', 1, 0, '80', 0.00),
(888, 1, '2018-09-02', 1, 0, '80', 0.00),
(887, 1, '2018-09-01', 1, 0, '80', 0.00),
(886, 1, '2018-08-31', 1, 0, '80', 0.00),
(885, 1, '2018-08-30', 1, 0, '80', 0.00),
(884, 1, '2018-08-29', 1, 0, '80', 0.00),
(883, 1, '2018-08-28', 1, 0, '80', 0.00),
(882, 1, '2018-08-27', 1, 0, '80', 0.00),
(881, 1, '2018-08-25', 1, 0, '80', 0.00),
(880, 1, '2018-08-24', 1, 0, '80', 0.00),
(879, 1, '2018-08-23', 1, 0, '80', 0.00),
(878, 1, '2018-08-22', 1, 0, '80', 0.00),
(877, 1, '2018-08-20', 1, 0, '80', 0.00),
(876, 1, '2018-08-19', 1, 0, '80', 0.00),
(875, 1, '2018-08-18', 1, 0, '80', 0.00),
(874, 1, '2018-08-17', 1, 0, '80', 0.00),
(865, 1, '2018-08-05', 1, 0, '80', 0.00),
(864, 1, '2018-08-04', 1, 0, '80', 0.00),
(863, 1, '2018-08-03', 1, 0, '80', 0.00),
(862, 1, '2018-08-02', 1, 0, '80', 0.00),
(869, 1, '2018-08-16', 1, 0, '80', 0.00),
(868, 1, '2018-08-15', 1, 0, '80', 0.00),
(867, 1, '2018-08-14', 1, 0, '80', 0.00),
(866, 1, '2018-08-13', 1, 0, '80', 0.00),
(857, 1, '2018-07-23', 1, 0, '80', 0.00),
(856, 1, '2018-07-22', 1, 0, '80', 0.00),
(855, 1, '2018-07-21', 1, 0, '80', 0.00),
(854, 1, '2018-07-20', 1, 0, '80', 0.00),
(902, 1, '2018-10-10', 1, 0, '197', 0.00),
(901, 1, '2018-10-11', 1, 0, '197', 0.00),
(903, 1, '2018-10-23', 1, 0, '200', 0.00),
(904, 1, '2018-10-24', 1, 0, '200', 0.00),
(905, 1, '2018-10-25', 1, 0, '200', 0.00),
(906, 1, '2018-10-26', 1, 0, '200', 0.00);

-- --------------------------------------------------------

--
-- Table structure for table `bookings_config`
--

CREATE TABLE `bookings_config` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL DEFAULT '',
  `num_months` tinyint(3) NOT NULL DEFAULT '3',
  `default_lang` varchar(6) NOT NULL DEFAULT 'en',
  `theme` varchar(50) NOT NULL DEFAULT 'default',
  `start_day` enum('mon','sun') NOT NULL DEFAULT 'sun',
  `date_format` enum('us','eu') NOT NULL DEFAULT 'eu',
  `click_past_dates` enum('on','off') NOT NULL DEFAULT 'off',
  `cal_url` varchar(255) NOT NULL DEFAULT '',
  `local_path` varchar(255) NOT NULL DEFAULT '/calendar',
  `version` varchar(10) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bookings_config`
--

INSERT INTO `bookings_config` (`id`, `title`, `num_months`, `default_lang`, `theme`, `start_day`, `date_format`, `click_past_dates`, `cal_url`, `local_path`, `version`) VALUES
(1, 'Availability Calendar', 6, 'en', 'default', 'sun', 'eu', 'off', '', '/calendar', 'v3.03.07');

-- --------------------------------------------------------

--
-- Table structure for table `bookings_items`
--

CREATE TABLE `bookings_items` (
  `id` int(11) NOT NULL,
  `id_user` int(11) NOT NULL DEFAULT '1',
  `id_ref_external` int(11) NOT NULL COMMENT 'link to external db table',
  `desc_en` varchar(100) NOT NULL DEFAULT '',
  `desc_es` varchar(100) NOT NULL DEFAULT '',
  `list_order` int(11) NOT NULL DEFAULT '0',
  `state` tinyint(1) NOT NULL DEFAULT '1'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bookings_items`
--

INSERT INTO `bookings_items` (`id`, `id_user`, `id_ref_external`, `desc_en`, `desc_es`, `list_order`, `state`) VALUES
(1, 1, 0, 'Demo Item', 'Demo', 1, 1);

-- --------------------------------------------------------

--
-- Table structure for table `bookings_last_update`
--

CREATE TABLE `bookings_last_update` (
  `id` int(10) NOT NULL,
  `id_item` int(10) NOT NULL DEFAULT '0',
  `date_mod` datetime NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bookings_last_update`
--

INSERT INTO `bookings_last_update` (`id`, `id_item`, `date_mod`) VALUES
(1, 1, '2014-01-21 10:38:03');

-- --------------------------------------------------------

--
-- Table structure for table `bookings_states`
--

CREATE TABLE `bookings_states` (
  `id` int(11) NOT NULL,
  `desc_en` varchar(100) NOT NULL DEFAULT '',
  `desc_es` varchar(100) NOT NULL DEFAULT '',
  `code` varchar(10) NOT NULL DEFAULT '',
  `state` tinyint(1) NOT NULL DEFAULT '1',
  `list_order` int(11) NOT NULL DEFAULT '0',
  `class` varchar(30) NOT NULL DEFAULT '',
  `show_in_key` tinyint(1) NOT NULL DEFAULT '1'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bookings_states`
--

INSERT INTO `bookings_states` (`id`, `desc_en`, `desc_es`, `code`, `state`, `list_order`, `class`, `show_in_key`) VALUES
(1, 'Booked', 'Reservado', 'b', 1, 0, 'booked', 1),
(4, 'Unavailable', 'Unavailable', 'pr', 1, 3, 'booked_pr', 1);

-- --------------------------------------------------------

--
-- Table structure for table `cancel_payment_paid`
--

CREATE TABLE `cancel_payment_paid` (
  `id` int(11) NOT NULL,
  `customer_email` varchar(250) NOT NULL,
  `amount` varchar(250) NOT NULL,
  `transaction_id` int(11) NOT NULL,
  `pay_status` varchar(255) NOT NULL DEFAULT 'pending',
  `status` int(11) NOT NULL DEFAULT '1' COMMENT '1->product,2->exp',
  `date_added` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `city_locations`
--

CREATE TABLE `city_locations` (
  `id` int(11) NOT NULL,
  `countryid` int(11) NOT NULL,
  `stateid` int(11) NOT NULL,
  `state_code` varchar(32) NOT NULL,
  `name` varchar(32) NOT NULL,
  `city` varchar(32) NOT NULL,
  `contid` varchar(50) NOT NULL,
  `seourl` varchar(250) NOT NULL,
  `status` enum('InActive','Active') NOT NULL,
  `featured` enum('0','1') NOT NULL,
  `description` longblob NOT NULL,
  `meta_title` varchar(1000) NOT NULL,
  `meta_keyword` varchar(1000) NOT NULL,
  `meta_description` blob NOT NULL,
  `citylogo` varchar(1000) NOT NULL,
  `citythumb` varchar(1000) NOT NULL,
  `mobile_citylogo` varchar(500) NOT NULL,
  `neighborhoods` varchar(1000) NOT NULL,
  `tags` varchar(1000) NOT NULL,
  `short_description` varchar(1000) NOT NULL,
  `latitude` varchar(1000) NOT NULL,
  `longitude` varchar(1000) NOT NULL,
  `get_around` varchar(1000) NOT NULL,
  `known_for` varchar(1000) NOT NULL,
  `view_order` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `ci_sessions`
--

CREATE TABLE `ci_sessions` (
  `session_id` varchar(40) NOT NULL DEFAULT '0',
  `ip_address` varchar(45) NOT NULL DEFAULT '0',
  `user_agent` varchar(120) NOT NULL,
  `last_activity` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `user_data` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `contactus`
--

CREATE TABLE `contactus` (
  `id` int(20) NOT NULL,
  `date` varchar(20) NOT NULL,
  `name` varchar(250) NOT NULL,
  `email` varchar(250) NOT NULL,
  `subject` varchar(250) NOT NULL,
  `message` text NOT NULL,
  `security_code` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `contactus`
--

INSERT INTO `contactus` (`id`, `date`, `name`, `email`, `subject`, `message`, `security_code`) VALUES
(1, '2017-12-20', 'preetha', 'preetha@pofitec.com', 'test', 'test', ''),
(2, '2018-02-07', ' preetha', 'preetha@pofitec.com', 'enq', 'message', ''),
(5, '2018-02-08', 'Azhahesan', 'azhahesan@pofitec.com', 'Contact Us', 'Welcome', ''),
(6, '2018-02-08', 'Azhahesan', 'azhahesan@pofitec.com', 'Contact Us', 'Contact Us', ''),
(7, '2018-06-08', 'Test Contact Us', 'test@vacason', 'Testing Contact', 'Testing Contact', '');

-- --------------------------------------------------------

--
-- Table structure for table `country_code`
--

CREATE TABLE `country_code` (
  `Country` varchar(80) NOT NULL,
  `Code` varchar(80) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `email_user`
--

CREATE TABLE `email_user` (
  `id` int(11) NOT NULL,
  `username` varchar(100) NOT NULL,
  `phone` varchar(100) NOT NULL,
  `message1` varchar(255) NOT NULL,
  `email` varchar(100) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `fc_advertisment`
--

CREATE TABLE `fc_advertisment` (
  `advertisment_id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `link` varchar(255) NOT NULL,
  `description` longtext NOT NULL,
  `image` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL,
  `created_date` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `fc_attribute`
--

CREATE TABLE `fc_attribute` (
  `id` int(11) NOT NULL,
  `attribute_name` varchar(500) NOT NULL,
  `status` enum('Active','Inactive') NOT NULL,
  `dateAdded` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `attribute_seourl` varchar(500) NOT NULL,
  `attribute_title` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `fc_attribute`
--

INSERT INTO `fc_attribute` (`id`, `attribute_name`, `status`, `dateAdded`, `attribute_seourl`, `attribute_title`) VALUES
(1, 'Amenities', 'Active', '2018-02-10 18:39:44', 'amenities', 'Amenities'),
(5, 'Accessibility', 'Active', '2018-02-10 18:39:58', 'accessibility', 'Accessibility'),
(8, 'Sleeping Arrangements', 'Active', '2018-01-28 20:01:25', 'sleepingarrangements', 'Sleeping Arrangements'),
(9, 'Common Amenities ', 'Inactive', '2018-02-17 23:51:56', 'commonamenities', 'Common Amenities '),
(10, 'Special Features', 'Active', '2018-02-17 23:13:23', 'specialfeatures', 'Special Features'),
(11, 'Extra Amenities ', 'Active', '2018-02-17 23:13:32', 'extraamenities', 'Extra Amenities '),
(12, 'Home Safety ', 'Active', '2018-02-17 23:13:40', 'homesafety', 'Home Safety '),
(13, 'WiFi ', 'Inactive', '2018-02-17 23:01:13', 'wifi', 'WiFi '),
(14, 'Trip Type', 'Active', '2018-02-23 20:07:23', 'triptype', 'Trip Type'),
(15, 'Proximity', 'Active', '2018-03-12 19:31:29', 'proximity', 'Proximity');

-- --------------------------------------------------------

--
-- Table structure for table `fc_banner_category`
--

CREATE TABLE `fc_banner_category` (
  `id` bigint(20) NOT NULL,
  `name` mediumtext NOT NULL,
  `image` mediumtext NOT NULL,
  `link` mediumtext NOT NULL,
  `status` enum('Publish','Unpublish') NOT NULL,
  `dateAdded` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `fc_banner_category`
--

INSERT INTO `fc_banner_category` (`id`, `name`, `image`, `link`, `status`, `dateAdded`) VALUES
(5, 'Nursery', 'nursery.jpg', '', 'Publish', '2013-09-24 06:13:07'),
(6, 'Season Indoors', 'season-indoors.jpg', '', 'Publish', '2013-09-24 06:13:17');

-- --------------------------------------------------------

--
-- Table structure for table `fc_bnb_modules`
--

CREATE TABLE `fc_bnb_modules` (
  `module_id` int(11) NOT NULL,
  `module_name` varchar(255) NOT NULL,
  `module_title` varchar(255) NOT NULL,
  `module_description` varchar(1000) NOT NULL,
  `status` enum('0','1') NOT NULL DEFAULT '0',
  `added_date` datetime NOT NULL,
  `last_modified` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `fc_bnb_modules`
--

INSERT INTO `fc_bnb_modules` (`module_id`, `module_name`, `module_title`, `module_description`, `status`, `added_date`, `last_modified`) VALUES
(1, 'experience', 'Experience', 'Experience means a specialist or expert gives a intract guideline or live experience like an event posting.  ', '1', '2017-07-24 17:38:00', '0000-00-00 00:00:00'),
(2, 'payment_option', 'Payment Option', 'To add Instant payment along with Request to book option', '1', '2017-09-11 12:40:00', '0000-00-00 00:00:00');

-- --------------------------------------------------------

--
-- Table structure for table `fc_booking`
--

CREATE TABLE `fc_booking` (
  `id` int(11) NOT NULL,
  `From_date` datetime NOT NULL,
  `To_date` datetime NOT NULL,
  `prd_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `owner_id` int(11) NOT NULL,
  `Details` varchar(300) NOT NULL,
  `NoofGuest` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `fc_category`
--

CREATE TABLE `fc_category` (
  `id` int(200) NOT NULL,
  `cat_name` varchar(500) NOT NULL,
  `rootID` int(20) NOT NULL,
  `seourl` varchar(255) NOT NULL,
  `image` varchar(100) NOT NULL,
  `status` enum('Active','InActive') NOT NULL,
  `cat_position` int(11) NOT NULL,
  `seo_title` longblob NOT NULL,
  `seo_keyword` longblob NOT NULL,
  `seo_description` longblob NOT NULL,
  `dateAdded` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `fc_category`
--

INSERT INTO `fc_category` (`id`, `cat_name`, `rootID`, `seourl`, `image`, `status`, `cat_position`, `seo_title`, `seo_keyword`, `seo_description`, `dateAdded`) VALUES
(1, '', 0, '', '', 'Active', 0, '', '', '', '2014-10-30 21:12:15');

-- --------------------------------------------------------

--
-- Table structure for table `fc_cities`
--

CREATE TABLE `fc_cities` (
  `id` int(11) NOT NULL,
  `countryid` int(11) NOT NULL,
  `stateid` int(11) NOT NULL,
  `state_code` varchar(32) NOT NULL,
  `name` varchar(32) NOT NULL,
  `contid` varchar(50) NOT NULL,
  `seourl` varchar(250) NOT NULL,
  `status` enum('InActive','Active') NOT NULL,
  `featured` enum('0','1') NOT NULL,
  `description` longblob NOT NULL,
  `meta_title` varchar(1000) NOT NULL,
  `meta_keyword` varchar(1000) NOT NULL,
  `meta_description` blob NOT NULL,
  `citylogo` varchar(1000) NOT NULL,
  `citythumb` varchar(1000) NOT NULL,
  `mobile_citylogo` varchar(500) NOT NULL,
  `neighborhoods` varchar(1000) NOT NULL,
  `tags` varchar(1000) NOT NULL,
  `short_description` varchar(1000) NOT NULL,
  `latitude` varchar(1000) NOT NULL,
  `longitude` varchar(1000) NOT NULL,
  `get_around` varchar(1000) NOT NULL,
  `known_for` varchar(1000) NOT NULL,
  `view_order` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `fc_cities`
--

INSERT INTO `fc_cities` (`id`, `countryid`, `stateid`, `state_code`, `name`, `contid`, `seourl`, `status`, `featured`, `description`, `meta_title`, `meta_keyword`, `meta_description`, `citylogo`, `citythumb`, `mobile_citylogo`, `neighborhoods`, `tags`, `short_description`, `latitude`, `longitude`, `get_around`, `known_for`, `view_order`) VALUES
(460, 95, 875, '', 'Chênnêi', '', 'chnni', 'Active', '0', '', '', '', '', '1504528461-Chrysanthemum1.jpg', 'Chrysanthemum1.jpg', '', '0', '', '', '12.95812', '80.25542', '', '', 0),
(3, 145, 0, 'TRG', 'kol', '', 'kol', 'Active', '0', '', '', '', '', '', '', '', '0', '', '', '4.21048', '101.97577', '', '', 0),
(4, 145, 4, 'MLK', 'Alor Gâjah', '', 'alor-gjah', 'Active', '0', '', '', '', '', '', '', '', '0', '', '', '2.36180', '102.22150', '', '', 0),
(5, 145, 4, 'KDH', 'Alor Setar', '', 'alor-setar', 'Active', '0', '', '', '', '', '1505732218-Desert.jpg', 'Desert.jpg', '', '0', '', '', '6.10630', '100.36850', '', '', 0),
(6, 145, 4, 'KDH', 'Alor Star', '', 'alor-star', 'Active', '0', '', '', '', '', '', '', '', '0', '', '', '6.11940', '100.36770', '', '', 0),
(7, 145, 0, 'SGR', 'Ampang', '', 'ampang', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '3.1549', '101.7412', '', '', 0),
(8, 145, 0, 'PLS', 'Arau', '', 'arau', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '6.4246', '100.2736', '', '', 0),
(9, 145, 0, 'MLK', 'Asahan', '', 'asahan', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '2.38', '102.4819', '', '', 0),
(10, 145, 0, 'SRW', 'Asajaya', '', 'asajaya', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '1.5424', '110.516', '', '', 0),
(11, 145, 0, 'JHR', 'Ayer Baloi', '', 'ayer-baloi', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '1.6927', '103.2524', '', '', 0),
(12, 145, 0, 'JHR', 'Ayer Hitam', '', 'ayer-hitam', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '1.9032', '103.2165', '', '', 0),
(13, 145, 0, 'PNG', 'Ayer Itam', '', 'ayer-itam', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.3681', '100.305', '', '', 0),
(14, 145, 0, 'MLK', 'Ayer Keroh', '', 'ayer-keroh', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '2.2872', '102.2759', '', '', 0),
(451, 29, 870, '', 'Indianopolis', '', 'indianopolis', 'InActive', '1', '', '', '', '', '1489092432-restaurant.png', 'restaurant.png', '', '0', '', '', '-23.60883', '-46.66708', '', '', 0),
(16, 145, 0, 'PRK', 'Ayer Tawar', '', 'ayer-tawar', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '4.3674', '100.8604', '', '', 0),
(17, 145, 0, 'JHR', 'Ayer Tawar 3', '', 'ayer-tawar-3', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '1.721', '103.8967', '', '', 0),
(18, 145, 0, 'KTN', 'Bachok', '', 'bachok', 'Active', '0', '', '', '', '', 'large.jpg', 'large1.jpg', '', '0', '', '', '6.05580', '102.34870', '', '', 3),
(19, 145, 0, 'PRK', 'Bagan Datoh', '', 'bagan-datoh', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '3.9793', '100.7593', '', '', 0),
(20, 145, 0, 'PRK', 'Bagan Serai', '', 'bagan-serai', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '4.8687', '100.6968', '', '', 0),
(21, 145, 0, 'NSN', 'Bahau', '', 'bahau', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '2.8199', '102.2934', '', '', 0),
(22, 145, 0, 'PNG', 'Balik Pulau', '', 'balik-pulau', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.352', '100.2824', '', '', 0),
(23, 145, 0, 'KDH', 'Baling', '', 'baling', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.7229', '100.7831', '', '', 0),
(24, 145, 0, 'SRW', 'Balingian', '', 'balingian', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '2.2248', '111.6044', '', '', 0),
(25, 145, 0, 'PHG', 'Balok', '', 'balok', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '3.912', '103.3298', '', '', 0),
(26, 145, 0, 'KDH', 'Bandar Baharu', '', 'bandar-baharu', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.1873', '100.5156', '', '', 0),
(27, 145, 0, 'KDH', 'Bandar Bahru', '', 'bandar-bahru', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.6564', '100.5422', '', '', 0),
(28, 145, 0, 'SGR', 'Bandar Baru Ban', '', 'bandar-baru-ban', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '2.9918', '101.7455', '', '', 0),
(29, 145, 0, 'NSN', 'Bandar Baru Ens', '', 'bandar-baru-ens', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '2.7526', '101.7667', '', '', 0),
(30, 145, 0, 'JHR', 'Bandar Penawar', '', 'bandar-penawar', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '1.6712', '103.9725', '', '', 0),
(31, 145, 0, 'SGR', 'Bandar Puncak A', '', 'bandar-puncak-a', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '3.1682', '101.5271', '', '', 0),
(32, 145, 0, 'PHG', 'Bandar Pusat  J', '', 'bandar-pusat-j', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '3.7416', '102.5443', '', '', 0),
(33, 145, 0, 'PHG', 'Bandar Pusat Je', '', 'bandar-pusat-je', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '3.6739', '102.5212', '', '', 0),
(34, 145, 0, 'PRK', 'Bandar Seri Isk', '', 'bandar-seri-isk', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '4.3587', '100.9673', '', '', 0),
(35, 145, 0, 'NSN', 'Bandar Seri Jem', '', 'bandar-seri-jem', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '2.8299', '102.2531', '', '', 0),
(36, 145, 0, 'JHR', 'Bandar Tenggara', '', 'bandar-tenggara', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '1.7876', '103.6699', '', '', 0),
(37, 145, 0, 'PHG', 'Bandar Tun Abdu', '', 'bandar-tun-abdu', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '2.9499', '102.6818', '', '', 0),
(38, 145, 0, 'SGR', 'Bangi', '', 'bangi', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '2.9271', '101.7802', '', '', 0),
(39, 145, 0, 'SGR', 'Banting', '', 'banting', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '2.9092', '101.5279', '', '', 0),
(40, 145, 0, 'SRW', 'Baram', '', 'baram', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '2.0768', '112.3837', '', '', 0),
(41, 145, 0, 'SGR', 'Batang Berjunta', '', 'batang-berjunta', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '3.3036', '101.46', '', '', 0),
(42, 145, 0, 'SGR', 'Batang Kali', '', 'batang-kali', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '3.3751', '101.6306', '', '', 0),
(43, 145, 0, 'JHR', 'Batu Anam', '', 'batu-anam', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '2.4247', '102.8497', '', '', 0),
(44, 145, 0, 'KUL', 'Batu Caves', '', 'batu-caves', 'Active', '0', '', '', '', '', 'large2.jpg', 'large3.jpg', '', '0', '', '', '3.21780', '101.69190', '', '', 2),
(45, 145, 0, 'PNG', 'Batu Ferringhi', '', 'batu-ferringhi', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.4452', '100.2911', '', '', 0),
(46, 145, 0, 'PRK', 'Batu Gajah', '', 'batu-gajah', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '4.4422', '101.0546', '', '', 0),
(47, 145, 0, 'NSN', 'Batu Kikir', '', 'batu-kikir', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '2.8352', '102.2086', '', '', 0),
(48, 145, 0, 'PRK', 'Batu Kurau', '', 'batu-kurau', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '4.9553', '100.8398', '', '', 0),
(49, 145, 0, 'PNG', 'Batu Maung', '', 'batu-maung', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.355', '100.2709', '', '', 0),
(50, 145, 0, 'JHR', 'Batu Pahat', '', 'batu-pahat', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '1.8578', '103.0357', '', '', 0),
(51, 145, 0, 'SRW', 'Bau', '', 'bau', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '1.4813', '110.1013', '', '', 0),
(52, 145, 0, 'PNG', 'Bayan Lepas', '', 'bayan-lepas', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.3163', '100.281', '', '', 0),
(53, 145, 0, 'SBH', 'Beaufort', '', 'beaufort', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.3452', '115.7078', '', '', 0),
(54, 145, 0, 'KDH', 'Bedong', '', 'bedong', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.7879', '100.4719', '', '', 0),
(55, 145, 0, 'PRK', 'Behrang Stesen', '', 'behrang-stesen', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '3.889', '101.4121', '', '', 0),
(56, 145, 0, 'SRW', 'Bekenu', '', 'bekenu', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '4.0678', '113.8315', '', '', 0),
(57, 145, 0, 'JHR', 'Bekok', '', 'bekok', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '2.1332', '103.4663', '', '', 0),
(58, 145, 0, 'SRW', 'Belaga', '', 'belaga', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '2.4811', '113.6292', '', '', 0),
(59, 145, 0, 'SRW', 'Belawai', '', 'belawai', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '1.9636', '111.0947', '', '', 0),
(60, 145, 0, 'SBH', 'Beluran', '', 'beluran', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.9945', '117.3361', '', '', 0),
(61, 145, 0, 'PHG', 'Benta', '', 'benta', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '3.9583', '102.1692', '', '', 0),
(62, 145, 0, 'PHG', 'Bentong', '', 'bentong', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '3.5281', '101.9763', '', '', 0),
(63, 145, 0, 'JHR', 'Benut', '', 'benut', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '1.6864', '103.2713', '', '', 0),
(64, 145, 0, 'SGR', 'Beranang', '', 'beranang', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '2.952', '101.8261', '', '', 0),
(65, 145, 0, 'SRW', 'Betong', '', 'betong', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '1.5038', '111.4675', '', '', 0),
(66, 145, 0, 'SBH', 'Beverly', '', 'beverly', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.4204', '116.7968', '', '', 0),
(67, 145, 0, 'PRK', 'Bidor', '', 'bidor', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '4.1787', '101.2265', '', '', 0),
(68, 145, 0, 'SRW', 'Bintangor', '', 'bintangor', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '2.2244', '111.5791', '', '', 0),
(69, 145, 0, 'SRW', 'Bintulu', '', 'bintulu', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '2.6262', '112.1367', '', '', 0),
(70, 145, 0, 'SBH', 'Bongawan', '', 'bongawan', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.4835', '115.7834', '', '', 0),
(71, 145, 0, 'PHG', 'Brinchang', '', 'brinchang', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '4.3557', '101.6275', '', '', 0),
(72, 145, 0, 'PRK', 'Bruas', '', 'bruas', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '4.7499', '100.837', '', '', 0),
(73, 145, 0, 'TRG', 'Bukit Besi', '', 'bukit-besi', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.0395', '102.7909', '', '', 0),
(74, 145, 0, 'PHG', 'Bukit Fraser', '', 'bukit-fraser', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '3.7188', '101.7403', '', '', 0),
(75, 145, 0, 'JHR', 'Bukit Gambir', '', 'bukit-gambir', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '2.1437', '102.8537', '', '', 0),
(76, 145, 0, 'PHG', 'Bukit Goh', '', 'bukit-goh', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '3.7793', '102.9106', '', '', 0),
(77, 145, 0, 'KDH', 'Bukit Kayu Hita', '', 'bukit-kayu-hita', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '6.3493', '100.4429', '', '', 0),
(78, 145, 0, 'PNG', 'Bukit Mertajam', '', 'bukit-mertajam', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.3344', '100.4673', '', '', 0),
(79, 145, 0, 'JHR', 'Bukit Pasir', '', 'bukit-pasir', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '2.1122', '102.7617', '', '', 0),
(80, 145, 0, 'TRG', 'Bukit Payong', '', 'bukit-payong', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.2321', '103.1041', '', '', 0),
(81, 145, 0, 'SGR', 'Bukit Rotan', '', 'bukit-rotan', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '3.1956', '101.3926', '', '', 0),
(82, 145, 0, 'PNG', 'Butterworth', '', 'butterworth', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.4093', '100.3649', '', '', 0),
(83, 145, 0, 'TRG', 'Ceneh', '', 'ceneh', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '4.1373', '103.2476', '', '', 0),
(84, 145, 0, 'JHR', 'Chaah', '', 'chaah', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '2.0491', '103.1443', '', '', 0),
(85, 145, 0, 'TRG', 'Chalok', '', 'chalok', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.3867', '102.8676', '', '', 0),
(86, 145, 0, 'PRK', 'Changkat Jering', '', 'changkat-jering', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '4.7067', '100.832', '', '', 0),
(87, 145, 0, 'PRK', 'Changkat Keruin', '', 'changkat-keruin', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '4.2702', '100.8909', '', '', 0),
(88, 145, 0, 'PRK', 'Chêmorrr', '', 'chmorrr', 'Active', '0', '', '', '', '', '', '', '', '0', '', '', '4.72810', '101.12000', '', '', 0),
(89, 145, 0, 'PRK', 'Chenderiang', '', 'chenderiang', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '4.3111', '101.2339', '', '', 0),
(90, 145, 0, 'PRK', 'Chenderong Bala', '', 'chenderong-bala', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '4.2992', '101.0101', '', '', 0),
(91, 145, 0, 'PHG', 'Chênor', '', 'chnor', 'Active', '0', '', '', '', '', '', '', '', '0', '', '', '3.50180', '102.64550', '', '', 0),
(92, 145, 0, 'KTN', 'Cherang Ruku', '', 'cherang-ruku', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.8722', '102.4363', '', '', 0),
(93, 145, 0, 'KUL', 'Cheras', '', 'cheras', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '3.1056', '101.7253', '', '', 0),
(94, 145, 0, 'PRK', 'Chikus', '', 'chikus', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '4.3082', '101.0173', '', '', 0),
(95, 145, 0, 'PHG', 'Chini', '', 'chini', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '3.2106', '103.0223', '', '', 0),
(96, 145, 0, 'TRG', 'Cukai', '', 'cukai', 'Active', '0', '', '', '', '', '', '', '', '0', '', '', '4.33050', '103.35200', '', '', 0),
(97, 145, 0, 'SGR', 'Cyberjaya', '', 'cyberjaya', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '2.9679', '101.653', '', '', 0),
(98, 145, 0, 'KTN', 'Dabong', '', 'dabong', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.4938', '102.0523', '', '', 0),
(99, 145, 0, 'SRW', 'Dalat', '', 'dalat', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '2.2853', '111.9027', '', '', 0),
(100, 145, 0, 'PHG', 'Damak', '', 'damak', 'Active', '0', '', '', '', '', 'images1.jpg', 'images2.jpg', '', '0', '', '', '3.84870', '102.24600', '', '', 5),
(101, 145, 0, 'SRW', 'Daro', '', 'daro', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '2.5321', '111.5253', '', '', 0),
(102, 145, 0, 'SRW', 'Debak', '', 'debak', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '1.5775', '111.2168', '', '', 0),
(103, 145, 0, 'SGR', 'Dengkil', '', 'dengkil', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '2.9686', '101.652', '', '', 0),
(104, 145, 0, 'PHG', 'Dong', '', 'dong', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '3.8834', '101.983', '', '', 0),
(105, 145, 0, 'TRG', 'Dungun', '', 'dungun', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '4.8168', '103.3036', '', '', 0),
(106, 145, 0, 'MLK', 'Durian Tunggal', '', 'durian-tunggal', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '2.3013', '102.2842', '', '', 0),
(107, 145, 0, 'JHR', 'Endau', '', 'endau', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '2.5415', '103.542', '', '', 0),
(108, 145, 0, 'PRK', 'Enggor', '', 'enggor', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '4.8218', '100.946', '', '', 0),
(109, 145, 0, 'SRW', 'Engkilili', '', 'engkilili', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '1.2817', '110.9074', '', '', 0),
(110, 145, 0, 'PHG', 'Gambang', '', 'gambang', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '3.7444', '103.1378', '', '', 0),
(111, 145, 0, 'JHR', 'Gelang Patah', '', 'gelang-patah', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '1.4619', '103.5857', '', '', 0),
(112, 145, 0, 'PNG', 'Gelugor', '', 'gelugor', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.3653', '100.3067', '', '', 0),
(113, 145, 0, 'NSN', 'Gemas', '', 'gemas', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '2.6637', '102.5259', '', '', 0),
(114, 145, 0, 'NSN', 'Gemencheh', '', 'gemencheh', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '2.6213', '102.3113', '', '', 0),
(115, 145, 0, 'PHG', 'Genting Highlan', '', 'genting-highlan', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '3.422', '101.7892', '', '', 0),
(116, 145, 0, 'PRK', 'Gerik', '', 'gerik', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.2806', '101.1007', '', '', 0),
(117, 145, 0, 'JHR', 'Gerisek', '', 'gerisek', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '2.215', '102.7854', '', '', 0),
(118, 145, 0, 'PRK', 'Gopeng', '', 'gopeng', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '4.5193', '101.1153', '', '', 0),
(119, 145, 0, 'KTN', 'Gua Musang', '', 'gua-musang', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.0356', '102.0247', '', '', 0),
(120, 145, 0, 'JHR', 'Gugusan Taib An', '', 'gugusan-taib-an', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '1.7601', '103.6852', '', '', 0),
(121, 145, 0, 'KDH', 'Gurun', '', 'gurun', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.8064', '100.5136', '', '', 0),
(122, 145, 0, 'SGR', 'Hulu Langat', '', 'hulu-langat', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '3.0719', '101.8347', '', '', 0),
(123, 145, 0, 'PRK', 'Hutan Melintang', '', 'hutan-melintang', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '4.0333', '100.9471', '', '', 0),
(124, 145, 0, 'SBH', 'Inanam', '', 'inanam', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.9933', '116.1322', '', '', 0),
(125, 145, 0, 'PRK', 'Intan', '', 'intan', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.4297', '101.0342', '', '', 0),
(126, 145, 0, 'PRK', 'Ipoh', '', 'ipoh', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '4.6502', '101.0682', '', '', 0),
(127, 145, 0, 'MLK', 'Jasin', '', 'jasin', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '2.2933', '102.4146', '', '', 0),
(128, 145, 0, 'PHG', 'Jaya Gading', '', 'jaya-gading', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '3.8173', '103.1733', '', '', 0),
(129, 145, 0, 'KTN', 'Jeli', '', 'jeli', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.728', '101.9225', '', '', 0),
(130, 145, 0, 'PNG', 'Jelutong', '', 'jelutong', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.3956', '100.3111', '', '', 0),
(131, 145, 0, 'JHR', 'Jementah', '', 'jementah', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '2.1737', '102.9493', '', '', 0),
(132, 145, 0, 'KDH', 'Jeniang', '', 'jeniang', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.8343', '100.6252', '', '', 0),
(133, 145, 0, 'SGR', 'Jenjarom', '', 'jenjarom', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '2.9723', '101.5282', '', '', 0),
(134, 145, 0, 'PRK', 'Jeram', '', 'jeram', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '4.3641', '101.1539', '', '', 0),
(135, 145, 0, 'PHG', 'Jerantut', '', 'jerantut', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '3.868', '102.4271', '', '', 0),
(136, 145, 0, 'TRG', 'Jerteh', '', 'jerteh', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.6111', '102.5729', '', '', 0),
(137, 145, 0, 'KDH', 'Jitra', '', 'jitra', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '6.1316', '100.4351', '', '', 0),
(138, 145, 0, 'NSN', 'Johol', '', 'johol', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '2.6182', '102.2701', '', '', 0),
(139, 145, 0, 'JHR', 'Johor Bahru', '', 'johor-bahru', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '1.5035', '103.7405', '', '', 0),
(140, 145, 0, 'SRW', 'Julau', '', 'julau', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '1.783', '111.9699', '', '', 0),
(141, 145, 0, 'SRW', 'Kabong', '', 'kabong', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '1.8453', '111.4252', '', '', 0),
(142, 145, 0, 'JHR', 'Kahang', '', 'kahang', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '2.1504', '103.5336', '', '', 0),
(143, 145, 0, 'SGR', 'Kajang', '', 'kajang', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '3.0094', '101.7755', '', '', 0),
(144, 145, 0, 'PLS', 'Kaki Bukit', '', 'kaki-bukit', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '6.6472', '100.2022', '', '', 0),
(145, 145, 0, 'PRK', 'Kampar', '', 'kampar', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '4.3551', '101.1252', '', '', 0),
(146, 145, 0, 'PRK', 'Kampung Gajah', '', 'kampung-gajah', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '4.3923', '100.9307', '', '', 0),
(147, 145, 0, 'PRK', 'Kampung Kepayan', '', 'kampung-kepayan', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '4.5595', '101.0673', '', '', 0),
(148, 145, 0, 'TRG', 'Kampung Raja', '', 'kampung-raja', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.7332', '102.613', '', '', 0),
(149, 145, 0, 'PRK', 'Kamunting', '', 'kamunting', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '4.8263', '100.7717', '', '', 0),
(150, 145, 0, 'PLS', 'Kangar', '', 'kangar', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '6.4312', '100.2056', '', '', 0),
(151, 145, 0, 'SRW', 'Kanowit', '', 'kanowit', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '1.9416', '112.0866', '', '', 0),
(152, 145, 0, 'SGR', 'Kapar', '', 'kapar', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '3.1331', '101.4207', '', '', 0),
(153, 145, 0, 'SRW', 'Kapit', '', 'kapit', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '1.9499', '113.1692', '', '', 0),
(154, 145, 0, 'PHG', 'Karak', '', 'karak', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '3.4339', '102.1543', '', '', 0),
(155, 145, 0, 'KDH', 'Karangan', '', 'karangan', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.5748', '100.6005', '', '', 0),
(156, 145, 0, 'KTN', 'Kem Desa Pahlaw', '', 'kem-desa-pahlaw', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.8938', '102.2273', '', '', 0),
(157, 145, 0, 'MLK', 'Kem Trendak', '', 'kem-trendak', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '2.2891', '102.3256', '', '', 0),
(158, 145, 0, 'TRG', 'Kemasek', '', 'kemasek', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '4.62', '103.353', '', '', 0),
(159, 145, 0, 'PHG', 'Kemayan', '', 'kemayan', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '3.251', '102.5593', '', '', 0),
(160, 145, 0, 'SBH', 'Keningau', '', 'keningau', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.3561', '116.3049', '', '', 0),
(161, 145, 0, 'KDH', 'Kepala Batas', '', 'kepala-batas', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.9661', '100.4734', '', '', 0),
(162, 145, 0, 'SGR', 'Kerling', '', 'kerling', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '3.5566', '101.5612', '', '', 0),
(163, 145, 0, 'TRG', 'Kerteh', '', 'kerteh', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '4.6985', '103.3568', '', '', 0),
(164, 145, 0, 'TRG', 'Ketengah Jaya', '', 'ketengah-jaya', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '4.4348', '103.3763', '', '', 0),
(165, 145, 0, 'KTN', 'Ketereh', '', 'ketereh', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.9179', '102.2274', '', '', 0),
(166, 145, 0, 'TRG', 'Kijal', '', 'kijal', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '4.436', '103.4175', '', '', 0),
(167, 145, 0, 'SGR', 'Klang', '', 'klang', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '3.0349', '101.5119', '', '', 0),
(168, 145, 0, 'SGR', 'KLIA', '', 'klia', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '2.8239', '101.687', '', '', 0),
(169, 145, 0, 'JHR', 'Kluang', '', 'kluang', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '1.9226', '103.4038', '', '', 0),
(170, 145, 0, 'KDH', 'Kodiang', '', 'kodiang', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '6.2045', '100.3746', '', '', 0),
(171, 145, 0, 'NSN', 'Kota', '', 'kota', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '2.5231', '102.1388', '', '', 0),
(172, 145, 0, 'KTN', 'Kota Bahru', '', 'kota-bahru', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '6.122', '102.2523', '', '', 0),
(173, 145, 0, 'SBH', 'Kota Belud', '', 'kota-belud', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '6.3463', '116.4665', '', '', 0),
(174, 145, 0, 'KTN', 'Kota Bharu', '', 'kota-bharu', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '6.1253', '102.2461', '', '', 0),
(175, 145, 0, 'SBH', 'Kota Kinabalu', '', 'kota-kinabalu', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.8626', '115.9946', '', '', 0),
(176, 145, 0, 'SBH', 'Kota Kinabatang', '', 'kota-kinabatang', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.2438', '117.4841', '', '', 0),
(177, 145, 0, 'KDH', 'Kota Kuala Muda', '', 'kota-kuala-muda', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.7405', '100.4243', '', '', 0),
(178, 145, 0, 'SBH', 'Kota Marudu', '', 'kota-marudu', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '6.5407', '116.8224', '', '', 0),
(179, 145, 0, 'SRW', 'Kota Samarahan', '', 'kota-samarahan', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '1.4727', '110.402', '', '', 0),
(180, 145, 0, 'KDH', 'Kota Sarang Sem', '', 'kota-sarang-sem', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.9008', '100.4089', '', '', 0),
(181, 145, 0, 'JHR', 'Kota Tinggi', '', 'kota-tinggi', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '1.7427', '103.7788', '', '', 0),
(182, 145, 0, 'KTN', 'Kuala Balah', '', 'kuala-balah', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.4526', '101.9212', '', '', 0),
(183, 145, 0, 'TRG', 'Kuala Berang', '', 'kuala-berang', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.1048', '102.9733', '', '', 0),
(184, 145, 0, 'TRG', 'Kuala Besut', '', 'kuala-besut', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.7998', '102.5579', '', '', 0),
(185, 145, 0, 'PRK', 'Kuala Kangsar', '', 'kuala-kangsar', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '4.7073', '100.9381', '', '', 0),
(186, 145, 0, 'KDH', 'Kuala Kedah', '', 'kuala-kedah', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.9919', '100.3635', '', '', 0),
(187, 145, 0, 'KDH', 'Kuala Ketil', '', 'kuala-ketil', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.6747', '100.6754', '', '', 0),
(188, 145, 0, 'NSN', 'Kuala Klawang', '', 'kuala-klawang', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '2.9555', '102.0719', '', '', 0),
(189, 145, 0, 'KTN', 'Kuala Krai', '', 'kuala-krai', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.5693', '102.1786', '', '', 0),
(190, 145, 0, 'PHG', 'Kuala Krau', '', 'kuala-krau', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '3.6237', '102.456', '', '', 0),
(191, 145, 0, 'SGR', 'Kuala Kubu Baru', '', 'kuala-kubu-baru', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '3.386', '101.5488', '', '', 0),
(192, 145, 0, 'PRK', 'Kuala Kurau', '', 'kuala-kurau', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '4.9211', '100.5186', '', '', 0),
(193, 145, 0, 'PHG', 'Kuala Lipis', '', 'kuala-lipis', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '4.0629', '102.1071', '', '', 0),
(194, 145, 0, 'KUL', 'Kuala Lumpur', '', 'kuala-lumpur', 'Active', '0', '', '', '', '', 'images.jpg', 'netherland.jpg', '', '0', '', '', '3.14330', '101.69550', '', '', 4),
(195, 145, 0, 'KDH', 'Kuala Nerang', '', 'kuala-nerang', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '6.1461', '100.5833', '', '', 0),
(196, 145, 0, 'KDH', 'Kuala Pegang', '', 'kuala-pegang', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.7874', '100.6923', '', '', 0),
(197, 145, 0, 'SBH', 'Kuala Penyu', '', 'kuala-penyu', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.4894', '115.5347', '', '', 0),
(198, 145, 0, 'PLS', 'Kuala Perlis', '', 'kuala-perlis', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '6.2683', '100.2088', '', '', 0),
(199, 145, 0, 'NSN', 'Kuala Pilah', '', 'kuala-pilah', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '2.7226', '102.2138', '', '', 0),
(200, 145, 0, 'PHG', 'Kuala Rompin', '', 'kuala-rompin', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '2.9496', '103.4089', '', '', 0),
(201, 145, 0, 'SGR', 'Kuala Selangor', '', 'kuala-selangor', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '3.2457', '101.3678', '', '', 0),
(202, 145, 0, 'PRK', 'Kuala Sepetang', '', 'kuala-sepetang', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '4.9204', '100.6607', '', '', 0),
(203, 145, 0, 'MLK', 'Kuala Sungai Ba', '', 'kuala-sungai-ba', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '2.33', '102.0961', '', '', 0),
(204, 145, 0, 'TRG', 'Kuala Terenggan', '', 'kuala-terenggan', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.2847', '103.1475', '', '', 0),
(205, 145, 0, 'PHG', 'Kuantan', '', 'kuantan', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '3.8099', '103.2893', '', '', 0),
(206, 145, 0, 'PNG', 'Kubang Semang', '', 'kubang-semang', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.4088', '100.4837', '', '', 0),
(207, 145, 0, 'SRW', 'Kuching', '', 'kuching', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '1.5455', '110.3439', '', '', 0),
(208, 145, 0, 'SBH', 'Kudat', '', 'kudat', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '6.8298', '116.8867', '', '', 0),
(209, 145, 0, 'JHR', 'Kukup', '', 'kukup', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '1.423', '103.4425', '', '', 0),
(210, 145, 0, 'JHR', 'Kulai', '', 'kulai', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '1.7259', '103.5011', '', '', 0),
(211, 145, 0, 'KDH', 'Kulim', '', 'kulim', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.4724', '100.5385', '', '', 0),
(212, 145, 0, 'SBH', 'Kunak', '', 'kunak', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '4.677', '118.1392', '', '', 0),
(213, 145, 0, 'KDH', 'Kupang', '', 'kupang', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.6818', '100.758', '', '', 0),
(214, 145, 0, 'JHR', 'Labis', '', 'labis', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '2.2604', '103.5458', '', '', 0),
(215, 145, 0, 'NSN', 'Labu', '', 'labu', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '2.7339', '101.8927', '', '', 0),
(216, 145, 0, 'LBN', 'Labuan', '', 'labuan', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.296', '115.2429', '', '', 0),
(217, 145, 0, 'SBH', 'Lahad Datu', '', 'lahad-datu', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.0434', '118.346', '', '', 0),
(218, 145, 0, 'PRK', 'Lambor Kanan', '', 'lambor-kanan', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '4.385', '100.9163', '', '', 0),
(219, 145, 0, 'PHG', 'Lanchang', '', 'lanchang', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '3.5547', '102.265', '', '', 0),
(220, 145, 0, 'KDH', 'Langgar', '', 'langgar', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '6.0479', '100.407', '', '', 0),
(221, 145, 0, 'PRK', 'Langkap', '', 'langkap', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '4.2015', '101.0814', '', '', 0),
(222, 145, 0, 'KDH', 'Langkawi', '', 'langkawi', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '6.2439', '99.9533', '', '', 0),
(223, 145, 0, 'SRW', 'Lawas', '', 'lawas', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '3.9117', '114.0909', '', '', 0),
(224, 145, 0, 'JHR', 'Layang-Layang', '', 'layang-layang', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '1.7832', '103.4388', '', '', 0),
(225, 145, 0, 'PRK', 'Lenggong', '', 'lenggong', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '4.9846', '100.973', '', '', 0),
(226, 145, 0, 'SBH', 'Likas', '', 'likas', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '6.008', '116.1256', '', '', 0),
(227, 145, 0, 'SRW', 'Limbang', '', 'limbang', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '4.1371', '114.6005', '', '', 0),
(228, 145, 0, 'SRW', 'Lingga', '', 'lingga', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '1.3306', '111.1952', '', '', 0),
(229, 145, 0, 'NSN', 'Linggi', '', 'linggi', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '2.5272', '102.026', '', '', 0),
(230, 145, 0, 'SRW', 'Long Lama', '', 'long-lama', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '3.9671', '114.2984', '', '', 0),
(231, 145, 0, 'SRW', 'Lubok Antu', '', 'lubok-antu', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '1.2548', '111.6771', '', '', 0),
(232, 145, 0, 'MLK', 'Lubok China', '', 'lubok-china', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '2.4326', '102.1127', '', '', 0),
(233, 145, 0, 'PRK', 'Lumut', '', 'lumut', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '4.317', '100.7977', '', '', 0),
(234, 145, 0, 'KDH', 'Lunas', '', 'lunas', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.5071', '100.5589', '', '', 0),
(235, 145, 0, 'SRW', 'Lundu', '', 'lundu', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '1.6733', '109.8363', '', '', 0),
(236, 145, 0, 'PHG', 'Lurah Bilut', '', 'lurah-bilut', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '3.6623', '101.9202', '', '', 0),
(237, 145, 0, 'SRW', 'Lutong', '', 'lutong', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '4.4803', '114.0108', '', '', 0),
(238, 145, 0, 'KTN', 'Machang', '', 'machang', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.7573', '102.2168', '', '', 0),
(239, 145, 0, 'PRK', 'Malim Nawar', '', 'malim-nawar', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '4.3844', '101.1174', '', '', 0),
(240, 145, 0, 'PRK', 'Mambang Di Awan', '', 'mambang-di-awan', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '4.4423', '101.1131', '', '', 0),
(241, 145, 0, 'PRK', 'Manong', '', 'manong', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '4.6523', '100.8827', '', '', 0),
(242, 145, 0, 'NSN', 'Mantin', '', 'mantin', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '2.8078', '101.9088', '', '', 0),
(243, 145, 0, 'TRG', 'Marang', '', 'marang', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.2424', '103.126', '', '', 0),
(244, 145, 0, 'JHR', 'Masai', '', 'masai', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '1.5558', '103.7616', '', '', 0),
(245, 145, 0, 'MLK', 'Masjid Tanah', '', 'masjid-tanah', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '2.3301', '102.1472', '', '', 0),
(246, 145, 0, 'PRK', 'Matang', '', 'matang', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '4.7804', '100.7247', '', '', 0),
(247, 145, 0, 'SRW', 'Matu', '', 'matu', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '2.6413', '111.4437', '', '', 0),
(248, 145, 0, 'MLK', 'Melaka', '', 'melaka', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '2.2019', '102.2518', '', '', 0),
(249, 145, 0, 'KTN', 'Melor', '', 'melor', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.92', '102.2742', '', '', 0),
(250, 145, 0, 'SBH', 'Membakut', '', 'membakut', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.5243', '115.6889', '', '', 0),
(251, 145, 0, 'PHG', 'Mentakab', '', 'mentakab', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '3.5435', '102.3122', '', '', 0),
(252, 145, 0, 'SBH', 'Menumbok', '', 'menumbok', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.3398', '115.3766', '', '', 0),
(253, 145, 0, 'KDH', 'Merbok', '', 'merbok', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.7262', '100.4529', '', '', 0),
(254, 145, 0, 'MLK', 'Merlimau', '', 'merlimau', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '2.198', '102.3718', '', '', 0),
(255, 145, 0, 'JHR', 'Mersing', '', 'mersing', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '2.3043', '103.7599', '', '', 0),
(256, 145, 0, 'SRW', 'Miri', '', 'miri', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '4.2678', '113.9692', '', '', 0),
(257, 145, 0, 'PHG', 'Muadzam Shah', '', 'muadzam-shah', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '3.2041', '102.8052', '', '', 0),
(258, 145, 0, 'JHR', 'Muar', '', 'muar', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '2.0051', '102.7335', '', '', 0),
(259, 145, 0, 'SRW', 'Mukah', '', 'mukah', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '2.4118', '112.0435', '', '', 0),
(260, 145, 0, 'SBH', 'Nabawan', '', 'nabawan', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '4.7676', '116.4017', '', '', 0),
(261, 145, 0, 'SRW', 'Nanga Medamit', '', 'nanga-medamit', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '2.5574', '113.0012', '', '', 0),
(262, 145, 0, 'SRW', 'Niah', '', 'niah', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '3.195', '112.6848', '', '', 0),
(263, 145, 0, 'PNG', 'Nibong Tebal', '', 'nibong-tebal', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.2141', '100.4518', '', '', 0),
(264, 145, 0, 'NSN', 'Nilai', '', 'nilai', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '2.8093', '101.8334', '', '', 0),
(265, 145, 0, 'JHR', 'Nusajaya', '', 'nusajaya', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '1.5014', '103.6439', '', '', 0),
(266, 145, 0, 'PLS', 'Padang Besar', '', 'padang-besar', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '6.5341', '100.31', '', '', 0),
(267, 145, 0, 'PRK', 'Padang Rengas', '', 'padang-rengas', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '4.8174', '100.8677', '', '', 0),
(268, 145, 0, 'KDH', 'Padang Serai', '', 'padang-serai', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.5331', '100.5534', '', '', 0),
(269, 145, 0, 'PHG', 'Padang Tengku', '', 'padang-tengku', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '4.1907', '102.0495', '', '', 0),
(270, 145, 0, 'JHR', 'Pagoh', '', 'pagoh', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '2.087', '102.8871', '', '', 0),
(271, 145, 0, 'TRG', 'Paka', '', 'paka', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '4.7314', '103.358', '', '', 0),
(272, 145, 0, 'JHR', 'Paloh', '', 'paloh', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '2.1593', '103.507', '', '', 0),
(273, 145, 0, 'SBH', 'Pamol', '', 'pamol', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '6.0793', '117.5024', '', '', 0),
(274, 145, 0, 'JHR', 'Panchor', '', 'panchor', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '2.0423', '102.9538', '', '', 0),
(275, 145, 0, 'PRK', 'Pangkor', '', 'pangkor', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '4.2597', '100.6095', '', '', 0),
(276, 145, 0, 'PRK', 'Pantai Remis', '', 'pantai-remis', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '4.5708', '100.6901', '', '', 0),
(277, 145, 0, 'SBH', 'Papar', '', 'papar', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.5174', '115.9036', '', '', 0),
(278, 145, 0, 'PRK', 'Parit', '', 'parit', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '4.5504', '100.9064', '', '', 0),
(279, 145, 0, 'PRK', 'Parit Buntar', '', 'parit-buntar', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '4.907', '100.6029', '', '', 0),
(280, 145, 0, 'JHR', 'Parit Jawa', '', 'parit-jawa', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '1.9152', '102.8197', '', '', 0),
(281, 145, 0, 'JHR', 'Parit Raja', '', 'parit-raja', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '1.8605', '103.1004', '', '', 0),
(282, 145, 0, 'JHR', 'Parit Sulong', '', 'parit-sulong', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '1.9663', '102.9015', '', '', 0),
(283, 145, 0, 'KTN', 'Pasir  Puteh', '', 'pasir-puteh', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.876', '102.3841', '', '', 0),
(284, 145, 0, 'JHR', 'Pasir Gudang', '', 'pasir-gudang', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '1.5002', '103.8273', '', '', 0),
(285, 145, 0, 'KTN', 'Pasir Mas', '', 'pasir-mas', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '6.0129', '102.1459', '', '', 0),
(286, 145, 0, 'PHG', 'Pekan', '', 'pekan', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '3.5374', '103.2801', '', '', 0),
(287, 145, 0, 'SGR', 'Pelabuhan Klang', '', 'pelabuhan-klang', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '3.0186', '101.4286', '', '', 0),
(288, 145, 0, 'PNG', 'Penaga', '', 'penaga', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.4632', '100.4027', '', '', 0),
(289, 145, 0, 'SBH', 'Penampang', '', 'penampang', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.8883', '116.1026', '', '', 0),
(290, 145, 0, 'PNG', 'Penang Hill', '', 'penang-hill', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.418', '100.2775', '', '', 0),
(291, 145, 0, 'KDH', 'Pendang', '', 'pendang', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.9623', '100.472', '', '', 0),
(292, 145, 0, 'JHR', 'Pengerang', '', 'pengerang', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '1.4656', '103.9435', '', '', 0),
(293, 145, 0, 'PRK', 'Pengkalan Hulu', '', 'pengkalan-hulu', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.4731', '101.0105', '', '', 0),
(294, 145, 0, 'PNG', 'Perai', '', 'perai', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.3769', '100.3848', '', '', 0),
(295, 145, 0, 'TRG', 'Permaisuri', '', 'permaisuri', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.4698', '102.8602', '', '', 0),
(296, 145, 0, 'PNG', 'Permatang Pauh', '', 'permatang-pauh', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.3934', '100.4107', '', '', 0),
(297, 145, 0, 'SGR', 'Petaling Jaya', '', 'petaling-jaya', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '3.107', '101.6305', '', '', 0),
(298, 145, 0, 'KDH', 'Pokok Sena', '', 'pokok-sena', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '6.1542', '100.5613', '', '', 0),
(299, 145, 0, 'JHR', 'Pontian', '', 'pontian', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '1.5666', '103.3873', '', '', 0),
(300, 145, 0, 'NSN', 'Port Dickson', '', 'port-dickson', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '2.5932', '101.8413', '', '', 0),
(301, 145, 0, 'SGR', 'Puchong', '', 'puchong', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '3.0757', '101.6198', '', '', 0),
(302, 145, 0, 'KTN', 'Pulai Chondong', '', 'pulai-chondong', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.8908', '102.2376', '', '', 0),
(303, 145, 0, 'SGR', 'Pulau Carey', '', 'pulau-carey', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '2.8879', '101.3913', '', '', 0),
(304, 145, 0, 'SGR', 'Pulau Ketam', '', 'pulau-ketam', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '2.9555', '101.3268', '', '', 0),
(305, 145, 0, 'PNG', 'Pulau Pinang', '', 'pulau-pinang', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.4166', '100.3305', '', '', 0),
(306, 145, 0, 'SRW', 'Pusa', '', 'pusa', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '1.6097', '111.4337', '', '', 0),
(307, 145, 0, 'NSN', 'Pusat  Bandar P', '', 'pusat-bandar-p', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '2.7184', '102.5765', '', '', 0),
(308, 145, 0, 'PRK', 'Pusing', '', 'pusing', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '4.5117', '100.9917', '', '', 0),
(309, 145, 0, 'SBH', 'Putatan', '', 'putatan', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.4204', '116.7968', '', '', 0),
(310, 145, 0, 'PJY', 'Putrajaya', '', 'putrajaya', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '2.9264', '101.6964', '', '', 0),
(311, 145, 0, 'SBH', 'Ranau', '', 'ranau', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.9589', '116.6402', '', '', 0),
(312, 145, 0, 'NSN', 'Rantau', '', 'rantau', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '2.589', '101.9629', '', '', 0),
(313, 145, 0, 'KTN', 'Rantau Panjang', '', 'rantau-panjang', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.9632', '102.0073', '', '', 0),
(314, 145, 0, 'SGR', 'Rasa', '', 'rasa', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '3.3861', '101.6093', '', '', 0),
(315, 145, 0, 'PHG', 'Raub', '', 'raub', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '3.7577', '101.9827', '', '', 0),
(316, 145, 0, 'SGR', 'Rawang', '', 'rawang', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '3.2549', '101.5705', '', '', 0),
(317, 145, 0, 'NSN', 'Rembau', '', 'rembau', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '2.5798', '102.1108', '', '', 0),
(318, 145, 0, 'JHR', 'Rengam', '', 'rengam', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '1.8498', '103.3555', '', '', 0),
(319, 145, 0, 'JHR', 'Rengit', '', 'rengit', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '1.664', '103.2453', '', '', 0),
(320, 145, 0, 'PHG', 'Ringlet', '', 'ringlet', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '4.2961', '101.5451', '', '', 0),
(321, 145, 0, 'SRW', 'Roban', '', 'roban', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '1.8838', '111.3155', '', '', 0),
(322, 145, 0, 'NSN', 'Rompin', '', 'rompin', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '2.694', '102.4612', '', '', 0),
(323, 145, 0, 'SGR', 'Sabak Bernam', '', 'sabak-bernam', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '3.6254', '101.0593', '', '', 0),
(324, 145, 0, 'SBH', 'Sandakan', '', 'sandakan', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.848', '117.9591', '', '', 0),
(325, 145, 0, 'SRW', 'Saratok', '', 'saratok', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '1.6629', '111.2076', '', '', 0),
(326, 145, 0, 'SRW', 'Sarikei', '', 'sarikei', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '2.0455', '111.5346', '', '', 0),
(327, 145, 0, 'PRK', 'Sauk', '', 'sauk', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '4.8496', '100.9456', '', '', 0),
(328, 145, 0, 'SRW', 'Sebauh', '', 'sebauh', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '2.7811', '112.6702', '', '', 0),
(329, 145, 0, 'SRW', 'Sebuyau', '', 'sebuyau', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '1.3337', '110.9275', '', '', 0),
(330, 145, 0, 'PHG', 'Sega', '', 'sega', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '3.9817', '101.9348', '', '', 0),
(331, 145, 0, 'JHR', 'Segamat', '', 'segamat', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '2.3134', '102.9786', '', '', 0),
(332, 145, 0, 'SGR', 'Sekinchan', '', 'sekinchan', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '3.3788', '101.2798', '', '', 0),
(333, 145, 0, 'PRK', 'Selama', '', 'selama', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '4.829', '100.8841', '', '', 0),
(334, 145, 0, 'MLK', 'Selandar', '', 'selandar', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '2.384', '102.3584', '', '', 0),
(335, 145, 0, 'PRK', 'Selekoh', '', 'selekoh', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '3.9955', '100.768', '', '', 0),
(336, 145, 0, 'KTN', 'Selising', '', 'selising', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.8899', '102.2958', '', '', 0),
(337, 145, 0, 'SGR', 'Semenyih', '', 'semenyih', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '2.9982', '101.8017', '', '', 0),
(338, 145, 0, 'JHR', 'Semerah', '', 'semerah', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '1.9075', '102.8813', '', '', 0),
(339, 145, 0, 'SBH', 'Semporna', '', 'semporna', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '4.4363', '118.5318', '', '', 0),
(340, 145, 0, 'JHR', 'Senai', '', 'senai', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '1.6446', '103.5973', '', '', 0),
(341, 145, 0, 'JHR', 'Senggarang', '', 'senggarang', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '1.8138', '103.0467', '', '', 0),
(342, 145, 0, 'SGR', 'Sepang', '', 'sepang', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '2.9765', '101.7067', '', '', 0),
(343, 145, 0, 'KDH', 'Serdang', '', 'serdang', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.4765', '100.5938', '', '', 0),
(344, 145, 0, 'NSN', 'Seremban', '', 'seremban', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '2.8109', '101.9012', '', '', 0),
(345, 145, 0, 'SGR', 'Serendah', '', 'serendah', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '3.23', '101.6374', '', '', 0),
(346, 145, 0, 'JHR', 'Seri Gading', '', 'seri-gading', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '1.8197', '103.2399', '', '', 0),
(347, 145, 0, 'SGR', 'Seri Kembangan', '', 'seri-kembangan', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '3.0383', '101.7094', '', '', 0),
(348, 145, 0, 'PRK', 'Seri Manjung', '', 'seri-manjung', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '4.602', '100.7979', '', '', 0),
(349, 145, 0, 'SRW', 'Serian', '', 'serian', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '1.2438', '110.2563', '', '', 0),
(350, 145, 0, 'KUL', 'Setapak', '', 'setapak', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '3.1876', '101.7102', '', '', 0),
(351, 145, 0, 'SGR', 'Shah Alam', '', 'shah-alam', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '3.0797', '101.5186', '', '', 0),
(352, 145, 0, 'NSN', 'Si Rusa', '', 'si-rusa', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '2.5099', '102.0049', '', '', 0),
(353, 145, 0, 'SRW', 'Sibu', '', 'sibu', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '2.2086', '111.6', '', '', 0),
(354, 145, 0, 'SRW', 'Siburan', '', 'siburan', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '1.3148', '110.3751', '', '', 0),
(355, 145, 0, 'KDH', 'Sik', '', 'sik', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.8207', '100.6951', '', '', 0),
(356, 145, 0, 'PRK', 'Simpang', '', 'simpang', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '4.7183', '100.7986', '', '', 0),
(357, 145, 0, 'PLS', 'Simpang Ampat', '', 'simpang-ampat', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '6.3155', '100.2026', '', '', 0),
(358, 145, 0, 'PRK', 'Simpang Ampat S', '', 'simpang-ampat-s', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '4.9211', '100.7084', '', '', 0),
(359, 145, 0, 'NSN', 'Simpang Durian', '', 'simpang-durian', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '3.0168', '102.1793', '', '', 0),
(360, 145, 0, 'KDH', 'Simpang Empat', '', 'simpang-empat', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '6.013', '100.4018', '', '', 0),
(361, 145, 0, 'NSN', 'Simpang Pertang', '', 'simpang-pertang', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '3.018', '102.3018', '', '', 0);
INSERT INTO `fc_cities` (`id`, `countryid`, `stateid`, `state_code`, `name`, `contid`, `seourl`, `status`, `featured`, `description`, `meta_title`, `meta_keyword`, `meta_description`, `citylogo`, `citythumb`, `mobile_citylogo`, `neighborhoods`, `tags`, `short_description`, `latitude`, `longitude`, `get_around`, `known_for`, `view_order`) VALUES
(362, 145, 0, 'JHR', 'Simpang Rengam', '', 'simpang-rengam', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '1.881', '103.3957', '', '', 0),
(363, 145, 0, 'SRW', 'Simunjan', '', 'simunjan', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '1.2657', '110.8125', '', '', 0),
(364, 145, 0, 'SBH', 'Sipitang', '', 'sipitang', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.0331', '115.5728', '', '', 0),
(365, 145, 0, 'PRK', 'Sitiawan', '', 'sitiawan', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '4.3227', '100.8021', '', '', 0),
(366, 145, 0, 'PRK', 'Slim River', '', 'slim-river', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '4.0303', '101.294', '', '', 0),
(367, 145, 0, 'SRW', 'Song', '', 'song', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '1.735', '112.533', '', '', 0),
(368, 145, 0, 'SRW', 'Spaoh', '', 'spaoh', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '1.6533', '111.5983', '', '', 0),
(369, 145, 0, 'SRW', 'Sri Aman', '', 'sri-aman', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '1.3177', '111.3894', '', '', 0),
(370, 145, 0, 'JHR', 'Sri Medan', '', 'sri-medan', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '1.5084', '103.7136', '', '', 0),
(371, 145, 0, 'SGR', 'Subang Airport', '', 'subang-airport', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '3.1851', '101.6275', '', '', 0),
(372, 145, 0, 'SGR', 'Subang Jaya', '', 'subang-jaya', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '3.0542', '101.5949', '', '', 0),
(373, 145, 0, 'SRW', 'Sundar', '', 'sundar', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '3.9777', '114.0651', '', '', 0),
(374, 145, 0, 'SGR', 'Sungai Ayer Taw', '', 'sungai-ayer-taw', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '3.776', '100.875', '', '', 0),
(375, 145, 0, 'SGR', 'Sungai Besar', '', 'sungai-besar', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '3.5615', '101.146', '', '', 0),
(376, 145, 0, 'SGR', 'Sungai Buloh', '', 'sungai-buloh', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '3.1618', '101.598', '', '', 0),
(377, 145, 0, 'PHG', 'Sungai Koyan', '', 'sungai-koyan', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '4.1582', '101.84', '', '', 0),
(378, 145, 0, 'PHG', 'Sungai Lembing', '', 'sungai-lembing', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '3.8104', '102.9129', '', '', 0),
(379, 145, 0, 'JHR', 'Sungai Mati', '', 'sungai-mati', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '1.5141', '103.7014', '', '', 0),
(380, 145, 0, 'SGR', 'Sungai Pelek', '', 'sungai-pelek', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '2.8526', '101.632', '', '', 0),
(381, 145, 0, 'KDH', 'Sungai Petani', '', 'sungai-petani', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.6639', '100.4902', '', '', 0),
(382, 145, 0, 'MLK', 'Sungai Rambai', '', 'sungai-rambai', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '2.1368', '102.5051', '', '', 0),
(383, 145, 0, 'MLK', 'Sungai Rambai\'', '', 'sungai-rambai', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '2.1368', '102.5051', '', '', 0),
(384, 145, 0, 'PRK', 'Sungai Siput', '', 'sungai-siput', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '4.9134', '101.0665', '', '', 0),
(385, 145, 0, 'PRK', 'Sungai Sumun', '', 'sungai-sumun', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '4.0448', '100.8621', '', '', 0),
(386, 145, 0, 'TRG', 'Sungai Tong', '', 'sungai-tong', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.2448', '102.8795', '', '', 0),
(387, 145, 0, 'MLK', 'Sungai Udang', '', 'sungai-udang', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '2.2867', '102.1406', '', '', 0),
(388, 145, 0, 'PRK', 'Sungkai', '', 'sungkai', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '4.112', '101.2529', '', '', 0),
(389, 145, 0, 'PRK', 'Taiping', '', 'taiping', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '4.7969', '100.7934', '', '', 0),
(390, 145, 0, 'SBH', 'Tambunan', '', 'tambunan', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.6933', '116.3797', '', '', 0),
(391, 145, 0, 'SBH', 'Tamparuli', '', 'tamparuli', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '6.117', '116.2675', '', '', 0),
(392, 145, 0, 'NSN', 'Tampin', '', 'tampin', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '2.5687', '102.1824', '', '', 0),
(393, 145, 0, 'KTN', 'Tanah Merah', '', 'tanah-merah', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.7687', '102.1201', '', '', 0),
(394, 145, 0, 'PHG', 'Tanah Rata', '', 'tanah-rata', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '4.3972', '101.4559', '', '', 0),
(395, 145, 0, 'JHR', 'Tangkak', '', 'tangkak', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '2.1462', '102.7848', '', '', 0),
(396, 145, 0, 'PNG', 'Tanjong Bungah', '', 'tanjong-bungah', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.4515', '100.2943', '', '', 0),
(397, 145, 0, 'NSN', 'Tanjong Ipoh', '', 'tanjong-ipoh', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '2.73', '102.1526', '', '', 0),
(398, 145, 0, 'SGR', 'Tanjong Karang', '', 'tanjong-karang', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '3.316', '101.3201', '', '', 0),
(399, 145, 0, 'MLK', 'Tanjong Kling', '', 'tanjong-kling', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '2.2376', '102.1588', '', '', 0),
(400, 145, 0, 'PRK', 'Tanjong Malim', '', 'tanjong-malim', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '3.9159', '101.3812', '', '', 0),
(401, 145, 0, 'PRK', 'Tanjong Piandan', '', 'tanjong-piandan', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '4.9011', '100.5731', '', '', 0),
(402, 145, 0, 'PRK', 'Tanjong Rambuta', '', 'tanjong-rambuta', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '4.5601', '101.1448', '', '', 0),
(403, 145, 0, 'SGR', 'Tanjong Sepat', '', 'tanjong-sepat', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '2.7691', '101.5625', '', '', 0),
(404, 145, 0, 'PRK', 'Tanjong Tualang', '', 'tanjong-tualang', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '4.3912', '101.0461', '', '', 0),
(405, 145, 0, 'SBH', 'Tanjung Aru', '', 'tanjung-aru', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.9771', '116.0678', '', '', 0),
(406, 145, 0, 'PRK', 'Tapah', '', 'tapah', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '4.3279', '101.1595', '', '', 0),
(407, 145, 0, 'PRK', 'Tapah Road', '', 'tapah-road', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '4.2684', '101.1236', '', '', 0),
(408, 145, 0, 'PNG', 'Tasek Gelugor', '', 'tasek-gelugor', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.4558', '100.4549', '', '', 0),
(409, 145, 0, 'PNG', 'Tasek Gelugur', '', 'tasek-gelugur', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.2632', '100.4846', '', '', 0),
(410, 145, 0, 'SRW', 'Tatau', '', 'tatau', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '2.5733', '112.6906', '', '', 0),
(411, 145, 0, 'SBH', 'Tawau', '', 'tawau', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '4.2901', '117.8994', '', '', 0),
(412, 145, 0, 'SGR', 'Telok Panglima ', '', 'telok-panglima', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '3.0195', '101.5246', '', '', 0),
(413, 145, 0, 'PRK', 'Teluk Intan', '', 'teluk-intan', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '4.1739', '101.0194', '', '', 0),
(414, 145, 0, 'KTN', 'Temangan', '', 'temangan', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.7612', '102.1769', '', '', 0),
(415, 145, 0, 'PHG', 'Temerloh', '', 'temerloh', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '3.484', '102.4266', '', '', 0),
(416, 145, 0, 'PRK', 'Temoh', '', 'temoh', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '4.3504', '101.1622', '', '', 0),
(417, 145, 0, 'SBH', 'Tenghilan', '', 'tenghilan', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.9977', '116.529', '', '', 0),
(418, 145, 0, 'SBH', 'Tenom', '', 'tenom', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '4.9839', '115.93', '', '', 0),
(419, 145, 0, 'PRK', 'TLDM Lumut', '', 'tldm-lumut', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '4.8073', '100.8', '', '', 0),
(420, 145, 0, 'PHG', 'Triang', '', 'triang', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '3.4051', '102.6233', '', '', 0),
(421, 145, 0, 'PRK', 'Trolak', '', 'trolak', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '3.9577', '101.3342', '', '', 0),
(422, 145, 0, 'PRK', 'Trong', '', 'trong', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '4.6539', '100.7739', '', '', 0),
(423, 145, 0, 'PRK', 'Tronoh', '', 'tronoh', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '4.4306', '101.014', '', '', 0),
(424, 145, 0, 'SBH', 'Tuaran', '', 'tuaran', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '6.132', '116.2069', '', '', 0),
(425, 145, 0, 'KTN', 'Tumpat', '', 'tumpat', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '6.1411', '102.1763', '', '', 0),
(426, 145, 0, 'PRK', 'Ulu Bernam', '', 'ulu-bernam', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '3.9111', '101.2078', '', '', 0),
(427, 145, 0, 'PRK', 'Ulu Kinta', '', 'ulu-kinta', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '4.6008', '101.1007', '', '', 0),
(428, 145, 0, 'JHR', 'Ulu Tiram', '', 'ulu-tiram', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '1.6728', '103.6325', '', '', 0),
(429, 145, 0, 'KDH', 'Universiti Utar', '', 'universiti-utar', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '6.4574', '100.506', '', '', 0),
(430, 145, 0, 'PNG', 'USM Pulau Pinan', '', 'usm-pulau-pinan', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.3572', '100.3055', '', '', 0),
(431, 145, 0, 'KTN', 'Wakaf Bharu', '', 'wakaf-bharu', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '6.0573', '102.1743', '', '', 0),
(432, 145, 0, 'KDH', 'Yan', '', 'yan', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '5.8366', '100.4039', '', '', 0),
(433, 145, 0, 'JHR', 'Yong Peng', '', 'yong-peng', 'Active', '0', '', '', '', '', '', '', '', '', '', '', '1.9139', '103.1326', '', '', 0),
(434, 215, 4, '', 'azil', '', 'azil', 'Active', '0', '', '', '', '', '1430899199-Penguins.jpg', 'Penguins.jpg', '', '0', '', '', '34.04893', '-111.09373', '', '', 1),
(435, 215, 4, '', 'Brickworks estate', '', 'brickworks-estate', 'Active', '0', '', '', '', '', '1430997868-Chrysanthemum.jpg', 'Chrysanthemum.jpg', '', '0', '', '', '37.77264', '-122.40992', '', '', 0),
(436, 40, 0, '', 'Zurich', '', 'zurich', 'Active', '0', '', '', '', '', '1467198155-zurich.jpg', 'zurich.jpg', '', '0', '', '', '40.71278', '-74.00594', '', '', 2),
(437, 215, 39, '', 'Los Vegas', '', 'los-vegas', 'Active', '0', '', '', '', '', '1467198731-los-vegas.jpg', 'los-vegas.jpg', '', '0', '', '', '37.77493', '-122.41942', '', '', 3),
(438, 70, 886, '', 'London', '', 'london', 'Active', '1', '', '', '', '', '1517774390-london.jpg', 'london.jpg', '', '0', '', '', '47.60621', '-122.33207', '', '', 1),
(445, 95, 865, '', 'Mumbai', '', 'mumbai', 'Active', '0', '', '', '', '', '1470557507-mumbai2.jpg', 'mumbai2.jpg', '', '0', '', '', '19.07598', '72.87766', '', '', 5),
(439, 12, 182, '', 'Sydney', '', 'sydney', 'Active', '0', '', '', '', '', '1467197975-sidney.jpg', 'sidney.jpg', '', '0', '', '', '29.76043', '-95.36980', '', '', 1),
(440, 44, 863, '', 'Beijing', '', 'beijing', 'Active', '0', '', '', '', '', '1467198689-china.jpg', 'china.jpg', '', '0', '', '', '40.73566', '-74.17237', '', '', 4),
(442, 215, 18, '', 'Miami', '', 'miami', 'Active', '1', '', '', '', '', '1517770708-miami2.jpg', 'miami2.jpg', '', '0', '', '', '37.77264', '-122.40992', '', '', 4),
(444, 95, 864, '', 'Kochi', '', 'kochi', 'InActive', '1', '', '', '', '', '1470553861-kerala.jpg', 'kerala.jpg', '', '0', '', '', '9.93123', '76.26730', '', '', 0),
(443, 0, 0, '', 'Vatican City', '', 'vatican-city', 'Active', '0', '', '', '', '', '1467198774-vatican-city.jpg', 'vatican-city.jpg', '', '0', '', '', '37.77264', '-122.40992', '', '', 6),
(446, 95, 866, '', 'Hydrabad', '', 'hydrabad', 'InActive', '1', '', '', '', '', '1470555402-hydreabad.jpg', 'hydreabad.jpg', '', '0', '', '', '17.38504', '78.48667', '', '', 13),
(447, 95, 875, '', 'Ooty', '', 'ooty', 'Active', '0', '', '', '', '', '1484316836-Ooty.jpg', 'Ooty.jpg', '', '0', '', '', '11.40641', '76.69324', '', '', 16),
(448, 95, 867, '', 'Bangaluru', '', 'bangaluru', 'InActive', '1', '', '', '', '', '1470556169-mysore.jpg', 'mysore.jpg', '', '0', '', '', '12.97160', '77.59456', '', '', 14),
(449, 95, 868, '', 'Agra', '', 'agra', 'InActive', '1', '', '', '', '', '1470555129-agra2.jpg', 'agra2.jpg', '', '0', '', '', '27.17667', '78.00807', '', '', 8),
(450, 95, 869, '', 'Rajkot', '', 'rajkot', 'InActive', '1', '', '', '', '', '1470556949-rajkot.jpg', 'rajkot.jpg', '', '0', '', '', '22.30389', '70.80216', '', '', 9),
(452, 29, 870, '', 'Campo Belo, SP', '', 'campo-belo-sp', 'InActive', '1', '', '', '', '', '1489092585-camarao-festival.jpg', 'camarao-festival.jpg', '', '0', '', '', '-23.62203', '-46.67202', '', '', 0),
(453, 29, 870, '', 'Sao Paulo', '', 'sao-paulo', 'InActive', '1', '', '', '', '', '1489092647-galeria-sao-paulo-ponte-estaiada01-credito-thinkstock-186232464.jpg', 'galeria-sao-paulo-ponte-estaiada01-credito-thinkstock-186232464.jpg', '', '0', '', '', '-23.55052', '-46.63331', '', '', 0),
(454, 215, 862, '', 'Los angeles', '', 'los-angeles', 'InActive', '1', '', '', '', '', '1517772513-los.jpg', 'los.jpg', '', '0', '', '', '37.77264', '-122.40992', '', '', 0),
(455, 91, 0, '', 'medan', '', 'medan', 'InActive', '1', '', '', '', '', '1502276078-Medan.jpg', 'Medan.jpg', '', '0', '', '', '37.77264', '-122.40992', '', '', 10),
(456, 12, 888, '', 'melbourne', '', 'melbourne', 'Active', '1', '', '', '', '', '1518728726-melbourne1.jpg', 'melbourne1.jpg', '', '0', '', '', '37.77264', '-122.40992', '', '', 2),
(457, 105, 0, '', 'nairobi', '', 'nairobi', 'Active', '1', '', '', '', '', '1502286826-nairobi.jpg', 'nairobi.jpg', '', '0', '', '', '37.77264', '-122.40992', '', '', 6),
(458, 51, 0, '', 'Essen', '', 'essen', 'InActive', '1', '', '', '', '', '1502286979-essan.jpg', 'essan.jpg', '', '0', '', '', '37.77264', '-122.40992', '', '', 17),
(459, 95, 860, '', 'coimbatore', '', 'coimbatore', 'Active', '0', '', '', '', '', '1497609088-Chrysanthemum.jpg', 'Chrysanthemum.jpg', '', '0', '', '', '11.01684', '76.95583', '', '', 0),
(461, 150, 885, '', 'Lagos', '', 'lagos', 'Active', '1', '', '', '', '', '1517771142-lagos.jpg', 'lagos.jpg', '', '0', '', '', '6.52438', '3.37921', '', '', 5),
(462, 215, 19, '', 'Duluth', '', 'duluth', 'InActive', '1', '', '', '', '', '1518807938-duluth.jpg', 'duluth.jpg', '', '0', '', '', '34.00288', '-84.14464', '', '', 4),
(463, 228, 889, '', 'Johannesburg', '', 'johannesburg', 'Active', '1', '', '', '', '', '1526665352-johanesburg.jpg', 'johanesburg.jpg', '', '0', '', '', '', '', '', '', 2),
(464, 215, 39, '', 'Las Vegas', '', 'las-vegas', 'InActive', '1', '', '', '', '', '1536610125-los-vegas.jpg', 'los-vegas.jpg', '', '0', '', '', '', '', '', '', 0),
(465, 215, 21, '', 'Hawaii', '', 'hawaii', 'Active', '1', '', '', '', '', '1536613340-Hawaii.jpg', 'Hawaii.jpg', '', '0', '', '', '', '', '', '', 0),
(466, 215, 43, '', 'New York', '', 'new-york', 'Active', '1', '', '', '', '', '1541111767-newyork.jpg', 'newyork.jpg', '', '0', '', '', '', '', '', '', 0),
(467, 2, 890, '', 'Dubai', '', 'dubai', 'Active', '1', '', '', '', '', '1591215762-dubai.jpg', 'dubai.jpg', '', '0', '', '', '', '', '', '', 0),
(468, 59, 891, '', 'Cairo', '', 'cairo', 'Active', '1', '', '', '', '', '1608499132-Cairo1.jpg', 'Cairo1.jpg', '', '0', '', '', '', '', '', '', 0);

-- --------------------------------------------------------

--
-- Table structure for table `fc_city_locations`
--

CREATE TABLE `fc_city_locations` (
  `id` int(11) NOT NULL,
  `countryid` int(11) NOT NULL,
  `stateid` int(11) NOT NULL,
  `state_code` varchar(32) NOT NULL,
  `name` varchar(32) NOT NULL,
  `city` varchar(50) NOT NULL,
  `contid` varchar(50) NOT NULL,
  `seourl` varchar(250) NOT NULL,
  `status` enum('InActive','Active') NOT NULL,
  `featured` enum('0','1') NOT NULL,
  `description` longblob NOT NULL,
  `meta_title` varchar(1000) NOT NULL,
  `meta_keyword` varchar(1000) NOT NULL,
  `meta_description` blob NOT NULL,
  `citylogo` varchar(1000) NOT NULL,
  `citythumb` varchar(1000) NOT NULL,
  `mobile_citylogo` varchar(500) NOT NULL,
  `neighborhoods` varchar(1000) NOT NULL,
  `tags` varchar(1000) NOT NULL,
  `short_description` varchar(1000) NOT NULL,
  `latitude` varchar(1000) NOT NULL,
  `longitude` varchar(1000) NOT NULL,
  `get_around` varchar(1000) NOT NULL,
  `known_for` varchar(1000) NOT NULL,
  `view_order` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `fc_cms`
--

CREATE TABLE `fc_cms` (
  `id` int(200) NOT NULL,
  `page_name` varchar(500) NOT NULL,
  `page_title` varchar(200) NOT NULL,
  `section` varchar(50) NOT NULL,
  `seourl` varchar(1000) NOT NULL,
  `hidden_page` enum('Yes','No') NOT NULL DEFAULT 'No',
  `category` enum('Main','Sub') NOT NULL DEFAULT 'Main',
  `parent` int(11) NOT NULL DEFAULT '0',
  `meta_tag` varchar(500) NOT NULL,
  `meta_description` blob NOT NULL,
  `description` blob NOT NULL,
  `status` enum('Publish','UnPublish') NOT NULL,
  `meta_title` varchar(1000) NOT NULL,
  `lang_code` varchar(120) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `fc_cms`
--

INSERT INTO `fc_cms` (`id`, `page_name`, `page_title`, `section`, `seourl`, `hidden_page`, `category`, `parent`, `meta_tag`, `meta_description`, `description`, `status`, `meta_title`, `lang_code`) VALUES
(1, 'Privacy Policy', 'Privacy Policy', '', 'privacy-policy', 'No', 'Main', 0, '', '', 0x[encoded data, 9822 characters], 'Publish', 'Privacy Policy', 'en');
INSERT INTO `fc_cms` (`id`, `page_name`, `page_title`, `section`, `seourl`, `hidden_page`, `category`, `parent`, `meta_tag`, `meta_description`, `description`, `status`, `meta_title`, `lang_code`) VALUES
(2, 'Terms of Service', 'Terms of Service', 'company', 'terms-of-service', 'No', 'Main', 0, '', '', 0x[encoded data, 79218 characters], 'Publish', 'Terms of Service', 'en');
INSERT INTO `fc_cms` (`id`, `page_name`, `page_title`, `section`, `seourl`, `hidden_page`, `category`, `parent`, `meta_tag`, `meta_description`, `description`, `status`, `meta_title`, `lang_code`) VALUES
(3, 'Cancellation Policy', 'Cancellation Policy', 'services', 'cancellation-policy', 'No', 'Main', 0, 'cancellation policies', 0x48616c61686f7374732043616e63656c6c6174696f6e20506f6c6963696573, 0x[encoded data, 4336 characters], 'Publish', 'Halahosts Cancellation Policies', 'en'),
(4, 'About Halalhosts', 'About Halalhosts', '', 'about', 'No', 'Main', 0, 'Halahosts', 0x48616c61686f737473, 0x3c7020636c6173733d226669727374223e3c7370616e3e48616c616c686f73747320697320612066616974682d6261736564206f6e6c696e6520706c6174666f726d20666f72204d75736c696d732074726176656c65727320616e6420686f7374732e2048616c61686f73747320656e61626c6573204d75736c696d7320696e20636974696573206163726f73732074686520776f726c6420746f206c69737420756e6971756520616e642020616d617a696e67266e6273703b6163636f6d6d6f646174696f6e732c20657870657269656e63657320616e6420616476656e74757265732c207768696c6520656e61626c696e67204d75736c696d2074726176656c65727320776f726c647769646520746f20646973636f7665722c20626f6f6b20616e642020657870657269656e6365266e6273703b73756368206163636f6d6d6f646174696f6e732c20657870657269656e63657320616e6420616476656e7475726573207768696c65206f6e266e6273703b627573696e6573732c2063617375616c2c207661636174696f6e20616e6420686f6c696461792074726970732e3c2f7370616e3e3c6272202f3e3c6272202f3e3c7370616e3e41742048616c616c686f7374732c266e6273703b41706172746d656e74732c20486f757365732c2042726561642026616d703b20427265616b666173742c205661636174696f6e2052656e74616c732c202056696c6c61732c266e6273703b436162696e732c204c75787572792050726f706572746965732c20427567616c6f77732c2043616d7065722f5256732c20436173746c65732c20204368616c6574732c20436f61636865732c20436f6e646f732c20456172746820486f757365732c20486f74656c732c20487574732c204c6f6674732c2020547265652d686f757365732c2054726970692c204c69676874686f757365732c20266e6273703b426f6174732c20547261696e732c20506c616e65732c2056616e732c2059757274732c2020416476656e74757265732c2041757468656e6974696320466f6f6420457870657269656e63657320616e64206d6f72652063616e206265206c697374656420627920686f7374732c207768696c6520656e61626c696e67202074726176656c65727320286775657374732920746f2066696e6420616e6420626f6f6b2073756368206c697374696e677320666f72207661636174696f6e2c2020627573696e6573732c2063617375616c2c20686f6c69646179206f7220747269707320616e6420746f757269736d20696e206f7665722033302c30303020636974696573202061726f756e642074686520576f726c642e3c2f7370616e3e3c2f703e, 'Publish', 'Halahosts', 'en'),
(5, 'Press', 'Press', 'company', 'press', 'Yes', 'Main', 0, '', '', 0x3c703e48616c616c686f7374732050726573732052656c65617365733c2f703e, 'Publish', 'Press', 'en'),
(7, 'Trust And Safety', 'Trust And Safety', 'services', 'trust-and-safety', 'No', 'Main', 0, '', '', 0x[encoded data, 9994 characters], 'Publish', 'Trust And Safety', 'en'),
(9, 'Jobs', 'Jobs', 'services', 'job', 'No', 'Main', 0, '', '', 0x3c703e4e6f206a6f62732063757272656e746c7920617661696c61626c6520617420746869732074696d652e20506c6561736520636865636b206261636b206c617465722e3c2f703e, 'Publish', 'Jobs', 'en'),
(34, 'Services', 'Services', 'services', 'service1', 'No', 'Main', 0, '', '', '', 'UnPublish', '', 'en');
INSERT INTO `fc_cms` (`id`, `page_name`, `page_title`, `section`, `seourl`, `hidden_page`, `category`, `parent`, `meta_tag`, `meta_description`, `description`, `status`, `meta_title`, `lang_code`) VALUES
(10, 'How it Works', 'How The Platform Works', '', 'how-it-works', 'No', 'Main', 0, '', '', 0x[encoded data, 48096 characters], 'Publish', 'How it Works', 'en'),
(12, 'Pol?tica de privacidad', 'Pol?tica de privacidad', '', 'privacy-policy', 'No', 'Main', 0, '', '', '', 'Publish', '', 'es'),
(13, ' T?rminos de servicio', ' T?rminos de servicio', '', 'terms-of-service', 'No', 'Main', 0, '', '', '', 'Publish', '', 'es'),
(14, 'Pol?tica de cancelaci?n', '', '', 'cancellation-policy', 'No', 'Main', 0, '', '', '', 'Publish', '', 'es'),
(15, 'Sobre nosotros', 'Sobre nosotros', '', 'about', 'No', 'Main', 0, '', '', '', 'Publish', '', 'es'),
(16, ' prensa', ' prensa', '', 'press', 'No', 'Main', 0, '', '', '', 'Publish', '', 'es'),
(17, ' Confianza y Seguridad', ' Confianza y Seguridad', '', 'please-choose-main-page', 'No', 'Main', 0, '', '', '', 'Publish', '', 'Please Choose Language'),
(18, ' trabajo', ' trabajo', '', 'job', 'No', 'Main', 0, '', '', '', 'Publish', '', 'es'),
(19, 'C?mo funciona', 'C?mo funciona', '', 'how-it-works', 'No', 'Main', 0, '', '', '', 'Publish', '', 'es'),
(20, ' prueba', ' prueba', 'row )->secti \'discover\')echo \'selected=\"selected\"\'', 'test', 'No', 'Main', 0, '', '', '', 'Publish', '', 'es'),
(22, 'pagetêîô', 'pagetêîôêîô', '', 'privacy-policy', 'No', 'Main', 0, '', '', '', 'Publish', '', 'fr'),
(23, 'testêîô', 'êîôêîôtest', '', 'test', 'No', 'Main', 0, '', '', '', 'Publish', '', 'fr'),
(24, 'j', '', '', 'please-choose-main-page', 'No', 'Main', 0, '', '', '', 'Publish', '', 'Please Choose Language'),
(25, 'page', '', '', 'cancellation-policy', 'No', 'Main', 0, '', '', '', 'Publish', '', 'Please Choose Language');
INSERT INTO `fc_cms` (`id`, `page_name`, `page_title`, `section`, `seourl`, `hidden_page`, `category`, `parent`, `meta_tag`, `meta_description`, `description`, `status`, `meta_title`, `lang_code`) VALUES
(26, 'k', '', '', 'please-choose-main-page', 'No', 'Main', 0, '', '', '', 'Publish', '', 'Please Choose Language'),
(30, 'tt', '', '', 'privacy-policy', 'No', 'Main', 0, '', '', '', 'Publish', '', 'ca'),
(31, 'Local Taxes', 'Local Taxes', '', 'local-taxes', 'Yes', 'Main', 0, '', '', 0x3c703e3c7370616e3e4c6f63616c20617574686f72697469657320696e20736f6d65206369746965732061726f756e642074686520776f726c64206d617920696d706f7365207461786573206f6e20726f6f6d2072656e74616c2e20576520656e636f757261676520486f7374206d656d6265727320746f20636865636b2077697468207468656972206c6f63616c20617574686f72697469657320666f7220617070726f707269617465206c6f63616c2074617865732077686572657665722074686579206170706c7920746f20726f6f6d2072656e74616c7320696e207468656972206c6f63616c697469657320616e642070617920746f207468656d20617070726f7072696174656c792e205468657365207461786573206d6179206265206b6e6f776e20617320746f7572697374207461782c20726f6f6d207461782c20686f74656c207461782c20757365207461782c20626564207461782c206f63637570616e6379207461782c2073616c657320746178206f72206c6f6467696e67207461782e3c2f7370616e3e3c2f703e, 'Publish', 'Local Taxes', 'en'),
(32, 'Acceptable Use Policy', 'Acceptable Use Policy', '', 'acceptable-use-policy', 'No', 'Main', 0, 'acceptable use policy', '', 0x[encoded data, 16932 characters], 'Publish', 'Acceptable Use Policy', 'en'),
(33, 'Popular Events', 'Popular Events', '', 'popular-events', 'Yes', 'Main', 0, 'events, popular events', 0x6576656e74732c20706f70756c6172206576656e7473, '', 'Publish', 'Popular Events', 'en');

-- --------------------------------------------------------

--
-- Table structure for table `fc_commission`
--

CREATE TABLE `fc_commission` (
  `id` int(10) NOT NULL,
  `commission_type` varchar(250) NOT NULL,
  `commission_percentage` varchar(200) NOT NULL,
  `promotion_type` enum('flat','percentage') NOT NULL,
  `status` enum('Active','Inactive') NOT NULL,
  `seo_tag` varchar(50) NOT NULL,
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `fc_commission`
--

INSERT INTO `fc_commission` (`id`, `commission_type`, `commission_percentage`, `promotion_type`, `status`, `seo_tag`, `created`) VALUES
(1, 'Host Listing', '3', 'flat', 'Inactive', 'host-listing', '2018-03-02 06:43:50'),
(2, 'Guest Booking', '7', 'percentage', 'Active', 'guest-booking', '2018-06-12 20:10:31'),
(5, 'Host invite', '0', 'percentage', 'Active', 'host_invite_accept', '2018-02-12 18:36:32'),
(6, 'Guest Invite', '0', 'percentage', 'Active', 'guest_invite_accept', '2018-02-12 18:38:28'),
(7, 'Experience Listing', '10', 'flat', 'Inactive', 'experience_listing', '2018-03-05 23:39:12'),
(8, 'Experience Booking', '10', 'percentage', 'Active', 'experience_booking', '2017-08-10 06:03:53'),
(9, 'Host Accept The Reservation Request', '3', 'percentage', 'Active', 'host-accept', '2018-03-22 20:34:50'),
(10, 'Experience Host Fee', '10', 'percentage', 'Active', 'experience-host-fee', '2018-03-22 20:33:15');

-- --------------------------------------------------------

--
-- Table structure for table `fc_commission_paid`
--

CREATE TABLE `fc_commission_paid` (
  `id` int(11) NOT NULL,
  `host_email` varchar(250) NOT NULL,
  `amount` varchar(155) NOT NULL,
  `transaction_id` varchar(250) NOT NULL,
  `status` enum('Pending','Paid') NOT NULL DEFAULT 'Pending',
  `dateAdded` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `fc_commission_rep_tracking`
--

CREATE TABLE `fc_commission_rep_tracking` (
  `id` int(10) NOT NULL,
  `host_email` varchar(255) NOT NULL,
  `booking_no` varchar(255) NOT NULL,
  `total_amount` float(10,2) NOT NULL,
  `guest_fee` float(10,2) NOT NULL,
  `host_fee` float(10,2) NOT NULL,
  `rep_fee` varchar(255) NOT NULL,
  `payable_amount` float(10,2) NOT NULL,
  `paid_status` enum('yes','no') NOT NULL DEFAULT 'no',
  `code` varchar(255) NOT NULL,
  `dataAdded` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `status` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
