[01/30/2024 09:19:56], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-30 09:19:56',login_attempt=0 where id = '7868';
[01/30/2024 09:19:56], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'hotelyards', user_type = 'A', branch_id = '1', login_datetime = '2024-01-30 09:19:56', ip = '123.253.233.242', action = 'Login' ;
[01/30/2024 09:19:57], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 09:19:57' WHERE id= '459';
[01/30/2024 09:19:59], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 09:19:59' WHERE id= '459';
[01/30/2024 09:20:03], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 09:20:03' WHERE id= '459';
[01/30/2024 09:20:14], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 09:20:14' WHERE id= '459';
[01/30/2024 09:20:14], [file name :-/home/otrams/public_html/beta/booking_list.php],update messages set mssg_status='R' where booking_id=?;
[01/30/2024 09:20:22], [file name :-/home/otrams/public_html/beta/print_voucher.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 09:20:22' WHERE id= '459';
[01/30/2024 09:20:26], [file name :-/home/otrams/public_html/beta/print_invoice.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 09:20:26' WHERE id= '459';
[01/30/2024 09:23:35], [file name :-/home/otrams/public_html/beta/tms/logout.php],INSERT INTO psa_login_log set username = 'v3alpha' , user_type = 'v3alpha'_type , branch_id = '' , login_datetime = '2024-01-30 09:23:35' , ip = '43.239.53.130' , action = 'Logout'  ;
[01/30/2024 09:25:34], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-30 09:25:34',login_attempt=0 where id = '7867';
[01/30/2024 09:25:34], [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-01-30 09:25:34', ip = '43.239.53.130', action = 'Login' ;
[01/30/2024 09:25:34], [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='231766593d12b484d744ff74a96c5205ff100aae30ed163495709c362bf6088c',create_date='2024-01-30 09:25:34', update_date='2024-01-30 09:25:34',domain='beta.astrabookings.com',sub_agent_id='',sub_user_id='';
[01/30/2024 09:28:05], [file name :-/home/otrams/public_html/beta/tms/logout.php],INSERT INTO psa_login_log set username = 'Ayman' , user_type = 'Ayman'_type , branch_id = '31' , login_datetime = '2024-01-30 09:28:05' , ip = '43.239.53.130' , action = 'Logout'  ;
[01/30/2024 09:30:37], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-30 09:30:37',login_attempt=0 where id = '7866';
[01/30/2024 09:30:37], [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-01-30 09:30:37', ip = '43.239.53.130', action = 'Login' ;
[01/30/2024 09:30:37], [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='be663d3948071f88f42bd9b3829901e85a11e09ef3c6b983f9d6407acc2aa4b6',create_date='2024-01-30 09:30:37', update_date='2024-01-30 09:30:37',domain='hotelyards.astrabookings.com',sub_agent_id='',sub_user_id='';
[01/30/2024 09:30:57], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 09:30:57' WHERE id= '469';
[01/30/2024 09:31:16], [file name :-/home/otrams/public_html/beta/tms/logout.php],INSERT INTO psa_login_log set username = 'v3alpha' , user_type = 'v3alpha'_type , branch_id = '' , login_datetime = '2024-01-30 09:31:16' , ip = '43.239.53.130' , action = 'Logout'  ;
[01/30/2024 09:35:42], [file name :-/home/otrams/public_html/beta/contact_us.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 09:35:42' WHERE id= '469';
[01/30/2024 09:36:17], [file name :-/home/otrams/public_html/beta/contact_us.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 09:36:17' WHERE id= '469';
[01/30/2024 09:36:22], [file name :-/home/otrams/public_html/beta/contact_us.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 09:36:22' WHERE id= '469';
[01/30/2024 09:37:18], [file name :-/home/otrams/public_html/beta/contact_us.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 09:37:18' WHERE id= '469';
[01/30/2024 09:37:23], [file name :-/home/otrams/public_html/beta/contact_us.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 09:37:23' WHERE id= '469';
[01/30/2024 09:37:56], [file name :-/home/otrams/public_html/beta/contact_us.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 09:37:56' WHERE id= '469';
[01/30/2024 09:38:02], [file name :-/home/otrams/public_html/beta/contact_us.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 09:38:02' WHERE id= '469';
[01/30/2024 09:40:00], [file name :-/home/otrams/public_html/beta/contact_us.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 09:40:00' WHERE id= '469';
[01/30/2024 09:40:33], [file name :-/home/otrams/public_html/beta/contact_us.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 09:40:33' WHERE id= '469';
[01/30/2024 09:41:20], [file name :-/home/otrams/public_html/beta/contact_us.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 09:41:20' WHERE id= '469';
[01/30/2024 09:42:31], [file name :-/home/otrams/public_html/beta/contact_us.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 09:42:31' WHERE id= '469';
[01/30/2024 09:43:06], [file name :-/home/otrams/public_html/beta/contact_us.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 09:43:06' WHERE id= '469';
[01/30/2024 09:43:24], [file name :-/home/otrams/public_html/beta/contact_us.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 09:43:24' WHERE id= '469';
[01/30/2024 09:43:50], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 09:43:50' WHERE id= '469';
[01/30/2024 09:43:55], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 09:43:55' WHERE id= '469';
[01/30/2024 09:45:41], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 09:45:41' WHERE id= '469';
[01/30/2024 09:45:57], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 09:45:57' WHERE id= '469';
[01/30/2024 09:46:02], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 09:46:02' WHERE id= '469';
[01/30/2024 09:46:02], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-30 09:46:02',login_attempt=0 where id = '7865';
[01/30/2024 09:46:02], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'test_Whitelable', user_type = 'A', branch_id = '31', login_datetime = '2024-01-30 09:46:02', ip = '43.239.53.130', action = 'Login' ;
[01/30/2024 09:46:02], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 09:46:02' WHERE id= '469';
[01/30/2024 09:46:08], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 09:46:08' WHERE id= '469';
[01/30/2024 09:46:33], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 09:46:33' WHERE id= '469';
[01/30/2024 09:48:34], [file name :-/home/otrams/public_html/beta/logout.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 09:48:34' WHERE id= '469';
[01/30/2024 09:50:51], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-30 09:50:51',login_attempt=0 where id = '7866';
[01/30/2024 09:50:51], [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-01-30 09:50:51', ip = '43.239.53.130', action = 'Login' ;
[01/30/2024 09:50:51], [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='02e96422cff10bfa2d75a2c723c469eb9ca98acccdd3763884d9da0a8c3f308c',create_date='2024-01-30 09:50:51', update_date='2024-01-30 09:50:51',domain='hotelyards.astrabookings.com',sub_agent_id='',sub_user_id='';
[01/30/2024 09:51:27], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 09:51:27' WHERE id= '470';
[01/30/2024 09:52:20], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 09:52:20' WHERE id= '470';
[01/30/2024 09:54:27], [file name :-/home/otrams/public_html/beta/tms/logout.php],INSERT INTO psa_login_log set username = 'v3alpha' , user_type = 'v3alpha'_type , branch_id = '' , login_datetime = '2024-01-30 09:54:27' , ip = '43.239.53.130' , action = 'Logout'  ;
[01/30/2024 09:54:44], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 09:54:44' WHERE id= '470';
[01/30/2024 09:54:44], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 09:54:44' WHERE id= '470';
[01/30/2024 09:55:22], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-30 09:55:22',login_attempt=0 where id = '7851';
[01/30/2024 09:55:22], [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-01-30 09:55:22', ip = '43.239.53.130', action = 'Login' ;
[01/30/2024 09:55:23], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 09:55:23' WHERE id= '467';
[01/30/2024 09:55:26], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 09:55:26' WHERE id= '467';
[01/30/2024 09:55:29], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 09:55:29' WHERE id= '467';
[01/30/2024 09:55:33], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 09:55:33' WHERE id= '467';
[01/30/2024 09:55:33], [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/02/08',  departure_date='2024/02/08',  nights='1',  create_date='2024-01-30 :09:55:33',  nationality='',  additional_markup='',  selected_currency='SAR',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/30/2024 09:55:42], [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/30_01_2024/request_availability_Viator_test_09_55_33_1706608533.json', 'v1/30_01_2024/response_availability_Viator_test_09_55_33_1706608533.json', 'v1/30_01_2024/response_header_availability_Viator_test_09_55_33_1706608533.json', 'viator', '2024-01-30 09:55:42', '', '', '1192');
[01/30/2024 09:55:44], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 09:55:44' WHERE id= '467';
[01/30/2024 09:55:44], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 09:55:44' WHERE id= '467';
[01/30/2024 09:55:51], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-30 09:55:51',login_attempt=0 where id = '7866';
[01/30/2024 09:55:51], [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-01-30 09:55:51', ip = '43.239.53.130', action = 'Login' ;
[01/30/2024 09:55:51], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 09:55:51' WHERE id= '467';
[01/30/2024 09:55:51], [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/02/08',  departure_date='2024/02/08',  nights='1',  create_date='2024-01-30 :09:55:51',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/30/2024 09:55:52], [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='ae2efedad555ff49b7136479324301ee94b789ea4e4fc7315c75b99bc9fbde7b',create_date='2024-01-30 09:55:52', update_date='2024-01-30 09:55:52',domain='hotelyards.astrabookings.com',sub_agent_id='',sub_user_id='';
[01/30/2024 09:55:55], [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/30_01_2024/request_availability_Viator_test_09_55_51_1706608551.json', 'v1/30_01_2024/response_availability_Viator_test_09_55_51_1706608551.json', 'v1/30_01_2024/response_header_availability_Viator_test_09_55_51_1706608551.json', 'viator', '2024-01-30 09:55:55', '', '', '1193');
[01/30/2024 09:55:56], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 09:55:56' WHERE id= '467';
[01/30/2024 09:55:56], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 09:55:56' WHERE id= '467';
[01/30/2024 09:56:03], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 09:56:03' WHERE id= '467';
[01/30/2024 09:56:04], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/30_01_2024/request_sight_details_Viator_test_09_56_03_1706608563.json', 'v1/30_01_2024/response_sight_details_Viator_test_09_56_03_1706608563.json', 'v1/30_01_2024/response_header_sight_details_Viator_test_09_56_03_1706608563.json', 'viator', '2024-01-30 09:56:04', '', '', '1193');
[01/30/2024 09:56:06], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 09:56:06' WHERE id= '467';
[01/30/2024 09:56:15], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 09:56:15' WHERE id= '470';
[01/30/2024 09:56:24], [file name :-/home/otrams/public_html/beta/my_accounts.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 09:56:24' WHERE id= '470';
[01/30/2024 09:57:37], [file name :-/home/otrams/public_html/beta/tms/user.php],update psa_users set active='N' where id='hotelyards';
[01/30/2024 09:57:37], [file name :-/home/otrams/public_html/beta/tms/user.php],insert into `user_logs` set `username`= 'v3alpha',`create_date`= '2024-01-30 09:57:37',`log_type`= 'User Deactivated',`sql_query`= 'update psa_users set active=\&#039;N\&#039; where id=\&#039;hotelyards\&#039;',`log_description`= 'User hotelyards Deactivated',`ip`= '43.239.53.130';
[01/30/2024 09:57:41], [file name :-/home/otrams/public_html/beta/tms/user.php],update psa_users set active='Y' where id='hotelyards';
[01/30/2024 09:57:41], [file name :-/home/otrams/public_html/beta/tms/user.php],insert into `user_logs` set `username`= 'v3alpha',`create_date`= '2024-01-30 09:57:41',`log_type`= 'User Activated',`sql_query`= 'update psa_users set active=\&#039;Y\&#039; where id=\&#039;hotelyards\&#039;',`log_description`= 'User hotelyards Activated',`ip`= '43.239.53.130';
[01/30/2024 09:58:20], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 09:58:20' WHERE id= '470';
[01/30/2024 09:58:48], [file name :-/home/otrams/public_html/beta/tms/user.php],update psa_users set active='N' where id='hotelyards';
[01/30/2024 09:58:48], [file name :-/home/otrams/public_html/beta/tms/user.php],insert into `user_logs` set `username`= 'v3alpha',`create_date`= '2024-01-30 09:58:48',`log_type`= 'User Deactivated',`sql_query`= 'update psa_users set active=\&#039;N\&#039; where id=\&#039;hotelyards\&#039;',`log_description`= 'User hotelyards Deactivated',`ip`= '43.239.53.130';
[01/30/2024 09:58:51], [file name :-/home/otrams/public_html/beta/tms/user.php],update psa_users set active='Y' where id='hotelyards';
[01/30/2024 09:58:51], [file name :-/home/otrams/public_html/beta/tms/user.php],insert into `user_logs` set `username`= 'v3alpha',`create_date`= '2024-01-30 09:58:51',`log_type`= 'User Activated',`sql_query`= 'update psa_users set active=\&#039;Y\&#039; where id=\&#039;hotelyards\&#039;',`log_description`= 'User hotelyards Activated',`ip`= '43.239.53.130';
[01/30/2024 09:59:58], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-30 09:59:58' WHERE id= '470';
