[02/16/2024 06:16:04], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-02-16 06:16:04',login_attempt=0 where id = '7851';
[02/16/2024 06:16:04], [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-02-16 18:16:04', ip = '43.239.53.130', action = 'Login' ;
[02/16/2024 06:16:05], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 06:16:05' WHERE id= '562';
[02/16/2024 06:16:30], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 06:16:30' WHERE id= '562';
[02/16/2024 06:16:34], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 06:16:34' WHERE id= '562';
[02/16/2024 06:16:55], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 06:16:55' WHERE id= '562';
[02/16/2024 06:16:55], [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/03/28',  departure_date='2024/03/28',  nights='1',  create_date='2024-02-16 :18:16:55',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[02/16/2024 06:16:58], [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/16_02_2024/request_availability_Viator_test_18_16_55_1708107415.json', 'v1/16_02_2024/response_availability_Viator_test_18_16_55_1708107415.json', 'v1/16_02_2024/response_header_availability_Viator_test_18_16_55_1708107415.json', 'viator', '2024-02-16 06:16:58', '', '', '1646');
[02/16/2024 06:16:58], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 06:16:58' WHERE id= '562';
[02/16/2024 06:17:41], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 06:17:41' WHERE id= '562';
[02/16/2024 06:17:41], [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/03/28',  departure_date='2024/03/28',  nights='1',  create_date='2024-02-16 :18:17:41',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[02/16/2024 06:17:51], [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/16_02_2024/request_availability_Viator_test_18_17_41_1708107461.json', 'v1/16_02_2024/response_availability_Viator_test_18_17_41_1708107461.json', 'v1/16_02_2024/response_header_availability_Viator_test_18_17_41_1708107461.json', 'viator', '2024-02-16 06:17:51', '', '', '1647');
[02/16/2024 06:17:51], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 06:17:51' WHERE id= '562';
[02/16/2024 06:18:38], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 06:18:38' WHERE id= '562';
[02/16/2024 06:18:38], [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/03/30',  departure_date='2024/03/30',  nights='1',  create_date='2024-02-16 :18:18:38',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[02/16/2024 06:18:41], [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/16_02_2024/request_availability_Viator_test_18_18_38_1708107518.json', 'v1/16_02_2024/response_availability_Viator_test_18_18_38_1708107518.json', 'v1/16_02_2024/response_header_availability_Viator_test_18_18_38_1708107518.json', 'viator', '2024-02-16 06:18:41', '', '', '1648');
[02/16/2024 06:18:42], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 06:18:42' WHERE id= '562';
[02/16/2024 06:20:56], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 06:20:56' WHERE id= '562';
[02/16/2024 06:20:56], [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/02/28',  departure_date='2024/02/28',  nights='1',  create_date='2024-02-16 :18:20:56',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[02/16/2024 06:21:05], [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/16_02_2024/request_availability_Viator_test_18_20_56_1708107656.json', 'v1/16_02_2024/response_availability_Viator_test_18_20_56_1708107656.json', 'v1/16_02_2024/response_header_availability_Viator_test_18_20_56_1708107656.json', 'viator', '2024-02-16 06:21:05', '', '', '1649');
[02/16/2024 06:21:05], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 06:21:05' WHERE id= '562';
[02/16/2024 06:21:20], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 06:21:20' WHERE id= '562';
[02/16/2024 06:21:20], [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/02/21',  departure_date='2024/02/21',  nights='1',  create_date='2024-02-16 :18:21:20',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[02/16/2024 06:21:21], [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/16_02_2024/request_availability_Viator_test_18_21_20_1708107680.json', 'v1/16_02_2024/response_availability_Viator_test_18_21_20_1708107680.json', 'v1/16_02_2024/response_header_availability_Viator_test_18_21_20_1708107680.json', 'viator', '2024-02-16 06:21:21', '', '', '1650');
[02/16/2024 06:21:22], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 06:21:22' WHERE id= '562';
[02/16/2024 06:21:22], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 06:21:22' WHERE id= '562';
[02/16/2024 06:21:51], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 06:21:51' WHERE id= '562';
[02/16/2024 06:21:52], [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/16_02_2024/request_sight_details_Viator_test_18_21_51_1708107711.json', 'v1/16_02_2024/response_sight_details_Viator_test_18_21_51_1708107711.json', 'v1/16_02_2024/response_header_sight_details_Viator_test_18_21_51_1708107711.json', 'viator', '2024-02-16 06:21:52', '', '', '1650');
[02/16/2024 06:21:52], [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/16_02_2024/request_sight_details_Viator_test_18_21_52_1708107712.json', 'v1/16_02_2024/response_sight_details_Viator_test_18_21_52_1708107712.json', 'v1/16_02_2024/response_header_sight_details_Viator_test_18_21_52_1708107712.json', 'viator', '2024-02-16 06:21:52', '', '', '1650');
[02/16/2024 06:21:57], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 06:21:57' WHERE id= '562';
[02/16/2024 06:21:58], [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/16_02_2024/request_sight_details_Viator_test_18_21_57_1708107717.json', 'v1/16_02_2024/response_sight_details_Viator_test_18_21_57_1708107717.json', 'v1/16_02_2024/response_header_sight_details_Viator_test_18_21_57_1708107717.json', 'viator', '2024-02-16 06:21:58', '', '', '1650');
[02/16/2024 06:21:58], [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/16_02_2024/request_sight_details_Viator_test_18_21_58_1708107718.json', 'v1/16_02_2024/response_sight_details_Viator_test_18_21_58_1708107718.json', 'v1/16_02_2024/response_header_sight_details_Viator_test_18_21_58_1708107718.json', 'viator', '2024-02-16 06:21:58', '', '', '1650');
[02/16/2024 06:22:12], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 06:22:12' WHERE id= '562';
[02/16/2024 06:22:12], [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/16_02_2024/request_check_availability_Viator_test_18_22_12_1708107732.json', 'v1/16_02_2024/response_check_availability_Viator_test_18_22_12_1708107732.json', 'v1/16_02_2024/response_header_check_availability_Viator_test_18_22_12_1708107732.json', 'viator', '2024-02-16 06:22:12', '', '', '1650');
[02/16/2024 06:23:35], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 06:23:35' WHERE id= '562';
[02/16/2024 06:23:35], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1708107815','43.239.53.130');
[02/16/2024 06:24:35], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 06:24:35' WHERE id= '562';
[02/16/2024 06:24:35], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1708107875','43.239.53.130');
[02/16/2024 06:24:57], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 06:24:57' WHERE id= '562';
[02/16/2024 06:25:16], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 06:25:16' WHERE id= '562';
[02/16/2024 06:25:22], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 06:25:22' WHERE id= '562';
[02/16/2024 06:25:27], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 06:25:27' WHERE id= '562';
[02/16/2024 06:26:06], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 06:26:06' WHERE id= '562';
[02/16/2024 06:28:21], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 06:28:21' WHERE id= '562';
[02/16/2024 06:28:21], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1708108101','43.239.53.130');
[02/16/2024 06:28:22], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 06:28:22' WHERE id= '562';
[02/16/2024 06:28:22], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO bookings set reservation_id='2865',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='166.5',display_currency_code='USD',native_room_rate='166.5',consultant_id='SUJAY_QTECH',native_currency_code='USD',cancellation_policy='Cancellation Charges will be applicable if cancelled after 19 Feb 2024 03:00 hrs.<BR>Late amendment charge may apply.<Br><Br><B><U>Detailed Cancellation Policy:</U></B><Br>Charges - 166.5  applicable if cancelled after 19 Feb 2024 at 03:00 hrs',current_status='inprocess-booking',booking_status='1',sales_manager_id='0',create_date='2024-02-16 18:28:22',source_type='viator',expiration_date= '2024-02-19 00: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-02-21',sub_user_id='',check_out_date='2024-02-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';
[02/16/2024 06:28:22], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO sight_bookings set booking_id='448',native_nightly_rates='a:2:{s:4:\"size\";i:1;s:17:\"nativeNightlyRate\";d:166.5;}',rate_description='',display_nightly_rates='a:4:{s:4:\"size\";i:1;s:18:\"displayNightlyRate\";d:166.5;s:25:\"displayNightlyRateDisplay\";s:133:\"Rate - 166.5 USD, Currency Multiplier (USD-USD) - 1.00000, Markup  in % - %, Markup Amount - , Markup Amount in  - ,Other Markup - 0%\";s:23:\"displayNightlyRateStore\";s:134:\"Rate - 166.5 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='333273P5',sight_name='PREMIUM RED DUNES BASHING WITH QUAD BIKE, CAMEL, FALCON &VIP CAMP- V2',tour_time='',tour_details='',tour_inclusive='S<br/>',tour_exclusive='A<br/>',meeting_point='',tour_dep_point=' ',tour_language='en/SERVICE_GUIDE',tour_supplier_phone='',additional_tour_dep_point='',tour_duration='7 hours 30 minutes<br> Start Time: 14:00',arrival_date='2024-02-21',total_adults='2',total_children='1',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='',additional_service_rate='0',booking_remark='',emergency_cont_no='',terms_n_condition='';
[02/16/2024 06:28: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','2865','2024-02-16 18:28:22',0);
[02/16/2024 06:30:20], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 06:30:20' WHERE id= '562';
[02/16/2024 06:30:20], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1708108220','43.239.53.130');
[02/16/2024 06:30:21], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 06:30:21' WHERE id= '562';
[02/16/2024 06:30:21], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO bookings set reservation_id='2865',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='166.5',display_currency_code='USD',native_room_rate='166.5',consultant_id='SUJAY_QTECH',native_currency_code='USD',cancellation_policy='Cancellation Charges will be applicable if cancelled after 19 Feb 2024 03:00 hrs.<BR>Late amendment charge may apply.<Br><Br><B><U>Detailed Cancellation Policy:</U></B><Br>Charges - 166.5  applicable if cancelled after 19 Feb 2024 at 03:00 hrs',current_status='inprocess-booking',booking_status='1',sales_manager_id='0',create_date='2024-02-16 18:30:21',source_type='viator',expiration_date= '2024-02-19 00: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-02-21',sub_user_id='',check_out_date='2024-02-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';
[02/16/2024 06:30:21], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO sight_bookings set booking_id='449',native_nightly_rates='a:2:{s:4:\"size\";i:1;s:17:\"nativeNightlyRate\";d:166.5;}',rate_description='',display_nightly_rates='a:4:{s:4:\"size\";i:1;s:18:\"displayNightlyRate\";d:166.5;s:25:\"displayNightlyRateDisplay\";s:133:\"Rate - 166.5 USD, Currency Multiplier (USD-USD) - 1.00000, Markup  in % - %, Markup Amount - , Markup Amount in  - ,Other Markup - 0%\";s:23:\"displayNightlyRateStore\";s:134:\"Rate - 166.5 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='333273P5',sight_name='PREMIUM RED DUNES BASHING WITH QUAD BIKE, CAMEL, FALCON &VIP CAMP- V2',tour_time='',tour_details='',tour_inclusive='S<br/>',tour_exclusive='A<br/>',meeting_point='',tour_dep_point=' ',tour_language='en/SERVICE_GUIDE',tour_supplier_phone='',additional_tour_dep_point='',tour_duration='7 hours 30 minutes<br> Start Time: 14:00',arrival_date='2024-02-21',total_adults='2',total_children='1',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='',additional_service_rate='0',booking_remark='',emergency_cont_no='',terms_n_condition='';
[02/16/2024 06:30:21], [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','2865','2024-02-16 18:30:21',0);
[02/16/2024 06:30:24], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 06:30:24' WHERE id= '562';
[02/16/2024 06:30:24], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1708108224','43.239.53.130');
[02/16/2024 06:31:54], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 06:31:54' WHERE id= '562';
[02/16/2024 06:31:54], [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/02/21',  departure_date='2024/02/21',  nights='1',  create_date='2024-02-16 :18:31:54',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[02/16/2024 06:31:57], [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/16_02_2024/request_availability_Viator_test_18_31_54_1708108314.json', 'v1/16_02_2024/response_availability_Viator_test_18_31_54_1708108314.json', 'v1/16_02_2024/response_header_availability_Viator_test_18_31_54_1708108314.json', 'viator', '2024-02-16 06:31:57', '', '', '1651');
[02/16/2024 06:31:58], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 06:31:58' WHERE id= '562';
[02/16/2024 06:31:58], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 06:31:58' WHERE id= '562';
[02/16/2024 06:33:23], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 06:33:23' WHERE id= '562';
[02/16/2024 06:33:24], [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/16_02_2024/request_sight_details_Viator_test_18_33_23_1708108403.json', 'v1/16_02_2024/response_sight_details_Viator_test_18_33_23_1708108403.json', 'v1/16_02_2024/response_header_sight_details_Viator_test_18_33_23_1708108403.json', 'viator', '2024-02-16 06:33:24', '', '', '1651');
[02/16/2024 06:33:24], [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/16_02_2024/request_sight_details_Viator_test_18_33_24_1708108404.json', 'v1/16_02_2024/response_sight_details_Viator_test_18_33_24_1708108404.json', 'v1/16_02_2024/response_header_sight_details_Viator_test_18_33_24_1708108404.json', 'viator', '2024-02-16 06:33:24', '', '', '1651');
[02/16/2024 06:33:28], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 06:33:28' WHERE id= '562';
[02/16/2024 06:33:29], [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/16_02_2024/request_sight_details_Viator_test_18_33_28_1708108408.json', 'v1/16_02_2024/response_sight_details_Viator_test_18_33_28_1708108408.json', 'v1/16_02_2024/response_header_sight_details_Viator_test_18_33_28_1708108408.json', 'viator', '2024-02-16 06:33:29', '', '', '1651');
[02/16/2024 06:33:29], [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/16_02_2024/request_sight_details_Viator_test_18_33_29_1708108409.json', 'v1/16_02_2024/response_sight_details_Viator_test_18_33_29_1708108409.json', 'v1/16_02_2024/response_header_sight_details_Viator_test_18_33_29_1708108409.json', 'viator', '2024-02-16 06:33:29', '', '', '1651');
[02/16/2024 06:33:34], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 06:33:34' WHERE id= '562';
[02/16/2024 06:33:34], [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/16_02_2024/request_sight_details_Viator_test_18_33_34_1708108414.json', 'v1/16_02_2024/response_sight_details_Viator_test_18_33_34_1708108414.json', 'v1/16_02_2024/response_header_sight_details_Viator_test_18_33_34_1708108414.json', 'viator', '2024-02-16 06:33:34', '', '', '1651');
[02/16/2024 06:33:34], [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/16_02_2024/request_sight_details_Viator_test_18_33_34_1708108414.json', 'v1/16_02_2024/response_sight_details_Viator_test_18_33_34_1708108414.json', 'v1/16_02_2024/response_header_sight_details_Viator_test_18_33_34_1708108414.json', 'viator', '2024-02-16 06:33:34', '', '', '1651');
[02/16/2024 06:35:12], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 06:35:12' WHERE id= '562';
[02/16/2024 06:35:12], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1708108512','43.239.53.130');
[02/16/2024 06:35:40], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 06:35:40' WHERE id= '562';
[02/16/2024 06:35:40], [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/02/21',  departure_date='2024/02/21',  nights='1',  create_date='2024-02-16 :18:35:40',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[02/16/2024 06:35:42], [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/16_02_2024/request_availability_Viator_test_18_35_40_1708108540.json', 'v1/16_02_2024/response_availability_Viator_test_18_35_40_1708108540.json', 'v1/16_02_2024/response_header_availability_Viator_test_18_35_40_1708108540.json', 'viator', '2024-02-16 06:35:42', '', '', '1652');
[02/16/2024 06:35:43], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 06:35:43' WHERE id= '562';
[02/16/2024 06:35:43], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 06:35:43' WHERE id= '562';
[02/16/2024 06:36:37], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 06:36:37' WHERE id= '562';
[02/16/2024 06:36:38], [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/16_02_2024/request_sight_details_Viator_test_18_36_37_1708108597.json', 'v1/16_02_2024/response_sight_details_Viator_test_18_36_37_1708108597.json', 'v1/16_02_2024/response_header_sight_details_Viator_test_18_36_37_1708108597.json', 'viator', '2024-02-16 06:36:38', '', '', '1652');
[02/16/2024 06:36:38], [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/16_02_2024/request_sight_details_Viator_test_18_36_38_1708108598.json', 'v1/16_02_2024/response_sight_details_Viator_test_18_36_38_1708108598.json', 'v1/16_02_2024/response_header_sight_details_Viator_test_18_36_38_1708108598.json', 'viator', '2024-02-16 06:36:38', '', '', '1652');
[02/16/2024 06:36:49], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 06:36:49' WHERE id= '562';
[02/16/2024 06:36:49], [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/16_02_2024/request_check_availability_Viator_test_18_36_49_1708108609.json', 'v1/16_02_2024/response_check_availability_Viator_test_18_36_49_1708108609.json', 'v1/16_02_2024/response_header_check_availability_Viator_test_18_36_49_1708108609.json', 'viator', '2024-02-16 06:36:49', '', '', '1652');
[02/16/2024 06:37:01], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 06:37:01' WHERE id= '562';
[02/16/2024 06:37:01], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1708108621','43.239.53.130');
[02/16/2024 06:37:10], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 06:37:10' WHERE id= '562';
[02/16/2024 06:37:13], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 06:37:13' WHERE id= '562';
[02/16/2024 06:37:15], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 06:37:15' WHERE id= '562';
[02/16/2024 06:37:19], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 06:37:19' WHERE id= '562';
[02/16/2024 06:38:08], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 06:38:08' WHERE id= '562';
[02/16/2024 06:38:08], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1708108688','43.239.53.130');
[02/16/2024 06:38:09], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 06:38:09' WHERE id= '562';
[02/16/2024 06:38:09], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO bookings set reservation_id='2870',agent_id='7851',leader_title='Mr',leader_first_name='dfs',leader_last_name='sda',city_id='dubai',country_id='138',nationality='Emirati',display_room_rate='166.5',display_currency_code='USD',native_room_rate='166.5',consultant_id='SUJAY_QTECH',native_currency_code='USD',cancellation_policy='Cancellation Charges will be applicable if cancelled after 19 Feb 2024 03:00 hrs.<BR>Late amendment charge may apply.<Br><Br><B><U>Detailed Cancellation Policy:</U></B><Br>Charges - 166.5  applicable if cancelled after 19 Feb 2024 at 03:00 hrs',current_status='inprocess-booking',booking_status='1',sales_manager_id='0',create_date='2024-02-16 18:38:09',source_type='viator',expiration_date= '2024-02-19 00: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-02-21',sub_user_id='',check_out_date='2024-02-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';
[02/16/2024 06:38:09], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO sight_bookings set booking_id='450',native_nightly_rates='a:2:{s:4:\"size\";i:1;s:17:\"nativeNightlyRate\";d:166.5;}',rate_description='',display_nightly_rates='a:4:{s:4:\"size\";i:1;s:18:\"displayNightlyRate\";d:166.5;s:25:\"displayNightlyRateDisplay\";s:133:\"Rate - 166.5 USD, Currency Multiplier (USD-USD) - 1.00000, Markup  in % - %, Markup Amount - , Markup Amount in  - ,Other Markup - 0%\";s:23:\"displayNightlyRateStore\";s:134:\"Rate - 166.5 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='333273P5',sight_name='PREMIUM RED DUNES BASHING WITH QUAD BIKE, CAMEL, FALCON &VIP CAMP- V2',tour_time='',tour_details='',tour_inclusive='S<br/>',tour_exclusive='A<br/>',meeting_point='',tour_dep_point=' ',tour_language='en/SERVICE_GUIDE',tour_supplier_phone='',additional_tour_dep_point='',tour_duration='7 hours 30 minutes<br> Start Time: 14:00',arrival_date='2024-02-21',total_adults='2',total_children='1',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='',additional_service_rate='0',booking_remark='',emergency_cont_no='',terms_n_condition='';
[02/16/2024 06:38:09], [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','2870','2024-02-16 18:38:09',0);
[02/16/2024 06:38:10], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 06:38:10' WHERE id= '562';
[02/16/2024 06:38:10], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO bookings set reservation_id='2870',agent_id='7851',leader_title='Mr',leader_first_name='dfs',leader_last_name='sda',city_id='dubai',country_id='138',nationality='Emirati',display_room_rate='166.5',display_currency_code='USD',native_room_rate='166.5',consultant_id='SUJAY_QTECH',native_currency_code='USD',cancellation_policy='Cancellation Charges will be applicable if cancelled after 19 Feb 2024 03:00 hrs.<BR>Late amendment charge may apply.<Br><Br><B><U>Detailed Cancellation Policy:</U></B><Br>Charges - 166.5  applicable if cancelled after 19 Feb 2024 at 03:00 hrs',current_status='inprocess-booking',booking_status='1',sales_manager_id='0',create_date='2024-02-16 18:38:10',source_type='viator',expiration_date= '2024-02-19 00: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-02-21',sub_user_id='',check_out_date='2024-02-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';
[02/16/2024 06:38:10], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO sight_bookings set booking_id='451',native_nightly_rates='a:2:{s:4:\"size\";i:1;s:17:\"nativeNightlyRate\";d:166.5;}',rate_description='',display_nightly_rates='a:4:{s:4:\"size\";i:1;s:18:\"displayNightlyRate\";d:166.5;s:25:\"displayNightlyRateDisplay\";s:133:\"Rate - 166.5 USD, Currency Multiplier (USD-USD) - 1.00000, Markup  in % - %, Markup Amount - , Markup Amount in  - ,Other Markup - 0%\";s:23:\"displayNightlyRateStore\";s:134:\"Rate - 166.5 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='333273P5',sight_name='PREMIUM RED DUNES BASHING WITH QUAD BIKE, CAMEL, FALCON &VIP CAMP- V2',tour_time='',tour_details='',tour_inclusive='S<br/>',tour_exclusive='A<br/>',meeting_point='',tour_dep_point=' ',tour_language='en/SERVICE_GUIDE',tour_supplier_phone='',additional_tour_dep_point='',tour_duration='7 hours 30 minutes<br> Start Time: 14:00',arrival_date='2024-02-21',total_adults='2',total_children='1',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='',additional_service_rate='0',booking_remark='',emergency_cont_no='',terms_n_condition='';
[02/16/2024 06:38:10], [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','2870','2024-02-16 18:38:10',0);
[02/16/2024 06:43:40], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 06:43:40' WHERE id= '562';
[02/16/2024 06:43:40], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO bookings set reservation_id='2870',agent_id='7851',leader_title='Mr',leader_first_name='dfs',leader_last_name='sda',city_id='dubai',country_id='138',nationality='Emirati',display_room_rate='166.5',display_currency_code='USD',native_room_rate='166.5',consultant_id='SUJAY_QTECH',native_currency_code='USD',cancellation_policy='Cancellation Charges will be applicable if cancelled after 19 Feb 2024 03:00 hrs.<BR>Late amendment charge may apply.<Br><Br><B><U>Detailed Cancellation Policy:</U></B><Br>Charges - 166.5  applicable if cancelled after 19 Feb 2024 at 03:00 hrs',current_status='inprocess-booking',booking_status='1',sales_manager_id='0',create_date='2024-02-16 18:43:40',source_type='viator',expiration_date= '2024-02-19 00: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-02-21',sub_user_id='',check_out_date='2024-02-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';
[02/16/2024 06:43:40], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO sight_bookings set booking_id='452',native_nightly_rates='a:2:{s:4:\"size\";i:1;s:17:\"nativeNightlyRate\";d:166.5;}',rate_description='',display_nightly_rates='a:4:{s:4:\"size\";i:1;s:18:\"displayNightlyRate\";d:166.5;s:25:\"displayNightlyRateDisplay\";s:133:\"Rate - 166.5 USD, Currency Multiplier (USD-USD) - 1.00000, Markup  in % - %, Markup Amount - , Markup Amount in  - ,Other Markup - 0%\";s:23:\"displayNightlyRateStore\";s:134:\"Rate - 166.5 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='333273P5',sight_name='PREMIUM RED DUNES BASHING WITH QUAD BIKE, CAMEL, FALCON &VIP CAMP- V2',tour_time='',tour_details='',tour_inclusive='S<br/>',tour_exclusive='A<br/>',meeting_point='',tour_dep_point=' ',tour_language='en/SERVICE_GUIDE',tour_supplier_phone='',additional_tour_dep_point='',tour_duration='7 hours 30 minutes<br> Start Time: 14:00',arrival_date='2024-02-21',total_adults='2',total_children='1',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='',additional_service_rate='0',booking_remark='',emergency_cont_no='',terms_n_condition='';
[02/16/2024 06:43:40], [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','2870','2024-02-16 18:43:40',0);
[02/16/2024 06:44:02], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 06:44:02' WHERE id= '562';
[02/16/2024 06:44:02], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1708109042','43.239.53.130');
[02/16/2024 06:44:02], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 06:44:02' WHERE id= '562';
[02/16/2024 06:44:02], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO bookings set reservation_id='2870',agent_id='7851',leader_title='Mr',leader_first_name='dfs',leader_last_name='sda',city_id='dubai',country_id='138',nationality='Emirati',display_room_rate='166.5',display_currency_code='USD',native_room_rate='166.5',consultant_id='SUJAY_QTECH',native_currency_code='USD',cancellation_policy='Cancellation Charges will be applicable if cancelled after 19 Feb 2024 03:00 hrs.<BR>Late amendment charge may apply.<Br><Br><B><U>Detailed Cancellation Policy:</U></B><Br>Charges - 166.5  applicable if cancelled after 19 Feb 2024 at 03:00 hrs',current_status='inprocess-booking',booking_status='1',sales_manager_id='0',create_date='2024-02-16 18:44:02',source_type='viator',expiration_date= '2024-02-19 00: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-02-21',sub_user_id='',check_out_date='2024-02-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';
[02/16/2024 06:44:02], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO sight_bookings set booking_id='453',native_nightly_rates='a:2:{s:4:\"size\";i:1;s:17:\"nativeNightlyRate\";d:166.5;}',rate_description='',display_nightly_rates='a:4:{s:4:\"size\";i:1;s:18:\"displayNightlyRate\";d:166.5;s:25:\"displayNightlyRateDisplay\";s:133:\"Rate - 166.5 USD, Currency Multiplier (USD-USD) - 1.00000, Markup  in % - %, Markup Amount - , Markup Amount in  - ,Other Markup - 0%\";s:23:\"displayNightlyRateStore\";s:134:\"Rate - 166.5 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='333273P5',sight_name='PREMIUM RED DUNES BASHING WITH QUAD BIKE, CAMEL, FALCON &VIP CAMP- V2',tour_time='',tour_details='',tour_inclusive='S<br/>',tour_exclusive='A<br/>',meeting_point='',tour_dep_point=' ',tour_language='en/SERVICE_GUIDE',tour_supplier_phone='',additional_tour_dep_point='',tour_duration='7 hours 30 minutes<br> Start Time: 14:00',arrival_date='2024-02-21',total_adults='2',total_children='1',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='',additional_service_rate='0',booking_remark='',emergency_cont_no='',terms_n_condition='';
[02/16/2024 06:44: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','2870','2024-02-16 18:44:02',0);
[02/16/2024 06:44:11], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 06:44:11' WHERE id= '562';
[02/16/2024 06:44:11], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1708109051','43.239.53.130');
[02/16/2024 06:44:33], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 06:44:33' WHERE id= '562';
[02/16/2024 06:44:33], [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/02/21',  departure_date='2024/02/21',  nights='1',  create_date='2024-02-16 :18:44:33',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[02/16/2024 06:44:33], [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/16_02_2024/request_availability_Viator_test_18_44_33_1708109073.json', 'v1/16_02_2024/response_availability_Viator_test_18_44_33_1708109073.json', 'v1/16_02_2024/response_header_availability_Viator_test_18_44_33_1708109073.json', 'viator', '2024-02-16 06:44:33', '', '', '1653');
[02/16/2024 06:44:34], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 06:44:34' WHERE id= '562';
[02/16/2024 06:44:34], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 06:44:34' WHERE id= '562';
[02/16/2024 06:44:49], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 06:44:49' WHERE id= '562';
[02/16/2024 06:44:49], [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/16_02_2024/request_sight_details_Viator_test_18_44_49_1708109089.json', 'v1/16_02_2024/response_sight_details_Viator_test_18_44_49_1708109089.json', 'v1/16_02_2024/response_header_sight_details_Viator_test_18_44_49_1708109089.json', 'viator', '2024-02-16 06:44:49', '', '', '1653');
[02/16/2024 06:44:49], [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/16_02_2024/request_sight_details_Viator_test_18_44_49_1708109089.json', 'v1/16_02_2024/response_sight_details_Viator_test_18_44_49_1708109089.json', 'v1/16_02_2024/response_header_sight_details_Viator_test_18_44_49_1708109089.json', 'viator', '2024-02-16 06:44:49', '', '', '1653');
[02/16/2024 06:45:07], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 06:45:07' WHERE id= '562';
[02/16/2024 06:45:08], [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/16_02_2024/request_check_availability_Viator_test_18_45_07_1708109107.json', 'v1/16_02_2024/response_check_availability_Viator_test_18_45_07_1708109107.json', 'v1/16_02_2024/response_header_check_availability_Viator_test_18_45_07_1708109107.json', 'viator', '2024-02-16 06:45:08', '', '', '1653');
[02/16/2024 06:45:35], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 06:45:35' WHERE id= '562';
[02/16/2024 06:45:35], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1708109135','43.239.53.130');
[02/16/2024 06:46:21], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 06:46:21' WHERE id= '562';
[02/16/2024 06:46:23], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 06:46:23' WHERE id= '562';
[02/16/2024 06:46:25], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 06:46:25' WHERE id= '562';
[02/16/2024 06:46:27], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 06:46:27' WHERE id= '562';
[02/16/2024 06:47:31], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 06:47:31' WHERE id= '562';
[02/16/2024 06:47:31], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1708109251','43.239.53.130');
[02/16/2024 06:47:31], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 06:47:31' WHERE id= '562';
[02/16/2024 06:47:31], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO bookings set reservation_id='2874',agent_id='7851',leader_title='Mr',leader_first_name='fsfsd',leader_last_name='sdfs',city_id='dubai',country_id='138',nationality='Emirati',display_room_rate='166.5',display_currency_code='USD',native_room_rate='166.5',consultant_id='SUJAY_QTECH',native_currency_code='USD',cancellation_policy='Cancellation Charges will be applicable if cancelled after 19 Feb 2024 03:00 hrs.<BR>Late amendment charge may apply.<Br><Br><B><U>Detailed Cancellation Policy:</U></B><Br>Charges - 166.5  applicable if cancelled after 19 Feb 2024 at 03:00 hrs',current_status='inprocess-booking',booking_status='1',sales_manager_id='0',create_date='2024-02-16 18:47:31',source_type='viator',expiration_date= '2024-02-19 00: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-02-21',sub_user_id='',check_out_date='2024-02-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';
[02/16/2024 06:47:31], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO sight_bookings set booking_id='454',native_nightly_rates='a:2:{s:4:\"size\";i:1;s:17:\"nativeNightlyRate\";d:166.5;}',rate_description='',display_nightly_rates='a:4:{s:4:\"size\";i:1;s:18:\"displayNightlyRate\";d:166.5;s:25:\"displayNightlyRateDisplay\";s:133:\"Rate - 166.5 USD, Currency Multiplier (USD-USD) - 1.00000, Markup  in % - %, Markup Amount - , Markup Amount in  - ,Other Markup - 0%\";s:23:\"displayNightlyRateStore\";s:134:\"Rate - 166.5 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='333273P5',sight_name='PREMIUM RED DUNES BASHING WITH QUAD BIKE, CAMEL, FALCON &VIP CAMP- V2',tour_time='',tour_details='',tour_inclusive='S<br/>',tour_exclusive='A<br/>',meeting_point='',tour_dep_point=' ',tour_language='en/SERVICE_GUIDE',tour_supplier_phone='',additional_tour_dep_point='',tour_duration='7 hours 30 minutes<br> Start Time: 14:00',arrival_date='2024-02-21',total_adults='2',total_children='1',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='',additional_service_rate='0',booking_remark='',emergency_cont_no='',terms_n_condition='';
[02/16/2024 06:47:31], [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','2874','2024-02-16 18:47:31',0);
[02/16/2024 06:49:24], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 06:49:24' WHERE id= '562';
[02/16/2024 06:49:24], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO bookings set reservation_id='2874',agent_id='7851',leader_title='Mr',leader_first_name='fsfsd',leader_last_name='sdfs',city_id='dubai',country_id='138',nationality='Emirati',display_room_rate='166.5',display_currency_code='USD',native_room_rate='166.5',consultant_id='SUJAY_QTECH',native_currency_code='USD',cancellation_policy='Cancellation Charges will be applicable if cancelled after 19 Feb 2024 03:00 hrs.<BR>Late amendment charge may apply.<Br><Br><B><U>Detailed Cancellation Policy:</U></B><Br>Charges - 166.5  applicable if cancelled after 19 Feb 2024 at 03:00 hrs',current_status='inprocess-booking',booking_status='1',sales_manager_id='0',create_date='2024-02-16 18:49:24',source_type='viator',expiration_date= '2024-02-19 00: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-02-21',sub_user_id='',check_out_date='2024-02-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';
[02/16/2024 06:49:24], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO sight_bookings set booking_id='455',native_nightly_rates='a:2:{s:4:\"size\";i:1;s:17:\"nativeNightlyRate\";d:166.5;}',rate_description='',display_nightly_rates='a:4:{s:4:\"size\";i:1;s:18:\"displayNightlyRate\";d:166.5;s:25:\"displayNightlyRateDisplay\";s:133:\"Rate - 166.5 USD, Currency Multiplier (USD-USD) - 1.00000, Markup  in % - %, Markup Amount - , Markup Amount in  - ,Other Markup - 0%\";s:23:\"displayNightlyRateStore\";s:134:\"Rate - 166.5 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='333273P5',sight_name='PREMIUM RED DUNES BASHING WITH QUAD BIKE, CAMEL, FALCON &VIP CAMP- V2',tour_time='',tour_details='',tour_inclusive='S<br/>',tour_exclusive='A<br/>',meeting_point='',tour_dep_point=' ',tour_language='en/SERVICE_GUIDE',tour_supplier_phone='',additional_tour_dep_point='',tour_duration='7 hours 30 minutes<br> Start Time: 14:00',arrival_date='2024-02-21',total_adults='2',total_children='1',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='',additional_service_rate='0',booking_remark='',emergency_cont_no='',terms_n_condition='';
[02/16/2024 06:49: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','2874','2024-02-16 18:49:24',0);
[02/16/2024 06:54:19], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 06:54:19' WHERE id= '562';
[02/16/2024 06:54:24], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 06:54:24' WHERE id= '562';
[02/16/2024 06:54:28], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 06:54:28' WHERE id= '562';
[02/16/2024 06:54:28], [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/02/21',  departure_date='2024/02/21',  nights='1',  create_date='2024-02-16 :18:54:28',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[02/16/2024 06:54:28], [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/16_02_2024/request_availability_Viator_test_18_54_28_1708109668.json', 'v1/16_02_2024/response_availability_Viator_test_18_54_28_1708109668.json', 'v1/16_02_2024/response_header_availability_Viator_test_18_54_28_1708109668.json', 'viator', '2024-02-16 06:54:28', '', '', '1654');
[02/16/2024 06:54:30], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 06:54:30' WHERE id= '562';
[02/16/2024 06:54:30], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 06:54:30' WHERE id= '562';
[02/16/2024 06:54:40], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 06:54:40' WHERE id= '562';
[02/16/2024 06:54:40], [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/16_02_2024/request_sight_details_Viator_test_18_54_40_1708109680.json', 'v1/16_02_2024/response_sight_details_Viator_test_18_54_40_1708109680.json', 'v1/16_02_2024/response_header_sight_details_Viator_test_18_54_40_1708109680.json', 'viator', '2024-02-16 06:54:40', '', '', '1654');
[02/16/2024 06:54:40], [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/16_02_2024/request_sight_details_Viator_test_18_54_40_1708109680.json', 'v1/16_02_2024/response_sight_details_Viator_test_18_54_40_1708109680.json', 'v1/16_02_2024/response_header_sight_details_Viator_test_18_54_40_1708109680.json', 'viator', '2024-02-16 06:54:40', '', '', '1654');
[02/16/2024 06:54:51], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 06:54:51' WHERE id= '562';
[02/16/2024 06:54:51], [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/16_02_2024/request_check_availability_Viator_test_18_54_51_1708109691.json', 'v1/16_02_2024/response_check_availability_Viator_test_18_54_51_1708109691.json', 'v1/16_02_2024/response_header_check_availability_Viator_test_18_54_51_1708109691.json', 'viator', '2024-02-16 06:54:51', '', '', '1654');
[02/16/2024 06:56:58], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 06:56:58' WHERE id= '562';
[02/16/2024 06:57:00], [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/16_02_2024/request_check_availability_Viator_test_18_56_58_1708109818.json', 'v1/16_02_2024/response_check_availability_Viator_test_18_56_58_1708109818.json', 'v1/16_02_2024/response_header_check_availability_Viator_test_18_56_58_1708109818.json', 'viator', '2024-02-16 06:57:00', '', '', '1654');
