[01/23/2024 01:37:22], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-23 01:37:22',login_attempt=0 where id = '7851';
[01/23/2024 01:37:22], [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-23 13:37:22', ip = '43.239.53.130', action = 'Login' ;
[01/23/2024 01:37:22], [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/23/2024 01:37:28], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-23 01:37:28',login_attempt=0 where id = '7851';
[01/23/2024 01:37: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-23 13:37:28', ip = '43.239.53.130', action = 'Login' ;
[01/23/2024 01:37:29], [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/23/2024 01:37:58], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-23 01:37:58',login_attempt=0 where id = '7851';
[01/23/2024 01:37:58], [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-23 13:37:58', ip = '43.239.53.130', action = 'Login' ;
[01/23/2024 01:37:58], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-23 01:37:58' WHERE id= '309';
[01/23/2024 01:38:01], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-23 01:38:01' WHERE id= '309';
[01/23/2024 01:38:05], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-23 01:38:05' WHERE id= '309';
[01/23/2024 01:38:18], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-23 01:38:18' WHERE id= '309';
[01/23/2024 01:38:18], [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/15',  departure_date='2024/02/15',  nights='1',  create_date='2024-01-23 :13:38:18',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/23/2024 01:38:28], [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/23_01_2024/request_availability_Viator_test_13_38_18_1706017098.json', 'v1/23_01_2024/response_availability_Viator_test_13_38_18_1706017098.json', 'v1/23_01_2024/response_header_availability_Viator_test_13_38_18_1706017098.json', 'viator', '2024-01-23 01:38:28', '', '', '1118');
[01/23/2024 01:38:29], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-23 01:38:29' WHERE id= '309';
[01/23/2024 01:38:29], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-23 01:38:29' WHERE id= '309';
[01/23/2024 01:39:58], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-23 01:39:58' WHERE id= '309';
[01/23/2024 01:39:59], [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/23_01_2024/request_sight_details_Viator_test_13_39_58_1706017198.json', 'v1/23_01_2024/response_sight_details_Viator_test_13_39_58_1706017198.json', 'v1/23_01_2024/response_header_sight_details_Viator_test_13_39_58_1706017198.json', 'viator', '2024-01-23 01:39:59', '', '', '1118');
[01/23/2024 01:40:03], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-23 01:40:03' WHERE id= '309';
[01/23/2024 01:40:03], [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/23_01_2024/request_check_availability_Viator_test_13_40_03_1706017203.json', 'v1/23_01_2024/response_check_availability_Viator_test_13_40_03_1706017203.json', 'v1/23_01_2024/response_header_check_availability_Viator_test_13_40_03_1706017203.json', 'viator', '2024-01-23 01:40:03', '', '', '1118');
[01/23/2024 01:40:37], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-23 01:40:37' WHERE id= '309';
[01/23/2024 01:40:37], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1706017237','43.239.53.130');
[01/23/2024 01:47:12], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-23 01:47:12' WHERE id= '309';
[01/23/2024 01:47:12], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1706017632','43.239.53.130');
[01/23/2024 01:47:48], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2024-01-23 01:47:48' WHERE id= '309';
[01/23/2024 01:47:48], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-23 01:47:48',login_attempt=0 where id = '7851';
[01/23/2024 01:47:48], [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-23 13:47:48', ip = '43.239.53.130', action = 'Login' ;
[01/23/2024 01:47:48], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-23 01:47:48' WHERE id= '309';
[01/23/2024 01:47:51], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-23 01:47:51' WHERE id= '309';
[01/23/2024 01:47:54], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-23 01:47:54' WHERE id= '309';
[01/23/2024 01:48:00], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-23 01:48:00' WHERE id= '309';
[01/23/2024 01:48:00], [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/26',  departure_date='2024/01/26',  nights='1',  create_date='2024-01-23 :13:48:00',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/23/2024 01:48: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/23_01_2024/request_availability_Viator_test_13_48_00_1706017680.json', 'v1/23_01_2024/response_availability_Viator_test_13_48_00_1706017680.json', 'v1/23_01_2024/response_header_availability_Viator_test_13_48_00_1706017680.json', 'viator', '2024-01-23 01:48:03', '', '', '1119');
[01/23/2024 01:48:05], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-23 01:48:05' WHERE id= '309';
[01/23/2024 01:48:05], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-23 01:48:05' WHERE id= '309';
[01/23/2024 01:52:48], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-23 01:52:48' WHERE id= '309';
[01/23/2024 01:52:49], [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/23_01_2024/request_sight_details_Viator_test_13_52_48_1706017968.json', 'v1/23_01_2024/response_sight_details_Viator_test_13_52_48_1706017968.json', 'v1/23_01_2024/response_header_sight_details_Viator_test_13_52_48_1706017968.json', 'viator', '2024-01-23 01:52:49', '', '', '1119');
[01/23/2024 01:52:53], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-23 01:52:53' WHERE id= '309';
[01/23/2024 01:52:53], [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/23_01_2024/request_sight_details_Viator_test_13_52_53_1706017973.json', 'v1/23_01_2024/response_sight_details_Viator_test_13_52_53_1706017973.json', 'v1/23_01_2024/response_header_sight_details_Viator_test_13_52_53_1706017973.json', 'viator', '2024-01-23 01:52:53', '', '', '1119');
[01/23/2024 01:52:56], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-23 01:52:56' WHERE id= '309';
[01/23/2024 01:52:57], [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/23_01_2024/request_check_availability_Viator_test_13_52_56_1706017976.json', 'v1/23_01_2024/response_check_availability_Viator_test_13_52_56_1706017976.json', 'v1/23_01_2024/response_header_check_availability_Viator_test_13_52_56_1706017976.json', 'viator', '2024-01-23 01:52:57', '', '', '1119');
[01/23/2024 01:53:00], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-23 01:53:00' WHERE id= '309';
[01/23/2024 01:53:00], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1706017980','43.239.53.130');
[01/23/2024 01:55:15], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-23 01:55:15' WHERE id= '309';
[01/23/2024 01:55:15], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1706018115','43.239.53.130');
[01/23/2024 01:56:13], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-23 01:56:13' WHERE id= '309';
[01/23/2024 01:56:14], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1706018174','43.239.53.130');
[01/23/2024 01:57:23], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-23 01:57:23' WHERE id= '309';
[01/23/2024 01:57:23], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1706018243','43.239.53.130');
