[01/22/2024 09:08:04], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-22 09:08:04',login_attempt=0 where id = '7851';
[01/22/2024 09:08:04], [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 09:08:04', ip = '43.239.53.130', action = 'Login' ;
[01/22/2024 09:08:04], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-22 09:08:04' WHERE id= '327';
[01/22/2024 09:08:06], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-22 09:08:06' WHERE id= '327';
[01/22/2024 09:08:10], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-22 09:08:10' WHERE id= '327';
[01/22/2024 09:08:18], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-22 09:08:18' WHERE id= '327';
[01/22/2024 09:08: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/29',  departure_date='2024/02/29',  nights='1',  create_date='2024-01-22 :09:08:18',  nationality='',  additional_markup='',  selected_currency='AED',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/22/2024 09:08:29], [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_09_08_18_1705914498.json', 'v1/22_01_2024/response_availability_Viator_test_09_08_18_1705914498.json', 'v1/22_01_2024/response_header_availability_Viator_test_09_08_18_1705914498.json', 'viator', '2024-01-22 09:08:29', '', '', '1073');
[01/22/2024 09:08:30], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-22 09:08:30' WHERE id= '327';
[01/22/2024 09:08:30], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-22 09:08:30' WHERE id= '327';
[01/22/2024 09:09:35], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-22 09:09:35' WHERE id= '327';
[01/22/2024 09:09:36], [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_09_09_35_1705914575.json', 'v1/22_01_2024/response_sight_details_Viator_test_09_09_35_1705914575.json', 'v1/22_01_2024/response_header_sight_details_Viator_test_09_09_35_1705914575.json', 'viator', '2024-01-22 09:09:36', '', '', '1073');
[01/22/2024 09:09:40], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-22 09:09:40' WHERE id= '327';
[01/22/2024 09:09:40], [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_09_09_40_1705914580.json', 'v1/22_01_2024/response_check_availability_Viator_test_09_09_40_1705914580.json', 'v1/22_01_2024/response_header_check_availability_Viator_test_09_09_40_1705914580.json', 'viator', '2024-01-22 09:09:40', '', '', '1073');
[01/22/2024 09:09:42], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-22 09:09:42' WHERE id= '327';
[01/22/2024 09:09:42], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705914582','43.239.53.130');
[01/22/2024 09:13:21], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-22 09:13:21' WHERE id= '327';
[01/22/2024 09:13:21], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705914801','43.239.53.130');
[01/22/2024 09:13:45], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-22 09:13:45' WHERE id= '327';
[01/22/2024 09:13:45], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705914825','43.239.53.130');
[01/22/2024 09:16:14], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-22 09:16:14' WHERE id= '327';
[01/22/2024 09:16:14], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705914974','43.239.53.130');
[01/22/2024 09:18:03], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-22 09:18:03' WHERE id= '327';
[01/22/2024 09:18:03], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705915083','43.239.53.130');
[01/22/2024 09:18:27], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-22 09:18:27' WHERE id= '327';
[01/22/2024 09:18:27], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705915107','43.239.53.130');
[01/22/2024 09:18:48], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-22 09:18:48' WHERE id= '327';
[01/22/2024 09:18:48], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705915128','43.239.53.130');
[01/22/2024 09:19:14], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-22 09:19:14' WHERE id= '327';
[01/22/2024 09:19:14], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705915154','43.239.53.130');
[01/22/2024 09:19:41], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-22 09:19:41' WHERE id= '327';
[01/22/2024 09:19:41], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705915181','43.239.53.130');
[01/22/2024 09:22:32], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-22 09:22:32' WHERE id= '327';
[01/22/2024 09:22:32], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705915352','43.239.53.130');
[01/22/2024 09:23:04], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-22 09:23:04' WHERE id= '327';
[01/22/2024 09:23:04], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705915384','43.239.53.130');
[01/22/2024 09:24:13], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-22 09:24:13' WHERE id= '327';
[01/22/2024 09:24:13], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705915453','43.239.53.130');
[01/22/2024 09:25:25], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-22 09:25:25' WHERE id= '327';
[01/22/2024 09:25:25], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705915525','43.239.53.130');
[01/22/2024 09:26:33], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-22 09:26:33' WHERE id= '327';
[01/22/2024 09:26:33], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705915593','43.239.53.130');
[01/22/2024 09:27:28], [file name :-/home/otrams/public_html/beta/transfer_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-22 09:27:28' WHERE id= '327';
[01/22/2024 09:30:08], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-22 09:30:08' WHERE id= '327';
[01/22/2024 09:30:08], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705915808','43.239.53.130');
[01/22/2024 09:32:20], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-22 09:32:20' WHERE id= '327';
[01/22/2024 09:32:20], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705915940','43.239.53.130');
[01/22/2024 09:33:27], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-22 09:33:27' WHERE id= '327';
[01/22/2024 09:33:27], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705916007','43.239.53.130');
[01/22/2024 09:33:54], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-22 09:33:54' WHERE id= '327';
[01/22/2024 09:33:54], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705916034','43.239.53.130');
[01/22/2024 09:34:54], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-22 09:34:54' WHERE id= '327';
[01/22/2024 09:34:54], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705916094','43.239.53.130');
[01/22/2024 09:36:00], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-22 09:36:00' WHERE id= '327';
[01/22/2024 09:36:00], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705916160','43.239.53.130');
[01/22/2024 09:37:35], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-22 09:37:35' WHERE id= '327';
[01/22/2024 09:37:35], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705916255','43.239.53.130');
[01/22/2024 09:37:51], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-22 09:37:51' WHERE id= '327';
[01/22/2024 09:37:51], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705916271','43.239.53.130');
[01/22/2024 09:41:52], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-22 09:41:52' WHERE id= '327';
[01/22/2024 09:41:52], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705916512','43.239.53.130');
[01/22/2024 09:42:50], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-22 09:42:50' WHERE id= '327';
[01/22/2024 09:42:50], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705916570','43.239.53.130');
[01/22/2024 09:43:43], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-22 09:43:43' WHERE id= '327';
[01/22/2024 09:43:43], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705916623','43.239.53.130');
[01/22/2024 09:44:30], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-22 09:44:30' WHERE id= '327';
[01/22/2024 09:44:30], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705916670','43.239.53.130');
[01/22/2024 09:44:40], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-22 09:44:40' WHERE id= '327';
[01/22/2024 09:44:40], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705916680','43.239.53.130');
[01/22/2024 09:45:25], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-22 09:45:25' WHERE id= '327';
[01/22/2024 09:45:25], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705916725','43.239.53.130');
[01/22/2024 09:46:38], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-22 09:46:38' WHERE id= '327';
[01/22/2024 09:46:38], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705916798','43.239.53.130');
[01/22/2024 09:46:42], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-22 09:46:42' WHERE id= '327';
[01/22/2024 09:46:42], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705916802','43.239.53.130');
[01/22/2024 09:51:46], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-22 09:51:46',login_attempt=0 where id = '7851';
[01/22/2024 09:51:46], [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 09:51:46', ip = '43.239.53.130', action = 'Login' ;
[01/22/2024 09:51:46], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-22 09:51:46' WHERE id= '309';
[01/22/2024 09:51:49], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-22 09:51:49' WHERE id= '309';
[01/22/2024 09:51:53], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-22 09:51:53' WHERE id= '309';
[01/22/2024 09:52:00], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-22 09:52:00' WHERE id= '309';
[01/22/2024 09:52: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/02/15',  departure_date='2024/02/15',  nights='1',  create_date='2024-01-22 :09:52:00',  nationality='',  additional_markup='',  selected_currency='AUD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/22/2024 09:52:12], [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_09_52_00_1705917120.json', 'v1/22_01_2024/response_availability_Viator_test_09_52_00_1705917120.json', 'v1/22_01_2024/response_header_availability_Viator_test_09_52_00_1705917120.json', 'viator', '2024-01-22 09:52:12', '', '', '1074');
[01/22/2024 09:52:14], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-22 09:52:14' WHERE id= '309';
[01/22/2024 09:52:15], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-22 09:52:15' WHERE id= '309';
[01/22/2024 09:52:56], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-22 09:52:56' WHERE id= '309';
[01/22/2024 09: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 ('', 'sight_details', 'v1/22_01_2024/request_sight_details_Viator_test_09_52_56_1705917176.json', 'v1/22_01_2024/response_sight_details_Viator_test_09_52_56_1705917176.json', 'v1/22_01_2024/response_header_sight_details_Viator_test_09_52_56_1705917176.json', 'viator', '2024-01-22 09:52:57', '', '', '1074');
[01/22/2024 09:53:00], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-22 09:53:00' WHERE id= '309';
[01/22/2024 09:53:00], [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_09_53_00_1705917180.json', 'v1/22_01_2024/response_check_availability_Viator_test_09_53_00_1705917180.json', 'v1/22_01_2024/response_header_check_availability_Viator_test_09_53_00_1705917180.json', 'viator', '2024-01-22 09:53:00', '', '', '1074');
[01/22/2024 09:53:02], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-22 09:53:02' WHERE id= '309';
[01/22/2024 09:53:02], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705917182','43.239.53.130');
[01/22/2024 09:54:19], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-22 09:54:19' WHERE id= '327';
[01/22/2024 09:54:19], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705917259','43.239.53.130');
