[12/29/2023 01:05:21], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2023-12-29 01:05:21',login_attempt=0 where id = '7851';
[12/29/2023 01:05:21], [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 = '2023-12-29 13:05:21', ip = '43.239.53.130', action = 'Login' ;
[12/29/2023 01:05:22], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2023-12-29 01:05:22' WHERE id= '247';
[12/29/2023 01:05:25], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2023-12-29 01:05:25' WHERE id= '247';
[12/29/2023 01:05:30], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-12-29 01:05:30' WHERE id= '247';
[12/29/2023 01:05:37], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2023-12-29 01:05:37' WHERE id= '247';
[12/29/2023 01:05:37], [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 = 'lucca' , arrival_date='2023/12/30',  departure_date='2023/12/30',  nights='1',  create_date='2023-12-29 :13:05:37',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[12/29/2023 01:05:37], [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/29_12_2023/request_availability_Viator_test_13_05_37_1703855137.json', 'v1/29_12_2023/response_availability_Viator_test_13_05_37_1703855137.json', 'v1/29_12_2023/response_header_availability_Viator_test_13_05_37_1703855137.json', 'viator', '2023-12-29 01:05:37', '', '', '304');
