[05/08/2024 12:01:16], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-05-08 12:01:16',login_attempt=0 where id = '7851';
[05/08/2024 12:01:16], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Viator_test', user_type = 'A', branch_id = '27', login_datetime = '2024-05-08 12:01:16', ip = '43.239.53.130', action = 'Login' ;
[05/08/2024 12:01:16], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-05-08 12:01:16' WHERE id= '846';
[05/08/2024 12:01:19], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-05-08 12:01:19' WHERE id= '846';
[05/08/2024 12:01:21], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-05-08 12:01:21' WHERE id= '846';
[05/08/2024 12:01:25], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-05-08 12:01:25' WHERE id= '846';
[05/08/2024 12:01:32], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-05-08 12:01:32' WHERE id= '846';
[05/08/2024 12:01:32], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7851' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '27' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/05/30',  departure_date='2024/05/30',  nights='1',  create_date='2024-05-08 :12:01:32',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[05/08/2024 12:01: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_05_2024/request_availability_Viator_test_12_01_32_1715169692.json', 'v1/08_05_2024/response_availability_Viator_test_12_01_32_1715169692.json', 'v1/08_05_2024/response_header_availability_Viator_test_12_01_32_1715169692.json', 'viator', '2024-05-08 12:01:32', '', '', '1621');
[05/08/2024 12:01:33], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-05-08 12:01:33' WHERE id= '846';
[05/08/2024 12:02:59], [file name :-/home/otrams/public_html/beta/manage_sub_user.php],UPDATE user_sessions_ip SET update_date = '2024-05-08 12:02:59' WHERE id= '847';
[05/08/2024 12:03:07], [file name :-/home/otrams/public_html/beta/manage_sub_user.php],UPDATE user_sessions_ip SET update_date = '2024-05-08 12:03:07' WHERE id= '847';
[05/08/2024 12:03:07], [file name :-/home/otrams/public_html/beta/manage_sub_user.php],update sub_user SET first_name='gajendra',middle_name='',last_name='qtech',address='mumbai',city='71649',country='138',phone='  91-1234567890',mobile='  91-1234567890',designation='QA',can_book='',can_voucher='',view_all_bookings='0',allow_book_under_cancellation='',modify_date='2024-05-08 12:03:07',email='gajendra.rajpurohit@qtechsoftware.com',status='A'where sub_user_id='6';
[05/08/2024 12:03:08], [file name :-/home/otrams/public_html/beta/manage_sub_user.php],UPDATE user_sessions_ip SET update_date = '2024-05-08 12:03:08' WHERE id= '847';
[05/08/2024 12:05:11], [file name :-/home/otrams/public_html/beta/logout.php],UPDATE user_sessions_ip SET update_date = '2024-05-08 12:05:11' WHERE id= '847';
[05/08/2024 12:05:36], [file name :-/home/otrams/public_html/beta/forgot_password.php],update sub_user set hash='9289be5'6'16269ac182fa7fe16b71a62d' where sub_user_id= ? and status !='D';
[05/08/2024 12:06:58], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-05-08 12:06:58',login_attempt=0 where id = '7867';
[05/08/2024 12:06:58], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'hotel_yards', user_type = 'A', branch_id = '32', login_datetime = '2024-05-08 12:06:58', ip = '43.239.53.130', action = 'Login' ;
[05/08/2024 12:06:58], [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='82e3e10682b19dd2480b303f40738b574ba14c6b594a6573f88f957538ce3e64',create_date='2024-05-08 12:06:58', update_date='2024-05-08 12:06:58',domain='beta.astrabookings.com',sub_agent_id='',sub_user_id='';
[05/08/2024 12:07:03], [file name :-/home/otrams/public_html/beta/my_accounts.php],UPDATE user_sessions_ip SET update_date = '2024-05-08 12:07:03' WHERE id= '848';
[05/08/2024 12:07:06], [file name :-/home/otrams/public_html/beta/manage_sub_user.php],UPDATE user_sessions_ip SET update_date = '2024-05-08 12:07:06' WHERE id= '848';
[05/08/2024 12:07:19], [file name :-/home/otrams/public_html/beta/manage_sub_user.php],UPDATE user_sessions_ip SET update_date = '2024-05-08 12:07:19' WHERE id= '848';
[05/08/2024 12:14:26], [file name :-/home/otrams/public_html/beta/manage_sub_user.php],UPDATE user_sessions_ip SET update_date = '2024-05-08 12:14:26' WHERE id= '848';
[05/08/2024 12:14:26], [file name :-/home/otrams/public_html/beta/manage_sub_user.php],update sub_user SET first_name='Raju',middle_name='kishor',last_name='Teli',address='Mumbai Central',city='71649',country='138',phone='  91-9876543210',mobile='  91-9876543210',designation='operation staff',can_book='1',can_voucher='',view_all_bookings='1',allow_book_under_cancellation='',modify_date='2024-05-08 12:14:26',email='rajuteli@gmail.com',status='A'where sub_user_id='7';
[05/08/2024 12:14:26], [file name :-/home/otrams/public_html/beta/manage_sub_user.php],UPDATE user_sessions_ip SET update_date = '2024-05-08 12:14:26' WHERE id= '848';
[05/08/2024 12:21:26], [file name :-/home/otrams/public_html/beta/manage_sub_user.php],UPDATE user_sessions_ip SET update_date = '2024-05-08 12:21:26' WHERE id= '848';
[05/08/2024 12:21:45], [file name :-/home/otrams/public_html/beta/manage_sub_user.php],UPDATE user_sessions_ip SET update_date = '2024-05-08 12:21:45' WHERE id= '848';
[05/08/2024 12:21:45], [file name :-/home/otrams/public_html/beta/manage_sub_user.php],update sub_user SET first_name='shiv',middle_name='',last_name='baba',address='mumbai',city='71650',country='138',phone='    91-1234567890',mobile='    91-1234567890',designation='',can_book='1',can_voucher='1',view_all_bookings='1',allow_book_under_cancellation='1',modify_date='2024-05-08 12:21:45',email='shiv.chauhan123@qtechsoftware.com',status='A'where sub_user_id='5';
[05/08/2024 12:21:45], [file name :-/home/otrams/public_html/beta/manage_sub_user.php],UPDATE user_sessions_ip SET update_date = '2024-05-08 12:21:45' WHERE id= '848';
[05/08/2024 12:22:56], [file name :-/home/otrams/public_html/beta/manage_sub_user.php],UPDATE user_sessions_ip SET update_date = '2024-05-08 12:22:56' WHERE id= '848';
[05/08/2024 12:23:03], [file name :-/home/otrams/public_html/beta/manage_sub_user.php],UPDATE user_sessions_ip SET update_date = '2024-05-08 12:23:03' WHERE id= '848';
[05/08/2024 12:23:03], [file name :-/home/otrams/public_html/beta/manage_sub_user.php],update sub_user SET first_name='shiv',middle_name='',last_name='baba',address='mumbai',city='71650',country='138',phone='     91-1234567890',mobile='     91-1234567890',designation='',can_book='1',can_voucher='1',view_all_bookings='1',allow_book_under_cancellation='1',modify_date='2024-05-08 12:23:03',email='shiv.chauhan@qtechsoftware.com',status='A'where sub_user_id='5';
[05/08/2024 12:23:04], [file name :-/home/otrams/public_html/beta/manage_sub_user.php],UPDATE user_sessions_ip SET update_date = '2024-05-08 12:23:04' WHERE id= '848';
[05/08/2024 12:23:13], [file name :-/home/otrams/public_html/beta/manage_sub_user.php],UPDATE user_sessions_ip SET update_date = '2024-05-08 12:23:13' WHERE id= '848';
[05/08/2024 12:27:36], [file name :-/home/otrams/public_html/beta/manage_sub_user.php],UPDATE user_sessions_ip SET update_date = '2024-05-08 12:27:36' WHERE id= '848';
[05/08/2024 12:27:42], [file name :-/home/otrams/public_html/beta/my_accounts.php],UPDATE user_sessions_ip SET update_date = '2024-05-08 12:27:42' WHERE id= '848';
[05/08/2024 12:27:46], [file name :-/home/otrams/public_html/beta/manage_sub_user.php],UPDATE user_sessions_ip SET update_date = '2024-05-08 12:27:46' WHERE id= '848';
[05/08/2024 12:28:40], [file name :-/home/otrams/public_html/beta/manage_sub_user.php],UPDATE user_sessions_ip SET update_date = '2024-05-08 12:28:40' WHERE id= '848';
[05/08/2024 12:28:51], [file name :-/home/otrams/public_html/beta/manage_sub_user.php],UPDATE user_sessions_ip SET update_date = '2024-05-08 12:28:51' WHERE id= '848';
[05/08/2024 12:30:49], [file name :-/home/otrams/public_html/beta/ajax/check_captcha.php],UPDATE user_sessions_ip SET update_date = '2024-05-08 12:30:49' WHERE id= '848';
[05/08/2024 12:30:50], [file name :-/home/otrams/public_html/beta/manage_sub_user.php],UPDATE user_sessions_ip SET update_date = '2024-05-08 12:30:50' WHERE id= '848';
[05/08/2024 12:30:50], [file name :-/home/otrams/public_html/beta/manage_sub_user.php],UPDATE user_sessions_ip SET update_date = '2024-05-08 12:30:50' WHERE id= '848';
