[08/21/2023 10:00:44], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO ws_logs(request_path,response_path,userid,search_unique_id,booking_id,log_date_time,end_time,action_type,error_description,error_code,response_time,agent_log_id)
		VALUES('https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/21_08_2023/request_hotel_search_Tripathon_10_00_44_1692612044_7297910.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/21_08_2023/response_hotel_search_Tripathon_10_00_44_1692612044_7297910.txt','','','0','2023-08-21 10:00:44','2023-08-21 10:00:44','hotel_search','The IP [3.128.191.50] does not have permission to access this Webservice','','0','');
[08/21/2023 10:01:12], [file name :-/home/otrams/public_html/beta/tms/authenticate_web_service.php],update agents set web_service='1' , ws_customer_type= 'external' , allow_iprange= '', allow_encoding= '', web_service_ip= '3.128.191.50' , web_service_only_mapped_hotels='0' where id= '7858';
[08/21/2023 10:01:23], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO agent_logs SET  agent_id = '7858' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '24' , ip = '3.128.191.50' , city = 'Dubai' , service_name = '' , country_of_residence = '109' , service_type = 'hotel' , arrival_date = '2023/08/29' , departure_date = '2023/08/31' , nights = '2' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2023-08-21 10:01:23' , site_id = '' , country_code = '138' , city_code = '' , ratings = '3.0,4.0,5.0' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '1' ;
[08/21/2023 10:01:24], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-08-21 10:01:24.332'
                , total_duration = '0.020'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-08-21 10:01:24'
                , session_id = '78582120230810012358204357190'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2743216';
[08/21/2023 10:01:24], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-08-21 10:01:24.332'
                , total_duration = '0.020'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-08-21 10:01:24'
                , session_id = '78582120230810012358204357190'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2743216';
[08/21/2023 10:01:24], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-08-21 10:01:24.332'
                , total_duration = '0.020'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-08-21 10:01:24'
                , session_id = '78582120230810012358204357190'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2743216';
[08/21/2023 10:01:24], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-08-21 10:01:24.332'
                , total_duration = '0.020'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-08-21 10:01:24'
                , session_id = '78582120230810012358204357190'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2743216';
[08/21/2023 10:01:24], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-08-21 10:01:24.332'
                , total_duration = '0.021'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-08-21 10:01:24'
                , session_id = '78582120230810012358204357190'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2743216';
[08/21/2023 10:01:24], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-08-21 10:01:24.332'
                , total_duration = '0.021'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-08-21 10:01:24'
                , session_id = '78582120230810012358204357190'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2743216';
[08/21/2023 10:01:24], [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', 'm1/21_08_2023/request_availability_Tripathon_10_01_24_1692612084_.xml', 'm1/21_08_2023/response_availability_Tripathon_10_01_24_1692612084_.xml', 'm1/21_08_2023/response_header_availability_Tripathon_10_01_24_1692612084_.xml', 'miki', '2023-08-21 10:01:24', '', '78582120230810012358204357190', '0');
[08/21/2023 10:01:24], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=miki&sessionid=78582120230810012358204357190&city_code=97001&country_code=AE&xml_user_id=7858&db_caching=1&wh_agent_id=&erequest=0&total_request=1&hotel_ids=&web_service=yes&time_out=24'
            , http_hit_time = '2023-08-21 10:01:24.332'
            , 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.280'
            , error_description = ''
            , memory_used = '2480816'
            WHERE id = '4313';
[08/21/2023 10:01:26], [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/21_08_2023/request_availability_Tripathon_10_01_24_1692612084_29.json', 'e1/21_08_2023/response_availability_Tripathon_10_01_24_1692612084_29.json', 'e1/21_08_2023/response_header_availability_Tripathon_10_01_24_1692612084_29.json', 'expedia', '2023-08-21 10:01:26', '', '78582120230810012358204357190', '0');
[08/21/2023 10:01:27], [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/21_08_2023/request_availability_Tripathon_10_01_24_1692612084_17.json', 'e1/21_08_2023/response_availability_Tripathon_10_01_24_1692612084_17.json', 'e1/21_08_2023/response_header_availability_Tripathon_10_01_24_1692612084_17.json', 'expedia', '2023-08-21 10:01:27', '', '78582120230810012358204357190', '0');
[08/21/2023 10:01:27], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=78582120230810012358204357190&xml_user_id=7858&db_caching=1&erequest=1&total_request=2&web_service=yes&time_out=24&ip=3.128.191.50&browser=IE&hotels_ids=&expediaRapidApi=&agent_country='
            , http_hit_time = '2023-08-21 10:01:24.332'
            , 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.329'
            , error_description = ''
            , memory_used = '88818728'
            WHERE id = '4315';
[08/21/2023 10:01:28], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=78582120230810012358204357190&xml_user_id=7858&db_caching=1&erequest=0&total_request=2&web_service=yes&time_out=24&ip=3.128.191.50&browser=IE&hotels_ids=&expediaRapidApi=&agent_country='
            , http_hit_time = '2023-08-21 10:01:24.332'
            , 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.855'
            , error_description = ''
            , memory_used = '213037912'
            WHERE id = '4314';
[08/21/2023 10:01:28], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO ws_logs(request_path,response_path,userid,search_unique_id,booking_id,log_date_time,end_time,action_type,error_description,error_code,response_time,agent_log_id)
		VALUES('https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/21_08_2023/request_hotel_search_Tripathon_10_01_28_1692612088_3141605.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/Tripathon/21_08_2023/response_hotel_search_Tripathon_10_01_28_1692612088_3141605.txt','7858','78582120230810012358204357190','0','2023-08-21 10:01:23','2023-08-21 10:01:28','hotel_search','','','5','0');
[08/21/2023 10:07:17], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2023-08-21 10:07:17',login_attempt=0 where id = '7858';
[08/21/2023 10:07:17], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Tripathon', user_type = 'A', branch_id = '24', login_datetime = '2023-08-21 10:07:17', ip = '43.239.53.130', action = 'Login' ;
[08/21/2023 10:07:17], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2023-08-21 10:07:17' WHERE id= '62';
[08/21/2023 10:07:37], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-08-21 10:07:37' WHERE id= '62';
[08/21/2023 10:07:42], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-08-21 10:07:42' WHERE id= '62';
[08/21/2023 10:07:43], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-08-21 10:07:43' WHERE id= '62';
[08/21/2023 10:07:46], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-08-21 10:07:46' WHERE id= '62';
[08/21/2023 10:08:12], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2023-08-21 10:08:12' WHERE id= '62';
[08/21/2023 10:08:12], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7858' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '24' , ip = '43.239.53.130' , city = 'frankfurt' , service_name = '' , country_of_residence = '109' , service_type = 'hotel' , arrival_date = '2023/08/23' , departure_date = '2023/08/30' , nights = '7' , nationality = '109' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2023-08-21 10:08:12' , site_id = '' , country_code = '60' , city_code = '60_3763-FRA_7248' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[08/21/2023 10:08:13], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2023-08-21 10:08:13' WHERE id= '62';
[08/21/2023 10:08:13], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-08-21 10:08:13.650'
                , total_duration = '0.016'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-08-21 10:08:13'
                , session_id = '03ccd92afef669666c85bdf9b9012054475d14db8b98c8cb39928c06cd580a0f'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2745912';
[08/21/2023 10:08:13], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-08-21 10:08:13.650'
                , total_duration = '0.018'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-08-21 10:08:13'
                , session_id = '03ccd92afef669666c85bdf9b9012054475d14db8b98c8cb39928c06cd580a0f'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2745912';
[08/21/2023 10:08:13], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2023-08-21 10:08:13.650'
                , total_duration = '0.020'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2023-08-21 10:08:13'
                , session_id = '03ccd92afef669666c85bdf9b9012054475d14db8b98c8cb39928c06cd580a0f'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '2745912';
[08/21/2023 10:08:14], [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/21_08_2023/request_availability_Tripathon_10_08_13_1692612493_79.json', 'e1/21_08_2023/response_availability_Tripathon_10_08_13_1692612493_79.json', 'e1/21_08_2023/response_header_availability_Tripathon_10_08_13_1692612493_79.json', 'expedia', '2023-08-21 10:08:14', '', '03ccd92afef669666c85bdf9b9012054475d14db8b98c8cb39928c06cd580a0f', '0');
[08/21/2023 10:08:15], [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/21_08_2023/request_availability_Tripathon_10_08_13_1692612493_54.json', 'e1/21_08_2023/response_availability_Tripathon_10_08_13_1692612493_54.json', 'e1/21_08_2023/response_header_availability_Tripathon_10_08_13_1692612493_54.json', 'expedia', '2023-08-21 10:08:15', '', '03ccd92afef669666c85bdf9b9012054475d14db8b98c8cb39928c06cd580a0f', '0');
[08/21/2023 10:08:15], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=03ccd92afef669666c85bdf9b9012054475d14db8b98c8cb39928c06cd580a0f&xml_user_id=7858&db_caching=1&erequest=1&total_request=2&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F112.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=138'
            , http_hit_time = '2023-08-21 10:08:13.650'
            , 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.553'
            , error_description = ''
            , memory_used = '21630648'
            WHERE id = '4320';
[08/21/2023 10:08:15], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=03ccd92afef669666c85bdf9b9012054475d14db8b98c8cb39928c06cd580a0f&xml_user_id=7858&db_caching=1&erequest=0&total_request=2&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F112.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=138'
            , http_hit_time = '2023-08-21 10:08:13.650'
            , 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.921'
            , error_description = ''
            , memory_used = '78502336'
            WHERE id = '4319';
[08/21/2023 10:08:15], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-08-21 10:08:15' WHERE id= '62';
[08/21/2023 10:08:17], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2023-08-21 10:08:17' WHERE id= '62';
[08/21/2023 10:09:48], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2023-08-21 10:09:48' WHERE id= '62';
