[01/03/2024 06:00:00], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-03 06:00:00' WHERE id= '247';
[01/03/2024 06:00:05], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-03 06:00:05' WHERE id= '247';
[01/03/2024 06:00:14], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-03 06:00:14' WHERE id= '247';
[01/03/2024 06:00:14], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '108' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '0' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/01/06',  departure_date='2024/01/06',  nights='1',  create_date='2024-01-03 :06:00:14',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/03/2024 06:00:30], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-01-03 06:00:30' WHERE id= '252';
[01/03/2024 06:01:35], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-03 06:01:35' WHERE id= '247';
[01/03/2024 06:01:35], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '108' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '0' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/01/06',  departure_date='2024/01/06',  nights='1',  create_date='2024-01-03 :06:01:35',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/03/2024 06:01: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/03_01_2024/request_availability_rrrrrrrrr_06_01_35_1704261695.json', 'v1/03_01_2024/response_availability_rrrrrrrrr_06_01_35_1704261695.json', 'v1/03_01_2024/response_header_availability_rrrrrrrrr_06_01_35_1704261695.json', 'viator', '2024-01-03 06:01:37', '', '', '379');
[01/03/2024 06:02:03], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-03 06:02:03' WHERE id= '254';
[01/03/2024 06:02:03], [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-03 :06:02:03',  nationality='',  additional_markup='',  selected_currency='INR',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/03/2024 06:02: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/03_01_2024/request_availability_Viator_test_06_02_03_1704261723.json', 'v1/03_01_2024/response_availability_Viator_test_06_02_03_1704261723.json', 'v1/03_01_2024/response_header_availability_Viator_test_06_02_03_1704261723.json', 'viator', '2024-01-03 06:02:04', '', '', '380');
[01/03/2024 06:03:09], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-03 06:03:09' WHERE id= '247';
[01/03/2024 06:03:09], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '108' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '0' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/01/06',  departure_date='2024/01/06',  nights='1',  create_date='2024-01-03 :06:03:09',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/03/2024 06:03:17], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-01-03 06:03:17' WHERE id= '252';
[01/03/2024 06:05:00], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-03 06:05:00' WHERE id= '247';
[01/03/2024 06:05:00], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '108' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '0' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/01/06',  departure_date='2024/01/06',  nights='1',  create_date='2024-01-03 :06:05:00',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/03/2024 06:05:05], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-03 06:05:05' WHERE id= '254';
[01/03/2024 06:05: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/10',  departure_date='2024/01/10',  nights='1',  create_date='2024-01-03 :06:05:05',  nationality='',  additional_markup='',  selected_currency='INR',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/03/2024 06:07:52], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-03 06:07:52' WHERE id= '247';
[01/03/2024 06:07:52], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '108' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '0' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/01/06',  departure_date='2024/01/06',  nights='1',  create_date='2024-01-03 :06:07:52',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/03/2024 06:09:54], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-03 06:09:54' WHERE id= '247';
[01/03/2024 06:09:54], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '108' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '0' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/01/06',  departure_date='2024/01/06',  nights='1',  create_date='2024-01-03 :06:09:54',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/03/2024 06:10:21], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-03 06:10:21' WHERE id= '247';
[01/03/2024 06:10:21], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '108' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '0' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/01/06',  departure_date='2024/01/06',  nights='1',  create_date='2024-01-03 :06:10:21',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/03/2024 06:11:14], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-03 06:11:14' WHERE id= '247';
[01/03/2024 06:11:14], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '108' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '0' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/01/06',  departure_date='2024/01/06',  nights='1',  create_date='2024-01-03 :06:11:14',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/03/2024 06:11:30], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-03 06:11:30' WHERE id= '254';
[01/03/2024 06:11:30], [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-03 :06:11:30',  nationality='',  additional_markup='',  selected_currency='INR',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/03/2024 06:11:39], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-03 06:11:39' WHERE id= '254';
[01/03/2024 06:11:39], [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-03 :06:11:39',  nationality='',  additional_markup='',  selected_currency='INR',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/03/2024 06:11:56], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-03 06:11:56' WHERE id= '247';
[01/03/2024 06:11:56], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '108' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '0' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/01/06',  departure_date='2024/01/06',  nights='1',  create_date='2024-01-03 :06:11:56',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/03/2024 06:12:00], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-03 06:12:00' WHERE id= '254';
[01/03/2024 06:12: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/01/10',  departure_date='2024/01/10',  nights='1',  create_date='2024-01-03 :06:12:00',  nationality='',  additional_markup='',  selected_currency='INR',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/03/2024 06:12:23], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-03 06:12:23' WHERE id= '254';
[01/03/2024 06:12: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-03 :06:12:23',  nationality='',  additional_markup='',  selected_currency='INR',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/03/2024 06:14:12], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-03 06:14:12' WHERE id= '247';
[01/03/2024 06:14:12], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '108' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '0' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/01/06',  departure_date='2024/01/06',  nights='1',  create_date='2024-01-03 :06:14:12',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/03/2024 06:15:56], [file name :-/home/otrams/public_html/beta/tms/agent.php],DELETE FROM agent_supplier_settings WHERE 1  and agent_id= ? ;
[01/03/2024 06:15:56], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '67' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/03/2024 06:15:56], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '52' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/03/2024 06:15:56], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '76' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/03/2024 06:15:56], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '24' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/03/2024 06:15:56], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '77' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/03/2024 06:15:56], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '64' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/03/2024 06:15:56], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '65' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/03/2024 06:15:56], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '34' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/03/2024 06:15:56], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '20' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/03/2024 06:15:56], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '55' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/03/2024 06:15:56], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '62' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/03/2024 06:15:56], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '53' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/03/2024 06:15:56], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '16' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/03/2024 06:15:56], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '75' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/03/2024 06:15:56], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '60' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/03/2024 06:15:56], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '18' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/03/2024 06:15:56], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '19' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/03/2024 06:15:56], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '73' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/03/2024 06:15:56], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '71' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/03/2024 06:15:56], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '69' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/03/2024 06:15:56], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '68' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/03/2024 06:15:56], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '74' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/03/2024 06:15:56], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '35' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/03/2024 06:15:56], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '70' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/03/2024 06:15:56], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '59' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/03/2024 06:15:56], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '32' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/03/2024 06:15:56], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '58' ,status = '1' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/03/2024 06:15:56], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '56' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/03/2024 06:15:56], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '57' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/03/2024 06:15:56], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '61' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/03/2024 06:15:56], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '63' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/03/2024 06:15:56], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '54' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/03/2024 06:15:56], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '66' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/03/2024 06:15:56], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '45' ,status = '' ,priority = '' ,lead_time = '',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/03/2024 06:15:56], [file name :-/home/otrams/public_html/beta/tms/agent.php],insert into `user_logs` set `username`= 'v3alpha',`create_date`= '2024-01-03 06:15:56',`log_type`= 'Agent Supplier settings',`sql_query`= '======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7851\&#039;,supplier_id = 67 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7851\&#039;,supplier_id = 52 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7851\&#039;,supplier_id = 76 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7851\&#039;,supplier_id = 24 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7851\&#039;,supplier_id = 77 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7851\&#039;,supplier_id = 64 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7851\&#039;,supplier_id = 65 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7851\&#039;,supplier_id = 34 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7851\&#039;,supplier_id = 20 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7851\&#039;,supplier_id = 55 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7851\&#039;,supplier_id = 62 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7851\&#039;,supplier_id = 53 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7851\&#039;,supplier_id = 16 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7851\&#039;,supplier_id = 75 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7851\&#039;,supplier_id = 60 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7851\&#039;,supplier_id = 18 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7851\&#039;,supplier_id = 19 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7851\&#039;,supplier_id = 73 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7851\&#039;,supplier_id = 71 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7851\&#039;,supplier_id = 69 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7851\&#039;,supplier_id = 68 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7851\&#039;,supplier_id = 74 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7851\&#039;,supplier_id = 35 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7851\&#039;,supplier_id = 70 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7851\&#039;,supplier_id = 59 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7851\&#039;,supplier_id = 32 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7851\&#039;,supplier_id = 58 ,status = \&#039;1\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7851\&#039;,supplier_id = 56 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7851\&#039;,supplier_id = 57 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7851\&#039;,supplier_id = 61 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7851\&#039;,supplier_id = 63 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7851\&#039;,supplier_id = 54 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7851\&#039;,supplier_id = 66 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7851\&#039;,supplier_id = 45 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = ,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;',`log_description`= 'Supplier setting updated  Previous data-- agent_id-7851 ## supplier_id- 58 ## company_name - Viator (SightSeeing) ## supplier_code-viator  ## percentage - 0.00 ## lead_time - 0 ',`ip`= '43.239.53.130';
[01/03/2024 06:16:07], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2024-01-03 06:16:07' WHERE id= '247';
[01/03/2024 06:16:07], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-03 06:16:07',login_attempt=0 where id = '7851';
[01/03/2024 06:16:07], [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-03 06:16:07', ip = '43.239.53.130', action = 'Login' ;
[01/03/2024 06:16:07], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-03 06:16:07' WHERE id= '247';
[01/03/2024 06:16:10], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-03 06:16:10' WHERE id= '247';
[01/03/2024 06:16:17], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-03 06:16:17' WHERE id= '247';
[01/03/2024 06:16:23], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-03 06:16:23' WHERE id= '247';
[01/03/2024 06:16: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/05',  departure_date='2024/01/05',  nights='1',  create_date='2024-01-03 :06:16:23',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/03/2024 06:16:41], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-03 06:16:41' WHERE id= '254';
[01/03/2024 06:16:41], [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-03 :06:16:41',  nationality='',  additional_markup='',  selected_currency='INR',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/03/2024 06:16:44], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-03 06:16:44' WHERE id= '254';
[01/03/2024 06:16:44], [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-03 :06:16:44',  nationality='',  additional_markup='',  selected_currency='INR',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/03/2024 06:16:53], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-01-03 06:16:53' WHERE id= '252';
[01/03/2024 06:18:09], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-03 06:18:09' WHERE id= '247';
[01/03/2024 06:18:09], [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/05',  departure_date='2024/01/05',  nights='1',  create_date='2024-01-03 :06:18:09',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/03/2024 06:20:53], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-03 06:20:53' WHERE id= '247';
[01/03/2024 06:20:53], [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/05',  departure_date='2024/01/05',  nights='1',  create_date='2024-01-03 :06:20:53',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/03/2024 06:22:13], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-03 06:22:13' WHERE id= '247';
[01/03/2024 06:22:13], [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/05',  departure_date='2024/01/05',  nights='1',  create_date='2024-01-03 :06:22:13',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/03/2024 06:22: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/03_01_2024/request_availability_Viator_test_06_22_13_1704262933.json', 'v1/03_01_2024/response_availability_Viator_test_06_22_13_1704262933.json', 'v1/03_01_2024/response_header_availability_Viator_test_06_22_13_1704262933.json', 'viator', '2024-01-03 06:22:13', '', '', '399');
[01/03/2024 06:25:20], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-03 06:25:20' WHERE id= '247';
[01/03/2024 06:25:20], [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/05',  departure_date='2024/01/05',  nights='1',  create_date='2024-01-03 :06:25:20',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/03/2024 06: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/03_01_2024/request_availability_Viator_test_06_25_20_1704263120.json', 'v1/03_01_2024/response_availability_Viator_test_06_25_20_1704263120.json', 'v1/03_01_2024/response_header_availability_Viator_test_06_25_20_1704263120.json', 'viator', '2024-01-03 06:25:21', '', '', '400');
[01/03/2024 06:25:37], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-03 06:25:37' WHERE id= '247';
[01/03/2024 06:26:33], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-03 06:26:33' WHERE id= '247';
[01/03/2024 06:27:18], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-03 06:27:18' WHERE id= '247';
[01/03/2024 06:27:20], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-03 06:27:20' WHERE id= '247';
[01/03/2024 06:28:33], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-03 06:28:33' WHERE id= '247';
[01/03/2024 06:28:36], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-01-03 06:28:36' WHERE id= '252';
[01/03/2024 06:28:43], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2024-01-03 06:28:43' WHERE id= '247';
[01/03/2024 06:28:43], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-03 06:28:43',login_attempt=0 where id = '7851';
[01/03/2024 06:28:43], [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-03 06:28:43', ip = '43.239.53.130', action = 'Login' ;
[01/03/2024 06:28:43], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-03 06:28:43' WHERE id= '247';
[01/03/2024 06:28:46], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-03 06:28:46' WHERE id= '247';
[01/03/2024 06:28:49], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-03 06:28:49' WHERE id= '247';
[01/03/2024 06:28:56], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-03 06:28:56' WHERE id= '247';
[01/03/2024 06:28:56], [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/05',  departure_date='2024/01/05',  nights='1',  create_date='2024-01-03 :06:28:56',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/03/2024 06:28:57], [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/03_01_2024/request_availability_Viator_test_06_28_56_1704263336.json', 'v1/03_01_2024/response_availability_Viator_test_06_28_56_1704263336.json', 'v1/03_01_2024/response_header_availability_Viator_test_06_28_56_1704263336.json', 'viator', '2024-01-03 06:28:57', '', '', '401');
[01/03/2024 06:29:17], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-03 06:29:17' WHERE id= '247';
[01/03/2024 06:29:17], [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/05',  departure_date='2024/01/05',  nights='1',  create_date='2024-01-03 :06:29:17',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/03/2024 06:29:17], [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/03_01_2024/request_availability_Viator_test_06_29_17_1704263357.json', 'v1/03_01_2024/response_availability_Viator_test_06_29_17_1704263357.json', 'v1/03_01_2024/response_header_availability_Viator_test_06_29_17_1704263357.json', 'viator', '2024-01-03 06:29:17', '', '', '402');
[01/03/2024 06:29:44], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-01-03 06:29:44' WHERE id= '252';
[01/03/2024 06:30:26], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-03 06:30:26' WHERE id= '247';
[01/03/2024 06:30:26], [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/05',  departure_date='2024/01/05',  nights='1',  create_date='2024-01-03 :06:30:26',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/03/2024 06:31:09], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-03 06:31:09' WHERE id= '247';
[01/03/2024 06:31:09], [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/05',  departure_date='2024/01/05',  nights='1',  create_date='2024-01-03 :06:31:09',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/03/2024 06:31:38], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-01-03 06:31:38' WHERE id= '252';
[01/03/2024 06:31:41], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2024-01-03 06:31:41' WHERE id= '247';
[01/03/2024 06:31:41], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-03 06:31:41',login_attempt=0 where id = '7851';
[01/03/2024 06:31:41], [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-03 06:31:41', ip = '43.239.53.130', action = 'Login' ;
[01/03/2024 06:31:41], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-03 06:31:41' WHERE id= '247';
[01/03/2024 06:31:44], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-03 06:31:44' WHERE id= '247';
[01/03/2024 06:31:48], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-03 06:31:48' WHERE id= '247';
[01/03/2024 06:31:53], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-03 06:31:53' WHERE id= '247';
[01/03/2024 06:31:53], [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/05',  departure_date='2024/01/05',  nights='1',  create_date='2024-01-03 :06:31:53',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/03/2024 06:32:48], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-01-03 06:32:48' WHERE id= '252';
[01/03/2024 06:33:55], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-03 06:33:55' WHERE id= '254';
[01/03/2024 06:33:55], [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-03 :06:33:55',  nationality='',  additional_markup='',  selected_currency='INR',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/03/2024 06:33:59], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-03 06:33:59' WHERE id= '254';
[01/03/2024 06:33:59], [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-03 :06:33:59',  nationality='',  additional_markup='',  selected_currency='INR',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/03/2024 06:34:19], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-01-03 06:34:19' WHERE id= '252';
[01/03/2024 06:35:11], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-03 06:35:11' WHERE id= '247';
[01/03/2024 06:35:11], [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/05',  departure_date='2024/01/05',  nights='1',  create_date='2024-01-03 :06:35:11',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/03/2024 06:35:11], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-03 06:35:11' WHERE id= '254';
[01/03/2024 06:35:11], [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-03 :06:35:11',  nationality='',  additional_markup='',  selected_currency='INR',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/03/2024 06:35:44], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-03 06:35:44' WHERE id= '247';
[01/03/2024 06:35:44], [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/05',  departure_date='2024/01/05',  nights='1',  create_date='2024-01-03 :06:35:44',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/03/2024 06:35:47], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-01-03 06:35:47' WHERE id= '252';
[01/03/2024 06:35:59], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-03 06:35:59' WHERE id= '254';
[01/03/2024 06:35:59], [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-03 :06:35:59',  nationality='',  additional_markup='',  selected_currency='INR',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/03/2024 06:36:17], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-03 06:36:17' WHERE id= '247';
[01/03/2024 06:36:17], [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/05',  departure_date='2024/01/05',  nights='1',  create_date='2024-01-03 :06:36:17',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/03/2024 06:37:12], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-03 06:37:12' WHERE id= '254';
[01/03/2024 06:37:12], [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-03 :06:37:12',  nationality='',  additional_markup='',  selected_currency='INR',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/03/2024 06:37:35], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-01-03 06:37:35' WHERE id= '252';
[01/03/2024 06:37:42], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-03 06:37:42' WHERE id= '254';
[01/03/2024 06:37:42], [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-03 :06:37:42',  nationality='',  additional_markup='',  selected_currency='INR',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/03/2024 06:37:48], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-03 06:37:48' WHERE id= '254';
[01/03/2024 06:37:48], [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-03 :06:37:48',  nationality='',  additional_markup='',  selected_currency='INR',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/03/2024 06:37:51], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-03 06:37:51' WHERE id= '254';
[01/03/2024 06:37:51], [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-03 :06:37:51',  nationality='',  additional_markup='',  selected_currency='INR',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/03/2024 06:38:41], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-03 06:38:41' WHERE id= '254';
[01/03/2024 06:38:41], [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-03 :06:38:41',  nationality='',  additional_markup='',  selected_currency='INR',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/03/2024 06:38:57], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-01-03 06:38:57' WHERE id= '252';
[01/03/2024 06:39:06], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-03 06:39:06' WHERE id= '254';
[01/03/2024 06:39:06], [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-03 :06:39:06',  nationality='',  additional_markup='',  selected_currency='INR',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/03/2024 06:39:10], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-01-03 06:39:10' WHERE id= '252';
[01/03/2024 06:41:12], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-01-03 06:41:12' WHERE id= '252';
[01/03/2024 06:41:43], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-01-03 06:41:43' WHERE id= '252';
[01/03/2024 06:42:03], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-01-03 06:42:03' WHERE id= '252';
[01/03/2024 06:43:13], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-01-03 06:43:13' WHERE id= '252';
[01/03/2024 06:43:41], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-01-03 06:43:41' WHERE id= '252';
[01/03/2024 06:44:52], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-03 06:44:52' WHERE id= '247';
[01/03/2024 06:45:01], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2024-01-03 06:45:01' WHERE id= '247';
[01/03/2024 06:45:01], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-03 06:45:01',login_attempt=0 where id = '7851';
[01/03/2024 06:45:01], [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-03 06:45:01', ip = '43.239.53.130', action = 'Login' ;
[01/03/2024 06:45:01], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-03 06:45:01' WHERE id= '247';
[01/03/2024 06:45:04], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-03 06:45:04' WHERE id= '247';
[01/03/2024 06:45:08], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-03 06:45:08' WHERE id= '247';
[01/03/2024 06:45:12], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-03 06:45:12' WHERE id= '247';
[01/03/2024 06:45:12], [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/05',  departure_date='2024/01/05',  nights='1',  create_date='2024-01-03 :06:45:12',  nationality='',  additional_markup='',  selected_currency='SAR',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/03/2024 06:46:16], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-01-03 06:46:16' WHERE id= '252';
[01/03/2024 06:47:20], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-01-03 06:47:20' WHERE id= '252';
[01/03/2024 06:48:48], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-01-03 06:48:48' WHERE id= '252';
[01/03/2024 06:49:11], [file name :-/home/otrams/public_html/beta/test_definer.php],UPDATE user_sessions_ip SET update_date = '2024-01-03 06:49:11' WHERE id= '252';
[01/03/2024 06:52:18], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-03 06:52:18' WHERE id= '247';
[01/03/2024 06:52: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/01/05',  departure_date='2024/01/05',  nights='1',  create_date='2024-01-03 :06:52:18',  nationality='',  additional_markup='',  selected_currency='SAR',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/03/2024 06:54:10], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-01-03 06:54:10' WHERE id= '252';
[01/03/2024 06:54:32], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-03 06:54:32' WHERE id= '247';
[01/03/2024 06:54:32], [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/05',  departure_date='2024/01/05',  nights='1',  create_date='2024-01-03 :06:54:32',  nationality='',  additional_markup='',  selected_currency='SAR',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/03/2024 06:54:32], [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/03_01_2024/request_availability_Viator_test_06_54_32_1704264872.json', 'v1/03_01_2024/response_availability_Viator_test_06_54_32_1704264872.json', 'v1/03_01_2024/response_header_availability_Viator_test_06_54_32_1704264872.json', 'viator', '2024-01-03 06:54:32', '', '', '421');
[01/03/2024 06:54:56], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-01-03 06:54:56' WHERE id= '252';
[01/03/2024 06:55:10], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-03 06:55:10' WHERE id= '247';
[01/03/2024 06:55:10], [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/05',  departure_date='2024/01/05',  nights='1',  create_date='2024-01-03 :06:55:10',  nationality='',  additional_markup='',  selected_currency='SAR',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/03/2024 06:55: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/03_01_2024/request_availability_Viator_test_06_55_10_1704264910.json', 'v1/03_01_2024/response_availability_Viator_test_06_55_10_1704264910.json', 'v1/03_01_2024/response_header_availability_Viator_test_06_55_10_1704264910.json', 'viator', '2024-01-03 06:55:10', '', '', '422');
[01/03/2024 06:59:08], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-03 06:59:08' WHERE id= '254';
[01/03/2024 06:59:08], [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-03 :06:59:08',  nationality='',  additional_markup='',  selected_currency='INR',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/03/2024 06:59: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/03_01_2024/request_availability_Viator_test_06_59_08_1704265148.json', 'v1/03_01_2024/response_availability_Viator_test_06_59_08_1704265148.json', 'v1/03_01_2024/response_header_availability_Viator_test_06_59_08_1704265148.json', 'viator', '2024-01-03 06:59:13', '', '', '423');
