[01/24/2024 04:22:26], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-24 04:22:26',login_attempt=0 where id = '7851';
[01/24/2024 04:22:26], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Viator_test', user_type = 'A', branch_id = '27', login_datetime = '2024-01-24 16:22:26', ip = '43.239.53.130', action = 'Login' ;
[01/24/2024 04:22:27], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 04:22:27' WHERE id= '309';
[01/24/2024 04:22:30], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 04:22:30' WHERE id= '309';
[01/24/2024 04:22:34], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 04:22:34' WHERE id= '309';
[01/24/2024 04:22:36], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 04:22:36' WHERE id= '309';
[01/24/2024 04:22:43], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 04:22:43' WHERE id= '309';
[01/24/2024 04:22:43], [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/02/14',  departure_date='2024/02/14',  nights='1',  create_date='2024-01-24 :16:22:43',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/24/2024 04:22:57], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'v1/24_01_2024/request_availability_Viator_test_16_22_43_1706113363.json', 'v1/24_01_2024/response_availability_Viator_test_16_22_43_1706113363.json', 'v1/24_01_2024/response_header_availability_Viator_test_16_22_43_1706113363.json', 'viator', '2024-01-24 04:22:57', '', '', '1132');
[01/24/2024 04:22:58], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 04:22:58' WHERE id= '309';
[01/24/2024 04:22:58], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 04:22:58' WHERE id= '309';
[01/24/2024 04:23:00], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 04:23:00' WHERE id= '309';
[01/24/2024 04:23: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/24_01_2024/request_sight_details_Viator_test_16_23_00_1706113380.json', 'v1/24_01_2024/response_sight_details_Viator_test_16_23_00_1706113380.json', 'v1/24_01_2024/response_header_sight_details_Viator_test_16_23_00_1706113380.json', 'viator', '2024-01-24 04:23:01', '', '', '1132');
[01/24/2024 04:23:04], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 04:23:04' WHERE id= '309';
[01/24/2024 04:23:18], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 04:23:18' WHERE id= '309';
[01/24/2024 04:23:19], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'check_availability', 'v1/24_01_2024/request_check_availability_Viator_test_16_23_18_1706113398.json', 'v1/24_01_2024/response_check_availability_Viator_test_16_23_18_1706113398.json', 'v1/24_01_2024/response_header_check_availability_Viator_test_16_23_18_1706113398.json', 'viator', '2024-01-24 04:23:19', '', '', '1132');
[01/24/2024 04:23:49], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 04:23:49' WHERE id= '309';
[01/24/2024 04:23:49], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1706113429','43.239.53.130');
[01/24/2024 04:24:28], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 04:24:28' WHERE id= '309';
[01/24/2024 04:24:28], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1706113468','43.239.53.130');
[01/24/2024 04:26:04], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 04:26:04' WHERE id= '309';
[01/24/2024 04:26:04], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1706113564','43.239.53.130');
[01/24/2024 04:26:28], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 04:26:28' WHERE id= '309';
[01/24/2024 04:26:28], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1706113588','43.239.53.130');
[01/24/2024 04:26:34], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 04:26:34' WHERE id= '309';
[01/24/2024 04:26:34], [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/02/14',  departure_date='2024/02/14',  nights='1',  create_date='2024-01-24 :16:26:34',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/24/2024 04:26:58], [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/24_01_2024/request_availability_Viator_test_16_26_34_1706113594.json', 'v1/24_01_2024/response_availability_Viator_test_16_26_34_1706113594.json', 'v1/24_01_2024/response_header_availability_Viator_test_16_26_34_1706113594.json', 'viator', '2024-01-24 04:26:58', '', '', '1133');
[01/24/2024 04:27:00], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 04:27:00' WHERE id= '309';
[01/24/2024 04:27:00], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 04:27:00' WHERE id= '309';
[01/24/2024 04:27:03], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 04:27:03' WHERE id= '309';
[01/24/2024 04:27: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/24_01_2024/request_sight_details_Viator_test_16_27_03_1706113623.json', 'v1/24_01_2024/response_sight_details_Viator_test_16_27_03_1706113623.json', 'v1/24_01_2024/response_header_sight_details_Viator_test_16_27_03_1706113623.json', 'viator', '2024-01-24 04:27:03', '', '', '1133');
[01/24/2024 04:27:08], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 04:27:08' WHERE id= '309';
[01/24/2024 04:27: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 ('', 'check_availability', 'v1/24_01_2024/request_check_availability_Viator_test_16_27_08_1706113628.json', 'v1/24_01_2024/response_check_availability_Viator_test_16_27_08_1706113628.json', 'v1/24_01_2024/response_header_check_availability_Viator_test_16_27_08_1706113628.json', 'viator', '2024-01-24 04:27:09', '', '', '1133');
[01/24/2024 04:27:52], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 04:27:52' WHERE id= '309';
[01/24/2024 04: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 ('', 'check_availability', 'v1/24_01_2024/request_check_availability_Viator_test_16_27_52_1706113672.json', 'v1/24_01_2024/response_check_availability_Viator_test_16_27_52_1706113672.json', 'v1/24_01_2024/response_header_check_availability_Viator_test_16_27_52_1706113672.json', 'viator', '2024-01-24 04:27:53', '', '', '1133');
[01/24/2024 04:30:18], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 04:30:18' WHERE id= '309';
[01/24/2024 04:30:19], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'check_availability', 'v1/24_01_2024/request_check_availability_Viator_test_16_30_18_1706113818.json', 'v1/24_01_2024/response_check_availability_Viator_test_16_30_18_1706113818.json', 'v1/24_01_2024/response_header_check_availability_Viator_test_16_30_18_1706113818.json', 'viator', '2024-01-24 04:30:19', '', '', '1133');
[01/24/2024 04:30:21], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 04:30:21' WHERE id= '309';
[01/24/2024 04:30: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 ('', 'check_availability', 'v1/24_01_2024/request_check_availability_Viator_test_16_30_21_1706113821.json', 'v1/24_01_2024/response_check_availability_Viator_test_16_30_21_1706113821.json', 'v1/24_01_2024/response_header_check_availability_Viator_test_16_30_21_1706113821.json', 'viator', '2024-01-24 04:30:27', '', '', '1133');
[01/24/2024 04:30:29], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 04:30:29' WHERE id= '309';
[01/24/2024 04:30:29], [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/02/14',  departure_date='2024/02/14',  nights='1',  create_date='2024-01-24 :16:30:29',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/24/2024 04:30:31], [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/24_01_2024/request_availability_Viator_test_16_30_29_1706113829.json', 'v1/24_01_2024/response_availability_Viator_test_16_30_29_1706113829.json', 'v1/24_01_2024/response_header_availability_Viator_test_16_30_29_1706113829.json', 'viator', '2024-01-24 04:30:31', '', '', '1134');
[01/24/2024 04:30:33], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 04:30:33' WHERE id= '309';
[01/24/2024 04:30:33], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 04:30:33' WHERE id= '309';
[01/24/2024 04:30:35], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 04:30:35' WHERE id= '309';
[01/24/2024 04:30:37], [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/24_01_2024/request_sight_details_Viator_test_16_30_35_1706113835.json', 'v1/24_01_2024/response_sight_details_Viator_test_16_30_35_1706113835.json', 'v1/24_01_2024/response_header_sight_details_Viator_test_16_30_35_1706113835.json', 'viator', '2024-01-24 04:30:37', '', '', '1134');
[01/24/2024 04:30:40], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 04:30:40' WHERE id= '309';
[01/24/2024 04:30: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 ('', 'check_availability', 'v1/24_01_2024/request_check_availability_Viator_test_16_30_40_1706113840.json', 'v1/24_01_2024/response_check_availability_Viator_test_16_30_40_1706113840.json', 'v1/24_01_2024/response_header_check_availability_Viator_test_16_30_40_1706113840.json', 'viator', '2024-01-24 04:30:41', '', '', '1134');
[01/24/2024 04:30:58], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 04:30:58' WHERE id= '309';
[01/24/2024 04:31: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 ('', 'check_availability', 'v1/24_01_2024/request_check_availability_Viator_test_16_30_58_1706113858.json', 'v1/24_01_2024/response_check_availability_Viator_test_16_30_58_1706113858.json', 'v1/24_01_2024/response_header_check_availability_Viator_test_16_30_58_1706113858.json', 'viator', '2024-01-24 04:31:01', '', '', '1134');
[01/24/2024 04:36:19], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 04:36:19' WHERE id= '309';
[01/24/2024 04:36: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/24_01_2024/request_check_availability_Viator_test_16_36_19_1706114179.json', 'v1/24_01_2024/response_check_availability_Viator_test_16_36_19_1706114179.json', 'v1/24_01_2024/response_header_check_availability_Viator_test_16_36_19_1706114179.json', 'viator', '2024-01-24 04:36:39', '', '', '1134');
[01/24/2024 04:37:31], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 04:37:31' WHERE id= '309';
[01/24/2024 04:37:31], [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/02/14',  departure_date='2024/02/14',  nights='1',  create_date='2024-01-24 :16:37:31',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/24/2024 04:37:51], [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/24_01_2024/request_availability_Viator_test_16_37_31_1706114251.json', 'v1/24_01_2024/response_availability_Viator_test_16_37_31_1706114251.json', 'v1/24_01_2024/response_header_availability_Viator_test_16_37_31_1706114251.json', 'viator', '2024-01-24 04:37:51', '', '', '1135');
[01/24/2024 04:37:51], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 04:37:51' WHERE id= '309';
[01/24/2024 04:38:46], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 04:38:46' WHERE id= '309';
[01/24/2024 04:38:46], [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/02/14',  departure_date='2024/02/14',  nights='1',  create_date='2024-01-24 :16:38:46',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/24/2024 04:39:03], [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/24_01_2024/request_availability_Viator_test_16_38_46_1706114326.json', 'v1/24_01_2024/response_availability_Viator_test_16_38_46_1706114326.json', 'v1/24_01_2024/response_header_availability_Viator_test_16_38_46_1706114326.json', 'viator', '2024-01-24 04:39:03', '', '', '1136');
[01/24/2024 04:39:05], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 04:39:05' WHERE id= '309';
[01/24/2024 04:39:05], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 04:39:05' WHERE id= '309';
[01/24/2024 04:39:07], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 04:39:07' WHERE id= '309';
[01/24/2024 04:39: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/24_01_2024/request_sight_details_Viator_test_16_39_07_1706114347.json', 'v1/24_01_2024/response_sight_details_Viator_test_16_39_07_1706114347.json', 'v1/24_01_2024/response_header_sight_details_Viator_test_16_39_07_1706114347.json', 'viator', '2024-01-24 04:39:07', '', '', '1136');
[01/24/2024 04:39:10], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 04:39:10' WHERE id= '309';
[01/24/2024 04:39: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 ('', 'check_availability', 'v1/24_01_2024/request_check_availability_Viator_test_16_39_10_1706114350.json', 'v1/24_01_2024/response_check_availability_Viator_test_16_39_10_1706114350.json', 'v1/24_01_2024/response_header_check_availability_Viator_test_16_39_10_1706114350.json', 'viator', '2024-01-24 04:39:11', '', '', '1136');
[01/24/2024 04:39:56], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 04:39:56' WHERE id= '309';
[01/24/2024 04:39: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 ('', 'check_availability', 'v1/24_01_2024/request_check_availability_Viator_test_16_39_56_1706114396.json', 'v1/24_01_2024/response_check_availability_Viator_test_16_39_56_1706114396.json', 'v1/24_01_2024/response_header_check_availability_Viator_test_16_39_56_1706114396.json', 'viator', '2024-01-24 04:39:57', '', '', '1136');
[01/24/2024 04:43:47], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 04:43:47' WHERE id= '309';
[01/24/2024 04:43: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 ('', 'check_availability', 'v1/24_01_2024/request_check_availability_Viator_test_16_43_47_1706114627.json', 'v1/24_01_2024/response_check_availability_Viator_test_16_43_47_1706114627.json', 'v1/24_01_2024/response_header_check_availability_Viator_test_16_43_47_1706114627.json', 'viator', '2024-01-24 04:43:48', '', '', '1136');
[01/24/2024 04:44:33], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 04:44:33' WHERE id= '309';
[01/24/2024 04:44: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 ('', 'check_availability', 'v1/24_01_2024/request_check_availability_Viator_test_16_44_33_1706114673.json', 'v1/24_01_2024/response_check_availability_Viator_test_16_44_33_1706114673.json', 'v1/24_01_2024/response_header_check_availability_Viator_test_16_44_33_1706114673.json', 'viator', '2024-01-24 04:44:34', '', '', '1136');
[01/24/2024 04:44:56], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 04:44:56' WHERE id= '309';
[01/24/2024 04:44:56], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-24 04:44:56',login_attempt=0 where id = '7851';
[01/24/2024 04:44:56], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Viator_test', user_type = 'A', branch_id = '27', login_datetime = '2024-01-24 16:44:56', ip = '43.239.53.130', action = 'Login' ;
[01/24/2024 04:44:57], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 04:44:57' WHERE id= '309';
[01/24/2024 04:45:01], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 04:45:01' WHERE id= '309';
[01/24/2024 04:45:05], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 04:45:05' WHERE id= '309';
[01/24/2024 04:45:11], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 04:45:11' WHERE id= '309';
[01/24/2024 04:45:11], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7851' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '27' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/02/20',  departure_date='2024/02/20',  nights='1',  create_date='2024-01-24 :16:45:11',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/24/2024 04:45:32], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'v1/24_01_2024/request_availability_Viator_test_16_45_11_1706114711.json', 'v1/24_01_2024/response_availability_Viator_test_16_45_11_1706114711.json', 'v1/24_01_2024/response_header_availability_Viator_test_16_45_11_1706114711.json', 'viator', '2024-01-24 04:45:32', '', '', '1137');
[01/24/2024 04:45:33], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 04:45:33' WHERE id= '309';
[01/24/2024 04:45:33], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 04:45:33' WHERE id= '309';
[01/24/2024 04:45:43], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 04:45:43' WHERE id= '309';
[01/24/2024 04:45:43], [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/24_01_2024/request_sight_details_Viator_test_16_45_43_1706114743.json', 'v1/24_01_2024/response_sight_details_Viator_test_16_45_43_1706114743.json', 'v1/24_01_2024/response_header_sight_details_Viator_test_16_45_43_1706114743.json', 'viator', '2024-01-24 04:45:43', '', '', '1137');
[01/24/2024 04:45:52], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 04:45:52' WHERE id= '309';
[01/24/2024 04:45: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 ('', 'check_availability', 'v1/24_01_2024/request_check_availability_Viator_test_16_45_52_1706114752.json', 'v1/24_01_2024/response_check_availability_Viator_test_16_45_52_1706114752.json', 'v1/24_01_2024/response_header_check_availability_Viator_test_16_45_52_1706114752.json', 'viator', '2024-01-24 04:45:53', '', '', '1137');
[01/24/2024 04:46:45], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 04:46:45' WHERE id= '309';
[01/24/2024 04:46: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/24_01_2024/request_check_availability_Viator_test_16_46_45_1706114805.json', 'v1/24_01_2024/response_check_availability_Viator_test_16_46_45_1706114805.json', 'v1/24_01_2024/response_header_check_availability_Viator_test_16_46_45_1706114805.json', 'viator', '2024-01-24 04:46:46', '', '', '1137');
[01/24/2024 04:46:48], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 04:46:48' WHERE id= '309';
[01/24/2024 04:46:48], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1706114808','43.239.53.130');
[01/24/2024 04:47:39], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 04:47:39' WHERE id= '309';
[01/24/2024 04:47:39], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1706114859','43.239.53.130');
[01/24/2024 04:48:44], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 04:48:44' WHERE id= '309';
[01/24/2024 04:48:44], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1706114924','43.239.53.130');
[01/24/2024 04:48:57], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 04:48:57' WHERE id= '309';
[01/24/2024 04:48:58], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 04:48:58' WHERE id= '309';
[01/24/2024 04:49:01], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 04:49:01' WHERE id= '309';
[01/24/2024 04:49:04], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 04:49:04' WHERE id= '309';
[01/24/2024 04:49:07], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 04:49:07' WHERE id= '309';
[01/24/2024 04:49:36], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 04:49:36' WHERE id= '309';
[01/24/2024 04:49:36], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1706114976','43.239.53.130');
[01/24/2024 04:49:36], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 04:49:36' WHERE id= '309';
[01/24/2024 04:49:36], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO bookings set reservation_id='2315',agent_id='7851',leader_title='Mr',leader_first_name='shiv',leader_last_name='chauhan',city_id='dubai',country_id='138',nationality='Emirati',display_room_rate='166.5',display_currency_code='USD',native_room_rate='166.5',consultant_id='SUJAY_QTECH',native_currency_code='USD',cancellation_policy='Cancellation Charges will be applicable if cancelled after 20 Feb 2024 00:00 hrs.<BR>Late amendment charge may apply.',current_status='inprocess-booking',booking_status='1',sales_manager_id='0',create_date='2024-01-24 16:49:36',source_type='viator',expiration_date= '2024-02-19 21: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='3.7507', booking_branch_id = '27',site_url = 'https://beta.astrabookings.com/',ip_addr='43.239.53.130',leader_phone=' 9823860012',email_id='shiv.chauhan@qtechsoftware.com',service_type='sightseeing';
[01/24/2024 04:49:36], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO sight_bookings set booking_id='364',native_nightly_rates='a:2:{s:4:\"size\";i:1;s:17:\"nativeNightlyRate\";d:166.5;}',rate_description='',display_nightly_rates='a:4:{s:4:\"size\";i:1;s:18:\"displayNightlyRate\";d:166.5;s:25:\"displayNightlyRateDisplay\";s:133:\"Rate - 166.5 USD, Currency Multiplier (USD-USD) - 1.00000, Markup  in % - %, Markup Amount - , Markup Amount in  - ,Other Markup - 0%\";s:23:\"displayNightlyRateStore\";s:134:\"Rate - 166.5 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- V2',tour_time='',tour_details='',tour_inclusive='<br/>',tour_exclusive='<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='2',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='';
[01/24/2024 04:49:36], [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','2315','2024-01-24 16:49:36',0);
[01/24/2024 04:49:38], [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/24_01_2024/request_reservation_sight_Viator_test_16_49_36_1706114976.json', 'v1/24_01_2024/response_reservation_sight_Viator_test_16_49_36_1706114976.json', 'v1/24_01_2024/response_header_reservation_sight_Viator_test_16_49_36_1706114976.json', 'viator', '2024-01-24 04:49:38', '', '', '1137');
[01/24/2024 04:49:38], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE posted_bookings set status=1 where id= '201';
[01/24/2024 04:49:38], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],update bookings set  parent_agent_id='7851', applicable_service_tax='0', sub_agent_rate='0', agent_rate='166.5', supplier_rate='166.5', uid='', itenirary_id='', confirmation_number='', comment_contract='', current_status='failed', original_source='' where id='364';
[01/24/2024 04:49:38], [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='364';
[01/24/2024 04:49:38], [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
		('','','364','failed','2024-01-24 16:49:38','Sightseeing Booking failed by Agent..7851','7851','43.239.53.130','','','');
[01/24/2024 04:49:38], [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('364','Mr','1','shiv','chauhan','adult','0');
[01/24/2024 04:49:38], [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('364','Mr','1','amit','mishra','adult','0');
[01/24/2024 04:49:38], [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('364','Master','1','rohan','abc','child','6');
[01/24/2024 04:49:38], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],update xmllogs set reservation_id='364' where agent_logs_id='1137' and source_type='viator';
[01/24/2024 04:49:59], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 04:49:59' WHERE id= '309';
[01/24/2024 04:49:59], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-24 04:49:59',login_attempt=0 where id = '7851';
[01/24/2024 04:49:59], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Viator_test', user_type = 'A', branch_id = '27', login_datetime = '2024-01-24 16:49:59', ip = '43.239.53.130', action = 'Login' ;
[01/24/2024 04:50:00], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 04:50:00' WHERE id= '309';
[01/24/2024 04:50:03], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 04:50:03' WHERE id= '309';
[01/24/2024 04:50:07], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 04:50:07' WHERE id= '309';
[01/24/2024 04:50:12], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 04:50:12' WHERE id= '309';
[01/24/2024 04:50:12], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7851' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '27' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/01/29',  departure_date='2024/01/29',  nights='1',  create_date='2024-01-24 :16:50:12',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/24/2024 04:50: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/24_01_2024/request_availability_Viator_test_16_50_12_1706115012.json', 'v1/24_01_2024/response_availability_Viator_test_16_50_12_1706115012.json', 'v1/24_01_2024/response_header_availability_Viator_test_16_50_12_1706115012.json', 'viator', '2024-01-24 04:50:13', '', '', '1138');
[01/24/2024 04:50:14], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 04:50:14' WHERE id= '309';
[01/24/2024 04:50:14], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 04:50:14' WHERE id= '309';
[01/24/2024 04:50:16], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 04:50:16' WHERE id= '309';
[01/24/2024 04:50: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/24_01_2024/request_sight_details_Viator_test_16_50_16_1706115016.json', 'v1/24_01_2024/response_sight_details_Viator_test_16_50_16_1706115016.json', 'v1/24_01_2024/response_header_sight_details_Viator_test_16_50_16_1706115016.json', 'viator', '2024-01-24 04:50:19', '', '', '1138');
[01/24/2024 04:50:22], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 04:50:22' WHERE id= '309';
[01/24/2024 04:50:22], [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/24_01_2024/request_sight_details_Viator_test_16_50_22_1706115022.json', 'v1/24_01_2024/response_sight_details_Viator_test_16_50_22_1706115022.json', 'v1/24_01_2024/response_header_sight_details_Viator_test_16_50_22_1706115022.json', 'viator', '2024-01-24 04:50:22', '', '', '1138');
[01/24/2024 04:50:25], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 04:50:25' WHERE id= '309';
[01/24/2024 04:50:37], [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/24_01_2024/request_check_availability_Viator_test_16_50_25_1706115025.json', 'v1/24_01_2024/response_check_availability_Viator_test_16_50_25_1706115025.json', 'v1/24_01_2024/response_header_check_availability_Viator_test_16_50_25_1706115025.json', 'viator', '2024-01-24 04:50:37', '', '', '1138');
[01/24/2024 04:50:42], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 04:50:42' WHERE id= '309';
[01/24/2024 04:50:42], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1706115042','43.239.53.130');
[01/24/2024 04:50:47], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 04:50:47' WHERE id= '309';
[01/24/2024 04:50:50], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 04:50:50' WHERE id= '309';
[01/24/2024 04:50:52], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 04:50:52' WHERE id= '309';
[01/24/2024 04:50:56], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 04:50:56' WHERE id= '309';
[01/24/2024 04:51:17], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 04:51:17' WHERE id= '309';
[01/24/2024 04:51:17], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1706115077','43.239.53.130');
[01/24/2024 04:51:18], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 04:51:18' WHERE id= '309';
[01/24/2024 04:51:18], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO bookings set reservation_id='2317',agent_id='7851',leader_title='Mr',leader_first_name='shiv',leader_last_name='chauhan',city_id='dubai',country_id='138',nationality='Emirati',display_room_rate='89.18',display_currency_code='USD',native_room_rate='89.18',consultant_id='SUJAY_QTECH',native_currency_code='USD',cancellation_policy='Cancellation Charges will be applicable if cancelled after 29 Jan 2024 00:00 hrs.<BR>Late amendment charge may apply.',current_status='inprocess-booking',booking_status='1',sales_manager_id='0',create_date='2024-01-24 16:51:18',source_type='viator',expiration_date= '2024-01-28 21: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-01-29',sub_user_id='',check_out_date='2024-01-29',supplier_profile_id='',agent_currency_multiplier='3.7507', booking_branch_id = '27',site_url = 'https://beta.astrabookings.com/',ip_addr='43.239.53.130',leader_phone=' 9823860012',email_id='shiv.chauhan@qtechsoftware.com',service_type='sightseeing';
[01/24/2024 04:51:18], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO sight_bookings set booking_id='365',native_nightly_rates='a:2:{s:4:\"size\";i:1;s:17:\"nativeNightlyRate\";d:89.180000000000007;}',rate_description='',display_nightly_rates='a:4:{s:4:\"size\";i:1;s:18:\"displayNightlyRate\";d:89.180000000000007;s:25:\"displayNightlyRateDisplay\";s:133:\"Rate - 89.18 USD, Currency Multiplier (USD-USD) - 1.00000, Markup  in % - %, Markup Amount - , Markup Amount in  - ,Other Markup - 0%\";s:23:\"displayNightlyRateStore\";s:134:\"Rate - 89.18 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='333273P2',sight_name='DUBAI LONG SELF-DRIVE QUADBIKE WITH CAMEL AND FALCON- V2',tour_time='',tour_details='',tour_inclusive='<br/>',tour_exclusive=',<br/>',meeting_point='',tour_dep_point=' ',tour_language='en/SERVICE_GUIDE',tour_supplier_phone='',additional_tour_dep_point='',tour_duration='4 hours 0 minutes<br> Start Time: 07:00',arrival_date='2024-01-29',total_adults='2',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='';
[01/24/2024 04:51:18], [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','2317','2024-01-24 16:51:18',0);
[01/24/2024 04:51:21], [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/24_01_2024/request_reservation_sight_Viator_test_16_51_18_1706115078.json', 'v1/24_01_2024/response_reservation_sight_Viator_test_16_51_18_1706115078.json', 'v1/24_01_2024/response_header_reservation_sight_Viator_test_16_51_18_1706115078.json', 'viator', '2024-01-24 04:51:21', '', '', '1138');
[01/24/2024 04:51:21], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE posted_bookings set status=1 where id= '202';
[01/24/2024 04:51:21], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],update bookings set  parent_agent_id='7851', applicable_service_tax='0', sub_agent_rate='0', agent_rate='89.18', supplier_rate='89.18', uid='', itenirary_id='2317136', confirmation_number='BR-595268729', comment_contract='', current_status='confirmed', original_source='' where id='365';
[01/24/2024 04:51:21], [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='365';
[01/24/2024 04:51:21], [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
		('','','365','confirmed','2024-01-24 16:51:21','Sightseeing Booking confirmed by Agent..7851','7851','43.239.53.130','','','');
[01/24/2024 04:51:21], [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('365','Mr','1','shiv','chauhan','adult','0');
[01/24/2024 04:51:21], [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('365','Mr','1','jai','praksh','adult','0');
[01/24/2024 04:51:21], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],update xmllogs set reservation_id='365' where agent_logs_id='1138' and source_type='viator';
[01/24/2024 04:51:36], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 04:51:36' WHERE id= '309';
[01/24/2024 04:51:43], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 04:51:43' WHERE id= '309';
[01/24/2024 04:51:46], [file name :-/home/otrams/public_html/beta/booking_list_sight.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 04:51:46' WHERE id= '309';
[01/24/2024 04:51:56], [file name :-/home/otrams/public_html/beta/get_cancellation_fee_sight.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 04:51:56' WHERE id= '309';
[01/24/2024 04:51:57], [file name :-/home/otrams/public_html/beta/get_cancellation_fee_sight.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header)
                    VALUE('365', 'sight_cancellation_fee', 'v1/24_01_2024/request_sight_cancellation_fee_Viator_test_365_16_51_56_1706115116.json', 'v1/24_01_2024/response_sight_cancellation_fee_Viator_test_365_16_51_56_1706115116.json', 'v1/24_01_2024/response_header_sight_cancellation_fee_Viator_test_365_16_51_56_1706115116.json', 'viator', '2024-01-24 04:51:57', '');
[01/24/2024 04:51:57], [file name :-/home/otrams/public_html/beta/get_cancellation_fee_sight.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header)
                    VALUE('365', 'sight_cancellation_reason', 'v1/24_01_2024/request_sight_cancellation_reason_Viator_test_365_16_51_57_1706115117.json', 'v1/24_01_2024/response_sight_cancellation_reason_Viator_test_365_16_51_57_1706115117.json', 'v1/24_01_2024/response_header_sight_cancellation_reason_Viator_test_365_16_51_57_1706115117.json', 'viator', '2024-01-24 04:51:57', '');
[01/24/2024 04:52:03], [file name :-/home/otrams/public_html/beta/booking_list_sight.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 04:52:03' WHERE id= '309';
[01/24/2024 04:52:06], [file name :-/home/otrams/public_html/beta/booking_list_sight.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header)
                    VALUE('365', 'sight_cancellation', 'v1/24_01_2024/request_sight_cancellation_Viator_test_365_16_52_03_1706115123.json', 'v1/24_01_2024/response_sight_cancellation_Viator_test_365_16_52_03_1706115123.json', 'v1/24_01_2024/response_header_sight_cancellation_Viator_test_365_16_52_03_1706115123.json', 'viator', '2024-01-24 04:52:06', '');
[01/24/2024 04:52:06], [file name :-/home/otrams/public_html/beta/booking_list_sight.php],INSERT INTO history_bookings set history_booking_id ='365', agent_id ='7851', itenirary_id ='2317136', confirmation_number ='BR-595268729', payment_confirmation_no ='', voucher_id ='', voucher_hashcode ='', email_id ='shiv.chauhan@qtechsoftware.com', leader_title ='Mr', leader_first_name ='shiv', leader_last_name ='chauhan', city_id ='dubai', country_id ='138', display_room_rate ='89.180', native_room_rate ='89.180', native_currency_code ='USD', additional_charge ='0.000', cancellation_policy ='Cancellation Charges will be applicable if cancelled after 29 Jan 2024 00:00 hrs.<BR>Late amendment charge may apply.', supplier_cancellation_policy ='', current_status ='confirmed', booking_status ='1', status_date ='0000-00-00 00:00:00', create_date ='2024-01-24 16:51:18', source_type ='viator', expiration_date ='2024-01-28 21:00:00', comment_contract ='', admin_note ='', is_payment_gateway ='0', service_type ='sightseeing', service_type_detail ='', native_rate ='', display_rate ='', agent_rate ='89.180', wh_sub_agent_rate ='0.000', wh_agent_rate ='0.000', supplier_rate ='89.180', special_comment ='', special_remark ='', sms_status ='', is_xml ='0', consultant_id ='SUJAY_QTECH', admin_booked ='0', emailed_status ='0', applied_multiplier ='1.00000', applied_markup ='0', wh_applied_markup ='0.000', original_voucher ='', subagent_markup ='', agent_markup ='0', wh_agent_markup ='0.000', basecurrency_multiplier ='1.00000', wh_basecurrency_multiplier ='1', basecurrency_multiplier_native ='1.00000', wh_basecurrency_multiplier_native ='1', agent_currency_multiplier ='3.7507', wh_agent_currency_multiplier ='1.000', modified_datetime ='2024-01-24 16:52:06', modified_by ='', display_currency_code ='USD', created_datetime ='2024-01-24 16:52:06', sub_agent_rate ='0.000', created_by ='Viator_test', site_id ='0', applicable_service_tax ='0.000', wh_parent_agent_id ='0', wh_agent_id ='0', nationality ='Emirati', ip_addr ='43.239.53.130', is_cancel_history ='1';
[01/24/2024 04:52:06], [file name :-/home/otrams/public_html/beta/booking_list_sight.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
		('','','365','cancelled','2024-01-24 16:52:06','','7851','43.239.53.130','','','');
[01/24/2024 04:52:06], [file name :-/home/otrams/public_html/beta/booking_list_sight.php],UPDATE bookings SET current_status='cancelled',status_date='2024-01-24 16:52:06' , pending_cancellation = 'no' WHERE reservation_id = '2317' AND id = '365' AND (current_status = 'pending' OR  current_status = 'confirmed' OR  current_status = 'vouchered' OR  current_status = 'on_request' OR  current_status = 'inprocess_cancel') ;
[01/24/2024 04:52:06], [file name :-/home/otrams/public_html/beta/booking_list_sight.php],update booking_commission set status='D'  where booking_id ='365';
[01/24/2024 04:52:06], [file name :-/home/otrams/public_html/beta/booking_list_sight.php],UPDATE bookings SET  agent_rate='0' , sub_agent_rate='0' , supplier_rate='0' , applicable_service_tax='0' WHERE id = '365' AND (current_status = 'cancelled' ) ;
[01/24/2024 04:52:06], [file name :-/home/otrams/public_html/beta/booking_list_sight.php],delete from cancellations where booking_id =? ;
[01/24/2024 04:52:06], [file name :-/home/otrams/public_html/beta/booking_list_sight.php],INSERT INTO cancellations (native_charge,display_charge,native_currency_code,display_currency_code,reservation_id,booking_id,cancellation_date,confirmation_no,note) values ('','0','USD','USD','2317','365','2024-01-24 16:52:06','','Confirmed charges. ');
[01/24/2024 04:52:14], [file name :-/home/otrams/public_html/beta/index.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 04:52:14' WHERE id= '309';
[01/24/2024 04:52:14], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 04:52:14' WHERE id= '309';
[01/24/2024 04:52:15], [file name :-/home/otrams/public_html/beta/booking_list_sight.php],UPDATE user_sessions_ip SET update_date = '2024-01-24 04:52:15' WHERE id= '309';
