[01/21/2024 05:08:21], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET is_exception = 'yes', exception_info = CONCAT(exception_info, '~~~' ,'ip changed 103.139.247.152') WHERE id= '309';
[01/21/2024 05:09:14], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-21 05:09:14',login_attempt=0 where id = '7851';
[01/21/2024 05:09:14], [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-21 17:09:14', ip = '103.139.247.152', action = 'Login' ;
[01/21/2024 05:09:15], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET is_exception = 'yes', exception_info = CONCAT(exception_info, '~~~' ,'ip changed 103.139.247.152') WHERE id= '309';
[01/21/2024 05:10:54], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-21 05:10:54',login_attempt=0 where id = '7851';
[01/21/2024 05:10:54], [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-21 17:10:54', ip = '103.139.247.152', action = 'Login' ;
[01/21/2024 05:10:54], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET is_exception = 'yes', exception_info = CONCAT(exception_info, '~~~' ,'ip changed 103.139.247.152') WHERE id= '309';
[01/21/2024 05:11:40], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-21 05:11:40',login_attempt=0 where id = '7851';
[01/21/2024 05:11:40], [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-21 17:11:40', ip = '43.239.53.130', action = 'Login' ;
[01/21/2024 05:11:40], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-21 05:11:40' WHERE id= '309';
[01/21/2024 05:11:46], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-21 05:11:46' WHERE id= '309';
[01/21/2024 05:11:50], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-21 05:11:50' WHERE id= '309';
[01/21/2024 05:12:02], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-21 05:12:02' WHERE id= '309';
[01/21/2024 05:12:02], [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/13',  departure_date='2024/02/13',  nights='1',  create_date='2024-01-21 :17:12:02',  nationality='',  additional_markup='',  selected_currency='AUD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/21/2024 05:12:03], [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/21_01_2024/request_availability_Viator_test_17_12_02_1705857122.json', 'v1/21_01_2024/response_availability_Viator_test_17_12_02_1705857122.json', 'v1/21_01_2024/response_header_availability_Viator_test_17_12_02_1705857122.json', 'viator', '2024-01-21 05:12:03', '', '', '1062');
[01/21/2024 05:12:05], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-21 05:12:05' WHERE id= '309';
[01/21/2024 05:12:05], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-21 05:12:05' WHERE id= '309';
[01/21/2024 05:12:08], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-21 05:12:08' WHERE id= '309';
[01/21/2024 05:12:09], [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/21_01_2024/request_sight_details_Viator_test_17_12_08_1705857128.json', 'v1/21_01_2024/response_sight_details_Viator_test_17_12_08_1705857128.json', 'v1/21_01_2024/response_header_sight_details_Viator_test_17_12_08_1705857128.json', 'viator', '2024-01-21 05:12:09', '', '', '1062');
[01/21/2024 05:12:21], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-21 05:12:21' WHERE id= '309';
[01/21/2024 05:12:22], [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/21_01_2024/request_check_availability_Viator_test_17_12_22_1705857142.json', 'v1/21_01_2024/response_check_availability_Viator_test_17_12_22_1705857142.json', 'v1/21_01_2024/response_header_check_availability_Viator_test_17_12_22_1705857142.json', 'viator', '2024-01-21 05:12:22', '', '', '1062');
[01/21/2024 05:12:24], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-21 05:12:24' WHERE id= '309';
[01/21/2024 05:12:24], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705857144','43.239.53.130');
