[01/15/2024 09:00:58], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-15 09:00:58' WHERE id= '297';
[01/15/2024 09:00:59], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705309259','43.239.53.130');
[01/15/2024 09:03:53], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-15 09:03:53' WHERE id= '297';
[01/15/2024 09:03:53], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705309433','43.239.53.130');
[01/15/2024 09:04:33], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-15 09:04:33' WHERE id= '297';
[01/15/2024 09:04:33], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705309473','43.239.53.130');
[01/15/2024 09:11:00], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-15 09:11:00' WHERE id= '297';
[01/15/2024 09:11:00], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705309860','43.239.53.130');
[01/15/2024 09:12:15], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-15 09:12:15' WHERE id= '297';
[01/15/2024 09:12:15], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705309935','43.239.53.130');
[01/15/2024 09:14:07], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-15 09:14:07' WHERE id= '297';
[01/15/2024 09:14:07], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705310047','43.239.53.130');
[01/15/2024 09:15:40], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-15 09:15:40' WHERE id= '297';
[01/15/2024 09:15:40], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705310140','43.239.53.130');
[01/15/2024 09:16:48], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-15 09:16:48' WHERE id= '297';
[01/15/2024 09:16:48], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705310208','43.239.53.130');
[01/15/2024 09:19:08], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-15 09:19:08' WHERE id= '297';
[01/15/2024 09:19:08], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705310348','43.239.53.130');
[01/15/2024 09:19:49], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-15 09:19:49' WHERE id= '297';
[01/15/2024 09:19:49], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705310389','43.239.53.130');
[01/15/2024 09:23:00], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET is_exception = 'yes', exception_info = CONCAT(exception_info, '~~~' ,'ip changed 103.104.226.130') WHERE id= '297';
[01/15/2024 09:23:28], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-15 09:23:28',login_attempt=0 where id = '7851';
[01/15/2024 09:23: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-15 09:23:28', ip = '103.104.226.130', action = 'Login' ;
[01/15/2024 09:23:28], [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 103.104.226.130') WHERE id= '297';
[01/15/2024 09:23:38], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-15 09:23:38',login_attempt=0 where id = '7851';
[01/15/2024 09:23:38], [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-15 09:23:38', ip = '103.104.226.130', action = 'Login' ;
[01/15/2024 09:23:39], [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 103.104.226.130') WHERE id= '297';
[01/15/2024 09:23:47], [file name :-/home/otrams/public_html/beta/tms/logout.php],INSERT INTO psa_login_log set username = 'v3alpha' , user_type = 'v3alpha'_type , branch_id = '' , login_datetime = '2024-01-15 09:23:47' , ip = '103.104.226.130' , action = 'Logout'  ;
[01/15/2024 09:24:12], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-15 09:24:12',login_attempt=0 where id = '7851';
[01/15/2024 09:24:12], [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-15 09:24:12', ip = '103.104.226.130', action = 'Login' ;
[01/15/2024 09:24:13], [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 103.104.226.130') WHERE id= '297';
[01/15/2024 09:30:39], [file name :-/home/otrams/public_html/beta/tms/logout.php],INSERT INTO psa_login_log set username = 'SUJAY_QTECH' , user_type = 'SUJAY_QTECH'_type , branch_id = '' , login_datetime = '2024-01-15 09:30:39' , ip = '43.239.53.130' , action = 'Logout'  ;
[01/15/2024 09:32:08], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-15 09:32:08',login_attempt=0 where id = '7851';
[01/15/2024 09:32:08], [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-15 09:32:08', ip = '43.239.53.130', action = 'Login' ;
[01/15/2024 09:32:08], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-15 09:32:08' WHERE id= '297';
[01/15/2024 09:32:12], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-15 09:32:12' WHERE id= '297';
[01/15/2024 09:32:19], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-15 09:32:19' WHERE id= '297';
[01/15/2024 09:32:24], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-15 09:32:24' WHERE id= '297';
[01/15/2024 09:32:24], [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/18',  departure_date='2024/01/18',  nights='1',  create_date='2024-01-15 :09:32:24',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/15/2024 09:32:25], [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/15_01_2024/request_availability_Viator_test_09_32_24_1705311144.json', 'v1/15_01_2024/response_availability_Viator_test_09_32_24_1705311144.json', 'v1/15_01_2024/response_header_availability_Viator_test_09_32_24_1705311144.json', 'viator', '2024-01-15 09:32:25', '', '', '921');
[01/15/2024 09:32:27], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-15 09:32:27' WHERE id= '297';
[01/15/2024 09:32:27], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-15 09:32:27' WHERE id= '297';
[01/15/2024 09:32:33], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-15 09:32:33' WHERE id= '297';
[01/15/2024 09:32:34], [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/15_01_2024/request_sight_details_Viator_test_09_32_33_1705311153.json', 'v1/15_01_2024/response_sight_details_Viator_test_09_32_33_1705311153.json', 'v1/15_01_2024/response_header_sight_details_Viator_test_09_32_33_1705311153.json', 'viator', '2024-01-15 09:32:34', '', '', '921');
[01/15/2024 09:32:39], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-15 09:32:39' WHERE id= '297';
[01/15/2024 09:32: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 ('', 'check_availability', 'v1/15_01_2024/request_check_availability_Viator_test_09_32_39_1705311159.json', 'v1/15_01_2024/response_check_availability_Viator_test_09_32_39_1705311159.json', 'v1/15_01_2024/response_header_check_availability_Viator_test_09_32_39_1705311159.json', 'viator', '2024-01-15 09:32:39', '', '', '921');
[01/15/2024 09:32:45], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-15 09:32:45' WHERE id= '297';
[01/15/2024 09:32:46], [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/15_01_2024/request_check_availability_Viator_test_09_32_46_1705311166.json', 'v1/15_01_2024/response_check_availability_Viator_test_09_32_46_1705311166.json', 'v1/15_01_2024/response_header_check_availability_Viator_test_09_32_46_1705311166.json', 'viator', '2024-01-15 09:32:46', '', '', '921');
[01/15/2024 09:32:47], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-15 09:32:47' WHERE id= '297';
[01/15/2024 09:32:47], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705311167','43.239.53.130');
[01/15/2024 09:33:15], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-15 09:33:15' WHERE id= '297';
[01/15/2024 09:33:15], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705311195','43.239.53.130');
[01/15/2024 09:38:32], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-15 09:38:32',login_attempt=0 where id = '7851';
[01/15/2024 09:38:32], [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-15 09:38:32', ip = '43.239.53.130', action = 'Login' ;
[01/15/2024 09:38:32], [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/15/2024 09:38:49], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2024-01-15 09:38:49' WHERE id= '297';
[01/15/2024 09:38:49], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-15 09:38:49',login_attempt=0 where id = '7851';
[01/15/2024 09:38:49], [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-15 09:38:49', ip = '43.239.53.130', action = 'Login' ;
[01/15/2024 09:38:49], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-15 09:38:49' WHERE id= '297';
[01/15/2024 09:38:54], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-15 09:38:54' WHERE id= '297';
[01/15/2024 09:39:00], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-15 09:39:00' WHERE id= '297';
[01/15/2024 09:39:05], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-15 09:39:05' WHERE id= '297';
[01/15/2024 09:39:05], [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/18',  departure_date='2024/01/18',  nights='1',  create_date='2024-01-15 :09:39:05',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/15/2024 09:39:06], [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/15_01_2024/request_availability_Viator_test_09_39_05_1705311545.json', 'v1/15_01_2024/response_availability_Viator_test_09_39_05_1705311545.json', 'v1/15_01_2024/response_header_availability_Viator_test_09_39_05_1705311545.json', 'viator', '2024-01-15 09:39:06', '', '', '922');
[01/15/2024 09:39:07], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-15 09:39:07' WHERE id= '297';
[01/15/2024 09:39:07], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-15 09:39:07' WHERE id= '297';
[01/15/2024 09:39:09], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-15 09:39:09' WHERE id= '297';
[01/15/2024 09:39: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 ('', 'sight_details', 'v1/15_01_2024/request_sight_details_Viator_test_09_39_09_1705311549.json', 'v1/15_01_2024/response_sight_details_Viator_test_09_39_09_1705311549.json', 'v1/15_01_2024/response_header_sight_details_Viator_test_09_39_09_1705311549.json', 'viator', '2024-01-15 09:39:10', '', '', '922');
[01/15/2024 09:39:15], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-15 09:39:15' WHERE id= '297';
[01/15/2024 09:39:15], [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/15_01_2024/request_check_availability_Viator_test_09_39_15_1705311555.json', 'v1/15_01_2024/response_check_availability_Viator_test_09_39_15_1705311555.json', 'v1/15_01_2024/response_header_check_availability_Viator_test_09_39_15_1705311555.json', 'viator', '2024-01-15 09:39:15', '', '', '922');
[01/15/2024 09:39:19], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-15 09:39:19' WHERE id= '297';
[01/15/2024 09:39:19], [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/15_01_2024/request_check_availability_Viator_test_09_39_19_1705311559.json', 'v1/15_01_2024/response_check_availability_Viator_test_09_39_19_1705311559.json', 'v1/15_01_2024/response_header_check_availability_Viator_test_09_39_19_1705311559.json', 'viator', '2024-01-15 09:39:19', '', '', '922');
[01/15/2024 09:39:46], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-15 09:39:46' WHERE id= '297';
[01/15/2024 09:39:46], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705311586','43.239.53.130');
[01/15/2024 09:42:42], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-15 09:42:42' WHERE id= '297';
[01/15/2024 09:42:42], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705311762','43.239.53.130');
[01/15/2024 09:53:59], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-15 09:53:59' WHERE id= '297';
[01/15/2024 09:53:59], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705312439','43.239.53.130');
