[01/30/2024 10:00:48], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:00:48' WHERE id= '470';
[01/30/2024 10:01:24], [file name :-/home/otrams/public_html/beta/tms/user.php],update psa_users set active='N' where id='hotelyards';
[01/30/2024 10:01:24], [file name :-/home/otrams/public_html/beta/tms/user.php],insert into `user_logs` set `username`= 'v3alpha',`create_date`= '2024-01-30 10:01:24',`log_type`= 'User Deactivated',`sql_query`= 'update psa_users set active=\&#039;N\&#039; where id=\&#039;hotelyards\&#039;',`log_description`= 'User hotelyards Deactivated',`ip`= '43.239.53.130';
[01/30/2024 10:01:27], [file name :-/home/otrams/public_html/beta/tms/user.php],update psa_users set active='Y' where id='hotelyards';
[01/30/2024 10:01:27], [file name :-/home/otrams/public_html/beta/tms/user.php],insert into `user_logs` set `username`= 'v3alpha',`create_date`= '2024-01-30 10:01:27',`log_type`= 'User Activated',`sql_query`= 'update psa_users set active=\&#039;Y\&#039; where id=\&#039;hotelyards\&#039;',`log_description`= 'User hotelyards Activated',`ip`= '43.239.53.130';
[01/30/2024 10:04:24], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:04:24' WHERE id= '470';
[01/30/2024 10:04:34], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:04:34' WHERE id= '470';
[01/30/2024 10:04:35], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:04:35' WHERE id= '470';
[01/30/2024 10:04:35], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:04:35' WHERE id= '470';
[01/30/2024 10:04:35], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:04:35' WHERE id= '470';
[01/30/2024 10:04:35], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:04:35' WHERE id= '470';
[01/30/2024 10:04:39], [file name :-/home/otrams/public_html/beta/my_accounts.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:04:39' WHERE id= '470';
[01/30/2024 10:04:51], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:04:51' WHERE id= '470';
[01/30/2024 10:05:02], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:05:02' WHERE id= '470';
[01/30/2024 10:05:50], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:05:50' WHERE id= '470';
[01/30/2024 10:06:07], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:06:07' WHERE id= '470';
[01/30/2024 10:06:12], [file name :-/home/otrams/public_html/beta/about_us.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:06:12' WHERE id= '470';
[01/30/2024 10:08:35], [file name :-/home/otrams/public_html/beta/tms/user.php],update  `psa_users` set  `consultant_acc_id` ='', `lname`='whitelabel', `mname`='', `fname`='hotelyards', `email`='gajendra.rajpurohit@qtechsoftware.com', `time_zone_offset`='0', `phone`='9876598765', `messenger_type`='', `messenger_id`='', `user_description`='', `connection`='', `modify_by`='v3alpha', `user_type`='admin', `allow_book_under_cancellation`='1', `allow_cancellation_after_voucher`='1', `is_booking_email_received`='1', `all_bookings`='branch_booking', `designation`='', `updated`='2024-01-30 10:08:35', `modify_date`='2024-01-30 10:08:35'  where `site_id`='' and `id` ='hotelyards' ;
[01/30/2024 10:08:35], [file name :-/home/otrams/public_html/beta/tms/user.php],insert into `user_logs` set `username`= 'v3alpha',`create_date`= '2024-01-30 10:08:35',`log_type`= 'User',`sql_query`= 'update  `psa_users` set  `consultant_acc_id` =:accounting_id, `lname`=:last_name, `mname`=:middle_name, `fname`=:first_name, `email`=:email, `time_zone_offset`=:time_zone_offset, `phone`=:phone, `messenger_type`=:messenger_type, `messenger_id`=:messenger_id, `user_description`=:user_description, `connection`=:connection, `modify_by`=:modify_by, `user_type`=:user_type, `allow_book_under_cancellation`=:allow_book_under_cancellation, `allow_cancellation_after_voucher`=:allow_cancellation_after_voucher, `is_booking_email_received`=:is_booking_email_received, `all_bookings`=:all_bookings, `designation`=:designation, `updated`=:updated, `modify_date`=:modify_date  where `site_id`=:site_id and `id` =:user_id ',`log_description`= 'User hotelyards updated For  - email=email%40hotelyards.com&updated=2024-01-30+18%3A05%3A32 changed to - email=gajendra.rajpurohit%40qtechsoftware.com&updated=2024-01-30+10%3A08%3A35&modify_by=v3alpha&modify_date=2024-01-30+10%3A08%3A35',`ip`= '43.239.53.130';
[01/30/2024 10:08:41], [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/30/2024 10:08:41], [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/30/2024 10:08:41], [file name :-/home/otrams/public_html/beta/tms/supplier_profile/supplier_profile.php],update supplier_profiles SET modify_by = 'v3alpha',modify_date = '2024-01-30 10:08:41' where supplier_id= 'viator'  and supplier_profile_id= '13';
[01/30/2024 10:08:41], [file name :-/home/otrams/public_html/beta/tms/supplier_profile/supplier_profile.php],delete from supplier_profiles_countries  where supplier_profile_id= ?;
[01/30/2024 10:08:41], [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/30/2024 10:08:41], [file name :-/home/otrams/public_html/beta/tms/supplier_profile/supplier_profile.php],delete from supplier_profiles_access  where supplier_profile_id= ? ;
[01/30/2024 10:08:41], [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/30/2024 10:08:41], [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/30/2024 10:08:41], [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/30/2024 10:08:41], [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/30/2024 10:08:41], [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/30/2024 10:08:41], [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/30/2024 10:08:41], [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/30/2024 10:08:41], [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/30/2024 10:08:41], [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/30/2024 10:08:41], [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/30/2024 10:08:41], [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/30/2024 10:08:41], [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/30/2024 10:08:41], [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 = 'MWl3Ri9wY2cxYUJYUi9LY3RnTGdSUT09' ;
[01/30/2024 10:08:41], [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/30/2024 10:08:41], [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/30/2024 10:08:41], [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/30/2024 10:08:41], [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/30/2024 10:08:41], [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/30/2024 10:08:41], [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/30/2024 10:08:41], [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/30/2024 10:08:41], [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/30/2024 10:08:41], [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/30/2024 10:08:41], [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/30/2024 10:08:41], [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/30/2024 10:08:42], [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/30/2024 10:08:42], [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 = 'Z2xuMG1GcTNCMHdwY2wvdHVHbnhqdERTdjhXYUt1ZVlvWlFQUzFlblNQTT0=',key_value = 'ZzNPY1IvN1pPZEZJT0Z4Njh6bElNUVRHb0JSWkhIS0NLZWh6Ymc2RllEcz0=' ;
[01/30/2024 10:08:42], [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/30/2024 10:08:42], [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/30/2024 10:09:06], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-30 10:09:06',login_attempt=0 where id = '7865';
[01/30/2024 10:09:06], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'test_Whitelable', user_type = 'A', branch_id = '31', login_datetime = '2024-01-30 10:09:06', ip = '43.239.53.130', action = 'Login' ;
[01/30/2024 10:09:06], [file name :-/home/otrams/public_html/beta/hotel_search.php],insert into user_sessions_ip SET ip_addr='43.239.53.130', agent_id='7867', session_id='46c187eb5467fd821244efa5486743c76444d860d77e6ce86dbc0eac7f6a35a4',create_date='2024-01-30 10:09:06', update_date='2024-01-30 10:09:06',domain='hotelyards.astrabookings.com',sub_agent_id='',sub_user_id='';
[01/30/2024 10:09:47], [file name :-/home/otrams/public_html/beta/tms/user.php],update psa_users set active='N' where id='hotelyards';
[01/30/2024 10:09:47], [file name :-/home/otrams/public_html/beta/tms/user.php],insert into `user_logs` set `username`= 'v3alpha',`create_date`= '2024-01-30 10:09:47',`log_type`= 'User Deactivated',`sql_query`= 'update psa_users set active=\&#039;N\&#039; where id=\&#039;hotelyards\&#039;',`log_description`= 'User hotelyards Deactivated',`ip`= '43.239.53.130';
[01/30/2024 10:09:49], [file name :-/home/otrams/public_html/beta/tms/user.php],update psa_users set active='Y' where id='hotelyards';
[01/30/2024 10:09:49], [file name :-/home/otrams/public_html/beta/tms/user.php],insert into `user_logs` set `username`= 'v3alpha',`create_date`= '2024-01-30 10:09:49',`log_type`= 'User Activated',`sql_query`= 'update psa_users set active=\&#039;Y\&#039; where id=\&#039;hotelyards\&#039;',`log_description`= 'User hotelyards Activated',`ip`= '43.239.53.130';
[01/30/2024 10:10:23], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:10:23' WHERE id= '472';
[01/30/2024 10:10:29], [file name :-/home/otrams/public_html/beta/logout.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:10:29' WHERE id= '472';
[01/30/2024 10:10:34], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:10:34' WHERE id= '467';
[01/30/2024 10:10:34], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7851' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '27' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/02/08',  departure_date='2024/02/08',  nights='1',  create_date='2024-01-30 :10:10:34',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/30/2024 10:10:36], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'v1/30_01_2024/request_availability_Viator_test_10_10_34_1706609434.json', 'v1/30_01_2024/response_availability_Viator_test_10_10_34_1706609434.json', 'v1/30_01_2024/response_header_availability_Viator_test_10_10_34_1706609434.json', 'viator', '2024-01-30 10:10:36', '', '', '1194');
[01/30/2024 10:10:37], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:10:37' WHERE id= '467';
[01/30/2024 10:10:38], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:10:38' WHERE id= '467';
[01/30/2024 10:10:38], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-30 10:10:38',login_attempt=0 where id = '7865';
[01/30/2024 10:10:38], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'test_Whitelable', user_type = 'A', branch_id = '31', login_datetime = '2024-01-30 10:10:38', ip = '43.239.53.130', action = 'Login' ;
[01/30/2024 10:10:38], [file name :-/home/otrams/public_html/beta/hotel_search.php],insert into user_sessions_ip SET ip_addr='43.239.53.130', agent_id='7867', session_id='7075c0be73ebd8327ccf2823d1e4110a33cf3628b486b22ffe6cb8e1e3c5f17b',create_date='2024-01-30 10:10:38', update_date='2024-01-30 10:10:38',domain='hotelyards.astrabookings.com',sub_agent_id='',sub_user_id='';
[01/30/2024 10:10:39], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:10:39' WHERE id= '467';
[01/30/2024 10:10:40], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/30_01_2024/request_sight_details_Viator_test_10_10_39_1706609439.json', 'v1/30_01_2024/response_sight_details_Viator_test_10_10_39_1706609439.json', 'v1/30_01_2024/response_header_sight_details_Viator_test_10_10_39_1706609439.json', 'viator', '2024-01-30 10:10:40', '', '', '1194');
[01/30/2024 10:12:30], [file name :-/home/otrams/public_html/beta/logout.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:12:30' WHERE id= '473';
[01/30/2024 10:12:43], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:12:43' WHERE id= '467';
[01/30/2024 10:12:43], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7851' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '27' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/02/08',  departure_date='2024/02/08',  nights='1',  create_date='2024-01-30 :10:12:43',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/30/2024 10:12:47], [file name :-/home/otrams/public_html/beta/tms/logout.php],INSERT INTO psa_login_log set username = 'Ayman' , user_type = 'Ayman'_type , branch_id = '31' , login_datetime = '2024-01-30 10:12:47' , ip = '43.239.53.130' , action = 'Logout'  ;
[01/30/2024 10:13:07], [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/30_01_2024/request_availability_Viator_test_10_12_43_1706609563.json', 'v1/30_01_2024/response_availability_Viator_test_10_12_43_1706609563.json', 'v1/30_01_2024/response_header_availability_Viator_test_10_12_43_1706609563.json', 'viator', '2024-01-30 10:13:07', '', '', '1195');
[01/30/2024 10:13:08], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:13:08' WHERE id= '467';
[01/30/2024 10:13:09], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:13:09' WHERE id= '467';
[01/30/2024 10:13:34], [file name :-/home/otrams/public_html/beta/tms/logout.php],INSERT INTO psa_login_log set username = 'Ayman' , user_type = 'Ayman'_type , branch_id = '31' , login_datetime = '2024-01-30 10:13:34' , ip = '43.239.53.130' , action = 'Logout'  ;
[01/30/2024 10:18:17], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-30 10:18:17',login_attempt=0 where id = '7866';
[01/30/2024 10:18:17], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'deepak_qtech', user_type = 'A', branch_id = '31', login_datetime = '2024-01-30 10:18:17', ip = '43.239.53.130', action = 'Login' ;
[01/30/2024 10:18:17], [file name :-/home/otrams/public_html/beta/hotel_search.php],insert into user_sessions_ip SET ip_addr='43.239.53.130', agent_id='7867', session_id='5e399b99e724c593fad91a9d79b3ecc37dfd462479ed061b567060eaa8adcc99',create_date='2024-01-30 10:18:17', update_date='2024-01-30 10:18:17',domain='hotelyards.astrabookings.com',sub_agent_id='',sub_user_id='';
[01/30/2024 10:19:58], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:19:58' WHERE id= '467';
[01/30/2024 10:19:58], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/30_01_2024/request_sight_details_Viator_test_10_19_58_1706609998.json', 'v1/30_01_2024/response_sight_details_Viator_test_10_19_58_1706609998.json', 'v1/30_01_2024/response_header_sight_details_Viator_test_10_19_58_1706609998.json', 'viator', '2024-01-30 10:19:58', '', '', '1195');
[01/30/2024 10:22:28], [file name :-/home/otrams/public_html/beta/tms/agent.php],UPDATE agents SET agency_name= 'qtech',other_language_agency_name= '',accounting_name= '',first_name= 'hotelyards',middle_name= '',last_name= 'whitelabel',agent_type= 'CC',sort_type= 'price',credit_limit_assigned= '6666666.000',credit_limit= '6666666.000',credit_distribution= '0',temp_credit_limit= '',address= 'address lane 1',other_language_address= '',city= '64440',pincode= '',country= '106',time_zone_offset= '-12',enable_dst= '',branch_id='32',phone= '91-9876598765',mobile= '91-9876598765',fax= '',currency= '6',email= 'gajendra.rajpurohit@qtechsoftware.com',website= '',lead_time= '',search_by_multicurrency= '1',debug= '',profile= '',designation= '',iata_status= '0',iata_number= '',nature_of_business= '0',can_book= '1',sales_manager_id= '',comp_reg_no= 'Hotel Yards',allow_quotation= '1',can_voucher= '1',markup= '0.5',allow_book_under_cancellation='1',modify_date='2024-01-30 10:22:28',consultant_id= 'hotelyards',agency_email= '',acc_name= 'HOTEL YARDS',acc_email= 'email@hotelyards.com',acc_phone= '',man_name= '',man_email= '',man_phone= '',res_name= '',res_email= '',res_phone= '',remarks= '',apply_service_tax= 'no',allow_ticketing= '1' WHERE id= '7868';
[01/30/2024 10:22:28], [file name :-/home/otrams/public_html/beta/tms/agent.php],insert into `user_logs` set `username`= 'hotelyards',`create_date`= '2024-01-30 10:22:28',`log_type`= 'Agent Updated',`sql_query`= 'UPDATE agents SET agency_name= \&#039;qtech\&#039;,other_language_agency_name= \&#039;\&#039;,accounting_name= \&#039;\&#039;,first_name= \&#039;hotelyards\&#039;,middle_name= \&#039;\&#039;,last_name= \&#039;whitelabel\&#039;,agent_type= \&#039;CC\&#039;,sort_type= \&#039;price\&#039;,credit_limit_assigned= \&#039;6666666.000\&#039;,credit_limit= \&#039;6666666.000\&#039;,credit_distribution= \&#039;0\&#039;,temp_credit_limit= \&#039;\&#039;,address= \&#039;address lane 1\&#039;,other_language_address= \&#039;\&#039;,city= \&#039;64440\&#039;,pincode= \&#039;\&#039;,country= \&#039;106\&#039;,time_zone_offset= \&#039;-12\&#039;,enable_dst= 0,branch_id=\&#039;32\&#039;,phone= \&#039;91-9876598765\&#039;,mobile= \&#039;91-9876598765\&#039;,fax= \&#039;\&#039;,currency= \&#039;6\&#039;,email= \&#039;gajendra.rajpurohit@qtechsoftware.com\&#039;,website= \&#039;\&#039;,lead_time= 0,search_by_multicurrency= \&#039;1\&#039;,debug= 0,profile= \&#039;\&#039;,designation= \&#039;\&#039;,iata_status= \&#039;0\&#039;,iata_number= \&#039;\&#039;,nature_of_business= \&#039;0\&#039;,can_book= \&#039;1\&#039;,sales_manager_id= ,comp_reg_no= \&#039;Hotel Yards\&#039;,allow_quotation= \&#039;1\&#039;,can_voucher= \&#039;1\&#039;,markup= \&#039;0.5\&#039;,allow_book_under_cancellation=\&#039;1\&#039;,modify_date=\&#039;2024-01-30 10:22:28\&#039;,consultant_id= \&#039;hotelyards\&#039;,agency_email= \&#039;\&#039;,acc_name= \&#039;HOTEL YARDS\&#039;,acc_email= \&#039;email@hotelyards.com\&#039;,acc_phone= \&#039;\&#039;,man_name= \&#039;\&#039;,man_email= \&#039;\&#039;,man_phone= \&#039;\&#039;,res_name= \&#039;\&#039;,res_email= \&#039;\&#039;,res_phone= \&#039;\&#039;,remarks= ,apply_service_tax= \&#039;no\&#039;,allow_ticketing= 1 WHERE id= \&#039;7868\&#039;',`log_description`= 'Agent 7868 updated For  - modify_date=2024-01-25+12%3A53%3A02&branch_id=1 changed to - modify_date=2024-01-30+10%3A22%3A28&branch_id=32',`ip`= '43.239.53.130';
[01/30/2024 10:22:28], [file name :-/home/otrams/public_html/beta/tms/agent.php],UPDATE agents SET cd_credit_limit=credit_limit-'7868' , cd_credit_value=cd_credit_limit-cd_credit_usage WHERE id= ?;
[01/30/2024 10:22:28], [file name :-/home/otrams/public_html/beta/tms/agent.php],insert into  agent_credit_log SET agent_id= '7868',credit_value= '6665898.620',credit_usage= '767.380',credit_limit= '6666666.000',receipt_id= '',amount= '',ip='43.239.53.130',user_type='admin',admin_id='hotelyards',temp_credit_limit='',log_type='Edit_Agent',note='Agent Edited by hotelyards',create_date='2024-01-30 10:01:28';
[01/30/2024 10:22:28], [file name :-/home/otrams/public_html/beta/tms/agent.php],UPDATE agents SET currency= '6',branch_id= '32',consultant_id= 'hotelyards',sales_manager_id= '',profile= '', agent_type= 'CC' WHERE parent_agent= '7868';
[01/30/2024 10:23:40], [file name :-/home/otrams/public_html/beta/tms/agent.php],DELETE FROM agent_supplier_settings WHERE 1  and agent_id= ? ;
[01/30/2024 10:23:40], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7849',supplier_id = '67' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/30/2024 10:23:40], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7849',supplier_id = '52' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/30/2024 10:23:40], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7849',supplier_id = '76' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/30/2024 10:23:40], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7849',supplier_id = '24' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/30/2024 10:23:40], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7849',supplier_id = '77' ,status = '1' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/30/2024 10:23:40], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7849',supplier_id = '64' ,status = '1' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/30/2024 10:23:40], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7849',supplier_id = '65' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/30/2024 10:23:40], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7849',supplier_id = '34' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/30/2024 10:23:40], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7849',supplier_id = '20' ,status = '1' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/30/2024 10:23:40], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7849',supplier_id = '55' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/30/2024 10:23:40], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7849',supplier_id = '62' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/30/2024 10:23:40], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7849',supplier_id = '53' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/30/2024 10:23:40], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7849',supplier_id = '16' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/30/2024 10:23:40], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7849',supplier_id = '75' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/30/2024 10:23:40], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7849',supplier_id = '60' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/30/2024 10:23:40], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7849',supplier_id = '18' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/30/2024 10:23:40], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7849',supplier_id = '19' ,status = '1' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/30/2024 10:23:40], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7849',supplier_id = '73' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/30/2024 10:23:40], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7849',supplier_id = '71' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/30/2024 10:23:40], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7849',supplier_id = '69' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/30/2024 10:23:40], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7849',supplier_id = '68' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/30/2024 10:23:40], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7849',supplier_id = '74' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/30/2024 10:23:40], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7849',supplier_id = '35' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/30/2024 10:23:40], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7849',supplier_id = '70' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/30/2024 10:23:40], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7849',supplier_id = '59' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/30/2024 10:23:40], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7849',supplier_id = '32' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/30/2024 10:23:40], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7849',supplier_id = '58' ,status = '1' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/30/2024 10:23:40], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7849',supplier_id = '56' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/30/2024 10:23:40], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7849',supplier_id = '57' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/30/2024 10:23:40], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7849',supplier_id = '61' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/30/2024 10:23:40], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7849',supplier_id = '63' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/30/2024 10:23:40], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7849',supplier_id = '54' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/30/2024 10:23:40], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7849',supplier_id = '66' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/30/2024 10:23:40], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7849',supplier_id = '45' ,status = '' ,priority = '' ,lead_time = '',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/30/2024 10:23:40], [file name :-/home/otrams/public_html/beta/tms/agent.php],insert into `user_logs` set `username`= 'v3alpha',`create_date`= '2024-01-30 10:23:40',`log_type`= 'Agent Supplier settings',`sql_query`= '======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7849\&#039;,supplier_id = 67 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7849\&#039;,supplier_id = 52 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7849\&#039;,supplier_id = 76 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7849\&#039;,supplier_id = 24 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7849\&#039;,supplier_id = 77 ,status = \&#039;1\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7849\&#039;,supplier_id = 64 ,status = \&#039;1\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7849\&#039;,supplier_id = 65 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7849\&#039;,supplier_id = 34 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7849\&#039;,supplier_id = 20 ,status = \&#039;1\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7849\&#039;,supplier_id = 55 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7849\&#039;,supplier_id = 62 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7849\&#039;,supplier_id = 53 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7849\&#039;,supplier_id = 16 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7849\&#039;,supplier_id = 75 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7849\&#039;,supplier_id = 60 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7849\&#039;,supplier_id = 18 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7849\&#039;,supplier_id = 19 ,status = \&#039;1\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7849\&#039;,supplier_id = 73 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7849\&#039;,supplier_id = 71 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7849\&#039;,supplier_id = 69 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7849\&#039;,supplier_id = 68 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7849\&#039;,supplier_id = 74 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7849\&#039;,supplier_id = 35 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7849\&#039;,supplier_id = 70 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7849\&#039;,supplier_id = 59 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7849\&#039;,supplier_id = 32 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7849\&#039;,supplier_id = 58 ,status = \&#039;1\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7849\&#039;,supplier_id = 56 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7849\&#039;,supplier_id = 57 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7849\&#039;,supplier_id = 61 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7849\&#039;,supplier_id = 63 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7849\&#039;,supplier_id = 54 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7849\&#039;,supplier_id = 66 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7849\&#039;,supplier_id = 45 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = ,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;',`log_description`= 'Supplier setting updated  Previous data-- agent_id-7849 ## supplier_id- 77 ## company_name - Ebooking Center ## supplier_code-ebookingcenter  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-7849 ## supplier_id- 64 ## company_name - Expedia ## supplier_code-expedia  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-7849 ## supplier_id- 20 ## company_name - Hotelbeds ## supplier_code-hotelbeds  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-7849 ## supplier_id- 19 ## company_name - Travco ## supplier_code-travco  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-7849 ## supplier_id- 58 ## company_name - Viator (SightSeeing) ## supplier_code-viator  ## percentage - 0.00 ## lead_time - 0 ',`ip`= '43.239.53.130';
[01/30/2024 10:23:44], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:23:44' WHERE id= '467';
[01/30/2024 10:23:44], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-30 10:23:44',login_attempt=0 where id = '7849';
[01/30/2024 10:23:44], [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-01-30 10:23:44', ip = '43.239.53.130', action = 'Login' ;
[01/30/2024 10:23:44], [file name :-/home/otrams/public_html/beta/tms/logout.php],INSERT INTO psa_login_log set username = 'hotelyards' , user_type = 'hotelyards'_type , branch_id = '32' , login_datetime = '2024-01-30 10:23:44' , ip = '43.239.53.130' , action = 'Logout'  ;
[01/30/2024 10:23:44], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:23:44' WHERE id= '467';
[01/30/2024 10:23:47], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:23:47' WHERE id= '467';
[01/30/2024 10:23:50], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:23:50' WHERE id= '467';
[01/30/2024 10:23:56], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:23:56' WHERE id= '467';
[01/30/2024 10:23:56], [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/09',  departure_date='2024/02/09',  nights='1',  create_date='2024-01-30 :10:23:56',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/30/2024 10:24:23], [file name :-/home/otrams/public_html/beta/about_us.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:24:23' WHERE id= '474';
[01/30/2024 10:24:26], [file name :-/home/otrams/public_html/beta/about_us.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:24:26' WHERE id= '474';
[01/30/2024 10:24:26], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:24:26' WHERE id= '467';

[01/30/2024 10:26:50], [file name :-/home/otrams/public_html/beta/tms/agent.php],UPDATE agents SET cd_credit_limit=credit_limit-'7870' , expiry_date = '2'7870'24-'7870'4-29 1'7870':26:5'7870'',cd_credit_value=cd_credit_limit-cd_credit_usage WHERE id= ? and site_id = '21';
[01/30/2024 10:27:30], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-30 10:27:30',login_attempt=0 where id = '7870';
[01/30/2024 10:27:30], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'hotelyards-agent', user_type = 'A', branch_id = '32', login_datetime = '2024-01-30 10:27:30', ip = '43.239.53.130', action = 'Login' ;
[01/30/2024 10:27:30], [file name :-/home/otrams/public_html/beta/hotel_search.php],insert into user_sessions_ip SET ip_addr='43.239.53.130', agent_id='7867', session_id='68e8702fa073888bfa32d912cb60e1b5cc531c4a7c609bcfbe9f01378039ec27',create_date='2024-01-30 10:27:30', update_date='2024-01-30 10:27:30',domain='hotelyards.astrabookings.com',sub_agent_id='',sub_user_id='';
[01/30/2024 10:27:46], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:27:46' WHERE id= '474';
[01/30/2024 10:27:58], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:27:58' WHERE id= '474';
[01/30/2024 10:29:08], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:29:08' WHERE id= '474';
[01/30/2024 10:29:28], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:29:28' WHERE id= '475';
[01/30/2024 10:30:12], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:30:12' WHERE id= '475';
[01/30/2024 10:31:08], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:31:08' WHERE id= '467';
[01/30/2024 10:31:08], [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/09',  departure_date='2024/02/09',  nights='1',  create_date='2024-01-30 :10:31:08',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/30/2024 10:31:08], [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/30_01_2024/request_availability_shiv_qtech_10_31_08_1706610668.json', 'v1/30_01_2024/response_availability_shiv_qtech_10_31_08_1706610668.json', 'v1/30_01_2024/response_header_availability_shiv_qtech_10_31_08_1706610668.json', 'viator', '2024-01-30 10:31:08', '', '', '1197');
[01/30/2024 10:31:09], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:31:09' WHERE id= '467';
[01/30/2024 10:31:10], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:31:10' WHERE id= '467';
[01/30/2024 10:31:15], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:31:15' WHERE id= '467';
[01/30/2024 10:31:16], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/30_01_2024/request_sight_details_shiv_qtech_10_31_15_1706610675.json', 'v1/30_01_2024/response_sight_details_shiv_qtech_10_31_15_1706610675.json', 'v1/30_01_2024/response_header_sight_details_shiv_qtech_10_31_15_1706610675.json', 'viator', '2024-01-30 10:31:16', '', '', '1197');
[01/30/2024 10:31:32], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:31:32' WHERE id= '475';
[01/30/2024 10:32:04], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:32:04' WHERE id= '467';
[01/30/2024 10:32:04], [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/09',  departure_date='2024/02/09',  nights='1',  create_date='2024-01-30 :10:32:04',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/30/2024 10:32:05], [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/30_01_2024/request_availability_shiv_qtech_10_32_04_1706610724.json', 'v1/30_01_2024/response_availability_shiv_qtech_10_32_04_1706610724.json', 'v1/30_01_2024/response_header_availability_shiv_qtech_10_32_04_1706610724.json', 'viator', '2024-01-30 10:32:05', '', '', '1198');
[01/30/2024 10:32:07], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:32:07' WHERE id= '467';
[01/30/2024 10:32:07], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:32:07' WHERE id= '467';
[01/30/2024 10:32:08], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:32:08' WHERE id= '467';
[01/30/2024 10:32:16], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/30_01_2024/request_sight_details_shiv_qtech_10_32_08_1706610728.json', 'v1/30_01_2024/response_sight_details_shiv_qtech_10_32_08_1706610728.json', 'v1/30_01_2024/response_header_sight_details_shiv_qtech_10_32_08_1706610728.json', 'viator', '2024-01-30 10:32:16', '', '', '1198');
[01/30/2024 10:32:42], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:32:42' WHERE id= '467';
[01/30/2024 10:32:42], [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/09',  departure_date='2024/02/09',  nights='1',  create_date='2024-01-30 :10:32:42',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/30/2024 10:32:42], [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/30_01_2024/request_availability_shiv_qtech_10_32_42_1706610762.json', 'v1/30_01_2024/response_availability_shiv_qtech_10_32_42_1706610762.json', 'v1/30_01_2024/response_header_availability_shiv_qtech_10_32_42_1706610762.json', 'viator', '2024-01-30 10:32:42', '', '', '1199');
[01/30/2024 10:32:44], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:32:44' WHERE id= '467';
[01/30/2024 10:32:45], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:32:45' WHERE id= '467';
[01/30/2024 10:32:47], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:32:47' WHERE id= '467';
[01/30/2024 10:32:47], [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/08',  departure_date='2024/02/08',  nights='1',  create_date='2024-01-30 :10:32:47',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/30/2024 10:32:48], [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/30_01_2024/request_availability_shiv_qtech_10_32_47_1706610767.json', 'v1/30_01_2024/response_availability_shiv_qtech_10_32_47_1706610767.json', 'v1/30_01_2024/response_header_availability_shiv_qtech_10_32_47_1706610767.json', 'viator', '2024-01-30 10:32:48', '', '', '1200');
[01/30/2024 10:32:50], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:32:50' WHERE id= '467';
[01/30/2024 10:32:50], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:32:50' WHERE id= '467';
[01/30/2024 10:32:52], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:32:52' WHERE id= '467';
[01/30/2024 10:32: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/30_01_2024/request_sight_details_shiv_qtech_10_32_52_1706610772.json', 'v1/30_01_2024/response_sight_details_shiv_qtech_10_32_52_1706610772.json', 'v1/30_01_2024/response_header_sight_details_shiv_qtech_10_32_52_1706610772.json', 'viator', '2024-01-30 10:32:52', '', '', '1200');
[01/30/2024 10:33:14], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:33:14' WHERE id= '475';
[01/30/2024 10:33:20], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:33:20' WHERE id= '475';
[01/30/2024 10:33:23], [file name :-/home/otrams/public_html/beta/logout.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:33:23' WHERE id= '467';
[01/30/2024 10:33:31], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:33:31' WHERE id= '475';
[01/30/2024 10:33:40], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-30 10:33:40',login_attempt=0 where id = '7851';
[01/30/2024 10:33:40], [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-30 10:33:40', ip = '43.239.53.130', action = 'Login' ;
[01/30/2024 10:33:40], [file name :-/home/otrams/public_html/beta/hotel_search.php],insert into user_sessions_ip SET ip_addr='43.239.53.130', agent_id='7851', session_id='22b63ff5a053a393f488787b4cc250c7cc5a0d5e38128c15f9888c1066538e66',create_date='2024-01-30 10:33:40', update_date='2024-01-30 10:33:40',domain='beta.astrabookings.com',sub_agent_id='',sub_user_id='';
[01/30/2024 10:33:44], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:33:44' WHERE id= '476';
[01/30/2024 10:33:48], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:33:48' WHERE id= '476';
[01/30/2024 10:33:54], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:33:54' WHERE id= '476';
[01/30/2024 10:33:54], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7851' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '27' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/02/07',  departure_date='2024/02/07',  nights='1',  create_date='2024-01-30 :10:33:54',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/30/2024 10:33:55], [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/30_01_2024/request_availability_Viator_test_10_33_54_1706610834.json', 'v1/30_01_2024/response_availability_Viator_test_10_33_54_1706610834.json', 'v1/30_01_2024/response_header_availability_Viator_test_10_33_54_1706610834.json', 'viator', '2024-01-30 10:33:55', '', '', '1201');
[01/30/2024 10:33:57], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:33:57' WHERE id= '476';
[01/30/2024 10:33:57], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:33:57' WHERE id= '476';
[01/30/2024 10:35:13], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:35:13' WHERE id= '476';
[01/30/2024 10:35:13], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/30_01_2024/request_sight_details_Viator_test_10_35_13_1706610913.json', 'v1/30_01_2024/response_sight_details_Viator_test_10_35_13_1706610913.json', 'v1/30_01_2024/response_header_sight_details_Viator_test_10_35_13_1706610913.json', 'viator', '2024-01-30 10:35:13', '', '', '1201');
[01/30/2024 10:35:20], [file name :-/home/otrams/public_html/beta/logout.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:35:20' WHERE id= '476';
[01/30/2024 10:35:34], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-30 10:35:34',login_attempt=0 where id = '7849';
[01/30/2024 10:35:34], [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-01-30 10:35:34', ip = '43.239.53.130', action = 'Login' ;
[01/30/2024 10:35:34], [file name :-/home/otrams/public_html/beta/hotel_search.php],insert into user_sessions_ip SET ip_addr='43.239.53.130', agent_id='7849', session_id='dfa9d40085dfb8cc90673279f30eb450f5a607df3cda2879dcf934d49db35d52',create_date='2024-01-30 10:35:34', update_date='2024-01-30 10:35:34',domain='beta.astrabookings.com',sub_agent_id='',sub_user_id='';
[01/30/2024 10:35:38], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:35:38' WHERE id= '477';
[01/30/2024 10:35:41], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:35:41' WHERE id= '477';
[01/30/2024 10:35:47], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:35:47' WHERE id= '477';
[01/30/2024 10:35:47], [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/08',  departure_date='2024/02/08',  nights='1',  create_date='2024-01-30 :10:35:47',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/30/2024 10:35: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/30_01_2024/request_availability_shiv_qtech_10_35_47_1706610947.json', 'v1/30_01_2024/response_availability_shiv_qtech_10_35_47_1706610947.json', 'v1/30_01_2024/response_header_availability_shiv_qtech_10_35_47_1706610947.json', 'viator', '2024-01-30 10:35:58', '', '', '1202');
[01/30/2024 10:36:00], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:36:00' WHERE id= '477';
[01/30/2024 10:36:00], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:36:00' WHERE id= '477';
[01/30/2024 10:37:35], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:37:35' WHERE id= '477';
[01/30/2024 10:37:36], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/30_01_2024/request_sight_details_shiv_qtech_10_37_35_1706611055.json', 'v1/30_01_2024/response_sight_details_shiv_qtech_10_37_35_1706611055.json', 'v1/30_01_2024/response_header_sight_details_shiv_qtech_10_37_35_1706611055.json', 'viator', '2024-01-30 10:37:36', '', '', '1202');
[01/30/2024 10:39:13], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-30 10:39:13',login_attempt=0 where id = '7866';
[01/30/2024 10:39:13], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'deepak_qtech', user_type = 'A', branch_id = '31', login_datetime = '2024-01-30 10:39:13', ip = '43.239.53.130', action = 'Login' ;
[01/30/2024 10:39:13], [file name :-/home/otrams/public_html/beta/hotel_search.php],insert into user_sessions_ip SET ip_addr='43.239.53.130', agent_id='7867', session_id='3b1a3e7e83d2cce7102265f527ea8bfbc50a147c47cdabc17b8ccf5d3ac0b620',create_date='2024-01-30 10:39:13', update_date='2024-01-30 10:39:13',domain='hotelyards.astrabookings.com',sub_agent_id='',sub_user_id='';
[01/30/2024 10:39:42], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:39:42' WHERE id= '477';
[01/30/2024 10:39:42], [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/08',  departure_date='2024/02/08',  nights='1',  create_date='2024-01-30 :10:39:42',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/30/2024 10:39:49], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'v1/30_01_2024/request_availability_shiv_qtech_10_39_42_1706611182.json', 'v1/30_01_2024/response_availability_shiv_qtech_10_39_42_1706611182.json', 'v1/30_01_2024/response_header_availability_shiv_qtech_10_39_42_1706611182.json', 'viator', '2024-01-30 10:39:49', '', '', '1203');
[01/30/2024 10:39:50], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:39:50' WHERE id= '477';
[01/30/2024 10:39:50], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:39:50' WHERE id= '477';
[01/30/2024 10:40:14], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:40:14' WHERE id= '475';
[01/30/2024 10:40:14], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-30 10:40:14',login_attempt=0 where id = '7870';
[01/30/2024 10:40:14], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'hotelyards-agent', user_type = 'A', branch_id = '32', login_datetime = '2024-01-30 10:40:14', ip = '43.239.53.130', action = 'Login' ;
[01/30/2024 10:40:14], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:40:14' WHERE id= '475';
[01/30/2024 10:40:32], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:40:32' WHERE id= '477';
[01/30/2024 10:40: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/30_01_2024/request_sight_details_shiv_qtech_10_40_33_1706611233.json', 'v1/30_01_2024/response_sight_details_shiv_qtech_10_40_33_1706611233.json', 'v1/30_01_2024/response_header_sight_details_shiv_qtech_10_40_33_1706611233.json', 'viator', '2024-01-30 10:40:33', '', '', '1203');
[01/30/2024 10:40:49], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:40:49' WHERE id= '478';
[01/30/2024 10:41:03], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:41:03' WHERE id= '477';
[01/30/2024 10:41:03], [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/08',  departure_date='2024/02/08',  nights='1',  create_date='2024-01-30 :10:41:03',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/30/2024 10:41:05], [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/30_01_2024/request_availability_shiv_qtech_10_41_03_1706611263.json', 'v1/30_01_2024/response_availability_shiv_qtech_10_41_03_1706611263.json', 'v1/30_01_2024/response_header_availability_shiv_qtech_10_41_03_1706611263.json', 'viator', '2024-01-30 10:41:05', '', '', '1204');
[01/30/2024 10:41:06], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:41:06' WHERE id= '478';
[01/30/2024 10:41:06], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-30 10:41:06',login_attempt=0 where id = '7865';
[01/30/2024 10:41:06], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'test_Whitelable', user_type = 'A', branch_id = '31', login_datetime = '2024-01-30 10:41:06', ip = '43.239.53.130', action = 'Login' ;
[01/30/2024 10:41:07], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:41:07' WHERE id= '478';
[01/30/2024 10:41:07], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:41:07' WHERE id= '477';
[01/30/2024 10:41:07], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:41:07' WHERE id= '477';
[01/30/2024 10:41:09], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:41:09' WHERE id= '477';
[01/30/2024 10:41:09], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/30_01_2024/request_sight_details_shiv_qtech_10_41_09_1706611269.json', 'v1/30_01_2024/response_sight_details_shiv_qtech_10_41_09_1706611269.json', 'v1/30_01_2024/response_header_sight_details_shiv_qtech_10_41_09_1706611269.json', 'viator', '2024-01-30 10:41:09', '', '', '1204');
[01/30/2024 10:41:15], [file name :-/home/otrams/public_html/beta/tms/logout.php],INSERT INTO psa_login_log set username = 'hotelyards' , user_type = 'hotelyards'_type , branch_id = '32' , login_datetime = '2024-01-30 10:41:15' , ip = '43.239.53.130' , action = 'Logout'  ;
[01/30/2024 10:41:29], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:41:29' WHERE id= '477';
[01/30/2024 10:41:29], [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/08',  departure_date='2024/02/08',  nights='1',  create_date='2024-01-30 :10:41:29',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/30/2024 10:41:46], [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/30_01_2024/request_availability_shiv_qtech_10_41_29_1706611289.json', 'v1/30_01_2024/response_availability_shiv_qtech_10_41_29_1706611289.json', 'v1/30_01_2024/response_header_availability_shiv_qtech_10_41_29_1706611289.json', 'viator', '2024-01-30 10:41:46', '', '', '1205');
[01/30/2024 10:41:47], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:41:47' WHERE id= '477';
[01/30/2024 10:41:47], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:41:47' WHERE id= '477';
[01/30/2024 10:41:54], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:41:54' WHERE id= '477';
[01/30/2024 10:41: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/30_01_2024/request_sight_details_shiv_qtech_10_41_54_1706611314.json', 'v1/30_01_2024/response_sight_details_shiv_qtech_10_41_54_1706611314.json', 'v1/30_01_2024/response_header_sight_details_shiv_qtech_10_41_54_1706611314.json', 'viator', '2024-01-30 10:41:54', '', '', '1205');
[01/30/2024 10:43:22], [file name :-/home/otrams/public_html/beta/tms/logout.php],INSERT INTO psa_login_log set username = 'hotelyards' , user_type = 'hotelyards'_type , branch_id = '32' , login_datetime = '2024-01-30 10:43:22' , ip = '43.239.53.130' , action = 'Logout'  ;
[01/30/2024 10:43:35], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-30 10:43:35',login_attempt=0 where id = '7870';
[01/30/2024 10:43:35], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'hotelyards-agent', user_type = 'A', branch_id = '32', login_datetime = '2024-01-30 10:43:35', ip = '43.239.53.130', action = 'Login' ;
[01/30/2024 10:43:35], [file name :-/home/otrams/public_html/beta/hotel_search.php],insert into user_sessions_ip SET ip_addr='43.239.53.130', agent_id='7867', session_id='ad0d6709fc6309f55733ca4968744fbee0e0bfa604e734262934a22cc67493d9',create_date='2024-01-30 10:43:35', update_date='2024-01-30 10:43:35',domain='hotelyards.astrabookings.com',sub_agent_id='',sub_user_id='';
[01/30/2024 10:43:55], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:43:55' WHERE id= '477';
[01/30/2024 10:43:55], [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/08',  departure_date='2024/02/08',  nights='1',  create_date='2024-01-30 :10:43:55',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/30/2024 10:44:13], [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/30_01_2024/request_availability_shiv_qtech_10_43_55_1706611435.json', 'v1/30_01_2024/response_availability_shiv_qtech_10_43_55_1706611435.json', 'v1/30_01_2024/response_header_availability_shiv_qtech_10_43_55_1706611435.json', 'viator', '2024-01-30 10:44:13', '', '', '1206');
[01/30/2024 10:44:14], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:44:14' WHERE id= '477';
[01/30/2024 10:44:14], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:44:14' WHERE id= '477';
[01/30/2024 10:44:24], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:44:24' WHERE id= '477';
[01/30/2024 10:44: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/30_01_2024/request_sight_details_shiv_qtech_10_44_24_1706611464.json', 'v1/30_01_2024/response_sight_details_shiv_qtech_10_44_24_1706611464.json', 'v1/30_01_2024/response_header_sight_details_shiv_qtech_10_44_24_1706611464.json', 'viator', '2024-01-30 10:44:26', '', '', '1206');
[01/30/2024 10:44: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/30_01_2024/request_sight_details_shiv_qtech_10_44_26_1706611466.json', 'v1/30_01_2024/response_sight_details_shiv_qtech_10_44_26_1706611466.json', 'v1/30_01_2024/response_header_sight_details_shiv_qtech_10_44_26_1706611466.json', 'viator', '2024-01-30 10:44:26', '', '', '1206');
[01/30/2024 10:44:49], [file name :-/home/otrams/public_html/beta/tms/logout.php],INSERT INTO psa_login_log set username = 'Ayman' , user_type = 'Ayman'_type , branch_id = '31' , login_datetime = '2024-01-30 10:44:49' , ip = '43.239.53.130' , action = 'Logout'  ;
[01/30/2024 10:44:53], [file name :-/home/otrams/public_html/beta/logout.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:44:53' WHERE id= '479';
[01/30/2024 10:44:57], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set login_attempt ='1'  where id = '7868';

[01/30/2024 10:45:13], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:45:13' WHERE id= '478';
[01/30/2024 10:45:13], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-30 10:45:13',login_attempt=0 where id = '7870';
[01/30/2024 10:45:13], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'hotelyards-agent', user_type = 'A', branch_id = '32', login_datetime = '2024-01-30 10:45:13', ip = '43.239.53.130', action = 'Login' ;
[01/30/2024 10:45:13], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:45:13' WHERE id= '478';
[01/30/2024 10:50:08], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:50:08' WHERE id= '478';
[01/30/2024 10:50:58], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:50:58' WHERE id= '478';
[01/30/2024 10:51:14], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:51:14' WHERE id= '478';
[01/30/2024 10:54:55], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:54:55' WHERE id= '478';
[01/30/2024 10:59:23], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 10:59:23' WHERE id= '478';
