[08/13/2024 10:27:49], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-08-13 10:27:49',login_attempt=0 where id = '949';
[08/13/2024 10:27:49], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'yogeshqtech', user_type = 'A', branch_id = '1', login_datetime = '2024-08-13 10:27:49', ip = '43.239.53.130', action = 'Login' ;
[08/13/2024 10:27:58], [file name :-/efsdata/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '949' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '43.239.53.130' , city = 'bali' , arrival_date='2024/08/29',  departure_date='2024/08/29',  nights='1',  create_date='2024-08-13 :10:27:58',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[08/13/2024 10:28: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/13_08_2024/request_availability_yogeshqtech_10_27_58_1723544878.json', 'v1/13_08_2024/response_availability_yogeshqtech_10_27_58_1723544878.json', 'v1/13_08_2024/response_header_availability_yogeshqtech_10_27_58_1723544878.json', 'viator', '2024-08-13 10:28:04', '', '', '14755864', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/13_08_2024/response_availability_yogeshqtech_10_27_58_1723544878.json');
[08/13/2024 10:28:47], [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/13_08_2024/request_sight_details_yogeshqtech_10_28_47_1723544927.json', 'v1/13_08_2024/response_sight_details_yogeshqtech_10_28_47_1723544927.json', 'v1/13_08_2024/response_header_sight_details_yogeshqtech_10_28_47_1723544927.json', 'viator', '2024-08-13 10:28:47', '', '', '14755864', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/13_08_2024/response_sight_details_yogeshqtech_10_28_47_1723544927.json');
[08/13/2024 10:28:47], [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/13_08_2024/request_valuation_yogeshqtech_10_28_47_1723544927.json', 'v1/13_08_2024/response_valuation_yogeshqtech_10_28_47_1723544927.json', 'v1/13_08_2024/response_header_valuation_yogeshqtech_10_28_47_1723544927.json', 'viator', '2024-08-13 10:28:47', '', '', '14755864', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/13_08_2024/response_valuation_yogeshqtech_10_28_47_1723544927.json');
[08/13/2024 10:28:52], [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/13_08_2024/request_check_availability_yogeshqtech_10_28_51_1723544931.json', 'v1/13_08_2024/response_check_availability_yogeshqtech_10_28_51_1723544931.json', 'v1/13_08_2024/response_header_check_availability_yogeshqtech_10_28_51_1723544931.json', 'viator', '2024-08-13 10:28:52', '', '', '14755864', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/13_08_2024/response_check_availability_yogeshqtech_10_28_51_1723544931.json');
[08/13/2024 10:28:57], [file name :-/efsdata/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1723544937','43.239.53.130');
[08/13/2024 10:28:59], [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/13_08_2024/request_hotel_pickup_yogeshqtech_10_28_58_1723544938.json', 'v1/13_08_2024/response_hotel_pickup_yogeshqtech_10_28_58_1723544938.json', 'v1/13_08_2024/response_header_hotel_pickup_yogeshqtech_10_28_58_1723544938.json', 'viator', '2024-08-13 10:28:59', '', '', '14755864', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/13_08_2024/response_hotel_pickup_yogeshqtech_10_28_58_1723544938.json');
[08/13/2024 10:34:14], [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/13_08_2024/request_sight_details_yogeshqtech_10_34_13_1723545253.json', 'v1/13_08_2024/response_sight_details_yogeshqtech_10_34_13_1723545253.json', 'v1/13_08_2024/response_header_sight_details_yogeshqtech_10_34_13_1723545253.json', 'viator', '2024-08-13 10:34:14', '', '', '14755864', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/13_08_2024/response_sight_details_yogeshqtech_10_34_13_1723545253.json');
[08/13/2024 10:34:15], [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/13_08_2024/request_valuation_yogeshqtech_10_34_14_1723545254.json', 'v1/13_08_2024/response_valuation_yogeshqtech_10_34_14_1723545254.json', 'v1/13_08_2024/response_header_valuation_yogeshqtech_10_34_14_1723545254.json', 'viator', '2024-08-13 10:34:15', '', '', '14755864', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/13_08_2024/response_valuation_yogeshqtech_10_34_14_1723545254.json');
[08/13/2024 10:34:22], [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/13_08_2024/request_check_availability_yogeshqtech_10_34_21_1723545261.json', 'v1/13_08_2024/response_check_availability_yogeshqtech_10_34_21_1723545261.json', 'v1/13_08_2024/response_header_check_availability_yogeshqtech_10_34_21_1723545261.json', 'viator', '2024-08-13 10:34:22', '', '', '14755864', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/13_08_2024/response_check_availability_yogeshqtech_10_34_21_1723545261.json');
[08/13/2024 10:34:28], [file name :-/efsdata/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1723545268','43.239.53.130');
[08/13/2024 10:34:30], [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/13_08_2024/request_hotel_pickup_yogeshqtech_10_34_29_1723545269.json', 'v1/13_08_2024/response_hotel_pickup_yogeshqtech_10_34_29_1723545269.json', 'v1/13_08_2024/response_header_hotel_pickup_yogeshqtech_10_34_29_1723545269.json', 'viator', '2024-08-13 10:34:30', '', '', '14755864', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/13_08_2024/response_hotel_pickup_yogeshqtech_10_34_29_1723545269.json');
[08/13/2024 10:36:05], [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/13_08_2024/request_sight_details_yogeshqtech_10_36_04_1723545364.json', 'v1/13_08_2024/response_sight_details_yogeshqtech_10_36_04_1723545364.json', 'v1/13_08_2024/response_header_sight_details_yogeshqtech_10_36_04_1723545364.json', 'viator', '2024-08-13 10:36:04', '', '', '14755864', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/13_08_2024/response_sight_details_yogeshqtech_10_36_04_1723545364.json');
[08/13/2024 10:36:05], [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/13_08_2024/request_valuation_yogeshqtech_10_36_05_1723545365.json', 'v1/13_08_2024/response_valuation_yogeshqtech_10_36_05_1723545365.json', 'v1/13_08_2024/response_header_valuation_yogeshqtech_10_36_05_1723545365.json', 'viator', '2024-08-13 10:36:05', '', '', '14755864', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/13_08_2024/response_valuation_yogeshqtech_10_36_05_1723545365.json');
[08/13/2024 10:36:40], [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/13_08_2024/request_check_availability_yogeshqtech_10_36_39_1723545399.json', 'v1/13_08_2024/response_check_availability_yogeshqtech_10_36_39_1723545399.json', 'v1/13_08_2024/response_header_check_availability_yogeshqtech_10_36_39_1723545399.json', 'viator', '2024-08-13 10:36:40', '', '', '14755864', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/13_08_2024/response_check_availability_yogeshqtech_10_36_39_1723545399.json');
[08/13/2024 10:36:46], [file name :-/efsdata/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1723545406','43.239.53.130');
[08/13/2024 10:36:48], [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/13_08_2024/request_hotel_pickup_yogeshqtech_10_36_47_1723545407.json', 'v1/13_08_2024/response_hotel_pickup_yogeshqtech_10_36_47_1723545407.json', 'v1/13_08_2024/response_header_hotel_pickup_yogeshqtech_10_36_47_1723545407.json', 'viator', '2024-08-13 10:36:48', '', '', '14755864', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/13_08_2024/response_hotel_pickup_yogeshqtech_10_36_47_1723545407.json');
