[03/28/2024 12:02:05], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:02:05' WHERE id= '728';
[03/28/2024 12:02:09], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:02:09' WHERE id= '728';
[03/28/2024 12:04:53], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-03-28 12:04:53',login_attempt=0 where id = '7866';
[03/28/2024 12:04:53], [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-03-28 12:04:53', ip = '43.239.53.130', action = 'Login' ;
[03/28/2024 12:04:54], [file name :-/home/otrams/public_html/beta/hotel_search.php],insert into user_sessions_ip SET ip_addr='43.239.53.130', agent_id='7863', session_id='168cfc4dde354a30ce85c4e3f3f00fb3fb79380e86cb02f0a5b6bc3ebbc9e42f',create_date='2024-03-28 12:04:54', update_date='2024-03-28 12:04:54',domain='baysantravel.astrabookings.com',sub_agent_id='',sub_user_id='';
[03/28/2024 12:06:52], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:06:52' WHERE id= '729';
[03/28/2024 12:06:56], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:06:56' WHERE id= '729';
[03/28/2024 12:07:01], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:07:01' WHERE id= '729';
[03/28/2024 12:07:01], [file name :-/home/otrams/public_html/beta/booking_list.php],update messages set mssg_status='R' where booking_id=?;
[03/28/2024 12:07:20], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:07:20' WHERE id= '705';
[03/28/2024 12:07:20], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7851' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '27' , ip = '43.239.53.130' , city = 'belize' , arrival_date='2024/04/18',  departure_date='2024/04/18',  nights='1',  create_date='2024-03-28 :12:07:20',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[03/28/2024 12:07:45], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'v1/28_03_2024/request_availability_Viator_test_12_07_20_1711627640.json', 'v1/28_03_2024/response_availability_Viator_test_12_07_20_1711627640.json', 'v1/28_03_2024/response_header_availability_Viator_test_12_07_20_1711627640.json', 'viator', '2024-03-28 12:07:45', '', '', '669');
[03/28/2024 12:07:51], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'v1/28_03_2024/request_availability_Viator_test_12_07_45_1711627665_40.json', 'v1/28_03_2024/response_availability_Viator_test_12_07_45_1711627665_40.json', 'v1/28_03_2024/response_header_availability_Viator_test_12_07_45_1711627665_40.json', 'viator', '2024-03-28 12:07:51', '', '', '669');
[03/28/2024 12:07:51], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'v1/28_03_2024/request_availability_Viator_test_12_07_45_1711627665_40.json', 'v1/28_03_2024/response_availability_Viator_test_12_07_45_1711627665_40.json', 'v1/28_03_2024/response_header_availability_Viator_test_12_07_45_1711627665_40.json', 'viator', '2024-03-28 12:07:51', '', '', '669');
[03/28/2024 12:07:51], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'v1/28_03_2024/request_availability_Viator_test_12_07_45_1711627665_40.json', 'v1/28_03_2024/response_availability_Viator_test_12_07_45_1711627665_40.json', 'v1/28_03_2024/response_header_availability_Viator_test_12_07_45_1711627665_40.json', 'viator', '2024-03-28 12:07:51', '', '', '669');
[03/28/2024 12:07:51], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'v1/28_03_2024/request_availability_Viator_test_12_07_45_1711627665_40.json', 'v1/28_03_2024/response_availability_Viator_test_12_07_45_1711627665_40.json', 'v1/28_03_2024/response_header_availability_Viator_test_12_07_45_1711627665_40.json', 'viator', '2024-03-28 12:07:51', '', '', '669');
[03/28/2024 12:07:51], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'v1/28_03_2024/request_availability_Viator_test_12_07_45_1711627665_40.json', 'v1/28_03_2024/response_availability_Viator_test_12_07_45_1711627665_40.json', 'v1/28_03_2024/response_header_availability_Viator_test_12_07_45_1711627665_40.json', 'viator', '2024-03-28 12:07:51', '', '', '669');
[03/28/2024 12:07:51], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'v1/28_03_2024/request_availability_Viator_test_12_07_45_1711627665_40.json', 'v1/28_03_2024/response_availability_Viator_test_12_07_45_1711627665_40.json', 'v1/28_03_2024/response_header_availability_Viator_test_12_07_45_1711627665_40.json', 'viator', '2024-03-28 12:07:51', '', '', '669');
[03/28/2024 12:07:51], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'v1/28_03_2024/request_availability_Viator_test_12_07_45_1711627665_40.json', 'v1/28_03_2024/response_availability_Viator_test_12_07_45_1711627665_40.json', 'v1/28_03_2024/response_header_availability_Viator_test_12_07_45_1711627665_40.json', 'viator', '2024-03-28 12:07:51', '', '', '669');
[03/28/2024 12:07:51], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'v1/28_03_2024/request_availability_Viator_test_12_07_45_1711627665_40.json', 'v1/28_03_2024/response_availability_Viator_test_12_07_45_1711627665_40.json', 'v1/28_03_2024/response_header_availability_Viator_test_12_07_45_1711627665_40.json', 'viator', '2024-03-28 12:07:51', '', '', '669');
[03/28/2024 12:07:51], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'v1/28_03_2024/request_availability_Viator_test_12_07_45_1711627665_40.json', 'v1/28_03_2024/response_availability_Viator_test_12_07_45_1711627665_40.json', 'v1/28_03_2024/response_header_availability_Viator_test_12_07_45_1711627665_40.json', 'viator', '2024-03-28 12:07:51', '', '', '669');
[03/28/2024 12:07:54], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:07:54' WHERE id= '705';
[03/28/2024 12:07:54], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:07:54' WHERE id= '705';
[03/28/2024 12:08:46], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:08:46' WHERE id= '705';
[03/28/2024 12:08: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/28_03_2024/request_sight_details_Viator_test_12_08_46_1711627726.json', 'v1/28_03_2024/response_sight_details_Viator_test_12_08_46_1711627726.json', 'v1/28_03_2024/response_header_sight_details_Viator_test_12_08_46_1711627726.json', 'viator', '2024-03-28 12:08:47', '', '', '669');
[03/28/2024 12:08: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/28_03_2024/request_sight_details_Viator_test_12_08_47_1711627727.json', 'v1/28_03_2024/response_sight_details_Viator_test_12_08_47_1711627727.json', 'v1/28_03_2024/response_header_sight_details_Viator_test_12_08_47_1711627727.json', 'viator', '2024-03-28 12:08:47', '', '', '669');
[03/28/2024 12:08:52], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:08:52' WHERE id= '705';
[03/28/2024 12:08:52], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'check_availability', 'v1/28_03_2024/request_check_availability_Viator_test_12_08_52_1711627732.json', 'v1/28_03_2024/response_check_availability_Viator_test_12_08_52_1711627732.json', 'v1/28_03_2024/response_header_check_availability_Viator_test_12_08_52_1711627732.json', 'viator', '2024-03-28 12:08:52', '', '', '669');
[03/28/2024 12:09:10], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:09:10' WHERE id= '705';
[03/28/2024 12:09:10], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1711627750','43.239.53.130');
[03/28/2024 12:10:10], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:10:10' WHERE id= '705';
[03/28/2024 12:10:11], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:10:11' WHERE id= '705';
[03/28/2024 12:10:12], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:10:12' WHERE id= '705';
[03/28/2024 12:10:21], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:10:21' WHERE id= '705';
[03/28/2024 12:10: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/28_03_2024/request_sight_details_Viator_test_12_10_21_1711627821.json', 'v1/28_03_2024/response_sight_details_Viator_test_12_10_21_1711627821.json', 'v1/28_03_2024/response_header_sight_details_Viator_test_12_10_21_1711627821.json', 'viator', '2024-03-28 12:10:21', '', '', '669');
[03/28/2024 12:10: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/28_03_2024/request_sight_details_Viator_test_12_10_21_1711627821.json', 'v1/28_03_2024/response_sight_details_Viator_test_12_10_21_1711627821.json', 'v1/28_03_2024/response_header_sight_details_Viator_test_12_10_21_1711627821.json', 'viator', '2024-03-28 12:10:22', '', '', '669');
[03/28/2024 12:10:24], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:10:24' WHERE id= '705';
[03/28/2024 12:10:24], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'check_availability', 'v1/28_03_2024/request_check_availability_Viator_test_12_10_24_1711627824.json', 'v1/28_03_2024/response_check_availability_Viator_test_12_10_24_1711627824.json', 'v1/28_03_2024/response_header_check_availability_Viator_test_12_10_24_1711627824.json', 'viator', '2024-03-28 12:10:24', '', '', '669');
[03/28/2024 12:11:16], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:11:16' WHERE id= '705';
[03/28/2024 12:11:16], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1711627876','43.239.53.130');
[03/28/2024 12:13:12], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:13:12' WHERE id= '705';
[03/28/2024 12:13:15], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:13:15' WHERE id= '705';
[03/28/2024 12:13:20], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:13:20' WHERE id= '705';
[03/28/2024 12:13:24], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:13:24' WHERE id= '705';
[03/28/2024 12:13:45], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:13:45' WHERE id= '705';
[03/28/2024 12:13:45], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1711628025','43.239.53.130');
[03/28/2024 12:13:46], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:13:46' WHERE id= '705';
[03/28/2024 12:13:46], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO bookings set reservation_id='4261',agent_id='7851',leader_title='Mr',leader_first_name='shiv',leader_last_name='chauhan',city_id='belize',country_id='5',nationality='Belizean',display_room_rate='198.08',display_currency_code='USD',native_room_rate='198.08',consultant_id='SUJAY_QTECH',native_currency_code='USD',cancellation_policy='Cancellation Charges will be applicable if cancelled after 18 Apr 2024 00:00 hrs.<BR>Late amendment charge may apply.',current_status='inprocess-booking',booking_status='1',sales_manager_id='0',create_date='2024-03-28 12:13:46',source_type='viator',expiration_date= '2024-04-17 21:00:00',applied_multiplier='1.00000',applied_markup='0',agent_markup='0',basecurrency_multiplier='1.00000',basecurrency_multiplier_native='1.00000',admin_booked='0',service_date='2024-04-18',sub_user_id='',check_out_date='2024-04-18',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';
[03/28/2024 12:13:46], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO sight_bookings set booking_id='569',native_nightly_rates='a:2:{s:4:\"size\";i:1;s:17:\"nativeNightlyRate\";d:198.08000000000001;}',rate_description='',display_nightly_rates='a:4:{s:4:\"size\";i:1;s:18:\"displayNightlyRate\";d:198.08000000000001;s:25:\"displayNightlyRateDisplay\";s:134:\"Rate - 198.08 USD, Currency Multiplier (USD-USD) - 1.00000, Markup  in % - %, Markup Amount - , Markup Amount in  - ,Other Markup - 0%\";s:23:\"displayNightlyRateStore\";s:135:\"Rate - 198.08 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='9025P1',sight_name='CAVE TUBING FROM BELIZE CITY - V2',tour_time='',tour_details='',tour_inclusive='H<br/>',tour_exclusive='G<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: 09:00',arrival_date='2024-04-18',total_adults='2',total_children='0',total_infants='0',gta_city_code='5094',supplier_id='9025P1',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='';
[03/28/2024 12:13:46], [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','4261','2024-03-28 12:13:46',0);
[03/28/2024 12:13:49], [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/28_03_2024/request_reservation_sight_Viator_test_12_13_46_1711628026.json', 'v1/28_03_2024/response_reservation_sight_Viator_test_12_13_46_1711628026.json', 'v1/28_03_2024/response_header_reservation_sight_Viator_test_12_13_46_1711628026.json', 'viator', '2024-03-28 12:13:49', '', '', '669');
[03/28/2024 12:13:49], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE posted_bookings set status=1 where id= '496';
[03/28/2024 12:13:49], [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='198.08', supplier_rate='198.08', uid='', itenirary_id='4261887', confirmation_number='BR-596090759', comment_contract='', current_status='confirmed', original_source='' where id='569';
[03/28/2024 12:13:49], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],update sight_bookings set gtaToken='',gta_item_confirm_ref='',viator_item_ref='BR-596090759',viator_ref='BR-596090759',viator_item_id='',viator_voucherKey='https://shop.live.rc.viator.com/ticket?code=1020898533:e427a605ac876af9a62ed44be7fab9a3f60f89946b369e78936ba872f4d4c0d5:596090759',tour_supplier='',textaddition_activities='N;' where booking_id='569';
[03/28/2024 12:13:49], [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
		('','','569','confirmed','2024-03-28 12:13:49','Sightseeing Booking confirmed by Agent..7851','7851','43.239.53.130','','','');
[03/28/2024 12:13:49], [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('569','Mr','1','shiv','chauhan','adult','0');
[03/28/2024 12:13:49], [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('569','Mr','1','deepak','trivedi','adult','0');
[03/28/2024 12:13:49], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],update xmllogs set reservation_id='569' where agent_logs_id='669' and source_type='viator';
[03/28/2024 12:15:03], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_bookings set history_booking_id ='301', agent_id ='7863', itenirary_id ='7836835171571', confirmation_number ='7836835171571', payment_confirmation_no ='', voucher_id ='33', voucher_hashcode ='993828d8536a85f7e9238e514869385082138301', email_id ='', leader_title ='Mr', leader_first_name ='Sujay', leader_last_name ='Raut', city_id ='phuket', country_id ='136', display_room_rate ='47.780', native_room_rate ='43.440', native_currency_code ='USD', additional_charge ='0.000', cancellation_policy ='Free cancellation up to  19:58:59 on  2024-05-14<br>If you cancel between 2024-05-14 19:59:00 and 2024-05-16 00:00:00 , you will be charged 48.02 USD<br>No show is subject to a 100 % cancellation charge<br><br/><b>Amendment Policy</b><br/>
		Please note that most hotels treat changes in pax details, room category and dates as a cancellation of the booking, and charges will apply according to the cancellation policy.
		Late amendment charges may apply if requested after 19:59 on 14th of May 2024.
		Confirmation of amendments is subject to availability and rates at the time of making the amendment.', supplier_cancellation_policy ='', current_status ='vouchered', booking_status ='1', status_date ='2024-01-19 11:05:22', create_date ='2024-01-19 11:04:03', source_type ='expediapackage', expiration_date ='2024-05-14 16:59:00', comment_contract =' Bed Type Selection is not guaranteed.<br/><span style=\'color: red;\'><strong>Note</strong>: Nightly rates might be calculated based on the average of Total Rate</span><br><br><b>Amenities:</b>Free parking, Free WiFi<br><br><b>Deal:</b> Book now and save,<br><br/><br/><br/><b>Checkin Start Time :</b> , <br/><b>Checkin End Time :</b> , <br/><b>Min Checkin Age :</b> , <br/><b>Checkout Time :</b> ,<br/><b>Instructions :</b> ,<br/><b>Special Instructions :</b> ,<br/><b>Important Note :</b> Agent agree that this rate is being sold with approved transport component.', admin_note ='', is_payment_gateway ='0', service_type ='hotel', service_type_detail ='', native_rate ='', display_rate ='', agent_rate ='47.780', wh_sub_agent_rate ='0.000', wh_agent_rate ='48.020', supplier_rate ='43.440', special_comment ='', special_remark ='', sms_status ='', is_xml ='0', consultant_id ='Ayman', admin_booked ='0', emailed_status ='0', applied_multiplier ='1.00000', applied_markup ='9.99', wh_applied_markup ='0.500', original_voucher ='', subagent_markup ='', agent_markup ='9.99', wh_agent_markup ='0.500', basecurrency_multiplier ='1.00000', wh_basecurrency_multiplier ='1.00000', basecurrency_multiplier_native ='1.00000', wh_basecurrency_multiplier_native ='1.00000', agent_currency_multiplier ='1.00000', wh_agent_currency_multiplier ='1.00000', modified_datetime ='2024-03-28 12:15:03', modified_by ='Ayman', display_currency_code ='USD', created_datetime ='2024-03-28 12:15:03', sub_agent_rate ='0.000', created_by ='Ayman', site_id ='20', applicable_service_tax ='0.000', wh_parent_agent_id ='7866', wh_agent_id ='7866', nationality ='Emirati', ip_addr ='43.239.53.130';
[03/28/2024 12:15:03], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_bookings_details  set  history_booking_detail_id ='166', old_reff_id ='73', booking_id ='301', supplier_id ='', total_nights ='1', arrival_date ='2024/05/16', departure_date ='2024/05/17', hotel_id ='2510986', hotel_name ='Phuketa Hotel', hotel_address1 ='24/5 Moo 6, Thepkrasatri Rd.', hotel_phone ='+6676241427', hotel_rating ='4.0', rate_code ='', touricoRoomResId ='', gta_item_confirm_ref ='', channel_manager ='', reservation_pushed ='0', gtaToken ='';
[03/28/2024 12:15:03], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_passangers set history_passenger_id = '326', old_reff_id = '73', booking_id = '301', booking_detail_id = '1', salutations = 'Mr', room = '0', rid = '169', first_name = 'Sujay', last_name = 'Raut' ,passenger_type = 'adult' ,age = '';
[03/28/2024 12:15:03], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_passangers set history_passenger_id = '327', old_reff_id = '73', booking_id = '301', booking_detail_id = '1', salutations = 'Mr', room = '1', rid = '169', first_name = 'TBA', last_name = 'TBA' ,passenger_type = 'adult' ,age = '';
[03/28/2024 12:15:03], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],delete from passangers WHERE booking_id=?;
[03/28/2024 12:15:03], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_booking_room_detail set rid = '169', old_reff_id = '73', booking_id = '301', booking_detail_id = '1', room_type_code = '', room_name = 'single', room_type_description = 'FullBed Deluxe Front View (Double)(Room Only)- <font color=\'red\'>Package Deal</font> <b><font color=\'#265db7\'>(Book now and save)</font></b><br>(1 Double Bed)', display_nightly_rates = 'a:1:{i:0;a:3:{s:18:"displayNightlyRate";d:23.890000000000001;s:25:"displayNightlyRateDisplay";s:197:"Rate - 21.72, Currency Multiplier (USD-USD) - 1.00000, Markup in % - 10.00%, Markup Amount - 0, Markup Amount in SAR- 0.00, Supplier Commission - 2.07 USD, Marketing Fee - 2.07  USD #expediapackage";s:13:"whNightlyRate";d:24.010000000000002;}}' ,native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";d:21.719999999999999;}}' ,native_room_rate_total = '43.44' ,display_room_rate_total = '47.78' ,wh_room_rate_total = '48.02' ,number_of_rooms = '2';
[03/28/2024 12:15:03], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],delete from booking_room_detail WHERE booking_id=?;
[03/28/2024 12:15:03], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],delete from passangers WHERE booking_id=?;
[03/28/2024 12:15:03], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO booking_room_detail set booking_id = '301', booking_detail_id = '166', room_type_code = '', room_name = 'single', room_type_description = 'FullBed Deluxe Front View (Double)(Room Only)- Package Deal (Book now and save)(1 Double Bed)', display_nightly_rates = 'a:1:{i:0;a:2:{s:18:"displayNightlyRate";s:2:"25";s:13:"whNightlyRate";s:5:"24.32";}}' ,native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";s:2:"22";}}' ,native_room_rate_total = '44' ,display_room_rate_total = '50' ,number_of_rooms = '2';
[03/28/2024 12:15:03], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO passangers set booking_id = '301', booking_detail_id = '166', salutations = 'Mr', room = '', rid = '275', first_name = 'Sujay', last_name = 'Raut' ,age = '';
[03/28/2024 12:15:03], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO passangers set booking_id = '301', booking_detail_id = '166', salutations = 'Mr', room = '', rid = '275', first_name = 'TBA', last_name = 'TBA' ,age = '';
[03/28/2024 12:15:03], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],UPDATE bookings SET confirmation_number='7836835171571',cancellation_policy='						Free cancellation up to  19:58:59 on  2024-05-14&lt;br&gt;If you cancel between 2024-05-14 19:59:00 and 2024-05-16 00:00:00 , you will be charged 48.02 USD&lt;br&gt;No show is subject to a 100 % cancellation charge&lt;br&gt;&lt;br/&gt;&lt;b&gt;Amendment Policy&lt;/b&gt;&lt;br/&gt;
		Please note that most hotels treat changes in pax details, room category and dates as a cancellation of the booking, and charges will apply according to the cancellation policy.
		Late amendment charges may apply if requested after 19:59 on 14th of May 2024.
		Confirmation of amendments is subject to availability and rates at the time of making the amendment.
											',supplier_cancellation_policy='',applied_multiplier='1.00000',applied_markup='13.636363636364',agent_markup='13.636363636364',consultant_id='Ayman',basecurrency_multiplier='1.00000',basecurrency_multiplier_native='1.00000'_native,agent_currency_multiplier='1.00000',current_status='vouchered',status_date='2024-03-28 12:15:03',service_date='2024-05-16',check_out_date='2024-05-17',display_room_rate= '50',display_discount='0',modified_datetime='2024-03-28 12:15:03',modified_by ='Ayman',native_room_rate='44',native_discount='0.000',additional_charge='0.000',applicable_service_tax='',leader_title='Mr',leader_first_name='Sujay',leader_last_name='Raut',nationality ='Emirati',booking_type ='online',supplier_profile_id ='43',expiration_date= '2024-05-14 16:59:00',source_type='expediapackage',special_comment='',admin_note='',comment_contract=' Bed Type Selection is not guaranteed.&lt;br/&gt;&lt;span style=\&#039;color: red;\&#039;&gt;&lt;strong&gt;Note&lt;/strong&gt;: Nightly rates might be calculated based on the average of Total Rate&lt;/span&gt;&lt;br&gt;&lt;br&gt;&lt;b&gt;Amenities:&lt;/b&gt;Free parking, Free WiFi&lt;br&gt;&lt;br&gt;&lt;b&gt;Deal:&lt;/b&gt; Book now and save,&lt;br&gt;&lt;br/&gt;&lt;br/&gt;&lt;br/&gt;&lt;b&gt;Checkin Start Time :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Checkin End Time :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Min Checkin Age :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Checkout Time :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Instructions :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Special Instructions :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Important Note :&lt;/b&gt; Agent agree that this rate is being sold with approved transport component.' WHERE id='301';
[03/28/2024 12:15:03], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],update bookings set  parent_agent_id='7863', sub_agent_rate='', agent_rate='50', agent_markup='13.636363636364', supplier_rate='44', wh_sub_agent_rate='', wh_agent_rate='48.64' where id='301';
[03/28/2024 12:15:03], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php], insert into booking_rate_info set  booking_id = '301', booking_log = 'Booking Modified', create_date = '2024-03-28 12:15:03', supplier_currency ='USD', type = 'Ammended', agent_price = '2.22', sub_agent_price ='', supplier_price = '0.56', supplier_id = 'expediapackage', supplier_type = 'online';
[03/28/2024 12:15:03], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php], update wh_booking_rate_info set  booking_id = '301', booking_log = 'Booking Modified', create_date = '2024-03-28 12:15:03', agent_price = '48.640', sub_agent_price = '0.000', supplier_price = '50.000' where booking_id = '301'  and type = "Sale";
[03/28/2024 12:15:03], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],UPDATE agents SET credit_usage=credit_usage+('2.22'),   credit_value= credit_value-('2.22') ,  cd_credit_usage=cd_credit_usage+('2.22') , cd_credit_value=cd_credit_value-('2.22')  WHERE id = '7863';
[03/28/2024 12:15:03], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],insert into  agent_credit_log SET agent_id= '7863',credit_value= '999998674.300',credit_usage= '325.700',credit_limit= '999999000.000',receipt_id= '',amount= '2.22',booking_id='301',booking_cost= '50',receipt_allocation= '',balance= '50',ip='43.239.53.130',user_type='admin',admin_id='Ayman',temp_credit_limit='',log_type='Booking Modified',note='Booking Modified',create_date='2024-03-28 12:03:03';
[03/28/2024 12:15:03], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],UPDATE agents  SET credit_usage=credit_usage+('0.62'),   credit_value= credit_value-('0.62') ,  cd_credit_usage=cd_credit_usage+('0.62') , cd_credit_value=cd_credit_value-('0.62')  WHERE id = '7866';
[03/28/2024 12:15:03], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],insert into  agent_credit_log SET agent_id= '7866',credit_value= '-0.620',credit_usage= '0.620',credit_limit= '0.000',receipt_id= '',amount= '0.62',booking_id='301',booking_cost= '50',receipt_allocation= '',balance= '50',ip='43.239.53.130',user_type='admin',admin_id='Ayman',temp_credit_limit='',log_type='Booking Modified',note='Booking Modified',create_date='2024-03-28 12:03:03';
[03/28/2024 12:15:03], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],delete from  agent_commission   WHERE booking_id='301';
[03/28/2024 12:15:03], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO agent_commission SET booking_id ='301',booking_detail_id ='301',agent_id ='7863',is_sub_agent ='N',parent_id ='',display_commission ='6.0000000000002',display_currency ='USD',paid ='N',type ='hotel',description ='Agent Mark Up Percentage is 13.636363636364 %',create_date ='2024-03-28 12:15:03';
[03/28/2024 12:15:03], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],update bookings_details set total_nights='1' , supplier_id= 'expediapackage' , total_rooms= '2', arrival_date='2024/05/16', departure_date='2024/05/17', rate_code='~', hotel_address1='24/5 Moo 6, Thepkrasatri Rd.', hotel_name='Phuketa Hotel', hotel_phone='+6676241427' where booking_id ='301';
[03/28/2024 12:15:03], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
		('','','301','vouchered','2024-03-28 12:15:03','Booking Modified by Ayman','Ayman','43.239.53.130','Ayman','','');
[03/28/2024 12:15:04], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],insert into temp(booking_id,mail_send_to)values('301','Sujay.raut@qtechsoftware.com');
[03/28/2024 12:16:06], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:16:06' WHERE id= '705';
[03/28/2024 12:16:10], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:16:10' WHERE id= '705';
[03/28/2024 12:16:10], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7851' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '27' , ip = '43.239.53.130' , city = 'belize' , arrival_date='2024/04/18',  departure_date='2024/04/18',  nights='1',  create_date='2024-03-28 :12:16:10',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[03/28/2024 12:16: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/28_03_2024/request_availability_Viator_test_12_16_10_1711628170.json', 'v1/28_03_2024/response_availability_Viator_test_12_16_10_1711628170.json', 'v1/28_03_2024/response_header_availability_Viator_test_12_16_10_1711628170.json', 'viator', '2024-03-28 12:16:14', '', '', '670');
[03/28/2024 12:16:19], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'v1/28_03_2024/request_availability_Viator_test_12_16_14_1711628174_9.json', 'v1/28_03_2024/response_availability_Viator_test_12_16_14_1711628174_9.json', 'v1/28_03_2024/response_header_availability_Viator_test_12_16_14_1711628174_9.json', 'viator', '2024-03-28 12:16:19', '', '', '670');
[03/28/2024 12:16:19], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'v1/28_03_2024/request_availability_Viator_test_12_16_14_1711628174_9.json', 'v1/28_03_2024/response_availability_Viator_test_12_16_14_1711628174_9.json', 'v1/28_03_2024/response_header_availability_Viator_test_12_16_14_1711628174_9.json', 'viator', '2024-03-28 12:16:19', '', '', '670');
[03/28/2024 12:16:19], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'v1/28_03_2024/request_availability_Viator_test_12_16_14_1711628174_9.json', 'v1/28_03_2024/response_availability_Viator_test_12_16_14_1711628174_9.json', 'v1/28_03_2024/response_header_availability_Viator_test_12_16_14_1711628174_9.json', 'viator', '2024-03-28 12:16:19', '', '', '670');
[03/28/2024 12:16:19], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'v1/28_03_2024/request_availability_Viator_test_12_16_14_1711628174_9.json', 'v1/28_03_2024/response_availability_Viator_test_12_16_14_1711628174_9.json', 'v1/28_03_2024/response_header_availability_Viator_test_12_16_14_1711628174_9.json', 'viator', '2024-03-28 12:16:19', '', '', '670');
[03/28/2024 12:16:19], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'v1/28_03_2024/request_availability_Viator_test_12_16_14_1711628174_9.json', 'v1/28_03_2024/response_availability_Viator_test_12_16_14_1711628174_9.json', 'v1/28_03_2024/response_header_availability_Viator_test_12_16_14_1711628174_9.json', 'viator', '2024-03-28 12:16:19', '', '', '670');
[03/28/2024 12:16:19], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'v1/28_03_2024/request_availability_Viator_test_12_16_14_1711628174_9.json', 'v1/28_03_2024/response_availability_Viator_test_12_16_14_1711628174_9.json', 'v1/28_03_2024/response_header_availability_Viator_test_12_16_14_1711628174_9.json', 'viator', '2024-03-28 12:16:19', '', '', '670');
[03/28/2024 12:16:19], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'v1/28_03_2024/request_availability_Viator_test_12_16_14_1711628174_9.json', 'v1/28_03_2024/response_availability_Viator_test_12_16_14_1711628174_9.json', 'v1/28_03_2024/response_header_availability_Viator_test_12_16_14_1711628174_9.json', 'viator', '2024-03-28 12:16:19', '', '', '670');
[03/28/2024 12:16:19], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'v1/28_03_2024/request_availability_Viator_test_12_16_14_1711628174_9.json', 'v1/28_03_2024/response_availability_Viator_test_12_16_14_1711628174_9.json', 'v1/28_03_2024/response_header_availability_Viator_test_12_16_14_1711628174_9.json', 'viator', '2024-03-28 12:16:19', '', '', '670');
[03/28/2024 12:16:19], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'v1/28_03_2024/request_availability_Viator_test_12_16_14_1711628174_9.json', 'v1/28_03_2024/response_availability_Viator_test_12_16_14_1711628174_9.json', 'v1/28_03_2024/response_header_availability_Viator_test_12_16_14_1711628174_9.json', 'viator', '2024-03-28 12:16:19', '', '', '670');
[03/28/2024 12:16:21], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:16:21' WHERE id= '705';
[03/28/2024 12:16:22], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:16:22' WHERE id= '705';
[03/28/2024 12:16:27], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:16:27' WHERE id= '705';
[03/28/2024 12:16:27], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/28_03_2024/request_sight_details_Viator_test_12_16_27_1711628187.json', 'v1/28_03_2024/response_sight_details_Viator_test_12_16_27_1711628187.json', 'v1/28_03_2024/response_header_sight_details_Viator_test_12_16_27_1711628187.json', 'viator', '2024-03-28 12:16:27', '', '', '670');
[03/28/2024 12:16:27], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/28_03_2024/request_sight_details_Viator_test_12_16_27_1711628187.json', 'v1/28_03_2024/response_sight_details_Viator_test_12_16_27_1711628187.json', 'v1/28_03_2024/response_header_sight_details_Viator_test_12_16_27_1711628187.json', 'viator', '2024-03-28 12:16:27', '', '', '670');
[03/28/2024 12:16:30], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:16:30' WHERE id= '705';
[03/28/2024 12:16:30], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'check_availability', 'v1/28_03_2024/request_check_availability_Viator_test_12_16_30_1711628190.json', 'v1/28_03_2024/response_check_availability_Viator_test_12_16_30_1711628190.json', 'v1/28_03_2024/response_header_check_availability_Viator_test_12_16_30_1711628190.json', 'viator', '2024-03-28 12:16:30', '', '', '670');
[03/28/2024 12:16:39], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:16:39' WHERE id= '705';
[03/28/2024 12:16:39], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/28_03_2024/request_sight_details_Viator_test_12_16_39_1711628199.json', 'v1/28_03_2024/response_sight_details_Viator_test_12_16_39_1711628199.json', 'v1/28_03_2024/response_header_sight_details_Viator_test_12_16_39_1711628199.json', 'viator', '2024-03-28 12:16:39', '', '', '670');
[03/28/2024 12:16: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/28_03_2024/request_sight_details_Viator_test_12_16_39_1711628199.json', 'v1/28_03_2024/response_sight_details_Viator_test_12_16_39_1711628199.json', 'v1/28_03_2024/response_header_sight_details_Viator_test_12_16_39_1711628199.json', 'viator', '2024-03-28 12:16:40', '', '', '670');
[03/28/2024 12:16:42], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:16:42' WHERE id= '705';
[03/28/2024 12:16:42], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'check_availability', 'v1/28_03_2024/request_check_availability_Viator_test_12_16_42_1711628202.json', 'v1/28_03_2024/response_check_availability_Viator_test_12_16_42_1711628202.json', 'v1/28_03_2024/response_header_check_availability_Viator_test_12_16_42_1711628202.json', 'viator', '2024-03-28 12:16:42', '', '', '670');
[03/28/2024 12:16:53], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:16:53' WHERE id= '705';
[03/28/2024 12:16:53], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1711628213','43.239.53.130');
[03/28/2024 12:16:59], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:16:59' WHERE id= '705';
[03/28/2024 12:17:04], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:17:04' WHERE id= '705';
[03/28/2024 12:17:08], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:17:08' WHERE id= '705';
[03/28/2024 12:17:10], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:17:10' WHERE id= '705';
[03/28/2024 12:17:46], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_bookings set history_booking_id ='301', agent_id ='7863', itenirary_id ='7836835171571', confirmation_number ='7836835171571', payment_confirmation_no ='', voucher_id ='33', voucher_hashcode ='993828d8536a85f7e9238e514869385082138301', email_id ='', leader_title ='Mr', leader_first_name ='Sujay', leader_last_name ='Raut', city_id ='phuket', country_id ='136', display_room_rate ='50.000', native_room_rate ='44.000', native_currency_code ='USD', additional_charge ='0.000', cancellation_policy ='						Free cancellation up to  19:58:59 on  2024-05-14&lt;br&gt;If you cancel between 2024-05-14 19:59:00 and 2024-05-16 00:00:00 , you will be charged 48.02 USD&lt;br&gt;No show is subject to a 100 % cancellation charge&lt;br&gt;&lt;br/&gt;&lt;b&gt;Amendment Policy&lt;/b&gt;&lt;br/&gt;
		Please note that most hotels treat changes in pax details, room category and dates as a cancellation of the booking, and charges will apply according to the cancellation policy.
		Late amendment charges may apply if requested after 19:59 on 14th of May 2024.
		Confirmation of amendments is subject to availability and rates at the time of making the amendment.
											', supplier_cancellation_policy ='', current_status ='vouchered', booking_status ='1', status_date ='2024-03-28 12:15:03', create_date ='2024-01-19 11:04:03', source_type ='expediapackage', expiration_date ='2024-05-14 16:59:00', comment_contract =' Bed Type Selection is not guaranteed.&lt;br/&gt;&lt;span style=\\&#039;color: red;\\&#039;&gt;&lt;strong&gt;Note&lt;/strong&gt;: Nightly rates might be calculated based on the average of Total Rate&lt;/span&gt;&lt;br&gt;&lt;br&gt;&lt;b&gt;Amenities:&lt;/b&gt;Free parking, Free WiFi&lt;br&gt;&lt;br&gt;&lt;b&gt;Deal:&lt;/b&gt; Book now and save,&lt;br&gt;&lt;br/&gt;&lt;br/&gt;&lt;br/&gt;&lt;b&gt;Checkin Start Time :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Checkin End Time :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Min Checkin Age :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Checkout Time :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Instructions :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Special Instructions :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Important Note :&lt;/b&gt; Agent agree that this rate is being sold with approved transport component.', admin_note ='', is_payment_gateway ='0', service_type ='hotel', service_type_detail ='', native_rate ='', display_rate ='', agent_rate ='50.000', wh_sub_agent_rate ='0.000', wh_agent_rate ='48.640', supplier_rate ='44.000', special_comment ='', special_remark ='', sms_status ='', is_xml ='0', consultant_id ='Ayman', admin_booked ='0', emailed_status ='0', applied_multiplier ='1.00000', applied_markup ='13.636363636364', wh_applied_markup ='0.500', original_voucher ='', subagent_markup ='', agent_markup ='13.636363636364', wh_agent_markup ='0.500', basecurrency_multiplier ='1.00000', wh_basecurrency_multiplier ='1.00000', basecurrency_multiplier_native ='1.00000', wh_basecurrency_multiplier_native ='1.00000', agent_currency_multiplier ='1.00000', wh_agent_currency_multiplier ='1.00000', modified_datetime ='2024-03-28 12:17:46', modified_by ='Ayman', display_currency_code ='USD', created_datetime ='2024-03-28 12:17:46', sub_agent_rate ='0.000', created_by ='Ayman', site_id ='20', applicable_service_tax ='0.000', wh_parent_agent_id ='7866', wh_agent_id ='7866', nationality ='Emirati', ip_addr ='43.239.53.130';
[03/28/2024 12:17:46], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_bookings_details  set  history_booking_detail_id ='166', old_reff_id ='74', booking_id ='301', supplier_id ='expediapack', total_nights ='1', arrival_date ='2024/05/16', departure_date ='2024/05/17', hotel_id ='2510986', hotel_name ='Phuketa Hotel', hotel_address1 ='24/5 Moo 6, Thepkrasatri Rd.', hotel_phone ='+6676241427', hotel_rating ='4.0', rate_code ='~', touricoRoomResId ='', gta_item_confirm_ref ='', channel_manager ='', reservation_pushed ='0', gtaToken ='';
[03/28/2024 12:17:46], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_passangers set history_passenger_id = '523', old_reff_id = '74', booking_id = '301', booking_detail_id = '166', salutations = 'Mr', room = '0', rid = '275', first_name = 'Sujay', last_name = 'Raut' ,passenger_type = 'adult' ,age = '';
[03/28/2024 12:17:46], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_passangers set history_passenger_id = '524', old_reff_id = '74', booking_id = '301', booking_detail_id = '166', salutations = 'Mr', room = '0', rid = '275', first_name = 'TBA', last_name = 'TBA' ,passenger_type = 'adult' ,age = '';
[03/28/2024 12:17:46], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],delete from passangers WHERE booking_id=?;
[03/28/2024 12:17:46], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_booking_room_detail set rid = '275', old_reff_id = '74', booking_id = '301', booking_detail_id = '166', room_type_code = '', room_name = 'single', room_type_description = 'FullBed Deluxe Front View (Double)(Room Only)- Package Deal (Book now and save)(1 Double Bed)', display_nightly_rates = 'a:1:{i:0;a:2:{s:18:"displayNightlyRate";s:2:"25";s:13:"whNightlyRate";s:5:"24.32";}}' ,native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";s:2:"22";}}' ,native_room_rate_total = '44' ,display_room_rate_total = '50' ,wh_room_rate_total = '' ,number_of_rooms = '2';
[03/28/2024 12:17:46], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],delete from booking_room_detail WHERE booking_id=?;
[03/28/2024 12:17:46], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],delete from passangers WHERE booking_id=?;
[03/28/2024 12:17:46], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO booking_room_detail set booking_id = '301', booking_detail_id = '166', room_type_code = '', room_name = 'single', room_type_description = 'FullBed Deluxe Front View (Double)(Room Only)- Package Deal (Book now and save)(1 Double Bed)', display_nightly_rates = 'a:1:{i:0;a:2:{s:18:"displayNightlyRate";s:2:"28";s:13:"whNightlyRate";s:5:"26.27";}}' ,native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";s:2:"23";}}' ,native_room_rate_total = '46' ,display_room_rate_total = '56' ,number_of_rooms = '2';
[03/28/2024 12:17:46], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO passangers set booking_id = '301', booking_detail_id = '166', salutations = 'Mr', room = '', rid = '276', first_name = 'Sujay', last_name = 'Raut' ,age = '';
[03/28/2024 12:17:46], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO passangers set booking_id = '301', booking_detail_id = '166', salutations = 'Mr', room = '', rid = '276', first_name = 'TBA', last_name = 'TBA' ,age = '';
[03/28/2024 12:17:46], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],UPDATE bookings SET confirmation_number='7836835171571',cancellation_policy='												Free cancellation up to  19:58:59 on  2024-05-14&lt;br&gt;If you cancel between 2024-05-14 19:59:00 and 2024-05-16 00:00:00 , you will be charged 48.02 USD&lt;br&gt;No show is subject to a 100 % cancellation charge&lt;br&gt;&lt;br/&gt;&lt;b&gt;Amendment Policy&lt;/b&gt;&lt;br/&gt;
		Please note that most hotels treat changes in pax details, room category and dates as a cancellation of the booking, and charges will apply according to the cancellation policy.
		Late amendment charges may apply if requested after 19:59 on 14th of May 2024.
		Confirmation of amendments is subject to availability and rates at the time of making the amendment.
											
											',supplier_cancellation_policy='',applied_multiplier='1.00000',applied_markup='21.739130434783',agent_markup='21.739130434783',consultant_id='Ayman',basecurrency_multiplier='1.00000',basecurrency_multiplier_native='1.00000'_native,agent_currency_multiplier='1.00000',current_status='vouchered',status_date='2024-03-28 12:17:46',service_date='2024-05-16',check_out_date='2024-05-17',display_room_rate= '56',display_discount='0',modified_datetime='2024-03-28 12:17:46',modified_by ='Ayman',native_room_rate='46',native_discount='0.000',additional_charge='0.000',applicable_service_tax='',leader_title='Mr',leader_first_name='Sujay',leader_last_name='Raut',nationality ='Emirati',booking_type ='online',supplier_profile_id ='43',expiration_date= '2024-05-14 16:59:00',source_type='expediapackage',special_comment='',admin_note='',comment_contract=' Bed Type Selection is not guaranteed.&lt;br/&gt;&lt;span style=\&#039;color: red;\&#039;&gt;&lt;strong&gt;Note&lt;/strong&gt;: Nightly rates might be calculated based on the average of Total Rate&lt;/span&gt;&lt;br&gt;&lt;br&gt;&lt;b&gt;Amenities:&lt;/b&gt;Free parking, Free WiFi&lt;br&gt;&lt;br&gt;&lt;b&gt;Deal:&lt;/b&gt; Book now and save,&lt;br&gt;&lt;br/&gt;&lt;br/&gt;&lt;br/&gt;&lt;b&gt;Checkin Start Time :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Checkin End Time :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Min Checkin Age :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Checkout Time :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Instructions :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Special Instructions :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Important Note :&lt;/b&gt; Agent agree that this rate is being sold with approved transport component.' WHERE id='301';
[03/28/2024 12:17:46], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],update bookings set  parent_agent_id='7863', sub_agent_rate='', agent_rate='56', agent_markup='21.739130434783', supplier_rate='46', wh_sub_agent_rate='', wh_agent_rate='52.54' where id='301';
[03/28/2024 12:17:46], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php], insert into booking_rate_info set  booking_id = '301', booking_log = 'Booking Modified', create_date = '2024-03-28 12:17:46', supplier_currency ='USD', type = 'Ammended', agent_price = '6', sub_agent_price ='', supplier_price = '2', supplier_id = 'expediapackage', supplier_type = 'online';
[03/28/2024 12:17:46], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php], insert into booking_rate_info set  booking_id = '301', booking_log = 'Booking Modified', create_date = '2024-03-28 12:17:46', supplier_currency ='USD', type = 'Ammended', agent_price = '', sub_agent_price ='', supplier_price = '', supplier_id = 'expediapack', supplier_type = 'online';
[03/28/2024 12:17:46], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php], insert into booking_rate_info set  booking_id = '301', booking_log = 'Booking Modified', create_date = '2024-03-28 12:17:46', supplier_currency ='USD', type = 'Ammended', agent_price = '', sub_agent_price ='', supplier_price = '44.000', supplier_id = 'expediapackage', supplier_type = 'online';
[03/28/2024 12:17:46], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php], update wh_booking_rate_info set  booking_id = '301', booking_log = 'Booking Modified', create_date = '2024-03-28 12:17:46', agent_price = '52.540', sub_agent_price = '0.000', supplier_price = '56.000' where booking_id = '301'  and type = "Sale";
[03/28/2024 12:17:46], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],UPDATE agents SET credit_usage=credit_usage+('6'),   credit_value= credit_value-('6') ,  cd_credit_usage=cd_credit_usage+('6') , cd_credit_value=cd_credit_value-('6')  WHERE id = '7863';
[03/28/2024 12:17:46], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],insert into  agent_credit_log SET agent_id= '7863',credit_value= '999998668.300',credit_usage= '331.700',credit_limit= '999999000.000',receipt_id= '',amount= '6',booking_id='301',booking_cost= '56',receipt_allocation= '',balance= '56',ip='43.239.53.130',user_type='admin',admin_id='Ayman',temp_credit_limit='',log_type='Booking Modified',note='Booking Modified',create_date='2024-03-28 12:03:46';
[03/28/2024 12:17:46], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],UPDATE agents  SET credit_usage=credit_usage+('3.9'),   credit_value= credit_value-('3.9') ,  cd_credit_usage=cd_credit_usage+('3.9') , cd_credit_value=cd_credit_value-('3.9')  WHERE id = '7866';
[03/28/2024 12:17:46], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],insert into  agent_credit_log SET agent_id= '7866',credit_value= '-4.520',credit_usage= '4.520',credit_limit= '0.000',receipt_id= '',amount= '3.9',booking_id='301',booking_cost= '56',receipt_allocation= '',balance= '56',ip='43.239.53.130',user_type='admin',admin_id='Ayman',temp_credit_limit='',log_type='Booking Modified',note='Booking Modified',create_date='2024-03-28 12:03:46';
[03/28/2024 12:17:46], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],delete from  agent_commission   WHERE booking_id='301';
[03/28/2024 12:17:46], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO agent_commission SET booking_id ='301',booking_detail_id ='301',agent_id ='7863',is_sub_agent ='N',parent_id ='',display_commission ='10',display_currency ='USD',paid ='N',type ='hotel',description ='Agent Mark Up Percentage is 21.739130434783 %',create_date ='2024-03-28 12:17:46';
[03/28/2024 12:17:46], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],update bookings_details set total_nights='1' , supplier_id= 'expediapackage' , total_rooms= '2', arrival_date='2024/05/16', departure_date='2024/05/17', rate_code='~', hotel_address1='24/5 Moo 6, Thepkrasatri Rd.', hotel_name='Phuketa Hotel', hotel_phone='+6676241427' where booking_id ='301';
[03/28/2024 12:17:46], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
		('','','301','vouchered','2024-03-28 12:17:46','Booking Modified by Ayman','Ayman','43.239.53.130','Ayman','','');
[03/28/2024 12:18:06], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:18:06' WHERE id= '705';
[03/28/2024 12:18:06], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1711628286','43.239.53.130');
[03/28/2024 12:18:06], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:18:06' WHERE id= '705';
[03/28/2024 12:18:06], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO bookings set reservation_id='4263',agent_id='7851',leader_title='Mr',leader_first_name='shiv',leader_last_name='chauhan',city_id='belize',country_id='5',nationality='Belizean',display_room_rate='198.08',display_currency_code='USD',native_room_rate='198.08',consultant_id='SUJAY_QTECH',native_currency_code='USD',cancellation_policy='Cancellation Charges will be applicable if cancelled after 18 Apr 2024 00:00 hrs.<BR>Late amendment charge may apply.',current_status='inprocess-booking',booking_status='1',sales_manager_id='0',create_date='2024-03-28 12:18:06',source_type='viator',expiration_date= '2024-04-17 21:00:00',applied_multiplier='1.00000',applied_markup='0',agent_markup='0',basecurrency_multiplier='1.00000',basecurrency_multiplier_native='1.00000',admin_booked='0',service_date='2024-04-18',sub_user_id='',check_out_date='2024-04-18',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';
[03/28/2024 12:18:06], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO sight_bookings set booking_id='570',native_nightly_rates='a:2:{s:4:\"size\";i:1;s:17:\"nativeNightlyRate\";d:198.08000000000001;}',rate_description='',display_nightly_rates='a:4:{s:4:\"size\";i:1;s:18:\"displayNightlyRate\";d:198.08000000000001;s:25:\"displayNightlyRateDisplay\";s:134:\"Rate - 198.08 USD, Currency Multiplier (USD-USD) - 1.00000, Markup  in % - %, Markup Amount - , Markup Amount in  - ,Other Markup - 0%\";s:23:\"displayNightlyRateStore\";s:135:\"Rate - 198.08 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='9025P1',sight_name='CAVE TUBING FROM BELIZE CITY - V2',tour_time='',tour_details='',tour_inclusive='H<br/>',tour_exclusive='G<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: 09:00',arrival_date='2024-04-18',total_adults='2',total_children='0',total_infants='0',gta_city_code='5094',supplier_id='9025P1',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='';
[03/28/2024 12:18:06], [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','4263','2024-03-28 12:18:06',0);
[03/28/2024 12:18:07], [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/28_03_2024/request_reservation_sight_Viator_test_12_18_06_1711628286.json', 'v1/28_03_2024/response_reservation_sight_Viator_test_12_18_06_1711628286.json', 'v1/28_03_2024/response_header_reservation_sight_Viator_test_12_18_06_1711628286.json', 'viator', '2024-03-28 12:18:07', '', '', '670');
[03/28/2024 12:18:07], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE posted_bookings set status=1 where id= '497';
[03/28/2024 12:18:07], [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='570';
[03/28/2024 12:18:07], [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
		('','','570','failed','2024-03-28 12:18:07','Sightseeing Booking failed by Agent..7851','7851','43.239.53.130','','','');
[03/28/2024 12:18:07], [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('570','Mr','1','shiv','chauhan','adult','0');
[03/28/2024 12:18:07], [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('570','Mr','1','deepak','trivedi','adult','0');
[03/28/2024 12:18:07], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],update xmllogs set reservation_id='570' where agent_logs_id='670' and source_type='viator';
[03/28/2024 12:18:14], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_bookings set history_booking_id ='301', agent_id ='7863', itenirary_id ='7836835171571', confirmation_number ='7836835171571', payment_confirmation_no ='', voucher_id ='33', voucher_hashcode ='993828d8536a85f7e9238e514869385082138301', email_id ='', leader_title ='Mr', leader_first_name ='Sujay', leader_last_name ='Raut', city_id ='phuket', country_id ='136', display_room_rate ='56.000', native_room_rate ='46.000', native_currency_code ='USD', additional_charge ='0.000', cancellation_policy ='												Free cancellation up to  19:58:59 on  2024-05-14&lt;br&gt;If you cancel between 2024-05-14 19:59:00 and 2024-05-16 00:00:00 , you will be charged 48.02 USD&lt;br&gt;No show is subject to a 100 % cancellation charge&lt;br&gt;&lt;br/&gt;&lt;b&gt;Amendment Policy&lt;/b&gt;&lt;br/&gt;
		Please note that most hotels treat changes in pax details, room category and dates as a cancellation of the booking, and charges will apply according to the cancellation policy.
		Late amendment charges may apply if requested after 19:59 on 14th of May 2024.
		Confirmation of amendments is subject to availability and rates at the time of making the amendment.
											
											', supplier_cancellation_policy ='', current_status ='vouchered', booking_status ='1', status_date ='2024-03-28 12:17:46', create_date ='2024-01-19 11:04:03', source_type ='expediapackage', expiration_date ='2024-05-14 16:59:00', comment_contract =' Bed Type Selection is not guaranteed.&lt;br/&gt;&lt;span style=\\&#039;color: red;\\&#039;&gt;&lt;strong&gt;Note&lt;/strong&gt;: Nightly rates might be calculated based on the average of Total Rate&lt;/span&gt;&lt;br&gt;&lt;br&gt;&lt;b&gt;Amenities:&lt;/b&gt;Free parking, Free WiFi&lt;br&gt;&lt;br&gt;&lt;b&gt;Deal:&lt;/b&gt; Book now and save,&lt;br&gt;&lt;br/&gt;&lt;br/&gt;&lt;br/&gt;&lt;b&gt;Checkin Start Time :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Checkin End Time :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Min Checkin Age :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Checkout Time :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Instructions :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Special Instructions :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Important Note :&lt;/b&gt; Agent agree that this rate is being sold with approved transport component.', admin_note ='', is_payment_gateway ='0', service_type ='hotel', service_type_detail ='', native_rate ='', display_rate ='', agent_rate ='56.000', wh_sub_agent_rate ='0.000', wh_agent_rate ='52.540', supplier_rate ='46.000', special_comment ='', special_remark ='', sms_status ='', is_xml ='0', consultant_id ='Ayman', admin_booked ='0', emailed_status ='0', applied_multiplier ='1.00000', applied_markup ='21.739130434783', wh_applied_markup ='0.500', original_voucher ='', subagent_markup ='', agent_markup ='21.739130434783', wh_agent_markup ='0.500', basecurrency_multiplier ='1.00000', wh_basecurrency_multiplier ='1.00000', basecurrency_multiplier_native ='1.00000', wh_basecurrency_multiplier_native ='1.00000', agent_currency_multiplier ='1.00000', wh_agent_currency_multiplier ='1.00000', modified_datetime ='2024-03-28 12:18:14', modified_by ='Ayman', display_currency_code ='USD', created_datetime ='2024-03-28 12:18:14', sub_agent_rate ='0.000', created_by ='Ayman', site_id ='20', applicable_service_tax ='0.000', wh_parent_agent_id ='7866', wh_agent_id ='7866', nationality ='Emirati', ip_addr ='43.239.53.130';
[03/28/2024 12:18:14], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_bookings_details  set  history_booking_detail_id ='166', old_reff_id ='75', booking_id ='301', supplier_id ='expediapack', total_nights ='1', arrival_date ='2024/05/16', departure_date ='2024/05/17', hotel_id ='2510986', hotel_name ='Phuketa Hotel', hotel_address1 ='24/5 Moo 6, Thepkrasatri Rd.', hotel_phone ='+6676241427', hotel_rating ='4.0', rate_code ='~', touricoRoomResId ='', gta_item_confirm_ref ='', channel_manager ='', reservation_pushed ='0', gtaToken ='';
[03/28/2024 12:18:14], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_passangers set history_passenger_id = '525', old_reff_id = '75', booking_id = '301', booking_detail_id = '166', salutations = 'Mr', room = '0', rid = '276', first_name = 'Sujay', last_name = 'Raut' ,passenger_type = 'adult' ,age = '';
[03/28/2024 12:18:14], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_passangers set history_passenger_id = '526', old_reff_id = '75', booking_id = '301', booking_detail_id = '166', salutations = 'Mr', room = '0', rid = '276', first_name = 'TBA', last_name = 'TBA' ,passenger_type = 'adult' ,age = '';
[03/28/2024 12:18:14], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],delete from passangers WHERE booking_id=?;
[03/28/2024 12:18:14], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_booking_room_detail set rid = '276', old_reff_id = '75', booking_id = '301', booking_detail_id = '166', room_type_code = '', room_name = 'single', room_type_description = 'FullBed Deluxe Front View (Double)(Room Only)- Package Deal (Book now and save)(1 Double Bed)', display_nightly_rates = 'a:1:{i:0;a:2:{s:18:"displayNightlyRate";s:2:"28";s:13:"whNightlyRate";s:5:"26.27";}}' ,native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";s:2:"23";}}' ,native_room_rate_total = '46' ,display_room_rate_total = '56' ,wh_room_rate_total = '' ,number_of_rooms = '2';
[03/28/2024 12:18:14], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],delete from booking_room_detail WHERE booking_id=?;
[03/28/2024 12:18:14], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],delete from passangers WHERE booking_id=?;
[03/28/2024 12:18:14], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO booking_room_detail set booking_id = '301', booking_detail_id = '166', room_type_code = '', room_name = 'single', room_type_description = 'FullBed Deluxe Front View (Double)(Room Only)- Package Deal (Book now and save)(1 Double Bed)', display_nightly_rates = 'a:1:{i:0;a:2:{s:18:"displayNightlyRate";s:2:"28";s:13:"whNightlyRate";s:5:"28.14";}}' ,native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";s:2:"23";}}' ,native_room_rate_total = '46' ,display_room_rate_total = '56' ,number_of_rooms = '2';
[03/28/2024 12:18:14], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO passangers set booking_id = '301', booking_detail_id = '166', salutations = 'Mr', room = '', rid = '277', first_name = 'Sujay', last_name = 'Raut' ,age = '';
[03/28/2024 12:18:14], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO passangers set booking_id = '301', booking_detail_id = '166', salutations = 'Mr', room = '', rid = '277', first_name = 'TBA', last_name = 'TBA' ,age = '';
[03/28/2024 12:18:14], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],UPDATE bookings SET confirmation_number='7836835171571',cancellation_policy='																		Free cancellation up to  19:58:59 on  2024-05-14&lt;br&gt;If you cancel between 2024-05-14 19:59:00 and 2024-05-16 00:00:00 , you will be charged 48.02 USD&lt;br&gt;No show is subject to a 100 % cancellation charge&lt;br&gt;&lt;br/&gt;&lt;b&gt;Amendment Policy&lt;/b&gt;&lt;br/&gt;
		Please note that most hotels treat changes in pax details, room category and dates as a cancellation of the booking, and charges will apply according to the cancellation policy.
		Late amendment charges may apply if requested after 19:59 on 14th of May 2024.
		Confirmation of amendments is subject to availability and rates at the time of making the amendment.
											
											
											',supplier_cancellation_policy='',applied_multiplier='1.00000',applied_markup='21.739130434783',agent_markup='21.739130434783',consultant_id='Ayman',basecurrency_multiplier='1.00000',basecurrency_multiplier_native='1.00000'_native,agent_currency_multiplier='1.00000',current_status='vouchered',status_date='2024-03-28 12:18:14',service_date='2024-05-16',check_out_date='2024-05-17',display_room_rate= '56',display_discount='0',modified_datetime='2024-03-28 12:18:14',modified_by ='Ayman',native_room_rate='46',native_discount='0.000',additional_charge='0.000',applicable_service_tax='',leader_title='Mr',leader_first_name='Sujay',leader_last_name='Raut',nationality ='Emirati',booking_type ='online',supplier_profile_id ='43',expiration_date= '2024-05-14 16:59:00',source_type='expediapackage',special_comment='',admin_note='',comment_contract=' Bed Type Selection is not guaranteed.&lt;br/&gt;&lt;span style=\&#039;color: red;\&#039;&gt;&lt;strong&gt;Note&lt;/strong&gt;: Nightly rates might be calculated based on the average of Total Rate&lt;/span&gt;&lt;br&gt;&lt;br&gt;&lt;b&gt;Amenities:&lt;/b&gt;Free parking, Free WiFi&lt;br&gt;&lt;br&gt;&lt;b&gt;Deal:&lt;/b&gt; Book now and save,&lt;br&gt;&lt;br/&gt;&lt;br/&gt;&lt;br/&gt;&lt;b&gt;Checkin Start Time :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Checkin End Time :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Min Checkin Age :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Checkout Time :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Instructions :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Special Instructions :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Important Note :&lt;/b&gt; Agent agree that this rate is being sold with approved transport component.' WHERE id='301';
[03/28/2024 12:18:14], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],update bookings set  parent_agent_id='7863', sub_agent_rate='', agent_rate='56', agent_markup='21.739130434783', supplier_rate='46', wh_sub_agent_rate='', wh_agent_rate='56.28' where id='301';
[03/28/2024 12:18:14], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php], insert into booking_rate_info set  booking_id = '301', booking_log = 'Booking Modified', create_date = '2024-03-28 12:18:14', supplier_currency ='USD', type = 'Ammended', agent_price = '', sub_agent_price ='', supplier_price = '', supplier_id = 'expediapack', supplier_type = 'online';
[03/28/2024 12:18:14], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php], insert into booking_rate_info set  booking_id = '301', booking_log = 'Booking Modified', create_date = '2024-03-28 12:18:14', supplier_currency ='USD', type = 'Ammended', agent_price = '', sub_agent_price ='', supplier_price = '46.000', supplier_id = 'expediapackage', supplier_type = 'online';
[03/28/2024 12:18:14], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php], update wh_booking_rate_info set  booking_id = '301', booking_log = 'Booking Modified', create_date = '2024-03-28 12:18:14', agent_price = '56.280', sub_agent_price = '0.000', supplier_price = '56.000' where booking_id = '301'  and type = "Sale";
[03/28/2024 12:18:14], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],update bookings_details set total_nights='1' , supplier_id= 'expediapackage' , total_rooms= '2', arrival_date='2024/05/16', departure_date='2024/05/17', rate_code='~', hotel_address1='24/5 Moo 6, Thepkrasatri Rd.', hotel_name='Phuketa Hotel', hotel_phone='+6676241427' where booking_id ='301';
[03/28/2024 12:18:14], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
		('','','301','vouchered','2024-03-28 12:18:14','Booking Modified by Ayman','Ayman','43.239.53.130','Ayman','','');
[03/28/2024 12:19:19], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:19:19' WHERE id= '705';
[03/28/2024 12:19:19], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-03-28 12:19:19',login_attempt=0 where id = '7851';
[03/28/2024 12:19:19], [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-03-28 12:19:19', ip = '43.239.53.130', action = 'Login' ;
[03/28/2024 12:19:20], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:19:20' WHERE id= '705';
[03/28/2024 12:19:24], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:19:24' WHERE id= '705';
[03/28/2024 12:19:29], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:19:29' WHERE id= '705';
[03/28/2024 12:19:31], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:19:31' WHERE id= '705';
[03/28/2024 12:19:31], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:19:31' WHERE id= '705';
[03/28/2024 12:19:32], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:19:32' WHERE id= '705';
[03/28/2024 12:19:33], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:19:33' WHERE id= '705';
[03/28/2024 12:19:39], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:19:39' WHERE id= '705';
[03/28/2024 12:19: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 = 'belize' , arrival_date='2024/04/18',  departure_date='2024/04/18',  nights='1',  create_date='2024-03-28 :12:19:39',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[03/28/2024 12:19:43], [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/28_03_2024/request_availability_Viator_test_12_19_39_1711628379.json', 'v1/28_03_2024/response_availability_Viator_test_12_19_39_1711628379.json', 'v1/28_03_2024/response_header_availability_Viator_test_12_19_39_1711628379.json', 'viator', '2024-03-28 12:19:43', '', '', '671');
[03/28/2024 12:19: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/28_03_2024/request_availability_Viator_test_12_19_43_1711628383_50.json', 'v1/28_03_2024/response_availability_Viator_test_12_19_43_1711628383_50.json', 'v1/28_03_2024/response_header_availability_Viator_test_12_19_43_1711628383_50.json', 'viator', '2024-03-28 12:19:58', '', '', '671');
[03/28/2024 12:19: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/28_03_2024/request_availability_Viator_test_12_19_43_1711628383_50.json', 'v1/28_03_2024/response_availability_Viator_test_12_19_43_1711628383_50.json', 'v1/28_03_2024/response_header_availability_Viator_test_12_19_43_1711628383_50.json', 'viator', '2024-03-28 12:19:58', '', '', '671');
[03/28/2024 12:19: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/28_03_2024/request_availability_Viator_test_12_19_43_1711628383_50.json', 'v1/28_03_2024/response_availability_Viator_test_12_19_43_1711628383_50.json', 'v1/28_03_2024/response_header_availability_Viator_test_12_19_43_1711628383_50.json', 'viator', '2024-03-28 12:19:58', '', '', '671');
[03/28/2024 12:19: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/28_03_2024/request_availability_Viator_test_12_19_43_1711628383_50.json', 'v1/28_03_2024/response_availability_Viator_test_12_19_43_1711628383_50.json', 'v1/28_03_2024/response_header_availability_Viator_test_12_19_43_1711628383_50.json', 'viator', '2024-03-28 12:19:58', '', '', '671');
[03/28/2024 12:19: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/28_03_2024/request_availability_Viator_test_12_19_43_1711628383_50.json', 'v1/28_03_2024/response_availability_Viator_test_12_19_43_1711628383_50.json', 'v1/28_03_2024/response_header_availability_Viator_test_12_19_43_1711628383_50.json', 'viator', '2024-03-28 12:19:58', '', '', '671');
[03/28/2024 12:19: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/28_03_2024/request_availability_Viator_test_12_19_43_1711628383_50.json', 'v1/28_03_2024/response_availability_Viator_test_12_19_43_1711628383_50.json', 'v1/28_03_2024/response_header_availability_Viator_test_12_19_43_1711628383_50.json', 'viator', '2024-03-28 12:19:58', '', '', '671');
[03/28/2024 12:19: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/28_03_2024/request_availability_Viator_test_12_19_43_1711628383_50.json', 'v1/28_03_2024/response_availability_Viator_test_12_19_43_1711628383_50.json', 'v1/28_03_2024/response_header_availability_Viator_test_12_19_43_1711628383_50.json', 'viator', '2024-03-28 12:19:58', '', '', '671');
[03/28/2024 12:19: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/28_03_2024/request_availability_Viator_test_12_19_43_1711628383_50.json', 'v1/28_03_2024/response_availability_Viator_test_12_19_43_1711628383_50.json', 'v1/28_03_2024/response_header_availability_Viator_test_12_19_43_1711628383_50.json', 'viator', '2024-03-28 12:19:58', '', '', '671');
[03/28/2024 12:19: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/28_03_2024/request_availability_Viator_test_12_19_43_1711628383_50.json', 'v1/28_03_2024/response_availability_Viator_test_12_19_43_1711628383_50.json', 'v1/28_03_2024/response_header_availability_Viator_test_12_19_43_1711628383_50.json', 'viator', '2024-03-28 12:19:58', '', '', '671');
[03/28/2024 12:20:00], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:20:00' WHERE id= '705';
[03/28/2024 12:20:00], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:20:00' WHERE id= '705';
[03/28/2024 12:20:14], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:20:14' WHERE id= '705';
[03/28/2024 12:20: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/28_03_2024/request_sight_details_Viator_test_12_20_14_1711628414.json', 'v1/28_03_2024/response_sight_details_Viator_test_12_20_14_1711628414.json', 'v1/28_03_2024/response_header_sight_details_Viator_test_12_20_14_1711628414.json', 'viator', '2024-03-28 12:20:14', '', '', '671');
[03/28/2024 12:20: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/28_03_2024/request_sight_details_Viator_test_12_20_14_1711628414.json', 'v1/28_03_2024/response_sight_details_Viator_test_12_20_14_1711628414.json', 'v1/28_03_2024/response_header_sight_details_Viator_test_12_20_14_1711628414.json', 'viator', '2024-03-28 12:20:14', '', '', '671');
[03/28/2024 12:20:21], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:20:21' WHERE id= '705';
[03/28/2024 12:20: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/28_03_2024/request_sight_details_Viator_test_12_20_21_1711628421.json', 'v1/28_03_2024/response_sight_details_Viator_test_12_20_21_1711628421.json', 'v1/28_03_2024/response_header_sight_details_Viator_test_12_20_21_1711628421.json', 'viator', '2024-03-28 12:20:21', '', '', '671');
[03/28/2024 12:20: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/28_03_2024/request_sight_details_Viator_test_12_20_21_1711628421.json', 'v1/28_03_2024/response_sight_details_Viator_test_12_20_21_1711628421.json', 'v1/28_03_2024/response_header_sight_details_Viator_test_12_20_21_1711628421.json', 'viator', '2024-03-28 12:20:22', '', '', '671');
[03/28/2024 12:20:23], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:20:23' WHERE id= '705';
[03/28/2024 12:20:24], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'check_availability', 'v1/28_03_2024/request_check_availability_Viator_test_12_20_23_1711628423.json', 'v1/28_03_2024/response_check_availability_Viator_test_12_20_23_1711628423.json', 'v1/28_03_2024/response_header_check_availability_Viator_test_12_20_23_1711628423.json', 'viator', '2024-03-28 12:20:24', '', '', '671');
[03/28/2024 12:20:43], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:20:43' WHERE id= '705';
[03/28/2024 12:20:44], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/28_03_2024/request_sight_details_Viator_test_12_20_43_1711628443.json', 'v1/28_03_2024/response_sight_details_Viator_test_12_20_43_1711628443.json', 'v1/28_03_2024/response_header_sight_details_Viator_test_12_20_43_1711628443.json', 'viator', '2024-03-28 12:20:44', '', '', '671');
[03/28/2024 12:20: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/28_03_2024/request_sight_details_Viator_test_12_20_44_1711628444.json', 'v1/28_03_2024/response_sight_details_Viator_test_12_20_44_1711628444.json', 'v1/28_03_2024/response_header_sight_details_Viator_test_12_20_44_1711628444.json', 'viator', '2024-03-28 12:20:45', '', '', '671');
[03/28/2024 12:20:47], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:20:47' WHERE id= '705';
[03/28/2024 12:20:50], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'check_availability', 'v1/28_03_2024/request_check_availability_Viator_test_12_20_47_1711628447.json', 'v1/28_03_2024/response_check_availability_Viator_test_12_20_47_1711628447.json', 'v1/28_03_2024/response_header_check_availability_Viator_test_12_20_47_1711628447.json', 'viator', '2024-03-28 12:20:50', '', '', '671');
[03/28/2024 12:21:05], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:21:05' WHERE id= '705';
[03/28/2024 12:21:05], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1711628465','43.239.53.130');
[03/28/2024 12:21:18], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:21:18' WHERE id= '705';
[03/28/2024 12:21:23], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:21:23' WHERE id= '705';
[03/28/2024 12:21:27], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:21:27' WHERE id= '705';
[03/28/2024 12:21:54], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:21:54' WHERE id= '705';
[03/28/2024 12:21:56], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:21:56' WHERE id= '705';
[03/28/2024 12:21:56], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:21:56' WHERE id= '705';
[03/28/2024 12:22:08], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:22:08' WHERE id= '705';
[03/28/2024 12:22:09], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/28_03_2024/request_sight_details_Viator_test_12_22_08_1711628528.json', 'v1/28_03_2024/response_sight_details_Viator_test_12_22_08_1711628528.json', 'v1/28_03_2024/response_header_sight_details_Viator_test_12_22_08_1711628528.json', 'viator', '2024-03-28 12:22:09', '', '', '671');
[03/28/2024 12:22:09], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/28_03_2024/request_sight_details_Viator_test_12_22_09_1711628529.json', 'v1/28_03_2024/response_sight_details_Viator_test_12_22_09_1711628529.json', 'v1/28_03_2024/response_header_sight_details_Viator_test_12_22_09_1711628529.json', 'viator', '2024-03-28 12:22:09', '', '', '671');
[03/28/2024 12:22:26], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_bookings set history_booking_id ='301', agent_id ='7863', itenirary_id ='7836835171571', confirmation_number ='7836835171571', payment_confirmation_no ='', voucher_id ='33', voucher_hashcode ='993828d8536a85f7e9238e514869385082138301', email_id ='', leader_title ='Mr', leader_first_name ='Sujay', leader_last_name ='Raut', city_id ='phuket', country_id ='136', display_room_rate ='56.000', native_room_rate ='46.000', native_currency_code ='USD', additional_charge ='0.000', cancellation_policy ='																		Free cancellation up to  19:58:59 on  2024-05-14&lt;br&gt;If you cancel between 2024-05-14 19:59:00 and 2024-05-16 00:00:00 , you will be charged 48.02 USD&lt;br&gt;No show is subject to a 100 % cancellation charge&lt;br&gt;&lt;br/&gt;&lt;b&gt;Amendment Policy&lt;/b&gt;&lt;br/&gt;
		Please note that most hotels treat changes in pax details, room category and dates as a cancellation of the booking, and charges will apply according to the cancellation policy.
		Late amendment charges may apply if requested after 19:59 on 14th of May 2024.
		Confirmation of amendments is subject to availability and rates at the time of making the amendment.
											
											
											', supplier_cancellation_policy ='', current_status ='vouchered', booking_status ='1', status_date ='2024-03-28 12:18:14', create_date ='2024-01-19 11:04:03', source_type ='expediapackage', expiration_date ='2024-05-14 16:59:00', comment_contract =' Bed Type Selection is not guaranteed.&lt;br/&gt;&lt;span style=\\&#039;color: red;\\&#039;&gt;&lt;strong&gt;Note&lt;/strong&gt;: Nightly rates might be calculated based on the average of Total Rate&lt;/span&gt;&lt;br&gt;&lt;br&gt;&lt;b&gt;Amenities:&lt;/b&gt;Free parking, Free WiFi&lt;br&gt;&lt;br&gt;&lt;b&gt;Deal:&lt;/b&gt; Book now and save,&lt;br&gt;&lt;br/&gt;&lt;br/&gt;&lt;br/&gt;&lt;b&gt;Checkin Start Time :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Checkin End Time :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Min Checkin Age :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Checkout Time :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Instructions :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Special Instructions :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Important Note :&lt;/b&gt; Agent agree that this rate is being sold with approved transport component.', admin_note ='', is_payment_gateway ='0', service_type ='hotel', service_type_detail ='', native_rate ='', display_rate ='', agent_rate ='56.000', wh_sub_agent_rate ='0.000', wh_agent_rate ='56.280', supplier_rate ='46.000', special_comment ='', special_remark ='', sms_status ='', is_xml ='0', consultant_id ='Ayman', admin_booked ='0', emailed_status ='0', applied_multiplier ='1.00000', applied_markup ='21.739130434783', wh_applied_markup ='0.500', original_voucher ='', subagent_markup ='', agent_markup ='21.739130434783', wh_agent_markup ='0.500', basecurrency_multiplier ='1.00000', wh_basecurrency_multiplier ='1.00000', basecurrency_multiplier_native ='1.00000', wh_basecurrency_multiplier_native ='1.00000', agent_currency_multiplier ='1.00000', wh_agent_currency_multiplier ='1.00000', modified_datetime ='2024-03-28 12:22:26', modified_by ='Ayman', display_currency_code ='USD', created_datetime ='2024-03-28 12:22:26', sub_agent_rate ='0.000', created_by ='Ayman', site_id ='20', applicable_service_tax ='0.000', wh_parent_agent_id ='7866', wh_agent_id ='7866', nationality ='Emirati', ip_addr ='43.239.53.130';
[03/28/2024 12:22:26], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_bookings_details  set  history_booking_detail_id ='166', old_reff_id ='76', booking_id ='301', supplier_id ='expediapack', total_nights ='1', arrival_date ='2024/05/16', departure_date ='2024/05/17', hotel_id ='2510986', hotel_name ='Phuketa Hotel', hotel_address1 ='24/5 Moo 6, Thepkrasatri Rd.', hotel_phone ='+6676241427', hotel_rating ='4.0', rate_code ='~', touricoRoomResId ='', gta_item_confirm_ref ='', channel_manager ='', reservation_pushed ='0', gtaToken ='';
[03/28/2024 12:22:26], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_passangers set history_passenger_id = '527', old_reff_id = '76', booking_id = '301', booking_detail_id = '166', salutations = 'Mr', room = '0', rid = '277', first_name = 'Sujay', last_name = 'Raut' ,passenger_type = 'adult' ,age = '';
[03/28/2024 12:22:26], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_passangers set history_passenger_id = '528', old_reff_id = '76', booking_id = '301', booking_detail_id = '166', salutations = 'Mr', room = '0', rid = '277', first_name = 'TBA', last_name = 'TBA' ,passenger_type = 'adult' ,age = '';
[03/28/2024 12:22:26], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],delete from passangers WHERE booking_id=?;
[03/28/2024 12:22:26], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_booking_room_detail set rid = '277', old_reff_id = '76', booking_id = '301', booking_detail_id = '166', room_type_code = '', room_name = 'single', room_type_description = 'FullBed Deluxe Front View (Double)(Room Only)- Package Deal (Book now and save)(1 Double Bed)', display_nightly_rates = 'a:1:{i:0;a:2:{s:18:"displayNightlyRate";s:2:"28";s:13:"whNightlyRate";s:5:"28.14";}}' ,native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";s:2:"23";}}' ,native_room_rate_total = '46' ,display_room_rate_total = '56' ,wh_room_rate_total = '' ,number_of_rooms = '2';
[03/28/2024 12:22:26], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],delete from booking_room_detail WHERE booking_id=?;
[03/28/2024 12:22:26], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],delete from passangers WHERE booking_id=?;
[03/28/2024 12:22:26], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO booking_room_detail set booking_id = '301', booking_detail_id = '166', room_type_code = '', room_name = 'single', room_type_description = 'FullBed Deluxe Front View (Double)(Room Only)- Package Deal (Book now and save)(1 Double Bed)', display_nightly_rates = 'a:1:{i:0;a:2:{s:18:"displayNightlyRate";s:3:"125";s:13:"whNightlyRate";s:6:"122.35";}}' ,native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";s:3:"100";}}' ,native_room_rate_total = '200' ,display_room_rate_total = '250' ,number_of_rooms = '2';
[03/28/2024 12:22:26], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO passangers set booking_id = '301', booking_detail_id = '166', salutations = 'Mr', room = '', rid = '278', first_name = 'Sujay', last_name = 'Raut' ,age = '';
[03/28/2024 12:22:26], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO passangers set booking_id = '301', booking_detail_id = '166', salutations = 'Mr', room = '', rid = '278', first_name = 'TBA', last_name = 'TBA' ,age = '';
[03/28/2024 12:22:26], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],UPDATE bookings SET confirmation_number='7836835171571',cancellation_policy='																								Free cancellation up to  19:58:59 on  2024-05-14&lt;br&gt;If you cancel between 2024-05-14 19:59:00 and 2024-05-16 00:00:00 , you will be charged 48.02 USD&lt;br&gt;No show is subject to a 100 % cancellation charge&lt;br&gt;&lt;br/&gt;&lt;b&gt;Amendment Policy&lt;/b&gt;&lt;br/&gt;
		Please note that most hotels treat changes in pax details, room category and dates as a cancellation of the booking, and charges will apply according to the cancellation policy.
		Late amendment charges may apply if requested after 19:59 on 14th of May 2024.
		Confirmation of amendments is subject to availability and rates at the time of making the amendment.
											
											
											
											',supplier_cancellation_policy='',applied_multiplier='1.00000',applied_markup='25',agent_markup='25',consultant_id='Ayman',basecurrency_multiplier='1.00000',basecurrency_multiplier_native='1.00000'_native,agent_currency_multiplier='1.00000',current_status='vouchered',status_date='2024-03-28 12:22:26',service_date='2024-05-16',check_out_date='2024-05-17',display_room_rate= '250',display_discount='0',modified_datetime='2024-03-28 12:22:26',modified_by ='Ayman',native_room_rate='200',native_discount='0.000',additional_charge='0.000',applicable_service_tax='',leader_title='Mr',leader_first_name='Sujay',leader_last_name='Raut',nationality ='Emirati',booking_type ='online',supplier_profile_id ='43',expiration_date= '2024-05-14 16:59:00',source_type='expediapackage',special_comment='',admin_note='',comment_contract=' Bed Type Selection is not guaranteed.&lt;br/&gt;&lt;span style=\&#039;color: red;\&#039;&gt;&lt;strong&gt;Note&lt;/strong&gt;: Nightly rates might be calculated based on the average of Total Rate&lt;/span&gt;&lt;br&gt;&lt;br&gt;&lt;b&gt;Amenities:&lt;/b&gt;Free parking, Free WiFi&lt;br&gt;&lt;br&gt;&lt;b&gt;Deal:&lt;/b&gt; Book now and save,&lt;br&gt;&lt;br/&gt;&lt;br/&gt;&lt;br/&gt;&lt;b&gt;Checkin Start Time :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Checkin End Time :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Min Checkin Age :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Checkout Time :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Instructions :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Special Instructions :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Important Note :&lt;/b&gt; Agent agree that this rate is being sold with approved transport component.' WHERE id='301';
[03/28/2024 12:22:26], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],update bookings set  parent_agent_id='7863', sub_agent_rate='', agent_rate='250', agent_markup='25', supplier_rate='200', wh_sub_agent_rate='', wh_agent_rate='244.7' where id='301';
[03/28/2024 12:22:26], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php], insert into booking_rate_info set  booking_id = '301', booking_log = 'Booking Modified', create_date = '2024-03-28 12:22:26', supplier_currency ='USD', type = 'Ammended', agent_price = '194', sub_agent_price ='', supplier_price = '154', supplier_id = 'expediapackage', supplier_type = 'online';
[03/28/2024 12:22:26], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php], insert into booking_rate_info set  booking_id = '301', booking_log = 'Booking Modified', create_date = '2024-03-28 12:22:26', supplier_currency ='USD', type = 'Ammended', agent_price = '', sub_agent_price ='', supplier_price = '', supplier_id = 'expediapack', supplier_type = 'online';
[03/28/2024 12:22:26], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php], insert into booking_rate_info set  booking_id = '301', booking_log = 'Booking Modified', create_date = '2024-03-28 12:22:26', supplier_currency ='USD', type = 'Ammended', agent_price = '', sub_agent_price ='', supplier_price = '46.000', supplier_id = 'expediapackage', supplier_type = 'online';
[03/28/2024 12:22:26], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php], update wh_booking_rate_info set  booking_id = '301', booking_log = 'Booking Modified', create_date = '2024-03-28 12:22:26', agent_price = '244.700', sub_agent_price = '0.000', supplier_price = '250.000' where booking_id = '301'  and type = "Sale";
[03/28/2024 12:22:26], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],UPDATE agents SET credit_usage=credit_usage+('194'),   credit_value= credit_value-('194') ,  cd_credit_usage=cd_credit_usage+('194') , cd_credit_value=cd_credit_value-('194')  WHERE id = '7863';
[03/28/2024 12:22:26], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],insert into  agent_credit_log SET agent_id= '7863',credit_value= '999998474.300',credit_usage= '525.700',credit_limit= '999999000.000',receipt_id= '',amount= '194',booking_id='301',booking_cost= '250',receipt_allocation= '',balance= '250',ip='43.239.53.130',user_type='admin',admin_id='Ayman',temp_credit_limit='',log_type='Booking Modified',note='Booking Modified',create_date='2024-03-28 12:03:26';
[03/28/2024 12:22:26], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],UPDATE agents  SET credit_usage=credit_usage+('188.42'),   credit_value= credit_value-('188.42') ,  cd_credit_usage=cd_credit_usage+('188.42') , cd_credit_value=cd_credit_value-('188.42')  WHERE id = '7866';
[03/28/2024 12:22:26], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],insert into  agent_credit_log SET agent_id= '7866',credit_value= '-192.940',credit_usage= '192.940',credit_limit= '0.000',receipt_id= '',amount= '188.42',booking_id='301',booking_cost= '250',receipt_allocation= '',balance= '250',ip='43.239.53.130',user_type='admin',admin_id='Ayman',temp_credit_limit='',log_type='Booking Modified',note='Booking Modified',create_date='2024-03-28 12:03:26';
[03/28/2024 12:22:26], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],delete from  agent_commission   WHERE booking_id='301';
[03/28/2024 12:22:26], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO agent_commission SET booking_id ='301',booking_detail_id ='301',agent_id ='7863',is_sub_agent ='N',parent_id ='',display_commission ='50',display_currency ='USD',paid ='N',type ='hotel',description ='Agent Mark Up Percentage is 25 %',create_date ='2024-03-28 12:22:26';
[03/28/2024 12:22:26], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],update bookings_details set total_nights='1' , supplier_id= 'expediapackage' , total_rooms= '2', arrival_date='2024/05/16', departure_date='2024/05/17', rate_code='~', hotel_address1='24/5 Moo 6, Thepkrasatri Rd.', hotel_name='Phuketa Hotel', hotel_phone='+6676241427' where booking_id ='301';
[03/28/2024 12:22:26], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
		('','','301','vouchered','2024-03-28 12:22:26','Booking Modified by Ayman','Ayman','43.239.53.130','Ayman','','');
[03/28/2024 12:22:29], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:22:29' WHERE id= '705';
[03/28/2024 12:22: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/28_03_2024/request_sight_details_Viator_test_12_22_29_1711628549.json', 'v1/28_03_2024/response_sight_details_Viator_test_12_22_29_1711628549.json', 'v1/28_03_2024/response_header_sight_details_Viator_test_12_22_29_1711628549.json', 'viator', '2024-03-28 12:22:30', '', '', '671');
[03/28/2024 12:22: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/28_03_2024/request_sight_details_Viator_test_12_22_30_1711628550.json', 'v1/28_03_2024/response_sight_details_Viator_test_12_22_30_1711628550.json', 'v1/28_03_2024/response_header_sight_details_Viator_test_12_22_30_1711628550.json', 'viator', '2024-03-28 12:22:30', '', '', '671');
[03/28/2024 12:22:38], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:22:38' WHERE id= '705';
[03/28/2024 12:22: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/28_03_2024/request_sight_details_Viator_test_12_22_38_1711628558.json', 'v1/28_03_2024/response_sight_details_Viator_test_12_22_38_1711628558.json', 'v1/28_03_2024/response_header_sight_details_Viator_test_12_22_38_1711628558.json', 'viator', '2024-03-28 12:22:38', '', '', '671');
[03/28/2024 12:22:39], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/28_03_2024/request_sight_details_Viator_test_12_22_38_1711628558.json', 'v1/28_03_2024/response_sight_details_Viator_test_12_22_38_1711628558.json', 'v1/28_03_2024/response_header_sight_details_Viator_test_12_22_38_1711628558.json', 'viator', '2024-03-28 12:22:39', '', '', '671');
[03/28/2024 12:22:43], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:22:43' WHERE id= '705';
[03/28/2024 12:22: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/28_03_2024/request_check_availability_Viator_test_12_22_43_1711628563.json', 'v1/28_03_2024/response_check_availability_Viator_test_12_22_43_1711628563.json', 'v1/28_03_2024/response_header_check_availability_Viator_test_12_22_43_1711628563.json', 'viator', '2024-03-28 12:22:44', '', '', '671');
[03/28/2024 12:22:59], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:22:59' WHERE id= '705';
[03/28/2024 12:23: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/28_03_2024/request_sight_details_Viator_test_12_22_59_1711628579.json', 'v1/28_03_2024/response_sight_details_Viator_test_12_22_59_1711628579.json', 'v1/28_03_2024/response_header_sight_details_Viator_test_12_22_59_1711628579.json', 'viator', '2024-03-28 12:23:05', '', '', '671');
[03/28/2024 12:23: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/28_03_2024/request_sight_details_Viator_test_12_23_05_1711628585.json', 'v1/28_03_2024/response_sight_details_Viator_test_12_23_05_1711628585.json', 'v1/28_03_2024/response_header_sight_details_Viator_test_12_23_05_1711628585.json', 'viator', '2024-03-28 12:23:05', '', '', '671');
[03/28/2024 12:23:09], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:23:09' WHERE id= '705';
[03/28/2024 12:23: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 ('', 'check_availability', 'v1/28_03_2024/request_check_availability_Viator_test_12_23_09_1711628589.json', 'v1/28_03_2024/response_check_availability_Viator_test_12_23_09_1711628589.json', 'v1/28_03_2024/response_header_check_availability_Viator_test_12_23_09_1711628589.json', 'viator', '2024-03-28 12:23:10', '', '', '671');
[03/28/2024 12:23:24], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_bookings set history_booking_id ='301', agent_id ='7863', itenirary_id ='7836835171571', confirmation_number ='7836835171571', payment_confirmation_no ='', voucher_id ='33', voucher_hashcode ='993828d8536a85f7e9238e514869385082138301', email_id ='', leader_title ='Mr', leader_first_name ='Sujay', leader_last_name ='Raut', city_id ='phuket', country_id ='136', display_room_rate ='250.000', native_room_rate ='200.000', native_currency_code ='USD', additional_charge ='0.000', cancellation_policy ='																								Free cancellation up to  19:58:59 on  2024-05-14&lt;br&gt;If you cancel between 2024-05-14 19:59:00 and 2024-05-16 00:00:00 , you will be charged 48.02 USD&lt;br&gt;No show is subject to a 100 % cancellation charge&lt;br&gt;&lt;br/&gt;&lt;b&gt;Amendment Policy&lt;/b&gt;&lt;br/&gt;
		Please note that most hotels treat changes in pax details, room category and dates as a cancellation of the booking, and charges will apply according to the cancellation policy.
		Late amendment charges may apply if requested after 19:59 on 14th of May 2024.
		Confirmation of amendments is subject to availability and rates at the time of making the amendment.
											
											
											
											', supplier_cancellation_policy ='', current_status ='vouchered', booking_status ='1', status_date ='2024-03-28 12:22:26', create_date ='2024-01-19 11:04:03', source_type ='expediapackage', expiration_date ='2024-05-14 16:59:00', comment_contract =' Bed Type Selection is not guaranteed.&lt;br/&gt;&lt;span style=\\&#039;color: red;\\&#039;&gt;&lt;strong&gt;Note&lt;/strong&gt;: Nightly rates might be calculated based on the average of Total Rate&lt;/span&gt;&lt;br&gt;&lt;br&gt;&lt;b&gt;Amenities:&lt;/b&gt;Free parking, Free WiFi&lt;br&gt;&lt;br&gt;&lt;b&gt;Deal:&lt;/b&gt; Book now and save,&lt;br&gt;&lt;br/&gt;&lt;br/&gt;&lt;br/&gt;&lt;b&gt;Checkin Start Time :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Checkin End Time :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Min Checkin Age :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Checkout Time :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Instructions :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Special Instructions :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Important Note :&lt;/b&gt; Agent agree that this rate is being sold with approved transport component.', admin_note ='', is_payment_gateway ='0', service_type ='hotel', service_type_detail ='', native_rate ='', display_rate ='', agent_rate ='250.000', wh_sub_agent_rate ='0.000', wh_agent_rate ='244.700', supplier_rate ='200.000', special_comment ='', special_remark ='', sms_status ='', is_xml ='0', consultant_id ='Ayman', admin_booked ='0', emailed_status ='0', applied_multiplier ='1.00000', applied_markup ='25', wh_applied_markup ='0.500', original_voucher ='', subagent_markup ='', agent_markup ='25', wh_agent_markup ='0.500', basecurrency_multiplier ='1.00000', wh_basecurrency_multiplier ='1.00000', basecurrency_multiplier_native ='1.00000', wh_basecurrency_multiplier_native ='1.00000', agent_currency_multiplier ='1.00000', wh_agent_currency_multiplier ='1.00000', modified_datetime ='2024-03-28 12:23:24', modified_by ='Ayman', display_currency_code ='USD', created_datetime ='2024-03-28 12:23:24', sub_agent_rate ='0.000', created_by ='Ayman', site_id ='20', applicable_service_tax ='0.000', wh_parent_agent_id ='7866', wh_agent_id ='7866', nationality ='Emirati', ip_addr ='43.239.53.130';
[03/28/2024 12:23:24], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_bookings_details  set  history_booking_detail_id ='166', old_reff_id ='77', booking_id ='301', supplier_id ='expediapack', total_nights ='1', arrival_date ='2024/05/16', departure_date ='2024/05/17', hotel_id ='2510986', hotel_name ='Phuketa Hotel', hotel_address1 ='24/5 Moo 6, Thepkrasatri Rd.', hotel_phone ='+6676241427', hotel_rating ='4.0', rate_code ='~', touricoRoomResId ='', gta_item_confirm_ref ='', channel_manager ='', reservation_pushed ='0', gtaToken ='';
[03/28/2024 12:23:24], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_passangers set history_passenger_id = '529', old_reff_id = '77', booking_id = '301', booking_detail_id = '166', salutations = 'Mr', room = '0', rid = '278', first_name = 'Sujay', last_name = 'Raut' ,passenger_type = 'adult' ,age = '';
[03/28/2024 12:23:24], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_passangers set history_passenger_id = '530', old_reff_id = '77', booking_id = '301', booking_detail_id = '166', salutations = 'Mr', room = '0', rid = '278', first_name = 'TBA', last_name = 'TBA' ,passenger_type = 'adult' ,age = '';
[03/28/2024 12:23:24], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],delete from passangers WHERE booking_id=?;
[03/28/2024 12:23:24], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_booking_room_detail set rid = '278', old_reff_id = '77', booking_id = '301', booking_detail_id = '166', room_type_code = '', room_name = 'single', room_type_description = 'FullBed Deluxe Front View (Double)(Room Only)- Package Deal (Book now and save)(1 Double Bed)', display_nightly_rates = 'a:1:{i:0;a:2:{s:18:"displayNightlyRate";s:3:"125";s:13:"whNightlyRate";s:6:"122.35";}}' ,native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";s:3:"100";}}' ,native_room_rate_total = '200' ,display_room_rate_total = '250' ,wh_room_rate_total = '' ,number_of_rooms = '2';
[03/28/2024 12:23:24], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],delete from booking_room_detail WHERE booking_id=?;
[03/28/2024 12:23:24], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],delete from passangers WHERE booking_id=?;
[03/28/2024 12:23:24], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO booking_room_detail set booking_id = '301', booking_detail_id = '166', room_type_code = '', room_name = 'single', room_type_description = 'FullBed Deluxe Front View (Double)(Room Only)- Package Deal (Book now and save)(1 Double Bed)', display_nightly_rates = 'a:1:{i:0;a:2:{s:18:"displayNightlyRate";s:3:"125";s:13:"whNightlyRate";s:6:"125.63";}}' ,native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";s:3:"100";}}' ,native_room_rate_total = '200' ,display_room_rate_total = '250' ,number_of_rooms = '2';
[03/28/2024 12:23:24], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO passangers set booking_id = '301', booking_detail_id = '166', salutations = 'Mr', room = '', rid = '279', first_name = 'Sujay', last_name = 'Raut' ,age = '';
[03/28/2024 12:23:24], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO passangers set booking_id = '301', booking_detail_id = '166', salutations = 'Mr', room = '', rid = '279', first_name = 'TBA', last_name = 'TBA' ,age = '';
[03/28/2024 12:23:24], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],UPDATE bookings SET confirmation_number='7836835171571',cancellation_policy='																														Free cancellation up to  19:58:59 on  2024-05-14&lt;br&gt;If you cancel between 2024-05-14 19:59:00 and 2024-05-16 00:00:00 , you will be charged 48.02 USD&lt;br&gt;No show is subject to a 100 % cancellation charge&lt;br&gt;&lt;br/&gt;&lt;b&gt;Amendment Policy&lt;/b&gt;&lt;br/&gt;
		Please note that most hotels treat changes in pax details, room category and dates as a cancellation of the booking, and charges will apply according to the cancellation policy.
		Late amendment charges may apply if requested after 19:59 on 14th of May 2024.
		Confirmation of amendments is subject to availability and rates at the time of making the amendment.
											
											
											
											
											',supplier_cancellation_policy='',applied_multiplier='1.00000',applied_markup='25',agent_markup='25',consultant_id='Ayman',basecurrency_multiplier='1.00000',basecurrency_multiplier_native='1.00000'_native,agent_currency_multiplier='1.00000',current_status='vouchered',status_date='2024-03-28 12:23:24',service_date='2024-05-16',check_out_date='2024-05-17',display_room_rate= '250',display_discount='0',modified_datetime='2024-03-28 12:23:24',modified_by ='Ayman',native_room_rate='200',native_discount='0.000',additional_charge='0.000',applicable_service_tax='',leader_title='Mr',leader_first_name='Sujay',leader_last_name='Raut',nationality ='Emirati',booking_type ='online',supplier_profile_id ='43',expiration_date= '2024-05-14 16:59:00',source_type='expediapackage',special_comment='',admin_note='',comment_contract=' Bed Type Selection is not guaranteed.&lt;br/&gt;&lt;span style=\&#039;color: red;\&#039;&gt;&lt;strong&gt;Note&lt;/strong&gt;: Nightly rates might be calculated based on the average of Total Rate&lt;/span&gt;&lt;br&gt;&lt;br&gt;&lt;b&gt;Amenities:&lt;/b&gt;Free parking, Free WiFi&lt;br&gt;&lt;br&gt;&lt;b&gt;Deal:&lt;/b&gt; Book now and save,&lt;br&gt;&lt;br/&gt;&lt;br/&gt;&lt;br/&gt;&lt;b&gt;Checkin Start Time :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Checkin End Time :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Min Checkin Age :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Checkout Time :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Instructions :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Special Instructions :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Important Note :&lt;/b&gt; Agent agree that this rate is being sold with approved transport component.' WHERE id='301';
[03/28/2024 12:23:24], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],update bookings set  parent_agent_id='7863', sub_agent_rate='', agent_rate='250', agent_markup='25', supplier_rate='200', wh_sub_agent_rate='', wh_agent_rate='251.26' where id='301';
[03/28/2024 12:23:24], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php], insert into booking_rate_info set  booking_id = '301', booking_log = 'Booking Modified', create_date = '2024-03-28 12:23:24', supplier_currency ='USD', type = 'Ammended', agent_price = '', sub_agent_price ='', supplier_price = '', supplier_id = 'expediapack', supplier_type = 'online';
[03/28/2024 12:23:24], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php], insert into booking_rate_info set  booking_id = '301', booking_log = 'Booking Modified', create_date = '2024-03-28 12:23:24', supplier_currency ='USD', type = 'Ammended', agent_price = '', sub_agent_price ='', supplier_price = '200.000', supplier_id = 'expediapackage', supplier_type = 'online';
[03/28/2024 12:23:24], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php], update wh_booking_rate_info set  booking_id = '301', booking_log = 'Booking Modified', create_date = '2024-03-28 12:23:24', agent_price = '251.260', sub_agent_price = '0.000', supplier_price = '250.000' where booking_id = '301'  and type = "Sale";
[03/28/2024 12:23:24], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],update bookings_details set total_nights='1' , supplier_id= 'expediapackage' , total_rooms= '2', arrival_date='2024/05/16', departure_date='2024/05/17', rate_code='~', hotel_address1='24/5 Moo 6, Thepkrasatri Rd.', hotel_name='Phuketa Hotel', hotel_phone='+6676241427' where booking_id ='301';
[03/28/2024 12:23:24], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
		('','','301','vouchered','2024-03-28 12:23:24','Booking Modified by Ayman','Ayman','43.239.53.130','Ayman','','');
[03/28/2024 12:23:29], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:23:29' WHERE id= '705';
[03/28/2024 12:23:29], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'check_availability', 'v1/28_03_2024/request_check_availability_Viator_test_12_23_29_1711628609.json', 'v1/28_03_2024/response_check_availability_Viator_test_12_23_29_1711628609.json', 'v1/28_03_2024/response_header_check_availability_Viator_test_12_23_29_1711628609.json', 'viator', '2024-03-28 12:23:29', '', '', '671');
[03/28/2024 12:23:52], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:23:52' WHERE id= '705';
[03/28/2024 12:23: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 = 'belize' , arrival_date='2024/04/18',  departure_date='2024/04/18',  nights='1',  create_date='2024-03-28 :12:23:52',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[03/28/2024 12:24:20], [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/28_03_2024/request_availability_Viator_test_12_23_52_1711628632.json', 'v1/28_03_2024/response_availability_Viator_test_12_23_52_1711628632.json', 'v1/28_03_2024/response_header_availability_Viator_test_12_23_52_1711628632.json', 'viator', '2024-03-28 12:24:20', '', '', '672');
[03/28/2024 12:24:36], [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/28_03_2024/request_availability_Viator_test_12_24_20_1711628660_48.json', 'v1/28_03_2024/response_availability_Viator_test_12_24_20_1711628660_48.json', 'v1/28_03_2024/response_header_availability_Viator_test_12_24_20_1711628660_48.json', 'viator', '2024-03-28 12:24:36', '', '', '672');
[03/28/2024 12:24:36], [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/28_03_2024/request_availability_Viator_test_12_24_20_1711628660_48.json', 'v1/28_03_2024/response_availability_Viator_test_12_24_20_1711628660_48.json', 'v1/28_03_2024/response_header_availability_Viator_test_12_24_20_1711628660_48.json', 'viator', '2024-03-28 12:24:36', '', '', '672');
[03/28/2024 12:24:36], [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/28_03_2024/request_availability_Viator_test_12_24_20_1711628660_48.json', 'v1/28_03_2024/response_availability_Viator_test_12_24_20_1711628660_48.json', 'v1/28_03_2024/response_header_availability_Viator_test_12_24_20_1711628660_48.json', 'viator', '2024-03-28 12:24:36', '', '', '672');
[03/28/2024 12:24:36], [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/28_03_2024/request_availability_Viator_test_12_24_20_1711628660_48.json', 'v1/28_03_2024/response_availability_Viator_test_12_24_20_1711628660_48.json', 'v1/28_03_2024/response_header_availability_Viator_test_12_24_20_1711628660_48.json', 'viator', '2024-03-28 12:24:36', '', '', '672');
[03/28/2024 12:24:36], [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/28_03_2024/request_availability_Viator_test_12_24_20_1711628660_48.json', 'v1/28_03_2024/response_availability_Viator_test_12_24_20_1711628660_48.json', 'v1/28_03_2024/response_header_availability_Viator_test_12_24_20_1711628660_48.json', 'viator', '2024-03-28 12:24:36', '', '', '672');
[03/28/2024 12:24:36], [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/28_03_2024/request_availability_Viator_test_12_24_20_1711628660_48.json', 'v1/28_03_2024/response_availability_Viator_test_12_24_20_1711628660_48.json', 'v1/28_03_2024/response_header_availability_Viator_test_12_24_20_1711628660_48.json', 'viator', '2024-03-28 12:24:36', '', '', '672');
[03/28/2024 12:24:36], [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/28_03_2024/request_availability_Viator_test_12_24_20_1711628660_48.json', 'v1/28_03_2024/response_availability_Viator_test_12_24_20_1711628660_48.json', 'v1/28_03_2024/response_header_availability_Viator_test_12_24_20_1711628660_48.json', 'viator', '2024-03-28 12:24:36', '', '', '672');
[03/28/2024 12:24:36], [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/28_03_2024/request_availability_Viator_test_12_24_20_1711628660_48.json', 'v1/28_03_2024/response_availability_Viator_test_12_24_20_1711628660_48.json', 'v1/28_03_2024/response_header_availability_Viator_test_12_24_20_1711628660_48.json', 'viator', '2024-03-28 12:24:36', '', '', '672');
[03/28/2024 12:24:36], [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/28_03_2024/request_availability_Viator_test_12_24_20_1711628660_48.json', 'v1/28_03_2024/response_availability_Viator_test_12_24_20_1711628660_48.json', 'v1/28_03_2024/response_header_availability_Viator_test_12_24_20_1711628660_48.json', 'viator', '2024-03-28 12:24:36', '', '', '672');
[03/28/2024 12:24:38], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:24:38' WHERE id= '705';
[03/28/2024 12:24:38], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:24:38' WHERE id= '705';
[03/28/2024 12:24:39], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:24:39' WHERE id= '729';
[03/28/2024 12:24:42], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:24:42' WHERE id= '729';
[03/28/2024 12:24:43], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:24:43' WHERE id= '705';
[03/28/2024 12:24:43], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/28_03_2024/request_sight_details_Viator_test_12_24_43_1711628683.json', 'v1/28_03_2024/response_sight_details_Viator_test_12_24_43_1711628683.json', 'v1/28_03_2024/response_header_sight_details_Viator_test_12_24_43_1711628683.json', 'viator', '2024-03-28 12:24:43', '', '', '672');
[03/28/2024 12:24:43], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/28_03_2024/request_sight_details_Viator_test_12_24_43_1711628683.json', 'v1/28_03_2024/response_sight_details_Viator_test_12_24_43_1711628683.json', 'v1/28_03_2024/response_header_sight_details_Viator_test_12_24_43_1711628683.json', 'viator', '2024-03-28 12:24:43', '', '', '672');
[03/28/2024 12:24:46], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:24:46' WHERE id= '705';
[03/28/2024 12:24: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/28_03_2024/request_check_availability_Viator_test_12_24_46_1711628686.json', 'v1/28_03_2024/response_check_availability_Viator_test_12_24_46_1711628686.json', 'v1/28_03_2024/response_header_check_availability_Viator_test_12_24_46_1711628686.json', 'viator', '2024-03-28 12:24:47', '', '', '672');
[03/28/2024 12:24:51], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:24:51' WHERE id= '729';
[03/28/2024 12:24:51], [file name :-/home/otrams/public_html/beta/booking_list.php],update messages set mssg_status='R' where booking_id=?;
[03/28/2024 12:24:51], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:24:51' WHERE id= '705';
[03/28/2024 12:24:51], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1711628691','43.239.53.130');
[03/28/2024 12:24:56], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:24:56' WHERE id= '705';
[03/28/2024 12:25:02], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:25:02' WHERE id= '705';
[03/28/2024 12:25:05], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:25:05' WHERE id= '705';
[03/28/2024 12:25:07], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:25:07' WHERE id= '705';
[03/28/2024 12:25:09], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:25:09' WHERE id= '705';
[03/28/2024 12:25:12], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:25:12' WHERE id= '705';
[03/28/2024 12:25:13], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:25:13' WHERE id= '705';
[03/28/2024 12:25:18], [file name :-/home/otrams/public_html/beta/hotel_search.php],INSERT INTO psa_login_log  SET username = '', user_type = 'A', branch_id = '7', login_datetime = '2024-03-28 12:25:18', ip = '66.249.66.168', action = 'Login' ;
[03/28/2024 12:25:35], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:25:35' WHERE id= '705';
[03/28/2024 12:25:35], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1711628735','43.239.53.130');
[03/28/2024 12:25:36], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:25:36' WHERE id= '705';
[03/28/2024 12:25:36], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO bookings set reservation_id='4266',agent_id='7851',leader_title='Mr',leader_first_name='shiv',leader_last_name='chauhan',city_id='belize',country_id='5',nationality='Belizean',display_room_rate='198.08',display_currency_code='USD',native_room_rate='198.08',consultant_id='SUJAY_QTECH',native_currency_code='USD',cancellation_policy='Cancellation Charges will be applicable if cancelled after 18 Apr 2024 00:00 hrs.<BR>Late amendment charge may apply.',current_status='inprocess-booking',booking_status='1',sales_manager_id='0',create_date='2024-03-28 12:25:36',source_type='viator',expiration_date= '2024-04-17 21:00:00',applied_multiplier='1.00000',applied_markup='0',agent_markup='0',basecurrency_multiplier='1.00000',basecurrency_multiplier_native='1.00000',admin_booked='0',service_date='2024-04-18',sub_user_id='',check_out_date='2024-04-18',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';
[03/28/2024 12:25:36], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO sight_bookings set booking_id='571',native_nightly_rates='a:2:{s:4:\"size\";i:1;s:17:\"nativeNightlyRate\";d:198.08000000000001;}',rate_description='',display_nightly_rates='a:4:{s:4:\"size\";i:1;s:18:\"displayNightlyRate\";d:198.08000000000001;s:25:\"displayNightlyRateDisplay\";s:134:\"Rate - 198.08 USD, Currency Multiplier (USD-USD) - 1.00000, Markup  in % - %, Markup Amount - , Markup Amount in  - ,Other Markup - 0%\";s:23:\"displayNightlyRateStore\";s:135:\"Rate - 198.08 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='9025P1',sight_name='CAVE TUBING FROM BELIZE CITY - V2',tour_time='',tour_details='',tour_inclusive='H<br/>',tour_exclusive='G<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: 09:00',arrival_date='2024-04-18',total_adults='2',total_children='0',total_infants='0',gta_city_code='5094',supplier_id='9025P1',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='';
[03/28/2024 12:25:36], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO posted_bookings(id,source_type,reservation_id,create_date,status) values ('','viator','4266','2024-03-28 12:25:36',0);
[03/28/2024 12:25:39], [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/28_03_2024/request_reservation_sight_Viator_test_12_25_36_1711628736.json', 'v1/28_03_2024/response_reservation_sight_Viator_test_12_25_36_1711628736.json', 'v1/28_03_2024/response_header_reservation_sight_Viator_test_12_25_36_1711628736.json', 'viator', '2024-03-28 12:25:39', '', '', '672');
[03/28/2024 12:25:39], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE posted_bookings set status=1 where id= '498';
[03/28/2024 12:30:31], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:30:31' WHERE id= '705';
[03/28/2024 12:30:31], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO bookings set reservation_id='4266',agent_id='7851',leader_title='Mr',leader_first_name='shiv',leader_last_name='chauhan',city_id='belize',country_id='5',nationality='Belizean',display_room_rate='198.08',display_currency_code='USD',native_room_rate='198.08',consultant_id='SUJAY_QTECH',native_currency_code='USD',cancellation_policy='Cancellation Charges will be applicable if cancelled after 18 Apr 2024 00:00 hrs.<BR>Late amendment charge may apply.',current_status='inprocess-booking',booking_status='1',sales_manager_id='0',create_date='2024-03-28 12:30:31',source_type='viator',expiration_date= '2024-04-17 21:00:00',applied_multiplier='1.00000',applied_markup='0',agent_markup='0',basecurrency_multiplier='1.00000',basecurrency_multiplier_native='1.00000',admin_booked='0',service_date='2024-04-18',sub_user_id='',check_out_date='2024-04-18',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';
[03/28/2024 12:30:31], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO sight_bookings set booking_id='572',native_nightly_rates='a:2:{s:4:\"size\";i:1;s:17:\"nativeNightlyRate\";d:198.08000000000001;}',rate_description='',display_nightly_rates='a:4:{s:4:\"size\";i:1;s:18:\"displayNightlyRate\";d:198.08000000000001;s:25:\"displayNightlyRateDisplay\";s:134:\"Rate - 198.08 USD, Currency Multiplier (USD-USD) - 1.00000, Markup  in % - %, Markup Amount - , Markup Amount in  - ,Other Markup - 0%\";s:23:\"displayNightlyRateStore\";s:135:\"Rate - 198.08 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='9025P1',sight_name='CAVE TUBING FROM BELIZE CITY - V2',tour_time='',tour_details='',tour_inclusive='H<br/>',tour_exclusive='G<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: 09:00',arrival_date='2024-04-18',total_adults='2',total_children='0',total_infants='0',gta_city_code='5094',supplier_id='9025P1',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='';
[03/28/2024 12:30:31], [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','4266','2024-03-28 12:30:31',0);
[03/28/2024 12:30: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/28_03_2024/request_reservation_sight_Viator_test_12_30_31_1711629031.json', 'v1/28_03_2024/response_reservation_sight_Viator_test_12_30_31_1711629031.json', 'v1/28_03_2024/response_header_reservation_sight_Viator_test_12_30_31_1711629031.json', 'viator', '2024-03-28 12:30:33', '', '', '672');
[03/28/2024 12:30:33], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE posted_bookings set status=1 where id= '499';
[03/28/2024 12:30: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='198.08', supplier_rate='198.08', uid='', itenirary_id='4266237', confirmation_number='BR-596090989', comment_contract='', current_status='confirmed', original_source='' where id='572';
[03/28/2024 12:30: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-596090989',viator_ref='BR-596090989',viator_item_id='',viator_voucherKey='https://shop.live.rc.viator.com/ticket?code=1020898799:9ccc5524c8b3f4f1fa59de537333a86b18d9ae4bd8b86c52877840483aee19d2:596090989',tour_supplier='',textaddition_activities='N;' where booking_id='572';
[03/28/2024 12:30: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
		('','','572','confirmed','2024-03-28 12:30:33','Sightseeing Booking confirmed by Agent..7851','7851','43.239.53.130','','','');
[03/28/2024 12:30: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('572','Mr','1','shiv','chauhan','adult','0');
[03/28/2024 12:30: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('572','Mr','1','deepak','trivedi','adult','0');
[03/28/2024 12:30:33], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],update xmllogs set reservation_id='572' where agent_logs_id='672' and source_type='viator';
[03/28/2024 12:32:56], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:32:56' WHERE id= '705';
[03/28/2024 12:32:56], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-03-28 12:32:56',login_attempt=0 where id = '7851';
[03/28/2024 12:32:56], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Viator_test', user_type = 'A', branch_id = '27', login_datetime = '2024-03-28 12:32:56', ip = '43.239.53.130', action = 'Login' ;
[03/28/2024 12:32:56], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:32:56' WHERE id= '705';
[03/28/2024 12:33:03], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:33:03' WHERE id= '705';
[03/28/2024 12:33:10], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:33:10' WHERE id= '705';
[03/28/2024 12:33:11], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:33:11' WHERE id= '705';
[03/28/2024 12:33:12], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:33:12' WHERE id= '705';
[03/28/2024 12:33:12], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:33:12' WHERE id= '705';
[03/28/2024 12:33:19], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:33:19' WHERE id= '705';
[03/28/2024 12:33:20], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7851' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '27' , ip = '43.239.53.130' , city = 'belize' , arrival_date='2024/04/18',  departure_date='2024/04/18',  nights='1',  create_date='2024-03-28 :12:33:20',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[03/28/2024 12:33:23], [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/28_03_2024/request_availability_Viator_test_12_33_20_1711629200.json', 'v1/28_03_2024/response_availability_Viator_test_12_33_20_1711629200.json', 'v1/28_03_2024/response_header_availability_Viator_test_12_33_20_1711629200.json', 'viator', '2024-03-28 12:33:23', '', '', '673');
[03/28/2024 12:33: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/28_03_2024/request_availability_Viator_test_12_33_23_1711629203_27.json', 'v1/28_03_2024/response_availability_Viator_test_12_33_23_1711629203_27.json', 'v1/28_03_2024/response_header_availability_Viator_test_12_33_23_1711629203_27.json', 'viator', '2024-03-28 12:33:39', '', '', '673');
[03/28/2024 12:33: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/28_03_2024/request_availability_Viator_test_12_33_23_1711629203_27.json', 'v1/28_03_2024/response_availability_Viator_test_12_33_23_1711629203_27.json', 'v1/28_03_2024/response_header_availability_Viator_test_12_33_23_1711629203_27.json', 'viator', '2024-03-28 12:33:39', '', '', '673');
[03/28/2024 12:33: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/28_03_2024/request_availability_Viator_test_12_33_23_1711629203_27.json', 'v1/28_03_2024/response_availability_Viator_test_12_33_23_1711629203_27.json', 'v1/28_03_2024/response_header_availability_Viator_test_12_33_23_1711629203_27.json', 'viator', '2024-03-28 12:33:39', '', '', '673');
[03/28/2024 12:33: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/28_03_2024/request_availability_Viator_test_12_33_23_1711629203_27.json', 'v1/28_03_2024/response_availability_Viator_test_12_33_23_1711629203_27.json', 'v1/28_03_2024/response_header_availability_Viator_test_12_33_23_1711629203_27.json', 'viator', '2024-03-28 12:33:39', '', '', '673');
[03/28/2024 12:33: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/28_03_2024/request_availability_Viator_test_12_33_23_1711629203_27.json', 'v1/28_03_2024/response_availability_Viator_test_12_33_23_1711629203_27.json', 'v1/28_03_2024/response_header_availability_Viator_test_12_33_23_1711629203_27.json', 'viator', '2024-03-28 12:33:39', '', '', '673');
[03/28/2024 12:33: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/28_03_2024/request_availability_Viator_test_12_33_23_1711629203_27.json', 'v1/28_03_2024/response_availability_Viator_test_12_33_23_1711629203_27.json', 'v1/28_03_2024/response_header_availability_Viator_test_12_33_23_1711629203_27.json', 'viator', '2024-03-28 12:33:39', '', '', '673');
[03/28/2024 12:33: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/28_03_2024/request_availability_Viator_test_12_33_23_1711629203_27.json', 'v1/28_03_2024/response_availability_Viator_test_12_33_23_1711629203_27.json', 'v1/28_03_2024/response_header_availability_Viator_test_12_33_23_1711629203_27.json', 'viator', '2024-03-28 12:33:39', '', '', '673');
[03/28/2024 12:33: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/28_03_2024/request_availability_Viator_test_12_33_23_1711629203_27.json', 'v1/28_03_2024/response_availability_Viator_test_12_33_23_1711629203_27.json', 'v1/28_03_2024/response_header_availability_Viator_test_12_33_23_1711629203_27.json', 'viator', '2024-03-28 12:33:39', '', '', '673');
[03/28/2024 12:33: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/28_03_2024/request_availability_Viator_test_12_33_23_1711629203_27.json', 'v1/28_03_2024/response_availability_Viator_test_12_33_23_1711629203_27.json', 'v1/28_03_2024/response_header_availability_Viator_test_12_33_23_1711629203_27.json', 'viator', '2024-03-28 12:33:39', '', '', '673');
[03/28/2024 12:33:41], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:33:41' WHERE id= '705';
[03/28/2024 12:33:42], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:33:42' WHERE id= '705';
[03/28/2024 12:37:08], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:37:08' WHERE id= '705';
[03/28/2024 12:37:09], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/28_03_2024/request_sight_details_Viator_test_12_37_08_1711629428.json', 'v1/28_03_2024/response_sight_details_Viator_test_12_37_08_1711629428.json', 'v1/28_03_2024/response_header_sight_details_Viator_test_12_37_08_1711629428.json', 'viator', '2024-03-28 12:37:09', '', '', '673');
[03/28/2024 12:37:09], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/28_03_2024/request_sight_details_Viator_test_12_37_09_1711629429.json', 'v1/28_03_2024/response_sight_details_Viator_test_12_37_09_1711629429.json', 'v1/28_03_2024/response_header_sight_details_Viator_test_12_37_09_1711629429.json', 'viator', '2024-03-28 12:37:09', '', '', '673');
[03/28/2024 12:37:13], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:37:13' WHERE id= '705';
[03/28/2024 12: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/28_03_2024/request_check_availability_Viator_test_12_37_13_1711629433.json', 'v1/28_03_2024/response_check_availability_Viator_test_12_37_13_1711629433.json', 'v1/28_03_2024/response_header_check_availability_Viator_test_12_37_13_1711629433.json', 'viator', '2024-03-28 12:37:14', '', '', '673');
[03/28/2024 12:37:25], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:37:25' WHERE id= '705';
[03/28/2024 12:37: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 ('', 'sight_details', 'v1/28_03_2024/request_sight_details_Viator_test_12_37_25_1711629445.json', 'v1/28_03_2024/response_sight_details_Viator_test_12_37_25_1711629445.json', 'v1/28_03_2024/response_header_sight_details_Viator_test_12_37_25_1711629445.json', 'viator', '2024-03-28 12:37:25', '', '', '673');
[03/28/2024 12:37:26], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/28_03_2024/request_sight_details_Viator_test_12_37_25_1711629445.json', 'v1/28_03_2024/response_sight_details_Viator_test_12_37_25_1711629445.json', 'v1/28_03_2024/response_header_sight_details_Viator_test_12_37_25_1711629445.json', 'viator', '2024-03-28 12:37:26', '', '', '673');
[03/28/2024 12:37:28], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:37:28' WHERE id= '705';
[03/28/2024 12:37:29], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'check_availability', 'v1/28_03_2024/request_check_availability_Viator_test_12_37_28_1711629448.json', 'v1/28_03_2024/response_check_availability_Viator_test_12_37_28_1711629448.json', 'v1/28_03_2024/response_header_check_availability_Viator_test_12_37_28_1711629448.json', 'viator', '2024-03-28 12:37:29', '', '', '673');
[03/28/2024 12:37:38], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:37:38' WHERE id= '705';
[03/28/2024 12:37: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/28_03_2024/request_sight_details_Viator_test_12_37_38_1711629458.json', 'v1/28_03_2024/response_sight_details_Viator_test_12_37_38_1711629458.json', 'v1/28_03_2024/response_header_sight_details_Viator_test_12_37_38_1711629458.json', 'viator', '2024-03-28 12:37:40', '', '', '673');
[03/28/2024 12:37:41], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/28_03_2024/request_sight_details_Viator_test_12_37_40_1711629460.json', 'v1/28_03_2024/response_sight_details_Viator_test_12_37_40_1711629460.json', 'v1/28_03_2024/response_header_sight_details_Viator_test_12_37_40_1711629460.json', 'viator', '2024-03-28 12:37:41', '', '', '673');
[03/28/2024 12:37:45], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:37:45' WHERE id= '705';
[03/28/2024 12:37: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/28_03_2024/request_check_availability_Viator_test_12_37_45_1711629465.json', 'v1/28_03_2024/response_check_availability_Viator_test_12_37_45_1711629465.json', 'v1/28_03_2024/response_header_check_availability_Viator_test_12_37_45_1711629465.json', 'viator', '2024-03-28 12:37:45', '', '', '673');
[03/28/2024 12:37:52], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:37:52' WHERE id= '705';
[03/28/2024 12:37: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/28_03_2024/request_sight_details_Viator_test_12_37_53_1711629473.json', 'v1/28_03_2024/response_sight_details_Viator_test_12_37_53_1711629473.json', 'v1/28_03_2024/response_header_sight_details_Viator_test_12_37_53_1711629473.json', 'viator', '2024-03-28 12:37:53', '', '', '673');
[03/28/2024 12:37: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/28_03_2024/request_sight_details_Viator_test_12_37_53_1711629473.json', 'v1/28_03_2024/response_sight_details_Viator_test_12_37_53_1711629473.json', 'v1/28_03_2024/response_header_sight_details_Viator_test_12_37_53_1711629473.json', 'viator', '2024-03-28 12:37:53', '', '', '673');
[03/28/2024 12:37:57], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:37:57' WHERE id= '705';
[03/28/2024 12:37:57], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'check_availability', 'v1/28_03_2024/request_check_availability_Viator_test_12_37_57_1711629477.json', 'v1/28_03_2024/response_check_availability_Viator_test_12_37_57_1711629477.json', 'v1/28_03_2024/response_header_check_availability_Viator_test_12_37_57_1711629477.json', 'viator', '2024-03-28 12:37:57', '', '', '673');
[03/28/2024 12:38:06], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:38:06' WHERE id= '705';
[03/28/2024 12:38: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/28_03_2024/request_sight_details_Viator_test_12_38_06_1711629486.json', 'v1/28_03_2024/response_sight_details_Viator_test_12_38_06_1711629486.json', 'v1/28_03_2024/response_header_sight_details_Viator_test_12_38_06_1711629486.json', 'viator', '2024-03-28 12:38:07', '', '', '673');
[03/28/2024 12:38: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/28_03_2024/request_sight_details_Viator_test_12_38_07_1711629487.json', 'v1/28_03_2024/response_sight_details_Viator_test_12_38_07_1711629487.json', 'v1/28_03_2024/response_header_sight_details_Viator_test_12_38_07_1711629487.json', 'viator', '2024-03-28 12:38:07', '', '', '673');
[03/28/2024 12:38:10], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:38:10' WHERE id= '705';
[03/28/2024 12:38:11], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'check_availability', 'v1/28_03_2024/request_check_availability_Viator_test_12_38_10_1711629490.json', 'v1/28_03_2024/response_check_availability_Viator_test_12_38_10_1711629490.json', 'v1/28_03_2024/response_header_check_availability_Viator_test_12_38_10_1711629490.json', 'viator', '2024-03-28 12:38:11', '', '', '673');
[03/28/2024 12:38:36], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:38:36' WHERE id= '705';
[03/28/2024 12:38:42], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/28_03_2024/request_sight_details_Viator_test_12_38_36_1711629516.json', 'v1/28_03_2024/response_sight_details_Viator_test_12_38_36_1711629516.json', 'v1/28_03_2024/response_header_sight_details_Viator_test_12_38_36_1711629516.json', 'viator', '2024-03-28 12:38:39', '', '', '673');
[03/28/2024 12:38:46], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/28_03_2024/request_sight_details_Viator_test_12_38_46_1711629526.json', 'v1/28_03_2024/response_sight_details_Viator_test_12_38_46_1711629526.json', 'v1/28_03_2024/response_header_sight_details_Viator_test_12_38_46_1711629526.json', 'viator', '2024-03-28 12:38:46', '', '', '673');
[03/28/2024 12:38:52], [file name :-/home/otrams/public_html/beta/ajax_getsightlist.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:38:52' WHERE id= '705';
[03/28/2024 12:38:53], [file name :-/home/otrams/public_html/beta/ajax_getsightlist.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:38:53' WHERE id= '705';
[03/28/2024 12:38:53], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:38:53' WHERE id= '705';
[03/28/2024 12:38:54], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:38:54' WHERE id= '705';
[03/28/2024 12:39:00], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:39:00' WHERE id= '705';
[03/28/2024 12:39:01], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/28_03_2024/request_sight_details_Viator_test_12_39_00_1711629540.json', 'v1/28_03_2024/response_sight_details_Viator_test_12_39_00_1711629540.json', 'v1/28_03_2024/response_header_sight_details_Viator_test_12_39_00_1711629540.json', 'viator', '2024-03-28 12:39:01', '', '', '673');
[03/28/2024 12:39:01], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/28_03_2024/request_sight_details_Viator_test_12_39_01_1711629541.json', 'v1/28_03_2024/response_sight_details_Viator_test_12_39_01_1711629541.json', 'v1/28_03_2024/response_header_sight_details_Viator_test_12_39_01_1711629541.json', 'viator', '2024-03-28 12:39:01', '', '', '673');
[03/28/2024 12:39:03], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:39:03' WHERE id= '705';
[03/28/2024 12:39:03], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'check_availability', 'v1/28_03_2024/request_check_availability_Viator_test_12_39_03_1711629543.json', 'v1/28_03_2024/response_check_availability_Viator_test_12_39_03_1711629543.json', 'v1/28_03_2024/response_header_check_availability_Viator_test_12_39_03_1711629543.json', 'viator', '2024-03-28 12:39:03', '', '', '673');
[03/28/2024 12:39:21], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:39:21' WHERE id= '705';
[03/28/2024 12:39:21], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1711629561','43.239.53.130');
[03/28/2024 12:39:28], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:39:28' WHERE id= '705';
[03/28/2024 12:39:30], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:39:30' WHERE id= '705';
[03/28/2024 12:39:30], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:39:30' WHERE id= '705';
[03/28/2024 12:39:32], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:39:32' WHERE id= '705';
[03/28/2024 12:39:33], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/28_03_2024/request_sight_details_Viator_test_12_39_32_1711629572.json', 'v1/28_03_2024/response_sight_details_Viator_test_12_39_32_1711629572.json', 'v1/28_03_2024/response_header_sight_details_Viator_test_12_39_32_1711629572.json', 'viator', '2024-03-28 12:39:33', '', '', '673');
[03/28/2024 12:39: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/28_03_2024/request_sight_details_Viator_test_12_39_33_1711629573.json', 'v1/28_03_2024/response_sight_details_Viator_test_12_39_33_1711629573.json', 'v1/28_03_2024/response_header_sight_details_Viator_test_12_39_33_1711629573.json', 'viator', '2024-03-28 12:39:34', '', '', '673');
[03/28/2024 12:39:36], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:39:36' WHERE id= '705';
[03/28/2024 12:39:37], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'check_availability', 'v1/28_03_2024/request_check_availability_Viator_test_12_39_36_1711629576.json', 'v1/28_03_2024/response_check_availability_Viator_test_12_39_36_1711629576.json', 'v1/28_03_2024/response_header_check_availability_Viator_test_12_39_36_1711629576.json', 'viator', '2024-03-28 12:39:37', '', '', '673');
[03/28/2024 12:39:45], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:39:45' WHERE id= '705';
[03/28/2024 12:39:46], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/28_03_2024/request_sight_details_Viator_test_12_39_45_1711629585.json', 'v1/28_03_2024/response_sight_details_Viator_test_12_39_45_1711629585.json', 'v1/28_03_2024/response_header_sight_details_Viator_test_12_39_45_1711629585.json', 'viator', '2024-03-28 12:39:46', '', '', '673');
[03/28/2024 12:39:46], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/28_03_2024/request_sight_details_Viator_test_12_39_46_1711629586.json', 'v1/28_03_2024/response_sight_details_Viator_test_12_39_46_1711629586.json', 'v1/28_03_2024/response_header_sight_details_Viator_test_12_39_46_1711629586.json', 'viator', '2024-03-28 12:39:46', '', '', '673');
[03/28/2024 12:39:48], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:39:48' WHERE id= '705';
[03/28/2024 12:39: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 ('', 'check_availability', 'v1/28_03_2024/request_check_availability_Viator_test_12_39_48_1711629588.json', 'v1/28_03_2024/response_check_availability_Viator_test_12_39_48_1711629588.json', 'v1/28_03_2024/response_header_check_availability_Viator_test_12_39_48_1711629588.json', 'viator', '2024-03-28 12:39:49', '', '', '673');
[03/28/2024 12:40:00], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:40:00' WHERE id= '705';
[03/28/2024 12:40:01], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/28_03_2024/request_sight_details_Viator_test_12_40_00_1711629600.json', 'v1/28_03_2024/response_sight_details_Viator_test_12_40_00_1711629600.json', 'v1/28_03_2024/response_header_sight_details_Viator_test_12_40_00_1711629600.json', 'viator', '2024-03-28 12:40:01', '', '', '673');
[03/28/2024 12:40:01], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/28_03_2024/request_sight_details_Viator_test_12_40_01_1711629601.json', 'v1/28_03_2024/response_sight_details_Viator_test_12_40_01_1711629601.json', 'v1/28_03_2024/response_header_sight_details_Viator_test_12_40_01_1711629601.json', 'viator', '2024-03-28 12:40:01', '', '', '673');
[03/28/2024 12:40:03], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:40:03' WHERE id= '705';
[03/28/2024 12:40: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/28_03_2024/request_check_availability_Viator_test_12_40_03_1711629603.json', 'v1/28_03_2024/response_check_availability_Viator_test_12_40_03_1711629603.json', 'v1/28_03_2024/response_header_check_availability_Viator_test_12_40_03_1711629603.json', 'viator', '2024-03-28 12:40:04', '', '', '673');
[03/28/2024 12:40:15], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:40:15' WHERE id= '705';
[03/28/2024 12:40: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/28_03_2024/request_sight_details_Viator_test_12_40_15_1711629615.json', 'v1/28_03_2024/response_sight_details_Viator_test_12_40_15_1711629615.json', 'v1/28_03_2024/response_header_sight_details_Viator_test_12_40_15_1711629615.json', 'viator', '2024-03-28 12:40:15', '', '', '673');
[03/28/2024 12:40:16], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/28_03_2024/request_sight_details_Viator_test_12_40_15_1711629615.json', 'v1/28_03_2024/response_sight_details_Viator_test_12_40_15_1711629615.json', 'v1/28_03_2024/response_header_sight_details_Viator_test_12_40_15_1711629615.json', 'viator', '2024-03-28 12:40:16', '', '', '673');
[03/28/2024 12:40:19], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:40:19' WHERE id= '705';
[03/28/2024 12:40:19], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'check_availability', 'v1/28_03_2024/request_check_availability_Viator_test_12_40_19_1711629619.json', 'v1/28_03_2024/response_check_availability_Viator_test_12_40_19_1711629619.json', 'v1/28_03_2024/response_header_check_availability_Viator_test_12_40_19_1711629619.json', 'viator', '2024-03-28 12:40:19', '', '', '673');
[03/28/2024 12:40:36], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:40:36' WHERE id= '705';
[03/28/2024 12:40: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/28_03_2024/request_sight_details_Viator_test_12_40_36_1711629636.json', 'v1/28_03_2024/response_sight_details_Viator_test_12_40_36_1711629636.json', 'v1/28_03_2024/response_header_sight_details_Viator_test_12_40_36_1711629636.json', 'viator', '2024-03-28 12:40:37', '', '', '673');
[03/28/2024 12:40: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/28_03_2024/request_sight_details_Viator_test_12_40_37_1711629637.json', 'v1/28_03_2024/response_sight_details_Viator_test_12_40_37_1711629637.json', 'v1/28_03_2024/response_header_sight_details_Viator_test_12_40_37_1711629637.json', 'viator', '2024-03-28 12:40:37', '', '', '673');
[03/28/2024 12:40:40], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:40:40' WHERE id= '705';
[03/28/2024 12:40: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/28_03_2024/request_check_availability_Viator_test_12_40_40_1711629640.json', 'v1/28_03_2024/response_check_availability_Viator_test_12_40_40_1711629640.json', 'v1/28_03_2024/response_header_check_availability_Viator_test_12_40_40_1711629640.json', 'viator', '2024-03-28 12:40:41', '', '', '673');
[03/28/2024 12:40:51], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:40:51' WHERE id= '705';
[03/28/2024 12:40: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 ('', 'sight_details', 'v1/28_03_2024/request_sight_details_Viator_test_12_40_51_1711629651.json', 'v1/28_03_2024/response_sight_details_Viator_test_12_40_51_1711629651.json', 'v1/28_03_2024/response_header_sight_details_Viator_test_12_40_51_1711629651.json', 'viator', '2024-03-28 12:40:51', '', '', '673');
[03/28/2024 12:40:52], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/28_03_2024/request_sight_details_Viator_test_12_40_52_1711629652.json', 'v1/28_03_2024/response_sight_details_Viator_test_12_40_52_1711629652.json', 'v1/28_03_2024/response_header_sight_details_Viator_test_12_40_52_1711629652.json', 'viator', '2024-03-28 12:40:52', '', '', '673');
[03/28/2024 12:40:55], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:40:55' WHERE id= '705';
[03/28/2024 12:40:55], [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/28_03_2024/request_check_availability_Viator_test_12_40_55_1711629655.json', 'v1/28_03_2024/response_check_availability_Viator_test_12_40_55_1711629655.json', 'v1/28_03_2024/response_header_check_availability_Viator_test_12_40_55_1711629655.json', 'viator', '2024-03-28 12:40:55', '', '', '673');
[03/28/2024 12:41:13], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:41:13' WHERE id= '705';
[03/28/2024 12:41:17], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:41:17' WHERE id= '705';
[03/28/2024 12:41: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/28_03_2024/request_sight_details_Viator_test_12_41_17_1711629677.json', 'v1/28_03_2024/response_sight_details_Viator_test_12_41_17_1711629677.json', 'v1/28_03_2024/response_header_sight_details_Viator_test_12_41_17_1711629677.json', 'viator', '2024-03-28 12:41:18', '', '', '673');
[03/28/2024 12:41: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/28_03_2024/request_sight_details_Viator_test_12_41_18_1711629678.json', 'v1/28_03_2024/response_sight_details_Viator_test_12_41_18_1711629678.json', 'v1/28_03_2024/response_header_sight_details_Viator_test_12_41_18_1711629678.json', 'viator', '2024-03-28 12:41:18', '', '', '673');
[03/28/2024 12:41:20], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:41:20' WHERE id= '705';
[03/28/2024 12:41: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 ('', 'check_availability', 'v1/28_03_2024/request_check_availability_Viator_test_12_41_20_1711629680.json', 'v1/28_03_2024/response_check_availability_Viator_test_12_41_20_1711629680.json', 'v1/28_03_2024/response_header_check_availability_Viator_test_12_41_20_1711629680.json', 'viator', '2024-03-28 12:41:21', '', '', '673');
[03/28/2024 12:41:26], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:41:26' WHERE id= '705';
[03/28/2024 12:41:27], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/28_03_2024/request_sight_details_Viator_test_12_41_27_1711629687.json', 'v1/28_03_2024/response_sight_details_Viator_test_12_41_27_1711629687.json', 'v1/28_03_2024/response_header_sight_details_Viator_test_12_41_27_1711629687.json', 'viator', '2024-03-28 12:41:27', '', '', '673');
[03/28/2024 12:41:28], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/28_03_2024/request_sight_details_Viator_test_12_41_27_1711629687.json', 'v1/28_03_2024/response_sight_details_Viator_test_12_41_27_1711629687.json', 'v1/28_03_2024/response_header_sight_details_Viator_test_12_41_27_1711629687.json', 'viator', '2024-03-28 12:41:28', '', '', '673');
[03/28/2024 12:41:38], [file name :-/home/otrams/public_html/beta/ajax_getsightlist.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:41:38' WHERE id= '705';
[03/28/2024 12:41:39], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:41:39' WHERE id= '705';
[03/28/2024 12:41:39], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:41:39' WHERE id= '705';
[03/28/2024 12:41:51], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:41:51' WHERE id= '705';
[03/28/2024 12:41:51], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:41:51' WHERE id= '705';
[03/28/2024 12:42:36], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_bookings set history_booking_id ='301', agent_id ='7863', itenirary_id ='7836835171571', confirmation_number ='7836835171571', payment_confirmation_no ='', voucher_id ='33', voucher_hashcode ='993828d8536a85f7e9238e514869385082138301', email_id ='', leader_title ='Mr', leader_first_name ='Sujay', leader_last_name ='Raut', city_id ='phuket', country_id ='136', display_room_rate ='250.000', native_room_rate ='200.000', native_currency_code ='USD', additional_charge ='0.000', cancellation_policy ='																														Free cancellation up to  19:58:59 on  2024-05-14&lt;br&gt;If you cancel between 2024-05-14 19:59:00 and 2024-05-16 00:00:00 , you will be charged 48.02 USD&lt;br&gt;No show is subject to a 100 % cancellation charge&lt;br&gt;&lt;br/&gt;&lt;b&gt;Amendment Policy&lt;/b&gt;&lt;br/&gt;
		Please note that most hotels treat changes in pax details, room category and dates as a cancellation of the booking, and charges will apply according to the cancellation policy.
		Late amendment charges may apply if requested after 19:59 on 14th of May 2024.
		Confirmation of amendments is subject to availability and rates at the time of making the amendment.
											
											
											
											
											', supplier_cancellation_policy ='', current_status ='vouchered', booking_status ='1', status_date ='2024-03-28 12:23:24', create_date ='2024-01-19 11:04:03', source_type ='expediapackage', expiration_date ='2024-05-14 16:59:00', comment_contract =' Bed Type Selection is not guaranteed.&lt;br/&gt;&lt;span style=\\&#039;color: red;\\&#039;&gt;&lt;strong&gt;Note&lt;/strong&gt;: Nightly rates might be calculated based on the average of Total Rate&lt;/span&gt;&lt;br&gt;&lt;br&gt;&lt;b&gt;Amenities:&lt;/b&gt;Free parking, Free WiFi&lt;br&gt;&lt;br&gt;&lt;b&gt;Deal:&lt;/b&gt; Book now and save,&lt;br&gt;&lt;br/&gt;&lt;br/&gt;&lt;br/&gt;&lt;b&gt;Checkin Start Time :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Checkin End Time :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Min Checkin Age :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Checkout Time :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Instructions :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Special Instructions :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Important Note :&lt;/b&gt; Agent agree that this rate is being sold with approved transport component.', admin_note ='', is_payment_gateway ='0', service_type ='hotel', service_type_detail ='', native_rate ='', display_rate ='', agent_rate ='250.000', wh_sub_agent_rate ='0.000', wh_agent_rate ='251.260', supplier_rate ='200.000', special_comment ='', special_remark ='', sms_status ='', is_xml ='0', consultant_id ='Ayman', admin_booked ='0', emailed_status ='0', applied_multiplier ='1.00000', applied_markup ='25', wh_applied_markup ='0.500', original_voucher ='', subagent_markup ='', agent_markup ='25', wh_agent_markup ='0.500', basecurrency_multiplier ='1.00000', wh_basecurrency_multiplier ='1.00000', basecurrency_multiplier_native ='1.00000', wh_basecurrency_multiplier_native ='1.00000', agent_currency_multiplier ='1.00000', wh_agent_currency_multiplier ='1.00000', modified_datetime ='2024-03-28 12:42:36', modified_by ='v3alpha', display_currency_code ='USD', created_datetime ='2024-03-28 12:42:36', sub_agent_rate ='0.000', created_by ='v3alpha', site_id ='20', applicable_service_tax ='0.000', wh_parent_agent_id ='7866', wh_agent_id ='7866', nationality ='Emirati', ip_addr ='43.239.53.130';
[03/28/2024 12:42:36], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_bookings_details  set  history_booking_detail_id ='166', old_reff_id ='78', booking_id ='301', supplier_id ='expediapack', total_nights ='1', arrival_date ='2024/05/16', departure_date ='2024/05/17', hotel_id ='2510986', hotel_name ='Phuketa Hotel', hotel_address1 ='24/5 Moo 6, Thepkrasatri Rd.', hotel_phone ='+6676241427', hotel_rating ='4.0', rate_code ='~', touricoRoomResId ='', gta_item_confirm_ref ='', channel_manager ='', reservation_pushed ='0', gtaToken ='';
[03/28/2024 12:42:36], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_passangers set history_passenger_id = '531', old_reff_id = '78', booking_id = '301', booking_detail_id = '166', salutations = 'Mr', room = '0', rid = '279', first_name = 'Sujay', last_name = 'Raut' ,passenger_type = 'adult' ,age = '';
[03/28/2024 12:42:36], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_passangers set history_passenger_id = '532', old_reff_id = '78', booking_id = '301', booking_detail_id = '166', salutations = 'Mr', room = '0', rid = '279', first_name = 'TBA', last_name = 'TBA' ,passenger_type = 'adult' ,age = '';
[03/28/2024 12:42:36], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],delete from passangers WHERE booking_id=?;
[03/28/2024 12:42:36], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO history_booking_room_detail set rid = '279', old_reff_id = '78', booking_id = '301', booking_detail_id = '166', room_type_code = '', room_name = 'single', room_type_description = 'FullBed Deluxe Front View (Double)(Room Only)- Package Deal (Book now and save)(1 Double Bed)', display_nightly_rates = 'a:1:{i:0;a:2:{s:18:"displayNightlyRate";s:3:"125";s:13:"whNightlyRate";s:6:"125.63";}}' ,native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";s:3:"100";}}' ,native_room_rate_total = '200' ,display_room_rate_total = '250' ,wh_room_rate_total = '' ,number_of_rooms = '2';
[03/28/2024 12:42:36], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],delete from booking_room_detail WHERE booking_id=?;
[03/28/2024 12:42:36], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],delete from passangers WHERE booking_id=?;
[03/28/2024 12:42:36], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO booking_room_detail set booking_id = '301', booking_detail_id = '166', room_type_code = '', room_name = 'single', room_type_description = 'FullBed Deluxe Front View (Double)(Room Only)- Package Deal (Book now and save)(1 Double Bed)', display_nightly_rates = 'a:1:{i:0;a:2:{s:18:"displayNightlyRate";s:3:"130";s:13:"whNightlyRate";s:6:"125.63";}}' ,native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";s:3:"100";}}' ,native_room_rate_total = '200' ,display_room_rate_total = '260' ,number_of_rooms = '2';
[03/28/2024 12:42:36], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO passangers set booking_id = '301', booking_detail_id = '166', salutations = 'Mr', room = '', rid = '280', first_name = 'Sujay', last_name = 'Raut' ,age = '';
[03/28/2024 12:42:36], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO passangers set booking_id = '301', booking_detail_id = '166', salutations = 'Mr', room = '', rid = '280', first_name = 'TBA', last_name = 'TBA' ,age = '';
[03/28/2024 12:42:36], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],UPDATE bookings SET confirmation_number='7836835171571',cancellation_policy='																																				Free cancellation up to  19:58:59 on  2024-05-14&lt;br&gt;If you cancel between 2024-05-14 19:59:00 and 2024-05-16 00:00:00 , you will be charged 48.02 USD&lt;br&gt;No show is subject to a 100 % cancellation charge&lt;br&gt;&lt;br/&gt;&lt;b&gt;Amendment Policy&lt;/b&gt;&lt;br/&gt;
		Please note that most hotels treat changes in pax details, room category and dates as a cancellation of the booking, and charges will apply according to the cancellation policy.
		Late amendment charges may apply if requested after 19:59 on 14th of May 2024.
		Confirmation of amendments is subject to availability and rates at the time of making the amendment.
											
											
											
											
											
											',supplier_cancellation_policy='',applied_multiplier='1.00000',applied_markup='30',agent_markup='30',consultant_id='v3alpha',basecurrency_multiplier='1.00000',basecurrency_multiplier_native='1.00000'_native,agent_currency_multiplier='1.00000',current_status='vouchered',status_date='2024-03-28 12:42:36',service_date='2024-05-16',check_out_date='2024-05-17',display_room_rate= '260',display_discount='0',modified_datetime='2024-03-28 12:42:36',modified_by ='v3alpha',native_room_rate='200',native_discount='0.000',additional_charge='0.000',applicable_service_tax='',leader_title='Mr',leader_first_name='Sujay',leader_last_name='Raut',nationality ='Emirati',booking_type ='online',supplier_profile_id ='43',expiration_date= '2024-05-14 16:59:00',source_type='expediapackage',special_comment='',admin_note='',comment_contract=' Bed Type Selection is not guaranteed.&lt;br/&gt;&lt;span style=\&#039;color: red;\&#039;&gt;&lt;strong&gt;Note&lt;/strong&gt;: Nightly rates might be calculated based on the average of Total Rate&lt;/span&gt;&lt;br&gt;&lt;br&gt;&lt;b&gt;Amenities:&lt;/b&gt;Free parking, Free WiFi&lt;br&gt;&lt;br&gt;&lt;b&gt;Deal:&lt;/b&gt; Book now and save,&lt;br&gt;&lt;br/&gt;&lt;br/&gt;&lt;br/&gt;&lt;b&gt;Checkin Start Time :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Checkin End Time :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Min Checkin Age :&lt;/b&gt; , &lt;br/&gt;&lt;b&gt;Checkout Time :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Instructions :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Special Instructions :&lt;/b&gt; ,&lt;br/&gt;&lt;b&gt;Important Note :&lt;/b&gt; Agent agree that this rate is being sold with approved transport component.' WHERE id='301';
[03/28/2024 12:42:36], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],update bookings set  parent_agent_id='7863', sub_agent_rate='', agent_rate='260', agent_markup='30', supplier_rate='200', wh_sub_agent_rate='', wh_agent_rate='251.26' where id='301';
[03/28/2024 12:42:36], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php], insert into booking_rate_info set  booking_id = '301', booking_log = 'Booking Modified', create_date = '2024-03-28 12:42:36', supplier_currency ='USD', type = 'Ammended', agent_price = '10', sub_agent_price ='', supplier_price = '', supplier_id = 'expediapackage', supplier_type = 'online';
[03/28/2024 12:42:36], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php], insert into booking_rate_info set  booking_id = '301', booking_log = 'Booking Modified', create_date = '2024-03-28 12:42:36', supplier_currency ='USD', type = 'Ammended', agent_price = '', sub_agent_price ='', supplier_price = '', supplier_id = 'expediapack', supplier_type = 'online';
[03/28/2024 12:42:36], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php], insert into booking_rate_info set  booking_id = '301', booking_log = 'Booking Modified', create_date = '2024-03-28 12:42:36', supplier_currency ='USD', type = 'Ammended', agent_price = '', sub_agent_price ='', supplier_price = '200.000', supplier_id = 'expediapackage', supplier_type = 'online';
[03/28/2024 12:42:36], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php], update wh_booking_rate_info set  booking_id = '301', booking_log = 'Booking Modified', create_date = '2024-03-28 12:42:36', agent_price = '251.260', sub_agent_price = '0.000', supplier_price = '260.000' where booking_id = '301'  and type = "Sale";
[03/28/2024 12:42:36], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],UPDATE agents SET credit_usage=credit_usage+('10'),   credit_value= credit_value-('10') ,  cd_credit_usage=cd_credit_usage+('10') , cd_credit_value=cd_credit_value-('10')  WHERE id = '7863';
[03/28/2024 12:42:36], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],insert into  agent_credit_log SET agent_id= '7863',credit_value= '999998464.300',credit_usage= '535.700',credit_limit= '999999000.000',receipt_id= '',amount= '10',booking_id='301',booking_cost= '260',receipt_allocation= '',balance= '260',ip='43.239.53.130',user_type='admin',admin_id='v3alpha',temp_credit_limit='',log_type='Booking Modified',note='Booking Modified',create_date='2024-03-28 12:03:36';
[03/28/2024 12:42:36], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.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 = '7866';
[03/28/2024 12:42:36], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],insert into  agent_credit_log SET agent_id= '7866',credit_value= '-192.940',credit_usage= '192.940',credit_limit= '0.000',receipt_id= '',amount= '',booking_id='301',booking_cost= '260',receipt_allocation= '',balance= '260',ip='43.239.53.130',user_type='admin',admin_id='v3alpha',temp_credit_limit='',log_type='Booking Modified',note='Booking Modified',create_date='2024-03-28 12:03:36';
[03/28/2024 12:42:36], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],delete from  agent_commission   WHERE booking_id='301';
[03/28/2024 12:42:36], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO agent_commission SET booking_id ='301',booking_detail_id ='301',agent_id ='7863',is_sub_agent ='N',parent_id ='',display_commission ='60',display_currency ='USD',paid ='N',type ='hotel',description ='Agent Mark Up Percentage is 30 %',create_date ='2024-03-28 12:42:36';
[03/28/2024 12:42:36], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],update bookings_details set total_nights='1' , supplier_id= 'expediapackage' , total_rooms= '2', arrival_date='2024/05/16', departure_date='2024/05/17', rate_code='~', hotel_address1='24/5 Moo 6, Thepkrasatri Rd.', hotel_name='Phuketa Hotel', hotel_phone='+6676241427' where booking_id ='301';
[03/28/2024 12:42:36], [file name :-/home/otrams/public_html/beta/tms/bookings_modification.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
		('','','301','vouchered','2024-03-28 12:42:36','Booking Modified by v3alpha','v3alpha','43.239.53.130','v3alpha','','');
[03/28/2024 12:43:22], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:43:22' WHERE id= '705';
[03/28/2024 12:43:22], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:43:22' WHERE id= '705';
[03/28/2024 12:48:08], [file name :-/home/otrams/public_html/beta/ajax_getsightlist.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:48:08' WHERE id= '705';
[03/28/2024 12:48:08], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:48:08' WHERE id= '705';
[03/28/2024 12:48:08], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:48:08' WHERE id= '705';
[03/28/2024 12:48:10], [file name :-/home/otrams/public_html/beta/ajax_getsightlist.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:48:10' WHERE id= '705';
[03/28/2024 12:48:11], [file name :-/home/otrams/public_html/beta/ajax_getsightlist.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:48:11' WHERE id= '705';
[03/28/2024 12:48:12], [file name :-/home/otrams/public_html/beta/ajax_getsightlist.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:48:12' WHERE id= '705';
[03/28/2024 12:48:12], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:48:12' WHERE id= '705';
[03/28/2024 12:48:13], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:48:13' WHERE id= '705';
[03/28/2024 12:48:22], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:48:22' WHERE id= '705';
[03/28/2024 12:48: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/28_03_2024/request_sight_details_Viator_test_12_48_22_1711630102.json', 'v1/28_03_2024/response_sight_details_Viator_test_12_48_22_1711630102.json', 'v1/28_03_2024/response_header_sight_details_Viator_test_12_48_22_1711630102.json', 'viator', '2024-03-28 12:48:22', '', '', '673');
[03/28/2024 12:48: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/28_03_2024/request_sight_details_Viator_test_12_48_22_1711630102.json', 'v1/28_03_2024/response_sight_details_Viator_test_12_48_22_1711630102.json', 'v1/28_03_2024/response_header_sight_details_Viator_test_12_48_22_1711630102.json', 'viator', '2024-03-28 12:48:23', '', '', '673');
[03/28/2024 12:48:25], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:48:25' WHERE id= '705';
[03/28/2024 12: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/28_03_2024/request_check_availability_Viator_test_12_48_25_1711630105.json', 'v1/28_03_2024/response_check_availability_Viator_test_12_48_25_1711630105.json', 'v1/28_03_2024/response_header_check_availability_Viator_test_12_48_25_1711630105.json', 'viator', '2024-03-28 12:48:25', '', '', '673');
[03/28/2024 12:48:32], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:48:32' WHERE id= '705';
[03/28/2024 12:48:32], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/28_03_2024/request_sight_details_Viator_test_12_48_32_1711630112.json', 'v1/28_03_2024/response_sight_details_Viator_test_12_48_32_1711630112.json', 'v1/28_03_2024/response_header_sight_details_Viator_test_12_48_32_1711630112.json', 'viator', '2024-03-28 12:48:32', '', '', '673');
[03/28/2024 12:48:32], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/28_03_2024/request_sight_details_Viator_test_12_48_32_1711630112.json', 'v1/28_03_2024/response_sight_details_Viator_test_12_48_32_1711630112.json', 'v1/28_03_2024/response_header_sight_details_Viator_test_12_48_32_1711630112.json', 'viator', '2024-03-28 12:48:32', '', '', '673');
[03/28/2024 12:48:35], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:48:35' WHERE id= '705';
[03/28/2024 12:48:35], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'check_availability', 'v1/28_03_2024/request_check_availability_Viator_test_12_48_35_1711630115.json', 'v1/28_03_2024/response_check_availability_Viator_test_12_48_35_1711630115.json', 'v1/28_03_2024/response_header_check_availability_Viator_test_12_48_35_1711630115.json', 'viator', '2024-03-28 12:48:35', '', '', '673');
[03/28/2024 12:48:54], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:48:54' WHERE id= '705';
[03/28/2024 12:48:55], [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/28_03_2024/request_sight_details_Viator_test_12_48_55_1711630135.json', 'v1/28_03_2024/response_sight_details_Viator_test_12_48_55_1711630135.json', 'v1/28_03_2024/response_header_sight_details_Viator_test_12_48_55_1711630135.json', 'viator', '2024-03-28 12:48:55', '', '', '673');
[03/28/2024 12:48:55], [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/28_03_2024/request_sight_details_Viator_test_12_48_55_1711630135.json', 'v1/28_03_2024/response_sight_details_Viator_test_12_48_55_1711630135.json', 'v1/28_03_2024/response_header_sight_details_Viator_test_12_48_55_1711630135.json', 'viator', '2024-03-28 12:48:55', '', '', '673');
[03/28/2024 12:55:05], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:55:05' WHERE id= '705';
[03/28/2024 12:55: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 ('', 'check_availability', 'v1/28_03_2024/request_check_availability_Viator_test_12_55_05_1711630505.json', 'v1/28_03_2024/response_check_availability_Viator_test_12_55_05_1711630505.json', 'v1/28_03_2024/response_header_check_availability_Viator_test_12_55_05_1711630505.json', 'viator', '2024-03-28 12:55:06', '', '', '673');
[03/28/2024 12:55:14], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:55:14' WHERE id= '705';
[03/28/2024 12:55: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/28_03_2024/request_sight_details_Viator_test_12_55_14_1711630514.json', 'v1/28_03_2024/response_sight_details_Viator_test_12_55_14_1711630514.json', 'v1/28_03_2024/response_header_sight_details_Viator_test_12_55_14_1711630514.json', 'viator', '2024-03-28 12:55:15', '', '', '673');
[03/28/2024 12:55: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/28_03_2024/request_sight_details_Viator_test_12_55_15_1711630515.json', 'v1/28_03_2024/response_sight_details_Viator_test_12_55_15_1711630515.json', 'v1/28_03_2024/response_header_sight_details_Viator_test_12_55_15_1711630515.json', 'viator', '2024-03-28 12:55:15', '', '', '673');
[03/28/2024 12:55:17], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-03-28 12:55:17' WHERE id= '705';
[03/28/2024 12:55: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/28_03_2024/request_check_availability_Viator_test_12_55_17_1711630517.json', 'v1/28_03_2024/response_check_availability_Viator_test_12_55_17_1711630517.json', 'v1/28_03_2024/response_header_check_availability_Viator_test_12_55_17_1711630517.json', 'viator', '2024-03-28 12:55:18', '', '', '673');
