[02/12/2024 06:07:07], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-02-12 06:07:07',login_attempt=0 where id = '7849';
[02/12/2024 06:07:07], [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-12 06:07:07', ip = '43.239.53.130', action = 'Login' ;
[02/12/2024 06:07:07], [file name :-/home/otrams/public_html/beta/hotel_search.php],insert into user_sessions_ip SET ip_addr='43.239.53.130', agent_id='7849', session_id='c362146d7d94148a142eaa3812fc2453a1a87d966578568ca669bd7578e45246',create_date='2024-02-12 06:07:07', update_date='2024-02-12 06:07:07',domain='beta.astrabookings.com',sub_agent_id='',sub_user_id='';
[02/12/2024 06:07:12], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 06:07:12' WHERE id= '541';
[02/12/2024 06:07:16], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 06:07:16' WHERE id= '541';
[02/12/2024 06:07:20], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 06:07:20' WHERE id= '541';
[02/12/2024 06:07:20], [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/25',  departure_date='2024/02/25',  nights='1',  create_date='2024-02-12 :06:07:20',  nationality='',  additional_markup='',  selected_currency='INR',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[02/12/2024 06:07: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/12_02_2024/request_availability_shiv_qtech_06_07_20_1707718040.json', 'v1/12_02_2024/response_availability_shiv_qtech_06_07_20_1707718040.json', 'v1/12_02_2024/response_header_availability_shiv_qtech_06_07_20_1707718040.json', 'viator', '2024-02-12 06:07:26', '', '', '1388');
[02/12/2024 06:07:28], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 06:07:28' WHERE id= '541';
[02/12/2024 06:07:29], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 06:07:29' WHERE id= '541';
[02/12/2024 06:07:31], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 06:07:31' WHERE id= '541';
[02/12/2024 06:07: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/12_02_2024/request_sight_details_shiv_qtech_06_07_31_1707718051.json', 'v1/12_02_2024/response_sight_details_shiv_qtech_06_07_31_1707718051.json', 'v1/12_02_2024/response_header_sight_details_shiv_qtech_06_07_31_1707718051.json', 'viator', '2024-02-12 06:07:32', '', '', '1388');
[02/12/2024 06:07: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/12_02_2024/request_sight_details_shiv_qtech_06_07_32_1707718052.json', 'v1/12_02_2024/response_sight_details_shiv_qtech_06_07_32_1707718052.json', 'v1/12_02_2024/response_header_sight_details_shiv_qtech_06_07_32_1707718052.json', 'viator', '2024-02-12 06:07:32', '', '', '1388');
[02/12/2024 06:07:34], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 06:07:34' WHERE id= '541';
[02/12/2024 06:07: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 ('', 'check_availability', 'v1/12_02_2024/request_check_availability_shiv_qtech_06_07_34_1707718054.json', 'v1/12_02_2024/response_check_availability_shiv_qtech_06_07_34_1707718054.json', 'v1/12_02_2024/response_header_check_availability_shiv_qtech_06_07_34_1707718054.json', 'viator', '2024-02-12 06:07:34', '', '', '1388');
[02/12/2024 06:07:38], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 06:07:38' WHERE id= '541';
[02/12/2024 06:07:38], [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/12_02_2024/request_check_availability_shiv_qtech_06_07_38_1707718058.json', 'v1/12_02_2024/response_check_availability_shiv_qtech_06_07_38_1707718058.json', 'v1/12_02_2024/response_header_check_availability_shiv_qtech_06_07_38_1707718058.json', 'viator', '2024-02-12 06:07:38', '', '', '1388');
[02/12/2024 06:07:57], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 06:07:57' WHERE id= '541';
[02/12/2024 06:07:57], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1707718077','43.239.53.130');
[02/12/2024 06:12:29], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-02-12 06:12:29',login_attempt=0 where id = '7870';
[02/12/2024 06:12:29], [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-12 06:12:29', ip = '43.239.53.130', action = 'Login' ;
[02/12/2024 06:12:29], [file name :-/home/otrams/public_html/beta/hotel_search.php],insert into user_sessions_ip SET ip_addr='43.239.53.130', agent_id='7867', session_id='7652e5ea99667946daa236c09ab546a82d99ec84c07c03dc463d76049258e6f4',create_date='2024-02-12 06:12:29', update_date='2024-02-12 06:12:29',domain='hotelyards.astrabookings.com',sub_agent_id='',sub_user_id='';
[02/12/2024 06:12:32], [file name :-/home/otrams/public_html/beta/logout.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 06:12:32' WHERE id= '542';
[02/12/2024 06:30:49], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-02-12 06:30:49',login_attempt=0 where id = '7866';
[02/12/2024 06:30:49], [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-12 06:30:49', ip = '43.239.53.130', action = 'Login' ;
[02/12/2024 06:30:49], [file name :-/home/otrams/public_html/beta/hotel_search.php],insert into user_sessions_ip SET ip_addr='43.239.53.130', agent_id='7863', session_id='805843db93dac362964ad37c9844742ee2baf7c956e2a0b80add5b8779afe256',create_date='2024-02-12 06:30:49', update_date='2024-02-12 06:30:49',domain='baysantravel.astrabookings.com',sub_agent_id='',sub_user_id='';
[02/12/2024 06:36:31], [file name :-/home/otrams/public_html/beta/logout.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 06:36:31' WHERE id= '543';
