[02/16/2024 10:00:43], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-02-16 10:00:43',login_attempt=0 where id = '7849';
[02/16/2024 10:00:43], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'shiv_qtech', user_type = 'A', branch_id = '24', login_datetime = '2024-02-16 10:00:43', ip = '43.239.53.130', action = 'Login' ;
[02/16/2024 10:00:43], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 10:00:43' WHERE id= '541';
[02/16/2024 10:00:58], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 10:00:58' WHERE id= '541';
[02/16/2024 10:01:02], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 10:01:02' WHERE id= '541';
[02/16/2024 10:01:05], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 10:01:05' WHERE id= '541';
[02/16/2024 10:01:10], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 10:01:10' WHERE id= '541';
[02/16/2024 10:01:10], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7849' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '24' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/02/29',  departure_date='2024/02/29',  nights='1',  create_date='2024-02-16 :10:01:10',  nationality='',  additional_markup='',  selected_currency='INR',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[02/16/2024 10:01:11], [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/16_02_2024/request_availability_shiv_qtech_10_01_10_1708077670.json', 'v1/16_02_2024/response_availability_shiv_qtech_10_01_10_1708077670.json', 'v1/16_02_2024/response_header_availability_shiv_qtech_10_01_10_1708077670.json', 'viator', '2024-02-16 10:01:11', '', '', '1635');
[02/16/2024 10:01:11], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 10:01:11' WHERE id= '541';
[02/16/2024 10:01:22], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 10:01:22' WHERE id= '541';
[02/16/2024 10:01:24], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 10:01:24' WHERE id= '541';
[02/16/2024 10:01:24], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 10:01:24' WHERE id= '541';
[02/16/2024 10:01:32], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 10:01:32' WHERE id= '541';
[02/16/2024 10:01:35], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 10:01:35' WHERE id= '541';
[02/16/2024 10:01:35], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7849' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '24' , ip = '43.239.53.130' , city = 'lucca' , arrival_date='2024/02/29',  departure_date='2024/02/29',  nights='1',  create_date='2024-02-16 :10:01:35',  nationality='',  additional_markup='',  selected_currency='INR',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[02/16/2024 10:01:38], [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/16_02_2024/request_availability_shiv_qtech_10_01_35_1708077695.json', 'v1/16_02_2024/response_availability_shiv_qtech_10_01_35_1708077695.json', 'v1/16_02_2024/response_header_availability_shiv_qtech_10_01_35_1708077695.json', 'viator', '2024-02-16 10:01:38', '', '', '1636');
[02/16/2024 10:01:40], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 10:01:40' WHERE id= '541';
[02/16/2024 10:01:40], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 10:01:40' WHERE id= '541';
[02/16/2024 10:01:47], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 10:01:47' WHERE id= '541';
[02/16/2024 10:01:47], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 10:01:47' WHERE id= '541';
[02/16/2024 10:01:52], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 10:01:52' WHERE id= '541';
[02/16/2024 10:01:52], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 10:01:52' WHERE id= '541';
[02/16/2024 10:16:48], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 10:16:48' WHERE id= '541';
[02/16/2024 10:16:50], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 10:16:50' WHERE id= '541';
[02/16/2024 10:16:54], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 10:16:54' WHERE id= '541';
[02/16/2024 10:16:59], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 10:16:59' WHERE id= '541';
[02/16/2024 10:16:59], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 10:16:59' WHERE id= '541';
[02/16/2024 10:17:01], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 10:17:01' WHERE id= '541';
[02/16/2024 10:17:02], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 10:17:02' WHERE id= '541';
[02/16/2024 10:17:12], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 10:17:12' WHERE id= '541';
[02/16/2024 10:17:12], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7849' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '24' , ip = '43.239.53.130' , city = 'lucca' , arrival_date='2024/02/29',  departure_date='2024/02/29',  nights='1',  create_date='2024-02-16 :10:17:12',  nationality='',  additional_markup='',  selected_currency='INR',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[02/16/2024 10:17:35], [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/16_02_2024/request_availability_shiv_qtech_10_17_12_1708078632.json', 'v1/16_02_2024/response_availability_shiv_qtech_10_17_12_1708078632.json', 'v1/16_02_2024/response_header_availability_shiv_qtech_10_17_12_1708078632.json', 'viator', '2024-02-16 10:17:35', '', '', '1637');
[02/16/2024 10:17:36], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 10:17:36' WHERE id= '541';
[02/16/2024 10:17:36], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 10:17:36' WHERE id= '541';
[02/16/2024 10:18:18], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 10:18:18' WHERE id= '541';
[02/16/2024 10:18:19], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/16_02_2024/request_sight_details_shiv_qtech_10_18_18_1708078698.json', 'v1/16_02_2024/response_sight_details_shiv_qtech_10_18_18_1708078698.json', 'v1/16_02_2024/response_header_sight_details_shiv_qtech_10_18_18_1708078698.json', 'viator', '2024-02-16 10:18:19', '', '', '1637');
[02/16/2024 10:18:19], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/16_02_2024/request_sight_details_shiv_qtech_10_18_19_1708078699.json', 'v1/16_02_2024/response_sight_details_shiv_qtech_10_18_19_1708078699.json', 'v1/16_02_2024/response_header_sight_details_shiv_qtech_10_18_19_1708078699.json', 'viator', '2024-02-16 10:18:19', '', '', '1637');
[02/16/2024 10:18:29], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 10:18:29' WHERE id= '541';
[02/16/2024 10:18: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/16_02_2024/request_check_availability_shiv_qtech_10_18_29_1708078709.json', 'v1/16_02_2024/response_check_availability_shiv_qtech_10_18_29_1708078709.json', 'v1/16_02_2024/response_header_check_availability_shiv_qtech_10_18_29_1708078709.json', 'viator', '2024-02-16 10:18:29', '', '', '1637');
[02/16/2024 10:18:33], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 10:18:33' WHERE id= '541';
[02/16/2024 10:18: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/16_02_2024/request_sight_details_shiv_qtech_10_18_33_1708078713.json', 'v1/16_02_2024/response_sight_details_shiv_qtech_10_18_33_1708078713.json', 'v1/16_02_2024/response_header_sight_details_shiv_qtech_10_18_33_1708078713.json', 'viator', '2024-02-16 10:18:33', '', '', '1637');
[02/16/2024 10:18: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/16_02_2024/request_sight_details_shiv_qtech_10_18_34_1708078714.json', 'v1/16_02_2024/response_sight_details_shiv_qtech_10_18_34_1708078714.json', 'v1/16_02_2024/response_header_sight_details_shiv_qtech_10_18_34_1708078714.json', 'viator', '2024-02-16 10:18:34', '', '', '1637');
[02/16/2024 10:38:27], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-02-16 10:38:27',login_attempt=0 where id = '7851';
[02/16/2024 10:38:27], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Viator_test', user_type = 'A', branch_id = '27', login_datetime = '2024-02-16 10:38:27', ip = '43.239.53.130', action = 'Login' ;
[02/16/2024 10:38:28], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 10:38:28' WHERE id= '562';
[02/16/2024 10:38:31], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 10:38:31' WHERE id= '562';
[02/16/2024 10:38:38], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 10:38:38' WHERE id= '562';
[02/16/2024 10:38:44], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 10:38:44' WHERE id= '562';
[02/16/2024 10:38:44], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7851' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '27' , ip = '43.239.53.130' , city = 'lucca' , arrival_date='2024/03/28',  departure_date='2024/03/28',  nights='1',  create_date='2024-02-16 :10:38:44',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[02/16/2024 10:38: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/16_02_2024/request_availability_Viator_test_10_38_44_1708079924.json', 'v1/16_02_2024/response_availability_Viator_test_10_38_44_1708079924.json', 'v1/16_02_2024/response_header_availability_Viator_test_10_38_44_1708079924.json', 'viator', '2024-02-16 10:38:45', '', '', '1638');
[02/16/2024 10:38:46], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 10:38:46' WHERE id= '562';
[02/16/2024 10:38:47], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 10:38:47' WHERE id= '562';
[02/16/2024 10:38:50], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 10:38:50' WHERE id= '562';
[02/16/2024 10:38: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/16_02_2024/request_sight_details_Viator_test_10_38_50_1708079930.json', 'v1/16_02_2024/response_sight_details_Viator_test_10_38_50_1708079930.json', 'v1/16_02_2024/response_header_sight_details_Viator_test_10_38_50_1708079930.json', 'viator', '2024-02-16 10:38:51', '', '', '1638');
[02/16/2024 10:38:52], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/16_02_2024/request_sight_details_Viator_test_10_38_51_1708079931.json', 'v1/16_02_2024/response_sight_details_Viator_test_10_38_51_1708079931.json', 'v1/16_02_2024/response_header_sight_details_Viator_test_10_38_51_1708079931.json', 'viator', '2024-02-16 10:38:52', '', '', '1638');
[02/16/2024 10:38:56], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 10:38:56' WHERE id= '562';
[02/16/2024 10:38: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/16_02_2024/request_check_availability_Viator_test_10_38_56_1708079936.json', 'v1/16_02_2024/response_check_availability_Viator_test_10_38_56_1708079936.json', 'v1/16_02_2024/response_header_check_availability_Viator_test_10_38_56_1708079936.json', 'viator', '2024-02-16 10:38:57', '', '', '1638');
[02/16/2024 10:38:59], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 10:38:59' WHERE id= '562';
[02/16/2024 10:38:59], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1708079939','43.239.53.130');
[02/16/2024 10:40:07], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 10:40:07' WHERE id= '562';
[02/16/2024 10:40:07], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1708080007','43.239.53.130');
[02/16/2024 10:40:27], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 10:40:27' WHERE id= '562';
[02/16/2024 10:40:29], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 10:40:29' WHERE id= '562';
[02/16/2024 10:40:42], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 10:40:42' WHERE id= '562';
[02/16/2024 10:40:45], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 10:40:45' WHERE id= '562';
[02/16/2024 10:41:09], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 10:41:09' WHERE id= '562';
[02/16/2024 10:41:09], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1708080069','43.239.53.130');
[02/16/2024 10:41:10], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 10:41:10' WHERE id= '562';
[02/16/2024 10:41:10], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO bookings set reservation_id='2838',agent_id='7851',leader_title='Mr',leader_first_name='shiv',leader_last_name='chauhan',city_id='lucca',country_id='68',nationality='Italian',display_room_rate='95.51',display_currency_code='USD',native_room_rate='70.14',consultant_id='SUJAY_QTECH',native_currency_code='EUR',cancellation_policy='Cancellation Charges will be applicable if cancelled after 26 Mar 2024 03:00 hrs.<BR>Late amendment charge may apply.<Br><Br><B><U>Detailed Cancellation Policy:</U></B><Br>Charges - 95.51  applicable if cancelled after 26 Mar 2024 at 03:00 hrs',current_status='inprocess-booking',booking_status='1',sales_manager_id='0',create_date='2024-02-16 10:41:10',source_type='viator',expiration_date= '2024-03-26 00:00:00',applied_multiplier='1.36177',applied_markup='0',agent_markup='0',basecurrency_multiplier='1.00000',basecurrency_multiplier_native='1.36177',admin_booked='0',service_date='2024-03-28',sub_user_id='',check_out_date='2024-03-28',supplier_profile_id='',agent_currency_multiplier='3.7507', booking_branch_id = '27',site_url = 'https://beta.astrabookings.com/',ip_addr='43.239.53.130',leader_phone=' 9823860012',email_id='shiv.chauhan@qtechsoftware.com',service_type='sightseeing';
[02/16/2024 10:41:10], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO sight_bookings set booking_id='422',native_nightly_rates='a:2:{s:4:\"size\";i:1;s:17:\"nativeNightlyRate\";d:70.140000000000001;}',rate_description='',display_nightly_rates='a:4:{s:4:\"size\";i:1;s:18:\"displayNightlyRate\";d:95.510000000000005;s:25:\"displayNightlyRateDisplay\";s:133:\"Rate - 70.14 EUR, Currency Multiplier (EUR-USD) - 1.36177, Markup  in % - %, Markup Amount - , Markup Amount in  - ,Other Markup - 0%\";s:23:\"displayNightlyRateStore\";s:134:\"Rate - 70.14 EUR, Currency Multiplier (EUR-USD) - 1.36177, Markup  in % - %, Markup Amount - , Markup Amount in  -  ,Other Markup - 0%\";}',display_currency_code='USD',native_currency_code='EUR',sight_id='87299P10',sight_name='E-BIKE RENTAL IN LUCCA- V2',tour_time='',tour_details='',tour_inclusive='B<br/>',tour_exclusive='<br/>',meeting_point='',tour_dep_point=' ',tour_language='',tour_supplier_phone='',additional_tour_dep_point='',tour_duration='9 hours 0 minutes<br> Start Time: 10:00',arrival_date='2024-03-28',total_adults='2',total_children='',total_infants='',gta_city_code='22436',supplier_id='',pick_up_point='',drop_off_point='',from_slot='',to_slot='',total_adult_rate='',total_child_rate='',adult_rate='',child_rate='',display_total_adult_rate='',display_total_child_rate='',display_adult_rate='',display_child_rate='0',additional_service_rate='0',booking_remark='',emergency_cont_no='',terms_n_condition='';
[02/16/2024 10:41:10], [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','2838','2024-02-16 10:41:10',0);
[02/16/2024 10:42:19], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 10:42:19' WHERE id= '562';
[02/16/2024 10:42:19], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO bookings set reservation_id='2838',agent_id='7851',leader_title='Mr',leader_first_name='shiv',leader_last_name='chauhan',city_id='lucca',country_id='68',nationality='Italian',display_room_rate='95.51',display_currency_code='USD',native_room_rate='70.14',consultant_id='SUJAY_QTECH',native_currency_code='EUR',cancellation_policy='Cancellation Charges will be applicable if cancelled after 26 Mar 2024 03:00 hrs.<BR>Late amendment charge may apply.<Br><Br><B><U>Detailed Cancellation Policy:</U></B><Br>Charges - 95.51  applicable if cancelled after 26 Mar 2024 at 03:00 hrs',current_status='inprocess-booking',booking_status='1',sales_manager_id='0',create_date='2024-02-16 10:42:19',source_type='viator',expiration_date= '2024-03-26 00:00:00',applied_multiplier='1.36177',applied_markup='0',agent_markup='0',basecurrency_multiplier='1.00000',basecurrency_multiplier_native='1.36177',admin_booked='0',service_date='2024-03-28',sub_user_id='',check_out_date='2024-03-28',supplier_profile_id='',agent_currency_multiplier='3.7507', booking_branch_id = '27',site_url = 'https://beta.astrabookings.com/',ip_addr='43.239.53.130',leader_phone=' 9823860012',email_id='shiv.chauhan@qtechsoftware.com',service_type='sightseeing';
[02/16/2024 10:42:19], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO sight_bookings set booking_id='423',native_nightly_rates='a:2:{s:4:\"size\";i:1;s:17:\"nativeNightlyRate\";d:70.140000000000001;}',rate_description='',display_nightly_rates='a:4:{s:4:\"size\";i:1;s:18:\"displayNightlyRate\";d:95.510000000000005;s:25:\"displayNightlyRateDisplay\";s:133:\"Rate - 70.14 EUR, Currency Multiplier (EUR-USD) - 1.36177, Markup  in % - %, Markup Amount - , Markup Amount in  - ,Other Markup - 0%\";s:23:\"displayNightlyRateStore\";s:134:\"Rate - 70.14 EUR, Currency Multiplier (EUR-USD) - 1.36177, Markup  in % - %, Markup Amount - , Markup Amount in  -  ,Other Markup - 0%\";}',display_currency_code='USD',native_currency_code='EUR',sight_id='87299P10',sight_name='E-BIKE RENTAL IN LUCCA- V2',tour_time='',tour_details='',tour_inclusive='B<br/>',tour_exclusive='<br/>',meeting_point='',tour_dep_point=' ',tour_language='',tour_supplier_phone='',additional_tour_dep_point='',tour_duration='9 hours 0 minutes<br> Start Time: 10:00',arrival_date='2024-03-28',total_adults='2',total_children='',total_infants='',gta_city_code='22436',supplier_id='',pick_up_point='',drop_off_point='',from_slot='',to_slot='',total_adult_rate='',total_child_rate='',adult_rate='',child_rate='',display_total_adult_rate='',display_total_child_rate='',display_adult_rate='',display_child_rate='0',additional_service_rate='0',booking_remark='',emergency_cont_no='',terms_n_condition='';
[02/16/2024 10:42:19], [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','2838','2024-02-16 10:42:19',0);
[02/16/2024 10:49:15], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 10:49:15' WHERE id= '562';
[02/16/2024 10:49:15], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO bookings set reservation_id='2838',agent_id='7851',leader_title='Mr',leader_first_name='shiv',leader_last_name='chauhan',city_id='lucca',country_id='68',nationality='Italian',display_room_rate='95.51',display_currency_code='USD',native_room_rate='70.14',consultant_id='SUJAY_QTECH',native_currency_code='EUR',cancellation_policy='Cancellation Charges will be applicable if cancelled after 26 Mar 2024 03:00 hrs.<BR>Late amendment charge may apply.<Br><Br><B><U>Detailed Cancellation Policy:</U></B><Br>Charges - 95.51  applicable if cancelled after 26 Mar 2024 at 03:00 hrs',current_status='inprocess-booking',booking_status='1',sales_manager_id='0',create_date='2024-02-16 10:49:15',source_type='viator',expiration_date= '2024-03-26 00:00:00',applied_multiplier='1.36177',applied_markup='0',agent_markup='0',basecurrency_multiplier='1.00000',basecurrency_multiplier_native='1.36177',admin_booked='0',service_date='2024-03-28',sub_user_id='',check_out_date='2024-03-28',supplier_profile_id='',agent_currency_multiplier='3.7507', booking_branch_id = '27',site_url = 'https://beta.astrabookings.com/',ip_addr='43.239.53.130',leader_phone=' 9823860012',email_id='shiv.chauhan@qtechsoftware.com',service_type='sightseeing';
[02/16/2024 10:49:15], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO sight_bookings set booking_id='424',native_nightly_rates='a:2:{s:4:\"size\";i:1;s:17:\"nativeNightlyRate\";d:70.140000000000001;}',rate_description='',display_nightly_rates='a:4:{s:4:\"size\";i:1;s:18:\"displayNightlyRate\";d:95.510000000000005;s:25:\"displayNightlyRateDisplay\";s:133:\"Rate - 70.14 EUR, Currency Multiplier (EUR-USD) - 1.36177, Markup  in % - %, Markup Amount - , Markup Amount in  - ,Other Markup - 0%\";s:23:\"displayNightlyRateStore\";s:134:\"Rate - 70.14 EUR, Currency Multiplier (EUR-USD) - 1.36177, Markup  in % - %, Markup Amount - , Markup Amount in  -  ,Other Markup - 0%\";}',display_currency_code='USD',native_currency_code='EUR',sight_id='87299P10',sight_name='E-BIKE RENTAL IN LUCCA- V2',tour_time='',tour_details='',tour_inclusive='B<br/>',tour_exclusive='<br/>',meeting_point='',tour_dep_point=' ',tour_language='',tour_supplier_phone='',additional_tour_dep_point='',tour_duration='9 hours 0 minutes<br> Start Time: 10:00',arrival_date='2024-03-28',total_adults='2',total_children='',total_infants='',gta_city_code='22436',supplier_id='',pick_up_point='',drop_off_point='',from_slot='',to_slot='',total_adult_rate='',total_child_rate='',adult_rate='',child_rate='',display_total_adult_rate='',display_total_child_rate='',display_adult_rate='',display_child_rate='0',additional_service_rate='0',booking_remark='',emergency_cont_no='',terms_n_condition='';
[02/16/2024 10:49:15], [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','2838','2024-02-16 10:49:15',0);
[02/16/2024 10:54:15], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 10:54:15' WHERE id= '562';
[02/16/2024 10:54:15], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO bookings set reservation_id='2838',agent_id='7851',leader_title='Mr',leader_first_name='shiv',leader_last_name='chauhan',city_id='lucca',country_id='68',nationality='Italian',display_room_rate='95.51',display_currency_code='USD',native_room_rate='70.14',consultant_id='SUJAY_QTECH',native_currency_code='EUR',cancellation_policy='Cancellation Charges will be applicable if cancelled after 26 Mar 2024 03:00 hrs.<BR>Late amendment charge may apply.<Br><Br><B><U>Detailed Cancellation Policy:</U></B><Br>Charges - 95.51  applicable if cancelled after 26 Mar 2024 at 03:00 hrs',current_status='inprocess-booking',booking_status='1',sales_manager_id='0',create_date='2024-02-16 10:54:15',source_type='viator',expiration_date= '2024-03-26 00:00:00',applied_multiplier='1.36177',applied_markup='0',agent_markup='0',basecurrency_multiplier='1.00000',basecurrency_multiplier_native='1.36177',admin_booked='0',service_date='2024-03-28',sub_user_id='',check_out_date='2024-03-28',supplier_profile_id='',agent_currency_multiplier='3.7507', booking_branch_id = '27',site_url = 'https://beta.astrabookings.com/',ip_addr='43.239.53.130',leader_phone=' 9823860012',email_id='shiv.chauhan@qtechsoftware.com',service_type='sightseeing';
[02/16/2024 10:54:15], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO sight_bookings set booking_id='425',native_nightly_rates='a:2:{s:4:\"size\";i:1;s:17:\"nativeNightlyRate\";d:70.140000000000001;}',rate_description='',display_nightly_rates='a:4:{s:4:\"size\";i:1;s:18:\"displayNightlyRate\";d:95.510000000000005;s:25:\"displayNightlyRateDisplay\";s:133:\"Rate - 70.14 EUR, Currency Multiplier (EUR-USD) - 1.36177, Markup  in % - %, Markup Amount - , Markup Amount in  - ,Other Markup - 0%\";s:23:\"displayNightlyRateStore\";s:134:\"Rate - 70.14 EUR, Currency Multiplier (EUR-USD) - 1.36177, Markup  in % - %, Markup Amount - , Markup Amount in  -  ,Other Markup - 0%\";}',display_currency_code='USD',native_currency_code='EUR',sight_id='87299P10',sight_name='E-BIKE RENTAL IN LUCCA- V2',tour_time='',tour_details='',tour_inclusive='B<br/>',tour_exclusive='<br/>',meeting_point='',tour_dep_point=' ',tour_language='',tour_supplier_phone='',additional_tour_dep_point='',tour_duration='9 hours 0 minutes<br> Start Time: 10:00',arrival_date='2024-03-28',total_adults='2',total_children='',total_infants='',gta_city_code='22436',supplier_id='',pick_up_point='',drop_off_point='',from_slot='',to_slot='',total_adult_rate='',total_child_rate='',adult_rate='',child_rate='',display_total_adult_rate='',display_total_child_rate='',display_adult_rate='',display_child_rate='0',additional_service_rate='0',booking_remark='',emergency_cont_no='',terms_n_condition='';
[02/16/2024 10:54:15], [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','2838','2024-02-16 10:54:15',0);
[02/16/2024 10:54:39], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 10:54:39' WHERE id= '562';
[02/16/2024 10:54:39], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO bookings set reservation_id='2838',agent_id='7851',leader_title='Mr',leader_first_name='shiv',leader_last_name='chauhan',city_id='lucca',country_id='68',nationality='Italian',display_room_rate='95.51',display_currency_code='USD',native_room_rate='70.14',consultant_id='SUJAY_QTECH',native_currency_code='EUR',cancellation_policy='Cancellation Charges will be applicable if cancelled after 26 Mar 2024 03:00 hrs.<BR>Late amendment charge may apply.<Br><Br><B><U>Detailed Cancellation Policy:</U></B><Br>Charges - 95.51  applicable if cancelled after 26 Mar 2024 at 03:00 hrs',current_status='inprocess-booking',booking_status='1',sales_manager_id='0',create_date='2024-02-16 10:54:39',source_type='viator',expiration_date= '2024-03-26 00:00:00',applied_multiplier='1.36177',applied_markup='0',agent_markup='0',basecurrency_multiplier='1.00000',basecurrency_multiplier_native='1.36177',admin_booked='0',service_date='2024-03-28',sub_user_id='',check_out_date='2024-03-28',supplier_profile_id='',agent_currency_multiplier='3.7507', booking_branch_id = '27',site_url = 'https://beta.astrabookings.com/',ip_addr='43.239.53.130',leader_phone=' 9823860012',email_id='shiv.chauhan@qtechsoftware.com',service_type='sightseeing';
[02/16/2024 10:54:39], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO sight_bookings set booking_id='426',native_nightly_rates='a:2:{s:4:\"size\";i:1;s:17:\"nativeNightlyRate\";d:70.140000000000001;}',rate_description='',display_nightly_rates='a:4:{s:4:\"size\";i:1;s:18:\"displayNightlyRate\";d:95.510000000000005;s:25:\"displayNightlyRateDisplay\";s:133:\"Rate - 70.14 EUR, Currency Multiplier (EUR-USD) - 1.36177, Markup  in % - %, Markup Amount - , Markup Amount in  - ,Other Markup - 0%\";s:23:\"displayNightlyRateStore\";s:134:\"Rate - 70.14 EUR, Currency Multiplier (EUR-USD) - 1.36177, Markup  in % - %, Markup Amount - , Markup Amount in  -  ,Other Markup - 0%\";}',display_currency_code='USD',native_currency_code='EUR',sight_id='87299P10',sight_name='E-BIKE RENTAL IN LUCCA- V2',tour_time='',tour_details='',tour_inclusive='B<br/>',tour_exclusive='<br/>',meeting_point='',tour_dep_point=' ',tour_language='',tour_supplier_phone='',additional_tour_dep_point='',tour_duration='9 hours 0 minutes<br> Start Time: 10:00',arrival_date='2024-03-28',total_adults='2',total_children='',total_infants='',gta_city_code='22436',supplier_id='',pick_up_point='',drop_off_point='',from_slot='',to_slot='',total_adult_rate='',total_child_rate='',adult_rate='',child_rate='',display_total_adult_rate='',display_total_child_rate='',display_adult_rate='',display_child_rate='0',additional_service_rate='0',booking_remark='',emergency_cont_no='',terms_n_condition='';
[02/16/2024 10:54:39], [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','2838','2024-02-16 10:54:39',0);
[02/16/2024 10:56:38], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 10:56:38' WHERE id= '562';
[02/16/2024 10:56:38], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO bookings set reservation_id='2838',agent_id='7851',leader_title='Mr',leader_first_name='shiv',leader_last_name='chauhan',city_id='lucca',country_id='68',nationality='Italian',display_room_rate='95.51',display_currency_code='USD',native_room_rate='70.14',consultant_id='SUJAY_QTECH',native_currency_code='EUR',cancellation_policy='Cancellation Charges will be applicable if cancelled after 26 Mar 2024 03:00 hrs.<BR>Late amendment charge may apply.<Br><Br><B><U>Detailed Cancellation Policy:</U></B><Br>Charges - 95.51  applicable if cancelled after 26 Mar 2024 at 03:00 hrs',current_status='inprocess-booking',booking_status='1',sales_manager_id='0',create_date='2024-02-16 10:56:38',source_type='viator',expiration_date= '2024-03-26 00:00:00',applied_multiplier='1.36177',applied_markup='0',agent_markup='0',basecurrency_multiplier='1.00000',basecurrency_multiplier_native='1.36177',admin_booked='0',service_date='2024-03-28',sub_user_id='',check_out_date='2024-03-28',supplier_profile_id='',agent_currency_multiplier='3.7507', booking_branch_id = '27',site_url = 'https://beta.astrabookings.com/',ip_addr='43.239.53.130',leader_phone=' 9823860012',email_id='shiv.chauhan@qtechsoftware.com',service_type='sightseeing';
[02/16/2024 10:56:38], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO sight_bookings set booking_id='427',native_nightly_rates='a:2:{s:4:\"size\";i:1;s:17:\"nativeNightlyRate\";d:70.140000000000001;}',rate_description='',display_nightly_rates='a:4:{s:4:\"size\";i:1;s:18:\"displayNightlyRate\";d:95.510000000000005;s:25:\"displayNightlyRateDisplay\";s:133:\"Rate - 70.14 EUR, Currency Multiplier (EUR-USD) - 1.36177, Markup  in % - %, Markup Amount - , Markup Amount in  - ,Other Markup - 0%\";s:23:\"displayNightlyRateStore\";s:134:\"Rate - 70.14 EUR, Currency Multiplier (EUR-USD) - 1.36177, Markup  in % - %, Markup Amount - , Markup Amount in  -  ,Other Markup - 0%\";}',display_currency_code='USD',native_currency_code='EUR',sight_id='87299P10',sight_name='E-BIKE RENTAL IN LUCCA- V2',tour_time='',tour_details='',tour_inclusive='B<br/>',tour_exclusive='<br/>',meeting_point='',tour_dep_point=' ',tour_language='',tour_supplier_phone='',additional_tour_dep_point='',tour_duration='9 hours 0 minutes<br> Start Time: 10:00',arrival_date='2024-03-28',total_adults='2',total_children='',total_infants='',gta_city_code='22436',supplier_id='',pick_up_point='',drop_off_point='',from_slot='',to_slot='',total_adult_rate='',total_child_rate='',adult_rate='',child_rate='',display_total_adult_rate='',display_total_child_rate='',display_adult_rate='',display_child_rate='0',additional_service_rate='0',booking_remark='',emergency_cont_no='',terms_n_condition='';
[02/16/2024 10:56:38], [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','2838','2024-02-16 10:56:38',0);
[02/16/2024 10:57:19], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 10:57:19' WHERE id= '562';
[02/16/2024 10:57:19], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO bookings set reservation_id='2838',agent_id='7851',leader_title='Mr',leader_first_name='shiv',leader_last_name='chauhan',city_id='lucca',country_id='68',nationality='Italian',display_room_rate='95.51',display_currency_code='USD',native_room_rate='70.14',consultant_id='SUJAY_QTECH',native_currency_code='EUR',cancellation_policy='Cancellation Charges will be applicable if cancelled after 26 Mar 2024 03:00 hrs.<BR>Late amendment charge may apply.<Br><Br><B><U>Detailed Cancellation Policy:</U></B><Br>Charges - 95.51  applicable if cancelled after 26 Mar 2024 at 03:00 hrs',current_status='inprocess-booking',booking_status='1',sales_manager_id='0',create_date='2024-02-16 10:57:19',source_type='viator',expiration_date= '2024-03-26 00:00:00',applied_multiplier='1.36177',applied_markup='0',agent_markup='0',basecurrency_multiplier='1.00000',basecurrency_multiplier_native='1.36177',admin_booked='0',service_date='2024-03-28',sub_user_id='',check_out_date='2024-03-28',supplier_profile_id='',agent_currency_multiplier='3.7507', booking_branch_id = '27',site_url = 'https://beta.astrabookings.com/',ip_addr='43.239.53.130',leader_phone=' 9823860012',email_id='shiv.chauhan@qtechsoftware.com',service_type='sightseeing';
[02/16/2024 10:57:19], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO sight_bookings set booking_id='428',native_nightly_rates='a:2:{s:4:\"size\";i:1;s:17:\"nativeNightlyRate\";d:70.140000000000001;}',rate_description='',display_nightly_rates='a:4:{s:4:\"size\";i:1;s:18:\"displayNightlyRate\";d:95.510000000000005;s:25:\"displayNightlyRateDisplay\";s:133:\"Rate - 70.14 EUR, Currency Multiplier (EUR-USD) - 1.36177, Markup  in % - %, Markup Amount - , Markup Amount in  - ,Other Markup - 0%\";s:23:\"displayNightlyRateStore\";s:134:\"Rate - 70.14 EUR, Currency Multiplier (EUR-USD) - 1.36177, Markup  in % - %, Markup Amount - , Markup Amount in  -  ,Other Markup - 0%\";}',display_currency_code='USD',native_currency_code='EUR',sight_id='87299P10',sight_name='E-BIKE RENTAL IN LUCCA- V2',tour_time='',tour_details='',tour_inclusive='B<br/>',tour_exclusive='<br/>',meeting_point='',tour_dep_point=' ',tour_language='',tour_supplier_phone='',additional_tour_dep_point='',tour_duration='9 hours 0 minutes<br> Start Time: 10:00',arrival_date='2024-03-28',total_adults='2',total_children='',total_infants='',gta_city_code='22436',supplier_id='',pick_up_point='',drop_off_point='',from_slot='',to_slot='',total_adult_rate='',total_child_rate='',adult_rate='',child_rate='',display_total_adult_rate='',display_total_child_rate='',display_adult_rate='',display_child_rate='0',additional_service_rate='0',booking_remark='',emergency_cont_no='',terms_n_condition='';
[02/16/2024 10:57:19], [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','2838','2024-02-16 10:57:19',0);
[02/16/2024 10:58:14], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 10:58:14' WHERE id= '562';
[02/16/2024 10:58:14], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO bookings set reservation_id='2838',agent_id='7851',leader_title='Mr',leader_first_name='shiv',leader_last_name='chauhan',city_id='lucca',country_id='68',nationality='Italian',display_room_rate='95.51',display_currency_code='USD',native_room_rate='70.14',consultant_id='SUJAY_QTECH',native_currency_code='EUR',cancellation_policy='Cancellation Charges will be applicable if cancelled after 26 Mar 2024 03:00 hrs.<BR>Late amendment charge may apply.<Br><Br><B><U>Detailed Cancellation Policy:</U></B><Br>Charges - 95.51  applicable if cancelled after 26 Mar 2024 at 03:00 hrs',current_status='inprocess-booking',booking_status='1',sales_manager_id='0',create_date='2024-02-16 10:58:14',source_type='viator',expiration_date= '2024-03-26 00:00:00',applied_multiplier='1.36177',applied_markup='0',agent_markup='0',basecurrency_multiplier='1.00000',basecurrency_multiplier_native='1.36177',admin_booked='0',service_date='2024-03-28',sub_user_id='',check_out_date='2024-03-28',supplier_profile_id='',agent_currency_multiplier='3.7507', booking_branch_id = '27',site_url = 'https://beta.astrabookings.com/',ip_addr='43.239.53.130',leader_phone=' 9823860012',email_id='shiv.chauhan@qtechsoftware.com',service_type='sightseeing';
[02/16/2024 10:58:14], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO sight_bookings set booking_id='429',native_nightly_rates='a:2:{s:4:\"size\";i:1;s:17:\"nativeNightlyRate\";d:70.140000000000001;}',rate_description='',display_nightly_rates='a:4:{s:4:\"size\";i:1;s:18:\"displayNightlyRate\";d:95.510000000000005;s:25:\"displayNightlyRateDisplay\";s:133:\"Rate - 70.14 EUR, Currency Multiplier (EUR-USD) - 1.36177, Markup  in % - %, Markup Amount - , Markup Amount in  - ,Other Markup - 0%\";s:23:\"displayNightlyRateStore\";s:134:\"Rate - 70.14 EUR, Currency Multiplier (EUR-USD) - 1.36177, Markup  in % - %, Markup Amount - , Markup Amount in  -  ,Other Markup - 0%\";}',display_currency_code='USD',native_currency_code='EUR',sight_id='87299P10',sight_name='E-BIKE RENTAL IN LUCCA- V2',tour_time='',tour_details='',tour_inclusive='B<br/>',tour_exclusive='<br/>',meeting_point='',tour_dep_point=' ',tour_language='',tour_supplier_phone='',additional_tour_dep_point='',tour_duration='9 hours 0 minutes<br> Start Time: 10:00',arrival_date='2024-03-28',total_adults='2',total_children='',total_infants='',gta_city_code='22436',supplier_id='',pick_up_point='',drop_off_point='',from_slot='',to_slot='',total_adult_rate='',total_child_rate='',adult_rate='',child_rate='',display_total_adult_rate='',display_total_child_rate='',display_adult_rate='',display_child_rate='0',additional_service_rate='0',booking_remark='',emergency_cont_no='',terms_n_condition='';
[02/16/2024 10:58:14], [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','2838','2024-02-16 10:58:14',0);
[02/16/2024 10:59:22], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 10:59:22' WHERE id= '562';
[02/16/2024 10:59:22], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO bookings set reservation_id='2838',agent_id='7851',leader_title='Mr',leader_first_name='shiv',leader_last_name='chauhan',city_id='lucca',country_id='68',nationality='Italian',display_room_rate='95.51',display_currency_code='USD',native_room_rate='70.14',consultant_id='SUJAY_QTECH',native_currency_code='EUR',cancellation_policy='Cancellation Charges will be applicable if cancelled after 26 Mar 2024 03:00 hrs.<BR>Late amendment charge may apply.<Br><Br><B><U>Detailed Cancellation Policy:</U></B><Br>Charges - 95.51  applicable if cancelled after 26 Mar 2024 at 03:00 hrs',current_status='inprocess-booking',booking_status='1',sales_manager_id='0',create_date='2024-02-16 10:59:22',source_type='viator',expiration_date= '2024-03-26 00:00:00',applied_multiplier='1.36177',applied_markup='0',agent_markup='0',basecurrency_multiplier='1.00000',basecurrency_multiplier_native='1.36177',admin_booked='0',service_date='2024-03-28',sub_user_id='',check_out_date='2024-03-28',supplier_profile_id='',agent_currency_multiplier='3.7507', booking_branch_id = '27',site_url = 'https://beta.astrabookings.com/',ip_addr='43.239.53.130',leader_phone=' 9823860012',email_id='shiv.chauhan@qtechsoftware.com',service_type='sightseeing';
[02/16/2024 10:59:22], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO sight_bookings set booking_id='430',native_nightly_rates='a:2:{s:4:\"size\";i:1;s:17:\"nativeNightlyRate\";d:70.140000000000001;}',rate_description='',display_nightly_rates='a:4:{s:4:\"size\";i:1;s:18:\"displayNightlyRate\";d:95.510000000000005;s:25:\"displayNightlyRateDisplay\";s:133:\"Rate - 70.14 EUR, Currency Multiplier (EUR-USD) - 1.36177, Markup  in % - %, Markup Amount - , Markup Amount in  - ,Other Markup - 0%\";s:23:\"displayNightlyRateStore\";s:134:\"Rate - 70.14 EUR, Currency Multiplier (EUR-USD) - 1.36177, Markup  in % - %, Markup Amount - , Markup Amount in  -  ,Other Markup - 0%\";}',display_currency_code='USD',native_currency_code='EUR',sight_id='87299P10',sight_name='E-BIKE RENTAL IN LUCCA- V2',tour_time='',tour_details='',tour_inclusive='B<br/>',tour_exclusive='<br/>',meeting_point='',tour_dep_point=' ',tour_language='',tour_supplier_phone='',additional_tour_dep_point='',tour_duration='9 hours 0 minutes<br> Start Time: 10:00',arrival_date='2024-03-28',total_adults='2',total_children='',total_infants='',gta_city_code='22436',supplier_id='',pick_up_point='',drop_off_point='',from_slot='',to_slot='',total_adult_rate='',total_child_rate='',adult_rate='',child_rate='',display_total_adult_rate='',display_total_child_rate='',display_adult_rate='',display_child_rate='0',additional_service_rate='0',booking_remark='',emergency_cont_no='',terms_n_condition='';
[02/16/2024 10:59:22], [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','2838','2024-02-16 10:59:22',0);
