[01/02/2024 01:14:03], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-02 01:14:03' WHERE id= '251';
[01/02/2024 01:14:03], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7857' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '23' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/01/10',  departure_date='2024/01/10',  nights='1',  create_date='2024-01-02 :13:14:03',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/02/2024 01:14:04], [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/02_01_2024/request_availability_Deepak_T_13_14_03_1704201243.json', 'v1/02_01_2024/response_availability_Deepak_T_13_14_03_1704201243.json', 'v1/02_01_2024/response_header_availability_Deepak_T_13_14_03_1704201243.json', 'viator', '2024-01-02 01:14:04', '', '', '336');
[01/02/2024 01:14:06], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-02 01:14:06' WHERE id= '251';
[01/02/2024 01:14:06], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7857' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '23' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/01/10',  departure_date='2024/01/10',  nights='1',  create_date='2024-01-02 :13:14:06',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/02/2024 01:14:10], [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/02_01_2024/request_availability_Deepak_T_13_14_06_1704201246.json', 'v1/02_01_2024/response_availability_Deepak_T_13_14_06_1704201246.json', 'v1/02_01_2024/response_header_availability_Deepak_T_13_14_06_1704201246.json', 'viator', '2024-01-02 01:14:10', '', '', '337');
[01/02/2024 01:14:12], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-02 01:14:12' WHERE id= '251';
[01/02/2024 01:14:12], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7857' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '23' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/01/10',  departure_date='2024/01/10',  nights='1',  create_date='2024-01-02 :13:14:12',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/02/2024 01:14:13], [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/02_01_2024/request_availability_Deepak_T_13_14_12_1704201252.json', 'v1/02_01_2024/response_availability_Deepak_T_13_14_12_1704201252.json', 'v1/02_01_2024/response_header_availability_Deepak_T_13_14_12_1704201252.json', 'viator', '2024-01-02 01:14:13', '', '', '338');
[01/02/2024 01:14:52], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-02 01:14:52' WHERE id= '251';
[01/02/2024 01:14:52], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7857' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '23' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/01/10',  departure_date='2024/01/10',  nights='1',  create_date='2024-01-02 :13:14:52',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/02/2024 01:15:27], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-02 01:15:27' WHERE id= '251';
[01/02/2024 01:15:27], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7857' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '23' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/01/10',  departure_date='2024/01/10',  nights='1',  create_date='2024-01-02 :13:15:27',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/02/2024 01:16:05], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-02 01:16:05' WHERE id= '251';
[01/02/2024 01:16:05], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7857' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '23' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/01/10',  departure_date='2024/01/10',  nights='1',  create_date='2024-01-02 :13:16:05',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/02/2024 01:16:38], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-02 01:16:38' WHERE id= '251';
[01/02/2024 01:16:38], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7857' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '23' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/01/10',  departure_date='2024/01/10',  nights='1',  create_date='2024-01-02 :13:16:38',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/02/2024 01:18:07], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-02 01:18:07' WHERE id= '251';
[01/02/2024 01:18:07], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7857' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '23' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/01/10',  departure_date='2024/01/10',  nights='1',  create_date='2024-01-02 :13:18:07',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/02/2024 01:18:42], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-02 01:18:42' WHERE id= '251';
[01/02/2024 01:18:42], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7857' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '23' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/01/10',  departure_date='2024/01/10',  nights='1',  create_date='2024-01-02 :13:18:42',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/02/2024 01:24:07], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-02 01:24:07' WHERE id= '251';
[01/02/2024 01:24:07], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7857' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '23' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/01/10',  departure_date='2024/01/10',  nights='1',  create_date='2024-01-02 :13:24:07',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/02/2024 01:24:13], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-02 01:24:13' WHERE id= '251';
[01/02/2024 01:24:13], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7857' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '23' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/01/10',  departure_date='2024/01/10',  nights='1',  create_date='2024-01-02 :13:24:13',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/02/2024 01:33:15], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-02 01:33:15' WHERE id= '251';
[01/02/2024 01:33:15], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7857' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '23' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/01/10',  departure_date='2024/01/10',  nights='1',  create_date='2024-01-02 :13:33:15',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/02/2024 01:38:53], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-02 01:38:53' WHERE id= '251';
[01/02/2024 01:38:53], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7857' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '23' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/01/10',  departure_date='2024/01/10',  nights='1',  create_date='2024-01-02 :13:38:53',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/02/2024 01:41:34], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-02 01:41:34' WHERE id= '251';
[01/02/2024 01:41:34], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7857' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '23' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/01/10',  departure_date='2024/01/10',  nights='1',  create_date='2024-01-02 :13:41:34',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/02/2024 01:44:13], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-02 01:44:13' WHERE id= '251';
[01/02/2024 01:44:13], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7857' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '23' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/01/10',  departure_date='2024/01/10',  nights='1',  create_date='2024-01-02 :13:44:13',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/02/2024 01:44:13], [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/02_01_2024/request_availability_Deepak_T_13_44_13_1704203053.json', 'v1/02_01_2024/response_availability_Deepak_T_13_44_13_1704203053.json', 'v1/02_01_2024/response_header_availability_Deepak_T_13_44_13_1704203053.json', 'viator', '2024-01-02 01:44:13', '', '', '350');
[01/02/2024 01:52:21], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-02 01:52:21',login_attempt=0 where id = '7851';
[01/02/2024 01:52:21], [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-02 13:52:21', ip = '43.239.53.130', action = 'Login' ;
[01/02/2024 01:52:21], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-02 01:52:21' WHERE id= '247';
[01/02/2024 01:52:24], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-02 01:52:24' WHERE id= '247';
[01/02/2024 01:52:29], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-02 01:52:29' WHERE id= '247';
[01/02/2024 01:52:37], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-02 01:52:37' WHERE id= '247';
[01/02/2024 01:52:37], [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/10',  departure_date='2024/01/10',  nights='1',  create_date='2024-01-02 :13:52:37',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/02/2024 01:52:38], [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/02_01_2024/request_availability_Viator_test_13_52_37_1704203557.json', 'v1/02_01_2024/response_availability_Viator_test_13_52_37_1704203557.json', 'v1/02_01_2024/response_header_availability_Viator_test_13_52_37_1704203557.json', 'viator', '2024-01-02 01:52:38', '', '', '351');
[01/02/2024 01:53:22], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-02 01:53:22' WHERE id= '247';
[01/02/2024 01:53:23], [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/10',  departure_date='2024/01/10',  nights='1',  create_date='2024-01-02 :13:53:23',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/02/2024 01:53: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/02_01_2024/request_availability_Viator_test_13_53_25_1704203605.json', 'v1/02_01_2024/response_availability_Viator_test_13_53_25_1704203605.json', 'v1/02_01_2024/response_header_availability_Viator_test_13_53_25_1704203605.json', 'viator', '2024-01-02 01:53:28', '', '', '352');
[01/02/2024 01:53:34], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-02 01:53:34' WHERE id= '247';
[01/02/2024 01:53:45], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2024-01-02 01:53:45' WHERE id= '247';
[01/02/2024 01:53:45], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-02 01:53:45',login_attempt=0 where id = '7851';
[01/02/2024 01:53:45], [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-02 13:53:45', ip = '43.239.53.130', action = 'Login' ;
[01/02/2024 01:53:45], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-02 01:53:45' WHERE id= '247';
[01/02/2024 01:53:49], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-02 01:53:49' WHERE id= '247';
[01/02/2024 01:53:55], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-02 01:53:55' WHERE id= '247';
[01/02/2024 01:54:02], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-02 01:54:02' WHERE id= '247';
[01/02/2024 01:54:02], [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/10',  departure_date='2024/01/10',  nights='1',  create_date='2024-01-02 :13:54:02',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/02/2024 01:54: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/02_01_2024/request_availability_Viator_test_13_54_02_1704203642.json', 'v1/02_01_2024/response_availability_Viator_test_13_54_02_1704203642.json', 'v1/02_01_2024/response_header_availability_Viator_test_13_54_02_1704203642.json', 'viator', '2024-01-02 01:54:07', '', '', '353');
