[02/14/2024 10:00:01], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:00:01' WHERE id= '553';
[02/14/2024 10:00:06], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_test_10_00_01_1707904801.json', 'v1/14_02_2024/response_sight_details_Viator_test_10_00_01_1707904801.json', 'v1/14_02_2024/response_header_sight_details_Viator_test_10_00_01_1707904801.json', 'viator', '2024-02-14 10:00:06', '', '', '1462');
[02/14/2024 10:00:06], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_test_10_00_06_1707904806.json', 'v1/14_02_2024/response_sight_details_Viator_test_10_00_06_1707904806.json', 'v1/14_02_2024/response_header_sight_details_Viator_test_10_00_06_1707904806.json', 'viator', '2024-02-14 10:00:06', '', '', '1462');
[02/14/2024 10:04:31], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:04:31' WHERE id= '554';
[02/14/2024 10:04:31], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-02-14 10:04:31',login_attempt=0 where id = '7869';
[02/14/2024 10:04:31], [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 10:04:31', ip = '43.239.53.130', action = 'Login' ;
[02/14/2024 10:04:31], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:04:31' WHERE id= '554';
[02/14/2024 10:04:36], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:04:36' WHERE id= '554';
[02/14/2024 10:04:40], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:04:40' WHERE id= '554';
[02/14/2024 10:04:44], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:04:44' WHERE id= '554';
[02/14/2024 10:04:44], [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/03/01',  departure_date='2024/03/01',  nights='1',  create_date='2024-02-14 :10:04:44',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[02/14/2024 10:04:45], [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_10_04_44_1707905084.json', 'v1/14_02_2024/response_availability_Viator_10_04_44_1707905084.json', 'v1/14_02_2024/response_header_availability_Viator_10_04_44_1707905084.json', 'viator', '2024-02-14 10:04:45', '', '', '1463');
[02/14/2024 10:04:46], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:04:46' WHERE id= '554';
[02/14/2024 10:04:46], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:04:46' WHERE id= '554';
[02/14/2024 10:04:49], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:04:49' WHERE id= '554';
[02/14/2024 10:04:49], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_04_49_1707905089.json', 'v1/14_02_2024/response_sight_details_Viator_10_04_49_1707905089.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_04_49_1707905089.json', 'viator', '2024-02-14 10:04:49', '', '', '1463');
[02/14/2024 10:04:49], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_04_49_1707905089.json', 'v1/14_02_2024/response_sight_details_Viator_10_04_49_1707905089.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_04_49_1707905089.json', 'viator', '2024-02-14 10:04:49', '', '', '1463');
[02/14/2024 10:05:46], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:05:46' WHERE id= '554';
[02/14/2024 10:05:46], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'check_availability', 'v1/14_02_2024/request_check_availability_Viator_10_05_46_1707905146.json', 'v1/14_02_2024/response_check_availability_Viator_10_05_46_1707905146.json', 'v1/14_02_2024/response_header_check_availability_Viator_10_05_46_1707905146.json', 'viator', '2024-02-14 10:05:46', '', '', '1463');
[02/14/2024 10:06:49], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:06:49' WHERE id= '554';
[02/14/2024 10:06:49], [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/03/01',  departure_date='2024/03/01',  nights='1',  create_date='2024-02-14 :10:06:49',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[02/14/2024 10:06:49], [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_10_06_49_1707905209.json', 'v1/14_02_2024/response_availability_Viator_10_06_49_1707905209.json', 'v1/14_02_2024/response_header_availability_Viator_10_06_49_1707905209.json', 'viator', '2024-02-14 10:06:49', '', '', '1464');
[02/14/2024 10:06:49], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:06:49' WHERE id= '554';
[02/14/2024 10:06:50], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_06_49_1707905209.json', 'v1/14_02_2024/response_sight_details_Viator_10_06_49_1707905209.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_06_49_1707905209.json', 'viator', '2024-02-14 10:06:50', '', '', '1464');
[02/14/2024 10:06:50], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_06_50_1707905210.json', 'v1/14_02_2024/response_sight_details_Viator_10_06_50_1707905210.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_06_50_1707905210.json', 'viator', '2024-02-14 10:06:50', '', '', '1464');
[02/14/2024 10:06:50], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:06:50' WHERE id= '554';
[02/14/2024 10:06:56], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:06:56' WHERE id= '554';
[02/14/2024 10:06:56], [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/03/01',  departure_date='2024/03/01',  nights='1',  create_date='2024-02-14 :10:06:56',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[02/14/2024 10:06:56], [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_10_06_56_1707905216.json', 'v1/14_02_2024/response_availability_Viator_10_06_56_1707905216.json', 'v1/14_02_2024/response_header_availability_Viator_10_06_56_1707905216.json', 'viator', '2024-02-14 10:06:56', '', '', '1465');
[02/14/2024 10:06:57], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:06:57' WHERE id= '554';
[02/14/2024 10:07:02], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:07:02' WHERE id= '554';
[02/14/2024 10:07:03], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:07:03' WHERE id= '554';
[02/14/2024 10:07:05], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:07:05' WHERE id= '554';
[02/14/2024 10:07:11], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:07:11' WHERE id= '554';
[02/14/2024 10:07:11], [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 = 'phuket' , arrival_date='2024/02/27',  departure_date='2024/02/27',  nights='1',  create_date='2024-02-14 :10:07:11',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[02/14/2024 10:07:12], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'v1/14_02_2024/request_availability_Viator_10_07_11_1707905231.json', 'v1/14_02_2024/response_availability_Viator_10_07_11_1707905231.json', 'v1/14_02_2024/response_header_availability_Viator_10_07_11_1707905231.json', 'viator', '2024-02-14 10:07:12', '', '', '1466');
[02/14/2024 10:07:12], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:07:12' WHERE id= '554';
[02/14/2024 10:07:27], [file name :-/home/otrams/public_html/beta/tms/agent.php],DELETE FROM agent_supplier_settings WHERE 1  and agent_id= ? ;
[02/14/2024 10:07:27], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7869',supplier_id = '67' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[02/14/2024 10:07:27], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7869',supplier_id = '52' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[02/14/2024 10:07:27], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7869',supplier_id = '76' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[02/14/2024 10:07:27], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7869',supplier_id = '24' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[02/14/2024 10:07:27], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7869',supplier_id = '77' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[02/14/2024 10:07:27], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7869',supplier_id = '64' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[02/14/2024 10:07:27], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7869',supplier_id = '65' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[02/14/2024 10:07:27], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7869',supplier_id = '34' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[02/14/2024 10:07:27], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7869',supplier_id = '20' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[02/14/2024 10:07:27], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7869',supplier_id = '55' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[02/14/2024 10:07:27], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7869',supplier_id = '62' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[02/14/2024 10:07:27], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7869',supplier_id = '53' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[02/14/2024 10:07:27], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7869',supplier_id = '16' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[02/14/2024 10:07:27], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7869',supplier_id = '75' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[02/14/2024 10:07:27], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7869',supplier_id = '60' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[02/14/2024 10:07:27], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7869',supplier_id = '18' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[02/14/2024 10:07:27], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7869',supplier_id = '19' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[02/14/2024 10:07:27], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7869',supplier_id = '73' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[02/14/2024 10:07:27], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7869',supplier_id = '71' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[02/14/2024 10:07:27], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7869',supplier_id = '69' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[02/14/2024 10:07:27], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7869',supplier_id = '68' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[02/14/2024 10:07:27], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7869',supplier_id = '74' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[02/14/2024 10:07:27], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7869',supplier_id = '35' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[02/14/2024 10:07:27], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7869',supplier_id = '70' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[02/14/2024 10:07:27], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7869',supplier_id = '59' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[02/14/2024 10:07:27], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7869',supplier_id = '32' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[02/14/2024 10:07:27], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7869',supplier_id = '58' ,status = '1' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[02/14/2024 10:07:27], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7869',supplier_id = '56' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[02/14/2024 10:07:27], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7869',supplier_id = '57' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[02/14/2024 10:07:27], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7869',supplier_id = '61' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[02/14/2024 10:07:27], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7869',supplier_id = '63' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[02/14/2024 10:07:27], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7869',supplier_id = '54' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[02/14/2024 10:07:27], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7869',supplier_id = '66' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[02/14/2024 10:07:27], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7869',supplier_id = '45' ,status = '' ,priority = '' ,lead_time = '',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[02/14/2024 10:07:27], [file name :-/home/otrams/public_html/beta/tms/agent.php],insert into `user_logs` set `username`= 'v3alpha',`create_date`= '2024-02-14 10:07:27',`log_type`= 'Agent Supplier settings',`sql_query`= '======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7869\&#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;7869\&#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;7869\&#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;7869\&#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;7869\&#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;7869\&#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;7869\&#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;7869\&#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;7869\&#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;7869\&#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;7869\&#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;7869\&#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;7869\&#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;7869\&#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;7869\&#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;7869\&#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;7869\&#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;7869\&#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;7869\&#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;7869\&#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;7869\&#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;7869\&#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;7869\&#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;7869\&#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;7869\&#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;7869\&#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;7869\&#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;7869\&#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;7869\&#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;7869\&#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;7869\&#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;7869\&#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;7869\&#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;7869\&#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-7869 ## supplier_id- 58 ## company_name - Viator (SightSeeing) ## supplier_code-viator  ## percentage - 0.00 ## lead_time - 0 ',`ip`= '43.239.53.130';
[02/14/2024 10:07:30], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:07:30' WHERE id= '554';
[02/14/2024 10:07:33], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:07:33' WHERE id= '554';
[02/14/2024 10:07:33], [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/27',  departure_date='2024/02/27',  nights='1',  create_date='2024-02-14 :10:07:33',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[02/14/2024 10:07:54], [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_10_07_33_1707905253.json', 'v1/14_02_2024/response_availability_Viator_10_07_33_1707905253.json', 'v1/14_02_2024/response_header_availability_Viator_10_07_33_1707905253.json', 'viator', '2024-02-14 10:07:54', '', '', '1467');
[02/14/2024 10:07:58], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:07:58' WHERE id= '554';
[02/14/2024 10:07:58], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-02-14 10:07:58',login_attempt=0 where id = '7869';
[02/14/2024 10:07:58], [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 10:07:58', ip = '43.239.53.130', action = 'Login' ;
[02/14/2024 10:07:58], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:07:58' WHERE id= '554';
[02/14/2024 10:08:01], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:08:01' WHERE id= '554';
[02/14/2024 10:08:06], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:08:06' WHERE id= '554';
[02/14/2024 10:08:09], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:08:09' WHERE id= '554';
[02/14/2024 10:08: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/27',  departure_date='2024/02/27',  nights='1',  create_date='2024-02-14 :10:08:09',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[02/14/2024 10:08: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/14_02_2024/request_availability_Viator_10_08_09_1707905289.json', 'v1/14_02_2024/response_availability_Viator_10_08_09_1707905289.json', 'v1/14_02_2024/response_header_availability_Viator_10_08_09_1707905289.json', 'viator', '2024-02-14 10:08:10', '', '', '1468');
[02/14/2024 10:08:10], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:08:10' WHERE id= '554';
[02/14/2024 10:09:09], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:09:09' WHERE id= '554';
[02/14/2024 10:09:09], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:09:09' WHERE id= '554';
[02/14/2024 10:09:13], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:09:13' WHERE id= '554';
[02/14/2024 10:09:16], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:09:16' WHERE id= '554';
[02/14/2024 10:09:16], [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/27',  departure_date='2024/02/27',  nights='1',  create_date='2024-02-14 :10:09:16',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[02/14/2024 10:09: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/14_02_2024/request_availability_Viator_10_09_16_1707905356.json', 'v1/14_02_2024/response_availability_Viator_10_09_16_1707905356.json', 'v1/14_02_2024/response_header_availability_Viator_10_09_16_1707905356.json', 'viator', '2024-02-14 10:09:17', '', '', '1469');
[02/14/2024 10:09:19], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:09:19' WHERE id= '554';
[02/14/2024 10:09:19], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:09:19' WHERE id= '554';
[02/14/2024 10:09:23], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:09:23' WHERE id= '554';
[02/14/2024 10:09:23], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_09_23_1707905363.json', 'v1/14_02_2024/response_sight_details_Viator_10_09_23_1707905363.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_09_23_1707905363.json', 'viator', '2024-02-14 10:09:23', '', '', '1469');
[02/14/2024 10:09:23], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_09_23_1707905363.json', 'v1/14_02_2024/response_sight_details_Viator_10_09_23_1707905363.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_09_23_1707905363.json', 'viator', '2024-02-14 10:09:23', '', '', '1469');
[02/14/2024 10:09:34], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:09:34' WHERE id= '554';
[02/14/2024 10:09:35], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'check_availability', 'v1/14_02_2024/request_check_availability_Viator_10_09_34_1707905374.json', 'v1/14_02_2024/response_check_availability_Viator_10_09_34_1707905374.json', 'v1/14_02_2024/response_header_check_availability_Viator_10_09_34_1707905374.json', 'viator', '2024-02-14 10:09:35', '', '', '1469');
[02/14/2024 10:09:56], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:09:56' WHERE id= '554';
[02/14/2024 10:09:56], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1707905396','43.239.53.130');
[02/14/2024 10:12:54], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:12:54' WHERE id= '554';
[02/14/2024 10:12:54], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1707905574','43.239.53.130');
[02/14/2024 10:12:56], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:12:56' WHERE id= '554';
[02/14/2024 10:12:56], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO bookings set reservation_id='2695',agent_id='7869',leader_title='Mr',leader_first_name='shiv',leader_last_name='baba',city_id='dubai',country_id='138',nationality='Emirati',display_room_rate='214.7',display_currency_code='USD',native_room_rate='214.7',consultant_id='SUJAY_QTECH',native_currency_code='USD',cancellation_policy='Cancellation Charges will be applicable if cancelled after 25 Feb 2024 03:00 hrs.<BR>Late amendment charge may apply.<Br><Br><B><U>Detailed Cancellation Policy:</U></B><Br>Charges - 214.7  applicable if cancelled after 25 Feb 2024 at 03:00 hrs',current_status='inprocess-booking',booking_status='1',sales_manager_id='0',create_date='2024-02-14 10:12:56',source_type='viator',expiration_date= '2024-02-25 00:00:00',applied_multiplier='1.00000',applied_markup='0',agent_markup='0',basecurrency_multiplier='1.00000',basecurrency_multiplier_native='1.00000',admin_booked='0',service_date='2024-02-27',sub_user_id='',check_out_date='2024-02-27',supplier_profile_id='',agent_currency_multiplier='1.00000', booking_branch_id = '1',site_url = 'https://beta.astrabookings.com/',ip_addr='43.239.53.130',leader_phone=' 1234567876',email_id='deepak.trivedi@qtechosftware.com',service_type='sightseeing';
[02/14/2024 10:12:56], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO sight_bookings set booking_id='409',native_nightly_rates='a:2:{s:4:\"size\";i:1;s:17:\"nativeNightlyRate\";d:214.69999999999999;}',rate_description='',display_nightly_rates='a:3:{s:4:\"size\";i:1;s:18:\"displayNightlyRate\";d:214.69999999999999;s:23:\"displayNightlyRateStore\";s:134:\"Rate - 214.7 USD, Currency Multiplier (USD-USD) - 1.00000, Markup  in % - %, Markup Amount - , Markup Amount in  -  ,Other Markup - 0%\";}',display_currency_code='USD',native_currency_code='USD',sight_id='333273P5',sight_name='PREMIUM RED DUNES BASHING WITH QUAD BIKE, CAMEL, FALCON &VIP CAMP',tour_time='',tour_details='',tour_inclusive='S<br/>',tour_exclusive='A<br/>',meeting_point='',tour_dep_point=' ',tour_language='en/SERVICE_GUIDE',tour_supplier_phone='',additional_tour_dep_point='',tour_duration='7 hours 30 minutes<br> Start Time: 14:00',arrival_date='2024-02-27',total_adults='2',total_children='2',total_infants='',gta_city_code='828',supplier_id='',pick_up_point='',drop_off_point='',from_slot='',to_slot='',total_adult_rate='',total_child_rate='',adult_rate='',child_rate='',display_total_adult_rate='',display_total_child_rate='',display_adult_rate='',display_child_rate='',additional_service_rate='0',booking_remark='',emergency_cont_no='',terms_n_condition='';
[02/14/2024 10:12:56], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO posted_bookings(id,source_type,reservation_id,create_date,status) values ('','viator','2695','2024-02-14 10:12:56',0);
[02/14/2024 10:12:57], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'reservation_sight', 'v1/14_02_2024/request_reservation_sight_Viator_10_12_56_1707905576.json', 'v1/14_02_2024/response_reservation_sight_Viator_10_12_56_1707905576.json', 'v1/14_02_2024/response_header_reservation_sight_Viator_10_12_56_1707905576.json', 'viator', '2024-02-14 10:12:57', '', '', '1469');
[02/14/2024 10:12:57], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE posted_bookings set status=1 where id= '226';
[02/14/2024 10:12:57], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],update bookings set  parent_agent_id='7869', applicable_service_tax='0', sub_agent_rate='0', agent_rate='214.7', supplier_rate='214.7', uid='', itenirary_id='', confirmation_number='', comment_contract='', current_status='failed', original_source='' where id='409';
[02/14/2024 10:12:57], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],update sight_bookings set gtaToken='',gta_item_confirm_ref='',tour_supplier='',textaddition_activities='N;' where booking_id='409';
[02/14/2024 10:12:57], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
		('','','409','failed','2024-02-14 10:12:57','Sightseeing Booking failed by Agent..7869','7869','43.239.53.130','','','');
[02/14/2024 10:12:57], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],insert into sight_passangers(booking_id,salutations,tour,first_name,last_name,passenger_type,age)values('409','Mr','1','shiv','baba','adult','0');
[02/14/2024 10:12:57], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],insert into sight_passangers(booking_id,salutations,tour,first_name,last_name,passenger_type,age)values('409','Mr','1','gaju','baba','adult','0');
[02/14/2024 10:12:57], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],insert into sight_passangers(booking_id,salutations,tour,first_name,last_name,passenger_type,age)values('409','Master','1','pranlai','','child','7');
[02/14/2024 10:12:57], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],insert into sight_passangers(booking_id,salutations,tour,first_name,last_name,passenger_type,age)values('409','Master','1','sujay','','child','7');
[02/14/2024 10:12:57], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],update xmllogs set reservation_id='409' where agent_logs_id='1469' and source_type='viator';
[02/14/2024 10:13:08], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:13:08' WHERE id= '554';
[02/14/2024 10:13:08], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-02-14 10:13:08',login_attempt=0 where id = '7869';
[02/14/2024 10:13:08], [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 10:13:08', ip = '43.239.53.130', action = 'Login' ;
[02/14/2024 10:13:09], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:13:09' WHERE id= '554';
[02/14/2024 10:13:14], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:13:14' WHERE id= '554';
[02/14/2024 10:13:18], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:13:18' WHERE id= '554';
[02/14/2024 10:13:23], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:13:23' WHERE id= '554';
[02/14/2024 10:13: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 :10:13:23',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[02/14/2024 10:13:24], [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_10_13_23_1707905603.json', 'v1/14_02_2024/response_availability_Viator_10_13_23_1707905603.json', 'v1/14_02_2024/response_header_availability_Viator_10_13_23_1707905603.json', 'viator', '2024-02-14 10:13:24', '', '', '1470');
[02/14/2024 10:13:26], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:13:26' WHERE id= '554';
[02/14/2024 10:13:26], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:13:26' WHERE id= '554';
[02/14/2024 10:13:28], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:13:28' WHERE id= '554';
[02/14/2024 10:13:28], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_13_28_1707905608.json', 'v1/14_02_2024/response_sight_details_Viator_10_13_28_1707905608.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_13_28_1707905608.json', 'viator', '2024-02-14 10:13:28', '', '', '1470');
[02/14/2024 10:13:28], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_13_28_1707905608.json', 'v1/14_02_2024/response_sight_details_Viator_10_13_28_1707905608.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_13_28_1707905608.json', 'viator', '2024-02-14 10:13:28', '', '', '1470');
[02/14/2024 10:13:30], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:13:30' WHERE id= '554';
[02/14/2024 10:14:44], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:14:44' WHERE id= '554';
[02/14/2024 10:14:46], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:14:46' WHERE id= '554';
[02/14/2024 10:14:46], [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 = 'phuket' , arrival_date='2024/02/22',  departure_date='2024/02/22',  nights='1',  create_date='2024-02-14 :10:14:46',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[02/14/2024 10:14:47], [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_10_14_46_1707905686.json', 'v1/14_02_2024/response_availability_Viator_10_14_46_1707905686.json', 'v1/14_02_2024/response_header_availability_Viator_10_14_46_1707905686.json', 'viator', '2024-02-14 10:14:47', '', '', '1471');
[02/14/2024 10:14:49], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:14:49' WHERE id= '554';
[02/14/2024 10:14:49], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:14:49' WHERE id= '554';
[02/14/2024 10:15:00], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:15:00' WHERE id= '554';
[02/14/2024 10:15:00], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:15:00' WHERE id= '554';
[02/14/2024 10:15:10], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:15:10' WHERE id= '554';
[02/14/2024 10:15:10], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_15_10_1707905710.json', 'v1/14_02_2024/response_sight_details_Viator_10_15_10_1707905710.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_15_10_1707905710.json', 'viator', '2024-02-14 10:15:10', '', '', '1471');
[02/14/2024 10:15:11], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_15_10_1707905710.json', 'v1/14_02_2024/response_sight_details_Viator_10_15_10_1707905710.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_15_10_1707905710.json', 'viator', '2024-02-14 10:15:11', '', '', '1471');
[02/14/2024 10:15:23], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:15:23' WHERE id= '554';
[02/14/2024 10:15:24], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'check_availability', 'v1/14_02_2024/request_check_availability_Viator_10_15_23_1707905723.json', 'v1/14_02_2024/response_check_availability_Viator_10_15_23_1707905723.json', 'v1/14_02_2024/response_header_check_availability_Viator_10_15_23_1707905723.json', 'viator', '2024-02-14 10:15:24', '', '', '1471');
[02/14/2024 10:15:29], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:15:29' WHERE id= '554';
[02/14/2024 10:15:30], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:15:30' WHERE id= '554';
[02/14/2024 10:15:33], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:15:33' WHERE id= '554';
[02/14/2024 10:15:34], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_15_33_1707905733.json', 'v1/14_02_2024/response_sight_details_Viator_10_15_33_1707905733.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_15_33_1707905733.json', 'viator', '2024-02-14 10:15:34', '', '', '1471');
[02/14/2024 10:15:35], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_15_34_1707905734.json', 'v1/14_02_2024/response_sight_details_Viator_10_15_34_1707905734.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_15_34_1707905734.json', 'viator', '2024-02-14 10:15:35', '', '', '1471');
[02/14/2024 10:15:38], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:15:38' WHERE id= '554';
[02/14/2024 10:15:39], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'check_availability', 'v1/14_02_2024/request_check_availability_Viator_10_15_38_1707905738.json', 'v1/14_02_2024/response_check_availability_Viator_10_15_38_1707905738.json', 'v1/14_02_2024/response_header_check_availability_Viator_10_15_38_1707905738.json', 'viator', '2024-02-14 10:15:39', '', '', '1471');
[02/14/2024 10:15:49], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:15:49' WHERE id= '554';
[02/14/2024 10:15:49], [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 = 'phuket' , arrival_date='2024/03/20',  departure_date='2024/03/20',  nights='1',  create_date='2024-02-14 :10:15:49',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[02/14/2024 10:16:16], [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_10_15_49_1707905749.json', 'v1/14_02_2024/response_availability_Viator_10_15_49_1707905749.json', 'v1/14_02_2024/response_header_availability_Viator_10_15_49_1707905749.json', 'viator', '2024-02-14 10:16:16', '', '', '1472');
[02/14/2024 10:16:18], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:16:18' WHERE id= '554';
[02/14/2024 10:16:18], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:16:18' WHERE id= '554';
[02/14/2024 10:16:26], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:16:26' WHERE id= '554';
[02/14/2024 10:16:27], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_16_26_1707905786.json', 'v1/14_02_2024/response_sight_details_Viator_10_16_26_1707905786.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_16_26_1707905786.json', 'viator', '2024-02-14 10:16:27', '', '', '1472');
[02/14/2024 10:16:28], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_16_27_1707905787.json', 'v1/14_02_2024/response_sight_details_Viator_10_16_27_1707905787.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_16_27_1707905787.json', 'viator', '2024-02-14 10:16:28', '', '', '1472');
[02/14/2024 10:16:33], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:16:33' WHERE id= '554';
[02/14/2024 10:16:33], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'check_availability', 'v1/14_02_2024/request_check_availability_Viator_10_16_33_1707905793.json', 'v1/14_02_2024/response_check_availability_Viator_10_16_33_1707905793.json', 'v1/14_02_2024/response_header_check_availability_Viator_10_16_33_1707905793.json', 'viator', '2024-02-14 10:16:33', '', '', '1472');
[02/14/2024 10:17:32], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:17:32' WHERE id= '554';
[02/14/2024 10:17:32], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1707905852','43.239.53.130');
[02/14/2024 10:17:58], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:17:58' WHERE id= '554';
[02/14/2024 10:18:00], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:18:00' WHERE id= '554';
[02/14/2024 10:18:00], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:18:00' WHERE id= '554';
[02/14/2024 10:18:14], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:18:14' WHERE id= '554';
[02/14/2024 10:18:14], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_18_14_1707905894.json', 'v1/14_02_2024/response_sight_details_Viator_10_18_14_1707905894.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_18_14_1707905894.json', 'viator', '2024-02-14 10:18:14', '', '', '1472');
[02/14/2024 10:18:14], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_18_14_1707905894.json', 'v1/14_02_2024/response_sight_details_Viator_10_18_14_1707905894.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_18_14_1707905894.json', 'viator', '2024-02-14 10:18:14', '', '', '1472');
[02/14/2024 10:18:17], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:18:17' WHERE id= '554';
[02/14/2024 10:18:18], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'check_availability', 'v1/14_02_2024/request_check_availability_Viator_10_18_17_1707905897.json', 'v1/14_02_2024/response_check_availability_Viator_10_18_17_1707905897.json', 'v1/14_02_2024/response_header_check_availability_Viator_10_18_17_1707905897.json', 'viator', '2024-02-14 10:18:18', '', '', '1472');
[02/14/2024 10:18:23], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:18:23' WHERE id= '554';
[02/14/2024 10:18:23], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1707905903','43.239.53.130');
[02/14/2024 10:18:53], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:18:53' WHERE id= '553';
[02/14/2024 10:18:54], [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/03/29',  departure_date='2024/03/29',  nights='1',  create_date='2024-02-14 :10:18:54',  nationality='',  additional_markup='',  selected_currency='SAR',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[02/14/2024 10:18:54], [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_test_10_18_54_1707905934.json', 'v1/14_02_2024/response_availability_Viator_test_10_18_54_1707905934.json', 'v1/14_02_2024/response_header_availability_Viator_test_10_18_54_1707905934.json', 'viator', '2024-02-14 10:18:54', '', '', '1473');
[02/14/2024 10:18:54], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:18:54' WHERE id= '553';
[02/14/2024 10:18:58], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:18:58' WHERE id= '553';
[02/14/2024 10:18:58], [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/03/29',  departure_date='2024/03/29',  nights='1',  create_date='2024-02-14 :10:18:58',  nationality='',  additional_markup='',  selected_currency='SAR',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[02/14/2024 10:19:00], [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_test_10_18_58_1707905938.json', 'v1/14_02_2024/response_availability_Viator_test_10_18_58_1707905938.json', 'v1/14_02_2024/response_header_availability_Viator_test_10_18_58_1707905938.json', 'viator', '2024-02-14 10:19:00', '', '', '1474');
[02/14/2024 10:19:01], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:19:01' WHERE id= '553';
[02/14/2024 10:19:02], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:19:02' WHERE id= '553';
[02/14/2024 10:19:06], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:19:06' WHERE id= '553';
[02/14/2024 10:19:06], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_test_10_19_06_1707905946.json', 'v1/14_02_2024/response_sight_details_Viator_test_10_19_06_1707905946.json', 'v1/14_02_2024/response_header_sight_details_Viator_test_10_19_06_1707905946.json', 'viator', '2024-02-14 10:19:06', '', '', '1474');
[02/14/2024 10:19:07], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_test_10_19_07_1707905947.json', 'v1/14_02_2024/response_sight_details_Viator_test_10_19_07_1707905947.json', 'v1/14_02_2024/response_header_sight_details_Viator_test_10_19_07_1707905947.json', 'viator', '2024-02-14 10:19:07', '', '', '1474');
[02/14/2024 10:20:19], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:20:19' WHERE id= '554';
[02/14/2024 10:20:20], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:20:20' WHERE id= '554';
[02/14/2024 10:20:20], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1707906020','43.239.53.130');
[02/14/2024 10:20:21], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:20:21' WHERE id= '554';
[02/14/2024 10:20:21], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO bookings set reservation_id='2698',agent_id='7869',leader_title='Mr',leader_first_name='gaju',leader_last_name='baba',city_id='phuket',country_id='136',nationality='Thai',display_room_rate='63.9',display_currency_code='USD',native_room_rate='63.9',consultant_id='SUJAY_QTECH',native_currency_code='USD',cancellation_policy='Cancellation Charges will be applicable if cancelled after 18 Mar 2024 03:00 hrs.<BR>Late amendment charge may apply.<Br><Br><B><U>Detailed Cancellation Policy:</U></B><Br>Charges - 63.9  applicable if cancelled after 18 Mar 2024 at 03:00 hrs',current_status='inprocess-booking',booking_status='1',sales_manager_id='0',create_date='2024-02-14 10:20:21',source_type='viator',expiration_date= '2024-03-18 00:00:00',applied_multiplier='1.00000',applied_markup='0',agent_markup='0',basecurrency_multiplier='1.00000',basecurrency_multiplier_native='1.00000',admin_booked='1',service_date='2024-03-20',sub_user_id='',check_out_date='2024-03-20',supplier_profile_id='',agent_currency_multiplier='1.00000', booking_branch_id = '1',site_url = 'https://beta.astrabookings.com/',ip_addr='43.239.53.130',leader_phone=' 12345654321',email_id='deepak.trivedi@qtechsoftware.com',service_type='sightseeing';
[02/14/2024 10:20:21], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO sight_bookings set booking_id='410',native_nightly_rates='a:2:{s:4:\"size\";i:1;s:17:\"nativeNightlyRate\";d:63.899999999999999;}',rate_description='',display_nightly_rates='a:3:{s:4:\"size\";i:1;s:18:\"displayNightlyRate\";d:63.899999999999999;s:23:\"displayNightlyRateStore\";s:133:\"Rate - 63.9 USD, Currency Multiplier (USD-USD) - 1.00000, Markup  in % - %, Markup Amount - , Markup Amount in  -  ,Other Markup - 0%\";}',display_currency_code='USD',native_currency_code='USD',sight_id='71459P1',sight_name='KHAO LAK TRANSFER - AIRPORT TO HOTELS TRANSFERS - TAXI SERVICES',tour_time='',tour_details='',tour_inclusive='<br/>',tour_exclusive='B<br/>',meeting_point='',tour_dep_point=' ',tour_language='',tour_supplier_phone='',additional_tour_dep_point='',tour_duration='1 hours 30 minutes<br> Start Time: ',arrival_date='2024-03-20',total_adults='',total_children='',total_infants='',gta_city_code='349',supplier_id='',pick_up_point='',drop_off_point='',from_slot='',to_slot='',total_adult_rate='',total_child_rate='',adult_rate='',child_rate='',display_total_adult_rate='',display_total_child_rate='',display_adult_rate='',display_child_rate='0',additional_service_rate='0',booking_remark='',emergency_cont_no='',terms_n_condition='';
[02/14/2024 10:20:21], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO posted_bookings(id,source_type,reservation_id,create_date,status) values ('','viator','2698','2024-02-14 10:20:21',0);
[02/14/2024 10:20:22], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'reservation_sight', 'v1/14_02_2024/request_reservation_sight_Viator_10_20_21_1707906021.json', 'v1/14_02_2024/response_reservation_sight_Viator_10_20_21_1707906021.json', 'v1/14_02_2024/response_header_reservation_sight_Viator_10_20_21_1707906021.json', 'viator', '2024-02-14 10:20:22', '', '', '1472');
[02/14/2024 10:20:22], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE posted_bookings set status=1 where id= '227';
[02/14/2024 10:20:22], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],update bookings set  parent_agent_id='7869', applicable_service_tax='0', sub_agent_rate='0', agent_rate='63.9', supplier_rate='63.9', uid='', itenirary_id='', confirmation_number='', comment_contract='', current_status='failed', original_source='' where id='410';
[02/14/2024 10:20:22], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],update sight_bookings set gtaToken='',gta_item_confirm_ref='',tour_supplier='',textaddition_activities='N;' where booking_id='410';
[02/14/2024 10:20:22], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
		('','','410','failed','2024-02-14 10:20:22','Sightseeing Booking failed by Agent..7869','7869','43.239.53.130','','1','');
[02/14/2024 10:20:22], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],insert into sight_passangers(booking_id,salutations,tour,first_name,last_name,passenger_type,age)values('410','Mr','1','gaju','baba','adult','0');
[02/14/2024 10:20:22], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],update xmllogs set reservation_id='410' where agent_logs_id='1472' and source_type='viator';
[02/14/2024 10:21:19], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:21:19' WHERE id= '554';
[02/14/2024 10:21:23], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:21:23' WHERE id= '554';
[02/14/2024 10:21:24], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:21:24' WHERE id= '554';
[02/14/2024 10:21:24], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:21:24' WHERE id= '554';
[02/14/2024 10:21:25], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:21:25' WHERE id= '554';
[02/14/2024 10:21:28], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:21:28' WHERE id= '554';
[02/14/2024 10:21:28], [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 = 'las vegas(nv)' , arrival_date='2024/03/20',  departure_date='2024/03/20',  nights='1',  create_date='2024-02-14 :10:21:28',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[02/14/2024 10:21: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/14_02_2024/request_availability_Viator_10_21_28_1707906088.json', 'v1/14_02_2024/response_availability_Viator_10_21_28_1707906088.json', 'v1/14_02_2024/response_header_availability_Viator_10_21_28_1707906088.json', 'viator', '2024-02-14 10:21:28', '', '', '1475');
[02/14/2024 10:21:29], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:21:29' WHERE id= '554';
[02/14/2024 10:21:37], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:21:37' WHERE id= '554';
[02/14/2024 10:21:37], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-02-14 10:21:37',login_attempt=0 where id = '7869';
[02/14/2024 10:21:37], [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 10:21:37', ip = '43.239.53.130', action = 'Login' ;
[02/14/2024 10:21:37], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:21:37' WHERE id= '554';
[02/14/2024 10:21:41], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:21:41' WHERE id= '554';
[02/14/2024 10:21:46], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:21:46' WHERE id= '554';
[02/14/2024 10:21:46], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:21:46' WHERE id= '554';
[02/14/2024 10:21:49], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:21:49' WHERE id= '554';
[02/14/2024 10:21:49], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:21:49' WHERE id= '554';
[02/14/2024 10:21:54], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:21:54' WHERE id= '554';
[02/14/2024 10:21:54], [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 = 'las vegas(nv)' , arrival_date='2024/02/29',  departure_date='2024/02/29',  nights='1',  create_date='2024-02-14 :10:21:54',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[02/14/2024 10:21:54], [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_10_21_54_1707906114.json', 'v1/14_02_2024/response_availability_Viator_10_21_54_1707906114.json', 'v1/14_02_2024/response_header_availability_Viator_10_21_54_1707906114.json', 'viator', '2024-02-14 10:21:54', '', '', '1476');
[02/14/2024 10:21:57], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:21:57' WHERE id= '554';
[02/14/2024 10:21:57], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:21:57' WHERE id= '554';
[02/14/2024 10:22:01], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:22:01' WHERE id= '554';
[02/14/2024 10:22:01], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_22_01_1707906121.json', 'v1/14_02_2024/response_sight_details_Viator_10_22_01_1707906121.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_22_01_1707906121.json', 'viator', '2024-02-14 10:22:01', '', '', '1476');
[02/14/2024 10:22:02], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_22_01_1707906121.json', 'v1/14_02_2024/response_sight_details_Viator_10_22_01_1707906121.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_22_01_1707906121.json', 'viator', '2024-02-14 10:22:02', '', '', '1476');
[02/14/2024 10:22:04], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:22:04' WHERE id= '554';
[02/14/2024 10:22:11], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:22:11' WHERE id= '554';
[02/14/2024 10:22:12], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_22_11_1707906131.json', 'v1/14_02_2024/response_sight_details_Viator_10_22_11_1707906131.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_22_11_1707906131.json', 'viator', '2024-02-14 10:22:12', '', '', '1476');
[02/14/2024 10:22:12], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_22_12_1707906132.json', 'v1/14_02_2024/response_sight_details_Viator_10_22_12_1707906132.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_22_12_1707906132.json', 'viator', '2024-02-14 10:22:12', '', '', '1476');
[02/14/2024 10:22:13], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:22:13' WHERE id= '554';
[02/14/2024 10:22:20], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:22:20' WHERE id= '554';
[02/14/2024 10:22:20], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_22_20_1707906140.json', 'v1/14_02_2024/response_sight_details_Viator_10_22_20_1707906140.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_22_20_1707906140.json', 'viator', '2024-02-14 10:22:20', '', '', '1476');
[02/14/2024 10:22:20], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_22_20_1707906140.json', 'v1/14_02_2024/response_sight_details_Viator_10_22_20_1707906140.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_22_20_1707906140.json', 'viator', '2024-02-14 10:22:20', '', '', '1476');
[02/14/2024 10:22:23], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:22:23' WHERE id= '554';
[02/14/2024 10:22:28], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:22:28' WHERE id= '554';
[02/14/2024 10:22:29], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_22_28_1707906148.json', 'v1/14_02_2024/response_sight_details_Viator_10_22_28_1707906148.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_22_28_1707906148.json', 'viator', '2024-02-14 10:22:29', '', '', '1476');
[02/14/2024 10:22:29], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_22_29_1707906149.json', 'v1/14_02_2024/response_sight_details_Viator_10_22_29_1707906149.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_22_29_1707906149.json', 'viator', '2024-02-14 10:22:29', '', '', '1476');
[02/14/2024 10:22:31], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:22:31' WHERE id= '554';
[02/14/2024 10:22:40], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:22:40' WHERE id= '554';
[02/14/2024 10:22:41], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_22_40_1707906160.json', 'v1/14_02_2024/response_sight_details_Viator_10_22_40_1707906160.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_22_40_1707906160.json', 'viator', '2024-02-14 10:22:41', '', '', '1476');
[02/14/2024 10:22:42], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_22_41_1707906161.json', 'v1/14_02_2024/response_sight_details_Viator_10_22_41_1707906161.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_22_41_1707906161.json', 'viator', '2024-02-14 10:22:42', '', '', '1476');
[02/14/2024 10:22:43], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:22:43' WHERE id= '554';
[02/14/2024 10:22:48], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:22:48' WHERE id= '554';
[02/14/2024 10:22:48], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_22_48_1707906168.json', 'v1/14_02_2024/response_sight_details_Viator_10_22_48_1707906168.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_22_48_1707906168.json', 'viator', '2024-02-14 10:22:48', '', '', '1476');
[02/14/2024 10:22:49], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_22_48_1707906168.json', 'v1/14_02_2024/response_sight_details_Viator_10_22_48_1707906168.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_22_48_1707906168.json', 'viator', '2024-02-14 10:22:49', '', '', '1476');
[02/14/2024 10:22:51], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:22:51' WHERE id= '554';
[02/14/2024 10:22:56], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:22:56' WHERE id= '554';
[02/14/2024 10:22:57], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_22_56_1707906176.json', 'v1/14_02_2024/response_sight_details_Viator_10_22_56_1707906176.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_22_56_1707906176.json', 'viator', '2024-02-14 10:22:57', '', '', '1476');
[02/14/2024 10:22:58], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_22_57_1707906177.json', 'v1/14_02_2024/response_sight_details_Viator_10_22_57_1707906177.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_22_57_1707906177.json', 'viator', '2024-02-14 10:22:58', '', '', '1476');
[02/14/2024 10:23:00], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:23:00' WHERE id= '554';
[02/14/2024 10:23:05], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:23:05' WHERE id= '554';
[02/14/2024 10:23:06], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_23_05_1707906185.json', 'v1/14_02_2024/response_sight_details_Viator_10_23_05_1707906185.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_23_05_1707906185.json', 'viator', '2024-02-14 10:23:06', '', '', '1476');
[02/14/2024 10:23:06], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_23_06_1707906186.json', 'v1/14_02_2024/response_sight_details_Viator_10_23_06_1707906186.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_23_06_1707906186.json', 'viator', '2024-02-14 10:23:06', '', '', '1476');
[02/14/2024 10:23:08], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:23:08' WHERE id= '554';
[02/14/2024 10:23:13], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:23:13' WHERE id= '554';
[02/14/2024 10:23:13], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_23_13_1707906193.json', 'v1/14_02_2024/response_sight_details_Viator_10_23_13_1707906193.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_23_13_1707906193.json', 'viator', '2024-02-14 10:23:13', '', '', '1476');
[02/14/2024 10:23:14], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_23_13_1707906193.json', 'v1/14_02_2024/response_sight_details_Viator_10_23_13_1707906193.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_23_13_1707906193.json', 'viator', '2024-02-14 10:23:14', '', '', '1476');
[02/14/2024 10:23:16], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:23:16' WHERE id= '554';
[02/14/2024 10:23:25], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:23:25' WHERE id= '554';
[02/14/2024 10:23:25], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'check_availability', 'v1/14_02_2024/request_check_availability_Viator_10_23_25_1707906205.json', 'v1/14_02_2024/response_check_availability_Viator_10_23_25_1707906205.json', 'v1/14_02_2024/response_header_check_availability_Viator_10_23_25_1707906205.json', 'viator', '2024-02-14 10:23:25', '', '', '1476');
[02/14/2024 10:23:31], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:23:31' WHERE id= '554';
[02/14/2024 10:23:31], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-02-14 10:23:31',login_attempt=0 where id = '7869';
[02/14/2024 10:23:31], [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 10:23:31', ip = '43.239.53.130', action = 'Login' ;
[02/14/2024 10:23:32], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:23:32' WHERE id= '554';
[02/14/2024 10:23:36], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:23:36' WHERE id= '554';
[02/14/2024 10:23:43], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:23:43' WHERE id= '554';
[02/14/2024 10:23:47], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:23:47' WHERE id= '554';
[02/14/2024 10:23:47], [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/03/20',  departure_date='2024/03/20',  nights='1',  create_date='2024-02-14 :10:23:47',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[02/14/2024 10:23:50], [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_10_23_47_1707906227.json', 'v1/14_02_2024/response_availability_Viator_10_23_47_1707906227.json', 'v1/14_02_2024/response_header_availability_Viator_10_23_47_1707906227.json', 'viator', '2024-02-14 10:23:50', '', '', '1477');
[02/14/2024 10:23:52], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:23:52' WHERE id= '554';
[02/14/2024 10:23:52], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:23:52' WHERE id= '554';
[02/14/2024 10:23:54], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:23:54' WHERE id= '554';
[02/14/2024 10:23:54], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_23_54_1707906234.json', 'v1/14_02_2024/response_sight_details_Viator_10_23_54_1707906234.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_23_54_1707906234.json', 'viator', '2024-02-14 10:23:54', '', '', '1477');
[02/14/2024 10:23:54], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_23_54_1707906234.json', 'v1/14_02_2024/response_sight_details_Viator_10_23_54_1707906234.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_23_54_1707906234.json', 'viator', '2024-02-14 10:23:54', '', '', '1477');
[02/14/2024 10:23:57], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:23:57' WHERE id= '554';
[02/14/2024 10:23:57], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_23_57_1707906237.json', 'v1/14_02_2024/response_sight_details_Viator_10_23_57_1707906237.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_23_57_1707906237.json', 'viator', '2024-02-14 10:23:57', '', '', '1477');
[02/14/2024 10:23:58], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_23_58_1707906238.json', 'v1/14_02_2024/response_sight_details_Viator_10_23_58_1707906238.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_23_58_1707906238.json', 'viator', '2024-02-14 10:23:58', '', '', '1477');
[02/14/2024 10:24:03], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:24:03' WHERE id= '554';
[02/14/2024 10:24:03], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_24_03_1707906243.json', 'v1/14_02_2024/response_sight_details_Viator_10_24_03_1707906243.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_24_03_1707906243.json', 'viator', '2024-02-14 10:24:03', '', '', '1477');
[02/14/2024 10:24:03], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_24_03_1707906243.json', 'v1/14_02_2024/response_sight_details_Viator_10_24_03_1707906243.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_24_03_1707906243.json', 'viator', '2024-02-14 10:24:03', '', '', '1477');
[02/14/2024 10:24:06], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:24:06' WHERE id= '554';
[02/14/2024 10:24:06], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_24_06_1707906246.json', 'v1/14_02_2024/response_sight_details_Viator_10_24_06_1707906246.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_24_06_1707906246.json', 'viator', '2024-02-14 10:24:06', '', '', '1477');
[02/14/2024 10:24:07], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_24_06_1707906246.json', 'v1/14_02_2024/response_sight_details_Viator_10_24_06_1707906246.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_24_06_1707906246.json', 'viator', '2024-02-14 10:24:07', '', '', '1477');
[02/14/2024 10:24:09], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:24:09' WHERE id= '554';
[02/14/2024 10:24:09], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_24_09_1707906249.json', 'v1/14_02_2024/response_sight_details_Viator_10_24_09_1707906249.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_24_09_1707906249.json', 'viator', '2024-02-14 10:24:09', '', '', '1477');
[02/14/2024 10:24:10], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_24_09_1707906249.json', 'v1/14_02_2024/response_sight_details_Viator_10_24_09_1707906249.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_24_09_1707906249.json', 'viator', '2024-02-14 10:24:10', '', '', '1477');
[02/14/2024 10:24:26], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:24:26' WHERE id= '554';
[02/14/2024 10:24:27], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_24_27_1707906267.json', 'v1/14_02_2024/response_sight_details_Viator_10_24_27_1707906267.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_24_27_1707906267.json', 'viator', '2024-02-14 10:24:27', '', '', '1477');
[02/14/2024 10:24:27], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_24_27_1707906267.json', 'v1/14_02_2024/response_sight_details_Viator_10_24_27_1707906267.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_24_27_1707906267.json', 'viator', '2024-02-14 10:24:27', '', '', '1477');
[02/14/2024 10:24:39], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:24:39' WHERE id= '554';
[02/14/2024 10:24:39], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_24_39_1707906279.json', 'v1/14_02_2024/response_sight_details_Viator_10_24_39_1707906279.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_24_39_1707906279.json', 'viator', '2024-02-14 10:24:39', '', '', '1477');
[02/14/2024 10:24:40], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_24_39_1707906279.json', 'v1/14_02_2024/response_sight_details_Viator_10_24_39_1707906279.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_24_39_1707906279.json', 'viator', '2024-02-14 10:24:40', '', '', '1477');
[02/14/2024 10:24:43], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:24:43' WHERE id= '554';
[02/14/2024 10:24:44], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_24_43_1707906283.json', 'v1/14_02_2024/response_sight_details_Viator_10_24_43_1707906283.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_24_43_1707906283.json', 'viator', '2024-02-14 10:24:44', '', '', '1477');
[02/14/2024 10:24:44], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_24_44_1707906284.json', 'v1/14_02_2024/response_sight_details_Viator_10_24_44_1707906284.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_24_44_1707906284.json', 'viator', '2024-02-14 10:24:44', '', '', '1477');
[02/14/2024 10:25:31], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:25:31' WHERE id= '554';
[02/14/2024 10:25:39], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:25:39' WHERE id= '554';
[02/14/2024 10:25:39], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-02-14 10:25:39',login_attempt=0 where id = '7869';
[02/14/2024 10:25:39], [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 10:25:39', ip = '43.239.53.130', action = 'Login' ;
[02/14/2024 10:25:39], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:25:39' WHERE id= '554';
[02/14/2024 10:25:45], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:25:45' WHERE id= '554';
[02/14/2024 10:25:52], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:25:52' WHERE id= '554';
[02/14/2024 10:25:56], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:25:56' WHERE id= '554';
[02/14/2024 10:25:56], [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 = 'phuket' , arrival_date='2024/02/21',  departure_date='2024/02/21',  nights='1',  create_date='2024-02-14 :10:25:56',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[02/14/2024 10:26:00], [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_10_25_56_1707906356.json', 'v1/14_02_2024/response_availability_Viator_10_25_56_1707906356.json', 'v1/14_02_2024/response_header_availability_Viator_10_25_56_1707906356.json', 'viator', '2024-02-14 10:26:00', '', '', '1478');
[02/14/2024 10:26:01], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:26:01' WHERE id= '554';
[02/14/2024 10:26:01], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:26:01' WHERE id= '554';
[02/14/2024 10:26:03], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:26:03' WHERE id= '554';
[02/14/2024 10:26:05], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_26_03_1707906363.json', 'v1/14_02_2024/response_sight_details_Viator_10_26_03_1707906363.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_26_03_1707906363.json', 'viator', '2024-02-14 10:26:05', '', '', '1478');
[02/14/2024 10:26:05], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_26_05_1707906365.json', 'v1/14_02_2024/response_sight_details_Viator_10_26_05_1707906365.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_26_05_1707906365.json', 'viator', '2024-02-14 10:26:05', '', '', '1478');
[02/14/2024 10:26:09], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:26:09' WHERE id= '554';
[02/14/2024 10:26:09], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_26_09_1707906369.json', 'v1/14_02_2024/response_sight_details_Viator_10_26_09_1707906369.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_26_09_1707906369.json', 'viator', '2024-02-14 10:26:09', '', '', '1478');
[02/14/2024 10:26:09], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_26_09_1707906369.json', 'v1/14_02_2024/response_sight_details_Viator_10_26_09_1707906369.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_26_09_1707906369.json', 'viator', '2024-02-14 10:26:09', '', '', '1478');
[02/14/2024 10:26:19], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:26:19' WHERE id= '554';
[02/14/2024 10:26:19], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_26_19_1707906379.json', 'v1/14_02_2024/response_sight_details_Viator_10_26_19_1707906379.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_26_19_1707906379.json', 'viator', '2024-02-14 10:26:19', '', '', '1478');
[02/14/2024 10:26:20], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_26_19_1707906379.json', 'v1/14_02_2024/response_sight_details_Viator_10_26_19_1707906379.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_26_19_1707906379.json', 'viator', '2024-02-14 10:26:20', '', '', '1478');
[02/14/2024 10:26:25], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:26:25' WHERE id= '554';
[02/14/2024 10:26:26], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_26_25_1707906385.json', 'v1/14_02_2024/response_sight_details_Viator_10_26_25_1707906385.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_26_25_1707906385.json', 'viator', '2024-02-14 10:26:26', '', '', '1478');
[02/14/2024 10:26:26], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_26_26_1707906386.json', 'v1/14_02_2024/response_sight_details_Viator_10_26_26_1707906386.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_26_26_1707906386.json', 'viator', '2024-02-14 10:26:26', '', '', '1478');
[02/14/2024 10:26:28], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:26:28' WHERE id= '554';
[02/14/2024 10:26:28], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_26_28_1707906388.json', 'v1/14_02_2024/response_sight_details_Viator_10_26_28_1707906388.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_26_28_1707906388.json', 'viator', '2024-02-14 10:26:28', '', '', '1478');
[02/14/2024 10:26:29], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_26_28_1707906388.json', 'v1/14_02_2024/response_sight_details_Viator_10_26_28_1707906388.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_26_28_1707906388.json', 'viator', '2024-02-14 10:26:29', '', '', '1478');
[02/14/2024 10:26:31], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:26:31' WHERE id= '554';
[02/14/2024 10:26:32], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_26_31_1707906391.json', 'v1/14_02_2024/response_sight_details_Viator_10_26_31_1707906391.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_26_31_1707906391.json', 'viator', '2024-02-14 10:26:32', '', '', '1478');
[02/14/2024 10:26:32], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_26_32_1707906392.json', 'v1/14_02_2024/response_sight_details_Viator_10_26_32_1707906392.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_26_32_1707906392.json', 'viator', '2024-02-14 10:26:32', '', '', '1478');
[02/14/2024 10:26:35], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:26:35' WHERE id= '554';
[02/14/2024 10:26:35], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_26_35_1707906395.json', 'v1/14_02_2024/response_sight_details_Viator_10_26_35_1707906395.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_26_35_1707906395.json', 'viator', '2024-02-14 10:26:35', '', '', '1478');
[02/14/2024 10:26:35], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_26_35_1707906395.json', 'v1/14_02_2024/response_sight_details_Viator_10_26_35_1707906395.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_26_35_1707906395.json', 'viator', '2024-02-14 10:26:35', '', '', '1478');
[02/14/2024 10:26:37], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:26:37' WHERE id= '554';
[02/14/2024 10:26:38], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_26_37_1707906397.json', 'v1/14_02_2024/response_sight_details_Viator_10_26_37_1707906397.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_26_37_1707906397.json', 'viator', '2024-02-14 10:26:38', '', '', '1478');
[02/14/2024 10:26:38], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_26_38_1707906398.json', 'v1/14_02_2024/response_sight_details_Viator_10_26_38_1707906398.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_26_38_1707906398.json', 'viator', '2024-02-14 10:26:38', '', '', '1478');
[02/14/2024 10:26:40], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:26:40' WHERE id= '554';
[02/14/2024 10:26:41], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_26_40_1707906400.json', 'v1/14_02_2024/response_sight_details_Viator_10_26_40_1707906400.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_26_40_1707906400.json', 'viator', '2024-02-14 10:26:41', '', '', '1478');
[02/14/2024 10:26:41], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_26_41_1707906401.json', 'v1/14_02_2024/response_sight_details_Viator_10_26_41_1707906401.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_26_41_1707906401.json', 'viator', '2024-02-14 10:26:41', '', '', '1478');
[02/14/2024 10:26:44], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:26:44' WHERE id= '554';
[02/14/2024 10:26:44], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_26_44_1707906404.json', 'v1/14_02_2024/response_sight_details_Viator_10_26_44_1707906404.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_26_44_1707906404.json', 'viator', '2024-02-14 10:26:44', '', '', '1478');
[02/14/2024 10:26:44], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_26_44_1707906404.json', 'v1/14_02_2024/response_sight_details_Viator_10_26_44_1707906404.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_26_44_1707906404.json', 'viator', '2024-02-14 10:26:44', '', '', '1478');
[02/14/2024 10:26:57], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:26:57' WHERE id= '554';
[02/14/2024 10:26:58], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:26:58' WHERE id= '554';
[02/14/2024 10:26:58], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:26:58' WHERE id= '554';
[02/14/2024 10:27:00], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:27:00' WHERE id= '554';
[02/14/2024 10:27:00], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:27:00' WHERE id= '554';
[02/14/2024 10:27:13], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:27:13' WHERE id= '554';
[02/14/2024 10:27:13], [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 = 'phuket' , arrival_date='2024/02/21',  departure_date='2024/02/21',  nights='1',  create_date='2024-02-14 :10:27:13',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[02/14/2024 10:27: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/14_02_2024/request_availability_Viator_10_27_13_1707906433.json', 'v1/14_02_2024/response_availability_Viator_10_27_13_1707906433.json', 'v1/14_02_2024/response_header_availability_Viator_10_27_13_1707906433.json', 'viator', '2024-02-14 10:27:13', '', '', '1479');
[02/14/2024 10:27:14], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:27:14' WHERE id= '554';
[02/14/2024 10:27:15], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:27:15' WHERE id= '554';
[02/14/2024 10:27:17], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:27:17' WHERE id= '554';
[02/14/2024 10:27:17], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_27_17_1707906437.json', 'v1/14_02_2024/response_sight_details_Viator_10_27_17_1707906437.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_27_17_1707906437.json', 'viator', '2024-02-14 10:27:17', '', '', '1479');
[02/14/2024 10:27:18], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_27_18_1707906438.json', 'v1/14_02_2024/response_sight_details_Viator_10_27_18_1707906438.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_27_18_1707906438.json', 'viator', '2024-02-14 10:27:18', '', '', '1479');
[02/14/2024 10:27:29], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:27:29' WHERE id= '554';
[02/14/2024 10:27:29], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_27_29_1707906449.json', 'v1/14_02_2024/response_sight_details_Viator_10_27_29_1707906449.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_27_29_1707906449.json', 'viator', '2024-02-14 10:27:29', '', '', '1479');
[02/14/2024 10:27:30], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_27_29_1707906449.json', 'v1/14_02_2024/response_sight_details_Viator_10_27_29_1707906449.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_27_29_1707906449.json', 'viator', '2024-02-14 10:27:30', '', '', '1479');
[02/14/2024 10:27:35], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:27:35' WHERE id= '554';
[02/14/2024 10:27:37], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:27:37' WHERE id= '554';
[02/14/2024 10:27:38], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:27:38' WHERE id= '554';
[02/14/2024 10:27:39], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:27:39' WHERE id= '554';
[02/14/2024 10:27:42], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:27:42' WHERE id= '554';
[02/14/2024 10:27:42], [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 = 'las vegas(nv)' , arrival_date='2024/02/21',  departure_date='2024/02/21',  nights='1',  create_date='2024-02-14 :10:27:42',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[02/14/2024 10:27:44], [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_10_27_42_1707906462.json', 'v1/14_02_2024/response_availability_Viator_10_27_42_1707906462.json', 'v1/14_02_2024/response_header_availability_Viator_10_27_42_1707906462.json', 'viator', '2024-02-14 10:27:44', '', '', '1480');
[02/14/2024 10:27:46], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:27:46' WHERE id= '554';
[02/14/2024 10:27:46], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:27:46' WHERE id= '554';
[02/14/2024 10:27:53], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:27:53' WHERE id= '554';
[02/14/2024 10:27:53], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_27_53_1707906473.json', 'v1/14_02_2024/response_sight_details_Viator_10_27_53_1707906473.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_27_53_1707906473.json', 'viator', '2024-02-14 10:27:53', '', '', '1480');
[02/14/2024 10:27:53], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_27_53_1707906473.json', 'v1/14_02_2024/response_sight_details_Viator_10_27_53_1707906473.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_27_53_1707906473.json', 'viator', '2024-02-14 10:27:53', '', '', '1480');
[02/14/2024 10:27:56], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:27:56' WHERE id= '554';
[02/14/2024 10:27:57], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_27_56_1707906476.json', 'v1/14_02_2024/response_sight_details_Viator_10_27_56_1707906476.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_27_56_1707906476.json', 'viator', '2024-02-14 10:27:57', '', '', '1480');
[02/14/2024 10:27:58], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_27_57_1707906477.json', 'v1/14_02_2024/response_sight_details_Viator_10_27_57_1707906477.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_27_57_1707906477.json', 'viator', '2024-02-14 10:27:58', '', '', '1480');
[02/14/2024 10:28:00], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:28:00' WHERE id= '554';
[02/14/2024 10:28:00], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_28_00_1707906480.json', 'v1/14_02_2024/response_sight_details_Viator_10_28_00_1707906480.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_28_00_1707906480.json', 'viator', '2024-02-14 10:28:00', '', '', '1480');
[02/14/2024 10:28:00], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_28_00_1707906480.json', 'v1/14_02_2024/response_sight_details_Viator_10_28_00_1707906480.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_28_00_1707906480.json', 'viator', '2024-02-14 10:28:00', '', '', '1480');
[02/14/2024 10:28:05], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:28:05' WHERE id= '554';
[02/14/2024 10:28:06], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_28_05_1707906485.json', 'v1/14_02_2024/response_sight_details_Viator_10_28_05_1707906485.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_28_05_1707906485.json', 'viator', '2024-02-14 10:28:06', '', '', '1480');
[02/14/2024 10:28:06], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_28_06_1707906486.json', 'v1/14_02_2024/response_sight_details_Viator_10_28_06_1707906486.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_28_06_1707906486.json', 'viator', '2024-02-14 10:28:06', '', '', '1480');
[02/14/2024 10:28:09], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:28:09' WHERE id= '554';
[02/14/2024 10:28:09], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_28_09_1707906489.json', 'v1/14_02_2024/response_sight_details_Viator_10_28_09_1707906489.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_28_09_1707906489.json', 'viator', '2024-02-14 10:28:09', '', '', '1480');
[02/14/2024 10:28:09], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_28_09_1707906489.json', 'v1/14_02_2024/response_sight_details_Viator_10_28_09_1707906489.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_28_09_1707906489.json', 'viator', '2024-02-14 10:28:09', '', '', '1480');
[02/14/2024 10:28:12], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:28:12' WHERE id= '554';
[02/14/2024 10:28:12], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_28_12_1707906492.json', 'v1/14_02_2024/response_sight_details_Viator_10_28_12_1707906492.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_28_12_1707906492.json', 'viator', '2024-02-14 10:28:12', '', '', '1480');
[02/14/2024 10:28:12], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_28_12_1707906492.json', 'v1/14_02_2024/response_sight_details_Viator_10_28_12_1707906492.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_28_12_1707906492.json', 'viator', '2024-02-14 10:28:12', '', '', '1480');
[02/14/2024 10:28:15], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:28:15' WHERE id= '554';
[02/14/2024 10:28:16], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_28_15_1707906495.json', 'v1/14_02_2024/response_sight_details_Viator_10_28_15_1707906495.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_28_15_1707906495.json', 'viator', '2024-02-14 10:28:16', '', '', '1480');
[02/14/2024 10:28:17], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_28_16_1707906496.json', 'v1/14_02_2024/response_sight_details_Viator_10_28_16_1707906496.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_28_16_1707906496.json', 'viator', '2024-02-14 10:28:17', '', '', '1480');
[02/14/2024 10:28:19], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:28:19' WHERE id= '554';
[02/14/2024 10:28:20], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_28_19_1707906499.json', 'v1/14_02_2024/response_sight_details_Viator_10_28_19_1707906499.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_28_19_1707906499.json', 'viator', '2024-02-14 10:28:20', '', '', '1480');
[02/14/2024 10:28:20], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_28_20_1707906500.json', 'v1/14_02_2024/response_sight_details_Viator_10_28_20_1707906500.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_28_20_1707906500.json', 'viator', '2024-02-14 10:28:20', '', '', '1480');
[02/14/2024 10:28:23], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:28:23' WHERE id= '554';
[02/14/2024 10:28:23], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_28_23_1707906503.json', 'v1/14_02_2024/response_sight_details_Viator_10_28_23_1707906503.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_28_23_1707906503.json', 'viator', '2024-02-14 10:28:23', '', '', '1480');
[02/14/2024 10:28:23], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_28_23_1707906503.json', 'v1/14_02_2024/response_sight_details_Viator_10_28_23_1707906503.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_28_23_1707906503.json', 'viator', '2024-02-14 10:28:23', '', '', '1480');
[02/14/2024 10:28:26], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:28:26' WHERE id= '554';
[02/14/2024 10:28:27], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_28_26_1707906506.json', 'v1/14_02_2024/response_sight_details_Viator_10_28_26_1707906506.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_28_26_1707906506.json', 'viator', '2024-02-14 10:28:27', '', '', '1480');
[02/14/2024 10:28:27], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_28_27_1707906507.json', 'v1/14_02_2024/response_sight_details_Viator_10_28_27_1707906507.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_28_27_1707906507.json', 'viator', '2024-02-14 10:28:27', '', '', '1480');
[02/14/2024 10:28:33], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:28:33' WHERE id= '554';
[02/14/2024 10:28:38], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:28:38' WHERE id= '554';
[02/14/2024 10:28:38], [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 = 'bali' , arrival_date='2024/02/21',  departure_date='2024/02/21',  nights='1',  create_date='2024-02-14 :10:28:38',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[02/14/2024 10:28: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_10_28_39_1707906519.json', 'v1/14_02_2024/response_availability_Viator_10_28_39_1707906519.json', 'v1/14_02_2024/response_header_availability_Viator_10_28_39_1707906519.json', 'viator', '2024-02-14 10:28:41', '', '', '1481');
[02/14/2024 10:28:43], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:28:43' WHERE id= '554';
[02/14/2024 10:28:43], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:28:43' WHERE id= '554';
[02/14/2024 10:28:48], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:28:48' WHERE id= '554';
[02/14/2024 10:28:48], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_28_48_1707906528.json', 'v1/14_02_2024/response_sight_details_Viator_10_28_48_1707906528.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_28_48_1707906528.json', 'viator', '2024-02-14 10:28:48', '', '', '1481');
[02/14/2024 10:28:49], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_28_49_1707906529.json', 'v1/14_02_2024/response_sight_details_Viator_10_28_49_1707906529.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_28_49_1707906529.json', 'viator', '2024-02-14 10:28:49', '', '', '1481');
[02/14/2024 10:29:08], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:29:08' WHERE id= '554';
[02/14/2024 10:29:09], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_29_08_1707906548.json', 'v1/14_02_2024/response_sight_details_Viator_10_29_08_1707906548.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_29_08_1707906548.json', 'viator', '2024-02-14 10:29:09', '', '', '1481');
[02/14/2024 10:29:09], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_29_09_1707906549.json', 'v1/14_02_2024/response_sight_details_Viator_10_29_09_1707906549.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_29_09_1707906549.json', 'viator', '2024-02-14 10:29:09', '', '', '1481');
[02/14/2024 10:29:13], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:29:13' WHERE id= '554';
[02/14/2024 10:29:13], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_29_13_1707906553.json', 'v1/14_02_2024/response_sight_details_Viator_10_29_13_1707906553.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_29_13_1707906553.json', 'viator', '2024-02-14 10:29:13', '', '', '1481');
[02/14/2024 10:29:14], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_29_13_1707906553.json', 'v1/14_02_2024/response_sight_details_Viator_10_29_13_1707906553.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_29_13_1707906553.json', 'viator', '2024-02-14 10:29:14', '', '', '1481');
[02/14/2024 10:29:17], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:29:17' WHERE id= '554';
[02/14/2024 10:29:17], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_29_17_1707906557.json', 'v1/14_02_2024/response_sight_details_Viator_10_29_17_1707906557.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_29_17_1707906557.json', 'viator', '2024-02-14 10:29:17', '', '', '1481');
[02/14/2024 10:29:17], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_29_17_1707906557.json', 'v1/14_02_2024/response_sight_details_Viator_10_29_17_1707906557.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_29_17_1707906557.json', 'viator', '2024-02-14 10:29:17', '', '', '1481');
[02/14/2024 10:29:20], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:29:20' WHERE id= '554';
[02/14/2024 10:29:20], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_29_20_1707906560.json', 'v1/14_02_2024/response_sight_details_Viator_10_29_20_1707906560.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_29_20_1707906560.json', 'viator', '2024-02-14 10:29:20', '', '', '1481');
[02/14/2024 10:29:21], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_29_20_1707906560.json', 'v1/14_02_2024/response_sight_details_Viator_10_29_20_1707906560.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_29_20_1707906560.json', 'viator', '2024-02-14 10:29:21', '', '', '1481');
[02/14/2024 10:31:26], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:31:26' WHERE id= '554';
[02/14/2024 10:31:29], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:31:29' WHERE id= '554';
[02/14/2024 10:31:37], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:31:37' WHERE id= '554';
[02/14/2024 10:31:41], [file name :-/home/otrams/public_html/beta/booking_list_sight.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:31:41' WHERE id= '554';
[02/14/2024 10:31:48], [file name :-/home/otrams/public_html/beta/print_voucher_sight.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:31:48' WHERE id= '554';
[02/14/2024 10:32:03], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:32:03' WHERE id= '554';
[02/14/2024 10:32:03], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-02-14 10:32:03',login_attempt=0 where id = '7869';
[02/14/2024 10:32:03], [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 10:32:03', ip = '43.239.53.130', action = 'Login' ;
[02/14/2024 10:32:03], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:32:03' WHERE id= '554';
[02/14/2024 10:32:07], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:32:07' WHERE id= '554';
[02/14/2024 10:32:11], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:32:11' WHERE id= '554';
[02/14/2024 10:32:14], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:32:14' WHERE id= '554';
[02/14/2024 10:32:18], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:32:18' WHERE id= '554';
[02/14/2024 10:32:18], [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 :10:32:18',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[02/14/2024 10:32:19], [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_10_32_18_1707906738.json', 'v1/14_02_2024/response_availability_Viator_10_32_18_1707906738.json', 'v1/14_02_2024/response_header_availability_Viator_10_32_18_1707906738.json', 'viator', '2024-02-14 10:32:19', '', '', '1482');
[02/14/2024 10:32:20], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:32:20' WHERE id= '554';
[02/14/2024 10:32:21], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:32:21' WHERE id= '554';
[02/14/2024 10:32:34], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:32:34' WHERE id= '554';
[02/14/2024 10:32:35], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_32_34_1707906754.json', 'v1/14_02_2024/response_sight_details_Viator_10_32_34_1707906754.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_32_34_1707906754.json', 'viator', '2024-02-14 10:32:35', '', '', '1482');
[02/14/2024 10:32:35], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_32_35_1707906755.json', 'v1/14_02_2024/response_sight_details_Viator_10_32_35_1707906755.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_32_35_1707906755.json', 'viator', '2024-02-14 10:32:35', '', '', '1482');
[02/14/2024 10:32:41], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:32:41' WHERE id= '554';
[02/14/2024 10:32:42], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'check_availability', 'v1/14_02_2024/request_check_availability_Viator_10_32_41_1707906761.json', 'v1/14_02_2024/response_check_availability_Viator_10_32_41_1707906761.json', 'v1/14_02_2024/response_header_check_availability_Viator_10_32_41_1707906761.json', 'viator', '2024-02-14 10:32:42', '', '', '1482');
[02/14/2024 10:32:48], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:32:48' WHERE id= '554';
[02/14/2024 10:32:48], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1707906768','43.239.53.130');
[02/14/2024 10:33:09], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:33:09' WHERE id= '554';
[02/14/2024 10:35:48], [file name :-/home/otrams/public_html/beta/my_accounts.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:35:48' WHERE id= '554';
[02/14/2024 10:35:52], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:35:52' WHERE id= '554';
[02/14/2024 10:35:52], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-02-14 10:35:52',login_attempt=0 where id = '7869';
[02/14/2024 10:35:52], [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 10:35:52', ip = '43.239.53.130', action = 'Login' ;
[02/14/2024 10:35:52], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:35:52' WHERE id= '554';
[02/14/2024 10:35:55], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:35:55' WHERE id= '554';
[02/14/2024 10:36:07], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:36:07' WHERE id= '554';
[02/14/2024 10:36:10], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:36:10' WHERE id= '554';
[02/14/2024 10:36:14], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:36:14' WHERE id= '554';
[02/14/2024 10:36:14], [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/20',  departure_date='2024/02/20',  nights='1',  create_date='2024-02-14 :10:36:14',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[02/14/2024 10:36:15], [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_10_36_14_1707906974.json', 'v1/14_02_2024/response_availability_Viator_10_36_14_1707906974.json', 'v1/14_02_2024/response_header_availability_Viator_10_36_14_1707906974.json', 'viator', '2024-02-14 10:36:15', '', '', '1483');
[02/14/2024 10:36:16], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:36:16' WHERE id= '554';
[02/14/2024 10:36:16], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:36:16' WHERE id= '554';
[02/14/2024 10:36:20], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:36:20' WHERE id= '554';
[02/14/2024 10:36:21], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_36_20_1707906980.json', 'v1/14_02_2024/response_sight_details_Viator_10_36_20_1707906980.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_36_20_1707906980.json', 'viator', '2024-02-14 10:36:21', '', '', '1483');
[02/14/2024 10:36:21], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_36_21_1707906981.json', 'v1/14_02_2024/response_sight_details_Viator_10_36_21_1707906981.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_36_21_1707906981.json', 'viator', '2024-02-14 10:36:21', '', '', '1483');
[02/14/2024 10:36:29], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:36:29' WHERE id= '554';
[02/14/2024 10:36:30], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'check_availability', 'v1/14_02_2024/request_check_availability_Viator_10_36_29_1707906989.json', 'v1/14_02_2024/response_check_availability_Viator_10_36_29_1707906989.json', 'v1/14_02_2024/response_header_check_availability_Viator_10_36_29_1707906989.json', 'viator', '2024-02-14 10:36:30', '', '', '1483');
[02/14/2024 10:36:40], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:36:40' WHERE id= '554';
[02/14/2024 10:36:40], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1707907000','43.239.53.130');
[02/14/2024 10:37:27], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:37:27' WHERE id= '554';
[02/14/2024 10:37:27], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1707907047','43.239.53.130');
[02/14/2024 10:37:28], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:37:28' WHERE id= '554';
[02/14/2024 10:37:28], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO bookings set reservation_id='2701',agent_id='7869',leader_title='Mr',leader_first_name='shiv',leader_last_name='bob',city_id='dubai',country_id='138',nationality='Emirati',display_room_rate='107.35',display_currency_code='USD',native_room_rate='107.35',consultant_id='SUJAY_QTECH',native_currency_code='USD',cancellation_policy='Cancellation Charges will be applicable if cancelled after 18 Feb 2024 03:00 hrs.<BR>Late amendment charge may apply.<Br><Br><B><U>Detailed Cancellation Policy:</U></B><Br>Charges - 107.35  applicable if cancelled after 18 Feb 2024 at 03:00 hrs',current_status='inprocess-booking',booking_status='1',sales_manager_id='0',create_date='2024-02-14 10:37:28',source_type='viator',expiration_date= '2024-02-18 00:00:00',applied_multiplier='1.00000',applied_markup='0',agent_markup='0',basecurrency_multiplier='1.00000',basecurrency_multiplier_native='1.00000',admin_booked='0',service_date='2024-02-20',sub_user_id='',check_out_date='2024-02-20',supplier_profile_id='',agent_currency_multiplier='1.00000', booking_branch_id = '1',site_url = 'https://beta.astrabookings.com/',ip_addr='43.239.53.130',leader_phone=' 123456789',email_id='deepak.trivedi@qtechsoftware.com',service_type='sightseeing';
[02/14/2024 10:37:28], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO sight_bookings set booking_id='411',native_nightly_rates='a:2:{s:4:\"size\";i:1;s:17:\"nativeNightlyRate\";d:107.34999999999999;}',rate_description='',display_nightly_rates='a:3:{s:4:\"size\";i:1;s:18:\"displayNightlyRate\";d:107.34999999999999;s:23:\"displayNightlyRateStore\";s:135:\"Rate - 107.35 USD, Currency Multiplier (USD-USD) - 1.00000, Markup  in % - %, Markup Amount - , Markup Amount in  -  ,Other Markup - 0%\";}',display_currency_code='USD',native_currency_code='USD',sight_id='333273P5',sight_name='PREMIUM RED DUNES BASHING WITH QUAD BIKE, CAMEL, FALCON &VIP CAMP',tour_time='',tour_details='',tour_inclusive='S<br/>',tour_exclusive='A<br/>',meeting_point='',tour_dep_point=' ',tour_language='en/SERVICE_GUIDE',tour_supplier_phone='',additional_tour_dep_point='',tour_duration='7 hours 30 minutes<br> Start Time: 14:00',arrival_date='2024-02-20',total_adults='1',total_children='1',total_infants='',gta_city_code='828',supplier_id='',pick_up_point='',drop_off_point='',from_slot='',to_slot='',total_adult_rate='',total_child_rate='',adult_rate='',child_rate='',display_total_adult_rate='',display_total_child_rate='',display_adult_rate='',display_child_rate='',additional_service_rate='0',booking_remark='',emergency_cont_no='',terms_n_condition='';
[02/14/2024 10:37:28], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO posted_bookings(id,source_type,reservation_id,create_date,status) values ('','viator','2701','2024-02-14 10:37:28',0);
[02/14/2024 10:37:30], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'reservation_sight', 'v1/14_02_2024/request_reservation_sight_Viator_10_37_28_1707907048.json', 'v1/14_02_2024/response_reservation_sight_Viator_10_37_28_1707907048.json', 'v1/14_02_2024/response_header_reservation_sight_Viator_10_37_28_1707907048.json', 'viator', '2024-02-14 10:37:30', '', '', '1483');
[02/14/2024 10:37:30], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE posted_bookings set status=1 where id= '228';
[02/14/2024 10:37:30], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],update bookings set  parent_agent_id='7869', applicable_service_tax='0', sub_agent_rate='0', agent_rate='107.35', supplier_rate='107.35', uid='', itenirary_id='', confirmation_number='', comment_contract='', current_status='failed', original_source='' where id='411';
[02/14/2024 10:37:30], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],update sight_bookings set gtaToken='',gta_item_confirm_ref='',tour_supplier='',textaddition_activities='N;' where booking_id='411';
[02/14/2024 10:37:30], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
		('','','411','failed','2024-02-14 10:37:30','Sightseeing Booking failed by Agent..7869','7869','43.239.53.130','','','');
[02/14/2024 10:37:30], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],insert into sight_passangers(booking_id,salutations,tour,first_name,last_name,passenger_type,age)values('411','Mr','1','shiv','bob','adult','0');
[02/14/2024 10:37:30], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],insert into sight_passangers(booking_id,salutations,tour,first_name,last_name,passenger_type,age)values('411','Master','1','gaju','bob','child','6');
[02/14/2024 10:37:30], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],update xmllogs set reservation_id='411' where agent_logs_id='1483' and source_type='viator';
[02/14/2024 10:38:11], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:38:11' WHERE id= '554';
[02/14/2024 10:38:14], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:38:14' WHERE id= '554';
[02/14/2024 10:38:14], [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/20',  departure_date='2024/02/20',  nights='1',  create_date='2024-02-14 :10:38:14',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[02/14/2024 10:38:14], [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_10_38_14_1707907094.json', 'v1/14_02_2024/response_availability_Viator_10_38_14_1707907094.json', 'v1/14_02_2024/response_header_availability_Viator_10_38_14_1707907094.json', 'viator', '2024-02-14 10:38:14', '', '', '1484');
[02/14/2024 10:38:15], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:38:15' WHERE id= '554';
[02/14/2024 10:38:23], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:38:23' WHERE id= '554';
[02/14/2024 10:38:23], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-02-14 10:38:23',login_attempt=0 where id = '7869';
[02/14/2024 10:38:23], [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 10:38:23', ip = '43.239.53.130', action = 'Login' ;
[02/14/2024 10:38:24], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:38:24' WHERE id= '554';
[02/14/2024 10:38:30], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:38:30' WHERE id= '554';
[02/14/2024 10:38:35], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:38:35' WHERE id= '554';
[02/14/2024 10:38:41], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:38:41' WHERE id= '554';
[02/14/2024 10:38: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/20',  departure_date='2024/02/20',  nights='1',  create_date='2024-02-14 :10:38:41',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[02/14/2024 10:38:42], [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_10_38_41_1707907121.json', 'v1/14_02_2024/response_availability_Viator_10_38_41_1707907121.json', 'v1/14_02_2024/response_header_availability_Viator_10_38_41_1707907121.json', 'viator', '2024-02-14 10:38:42', '', '', '1485');
[02/14/2024 10:38:44], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:38:44' WHERE id= '554';
[02/14/2024 10:38:44], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:38:44' WHERE id= '554';
[02/14/2024 10:38:48], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:38:48' WHERE id= '554';
[02/14/2024 10:38:48], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_38_48_1707907128.json', 'v1/14_02_2024/response_sight_details_Viator_10_38_48_1707907128.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_38_48_1707907128.json', 'viator', '2024-02-14 10:38:48', '', '', '1485');
[02/14/2024 10:38:49], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_38_48_1707907128.json', 'v1/14_02_2024/response_sight_details_Viator_10_38_48_1707907128.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_38_48_1707907128.json', 'viator', '2024-02-14 10:38:49', '', '', '1485');
[02/14/2024 10:38:52], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:38:52' WHERE id= '554';
[02/14/2024 10:38:52], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'check_availability', 'v1/14_02_2024/request_check_availability_Viator_10_38_52_1707907132.json', 'v1/14_02_2024/response_check_availability_Viator_10_38_52_1707907132.json', 'v1/14_02_2024/response_header_check_availability_Viator_10_38_52_1707907132.json', 'viator', '2024-02-14 10:38:52', '', '', '1485');
[02/14/2024 10:38:58], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:38:58' WHERE id= '554';
[02/14/2024 10:38:58], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_38_58_1707907138.json', 'v1/14_02_2024/response_sight_details_Viator_10_38_58_1707907138.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_38_58_1707907138.json', 'viator', '2024-02-14 10:38:58', '', '', '1485');
[02/14/2024 10:38:58], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_Viator_10_38_58_1707907138.json', 'v1/14_02_2024/response_sight_details_Viator_10_38_58_1707907138.json', 'v1/14_02_2024/response_header_sight_details_Viator_10_38_58_1707907138.json', 'viator', '2024-02-14 10:38:58', '', '', '1485');
[02/14/2024 10:39:03], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:39:03' WHERE id= '554';
[02/14/2024 10:39:03], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'check_availability', 'v1/14_02_2024/request_check_availability_Viator_10_39_03_1707907143.json', 'v1/14_02_2024/response_check_availability_Viator_10_39_03_1707907143.json', 'v1/14_02_2024/response_header_check_availability_Viator_10_39_03_1707907143.json', 'viator', '2024-02-14 10:39:03', '', '', '1485');
[02/14/2024 10:39:14], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:39:14' WHERE id= '554';
[02/14/2024 10:39:14], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1707907154','43.239.53.130');
[02/14/2024 10:39:24], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:39:24' WHERE id= '554';
[02/14/2024 10:40:12], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:40:12' WHERE id= '554';
[02/14/2024 10:40:12], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1707907212','43.239.53.130');
[02/14/2024 10:40:12], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:40:12' WHERE id= '554';
[02/14/2024 10:40:12], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO bookings set reservation_id='2703',agent_id='7869',leader_title='Mr',leader_first_name='shavi',leader_last_name='pranlai',city_id='dubai',country_id='138',nationality='Emirati',display_room_rate='161.03',display_currency_code='USD',native_room_rate='161.03',consultant_id='SUJAY_QTECH',native_currency_code='USD',cancellation_policy='Cancellation Charges will be applicable if cancelled after 18 Feb 2024 03:00 hrs.<BR>Late amendment charge may apply.<Br><Br><B><U>Detailed Cancellation Policy:</U></B><Br>Charges - 161.03  applicable if cancelled after 18 Feb 2024 at 03:00 hrs',current_status='inprocess-booking',booking_status='1',sales_manager_id='0',create_date='2024-02-14 10:40:12',source_type='viator',expiration_date= '2024-02-18 00:00:00',applied_multiplier='1.00000',applied_markup='0',agent_markup='0',basecurrency_multiplier='1.00000',basecurrency_multiplier_native='1.00000',admin_booked='0',service_date='2024-02-20',sub_user_id='',check_out_date='2024-02-20',supplier_profile_id='',agent_currency_multiplier='1.00000', booking_branch_id = '1',site_url = 'https://beta.astrabookings.com/',ip_addr='43.239.53.130',leader_phone=' 12345678',email_id='deepak.trivedi@qtechsoftware.com',service_type='sightseeing';
[02/14/2024 10:40:12], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO sight_bookings set booking_id='412',native_nightly_rates='a:2:{s:4:\"size\";i:1;s:17:\"nativeNightlyRate\";d:161.03;}',rate_description='',display_nightly_rates='a:3:{s:4:\"size\";i:1;s:18:\"displayNightlyRate\";d:161.03;s:23:\"displayNightlyRateStore\";s:135:\"Rate - 161.03 USD, Currency Multiplier (USD-USD) - 1.00000, Markup  in % - %, Markup Amount - , Markup Amount in  -  ,Other Markup - 0%\";}',display_currency_code='USD',native_currency_code='USD',sight_id='434385P4',sight_name='ABU DHABI PRIVATE CITY TOUR ',tour_time='',tour_details='',tour_inclusive='B<br/>',tour_exclusive='E<br/>',meeting_point='',tour_dep_point=' ',tour_language='it/SERVICE_AUDIO',tour_supplier_phone='',additional_tour_dep_point='',tour_duration='10 hours 0 minutes<br> Start Time: 11:00',arrival_date='2024-02-20',total_adults='',total_children='',total_infants='',gta_city_code='828',supplier_id='',pick_up_point='',drop_off_point='',from_slot='',to_slot='',total_adult_rate='',total_child_rate='',adult_rate='',child_rate='',display_total_adult_rate='',display_total_child_rate='',display_adult_rate='',display_child_rate='0',additional_service_rate='0',booking_remark='',emergency_cont_no='',terms_n_condition='';
[02/14/2024 10:40:12], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO posted_bookings(id,source_type,reservation_id,create_date,status) values ('','viator','2703','2024-02-14 10:40:12',0);
[02/14/2024 10:40:15], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'reservation_sight', 'v1/14_02_2024/request_reservation_sight_Viator_10_40_12_1707907212.json', 'v1/14_02_2024/response_reservation_sight_Viator_10_40_12_1707907212.json', 'v1/14_02_2024/response_header_reservation_sight_Viator_10_40_12_1707907212.json', 'viator', '2024-02-14 10:40:15', '', '', '1485');
[02/14/2024 10:40:15], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE posted_bookings set status=1 where id= '229';
[02/14/2024 10:40:15], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],update bookings set  parent_agent_id='7869', applicable_service_tax='0', sub_agent_rate='0', agent_rate='161.03', supplier_rate='161.03', uid='', itenirary_id='2703129', confirmation_number='BR-595580945', comment_contract='', current_status='confirmed', original_source='' where id='412';
[02/14/2024 10:40:15], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],update sight_bookings set gtaToken='',gta_item_confirm_ref='',viator_item_ref='BR-595580945',viator_ref='BR-595580945',viator_item_id='',viator_voucherKey='https://shop.live.rc.viator.com/ticket?code=1020258639:27df040fbd1982f7b2762a49445c183e5c97d8e8a34ff2dc40c2cf6f65ac259d:595580945',tour_supplier='',textaddition_activities='N;' where booking_id='412';
[02/14/2024 10:40:15], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
		('','','412','confirmed','2024-02-14 10:40:15','Sightseeing Booking confirmed by Agent..7869','7869','43.239.53.130','','','');
[02/14/2024 10:40:15], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],insert into sight_passangers(booking_id,salutations,tour,first_name,last_name,passenger_type,age)values('412','Mr','1','shavi','pranlai','adult','0');
[02/14/2024 10:40:15], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],update xmllogs set reservation_id='412' where agent_logs_id='1485' and source_type='viator';
[02/14/2024 10:40:27], [file name :-/home/otrams/public_html/beta/add_voucher.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:40:27' WHERE id= '554';
[02/14/2024 10:40:29], [file name :-/home/otrams/public_html/beta/add_voucher.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:40:29' WHERE id= '554';
[02/14/2024 10:40:29], [file name :-/home/otrams/public_html/beta/add_voucher.php],update bookings set invoice_number= 'INV14022400004', voucher_id='dsfg324t',status_date='2024-02-14 10:40:29',current_status='vouchered',voucher_hashcode='6591d2066db0dda1ec7f2f08292a487239687412',vouchered_by ='' where id='412';
[02/14/2024 10:40:29], [file name :-/home/otrams/public_html/beta/add_voucher.php],update bookings set is_invoiced='yes',invoice_number= 'INV14022400004' where id='412' and is_invoiced!='yes';
[02/14/2024 10:40:29], [file name :-/home/otrams/public_html/beta/add_voucher.php],UPDATE agents SET credit_usage=credit_usage+('161.03'),   credit_value= credit_value-('161.03') ,  cd_credit_usage=cd_credit_usage+('161.03') , cd_credit_value=cd_credit_value-('161.03')  WHERE id = '7869';
[02/14/2024 10:40:29], [file name :-/home/otrams/public_html/beta/add_voucher.php],insert into  agent_credit_log SET agent_id= '7869',credit_value= '497950.690',credit_usage= '2049.310',credit_limit= '500000.000',receipt_id= '',amount= '161.03',booking_id='412',booking_cost= '',receipt_allocation= '',balance= '',ip='43.239.53.130',user_type='User',admin_id='Agent - Viator  Test(CD7869)',temp_credit_limit='',log_type='Add Invoice',note='Add Invoice',create_date='2024-02-14 10:02:29';
[02/14/2024 10:40:29], [file name :-/home/otrams/public_html/beta/add_voucher.php], insert into booking_rate_info set  booking_id = '412', booking_log = 'Booking Vouchered', create_date = '2024-02-14 10:40:29', supplier_currency ='USD', type = 'Sale', agent_price = '161.03', sub_agent_price ='', supplier_price = '161.030', supplier_id = 'viator', supplier_type = 'online';
[02/14/2024 10:40:32], [file name :-/home/otrams/public_html/beta/add_voucher.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
		('','','412','vouchered-invoiced','2024-02-14 10:40:32','Booking invoiced by Back Office v3alpha on behalf of Agent - Viator  Test(CD7869)','7869','43.239.53.130','','','');
[02/14/2024 10:40:32], [file name :-/home/otrams/public_html/beta/add_voucher.php],INSERT INTO agent_commission SET booking_id ='412',booking_detail_id ='412',agent_id ='7869',is_sub_agent ='N',parent_id ='',display_commission ='0',display_currency ='USD',paid ='N',type ='sightseeing',description ='Agent Mark Up Percentage is 0 %',create_date ='2024-02-14 10:40:32';
[02/14/2024 10:40:32], [file name :-/home/otrams/public_html/beta/add_voucher.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
		('','','412','vouchered','2024-02-14 10:40:32','Voucherd by Back Office v3alpha on behalf of Agent - Viator  Test(CD7869)','7869','43.239.53.130','','','');
[02/14/2024 10:40:41], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:40:41' WHERE id= '554';
[02/14/2024 10:40:45], [file name :-/home/otrams/public_html/beta/print_voucher_sight.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:40:45' WHERE id= '554';
[02/14/2024 10:40:54], [file name :-/home/otrams/public_html/beta/print_voucher_sight.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:40:54' WHERE id= '554';
[02/14/2024 10:41:43], [file name :-/home/otrams/public_html/beta/my_accounts.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:41:43' WHERE id= '554';
[02/14/2024 10:41:45], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:41:45' WHERE id= '554';
[02/14/2024 10:41:55], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:41:55' WHERE id= '554';
[02/14/2024 10:41:59], [file name :-/home/otrams/public_html/beta/booking_list_sight.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:41:59' WHERE id= '554';
[02/14/2024 10:42:04], [file name :-/home/otrams/public_html/beta/print_invoice.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:42:04' WHERE id= '554';
[02/14/2024 10:46:48], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-02-14 10:46:48',login_attempt=0 where id = '7849';
[02/14/2024 10:46:48], [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 10:46:48', ip = '43.239.53.130', action = 'Login' ;
[02/14/2024 10:46:48], [file name :-/home/otrams/public_html/beta/hotel_search.php],insert into user_sessions_ip SET ip_addr='43.239.53.130', agent_id='7849', session_id='e1b073717b31bb838102c7158771e5ca4e85a5a619c5920ee18f1aa4b4f49e7d',create_date='2024-02-14 10:46:48', update_date='2024-02-14 10:46:48',domain='beta.astrabookings.com',sub_agent_id='',sub_user_id='';
[02/14/2024 10:46:52], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:46:52' WHERE id= '555';
[02/14/2024 10:46:56], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:46:56' WHERE id= '555';
[02/14/2024 10:47:00], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:47:00' WHERE id= '555';
[02/14/2024 10:47:00], [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/28',  departure_date='2024/02/28',  nights='1',  create_date='2024-02-14 :10:47:00',  nationality='',  additional_markup='',  selected_currency='INR',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[02/14/2024 10:47: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/14_02_2024/request_availability_shiv_qtech_10_47_00_1707907620.json', 'v1/14_02_2024/response_availability_shiv_qtech_10_47_00_1707907620.json', 'v1/14_02_2024/response_header_availability_shiv_qtech_10_47_00_1707907620.json', 'viator', '2024-02-14 10:47:13', '', '', '1486');
[02/14/2024 10:47:15], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:47:15' WHERE id= '555';
[02/14/2024 10:47:15], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:47:15' WHERE id= '555';
[02/14/2024 10:47:19], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:47:19' WHERE id= '555';
[02/14/2024 10:47:20], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_shiv_qtech_10_47_19_1707907639.json', 'v1/14_02_2024/response_sight_details_shiv_qtech_10_47_19_1707907639.json', 'v1/14_02_2024/response_header_sight_details_shiv_qtech_10_47_19_1707907639.json', 'viator', '2024-02-14 10:47:20', '', '', '1486');
[02/14/2024 10:47:20], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_shiv_qtech_10_47_20_1707907640.json', 'v1/14_02_2024/response_sight_details_shiv_qtech_10_47_20_1707907640.json', 'v1/14_02_2024/response_header_sight_details_shiv_qtech_10_47_20_1707907640.json', 'viator', '2024-02-14 10:47:20', '', '', '1486');
[02/14/2024 10:47:22], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:47:22' WHERE id= '555';
[02/14/2024 10:47:23], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_shiv_qtech_10_47_22_1707907642.json', 'v1/14_02_2024/response_sight_details_shiv_qtech_10_47_22_1707907642.json', 'v1/14_02_2024/response_header_sight_details_shiv_qtech_10_47_22_1707907642.json', 'viator', '2024-02-14 10:47:23', '', '', '1486');
[02/14/2024 10:47:23], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_shiv_qtech_10_47_23_1707907643.json', 'v1/14_02_2024/response_sight_details_shiv_qtech_10_47_23_1707907643.json', 'v1/14_02_2024/response_header_sight_details_shiv_qtech_10_47_23_1707907643.json', 'viator', '2024-02-14 10:47:23', '', '', '1486');
[02/14/2024 10:47:25], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:47:25' WHERE id= '555';
[02/14/2024 10:47:26], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_shiv_qtech_10_47_25_1707907645.json', 'v1/14_02_2024/response_sight_details_shiv_qtech_10_47_25_1707907645.json', 'v1/14_02_2024/response_header_sight_details_shiv_qtech_10_47_25_1707907645.json', 'viator', '2024-02-14 10:47:26', '', '', '1486');
[02/14/2024 10:47:26], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_shiv_qtech_10_47_26_1707907646.json', 'v1/14_02_2024/response_sight_details_shiv_qtech_10_47_26_1707907646.json', 'v1/14_02_2024/response_header_sight_details_shiv_qtech_10_47_26_1707907646.json', 'viator', '2024-02-14 10:47:26', '', '', '1486');
[02/14/2024 10:47:29], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:47:29' WHERE id= '555';
[02/14/2024 10:47:29], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_shiv_qtech_10_47_29_1707907649.json', 'v1/14_02_2024/response_sight_details_shiv_qtech_10_47_29_1707907649.json', 'v1/14_02_2024/response_header_sight_details_shiv_qtech_10_47_29_1707907649.json', 'viator', '2024-02-14 10:47:29', '', '', '1486');
[02/14/2024 10:47:29], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_shiv_qtech_10_47_29_1707907649.json', 'v1/14_02_2024/response_sight_details_shiv_qtech_10_47_29_1707907649.json', 'v1/14_02_2024/response_header_sight_details_shiv_qtech_10_47_29_1707907649.json', 'viator', '2024-02-14 10:47:29', '', '', '1486');
[02/14/2024 10:51:04], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:51:04' WHERE id= '555';
[02/14/2024 10:51:04], [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/28',  departure_date='2024/02/28',  nights='1',  create_date='2024-02-14 :10:51:04',  nationality='',  additional_markup='',  selected_currency='INR',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[02/14/2024 10:51: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_shiv_qtech_10_51_04_1707907864.json', 'v1/14_02_2024/response_availability_shiv_qtech_10_51_04_1707907864.json', 'v1/14_02_2024/response_header_availability_shiv_qtech_10_51_04_1707907864.json', 'viator', '2024-02-14 10:51:09', '', '', '1487');
[02/14/2024 10:51:12], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:51:12' WHERE id= '555';
[02/14/2024 10:51:13], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:51:13' WHERE id= '555';
[02/14/2024 10:51:15], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:51:15' WHERE id= '555';
[02/14/2024 10:51:16], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_shiv_qtech_10_51_15_1707907875.json', 'v1/14_02_2024/response_sight_details_shiv_qtech_10_51_15_1707907875.json', 'v1/14_02_2024/response_header_sight_details_shiv_qtech_10_51_15_1707907875.json', 'viator', '2024-02-14 10:51:16', '', '', '1487');
[02/14/2024 10:51:16], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_shiv_qtech_10_51_16_1707907876.json', 'v1/14_02_2024/response_sight_details_shiv_qtech_10_51_16_1707907876.json', 'v1/14_02_2024/response_header_sight_details_shiv_qtech_10_51_16_1707907876.json', 'viator', '2024-02-14 10:51:16', '', '', '1487');
[02/14/2024 10:51:33], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:51:33' WHERE id= '555';
[02/14/2024 10:51:33], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'check_availability', 'v1/14_02_2024/request_check_availability_shiv_qtech_10_51_33_1707907893.json', 'v1/14_02_2024/response_check_availability_shiv_qtech_10_51_33_1707907893.json', 'v1/14_02_2024/response_header_check_availability_shiv_qtech_10_51_33_1707907893.json', 'viator', '2024-02-14 10:51:33', '', '', '1487');
[02/14/2024 10:51:41], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:51:41' WHERE id= '555';
[02/14/2024 10:51:42], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'check_availability', 'v1/14_02_2024/request_check_availability_shiv_qtech_10_51_41_1707907901.json', 'v1/14_02_2024/response_check_availability_shiv_qtech_10_51_41_1707907901.json', 'v1/14_02_2024/response_header_check_availability_shiv_qtech_10_51_41_1707907901.json', 'viator', '2024-02-14 10:51:42', '', '', '1487');
[02/14/2024 10:51:44], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:51:44' WHERE id= '555';
[02/14/2024 10:51:44], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_shiv_qtech_10_51_44_1707907904.json', 'v1/14_02_2024/response_sight_details_shiv_qtech_10_51_44_1707907904.json', 'v1/14_02_2024/response_header_sight_details_shiv_qtech_10_51_44_1707907904.json', 'viator', '2024-02-14 10:51:44', '', '', '1487');
[02/14/2024 10:51:45], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_shiv_qtech_10_51_45_1707907905.json', 'v1/14_02_2024/response_sight_details_shiv_qtech_10_51_45_1707907905.json', 'v1/14_02_2024/response_header_sight_details_shiv_qtech_10_51_45_1707907905.json', 'viator', '2024-02-14 10:51:45', '', '', '1487');
[02/14/2024 10:51:50], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:51:50' WHERE id= '555';
[02/14/2024 10:51:50], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'check_availability', 'v1/14_02_2024/request_check_availability_shiv_qtech_10_51_50_1707907910.json', 'v1/14_02_2024/response_check_availability_shiv_qtech_10_51_50_1707907910.json', 'v1/14_02_2024/response_header_check_availability_shiv_qtech_10_51_50_1707907910.json', 'viator', '2024-02-14 10:51:50', '', '', '1487');
[02/14/2024 10:52:01], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:52:01' WHERE id= '555';
[02/14/2024 10:52:01], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1707907921','43.239.53.130');
[02/14/2024 10:52:17], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:52:17' WHERE id= '555';
[02/14/2024 10:52:18], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:52:18' WHERE id= '555';
[02/14/2024 10:52:18], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:52:18' WHERE id= '555';
[02/14/2024 10:52:20], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:52:20' WHERE id= '555';
[02/14/2024 10:52:21], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_shiv_qtech_10_52_20_1707907940.json', 'v1/14_02_2024/response_sight_details_shiv_qtech_10_52_20_1707907940.json', 'v1/14_02_2024/response_header_sight_details_shiv_qtech_10_52_20_1707907940.json', 'viator', '2024-02-14 10:52:21', '', '', '1487');
[02/14/2024 10:52:21], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/14_02_2024/request_sight_details_shiv_qtech_10_52_21_1707907941.json', 'v1/14_02_2024/response_sight_details_shiv_qtech_10_52_21_1707907941.json', 'v1/14_02_2024/response_header_sight_details_shiv_qtech_10_52_21_1707907941.json', 'viator', '2024-02-14 10:52:21', '', '', '1487');
[02/14/2024 10:52:24], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:52:24' WHERE id= '555';
[02/14/2024 10:52:24], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'check_availability', 'v1/14_02_2024/request_check_availability_shiv_qtech_10_52_24_1707907944.json', 'v1/14_02_2024/response_check_availability_shiv_qtech_10_52_24_1707907944.json', 'v1/14_02_2024/response_header_check_availability_shiv_qtech_10_52_24_1707907944.json', 'viator', '2024-02-14 10:52:24', '', '', '1487');
[02/14/2024 10:52:30], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:52:30' WHERE id= '555';
[02/14/2024 10:52:30], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1707907950','43.239.53.130');
[02/14/2024 10:52:38], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-14 10:52:38' WHERE id= '555';
[02/14/2024 10:52:38], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1707907958','43.239.53.130');
