[01/18/2024 06:09:36], [file name :-/home/otrams/public_html/beta/about_us.php],INSERT INTO psa_login_log  SET username = '', user_type = 'A', branch_id = '7', login_datetime = '2024-01-18 06:09:36', ip = '207.46.13.128', action = 'Login' ;
[01/18/2024 06:22:39], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-18 06:22:39' WHERE id= '309';
[01/18/2024 06:22:39], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO bookings set reservation_id='1748',agent_id='7851',leader_title='Mr',leader_first_name='shiv',leader_last_name='chauhan',city_id='dubai',country_id='138',nationality='Emirati',display_room_rate='89.18',display_currency_code='USD',native_room_rate='89.18',consultant_id='SUJAY_QTECH',native_currency_code='USD',cancellation_policy='Cancellation Charges will be applicable if cancelled after 06 Dec 2023 12:00 hrs.<BR>Late amendment charge may apply.<Br><Br><B><U>Detailed Cancellation Policy:</U></B><Br>89.18 USDCharges - 100% applicable from time of Booking (Full Cancellation Charges applicable immediately)',current_status='inprocess-booking',booking_status='1',sales_manager_id='0',create_date='2024-01-18 06:22:39',source_type='viator',expiration_date= '2023-12-06 09:00:00',applied_multiplier='1.00000',applied_markup='0',agent_markup='0',basecurrency_multiplier='1.00000',basecurrency_multiplier_native='1.00000',admin_booked='0',service_date='2024-01-21',sub_user_id='',check_out_date='2024-01-21',supplier_profile_id='',agent_currency_multiplier='3.7507', booking_branch_id = '27',site_url = 'https://beta.astrabookings.com/',ip_addr='43.239.53.130',leader_phone=' 9823860012',email_id='shiv.chauhan@qtechsoftware.com',service_type='sightseeing';
[01/18/2024 06:22:39], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO sight_bookings set booking_id='213',native_nightly_rates='a:2:{s:4:\"size\";i:1;s:17:\"nativeNightlyRate\";d:89.180000000000007;}',rate_description='',display_nightly_rates='a:4:{s:4:\"size\";i:1;s:18:\"displayNightlyRate\";d:89.180000000000007;s:25:\"displayNightlyRateDisplay\";s:133:\"Rate - 89.18 USD, Currency Multiplier (USD-USD) - 1.00000, Markup  in % - %, Markup Amount - , Markup Amount in  - ,Other Markup - 0%\";s:23:\"displayNightlyRateStore\";s:134:\"Rate - 89.18 USD, Currency Multiplier (USD-USD) - 1.00000, Markup  in % - %, Markup Amount - , Markup Amount in  -  ,Other Markup - 0%\";}',display_currency_code='USD',native_currency_code='USD',sight_id='333273P2',sight_name='DUBAI LONG SELF-DRIVE QUADBIKE WITH CAMEL AND FALCON- V2',tour_time='',tour_details='',tour_inclusive='<br/>',tour_exclusive=',<br/>',meeting_point='',tour_dep_point=' ',tour_language='en/SERVICE_GUIDE',tour_supplier_phone='',additional_tour_dep_point='',tour_duration='4 hours 0 minutes<br> Start Time: 07:00',arrival_date='2024-01-21',total_adults='2',total_children='',total_infants='',gta_city_code='828',supplier_id='',pick_up_point='',drop_off_point='',from_slot='',to_slot='',total_adult_rate='',total_child_rate='',adult_rate='',child_rate='',display_total_adult_rate='',display_total_child_rate='',display_adult_rate='',display_child_rate='0',additional_service_rate='0',booking_remark='',emergency_cont_no='',terms_n_condition='';
[01/18/2024 06:22:39], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO posted_bookings(id,source_type,reservation_id,create_date,status) values ('','viator','1748','2024-01-18 06:22:39',0);
[01/18/2024 06:22:45], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2024-01-18 06:22:45' WHERE id= '309';
[01/18/2024 06:22:45], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-18 06:22:45',login_attempt=0 where id = '7851';
[01/18/2024 06:22:45], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Viator_test', user_type = 'A', branch_id = '27', login_datetime = '2024-01-18 06:22:45', ip = '43.239.53.130', action = 'Login' ;
[01/18/2024 06:22:45], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-18 06:22:45' WHERE id= '309';
[01/18/2024 06:22:48], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-18 06:22:48' WHERE id= '309';
[01/18/2024 06:22:51], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-18 06:22:51' WHERE id= '309';
[01/18/2024 06:22:57], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-18 06:22:57' WHERE id= '309';
[01/18/2024 06:22:57], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7851' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '27' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/01/21',  departure_date='2024/01/21',  nights='1',  create_date='2024-01-18 :06:22:57',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/18/2024 06:22:59], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'v1/18_01_2024/request_availability_Viator_test_06_22_57_1705558977.json', 'v1/18_01_2024/response_availability_Viator_test_06_22_57_1705558977.json', 'v1/18_01_2024/response_header_availability_Viator_test_06_22_57_1705558977.json', 'viator', '2024-01-18 06:22:59', '', '', '978');
[01/18/2024 06:23:00], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-18 06:23:00' WHERE id= '309';
[01/18/2024 06:23:00], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-18 06:23:00' WHERE id= '309';
[01/18/2024 06:23:02], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-18 06:23:02' WHERE id= '309';
[01/18/2024 06:23:03], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/18_01_2024/request_sight_details_Viator_test_06_23_02_1705558982.json', 'v1/18_01_2024/response_sight_details_Viator_test_06_23_02_1705558982.json', 'v1/18_01_2024/response_header_sight_details_Viator_test_06_23_02_1705558982.json', 'viator', '2024-01-18 06:23:03', '', '', '978');
[01/18/2024 06:23:06], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-18 06:23:06' WHERE id= '309';
[01/18/2024 06:23:07], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'check_availability', 'v1/18_01_2024/request_check_availability_Viator_test_06_23_06_1705558986.json', 'v1/18_01_2024/response_check_availability_Viator_test_06_23_06_1705558986.json', 'v1/18_01_2024/response_header_check_availability_Viator_test_06_23_06_1705558986.json', 'viator', '2024-01-18 06:23:07', '', '', '978');
[01/18/2024 06:23:09], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-18 06:23:09' WHERE id= '309';
[01/18/2024 06:23:09], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705558989','43.239.53.130');
[01/18/2024 06:23:14], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-01-18 06:23:14' WHERE id= '309';
[01/18/2024 06:23:22], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-01-18 06:23:22' WHERE id= '309';
[01/18/2024 06:23:25], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-01-18 06:23:25' WHERE id= '309';
[01/18/2024 06:24:51], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-18 06:24:51' WHERE id= '309';
[01/18/2024 06:24:51], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705559091','43.239.53.130');
[01/18/2024 06:24:57], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-01-18 06:24:57' WHERE id= '309';
[01/18/2024 06:24:59], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-01-18 06:24:59' WHERE id= '309';
[01/18/2024 06:25:02], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-01-18 06:25:02' WHERE id= '309';
[01/18/2024 06:25:06], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-01-18 06:25:06' WHERE id= '309';
[01/18/2024 06:25:09], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-01-18 06:25:09' WHERE id= '309';
[01/18/2024 06:25:18], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-01-18 06:25:18' WHERE id= '309';
[01/18/2024 06:27:21], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-18 06:27:21' WHERE id= '309';
[01/18/2024 06:27:21], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705559241','43.239.53.130');
[01/18/2024 06:27:22], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-18 06:27:22' WHERE id= '309';
[01/18/2024 06:27:22], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO bookings set reservation_id='1751',agent_id='7851',leader_title='Mr',leader_first_name='shiv',leader_last_name='chauhan',city_id='dubai',country_id='138',nationality='Emirati',display_room_rate='89.18',display_currency_code='USD',native_room_rate='89.18',consultant_id='SUJAY_QTECH',native_currency_code='USD',cancellation_policy='Cancellation Charges will be applicable if cancelled after 06 Dec 2023 12:00 hrs.<BR>Late amendment charge may apply.<Br><Br><B><U>Detailed Cancellation Policy:</U></B><Br>89.18 USDCharges - 100% applicable from time of Booking (Full Cancellation Charges applicable immediately)',current_status='inprocess-booking',booking_status='1',sales_manager_id='0',create_date='2024-01-18 06:27:22',source_type='viator',expiration_date= '2023-12-06 09:00:00',applied_multiplier='1.00000',applied_markup='0',agent_markup='0',basecurrency_multiplier='1.00000',basecurrency_multiplier_native='1.00000',admin_booked='0',service_date='2024-01-21',sub_user_id='',check_out_date='2024-01-21',supplier_profile_id='',agent_currency_multiplier='3.7507', booking_branch_id = '27',site_url = 'https://beta.astrabookings.com/',ip_addr='43.239.53.130',leader_phone=' 9823860012',email_id='shiv.chauhan@qtechsoftware.com',service_type='sightseeing';
[01/18/2024 06:27:22], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO sight_bookings set booking_id='214',native_nightly_rates='a:2:{s:4:\"size\";i:1;s:17:\"nativeNightlyRate\";d:89.180000000000007;}',rate_description='',display_nightly_rates='a:4:{s:4:\"size\";i:1;s:18:\"displayNightlyRate\";d:89.180000000000007;s:25:\"displayNightlyRateDisplay\";s:133:\"Rate - 89.18 USD, Currency Multiplier (USD-USD) - 1.00000, Markup  in % - %, Markup Amount - , Markup Amount in  - ,Other Markup - 0%\";s:23:\"displayNightlyRateStore\";s:134:\"Rate - 89.18 USD, Currency Multiplier (USD-USD) - 1.00000, Markup  in % - %, Markup Amount - , Markup Amount in  -  ,Other Markup - 0%\";}',display_currency_code='USD',native_currency_code='USD',sight_id='333273P2',sight_name='DUBAI LONG SELF-DRIVE QUADBIKE WITH CAMEL AND FALCON- V2',tour_time='',tour_details='',tour_inclusive='<br/>',tour_exclusive=',<br/>',meeting_point='',tour_dep_point=' ',tour_language='en/SERVICE_GUIDE',tour_supplier_phone='',additional_tour_dep_point='',tour_duration='4 hours 0 minutes<br> Start Time: 07:00',arrival_date='2024-01-21',total_adults='2',total_children='',total_infants='',gta_city_code='828',supplier_id='',pick_up_point='',drop_off_point='',from_slot='',to_slot='',total_adult_rate='',total_child_rate='',adult_rate='',child_rate='',display_total_adult_rate='',display_total_child_rate='',display_adult_rate='',display_child_rate='0',additional_service_rate='0',booking_remark='',emergency_cont_no='',terms_n_condition='';
[01/18/2024 06:27:22], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO posted_bookings(id,source_type,reservation_id,create_date,status) values ('','viator','1751','2024-01-18 06:27:22',0);
[01/18/2024 06:28:20], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-18 06:28:20' WHERE id= '309';
[01/18/2024 06:28:20], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO bookings set reservation_id='1751',agent_id='7851',leader_title='Mr',leader_first_name='shiv',leader_last_name='chauhan',city_id='dubai',country_id='138',nationality='Emirati',display_room_rate='89.18',display_currency_code='USD',native_room_rate='89.18',consultant_id='SUJAY_QTECH',native_currency_code='USD',cancellation_policy='Cancellation Charges will be applicable if cancelled after 06 Dec 2023 12:00 hrs.<BR>Late amendment charge may apply.<Br><Br><B><U>Detailed Cancellation Policy:</U></B><Br>89.18 USDCharges - 100% applicable from time of Booking (Full Cancellation Charges applicable immediately)',current_status='inprocess-booking',booking_status='1',sales_manager_id='0',create_date='2024-01-18 06:28:20',source_type='viator',expiration_date= '2023-12-06 09:00:00',applied_multiplier='1.00000',applied_markup='0',agent_markup='0',basecurrency_multiplier='1.00000',basecurrency_multiplier_native='1.00000',admin_booked='0',service_date='2024-01-21',sub_user_id='',check_out_date='2024-01-21',supplier_profile_id='',agent_currency_multiplier='3.7507', booking_branch_id = '27',site_url = 'https://beta.astrabookings.com/',ip_addr='43.239.53.130',leader_phone=' 9823860012',email_id='shiv.chauhan@qtechsoftware.com',service_type='sightseeing';
[01/18/2024 06:28:20], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO sight_bookings set booking_id='215',native_nightly_rates='a:2:{s:4:\"size\";i:1;s:17:\"nativeNightlyRate\";d:89.180000000000007;}',rate_description='',display_nightly_rates='a:4:{s:4:\"size\";i:1;s:18:\"displayNightlyRate\";d:89.180000000000007;s:25:\"displayNightlyRateDisplay\";s:133:\"Rate - 89.18 USD, Currency Multiplier (USD-USD) - 1.00000, Markup  in % - %, Markup Amount - , Markup Amount in  - ,Other Markup - 0%\";s:23:\"displayNightlyRateStore\";s:134:\"Rate - 89.18 USD, Currency Multiplier (USD-USD) - 1.00000, Markup  in % - %, Markup Amount - , Markup Amount in  -  ,Other Markup - 0%\";}',display_currency_code='USD',native_currency_code='USD',sight_id='333273P2',sight_name='DUBAI LONG SELF-DRIVE QUADBIKE WITH CAMEL AND FALCON- V2',tour_time='',tour_details='',tour_inclusive='<br/>',tour_exclusive=',<br/>',meeting_point='',tour_dep_point=' ',tour_language='en/SERVICE_GUIDE',tour_supplier_phone='',additional_tour_dep_point='',tour_duration='4 hours 0 minutes<br> Start Time: 07:00',arrival_date='2024-01-21',total_adults='2',total_children='',total_infants='',gta_city_code='828',supplier_id='',pick_up_point='',drop_off_point='',from_slot='',to_slot='',total_adult_rate='',total_child_rate='',adult_rate='',child_rate='',display_total_adult_rate='',display_total_child_rate='',display_adult_rate='',display_child_rate='0',additional_service_rate='0',booking_remark='',emergency_cont_no='',terms_n_condition='';
[01/18/2024 06:28:20], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO posted_bookings(id,source_type,reservation_id,create_date,status) values ('','viator','1751','2024-01-18 06:28:20',0);
[01/18/2024 06:30:03], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-18 06:30:03' WHERE id= '309';
[01/18/2024 06:30:03], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO bookings set reservation_id='1751',agent_id='7851',leader_title='Mr',leader_first_name='shiv',leader_last_name='chauhan',city_id='dubai',country_id='138',nationality='Emirati',display_room_rate='89.18',display_currency_code='USD',native_room_rate='89.18',consultant_id='SUJAY_QTECH',native_currency_code='USD',cancellation_policy='Cancellation Charges will be applicable if cancelled after 06 Dec 2023 12:00 hrs.<BR>Late amendment charge may apply.<Br><Br><B><U>Detailed Cancellation Policy:</U></B><Br>89.18 USDCharges - 100% applicable from time of Booking (Full Cancellation Charges applicable immediately)',current_status='inprocess-booking',booking_status='1',sales_manager_id='0',create_date='2024-01-18 06:30:03',source_type='viator',expiration_date= '2023-12-06 09:00:00',applied_multiplier='1.00000',applied_markup='0',agent_markup='0',basecurrency_multiplier='1.00000',basecurrency_multiplier_native='1.00000',admin_booked='0',service_date='2024-01-21',sub_user_id='',check_out_date='2024-01-21',supplier_profile_id='',agent_currency_multiplier='3.7507', booking_branch_id = '27',site_url = 'https://beta.astrabookings.com/',ip_addr='43.239.53.130',leader_phone=' 9823860012',email_id='shiv.chauhan@qtechsoftware.com',service_type='sightseeing';
[01/18/2024 06:30:03], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO sight_bookings set booking_id='216',native_nightly_rates='a:2:{s:4:\"size\";i:1;s:17:\"nativeNightlyRate\";d:89.180000000000007;}',rate_description='',display_nightly_rates='a:4:{s:4:\"size\";i:1;s:18:\"displayNightlyRate\";d:89.180000000000007;s:25:\"displayNightlyRateDisplay\";s:133:\"Rate - 89.18 USD, Currency Multiplier (USD-USD) - 1.00000, Markup  in % - %, Markup Amount - , Markup Amount in  - ,Other Markup - 0%\";s:23:\"displayNightlyRateStore\";s:134:\"Rate - 89.18 USD, Currency Multiplier (USD-USD) - 1.00000, Markup  in % - %, Markup Amount - , Markup Amount in  -  ,Other Markup - 0%\";}',display_currency_code='USD',native_currency_code='USD',sight_id='333273P2',sight_name='DUBAI LONG SELF-DRIVE QUADBIKE WITH CAMEL AND FALCON- V2',tour_time='',tour_details='',tour_inclusive='<br/>',tour_exclusive=',<br/>',meeting_point='',tour_dep_point=' ',tour_language='en/SERVICE_GUIDE',tour_supplier_phone='',additional_tour_dep_point='',tour_duration='4 hours 0 minutes<br> Start Time: 07:00',arrival_date='2024-01-21',total_adults='2',total_children='',total_infants='',gta_city_code='828',supplier_id='',pick_up_point='',drop_off_point='',from_slot='',to_slot='',total_adult_rate='',total_child_rate='',adult_rate='',child_rate='',display_total_adult_rate='',display_total_child_rate='',display_adult_rate='',display_child_rate='0',additional_service_rate='0',booking_remark='',emergency_cont_no='',terms_n_condition='';
[01/18/2024 06:30:03], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO posted_bookings(id,source_type,reservation_id,create_date,status) values ('','viator','1751','2024-01-18 06:30:03',0);
[01/18/2024 06:30:24], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-18 06:30:24' WHERE id= '309';
[01/18/2024 06:30:24], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO bookings set reservation_id='1751',agent_id='7851',leader_title='Mr',leader_first_name='shiv',leader_last_name='chauhan',city_id='dubai',country_id='138',nationality='Emirati',display_room_rate='89.18',display_currency_code='USD',native_room_rate='89.18',consultant_id='SUJAY_QTECH',native_currency_code='USD',cancellation_policy='Cancellation Charges will be applicable if cancelled after 06 Dec 2023 12:00 hrs.<BR>Late amendment charge may apply.<Br><Br><B><U>Detailed Cancellation Policy:</U></B><Br>89.18 USDCharges - 100% applicable from time of Booking (Full Cancellation Charges applicable immediately)',current_status='inprocess-booking',booking_status='1',sales_manager_id='0',create_date='2024-01-18 06:30:24',source_type='viator',expiration_date= '2023-12-06 09:00:00',applied_multiplier='1.00000',applied_markup='0',agent_markup='0',basecurrency_multiplier='1.00000',basecurrency_multiplier_native='1.00000',admin_booked='0',service_date='2024-01-21',sub_user_id='',check_out_date='2024-01-21',supplier_profile_id='',agent_currency_multiplier='3.7507', booking_branch_id = '27',site_url = 'https://beta.astrabookings.com/',ip_addr='43.239.53.130',leader_phone=' 9823860012',email_id='shiv.chauhan@qtechsoftware.com',service_type='sightseeing';
[01/18/2024 06:30:24], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO sight_bookings set booking_id='217',native_nightly_rates='a:2:{s:4:\"size\";i:1;s:17:\"nativeNightlyRate\";d:89.180000000000007;}',rate_description='',display_nightly_rates='a:4:{s:4:\"size\";i:1;s:18:\"displayNightlyRate\";d:89.180000000000007;s:25:\"displayNightlyRateDisplay\";s:133:\"Rate - 89.18 USD, Currency Multiplier (USD-USD) - 1.00000, Markup  in % - %, Markup Amount - , Markup Amount in  - ,Other Markup - 0%\";s:23:\"displayNightlyRateStore\";s:134:\"Rate - 89.18 USD, Currency Multiplier (USD-USD) - 1.00000, Markup  in % - %, Markup Amount - , Markup Amount in  -  ,Other Markup - 0%\";}',display_currency_code='USD',native_currency_code='USD',sight_id='333273P2',sight_name='DUBAI LONG SELF-DRIVE QUADBIKE WITH CAMEL AND FALCON- V2',tour_time='',tour_details='',tour_inclusive='<br/>',tour_exclusive=',<br/>',meeting_point='',tour_dep_point=' ',tour_language='en/SERVICE_GUIDE',tour_supplier_phone='',additional_tour_dep_point='',tour_duration='4 hours 0 minutes<br> Start Time: 07:00',arrival_date='2024-01-21',total_adults='2',total_children='',total_infants='',gta_city_code='828',supplier_id='',pick_up_point='',drop_off_point='',from_slot='',to_slot='',total_adult_rate='',total_child_rate='',adult_rate='',child_rate='',display_total_adult_rate='',display_total_child_rate='',display_adult_rate='',display_child_rate='0',additional_service_rate='0',booking_remark='',emergency_cont_no='',terms_n_condition='';
[01/18/2024 06:30:24], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO posted_bookings(id,source_type,reservation_id,create_date,status) values ('','viator','1751','2024-01-18 06:30:24',0);
[01/18/2024 06:32:08], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-18 06:32:08' WHERE id= '309';
[01/18/2024 06:32:08], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO bookings set reservation_id='1751',agent_id='7851',leader_title='Mr',leader_first_name='shiv',leader_last_name='chauhan',city_id='dubai',country_id='138',nationality='Emirati',display_room_rate='89.18',display_currency_code='USD',native_room_rate='89.18',consultant_id='SUJAY_QTECH',native_currency_code='USD',cancellation_policy='Cancellation Charges will be applicable if cancelled after 06 Dec 2023 12:00 hrs.<BR>Late amendment charge may apply.<Br><Br><B><U>Detailed Cancellation Policy:</U></B><Br>89.18 USDCharges - 100% applicable from time of Booking (Full Cancellation Charges applicable immediately)',current_status='inprocess-booking',booking_status='1',sales_manager_id='0',create_date='2024-01-18 06:32:08',source_type='viator',expiration_date= '2023-12-06 09:00:00',applied_multiplier='1.00000',applied_markup='0',agent_markup='0',basecurrency_multiplier='1.00000',basecurrency_multiplier_native='1.00000',admin_booked='0',service_date='2024-01-21',sub_user_id='',check_out_date='2024-01-21',supplier_profile_id='',agent_currency_multiplier='3.7507', booking_branch_id = '27',site_url = 'https://beta.astrabookings.com/',ip_addr='43.239.53.130',leader_phone=' 9823860012',email_id='shiv.chauhan@qtechsoftware.com',service_type='sightseeing';
[01/18/2024 06:32:08], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO sight_bookings set booking_id='218',native_nightly_rates='a:2:{s:4:\"size\";i:1;s:17:\"nativeNightlyRate\";d:89.180000000000007;}',rate_description='',display_nightly_rates='a:4:{s:4:\"size\";i:1;s:18:\"displayNightlyRate\";d:89.180000000000007;s:25:\"displayNightlyRateDisplay\";s:133:\"Rate - 89.18 USD, Currency Multiplier (USD-USD) - 1.00000, Markup  in % - %, Markup Amount - , Markup Amount in  - ,Other Markup - 0%\";s:23:\"displayNightlyRateStore\";s:134:\"Rate - 89.18 USD, Currency Multiplier (USD-USD) - 1.00000, Markup  in % - %, Markup Amount - , Markup Amount in  -  ,Other Markup - 0%\";}',display_currency_code='USD',native_currency_code='USD',sight_id='333273P2',sight_name='DUBAI LONG SELF-DRIVE QUADBIKE WITH CAMEL AND FALCON- V2',tour_time='',tour_details='',tour_inclusive='<br/>',tour_exclusive=',<br/>',meeting_point='',tour_dep_point=' ',tour_language='en/SERVICE_GUIDE',tour_supplier_phone='',additional_tour_dep_point='',tour_duration='4 hours 0 minutes<br> Start Time: 07:00',arrival_date='2024-01-21',total_adults='2',total_children='',total_infants='',gta_city_code='828',supplier_id='',pick_up_point='',drop_off_point='',from_slot='',to_slot='',total_adult_rate='',total_child_rate='',adult_rate='',child_rate='',display_total_adult_rate='',display_total_child_rate='',display_adult_rate='',display_child_rate='0',additional_service_rate='0',booking_remark='',emergency_cont_no='',terms_n_condition='';
[01/18/2024 06:32:08], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO posted_bookings(id,source_type,reservation_id,create_date,status) values ('','viator','1751','2024-01-18 06:32:08',0);
[01/18/2024 06:35:56], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-18 06:35:56' WHERE id= '309';
[01/18/2024 06:35:56], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO bookings set reservation_id='1751',agent_id='7851',leader_title='Mr',leader_first_name='shiv',leader_last_name='chauhan',city_id='dubai',country_id='138',nationality='Emirati',display_room_rate='89.18',display_currency_code='USD',native_room_rate='89.18',consultant_id='SUJAY_QTECH',native_currency_code='USD',cancellation_policy='Cancellation Charges will be applicable if cancelled after 06 Dec 2023 12:00 hrs.<BR>Late amendment charge may apply.<Br><Br><B><U>Detailed Cancellation Policy:</U></B><Br>89.18 USDCharges - 100% applicable from time of Booking (Full Cancellation Charges applicable immediately)',current_status='inprocess-booking',booking_status='1',sales_manager_id='0',create_date='2024-01-18 06:35:56',source_type='viator',expiration_date= '2023-12-06 09:00:00',applied_multiplier='1.00000',applied_markup='0',agent_markup='0',basecurrency_multiplier='1.00000',basecurrency_multiplier_native='1.00000',admin_booked='0',service_date='2024-01-21',sub_user_id='',check_out_date='2024-01-21',supplier_profile_id='',agent_currency_multiplier='3.7507', booking_branch_id = '27',site_url = 'https://beta.astrabookings.com/',ip_addr='43.239.53.130',leader_phone=' 9823860012',email_id='shiv.chauhan@qtechsoftware.com',service_type='sightseeing';
[01/18/2024 06:35:56], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO sight_bookings set booking_id='219',native_nightly_rates='a:2:{s:4:\"size\";i:1;s:17:\"nativeNightlyRate\";d:89.180000000000007;}',rate_description='',display_nightly_rates='a:4:{s:4:\"size\";i:1;s:18:\"displayNightlyRate\";d:89.180000000000007;s:25:\"displayNightlyRateDisplay\";s:133:\"Rate - 89.18 USD, Currency Multiplier (USD-USD) - 1.00000, Markup  in % - %, Markup Amount - , Markup Amount in  - ,Other Markup - 0%\";s:23:\"displayNightlyRateStore\";s:134:\"Rate - 89.18 USD, Currency Multiplier (USD-USD) - 1.00000, Markup  in % - %, Markup Amount - , Markup Amount in  -  ,Other Markup - 0%\";}',display_currency_code='USD',native_currency_code='USD',sight_id='333273P2',sight_name='DUBAI LONG SELF-DRIVE QUADBIKE WITH CAMEL AND FALCON- V2',tour_time='',tour_details='',tour_inclusive='<br/>',tour_exclusive=',<br/>',meeting_point='',tour_dep_point=' ',tour_language='en/SERVICE_GUIDE',tour_supplier_phone='',additional_tour_dep_point='',tour_duration='4 hours 0 minutes<br> Start Time: 07:00',arrival_date='2024-01-21',total_adults='2',total_children='',total_infants='',gta_city_code='828',supplier_id='',pick_up_point='',drop_off_point='',from_slot='',to_slot='',total_adult_rate='',total_child_rate='',adult_rate='',child_rate='',display_total_adult_rate='',display_total_child_rate='',display_adult_rate='',display_child_rate='0',additional_service_rate='0',booking_remark='',emergency_cont_no='',terms_n_condition='';
[01/18/2024 06:35:56], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO posted_bookings(id,source_type,reservation_id,create_date,status) values ('','viator','1751','2024-01-18 06:35:56',0);
[01/18/2024 06:38:35], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-18 06:38:35' WHERE id= '309';
[01/18/2024 06:38:35], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO bookings set reservation_id='1751',agent_id='7851',leader_title='Mr',leader_first_name='shiv',leader_last_name='chauhan',city_id='dubai',country_id='138',nationality='Emirati',display_room_rate='89.18',display_currency_code='USD',native_room_rate='89.18',consultant_id='SUJAY_QTECH',native_currency_code='USD',cancellation_policy='Cancellation Charges will be applicable if cancelled after 06 Dec 2023 12:00 hrs.<BR>Late amendment charge may apply.<Br><Br><B><U>Detailed Cancellation Policy:</U></B><Br>89.18 USDCharges - 100% applicable from time of Booking (Full Cancellation Charges applicable immediately)',current_status='inprocess-booking',booking_status='1',sales_manager_id='0',create_date='2024-01-18 06:38:35',source_type='viator',expiration_date= '2023-12-06 09:00:00',applied_multiplier='1.00000',applied_markup='0',agent_markup='0',basecurrency_multiplier='1.00000',basecurrency_multiplier_native='1.00000',admin_booked='0',service_date='2024-01-21',sub_user_id='',check_out_date='2024-01-21',supplier_profile_id='',agent_currency_multiplier='3.7507', booking_branch_id = '27',site_url = 'https://beta.astrabookings.com/',ip_addr='43.239.53.130',leader_phone=' 9823860012',email_id='shiv.chauhan@qtechsoftware.com',service_type='sightseeing';
[01/18/2024 06:38:35], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO sight_bookings set booking_id='220',native_nightly_rates='a:2:{s:4:\"size\";i:1;s:17:\"nativeNightlyRate\";d:89.180000000000007;}',rate_description='',display_nightly_rates='a:4:{s:4:\"size\";i:1;s:18:\"displayNightlyRate\";d:89.180000000000007;s:25:\"displayNightlyRateDisplay\";s:133:\"Rate - 89.18 USD, Currency Multiplier (USD-USD) - 1.00000, Markup  in % - %, Markup Amount - , Markup Amount in  - ,Other Markup - 0%\";s:23:\"displayNightlyRateStore\";s:134:\"Rate - 89.18 USD, Currency Multiplier (USD-USD) - 1.00000, Markup  in % - %, Markup Amount - , Markup Amount in  -  ,Other Markup - 0%\";}',display_currency_code='USD',native_currency_code='USD',sight_id='333273P2',sight_name='DUBAI LONG SELF-DRIVE QUADBIKE WITH CAMEL AND FALCON- V2',tour_time='',tour_details='',tour_inclusive='<br/>',tour_exclusive=',<br/>',meeting_point='',tour_dep_point=' ',tour_language='en/SERVICE_GUIDE',tour_supplier_phone='',additional_tour_dep_point='',tour_duration='4 hours 0 minutes<br> Start Time: 07:00',arrival_date='2024-01-21',total_adults='2',total_children='',total_infants='',gta_city_code='828',supplier_id='',pick_up_point='',drop_off_point='',from_slot='',to_slot='',total_adult_rate='',total_child_rate='',adult_rate='',child_rate='',display_total_adult_rate='',display_total_child_rate='',display_adult_rate='',display_child_rate='0',additional_service_rate='0',booking_remark='',emergency_cont_no='',terms_n_condition='';
[01/18/2024 06:38:35], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO posted_bookings(id,source_type,reservation_id,create_date,status) values ('','viator','1751','2024-01-18 06:38:35',0);
[01/18/2024 06:39:26], [file name :-/home/otrams/public_html/beta/tms/agent.php],UPDATE agents SET agency_name= 'Qtech',other_language_agency_name= '',accounting_name= '',first_name= 'Baysan',middle_name= '',last_name= 'test',agent_type= 'CC',sort_type= 'price',credit_limit_assigned= '0.000',credit_limit= '0.000',credit_distribution= '0',temp_credit_limit= '',address= 'ABC',other_language_address= '',city= '64440',pincode= '',country= '106',time_zone_offset= '-12',enable_dst= '',branch_id='31',phone= '91-9876542110',mobile= '91-9876543210',fax= '',currency= '6',email= 'sanket.desai@qtechsoftware.com',website= '',lead_time= '',search_by_multicurrency= '1',debug= '',profile= '',designation= '',iata_status= '0',iata_number= '',nature_of_business= '0',can_book= '1',sales_manager_id= '',comp_reg_no= '',allow_quotation= '1',can_voucher= '1',markup= '0.5',allow_book_under_cancellation='1',modify_date='2024-01-18 06:39:26',consultant_id= 'Ayman',agency_email= '',acc_name= 'SUJAY',acc_email= 'sanket.desai@qtechsoftware.com',acc_phone= '',man_name= '',man_email= '',man_phone= '',res_name= '',res_email= '',res_phone= '',remarks= '',apply_service_tax= 'no',allow_ticketing= '' WHERE id= '7865';
[01/18/2024 06:39:26], [file name :-/home/otrams/public_html/beta/tms/agent.php],insert into `user_logs` set `username`= 'Ayman',`create_date`= '2024-01-18 06:39:26',`log_type`= 'Agent Updated',`sql_query`= 'UPDATE agents SET agency_name= \&#039;Qtech\&#039;,other_language_agency_name= \&#039;\&#039;,accounting_name= \&#039;\&#039;,first_name= \&#039;Baysan\&#039;,middle_name= \&#039;\&#039;,last_name= \&#039;test\&#039;,agent_type= \&#039;CC\&#039;,sort_type= \&#039;price\&#039;,credit_limit_assigned= \&#039;0.000\&#039;,credit_limit= \&#039;0.000\&#039;,credit_distribution= \&#039;0\&#039;,temp_credit_limit= \&#039;\&#039;,address= \&#039;ABC\&#039;,other_language_address= \&#039;\&#039;,city= \&#039;64440\&#039;,pincode= \&#039;\&#039;,country= \&#039;106\&#039;,time_zone_offset= \&#039;-12\&#039;,enable_dst= 0,branch_id=\&#039;31\&#039;,phone= \&#039;91-9876542110\&#039;,mobile= \&#039;91-9876543210\&#039;,fax= \&#039;\&#039;,currency= \&#039;6\&#039;,email= \&#039;sanket.desai@qtechsoftware.com\&#039;,website= \&#039;\&#039;,lead_time= 0,search_by_multicurrency= \&#039;1\&#039;,debug= 0,profile= \&#039;\&#039;,designation= \&#039;\&#039;,iata_status= \&#039;0\&#039;,iata_number= \&#039;\&#039;,nature_of_business= \&#039;0\&#039;,can_book= \&#039;1\&#039;,sales_manager_id= ,comp_reg_no= \&#039;\&#039;,allow_quotation= \&#039;1\&#039;,can_voucher= \&#039;1\&#039;,markup= \&#039;0.5\&#039;,allow_book_under_cancellation=\&#039;1\&#039;,modify_date=\&#039;2024-01-18 06:39:26\&#039;,consultant_id= \&#039;Ayman\&#039;,agency_email= \&#039;\&#039;,acc_name= \&#039;SUJAY\&#039;,acc_email= \&#039;sanket.desai@qtechsoftware.com\&#039;,acc_phone= \&#039;\&#039;,man_name= \&#039;\&#039;,man_email= \&#039;\&#039;,man_phone= \&#039;\&#039;,res_name= \&#039;\&#039;,res_email= \&#039;\&#039;,res_phone= \&#039;\&#039;,remarks= ,apply_service_tax= \&#039;no\&#039;,allow_ticketing= 0 WHERE id= \&#039;7865\&#039;',`log_description`= 'Agent 7865 updated For  - email=sujay.raut%40qtechsoftware.com&modify_date=2023-12-07+12%3A26%3A11&acc_email=sujay.raut%40qtechsoftware.com changed to - email=sanket.desai%40qtechsoftware.com&modify_date=2024-01-18+06%3A39%3A26&acc_email=sanket.desai%40qtechsoftware.com',`ip`= '43.239.53.130';
[01/18/2024 06:39:26], [file name :-/home/otrams/public_html/beta/tms/agent.php],UPDATE agents SET cd_credit_limit=credit_limit-'7865' , cd_credit_value=cd_credit_limit-cd_credit_usage WHERE id= ?;
[01/18/2024 06:39:26], [file name :-/home/otrams/public_html/beta/tms/agent.php],insert into  agent_credit_log SET agent_id= '7865',credit_value= '-6.660',credit_usage= '6.660',credit_limit= '0.000',receipt_id= '',amount= '',ip='43.239.53.130',user_type='admin',admin_id='Ayman',temp_credit_limit='',log_type='Edit_Agent',note='Agent Edited by Ayman',create_date='2024-01-18 06:01:26';
[01/18/2024 06:39:26], [file name :-/home/otrams/public_html/beta/tms/agent.php],UPDATE agents SET currency= '6',branch_id= '31',consultant_id= 'Ayman',sales_manager_id= '',profile= '', agent_type= 'CC' WHERE parent_agent= '7865';
[01/18/2024 06:43:07], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-18 06:43:07' WHERE id= '309';
[01/18/2024 06:43:07], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO bookings set reservation_id='1751',agent_id='7851',leader_title='Mr',leader_first_name='shiv',leader_last_name='chauhan',city_id='dubai',country_id='138',nationality='Emirati',display_room_rate='89.18',display_currency_code='USD',native_room_rate='89.18',consultant_id='SUJAY_QTECH',native_currency_code='USD',cancellation_policy='Cancellation Charges will be applicable if cancelled after 06 Dec 2023 12:00 hrs.<BR>Late amendment charge may apply.<Br><Br><B><U>Detailed Cancellation Policy:</U></B><Br>89.18 USDCharges - 100% applicable from time of Booking (Full Cancellation Charges applicable immediately)',current_status='inprocess-booking',booking_status='1',sales_manager_id='0',create_date='2024-01-18 06:43:07',source_type='viator',expiration_date= '2023-12-06 09:00:00',applied_multiplier='1.00000',applied_markup='0',agent_markup='0',basecurrency_multiplier='1.00000',basecurrency_multiplier_native='1.00000',admin_booked='0',service_date='2024-01-21',sub_user_id='',check_out_date='2024-01-21',supplier_profile_id='',agent_currency_multiplier='3.7507', booking_branch_id = '27',site_url = 'https://beta.astrabookings.com/',ip_addr='43.239.53.130',leader_phone=' 9823860012',email_id='shiv.chauhan@qtechsoftware.com',service_type='sightseeing';
[01/18/2024 06:43:07], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO sight_bookings set booking_id='221',native_nightly_rates='a:2:{s:4:\"size\";i:1;s:17:\"nativeNightlyRate\";d:89.180000000000007;}',rate_description='',display_nightly_rates='a:4:{s:4:\"size\";i:1;s:18:\"displayNightlyRate\";d:89.180000000000007;s:25:\"displayNightlyRateDisplay\";s:133:\"Rate - 89.18 USD, Currency Multiplier (USD-USD) - 1.00000, Markup  in % - %, Markup Amount - , Markup Amount in  - ,Other Markup - 0%\";s:23:\"displayNightlyRateStore\";s:134:\"Rate - 89.18 USD, Currency Multiplier (USD-USD) - 1.00000, Markup  in % - %, Markup Amount - , Markup Amount in  -  ,Other Markup - 0%\";}',display_currency_code='USD',native_currency_code='USD',sight_id='333273P2',sight_name='DUBAI LONG SELF-DRIVE QUADBIKE WITH CAMEL AND FALCON- V2',tour_time='',tour_details='',tour_inclusive='<br/>',tour_exclusive=',<br/>',meeting_point='',tour_dep_point=' ',tour_language='en/SERVICE_GUIDE',tour_supplier_phone='',additional_tour_dep_point='',tour_duration='4 hours 0 minutes<br> Start Time: 07:00',arrival_date='2024-01-21',total_adults='2',total_children='',total_infants='',gta_city_code='828',supplier_id='',pick_up_point='',drop_off_point='',from_slot='',to_slot='',total_adult_rate='',total_child_rate='',adult_rate='',child_rate='',display_total_adult_rate='',display_total_child_rate='',display_adult_rate='',display_child_rate='0',additional_service_rate='0',booking_remark='',emergency_cont_no='',terms_n_condition='';
[01/18/2024 06:43:07], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO posted_bookings(id,source_type,reservation_id,create_date,status) values ('','viator','1751','2024-01-18 06:43:07',0);
[01/18/2024 06:47:05], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-18 06:47:05' WHERE id= '309';
[01/18/2024 06:47:05], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO bookings set reservation_id='1751',agent_id='7851',leader_title='Mr',leader_first_name='shiv',leader_last_name='chauhan',city_id='dubai',country_id='138',nationality='Emirati',display_room_rate='89.18',display_currency_code='USD',native_room_rate='89.18',consultant_id='SUJAY_QTECH',native_currency_code='USD',cancellation_policy='Cancellation Charges will be applicable if cancelled after 06 Dec 2023 12:00 hrs.<BR>Late amendment charge may apply.<Br><Br><B><U>Detailed Cancellation Policy:</U></B><Br>89.18 USDCharges - 100% applicable from time of Booking (Full Cancellation Charges applicable immediately)',current_status='inprocess-booking',booking_status='1',sales_manager_id='0',create_date='2024-01-18 06:47:05',source_type='viator',expiration_date= '2023-12-06 09:00:00',applied_multiplier='1.00000',applied_markup='0',agent_markup='0',basecurrency_multiplier='1.00000',basecurrency_multiplier_native='1.00000',admin_booked='0',service_date='2024-01-21',sub_user_id='',check_out_date='2024-01-21',supplier_profile_id='',agent_currency_multiplier='3.7507', booking_branch_id = '27',site_url = 'https://beta.astrabookings.com/',ip_addr='43.239.53.130',leader_phone=' 9823860012',email_id='shiv.chauhan@qtechsoftware.com',service_type='sightseeing';
[01/18/2024 06:47:05], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO sight_bookings set booking_id='222',native_nightly_rates='a:2:{s:4:\"size\";i:1;s:17:\"nativeNightlyRate\";d:89.180000000000007;}',rate_description='',display_nightly_rates='a:4:{s:4:\"size\";i:1;s:18:\"displayNightlyRate\";d:89.180000000000007;s:25:\"displayNightlyRateDisplay\";s:133:\"Rate - 89.18 USD, Currency Multiplier (USD-USD) - 1.00000, Markup  in % - %, Markup Amount - , Markup Amount in  - ,Other Markup - 0%\";s:23:\"displayNightlyRateStore\";s:134:\"Rate - 89.18 USD, Currency Multiplier (USD-USD) - 1.00000, Markup  in % - %, Markup Amount - , Markup Amount in  -  ,Other Markup - 0%\";}',display_currency_code='USD',native_currency_code='USD',sight_id='333273P2',sight_name='DUBAI LONG SELF-DRIVE QUADBIKE WITH CAMEL AND FALCON- V2',tour_time='',tour_details='',tour_inclusive='<br/>',tour_exclusive=',<br/>',meeting_point='',tour_dep_point=' ',tour_language='en/SERVICE_GUIDE',tour_supplier_phone='',additional_tour_dep_point='',tour_duration='4 hours 0 minutes<br> Start Time: 07:00',arrival_date='2024-01-21',total_adults='2',total_children='',total_infants='',gta_city_code='828',supplier_id='',pick_up_point='',drop_off_point='',from_slot='',to_slot='',total_adult_rate='',total_child_rate='',adult_rate='',child_rate='',display_total_adult_rate='',display_total_child_rate='',display_adult_rate='',display_child_rate='0',additional_service_rate='0',booking_remark='',emergency_cont_no='',terms_n_condition='';
[01/18/2024 06:47:05], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO posted_bookings(id,source_type,reservation_id,create_date,status) values ('','viator','1751','2024-01-18 06:47:05',0);
[01/18/2024 06:48:34], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-18 06:48:34' WHERE id= '309';
[01/18/2024 06:48:34], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO bookings set reservation_id='1751',agent_id='7851',leader_title='Mr',leader_first_name='shiv',leader_last_name='chauhan',city_id='dubai',country_id='138',nationality='Emirati',display_room_rate='89.18',display_currency_code='USD',native_room_rate='89.18',consultant_id='SUJAY_QTECH',native_currency_code='USD',cancellation_policy='Cancellation Charges will be applicable if cancelled after 06 Dec 2023 12:00 hrs.<BR>Late amendment charge may apply.<Br><Br><B><U>Detailed Cancellation Policy:</U></B><Br>89.18 USDCharges - 100% applicable from time of Booking (Full Cancellation Charges applicable immediately)',current_status='inprocess-booking',booking_status='1',sales_manager_id='0',create_date='2024-01-18 06:48:34',source_type='viator',expiration_date= '2023-12-06 09:00:00',applied_multiplier='1.00000',applied_markup='0',agent_markup='0',basecurrency_multiplier='1.00000',basecurrency_multiplier_native='1.00000',admin_booked='0',service_date='2024-01-21',sub_user_id='',check_out_date='2024-01-21',supplier_profile_id='',agent_currency_multiplier='3.7507', booking_branch_id = '27',site_url = 'https://beta.astrabookings.com/',ip_addr='43.239.53.130',leader_phone=' 9823860012',email_id='shiv.chauhan@qtechsoftware.com',service_type='sightseeing';
[01/18/2024 06:48:34], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO sight_bookings set booking_id='223',native_nightly_rates='a:2:{s:4:\"size\";i:1;s:17:\"nativeNightlyRate\";d:89.180000000000007;}',rate_description='',display_nightly_rates='a:4:{s:4:\"size\";i:1;s:18:\"displayNightlyRate\";d:89.180000000000007;s:25:\"displayNightlyRateDisplay\";s:133:\"Rate - 89.18 USD, Currency Multiplier (USD-USD) - 1.00000, Markup  in % - %, Markup Amount - , Markup Amount in  - ,Other Markup - 0%\";s:23:\"displayNightlyRateStore\";s:134:\"Rate - 89.18 USD, Currency Multiplier (USD-USD) - 1.00000, Markup  in % - %, Markup Amount - , Markup Amount in  -  ,Other Markup - 0%\";}',display_currency_code='USD',native_currency_code='USD',sight_id='333273P2',sight_name='DUBAI LONG SELF-DRIVE QUADBIKE WITH CAMEL AND FALCON- V2',tour_time='',tour_details='',tour_inclusive='<br/>',tour_exclusive=',<br/>',meeting_point='',tour_dep_point=' ',tour_language='en/SERVICE_GUIDE',tour_supplier_phone='',additional_tour_dep_point='',tour_duration='4 hours 0 minutes<br> Start Time: 07:00',arrival_date='2024-01-21',total_adults='2',total_children='',total_infants='',gta_city_code='828',supplier_id='',pick_up_point='',drop_off_point='',from_slot='',to_slot='',total_adult_rate='',total_child_rate='',adult_rate='',child_rate='',display_total_adult_rate='',display_total_child_rate='',display_adult_rate='',display_child_rate='0',additional_service_rate='0',booking_remark='',emergency_cont_no='',terms_n_condition='';
[01/18/2024 06:48:34], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO posted_bookings(id,source_type,reservation_id,create_date,status) values ('','viator','1751','2024-01-18 06:48:34',0);
[01/18/2024 06:50:02], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-18 06:50:02' WHERE id= '309';
[01/18/2024 06:50:02], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO bookings set reservation_id='1751',agent_id='7851',leader_title='Mr',leader_first_name='shiv',leader_last_name='chauhan',city_id='dubai',country_id='138',nationality='Emirati',display_room_rate='89.18',display_currency_code='USD',native_room_rate='89.18',consultant_id='SUJAY_QTECH',native_currency_code='USD',cancellation_policy='Cancellation Charges will be applicable if cancelled after 06 Dec 2023 12:00 hrs.<BR>Late amendment charge may apply.<Br><Br><B><U>Detailed Cancellation Policy:</U></B><Br>89.18 USDCharges - 100% applicable from time of Booking (Full Cancellation Charges applicable immediately)',current_status='inprocess-booking',booking_status='1',sales_manager_id='0',create_date='2024-01-18 06:50:02',source_type='viator',expiration_date= '2023-12-06 09:00:00',applied_multiplier='1.00000',applied_markup='0',agent_markup='0',basecurrency_multiplier='1.00000',basecurrency_multiplier_native='1.00000',admin_booked='0',service_date='2024-01-21',sub_user_id='',check_out_date='2024-01-21',supplier_profile_id='',agent_currency_multiplier='3.7507', booking_branch_id = '27',site_url = 'https://beta.astrabookings.com/',ip_addr='43.239.53.130',leader_phone=' 9823860012',email_id='shiv.chauhan@qtechsoftware.com',service_type='sightseeing';
[01/18/2024 06:50:02], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO sight_bookings set booking_id='224',native_nightly_rates='a:2:{s:4:\"size\";i:1;s:17:\"nativeNightlyRate\";d:89.180000000000007;}',rate_description='',display_nightly_rates='a:4:{s:4:\"size\";i:1;s:18:\"displayNightlyRate\";d:89.180000000000007;s:25:\"displayNightlyRateDisplay\";s:133:\"Rate - 89.18 USD, Currency Multiplier (USD-USD) - 1.00000, Markup  in % - %, Markup Amount - , Markup Amount in  - ,Other Markup - 0%\";s:23:\"displayNightlyRateStore\";s:134:\"Rate - 89.18 USD, Currency Multiplier (USD-USD) - 1.00000, Markup  in % - %, Markup Amount - , Markup Amount in  -  ,Other Markup - 0%\";}',display_currency_code='USD',native_currency_code='USD',sight_id='333273P2',sight_name='DUBAI LONG SELF-DRIVE QUADBIKE WITH CAMEL AND FALCON- V2',tour_time='',tour_details='',tour_inclusive='<br/>',tour_exclusive=',<br/>',meeting_point='',tour_dep_point=' ',tour_language='en/SERVICE_GUIDE',tour_supplier_phone='',additional_tour_dep_point='',tour_duration='4 hours 0 minutes<br> Start Time: 07:00',arrival_date='2024-01-21',total_adults='2',total_children='',total_infants='',gta_city_code='828',supplier_id='',pick_up_point='',drop_off_point='',from_slot='',to_slot='',total_adult_rate='',total_child_rate='',adult_rate='',child_rate='',display_total_adult_rate='',display_total_child_rate='',display_adult_rate='',display_child_rate='0',additional_service_rate='0',booking_remark='',emergency_cont_no='',terms_n_condition='';
[01/18/2024 06:50:02], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO posted_bookings(id,source_type,reservation_id,create_date,status) values ('','viator','1751','2024-01-18 06:50:02',0);
[01/18/2024 06:51:58], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-18 06:51:58' WHERE id= '309';
[01/18/2024 06:51:58], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO bookings set reservation_id='1751',agent_id='7851',leader_title='Mr',leader_first_name='shiv',leader_last_name='chauhan',city_id='dubai',country_id='138',nationality='Emirati',display_room_rate='89.18',display_currency_code='USD',native_room_rate='89.18',consultant_id='SUJAY_QTECH',native_currency_code='USD',cancellation_policy='Cancellation Charges will be applicable if cancelled after 06 Dec 2023 12:00 hrs.<BR>Late amendment charge may apply.<Br><Br><B><U>Detailed Cancellation Policy:</U></B><Br>89.18 USDCharges - 100% applicable from time of Booking (Full Cancellation Charges applicable immediately)',current_status='inprocess-booking',booking_status='1',sales_manager_id='0',create_date='2024-01-18 06:51:58',source_type='viator',expiration_date= '2023-12-06 09:00:00',applied_multiplier='1.00000',applied_markup='0',agent_markup='0',basecurrency_multiplier='1.00000',basecurrency_multiplier_native='1.00000',admin_booked='0',service_date='2024-01-21',sub_user_id='',check_out_date='2024-01-21',supplier_profile_id='',agent_currency_multiplier='3.7507', booking_branch_id = '27',site_url = 'https://beta.astrabookings.com/',ip_addr='43.239.53.130',leader_phone=' 9823860012',email_id='shiv.chauhan@qtechsoftware.com',service_type='sightseeing';
[01/18/2024 06:51:58], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO sight_bookings set booking_id='225',native_nightly_rates='a:2:{s:4:\"size\";i:1;s:17:\"nativeNightlyRate\";d:89.180000000000007;}',rate_description='',display_nightly_rates='a:4:{s:4:\"size\";i:1;s:18:\"displayNightlyRate\";d:89.180000000000007;s:25:\"displayNightlyRateDisplay\";s:133:\"Rate - 89.18 USD, Currency Multiplier (USD-USD) - 1.00000, Markup  in % - %, Markup Amount - , Markup Amount in  - ,Other Markup - 0%\";s:23:\"displayNightlyRateStore\";s:134:\"Rate - 89.18 USD, Currency Multiplier (USD-USD) - 1.00000, Markup  in % - %, Markup Amount - , Markup Amount in  -  ,Other Markup - 0%\";}',display_currency_code='USD',native_currency_code='USD',sight_id='333273P2',sight_name='DUBAI LONG SELF-DRIVE QUADBIKE WITH CAMEL AND FALCON- V2',tour_time='',tour_details='',tour_inclusive='<br/>',tour_exclusive=',<br/>',meeting_point='',tour_dep_point=' ',tour_language='en/SERVICE_GUIDE',tour_supplier_phone='',additional_tour_dep_point='',tour_duration='4 hours 0 minutes<br> Start Time: 07:00',arrival_date='2024-01-21',total_adults='2',total_children='',total_infants='',gta_city_code='828',supplier_id='',pick_up_point='',drop_off_point='',from_slot='',to_slot='',total_adult_rate='',total_child_rate='',adult_rate='',child_rate='',display_total_adult_rate='',display_total_child_rate='',display_adult_rate='',display_child_rate='0',additional_service_rate='0',booking_remark='',emergency_cont_no='',terms_n_condition='';
[01/18/2024 06:51:58], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO posted_bookings(id,source_type,reservation_id,create_date,status) values ('','viator','1751','2024-01-18 06:51:58',0);
[01/18/2024 06:53:12], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-18 06:53:12' WHERE id= '309';
[01/18/2024 06:53:12], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO bookings set reservation_id='1751',agent_id='7851',leader_title='Mr',leader_first_name='shiv',leader_last_name='chauhan',city_id='dubai',country_id='138',nationality='Emirati',display_room_rate='89.18',display_currency_code='USD',native_room_rate='89.18',consultant_id='SUJAY_QTECH',native_currency_code='USD',cancellation_policy='Cancellation Charges will be applicable if cancelled after 06 Dec 2023 12:00 hrs.<BR>Late amendment charge may apply.<Br><Br><B><U>Detailed Cancellation Policy:</U></B><Br>89.18 USDCharges - 100% applicable from time of Booking (Full Cancellation Charges applicable immediately)',current_status='inprocess-booking',booking_status='1',sales_manager_id='0',create_date='2024-01-18 06:53:12',source_type='viator',expiration_date= '2023-12-06 09:00:00',applied_multiplier='1.00000',applied_markup='0',agent_markup='0',basecurrency_multiplier='1.00000',basecurrency_multiplier_native='1.00000',admin_booked='0',service_date='2024-01-21',sub_user_id='',check_out_date='2024-01-21',supplier_profile_id='',agent_currency_multiplier='3.7507', booking_branch_id = '27',site_url = 'https://beta.astrabookings.com/',ip_addr='43.239.53.130',leader_phone=' 9823860012',email_id='shiv.chauhan@qtechsoftware.com',service_type='sightseeing';
[01/18/2024 06:53:12], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO sight_bookings set booking_id='226',native_nightly_rates='a:2:{s:4:\"size\";i:1;s:17:\"nativeNightlyRate\";d:89.180000000000007;}',rate_description='',display_nightly_rates='a:4:{s:4:\"size\";i:1;s:18:\"displayNightlyRate\";d:89.180000000000007;s:25:\"displayNightlyRateDisplay\";s:133:\"Rate - 89.18 USD, Currency Multiplier (USD-USD) - 1.00000, Markup  in % - %, Markup Amount - , Markup Amount in  - ,Other Markup - 0%\";s:23:\"displayNightlyRateStore\";s:134:\"Rate - 89.18 USD, Currency Multiplier (USD-USD) - 1.00000, Markup  in % - %, Markup Amount - , Markup Amount in  -  ,Other Markup - 0%\";}',display_currency_code='USD',native_currency_code='USD',sight_id='333273P2',sight_name='DUBAI LONG SELF-DRIVE QUADBIKE WITH CAMEL AND FALCON- V2',tour_time='',tour_details='',tour_inclusive='<br/>',tour_exclusive=',<br/>',meeting_point='',tour_dep_point=' ',tour_language='en/SERVICE_GUIDE',tour_supplier_phone='',additional_tour_dep_point='',tour_duration='4 hours 0 minutes<br> Start Time: 07:00',arrival_date='2024-01-21',total_adults='2',total_children='',total_infants='',gta_city_code='828',supplier_id='',pick_up_point='',drop_off_point='',from_slot='',to_slot='',total_adult_rate='',total_child_rate='',adult_rate='',child_rate='',display_total_adult_rate='',display_total_child_rate='',display_adult_rate='',display_child_rate='0',additional_service_rate='0',booking_remark='',emergency_cont_no='',terms_n_condition='';
[01/18/2024 06:53:12], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO posted_bookings(id,source_type,reservation_id,create_date,status) values ('','viator','1751','2024-01-18 06:53:12',0);
