[02/08/2024 12:07:00], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-02-08 12:07:00',login_attempt=0 where id = '7870';
[02/08/2024 12:07:00], [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-08 12:07:00', ip = '43.239.53.130', action = 'Login' ;
[02/08/2024 12:07:00], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 12:07:00' WHERE id= '519';
[02/08/2024 12:07:03], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 12:07:03' WHERE id= '519';
[02/08/2024 12:07:14], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 12:07:14' WHERE id= '519';
[02/08/2024 12:07:17], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 12:07:17' WHERE id= '519';
[02/08/2024 12:09:13], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 12:09:13' WHERE id= '519';
[02/08/2024 12:09:16], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 12:09:16' WHERE id= '519';
[02/08/2024 12:09:16], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7867' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '32' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/02/22',  departure_date='2024/02/22',  nights='1',  create_date='2024-02-08 :12:09:16',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '21' ;
[02/08/2024 12:09:17], [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/08_02_2024/request_availability_hotel_yards_12_09_16_1707394156.json', 'v1/08_02_2024/response_availability_hotel_yards_12_09_16_1707394156.json', 'v1/08_02_2024/response_header_availability_hotel_yards_12_09_16_1707394156.json', 'viator', '2024-02-08 12:09:17', '', '', '1358');
[02/08/2024 12:09:19], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 12:09:19' WHERE id= '519';
[02/08/2024 12:09:19], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 12:09:19' WHERE id= '519';
[02/08/2024 12:13:17], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 12:13:17' WHERE id= '519';
[02/08/2024 12:13:19], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 12:13:19' WHERE id= '519';
[02/08/2024 12:13:25], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 12:13:25' WHERE id= '519';
[02/08/2024 12:13:25], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7867' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '32' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/02/22',  departure_date='2024/02/22',  nights='1',  create_date='2024-02-08 :12:13:25',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '21' ;
[02/08/2024 12:13:32], [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/08_02_2024/request_availability_hotel_yards_12_13_25_1707394405.json', 'v1/08_02_2024/response_availability_hotel_yards_12_13_25_1707394405.json', 'v1/08_02_2024/response_header_availability_hotel_yards_12_13_25_1707394405.json', 'viator', '2024-02-08 12:13:32', '', '', '1359');
[02/08/2024 12:13:34], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 12:13:34' WHERE id= '519';
[02/08/2024 12:13:34], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 12:13:34' WHERE id= '519';
[02/08/2024 12:14:14], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 12:14:14' WHERE id= '519';
[02/08/2024 12:14:17], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 12:14:17' WHERE id= '519';
[02/08/2024 12:14:17], [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/22' , departure_date = '2024/02/23' , nights = '1' , nationality = '95' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-02-08 12:14:17' , 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/08/2024 12:14:18], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 12:14:18' WHERE id= '519';
[02/08/2024 12:14:18], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 12:14:18.655'
                , total_duration = '0.012'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 12:14:18'
                , session_id = 'ce35a71fecec6bd4a072f42244eca6746ecab7e5fbe6066df6df4d12a807ab14'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1696264';
[02/08/2024 12:14:18], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 12:14:18.655'
                , total_duration = '0.012'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 12:14:18'
                , session_id = 'ce35a71fecec6bd4a072f42244eca6746ecab7e5fbe6066df6df4d12a807ab14'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1696256';
[02/08/2024 12:14:18], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 12:14:18.656'
                , total_duration = '0.012'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 12:14:18'
                , session_id = 'ce35a71fecec6bd4a072f42244eca6746ecab7e5fbe6066df6df4d12a807ab14'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1696264';
[02/08/2024 12:14:18], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 12:14:18.656'
                , total_duration = '0.013'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 12:14:18'
                , session_id = 'ce35a71fecec6bd4a072f42244eca6746ecab7e5fbe6066df6df4d12a807ab14'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1696264';
[02/08/2024 12:14:18], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 12:14:18.655'
                , total_duration = '0.014'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 12:14:18'
                , session_id = 'ce35a71fecec6bd4a072f42244eca6746ecab7e5fbe6066df6df4d12a807ab14'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1696264';
[02/08/2024 12:14:18], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs SET
                type = 'ERROR'
                , http_hit_time = '2024-02-08 12:14:18.655'
                , total_duration = '0.015'
                , hotel_count = 0
                , source_type = 'hotelbeds'
                , create_date = '2024-02-08 12:14:18'
                , session_id = 'ce35a71fecec6bd4a072f42244eca6746ecab7e5fbe6066df6df4d12a807ab14'
                , agent_logs_id = '0'
                , error_description = ''
                , memory_used = '1696296';
[02/08/2024 12:14:19], [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/08_02_2024/request_availability_hotel_yards_12_14_18_1707394458_31.json', 'e1/08_02_2024/response_availability_hotel_yards_12_14_18_1707394458_31.json', 'e1/08_02_2024/response_header_availability_hotel_yards_12_14_18_1707394458_31.json', 'expedia', '2024-02-08 12:14:19', '', 'ce35a71fecec6bd4a072f42244eca6746ecab7e5fbe6066df6df4d12a807ab14', '0');
[02/08/2024 12:14:19], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=ce35a71fecec6bd4a072f42244eca6746ecab7e5fbe6066df6df4d12a807ab14&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-08 12:14:18.656'
            , 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.393'
            , error_description = ''
            , memory_used = '1425224'
            WHERE id = '31832';
[02/08/2024 12:14:20], [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/08_02_2024/request_availability_hotel_yards_12_14_18_1707394458_29.json', 'e1/08_02_2024/response_availability_hotel_yards_12_14_18_1707394458_29.json', 'e1/08_02_2024/response_header_availability_hotel_yards_12_14_18_1707394458_29.json', 'expedia', '2024-02-08 12:14:20', '', 'ce35a71fecec6bd4a072f42244eca6746ecab7e5fbe6066df6df4d12a807ab14', '0');
[02/08/2024 12:14:20], [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/08_02_2024/request_availability_hotel_yards_12_14_18_1707394458_26.json', 'e1/08_02_2024/response_availability_hotel_yards_12_14_18_1707394458_26.json', 'e1/08_02_2024/response_header_availability_hotel_yards_12_14_18_1707394458_26.json', 'expedia', '2024-02-08 12:14:20', '', 'ce35a71fecec6bd4a072f42244eca6746ecab7e5fbe6066df6df4d12a807ab14', '0');
[02/08/2024 12:14:21], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=ce35a71fecec6bd4a072f42244eca6746ecab7e5fbe6066df6df4d12a807ab14&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-08 12:14:18.656'
            , 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.539'
            , error_description = ''
            , memory_used = '126588464'
            WHERE id = '31833';
[02/08/2024 12:14:21], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=ce35a71fecec6bd4a072f42244eca6746ecab7e5fbe6066df6df4d12a807ab14&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-08 12:14:18.656'
            , 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.976'
            , error_description = ''
            , memory_used = '158798680'
            WHERE id = '31834';
[02/08/2024 12:14:21], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 12:14:21' WHERE id= '519';
[02/08/2024 12:14:25], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 12:14:25' WHERE id= '519';
[02/08/2024 12:14:57], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 12:14:57' WHERE id= '519';
[02/08/2024 12:14:57], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7867' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '32' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/02/22',  departure_date='2024/02/22',  nights='1',  create_date='2024-02-08 :12:14:57',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '21' ;
[02/08/2024 12:15: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/08_02_2024/request_availability_hotel_yards_12_14_57_1707394497.json', 'v1/08_02_2024/response_availability_hotel_yards_12_14_57_1707394497.json', 'v1/08_02_2024/response_header_availability_hotel_yards_12_14_57_1707394497.json', 'viator', '2024-02-08 12:15:00', '', '', '1360');
[02/08/2024 12:15:02], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 12:15:02' WHERE id= '519';
[02/08/2024 12:15:02], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 12:15:02' WHERE id= '519';
[02/08/2024 12:16:00], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 12:16:00' WHERE id= '519';
[02/08/2024 12:16:00], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7867' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '32' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/02/22',  departure_date='2024/02/22',  nights='1',  create_date='2024-02-08 :12:16:00',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '21' ;
[02/08/2024 12:16:01], [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/08_02_2024/request_availability_hotel_yards_12_16_00_1707394560.json', 'v1/08_02_2024/response_availability_hotel_yards_12_16_00_1707394560.json', 'v1/08_02_2024/response_header_availability_hotel_yards_12_16_00_1707394560.json', 'viator', '2024-02-08 12:16:01', '', '', '1361');
[02/08/2024 12:16:03], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 12:16:03' WHERE id= '519';
[02/08/2024 12:16:03], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 12:16:03' WHERE id= '519';
[02/08/2024 12:17:31], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 12:17:31' WHERE id= '519';
[02/08/2024 12:17:31], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7867' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '32' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/02/22',  departure_date='2024/02/22',  nights='1',  create_date='2024-02-08 :12:17:31',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '21' ;
[02/08/2024 12:17:34], [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/08_02_2024/request_availability_hotel_yards_12_17_31_1707394651.json', 'v1/08_02_2024/response_availability_hotel_yards_12_17_31_1707394651.json', 'v1/08_02_2024/response_header_availability_hotel_yards_12_17_31_1707394651.json', 'viator', '2024-02-08 12:17:34', '', '', '1362');
[02/08/2024 12:17:37], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 12:17:37' WHERE id= '519';
[02/08/2024 12:17:37], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 12:17:37' WHERE id= '519';
[02/08/2024 12:21:25], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 12:21:25' WHERE id= '519';
[02/08/2024 12:21:25], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7867' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '32' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/02/22',  departure_date='2024/02/22',  nights='1',  create_date='2024-02-08 :12:21:25',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '21' ;
[02/08/2024 12:21:28], [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/08_02_2024/request_availability_hotel_yards_12_21_25_1707394885.json', 'v1/08_02_2024/response_availability_hotel_yards_12_21_25_1707394885.json', 'v1/08_02_2024/response_header_availability_hotel_yards_12_21_25_1707394885.json', 'viator', '2024-02-08 12:21:28', '', '', '1363');
[02/08/2024 12:21:31], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 12:21:31' WHERE id= '519';
[02/08/2024 12:21:31], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 12:21:31' WHERE id= '519';
[02/08/2024 12:21:35], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 12:21:35' WHERE id= '519';
[02/08/2024 12:21:36], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/08_02_2024/request_sight_details_hotel_yards_12_21_35_1707394895.json', 'v1/08_02_2024/response_sight_details_hotel_yards_12_21_35_1707394895.json', 'v1/08_02_2024/response_header_sight_details_hotel_yards_12_21_35_1707394895.json', 'viator', '2024-02-08 12:21:36', '', '', '1363');
[02/08/2024 12:21:36], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/08_02_2024/request_sight_details_hotel_yards_12_21_36_1707394896.json', 'v1/08_02_2024/response_sight_details_hotel_yards_12_21_36_1707394896.json', 'v1/08_02_2024/response_header_sight_details_hotel_yards_12_21_36_1707394896.json', 'viator', '2024-02-08 12:21:36', '', '', '1363');
[02/08/2024 12:21:41], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 12:21:41' WHERE id= '519';
[02/08/2024 12:21:41], [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/08_02_2024/request_sight_details_hotel_yards_12_21_41_1707394901.json', 'v1/08_02_2024/response_sight_details_hotel_yards_12_21_41_1707394901.json', 'v1/08_02_2024/response_header_sight_details_hotel_yards_12_21_41_1707394901.json', 'viator', '2024-02-08 12:21:41', '', '', '1363');
[02/08/2024 12:21:42], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/08_02_2024/request_sight_details_hotel_yards_12_21_41_1707394901.json', 'v1/08_02_2024/response_sight_details_hotel_yards_12_21_41_1707394901.json', 'v1/08_02_2024/response_header_sight_details_hotel_yards_12_21_41_1707394901.json', 'viator', '2024-02-08 12:21:42', '', '', '1363');
[02/08/2024 12:21:45], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 12:21:45' WHERE id= '519';
[02/08/2024 12:21:46], [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/08_02_2024/request_sight_details_hotel_yards_12_21_45_1707394905.json', 'v1/08_02_2024/response_sight_details_hotel_yards_12_21_45_1707394905.json', 'v1/08_02_2024/response_header_sight_details_hotel_yards_12_21_45_1707394905.json', 'viator', '2024-02-08 12:21:46', '', '', '1363');
[02/08/2024 12:21:46], [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/08_02_2024/request_sight_details_hotel_yards_12_21_46_1707394906.json', 'v1/08_02_2024/response_sight_details_hotel_yards_12_21_46_1707394906.json', 'v1/08_02_2024/response_header_sight_details_hotel_yards_12_21_46_1707394906.json', 'viator', '2024-02-08 12:21:46', '', '', '1363');
[02/08/2024 12:22:08], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 12:22:08' WHERE id= '519';
[02/08/2024 12:22:10], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 12:22:10' WHERE id= '519';
[02/08/2024 12:22:13], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 12:22:13' WHERE id= '519';
[02/08/2024 12:22:13], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7867' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '32' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/02/22',  departure_date='2024/02/22',  nights='1',  create_date='2024-02-08 :12:22:13',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '21' ;
[02/08/2024 12:22:16], [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/08_02_2024/request_availability_hotel_yards_12_22_13_1707394933.json', 'v1/08_02_2024/response_availability_hotel_yards_12_22_13_1707394933.json', 'v1/08_02_2024/response_header_availability_hotel_yards_12_22_13_1707394933.json', 'viator', '2024-02-08 12:22:16', '', '', '1364');
[02/08/2024 12:22:18], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 12:22:18' WHERE id= '519';
[02/08/2024 12:22:18], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 12:22:18' WHERE id= '519';
[02/08/2024 12:22:46], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-02-08 12:22:46',login_attempt=0 where id = '7849';
[02/08/2024 12:22:46], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'shiv_qtech', user_type = 'A', branch_id = '24', login_datetime = '2024-02-08 12:22:46', ip = '43.239.53.130', action = 'Login' ;
[02/08/2024 12:22:46], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 12:22:46' WHERE id= '520';
[02/08/2024 12:22:50], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 12:22:50' WHERE id= '520';
[02/08/2024 12:22:54], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 12:22:54' WHERE id= '520';
[02/08/2024 12:22:59], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 12:22:59' WHERE id= '520';
[02/08/2024 12:22:59], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7849' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '24' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/02/22',  departure_date='2024/02/22',  nights='1',  create_date='2024-02-08 :12:22:59',  nationality='',  additional_markup='',  selected_currency='INR',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[02/08/2024 12:23:06], [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/08_02_2024/request_availability_shiv_qtech_12_22_59_1707394979.json', 'v1/08_02_2024/response_availability_shiv_qtech_12_22_59_1707394979.json', 'v1/08_02_2024/response_header_availability_shiv_qtech_12_22_59_1707394979.json', 'viator', '2024-02-08 12:23:06', '', '', '1365');
[02/08/2024 12:23:08], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 12:23:08' WHERE id= '520';
[02/08/2024 12:23:08], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 12:23:08' WHERE id= '520';
[02/08/2024 12:23:34], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 12:23:34' WHERE id= '520';
[02/08/2024 12:23:34], [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/08_02_2024/request_sight_details_shiv_qtech_12_23_34_1707395014.json', 'v1/08_02_2024/response_sight_details_shiv_qtech_12_23_34_1707395014.json', 'v1/08_02_2024/response_header_sight_details_shiv_qtech_12_23_34_1707395014.json', 'viator', '2024-02-08 12:23:34', '', '', '1365');
[02/08/2024 12:23:35], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 12:23:35' WHERE id= '519';
[02/08/2024 12:23:35], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7867' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '32' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/02/22',  departure_date='2024/02/22',  nights='1',  create_date='2024-02-08 :12:23:35',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '21' ;
[02/08/2024 12:23: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/08_02_2024/request_sight_details_shiv_qtech_12_23_35_1707395015.json', 'v1/08_02_2024/response_sight_details_shiv_qtech_12_23_35_1707395015.json', 'v1/08_02_2024/response_header_sight_details_shiv_qtech_12_23_35_1707395015.json', 'viator', '2024-02-08 12:23:35', '', '', '1365');
[02/08/2024 12:23:39], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 12:23:39' WHERE id= '520';
[02/08/2024 12:23:40], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/08_02_2024/request_sight_details_shiv_qtech_12_23_39_1707395019.json', 'v1/08_02_2024/response_sight_details_shiv_qtech_12_23_39_1707395019.json', 'v1/08_02_2024/response_header_sight_details_shiv_qtech_12_23_39_1707395019.json', 'viator', '2024-02-08 12:23:40', '', '', '1365');
[02/08/2024 12:23:40], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/08_02_2024/request_sight_details_shiv_qtech_12_23_40_1707395020.json', 'v1/08_02_2024/response_sight_details_shiv_qtech_12_23_40_1707395020.json', 'v1/08_02_2024/response_header_sight_details_shiv_qtech_12_23_40_1707395020.json', 'viator', '2024-02-08 12:23:40', '', '', '1365');
[02/08/2024 12:23:44], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 12:23:44' WHERE id= '520';
[02/08/2024 12:23:45], [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/08_02_2024/request_availability_hotel_yards_12_23_35_1707395015.json', 'v1/08_02_2024/response_availability_hotel_yards_12_23_35_1707395015.json', 'v1/08_02_2024/response_header_availability_hotel_yards_12_23_35_1707395015.json', 'viator', '2024-02-08 12:23:45', '', '', '1366');
[02/08/2024 12:23:46], [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/08_02_2024/request_check_availability_shiv_qtech_12_23_44_1707395024.json', 'v1/08_02_2024/response_check_availability_shiv_qtech_12_23_44_1707395024.json', 'v1/08_02_2024/response_header_check_availability_shiv_qtech_12_23_44_1707395024.json', 'viator', '2024-02-08 12:23:46', '', '', '1365');
[02/08/2024 12:23:47], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 12:23:47' WHERE id= '519';
[02/08/2024 12:23:47], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7867' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '32' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/02/22',  departure_date='2024/02/22',  nights='1',  create_date='2024-02-08 :12:23:47',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '21' ;
[02/08/2024 12:23: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/08_02_2024/request_availability_hotel_yards_12_23_47_1707395027.json', 'v1/08_02_2024/response_availability_hotel_yards_12_23_47_1707395027.json', 'v1/08_02_2024/response_header_availability_hotel_yards_12_23_47_1707395027.json', 'viator', '2024-02-08 12:23:47', '', '', '1367');
[02/08/2024 12:23:50], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 12:23:50' WHERE id= '519';
[02/08/2024 12:23:52], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 12:23:52' WHERE id= '519';
[02/08/2024 12:23:59], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 12:23:59' WHERE id= '519';
[02/08/2024 12:23:59], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 12:23:59' WHERE id= '519';
[02/08/2024 12:24:01], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 12:24:01' WHERE id= '519';
[02/08/2024 12:24:01], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 12:24:01' WHERE id= '519';
[02/08/2024 12:24:02], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 12:24:02' WHERE id= '519';
[02/08/2024 12:24:02], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 12:24:02' WHERE id= '519';
[02/08/2024 12:24:23], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 12:24:23' WHERE id= '520';
[02/08/2024 12:24:24], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 12:24:24' WHERE id= '519';
[02/08/2024 12:24:24], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7867' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '32' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/02/22',  departure_date='2024/02/22',  nights='1',  create_date='2024-02-08 :12:24:24',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '21' ;
[02/08/2024 12:24:26], [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/08_02_2024/request_availability_hotel_yards_12_24_24_1707395064.json', 'v1/08_02_2024/response_availability_hotel_yards_12_24_24_1707395064.json', 'v1/08_02_2024/response_header_availability_hotel_yards_12_24_24_1707395064.json', 'viator', '2024-02-08 12:24:26', '', '', '1368');
[02/08/2024 12:24: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 ('', 'check_availability', 'v1/08_02_2024/request_check_availability_shiv_qtech_12_24_23_1707395063.json', 'v1/08_02_2024/response_check_availability_shiv_qtech_12_24_23_1707395063.json', 'v1/08_02_2024/response_header_check_availability_shiv_qtech_12_24_23_1707395063.json', 'viator', '2024-02-08 12:24:27', '', '', '1365');
[02/08/2024 12:24:29], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 12:24:29' WHERE id= '519';
[02/08/2024 12:24:30], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 12:24:30' WHERE id= '519';
[02/08/2024 12:24:35], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 12:24:35' WHERE id= '519';
[02/08/2024 12:24:35], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 12:24:35' WHERE id= '519';
[02/08/2024 12:24:36], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 12:24:36' WHERE id= '519';
[02/08/2024 12:24:37], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 12:24:37' WHERE id= '519';
[02/08/2024 12:24:37], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 12:24:37' WHERE id= '519';
[02/08/2024 12:24:38], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 12:24:38' WHERE id= '519';
[02/08/2024 12:24:49], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 12:24:49' WHERE id= '519';
[02/08/2024 12:24:49], [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/08_02_2024/request_sight_details_hotel_yards_12_24_49_1707395089.json', 'v1/08_02_2024/response_sight_details_hotel_yards_12_24_49_1707395089.json', 'v1/08_02_2024/response_header_sight_details_hotel_yards_12_24_49_1707395089.json', 'viator', '2024-02-08 12:24:49', '', '', '1368');
[02/08/2024 12:24:50], [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/08_02_2024/request_sight_details_hotel_yards_12_24_50_1707395090.json', 'v1/08_02_2024/response_sight_details_hotel_yards_12_24_50_1707395090.json', 'v1/08_02_2024/response_header_sight_details_hotel_yards_12_24_50_1707395090.json', 'viator', '2024-02-08 12:24:50', '', '', '1368');
[02/08/2024 12:26:46], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 12:26:46' WHERE id= '520';
[02/08/2024 12:26:47], [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/08_02_2024/request_check_availability_shiv_qtech_12_26_46_1707395206.json', 'v1/08_02_2024/response_check_availability_shiv_qtech_12_26_46_1707395206.json', 'v1/08_02_2024/response_header_check_availability_shiv_qtech_12_26_46_1707395206.json', 'viator', '2024-02-08 12:26:47', '', '', '1365');
[02/08/2024 12:28:11], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 12:28:11' WHERE id= '520';
[02/08/2024 12:28:11], [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/08_02_2024/request_check_availability_shiv_qtech_12_28_11_1707395291.json', 'v1/08_02_2024/response_check_availability_shiv_qtech_12_28_11_1707395291.json', 'v1/08_02_2024/response_header_check_availability_shiv_qtech_12_28_11_1707395291.json', 'viator', '2024-02-08 12:28:11', '', '', '1365');
[02/08/2024 12:28:54], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 12:28:54' WHERE id= '519';
[02/08/2024 12:28:58], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 12:28:58' WHERE id= '519';
[02/08/2024 12:29:12], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-02-08 12:29:12',login_attempt=0 where id = '7866';
[02/08/2024 12:29:12], [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-02-08 12:29:12', ip = '43.239.53.130', action = 'Login' ;
[02/08/2024 12:29:12], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 12:29:12' WHERE id= '515';
[02/08/2024 12:30:46], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 12:30:46' WHERE id= '519';
[02/08/2024 12:31:03], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 12:31:03' WHERE id= '519';
[02/08/2024 12:31:05], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 12:31:05' WHERE id= '519';
[02/08/2024 12:31:05], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7867' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '32' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/02/22',  departure_date='2024/02/22',  nights='1',  create_date='2024-02-08 :12:31:05',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '21' ;
[02/08/2024 12:31: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/08_02_2024/request_availability_hotel_yards_12_31_05_1707395465.json', 'v1/08_02_2024/response_availability_hotel_yards_12_31_05_1707395465.json', 'v1/08_02_2024/response_header_availability_hotel_yards_12_31_05_1707395465.json', 'viator', '2024-02-08 12:31:15', '', '', '1369');
[02/08/2024 12:31:16], [file name :-/home/otrams/public_html/beta/contact_us.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 12:31:16' WHERE id= '519';
[02/08/2024 12:31:18], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 12:31:18' WHERE id= '519';
[02/08/2024 12:31:18], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 12:31:18' WHERE id= '519';
[02/08/2024 12:31:28], [file name :-/home/otrams/public_html/beta/terms.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 12:31:28' WHERE id= '519';
[02/08/2024 12:33:39], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 12:33:39' WHERE id= '520';
[02/08/2024 12:33:41], [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/08_02_2024/request_check_availability_shiv_qtech_12_33_39_1707395619.json', 'v1/08_02_2024/response_check_availability_shiv_qtech_12_33_39_1707395619.json', 'v1/08_02_2024/response_header_check_availability_shiv_qtech_12_33_39_1707395619.json', 'viator', '2024-02-08 12:33:41', '', '', '1365');
[02/08/2024 12:34:36], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-02-08 12:34:36',login_attempt=0 where id = '7870';
[02/08/2024 12:34:36], [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-08 12:34:36', ip = '43.239.53.130', action = 'Login' ;
[02/08/2024 12:34:37], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 12:34:37' WHERE id= '517';
[02/08/2024 12:34:41], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 12:34:41' WHERE id= '517';
[02/08/2024 12:42:37], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 12:42:37' WHERE id= '519';
[02/08/2024 12:51:20], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 12:51:20' WHERE id= '519';
[02/08/2024 12:51:26], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-08 12:51:26' WHERE id= '519';
