<?php
// Get data from form 
$username = $_POST['username'];


$updateASuSid= $_POST['agencyid'];

$password= $_POST['password'];

$dbname = "prathamtour_db";

$mysqli = new mysqli("localhost","prathamtour_user","ONpdKiSM5rEsMTJF#$%^&",$dbname);

if ($mysqli -> connect_errno) {
  echo "Failed to connect to MySQL: " . $mysqli -> connect_error;
  exit();
}
 
if($password == '12345' &&  $updateASuSid != NULL) {

$tbl_travelogues_insert = $mysqli -> query("INSERT INTO `admin_user` (`firstname`, `lastname`, `email`, `username`, `password`, `created`, `modified`, `logdate`, `is_active`, `role`, `AgencySysId`) VALUES
('$username', '$username', 'info@$username.com', '$username', '03810ff365fbdd67751b5148d76b51ed', '2022-04-11 12:49:35', NULL, NULL, 1, 'admin', $updateASuSid)");

$tbl_travelogues_insert = $mysqli -> query("INSERT INTO `tbl_common_box` (`common_id`, `common_content_header`, `common_content`, `status`, `metaTitle`, `Keyword`, `Description`, `common_content_header_1`, `common_content_header_2`, `common_content_header_3`, `common_content_footer_1`, `common_content_footer_2`, `common_content_footer_3`, `AgencySysId`) VALUES (NULL, 'common_content_header', '', '1', '', '', '', '', '', '', '', '', '', $updateASuSid)");


$tbl_travelogues_insert = $mysqli -> query("INSERT INTO `tbl_travelogues` (`TravTitle`, `BlogIdentifier`, `TravImage`, `TravBannerImage`, `TravDestination`, `TravUploadedBy`, `TravDate`, `TravDays`, `TravTraveller`, `TravCost`, `TravDescription`, `CreateDate`, `UpdateDate`, `TravMultiImage`, `TravIdentifier`, `keyword`, `description`, `metatag`, `status`, `tags`, `displayOnBanner`, `displayOnSaudi`, `isMarkForDel`, `category`, `selectedPackages`, `BlogDescription`, `AgencySysId`) VALUES
('Honeymoon ', NULL, '', '', NULL, 'prince', '2022-04-07', NULL, NULL, NULL, '', '2022-04-04 15:33:25', NULL, NULL, 'honeymoon-', '', '', '', 1, '', 1, '1', 0, 1, '[\"24\",\"23\"]', NULL, $updateASuSid)");
	

$tbl_travelogues_insert = $mysqli -> query("INSERT INTO `tbl_our_services` (`serviceTitle`, `serviceIdentifier`, `serviceDescription`, `bannerImage`, `metatag`, `keyword`, `description`, `isActive`, `isMarkForDel`, `AgencySysId`) VALUES
('Cab Services', 'cab-services', 'FOR CAB SERVICES KINDLY FILL IN THIS INFO.', '', 'CAB SERVICES ', '', '', '1', '0', $updateASuSid),
('Bus services ', 'bus-services-', '', '', '', '', '', '1', '0', $updateASuSid)");	
	
$tbl_travelogues_insert = $mysqli -> query("INSERT INTO `tb_homebanner_detail` (`image`, `heading`, `description`, `url`, `opt`, `isb2b`, `isDisplayOnHome`, `isDisplayOnBanner`, `status`, `isMarkForDel`, `AgencySysId`) VALUES
('', 'Bangkok', 'Bangkok', '', 0, '0', 1, '0', 1, 0, $updateASuSid),
('', 'Maldives', 'Maldives', '', 0, '0', 1, '0', 1, 0, $updateASuSid)");

$tbl_travelogues_insert = $mysqli -> query("INSERT INTO `tbl_offers` (`category`, `heading`, `image`, `subHeading`, `expiryDate`, `isb2b`, `url`, `tab`, `isActive`, `isMarkForDel`, `status`, `AgencySysId`) VALUES
(1, 'DUBAI PACKAGE ', '', '', '2022-04-30', '0', '', NULL, '1', '0', '1', $updateASuSid)");
	
$tbl_travelogues_insert = $mysqli -> query("INSERT INTO `tbl_static_pages` (`page_title`, `identifier`, `page_description`, `short_description`, `meta_title`, `meta_keywords`, `meta_description`, `background_image`, `status`, `description`, `displayOnFooter`, `createdOn`, `updatedOn`, `masterCategory`, `isb2b`, `AgencySysId`) VALUES
('ABOUT US', 'about-us', '<h3><br></h3>', '', '', 'About Travnet', '', '161_1643362368.jpg', 'Activate', '', '1', '2018-01-12 00:00:00', '2022-06-13 13:05:24', 0, 0, $updateASuSid),
('REFUND POLICY', 'refund-policy', 'REFUND POLICY', '', 'REFUND POLICY', 'REFUND POLICY', 'REFUND POLICY', '', 'Activate', '', '1', '2018-01-12 00:00:00', '2022-04-14 14:00:17', 0, 0, $updateASuSid),
('PRIVACY POLICY', 'privacy-policy', 'PRIVACY POLICY', '', 'PRIVACY POLICY', 'PRIVACY POLICY', 'PRIVACY POLICY', '', 'Activate', '', '1', '2018-01-12 00:00:00', '2022-04-14 14:02:12', 0, 0, $updateASuSid),
('INTERNATIONAL TOUR PACKAGES', 'international-tour-packages', '<p>International Tour Packages<br></p>', '', 'International Tour Packages', 'International Tour Packages', 'International Tour Packages', '', 'Activate', '', '1', '2018-04-12 15:25:37', '2022-01-31 18:23:07', 0, 0, $updateASuSid),
('OFFERS', 'offers', '<p><br></p>', '', 'Offer', 'Offer', 'Offer', '', 'Activate', '', '1', '2018-04-12 15:32:14', '2022-04-04 13:44:23', 0, 0, $updateASuSid),
('CONTACT US', 'contact-us', '<p>CONTACT US</p>', '', 'CONTACT US', 'CONTACT US', 'CONTACT US', '', 'Activate', '', '1', '2018-08-13 18:02:55', '2022-01-28 15:09:40', 0, 0, $updateASuSid),
('DOMESTIC TOUR PACKAGES', 'domestic-tour-packages', '<p>Domestic Tour Packages</p>', '', 'Domestic Tour Packages', 'Domestic Tour Packages', 'Domestic Tour Packages', '', 'Activate', '', '1', '2019-08-10 00:00:00', '2022-04-04 13:41:11', 0, 0, $updateASuSid),
('TRAVELOGUE', 'travelogue', '<p>BLOG</p>', '', 'BLOG', 'BLOG', 'BLOG', '', 'Activate', '', '1', '2019-08-12 11:45:58', '2022-04-07 11:00:51', 2, 0, $updateASuSid),
('Terms Of Use', 'terms-of-use', 'Terms Of Use', '', 'Terms Of Use', 'Terms Of Use', 'Terms Of Use', '', 'Activate', '', '1', '2018-01-12 00:00:00', '2022-04-14 14:02:12', 0, 0, $updateASuSid)");

$tbl_travelogues_insert = $mysqli -> query("INSERT INTO `tbl_query` (`email`, `secondEmail`, `phone`, `mobile`, `location`, `otherLocations`, `status`, `whatsapp_no`, `broucher`, `image`, `google_map`, `AgencySysId`) VALUES
('contact@catpl.co.in', 'contact@catpl.co.in', '+91 999999999', '+91 9999999999', 'india', '', '1', '999999999', '', '', '', $updateASuSid)");

$tbl_travelogues_insert = $mysqli -> query("INSERT INTO `tbl_feedback` (`AgencySysId`, `GtxRefId`, `AgentSysId`, `Salutation`, `Name`, `EmailId`, `CountryCode`, `MobileNo`, `Destination`, `DestinationId`, `TravelMonth`, `ReviewStarValue`, `ReviewTitle`, `Review`, `TripImage`, `displayOnHome`, `isActive`, `isMarkForDel`) VALUES
($updateASuSid, 1008, 0, 1, 'Prince Kapoor', 'prince@hellogtx.com', '+91', 8368874827, '', 0, 'Apr', 5, 'Great Experience ', 'Good', '', '1', '1', '0')");

$tbl_travelogues_insert = $mysqli -> query("INSERT INTO `tbl_pack_type` (`Title`, `banner_image`, `IsMarkForDel`, `IsActive`, `DisplayOnFooter`, `displayOnHome`, `image`, `metaTitle`, `metaKeyword`, `metaDescription`, `AgencySysId`) VALUES
('Honeymoon', '', '0', '1', '1', '1', '', '', '', '', $updateASuSid),
('Adventures', '', '0', '1', '1', '1', '', '', '', '', $updateASuSid),
('Wild Life', '', '0', '1', '1', '1', '', '', '', '', $updateASuSid),
('Beach', NULL, '0', '1', '1', '1', '', '', '', '', $updateASuSid),
('Family', NULL, '0', '1', '0', '1', '', '', '', '', $updateASuSid),
('Sports', NULL, '0', '1', '1', '1', '', '', '', '', $updateASuSid),
('Cruise', NULL, '0', '1', '1', '1', '', '', '', '', $updateASuSid),
('Religious', NULL, '0', '1', '1', '1', '', '', '', '', $updateASuSid),
('Hill Station', NULL, '0', '1', '1', '1', '', '', '', '', $updateASuSid),
('Heritage', NULL, '0', '1', '1', '1', '', '', '', '', $updateASuSid),
('Thomas', NULL, '0', '1', '0', '0', '', '', '', '', $updateASuSid),
('Weekend', NULL, '0', '1', '1', '0', '', '', '', '', $updateASuSid),
('NYE2018', NULL, '0', '1', '0', '0', '', '', '', '', $updateASuSid),
('Festivals and Events', NULL, '0', '1', '1', '0', '', '', '', '', $updateASuSid),
('Romantic', NULL, '0', '1', '1', '0', '', '', '', '', $updateASuSid),
('Shopping and Nightlife', NULL, '0', '1', '0', '0', '', '', '', '', $updateASuSid),
('Offbeat', NULL, '0', '1', '0', '0', '', '', '', '', $updateASuSid),
('Leisure', NULL, '0', '1', '0', '0', '', '', '', '', $updateASuSid),
('By Cab', NULL, '0', '1', '0', '0', '', '', '', '', $updateASuSid),
('Group Tours', NULL, '0', '1', '1', '0', '', '', '', '', $updateASuSid),
('BY Volvo', NULL, '0', '1', '0', '0', '', '', '', '', $updateASuSid),
('Circuit tour ', NULL, '0', '1', '0', '0', '', '', '', '', $updateASuSid)");


$tbl_tbl_currency_insert = $mysqli -> query("INSERT INTO `tbl_currency` (`CurrencyId`, `Title`, `defaultCurrency`, `isActive`, `AgencySysId`) VALUES
(1, 'INR', '0', '1', $updateASuSid),
(2, 'USD', '1', '1', $updateASuSid),
(3, 'AUD', '0', '1', $updateASuSid),
(8, 'CNY', '0', '1', $updateASuSid),
(11, 'GBP', '0', '1', $updateASuSid),
(17, 'JPY', '0', '1', $updateASuSid),
(28, 'SGD', '0', '1', $updateASuSid),
(29, 'THB', '0', '1', $updateASuSid),
(32, 'EUR', '0', '1', $updateASuSid),
(33, 'AED', '0', '1', $updateASuSid),
(83, 'KES', '0', '1', $updateASuSid)");


				 
				echo " successfully added";
		}
      


//if($email != NULL) {
 //   mail($to, $subject, $txt, $headers);
// 
// Redirect to
//header("Location:step2.php");
?>