[01/24/2024 02:11:43], [file name :-/home/otrams/public_html/beta/tms/get_cancellation_fee_sight.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header)
                    VALUE('360', 'sight_cancellation_fee', 'v1/24_01_2024/request_sight_cancellation_fee_admin_360_14_11_43_1706105503.json', 'v1/24_01_2024/response_sight_cancellation_fee_admin_360_14_11_43_1706105503.json', 'v1/24_01_2024/response_header_sight_cancellation_fee_admin_360_14_11_43_1706105503.json', 'viator', '2024-01-24 02:11:43', '');
[01/24/2024 02:12:36], [file name :-/home/otrams/public_html/beta/tms/get_cancellation_fee_sight.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header)
                    VALUE('360', 'sight_cancellation_fee', 'v1/24_01_2024/request_sight_cancellation_fee_admin_360_14_12_35_1706105555.json', 'v1/24_01_2024/response_sight_cancellation_fee_admin_360_14_12_35_1706105555.json', 'v1/24_01_2024/response_header_sight_cancellation_fee_admin_360_14_12_35_1706105555.json', 'viator', '2024-01-24 02:12:36', '');
[01/24/2024 02:12:37], [file name :-/home/otrams/public_html/beta/tms/get_cancellation_fee_sight.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header)
                    VALUE('360', 'sight_cancellation_fee', 'v1/24_01_2024/request_sight_cancellation_fee_admin_360_14_12_37_1706105557.json', 'v1/24_01_2024/response_sight_cancellation_fee_admin_360_14_12_37_1706105557.json', 'v1/24_01_2024/response_header_sight_cancellation_fee_admin_360_14_12_37_1706105557.json', 'viator', '2024-01-24 02:12:37', '');
[01/24/2024 02:14:45], [file name :-/home/otrams/public_html/beta/tms/get_cancellation_fee_sight.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header)
                    VALUE('360', 'sight_cancellation_fee', 'v1/24_01_2024/request_sight_cancellation_fee_admin_360_14_14_45_1706105685.json', 'v1/24_01_2024/response_sight_cancellation_fee_admin_360_14_14_45_1706105685.json', 'v1/24_01_2024/response_header_sight_cancellation_fee_admin_360_14_14_45_1706105685.json', 'viator', '2024-01-24 02:14:45', '');
[01/24/2024 02:14:51], [file name :-/home/otrams/public_html/beta/tms/view_booking_sight.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header)
                    VALUE('360', 'sight_cancellation', 'v1/24_01_2024/request_sight_cancellation_admin_360_14_14_51_1706105691.json', 'v1/24_01_2024/response_sight_cancellation_admin_360_14_14_51_1706105691.json', 'v1/24_01_2024/response_header_sight_cancellation_admin_360_14_14_51_1706105691.json', 'viator', '2024-01-24 02:14:51', '');
[01/24/2024 02:14:51], [file name :-/home/otrams/public_html/beta/tms/view_booking_sight.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
		('','','360','inprocess_cancel','2024-01-24 14:14:51','Cancellation request has been sent and we will refer with the cancellation charges by v3alpha','v3alpha','43.239.53.130','v3alpha','','');
[01/24/2024 02:14:51], [file name :-/home/otrams/public_html/beta/tms/view_booking_sight.php],UPDATE bookings SET current_status='inprocess_cancel',status_date='2024-01-24 14:14:51' WHERE reservation_id = '2292' AND id = '360' AND (current_status = 'pending' OR  current_status = 'confirmed' OR  current_status = 'vouchered' OR  current_status = 'on_request') ;
[01/24/2024 02:33:47], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-24 02:33:47',login_attempt=0 where id = '7851';
[01/24/2024 02:33:47], [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-24 14:33:47', ip = '43.239.53.130', action = 'Login' ;
[01/24/2024 02:33:47], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 02:33:47' WHERE id= '309';
[01/24/2024 02:33:52], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 02:33:52' WHERE id= '309';
[01/24/2024 02:33:56], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 02:33:56' WHERE id= '309';
[01/24/2024 02:34:03], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 02:34:03' WHERE id= '309';
[01/24/2024 02:34:04], [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-01-24 :14:34:04',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/24/2024 02:34: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/24_01_2024/request_availability_Viator_test_14_34_04_1706106844.json', 'v1/24_01_2024/response_availability_Viator_test_14_34_04_1706106844.json', 'v1/24_01_2024/response_header_availability_Viator_test_14_34_04_1706106844.json', 'viator', '2024-01-24 02:34:05', '', '', '1129');
[01/24/2024 02:34:07], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 02:34:07' WHERE id= '309';
[01/24/2024 02:34:08], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 02:34:08' WHERE id= '309';
[01/24/2024 02:34:10], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 02:34:10' WHERE id= '309';
[01/24/2024 02:34:10], [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/24_01_2024/request_sight_details_Viator_test_14_34_10_1706106850.json', 'v1/24_01_2024/response_sight_details_Viator_test_14_34_10_1706106850.json', 'v1/24_01_2024/response_header_sight_details_Viator_test_14_34_10_1706106850.json', 'viator', '2024-01-24 02:34:10', '', '', '1129');
[01/24/2024 02:34:13], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 02:34:13' WHERE id= '309';
[01/24/2024 02:34:14], [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/24_01_2024/request_check_availability_Viator_test_14_34_13_1706106853.json', 'v1/24_01_2024/response_check_availability_Viator_test_14_34_13_1706106853.json', 'v1/24_01_2024/response_header_check_availability_Viator_test_14_34_13_1706106853.json', 'viator', '2024-01-24 02:34:14', '', '', '1129');
[01/24/2024 02:34:16], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 02:34:16' WHERE id= '309';
[01/24/2024 02:34:16], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1706106856','43.239.53.130');
[01/24/2024 02:34:25], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 02:34:25' WHERE id= '309';
[01/24/2024 02:34:28], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 02:34:28' WHERE id= '309';
[01/24/2024 02:34:32], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 02:34:32' WHERE id= '309';
[01/24/2024 02:34:36], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 02:34:36' WHERE id= '309';
[01/24/2024 02:34:39], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 02:34:39' WHERE id= '309';
[01/24/2024 02:35:06], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 02:35:06' WHERE id= '309';
[01/24/2024 02:35:06], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1706106906','43.239.53.130');
[01/24/2024 02:35:07], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 02:35:07' WHERE id= '309';
[01/24/2024 02:35:07], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO bookings set reservation_id='2303',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 12 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-24 14:35:07',source_type='viator',expiration_date= '2023-12-12 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-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';
[01/24/2024 02:35:07], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO sight_bookings set booking_id='361',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-02-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/24/2024 02:35: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','2303','2024-01-24 14:35:07',0);
[01/24/2024 02:35:10], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'reservation_sight', 'v1/24_01_2024/request_reservation_sight_Viator_test_14_35_07_1706106907.json', 'v1/24_01_2024/response_reservation_sight_Viator_test_14_35_07_1706106907.json', 'v1/24_01_2024/response_header_reservation_sight_Viator_test_14_35_07_1706106907.json', 'viator', '2024-01-24 02:35:10', '', '', '1129');
[01/24/2024 02:35:10], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE posted_bookings set status=1 where id= '198';
[01/24/2024 02:35:10], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],update bookings set  parent_agent_id='7851', applicable_service_tax='0', sub_agent_rate='0', agent_rate='89.18', supplier_rate='89.18', uid='', itenirary_id='2303547', confirmation_number='BR-595267837', comment_contract='', current_status='confirmed', original_source='' where id='361';
[01/24/2024 02:35:10], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],update sight_bookings set gtaToken='',gta_item_confirm_ref='',tour_supplier='',textaddition_activities='N;' where booking_id='361';
[01/24/2024 02:35:10], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
		('','','361','confirmed','2024-01-24 14:35:10','Sightseeing Booking confirmed by Agent..7851','7851','43.239.53.130','','','');
[01/24/2024 02:35:10], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],insert into sight_passangers(booking_id,salutations,tour,first_name,last_name,passenger_type,age)values('361','Mr','1','shiv','chauhan','adult','0');
[01/24/2024 02:35:10], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],insert into sight_passangers(booking_id,salutations,tour,first_name,last_name,passenger_type,age)values('361','Mr','1','rohit','shukla','adult','0');
[01/24/2024 02:35:10], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],update xmllogs set reservation_id='361' where agent_logs_id='1129' and source_type='viator';
[01/24/2024 02:35:15], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],update bookings set invoice_number= 'INV24012400004', voucher_id='2401143515',status_date='2024-01-24 14:35:15',current_status='vouchered',voucher_hashcode='6b9080346de8f9d3c4e501e1ad49d55489175361',vouchered_by ='' where id='361';
[01/24/2024 02:35:15], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],update bookings set is_invoiced='yes',invoice_number= 'INV24012400004' where id='361' and is_invoiced!='yes';
[01/24/2024 02:35:15], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE agents SET credit_usage=credit_usage+('334.487426'),   credit_value= credit_value-('334.487426') ,  cd_credit_usage=cd_credit_usage+('334.487426') , cd_credit_value=cd_credit_value-('334.487426')  WHERE id = '7851';
[01/24/2024 02:35:15], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],insert into  agent_credit_log SET agent_id= '7851',credit_value= '3537.802',credit_usage= '6462.198',credit_limit= '10000.000',receipt_id= '',amount= '334.487426',booking_id='361',booking_cost= '',receipt_allocation= '',balance= '',ip='43.239.53.130',user_type='User',admin_id='Agent - Viator  Viator(CD7851)',temp_credit_limit='',log_type='Add Invoice',note='Add Invoice',create_date='2024-01-24 14:01:15';
[01/24/2024 02:35:15], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php], insert into booking_rate_info set  booking_id = '361', booking_log = 'Booking Vouchered', create_date = '2024-01-24 14:35:15', supplier_currency ='USD', type = 'Sale', agent_price = '89.18', sub_agent_price ='', supplier_price = '89.180', supplier_id = 'viator', supplier_type = 'online';
[01/24/2024 02:35:17], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
		('','','361','vouchered-invoiced','2024-01-24 14:35:17','Booking invoiced by Back Office v3alpha on behalf of Agent - Viator  Viator(CD7851)','7851','43.239.53.130','','','');
[01/24/2024 02:35:17], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO agent_commission SET booking_id ='361',booking_detail_id ='361',agent_id ='7851',is_sub_agent ='N',parent_id ='',display_commission ='0',display_currency ='USD',paid ='N',type ='sightseeing',description ='Agent Mark Up Percentage is 0 %',create_date ='2024-01-24 14:35:17';
[01/24/2024 02:35:17], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
		('','','361','vouchered','2024-01-24 14:35:17','Voucherd by Back Office v3alpha on behalf of Agent - Viator  Viator(CD7851)','7851','43.239.53.130','','','');
[01/24/2024 02:37:53], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 02:37:53' WHERE id= '309';
[01/24/2024 02:37:57], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 02:37:57' WHERE id= '309';
[01/24/2024 02:38:04], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 02:38:04' WHERE id= '309';
[01/24/2024 02:38:10], [file name :-/home/otrams/public_html/beta/booking_list_sight.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 02:38:10' WHERE id= '309';
[01/24/2024 02:38:25], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 02:38:25' WHERE id= '309';
[01/24/2024 02:38:30], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 02:38:30' WHERE id= '309';
[01/24/2024 02:38:36], [file name :-/home/otrams/public_html/beta/booking_list_sight.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 02:38:36' WHERE id= '309';
[01/24/2024 02:41:39], [file name :-/home/otrams/public_html/beta/booking_list_sight.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 02:41:39' WHERE id= '309';
[01/24/2024 02:41:51], [file name :-/home/otrams/public_html/beta/get_cancellation_fee_sight.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 02:41:51' WHERE id= '309';
[01/24/2024 02:42:23], [file name :-/home/otrams/public_html/beta/get_cancellation_fee_sight.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 02:42:23' WHERE id= '309';
[01/24/2024 02:42:23], [file name :-/home/otrams/public_html/beta/get_cancellation_fee_sight.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header)
                    VALUE('361', 'sight_cancellation_fee', 'v1/24_01_2024/request_sight_cancellation_fee_Viator_test_361_14_42_23_1706107343.json', 'v1/24_01_2024/response_sight_cancellation_fee_Viator_test_361_14_42_23_1706107343.json', 'v1/24_01_2024/response_header_sight_cancellation_fee_Viator_test_361_14_42_23_1706107343.json', 'viator', '2024-01-24 02:42:23', '');
[01/24/2024 02:42:33], [file name :-/home/otrams/public_html/beta/booking_list_sight.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 02:42:33' WHERE id= '309';
[01/24/2024 02:42:33], [file name :-/home/otrams/public_html/beta/booking_list_sight.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header)
                    VALUE('361', 'sight_cancellation', 'v1/24_01_2024/request_sight_cancellation_Viator_test_361_14_42_33_1706107353.json', 'v1/24_01_2024/response_sight_cancellation_Viator_test_361_14_42_33_1706107353.json', 'v1/24_01_2024/response_header_sight_cancellation_Viator_test_361_14_42_33_1706107353.json', 'viator', '2024-01-24 02:42:33', '');
[01/24/2024 02:42:33], [file name :-/home/otrams/public_html/beta/booking_list_sight.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
		('','','361','inprocess_cancel','2024-01-24 14:42:33','Cancellation request has been sent and we will refer with the cancellation charges','7851','43.239.53.130','','','');
[01/24/2024 02:42:33], [file name :-/home/otrams/public_html/beta/booking_list_sight.php],UPDATE bookings SET current_status='inprocess_cancel',status_date='2024-01-24 14:42:33' WHERE reservation_id = '2303' AND id = '361' AND (current_status = 'pending' OR  current_status = 'confirmed' OR  current_status = 'vouchered' OR  current_status = 'on_request') ;
[01/24/2024 02:42:40], [file name :-/home/otrams/public_html/beta/index.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 02:42:40' WHERE id= '309';
[01/24/2024 02:42:40], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 02:42:40' WHERE id= '309';
[01/24/2024 02:42:41], [file name :-/home/otrams/public_html/beta/booking_list_sight.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 02:42:41' WHERE id= '309';
[01/24/2024 02:43:13], [file name :-/home/otrams/public_html/beta/get_cancellation_fee_sight.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 02:43:13' WHERE id= '309';
[01/24/2024 02:43:13], [file name :-/home/otrams/public_html/beta/get_cancellation_fee_sight.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header)
                    VALUE('361', 'sight_cancellation_fee', 'v1/24_01_2024/request_sight_cancellation_fee_Viator_test_361_14_43_13_1706107393.json', 'v1/24_01_2024/response_sight_cancellation_fee_Viator_test_361_14_43_13_1706107393.json', 'v1/24_01_2024/response_header_sight_cancellation_fee_Viator_test_361_14_43_13_1706107393.json', 'viator', '2024-01-24 02:43:13', '');
[01/24/2024 02:43:27], [file name :-/home/otrams/public_html/beta/get_cancellation_fee_sight.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 02:43:27' WHERE id= '309';
[01/24/2024 02:43:27], [file name :-/home/otrams/public_html/beta/get_cancellation_fee_sight.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header)
                    VALUE('361', 'sight_cancellation_fee', 'v1/24_01_2024/request_sight_cancellation_fee_Viator_test_361_14_43_27_1706107407.json', 'v1/24_01_2024/response_sight_cancellation_fee_Viator_test_361_14_43_27_1706107407.json', 'v1/24_01_2024/response_header_sight_cancellation_fee_Viator_test_361_14_43_27_1706107407.json', 'viator', '2024-01-24 02:43:27', '');
[01/24/2024 02:43:31], [file name :-/home/otrams/public_html/beta/get_cancellation_fee_sight.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 02:43:31' WHERE id= '309';
[01/24/2024 02:43:31], [file name :-/home/otrams/public_html/beta/get_cancellation_fee_sight.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header)
                    VALUE('361', 'sight_cancellation_fee', 'v1/24_01_2024/request_sight_cancellation_fee_Viator_test_361_14_43_31_1706107411.json', 'v1/24_01_2024/response_sight_cancellation_fee_Viator_test_361_14_43_31_1706107411.json', 'v1/24_01_2024/response_header_sight_cancellation_fee_Viator_test_361_14_43_31_1706107411.json', 'viator', '2024-01-24 02:43:31', '');
[01/24/2024 02:45:37], [file name :-/home/otrams/public_html/beta/get_cancellation_fee_sight.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 02:45:37' WHERE id= '309';
[01/24/2024 02:46:24], [file name :-/home/otrams/public_html/beta/get_cancellation_fee_sight.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 02:46:24' WHERE id= '309';
[01/24/2024 02:47:01], [file name :-/home/otrams/public_html/beta/get_cancellation_fee_sight.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 02:47:01' WHERE id= '309';
[01/24/2024 02:47:39], [file name :-/home/otrams/public_html/beta/get_cancellation_fee_sight.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 02:47:39' WHERE id= '309';
[01/24/2024 02:48:24], [file name :-/home/otrams/public_html/beta/get_cancellation_fee_sight.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 02:48:24' WHERE id= '309';
[01/24/2024 02:48:24], [file name :-/home/otrams/public_html/beta/get_cancellation_fee_sight.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header)
                    VALUE('361', 'sight_cancellation_fee', 'v1/24_01_2024/request_sight_cancellation_fee_Viator_test_361_14_48_24_1706107704.json', 'v1/24_01_2024/response_sight_cancellation_fee_Viator_test_361_14_48_24_1706107704.json', 'v1/24_01_2024/response_header_sight_cancellation_fee_Viator_test_361_14_48_24_1706107704.json', 'viator', '2024-01-24 02:48:24', '');
[01/24/2024 02:48:50], [file name :-/home/otrams/public_html/beta/get_cancellation_fee_sight.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 02:48:50' WHERE id= '309';
[01/24/2024 02:48:50], [file name :-/home/otrams/public_html/beta/get_cancellation_fee_sight.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header)
                    VALUE('361', 'sight_cancellation_fee', 'v1/24_01_2024/request_sight_cancellation_fee_Viator_test_361_14_48_50_1706107730.json', 'v1/24_01_2024/response_sight_cancellation_fee_Viator_test_361_14_48_50_1706107730.json', 'v1/24_01_2024/response_header_sight_cancellation_fee_Viator_test_361_14_48_50_1706107730.json', 'viator', '2024-01-24 02:48:50', '');
[01/24/2024 02:51:10], [file name :-/home/otrams/public_html/beta/get_cancellation_fee_sight.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 02:51:10' WHERE id= '309';
[01/24/2024 02:51:10], [file name :-/home/otrams/public_html/beta/get_cancellation_fee_sight.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header)
                    VALUE('361', 'sight_cancellation_fee', 'v1/24_01_2024/request_sight_cancellation_fee_Viator_test_361_14_51_10_1706107870.json', 'v1/24_01_2024/response_sight_cancellation_fee_Viator_test_361_14_51_10_1706107870.json', 'v1/24_01_2024/response_header_sight_cancellation_fee_Viator_test_361_14_51_10_1706107870.json', 'viator', '2024-01-24 02:51:10', '');
[01/24/2024 02:51:31], [file name :-/home/otrams/public_html/beta/get_cancellation_fee_sight.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 02:51:31' WHERE id= '309';
[01/24/2024 02:51:32], [file name :-/home/otrams/public_html/beta/get_cancellation_fee_sight.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header)
                    VALUE('361', 'sight_cancellation_fee', 'v1/24_01_2024/request_sight_cancellation_fee_Viator_test_361_14_51_31_1706107891.json', 'v1/24_01_2024/response_sight_cancellation_fee_Viator_test_361_14_51_31_1706107891.json', 'v1/24_01_2024/response_header_sight_cancellation_fee_Viator_test_361_14_51_31_1706107891.json', 'viator', '2024-01-24 02:51:32', '');
[01/24/2024 02:52:18], [file name :-/home/otrams/public_html/beta/get_cancellation_fee_sight.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 02:52:18' WHERE id= '309';
[01/24/2024 02:52:19], [file name :-/home/otrams/public_html/beta/get_cancellation_fee_sight.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header)
                    VALUE('361', 'sight_cancellation_fee', 'v1/24_01_2024/request_sight_cancellation_fee_Viator_test_361_14_52_18_1706107938.json', 'v1/24_01_2024/response_sight_cancellation_fee_Viator_test_361_14_52_18_1706107938.json', 'v1/24_01_2024/response_header_sight_cancellation_fee_Viator_test_361_14_52_18_1706107938.json', 'viator', '2024-01-24 02:52:19', '');
[01/24/2024 02:53:15], [file name :-/home/otrams/public_html/beta/get_cancellation_fee_sight.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 02:53:15' WHERE id= '309';
[01/24/2024 02:53:16], [file name :-/home/otrams/public_html/beta/get_cancellation_fee_sight.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header)
                    VALUE('361', 'sight_cancellation_fee', 'v1/24_01_2024/request_sight_cancellation_fee_Viator_test_361_14_53_15_1706107995.json', 'v1/24_01_2024/response_sight_cancellation_fee_Viator_test_361_14_53_15_1706107995.json', 'v1/24_01_2024/response_header_sight_cancellation_fee_Viator_test_361_14_53_15_1706107995.json', 'viator', '2024-01-24 02:53:16', '');
[01/24/2024 02:53:16], [file name :-/home/otrams/public_html/beta/get_cancellation_fee_sight.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header)
                    VALUE('361', 'sight_cancellation_reason', 'v1/24_01_2024/request_sight_cancellation_reason_Viator_test_361_14_53_16_1706107996.json', 'v1/24_01_2024/response_sight_cancellation_reason_Viator_test_361_14_53_16_1706107996.json', 'v1/24_01_2024/response_header_sight_cancellation_reason_Viator_test_361_14_53_16_1706107996.json', 'viator', '2024-01-24 02:53:16', '');
[01/24/2024 02:53:41], [file name :-/home/otrams/public_html/beta/get_cancellation_fee_sight.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 02:53:41' WHERE id= '309';
[01/24/2024 02:53:42], [file name :-/home/otrams/public_html/beta/get_cancellation_fee_sight.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header)
                    VALUE('361', 'sight_cancellation_fee', 'v1/24_01_2024/request_sight_cancellation_fee_Viator_test_361_14_53_41_1706108021.json', 'v1/24_01_2024/response_sight_cancellation_fee_Viator_test_361_14_53_41_1706108021.json', 'v1/24_01_2024/response_header_sight_cancellation_fee_Viator_test_361_14_53_41_1706108021.json', 'viator', '2024-01-24 02:53:42', '');
[01/24/2024 02:53:42], [file name :-/home/otrams/public_html/beta/get_cancellation_fee_sight.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header)
                    VALUE('361', 'sight_cancellation_reason', 'v1/24_01_2024/request_sight_cancellation_reason_Viator_test_361_14_53_42_1706108022.json', 'v1/24_01_2024/response_sight_cancellation_reason_Viator_test_361_14_53_42_1706108022.json', 'v1/24_01_2024/response_header_sight_cancellation_reason_Viator_test_361_14_53_42_1706108022.json', 'viator', '2024-01-24 02:53:42', '');
[01/24/2024 02:54:45], [file name :-/home/otrams/public_html/beta/get_cancellation_fee_sight.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 02:54:45' WHERE id= '309';
[01/24/2024 02:54:46], [file name :-/home/otrams/public_html/beta/get_cancellation_fee_sight.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header)
                    VALUE('361', 'sight_cancellation_fee', 'v1/24_01_2024/request_sight_cancellation_fee_Viator_test_361_14_54_45_1706108085.json', 'v1/24_01_2024/response_sight_cancellation_fee_Viator_test_361_14_54_45_1706108085.json', 'v1/24_01_2024/response_header_sight_cancellation_fee_Viator_test_361_14_54_45_1706108085.json', 'viator', '2024-01-24 02:54:46', '');
[01/24/2024 02:54:47], [file name :-/home/otrams/public_html/beta/get_cancellation_fee_sight.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header)
                    VALUE('361', 'sight_cancellation_reason', 'v1/24_01_2024/request_sight_cancellation_reason_Viator_test_361_14_54_46_1706108086.json', 'v1/24_01_2024/response_sight_cancellation_reason_Viator_test_361_14_54_46_1706108086.json', 'v1/24_01_2024/response_header_sight_cancellation_reason_Viator_test_361_14_54_46_1706108086.json', 'viator', '2024-01-24 02:54:47', '');
[01/24/2024 02:54:53], [file name :-/home/otrams/public_html/beta/booking_list_sight.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 02:54:53' WHERE id= '309';
[01/24/2024 02:54:58], [file name :-/home/otrams/public_html/beta/booking_list_sight.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header)
                    VALUE('361', 'sight_cancellation', 'v1/24_01_2024/request_sight_cancellation_Viator_test_361_14_54_53_1706108093.json', 'v1/24_01_2024/response_sight_cancellation_Viator_test_361_14_54_53_1706108093.json', 'v1/24_01_2024/response_header_sight_cancellation_Viator_test_361_14_54_53_1706108093.json', 'viator', '2024-01-24 02:54:58', '');
[01/24/2024 02:54:58], [file name :-/home/otrams/public_html/beta/booking_list_sight.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
		('','','361','inprocess_cancel','2024-01-24 14:54:58','Cancellation request has been sent and we will refer with the cancellation charges','7851','43.239.53.130','','','');
[01/24/2024 02:54:58], [file name :-/home/otrams/public_html/beta/booking_list_sight.php],UPDATE bookings SET current_status='inprocess_cancel',status_date='2024-01-24 14:54:58' WHERE reservation_id = '2303' AND id = '361' AND (current_status = 'pending' OR  current_status = 'confirmed' OR  current_status = 'vouchered' OR  current_status = 'on_request') ;
[01/24/2024 02:55:05], [file name :-/home/otrams/public_html/beta/index.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 02:55:05' WHERE id= '309';
[01/24/2024 02:55:06], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 02:55:06' WHERE id= '309';
[01/24/2024 02:55:06], [file name :-/home/otrams/public_html/beta/booking_list_sight.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 02:55:06' WHERE id= '309';
[01/24/2024 02:56:37], [file name :-/home/otrams/public_html/beta/get_cancellation_fee_sight.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 02:56:37' WHERE id= '309';
[01/24/2024 02:56:37], [file name :-/home/otrams/public_html/beta/get_cancellation_fee_sight.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header)
                    VALUE('361', 'sight_cancellation_fee', 'v1/24_01_2024/request_sight_cancellation_fee_Viator_test_361_14_56_37_1706108197.json', 'v1/24_01_2024/response_sight_cancellation_fee_Viator_test_361_14_56_37_1706108197.json', 'v1/24_01_2024/response_header_sight_cancellation_fee_Viator_test_361_14_56_37_1706108197.json', 'viator', '2024-01-24 02:56:37', '');
[01/24/2024 02:56:50], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 02:56:50' WHERE id= '309';
[01/24/2024 02:56:58], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 02:56:58' WHERE id= '309';
[01/24/2024 02:57:02], [file name :-/home/otrams/public_html/beta/booking_list_sight.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 02:57:02' WHERE id= '309';
[01/24/2024 02:57:07], [file name :-/home/otrams/public_html/beta/get_cancellation_fee_sight.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 02:57:07' WHERE id= '309';
[01/24/2024 02:57:07], [file name :-/home/otrams/public_html/beta/get_cancellation_fee_sight.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header)
                    VALUE('361', 'sight_cancellation_fee', 'v1/24_01_2024/request_sight_cancellation_fee_Viator_test_361_14_57_07_1706108227.json', 'v1/24_01_2024/response_sight_cancellation_fee_Viator_test_361_14_57_07_1706108227.json', 'v1/24_01_2024/response_header_sight_cancellation_fee_Viator_test_361_14_57_07_1706108227.json', 'viator', '2024-01-24 02:57:07', '');
[01/24/2024 02:57:17], [file name :-/home/otrams/public_html/beta/get_cancellation_fee_sight.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 02:57:17' WHERE id= '309';
[01/24/2024 02:57:17], [file name :-/home/otrams/public_html/beta/get_cancellation_fee_sight.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header)
                    VALUE('361', 'sight_cancellation_fee', 'v1/24_01_2024/request_sight_cancellation_fee_Viator_test_361_14_57_17_1706108237.json', 'v1/24_01_2024/response_sight_cancellation_fee_Viator_test_361_14_57_17_1706108237.json', 'v1/24_01_2024/response_header_sight_cancellation_fee_Viator_test_361_14_57_17_1706108237.json', 'viator', '2024-01-24 02:57:17', '');
[01/24/2024 02:57:48], [file name :-/home/otrams/public_html/beta/get_cancellation_fee_sight.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 02:57:48' WHERE id= '309';
[01/24/2024 02:57:48], [file name :-/home/otrams/public_html/beta/get_cancellation_fee_sight.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header)
                    VALUE('361', 'sight_cancellation_fee', 'v1/24_01_2024/request_sight_cancellation_fee_Viator_test_361_14_57_48_1706108268.json', 'v1/24_01_2024/response_sight_cancellation_fee_Viator_test_361_14_57_48_1706108268.json', 'v1/24_01_2024/response_header_sight_cancellation_fee_Viator_test_361_14_57_48_1706108268.json', 'viator', '2024-01-24 02:57:48', '');
[01/24/2024 02:58:18], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 02:58:18' WHERE id= '309';
[01/24/2024 02:58:18], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-24 02:58:18',login_attempt=0 where id = '7851';
[01/24/2024 02:58:18], [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-24 14:58:18', ip = '43.239.53.130', action = 'Login' ;
[01/24/2024 02:58:19], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 02:58:19' WHERE id= '309';
[01/24/2024 02:58:22], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 02:58:22' WHERE id= '309';
[01/24/2024 02:58:25], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 02:58:25' WHERE id= '309';
[01/24/2024 02:58:32], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 02:58:32' WHERE id= '309';
[01/24/2024 02:58:32], [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-01-24 :14:58:32',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/24/2024 02:58:54], [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/24_01_2024/request_availability_Viator_test_14_58_32_1706108312.json', 'v1/24_01_2024/response_availability_Viator_test_14_58_32_1706108312.json', 'v1/24_01_2024/response_header_availability_Viator_test_14_58_32_1706108312.json', 'viator', '2024-01-24 02:58:54', '', '', '1130');
[01/24/2024 02:58:55], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 02:58:55' WHERE id= '309';
[01/24/2024 02:58:55], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 02:58:55' WHERE id= '309';
[01/24/2024 02:58:57], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 02:58:57' WHERE id= '309';
[01/24/2024 02:58:57], [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/24_01_2024/request_sight_details_Viator_test_14_58_57_1706108337.json', 'v1/24_01_2024/response_sight_details_Viator_test_14_58_57_1706108337.json', 'v1/24_01_2024/response_header_sight_details_Viator_test_14_58_57_1706108337.json', 'viator', '2024-01-24 02:58:57', '', '', '1130');
[01/24/2024 02:59:05], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 02:59:05' WHERE id= '309';
[01/24/2024 02:59:05], [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/24_01_2024/request_check_availability_Viator_test_14_59_05_1706108345.json', 'v1/24_01_2024/response_check_availability_Viator_test_14_59_05_1706108345.json', 'v1/24_01_2024/response_header_check_availability_Viator_test_14_59_05_1706108345.json', 'viator', '2024-01-24 02:59:05', '', '', '1130');
[01/24/2024 02:59:07], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 02:59:07' WHERE id= '309';
[01/24/2024 02:59:07], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1706108347','43.239.53.130');
[01/24/2024 02:59:12], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 02:59:12' WHERE id= '309';
[01/24/2024 02:59:14], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 02:59:14' WHERE id= '309';
[01/24/2024 02:59:17], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 02:59:17' WHERE id= '309';
[01/24/2024 02:59:20], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 02:59:20' WHERE id= '309';
[01/24/2024 02:59:24], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 02:59:24' WHERE id= '309';
[01/24/2024 02:59:26], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 02:59:26' WHERE id= '309';
[01/24/2024 02:59:27], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 02:59:27' WHERE id= '309';
[01/24/2024 02:59:49], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 02:59:49' WHERE id= '309';
[01/24/2024 02:59:49], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1706108389','43.239.53.130');
[01/24/2024 02:59:49], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 02:59:49' WHERE id= '309';
[01/24/2024 02:59:49], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO bookings set reservation_id='2305',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 12 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-24 14:59:49',source_type='viator',expiration_date= '2023-12-12 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-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';
[01/24/2024 02:59:49], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO sight_bookings set booking_id='362',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-02-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/24/2024 02:59:49], [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','2305','2024-01-24 14:59:49',0);
[01/24/2024 02:59:59], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'reservation_sight', 'v1/24_01_2024/request_reservation_sight_Viator_test_14_59_49_1706108389.json', 'v1/24_01_2024/response_reservation_sight_Viator_test_14_59_49_1706108389.json', 'v1/24_01_2024/response_header_reservation_sight_Viator_test_14_59_49_1706108389.json', 'viator', '2024-01-24 02:59:59', '', '', '1130');
[01/24/2024 02:59:59], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE posted_bookings set status=1 where id= '199';
[01/24/2024 02:59:59], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],update bookings set  parent_agent_id='7851', applicable_service_tax='0', sub_agent_rate='0', agent_rate='89.18', supplier_rate='89.18', uid='', itenirary_id='', confirmation_number='', comment_contract='', current_status='failed', original_source='' where id='362';
[01/24/2024 02:59:59], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],update sight_bookings set gtaToken='',gta_item_confirm_ref='',tour_supplier='',textaddition_activities='N;' where booking_id='362';
[01/24/2024 02:59:59], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
		('','','362','failed','2024-01-24 14:59:59','Sightseeing Booking failed by Agent..7851','7851','43.239.53.130','','','');
[01/24/2024 02:59:59], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],insert into sight_passangers(booking_id,salutations,tour,first_name,last_name,passenger_type,age)values('362','Mr','1','shiv','chauhan','adult','0');
[01/24/2024 02:59:59], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],insert into sight_passangers(booking_id,salutations,tour,first_name,last_name,passenger_type,age)values('362','Mr','1','Jai','praksh','adult','0');
[01/24/2024 02:59:59], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],update xmllogs set reservation_id='362' where agent_logs_id='1130' and source_type='viator';
