[01/19/2024 08:39:53], [file name :-/home/otrams/public_html/beta/index.php],INSERT INTO psa_login_log  SET username = '', user_type = 'A', branch_id = '12', login_datetime = '2024-01-19 08:39:53', ip = '205.210.31.67', action = 'Login' ;
[01/19/2024 08:41:09], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 08:41:09' WHERE id= '309';
[01/19/2024 08:41:10], [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/19_01_2024/request_check_availability_Viator_test_08_41_09_1705653669.json', 'v1/19_01_2024/response_check_availability_Viator_test_08_41_09_1705653669.json', 'v1/19_01_2024/response_header_check_availability_Viator_test_08_41_09_1705653669.json', 'viator', '2024-01-19 08:41:10', '', '', '');
[01/19/2024 08:41:12], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 08:41:12' WHERE id= '309';
[01/19/2024 08:41:12], [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/19_01_2024/request_check_availability_Viator_test_08_41_12_1705653672.json', 'v1/19_01_2024/response_check_availability_Viator_test_08_41_12_1705653672.json', 'v1/19_01_2024/response_header_check_availability_Viator_test_08_41_12_1705653672.json', 'viator', '2024-01-19 08:41:12', '', '', '');
[01/19/2024 08:41:38], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 08:41:38' WHERE id= '309';
[01/19/2024 08:41:39], [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/19_01_2024/request_sight_details_Viator_test_08_41_38_1705653698.json', 'v1/19_01_2024/response_sight_details_Viator_test_08_41_38_1705653698.json', 'v1/19_01_2024/response_header_sight_details_Viator_test_08_41_38_1705653698.json', 'viator', '2024-01-19 08:41:39', '', '', '');
[01/19/2024 08:41:42], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 08:41:42' WHERE id= '309';
[01/19/2024 08:41:43], [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/19_01_2024/request_check_availability_Viator_test_08_41_42_1705653702.json', 'v1/19_01_2024/response_check_availability_Viator_test_08_41_42_1705653702.json', 'v1/19_01_2024/response_header_check_availability_Viator_test_08_41_42_1705653702.json', 'viator', '2024-01-19 08:41:43', '', '', '');
[01/19/2024 08:41:47], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 08:41:47' WHERE id= '309';
[01/19/2024 08:41:47], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-19 08:41:47',login_attempt=0 where id = '7851';
[01/19/2024 08:41:47], [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-19 08:41:47', ip = '43.239.53.130', action = 'Login' ;
[01/19/2024 08:41:48], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 08:41:48' WHERE id= '309';
[01/19/2024 08:41:52], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 08:41:52' WHERE id= '309';
[01/19/2024 08:41:56], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 08:41:56' WHERE id= '309';
[01/19/2024 08:42:01], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 08:42:01' WHERE id= '309';
[01/19/2024 08:42:01], [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/22',  departure_date='2024/01/22',  nights='1',  create_date='2024-01-19 :08:42:01',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/19/2024 08:42:01], [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/19_01_2024/request_availability_Viator_test_08_42_01_1705653721.json', 'v1/19_01_2024/response_availability_Viator_test_08_42_01_1705653721.json', 'v1/19_01_2024/response_header_availability_Viator_test_08_42_01_1705653721.json', 'viator', '2024-01-19 08:42:01', '', '', '1011');
[01/19/2024 08:42:03], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 08:42:03' WHERE id= '309';
[01/19/2024 08:42:03], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 08:42:03' WHERE id= '309';
[01/19/2024 08:42:07], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 08:42:07' WHERE id= '309';
[01/19/2024 08:42:07], [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/19_01_2024/request_sight_details_Viator_test_08_42_07_1705653727.json', 'v1/19_01_2024/response_sight_details_Viator_test_08_42_07_1705653727.json', 'v1/19_01_2024/response_header_sight_details_Viator_test_08_42_07_1705653727.json', 'viator', '2024-01-19 08:42:07', '', '', '1011');
[01/19/2024 08:42:10], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 08:42:10' WHERE id= '309';
[01/19/2024 08:42:11], [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/19_01_2024/request_sight_details_Viator_test_08_42_10_1705653730.json', 'v1/19_01_2024/response_sight_details_Viator_test_08_42_10_1705653730.json', 'v1/19_01_2024/response_header_sight_details_Viator_test_08_42_10_1705653730.json', 'viator', '2024-01-19 08:42:11', '', '', '1011');
[01/19/2024 08:42:16], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 08:42:16' WHERE id= '309';
[01/19/2024 08:42:18], [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/19_01_2024/request_check_availability_Viator_test_08_42_16_1705653736.json', 'v1/19_01_2024/response_check_availability_Viator_test_08_42_16_1705653736.json', 'v1/19_01_2024/response_header_check_availability_Viator_test_08_42_16_1705653736.json', 'viator', '2024-01-19 08:42:18', '', '', '1011');
[01/19/2024 08:57:20], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-19 08:57:20',login_attempt=0 where id = '7851';
[01/19/2024 08:57:20], [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-19 08:57:20', ip = '43.239.53.130', action = 'Login' ;
[01/19/2024 08:57:21], [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 43.239.53.130') WHERE id= '1';
[01/19/2024 08:57:27], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 08:57:27' WHERE id= '309';
[01/19/2024 08:57:28], [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/19_01_2024/request_check_availability_Viator_test_08_57_27_1705654647.json', 'v1/19_01_2024/response_check_availability_Viator_test_08_57_27_1705654647.json', 'v1/19_01_2024/response_header_check_availability_Viator_test_08_57_27_1705654647.json', 'viator', '2024-01-19 08:57:28', '', '', '1011');
[01/19/2024 08:58:15], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 08:58:15' WHERE id= '309';
[01/19/2024 08:58:16], [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/19_01_2024/request_check_availability_Viator_test_08_58_16_1705654696.json', 'v1/19_01_2024/response_check_availability_Viator_test_08_58_16_1705654696.json', 'v1/19_01_2024/response_header_check_availability_Viator_test_08_58_16_1705654696.json', 'viator', '2024-01-19 08:58:16', '', '', '1011');
[01/19/2024 08:59:01], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 08:59:01' WHERE id= '309';
[01/19/2024 08:59:01], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705654741','43.239.53.130');
