[02/14/2024 05:13:46], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-02-14 05:13:46',login_attempt=0 where id = '7849';
[02/14/2024 05:13:46], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'shiv_qtech', user_type = 'A', branch_id = '24', login_datetime = '2024-02-14 05:13:46', ip = '43.239.53.130', action = 'Login' ;
[02/14/2024 05:13:46], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 05:13:46' WHERE id= '541';
[02/14/2024 05:13:50], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 05:13:50' WHERE id= '541';
[02/14/2024 05:13:54], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 05:13:54' WHERE id= '541';
[02/14/2024 05:13:59], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 05:13:59' WHERE id= '541';
[02/14/2024 05:13:59], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7849' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '24' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/02/29',  departure_date='2024/02/29',  nights='1',  create_date='2024-02-14 :05:13:59',  nationality='',  additional_markup='',  selected_currency='INR',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[02/14/2024 05:14: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/14_02_2024/request_availability_shiv_qtech_05_13_59_1707887639.json', 'v1/14_02_2024/response_availability_shiv_qtech_05_13_59_1707887639.json', 'v1/14_02_2024/response_header_availability_shiv_qtech_05_13_59_1707887639.json', 'viator', '2024-02-14 05:14:01', '', '', '1441');
[02/14/2024 05:14:02], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 05:14:02' WHERE id= '541';
[02/14/2024 05:14:02], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 05:14:02' WHERE id= '541';
[02/14/2024 05:14:06], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 05:14:06' WHERE id= '541';
[02/14/2024 05:14:06], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 05:14:06' WHERE id= '541';
[02/14/2024 05:14:06], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 05:14:06' WHERE id= '541';
[02/14/2024 05:14:06], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 05:14:06' WHERE id= '541';
[02/14/2024 05:14:07], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 05:14:07' WHERE id= '541';
[02/14/2024 05:14:08], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 05:14:08' WHERE id= '541';
[02/14/2024 05:14:11], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 05:14:11' WHERE id= '541';
[02/14/2024 05:14:12], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 05:14:12' WHERE id= '541';
[02/14/2024 05:24:11], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-02-14 05:24:11',login_attempt=0 where id = '7869';
[02/14/2024 05:24:11], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Viator', user_type = 'A', branch_id = '1', login_datetime = '2024-02-14 05:24:11', ip = '43.239.53.130', action = 'Login' ;
[02/14/2024 05:24:12], [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= '58';
[02/14/2024 05:24:18], [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-02-14 05:24:18' , ip = '43.239.53.130' , action = 'Logout'  ;
[02/14/2024 05:24:50], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-02-14 05:24:50',login_attempt=0 where id = '7869';
[02/14/2024 05:24:50], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Viator', user_type = 'A', branch_id = '1', login_datetime = '2024-02-14 05:24:50', ip = '43.239.53.130', action = 'Login' ;
[02/14/2024 05:24:51], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 05:24:51' WHERE id= '552';
[02/14/2024 05:24:54], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 05:24:54' WHERE id= '552';
[02/14/2024 05:25:00], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 05:25:00' WHERE id= '552';
[02/14/2024 05:25:09], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 05:25:09' WHERE id= '552';
[02/14/2024 05:25:09], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7869' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/02/22',  departure_date='2024/02/22',  nights='1',  create_date='2024-02-14 :05:25:09',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[02/14/2024 05:25:09], [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/14_02_2024/request_availability_Viator_05_25_09_1707888309.json', 'v1/14_02_2024/response_availability_Viator_05_25_09_1707888309.json', 'v1/14_02_2024/response_header_availability_Viator_05_25_09_1707888309.json', 'viator', '2024-02-14 05:25:09', '', '', '1442');
[02/14/2024 05:25:10], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 05:25:10' WHERE id= '552';
[02/14/2024 05:25:20], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 05:25:20' WHERE id= '552';
[02/14/2024 05:25:20], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7869' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/02/22',  departure_date='2024/02/22',  nights='1',  create_date='2024-02-14 :05:25:20',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[02/14/2024 05:25:21], [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/14_02_2024/request_availability_Viator_05_25_20_1707888320.json', 'v1/14_02_2024/response_availability_Viator_05_25_20_1707888320.json', 'v1/14_02_2024/response_header_availability_Viator_05_25_20_1707888320.json', 'viator', '2024-02-14 05:25:21', '', '', '1443');
[02/14/2024 05:25:22], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 05:25:22' WHERE id= '552';
[02/14/2024 05:25:22], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 05:25:22' WHERE id= '552';
[02/14/2024 05:35:24], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 05:35:24' WHERE id= '552';
[02/14/2024 05:35:24], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7869' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/02/22',  departure_date='2024/02/22',  nights='1',  create_date='2024-02-14 :05:35:24',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[02/14/2024 05:35: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/14_02_2024/request_availability_Viator_05_35_24_1707888924.json', 'v1/14_02_2024/response_availability_Viator_05_35_24_1707888924.json', 'v1/14_02_2024/response_header_availability_Viator_05_35_24_1707888924.json', 'viator', '2024-02-14 05:35:29', '', '', '1444');
[02/14/2024 05:43:23], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 05:43:23' WHERE id= '552';
[02/14/2024 05:43:23], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7869' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/02/22',  departure_date='2024/02/22',  nights='1',  create_date='2024-02-14 :05:43:23',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[02/14/2024 05:43:27], [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/14_02_2024/request_availability_Viator_05_43_23_1707889403.json', 'v1/14_02_2024/response_availability_Viator_05_43_23_1707889403.json', 'v1/14_02_2024/response_header_availability_Viator_05_43_23_1707889403.json', 'viator', '2024-02-14 05:43:27', '', '', '1445');
[02/14/2024 05:43:28], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 05:43:28' WHERE id= '552';
[02/14/2024 05:43:28], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 05:43:28' WHERE id= '552';
[02/14/2024 05:43:41], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 05:43:41' WHERE id= '552';
[02/14/2024 05:43:41], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7869' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/02/22',  departure_date='2024/02/22',  nights='1',  create_date='2024-02-14 :05:43:41',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[02/14/2024 05:43:41], [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/14_02_2024/request_availability_Viator_05_43_41_1707889421.json', 'v1/14_02_2024/response_availability_Viator_05_43_41_1707889421.json', 'v1/14_02_2024/response_header_availability_Viator_05_43_41_1707889421.json', 'viator', '2024-02-14 05:43:41', '', '', '1446');
[02/14/2024 05:43:42], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 05:43:42' WHERE id= '552';
[02/14/2024 05:43:43], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 05:43:43' WHERE id= '552';
[02/14/2024 05:43:53], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 05:43:53' WHERE id= '552';
[02/14/2024 05:45:35], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 05:45:35' WHERE id= '552';
[02/14/2024 05:45:48], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 05:45:48' WHERE id= '552';
[02/14/2024 05:45:57], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 05:45:57' WHERE id= '552';
[02/14/2024 05:46:37], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 05:46:37' WHERE id= '552';
[02/14/2024 05:46:37], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7869' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/02/22',  departure_date='2024/02/22',  nights='1',  create_date='2024-02-14 :05:46:37',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[02/14/2024 05:46:37], [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/14_02_2024/request_availability_Viator_05_46_37_1707889597.json', 'v1/14_02_2024/response_availability_Viator_05_46_37_1707889597.json', 'v1/14_02_2024/response_header_availability_Viator_05_46_37_1707889597.json', 'viator', '2024-02-14 05:46:37', '', '', '1447');
[02/14/2024 05:46:38], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 05:46:38' WHERE id= '552';
[02/14/2024 05:47:03], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 05:47:03' WHERE id= '552';
[02/14/2024 05:47:03], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7869' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/02/22',  departure_date='2024/02/22',  nights='1',  create_date='2024-02-14 :05:47:03',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[02/14/2024 05:47:07], [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/14_02_2024/request_availability_Viator_05_47_03_1707889623.json', 'v1/14_02_2024/response_availability_Viator_05_47_03_1707889623.json', 'v1/14_02_2024/response_header_availability_Viator_05_47_03_1707889623.json', 'viator', '2024-02-14 05:47:07', '', '', '1448');
[02/14/2024 05:47:08], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 05:47:08' WHERE id= '552';
[02/14/2024 05:47:08], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 05:47:08' WHERE id= '552';
[02/14/2024 05:48:59], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 05:48:59' WHERE id= '552';
[02/14/2024 05:51:14], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 05:51:14' WHERE id= '552';
[02/14/2024 05:52:30], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 05:52:30' WHERE id= '552';
[02/14/2024 05:52:56], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 05:52:56' WHERE id= '552';
[02/14/2024 05:54:54], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 05:54:54' WHERE id= '552';
[02/14/2024 05:55:17], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 05:55:17' WHERE id= '552';
[02/14/2024 05:55:42], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 05:55:42' WHERE id= '552';
[02/14/2024 05:57:50], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 05:57:50' WHERE id= '552';
[02/14/2024 05:58:14], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 05:58:14' WHERE id= '552';
[02/14/2024 05:58:25], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 05:58:25' WHERE id= '552';
[02/14/2024 05:59:27], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 05:59:27' WHERE id= '552';
[02/14/2024 05:59:37], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 05:59:37' WHERE id= '552';
