[03/22/2024 06:00:11], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 06:00:11' WHERE id= '681';
[03/22/2024 06:00:12], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 06:00:12' WHERE id= '681';
[03/22/2024 06:00:24], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 06:00:24' WHERE id= '681';
[03/22/2024 06:00:24], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1711087224','43.239.53.130');
[03/22/2024 06:00:25], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 06:00:25' WHERE id= '681';
[03/22/2024 06:00:25], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO posted_bookings(id,source_type,reservation_id,create_date,status) values ('','viator','3974','2024-03-22 06:00:25',0);
[03/22/2024 06:02:39], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 06:02:39' WHERE id= '681';
[03/22/2024 06:02:39], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1711087359','43.239.53.130');
[03/22/2024 06:03:22], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 06:03:22' WHERE id= '681';
[03/22/2024 06:03:24], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 06:03:24' WHERE id= '681';
[03/22/2024 06:03:29], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 06:03:29' WHERE id= '681';
[03/22/2024 06:03:29], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1711087409','43.239.53.130');
[03/22/2024 06:03:29], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 06:03:29' WHERE id= '681';
[03/22/2024 06:03:30], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO posted_bookings(id,source_type,reservation_id,create_date,status) values ('','viator','3976','2024-03-22 06:03:30',0);
[03/22/2024 06:15:39], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 06:15:39' WHERE id= '681';
[03/22/2024 06:15:39], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO posted_bookings(id,source_type,reservation_id,create_date,status) values ('','viator','3976','2024-03-22 06:15:39',0);
[03/22/2024 06:16:21], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 06:16:21' WHERE id= '681';
[03/22/2024 06:16:21], [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 = 'jaipur' , arrival_date='2024/03/31',  departure_date='2024/03/31',  nights='1',  create_date='2024-03-22 :06:16:21',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[03/22/2024 06:16: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/22_03_2024/request_availability_Viator_test_06_16_21_1711088181.json', 'v1/22_03_2024/response_availability_Viator_test_06_16_21_1711088181.json', 'v1/22_03_2024/response_header_availability_Viator_test_06_16_21_1711088181.json', 'viator', '2024-03-22 06:16:28', '', '', '474');
[03/22/2024 06:16: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/22_03_2024/request_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_header_availability_Viator_test_06_16_28_1711088188_8.json', 'viator', '2024-03-22 06:16:34', '', '', '474');
[03/22/2024 06:16: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/22_03_2024/request_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_header_availability_Viator_test_06_16_28_1711088188_8.json', 'viator', '2024-03-22 06:16:34', '', '', '474');
[03/22/2024 06:16: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/22_03_2024/request_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_header_availability_Viator_test_06_16_28_1711088188_8.json', 'viator', '2024-03-22 06:16:34', '', '', '474');
[03/22/2024 06:16: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/22_03_2024/request_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_header_availability_Viator_test_06_16_28_1711088188_8.json', 'viator', '2024-03-22 06:16:34', '', '', '474');
[03/22/2024 06:16: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/22_03_2024/request_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_header_availability_Viator_test_06_16_28_1711088188_8.json', 'viator', '2024-03-22 06:16:34', '', '', '474');
[03/22/2024 06:16: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/22_03_2024/request_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_header_availability_Viator_test_06_16_28_1711088188_8.json', 'viator', '2024-03-22 06:16:34', '', '', '474');
[03/22/2024 06:16: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/22_03_2024/request_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_header_availability_Viator_test_06_16_28_1711088188_8.json', 'viator', '2024-03-22 06:16:34', '', '', '474');
[03/22/2024 06:16: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/22_03_2024/request_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_header_availability_Viator_test_06_16_28_1711088188_8.json', 'viator', '2024-03-22 06:16:34', '', '', '474');
[03/22/2024 06:16: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/22_03_2024/request_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_header_availability_Viator_test_06_16_28_1711088188_8.json', 'viator', '2024-03-22 06:16:34', '', '', '474');
[03/22/2024 06:16: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/22_03_2024/request_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_header_availability_Viator_test_06_16_28_1711088188_8.json', 'viator', '2024-03-22 06:16:34', '', '', '474');
[03/22/2024 06:16: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/22_03_2024/request_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_header_availability_Viator_test_06_16_28_1711088188_8.json', 'viator', '2024-03-22 06:16:34', '', '', '474');
[03/22/2024 06:16: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/22_03_2024/request_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_header_availability_Viator_test_06_16_28_1711088188_8.json', 'viator', '2024-03-22 06:16:34', '', '', '474');
[03/22/2024 06:16: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/22_03_2024/request_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_header_availability_Viator_test_06_16_28_1711088188_8.json', 'viator', '2024-03-22 06:16:34', '', '', '474');
[03/22/2024 06:16: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/22_03_2024/request_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_header_availability_Viator_test_06_16_28_1711088188_8.json', 'viator', '2024-03-22 06:16:34', '', '', '474');
[03/22/2024 06:16: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/22_03_2024/request_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_header_availability_Viator_test_06_16_28_1711088188_8.json', 'viator', '2024-03-22 06:16:34', '', '', '474');
[03/22/2024 06:16: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/22_03_2024/request_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_header_availability_Viator_test_06_16_28_1711088188_8.json', 'viator', '2024-03-22 06:16:34', '', '', '474');
[03/22/2024 06:16: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/22_03_2024/request_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_header_availability_Viator_test_06_16_28_1711088188_8.json', 'viator', '2024-03-22 06:16:34', '', '', '474');
[03/22/2024 06:16: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/22_03_2024/request_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_header_availability_Viator_test_06_16_28_1711088188_8.json', 'viator', '2024-03-22 06:16:34', '', '', '474');
[03/22/2024 06:16: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/22_03_2024/request_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_header_availability_Viator_test_06_16_28_1711088188_8.json', 'viator', '2024-03-22 06:16:34', '', '', '474');
[03/22/2024 06:16: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/22_03_2024/request_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_header_availability_Viator_test_06_16_28_1711088188_8.json', 'viator', '2024-03-22 06:16:34', '', '', '474');
[03/22/2024 06:16: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/22_03_2024/request_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_header_availability_Viator_test_06_16_28_1711088188_8.json', 'viator', '2024-03-22 06:16:34', '', '', '474');
[03/22/2024 06:16: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/22_03_2024/request_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_header_availability_Viator_test_06_16_28_1711088188_8.json', 'viator', '2024-03-22 06:16:34', '', '', '474');
[03/22/2024 06:16: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/22_03_2024/request_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_header_availability_Viator_test_06_16_28_1711088188_8.json', 'viator', '2024-03-22 06:16:34', '', '', '474');
[03/22/2024 06:16: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/22_03_2024/request_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_header_availability_Viator_test_06_16_28_1711088188_8.json', 'viator', '2024-03-22 06:16:34', '', '', '474');
[03/22/2024 06:16: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/22_03_2024/request_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_header_availability_Viator_test_06_16_28_1711088188_8.json', 'viator', '2024-03-22 06:16:34', '', '', '474');
[03/22/2024 06:16: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/22_03_2024/request_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_header_availability_Viator_test_06_16_28_1711088188_8.json', 'viator', '2024-03-22 06:16:34', '', '', '474');
[03/22/2024 06:16: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/22_03_2024/request_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_header_availability_Viator_test_06_16_28_1711088188_8.json', 'viator', '2024-03-22 06:16:34', '', '', '474');
[03/22/2024 06:16: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/22_03_2024/request_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_header_availability_Viator_test_06_16_28_1711088188_8.json', 'viator', '2024-03-22 06:16:34', '', '', '474');
[03/22/2024 06:16: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/22_03_2024/request_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_header_availability_Viator_test_06_16_28_1711088188_8.json', 'viator', '2024-03-22 06:16:34', '', '', '474');
[03/22/2024 06:16: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/22_03_2024/request_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_header_availability_Viator_test_06_16_28_1711088188_8.json', 'viator', '2024-03-22 06:16:34', '', '', '474');
[03/22/2024 06:16: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/22_03_2024/request_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_header_availability_Viator_test_06_16_28_1711088188_8.json', 'viator', '2024-03-22 06:16:34', '', '', '474');
[03/22/2024 06:16: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/22_03_2024/request_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_header_availability_Viator_test_06_16_28_1711088188_8.json', 'viator', '2024-03-22 06:16:34', '', '', '474');
[03/22/2024 06:16: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/22_03_2024/request_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_header_availability_Viator_test_06_16_28_1711088188_8.json', 'viator', '2024-03-22 06:16:34', '', '', '474');
[03/22/2024 06:16: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/22_03_2024/request_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_header_availability_Viator_test_06_16_28_1711088188_8.json', 'viator', '2024-03-22 06:16:34', '', '', '474');
[03/22/2024 06:16: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/22_03_2024/request_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_header_availability_Viator_test_06_16_28_1711088188_8.json', 'viator', '2024-03-22 06:16:34', '', '', '474');
[03/22/2024 06:16: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/22_03_2024/request_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_header_availability_Viator_test_06_16_28_1711088188_8.json', 'viator', '2024-03-22 06:16:34', '', '', '474');
[03/22/2024 06:16: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/22_03_2024/request_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_header_availability_Viator_test_06_16_28_1711088188_8.json', 'viator', '2024-03-22 06:16:34', '', '', '474');
[03/22/2024 06:16: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/22_03_2024/request_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_header_availability_Viator_test_06_16_28_1711088188_8.json', 'viator', '2024-03-22 06:16:34', '', '', '474');
[03/22/2024 06:16: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/22_03_2024/request_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_header_availability_Viator_test_06_16_28_1711088188_8.json', 'viator', '2024-03-22 06:16:34', '', '', '474');
[03/22/2024 06:16: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/22_03_2024/request_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_header_availability_Viator_test_06_16_28_1711088188_8.json', 'viator', '2024-03-22 06:16:34', '', '', '474');
[03/22/2024 06:16: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/22_03_2024/request_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_header_availability_Viator_test_06_16_28_1711088188_8.json', 'viator', '2024-03-22 06:16:34', '', '', '474');
[03/22/2024 06:16: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/22_03_2024/request_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_header_availability_Viator_test_06_16_28_1711088188_8.json', 'viator', '2024-03-22 06:16:34', '', '', '474');
[03/22/2024 06:16: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/22_03_2024/request_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_header_availability_Viator_test_06_16_28_1711088188_8.json', 'viator', '2024-03-22 06:16:34', '', '', '474');
[03/22/2024 06:16: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/22_03_2024/request_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_header_availability_Viator_test_06_16_28_1711088188_8.json', 'viator', '2024-03-22 06:16:34', '', '', '474');
[03/22/2024 06:16: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/22_03_2024/request_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_header_availability_Viator_test_06_16_28_1711088188_8.json', 'viator', '2024-03-22 06:16:34', '', '', '474');
[03/22/2024 06:16: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/22_03_2024/request_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_header_availability_Viator_test_06_16_28_1711088188_8.json', 'viator', '2024-03-22 06:16:34', '', '', '474');
[03/22/2024 06:16: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/22_03_2024/request_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_header_availability_Viator_test_06_16_28_1711088188_8.json', 'viator', '2024-03-22 06:16:34', '', '', '474');
[03/22/2024 06:16: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/22_03_2024/request_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_header_availability_Viator_test_06_16_28_1711088188_8.json', 'viator', '2024-03-22 06:16:34', '', '', '474');
[03/22/2024 06:16: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/22_03_2024/request_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_header_availability_Viator_test_06_16_28_1711088188_8.json', 'viator', '2024-03-22 06:16:34', '', '', '474');
[03/22/2024 06:16: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/22_03_2024/request_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_header_availability_Viator_test_06_16_28_1711088188_8.json', 'viator', '2024-03-22 06:16:34', '', '', '474');
[03/22/2024 06:16: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/22_03_2024/request_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_header_availability_Viator_test_06_16_28_1711088188_8.json', 'viator', '2024-03-22 06:16:34', '', '', '474');
[03/22/2024 06:16: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/22_03_2024/request_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_header_availability_Viator_test_06_16_28_1711088188_8.json', 'viator', '2024-03-22 06:16:34', '', '', '474');
[03/22/2024 06:16: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/22_03_2024/request_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_header_availability_Viator_test_06_16_28_1711088188_8.json', 'viator', '2024-03-22 06:16:34', '', '', '474');
[03/22/2024 06:16: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/22_03_2024/request_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_header_availability_Viator_test_06_16_28_1711088188_8.json', 'viator', '2024-03-22 06:16:34', '', '', '474');
[03/22/2024 06:16: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/22_03_2024/request_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_header_availability_Viator_test_06_16_28_1711088188_8.json', 'viator', '2024-03-22 06:16:34', '', '', '474');
[03/22/2024 06:16: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/22_03_2024/request_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_header_availability_Viator_test_06_16_28_1711088188_8.json', 'viator', '2024-03-22 06:16:34', '', '', '474');
[03/22/2024 06:16: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/22_03_2024/request_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_header_availability_Viator_test_06_16_28_1711088188_8.json', 'viator', '2024-03-22 06:16:34', '', '', '474');
[03/22/2024 06:16: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/22_03_2024/request_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_header_availability_Viator_test_06_16_28_1711088188_8.json', 'viator', '2024-03-22 06:16:34', '', '', '474');
[03/22/2024 06:16: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/22_03_2024/request_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_header_availability_Viator_test_06_16_28_1711088188_8.json', 'viator', '2024-03-22 06:16:34', '', '', '474');
[03/22/2024 06:16: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/22_03_2024/request_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_header_availability_Viator_test_06_16_28_1711088188_8.json', 'viator', '2024-03-22 06:16:34', '', '', '474');
[03/22/2024 06:16: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/22_03_2024/request_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_availability_Viator_test_06_16_28_1711088188_8.json', 'v1/22_03_2024/response_header_availability_Viator_test_06_16_28_1711088188_8.json', 'viator', '2024-03-22 06:16:34', '', '', '474');
[03/22/2024 06:16:36], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 06:16:36' WHERE id= '681';
[03/22/2024 06:16:36], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 06:16:36' WHERE id= '681';
[03/22/2024 06:21:41], [file name :-/home/otrams/public_html/beta/index.php],INSERT INTO psa_login_log  SET username = '', user_type = 'A', branch_id = '12', login_datetime = '2024-03-22 06:21:41', ip = '199.45.154.66', action = 'Login' ;
[03/22/2024 06:22:31], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 06:22:31' WHERE id= '681';
[03/22/2024 06:22: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/22_03_2024/request_sight_details_Viator_test_06_22_31_1711088551.json', 'v1/22_03_2024/response_sight_details_Viator_test_06_22_31_1711088551.json', 'v1/22_03_2024/response_header_sight_details_Viator_test_06_22_31_1711088551.json', 'viator', '2024-03-22 06:22:32', '', '', '474');
[03/22/2024 06:22: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/22_03_2024/request_sight_details_Viator_test_06_22_32_1711088552.json', 'v1/22_03_2024/response_sight_details_Viator_test_06_22_32_1711088552.json', 'v1/22_03_2024/response_header_sight_details_Viator_test_06_22_32_1711088552.json', 'viator', '2024-03-22 06:22:33', '', '', '474');
[03/22/2024 06:22:33], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 06:22:33' WHERE id= '701';
[03/22/2024 06:22:33], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-03-22 06:22:33',login_attempt=0 where id = '7873';
[03/22/2024 06:22:33], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Gajendra', user_type = 'A', branch_id = '1', login_datetime = '2024-03-22 06:22:33', ip = '43.239.53.130', action = 'Login' ;
[03/22/2024 06:22:34], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 06:22:34' WHERE id= '701';
[03/22/2024 06:22:35], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 06:22:35' WHERE id= '681';
[03/22/2024 06:22: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 ('', 'check_availability', 'v1/22_03_2024/request_check_availability_Viator_test_06_22_35_1711088555.json', 'v1/22_03_2024/response_check_availability_Viator_test_06_22_35_1711088555.json', 'v1/22_03_2024/response_header_check_availability_Viator_test_06_22_35_1711088555.json', 'viator', '2024-03-22 06:22:36', '', '', '474');
[03/22/2024 06:22:38], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 06:22:38' WHERE id= '701';
[03/22/2024 06:22:39], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 06:22:39' WHERE id= '701';
[03/22/2024 06:22:41], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 06:22:41' WHERE id= '701';
[03/22/2024 06:22:41], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 06:22:41' WHERE id= '701';
[03/22/2024 06:22:43], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 06:22:43' WHERE id= '681';
[03/22/2024 06:22:43], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1711088563','43.239.53.130');
[03/22/2024 06:22:49], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 06:22:49' WHERE id= '701';
[03/22/2024 06:22:49], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7873' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '43.239.53.130' , city = 'agartala' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/05/01' , departure_date = '2024/05/02' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-03-22 06:22:49' , site_id = '' , country_code = '106' , city_code = '64625' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[03/22/2024 06:22:50], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 06:22:50' WHERE id= '701';
[03/22/2024 06:22:50], [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/22_03_2024/request_availability_Gajendra_475_1711088570_30.json', 'e1/22_03_2024/response_availability_Gajendra_475_1711088570_30.json', 'e1/22_03_2024/response_header_availability_Gajendra_475_1711088570_30.json', 'expedia', '2024-03-22 06:22:50', '', 'ac68809091dabae05c72e7ba54edb54ece3ff1340a508d31a5220ba03f0713a3', '475');
[03/22/2024 06:22:50], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=ac68809091dabae05c72e7ba54edb54ece3ff1340a508d31a5220ba03f0713a3&xml_user_id=7873&db_caching=1&erequest=0&total_request=1&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=MozillaFirefox%2F121.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-03-22 06:22:50.231'
        , 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.373'
        , error_description = ''
        , memory_used = '2013592'
        WHERE id = '77889';
[03/22/2024 06:22:50], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/22_03_2024/request_availability_Gajendra_475_1711088570_61.json', 'e1p/22_03_2024/response_availability_Gajendra_475_1711088570_61.json', 'e1p/22_03_2024/response_header_availability_Gajendra_475_1711088570_61.json', 'expediapackage', '2024-03-22 06:22:50', '', 'ac68809091dabae05c72e7ba54edb54ece3ff1340a508d31a5220ba03f0713a3', '475');
[03/22/2024 06:22:50], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=ac68809091dabae05c72e7ba54edb54ece3ff1340a508d31a5220ba03f0713a3&xml_user_id=7873&db_caching=1&erequest=0&total_request=1&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=MozillaFirefox%2F121.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-03-22 06:22:50.232'
        , 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.532'
        , error_description = ''
        , memory_used = '2024616'
        WHERE id = '77890';
[03/22/2024 06:22:50], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '4',
        request_path = '/xml_all.php?userid=7873&sessionid=ac68809091dabae05c72e7ba54edb54ece3ff1340a508d31a5220ba03f0713a3',
        duration = '0.588',
        merge_duration = '0.001',
        assigned_supplier_count = '2',
        searched_supplier_count = '2',
        system_load_1_min = '1.33',
        system_load_5_min = '0.66',
        system_load_15_min = '0.57',
        system_memory_usage = '59.93',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '475') + '1736976',
        parallel_search_count = '1',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '475';
[03/22/2024 06:22:51], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 06:22:51' WHERE id= '701';
[03/22/2024 06:22:52], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 06:22:52' WHERE id= '701';
[03/22/2024 06:23:08], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 06:23:08' WHERE id= '701';
[03/22/2024 06:23:08], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7873' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '43.239.53.130' , city = 'agartala' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/05/01' , departure_date = '2024/05/02' , nights = '1' , nationality = '106' , room_types = '3, 3' , room_type='[{"numberOfAdults":3},{"numberOfAdults":3}]' , available='0' , create_date = '2024-03-22 06:23:08' , site_id = '' , country_code = '106' , city_code = '64625' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[03/22/2024 06:23:09], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 06:23:09' WHERE id= '701';
[03/22/2024 06:23:09], [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/22_03_2024/request_availability_Gajendra_476_1711088589_60.json', 'e1/22_03_2024/response_availability_Gajendra_476_1711088589_60.json', 'e1/22_03_2024/response_header_availability_Gajendra_476_1711088589_60.json', 'expedia', '2024-03-22 06:23:09', '', 'ac68809091dabae05c72e7ba54edb54ece3ff1340a508d31a5220ba03f0713a3', '476');
[03/22/2024 06:23:09], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=ac68809091dabae05c72e7ba54edb54ece3ff1340a508d31a5220ba03f0713a3&xml_user_id=7873&db_caching=1&erequest=0&total_request=1&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=MozillaFirefox%2F121.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-03-22 06:23:09.173'
        , 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.329'
        , error_description = ''
        , memory_used = '1495312'
        WHERE id = '77891';
[03/22/2024 06:23:09], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/22_03_2024/request_availability_Gajendra_476_1711088589_22.json', 'e1p/22_03_2024/response_availability_Gajendra_476_1711088589_22.json', 'e1p/22_03_2024/response_header_availability_Gajendra_476_1711088589_22.json', 'expediapackage', '2024-03-22 06:23:09', '', 'ac68809091dabae05c72e7ba54edb54ece3ff1340a508d31a5220ba03f0713a3', '476');
[03/22/2024 06:23:09], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=ac68809091dabae05c72e7ba54edb54ece3ff1340a508d31a5220ba03f0713a3&xml_user_id=7873&db_caching=1&erequest=0&total_request=1&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=MozillaFirefox%2F121.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-03-22 06:23:09.174'
        , 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.406'
        , error_description = ''
        , memory_used = '1496184'
        WHERE id = '77892';
[03/22/2024 06:23:09], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '2',
        request_path = '/xml_all.php?userid=7873&sessionid=ac68809091dabae05c72e7ba54edb54ece3ff1340a508d31a5220ba03f0713a3',
        duration = '0.458',
        merge_duration = '0.001',
        assigned_supplier_count = '2',
        searched_supplier_count = '2',
        system_load_1_min = '0.95',
        system_load_5_min = '0.62',
        system_load_15_min = '0.56',
        system_memory_usage = '59.95',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '476') + '1737568',
        parallel_search_count = '1',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '476';
[03/22/2024 06:23:09], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 06:23:09' WHERE id= '701';
[03/22/2024 06:23:11], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 06:23:11' WHERE id= '701';
[03/22/2024 06:23:37], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 06:23:37' WHERE id= '701';
[03/22/2024 06:23:37], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7873' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '43.239.53.130' , city = 'agartala' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/05/01' , departure_date = '2024/05/02' , nights = '1' , nationality = '106' , room_types = '3, 3' , room_type='[{"numberOfAdults":3},{"numberOfAdults":3}]' , available='0' , create_date = '2024-03-22 06:23:37' , site_id = '' , country_code = '106' , city_code = '64625' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[03/22/2024 06:23:38], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 06:23:38' WHERE id= '701';
[03/22/2024 06:23:38], [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/22_03_2024/request_availability_Gajendra_477_1711088618_3.json', 'e1/22_03_2024/response_availability_Gajendra_477_1711088618_3.json', 'e1/22_03_2024/response_header_availability_Gajendra_477_1711088618_3.json', 'expedia', '2024-03-22 06:23:38', '', 'ac68809091dabae05c72e7ba54edb54ece3ff1340a508d31a5220ba03f0713a3', '477');
[03/22/2024 06:23:38], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expedia&sessionid=ac68809091dabae05c72e7ba54edb54ece3ff1340a508d31a5220ba03f0713a3&xml_user_id=7873&db_caching=1&erequest=0&total_request=1&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=MozillaFirefox%2F121.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-03-22 06:23:38.348'
        , 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.347'
        , error_description = ''
        , memory_used = '1496112'
        WHERE id = '77893';
[03/22/2024 06:23:38], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/22_03_2024/request_availability_Gajendra_477_1711088618_93.json', 'e1p/22_03_2024/response_availability_Gajendra_477_1711088618_93.json', 'e1p/22_03_2024/response_header_availability_Gajendra_477_1711088618_93.json', 'expediapackage', '2024-03-22 06:23:38', '', 'ac68809091dabae05c72e7ba54edb54ece3ff1340a508d31a5220ba03f0713a3', '477');
[03/22/2024 06:23:38], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=expediapackage&sessionid=ac68809091dabae05c72e7ba54edb54ece3ff1340a508d31a5220ba03f0713a3&xml_user_id=7873&db_caching=1&erequest=0&total_request=1&web_service=no&site_id=&save_log=yes&ip=43.239.53.130&browser=MozillaFirefox%2F121.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
        , http_hit_time = '2024-03-22 06:23:38.349'
        , 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.412'
        , error_description = ''
        , memory_used = '1495760'
        WHERE id = '77894';
[03/22/2024 06:23:38], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '2',
        request_path = '/xml_all.php?userid=7873&sessionid=ac68809091dabae05c72e7ba54edb54ece3ff1340a508d31a5220ba03f0713a3',
        duration = '0.475',
        merge_duration = '0.001',
        assigned_supplier_count = '2',
        searched_supplier_count = '2',
        system_load_1_min = '0.63',
        system_load_5_min = '0.57',
        system_load_15_min = '0.54',
        system_memory_usage = '59.85',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '477') + '1737776',
        parallel_search_count = '1',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '477';
[03/22/2024 06:23:39], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 06:23:39' WHERE id= '701';
[03/22/2024 06:23:41], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 06:23:41' WHERE id= '701';
[03/22/2024 06:34:40], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 06:34:40' WHERE id= '681';
[03/22/2024 06:34:40], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1711089280','43.239.53.130');
[03/22/2024 06:36:37], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 06:36:37' WHERE id= '681';
[03/22/2024 06:36:37], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1711089397','43.239.53.130');
[03/22/2024 06:37:47], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 06:37:47' WHERE id= '681';
[03/22/2024 06:37:47], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1711089467','43.239.53.130');
[03/22/2024 06:38:16], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 06:38:16' WHERE id= '681';
[03/22/2024 06:38:16], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1711089496','43.239.53.130');
[03/22/2024 06:39:41], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 06:39:41' WHERE id= '681';
[03/22/2024 06:39:41], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1711089581','43.239.53.130');
[03/22/2024 06:41:18], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 06:41:18' WHERE id= '701';
[03/22/2024 06:41:21], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 06:41:21' WHERE id= '701';
[03/22/2024 06:42:21], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 06:42:21' WHERE id= '681';
[03/22/2024 06:42:21], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1711089741','43.239.53.130');
[03/22/2024 06:44:39], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 06:44:39' WHERE id= '681';
[03/22/2024 06:44:39], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1711089879','43.239.53.130');
[03/22/2024 06:44:39], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 06:44:39' WHERE id= '681';
[03/22/2024 06:44:39], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO posted_bookings(id,source_type,reservation_id,create_date,status) values ('','viator','3984','2024-03-22 06:44:39',0);
[03/22/2024 06:47:21], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 06:47:21' WHERE id= '681';
[03/22/2024 06:47:21], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO posted_bookings(id,source_type,reservation_id,create_date,status) values ('','viator','3984','2024-03-22 06:47:21',0);
[03/22/2024 06:47:23], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 06:47:23' WHERE id= '681';
[03/22/2024 06:47:23], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1711090043','43.239.53.130');
[03/22/2024 06:48:39], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 06:48:39' WHERE id= '681';
[03/22/2024 06:48:39], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1711090119','43.239.53.130');
[03/22/2024 06:49:22], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 06:49:22' WHERE id= '681';
[03/22/2024 06:49:22], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1711090162','43.239.53.130');
[03/22/2024 06:51:22], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 06:51:22' WHERE id= '681';
[03/22/2024 06:51:22], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1711090282','43.239.53.130');
[03/22/2024 06:51:23], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 06:51:23' WHERE id= '681';
[03/22/2024 06:51:23], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO posted_bookings(id,source_type,reservation_id,create_date,status) values ('','viator','3988','2024-03-22 06:51:23',0);
[03/22/2024 06:51:33], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 06:51:33' WHERE id= '681';
[03/22/2024 06:51:33], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1711090293','43.239.53.130');
[03/22/2024 06:52:09], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 06:52:09' WHERE id= '681';
[03/22/2024 06:52:09], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1711090329','43.239.53.130');
[03/22/2024 06:53:48], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 06:53:48' WHERE id= '681';
[03/22/2024 06:53:48], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1711090428','43.239.53.130');
[03/22/2024 06:54:09], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-03-22 06:54:09' WHERE id= '681';
[03/22/2024 06:54:09], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1711090449','43.239.53.130');
