[01/02/2024 07:29:28], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-02 07:29:28',login_attempt=0 where id = '7851';
[01/02/2024 07:29:28], [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-02 07:29:28', ip = '43.239.53.130', action = 'Login' ;
[01/02/2024 07:29:29], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-02 07:29:29' WHERE id= '247';
[01/02/2024 07:29:32], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-02 07:29:32' WHERE id= '247';
[01/02/2024 07:29:36], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-02 07:29:36' WHERE id= '247';
[01/02/2024 07:29:47], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-02 07:29:47' WHERE id= '247';
[01/02/2024 07:29:47], [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/01/04',  departure_date='2024/01/04',  nights='1',  create_date='2024-01-02 :07:29:47',  nationality='',  additional_markup='',  selected_currency='SAR',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/02/2024 07:29:49], [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/02_01_2024/request_availability_Viator_test_07_29_47_1704180587.json', 'v1/02_01_2024/response_availability_Viator_test_07_29_47_1704180587.json', 'v1/02_01_2024/response_header_availability_Viator_test_07_29_47_1704180587.json', 'viator', '2024-01-02 07:29:49', '', '', '305');
[01/02/2024 07:36:43], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-02 07:36:43' WHERE id= '247';
[01/02/2024 07:36:43], [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/01/04',  departure_date='2024/01/04',  nights='1',  create_date='2024-01-02 :07:36:43',  nationality='',  additional_markup='',  selected_currency='SAR',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/02/2024 07:36:46], [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/02_01_2024/request_availability_Viator_test_07_36_43_1704181003.json', 'v1/02_01_2024/response_availability_Viator_test_07_36_43_1704181003.json', 'v1/02_01_2024/response_header_availability_Viator_test_07_36_43_1704181003.json', 'viator', '2024-01-02 07:36:46', '', '', '306');
