[01/15/2024 02:02:27], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-15 02:02:27' WHERE id= '297';
[01/15/2024 02:02:27], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705327347','43.239.53.130');
[01/15/2024 02:05:12], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2024-01-15 02:05:12' WHERE id= '297';
[01/15/2024 02:05:12], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-15 02:05:12',login_attempt=0 where id = '7851';
[01/15/2024 02:05:12], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Viator_test', user_type = 'A', branch_id = '27', login_datetime = '2024-01-15 14:05:12', ip = '43.239.53.130', action = 'Login' ;
[01/15/2024 02:05:12], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-15 02:05:12' WHERE id= '297';
[01/15/2024 02:05:16], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-15 02:05:16' WHERE id= '297';
[01/15/2024 02:05:20], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-15 02:05:20' WHERE id= '297';
[01/15/2024 02:05:26], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-15 02:05:26' WHERE id= '297';
[01/15/2024 02:05:26], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7851' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '27' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/01/18',  departure_date='2024/01/18',  nights='1',  create_date='2024-01-15 :14:05:26',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/15/2024 02:05:28], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'v1/15_01_2024/request_availability_Viator_test_14_05_26_1705327526.json', 'v1/15_01_2024/response_availability_Viator_test_14_05_26_1705327526.json', 'v1/15_01_2024/response_header_availability_Viator_test_14_05_26_1705327526.json', 'viator', '2024-01-15 02:05:28', '', '', '931');
[01/15/2024 02:05:30], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-15 02:05:30' WHERE id= '297';
[01/15/2024 02:05:30], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-15 02:05:30' WHERE id= '297';
[01/15/2024 02:05:34], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-15 02:05:34' WHERE id= '297';
[01/15/2024 02:05: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/15_01_2024/request_sight_details_Viator_test_14_05_34_1705327534.json', 'v1/15_01_2024/response_sight_details_Viator_test_14_05_34_1705327534.json', 'v1/15_01_2024/response_header_sight_details_Viator_test_14_05_34_1705327534.json', 'viator', '2024-01-15 02:05:34', '', '', '931');
[01/15/2024 02:05:43], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-15 02:05:43' WHERE id= '297';
[01/15/2024 02:05: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 ('', 'check_availability', 'v1/15_01_2024/request_check_availability_Viator_test_14_05_43_1705327543.json', 'v1/15_01_2024/response_check_availability_Viator_test_14_05_43_1705327543.json', 'v1/15_01_2024/response_header_check_availability_Viator_test_14_05_43_1705327543.json', 'viator', '2024-01-15 02:05:43', '', '', '931');
[01/15/2024 02:05:45], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-15 02:05:45' WHERE id= '297';
[01/15/2024 02:05:45], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705327545','43.239.53.130');
[01/15/2024 02:07:09], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-15 02:07:09' WHERE id= '297';
[01/15/2024 02:07:09], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705327629','43.239.53.130');
[01/15/2024 02:08:51], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-15 02:08:51' WHERE id= '297';
[01/15/2024 02:08:51], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705327731','43.239.53.130');
[01/15/2024 02:08:52], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-15 02:08:52' WHERE id= '297';
[01/15/2024 02:11:29], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-15 02:11:29' WHERE id= '297';
[01/15/2024 02:13:19], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-15 02:13:19' WHERE id= '297';
[01/15/2024 02:14:14], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-15 02:14:14' WHERE id= '297';
[01/15/2024 02:15:55], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-15 02:15:55' WHERE id= '297';
[01/15/2024 02:17:53], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-15 02:17:53' WHERE id= '297';
[01/15/2024 02:17:59], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-15 02:17:59' WHERE id= '297';
[01/15/2024 02:17:59], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705328279','43.239.53.130');
[01/15/2024 02:20:32], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-15 02:20:32' WHERE id= '297';
[01/15/2024 02:20:32], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705328432','43.239.53.130');
[01/15/2024 02:20:34], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-15 02:20:34' WHERE id= '297';
[01/15/2024 02:32:33], [file name :-/home/otrams/public_html/beta/tms/supplier_profile/supplier_profile.php],update supplier_profiles SET default_value='yes' where supplier_profile_id= ?;
[01/15/2024 02:32:33], [file name :-/home/otrams/public_html/beta/tms/supplier_profile/supplier_profile.php],update supplier_profiles SET default_value='no' where supplier_id= 'viator'  and supplier_profile_id!= '13';
[01/15/2024 02:32:33], [file name :-/home/otrams/public_html/beta/tms/supplier_profile/supplier_profile.php],update supplier_profiles SET modify_by = 'v3alpha',modify_date = '2024-01-15 02:32:33' where supplier_id= 'viator'  and supplier_profile_id= '13';
[01/15/2024 02:32:33], [file name :-/home/otrams/public_html/beta/tms/supplier_profile/supplier_profile.php],delete from supplier_profiles_countries  where supplier_profile_id= ?;
[01/15/2024 02:32:33], [file name :-/home/otrams/public_html/beta/tms/supplier_profile/supplier_profile.php],INSERT INTO supplier_profiles_countries SET country_id =? ,supplier_profile_id = ? ;
[01/15/2024 02:32:33], [file name :-/home/otrams/public_html/beta/tms/supplier_profile/supplier_profile.php],delete from supplier_profiles_access  where supplier_profile_id= ? ;
[01/15/2024 02:32:33], [file name :-/home/otrams/public_html/beta/tms/supplier_profile/supplier_profile.php],INSERT INTO supplier_profiles_access SET supplier_profile_id= '13',supplier_key = 'aEU1R3BhVFM3WVJBU3lKdFF1SDJXdDRORGN1Sk9DY0VEUlVLcGdLOENUOD0=',key_value = 'SytIdjBjLyt0TmJpMmZweXBVQVZDUT09' ;
[01/15/2024 02:32:33], [file name :-/home/otrams/public_html/beta/tms/supplier_profile/supplier_profile.php],INSERT INTO supplier_profiles_access SET supplier_profile_id= '13',supplier_key = 'azVyejRrZEcwd0F0QmJ5ajVvdnN2elB0RXM1dzRQbXphSFc0UzJkUHgzUT0=',key_value = 'a3dNZktvWUppeXdXVUc1eGFCYk5YMkk4K1pVUDZSMkNNQ2Jib3M3TnB4dz0=' ;
[01/15/2024 02:32:33], [file name :-/home/otrams/public_html/beta/tms/supplier_profile/supplier_profile.php],INSERT INTO supplier_profiles_access SET supplier_profile_id= '13',supplier_key = 'bjZqWTltcnJ3YlY3a1JVSlZheVBETFhpZXd2cDZxendqT042RWt6ZkVOaz0=',key_value = 'TitzaGVraUs2dEtMMTF6aitMUG5RYmVlU216SFdIOTQ2ZG0xM2FlakpWdz0=' ;
[01/15/2024 02:32:33], [file name :-/home/otrams/public_html/beta/tms/supplier_profile/supplier_profile.php],INSERT INTO supplier_profiles_access SET supplier_profile_id= '13',supplier_key = 'cTZ4cURsRWxjQTNDT1REMHZZTTl1Zz09',key_value = 'K0VtdzBycTI0RjBQZFpuOW1rbW12TUFXbWRhdW4yU0l4VUVtaEx0ZUJhRT0=' ;
[01/15/2024 02:32:33], [file name :-/home/otrams/public_html/beta/tms/supplier_profile/supplier_profile.php],INSERT INTO supplier_profiles_access SET supplier_profile_id= '13',supplier_key = 'dlNRd0RRekZWU3BNR0dMR1Z0cU5CR3huZEVSRzJPNDBSdlB0MzRnUHhwRT0=',key_value = 'RkxHMDVSMU5hNS9JSk5FQXdUU2ZiTVVmYTF5cHdCbHZJcmNEQklQUlZoRT0=' ;
[01/15/2024 02:32:33], [file name :-/home/otrams/public_html/beta/tms/supplier_profile/supplier_profile.php],INSERT INTO supplier_profiles_access SET supplier_profile_id= '13',supplier_key = 'dnpud0N3L29PaW5LZVd4WG5xRm53b3pEUjZFbkVkdGV6UjVrSDh6YUlTWT0=',key_value = 'VVNSM2xha2s4M1RaaTZZdzMrViswbEdRVEVuc3F4cEdOc3VGT2dWUk5CYz0=' ;
[01/15/2024 02:32:33], [file name :-/home/otrams/public_html/beta/tms/supplier_profile/supplier_profile.php],INSERT INTO supplier_profiles_access SET supplier_profile_id= '13',supplier_key = 'dzVHSWovNHZzR3gvWXZNeGUyYTMvRjhOalNoVmRVSDY2ZStISHowV1E0bz0=',key_value = 'RkxHMDVSMU5hNS9JSk5FQXdUU2ZiSVFXY0pta0M2ME81L0IwMko0T09OYz0=' ;
[01/15/2024 02:32:33], [file name :-/home/otrams/public_html/beta/tms/supplier_profile/supplier_profile.php],INSERT INTO supplier_profiles_access SET supplier_profile_id= '13',supplier_key = 'L0dZV1MyZW1yMUN5cmU2ejZzTVlmalRrdGVLMmNiYkRuSUxGV3BSckVwaz0=',key_value = 'S0p3THZpamF3N3J2UXFQMllWMWJNTFd0Y2ZqZks0Y01tb0ZJOXBkWms3VT0=' ;
[01/15/2024 02:32:33], [file name :-/home/otrams/public_html/beta/tms/supplier_profile/supplier_profile.php],INSERT INTO supplier_profiles_access SET supplier_profile_id= '13',supplier_key = 'M1Z2TVNCT1FWZkZCMXBnTzJrTEZxUT09',key_value = 'Tjh6Q0FqY3QyMWVBQUZnKzJzNmQrVU0vb3ZyV091ZFZaenp4clVGVk95U3hocVpuWHdNTVNaSlF4SzJOdnBULw==' ;
[01/15/2024 02:32:33], [file name :-/home/otrams/public_html/beta/tms/supplier_profile/supplier_profile.php],INSERT INTO supplier_profiles_access SET supplier_profile_id= '13',supplier_key = 'NUhQYkppU1RSazNqMW0zcW1BajZqRnZxU2g4dFhkMlZMZ0ZqMjVzMS9ORT0=',key_value = 'VTR0MndtVlFLeGprQ3BiVTdNRk1VUT09' ;
[01/15/2024 02:32:33], [file name :-/home/otrams/public_html/beta/tms/supplier_profile/supplier_profile.php],INSERT INTO supplier_profiles_access SET supplier_profile_id= '13',supplier_key = 'NUhQYkppU1RSazNqMW0zcW1BajZqSE5aVUEwbnhMYlZ3V1FqSGI5WmNubz0=',key_value = 'cG9tTTQzTDFCUDVZbXhkYzFaTmwrOEhYTTIwdjYveXF3OUY5dGxDaG5OUT0=' ;
[01/15/2024 02:32:33], [file name :-/home/otrams/public_html/beta/tms/supplier_profile/supplier_profile.php],INSERT INTO supplier_profiles_access SET supplier_profile_id= '13',supplier_key = 'Qk1MSk9GV1ppcm85SkhLaU85WTBPc2dST0RNMElqb2pITytSNVpGclpGaz0=',key_value = 'aG82SXRFYzBNQ2hFdlRCN29ZUFdYdz09' ;
[01/15/2024 02:32:33], [file name :-/home/otrams/public_html/beta/tms/supplier_profile/supplier_profile.php],INSERT INTO supplier_profiles_access SET supplier_profile_id= '13',supplier_key = 'QzdFWWJLT09nM3p1K3FoL0U2ak54QT09',key_value = 'K3ozQnpNM0d3MS8yNEtZQXBJYkZFaldrK1VRSUc4aHppZTFhUFl6dnE1ST0=' ;
[01/15/2024 02:32:33], [file name :-/home/otrams/public_html/beta/tms/supplier_profile/supplier_profile.php],INSERT INTO supplier_profiles_access SET supplier_profile_id= '13',supplier_key = 'QzVWNmxQdnJyaDNkeWZOdVllaytFVVptTkFXZWNTaTU3ZnRLazhLZ0NaTjZLYWpaQVVvZWFqMVo2bXhsMS85eA==',key_value = 'YzMwb01pcjR4djVwWVdWZ2JyTjRBU0hZelpqcTB5dlcweTN4TXZiN2lCYz0=' ;
[01/15/2024 02:32:33], [file name :-/home/otrams/public_html/beta/tms/supplier_profile/supplier_profile.php],INSERT INTO supplier_profiles_access SET supplier_profile_id= '13',supplier_key = 'Rm4wY1hVZUVIYzVOTEpWdG1qY0xCWHpoaG1tSnB0Z3hxbERpajNxakxTQT0=',key_value = 'QVEvQ3pIQ0lhY3dUaDBmN0lJTUJuZkpJak5sREkwKzdSNjNmSnJuMmlMT3dETmFBZTRwd0VLZW9UTE5VUDU4cg==' ;
[01/15/2024 02:32:33], [file name :-/home/otrams/public_html/beta/tms/supplier_profile/supplier_profile.php],INSERT INTO supplier_profiles_access SET supplier_profile_id= '13',supplier_key = 'STNIczZaYWNtTWJWRGxQdVA4ck9qU3EyNXcvRlNBQ2JZZ1hjaXZsZFhHYz0=',key_value = 'dFJaSHFjSmpibmkzRGZTMUpVZGs0QT09' ;
[01/15/2024 02:32:33], [file name :-/home/otrams/public_html/beta/tms/supplier_profile/supplier_profile.php],INSERT INTO supplier_profiles_access SET supplier_profile_id= '13',supplier_key = 'U2FZbUIyTDdyaVlvcUJBMWFUakRqeGFEZVhZNDhBb1puLzNydlRRYW54cz0=',key_value = 'VVNSM2xha2s4M1RaaTZZdzMrViswaE1sVnR6N0g3WlZXT1lTS2liajhzOD0=' ;
[01/15/2024 02:32:33], [file name :-/home/otrams/public_html/beta/tms/supplier_profile/supplier_profile.php],INSERT INTO supplier_profiles_access SET supplier_profile_id= '13',supplier_key = 'U2FZbUIyTDdyaVlvcUJBMWFUakRqM2tSTXpwVUp2a0hZTHkrbm5udWE4YWZIWjlmQTVBSUUxUFBmSXd3MGJHcg==',key_value = 'VVNSM2xha2s4M1RaaTZZdzMrViswZ1RzYWg0RGhUamVncmdjaGtsb2VKdz0=' ;
[01/15/2024 02:32:33], [file name :-/home/otrams/public_html/beta/tms/supplier_profile/supplier_profile.php],INSERT INTO supplier_profiles_access SET supplier_profile_id= '13',supplier_key = 'UWFhdFpKUGQ5dUFzT2IrUHRxOHlUOERsdUF0YkhEMHFyNWk2MnRoRVlDZz0=',key_value = 'bHFiWEE1UW9RNnpSVDJnSGZwY01RQT09' ;
[01/15/2024 02:32:33], [file name :-/home/otrams/public_html/beta/tms/supplier_profile/supplier_profile.php],INSERT INTO supplier_profiles_access SET supplier_profile_id= '13',supplier_key = 'V3gwdHF6SVhjSGtUTFVSTndJcnZMdz09',key_value = 'MElUWjU1OHVMZVVXVHJkU1hlV2pTRVBhYXVlbzhFNUpod1RtV3czVHZ0Zz0=' ;
[01/15/2024 02:32:33], [file name :-/home/otrams/public_html/beta/tms/supplier_profile/supplier_profile.php],INSERT INTO supplier_profiles_access SET supplier_profile_id= '13',supplier_key = 'VlI5UzdBQTgzNERjdThvK0svL00zU2NMOWpycEV4OTlmU3NhMUJ0RE42dz0=',key_value = 'MTBWaXBySktNY0FQdThYT0VYMGpsaTVvZmV6dmVXU3BQRG5aTDFtTmxlaz0=' ;
[01/15/2024 02:32:33], [file name :-/home/otrams/public_html/beta/tms/supplier_profile/supplier_profile.php],INSERT INTO supplier_profiles_access SET supplier_profile_id= '13',supplier_key = 'VnJoUk5ZYi9uNHhVYUh2U3lDVzk5VkJ3TFVGbGxac3ZoMVpNSW9tNzdoWT0=',key_value = 'dlRLcUlkQzVpbGovSm9obzRIY1FsLzVEcEJ1MDBRcXNtM05za1dqYTgrVT0=' ;
[01/15/2024 02:32:33], [file name :-/home/otrams/public_html/beta/tms/supplier_profile/supplier_profile.php],INSERT INTO supplier_profiles_access SET supplier_profile_id= '13',supplier_key = 'VnJoUk5ZYi9uNHhVYUh2U3lDVzk5VVRVUUV4Nlpjd3I3YzluNENFRTlFQT0=',key_value = 'UTdodEgwNUVyRmtIYllWWG5zRkhVZz09' ;
[01/15/2024 02:32:33], [file name :-/home/otrams/public_html/beta/tms/supplier_profile/supplier_profile.php],INSERT INTO supplier_profiles_access SET supplier_profile_id= '13',supplier_key = 'WE9uSzNRMVB3TVVLL1VEaU9JVktiVWkrUnVjUzVxL3Q1dVRpZmMyempQMD0=',key_value = 'Tjh6Q0FqY3QyMWVBQUZnKzJzNmQrVU0vb3ZyV091ZFZaenp4clVGVk95U3hocVpuWHdNTVNaSlF4SzJOdnBULw==' ;
[01/15/2024 02:32:33], [file name :-/home/otrams/public_html/beta/tms/supplier_profile/supplier_profile.php],INSERT INTO supplier_profiles_access SET supplier_profile_id= '13',supplier_key = 'Wm5OOHZzWVpMV3VPMVZSKzF1S1Z1NGxKMDBvU2ZUdVV0Zjk5enRJK2NFND0=',key_value = 'bzNVU1lvSTB4czZtZFVSMkFHU1l0dz09' ;
[01/15/2024 02:32:33], [file name :-/home/otrams/public_html/beta/tms/supplier_profile/supplier_profile.php],INSERT INTO supplier_profiles_access SET supplier_profile_id= '13',supplier_key = 'ZjJXcW8zaXh3MjVsaG0rcnZrRjBNQmdRc2RpQTlUd0R4dmkwcUM0dndSOD0=',key_value = 'M0d2SS8ra0szNFpTcUVEQm43SUVNUT09' ;
[01/15/2024 02:32:33], [file name :-/home/otrams/public_html/beta/tms/supplier_profile/supplier_profile.php],INSERT INTO supplier_profiles_access SET supplier_profile_id= '13',supplier_key = 'ZjJXcW8zaXh3MjVsaG0rcnZrRjBNRjJRZ2g4R2V0TXZCRkVKMDBCVFIxVT0=',key_value = 'WVVDclpCWXpZZmZYWDFZVEkrYkw1QkNCT2NGV1djd2dDdEMrWGpRRzBvVT0=' ;
[01/15/2024 02:38:37], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-15 02:38:37' WHERE id= '297';
[01/15/2024 02:38:37], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO bookings set reservation_id='1614',agent_id='7851',leader_title='Mr',leader_first_name='Sasa',leader_last_name='sas',city_id='dubai',country_id='138',nationality='Emirati',display_room_rate='99.28',display_currency_code='USD',native_room_rate='99.28',consultant_id='SUJAY_QTECH',native_currency_code='USD',cancellation_policy='Cancellation Charges will be applicable if cancelled after 03 Dec 2023 12:00 hrs.<BR>Late amendment charge may apply.<Br><Br><B><U>Detailed Cancellation Policy:</U></B><Br>99.28 USDCharges - 100% applicable from time of Booking (Full Cancellation Charges applicable immediately)',current_status='inprocess-booking',booking_status='1',sales_manager_id='0',create_date='2024-01-15 14:38:37',source_type='viator',expiration_date= '2023-12-03 09:00:00',applied_multiplier='1.00000',applied_markup='0',agent_markup='0',basecurrency_multiplier='1.00000',basecurrency_multiplier_native='1.00000',admin_booked='0',service_date='2024-01-18',sub_user_id='',check_out_date='2024-01-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';
[01/15/2024 02:38:37], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO sight_bookings set booking_id='169',native_nightly_rates='a:2:{s:4:\"size\";i:1;s:17:\"nativeNightlyRate\";d:99.280000000000001;}',rate_description='',display_nightly_rates='a:4:{s:4:\"size\";i:1;s:18:\"displayNightlyRate\";d:99.280000000000001;s:25:\"displayNightlyRateDisplay\";s:133:\"Rate - 99.28 USD, Currency Multiplier (USD-USD) - 1.00000, Markup  in % - %, Markup Amount - , Markup Amount in  - ,Other Markup - 0%\";s:23:\"displayNightlyRateStore\";s:134:\"Rate - 99.28 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='386596P1',sight_name='DESERT SAFARI, 60-MIN SELF-DRIVE ATV, CAMEL RIDE, SHOWS, DINNER- V2',tour_time='',tour_details='',tour_inclusive='<br/>',tour_exclusive=',<br/>',meeting_point='',tour_dep_point=' ',tour_language='',tour_supplier_phone='',additional_tour_dep_point='',tour_duration='7 hours 0 minutes<br> Start Time: 14:30',arrival_date='2024-01-18',total_adults='2',total_children='',total_infants='1',gta_city_code='828',supplier_id='',pick_up_point='',drop_off_point='',from_slot='',to_slot='',total_adult_rate='',total_child_rate='',adult_rate='',child_rate='',display_total_adult_rate='',display_total_child_rate='',display_adult_rate='',display_child_rate='0',additional_service_rate='0',booking_remark='',emergency_cont_no='',terms_n_condition='';
[01/15/2024 02:43:10], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-15 02:43:10' WHERE id= '297';
[01/15/2024 02:43:10], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO bookings set reservation_id='1614',agent_id='7851',leader_title='Mr',leader_first_name='Sasa',leader_last_name='sas',city_id='dubai',country_id='138',nationality='Emirati',display_room_rate='99.28',display_currency_code='USD',native_room_rate='99.28',consultant_id='SUJAY_QTECH',native_currency_code='USD',cancellation_policy='Cancellation Charges will be applicable if cancelled after 03 Dec 2023 12:00 hrs.<BR>Late amendment charge may apply.<Br><Br><B><U>Detailed Cancellation Policy:</U></B><Br>99.28 USDCharges - 100% applicable from time of Booking (Full Cancellation Charges applicable immediately)',current_status='inprocess-booking',booking_status='1',sales_manager_id='0',create_date='2024-01-15 14:43:10',source_type='viator',expiration_date= '2023-12-03 09:00:00',applied_multiplier='1.00000',applied_markup='0',agent_markup='0',basecurrency_multiplier='1.00000',basecurrency_multiplier_native='1.00000',admin_booked='0',service_date='2024-01-18',sub_user_id='',check_out_date='2024-01-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';
[01/15/2024 02:43:10], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO sight_bookings set booking_id='170',native_nightly_rates='a:2:{s:4:\"size\";i:1;s:17:\"nativeNightlyRate\";d:99.280000000000001;}',rate_description='',display_nightly_rates='a:4:{s:4:\"size\";i:1;s:18:\"displayNightlyRate\";d:99.280000000000001;s:25:\"displayNightlyRateDisplay\";s:133:\"Rate - 99.28 USD, Currency Multiplier (USD-USD) - 1.00000, Markup  in % - %, Markup Amount - , Markup Amount in  - ,Other Markup - 0%\";s:23:\"displayNightlyRateStore\";s:134:\"Rate - 99.28 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='386596P1',sight_name='DESERT SAFARI, 60-MIN SELF-DRIVE ATV, CAMEL RIDE, SHOWS, DINNER- V2',tour_time='',tour_details='',tour_inclusive='<br/>',tour_exclusive=',<br/>',meeting_point='',tour_dep_point=' ',tour_language='',tour_supplier_phone='',additional_tour_dep_point='',tour_duration='7 hours 0 minutes<br> Start Time: 14:30',arrival_date='2024-01-18',total_adults='2',total_children='',total_infants='1',gta_city_code='828',supplier_id='',pick_up_point='',drop_off_point='',from_slot='',to_slot='',total_adult_rate='',total_child_rate='',adult_rate='',child_rate='',display_total_adult_rate='',display_total_child_rate='',display_adult_rate='',display_child_rate='0',additional_service_rate='0',booking_remark='',emergency_cont_no='',terms_n_condition='';
[01/15/2024 02:43: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','1614','2024-01-15 14:43:10',0);
[01/15/2024 02:44:23], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-15 02:44:23' WHERE id= '297';
[01/15/2024 02:44:23], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO bookings set reservation_id='1614',agent_id='7851',leader_title='Mr',leader_first_name='Sasa',leader_last_name='sas',city_id='dubai',country_id='138',nationality='Emirati',display_room_rate='99.28',display_currency_code='USD',native_room_rate='99.28',consultant_id='SUJAY_QTECH',native_currency_code='USD',cancellation_policy='Cancellation Charges will be applicable if cancelled after 03 Dec 2023 12:00 hrs.<BR>Late amendment charge may apply.<Br><Br><B><U>Detailed Cancellation Policy:</U></B><Br>99.28 USDCharges - 100% applicable from time of Booking (Full Cancellation Charges applicable immediately)',current_status='inprocess-booking',booking_status='1',sales_manager_id='0',create_date='2024-01-15 14:44:23',source_type='viator',expiration_date= '2023-12-03 09:00:00',applied_multiplier='1.00000',applied_markup='0',agent_markup='0',basecurrency_multiplier='1.00000',basecurrency_multiplier_native='1.00000',admin_booked='0',service_date='2024-01-18',sub_user_id='',check_out_date='2024-01-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';
[01/15/2024 02:44:23], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO sight_bookings set booking_id='171',native_nightly_rates='a:2:{s:4:\"size\";i:1;s:17:\"nativeNightlyRate\";d:99.280000000000001;}',rate_description='',display_nightly_rates='a:4:{s:4:\"size\";i:1;s:18:\"displayNightlyRate\";d:99.280000000000001;s:25:\"displayNightlyRateDisplay\";s:133:\"Rate - 99.28 USD, Currency Multiplier (USD-USD) - 1.00000, Markup  in % - %, Markup Amount - , Markup Amount in  - ,Other Markup - 0%\";s:23:\"displayNightlyRateStore\";s:134:\"Rate - 99.28 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='386596P1',sight_name='DESERT SAFARI, 60-MIN SELF-DRIVE ATV, CAMEL RIDE, SHOWS, DINNER- V2',tour_time='',tour_details='',tour_inclusive='<br/>',tour_exclusive=',<br/>',meeting_point='',tour_dep_point=' ',tour_language='',tour_supplier_phone='',additional_tour_dep_point='',tour_duration='7 hours 0 minutes<br> Start Time: 14:30',arrival_date='2024-01-18',total_adults='2',total_children='',total_infants='1',gta_city_code='828',supplier_id='',pick_up_point='',drop_off_point='',from_slot='',to_slot='',total_adult_rate='',total_child_rate='',adult_rate='',child_rate='',display_total_adult_rate='',display_total_child_rate='',display_adult_rate='',display_child_rate='0',additional_service_rate='0',booking_remark='',emergency_cont_no='',terms_n_condition='';
[01/15/2024 02:44:23], [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','1614','2024-01-15 14:44:23',0);
[01/15/2024 02:45:51], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-15 02:45:51' WHERE id= '297';
[01/15/2024 02:45:51], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO bookings set reservation_id='1614',agent_id='7851',leader_title='Mr',leader_first_name='Sasa',leader_last_name='sas',city_id='dubai',country_id='138',nationality='Emirati',display_room_rate='99.28',display_currency_code='USD',native_room_rate='99.28',consultant_id='SUJAY_QTECH',native_currency_code='USD',cancellation_policy='Cancellation Charges will be applicable if cancelled after 03 Dec 2023 12:00 hrs.<BR>Late amendment charge may apply.<Br><Br><B><U>Detailed Cancellation Policy:</U></B><Br>99.28 USDCharges - 100% applicable from time of Booking (Full Cancellation Charges applicable immediately)',current_status='inprocess-booking',booking_status='1',sales_manager_id='0',create_date='2024-01-15 14:45:51',source_type='viator',expiration_date= '2023-12-03 09:00:00',applied_multiplier='1.00000',applied_markup='0',agent_markup='0',basecurrency_multiplier='1.00000',basecurrency_multiplier_native='1.00000',admin_booked='0',service_date='2024-01-18',sub_user_id='',check_out_date='2024-01-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';
[01/15/2024 02:45:51], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO sight_bookings set booking_id='172',native_nightly_rates='a:2:{s:4:\"size\";i:1;s:17:\"nativeNightlyRate\";d:99.280000000000001;}',rate_description='',display_nightly_rates='a:4:{s:4:\"size\";i:1;s:18:\"displayNightlyRate\";d:99.280000000000001;s:25:\"displayNightlyRateDisplay\";s:133:\"Rate - 99.28 USD, Currency Multiplier (USD-USD) - 1.00000, Markup  in % - %, Markup Amount - , Markup Amount in  - ,Other Markup - 0%\";s:23:\"displayNightlyRateStore\";s:134:\"Rate - 99.28 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='386596P1',sight_name='DESERT SAFARI, 60-MIN SELF-DRIVE ATV, CAMEL RIDE, SHOWS, DINNER- V2',tour_time='',tour_details='',tour_inclusive='<br/>',tour_exclusive=',<br/>',meeting_point='',tour_dep_point=' ',tour_language='',tour_supplier_phone='',additional_tour_dep_point='',tour_duration='7 hours 0 minutes<br> Start Time: 14:30',arrival_date='2024-01-18',total_adults='2',total_children='',total_infants='1',gta_city_code='828',supplier_id='',pick_up_point='',drop_off_point='',from_slot='',to_slot='',total_adult_rate='',total_child_rate='',adult_rate='',child_rate='',display_total_adult_rate='',display_total_child_rate='',display_adult_rate='',display_child_rate='0',additional_service_rate='0',booking_remark='',emergency_cont_no='',terms_n_condition='';
[01/15/2024 02:45:51], [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','1614','2024-01-15 14:45:51',0);
[01/15/2024 02:56:07], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-15 02:56:07' WHERE id= '297';
[01/15/2024 02:56:07], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO bookings set reservation_id='1614',agent_id='7851',leader_title='Mr',leader_first_name='Sasa',leader_last_name='sas',city_id='dubai',country_id='138',nationality='Emirati',display_room_rate='99.28',display_currency_code='USD',native_room_rate='99.28',consultant_id='SUJAY_QTECH',native_currency_code='USD',cancellation_policy='Cancellation Charges will be applicable if cancelled after 03 Dec 2023 12:00 hrs.<BR>Late amendment charge may apply.<Br><Br><B><U>Detailed Cancellation Policy:</U></B><Br>99.28 USDCharges - 100% applicable from time of Booking (Full Cancellation Charges applicable immediately)',current_status='inprocess-booking',booking_status='1',sales_manager_id='0',create_date='2024-01-15 14:56:07',source_type='viator',expiration_date= '2023-12-03 09:00:00',applied_multiplier='1.00000',applied_markup='0',agent_markup='0',basecurrency_multiplier='1.00000',basecurrency_multiplier_native='1.00000',admin_booked='0',service_date='2024-01-18',sub_user_id='',check_out_date='2024-01-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';
[01/15/2024 02:56:07], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO sight_bookings set booking_id='173',native_nightly_rates='a:2:{s:4:\"size\";i:1;s:17:\"nativeNightlyRate\";d:99.280000000000001;}',rate_description='',display_nightly_rates='a:4:{s:4:\"size\";i:1;s:18:\"displayNightlyRate\";d:99.280000000000001;s:25:\"displayNightlyRateDisplay\";s:133:\"Rate - 99.28 USD, Currency Multiplier (USD-USD) - 1.00000, Markup  in % - %, Markup Amount - , Markup Amount in  - ,Other Markup - 0%\";s:23:\"displayNightlyRateStore\";s:134:\"Rate - 99.28 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='386596P1',sight_name='DESERT SAFARI, 60-MIN SELF-DRIVE ATV, CAMEL RIDE, SHOWS, DINNER- V2',tour_time='',tour_details='',tour_inclusive='<br/>',tour_exclusive=',<br/>',meeting_point='',tour_dep_point=' ',tour_language='',tour_supplier_phone='',additional_tour_dep_point='',tour_duration='7 hours 0 minutes<br> Start Time: 14:30',arrival_date='2024-01-18',total_adults='2',total_children='',total_infants='1',gta_city_code='828',supplier_id='',pick_up_point='',drop_off_point='',from_slot='',to_slot='',total_adult_rate='',total_child_rate='',adult_rate='',child_rate='',display_total_adult_rate='',display_total_child_rate='',display_adult_rate='',display_child_rate='0',additional_service_rate='0',booking_remark='',emergency_cont_no='',terms_n_condition='';
[01/15/2024 02:56:07], [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','1614','2024-01-15 14:56:07',0);
