[02/21/2024 10:00:58], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-02-21 10:00:58',login_attempt=0 where id = '7866';
[02/21/2024 10:00:58], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'deepak_qtech', user_type = 'A', branch_id = '31', login_datetime = '2024-02-21 10:00:58', ip = '43.239.53.130', action = 'Login' ;
[02/21/2024 10:00:59], [file name :-/home/otrams/public_html/beta/hotel_search.php],insert into user_sessions_ip SET ip_addr='43.239.53.130', agent_id='7867', session_id='3566a72f2d551d356c4061871d558cdacddf54c86a17bdeecc38922ec2c566d5',create_date='2024-02-21 10:00:59', update_date='2024-02-21 10:00:59',domain='hotelyards.astrabookings.com',sub_agent_id='',sub_user_id='';
[02/21/2024 10:01:04], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:01:04' WHERE id= '588';
[02/21/2024 10:01:09], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:01:09' WHERE id= '588';
[02/21/2024 10:01:10], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:01:10' WHERE id= '588';
[02/21/2024 10:01:12], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:01:12' WHERE id= '588';
[02/21/2024 10:01:33], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:01:33' WHERE id= '588';
[02/21/2024 10:01:37], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:01:37' WHERE id= '588';
[02/21/2024 10:01:45], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:01:45' WHERE id= '588';
[02/21/2024 10:02:28], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:02:28' WHERE id= '588';
[02/21/2024 10:02:40], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:02:40' WHERE id= '588';
[02/21/2024 10:03:07], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:03:07' WHERE id= '584';
[02/21/2024 10:03:08], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:03:08' WHERE id= '584';
[02/21/2024 10:03:08], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:03:08' WHERE id= '584';
[02/21/2024 10:03:17], [file name :-/home/otrams/public_html/beta/booking_list_flight.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:03:17' WHERE id= '587';
[02/21/2024 10:03:20], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:03:20' WHERE id= '587';
[02/21/2024 10:03:25], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:03:25' WHERE id= '587';
[02/21/2024 10:03:25], [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/04/30',  departure_date='2024/04/30',  nights='1',  create_date='2024-02-21 :10:03:25',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[02/21/2024 10:03:30], [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/21_02_2024/request_availability_shiv_qtech_10_03_25_1708509805.json', 'v1/21_02_2024/response_availability_shiv_qtech_10_03_25_1708509805.json', 'v1/21_02_2024/response_header_availability_shiv_qtech_10_03_25_1708509805.json', 'viator', '2024-02-21 10:03:30', '', '', '1704');
[02/21/2024 10:03:31], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:03:31' WHERE id= '587';
[02/21/2024 10:03:31], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:03:31' WHERE id= '587';
[02/21/2024 10:03:34], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:03:34' WHERE id= '587';
[02/21/2024 10:03: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/21_02_2024/request_sight_details_shiv_qtech_10_03_34_1708509814.json', 'v1/21_02_2024/response_sight_details_shiv_qtech_10_03_34_1708509814.json', 'v1/21_02_2024/response_header_sight_details_shiv_qtech_10_03_34_1708509814.json', 'viator', '2024-02-21 10:03:34', '', '', '1704');
[02/21/2024 10:03: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/21_02_2024/request_sight_details_shiv_qtech_10_03_34_1708509814.json', 'v1/21_02_2024/response_sight_details_shiv_qtech_10_03_34_1708509814.json', 'v1/21_02_2024/response_header_sight_details_shiv_qtech_10_03_34_1708509814.json', 'viator', '2024-02-21 10:03:34', '', '', '1704');
[02/21/2024 10:03:47], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:03:47' WHERE id= '587';
[02/21/2024 10:03:47], [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/21_02_2024/request_check_availability_shiv_qtech_10_03_47_1708509827.json', 'v1/21_02_2024/response_check_availability_shiv_qtech_10_03_47_1708509827.json', 'v1/21_02_2024/response_header_check_availability_shiv_qtech_10_03_47_1708509827.json', 'viator', '2024-02-21 10:03:47', '', '', '1704');
[02/21/2024 10:03:51], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:03:51' WHERE id= '587';
[02/21/2024 10:03:51], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1708509831','43.239.53.130');
[02/21/2024 10:04:16], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-02-21 10:04:16',login_attempt=0 where id = '7869';
[02/21/2024 10:04:16], [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-21 10:04:16', ip = '43.239.53.130', action = 'Login' ;
[02/21/2024 10:04:17], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:04:17' WHERE id= '582';
[02/21/2024 10:04:20], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:04:20' WHERE id= '582';
[02/21/2024 10:04:28], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:04:28' WHERE id= '582';
[02/21/2024 10:04:31], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:04:31' WHERE id= '582';
[02/21/2024 10:04:31], [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 = 'mumbai' , arrival_date='2024/02/21',  departure_date='2024/02/21',  nights='1',  create_date='2024-02-21 :10:04:31',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[02/21/2024 10:04: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/21_02_2024/request_availability_Viator_10_04_31_1708509871.json', 'v1/21_02_2024/response_availability_Viator_10_04_31_1708509871.json', 'v1/21_02_2024/response_header_availability_Viator_10_04_31_1708509871.json', 'viator', '2024-02-21 10:04:32', '', '', '1705');
[02/21/2024 10:04:33], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:04:33' WHERE id= '582';
[02/21/2024 10:04:33], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:04:33' WHERE id= '582';
[02/21/2024 10:04:36], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:04:36' WHERE id= '582';
[02/21/2024 10:04:36], [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/21_02_2024/request_sight_details_Viator_10_04_36_1708509876.json', 'v1/21_02_2024/response_sight_details_Viator_10_04_36_1708509876.json', 'v1/21_02_2024/response_header_sight_details_Viator_10_04_36_1708509876.json', 'viator', '2024-02-21 10:04:36', '', '', '1705');
[02/21/2024 10:04: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/21_02_2024/request_sight_details_Viator_10_04_36_1708509876.json', 'v1/21_02_2024/response_sight_details_Viator_10_04_36_1708509876.json', 'v1/21_02_2024/response_header_sight_details_Viator_10_04_36_1708509876.json', 'viator', '2024-02-21 10:04:37', '', '', '1705');
[02/21/2024 10:04:45], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:04:45' WHERE id= '582';
[02/21/2024 10:04: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/21_02_2024/request_sight_details_Viator_10_04_45_1708509885.json', 'v1/21_02_2024/response_sight_details_Viator_10_04_45_1708509885.json', 'v1/21_02_2024/response_header_sight_details_Viator_10_04_45_1708509885.json', 'viator', '2024-02-21 10:04:45', '', '', '1705');
[02/21/2024 10:04:48], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:04:48' WHERE id= '588';
[02/21/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/21_02_2024/request_sight_details_Viator_10_04_45_1708509885.json', 'v1/21_02_2024/response_sight_details_Viator_10_04_45_1708509885.json', 'v1/21_02_2024/response_header_sight_details_Viator_10_04_45_1708509885.json', 'viator', '2024-02-21 10:04:49', '', '', '1705');
[02/21/2024 10:04:52], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:04:52' WHERE id= '588';
[02/21/2024 10:05:06], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:05:06' WHERE id= '582';
[02/21/2024 10:05: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/21_02_2024/request_sight_details_Viator_10_05_06_1708509906.json', 'v1/21_02_2024/response_sight_details_Viator_10_05_06_1708509906.json', 'v1/21_02_2024/response_header_sight_details_Viator_10_05_06_1708509906.json', 'viator', '2024-02-21 10:05:07', '', '', '1705');
[02/21/2024 10:05:08], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:05:08' WHERE id= '584';
[02/21/2024 10:05: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/21_02_2024/request_sight_details_Viator_10_05_07_1708509907.json', 'v1/21_02_2024/response_sight_details_Viator_10_05_07_1708509907.json', 'v1/21_02_2024/response_header_sight_details_Viator_10_05_07_1708509907.json', 'viator', '2024-02-21 10:05:14', '', '', '1705');
[02/21/2024 10:05:21], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:05:21' WHERE id= '584';
[02/21/2024 10:05:21], [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 = 'suva' , arrival_date='2024/03/28',  departure_date='2024/03/28',  nights='1',  create_date='2024-02-21 :10:05:21',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[02/21/2024 10:05:21], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:05:21' WHERE id= '584';
[02/21/2024 10:05:25], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:05:25' WHERE id= '584';
[02/21/2024 10:05:25], [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 = 'suva' , arrival_date='2024/03/28',  departure_date='2024/03/28',  nights='1',  create_date='2024-02-21 :10:05:25',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[02/21/2024 10:05:25], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:05:25' WHERE id= '584';
[02/21/2024 10:05:30], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:05:30' WHERE id= '584';
[02/21/2024 10:05:30], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7851' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '27' , ip = '43.239.53.130' , city = 'suva' , arrival_date='2024/03/11',  departure_date='2024/03/11',  nights='1',  create_date='2024-02-21 :10:05:30',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[02/21/2024 10:05:30], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:05:30' WHERE id= '584';
[02/21/2024 10:05:30], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:05:30' WHERE id= '582';
[02/21/2024 10:05: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/21_02_2024/request_sight_details_Viator_10_05_30_1708509930.json', 'v1/21_02_2024/response_sight_details_Viator_10_05_30_1708509930.json', 'v1/21_02_2024/response_header_sight_details_Viator_10_05_30_1708509930.json', 'viator', '2024-02-21 10:05:30', '', '', '1705');
[02/21/2024 10:05:31], [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/21_02_2024/request_sight_details_Viator_10_05_30_1708509930.json', 'v1/21_02_2024/response_sight_details_Viator_10_05_30_1708509930.json', 'v1/21_02_2024/response_header_sight_details_Viator_10_05_30_1708509930.json', 'viator', '2024-02-21 10:05:31', '', '', '1705');
[02/21/2024 10:05:32], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:05:32' WHERE id= '588';
[02/21/2024 10:05:35], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:05:35' WHERE id= '584';
[02/21/2024 10:05:35], [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 = 'suva' , arrival_date='2024/03/11',  departure_date='2024/03/11',  nights='1',  create_date='2024-02-21 :10:05:35',  nationality='',  additional_markup='',  selected_currency='INR',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[02/21/2024 10:05:35], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:05:35' WHERE id= '584';
[02/21/2024 10:05:36], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:05:36' WHERE id= '582';
[02/21/2024 10:05:36], [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/21_02_2024/request_sight_details_Viator_10_05_36_1708509936.json', 'v1/21_02_2024/response_sight_details_Viator_10_05_36_1708509936.json', 'v1/21_02_2024/response_header_sight_details_Viator_10_05_36_1708509936.json', 'viator', '2024-02-21 10:05:36', '', '', '1705');
[02/21/2024 10:05:36], [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/21_02_2024/request_sight_details_Viator_10_05_36_1708509936.json', 'v1/21_02_2024/response_sight_details_Viator_10_05_36_1708509936.json', 'v1/21_02_2024/response_header_sight_details_Viator_10_05_36_1708509936.json', 'viator', '2024-02-21 10:05:36', '', '', '1705');
[02/21/2024 10:05:42], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:05:42' WHERE id= '584';
[02/21/2024 10:05:42], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7851' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '27' , ip = '43.239.53.130' , city = 'suva' , arrival_date='2024/02/28',  departure_date='2024/02/28',  nights='1',  create_date='2024-02-21 :10:05:42',  nationality='',  additional_markup='',  selected_currency='INR',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[02/21/2024 10:05:43], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:05:43' WHERE id= '584';
[02/21/2024 10:05:47], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:05:47' WHERE id= '584';
[02/21/2024 10:05:47], [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 = 'suva' , arrival_date='2024/02/28',  departure_date='2024/02/28',  nights='1',  create_date='2024-02-21 :10:05:47',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[02/21/2024 10:05:47], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:05:47' WHERE id= '584';
[02/21/2024 10:05:52], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:05:52' WHERE id= '584';
[02/21/2024 10:05:52], [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 = 'suva' , arrival_date='2024/04/30',  departure_date='2024/04/30',  nights='1',  create_date='2024-02-21 :10:05:52',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[02/21/2024 10:05:53], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:05:53' WHERE id= '584';
[02/21/2024 10:06:02], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:06:02' WHERE id= '587';
[02/21/2024 10:06:02], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1708509962','43.239.53.130');
[02/21/2024 10:06:03], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:06:03' WHERE id= '584';
[02/21/2024 10:06:11], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:06:11' WHERE id= '587';
[02/21/2024 10:06:43], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:06:43' WHERE id= '587';
[02/21/2024 10:06:43], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1708510003','43.239.53.130');
[02/21/2024 10:06:54], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:06:54' WHERE id= '587';
[02/21/2024 10:07:00], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:07:00' WHERE id= '588';
[02/21/2024 10:07:51], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:07:51' WHERE id= '582';
[02/21/2024 10:07:51], [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/21_02_2024/request_check_availability_Viator_10_07_51_1708510071.json', 'v1/21_02_2024/response_check_availability_Viator_10_07_51_1708510071.json', 'v1/21_02_2024/response_header_check_availability_Viator_10_07_51_1708510071.json', 'viator', '2024-02-21 10:07:51', '', '', '1705');
[02/21/2024 10:07:53], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:07:53' WHERE id= '584';
[02/21/2024 10:07:59], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:07:59' WHERE id= '584';
[02/21/2024 10:07:59], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7851' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '27' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/03/28',  departure_date='2024/03/28',  nights='1',  create_date='2024-02-21 :10:07:59',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[02/21/2024 10:08:06], [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/21_02_2024/request_availability_Viator_test_10_07_59_1708510079.json', 'v1/21_02_2024/response_availability_Viator_test_10_07_59_1708510079.json', 'v1/21_02_2024/response_header_availability_Viator_test_10_07_59_1708510079.json', 'viator', '2024-02-21 10:08:06', '', '', '1713');
[02/21/2024 10:08:08], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:08:08' WHERE id= '584';
[02/21/2024 10:08:08], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:08:08' WHERE id= '584';
[02/21/2024 10:08:22], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:08:22' WHERE id= '582';
[02/21/2024 10:08: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/21_02_2024/request_sight_details_Viator_10_08_22_1708510102.json', 'v1/21_02_2024/response_sight_details_Viator_10_08_22_1708510102.json', 'v1/21_02_2024/response_header_sight_details_Viator_10_08_22_1708510102.json', 'viator', '2024-02-21 10:08:22', '', '', '1705');
[02/21/2024 10:08: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/21_02_2024/request_sight_details_Viator_10_08_22_1708510102.json', 'v1/21_02_2024/response_sight_details_Viator_10_08_22_1708510102.json', 'v1/21_02_2024/response_header_sight_details_Viator_10_08_22_1708510102.json', 'viator', '2024-02-21 10:08:23', '', '', '1705');
[02/21/2024 10:08:34], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:08:34' WHERE id= '588';
[02/21/2024 10:08:56], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:08:56' WHERE id= '584';
[02/21/2024 10:08:56], [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/21_02_2024/request_sight_details_Viator_test_10_08_56_1708510136.json', 'v1/21_02_2024/response_sight_details_Viator_test_10_08_56_1708510136.json', 'v1/21_02_2024/response_header_sight_details_Viator_test_10_08_56_1708510136.json', 'viator', '2024-02-21 10:08:56', '', '', '1713');
[02/21/2024 10:08: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/21_02_2024/request_sight_details_Viator_test_10_08_56_1708510136.json', 'v1/21_02_2024/response_sight_details_Viator_test_10_08_56_1708510136.json', 'v1/21_02_2024/response_header_sight_details_Viator_test_10_08_56_1708510136.json', 'viator', '2024-02-21 10:08:57', '', '', '1713');
[02/21/2024 10:08:58], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:08:58' WHERE id= '588';
[02/21/2024 10:08:59], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:08:59' WHERE id= '587';
[02/21/2024 10:08:59], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1708510139','43.239.53.130');
[02/21/2024 10:09:04], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:09:04' WHERE id= '584';
[02/21/2024 10:09:04], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:09:04' WHERE id= '588';
[02/21/2024 10:09:04], [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/21_02_2024/request_check_availability_Viator_test_10_09_04_1708510144.json', 'v1/21_02_2024/response_check_availability_Viator_test_10_09_04_1708510144.json', 'v1/21_02_2024/response_header_check_availability_Viator_test_10_09_04_1708510144.json', 'viator', '2024-02-21 10:09:04', '', '', '1713');
[02/21/2024 10:09:09], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:09:09' WHERE id= '587';
[02/21/2024 10:09:27], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:09:27' WHERE id= '588';
[02/21/2024 10:09:45], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:09:45' WHERE id= '584';
[02/21/2024 10:09:45], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1708510185','43.239.53.130');
[02/21/2024 10:10:00], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:10:00' WHERE id= '584';
[02/21/2024 10:10:03], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:10:03' WHERE id= '584';
[02/21/2024 10:10:07], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:10:07' WHERE id= '584';
[02/21/2024 10:10:11], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:10:11' WHERE id= '584';
[02/21/2024 10:10:14], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:10:14' WHERE id= '584';
[02/21/2024 10:10:22], [file name :-/home/otrams/public_html/beta/index.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:10:22' WHERE id= '588';
[02/21/2024 10:10:22], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:10:22' WHERE id= '588';
[02/21/2024 10:10:27], [file name :-/home/otrams/public_html/beta/logout.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:10:27' WHERE id= '588';
[02/21/2024 10:10:43], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:10:43' WHERE id= '584';
[02/21/2024 10:10:43], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1708510243','43.239.53.130');
[02/21/2024 10:10:44], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:10:44' WHERE id= '584';
[02/21/2024 10:10:44], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO bookings set reservation_id='3037',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='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 26 Mar 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 26 Mar 2024 at 03:00 hrs',current_status='inprocess-booking',booking_status='1',sales_manager_id='0',create_date='2024-02-21 10:10:44',source_type='viator',expiration_date= '2024-03-26 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-03-28',sub_user_id='',check_out_date='2024-03-28',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';
[02/21/2024 10:10:44], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO sight_bookings set booking_id='477',native_nightly_rates='a:2:{s:4:\"size\";i:1;s:17:\"nativeNightlyRate\";d:161.03;}',rate_description='',display_nightly_rates='a:4:{s:4:\"size\";i:1;s:18:\"displayNightlyRate\";d:161.03;s:25:\"displayNightlyRateDisplay\";s:134:\"Rate - 161.03 USD, Currency Multiplier (USD-USD) - 1.00000, Markup  in % - %, Markup Amount - , Markup Amount in  - ,Other Markup - 0%\";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 - V2',tour_time='',tour_details='',tour_inclusive='B<br/>',tour_exclusive='E<br/>',meeting_point='',tour_dep_point=' ',tour_language='en/SERVICE_GUIDE',tour_supplier_phone='',additional_tour_dep_point='',tour_duration='10 hours 0 minutes<br> Start Time: 11:00',arrival_date='2024-03-28',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/21/2024 10:10:44], [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','3037','2024-02-21 10:10:44',0);
[02/21/2024 10:10:44], [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/21_02_2024/request_reservation_sight_Viator_test_10_10_44_1708510244.json', 'v1/21_02_2024/response_reservation_sight_Viator_test_10_10_44_1708510244.json', 'v1/21_02_2024/response_header_reservation_sight_Viator_test_10_10_44_1708510244.json', 'viator', '2024-02-21 10:10:44', '', '', '1713');
[02/21/2024 10:10:44], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE posted_bookings set status=1 where id= '292';
[02/21/2024 10:10:44], [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='161.03', supplier_rate='161.03', uid='', itenirary_id='', confirmation_number='', comment_contract='', current_status='failed', original_source='' where id='477';
[02/21/2024 10:10:44], [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='477';
[02/21/2024 10:10:44], [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
		('','','477','failed','2024-02-21 10:10:44','Sightseeing Booking failed by Agent..7851','7851','43.239.53.130','','','');
[02/21/2024 10:10:44], [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('477','Mr','1','Shiv','Chauhan','adult','0');
[02/21/2024 10:10:44], [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('477','Mr','1','Joy','Beck','adult','0');
[02/21/2024 10:10:44], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],update xmllogs set reservation_id='477' where agent_logs_id='1713' and source_type='viator';
[02/21/2024 10:10:46], [file name :-/home/otrams/public_html/beta/tms/logout.php],INSERT INTO psa_login_log set username = 'Ayman' , user_type = 'Ayman'_type , branch_id = '31' , login_datetime = '2024-02-21 10:10:46' , ip = '43.239.53.130' , action = 'Logout'  ;
[02/21/2024 10:12:25], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-02-21 10:12:25',login_attempt=0 where id = '7870';
[02/21/2024 10:12:25], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'hotelyards-agent', user_type = 'A', branch_id = '32', login_datetime = '2024-02-21 10:12:25', ip = '43.239.53.130', action = 'Login' ;
[02/21/2024 10:12:26], [file name :-/home/otrams/public_html/beta/hotel_search.php],insert into user_sessions_ip SET ip_addr='43.239.53.130', agent_id='7867', session_id='f5727ef0063a5e0a9e92ecf18020b78ee88d2a6ee5d9f1ff551b25e464656f3a',create_date='2024-02-21 10:12:26', update_date='2024-02-21 10:12:26',domain='hotelyards.astrabookings.com',sub_agent_id='',sub_user_id='';
[02/21/2024 10:12:31], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:12:31' WHERE id= '584';
[02/21/2024 10:12:37], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:12:37' WHERE id= '584';
[02/21/2024 10:12:37], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7851' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '27' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/03/28',  departure_date='2024/03/28',  nights='1',  create_date='2024-02-21 :10:12:37',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[02/21/2024 10:13:05], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:13:05' WHERE id= '589';
[02/21/2024 10:13:07], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:13:07' WHERE id= '584';
[02/21/2024 10:13:12], [file name :-/home/otrams/public_html/beta/my_accounts.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:13:12' WHERE id= '589';
[02/21/2024 10:13:16], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:13:16' WHERE id= '589';
[02/21/2024 10:13:19], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:13:19' WHERE id= '589';
[02/21/2024 10:13:20], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:13:20' WHERE id= '584';
[02/21/2024 10:13:24], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:13:24' WHERE id= '584';
[02/21/2024 10:13:24], [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/30',  departure_date='2024/03/30',  nights='1',  create_date='2024-02-21 :10:13:24',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[02/21/2024 10:13:29], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'v1/21_02_2024/request_availability_Viator_test_10_13_24_1708510404.json', 'v1/21_02_2024/response_availability_Viator_test_10_13_24_1708510404.json', 'v1/21_02_2024/response_header_availability_Viator_test_10_13_24_1708510404.json', 'viator', '2024-02-21 10:13:29', '', '', '1715');
[02/21/2024 10:13:30], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:13:30' WHERE id= '584';
[02/21/2024 10:13:31], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:13:31' WHERE id= '584';
[02/21/2024 10:13:32], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:13:32' WHERE id= '589';
[02/21/2024 10:13:52], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:13:52' WHERE id= '589';
[02/21/2024 10:13:55], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:13:55' WHERE id= '589';
[02/21/2024 10:13:56], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:13:56' WHERE id= '589';
[02/21/2024 10:14:26], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:14:26' WHERE id= '587';
[02/21/2024 10:14:26], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1708510466','43.239.53.130');
[02/21/2024 10:14:27], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:14:27' WHERE id= '589';
[02/21/2024 10:14:36], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:14:36' WHERE id= '589';
[02/21/2024 10:14:49], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:14:49' WHERE id= '587';
[02/21/2024 10:14:49], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1708510489','43.239.53.130');
[02/21/2024 10:14:58], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:14:58' WHERE id= '587';
[02/21/2024 10:15:05], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:15:05' WHERE id= '584';
[02/21/2024 10:15: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/21_02_2024/request_sight_details_Viator_test_10_15_05_1708510505.json', 'v1/21_02_2024/response_sight_details_Viator_test_10_15_05_1708510505.json', 'v1/21_02_2024/response_header_sight_details_Viator_test_10_15_05_1708510505.json', 'viator', '2024-02-21 10:15:06', '', '', '1715');
[02/21/2024 10:15: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/21_02_2024/request_sight_details_Viator_test_10_15_06_1708510506.json', 'v1/21_02_2024/response_sight_details_Viator_test_10_15_06_1708510506.json', 'v1/21_02_2024/response_header_sight_details_Viator_test_10_15_06_1708510506.json', 'viator', '2024-02-21 10:15:06', '', '', '1715');
[02/21/2024 10:15:13], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:15:13' WHERE id= '584';
[02/21/2024 10:15: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/21_02_2024/request_sight_details_Viator_test_10_15_13_1708510513.json', 'v1/21_02_2024/response_sight_details_Viator_test_10_15_13_1708510513.json', 'v1/21_02_2024/response_header_sight_details_Viator_test_10_15_13_1708510513.json', 'viator', '2024-02-21 10:15:13', '', '', '1715');
[02/21/2024 10:15: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/21_02_2024/request_sight_details_Viator_test_10_15_13_1708510513.json', 'v1/21_02_2024/response_sight_details_Viator_test_10_15_13_1708510513.json', 'v1/21_02_2024/response_header_sight_details_Viator_test_10_15_13_1708510513.json', 'viator', '2024-02-21 10:15:14', '', '', '1715');
[02/21/2024 10:15:21], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:15:21' WHERE id= '584';
[02/21/2024 10:15: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 ('', 'check_availability', 'v1/21_02_2024/request_check_availability_Viator_test_10_15_21_1708510521.json', 'v1/21_02_2024/response_check_availability_Viator_test_10_15_21_1708510521.json', 'v1/21_02_2024/response_header_check_availability_Viator_test_10_15_21_1708510521.json', 'viator', '2024-02-21 10:15:22', '', '', '1715');
[02/21/2024 10:15:24], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:15:24' WHERE id= '584';
[02/21/2024 10:15:24], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1708510524','43.239.53.130');
[02/21/2024 10:15:37], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:15:37' WHERE id= '584';
[02/21/2024 10:15:39], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:15:39' WHERE id= '584';
[02/21/2024 10:15:39], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:15:39' WHERE id= '584';
[02/21/2024 10:15:47], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:15:47' WHERE id= '589';
[02/21/2024 10:15:50], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:15:50' WHERE id= '589';
[02/21/2024 10:15:53], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:15:53' WHERE id= '589';
[02/21/2024 10:16:23], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:16:23' WHERE id= '587';
[02/21/2024 10:16:23], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1708510583','43.239.53.130');
[02/21/2024 10:16:35], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:16:35' WHERE id= '589';
[02/21/2024 10:16:42], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:16:42' WHERE id= '589';
[02/21/2024 10:16:48], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:16:48' WHERE id= '589';
[02/21/2024 10:17:04], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:17:04' WHERE id= '587';
[02/21/2024 10:17:04], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1708510624','43.239.53.130');
[02/21/2024 10:17:09], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:17:09' WHERE id= '587';
[02/21/2024 10:17:25], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:17:25' WHERE id= '589';
[02/21/2024 10:17:27], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:17:27' WHERE id= '589';
[02/21/2024 10:17:32], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:17:32' WHERE id= '589';
[02/21/2024 10:17:37], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:17:37' WHERE id= '589';
[02/21/2024 10:18:27], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:18:27' WHERE id= '589';
[02/21/2024 10:18:32], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:18:32' WHERE id= '589';
[02/21/2024 10:18:44], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:18:44' WHERE id= '589';
[02/21/2024 10:19:48], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:19:48' WHERE id= '589';
[02/21/2024 10:19:57], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:19:57' WHERE id= '589';
[02/21/2024 10:20:02], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:20:02' WHERE id= '589';
[02/21/2024 10:20:22], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:20:22' WHERE id= '589';
[02/21/2024 10:20:26], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:20:26' WHERE id= '589';
[02/21/2024 10:24:02], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:24:02' WHERE id= '589';
[02/21/2024 10:24:09], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:24:09' WHERE id= '589';
[02/21/2024 10:24:11], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:24:11' WHERE id= '589';
[02/21/2024 10:24:20], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:24:20' WHERE id= '589';
[02/21/2024 10:25:39], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:25:39' WHERE id= '584';
[02/21/2024 10:25: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/21_02_2024/request_sight_details_Viator_test_10_25_39_1708511139.json', 'v1/21_02_2024/response_sight_details_Viator_test_10_25_39_1708511139.json', 'v1/21_02_2024/response_header_sight_details_Viator_test_10_25_39_1708511139.json', 'viator', '2024-02-21 10:25:40', '', '', '1715');
[02/21/2024 10:25: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/21_02_2024/request_sight_details_Viator_test_10_25_40_1708511140.json', 'v1/21_02_2024/response_sight_details_Viator_test_10_25_40_1708511140.json', 'v1/21_02_2024/response_header_sight_details_Viator_test_10_25_40_1708511140.json', 'viator', '2024-02-21 10:25:40', '', '', '1715');
[02/21/2024 10:27:49], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:27:49' WHERE id= '589';
[02/21/2024 10:27:54], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:27:54' WHERE id= '589';
[02/21/2024 10:27:56], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:27:56' WHERE id= '589';
[02/21/2024 10:28:12], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:28:12' WHERE id= '589';
[02/21/2024 10:28:16], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:28:16' WHERE id= '589';
[02/21/2024 10:28:21], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:28:21' WHERE id= '589';
[02/21/2024 10:31:31], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:31:31' WHERE id= '589';
[02/21/2024 10:31:35], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:31:35' WHERE id= '589';
[02/21/2024 10:31:37], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:31:37' WHERE id= '589';
[02/21/2024 10:31:42], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:31:42' WHERE id= '589';
[02/21/2024 10:32:30], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:32:30' WHERE id= '589';
[02/21/2024 10:32:37], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:32:37' WHERE id= '584';
[02/21/2024 10:32: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/21_02_2024/request_sight_details_Viator_test_10_32_37_1708511557.json', 'v1/21_02_2024/response_sight_details_Viator_test_10_32_37_1708511557.json', 'v1/21_02_2024/response_header_sight_details_Viator_test_10_32_37_1708511557.json', 'viator', '2024-02-21 10:32:38', '', '', '1715');
[02/21/2024 10:32: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/21_02_2024/request_sight_details_Viator_test_10_32_38_1708511558.json', 'v1/21_02_2024/response_sight_details_Viator_test_10_32_38_1708511558.json', 'v1/21_02_2024/response_header_sight_details_Viator_test_10_32_38_1708511558.json', 'viator', '2024-02-21 10:32:38', '', '', '1715');
[02/21/2024 10:32:44], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:32:44' WHERE id= '584';
[02/21/2024 10:32: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 ('', 'check_availability', 'v1/21_02_2024/request_check_availability_Viator_test_10_32_44_1708511564.json', 'v1/21_02_2024/response_check_availability_Viator_test_10_32_44_1708511564.json', 'v1/21_02_2024/response_header_check_availability_Viator_test_10_32_44_1708511564.json', 'viator', '2024-02-21 10:32:45', '', '', '1715');
[02/21/2024 10:32:51], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:32:51' WHERE id= '584';
[02/21/2024 10:32:51], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1708511571','43.239.53.130');
[02/21/2024 10:33:18], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:33:18' WHERE id= '584';
[02/21/2024 10:33:19], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:33:19' WHERE id= '584';
[02/21/2024 10:33:19], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:33:19' WHERE id= '584';
[02/21/2024 10:33:47], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:33:47' WHERE id= '584';
[02/21/2024 10:33:47], [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/21_02_2024/request_sight_details_Viator_test_10_33_47_1708511627.json', 'v1/21_02_2024/response_sight_details_Viator_test_10_33_47_1708511627.json', 'v1/21_02_2024/response_header_sight_details_Viator_test_10_33_47_1708511627.json', 'viator', '2024-02-21 10:33:47', '', '', '1715');
[02/21/2024 10:33:47], [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/21_02_2024/request_sight_details_Viator_test_10_33_47_1708511627.json', 'v1/21_02_2024/response_sight_details_Viator_test_10_33_47_1708511627.json', 'v1/21_02_2024/response_header_sight_details_Viator_test_10_33_47_1708511627.json', 'viator', '2024-02-21 10:33:47', '', '', '1715');
[02/21/2024 10:34:12], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:34:12' WHERE id= '584';
[02/21/2024 10:34: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/03/04',  departure_date='2024/03/04',  nights='1',  create_date='2024-02-21 :10:34:12',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[02/21/2024 10:34: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/21_02_2024/request_availability_Viator_test_10_34_12_1708511652.json', 'v1/21_02_2024/response_availability_Viator_test_10_34_12_1708511652.json', 'v1/21_02_2024/response_header_availability_Viator_test_10_34_12_1708511652.json', 'viator', '2024-02-21 10:34:14', '', '', '1716');
[02/21/2024 10:34:15], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:34:15' WHERE id= '584';
[02/21/2024 10:34:15], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:34:15' WHERE id= '584';
[02/21/2024 10:34:17], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:34:17' WHERE id= '584';
[02/21/2024 10:34: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/21_02_2024/request_sight_details_Viator_test_10_34_17_1708511657.json', 'v1/21_02_2024/response_sight_details_Viator_test_10_34_17_1708511657.json', 'v1/21_02_2024/response_header_sight_details_Viator_test_10_34_17_1708511657.json', 'viator', '2024-02-21 10:34:18', '', '', '1716');
[02/21/2024 10:34: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/21_02_2024/request_sight_details_Viator_test_10_34_18_1708511658.json', 'v1/21_02_2024/response_sight_details_Viator_test_10_34_18_1708511658.json', 'v1/21_02_2024/response_header_sight_details_Viator_test_10_34_18_1708511658.json', 'viator', '2024-02-21 10:34:18', '', '', '1716');
[02/21/2024 10:34:20], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:34:20' WHERE id= '584';
[02/21/2024 10:34: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/21_02_2024/request_sight_details_Viator_test_10_34_20_1708511660.json', 'v1/21_02_2024/response_sight_details_Viator_test_10_34_20_1708511660.json', 'v1/21_02_2024/response_header_sight_details_Viator_test_10_34_20_1708511660.json', 'viator', '2024-02-21 10:34:21', '', '', '1716');
[02/21/2024 10:34: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/21_02_2024/request_sight_details_Viator_test_10_34_21_1708511661.json', 'v1/21_02_2024/response_sight_details_Viator_test_10_34_21_1708511661.json', 'v1/21_02_2024/response_header_sight_details_Viator_test_10_34_21_1708511661.json', 'viator', '2024-02-21 10:34:21', '', '', '1716');
[02/21/2024 10:34:27], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:34:27' WHERE id= '584';
[02/21/2024 10:34: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/21_02_2024/request_check_availability_Viator_test_10_34_27_1708511667.json', 'v1/21_02_2024/response_check_availability_Viator_test_10_34_27_1708511667.json', 'v1/21_02_2024/response_header_check_availability_Viator_test_10_34_27_1708511667.json', 'viator', '2024-02-21 10:34:27', '', '', '1716');
[02/21/2024 10:34:50], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:34:50' WHERE id= '584';
[02/21/2024 10:34:50], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1708511690','43.239.53.130');
[02/21/2024 10:35:10], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:35:10' WHERE id= '589';
[02/21/2024 10:35:11], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:35:11' WHERE id= '589';
[02/21/2024 10:35:13], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:35:13' WHERE id= '584';
[02/21/2024 10:35:14], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:35:14' WHERE id= '589';
[02/21/2024 10:35:15], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:35:15' WHERE id= '584';
[02/21/2024 10:35:15], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:35:15' WHERE id= '584';
[02/21/2024 10:35:19], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:35:19' WHERE id= '589';
[02/21/2024 10:35:25], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:35:25' WHERE id= '589';
[02/21/2024 10:35:25], [file name :-/home/otrams/public_html/beta/booking_list.php],update messages set mssg_status='R' where booking_id=?;
[02/21/2024 10:35:39], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:35:39' WHERE id= '584';
[02/21/2024 10:35:39], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7851' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '27' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/02/28',  departure_date='2024/02/28',  nights='1',  create_date='2024-02-21 :10:35:39',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[02/21/2024 10:35:39], [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/21_02_2024/request_availability_Viator_test_10_35_39_1708511739.json', 'v1/21_02_2024/response_availability_Viator_test_10_35_39_1708511739.json', 'v1/21_02_2024/response_header_availability_Viator_test_10_35_39_1708511739.json', 'viator', '2024-02-21 10:35:39', '', '', '1717');
[02/21/2024 10:35:41], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:35:41' WHERE id= '584';
[02/21/2024 10:35:41], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:35:41' WHERE id= '584';
[02/21/2024 10:35:56], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:35:56' WHERE id= '584';
[02/21/2024 10:35:56], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:35:56' WHERE id= '584';
[02/21/2024 10:36:04], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:36:04' WHERE id= '584';
[02/21/2024 10:36:04], [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/21_02_2024/request_sight_details_Viator_test_10_36_04_1708511764.json', 'v1/21_02_2024/response_sight_details_Viator_test_10_36_04_1708511764.json', 'v1/21_02_2024/response_header_sight_details_Viator_test_10_36_04_1708511764.json', 'viator', '2024-02-21 10:36:04', '', '', '1717');
[02/21/2024 10:36: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/21_02_2024/request_sight_details_Viator_test_10_36_04_1708511764.json', 'v1/21_02_2024/response_sight_details_Viator_test_10_36_04_1708511764.json', 'v1/21_02_2024/response_header_sight_details_Viator_test_10_36_04_1708511764.json', 'viator', '2024-02-21 10:36:05', '', '', '1717');
[02/21/2024 10:36:07], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:36:07' WHERE id= '584';
[02/21/2024 10:36:08], [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/21_02_2024/request_check_availability_Viator_test_10_36_07_1708511767.json', 'v1/21_02_2024/response_check_availability_Viator_test_10_36_07_1708511767.json', 'v1/21_02_2024/response_header_check_availability_Viator_test_10_36_07_1708511767.json', 'viator', '2024-02-21 10:36:08', '', '', '1717');
[02/21/2024 10:36:14], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:36:14' WHERE id= '584';
[02/21/2024 10:36:14], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1708511774','43.239.53.130');
[02/21/2024 10:36:28], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:36:28' WHERE id= '584';
[02/21/2024 10:36:29], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:36:29' WHERE id= '584';
[02/21/2024 10:36:29], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:36:29' WHERE id= '584';
[02/21/2024 10:36:36], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:36:36' WHERE id= '584';
[02/21/2024 10:36:36], [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/21_02_2024/request_sight_details_Viator_test_10_36_36_1708511796.json', 'v1/21_02_2024/response_sight_details_Viator_test_10_36_36_1708511796.json', 'v1/21_02_2024/response_header_sight_details_Viator_test_10_36_36_1708511796.json', 'viator', '2024-02-21 10:36:36', '', '', '1717');
[02/21/2024 10:36:36], [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/21_02_2024/request_sight_details_Viator_test_10_36_36_1708511796.json', 'v1/21_02_2024/response_sight_details_Viator_test_10_36_36_1708511796.json', 'v1/21_02_2024/response_header_sight_details_Viator_test_10_36_36_1708511796.json', 'viator', '2024-02-21 10:36:36', '', '', '1717');
[02/21/2024 10:36:41], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:36:41' WHERE id= '584';
[02/21/2024 10:36: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/21_02_2024/request_check_availability_Viator_test_10_36_41_1708511801.json', 'v1/21_02_2024/response_check_availability_Viator_test_10_36_41_1708511801.json', 'v1/21_02_2024/response_header_check_availability_Viator_test_10_36_41_1708511801.json', 'viator', '2024-02-21 10:36:41', '', '', '1717');
[02/21/2024 10:36:51], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:36:51' WHERE id= '584';
[02/21/2024 10:36:51], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1708511811','43.239.53.130');
[02/21/2024 10:36:57], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:36:57' WHERE id= '584';
[02/21/2024 10:36:58], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:36:58' WHERE id= '584';
[02/21/2024 10:36:58], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:36:58' WHERE id= '584';
[02/21/2024 10:37:11], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:37:11' WHERE id= '584';
[02/21/2024 10:37: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/21_02_2024/request_sight_details_Viator_test_10_37_11_1708511831.json', 'v1/21_02_2024/response_sight_details_Viator_test_10_37_11_1708511831.json', 'v1/21_02_2024/response_header_sight_details_Viator_test_10_37_11_1708511831.json', 'viator', '2024-02-21 10:37:11', '', '', '1717');
[02/21/2024 10:37: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/21_02_2024/request_sight_details_Viator_test_10_37_11_1708511831.json', 'v1/21_02_2024/response_sight_details_Viator_test_10_37_11_1708511831.json', 'v1/21_02_2024/response_header_sight_details_Viator_test_10_37_11_1708511831.json', 'viator', '2024-02-21 10:37:11', '', '', '1717');
[02/21/2024 10:37:13], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:37:13' WHERE id= '584';
[02/21/2024 10:37: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 ('', 'check_availability', 'v1/21_02_2024/request_check_availability_Viator_test_10_37_13_1708511833.json', 'v1/21_02_2024/response_check_availability_Viator_test_10_37_13_1708511833.json', 'v1/21_02_2024/response_header_check_availability_Viator_test_10_37_13_1708511833.json', 'viator', '2024-02-21 10:37:14', '', '', '1717');
[02/21/2024 10:37:21], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:37:21' WHERE id= '584';
[02/21/2024 10:37:21], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1708511841','43.239.53.130');
[02/21/2024 10:37:55], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:37:55' WHERE id= '584';
[02/21/2024 10:37:56], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:37:56' WHERE id= '584';
[02/21/2024 10:37:56], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:37:56' WHERE id= '584';
[02/21/2024 10:38:02], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:38:02' WHERE id= '589';
[02/21/2024 10:38:02], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-02-21 10:38:02',login_attempt=0 where id = '7870';
[02/21/2024 10:38:09], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:38:09' WHERE id= '584';
[02/21/2024 10:38:09], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:38:09' WHERE id= '584';
[02/21/2024 10:38:15], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:38:15' WHERE id= '584';
[02/21/2024 10:38:15], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:38:15' WHERE id= '584';
[02/21/2024 10:38:32], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:38:32' WHERE id= '584';
[02/21/2024 10:38:32], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7851' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '27' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/04/30',  departure_date='2024/04/30',  nights='1',  create_date='2024-02-21 :10:38:32',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[02/21/2024 10:38:34], [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/21_02_2024/request_availability_Viator_test_10_38_32_1708511912.json', 'v1/21_02_2024/response_availability_Viator_test_10_38_32_1708511912.json', 'v1/21_02_2024/response_header_availability_Viator_test_10_38_32_1708511912.json', 'viator', '2024-02-21 10:38:34', '', '', '1718');
[02/21/2024 10:38:35], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:38:35' WHERE id= '584';
[02/21/2024 10:38:35], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:38:35' WHERE id= '584';
[02/21/2024 10:39:05], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-02-21 10:39:05',login_attempt=0 where id = '7870';
[02/21/2024 10:39:10], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:39:10' WHERE id= '584';
[02/21/2024 10:39: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/21_02_2024/request_sight_details_Viator_test_10_39_10_1708511950.json', 'v1/21_02_2024/response_sight_details_Viator_test_10_39_10_1708511950.json', 'v1/21_02_2024/response_header_sight_details_Viator_test_10_39_10_1708511950.json', 'viator', '2024-02-21 10:39:10', '', '', '1718');
[02/21/2024 10:39: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/21_02_2024/request_sight_details_Viator_test_10_39_10_1708511950.json', 'v1/21_02_2024/response_sight_details_Viator_test_10_39_10_1708511950.json', 'v1/21_02_2024/response_header_sight_details_Viator_test_10_39_10_1708511950.json', 'viator', '2024-02-21 10:39:10', '', '', '1718');
[02/21/2024 10:39:14], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:39:14' WHERE id= '584';
[02/21/2024 10:39: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/21_02_2024/request_sight_details_Viator_test_10_39_14_1708511954.json', 'v1/21_02_2024/response_sight_details_Viator_test_10_39_14_1708511954.json', 'v1/21_02_2024/response_header_sight_details_Viator_test_10_39_14_1708511954.json', 'viator', '2024-02-21 10:39:14', '', '', '1718');
[02/21/2024 10:39:15], [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/21_02_2024/request_sight_details_Viator_test_10_39_14_1708511954.json', 'v1/21_02_2024/response_sight_details_Viator_test_10_39_14_1708511954.json', 'v1/21_02_2024/response_header_sight_details_Viator_test_10_39_14_1708511954.json', 'viator', '2024-02-21 10:39:15', '', '', '1718');
[02/21/2024 10:39:17], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:39:17' WHERE id= '584';
[02/21/2024 10:39: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/21_02_2024/request_check_availability_Viator_test_10_39_17_1708511957.json', 'v1/21_02_2024/response_check_availability_Viator_test_10_39_17_1708511957.json', 'v1/21_02_2024/response_header_check_availability_Viator_test_10_39_17_1708511957.json', 'viator', '2024-02-21 10:39:18', '', '', '1718');
[02/21/2024 10:39:25], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:39:25' WHERE id= '584';
[02/21/2024 10:39:25], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1708511965','43.239.53.130');
[02/21/2024 10:39:27], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-02-21 10:39:27',login_attempt=0 where id = '7870';
[02/21/2024 10:39:32], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-02-21 10:39:32',login_attempt=0 where id = '7870';
[02/21/2024 10:39:33], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:39:33' WHERE id= '584';
[02/21/2024 10:39:35], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:39:35' WHERE id= '584';
[02/21/2024 10:39:35], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:39:35' WHERE id= '584';
[02/21/2024 10:39:39], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:39:39' WHERE id= '584';
[02/21/2024 10:39: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/21_02_2024/request_sight_details_Viator_test_10_39_39_1708511979.json', 'v1/21_02_2024/response_sight_details_Viator_test_10_39_39_1708511979.json', 'v1/21_02_2024/response_header_sight_details_Viator_test_10_39_39_1708511979.json', 'viator', '2024-02-21 10:39:40', '', '', '1718');
[02/21/2024 10:39: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/21_02_2024/request_sight_details_Viator_test_10_39_40_1708511980.json', 'v1/21_02_2024/response_sight_details_Viator_test_10_39_40_1708511980.json', 'v1/21_02_2024/response_header_sight_details_Viator_test_10_39_40_1708511980.json', 'viator', '2024-02-21 10:39:40', '', '', '1718');
[02/21/2024 10:39:43], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:39:43' WHERE id= '584';
[02/21/2024 10:39: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 ('', 'check_availability', 'v1/21_02_2024/request_check_availability_Viator_test_10_39_43_1708511983.json', 'v1/21_02_2024/response_check_availability_Viator_test_10_39_43_1708511983.json', 'v1/21_02_2024/response_header_check_availability_Viator_test_10_39_43_1708511983.json', 'viator', '2024-02-21 10:39:44', '', '', '1718');
[02/21/2024 10:39:45], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:39:45' WHERE id= '584';
[02/21/2024 10:39:45], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1708511985','43.239.53.130');
[02/21/2024 10:39:56], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:39:56' WHERE id= '584';
[02/21/2024 10:39:59], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-02-21 10:39:59',login_attempt=0 where id = '7870';
[02/21/2024 10:39:59], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'hotelyards-agent', user_type = 'A', branch_id = '32', login_datetime = '2024-02-21 10:39:59', ip = '43.239.53.130', action = 'Login' ;
[02/21/2024 10:40:00], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:40:00' WHERE id= '589';
[02/21/2024 10:40:01], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:40:01' WHERE id= '584';
[02/21/2024 10:40:39], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:40:39' WHERE id= '584';
[02/21/2024 10:40:42], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:40:42' WHERE id= '584';
[02/21/2024 10:40:45], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:40:45' WHERE id= '584';
[02/21/2024 10:41:28], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:41:28' WHERE id= '584';
[02/21/2024 10:41:28], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1708512088','43.239.53.130');
[02/21/2024 10:41:29], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:41:29' WHERE id= '584';
[02/21/2024 10:41:29], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO bookings set reservation_id='3050',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='446.22',display_currency_code='USD',native_room_rate='446.22',consultant_id='SUJAY_QTECH',native_currency_code='USD',cancellation_policy='Cancellation Charges will be applicable if cancelled after 18 Mar 2024 12:00 hrs.<BR>Late amendment charge may apply.<Br><Br><B><U>Detailed Cancellation Policy:</U></B><Br>446.22 Charges - 100% applicable from time of Booking (Full Cancellation Charges applicable immediately)',current_status='inprocess-booking',booking_status='1',sales_manager_id='0',create_date='2024-02-21 10:41:29',source_type='viator',expiration_date= '2024-01-09 09: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-04-30',sub_user_id='',check_out_date='2024-04-30',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';
[02/21/2024 10:41:29], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO sight_bookings set booking_id='478',native_nightly_rates='a:2:{s:4:\"size\";i:1;s:17:\"nativeNightlyRate\";d:446.22000000000003;}',rate_description='',display_nightly_rates='a:4:{s:4:\"size\";i:1;s:18:\"displayNightlyRate\";d:446.22000000000003;s:25:\"displayNightlyRateDisplay\";s:134:\"Rate - 446.22 USD, Currency Multiplier (USD-USD) - 1.00000, Markup  in % - %, Markup Amount - , Markup Amount in  - ,Other Markup - 0%\";s:23:\"displayNightlyRateStore\";s:135:\"Rate - 446.22 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='200315P1',sight_name='GO FISHING DUBAI 5 HOURS TROLLING & REGULAR FISHING - V2',tour_time='',tour_details='',tour_inclusive='C<br/>',tour_exclusive='T<br/>',meeting_point='',tour_dep_point=' ',tour_language='en/SERVICE_GUIDE',tour_supplier_phone='',additional_tour_dep_point='',tour_duration='5 hours 0 minutes<br> Start Time: ',arrival_date='2024-04-30',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/21/2024 10:41:29], [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','3050','2024-02-21 10:41:29',0);
[02/21/2024 10:41:33], [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/21_02_2024/request_reservation_sight_Viator_test_10_41_29_1708512089.json', 'v1/21_02_2024/response_reservation_sight_Viator_test_10_41_29_1708512089.json', 'v1/21_02_2024/response_header_reservation_sight_Viator_test_10_41_29_1708512089.json', 'viator', '2024-02-21 10:41:33', '', '', '1718');
[02/21/2024 10:41:33], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE posted_bookings set status=1 where id= '293';
[02/21/2024 10:41:33], [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='446.22', supplier_rate='446.22', uid='', itenirary_id='3050504', confirmation_number='BR-595645585', comment_contract='', current_status='confirmed', original_source='' where id='478';
[02/21/2024 10:41:33], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],update sight_bookings set gtaToken='',gta_item_confirm_ref='',viator_item_ref='BR-595645585',viator_ref='BR-595645585',viator_item_id='',viator_voucherKey='https://shop.live.rc.viator.com/ticket?code=1020344195:eaf2fbc0d5000061dda4b7148b94258a6a80246e886906ecfb73641a9a67b73e:595645585',tour_supplier='',textaddition_activities='N;' where booking_id='478';
[02/21/2024 10:41:33], [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
		('','','478','confirmed','2024-02-21 10:41:33','Sightseeing Booking confirmed by Agent..7851','7851','43.239.53.130','','','');
[02/21/2024 10:41:33], [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('478','Mr','1','Shiv','Chauhan','adult','0');
[02/21/2024 10:41:33], [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('478','Mr','1','Rohit','Kalla','adult','0');
[02/21/2024 10:41:33], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],update xmllogs set reservation_id='478' where agent_logs_id='1718' and source_type='viator';
[02/21/2024 10:41:37], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],update bookings set invoice_number= 'INV21022400001', voucher_id='2102104137',status_date='2024-02-21 10:41:37',current_status='vouchered',voucher_hashcode='4210f74d9426542e2a31d48e1e4e89a476874478',vouchered_by ='' where id='478';
[02/21/2024 10:41:38], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],update bookings set is_invoiced='yes',invoice_number= 'INV21022400001' where id='478' and is_invoiced!='yes';
[02/21/2024 10:41:38], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE agents SET credit_usage=credit_usage+('0'),   credit_value= credit_value-('0') ,  cd_credit_usage=cd_credit_usage+('0') , cd_credit_value=cd_credit_value-('0')  WHERE id = '7851';
[02/21/2024 10:41:38], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],insert into  agent_credit_log SET agent_id= '7851',credit_value= '2367.097',credit_usage= '7632.903',credit_limit= '10000.000',receipt_id= '',amount= '',booking_id='478',booking_cost= '',receipt_allocation= '',balance= '',ip='43.239.53.130',user_type='User',admin_id='Agent - Viator  Viator(CD7851)',temp_credit_limit='',log_type='Add Invoice',note='Add Invoice',create_date='2024-02-21 10:02:38';
[02/21/2024 10:41:38], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php], insert into booking_rate_info set  booking_id = '478', booking_log = 'Booking Vouchered', create_date = '2024-02-21 10:41:38', supplier_currency ='USD', type = 'Sale', agent_price = '', sub_agent_price ='', supplier_price = '0.000', supplier_id = 'viator', supplier_type = 'online';
[02/21/2024 10:41:40], [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
		('','','478','inprocess-booking-invoiced','2024-02-21 10:41:40','Booking invoiced by Back Office v3alpha on behalf of Agent - Viator  Viator(CD7851)','7851','43.239.53.130','','','');
[02/21/2024 10:41:40], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO agent_commission SET booking_id ='478',booking_detail_id ='478',agent_id ='7851',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-21 10:41:40';
[02/21/2024 10:41:40], [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
		('','','478','vouchered','2024-02-21 10:41:40','Voucherd by Back Office v3alpha on behalf of Agent - Viator  Viator(CD7851)','7851','43.239.53.130','','','');
[02/21/2024 10:42:32], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-02-21 10:42:32',login_attempt=0 where id = '7857';
[02/21/2024 10:42:32], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Deepak_T', user_type = 'A', branch_id = '23', login_datetime = '2024-02-21 10:42:32', ip = '43.239.53.130', action = 'Login' ;
[02/21/2024 10:42:32], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:42:32' WHERE id= '585';
[02/21/2024 10:42:35], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:42:35' WHERE id= '585';
[02/21/2024 10:42:41], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:42:41' WHERE id= '585';
[02/21/2024 10:42:41], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7857' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '23' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/02/25' , departure_date = '2024/02/26' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-02-21 10:42:41' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[02/21/2024 10:42:41], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:42:41' WHERE id= '585';
[02/21/2024 10:42:42], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-21 10:42:42.170'
                , total_duration = '0.012'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-21 10:42:42'
                , session_id = '4d889ec00c80993cd4f8ea6ea3974621983ebab8aaef58ec470ef4b282106849'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1617456';
[02/21/2024 10:42:42], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-21 10:42:42.170'
                , total_duration = '0.013'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-21 10:42:42'
                , session_id = '4d889ec00c80993cd4f8ea6ea3974621983ebab8aaef58ec470ef4b282106849'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1617456';
[02/21/2024 10:42:42], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-21 10:42:42.170'
                , total_duration = '0.017'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-21 10:42:42'
                , session_id = '4d889ec00c80993cd4f8ea6ea3974621983ebab8aaef58ec470ef4b282106849'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1617456';
[02/21/2024 10:42:42], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-21 10:42:42.170'
                , total_duration = '0.017'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-21 10:42:42'
                , session_id = '4d889ec00c80993cd4f8ea6ea3974621983ebab8aaef58ec470ef4b282106849'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1617456';
[02/21/2024 10:42:42], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-21 10:42:42.170'
                , total_duration = '0.017'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-21 10:42:42'
                , session_id = '4d889ec00c80993cd4f8ea6ea3974621983ebab8aaef58ec470ef4b282106849'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1617456';
[02/21/2024 10:42:42], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-21 10:42:42.170'
                , total_duration = '0.018'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-21 10:42:42'
                , session_id = '4d889ec00c80993cd4f8ea6ea3974621983ebab8aaef58ec470ef4b282106849'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1617456';
[02/21/2024 10:42:42], [file name :-/home/otrams/public_html/beta/call.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', 'e1/21_02_2024/request_availability_Deepak_T_10_42_42_1708512162_30.json', 'e1/21_02_2024/response_availability_Deepak_T_10_42_42_1708512162_30.json', 'e1/21_02_2024/response_header_availability_Deepak_T_10_42_42_1708512162_30.json', 'expedia', '2024-02-21 10:42:42', '', '4d889ec00c80993cd4f8ea6ea3974621983ebab8aaef58ec470ef4b282106849', '0');
[02/21/2024 10:42:42], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=4d889ec00c80993cd4f8ea6ea3974621983ebab8aaef58ec470ef4b282106849&xml_user_id=7857&db_caching=1&erequest=2&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F120.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-02-21 10:42:42.170'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '0.273'
            , error_description = ''
            , memory_used = '1687064'
            WHERE id = '34775';
[02/21/2024 10:42:42], [file name :-/home/otrams/public_html/beta/call.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', 'd1/21_02_2024/request_availability_Deepak_T__1_10_42_42_1708512162.xml', 'd1/21_02_2024/response_availability_Deepak_T__1_10_42_42_1708512162.xml', 'd1/21_02_2024/response_header_availability_Deepak_T__1_10_42_42_1708512162.xml', 'dotw', '2024-02-21 10:42:42', '', '4d889ec00c80993cd4f8ea6ea3974621983ebab8aaef58ec470ef4b282106849', '0');
[02/21/2024 10:42:42], [file name :-/home/otrams/public_html/beta/call.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', 'd1/21_02_2024/request_availability_Deepak_T__6_10_42_42_1708512162.xml', 'd1/21_02_2024/response_availability_Deepak_T__6_10_42_42_1708512162.xml', 'd1/21_02_2024/response_header_availability_Deepak_T__6_10_42_42_1708512162.xml', 'dotw', '2024-02-21 10:42:42', '', '4d889ec00c80993cd4f8ea6ea3974621983ebab8aaef58ec470ef4b282106849', '0');
[02/21/2024 10:42:42], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=dotw&sessionid=4d889ec00c80993cd4f8ea6ea3974621983ebab8aaef58ec470ef4b282106849&xml_user_id=7857&db_caching=1&destination_code=364&country_code=6&language=&web_service=no&hotels_ids=&erequest=1&total_request=9&web_service=no'
            , http_hit_time = '2024-02-21 10:42:42.170'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '0.311'
            , error_description = ''
            , memory_used = '1570384'
            WHERE id = '34776';
[02/21/2024 10:42:42], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=dotw&sessionid=4d889ec00c80993cd4f8ea6ea3974621983ebab8aaef58ec470ef4b282106849&xml_user_id=7857&db_caching=1&destination_code=364&country_code=6&language=&web_service=no&hotels_ids=&erequest=6&total_request=9&web_service=no'
            , http_hit_time = '2024-02-21 10:42:42.170'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '0.313'
            , error_description = ''
            , memory_used = '1570384'
            WHERE id = '34777';
[02/21/2024 10:42:42], [file name :-/home/otrams/public_html/beta/call.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', 'd1/21_02_2024/request_availability_Deepak_T__2_10_42_42_1708512162.xml', 'd1/21_02_2024/response_availability_Deepak_T__2_10_42_42_1708512162.xml', 'd1/21_02_2024/response_header_availability_Deepak_T__2_10_42_42_1708512162.xml', 'dotw', '2024-02-21 10:42:42', '', '4d889ec00c80993cd4f8ea6ea3974621983ebab8aaef58ec470ef4b282106849', '0');
[02/21/2024 10:42:42], [file name :-/home/otrams/public_html/beta/call.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', 'd1/21_02_2024/request_availability_Deepak_T__0_10_42_42_1708512162.xml', 'd1/21_02_2024/response_availability_Deepak_T__0_10_42_42_1708512162.xml', 'd1/21_02_2024/response_header_availability_Deepak_T__0_10_42_42_1708512162.xml', 'dotw', '2024-02-21 10:42:42', '', '4d889ec00c80993cd4f8ea6ea3974621983ebab8aaef58ec470ef4b282106849', '0');
[02/21/2024 10:42:42], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=dotw&sessionid=4d889ec00c80993cd4f8ea6ea3974621983ebab8aaef58ec470ef4b282106849&xml_user_id=7857&db_caching=1&destination_code=364&country_code=6&language=&web_service=no&hotels_ids=&erequest=2&total_request=9&web_service=no'
            , http_hit_time = '2024-02-21 10:42:42.170'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '0.323'
            , error_description = ''
            , memory_used = '1562752'
            WHERE id = '34778';
[02/21/2024 10:42:42], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=dotw&sessionid=4d889ec00c80993cd4f8ea6ea3974621983ebab8aaef58ec470ef4b282106849&xml_user_id=7857&db_caching=1&destination_code=364&country_code=6&language=&web_service=no&hotels_ids=&erequest=0&total_request=9&web_service=no'
            , http_hit_time = '2024-02-21 10:42:42.170'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '0.325'
            , error_description = ''
            , memory_used = '1570384'
            WHERE id = '34779';
[02/21/2024 10:42:42], [file name :-/home/otrams/public_html/beta/call.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', 'd1/21_02_2024/request_availability_Deepak_T__3_10_42_42_1708512162.xml', 'd1/21_02_2024/response_availability_Deepak_T__3_10_42_42_1708512162.xml', 'd1/21_02_2024/response_header_availability_Deepak_T__3_10_42_42_1708512162.xml', 'dotw', '2024-02-21 10:42:42', '', '4d889ec00c80993cd4f8ea6ea3974621983ebab8aaef58ec470ef4b282106849', '0');
[02/21/2024 10:42:42], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=dotw&sessionid=4d889ec00c80993cd4f8ea6ea3974621983ebab8aaef58ec470ef4b282106849&xml_user_id=7857&db_caching=1&destination_code=364&country_code=6&language=&web_service=no&hotels_ids=&erequest=3&total_request=9&web_service=no'
            , http_hit_time = '2024-02-21 10:42:42.170'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '0.343'
            , error_description = ''
            , memory_used = '1581160'
            WHERE id = '34780';
[02/21/2024 10:42:42], [file name :-/home/otrams/public_html/beta/call.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', 'd1/21_02_2024/request_availability_Deepak_T__5_10_42_42_1708512162.xml', 'd1/21_02_2024/response_availability_Deepak_T__5_10_42_42_1708512162.xml', 'd1/21_02_2024/response_header_availability_Deepak_T__5_10_42_42_1708512162.xml', 'dotw', '2024-02-21 10:42:42', '', '4d889ec00c80993cd4f8ea6ea3974621983ebab8aaef58ec470ef4b282106849', '0');
[02/21/2024 10:42:42], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=dotw&sessionid=4d889ec00c80993cd4f8ea6ea3974621983ebab8aaef58ec470ef4b282106849&xml_user_id=7857&db_caching=1&destination_code=364&country_code=6&language=&web_service=no&hotels_ids=&erequest=5&total_request=9&web_service=no'
            , http_hit_time = '2024-02-21 10:42:42.170'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '0.359'
            , error_description = ''
            , memory_used = '1570384'
            WHERE id = '34781';
[02/21/2024 10:42:42], [file name :-/home/otrams/public_html/beta/call.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', 'd1/21_02_2024/request_availability_Deepak_T__4_10_42_42_1708512162.xml', 'd1/21_02_2024/response_availability_Deepak_T__4_10_42_42_1708512162.xml', 'd1/21_02_2024/response_header_availability_Deepak_T__4_10_42_42_1708512162.xml', 'dotw', '2024-02-21 10:42:42', '', '4d889ec00c80993cd4f8ea6ea3974621983ebab8aaef58ec470ef4b282106849', '0');
[02/21/2024 10:42:42], [file name :-/home/otrams/public_html/beta/call.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', 'd1/21_02_2024/request_availability_Deepak_T__7_10_42_42_1708512162.xml', 'd1/21_02_2024/response_availability_Deepak_T__7_10_42_42_1708512162.xml', 'd1/21_02_2024/response_header_availability_Deepak_T__7_10_42_42_1708512162.xml', 'dotw', '2024-02-21 10:42:42', '', '4d889ec00c80993cd4f8ea6ea3974621983ebab8aaef58ec470ef4b282106849', '0');
[02/21/2024 10:42:42], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=dotw&sessionid=4d889ec00c80993cd4f8ea6ea3974621983ebab8aaef58ec470ef4b282106849&xml_user_id=7857&db_caching=1&destination_code=364&country_code=6&language=&web_service=no&hotels_ids=&erequest=4&total_request=9&web_service=no'
            , http_hit_time = '2024-02-21 10:42:42.170'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '0.364'
            , error_description = ''
            , memory_used = '1570384'
            WHERE id = '34782';
[02/21/2024 10:42:42], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=dotw&sessionid=4d889ec00c80993cd4f8ea6ea3974621983ebab8aaef58ec470ef4b282106849&xml_user_id=7857&db_caching=1&destination_code=364&country_code=6&language=&web_service=no&hotels_ids=&erequest=7&total_request=9&web_service=no'
            , http_hit_time = '2024-02-21 10:42:42.170'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '0.365'
            , error_description = ''
            , memory_used = '1581160'
            WHERE id = '34783';
[02/21/2024 10:42:42], [file name :-/home/otrams/public_html/beta/call.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', 'd1/21_02_2024/request_availability_Deepak_T__8_10_42_42_1708512162.xml', 'd1/21_02_2024/response_availability_Deepak_T__8_10_42_42_1708512162.xml', 'd1/21_02_2024/response_header_availability_Deepak_T__8_10_42_42_1708512162.xml', 'dotw', '2024-02-21 10:42:42', '', '4d889ec00c80993cd4f8ea6ea3974621983ebab8aaef58ec470ef4b282106849', '0');
[02/21/2024 10:42:42], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=dotw&sessionid=4d889ec00c80993cd4f8ea6ea3974621983ebab8aaef58ec470ef4b282106849&xml_user_id=7857&db_caching=1&destination_code=364&country_code=6&language=&web_service=no&hotels_ids=&erequest=8&total_request=9&web_service=no'
            , http_hit_time = '2024-02-21 10:42:42.170'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '0.371'
            , error_description = ''
            , memory_used = '1570400'
            WHERE id = '34784';
[02/21/2024 10:42:43], [file name :-/home/otrams/public_html/beta/call.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', 'e1/21_02_2024/request_availability_Deepak_T_10_42_42_1708512162_77.json', 'e1/21_02_2024/response_availability_Deepak_T_10_42_42_1708512162_77.json', 'e1/21_02_2024/response_header_availability_Deepak_T_10_42_42_1708512162_77.json', 'expedia', '2024-02-21 10:42:43', '', '4d889ec00c80993cd4f8ea6ea3974621983ebab8aaef58ec470ef4b282106849', '0');
[02/21/2024 10:42:43], [file name :-/home/otrams/public_html/beta/call.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', 'e1/21_02_2024/request_availability_Deepak_T_10_42_42_1708512162_50.json', 'e1/21_02_2024/response_availability_Deepak_T_10_42_42_1708512162_50.json', 'e1/21_02_2024/response_header_availability_Deepak_T_10_42_42_1708512162_50.json', 'expedia', '2024-02-21 10:42:43', '', '4d889ec00c80993cd4f8ea6ea3974621983ebab8aaef58ec470ef4b282106849', '0');
[02/21/2024 10:42:44], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=4d889ec00c80993cd4f8ea6ea3974621983ebab8aaef58ec470ef4b282106849&xml_user_id=7857&db_caching=1&erequest=1&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F120.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-02-21 10:42:42.170'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '2.310'
            , error_description = ''
            , memory_used = '125667368'
            WHERE id = '34786';
[02/21/2024 10:42:44], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=4d889ec00c80993cd4f8ea6ea3974621983ebab8aaef58ec470ef4b282106849&xml_user_id=7857&db_caching=1&erequest=0&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F120.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-02-21 10:42:42.170'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '2.461'
            , error_description = ''
            , memory_used = '148321056'
            WHERE id = '34785';
[02/21/2024 10:42:44], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:42:44' WHERE id= '585';
[02/21/2024 10:42:46], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:42:46' WHERE id= '585';
[02/21/2024 10:42:51], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:42:51' WHERE id= '585';
[02/21/2024 10:42:51], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:42:51' WHERE id= '585';
[02/21/2024 10:42:51], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1708512171','43.239.53.130');
[02/21/2024 10:42:51], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'valuation', 'e1/21_02_2024/request_valuation_Deepak_T_10_42_51_1708512171_53.json', 'e1/21_02_2024/response_valuation_Deepak_T_10_42_51_1708512171_53.json', 'e1/21_02_2024/response_header_valuation_Deepak_T_10_42_51_1708512171_53.json', 'expedia', '2024-02-21 10:42:51', '', '4d889ec00c80993cd4f8ea6ea3974621983ebab8aaef58ec470ef4b282106849', '0');
[02/21/2024 10:42:51], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Aravi Hotel', 'dubai', '138', '7857', '', '23', '', 'hotelcancellationpolicy', '2024-02-21 :10:42:51','');
[02/21/2024 10:42:55], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:42:55' WHERE id= '585';
[02/21/2024 10:42:55], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:42:55' WHERE id= '585';
[02/21/2024 10:42:55], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1708512175','43.239.53.130');
[02/21/2024 10:42:56], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'valuation', 'e1/21_02_2024/request_valuation_Deepak_T_10_42_55_1708512175_83.json', 'e1/21_02_2024/response_valuation_Deepak_T_10_42_55_1708512175_83.json', 'e1/21_02_2024/response_header_valuation_Deepak_T_10_42_55_1708512175_83.json', 'expedia', '2024-02-21 10:42:56', '', '4d889ec00c80993cd4f8ea6ea3974621983ebab8aaef58ec470ef4b282106849', '0');
[02/21/2024 10:43:02], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:43:02' WHERE id= '585';
[02/21/2024 10:43:06], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:43:06' WHERE id= '585';
[02/21/2024 10:43:06], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1708512186','43.239.53.130');
[02/21/2024 10:43:06], [file name :-/home/otrams/public_html/beta/payment_gateway_step1.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:43:06' WHERE id= '585';
[02/21/2024 10:43:07], [file name :-/home/otrams/public_html/beta/payment_gateway_step1.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:43:07' WHERE id= '585';
[02/21/2024 10:43:07], [file name :-/home/otrams/public_html/beta/payment_gateway_step1.php],insert into payment_log(agent_id,booking_amount,created_date,ip_address,track_id,voucher_id,reservation_id,payment_track,unique_ref_id,gateway_code,gateway_point,currency)
		values('7857','61.94','2024-02-21 10:43:07','43.239.53.130','17085121879573','20240221104307','3053','uid_7857##fname_dfbjd##bid_479##route_bookflow##type_B2B##pg_HP##mob_0##email_##phone_##siteurl_beta.astrabookings.com','3053_1708512187_hotel','HP','on_selection','EUR');
[02/21/2024 10:46:33], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:46:33' WHERE id= '584';
[02/21/2024 10:46:33], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-02-21 10:46:33',login_attempt=0 where id = '7851';
[02/21/2024 10:46:33], [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-02-21 10:46:33', ip = '43.239.53.130', action = 'Login' ;
[02/21/2024 10:46:34], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:46:34' WHERE id= '584';
[02/21/2024 10:46:39], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:46:39' WHERE id= '584';
[02/21/2024 10:46:44], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:46:44' WHERE id= '584';
[02/21/2024 10:46:53], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:46:53' WHERE id= '584';
[02/21/2024 10:46:53], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7851' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '27' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/04/30',  departure_date='2024/04/30',  nights='1',  create_date='2024-02-21 :10:46:53',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[02/21/2024 10:47: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/21_02_2024/request_availability_Viator_test_10_46_53_1708512413.json', 'v1/21_02_2024/response_availability_Viator_test_10_46_53_1708512413.json', 'v1/21_02_2024/response_header_availability_Viator_test_10_46_53_1708512413.json', 'viator', '2024-02-21 10:47:10', '', '', '1719');
[02/21/2024 10:47:12], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:47:12' WHERE id= '584';
[02/21/2024 10:47:12], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:47:12' WHERE id= '584';
[02/21/2024 10:47:49], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:47:49' WHERE id= '584';
[02/21/2024 10:47: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/21_02_2024/request_sight_details_Viator_test_10_47_49_1708512469.json', 'v1/21_02_2024/response_sight_details_Viator_test_10_47_49_1708512469.json', 'v1/21_02_2024/response_header_sight_details_Viator_test_10_47_49_1708512469.json', 'viator', '2024-02-21 10:47:50', '', '', '1719');
[02/21/2024 10:47: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/21_02_2024/request_sight_details_Viator_test_10_47_50_1708512470.json', 'v1/21_02_2024/response_sight_details_Viator_test_10_47_50_1708512470.json', 'v1/21_02_2024/response_header_sight_details_Viator_test_10_47_50_1708512470.json', 'viator', '2024-02-21 10:47:50', '', '', '1719');
[02/21/2024 10:47:57], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:47:57' WHERE id= '584';
[02/21/2024 10:47: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/21_02_2024/request_sight_details_Viator_test_10_47_57_1708512477.json', 'v1/21_02_2024/response_sight_details_Viator_test_10_47_57_1708512477.json', 'v1/21_02_2024/response_header_sight_details_Viator_test_10_47_57_1708512477.json', 'viator', '2024-02-21 10:47:58', '', '', '1719');
[02/21/2024 10:47: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/21_02_2024/request_sight_details_Viator_test_10_47_58_1708512478.json', 'v1/21_02_2024/response_sight_details_Viator_test_10_47_58_1708512478.json', 'v1/21_02_2024/response_header_sight_details_Viator_test_10_47_58_1708512478.json', 'viator', '2024-02-21 10:47:58', '', '', '1719');
[02/21/2024 10:48:08], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:48:08' WHERE id= '584';
[02/21/2024 10:48:08], [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/21_02_2024/request_check_availability_Viator_test_10_48_08_1708512488.json', 'v1/21_02_2024/response_check_availability_Viator_test_10_48_08_1708512488.json', 'v1/21_02_2024/response_header_check_availability_Viator_test_10_48_08_1708512488.json', 'viator', '2024-02-21 10:48:08', '', '', '1719');
[02/21/2024 10:48:11], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:48:11' WHERE id= '584';
[02/21/2024 10:48: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/21_02_2024/request_sight_details_Viator_test_10_48_11_1708512491.json', 'v1/21_02_2024/response_sight_details_Viator_test_10_48_11_1708512491.json', 'v1/21_02_2024/response_header_sight_details_Viator_test_10_48_11_1708512491.json', 'viator', '2024-02-21 10:48:12', '', '', '1719');
[02/21/2024 10:48: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/21_02_2024/request_sight_details_Viator_test_10_48_12_1708512492.json', 'v1/21_02_2024/response_sight_details_Viator_test_10_48_12_1708512492.json', 'v1/21_02_2024/response_header_sight_details_Viator_test_10_48_12_1708512492.json', 'viator', '2024-02-21 10:48:12', '', '', '1719');
[02/21/2024 10:48:25], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:48:25' WHERE id= '584';
[02/21/2024 10:48: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/21_02_2024/request_check_availability_Viator_test_10_48_25_1708512505.json', 'v1/21_02_2024/response_check_availability_Viator_test_10_48_25_1708512505.json', 'v1/21_02_2024/response_header_check_availability_Viator_test_10_48_25_1708512505.json', 'viator', '2024-02-21 10:48:25', '', '', '1719');
[02/21/2024 10:48:32], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:48:32' WHERE id= '584';
[02/21/2024 10:48:32], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1708512512','43.239.53.130');
[02/21/2024 10:48:41], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:48:41' WHERE id= '584';
[02/21/2024 10:48:50], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:48:50' WHERE id= '584';
[02/21/2024 10:48:53], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:48:53' WHERE id= '584';
[02/21/2024 10:50:21], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-02-21 10:50:21',login_attempt=0 where id = '7857';
[02/21/2024 10:50:21], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Deepak_T', user_type = 'A', branch_id = '23', login_datetime = '2024-02-21 10:50:21', ip = '43.239.53.130', action = 'Login' ;
[02/21/2024 10:50:22], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:50:22' WHERE id= '582';
[02/21/2024 10:50:27], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:50:27' WHERE id= '582';
[02/21/2024 10:50:28], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:50:28' WHERE id= '582';
[02/21/2024 10:50:32], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:50:32' WHERE id= '582';
[02/21/2024 10:50:32], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7857' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '23' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/02/22' , departure_date = '2024/02/23' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-02-21 10:50:32' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[02/21/2024 10:50:33], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:50:33' WHERE id= '582';
[02/21/2024 10:50:33], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-21 10:50:33.875'
                , total_duration = '0.016'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-21 10:50:33'
                , session_id = '00819bb642b8042f54483e1feb05c56dbab1ffa58130dda94d5688d939987fa9'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1607000';
[02/21/2024 10:50:33], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-21 10:50:33.875'
                , total_duration = '0.019'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-21 10:50:33'
                , session_id = '00819bb642b8042f54483e1feb05c56dbab1ffa58130dda94d5688d939987fa9'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1607000';
[02/21/2024 10:50:33], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-21 10:50:33.875'
                , total_duration = '0.019'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-21 10:50:33'
                , session_id = '00819bb642b8042f54483e1feb05c56dbab1ffa58130dda94d5688d939987fa9'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1607000';
[02/21/2024 10:50:33], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-21 10:50:33.875'
                , total_duration = '0.019'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-21 10:50:33'
                , session_id = '00819bb642b8042f54483e1feb05c56dbab1ffa58130dda94d5688d939987fa9'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1607000';
[02/21/2024 10:50:33], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-21 10:50:33.875'
                , total_duration = '0.020'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-21 10:50:33'
                , session_id = '00819bb642b8042f54483e1feb05c56dbab1ffa58130dda94d5688d939987fa9'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1607024';
[02/21/2024 10:50:33], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-21 10:50:33.875'
                , total_duration = '0.020'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-21 10:50:33'
                , session_id = '00819bb642b8042f54483e1feb05c56dbab1ffa58130dda94d5688d939987fa9'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1607000';
[02/21/2024 10:50:34], [file name :-/home/otrams/public_html/beta/call.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', 'e1/21_02_2024/request_availability_Deepak_T_10_50_33_1708512633_42.json', 'e1/21_02_2024/response_availability_Deepak_T_10_50_33_1708512633_42.json', 'e1/21_02_2024/response_header_availability_Deepak_T_10_50_33_1708512633_42.json', 'expedia', '2024-02-21 10:50:34', '', '00819bb642b8042f54483e1feb05c56dbab1ffa58130dda94d5688d939987fa9', '0');
[02/21/2024 10:50:34], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=00819bb642b8042f54483e1feb05c56dbab1ffa58130dda94d5688d939987fa9&xml_user_id=7857&db_caching=1&erequest=2&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-02-21 10:50:33.874'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '0.293'
            , error_description = ''
            , memory_used = '1351576'
            WHERE id = '34804';
[02/21/2024 10:50:34], [file name :-/home/otrams/public_html/beta/call.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', 'd1/21_02_2024/request_availability_Deepak_T__7_10_50_34_1708512634.xml', 'd1/21_02_2024/response_availability_Deepak_T__7_10_50_34_1708512634.xml', 'd1/21_02_2024/response_header_availability_Deepak_T__7_10_50_34_1708512634.xml', 'dotw', '2024-02-21 10:50:34', '', '00819bb642b8042f54483e1feb05c56dbab1ffa58130dda94d5688d939987fa9', '0');
[02/21/2024 10:50:34], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=dotw&sessionid=00819bb642b8042f54483e1feb05c56dbab1ffa58130dda94d5688d939987fa9&xml_user_id=7857&db_caching=1&destination_code=364&country_code=6&language=&web_service=no&hotels_ids=&erequest=7&total_request=9&web_service=no'
            , http_hit_time = '2024-02-21 10:50:33.875'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '0.331'
            , error_description = ''
            , memory_used = '1570832'
            WHERE id = '34805';
[02/21/2024 10:50:34], [file name :-/home/otrams/public_html/beta/call.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', 'd1/21_02_2024/request_availability_Deepak_T__0_10_50_34_1708512634.xml', 'd1/21_02_2024/response_availability_Deepak_T__0_10_50_34_1708512634.xml', 'd1/21_02_2024/response_header_availability_Deepak_T__0_10_50_34_1708512634.xml', 'dotw', '2024-02-21 10:50:34', '', '00819bb642b8042f54483e1feb05c56dbab1ffa58130dda94d5688d939987fa9', '0');
[02/21/2024 10:50:34], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=dotw&sessionid=00819bb642b8042f54483e1feb05c56dbab1ffa58130dda94d5688d939987fa9&xml_user_id=7857&db_caching=1&destination_code=364&country_code=6&language=&web_service=no&hotels_ids=&erequest=0&total_request=9&web_service=no'
            , http_hit_time = '2024-02-21 10:50:33.874'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '0.345'
            , error_description = ''
            , memory_used = '1560088'
            WHERE id = '34806';
[02/21/2024 10:50:34], [file name :-/home/otrams/public_html/beta/call.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', 'd1/21_02_2024/request_availability_Deepak_T__8_10_50_34_1708512634.xml', 'd1/21_02_2024/response_availability_Deepak_T__8_10_50_34_1708512634.xml', 'd1/21_02_2024/response_header_availability_Deepak_T__8_10_50_34_1708512634.xml', 'dotw', '2024-02-21 10:50:34', '', '00819bb642b8042f54483e1feb05c56dbab1ffa58130dda94d5688d939987fa9', '0');
[02/21/2024 10:50:34], [file name :-/home/otrams/public_html/beta/call.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', 'd1/21_02_2024/request_availability_Deepak_T__5_10_50_34_1708512634.xml', 'd1/21_02_2024/response_availability_Deepak_T__5_10_50_34_1708512634.xml', 'd1/21_02_2024/response_header_availability_Deepak_T__5_10_50_34_1708512634.xml', 'dotw', '2024-02-21 10:50:34', '', '00819bb642b8042f54483e1feb05c56dbab1ffa58130dda94d5688d939987fa9', '0');
[02/21/2024 10:50:34], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=dotw&sessionid=00819bb642b8042f54483e1feb05c56dbab1ffa58130dda94d5688d939987fa9&xml_user_id=7857&db_caching=1&destination_code=364&country_code=6&language=&web_service=no&hotels_ids=&erequest=8&total_request=9&web_service=no'
            , http_hit_time = '2024-02-21 10:50:33.875'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '0.369'
            , error_description = ''
            , memory_used = '1570864'
            WHERE id = '34807';
[02/21/2024 10:50:34], [file name :-/home/otrams/public_html/beta/call.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', 'd1/21_02_2024/request_availability_Deepak_T__1_10_50_34_1708512634.xml', 'd1/21_02_2024/response_availability_Deepak_T__1_10_50_34_1708512634.xml', 'd1/21_02_2024/response_header_availability_Deepak_T__1_10_50_34_1708512634.xml', 'dotw', '2024-02-21 10:50:34', '', '00819bb642b8042f54483e1feb05c56dbab1ffa58130dda94d5688d939987fa9', '0');
[02/21/2024 10:50:34], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=dotw&sessionid=00819bb642b8042f54483e1feb05c56dbab1ffa58130dda94d5688d939987fa9&xml_user_id=7857&db_caching=1&destination_code=364&country_code=6&language=&web_service=no&hotels_ids=&erequest=5&total_request=9&web_service=no'
            , http_hit_time = '2024-02-21 10:50:33.876'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '0.371'
            , error_description = ''
            , memory_used = '1571080'
            WHERE id = '34808';
[02/21/2024 10:50:34], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=dotw&sessionid=00819bb642b8042f54483e1feb05c56dbab1ffa58130dda94d5688d939987fa9&xml_user_id=7857&db_caching=1&destination_code=364&country_code=6&language=&web_service=no&hotels_ids=&erequest=1&total_request=9&web_service=no'
            , http_hit_time = '2024-02-21 10:50:33.874'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '0.376'
            , error_description = ''
            , memory_used = '1560088'
            WHERE id = '34809';
[02/21/2024 10:50:34], [file name :-/home/otrams/public_html/beta/call.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', 'd1/21_02_2024/request_availability_Deepak_T__4_10_50_34_1708512634.xml', 'd1/21_02_2024/response_availability_Deepak_T__4_10_50_34_1708512634.xml', 'd1/21_02_2024/response_header_availability_Deepak_T__4_10_50_34_1708512634.xml', 'dotw', '2024-02-21 10:50:34', '', '00819bb642b8042f54483e1feb05c56dbab1ffa58130dda94d5688d939987fa9', '0');
[02/21/2024 10:50:34], [file name :-/home/otrams/public_html/beta/call.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', 'd1/21_02_2024/request_availability_Deepak_T__2_10_50_34_1708512634.xml', 'd1/21_02_2024/response_availability_Deepak_T__2_10_50_34_1708512634.xml', 'd1/21_02_2024/response_header_availability_Deepak_T__2_10_50_34_1708512634.xml', 'dotw', '2024-02-21 10:50:34', '', '00819bb642b8042f54483e1feb05c56dbab1ffa58130dda94d5688d939987fa9', '0');
[02/21/2024 10:50:34], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=dotw&sessionid=00819bb642b8042f54483e1feb05c56dbab1ffa58130dda94d5688d939987fa9&xml_user_id=7857&db_caching=1&destination_code=364&country_code=6&language=&web_service=no&hotels_ids=&erequest=2&total_request=9&web_service=no'
            , http_hit_time = '2024-02-21 10:50:33.875'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '0.394'
            , error_description = ''
            , memory_used = '1570864'
            WHERE id = '34810';
[02/21/2024 10:50:34], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=dotw&sessionid=00819bb642b8042f54483e1feb05c56dbab1ffa58130dda94d5688d939987fa9&xml_user_id=7857&db_caching=1&destination_code=364&country_code=6&language=&web_service=no&hotels_ids=&erequest=4&total_request=9&web_service=no'
            , http_hit_time = '2024-02-21 10:50:33.875'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '0.397'
            , error_description = ''
            , memory_used = '1560088'
            WHERE id = '34811';
[02/21/2024 10:50:34], [file name :-/home/otrams/public_html/beta/call.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', 'd1/21_02_2024/request_availability_Deepak_T__3_10_50_34_1708512634.xml', 'd1/21_02_2024/response_availability_Deepak_T__3_10_50_34_1708512634.xml', 'd1/21_02_2024/response_header_availability_Deepak_T__3_10_50_34_1708512634.xml', 'dotw', '2024-02-21 10:50:34', '', '00819bb642b8042f54483e1feb05c56dbab1ffa58130dda94d5688d939987fa9', '0');
[02/21/2024 10:50:34], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=dotw&sessionid=00819bb642b8042f54483e1feb05c56dbab1ffa58130dda94d5688d939987fa9&xml_user_id=7857&db_caching=1&destination_code=364&country_code=6&language=&web_service=no&hotels_ids=&erequest=3&total_request=9&web_service=no'
            , http_hit_time = '2024-02-21 10:50:33.874'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '0.402'
            , error_description = ''
            , memory_used = '1570864'
            WHERE id = '34812';
[02/21/2024 10:50:34], [file name :-/home/otrams/public_html/beta/call.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', 'd1/21_02_2024/request_availability_Deepak_T__6_10_50_34_1708512634.xml', 'd1/21_02_2024/response_availability_Deepak_T__6_10_50_34_1708512634.xml', 'd1/21_02_2024/response_header_availability_Deepak_T__6_10_50_34_1708512634.xml', 'dotw', '2024-02-21 10:50:34', '', '00819bb642b8042f54483e1feb05c56dbab1ffa58130dda94d5688d939987fa9', '0');
[02/21/2024 10:50:34], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=dotw&sessionid=00819bb642b8042f54483e1feb05c56dbab1ffa58130dda94d5688d939987fa9&xml_user_id=7857&db_caching=1&destination_code=364&country_code=6&language=&web_service=no&hotels_ids=&erequest=6&total_request=9&web_service=no'
            , http_hit_time = '2024-02-21 10:50:33.875'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '0.456'
            , error_description = ''
            , memory_used = '1560304'
            WHERE id = '34813';
[02/21/2024 10:50:34], [file name :-/home/otrams/public_html/beta/call.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', 'e1/21_02_2024/request_availability_Deepak_T_10_50_33_1708512633_61.json', 'e1/21_02_2024/response_availability_Deepak_T_10_50_33_1708512633_61.json', 'e1/21_02_2024/response_header_availability_Deepak_T_10_50_33_1708512633_61.json', 'expedia', '2024-02-21 10:50:34', '', '00819bb642b8042f54483e1feb05c56dbab1ffa58130dda94d5688d939987fa9', '0');
[02/21/2024 10:50:34], [file name :-/home/otrams/public_html/beta/call.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', 'e1/21_02_2024/request_availability_Deepak_T_10_50_33_1708512633_70.json', 'e1/21_02_2024/response_availability_Deepak_T_10_50_33_1708512633_70.json', 'e1/21_02_2024/response_header_availability_Deepak_T_10_50_33_1708512633_70.json', 'expedia', '2024-02-21 10:50:34', '', '00819bb642b8042f54483e1feb05c56dbab1ffa58130dda94d5688d939987fa9', '0');
[02/21/2024 10:50:35], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=00819bb642b8042f54483e1feb05c56dbab1ffa58130dda94d5688d939987fa9&xml_user_id=7857&db_caching=1&erequest=1&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-02-21 10:50:33.874'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '1.397'
            , error_description = ''
            , memory_used = '54512552'
            WHERE id = '34814';
[02/21/2024 10:50:35], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=00819bb642b8042f54483e1feb05c56dbab1ffa58130dda94d5688d939987fa9&xml_user_id=7857&db_caching=1&erequest=0&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-02-21 10:50:33.874'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '1.536'
            , error_description = ''
            , memory_used = '52523816'
            WHERE id = '34815';
[02/21/2024 10:50:35], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:50:35' WHERE id= '582';
[02/21/2024 10:50:37], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:50:37' WHERE id= '582';
[02/21/2024 10:50:43], [file name :-/home/otrams/public_html/beta/show_hotel_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:50:43' WHERE id= '582';
[02/21/2024 10:50:44], [file name :-/home/otrams/public_html/beta/show_hotel_details.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Hafez Hotel Apartments', 'dubai', '138', '7857', '', '23', '', 'hoteldetails', '2024-02-21 :10:50:44','');
[02/21/2024 10:50:44], [file name :-/home/otrams/public_html/beta/view_map.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:50:44' WHERE id= '582';
[02/21/2024 10:50:55], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:50:55' WHERE id= '582';
[02/21/2024 10:50:55], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:50:55' WHERE id= '582';
[02/21/2024 10:50:55], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1708512655','43.239.53.130');
[02/21/2024 10:50:55], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'valuation', 'e1/21_02_2024/request_valuation_Deepak_T_10_50_55_1708512655_33.json', 'e1/21_02_2024/response_valuation_Deepak_T_10_50_55_1708512655_33.json', 'e1/21_02_2024/response_header_valuation_Deepak_T_10_50_55_1708512655_33.json', 'expedia', '2024-02-21 10:50:55', '', '00819bb642b8042f54483e1feb05c56dbab1ffa58130dda94d5688d939987fa9', '0');
[02/21/2024 10:50:55], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Hafez Hotel Apartments', 'dubai', '138', '7857', '', '23', '', 'hotelcancellationpolicy', '2024-02-21 :10:50:55','');
[02/21/2024 10:51:03], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:51:03' WHERE id= '582';
[02/21/2024 10:51:03], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:51:03' WHERE id= '582';
[02/21/2024 10:51:03], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1708512663','43.239.53.130');
[02/21/2024 10:51:04], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'valuation', 'e1/21_02_2024/request_valuation_Deepak_T_10_51_03_1708512663_56.json', 'e1/21_02_2024/response_valuation_Deepak_T_10_51_03_1708512663_56.json', 'e1/21_02_2024/response_header_valuation_Deepak_T_10_51_03_1708512663_56.json', 'expedia', '2024-02-21 10:51:04', '', '00819bb642b8042f54483e1feb05c56dbab1ffa58130dda94d5688d939987fa9', '0');
[02/21/2024 10:51:04], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Hafez Hotel Apartments', 'dubai', '138', '7857', '', '23', '', 'hotelcancellationpolicy', '2024-02-21 :10:51:04','');
[02/21/2024 10:51:27], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:51:27' WHERE id= '582';
[02/21/2024 10:51:27], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7857' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '23' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/02/21' , departure_date = '2024/02/22' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-02-21 10:51:27' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[02/21/2024 10:51:28], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:51:28' WHERE id= '582';
[02/21/2024 10:51:28], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-21 10:51:28.501'
                , total_duration = '0.011'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-21 10:51:28'
                , session_id = '00819bb642b8042f54483e1feb05c56dbab1ffa58130dda94d5688d939987fa9'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1607000';
[02/21/2024 10:51:28], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-21 10:51:28.501'
                , total_duration = '0.013'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-21 10:51:28'
                , session_id = '00819bb642b8042f54483e1feb05c56dbab1ffa58130dda94d5688d939987fa9'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1607000';
[02/21/2024 10:51:28], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-21 10:51:28.501'
                , total_duration = '0.013'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-21 10:51:28'
                , session_id = '00819bb642b8042f54483e1feb05c56dbab1ffa58130dda94d5688d939987fa9'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1607000';
[02/21/2024 10:51:28], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-21 10:51:28.501'
                , total_duration = '0.013'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-21 10:51:28'
                , session_id = '00819bb642b8042f54483e1feb05c56dbab1ffa58130dda94d5688d939987fa9'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1607024';
[02/21/2024 10:51:28], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-21 10:51:28.501'
                , total_duration = '0.026'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-21 10:51:28'
                , session_id = '00819bb642b8042f54483e1feb05c56dbab1ffa58130dda94d5688d939987fa9'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1607000';
[02/21/2024 10:51:28], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-21 10:51:28.501'
                , total_duration = '0.026'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-21 10:51:28'
                , session_id = '00819bb642b8042f54483e1feb05c56dbab1ffa58130dda94d5688d939987fa9'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1607000';
[02/21/2024 10:51:28], [file name :-/home/otrams/public_html/beta/call.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', 'e1/21_02_2024/request_availability_Deepak_T_10_51_28_1708512688_71.json', 'e1/21_02_2024/response_availability_Deepak_T_10_51_28_1708512688_71.json', 'e1/21_02_2024/response_header_availability_Deepak_T_10_51_28_1708512688_71.json', 'expedia', '2024-02-21 10:51:28', '', '00819bb642b8042f54483e1feb05c56dbab1ffa58130dda94d5688d939987fa9', '0');
[02/21/2024 10:51:28], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=00819bb642b8042f54483e1feb05c56dbab1ffa58130dda94d5688d939987fa9&xml_user_id=7857&db_caching=1&erequest=2&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-02-21 10:51:28.502'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '0.273'
            , error_description = ''
            , memory_used = '1351656'
            WHERE id = '34824';
[02/21/2024 10:51:28], [file name :-/home/otrams/public_html/beta/call.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', 'd1/21_02_2024/request_availability_Deepak_T__0_10_51_28_1708512688.xml', 'd1/21_02_2024/response_availability_Deepak_T__0_10_51_28_1708512688.xml', 'd1/21_02_2024/response_header_availability_Deepak_T__0_10_51_28_1708512688.xml', 'dotw', '2024-02-21 10:51:28', '', '00819bb642b8042f54483e1feb05c56dbab1ffa58130dda94d5688d939987fa9', '0');
[02/21/2024 10:51:28], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=dotw&sessionid=00819bb642b8042f54483e1feb05c56dbab1ffa58130dda94d5688d939987fa9&xml_user_id=7857&db_caching=1&destination_code=364&country_code=6&language=&web_service=no&hotels_ids=&erequest=0&total_request=9&web_service=no'
            , http_hit_time = '2024-02-21 10:51:28.501'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '0.316'
            , error_description = ''
            , memory_used = '1560088'
            WHERE id = '34825';
[02/21/2024 10:51:28], [file name :-/home/otrams/public_html/beta/call.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', 'd1/21_02_2024/request_availability_Deepak_T__6_10_51_28_1708512688.xml', 'd1/21_02_2024/response_availability_Deepak_T__6_10_51_28_1708512688.xml', 'd1/21_02_2024/response_header_availability_Deepak_T__6_10_51_28_1708512688.xml', 'dotw', '2024-02-21 10:51:28', '', '00819bb642b8042f54483e1feb05c56dbab1ffa58130dda94d5688d939987fa9', '0');
[02/21/2024 10:51:28], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=dotw&sessionid=00819bb642b8042f54483e1feb05c56dbab1ffa58130dda94d5688d939987fa9&xml_user_id=7857&db_caching=1&destination_code=364&country_code=6&language=&web_service=no&hotels_ids=&erequest=6&total_request=9&web_service=no'
            , http_hit_time = '2024-02-21 10:51:28.501'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '0.327'
            , error_description = ''
            , memory_used = '1560088'
            WHERE id = '34826';
[02/21/2024 10:51:28], [file name :-/home/otrams/public_html/beta/call.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', 'd1/21_02_2024/request_availability_Deepak_T__1_10_51_28_1708512688.xml', 'd1/21_02_2024/response_availability_Deepak_T__1_10_51_28_1708512688.xml', 'd1/21_02_2024/response_header_availability_Deepak_T__1_10_51_28_1708512688.xml', 'dotw', '2024-02-21 10:51:28', '', '00819bb642b8042f54483e1feb05c56dbab1ffa58130dda94d5688d939987fa9', '0');
[02/21/2024 10:51:28], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=dotw&sessionid=00819bb642b8042f54483e1feb05c56dbab1ffa58130dda94d5688d939987fa9&xml_user_id=7857&db_caching=1&destination_code=364&country_code=6&language=&web_service=no&hotels_ids=&erequest=1&total_request=9&web_service=no'
            , http_hit_time = '2024-02-21 10:51:28.501'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '0.340'
            , error_description = ''
            , memory_used = '1570864'
            WHERE id = '34827';
[02/21/2024 10:51:28], [file name :-/home/otrams/public_html/beta/call.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', 'd1/21_02_2024/request_availability_Deepak_T__5_10_51_28_1708512688.xml', 'd1/21_02_2024/response_availability_Deepak_T__5_10_51_28_1708512688.xml', 'd1/21_02_2024/response_header_availability_Deepak_T__5_10_51_28_1708512688.xml', 'dotw', '2024-02-21 10:51:28', '', '00819bb642b8042f54483e1feb05c56dbab1ffa58130dda94d5688d939987fa9', '0');
[02/21/2024 10:51:28], [file name :-/home/otrams/public_html/beta/call.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', 'd1/21_02_2024/request_availability_Deepak_T__8_10_51_28_1708512688.xml', 'd1/21_02_2024/response_availability_Deepak_T__8_10_51_28_1708512688.xml', 'd1/21_02_2024/response_header_availability_Deepak_T__8_10_51_28_1708512688.xml', 'dotw', '2024-02-21 10:51:28', '', '00819bb642b8042f54483e1feb05c56dbab1ffa58130dda94d5688d939987fa9', '0');
[02/21/2024 10:51:28], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=dotw&sessionid=00819bb642b8042f54483e1feb05c56dbab1ffa58130dda94d5688d939987fa9&xml_user_id=7857&db_caching=1&destination_code=364&country_code=6&language=&web_service=no&hotels_ids=&erequest=5&total_request=9&web_service=no'
            , http_hit_time = '2024-02-21 10:51:28.501'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '0.347'
            , error_description = ''
            , memory_used = '1570864'
            WHERE id = '34828';
[02/21/2024 10:51:28], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=dotw&sessionid=00819bb642b8042f54483e1feb05c56dbab1ffa58130dda94d5688d939987fa9&xml_user_id=7857&db_caching=1&destination_code=364&country_code=6&language=&web_service=no&hotels_ids=&erequest=8&total_request=9&web_service=no'
            , http_hit_time = '2024-02-21 10:51:28.501'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '0.349'
            , error_description = ''
            , memory_used = '1560056'
            WHERE id = '34829';
[02/21/2024 10:51:28], [file name :-/home/otrams/public_html/beta/call.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', 'd1/21_02_2024/request_availability_Deepak_T__3_10_51_28_1708512688.xml', 'd1/21_02_2024/response_availability_Deepak_T__3_10_51_28_1708512688.xml', 'd1/21_02_2024/response_header_availability_Deepak_T__3_10_51_28_1708512688.xml', 'dotw', '2024-02-21 10:51:28', '', '00819bb642b8042f54483e1feb05c56dbab1ffa58130dda94d5688d939987fa9', '0');
[02/21/2024 10:51:28], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=dotw&sessionid=00819bb642b8042f54483e1feb05c56dbab1ffa58130dda94d5688d939987fa9&xml_user_id=7857&db_caching=1&destination_code=364&country_code=6&language=&web_service=no&hotels_ids=&erequest=3&total_request=9&web_service=no'
            , http_hit_time = '2024-02-21 10:51:28.501'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '0.361'
            , error_description = ''
            , memory_used = '1560088'
            WHERE id = '34830';
[02/21/2024 10:51:28], [file name :-/home/otrams/public_html/beta/call.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', 'd1/21_02_2024/request_availability_Deepak_T__4_10_51_28_1708512688.xml', 'd1/21_02_2024/response_availability_Deepak_T__4_10_51_28_1708512688.xml', 'd1/21_02_2024/response_header_availability_Deepak_T__4_10_51_28_1708512688.xml', 'dotw', '2024-02-21 10:51:28', '', '00819bb642b8042f54483e1feb05c56dbab1ffa58130dda94d5688d939987fa9', '0');
[02/21/2024 10:51:28], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=dotw&sessionid=00819bb642b8042f54483e1feb05c56dbab1ffa58130dda94d5688d939987fa9&xml_user_id=7857&db_caching=1&destination_code=364&country_code=6&language=&web_service=no&hotels_ids=&erequest=4&total_request=9&web_service=no'
            , http_hit_time = '2024-02-21 10:51:28.501'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '0.371'
            , error_description = ''
            , memory_used = '1570864'
            WHERE id = '34831';
[02/21/2024 10:51:28], [file name :-/home/otrams/public_html/beta/call.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', 'd1/21_02_2024/request_availability_Deepak_T__2_10_51_28_1708512688.xml', 'd1/21_02_2024/response_availability_Deepak_T__2_10_51_28_1708512688.xml', 'd1/21_02_2024/response_header_availability_Deepak_T__2_10_51_28_1708512688.xml', 'dotw', '2024-02-21 10:51:28', '', '00819bb642b8042f54483e1feb05c56dbab1ffa58130dda94d5688d939987fa9', '0');
[02/21/2024 10:51:28], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=dotw&sessionid=00819bb642b8042f54483e1feb05c56dbab1ffa58130dda94d5688d939987fa9&xml_user_id=7857&db_caching=1&destination_code=364&country_code=6&language=&web_service=no&hotels_ids=&erequest=2&total_request=9&web_service=no'
            , http_hit_time = '2024-02-21 10:51:28.501'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '0.379'
            , error_description = ''
            , memory_used = '1560088'
            WHERE id = '34832';
[02/21/2024 10:51:28], [file name :-/home/otrams/public_html/beta/call.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', 'd1/21_02_2024/request_availability_Deepak_T__7_10_51_28_1708512688.xml', 'd1/21_02_2024/response_availability_Deepak_T__7_10_51_28_1708512688.xml', 'd1/21_02_2024/response_header_availability_Deepak_T__7_10_51_28_1708512688.xml', 'dotw', '2024-02-21 10:51:28', '', '00819bb642b8042f54483e1feb05c56dbab1ffa58130dda94d5688d939987fa9', '0');
[02/21/2024 10:51:28], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=dotw&sessionid=00819bb642b8042f54483e1feb05c56dbab1ffa58130dda94d5688d939987fa9&xml_user_id=7857&db_caching=1&destination_code=364&country_code=6&language=&web_service=no&hotels_ids=&erequest=7&total_request=9&web_service=no'
            , http_hit_time = '2024-02-21 10:51:28.501'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '0.388'
            , error_description = ''
            , memory_used = '1560088'
            WHERE id = '34833';
[02/21/2024 10:51:29], [file name :-/home/otrams/public_html/beta/call.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', 'e1/21_02_2024/request_availability_Deepak_T_10_51_28_1708512688_22.json', 'e1/21_02_2024/response_availability_Deepak_T_10_51_28_1708512688_22.json', 'e1/21_02_2024/response_header_availability_Deepak_T_10_51_28_1708512688_22.json', 'expedia', '2024-02-21 10:51:29', '', '00819bb642b8042f54483e1feb05c56dbab1ffa58130dda94d5688d939987fa9', '0');
[02/21/2024 10:51:29], [file name :-/home/otrams/public_html/beta/call.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', 'e1/21_02_2024/request_availability_Deepak_T_10_51_28_1708512688_36.json', 'e1/21_02_2024/response_availability_Deepak_T_10_51_28_1708512688_36.json', 'e1/21_02_2024/response_header_availability_Deepak_T_10_51_28_1708512688_36.json', 'expedia', '2024-02-21 10:51:29', '', '00819bb642b8042f54483e1feb05c56dbab1ffa58130dda94d5688d939987fa9', '0');
[02/21/2024 10:51:29], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=00819bb642b8042f54483e1feb05c56dbab1ffa58130dda94d5688d939987fa9&xml_user_id=7857&db_caching=1&erequest=0&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-02-21 10:51:28.501'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '0.759'
            , error_description = ''
            , memory_used = '14411072'
            WHERE id = '34834';
[02/21/2024 10:51:29], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=00819bb642b8042f54483e1feb05c56dbab1ffa58130dda94d5688d939987fa9&xml_user_id=7857&db_caching=1&erequest=1&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-02-21 10:51:28.501'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '0.780'
            , error_description = ''
            , memory_used = '18688320'
            WHERE id = '34835';
[02/21/2024 10:51:29], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:51:29' WHERE id= '582';
[02/21/2024 10:51:31], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:51:31' WHERE id= '582';
[02/21/2024 10:51:35], [file name :-/home/otrams/public_html/beta/show_hotel_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:51:35' WHERE id= '582';
[02/21/2024 10:51:35], [file name :-/home/otrams/public_html/beta/show_hotel_details.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Phoenix Hotel', 'dubai', '138', '7857', '', '23', '', 'hoteldetails', '2024-02-21 :10:51:35','');
[02/21/2024 10:51:36], [file name :-/home/otrams/public_html/beta/view_map.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:51:36' WHERE id= '582';
[02/21/2024 10:51:36], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:51:36' WHERE id= '584';
[02/21/2024 10:51:36], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1708512696','43.239.53.130');
[02/21/2024 10:51:37], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:51:37' WHERE id= '584';
[02/21/2024 10:51:37], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO bookings set reservation_id='3055',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='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 28 Apr 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 28 Apr 2024 at 03:00 hrs',current_status='inprocess-booking',booking_status='1',sales_manager_id='0',create_date='2024-02-21 10:51:37',source_type='viator',expiration_date= '2024-04-28 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-04-30',sub_user_id='',check_out_date='2024-04-30',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';
[02/21/2024 10:51:37], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO sight_bookings set booking_id='479',native_nightly_rates='a:2:{s:4:\"size\";i:1;s:17:\"nativeNightlyRate\";d:161.03;}',rate_description='',display_nightly_rates='a:4:{s:4:\"size\";i:1;s:18:\"displayNightlyRate\";d:161.03;s:25:\"displayNightlyRateDisplay\";s:134:\"Rate - 161.03 USD, Currency Multiplier (USD-USD) - 1.00000, Markup  in % - %, Markup Amount - , Markup Amount in  - ,Other Markup - 0%\";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 - V2',tour_time='',tour_details='',tour_inclusive='B<br/>',tour_exclusive='E<br/>',meeting_point='',tour_dep_point=' ',tour_language='en/SERVICE_GUIDE',tour_supplier_phone='',additional_tour_dep_point='',tour_duration='10 hours 0 minutes<br> Start Time: 11:00',arrival_date='2024-04-30',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/21/2024 10:51:37], [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','3055','2024-02-21 10:51:37',0);
[02/21/2024 10:51: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/21_02_2024/request_reservation_sight_Viator_test_10_51_37_1708512697.json', 'v1/21_02_2024/response_reservation_sight_Viator_test_10_51_37_1708512697.json', 'v1/21_02_2024/response_header_reservation_sight_Viator_test_10_51_37_1708512697.json', 'viator', '2024-02-21 10:51:38', '', '', '1719');
[02/21/2024 10:51:38], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE posted_bookings set status=1 where id= '294';
[02/21/2024 10:51: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='161.03', supplier_rate='161.03', uid='', itenirary_id='', confirmation_number='', comment_contract='', current_status='failed', original_source='' where id='479';
[02/21/2024 10:51: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='479';
[02/21/2024 10:51: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
		('','','479','failed','2024-02-21 10:51:38','Sightseeing Booking failed by Agent..7851','7851','43.239.53.130','','','');
[02/21/2024 10:51: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('479','Mr','1','Shiv','Chauhan','adult','0');
[02/21/2024 10:51: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('479','Mr','1','Rohit','Kalla','adult','0');
[02/21/2024 10:51:38], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],update xmllogs set reservation_id='479' where agent_logs_id='1719' and source_type='viator';
[02/21/2024 10:51:51], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:51:51' WHERE id= '582';
[02/21/2024 10:51:51], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:51:51' WHERE id= '582';
[02/21/2024 10:51:51], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1708512711','43.239.53.130');
[02/21/2024 10:51:51], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'valuation', 'e1/21_02_2024/request_valuation_Deepak_T_10_51_51_1708512711_48.json', 'e1/21_02_2024/response_valuation_Deepak_T_10_51_51_1708512711_48.json', 'e1/21_02_2024/response_header_valuation_Deepak_T_10_51_51_1708512711_48.json', 'expedia', '2024-02-21 10:51:51', '', '00819bb642b8042f54483e1feb05c56dbab1ffa58130dda94d5688d939987fa9', '0');
[02/21/2024 10:51:51], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Phoenix Hotel', 'dubai', '138', '7857', '', '23', '', 'hotelcancellationpolicy', '2024-02-21 :10:51:51','');
[02/21/2024 10:52:13], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:52:13' WHERE id= '582';
[02/21/2024 10:52:13], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:52:13' WHERE id= '582';
[02/21/2024 10:52:13], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1708512733','43.239.53.130');
[02/21/2024 10:52:14], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'valuation', 'e1/21_02_2024/request_valuation_Deepak_T_10_52_13_1708512733_73.json', 'e1/21_02_2024/response_valuation_Deepak_T_10_52_13_1708512733_73.json', 'e1/21_02_2024/response_header_valuation_Deepak_T_10_52_13_1708512733_73.json', 'expedia', '2024-02-21 10:52:14', '', '00819bb642b8042f54483e1feb05c56dbab1ffa58130dda94d5688d939987fa9', '0');
[02/21/2024 10:52:23], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:52:23' WHERE id= '582';
[02/21/2024 10:52:26], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-02-21 10:52:26',login_attempt=0 where id = '7849';
[02/21/2024 10:52:26], [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-21 10:52:26', ip = '43.239.53.130', action = 'Login' ;
[02/21/2024 10:52:26], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:52:26' WHERE id= '587';
[02/21/2024 10:52:29], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:52:29' WHERE id= '587';
[02/21/2024 10:52:32], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:52:32' WHERE id= '587';
[02/21/2024 10:52:33], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:52:33' WHERE id= '587';
[02/21/2024 10:52:46], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:52:46' WHERE id= '587';
[02/21/2024 10:52:46], [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/04/29',  departure_date='2024/04/29',  nights='1',  create_date='2024-02-21 :10:52:46',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[02/21/2024 10:52: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/21_02_2024/request_availability_shiv_qtech_10_52_46_1708512766.json', 'v1/21_02_2024/response_availability_shiv_qtech_10_52_46_1708512766.json', 'v1/21_02_2024/response_header_availability_shiv_qtech_10_52_46_1708512766.json', 'viator', '2024-02-21 10:52:49', '', '', '1720');
[02/21/2024 10:52:50], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:52:50' WHERE id= '587';
[02/21/2024 10:52:50], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:52:50' WHERE id= '587';
[02/21/2024 10:52:53], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:52:53' WHERE id= '587';
[02/21/2024 10:52: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/21_02_2024/request_sight_details_shiv_qtech_10_52_53_1708512773.json', 'v1/21_02_2024/response_sight_details_shiv_qtech_10_52_53_1708512773.json', 'v1/21_02_2024/response_header_sight_details_shiv_qtech_10_52_53_1708512773.json', 'viator', '2024-02-21 10:52:53', '', '', '1720');
[02/21/2024 10:52: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/21_02_2024/request_sight_details_shiv_qtech_10_52_53_1708512773.json', 'v1/21_02_2024/response_sight_details_shiv_qtech_10_52_53_1708512773.json', 'v1/21_02_2024/response_header_sight_details_shiv_qtech_10_52_53_1708512773.json', 'viator', '2024-02-21 10:52:54', '', '', '1720');
[02/21/2024 10:52:54], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:52:54' WHERE id= '584';
[02/21/2024 10:52:57], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:52:57' WHERE id= '584';
[02/21/2024 10:52:57], [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/04/30',  departure_date='2024/04/30',  nights='1',  create_date='2024-02-21 :10:52:57',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[02/21/2024 10:52:57], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:52:57' WHERE id= '587';
[02/21/2024 10:52: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 ('', 'check_availability', 'v1/21_02_2024/request_check_availability_shiv_qtech_10_52_57_1708512777.json', 'v1/21_02_2024/response_check_availability_shiv_qtech_10_52_57_1708512777.json', 'v1/21_02_2024/response_header_check_availability_shiv_qtech_10_52_57_1708512777.json', 'viator', '2024-02-21 10:52:58', '', '', '1720');
[02/21/2024 10:52: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/21_02_2024/request_availability_Viator_test_10_52_57_1708512777.json', 'v1/21_02_2024/response_availability_Viator_test_10_52_57_1708512777.json', 'v1/21_02_2024/response_header_availability_Viator_test_10_52_57_1708512777.json', 'viator', '2024-02-21 10:52:58', '', '', '1721');
[02/21/2024 10:52:59], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:52:59' WHERE id= '584';
[02/21/2024 10:53:00], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:53:00' WHERE id= '584';
[02/21/2024 10:53:01], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:53:01' WHERE id= '587';
[02/21/2024 10:53:01], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1708512781','43.239.53.130');
[02/21/2024 10:53:04], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:53:04' WHERE id= '584';
[02/21/2024 10:53:04], [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/21_02_2024/request_sight_details_Viator_test_10_53_04_1708512784.json', 'v1/21_02_2024/response_sight_details_Viator_test_10_53_04_1708512784.json', 'v1/21_02_2024/response_header_sight_details_Viator_test_10_53_04_1708512784.json', 'viator', '2024-02-21 10:53:04', '', '', '1721');
[02/21/2024 10:53:04], [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/21_02_2024/request_sight_details_Viator_test_10_53_04_1708512784.json', 'v1/21_02_2024/response_sight_details_Viator_test_10_53_04_1708512784.json', 'v1/21_02_2024/response_header_sight_details_Viator_test_10_53_04_1708512784.json', 'viator', '2024-02-21 10:53:04', '', '', '1721');
[02/21/2024 10:53:08], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:53:08' WHERE id= '584';
[02/21/2024 10:53:08], [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/21_02_2024/request_check_availability_Viator_test_10_53_08_1708512788.json', 'v1/21_02_2024/response_check_availability_Viator_test_10_53_08_1708512788.json', 'v1/21_02_2024/response_header_check_availability_Viator_test_10_53_08_1708512788.json', 'viator', '2024-02-21 10:53:08', '', '', '1721');
[02/21/2024 10:53:16], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:53:16' WHERE id= '584';
[02/21/2024 10:53:16], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1708512796','43.239.53.130');
[02/21/2024 10:53:24], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:53:24' WHERE id= '584';
[02/21/2024 10:53:27], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:53:27' WHERE id= '584';
[02/21/2024 10:53:31], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:53:31' WHERE id= '584';
[02/21/2024 10:53:35], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:53:35' WHERE id= '584';
[02/21/2024 10:54:42], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:54:42' WHERE id= '584';
[02/21/2024 10:54:42], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1708512882','43.239.53.130');
[02/21/2024 10:54:43], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:54:43' WHERE id= '584';
[02/21/2024 10:54:43], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO bookings set reservation_id='3062',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='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 28 Apr 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 28 Apr 2024 at 03:00 hrs',current_status='inprocess-booking',booking_status='1',sales_manager_id='0',create_date='2024-02-21 10:54:43',source_type='viator',expiration_date= '2024-04-28 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-04-30',sub_user_id='',check_out_date='2024-04-30',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';
[02/21/2024 10:54:43], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO sight_bookings set booking_id='480',native_nightly_rates='a:2:{s:4:\"size\";i:1;s:17:\"nativeNightlyRate\";d:161.03;}',rate_description='',display_nightly_rates='a:4:{s:4:\"size\";i:1;s:18:\"displayNightlyRate\";d:161.03;s:25:\"displayNightlyRateDisplay\";s:134:\"Rate - 161.03 USD, Currency Multiplier (USD-USD) - 1.00000, Markup  in % - %, Markup Amount - , Markup Amount in  - ,Other Markup - 0%\";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 - V2',tour_time='',tour_details='',tour_inclusive='B<br/>',tour_exclusive='E<br/>',meeting_point='',tour_dep_point=' ',tour_language='en/SERVICE_GUIDE',tour_supplier_phone='',additional_tour_dep_point='',tour_duration='10 hours 0 minutes<br> Start Time: 11:00',arrival_date='2024-04-30',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/21/2024 10:54:43], [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','3062','2024-02-21 10:54:43',0);
[02/21/2024 10:54:46], [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/21_02_2024/request_reservation_sight_Viator_test_10_54_43_1708512883.json', 'v1/21_02_2024/response_reservation_sight_Viator_test_10_54_43_1708512883.json', 'v1/21_02_2024/response_header_reservation_sight_Viator_test_10_54_43_1708512883.json', 'viator', '2024-02-21 10:54:46', '', '', '1721');
[02/21/2024 10:54:47], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE posted_bookings set status=1 where id= '295';
[02/21/2024 10:54:47], [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='161.03', supplier_rate='161.03', uid='', itenirary_id='3062210', confirmation_number='BR-595645711', comment_contract='', current_status='confirmed', original_source='' where id='480';
[02/21/2024 10:54:47], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],update sight_bookings set gtaToken='',gta_item_confirm_ref='',viator_item_ref='BR-595645711',viator_ref='BR-595645711',viator_item_id='',viator_voucherKey='https://shop.live.rc.viator.com/ticket?code=1020344357:fd22ac1c82c5913775cc23aa4590ce3b1b7853bb49e002eabb3edabf08b3af2d:595645711',tour_supplier='',textaddition_activities='N;' where booking_id='480';
[02/21/2024 10:54:47], [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
		('','','480','confirmed','2024-02-21 10:54:47','Sightseeing Booking confirmed by Agent..7851','7851','43.239.53.130','','','');
[02/21/2024 10:54:47], [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('480','Mr','1','Shiv','Chauhan','adult','0');
[02/21/2024 10:54:47], [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('480','Mr','1','Rohit','Kalla','adult','0');
[02/21/2024 10:54:47], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],update xmllogs set reservation_id='480' where agent_logs_id='1721' and source_type='viator';
[02/21/2024 10:56:33], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:56:33' WHERE id= '584';
[02/21/2024 10:56:33], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-02-21 10:56:33',login_attempt=0 where id = '7851';
[02/21/2024 10:56:33], [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-02-21 10:56:33', ip = '43.239.53.130', action = 'Login' ;
[02/21/2024 10:56:34], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:56:34' WHERE id= '584';
[02/21/2024 10:57:47], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:57:47' WHERE id= '584';
[02/21/2024 10:57:50], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:57:50' WHERE id= '584';
[02/21/2024 10:59:03], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:59:03' WHERE id= '584';
[02/21/2024 10:59:03], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7851' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '27' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/03/28',  departure_date='2024/03/28',  nights='1',  create_date='2024-02-21 :10:59:03',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[02/21/2024 10:59:04], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'v1/21_02_2024/request_availability_Viator_test_10_59_03_1708513143.json', 'v1/21_02_2024/response_availability_Viator_test_10_59_03_1708513143.json', 'v1/21_02_2024/response_header_availability_Viator_test_10_59_03_1708513143.json', 'viator', '2024-02-21 10:59:04', '', '', '1722');
[02/21/2024 10:59:05], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:59:05' WHERE id= '584';
[02/21/2024 10:59:05], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-21 10:59:05' WHERE id= '584';
