[01/22/2024 04:02:26], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-22 04:02:26',login_attempt=0 where id = '7851';
[01/22/2024 04:02:26], [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-22 04:02:26', ip = '43.239.53.130', action = 'Login' ;
[01/22/2024 04:02:26], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-22 04:02:26' WHERE id= '309';
[01/22/2024 04:02:30], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-22 04:02:30' WHERE id= '309';
[01/22/2024 04:02:44], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-22 04:02:44' WHERE id= '309';
[01/22/2024 04:02:52], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-22 04:02:52' WHERE id= '309';
[01/22/2024 04:02:52], [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-22 :04:02:52',  nationality='',  additional_markup='',  selected_currency='AUD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/22/2024 04:03:02], [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/22_01_2024/request_availability_Viator_test_04_02_52_1705896172.json', 'v1/22_01_2024/response_availability_Viator_test_04_02_52_1705896172.json', 'v1/22_01_2024/response_header_availability_Viator_test_04_02_52_1705896172.json', 'viator', '2024-01-22 04:03:02', '', '', '1065');
[01/22/2024 04:03:03], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-22 04:03:03' WHERE id= '309';
[01/22/2024 04:03:03], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-22 04:03:03' WHERE id= '309';
[01/22/2024 04:03:06], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-22 04:03:06' WHERE id= '309';
[01/22/2024 04:03:06], [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/22_01_2024/request_sight_details_Viator_test_04_03_06_1705896186.json', 'v1/22_01_2024/response_sight_details_Viator_test_04_03_06_1705896186.json', 'v1/22_01_2024/response_header_sight_details_Viator_test_04_03_06_1705896186.json', 'viator', '2024-01-22 04:03:06', '', '', '1065');
[01/22/2024 04:03:10], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-22 04:03:10' WHERE id= '309';
[01/22/2024 04:03: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/22_01_2024/request_check_availability_Viator_test_04_03_10_1705896190.json', 'v1/22_01_2024/response_check_availability_Viator_test_04_03_10_1705896190.json', 'v1/22_01_2024/response_header_check_availability_Viator_test_04_03_10_1705896190.json', 'viator', '2024-01-22 04:03:10', '', '', '1065');
[01/22/2024 04:03:16], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-22 04:03:16' WHERE id= '309';
[01/22/2024 04:03: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/22_01_2024/request_check_availability_Viator_test_04_03_16_1705896196.json', 'v1/22_01_2024/response_check_availability_Viator_test_04_03_16_1705896196.json', 'v1/22_01_2024/response_header_check_availability_Viator_test_04_03_16_1705896196.json', 'viator', '2024-01-22 04:03:16', '', '', '1065');
[01/22/2024 04:03:20], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-22 04:03:20' WHERE id= '309';
[01/22/2024 04:03:20], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705896200','43.239.53.130');
[01/22/2024 04:06:45], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-22 04:06:45' WHERE id= '309';
[01/22/2024 04:06:45], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705896405','43.239.53.130');
[01/22/2024 04:09:09], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-22 04:09:09' WHERE id= '309';
[01/22/2024 04:09:09], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705896549','43.239.53.130');
[01/22/2024 04:10:53], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-22 04:10:53' WHERE id= '309';
[01/22/2024 04:10:53], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705896653','43.239.53.130');
[01/22/2024 04:11:39], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-22 04:11:39' WHERE id= '309';
[01/22/2024 04:11:39], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705896699','43.239.53.130');
[01/22/2024 04:12:53], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-22 04:12:53' WHERE id= '309';
[01/22/2024 04:12:53], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705896773','43.239.53.130');
[01/22/2024 04:14:32], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-22 04:14:32' WHERE id= '309';
[01/22/2024 04:14:32], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705896872','43.239.53.130');
[01/22/2024 04:24:57], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-22 04:24:57' WHERE id= '309';
[01/22/2024 04:24:57], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705897497','43.239.53.130');
[01/22/2024 04:25:22], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-22 04:25:22' WHERE id= '309';
[01/22/2024 04:25:22], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705897522','43.239.53.130');
[01/22/2024 04:36:09], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-22 04:36:09' WHERE id= '309';
[01/22/2024 04:36:09], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705898169','43.239.53.130');
[01/22/2024 04:36:57], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-22 04:36:57' WHERE id= '309';
[01/22/2024 04:36:57], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705898217','43.239.53.130');
[01/22/2024 04:37:52], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-22 04:37:52' WHERE id= '309';
[01/22/2024 04:37:52], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705898272','43.239.53.130');
[01/22/2024 04:42:10], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-22 04:42:10' WHERE id= '309';
[01/22/2024 04:42:10], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705898530','43.239.53.130');
[01/22/2024 04:42:37], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-22 04:42:37' WHERE id= '309';
[01/22/2024 04:42:37], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705898557','43.239.53.130');
[01/22/2024 04:44:59], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-22 04:44:59' WHERE id= '309';
[01/22/2024 04:44:59], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705898699','43.239.53.130');
[01/22/2024 04:47:15], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-22 04:47:15' WHERE id= '309';
[01/22/2024 04:47:15], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705898835','43.239.53.130');
[01/22/2024 04:47:24], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-22 04:47:24' WHERE id= '309';
[01/22/2024 04:47:24], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705898844','43.239.53.130');
[01/22/2024 04:47:56], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-22 04:47:56' WHERE id= '309';
[01/22/2024 04:47:56], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705898876','43.239.53.130');
[01/22/2024 04:48:54], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-22 04:48:54' WHERE id= '309';
[01/22/2024 04:48:54], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705898934','43.239.53.130');
[01/22/2024 04:56:57], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-22 04:56:57' WHERE id= '309';
[01/22/2024 04:56:57], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705899417','43.239.53.130');
[01/22/2024 04:59:43], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-22 04:59:43' WHERE id= '309';
[01/22/2024 04:59:43], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705899583','43.239.53.130');
