[05/27/2024 04:29:23], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-05-27 04:29:23',login_attempt=0 where id = '7851';
[05/27/2024 04:29:23], [file name :-/efsdata/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-05-27 04:29:23', ip = '43.239.53.130', action = 'Login' ;
[05/27/2024 04:29:43], [file name :-/efsdata/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/06/29',  departure_date='2024/06/29',  nights='1',  create_date='2024-05-27 :04:29:43',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[05/27/2024 04:29:53], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'v1/27_05_2024/request_availability_Viator_test_04_29_43_1716784183.json', 'v1/27_05_2024/response_availability_Viator_test_04_29_43_1716784183.json', 'v1/27_05_2024/response_header_availability_Viator_test_04_29_43_1716784183.json', 'viator', '2024-05-27 04:29:53', '', '', '1932', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/27_05_2024/response_availability_Viator_test_04_29_43_1716784183.json');
[05/27/2024 04:30:07], [file name :-/efsdata/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,file_path) VALUE ('', 'SIGHT_DETAILS', 'v1/27_05_2024/request_sight_details_Viator_test_04_30_06_1716784206.json', 'v1/27_05_2024/response_sight_details_Viator_test_04_30_06_1716784206.json', 'v1/27_05_2024/response_header_sight_details_Viator_test_04_30_06_1716784206.json', 'viator', '2024-05-27 04:30:07', '', '', '1932', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/27_05_2024/response_sight_details_Viator_test_04_30_06_1716784206.json');
[05/27/2024 04:30:09], [file name :-/efsdata/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,file_path) VALUE ('', 'VALUATION', 'v1/27_05_2024/request_valuation_Viator_test_04_30_07_1716784207.json', 'v1/27_05_2024/response_valuation_Viator_test_04_30_07_1716784207.json', 'v1/27_05_2024/response_header_valuation_Viator_test_04_30_07_1716784207.json', 'viator', '2024-05-27 04:30:09', '', '', '1932', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/27_05_2024/response_valuation_Viator_test_04_30_07_1716784207.json');
[05/27/2024 04:30:16], [file name :-/efsdata/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,file_path) VALUE ('', 'CHECK_AVAILABILITY', 'v1/27_05_2024/request_check_availability_Viator_test_04_30_13_1716784213.json', 'v1/27_05_2024/response_check_availability_Viator_test_04_30_13_1716784213.json', 'v1/27_05_2024/response_header_check_availability_Viator_test_04_30_13_1716784213.json', 'viator', '2024-05-27 04:30:16', '', '', '1932', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/27_05_2024/response_check_availability_Viator_test_04_30_13_1716784213.json');
[05/27/2024 04:30:22], [file name :-/efsdata/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1716784222','43.239.53.130');
[05/27/2024 04:31:58], [file name :-/efsdata/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/06/29',  departure_date='2024/06/29',  nights='1',  create_date='2024-05-27 :04:31:58',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[05/27/2024 04:32:11], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'v1/27_05_2024/request_availability_Viator_test_04_31_58_1716784318.json', 'v1/27_05_2024/response_availability_Viator_test_04_31_58_1716784318.json', 'v1/27_05_2024/response_header_availability_Viator_test_04_31_58_1716784318.json', 'viator', '2024-05-27 04:32:11', '', '', '1933', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/27_05_2024/response_availability_Viator_test_04_31_58_1716784318.json');
[05/27/2024 04:32:51], [file name :-/efsdata/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 = 'dholpur(rajasthan)' , arrival_date='2024/06/30',  departure_date='2024/06/30',  nights='1',  create_date='2024-05-27 :04:32:51',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[05/27/2024 04:33:40], [file name :-/efsdata/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 = 'delhi(new delhi)' , arrival_date='2024/06/30',  departure_date='2024/06/30',  nights='1',  create_date='2024-05-27 :04:33:40',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[05/27/2024 04:34:04], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'v1/27_05_2024/request_availability_Viator_test_04_33_40_1716784420.json', 'v1/27_05_2024/response_availability_Viator_test_04_33_40_1716784420.json', 'v1/27_05_2024/response_header_availability_Viator_test_04_33_40_1716784420.json', 'viator', '2024-05-27 04:34:04', '', '', '1935', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/27_05_2024/response_availability_Viator_test_04_33_40_1716784420.json');
[05/27/2024 04:34:16], [file name :-/efsdata/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,file_path) VALUE ('', 'SIGHT_DETAILS', 'v1/27_05_2024/request_sight_details_Viator_test_04_34_16_1716784456.json', 'v1/27_05_2024/response_sight_details_Viator_test_04_34_16_1716784456.json', 'v1/27_05_2024/response_header_sight_details_Viator_test_04_34_16_1716784456.json', 'viator', '2024-05-27 04:34:16', '', '', '1935', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/27_05_2024/response_sight_details_Viator_test_04_34_16_1716784456.json');
[05/27/2024 04:34:17], [file name :-/efsdata/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,file_path) VALUE ('', 'VALUATION', 'v1/27_05_2024/request_valuation_Viator_test_04_34_16_1716784456.json', 'v1/27_05_2024/response_valuation_Viator_test_04_34_16_1716784456.json', 'v1/27_05_2024/response_header_valuation_Viator_test_04_34_16_1716784456.json', 'viator', '2024-05-27 04:34:17', '', '', '1935', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/27_05_2024/response_valuation_Viator_test_04_34_16_1716784456.json');
[05/27/2024 04:34:25], [file name :-/efsdata/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,file_path) VALUE ('', 'CHECK_AVAILABILITY', 'v1/27_05_2024/request_check_availability_Viator_test_04_34_23_1716784463.json', 'v1/27_05_2024/response_check_availability_Viator_test_04_34_23_1716784463.json', 'v1/27_05_2024/response_header_check_availability_Viator_test_04_34_23_1716784463.json', 'viator', '2024-05-27 04:34:25', '', '', '1935', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/27_05_2024/response_check_availability_Viator_test_04_34_23_1716784463.json');
[05/27/2024 04:34:31], [file name :-/efsdata/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1716784471','43.239.53.130');
[05/27/2024 04:34:33], [file name :-/efsdata/otrams/public_html/beta/book_sightseeing.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'HOTEL_PICKUP', 'v1/27_05_2024/request_hotel_pickup_Viator_test_04_34_32_1716784472.json', 'v1/27_05_2024/response_hotel_pickup_Viator_test_04_34_32_1716784472.json', 'v1/27_05_2024/response_header_hotel_pickup_Viator_test_04_34_32_1716784472.json', 'viator', '2024-05-27 04:34:33', '', '', '1935', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/27_05_2024/response_hotel_pickup_Viator_test_04_34_32_1716784472.json');
