[01/04/2024 09:14:30], [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/04/2024 09:14:30], [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/04/2024 09:14:30], [file name :-/home/otrams/public_html/beta/tms/supplier_profile/supplier_profile.php],update supplier_profiles SET modify_by = 'v3alpha',modify_date = '2024-01-04 09:14:30' where supplier_id= 'viator'  and supplier_profile_id= '13';
[01/04/2024 09:14:30], [file name :-/home/otrams/public_html/beta/tms/supplier_profile/supplier_profile.php],delete from supplier_profiles_countries  where supplier_profile_id= ?;
[01/04/2024 09:14:30], [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/04/2024 09:14:30], [file name :-/home/otrams/public_html/beta/tms/supplier_profile/supplier_profile.php],delete from supplier_profiles_access  where supplier_profile_id= ? ;
[01/04/2024 09:14:30], [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/04/2024 09:14:30], [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/04/2024 09:14:30], [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/04/2024 09:14:30], [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/04/2024 09:14:30], [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/04/2024 09:14:30], [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/04/2024 09:14:30], [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/04/2024 09:14:30], [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/04/2024 09:14:30], [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/04/2024 09:14:30], [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/04/2024 09:14:30], [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/04/2024 09:14:30], [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/04/2024 09:14:30], [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/04/2024 09:14:30], [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 = 'VVNSM2xha2s4M1RaaTZZdzMrViswcTVHdFd5YnFmekg3eitzVjBhT2cvRzhFS1EwOCtRYVNWbS9vYlFUM0N3QQ==' ;
[01/04/2024 09:14:30], [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/04/2024 09:14:30], [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/04/2024 09:14:30], [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/04/2024 09:14:30], [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/04/2024 09:14:30], [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 = 'ZUFyV3lMT2Juc3RKZEEzTmNkT3pUQT09' ;
[01/04/2024 09:14:30], [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/04/2024 09:14:30], [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/04/2024 09:14:30], [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/04/2024 09:14:30], [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/04/2024 09:14:30], [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/04/2024 09:14:30], [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/04/2024 09:14:30], [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/04/2024 09:14:30], [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/04/2024 09:21:08], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-04 09:21:08',login_attempt=0 where id = '7857';
[01/04/2024 09:21:08], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Deepak_T', user_type = 'A', branch_id = '23', login_datetime = '2024-01-04 09:21:08', ip = '43.239.53.130', action = 'Login' ;
[01/04/2024 09:21:08], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-04 09:21:08' WHERE id= '247';
[01/04/2024 09:21:11], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-04 09:21:11' WHERE id= '247';
[01/04/2024 09:21:15], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-04 09:21:15' WHERE id= '247';
[01/04/2024 09:21:29], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-04 09:21:29' WHERE id= '247';
[01/04/2024 09:21:29], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7857' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '23' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/01/07',  departure_date='2024/01/07',  nights='1',  create_date='2024-01-04 :09:21:29',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/04/2024 09:21:29], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'v1/04_01_2024/request_availability_Deepak_T_09_21_29_1704360089.json', 'v1/04_01_2024/response_availability_Deepak_T_09_21_29_1704360089.json', 'v1/04_01_2024/response_header_availability_Deepak_T_09_21_29_1704360089.json', 'viator', '2024-01-04 09:21:29', '', '', '559');
[01/04/2024 09:21:30], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-04 09:21:30' WHERE id= '247';
[01/04/2024 09:21:31], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-04 09:21:31' WHERE id= '247';
[01/04/2024 09:21:33], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-04 09:21:33' WHERE id= '247';
[01/04/2024 09:21: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/04_01_2024/request_sight_details_Deepak_T_09_21_33_1704360093.json', 'v1/04_01_2024/response_sight_details_Deepak_T_09_21_33_1704360093.json', 'v1/04_01_2024/response_header_sight_details_Deepak_T_09_21_33_1704360093.json', 'viator', '2024-01-04 09:21:33', '', '', '559');
[01/04/2024 09:21: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 ('', 'valuation', 'v1/04_01_2024/request_valuation_Deepak_T_09_21_33_1704360093.json', 'v1/04_01_2024/response_valuation_Deepak_T_09_21_33_1704360093.json', 'v1/04_01_2024/response_header_valuation_Deepak_T_09_21_33_1704360093.json', 'viator', '2024-01-04 09:21:33', '', '', '559');
[01/04/2024 09:22:54], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-04 09:22:54' WHERE id= '247';
[01/04/2024 09:23:01], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-04 09:23:01' WHERE id= '247';
[01/04/2024 09:24:53], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-04 09:24:53' WHERE id= '247';
[01/04/2024 09:31:14], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-04 09:31:14' WHERE id= '247';
[01/04/2024 09:32:37], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-04 09:32:37' WHERE id= '247';
[01/04/2024 09:32: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/04_01_2024/request_sight_details_Deepak_T_09_32_37_1704360757.json', 'v1/04_01_2024/response_sight_details_Deepak_T_09_32_37_1704360757.json', 'v1/04_01_2024/response_header_sight_details_Deepak_T_09_32_37_1704360757.json', 'viator', '2024-01-04 09:32:37', '', '', '559');
[01/04/2024 09:33:22], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-04 09:33:22' WHERE id= '247';
[01/04/2024 09:33: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/04_01_2024/request_sight_details_Deepak_T_09_33_22_1704360802.json', 'v1/04_01_2024/response_sight_details_Deepak_T_09_33_22_1704360802.json', 'v1/04_01_2024/response_header_sight_details_Deepak_T_09_33_22_1704360802.json', 'viator', '2024-01-04 09:33:22', '', '', '559');
[01/04/2024 09:33:33], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-04 09:33:33' WHERE id= '247';
[01/04/2024 09:33:33], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7857' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '23' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/01/07',  departure_date='2024/01/07',  nights='1',  create_date='2024-01-04 :09:33:33',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/04/2024 09:33:33], [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/04_01_2024/request_availability_Deepak_T_09_33_33_1704360813.json', 'v1/04_01_2024/response_availability_Deepak_T_09_33_33_1704360813.json', 'v1/04_01_2024/response_header_availability_Deepak_T_09_33_33_1704360813.json', 'viator', '2024-01-04 09:33:33', '', '', '560');
[01/04/2024 09:33:35], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-04 09:33:35' WHERE id= '247';
[01/04/2024 09:33:35], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-04 09:33:35' WHERE id= '247';
[01/04/2024 09:33:37], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-04 09:33:37' WHERE id= '247';
[01/04/2024 09:33: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/04_01_2024/request_sight_details_Deepak_T_09_33_37_1704360817.json', 'v1/04_01_2024/response_sight_details_Deepak_T_09_33_37_1704360817.json', 'v1/04_01_2024/response_header_sight_details_Deepak_T_09_33_37_1704360817.json', 'viator', '2024-01-04 09:33:37', '', '', '560');
[01/04/2024 09:39:03], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-04 09:39:03' WHERE id= '247';
[01/04/2024 09:39:03], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7857' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '23' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/01/07',  departure_date='2024/01/07',  nights='1',  create_date='2024-01-04 :09:39:03',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/04/2024 09:39:03], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'v1/04_01_2024/request_availability_Deepak_T_09_39_03_1704361143.json', 'v1/04_01_2024/response_availability_Deepak_T_09_39_03_1704361143.json', 'v1/04_01_2024/response_header_availability_Deepak_T_09_39_03_1704361143.json', 'viator', '2024-01-04 09:39:03', '', '', '561');
[01/04/2024 09:39:05], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-04 09:39:05' WHERE id= '247';
[01/04/2024 09:39:05], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-04 09:39:05' WHERE id= '247';
[01/04/2024 09:39:08], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-04 09:39:08' WHERE id= '247';
[01/04/2024 09:39:08], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/04_01_2024/request_sight_details_Deepak_T_09_39_08_1704361148.json', 'v1/04_01_2024/response_sight_details_Deepak_T_09_39_08_1704361148.json', 'v1/04_01_2024/response_header_sight_details_Deepak_T_09_39_08_1704361148.json', 'viator', '2024-01-04 09:39:08', '', '', '561');
[01/04/2024 09:42:32], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-04 09:42:32' WHERE id= '247';
[01/04/2024 09:42: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/04_01_2024/request_sight_details_Deepak_T_09_42_32_1704361352.json', 'v1/04_01_2024/response_sight_details_Deepak_T_09_42_32_1704361352.json', 'v1/04_01_2024/response_header_sight_details_Deepak_T_09_42_32_1704361352.json', 'viator', '2024-01-04 09:42:32', '', '', '561');
[01/04/2024 09:44:50], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-04 09:44:50' WHERE id= '247';
[01/04/2024 09:44: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/04_01_2024/request_sight_details_Deepak_T_09_44_50_1704361490.json', 'v1/04_01_2024/response_sight_details_Deepak_T_09_44_50_1704361490.json', 'v1/04_01_2024/response_header_sight_details_Deepak_T_09_44_50_1704361490.json', 'viator', '2024-01-04 09:44:51', '', '', '561');
[01/04/2024 09:46:39], [file name :-/home/otrams/public_html/beta/logout.php],UPDATE user_sessions_ip SET update_date = '2024-01-04 09:46:39' WHERE id= '247';
[01/04/2024 09:46:45], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-04 09:46:45',login_attempt=0 where id = '7857';
[01/04/2024 09:46:45], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Deepak_T', user_type = 'A', branch_id = '23', login_datetime = '2024-01-04 09:46:45', ip = '43.239.53.130', action = 'Login' ;
[01/04/2024 09:46:46], [file name :-/home/otrams/public_html/beta/hotel_search.php],insert into user_sessions_ip SET ip_addr='43.239.53.130', agent_id='7857', session_id='a4fd16ae802f12b26b33079d6b72a3bcd0f1711c44107dcead5a51b7c9e0c510',create_date='2024-01-04 09:46:46', update_date='2024-01-04 09:46:46',domain='beta.astrabookings.com',sub_agent_id='',sub_user_id='';
[01/04/2024 09:46:48], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-04 09:46:48' WHERE id= '259';
[01/04/2024 09:46:52], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-04 09:46:52' WHERE id= '259';
[01/04/2024 09:46:56], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-04 09:46:56' WHERE id= '259';
[01/04/2024 09:46:56], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7857' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '23' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/01/08',  departure_date='2024/01/08',  nights='1',  create_date='2024-01-04 :09:46:56',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/04/2024 09:46: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/04_01_2024/request_availability_Deepak_T_09_46_56_1704361616.json', 'v1/04_01_2024/response_availability_Deepak_T_09_46_56_1704361616.json', 'v1/04_01_2024/response_header_availability_Deepak_T_09_46_56_1704361616.json', 'viator', '2024-01-04 09:46:58', '', '', '562');
[01/04/2024 09:47:00], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-04 09:47:00' WHERE id= '259';
[01/04/2024 09:47:00], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-04 09:47:00' WHERE id= '259';
[01/04/2024 09:47:42], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-04 09:47:42' WHERE id= '259';
[01/04/2024 09:47: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/04_01_2024/request_sight_details_Deepak_T_09_47_42_1704361662.json', 'v1/04_01_2024/response_sight_details_Deepak_T_09_47_42_1704361662.json', 'v1/04_01_2024/response_header_sight_details_Deepak_T_09_47_42_1704361662.json', 'viator', '2024-01-04 09:47:42', '', '', '562');
[01/04/2024 09:50:25], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-04 09:50:25' WHERE id= '259';
[01/04/2024 09:50: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/04_01_2024/request_sight_details_Deepak_T_09_50_25_1704361825.json', 'v1/04_01_2024/response_sight_details_Deepak_T_09_50_25_1704361825.json', 'v1/04_01_2024/response_header_sight_details_Deepak_T_09_50_25_1704361825.json', 'viator', '2024-01-04 09:50:26', '', '', '562');
[01/04/2024 09:51:04], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-04 09:51:04' WHERE id= '259';
[01/04/2024 09:51: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/04_01_2024/request_sight_details_Deepak_T_09_51_04_1704361864.json', 'v1/04_01_2024/response_sight_details_Deepak_T_09_51_04_1704361864.json', 'v1/04_01_2024/response_header_sight_details_Deepak_T_09_51_04_1704361864.json', 'viator', '2024-01-04 09:51:05', '', '', '562');
[01/04/2024 09:51:22], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-04 09:51:22' WHERE id= '259';
[01/04/2024 09:52:53], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-04 09:52:53' WHERE id= '259';
[01/04/2024 09:52:54], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/04_01_2024/request_sight_details_Deepak_T_09_52_53_1704361973.json', 'v1/04_01_2024/response_sight_details_Deepak_T_09_52_53_1704361973.json', 'v1/04_01_2024/response_header_sight_details_Deepak_T_09_52_53_1704361973.json', 'viator', '2024-01-04 09:52:54', '', '', '562');
[01/04/2024 09:53:04], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-04 09:53:04' WHERE id= '259';
[01/04/2024 09:54:11], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-04 09:54:11' WHERE id= '259';
[01/04/2024 09:54:20], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-04 09:54:20' WHERE id= '259';
[01/04/2024 09:54:28], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-04 09:54:28' WHERE id= '259';
[01/04/2024 09:54: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/04_01_2024/request_sight_details_Deepak_T_09_54_28_1704362068.json', 'v1/04_01_2024/response_sight_details_Deepak_T_09_54_28_1704362068.json', 'v1/04_01_2024/response_header_sight_details_Deepak_T_09_54_28_1704362068.json', 'viator', '2024-01-04 09:54:28', '', '', '562');
