[01/19/2024 12:00:37], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-19 12:00:37',login_attempt=0 where id = '7866';
[01/19/2024 12:00:37], [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-19 12:00:37', ip = '43.239.53.130', action = 'Login' ;
[01/19/2024 12:00:37], [file name :-/home/otrams/public_html/beta/hotel_search.php],insert into user_sessions_ip SET ip_addr='43.239.53.130', agent_id='7863', session_id='d9f22a743b3b419c1b46f14066cc195345db1a8e745d96285a4d546d7da2077d',create_date='2024-01-19 12:00:37', update_date='2024-01-19 12:00:37',domain='baysantravel.astrabookings.com',sub_agent_id='',sub_user_id='';
[01/19/2024 12:00:43], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:00:43' WHERE id= '323';
[01/19/2024 12:00:46], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:00:46' WHERE id= '323';
[01/19/2024 12:01:00], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:01:00' WHERE id= '323';
[01/19/2024 12:01:00], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7866' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '31' , ip = '43.239.53.130' , city = 'phuket' , service_name = '' , country_of_residence = '112' , service_type = 'hotel' , arrival_date = '2024/05/22' , departure_date = '2024/05/23' , nights = '1' , nationality = '112' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-01-19 12:01:00' , site_id = '20' , country_code = '136' , city_code = '71351' , ratings = '4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[01/19/2024 12:01:01], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:01:01' WHERE id= '323';
[01/19/2024 12:01:03], [file name :-/home/otrams/public_html/beta/call.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', 'e1/19_01_2024/request_availability_Baysan_Tourism_wh_12_01_01_1705665661_71.json', 'e1/19_01_2024/response_availability_Baysan_Tourism_wh_12_01_01_1705665661_71.json', 'e1/19_01_2024/response_header_availability_Baysan_Tourism_wh_12_01_01_1705665661_71.json', 'expedia', '2024-01-19 12:01:03', '', 'd9f22a743b3b419c1b46f14066cc195345db1a8e745d96285a4d546d7da2077d', '0');
[01/19/2024 12:01:03], [file name :-/home/otrams/public_html/beta/call.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', 'e1/19_01_2024/request_availability_Baysan_Tourism_wh_12_01_01_1705665661_35.json', 'e1/19_01_2024/response_availability_Baysan_Tourism_wh_12_01_01_1705665661_35.json', 'e1/19_01_2024/response_header_availability_Baysan_Tourism_wh_12_01_01_1705665661_35.json', 'expedia', '2024-01-19 12:01:03', '', 'd9f22a743b3b419c1b46f14066cc195345db1a8e745d96285a4d546d7da2077d', '0');
[01/19/2024 12:01:03], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=d9f22a743b3b419c1b46f14066cc195345db1a8e745d96285a4d546d7da2077d&xml_user_id=7863&db_caching=1&erequest=1&total_request=2&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=138'
            , http_hit_time = '2024-01-19 12:01:01.966'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '1.703'
            , error_description = ''
            , memory_used = '55610648'
            WHERE id = '28856';
[01/19/2024 12:01:03], [file name :-/home/otrams/public_html/beta/call.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', 'e1p/19_01_2024/request_availability_Baysan_Tourism_wh_12_01_01_1705665661_22.json', 'e1p/19_01_2024/response_availability_Baysan_Tourism_wh_12_01_01_1705665661_22.json', 'e1p/19_01_2024/response_header_availability_Baysan_Tourism_wh_12_01_01_1705665661_22.json', 'expediapackage', '2024-01-19 12:01:03', '', 'd9f22a743b3b419c1b46f14066cc195345db1a8e745d96285a4d546d7da2077d', '0');
[01/19/2024 12:01:04], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=d9f22a743b3b419c1b46f14066cc195345db1a8e745d96285a4d546d7da2077d&xml_user_id=7863&db_caching=1&erequest=1&total_request=2&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=138'
            , http_hit_time = '2024-01-19 12:01:01.966'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '2.551'
            , error_description = ''
            , memory_used = '63912624'
            WHERE id = '28858';
[01/19/2024 12:01:04], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=d9f22a743b3b419c1b46f14066cc195345db1a8e745d96285a4d546d7da2077d&xml_user_id=7863&db_caching=1&erequest=0&total_request=2&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=138'
            , http_hit_time = '2024-01-19 12:01:01.965'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '2.777'
            , error_description = ''
            , memory_used = '131047272'
            WHERE id = '28857';
[01/19/2024 12:01:05], [file name :-/home/otrams/public_html/beta/call.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', 'e1p/19_01_2024/request_availability_Baysan_Tourism_wh_12_01_01_1705665661_23.json', 'e1p/19_01_2024/response_availability_Baysan_Tourism_wh_12_01_01_1705665661_23.json', 'e1p/19_01_2024/response_header_availability_Baysan_Tourism_wh_12_01_01_1705665661_23.json', 'expediapackage', '2024-01-19 12:01:05', '', 'd9f22a743b3b419c1b46f14066cc195345db1a8e745d96285a4d546d7da2077d', '0');
[01/19/2024 12:01:06], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=d9f22a743b3b419c1b46f14066cc195345db1a8e745d96285a4d546d7da2077d&xml_user_id=7863&db_caching=1&erequest=0&total_request=2&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=138'
            , http_hit_time = '2024-01-19 12:01:01.965'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '4.475'
            , error_description = ''
            , memory_used = '153275192'
            WHERE id = '28859';
[01/19/2024 12:01:07], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:01:07' WHERE id= '323';
[01/19/2024 12:01:07], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:01:07' WHERE id= '323';
[01/19/2024 12:01:40], [file name :-/home/otrams/public_html/beta/show_hotel_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:01:40' WHERE id= '323';
[01/19/2024 12:01:41], [file name :-/home/otrams/public_html/beta/view_map.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:01:41' WHERE id= '323';
[01/19/2024 12:03:13], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:03:13' WHERE id= '323';
[01/19/2024 12:03:27], [file name :-/home/otrams/public_html/beta/show_hotel_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:03:27' WHERE id= '323';
[01/19/2024 12:03:27], [file name :-/home/otrams/public_html/beta/view_map.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:03:27' WHERE id= '323';
[01/19/2024 12:04:30], [file name :-/home/otrams/public_html/beta/add_multiple_quotation.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:04:30' WHERE id= '323';
[01/19/2024 12:04:31], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:04:31' WHERE id= '323';
[01/19/2024 12:04:31], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:04:31' WHERE id= '323';
[01/19/2024 12:04:31], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705665871','43.239.53.130');
[01/19/2024 12:04:32], [file name :-/home/otrams/public_html/beta/book_now.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', 'e1p/19_01_2024/request_valuation_Baysan_Tourism_wh_12_04_31_1705665871_52.json', 'e1p/19_01_2024/response_valuation_Baysan_Tourism_wh_12_04_31_1705665871_52.json', 'e1p/19_01_2024/response_header_valuation_Baysan_Tourism_wh_12_04_31_1705665871_52.json', 'expediapackage', '2024-01-19 12:04:32', '', 'd9f22a743b3b419c1b46f14066cc195345db1a8e745d96285a4d546d7da2077d', '0');
[01/19/2024 12:04:32], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO mails_error_log set mailfrom='gajendra.rajpurohit@qtechsoftware.com',mailsubject='Payment Gateway credit limit is over for the days transaction (19-01-2024 12:04:32).(NOTIFICATION_PER_DAY_LIMIT)',mailbody='Dear Administrator,&lt;br/&gt;The Payment Gateway credit limit assigned is over for a day &lt;br/&gt; Payment Gateway Credit Limit IS  0 USD&lt;br/&gt; The customer wants to book for 0 USD&lt;br/&gt;&lt;br/&gt;Agent Information &lt;br/&gt;&lt;br/&gt;Agency Name : Qtech &lt;br&gt;Agency Code : CD7863 &lt;br&gt;City : phuket &lt;br&gt;Service Date : 2024/05/22 &lt;br&gt;',mailto='',mailcc='',mailbcc='',mailattachment='',reason='You must provide at least one recipient email address.',date_time='2024-01-19 12:04:32';
[01/19/2024 12:05:30], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:05:30' WHERE id= '323';
[01/19/2024 12:05:34], [file name :-/home/otrams/public_html/beta/compare.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:05:34' WHERE id= '323';
[01/19/2024 12:06:03], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-19 12:06:03',login_attempt=0 where id = '7866';
[01/19/2024 12:06:03], [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-19 12:06:03', ip = '223.189.23.117', action = 'Login' ;
[01/19/2024 12:06:03], [file name :-/home/otrams/public_html/beta/hotel_search.php],insert into user_sessions_ip SET ip_addr='223.189.23.117', agent_id='7863', session_id='e4e0544cb9d4348f94f36123a698d5033931e90cdd6d0a88f850a87118e47ad5',create_date='2024-01-19 12:06:03', update_date='2024-01-19 12:06:03',domain='baysantravel.astrabookings.com',sub_agent_id='',sub_user_id='';
[01/19/2024 12:06:09], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:06:09' WHERE id= '324';
[01/19/2024 12:06:09], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:06:09' WHERE id= '324';
[01/19/2024 12:06:20], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:06:20' WHERE id= '324';
[01/19/2024 12:06:20], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7866' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '31' , ip = '223.189.23.117' , city = 'dubai' , service_name = '' , country_of_residence = '138' , service_type = 'hotel' , arrival_date = '2024/02/23' , departure_date = '2024/02/24' , nights = '1' , nationality = '138' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-01-19 12:06:20' , site_id = '20' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[01/19/2024 12:06:20], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:06:20' WHERE id= '324';
[01/19/2024 12:06:21], [file name :-/home/otrams/public_html/beta/call.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', 'e1p/19_01_2024/request_availability_Baysan_Tourism_wh_12_06_20_1705665980_51.json', 'e1p/19_01_2024/response_availability_Baysan_Tourism_wh_12_06_20_1705665980_51.json', 'e1p/19_01_2024/response_header_availability_Baysan_Tourism_wh_12_06_20_1705665980_51.json', 'expediapackage', '2024-01-19 12:06:21', '', 'e4e0544cb9d4348f94f36123a698d5033931e90cdd6d0a88f850a87118e47ad5', '0');
[01/19/2024 12:06:21], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=e4e0544cb9d4348f94f36123a698d5033931e90cdd6d0a88f850a87118e47ad5&xml_user_id=7863&db_caching=1&erequest=2&total_request=3&web_service=no&ip=223.189.23.117&browser=GoogleChrome%2F120.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=138'
            , http_hit_time = '2024-01-19 12:06:20.964'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '0.171'
            , error_description = ''
            , memory_used = '1461392'
            WHERE id = '28861';
[01/19/2024 12:06:21], [file name :-/home/otrams/public_html/beta/call.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', 'e1/19_01_2024/request_availability_Baysan_Tourism_wh_12_06_20_1705665980_15.json', 'e1/19_01_2024/response_availability_Baysan_Tourism_wh_12_06_20_1705665980_15.json', 'e1/19_01_2024/response_header_availability_Baysan_Tourism_wh_12_06_20_1705665980_15.json', 'expedia', '2024-01-19 12:06:21', '', 'e4e0544cb9d4348f94f36123a698d5033931e90cdd6d0a88f850a87118e47ad5', '0');
[01/19/2024 12:06:21], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=e4e0544cb9d4348f94f36123a698d5033931e90cdd6d0a88f850a87118e47ad5&xml_user_id=7863&db_caching=1&erequest=2&total_request=3&web_service=no&ip=223.189.23.117&browser=GoogleChrome%2F120.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=138'
            , http_hit_time = '2024-01-19 12:06:20.964'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '0.241'
            , error_description = ''
            , memory_used = '1460672'
            WHERE id = '28862';
[01/19/2024 12:06:22], [file name :-/home/otrams/public_html/beta/call.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', 'e1/19_01_2024/request_availability_Baysan_Tourism_wh_12_06_20_1705665980_18.json', 'e1/19_01_2024/response_availability_Baysan_Tourism_wh_12_06_20_1705665980_18.json', 'e1/19_01_2024/response_header_availability_Baysan_Tourism_wh_12_06_20_1705665980_18.json', 'expedia', '2024-01-19 12:06:22', '', 'e4e0544cb9d4348f94f36123a698d5033931e90cdd6d0a88f850a87118e47ad5', '0');
[01/19/2024 12:06:22], [file name :-/home/otrams/public_html/beta/call.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', 'e1/19_01_2024/request_availability_Baysan_Tourism_wh_12_06_20_1705665980_9.json', 'e1/19_01_2024/response_availability_Baysan_Tourism_wh_12_06_20_1705665980_9.json', 'e1/19_01_2024/response_header_availability_Baysan_Tourism_wh_12_06_20_1705665980_9.json', 'expedia', '2024-01-19 12:06:22', '', 'e4e0544cb9d4348f94f36123a698d5033931e90cdd6d0a88f850a87118e47ad5', '0');
[01/19/2024 12:06:23], [file name :-/home/otrams/public_html/beta/call.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', 'e1p/19_01_2024/request_availability_Baysan_Tourism_wh_12_06_20_1705665980_29.json', 'e1p/19_01_2024/response_availability_Baysan_Tourism_wh_12_06_20_1705665980_29.json', 'e1p/19_01_2024/response_header_availability_Baysan_Tourism_wh_12_06_20_1705665980_29.json', 'expediapackage', '2024-01-19 12:06:23', '', 'e4e0544cb9d4348f94f36123a698d5033931e90cdd6d0a88f850a87118e47ad5', '0');
[01/19/2024 12:06:23], [file name :-/home/otrams/public_html/beta/call.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', 'e1p/19_01_2024/request_availability_Baysan_Tourism_wh_12_06_20_1705665980_71.json', 'e1p/19_01_2024/response_availability_Baysan_Tourism_wh_12_06_20_1705665980_71.json', 'e1p/19_01_2024/response_header_availability_Baysan_Tourism_wh_12_06_20_1705665980_71.json', 'expediapackage', '2024-01-19 12:06:23', '', 'e4e0544cb9d4348f94f36123a698d5033931e90cdd6d0a88f850a87118e47ad5', '0');
[01/19/2024 12:06:23], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=e4e0544cb9d4348f94f36123a698d5033931e90cdd6d0a88f850a87118e47ad5&xml_user_id=7863&db_caching=1&erequest=1&total_request=3&web_service=no&ip=223.189.23.117&browser=GoogleChrome%2F120.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=138'
            , http_hit_time = '2024-01-19 12:06:20.964'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '2.891'
            , error_description = ''
            , memory_used = '161928704'
            WHERE id = '28863';
[01/19/2024 12:06:24], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=e4e0544cb9d4348f94f36123a698d5033931e90cdd6d0a88f850a87118e47ad5&xml_user_id=7863&db_caching=1&erequest=0&total_request=3&web_service=no&ip=223.189.23.117&browser=GoogleChrome%2F120.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=138'
            , http_hit_time = '2024-01-19 12:06:20.964'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '3.362'
            , error_description = ''
            , memory_used = '184921592'
            WHERE id = '28864';
[01/19/2024 12:06:24], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=e4e0544cb9d4348f94f36123a698d5033931e90cdd6d0a88f850a87118e47ad5&xml_user_id=7863&db_caching=1&erequest=1&total_request=3&web_service=no&ip=223.189.23.117&browser=GoogleChrome%2F120.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=138'
            , http_hit_time = '2024-01-19 12:06:20.964'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '3.399'
            , error_description = ''
            , memory_used = '170064408'
            WHERE id = '28865';
[01/19/2024 12:06:24], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=e4e0544cb9d4348f94f36123a698d5033931e90cdd6d0a88f850a87118e47ad5&xml_user_id=7863&db_caching=1&erequest=0&total_request=3&web_service=no&ip=223.189.23.117&browser=GoogleChrome%2F120.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=138'
            , http_hit_time = '2024-01-19 12:06:20.964'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '4.028'
            , error_description = ''
            , memory_used = '197213416'
            WHERE id = '28866';
[01/19/2024 12:06:25], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:06:25' WHERE id= '324';
[01/19/2024 12:06:26], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:06:26' WHERE id= '324';
[01/19/2024 12:06:43], [file name :-/home/otrams/public_html/beta/show_hotel_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:06:43' WHERE id= '324';
[01/19/2024 12:06:43], [file name :-/home/otrams/public_html/beta/view_map.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:06:43' WHERE id= '324';
[01/19/2024 12:07:28], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:07:28' WHERE id= '324';
[01/19/2024 12:08:01], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:08:01' WHERE id= '324';
[01/19/2024 12:08:31], [file name :-/home/otrams/public_html/beta/show_hotel_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:08:31' WHERE id= '324';
[01/19/2024 12:08:31], [file name :-/home/otrams/public_html/beta/view_map.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:08:31' WHERE id= '324';
[01/19/2024 12:10:43], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:10:43' WHERE id= '323';
[01/19/2024 12:10:52], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:10:52' WHERE id= '323';
[01/19/2024 12:10:52], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7863' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '31' , ip = '43.239.53.130' , city = 'phuket' , arrival_date='2024/05/22',  departure_date='2024/05/22',  nights='1',  create_date='2024-01-19 :12:10:52',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '20' ;
[01/19/2024 12:11:00], [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/19_01_2024/request_availability_Baysan_Tourism_wh_12_10_52_1705666252.json', 'v1/19_01_2024/response_availability_Baysan_Tourism_wh_12_10_52_1705666252.json', 'v1/19_01_2024/response_header_availability_Baysan_Tourism_wh_12_10_52_1705666252.json', 'viator', '2024-01-19 12:11:00', '', '', '1026');
[01/19/2024 12:11:02], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:11:02' WHERE id= '323';
[01/19/2024 12:11:03], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:11:03' WHERE id= '323';
[01/19/2024 12:11:06], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:11:06' WHERE id= '323';
[01/19/2024 12:11:07], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/19_01_2024/request_sight_details_Baysan_Tourism_wh_12_11_06_1705666266.json', 'v1/19_01_2024/response_sight_details_Baysan_Tourism_wh_12_11_06_1705666266.json', 'v1/19_01_2024/response_header_sight_details_Baysan_Tourism_wh_12_11_06_1705666266.json', 'viator', '2024-01-19 12:11:07', '', '', '1026');
[01/19/2024 12:11:59], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:11:59' WHERE id= '323';
[01/19/2024 12:12:00], [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/19_01_2024/request_sight_details_Baysan_Tourism_wh_12_11_59_1705666319.json', 'v1/19_01_2024/response_sight_details_Baysan_Tourism_wh_12_11_59_1705666319.json', 'v1/19_01_2024/response_header_sight_details_Baysan_Tourism_wh_12_11_59_1705666319.json', 'viator', '2024-01-19 12:12:00', '', '', '1026');
[01/19/2024 12:12:21], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:12:21' WHERE id= '323';
[01/19/2024 12:12:21], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/19_01_2024/request_sight_details_Baysan_Tourism_wh_12_12_21_1705666341.json', 'v1/19_01_2024/response_sight_details_Baysan_Tourism_wh_12_12_21_1705666341.json', 'v1/19_01_2024/response_header_sight_details_Baysan_Tourism_wh_12_12_21_1705666341.json', 'viator', '2024-01-19 12:12:21', '', '', '1026');
[01/19/2024 12:13:09], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:13:09' WHERE id= '323';
[01/19/2024 12:13:09], [file name :-/home/otrams/public_html/beta/ajax_getsightlist.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:13:09' WHERE id= '323';
[01/19/2024 12:13:09], [file name :-/home/otrams/public_html/beta/ajax_getsightlist.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:13:09' WHERE id= '323';
[01/19/2024 12:13:09], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:13:09' WHERE id= '323';
[01/19/2024 12:13:09], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:13:09' WHERE id= '323';
[01/19/2024 12:13:10], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:13:10' WHERE id= '323';
[01/19/2024 12:13:13], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:13:13' WHERE id= '323';
[01/19/2024 12:13:13], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:13:13' WHERE id= '323';
[01/19/2024 12:13:15], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:13:15' WHERE id= '323';
[01/19/2024 12:13:15], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/19_01_2024/request_sight_details_Baysan_Tourism_wh_12_13_15_1705666395.json', 'v1/19_01_2024/response_sight_details_Baysan_Tourism_wh_12_13_15_1705666395.json', 'v1/19_01_2024/response_header_sight_details_Baysan_Tourism_wh_12_13_15_1705666395.json', 'viator', '2024-01-19 12:13:15', '', '', '1026');
[01/19/2024 12:13:34], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:13:34' WHERE id= '323';
[01/19/2024 12:13:35], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/19_01_2024/request_sight_details_Baysan_Tourism_wh_12_13_34_1705666414.json', 'v1/19_01_2024/response_sight_details_Baysan_Tourism_wh_12_13_34_1705666414.json', 'v1/19_01_2024/response_header_sight_details_Baysan_Tourism_wh_12_13_34_1705666414.json', 'viator', '2024-01-19 12:13:35', '', '', '1026');
[01/19/2024 12:14:19], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-19 12:14:19',login_attempt=0 where id = '7866';
[01/19/2024 12:14:19], [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-19 12:14:19', ip = '43.239.53.130', action = 'Login' ;
[01/19/2024 12:14:19], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET is_exception = 'yes', exception_info = CONCAT(exception_info, '~~~' ,'ip changed 43.239.53.130') WHERE id= '313';
[01/19/2024 12:14:20], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:14:20' WHERE id= '323';
[01/19/2024 12:14:20], [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/19_01_2024/request_sight_details_Baysan_Tourism_wh_12_14_20_1705666460.json', 'v1/19_01_2024/response_sight_details_Baysan_Tourism_wh_12_14_20_1705666460.json', 'v1/19_01_2024/response_header_sight_details_Baysan_Tourism_wh_12_14_20_1705666460.json', 'viator', '2024-01-19 12:14:20', '', '', '1026');
[01/19/2024 12:14:23], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-19 12:14:23',login_attempt=0 where id = '7865';
[01/19/2024 12:14:23], [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-19 12:14:23', ip = '43.239.53.130', action = 'Login' ;
[01/19/2024 12:14:23], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET is_exception = 'yes', exception_info = CONCAT(exception_info, '~~~' ,'ip changed 43.239.53.130') WHERE id= '313';
[01/19/2024 12:14:32], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-19 12:14:32',login_attempt=0 where id = '7866';
[01/19/2024 12:14:32], [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-19 12:14:32', ip = '43.239.53.130', action = 'Login' ;
[01/19/2024 12:14:33], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET is_exception = 'yes', exception_info = CONCAT(exception_info, '~~~' ,'ip changed 43.239.53.130') WHERE id= '313';
[01/19/2024 12:14:37], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:14:37' WHERE id= '323';
[01/19/2024 12:14:37], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7863' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '31' , ip = '43.239.53.130' , city = 'phuket' , arrival_date='2024/05/22',  departure_date='2024/05/22',  nights='1',  create_date='2024-01-19 :12:14:37',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '20' ;
[01/19/2024 12:14:38], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-19 12:14:38',login_attempt=0 where id = '7866';
[01/19/2024 12:14:38], [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-19 12:14:38', ip = '43.239.53.130', action = 'Login' ;
[01/19/2024 12:14:38], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET is_exception = 'yes', exception_info = CONCAT(exception_info, '~~~' ,'ip changed 43.239.53.130') WHERE id= '313';
[01/19/2024 12:14:43], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:14:43' WHERE id= '309';
[01/19/2024 12:14:43], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO bookings set reservation_id='1901',agent_id='7851',leader_title='Mr',leader_first_name='asdf',leader_last_name='fdgsdf',city_id='dubai',country_id='138',nationality='Emirati',display_room_rate='190.71',display_currency_code='USD',native_room_rate='190.71',consultant_id='SUJAY_QTECH',native_currency_code='USD',cancellation_policy='Cancellation Charges will be applicable if cancelled after 07 Dec 2023 12:00 hrs.<BR>Late amendment charge may apply.<Br><Br><B><U>Detailed Cancellation Policy:</U></B><Br>190.71 USDCharges - 100% applicable from time of Booking (Full Cancellation Charges applicable immediately)',current_status='inprocess-booking',booking_status='1',sales_manager_id='0',create_date='2024-01-19 12:14:43',source_type='viator',expiration_date= '2023-12-07 09:00:00',applied_multiplier='1.00000',applied_markup='0',agent_markup='0',basecurrency_multiplier='1.00000',basecurrency_multiplier_native='1.00000',admin_booked='0',service_date='2024-01-22',sub_user_id='',check_out_date='2024-01-22',supplier_profile_id='',agent_currency_multiplier='3.7507', booking_branch_id = '27',site_url = 'https://beta.astrabookings.com/',ip_addr='43.239.53.130',leader_phone=' 9823860012',email_id='shiv.chauhan@qtechsoftware.com',service_type='sightseeing';
[01/19/2024 12:14:43], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO sight_bookings set booking_id='314',native_nightly_rates='a:2:{s:4:\"size\";i:1;s:17:\"nativeNightlyRate\";d:190.71000000000001;}',rate_description='',display_nightly_rates='a:4:{s:4:\"size\";i:1;s:18:\"displayNightlyRate\";d:190.71000000000001;s:25:\"displayNightlyRateDisplay\";s:134:\"Rate - 190.71 USD, Currency Multiplier (USD-USD) - 1.00000, Markup  in % - %, Markup Amount - , Markup Amount in  - ,Other Markup - 0%\";s:23:\"displayNightlyRateStore\";s:135:\"Rate - 190.71 USD, Currency Multiplier (USD-USD) - 1.00000, Markup  in % - %, Markup Amount - , Markup Amount in  -  ,Other Markup - 0%\";}',display_currency_code='USD',native_currency_code='USD',sight_id='176239P4',sight_name='DUBAI: UNIQUE MORNING QUAD BIKE RED DUNES SAFARI- V2',tour_time='',tour_details='',tour_inclusive='<br/>',tour_exclusive=',<br/>',meeting_point='',tour_dep_point=' ',tour_language='en/SERVICE_GUIDE',tour_supplier_phone='',additional_tour_dep_point='',tour_duration='4 hours 0 minutes<br> Start Time: 08:00',arrival_date='2024-01-22',total_adults='3',total_children='',total_infants='',gta_city_code='828',supplier_id='',pick_up_point='',drop_off_point='',from_slot='',to_slot='',total_adult_rate='',total_child_rate='',adult_rate='',child_rate='',display_total_adult_rate='',display_total_child_rate='',display_adult_rate='',display_child_rate='0',additional_service_rate='0',booking_remark='',emergency_cont_no='',terms_n_condition='';
[01/19/2024 12:14:43], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO posted_bookings(id,source_type,reservation_id,create_date,status) values ('','viator','1901','2024-01-19 12:14:43',0);
[01/19/2024 12:14: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/19_01_2024/request_availability_Baysan_Tourism_wh_12_14_37_1705666477.json', 'v1/19_01_2024/response_availability_Baysan_Tourism_wh_12_14_37_1705666477.json', 'v1/19_01_2024/response_header_availability_Baysan_Tourism_wh_12_14_37_1705666477.json', 'viator', '2024-01-19 12:14:48', '', '', '1027');
[01/19/2024 12:14:51], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:14:51' WHERE id= '323';
[01/19/2024 12:14:51], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:14:51' WHERE id= '323';
[01/19/2024 12:14:55], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-19 12:14:55',login_attempt=0 where id = '7866';
[01/19/2024 12:14:55], [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-19 12:14:55', ip = '43.239.53.130', action = 'Login' ;
[01/19/2024 12:14:56], [file name :-/home/otrams/public_html/beta/hotel_search.php],insert into user_sessions_ip SET ip_addr='43.239.53.130', agent_id='7863', session_id='c9d07ec2a2f169d539285613c4bbf0aee5053f774137d385c6d757fe65c2853f',create_date='2024-01-19 12:14:56', update_date='2024-01-19 12:14:56',domain='baysantravel.astrabookings.com',sub_agent_id='',sub_user_id='';
[01/19/2024 12:14:59], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:14:59' WHERE id= '325';
[01/19/2024 12:15:03], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:15:03' WHERE id= '325';
[01/19/2024 12:15:03], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7866' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '31' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '138' , service_type = 'hotel' , arrival_date = '2024/01/31' , departure_date = '2024/02/01' , nights = '1' , nationality = '138' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-01-19 12:15:03' , site_id = '20' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[01/19/2024 12:15:03], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:15:03' WHERE id= '325';
[01/19/2024 12:15:03], [file name :-/home/otrams/public_html/beta/call.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', 'e1p/19_01_2024/request_availability_Baysan_Tourism_wh_12_15_03_1705666503_94.json', 'e1p/19_01_2024/response_availability_Baysan_Tourism_wh_12_15_03_1705666503_94.json', 'e1p/19_01_2024/response_header_availability_Baysan_Tourism_wh_12_15_03_1705666503_94.json', 'expediapackage', '2024-01-19 12:15:03', '', 'c9d07ec2a2f169d539285613c4bbf0aee5053f774137d385c6d757fe65c2853f', '0');
[01/19/2024 12:15:03], [file name :-/home/otrams/public_html/beta/call.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', 'e1/19_01_2024/request_availability_Baysan_Tourism_wh_12_15_03_1705666503_52.json', 'e1/19_01_2024/response_availability_Baysan_Tourism_wh_12_15_03_1705666503_52.json', 'e1/19_01_2024/response_header_availability_Baysan_Tourism_wh_12_15_03_1705666503_52.json', 'expedia', '2024-01-19 12:15:03', '', 'c9d07ec2a2f169d539285613c4bbf0aee5053f774137d385c6d757fe65c2853f', '0');
[01/19/2024 12:15:03], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=c9d07ec2a2f169d539285613c4bbf0aee5053f774137d385c6d757fe65c2853f&xml_user_id=7863&db_caching=1&erequest=2&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F120.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=138'
            , http_hit_time = '2024-01-19 12:15:03.634'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '0.186'
            , error_description = ''
            , memory_used = '1461392'
            WHERE id = '28875';
[01/19/2024 12:15:03], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=c9d07ec2a2f169d539285613c4bbf0aee5053f774137d385c6d757fe65c2853f&xml_user_id=7863&db_caching=1&erequest=2&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F120.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=138'
            , http_hit_time = '2024-01-19 12:15:03.634'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '0.192'
            , error_description = ''
            , memory_used = '1460672'
            WHERE id = '28876';
[01/19/2024 12:15:05], [file name :-/home/otrams/public_html/beta/call.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', 'e1/19_01_2024/request_availability_Baysan_Tourism_wh_12_15_03_1705666503_21.json', 'e1/19_01_2024/response_availability_Baysan_Tourism_wh_12_15_03_1705666503_21.json', 'e1/19_01_2024/response_header_availability_Baysan_Tourism_wh_12_15_03_1705666503_21.json', 'expedia', '2024-01-19 12:15:05', '', 'c9d07ec2a2f169d539285613c4bbf0aee5053f774137d385c6d757fe65c2853f', '0');
[01/19/2024 12:15:05], [file name :-/home/otrams/public_html/beta/call.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', 'e1p/19_01_2024/request_availability_Baysan_Tourism_wh_12_15_03_1705666503_40.json', 'e1p/19_01_2024/response_availability_Baysan_Tourism_wh_12_15_03_1705666503_40.json', 'e1p/19_01_2024/response_header_availability_Baysan_Tourism_wh_12_15_03_1705666503_40.json', 'expediapackage', '2024-01-19 12:15:05', '', 'c9d07ec2a2f169d539285613c4bbf0aee5053f774137d385c6d757fe65c2853f', '0');
[01/19/2024 12:15:05], [file name :-/home/otrams/public_html/beta/call.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', 'e1/19_01_2024/request_availability_Baysan_Tourism_wh_12_15_03_1705666503_22.json', 'e1/19_01_2024/response_availability_Baysan_Tourism_wh_12_15_03_1705666503_22.json', 'e1/19_01_2024/response_header_availability_Baysan_Tourism_wh_12_15_03_1705666503_22.json', 'expedia', '2024-01-19 12:15:05', '', 'c9d07ec2a2f169d539285613c4bbf0aee5053f774137d385c6d757fe65c2853f', '0');
[01/19/2024 12:15:06], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=c9d07ec2a2f169d539285613c4bbf0aee5053f774137d385c6d757fe65c2853f&xml_user_id=7863&db_caching=1&erequest=0&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F120.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=138'
            , http_hit_time = '2024-01-19 12:15:03.634'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '2.882'
            , error_description = ''
            , memory_used = '168568752'
            WHERE id = '28877';
[01/19/2024 12:15:06], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:15:06' WHERE id= '309';
[01/19/2024 12:15:06], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO bookings set reservation_id='1901',agent_id='7851',leader_title='Mr',leader_first_name='asdf',leader_last_name='fdgsdf',city_id='dubai',country_id='138',nationality='Emirati',display_room_rate='190.71',display_currency_code='USD',native_room_rate='190.71',consultant_id='SUJAY_QTECH',native_currency_code='USD',cancellation_policy='Cancellation Charges will be applicable if cancelled after 07 Dec 2023 12:00 hrs.<BR>Late amendment charge may apply.<Br><Br><B><U>Detailed Cancellation Policy:</U></B><Br>190.71 USDCharges - 100% applicable from time of Booking (Full Cancellation Charges applicable immediately)',current_status='inprocess-booking',booking_status='1',sales_manager_id='0',create_date='2024-01-19 12:15:06',source_type='viator',expiration_date= '2023-12-07 09:00:00',applied_multiplier='1.00000',applied_markup='0',agent_markup='0',basecurrency_multiplier='1.00000',basecurrency_multiplier_native='1.00000',admin_booked='0',service_date='2024-01-22',sub_user_id='',check_out_date='2024-01-22',supplier_profile_id='',agent_currency_multiplier='3.7507', booking_branch_id = '27',site_url = 'https://beta.astrabookings.com/',ip_addr='43.239.53.130',leader_phone=' 9823860012',email_id='shiv.chauhan@qtechsoftware.com',service_type='sightseeing';
[01/19/2024 12:15:06], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO sight_bookings set booking_id='315',native_nightly_rates='a:2:{s:4:\"size\";i:1;s:17:\"nativeNightlyRate\";d:190.71000000000001;}',rate_description='',display_nightly_rates='a:4:{s:4:\"size\";i:1;s:18:\"displayNightlyRate\";d:190.71000000000001;s:25:\"displayNightlyRateDisplay\";s:134:\"Rate - 190.71 USD, Currency Multiplier (USD-USD) - 1.00000, Markup  in % - %, Markup Amount - , Markup Amount in  - ,Other Markup - 0%\";s:23:\"displayNightlyRateStore\";s:135:\"Rate - 190.71 USD, Currency Multiplier (USD-USD) - 1.00000, Markup  in % - %, Markup Amount - , Markup Amount in  -  ,Other Markup - 0%\";}',display_currency_code='USD',native_currency_code='USD',sight_id='176239P4',sight_name='DUBAI: UNIQUE MORNING QUAD BIKE RED DUNES SAFARI- V2',tour_time='',tour_details='',tour_inclusive='<br/>',tour_exclusive=',<br/>',meeting_point='',tour_dep_point=' ',tour_language='en/SERVICE_GUIDE',tour_supplier_phone='',additional_tour_dep_point='',tour_duration='4 hours 0 minutes<br> Start Time: 08:00',arrival_date='2024-01-22',total_adults='3',total_children='',total_infants='',gta_city_code='828',supplier_id='',pick_up_point='',drop_off_point='',from_slot='',to_slot='',total_adult_rate='',total_child_rate='',adult_rate='',child_rate='',display_total_adult_rate='',display_total_child_rate='',display_adult_rate='',display_child_rate='0',additional_service_rate='0',booking_remark='',emergency_cont_no='',terms_n_condition='';
[01/19/2024 12:15:06], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO posted_bookings(id,source_type,reservation_id,create_date,status) values ('','viator','1901','2024-01-19 12:15:06',0);
[01/19/2024 12:15:06], [file name :-/home/otrams/public_html/beta/call.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', 'e1p/19_01_2024/request_availability_Baysan_Tourism_wh_12_15_03_1705666503_58.json', 'e1p/19_01_2024/response_availability_Baysan_Tourism_wh_12_15_03_1705666503_58.json', 'e1p/19_01_2024/response_header_availability_Baysan_Tourism_wh_12_15_03_1705666503_58.json', 'expediapackage', '2024-01-19 12:15:06', '', 'c9d07ec2a2f169d539285613c4bbf0aee5053f774137d385c6d757fe65c2853f', '0');
[01/19/2024 12:15:06], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=c9d07ec2a2f169d539285613c4bbf0aee5053f774137d385c6d757fe65c2853f&xml_user_id=7863&db_caching=1&erequest=0&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F120.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=138'
            , http_hit_time = '2024-01-19 12:15:03.634'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '3.297'
            , error_description = ''
            , memory_used = '177555920'
            WHERE id = '28878';
[01/19/2024 12:15:07], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=c9d07ec2a2f169d539285613c4bbf0aee5053f774137d385c6d757fe65c2853f&xml_user_id=7863&db_caching=1&erequest=1&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F120.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=138'
            , http_hit_time = '2024-01-19 12:15:03.634'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '3.539'
            , error_description = ''
            , memory_used = '152634576'
            WHERE id = '28879';
[01/19/2024 12:15:07], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=c9d07ec2a2f169d539285613c4bbf0aee5053f774137d385c6d757fe65c2853f&xml_user_id=7863&db_caching=1&erequest=1&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F120.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=138'
            , http_hit_time = '2024-01-19 12:15:03.634'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '4.215'
            , error_description = ''
            , memory_used = '159288008'
            WHERE id = '28880';
[01/19/2024 12:15:08], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:15:08' WHERE id= '325';
[01/19/2024 12:15:08], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:15:08' WHERE id= '325';
[01/19/2024 12:15:09], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:15:09' WHERE id= '325';
[01/19/2024 12:15:09], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:15:09' WHERE id= '323';
[01/19/2024 12:15:09], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'reservation_sight', 'v1/19_01_2024/request_reservation_sight_Viator_test_12_15_06_1705666506.json', 'v1/19_01_2024/response_reservation_sight_Viator_test_12_15_06_1705666506.json', 'v1/19_01_2024/response_header_reservation_sight_Viator_test_12_15_06_1705666506.json', 'viator', '2024-01-19 12:15:09', '', '', '1025');
[01/19/2024 12:15:09], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE posted_bookings set status=1 where id= '152';
[01/19/2024 12:15:09], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],update bookings set  parent_agent_id='7851', applicable_service_tax='0', sub_agent_rate='0', agent_rate='190.71', supplier_rate='190.71', uid='', itenirary_id='1901694', confirmation_number='BR-595210627', comment_contract='', current_status='confirmed', original_source='' where id='315';
[01/19/2024 12:15:09], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],update sight_bookings set gtaToken='',gta_item_confirm_ref='',tour_supplier='',textaddition_activities='N;' where booking_id='315';
[01/19/2024 12:15:09], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
		('','','315','confirmed','2024-01-19 12:15:09','Sightseeing Booking confirmed by Agent..7851','7851','43.239.53.130','','','');
[01/19/2024 12:15:09], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],insert into sight_passangers(booking_id,salutations,tour,first_name,last_name,passenger_type,age)values('315','Mr','1','asdf','fdgsdf','adult','0');
[01/19/2024 12:15:09], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],insert into sight_passangers(booking_id,salutations,tour,first_name,last_name,passenger_type,age)values('315','Mr','1','dfgfdg','dfgdv','adult','0');
[01/19/2024 12:15:09], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],insert into sight_passangers(booking_id,salutations,tour,first_name,last_name,passenger_type,age)values('315','Mr','1','dfg','hjyuij','adult','0');
[01/19/2024 12:15:09], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],update xmllogs set reservation_id='315' where agent_logs_id='1025' and source_type='viator';
[01/19/2024 12:15: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/19_01_2024/request_sight_details_Baysan_Tourism_wh_12_15_09_1705666509.json', 'v1/19_01_2024/response_sight_details_Baysan_Tourism_wh_12_15_09_1705666509.json', 'v1/19_01_2024/response_header_sight_details_Baysan_Tourism_wh_12_15_09_1705666509.json', 'viator', '2024-01-19 12:15:09', '', '', '1027');
[01/19/2024 12:15:13], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],update bookings set invoice_number= 'INV19012400001', voucher_id='1901121513',status_date='2024-01-19 12:15:13',current_status='vouchered',voucher_hashcode='0a5dbc6cae8489fa3f4cfafd326af72b94574315',vouchered_by ='' where id='315';
[01/19/2024 12:15:13], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],update bookings set is_invoiced='yes',invoice_number= 'INV19012400001' where id='315' and is_invoiced!='yes';
[01/19/2024 12:15:13], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE agents SET credit_usage=credit_usage+('715.295997'),   credit_value= credit_value-('715.295997') ,  cd_credit_usage=cd_credit_usage+('715.295997') , cd_credit_value=cd_credit_value-('715.295997')  WHERE id = '7851';
[01/19/2024 12:15:13], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],insert into  agent_credit_log SET agent_id= '7851',credit_value= '6276.696',credit_usage= '3723.304',credit_limit= '10000.000',receipt_id= '',amount= '715.295997',booking_id='315',booking_cost= '',receipt_allocation= '',balance= '',ip='43.239.53.130',user_type='User',admin_id='Agent - Viator  Viator(CD7851)',temp_credit_limit='',log_type='Add Invoice',note='Add Invoice',create_date='2024-01-19 12:01:13';
[01/19/2024 12:15:13], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php], insert into booking_rate_info set  booking_id = '315', booking_log = 'Booking Vouchered', create_date = '2024-01-19 12:15:13', supplier_currency ='USD', type = 'Sale', agent_price = '190.71', sub_agent_price ='', supplier_price = '190.710', supplier_id = 'viator', supplier_type = 'online';
[01/19/2024 12:15:16], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
		('','','315','vouchered-invoiced','2024-01-19 12:15:16','Booking invoiced by Back Office v3alpha on behalf of Agent - Viator  Viator(CD7851)','7851','43.239.53.130','','','');
[01/19/2024 12:15:16], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO agent_commission SET booking_id ='315',booking_detail_id ='315',agent_id ='7851',is_sub_agent ='N',parent_id ='',display_commission ='0',display_currency ='USD',paid ='N',type ='sightseeing',description ='Agent Mark Up Percentage is 0 %',create_date ='2024-01-19 12:15:16';
[01/19/2024 12:15:16], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
		('','','315','vouchered','2024-01-19 12:15:16','Voucherd by Back Office v3alpha on behalf of Agent - Viator  Viator(CD7851)','7851','43.239.53.130','','','');
[01/19/2024 12:16:09], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:16:09' WHERE id= '323';
[01/19/2024 12:16:10], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/19_01_2024/request_sight_details_Baysan_Tourism_wh_12_16_09_1705666569.json', 'v1/19_01_2024/response_sight_details_Baysan_Tourism_wh_12_16_09_1705666569.json', 'v1/19_01_2024/response_header_sight_details_Baysan_Tourism_wh_12_16_09_1705666569.json', 'viator', '2024-01-19 12:16:10', '', '', '1027');
[01/19/2024 12:18:31], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:18:31' WHERE id= '323';
[01/19/2024 12:18: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/19_01_2024/request_sight_details_Baysan_Tourism_wh_12_18_31_1705666711.json', 'v1/19_01_2024/response_sight_details_Baysan_Tourism_wh_12_18_31_1705666711.json', 'v1/19_01_2024/response_header_sight_details_Baysan_Tourism_wh_12_18_31_1705666711.json', 'viator', '2024-01-19 12:18:32', '', '', '1027');
[01/19/2024 12:18:38], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:18:38' WHERE id= '325';
[01/19/2024 12:21:06], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:21:06' WHERE id= '325';
[01/19/2024 12:21:12], [file name :-/home/otrams/public_html/beta/show_hotel_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:21:12' WHERE id= '325';
[01/19/2024 12:21:13], [file name :-/home/otrams/public_html/beta/view_map.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:21:13' WHERE id= '325';
[01/19/2024 12:21:41], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:21:41' WHERE id= '325';
[01/19/2024 12:23:14], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:23:14' WHERE id= '323';
[01/19/2024 12:23:14], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/19_01_2024/request_sight_details_Baysan_Tourism_wh_12_23_14_1705666994.json', 'v1/19_01_2024/response_sight_details_Baysan_Tourism_wh_12_23_14_1705666994.json', 'v1/19_01_2024/response_header_sight_details_Baysan_Tourism_wh_12_23_14_1705666994.json', 'viator', '2024-01-19 12:23:14', '', '', '1027');
[01/19/2024 12:23:23], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:23:23' WHERE id= '323';
[01/19/2024 12:23:23], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/19_01_2024/request_sight_details_Baysan_Tourism_wh_12_23_23_1705667003.json', 'v1/19_01_2024/response_sight_details_Baysan_Tourism_wh_12_23_23_1705667003.json', 'v1/19_01_2024/response_header_sight_details_Baysan_Tourism_wh_12_23_23_1705667003.json', 'viator', '2024-01-19 12:23:23', '', '', '1027');
[01/19/2024 12:24:25], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:24:25' WHERE id= '323';
[01/19/2024 12:24:26], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:24:26' WHERE id= '323';
[01/19/2024 12:24:27], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:24:27' WHERE id= '323';
[01/19/2024 12:24:28], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:24:28' WHERE id= '323';
[01/19/2024 12:24:34], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:24:34' WHERE id= '323';
[01/19/2024 12:24:34], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7863' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '31' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/03/19',  departure_date='2024/03/19',  nights='1',  create_date='2024-01-19 :12:24:34',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '20' ;
[01/19/2024 12:24: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/19_01_2024/request_availability_Baysan_Tourism_wh_12_24_34_1705667074.json', 'v1/19_01_2024/response_availability_Baysan_Tourism_wh_12_24_34_1705667074.json', 'v1/19_01_2024/response_header_availability_Baysan_Tourism_wh_12_24_34_1705667074.json', 'viator', '2024-01-19 12:24:49', '', '', '1028');
[01/19/2024 12:24:53], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:24:53' WHERE id= '323';
[01/19/2024 12:24:54], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:24:54' WHERE id= '323';
[01/19/2024 12:24:56], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:24:56' WHERE id= '323';
[01/19/2024 12:24:56], [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/19_01_2024/request_sight_details_Baysan_Tourism_wh_12_24_56_1705667096.json', 'v1/19_01_2024/response_sight_details_Baysan_Tourism_wh_12_24_56_1705667096.json', 'v1/19_01_2024/response_header_sight_details_Baysan_Tourism_wh_12_24_56_1705667096.json', 'viator', '2024-01-19 12:24:56', '', '', '1028');
[01/19/2024 12:26:00], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:26:00' WHERE id= '325';
[01/19/2024 12:26:05], [file name :-/home/otrams/public_html/beta/show_hotel_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:26:05' WHERE id= '325';
[01/19/2024 12:26:06], [file name :-/home/otrams/public_html/beta/view_map.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:26:06' WHERE id= '325';
[01/19/2024 12:27:25], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:27:25' WHERE id= '325';
[01/19/2024 12:27:29], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:27:29' WHERE id= '325';
[01/19/2024 12:27:29], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7863' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '31' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/01/31',  departure_date='2024/01/31',  nights='1',  create_date='2024-01-19 :12:27:29',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '20' ;
[01/19/2024 12:27: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/19_01_2024/request_availability_Baysan_Tourism_wh_12_27_29_1705667249.json', 'v1/19_01_2024/response_availability_Baysan_Tourism_wh_12_27_29_1705667249.json', 'v1/19_01_2024/response_header_availability_Baysan_Tourism_wh_12_27_29_1705667249.json', 'viator', '2024-01-19 12:27:33', '', '', '1029');
[01/19/2024 12:27:36], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:27:36' WHERE id= '325';
[01/19/2024 12:27:36], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:27:36' WHERE id= '325';
[01/19/2024 12:27:59], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:27:59' WHERE id= '325';
[01/19/2024 12:27:59], [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/19_01_2024/request_sight_details_Baysan_Tourism_wh_12_27_59_1705667279.json', 'v1/19_01_2024/response_sight_details_Baysan_Tourism_wh_12_27_59_1705667279.json', 'v1/19_01_2024/response_header_sight_details_Baysan_Tourism_wh_12_27_59_1705667279.json', 'viator', '2024-01-19 12:27:59', '', '', '1029');
[01/19/2024 12:29:03], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:29:03' WHERE id= '325';
[01/19/2024 12:29:03], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7863' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '31' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/01/31',  departure_date='2024/01/31',  nights='1',  create_date='2024-01-19 :12:29:03',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '20' ;
[01/19/2024 12:29:10], [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/19_01_2024/request_availability_Baysan_Tourism_wh_12_29_03_1705667343.json', 'v1/19_01_2024/response_availability_Baysan_Tourism_wh_12_29_03_1705667343.json', 'v1/19_01_2024/response_header_availability_Baysan_Tourism_wh_12_29_03_1705667343.json', 'viator', '2024-01-19 12:29:10', '', '', '1030');
[01/19/2024 12:29:12], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:29:12' WHERE id= '325';
[01/19/2024 12:29:12], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:29:12' WHERE id= '325';
[01/19/2024 12:29:14], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:29:14' WHERE id= '325';
[01/19/2024 12:29:14], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/19_01_2024/request_sight_details_Baysan_Tourism_wh_12_29_14_1705667354.json', 'v1/19_01_2024/response_sight_details_Baysan_Tourism_wh_12_29_14_1705667354.json', 'v1/19_01_2024/response_header_sight_details_Baysan_Tourism_wh_12_29_14_1705667354.json', 'viator', '2024-01-19 12:29:14', '', '', '1030');
[01/19/2024 12:29:56], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:29:56' WHERE id= '325';
[01/19/2024 12:29:56], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7863' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '31' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/01/31',  departure_date='2024/01/31',  nights='1',  create_date='2024-01-19 :12:29:56',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '20' ;
[01/19/2024 12:30:10], [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/19_01_2024/request_availability_Baysan_Tourism_wh_12_29_56_1705667396.json', 'v1/19_01_2024/response_availability_Baysan_Tourism_wh_12_29_56_1705667396.json', 'v1/19_01_2024/response_header_availability_Baysan_Tourism_wh_12_29_56_1705667396.json', 'viator', '2024-01-19 12:30:10', '', '', '1031');
[01/19/2024 12:30:11], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:30:11' WHERE id= '325';
[01/19/2024 12:30:11], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:30:11' WHERE id= '325';
[01/19/2024 12:30:14], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:30:14' WHERE id= '325';
[01/19/2024 12:30:15], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/19_01_2024/request_sight_details_Baysan_Tourism_wh_12_30_14_1705667414.json', 'v1/19_01_2024/response_sight_details_Baysan_Tourism_wh_12_30_14_1705667414.json', 'v1/19_01_2024/response_header_sight_details_Baysan_Tourism_wh_12_30_14_1705667414.json', 'viator', '2024-01-19 12:30:15', '', '', '1031');
[01/19/2024 12:31:44], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:31:44' WHERE id= '325';
[01/19/2024 12:31:44], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7863' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '31' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/01/31',  departure_date='2024/01/31',  nights='1',  create_date='2024-01-19 :12:31:44',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '20' ;
[01/19/2024 12:31:50], [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/19_01_2024/request_availability_Baysan_Tourism_wh_12_31_44_1705667504.json', 'v1/19_01_2024/response_availability_Baysan_Tourism_wh_12_31_44_1705667504.json', 'v1/19_01_2024/response_header_availability_Baysan_Tourism_wh_12_31_44_1705667504.json', 'viator', '2024-01-19 12:31:50', '', '', '1032');
[01/19/2024 12:31:51], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:31:51' WHERE id= '325';
[01/19/2024 12:31:51], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7863' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '31' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/01/31',  departure_date='2024/01/31',  nights='1',  create_date='2024-01-19 :12:31:51',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '20' ;
[01/19/2024 12:31: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/19_01_2024/request_availability_Baysan_Tourism_wh_12_31_51_1705667511.json', 'v1/19_01_2024/response_availability_Baysan_Tourism_wh_12_31_51_1705667511.json', 'v1/19_01_2024/response_header_availability_Baysan_Tourism_wh_12_31_51_1705667511.json', 'viator', '2024-01-19 12:31:58', '', '', '1033');
[01/19/2024 12:31:59], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:31:59' WHERE id= '325';
[01/19/2024 12:31:59], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:31:59' WHERE id= '325';
[01/19/2024 12:32:02], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:32:02' WHERE id= '325';
[01/19/2024 12:32:02], [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/19_01_2024/request_sight_details_Baysan_Tourism_wh_12_32_02_1705667522.json', 'v1/19_01_2024/response_sight_details_Baysan_Tourism_wh_12_32_02_1705667522.json', 'v1/19_01_2024/response_header_sight_details_Baysan_Tourism_wh_12_32_02_1705667522.json', 'viator', '2024-01-19 12:32:02', '', '', '1033');
[01/19/2024 12:33:11], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-19 12:33:11',login_attempt=0 where id = '7839';
[01/19/2024 12:33:11], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'sqtech', user_type = 'A', branch_id = '28', login_datetime = '2024-01-19 12:33:11', ip = '43.239.53.130', action = 'Login' ;
[01/19/2024 12:33:12], [file name :-/home/otrams/public_html/beta/hotel_search.php],insert into user_sessions_ip SET ip_addr='43.239.53.130', agent_id='7839', session_id='795dc4701561a6008fc5ff132456e6135c71d59518c807b5d7e0225448a92a1b',create_date='2024-01-19 12:33:12', update_date='2024-01-19 12:33:12',domain='beta.astrabookings.com',sub_agent_id='',sub_user_id='';
[01/19/2024 12:33:36], [file name :-/home/otrams/public_html/beta/tms/agent.php],DELETE FROM agent_supplier_settings WHERE 1  and agent_id= ? ;
[01/19/2024 12:33:36], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '67' ,status = '1' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[01/19/2024 12:33:36], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '52' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/19/2024 12:33:36], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '76' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/19/2024 12:33:36], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '24' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/19/2024 12:33:36], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '77' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/19/2024 12:33:36], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '64' ,status = '' ,priority = '' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/19/2024 12:33:36], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '65' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/19/2024 12:33:36], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '34' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/19/2024 12:33:36], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '20' ,status = '1' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[01/19/2024 12:33:36], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '55' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/19/2024 12:33:36], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '62' ,status = '1' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[01/19/2024 12:33:36], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '53' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/19/2024 12:33:36], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '16' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/19/2024 12:33:36], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '75' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/19/2024 12:33:36], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '60' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/19/2024 12:33:36], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '18' ,status = '1' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/19/2024 12:33:36], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '19' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/19/2024 12:33:36], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '73' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/19/2024 12:33:36], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '71' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/19/2024 12:33:36], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '69' ,status = '1' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/19/2024 12:33:36], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '68' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/19/2024 12:33:36], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '74' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/19/2024 12:33:36], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '35' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/19/2024 12:33:36], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '70' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/19/2024 12:33:36], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '59' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/19/2024 12:33:36], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '32' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/19/2024 12:33:36], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '58' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/19/2024 12:33:36], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '56' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/19/2024 12:33:36], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '57' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/19/2024 12:33:36], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '61' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/19/2024 12:33:36], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '63' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/19/2024 12:33:36], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '54' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/19/2024 12:33:36], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '66' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/19/2024 12:33:36], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '45' ,status = '' ,priority = '' ,lead_time = '',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/19/2024 12:33:36], [file name :-/home/otrams/public_html/beta/tms/agent.php],insert into `user_logs` set `username`= 'v3alpha',`create_date`= '2024-01-19 12:33:36',`log_type`= 'Agent Supplier settings',`sql_query`= '======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#039;,supplier_id = 67 ,status = \&#039;1\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#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;7839\&#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;7839\&#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;7839\&#039;,supplier_id = 77 ,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;7839\&#039;,supplier_id = 64 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;96\&#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;7839\&#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;7839\&#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;7839\&#039;,supplier_id = 20 ,status = \&#039;1\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#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;7839\&#039;,supplier_id = 62 ,status = \&#039;1\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#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;7839\&#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;7839\&#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;7839\&#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;7839\&#039;,supplier_id = 18 ,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;7839\&#039;,supplier_id = 19 ,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;7839\&#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;7839\&#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;7839\&#039;,supplier_id = 69 ,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;7839\&#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;7839\&#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;7839\&#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;7839\&#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;7839\&#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;7839\&#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;7839\&#039;,supplier_id = 58 ,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;7839\&#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;7839\&#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;7839\&#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;7839\&#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;7839\&#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;7839\&#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;7839\&#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-7839 ## supplier_id- 67 ## company_name - Agoda ## supplier_code-agoda  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-7839 ## supplier_id- 20 ## company_name - Hotelbeds ## supplier_code-hotelbeds  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-7839 ## supplier_id- 62 ## company_name - local_system ## supplier_code-localsystem  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-7839 ## supplier_id- 69 ## company_name - Amadeus Flight ## supplier_code-amadeus  ## percentage - 0.00 ## lead_time - 0 ',`ip`= '43.239.53.130';
[01/19/2024 12:33:37], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:33:37' WHERE id= '326';
[01/19/2024 12:34:13], [file name :-/home/otrams/public_html/beta/tms/agent.php],DELETE FROM agent_supplier_settings WHERE 1  and agent_id= ? ;
[01/19/2024 12:34:13], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '67' ,status = '1' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[01/19/2024 12:34:13], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '52' ,status = '1' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/19/2024 12:34:13], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '76' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/19/2024 12:34:13], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '24' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/19/2024 12:34:13], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '77' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/19/2024 12:34:13], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '64' ,status = '' ,priority = '' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/19/2024 12:34:13], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '65' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/19/2024 12:34:13], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '34' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/19/2024 12:34:13], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '20' ,status = '1' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[01/19/2024 12:34:13], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '55' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/19/2024 12:34:13], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '62' ,status = '1' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[01/19/2024 12:34:13], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '53' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/19/2024 12:34:13], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '16' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/19/2024 12:34:13], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '75' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/19/2024 12:34:13], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '60' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/19/2024 12:34:13], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '18' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/19/2024 12:34:13], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '19' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/19/2024 12:34:13], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '73' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/19/2024 12:34:13], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '71' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/19/2024 12:34:13], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '69' ,status = '1' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/19/2024 12:34:13], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '68' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/19/2024 12:34:13], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '74' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/19/2024 12:34:13], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '35' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/19/2024 12:34:13], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '70' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/19/2024 12:34:13], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '59' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/19/2024 12:34:13], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '32' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/19/2024 12:34:13], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '58' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/19/2024 12:34:13], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '56' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/19/2024 12:34:13], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '57' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/19/2024 12:34:13], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '61' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/19/2024 12:34:13], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '63' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/19/2024 12:34:13], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '54' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/19/2024 12:34:13], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '66' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/19/2024 12:34:13], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '45' ,status = '' ,priority = '' ,lead_time = '',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/19/2024 12:34:13], [file name :-/home/otrams/public_html/beta/tms/agent.php],insert into `user_logs` set `username`= 'v3alpha',`create_date`= '2024-01-19 12:34:13',`log_type`= 'Agent Supplier settings',`sql_query`= '======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#039;,supplier_id = 67 ,status = \&#039;1\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#039;,supplier_id = 52 ,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;7839\&#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;7839\&#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;7839\&#039;,supplier_id = 77 ,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;7839\&#039;,supplier_id = 64 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;96\&#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;7839\&#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;7839\&#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;7839\&#039;,supplier_id = 20 ,status = \&#039;1\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#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;7839\&#039;,supplier_id = 62 ,status = \&#039;1\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#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;7839\&#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;7839\&#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;7839\&#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;7839\&#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;7839\&#039;,supplier_id = 19 ,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;7839\&#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;7839\&#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;7839\&#039;,supplier_id = 69 ,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;7839\&#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;7839\&#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;7839\&#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;7839\&#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;7839\&#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;7839\&#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;7839\&#039;,supplier_id = 58 ,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;7839\&#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;7839\&#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;7839\&#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;7839\&#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;7839\&#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;7839\&#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;7839\&#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-7839 ## supplier_id- 67 ## company_name - Agoda ## supplier_code-agoda  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-7839 ## supplier_id- 20 ## company_name - Hotelbeds ## supplier_code-hotelbeds  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-7839 ## supplier_id- 62 ## company_name - local_system ## supplier_code-localsystem  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-7839 ## supplier_id- 18 ## company_name - Tourico ## supplier_code-tourico  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-7839 ## supplier_id- 69 ## company_name - Amadeus Flight ## supplier_code-amadeus  ## percentage - 0.00 ## lead_time - 0 ',`ip`= '43.239.53.130';
[01/19/2024 12:34:15], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:34:15' WHERE id= '326';
[01/19/2024 12:34:30], [file name :-/home/otrams/public_html/beta/tms/agent.php],DELETE FROM agent_supplier_settings WHERE 1  and agent_id= ? ;
[01/19/2024 12:34:30], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '67' ,status = '1' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[01/19/2024 12:34:30], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '52' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/19/2024 12:34:30], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '76' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/19/2024 12:34:30], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '24' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/19/2024 12:34:30], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '77' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/19/2024 12:34:30], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '64' ,status = '' ,priority = '' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/19/2024 12:34:30], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '65' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/19/2024 12:34:30], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '34' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/19/2024 12:34:30], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '20' ,status = '1' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[01/19/2024 12:34:30], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '55' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/19/2024 12:34:30], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '62' ,status = '1' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[01/19/2024 12:34:30], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '53' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/19/2024 12:34:30], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '16' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/19/2024 12:34:30], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '75' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/19/2024 12:34:30], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '60' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/19/2024 12:34:30], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '18' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/19/2024 12:34:30], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '19' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/19/2024 12:34:30], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '73' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/19/2024 12:34:30], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '71' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/19/2024 12:34:30], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '69' ,status = '1' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/19/2024 12:34:30], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '68' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/19/2024 12:34:30], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '74' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/19/2024 12:34:30], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '35' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/19/2024 12:34:30], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '70' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/19/2024 12:34:30], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '59' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/19/2024 12:34:30], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '32' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/19/2024 12:34:30], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '58' ,status = '1' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/19/2024 12:34:30], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '56' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/19/2024 12:34:30], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '57' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/19/2024 12:34:30], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '61' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/19/2024 12:34:30], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '63' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/19/2024 12:34:30], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '54' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/19/2024 12:34:30], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '66' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/19/2024 12:34:30], [file name :-/home/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7839',supplier_id = '45' ,status = '' ,priority = '' ,lead_time = '',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[01/19/2024 12:34:30], [file name :-/home/otrams/public_html/beta/tms/agent.php],insert into `user_logs` set `username`= 'v3alpha',`create_date`= '2024-01-19 12:34:30',`log_type`= 'Agent Supplier settings',`sql_query`= '======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#039;,supplier_id = 67 ,status = \&#039;1\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#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;7839\&#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;7839\&#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;7839\&#039;,supplier_id = 77 ,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;7839\&#039;,supplier_id = 64 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;96\&#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;7839\&#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;7839\&#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;7839\&#039;,supplier_id = 20 ,status = \&#039;1\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#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;7839\&#039;,supplier_id = 62 ,status = \&#039;1\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7839\&#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;7839\&#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;7839\&#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;7839\&#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;7839\&#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;7839\&#039;,supplier_id = 19 ,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;7839\&#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;7839\&#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;7839\&#039;,supplier_id = 69 ,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;7839\&#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;7839\&#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;7839\&#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;7839\&#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;7839\&#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;7839\&#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;7839\&#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;7839\&#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;7839\&#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;7839\&#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;7839\&#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;7839\&#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;7839\&#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;7839\&#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-7839 ## supplier_id- 67 ## company_name - Agoda ## supplier_code-agoda  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-7839 ## supplier_id- 52 ## company_name - Alphatours Dubai- Live ## supplier_code-alphatours  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-7839 ## supplier_id- 20 ## company_name - Hotelbeds ## supplier_code-hotelbeds  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-7839 ## supplier_id- 62 ## company_name - local_system ## supplier_code-localsystem  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-7839 ## supplier_id- 69 ## company_name - Amadeus Flight ## supplier_code-amadeus  ## percentage - 0.00 ## lead_time - 0 ',`ip`= '43.239.53.130';
[01/19/2024 12:34:31], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:34:31' WHERE id= '326';
[01/19/2024 12:34:31], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:34:31' WHERE id= '309';
[01/19/2024 12:34:31], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-19 12:34:31',login_attempt=0 where id = '7851';
[01/19/2024 12:34:31], [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-19 12:34:31', ip = '43.239.53.130', action = 'Login' ;
[01/19/2024 12:34:32], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:34:32' WHERE id= '309';
[01/19/2024 12:34:33], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:34:33' WHERE id= '326';
[01/19/2024 12:34:34], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:34:34' WHERE id= '309';
[01/19/2024 12:34:36], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:34:36' WHERE id= '326';
[01/19/2024 12:34:38], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:34:38' WHERE id= '309';
[01/19/2024 12:34:38], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:34:38' WHERE id= '326';
[01/19/2024 12:34:38], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7839' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '28' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/01/26',  departure_date='2024/01/26',  nights='1',  create_date='2024-01-19 :12:34:38',  nationality='',  additional_markup='',  selected_currency='SAR',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/19/2024 12:34: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/19_01_2024/request_availability_sqtech_12_34_38_1705667678.json', 'v1/19_01_2024/response_availability_sqtech_12_34_38_1705667678.json', 'v1/19_01_2024/response_header_availability_sqtech_12_34_38_1705667678.json', 'viator', '2024-01-19 12:34:46', '', '', '1034');
[01/19/2024 12:34:47], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:34:47' WHERE id= '326';
[01/19/2024 12:34:47], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:34:47' WHERE id= '326';
[01/19/2024 12:34:49], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:34:49' WHERE id= '309';
[01/19/2024 12:34:49], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7851' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '27' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/01/22',  departure_date='2024/01/22',  nights='1',  create_date='2024-01-19 :12:34:49',  nationality='',  additional_markup='',  selected_currency='SAR',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/19/2024 12:34:50], [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/19_01_2024/request_availability_Viator_test_12_34_49_1705667689.json', 'v1/19_01_2024/response_availability_Viator_test_12_34_49_1705667689.json', 'v1/19_01_2024/response_header_availability_Viator_test_12_34_49_1705667689.json', 'viator', '2024-01-19 12:34:50', '', '', '1035');
[01/19/2024 12:34:51], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:34:51' WHERE id= '309';
[01/19/2024 12:34:51], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:34:51' WHERE id= '309';
[01/19/2024 12:34:53], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:34:53' WHERE id= '326';
[01/19/2024 12:34: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/19_01_2024/request_sight_details_sqtech_12_34_53_1705667693.json', 'v1/19_01_2024/response_sight_details_sqtech_12_34_53_1705667693.json', 'v1/19_01_2024/response_header_sight_details_sqtech_12_34_53_1705667693.json', 'viator', '2024-01-19 12:34:54', '', '', '1034');
[01/19/2024 12:34:55], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:34:55' WHERE id= '309';
[01/19/2024 12:34:56], [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/19_01_2024/request_sight_details_Viator_test_12_34_55_1705667695.json', 'v1/19_01_2024/response_sight_details_Viator_test_12_34_55_1705667695.json', 'v1/19_01_2024/response_header_sight_details_Viator_test_12_34_55_1705667695.json', 'viator', '2024-01-19 12:34:56', '', '', '1035');
[01/19/2024 12:34:56], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:34:56' WHERE id= '326';
[01/19/2024 12:34:56], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'check_availability', 'v1/19_01_2024/request_check_availability_sqtech_12_34_56_1705667696.json', 'v1/19_01_2024/response_check_availability_sqtech_12_34_56_1705667696.json', 'v1/19_01_2024/response_header_check_availability_sqtech_12_34_56_1705667696.json', 'viator', '2024-01-19 12:34:56', '', '', '1034');
[01/19/2024 12:34:57], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:34:57' WHERE id= '326';
[01/19/2024 12:34: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 ('', 'check_availability', 'v1/19_01_2024/request_check_availability_sqtech_12_34_57_1705667697.json', 'v1/19_01_2024/response_check_availability_sqtech_12_34_57_1705667697.json', 'v1/19_01_2024/response_header_check_availability_sqtech_12_34_57_1705667697.json', 'viator', '2024-01-19 12:34:58', '', '', '1034');
[01/19/2024 12:34:58], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:34:58' WHERE id= '326';
[01/19/2024 12:34: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 ('', 'check_availability', 'v1/19_01_2024/request_check_availability_sqtech_12_34_58_1705667698.json', 'v1/19_01_2024/response_check_availability_sqtech_12_34_58_1705667698.json', 'v1/19_01_2024/response_header_check_availability_sqtech_12_34_58_1705667698.json', 'viator', '2024-01-19 12:34:58', '', '', '1034');
[01/19/2024 12:35:01], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:35:01' WHERE id= '326';
[01/19/2024 12:35:01], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:35:01' WHERE id= '309';
[01/19/2024 12:35:01], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'check_availability', 'v1/19_01_2024/request_check_availability_sqtech_12_35_01_1705667701.json', 'v1/19_01_2024/response_check_availability_sqtech_12_35_01_1705667701.json', 'v1/19_01_2024/response_header_check_availability_sqtech_12_35_01_1705667701.json', 'viator', '2024-01-19 12:35:01', '', '', '1034');
[01/19/2024 12:35:01], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:35:01' WHERE id= '326';
[01/19/2024 12:35:01], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'check_availability', 'v1/19_01_2024/request_check_availability_Viator_test_12_35_01_1705667701.json', 'v1/19_01_2024/response_check_availability_Viator_test_12_35_01_1705667701.json', 'v1/19_01_2024/response_header_check_availability_Viator_test_12_35_01_1705667701.json', 'viator', '2024-01-19 12:35:01', '', '', '1035');
[01/19/2024 12:35:02], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'check_availability', 'v1/19_01_2024/request_check_availability_sqtech_12_35_01_1705667701.json', 'v1/19_01_2024/response_check_availability_sqtech_12_35_01_1705667701.json', 'v1/19_01_2024/response_header_check_availability_sqtech_12_35_01_1705667701.json', 'viator', '2024-01-19 12:35:02', '', '', '1034');
[01/19/2024 12:35:02], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:35:02' WHERE id= '326';
[01/19/2024 12:35:02], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'check_availability', 'v1/19_01_2024/request_check_availability_sqtech_12_35_02_1705667702.json', 'v1/19_01_2024/response_check_availability_sqtech_12_35_02_1705667702.json', 'v1/19_01_2024/response_header_check_availability_sqtech_12_35_02_1705667702.json', 'viator', '2024-01-19 12:35:02', '', '', '1034');
[01/19/2024 12:35:02], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:35:02' WHERE id= '326';
[01/19/2024 12:35:02], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'check_availability', 'v1/19_01_2024/request_check_availability_sqtech_12_35_02_1705667702.json', 'v1/19_01_2024/response_check_availability_sqtech_12_35_02_1705667702.json', 'v1/19_01_2024/response_header_check_availability_sqtech_12_35_02_1705667702.json', 'viator', '2024-01-19 12:35:02', '', '', '1034');
[01/19/2024 12:35:03], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:35:03' WHERE id= '326';
[01/19/2024 12:35:03], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'check_availability', 'v1/19_01_2024/request_check_availability_sqtech_12_35_03_1705667703.json', 'v1/19_01_2024/response_check_availability_sqtech_12_35_03_1705667703.json', 'v1/19_01_2024/response_header_check_availability_sqtech_12_35_03_1705667703.json', 'viator', '2024-01-19 12:35:03', '', '', '1034');
[01/19/2024 12:35:03], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:35:03' WHERE id= '326';
[01/19/2024 12:35:03], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'check_availability', 'v1/19_01_2024/request_check_availability_sqtech_12_35_03_1705667703.json', 'v1/19_01_2024/response_check_availability_sqtech_12_35_03_1705667703.json', 'v1/19_01_2024/response_header_check_availability_sqtech_12_35_03_1705667703.json', 'viator', '2024-01-19 12:35:03', '', '', '1034');
[01/19/2024 12:35:05], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:35:05' WHERE id= '326';
[01/19/2024 12:35: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/19_01_2024/request_sight_details_sqtech_12_35_05_1705667705.json', 'v1/19_01_2024/response_sight_details_sqtech_12_35_05_1705667705.json', 'v1/19_01_2024/response_header_sight_details_sqtech_12_35_05_1705667705.json', 'viator', '2024-01-19 12:35:05', '', '', '1034');
[01/19/2024 12:35:06], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:35:06' WHERE id= '326';
[01/19/2024 12:35:06], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'check_availability', 'v1/19_01_2024/request_check_availability_sqtech_12_35_06_1705667706.json', 'v1/19_01_2024/response_check_availability_sqtech_12_35_06_1705667706.json', 'v1/19_01_2024/response_header_check_availability_sqtech_12_35_06_1705667706.json', 'viator', '2024-01-19 12:35:06', '', '', '1034');
[01/19/2024 12:35:07], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:35:07' WHERE id= '326';
[01/19/2024 12:35:07], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'check_availability', 'v1/19_01_2024/request_check_availability_sqtech_12_35_07_1705667707.json', 'v1/19_01_2024/response_check_availability_sqtech_12_35_07_1705667707.json', 'v1/19_01_2024/response_header_check_availability_sqtech_12_35_07_1705667707.json', 'viator', '2024-01-19 12:35:07', '', '', '1034');
[01/19/2024 12:35:24], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:35:24' WHERE id= '325';
[01/19/2024 12:35:24], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/19_01_2024/request_sight_details_Baysan_Tourism_wh_12_35_24_1705667724.json', 'v1/19_01_2024/response_sight_details_Baysan_Tourism_wh_12_35_24_1705667724.json', 'v1/19_01_2024/response_header_sight_details_Baysan_Tourism_wh_12_35_24_1705667724.json', 'viator', '2024-01-19 12:35:24', '', '', '1033');
[01/19/2024 12:35:27], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:35:27' WHERE id= '325';
[01/19/2024 12:35:31], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:35:31' WHERE id= '325';
[01/19/2024 12:35:31], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7866' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '31' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '138' , service_type = 'hotel' , arrival_date = '2024/01/31' , departure_date = '2024/02/01' , nights = '1' , nationality = '138' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-01-19 12:35:31' , site_id = '20' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[01/19/2024 12:35:32], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:35:32' WHERE id= '325';
[01/19/2024 12:35:32], [file name :-/home/otrams/public_html/beta/call.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', 'e1/19_01_2024/request_availability_Baysan_Tourism_wh_12_35_32_1705667732_69.json', 'e1/19_01_2024/response_availability_Baysan_Tourism_wh_12_35_32_1705667732_69.json', 'e1/19_01_2024/response_header_availability_Baysan_Tourism_wh_12_35_32_1705667732_69.json', 'expedia', '2024-01-19 12:35:32', '', 'c9d07ec2a2f169d539285613c4bbf0aee5053f774137d385c6d757fe65c2853f', '0');
[01/19/2024 12:35:32], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=c9d07ec2a2f169d539285613c4bbf0aee5053f774137d385c6d757fe65c2853f&xml_user_id=7863&db_caching=1&erequest=2&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F120.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=138'
            , http_hit_time = '2024-01-19 12:35:32.276'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '0.288'
            , error_description = ''
            , memory_used = '1769368'
            WHERE id = '28916';
[01/19/2024 12:35:32], [file name :-/home/otrams/public_html/beta/call.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', 'e1p/19_01_2024/request_availability_Baysan_Tourism_wh_12_35_32_1705667732_9.json', 'e1p/19_01_2024/response_availability_Baysan_Tourism_wh_12_35_32_1705667732_9.json', 'e1p/19_01_2024/response_header_availability_Baysan_Tourism_wh_12_35_32_1705667732_9.json', 'expediapackage', '2024-01-19 12:35:32', '', 'c9d07ec2a2f169d539285613c4bbf0aee5053f774137d385c6d757fe65c2853f', '0');
[01/19/2024 12:35:32], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=c9d07ec2a2f169d539285613c4bbf0aee5053f774137d385c6d757fe65c2853f&xml_user_id=7863&db_caching=1&erequest=2&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F120.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=138'
            , http_hit_time = '2024-01-19 12:35:32.276'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '0.297'
            , error_description = ''
            , memory_used = '1826496'
            WHERE id = '28917';
[01/19/2024 12:35:33], [file name :-/home/otrams/public_html/beta/call.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', 'e1/19_01_2024/request_availability_Baysan_Tourism_wh_12_35_32_1705667732_13.json', 'e1/19_01_2024/response_availability_Baysan_Tourism_wh_12_35_32_1705667732_13.json', 'e1/19_01_2024/response_header_availability_Baysan_Tourism_wh_12_35_32_1705667732_13.json', 'expedia', '2024-01-19 12:35:33', '', 'c9d07ec2a2f169d539285613c4bbf0aee5053f774137d385c6d757fe65c2853f', '0');
[01/19/2024 12:35:34], [file name :-/home/otrams/public_html/beta/call.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', 'e1/19_01_2024/request_availability_Baysan_Tourism_wh_12_35_32_1705667732_34.json', 'e1/19_01_2024/response_availability_Baysan_Tourism_wh_12_35_32_1705667732_34.json', 'e1/19_01_2024/response_header_availability_Baysan_Tourism_wh_12_35_32_1705667732_34.json', 'expedia', '2024-01-19 12:35:34', '', 'c9d07ec2a2f169d539285613c4bbf0aee5053f774137d385c6d757fe65c2853f', '0');
[01/19/2024 12:35:35], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=c9d07ec2a2f169d539285613c4bbf0aee5053f774137d385c6d757fe65c2853f&xml_user_id=7863&db_caching=1&erequest=0&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F120.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=138'
            , http_hit_time = '2024-01-19 12:35:32.275'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '2.773'
            , error_description = ''
            , memory_used = '168308088'
            WHERE id = '28918';
[01/19/2024 12:35:35], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=c9d07ec2a2f169d539285613c4bbf0aee5053f774137d385c6d757fe65c2853f&xml_user_id=7863&db_caching=1&erequest=1&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F120.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=138'
            , http_hit_time = '2024-01-19 12:35:32.275'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '3.035'
            , error_description = ''
            , memory_used = '152506072'
            WHERE id = '28919';
[01/19/2024 12:35:35], [file name :-/home/otrams/public_html/beta/call.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', 'e1p/19_01_2024/request_availability_Baysan_Tourism_wh_12_35_32_1705667732_88.json', 'e1p/19_01_2024/response_availability_Baysan_Tourism_wh_12_35_32_1705667732_88.json', 'e1p/19_01_2024/response_header_availability_Baysan_Tourism_wh_12_35_32_1705667732_88.json', 'expediapackage', '2024-01-19 12:35:35', '', 'c9d07ec2a2f169d539285613c4bbf0aee5053f774137d385c6d757fe65c2853f', '0');
[01/19/2024 12:35:35], [file name :-/home/otrams/public_html/beta/call.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', 'e1p/19_01_2024/request_availability_Baysan_Tourism_wh_12_35_32_1705667732_50.json', 'e1p/19_01_2024/response_availability_Baysan_Tourism_wh_12_35_32_1705667732_50.json', 'e1p/19_01_2024/response_header_availability_Baysan_Tourism_wh_12_35_32_1705667732_50.json', 'expediapackage', '2024-01-19 12:35:35', '', 'c9d07ec2a2f169d539285613c4bbf0aee5053f774137d385c6d757fe65c2853f', '0');
[01/19/2024 12:35:36], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=c9d07ec2a2f169d539285613c4bbf0aee5053f774137d385c6d757fe65c2853f&xml_user_id=7863&db_caching=1&erequest=0&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F120.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=138'
            , http_hit_time = '2024-01-19 12:35:32.275'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '4.533'
            , error_description = ''
            , memory_used = '177691448'
            WHERE id = '28920';
[01/19/2024 12:35:36], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=c9d07ec2a2f169d539285613c4bbf0aee5053f774137d385c6d757fe65c2853f&xml_user_id=7863&db_caching=1&erequest=1&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F120.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=138'
            , http_hit_time = '2024-01-19 12:35:32.275'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '4.636'
            , error_description = ''
            , memory_used = '159212896'
            WHERE id = '28921';
[01/19/2024 12:35:37], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:35:37' WHERE id= '325';
[01/19/2024 12:35:38], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:35:38' WHERE id= '325';
[01/19/2024 12:35:38], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:35:38' WHERE id= '325';
[01/19/2024 12:35:41], [file name :-/home/otrams/public_html/beta/show_hotel_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:35:41' WHERE id= '325';
[01/19/2024 12:35:41], [file name :-/home/otrams/public_html/beta/view_map.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:35:41' WHERE id= '325';
[01/19/2024 12:44:12], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:44:12' WHERE id= '309';
[01/19/2024 12:44:12], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-19 12:44:12',login_attempt=0 where id = '7851';
[01/19/2024 12:44:12], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Viator_test', user_type = 'A', branch_id = '27', login_datetime = '2024-01-19 12:44:12', ip = '43.239.53.130', action = 'Login' ;
[01/19/2024 12:44:13], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:44:13' WHERE id= '309';
[01/19/2024 12:44:16], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:44:16' WHERE id= '309';
[01/19/2024 12:44:20], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:44:20' WHERE id= '309';
[01/19/2024 12:44:30], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:44:30' WHERE id= '309';
[01/19/2024 12:44:30], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7851' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '27' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/01/22',  departure_date='2024/01/22',  nights='1',  create_date='2024-01-19 :12:44:30',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/19/2024 12:44:30], [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/19_01_2024/request_availability_Viator_test_12_44_30_1705668270.json', 'v1/19_01_2024/response_availability_Viator_test_12_44_30_1705668270.json', 'v1/19_01_2024/response_header_availability_Viator_test_12_44_30_1705668270.json', 'viator', '2024-01-19 12:44:30', '', '', '1036');
[01/19/2024 12:44:31], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:44:31' WHERE id= '309';
[01/19/2024 12:44:32], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:44:32' WHERE id= '309';
[01/19/2024 12:44:46], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:44:46' WHERE id= '309';
[01/19/2024 12:44:46], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7851' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '27' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/01/22',  departure_date='2024/01/22',  nights='1',  create_date='2024-01-19 :12:44:46',  nationality='',  additional_markup='',  selected_currency='AED',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/19/2024 12:44:47], [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/19_01_2024/request_availability_Viator_test_12_44_46_1705668286.json', 'v1/19_01_2024/response_availability_Viator_test_12_44_46_1705668286.json', 'v1/19_01_2024/response_header_availability_Viator_test_12_44_46_1705668286.json', 'viator', '2024-01-19 12:44:47', '', '', '1037');
[01/19/2024 12:44:48], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:44:48' WHERE id= '309';
[01/19/2024 12:44:48], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:44:48' WHERE id= '309';
[01/19/2024 12:49:11], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:49:11' WHERE id= '309';
[01/19/2024 12:49:11], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7851' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '27' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/01/22',  departure_date='2024/01/22',  nights='1',  create_date='2024-01-19 :12:49:11',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/19/2024 12:49:14], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'v1/19_01_2024/request_availability_Viator_test_12_49_11_1705668551.json', 'v1/19_01_2024/response_availability_Viator_test_12_49_11_1705668551.json', 'v1/19_01_2024/response_header_availability_Viator_test_12_49_11_1705668551.json', 'viator', '2024-01-19 12:49:14', '', '', '1038');
[01/19/2024 12:49:15], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:49:15' WHERE id= '309';
[01/19/2024 12:49:15], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:49:15' WHERE id= '309';
[01/19/2024 12:49:21], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:49:21' WHERE id= '309';
[01/19/2024 12:49:27], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:49:27' WHERE id= '309';
[01/19/2024 12:49:27], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7851' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '27' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/01/22',  departure_date='2024/01/22',  nights='1',  create_date='2024-01-19 :12:49:27',  nationality='',  additional_markup='',  selected_currency='AED',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/19/2024 12:49:27], [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/19_01_2024/request_availability_Viator_test_12_49_27_1705668567.json', 'v1/19_01_2024/response_availability_Viator_test_12_49_27_1705668567.json', 'v1/19_01_2024/response_header_availability_Viator_test_12_49_27_1705668567.json', 'viator', '2024-01-19 12:49:27', '', '', '1039');
[01/19/2024 12:49:28], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:49:28' WHERE id= '309';
[01/19/2024 12:49:28], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:49:28' WHERE id= '309';
[01/19/2024 12:50:15], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:50:15' WHERE id= '309';
[01/19/2024 12:50:18], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:50:18' WHERE id= '309';
[01/19/2024 12:50:23], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:50:23' WHERE id= '309';
[01/19/2024 12:50:33], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:50:33' WHERE id= '309';
[01/19/2024 12:51:47], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:51:47' WHERE id= '309';
[01/19/2024 12:52:53], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:52:53' WHERE id= '309';
[01/19/2024 12:52:53], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7851' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '27' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/01/22',  departure_date='2024/01/22',  nights='1',  create_date='2024-01-19 :12:52:53',  nationality='',  additional_markup='',  selected_currency='AED',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/19/2024 12:52:53], [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/19_01_2024/request_availability_Viator_test_12_52_53_1705668773.json', 'v1/19_01_2024/response_availability_Viator_test_12_52_53_1705668773.json', 'v1/19_01_2024/response_header_availability_Viator_test_12_52_53_1705668773.json', 'viator', '2024-01-19 12:52:53', '', '', '1040');
[01/19/2024 12:52:55], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:52:55' WHERE id= '309';
[01/19/2024 12:52:55], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:52:55' WHERE id= '309';
[01/19/2024 12:54:27], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:54:27' WHERE id= '309';
[01/19/2024 12:54:27], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7851' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '27' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/01/22',  departure_date='2024/01/22',  nights='1',  create_date='2024-01-19 :12:54:27',  nationality='',  additional_markup='',  selected_currency='AED',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/19/2024 12:54: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/19_01_2024/request_availability_Viator_test_12_54_27_1705668867.json', 'v1/19_01_2024/response_availability_Viator_test_12_54_27_1705668867.json', 'v1/19_01_2024/response_header_availability_Viator_test_12_54_27_1705668867.json', 'viator', '2024-01-19 12:54:29', '', '', '1041');
[01/19/2024 12:55:43], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:55:43' WHERE id= '325';
[01/19/2024 12:58:04], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:58:04' WHERE id= '309';
[01/19/2024 12:58:04], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7851' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '27' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/01/22',  departure_date='2024/01/22',  nights='1',  create_date='2024-01-19 :12:58:04',  nationality='',  additional_markup='',  selected_currency='AED',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/19/2024 12:58: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/19_01_2024/request_availability_Viator_test_12_58_04_1705669084.json', 'v1/19_01_2024/response_availability_Viator_test_12_58_04_1705669084.json', 'v1/19_01_2024/response_header_availability_Viator_test_12_58_04_1705669084.json', 'viator', '2024-01-19 12:58:05', '', '', '1042');
[01/19/2024 12:58:06], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:58:06' WHERE id= '309';
[01/19/2024 12:58:06], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:58:06' WHERE id= '309';
[01/19/2024 12:59:58], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 12:59:58' WHERE id= '309';
[01/19/2024 12:59:58], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7851' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '27' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/01/22',  departure_date='2024/01/22',  nights='1',  create_date='2024-01-19 :12:59:58',  nationality='',  additional_markup='',  selected_currency='AED',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/19/2024 12:59:59], [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/19_01_2024/request_availability_Viator_test_12_59_58_1705669198.json', 'v1/19_01_2024/response_availability_Viator_test_12_59_58_1705669198.json', 'v1/19_01_2024/response_header_availability_Viator_test_12_59_58_1705669198.json', 'viator', '2024-01-19 12:59:59', '', '', '1043');
