[02/19/2024 12:07:51], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-02-19 12:07:51',login_attempt=0 where id = '7851';
[02/19/2024 12:07:51], [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-02-19 12:07:51', ip = '43.239.53.130', action = 'Login' ;
[02/19/2024 12:07:52], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-19 12:07:52' WHERE id= '562';
[02/19/2024 12:08:03], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-19 12:08:03' WHERE id= '562';
[02/19/2024 12:08:07], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-19 12:08:07' WHERE id= '562';
[02/19/2024 12:08:13], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-19 12:08:13' WHERE id= '562';
[02/19/2024 12:08:13], [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/03/28',  departure_date='2024/03/28',  nights='1',  create_date='2024-02-19 :12:08:13',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[02/19/2024 12:08:15], [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_02_2024/request_availability_Viator_test_12_08_13_1708344493.json', 'v1/19_02_2024/response_availability_Viator_test_12_08_13_1708344493.json', 'v1/19_02_2024/response_header_availability_Viator_test_12_08_13_1708344493.json', 'viator', '2024-02-19 12:08:15', '', '', '1662');
[02/19/2024 12:08:17], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-19 12:08:17' WHERE id= '562';
[02/19/2024 12:08:17], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-19 12:08:17' WHERE id= '562';
[02/19/2024 12:08:26], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-19 12:08:26' WHERE id= '562';
[02/19/2024 12:08:27], [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_02_2024/request_sight_details_Viator_test_12_08_26_1708344506.json', 'v1/19_02_2024/response_sight_details_Viator_test_12_08_26_1708344506.json', 'v1/19_02_2024/response_header_sight_details_Viator_test_12_08_26_1708344506.json', 'viator', '2024-02-19 12:08:27', '', '', '1662');
[02/19/2024 12:08:27], [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_02_2024/request_sight_details_Viator_test_12_08_27_1708344507.json', 'v1/19_02_2024/response_sight_details_Viator_test_12_08_27_1708344507.json', 'v1/19_02_2024/response_header_sight_details_Viator_test_12_08_27_1708344507.json', 'viator', '2024-02-19 12:08:27', '', '', '1662');
[02/19/2024 12:08:31], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-19 12:08:31' WHERE id= '562';
[02/19/2024 12:08: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 ('', 'check_availability', 'v1/19_02_2024/request_check_availability_Viator_test_12_08_31_1708344511.json', 'v1/19_02_2024/response_check_availability_Viator_test_12_08_31_1708344511.json', 'v1/19_02_2024/response_header_check_availability_Viator_test_12_08_31_1708344511.json', 'viator', '2024-02-19 12:08:32', '', '', '1662');
[02/19/2024 12:08:38], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-19 12:08:38' WHERE id= '562';
[02/19/2024 12:08:38], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1708344518','43.239.53.130');
[02/19/2024 12:11:12], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-19 12:11:12' WHERE id= '562';
[02/19/2024 12:11:12], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1708344672','43.239.53.130');
[02/19/2024 12:13:32], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-02-19 12:13:32',login_attempt=0 where id = '7870';
[02/19/2024 12:13:32], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'hotelyards-agent', user_type = 'A', branch_id = '32', login_datetime = '2024-02-19 12:13:32', ip = '43.239.53.130', action = 'Login' ;
[02/19/2024 12:13:32], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-19 12:13:32' WHERE id= '569';
[02/19/2024 12:17:18], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-19 12:17:18' WHERE id= '569';
[02/19/2024 12:18:04], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-19 12:18:04' WHERE id= '569';
[02/19/2024 12:18:29], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-19 12:18:29' WHERE id= '569';
[02/19/2024 12:18:33], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-19 12:18:33' WHERE id= '569';
[02/19/2024 12:18:37], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-19 12:18:37' WHERE id= '569';
[02/19/2024 12:18:37], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-19 12:18:37' WHERE id= '569';
[02/19/2024 12:18:41], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-19 12:18:41' WHERE id= '569';
[02/19/2024 12:18:41], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7870' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '32' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '95' , service_type = 'hotel' , arrival_date = '2024/02/29' , departure_date = '2024/03/01' , nights = '1' , nationality = '95' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-02-19 12:18:41' , site_id = '21' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[02/19/2024 12:18:47], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-02-19 12:18:47' WHERE id= '569';
[02/19/2024 12:18:52], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-02-19 12:18:52' WHERE id= '569';
[02/19/2024 12:18:57], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-02-19 12:18:57' WHERE id= '569';
[02/19/2024 12:19:02], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-02-19 12:19:02' WHERE id= '569';
[02/19/2024 12:19:07], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-02-19 12:19:07' WHERE id= '569';
[02/19/2024 12:19:12], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-02-19 12:19:12' WHERE id= '569';
[02/19/2024 12:19:17], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-02-19 12:19:17' WHERE id= '569';
[02/19/2024 12:19:22], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-02-19 12:19:22' WHERE id= '569';
[02/19/2024 12:19:27], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-02-19 12:19:27' WHERE id= '569';
[02/19/2024 12:19:32], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-02-19 12:19:32' WHERE id= '569';
[02/19/2024 12:19:37], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-02-19 12:19:37' WHERE id= '569';
[02/19/2024 12:19:43], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-02-19 12:19:43' WHERE id= '569';
[02/19/2024 12:19:48], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-02-19 12:19:48' WHERE id= '569';
[02/19/2024 12:19:53], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-02-19 12:19:53' WHERE id= '569';
[02/19/2024 12:19:57], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-02-19 12:19:57' WHERE id= '569';
[02/19/2024 12:20:03], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-02-19 12:20:03' WHERE id= '569';
[02/19/2024 12:20:07], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-02-19 12:20:07' WHERE id= '569';
[02/19/2024 12:20:13], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-02-19 12:20:13' WHERE id= '569';
[02/19/2024 12:20:18], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-02-19 12:20:18' WHERE id= '569';
[02/19/2024 12:20:22], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-02-19 12:20:22' WHERE id= '569';
[02/19/2024 12:20:28], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-02-19 12:20:28' WHERE id= '569';
[02/19/2024 12:20:32], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-02-19 12:20:32' WHERE id= '569';
[02/19/2024 12:20:34], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-19 12:20:34' WHERE id= '569';
[02/19/2024 12:20:37], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-19 12:20:37' WHERE id= '569';
[02/19/2024 12:20:37], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7870' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '32' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '95' , service_type = 'hotel' , arrival_date = '2024/02/29' , departure_date = '2024/03/01' , nights = '1' , nationality = '95' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-02-19 12:20:37' , site_id = '21' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[02/19/2024 12:20:43], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-02-19 12:20:43' WHERE id= '569';
[02/19/2024 12:20:49], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-02-19 12:20:49' WHERE id= '569';
[02/19/2024 12:20:53], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-02-19 12:20:53' WHERE id= '569';
[02/19/2024 12:20:59], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-02-19 12:20:59' WHERE id= '569';
[02/19/2024 12:21:03], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-02-19 12:21:03' WHERE id= '569';
[02/19/2024 12:21:07], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-19 12:21:07' WHERE id= '569';
[02/19/2024 12:21:11], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-19 12:21:11' WHERE id= '569';
[02/19/2024 12:21:11], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7870' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '32' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '95' , service_type = 'hotel' , arrival_date = '2024/02/29' , departure_date = '2024/03/01' , nights = '1' , nationality = '95' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-02-19 12:21:11' , site_id = '21' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[02/19/2024 12:21:16], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-02-19 12:21:16' WHERE id= '569';
[02/19/2024 12:21:16], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-19 12:21:16' WHERE id= '569';
[02/19/2024 12:21:19], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-19 12:21:19' WHERE id= '569';
[02/19/2024 12:21:19], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7870' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '32' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '95' , service_type = 'hotel' , arrival_date = '2024/02/29' , departure_date = '2024/03/01' , nights = '1' , nationality = '95' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-02-19 12:21:19' , site_id = '21' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[02/19/2024 12:21:25], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-02-19 12:21:25' WHERE id= '569';
[02/19/2024 12:21:30], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-02-19 12:21:30' WHERE id= '569';
[02/19/2024 12:21:35], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2024-02-19 12:21:35' WHERE id= '569';
[02/19/2024 12:21:38], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-19 12:21:38' WHERE id= '569';
[02/19/2024 12:24:44], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-19 12:24:44' WHERE id= '569';
[02/19/2024 12:24:44], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7870' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '32' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '95' , service_type = 'hotel' , arrival_date = '2024/02/29' , departure_date = '2024/03/01' , nights = '1' , nationality = '95' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-02-19 12:24:44' , site_id = '21' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[02/19/2024 12:24:45], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-02-19 12:24:45' WHERE id= '569';
[02/19/2024 12:24:45], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-19 12:24:45.251'
                , total_duration = '0.018'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-19 12:24:45'
                , session_id = '752868bc6a8b840159c411eeade92fd9c06ec305f98a8057b71a9f4222506e16'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1703680';
[02/19/2024 12:24:45], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-19 12:24:45.251'
                , total_duration = '0.018'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-19 12:24:45'
                , session_id = '752868bc6a8b840159c411eeade92fd9c06ec305f98a8057b71a9f4222506e16'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1703680';
[02/19/2024 12:24:45], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-19 12:24:45.251'
                , total_duration = '0.019'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-19 12:24:45'
                , session_id = '752868bc6a8b840159c411eeade92fd9c06ec305f98a8057b71a9f4222506e16'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1703680';
[02/19/2024 12:24:45], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-19 12:24:45.251'
                , total_duration = '0.019'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-19 12:24:45'
                , session_id = '752868bc6a8b840159c411eeade92fd9c06ec305f98a8057b71a9f4222506e16'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1703680';
[02/19/2024 12:24:45], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-19 12:24:45.251'
                , total_duration = '0.019'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-19 12:24:45'
                , session_id = '752868bc6a8b840159c411eeade92fd9c06ec305f98a8057b71a9f4222506e16'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1703680';
[02/19/2024 12:24:45], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-19 12:24:45.251'
                , total_duration = '0.021'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-19 12:24:45'
                , session_id = '752868bc6a8b840159c411eeade92fd9c06ec305f98a8057b71a9f4222506e16'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1703680';
[02/19/2024 12:24:45], [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_02_2024/request_availability_hotel_yards_12_24_45_1708345485_9.json', 'e1/19_02_2024/response_availability_hotel_yards_12_24_45_1708345485_9.json', 'e1/19_02_2024/response_header_availability_hotel_yards_12_24_45_1708345485_9.json', 'expedia', '2024-02-19 12:24:45', '', '752868bc6a8b840159c411eeade92fd9c06ec305f98a8057b71a9f4222506e16', '0');
[02/19/2024 12:24:45], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=752868bc6a8b840159c411eeade92fd9c06ec305f98a8057b71a9f4222506e16&xml_user_id=7867&db_caching=1&erequest=2&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=95'
            , http_hit_time = '2024-02-19 12:24:45.251'
            , 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.368'
            , error_description = ''
            , memory_used = '1433880'
            WHERE id = '34258';
[02/19/2024 12:24:46], [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_02_2024/request_availability_hotel_yards_12_24_45_1708345485_21.json', 'e1/19_02_2024/response_availability_hotel_yards_12_24_45_1708345485_21.json', 'e1/19_02_2024/response_header_availability_hotel_yards_12_24_45_1708345485_21.json', 'expedia', '2024-02-19 12:24:46', '', '752868bc6a8b840159c411eeade92fd9c06ec305f98a8057b71a9f4222506e16', '0');
[02/19/2024 12:24:46], [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_02_2024/request_availability_hotel_yards_12_24_45_1708345485_56.json', 'e1/19_02_2024/response_availability_hotel_yards_12_24_45_1708345485_56.json', 'e1/19_02_2024/response_header_availability_hotel_yards_12_24_45_1708345485_56.json', 'expedia', '2024-02-19 12:24:46', '', '752868bc6a8b840159c411eeade92fd9c06ec305f98a8057b71a9f4222506e16', '0');
[02/19/2024 12:24:47], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=752868bc6a8b840159c411eeade92fd9c06ec305f98a8057b71a9f4222506e16&xml_user_id=7867&db_caching=1&erequest=1&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=95'
            , http_hit_time = '2024-02-19 12:24:45.251'
            , 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.628'
            , error_description = ''
            , memory_used = '132321176'
            WHERE id = '34259';
[02/19/2024 12:24:48], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=752868bc6a8b840159c411eeade92fd9c06ec305f98a8057b71a9f4222506e16&xml_user_id=7867&db_caching=1&erequest=0&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F121.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=95'
            , http_hit_time = '2024-02-19 12:24:45.251'
            , 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.103'
            , error_description = ''
            , memory_used = '143935472'
            WHERE id = '34260';
[02/19/2024 12:24:48], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-02-19 12:24:48' WHERE id= '569';
[02/19/2024 12:30:28], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-02-19 12:30:28',login_attempt=0 where id = '7870';
[02/19/2024 12:30:28], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'hotelyards-agent', user_type = 'A', branch_id = '32', login_datetime = '2024-02-19 12:30:28', ip = '43.239.53.130', action = 'Login' ;
[02/19/2024 12:30:29], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-19 12:30:29' WHERE id= '568';
[02/19/2024 12:30:39], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-19 12:30:39' WHERE id= '568';
[02/19/2024 12:30:44], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-19 12:30:44' WHERE id= '568';
[02/19/2024 12:30:44], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7870' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '32' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '95' , service_type = 'hotel' , arrival_date = '2024/02/29' , departure_date = '2024/03/01' , nights = '1' , nationality = '95' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-02-19 12:30:44' , site_id = '21' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[02/19/2024 12:30:46], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-02-19 12:30:46' WHERE id= '568';
[02/19/2024 12:30:46], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-19 12:30:46.873'
                , total_duration = '0.014'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-19 12:30:46'
                , session_id = '1c2dac62c142a4030055129779053e7ec2551fdb5aabd351695e964496174b27'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1703680';
[02/19/2024 12:30:46], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-19 12:30:46.874'
                , total_duration = '0.015'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-19 12:30:46'
                , session_id = '1c2dac62c142a4030055129779053e7ec2551fdb5aabd351695e964496174b27'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1703680';
[02/19/2024 12:30:46], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-19 12:30:46.873'
                , total_duration = '0.018'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-19 12:30:46'
                , session_id = '1c2dac62c142a4030055129779053e7ec2551fdb5aabd351695e964496174b27'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1703680';
[02/19/2024 12:30:46], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-19 12:30:46.873'
                , total_duration = '0.018'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-19 12:30:46'
                , session_id = '1c2dac62c142a4030055129779053e7ec2551fdb5aabd351695e964496174b27'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1703680';
[02/19/2024 12:30:46], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-19 12:30:46.873'
                , total_duration = '0.019'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-19 12:30:46'
                , session_id = '1c2dac62c142a4030055129779053e7ec2551fdb5aabd351695e964496174b27'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1703680';
[02/19/2024 12:30:46], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-19 12:30:46.874'
                , total_duration = '0.021'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-19 12:30:46'
                , session_id = '1c2dac62c142a4030055129779053e7ec2551fdb5aabd351695e964496174b27'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1703680';
[02/19/2024 12:30:47], [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_02_2024/request_availability_hotel_yards_12_30_46_1708345846_47.json', 'e1/19_02_2024/response_availability_hotel_yards_12_30_46_1708345846_47.json', 'e1/19_02_2024/response_header_availability_hotel_yards_12_30_46_1708345846_47.json', 'expedia', '2024-02-19 12:30:47', '', '1c2dac62c142a4030055129779053e7ec2551fdb5aabd351695e964496174b27', '0');
[02/19/2024 12:30:47], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=1c2dac62c142a4030055129779053e7ec2551fdb5aabd351695e964496174b27&xml_user_id=7867&db_caching=1&erequest=2&total_request=3&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F110.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=95'
            , http_hit_time = '2024-02-19 12:30:46.874'
            , 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.267'
            , error_description = ''
            , memory_used = '1434136'
            WHERE id = '34267';
[02/19/2024 12:30:48], [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_02_2024/request_availability_hotel_yards_12_30_46_1708345846_15.json', 'e1/19_02_2024/response_availability_hotel_yards_12_30_46_1708345846_15.json', 'e1/19_02_2024/response_header_availability_hotel_yards_12_30_46_1708345846_15.json', 'expedia', '2024-02-19 12:30:48', '', '1c2dac62c142a4030055129779053e7ec2551fdb5aabd351695e964496174b27', '0');
[02/19/2024 12:30:48], [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_02_2024/request_availability_hotel_yards_12_30_46_1708345846_4.json', 'e1/19_02_2024/response_availability_hotel_yards_12_30_46_1708345846_4.json', 'e1/19_02_2024/response_header_availability_hotel_yards_12_30_46_1708345846_4.json', 'expedia', '2024-02-19 12:30:48', '', '1c2dac62c142a4030055129779053e7ec2551fdb5aabd351695e964496174b27', '0');
[02/19/2024 12:30:49], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=1c2dac62c142a4030055129779053e7ec2551fdb5aabd351695e964496174b27&xml_user_id=7867&db_caching=1&erequest=0&total_request=3&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F110.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=95'
            , http_hit_time = '2024-02-19 12:30:46.874'
            , 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.722'
            , error_description = ''
            , memory_used = '143673464'
            WHERE id = '34268';
[02/19/2024 12:30:49], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=1c2dac62c142a4030055129779053e7ec2551fdb5aabd351695e964496174b27&xml_user_id=7867&db_caching=1&erequest=1&total_request=3&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F110.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=95'
            , http_hit_time = '2024-02-19 12:30:46.874'
            , 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.851'
            , error_description = ''
            , memory_used = '133034712'
            WHERE id = '34269';
[02/19/2024 12:30:50], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-02-19 12:30:50' WHERE id= '568';
[02/19/2024 12:33:19], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-19 12:33:19' WHERE id= '562';
[02/19/2024 12:33:20], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-19 12:33:20' WHERE id= '562';
[02/19/2024 12:33:20], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-19 12:33:20' WHERE id= '562';
[02/19/2024 12:33:26], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-19 12:33:26' WHERE id= '562';
[02/19/2024 12:33:27], [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_02_2024/request_sight_details_Viator_test_12_33_26_1708346006.json', 'v1/19_02_2024/response_sight_details_Viator_test_12_33_26_1708346006.json', 'v1/19_02_2024/response_header_sight_details_Viator_test_12_33_26_1708346006.json', 'viator', '2024-02-19 12:33:27', '', '', '1662');
[02/19/2024 12:33:27], [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_02_2024/request_sight_details_Viator_test_12_33_27_1708346007.json', 'v1/19_02_2024/response_sight_details_Viator_test_12_33_27_1708346007.json', 'v1/19_02_2024/response_header_sight_details_Viator_test_12_33_27_1708346007.json', 'viator', '2024-02-19 12:33:27', '', '', '1662');
[02/19/2024 12:33:31], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-19 12:33:31' WHERE id= '562';
[02/19/2024 12:33: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_02_2024/request_sight_details_Viator_test_12_33_31_1708346011.json', 'v1/19_02_2024/response_sight_details_Viator_test_12_33_31_1708346011.json', 'v1/19_02_2024/response_header_sight_details_Viator_test_12_33_31_1708346011.json', 'viator', '2024-02-19 12:33:32', '', '', '1662');
[02/19/2024 12:33:33], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/19_02_2024/request_sight_details_Viator_test_12_33_32_1708346012.json', 'v1/19_02_2024/response_sight_details_Viator_test_12_33_32_1708346012.json', 'v1/19_02_2024/response_header_sight_details_Viator_test_12_33_32_1708346012.json', 'viator', '2024-02-19 12:33:33', '', '', '1662');
[02/19/2024 12:33:37], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-19 12:33:37' WHERE id= '562';
[02/19/2024 12:33:37], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'check_availability', 'v1/19_02_2024/request_check_availability_Viator_test_12_33_37_1708346017.json', 'v1/19_02_2024/response_check_availability_Viator_test_12_33_37_1708346017.json', 'v1/19_02_2024/response_header_check_availability_Viator_test_12_33_37_1708346017.json', 'viator', '2024-02-19 12:33:37', '', '', '1662');
[02/19/2024 12:36:57], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-02-19 12:36:57' WHERE id= '569';
[02/19/2024 12:37:35], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-02-19 12:37:35' WHERE id= '569';
[02/19/2024 12:37:58], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-02-19 12:37:58' WHERE id= '569';
[02/19/2024 12:38:35], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-19 12:38:35' WHERE id= '569';
[02/19/2024 12:38:37], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-19 12:38:37' WHERE id= '569';
[02/19/2024 12:38:38], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-19 12:38:38' WHERE id= '569';
[02/19/2024 12:38:39], [file name :-/home/otrams/public_html/beta/compare.php],UPDATE user_sessions_ip SET update_date = '2024-02-19 12:38:39' WHERE id= '569';
[02/19/2024 12:38:44], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-19 12:38:44' WHERE id= '569';
[02/19/2024 12:38:45], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-19 12:38:45' WHERE id= '569';
[02/19/2024 12:38:46], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-19 12:38:46' WHERE id= '569';
[02/19/2024 12:39:32], [file name :-/home/otrams/public_html/beta/my_accounts.php],UPDATE user_sessions_ip SET update_date = '2024-02-19 12:39:32' WHERE id= '569';
[02/19/2024 12:39:36], [file name :-/home/otrams/public_html/beta/edit_profile.php],UPDATE user_sessions_ip SET update_date = '2024-02-19 12:39:36' WHERE id= '569';
[02/19/2024 12:47:04], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-19 12:47:04' WHERE id= '562';
[02/19/2024 12:47:04], [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_02_2024/request_check_availability_Viator_test_12_47_04_1708346824.json', 'v1/19_02_2024/response_check_availability_Viator_test_12_47_04_1708346824.json', 'v1/19_02_2024/response_header_check_availability_Viator_test_12_47_04_1708346824.json', 'viator', '2024-02-19 12:47:04', '', '', '1662');
[02/19/2024 12:54:14], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2024-02-19 12:54:14' WHERE id= '568';
[02/19/2024 12:54:15], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2024-02-19 12:54:15' WHERE id= '568';
[02/19/2024 12:54:15], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1708347255','43.239.53.130');
[02/19/2024 12:54:15], [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', 'e1/19_02_2024/request_valuation_hotel_yards_12_54_15_1708347255_49.json', 'e1/19_02_2024/response_valuation_hotel_yards_12_54_15_1708347255_49.json', 'e1/19_02_2024/response_header_valuation_hotel_yards_12_54_15_1708347255_49.json', 'expedia', '2024-02-19 12:54:15', '', '1c2dac62c142a4030055129779053e7ec2551fdb5aabd351695e964496174b27', '0');
