[08/20/2026 05:24:49], [Script File: agent.php, File: Agent.php, Function: update, Line: 4703],UPDATE agents SET agency_name= 'Qtech',other_language_agency_name= '',accounting_id= 'CD0086',accounting_name= '',first_name= 'Snehal',middle_name= '',last_name= 'Valanju',sort_type= 'price',Web_Service= '',agent_type= 'CC',credit_limit_assigned= '200000',credit_limit= '200000',credit_value=credit_limit-credit_usage,credit_distribution= '1',temp_credit_limit= '0',address= 'Mumbai, India',other_language_address= '',city= '49095',pincode= '40000',country= '47',time_zone_offset= '5.5',enable_dst= '',branch_id='1',phone= '91-7208049129',mobile= '91-7891919191',fax= '',currency= '11',email= 'vishwanath.dhotre@qtechsoftware.com',fields_access= 'Narration Text,Commission Narration',website= '',lead_time= '',search_by_multicurrency= '1',debug= '1',profile= '',designation= '',iata_status= '0',iata_number= '',nature_of_business= '',can_book= '',sales_manager_id= '',comp_reg_no= '',allow_quotation= '1',can_allocate_receipt= '1',can_voucher= '',allow_book_under_cancellation='0',modify_date='2026-08-20 05:24:49',consultant_id= 'Srijith',agency_email= '',acc_name= '',acc_email= '',acc_phone= '',man_name= '',man_email= '',man_phone= '',res_name= '',res_email= '',res_phone= '',remarks= '',apply_service_tax= 'no',allow_ticketing= '',can_show_hotels= '' WHERE id= '86'; [08/20/2026 05:24:49], [Script File: agent.php, File: UserLog.php, Function: insert_user_logs, Line: 32],insert into `user_logs` set `username`= 'sujay_qtech',`create_date`= '2026-08-20 05:24:49',`log_type`= 'Agent Updated',`sql_query`= 'UPDATE agents SET agency_name= \'Qtech\',other_language_agency_name= \'\',accounting_id= \'CD0086\',accounting_name= \'\',first_name= \'Snehal\',middle_name= \'\',last_name= \'Valanju\',sort_type= \'price\',Web_Service= ,agent_type= \'CC\',credit_limit_assigned= \'200000\',credit_limit= \'200000\',credit_value=credit_limit-credit_usage,credit_distribution= \'1\',temp_credit_limit= \'0\',address= \'Mumbai, India\',other_language_address= \'\',city= \'49095\',pincode= \'40000\',country= \'47\',time_zone_offset= \'5.5\',enable_dst= 0,branch_id=\'1\',phone= \'91-7208049129\',mobile= \'91-7891919191\',fax= \'\',currency= 11,email= \'vishwanath.dhotre@qtechsoftware.com\',fields_access= \'Narration Text,Commission Narration\',website= \'\',lead_time= 0,search_by_multicurrency= 1,debug= \'1\',profile= \'\',designation= \'\',iata_status= \'0\',iata_number= \'\',nature_of_business= \'\',can_book= ,sales_manager_id= \'\',comp_reg_no= \'\',allow_quotation= \'1\',can_allocate_receipt= \'1\',can_voucher= ,allow_book_under_cancellation=\'0\',modify_date=\'2026-08-20 05:24:49\',consultant_id= \'Srijith\',agency_email= \'\',acc_name= \'\',acc_email= \'\',acc_phone= \'\',man_name= \'\',man_email= \'\',man_phone= \'\',res_name= \'\',res_email= \'\',res_phone= \'\',remarks= \'\',apply_service_tax= \'no\',allow_ticketing= 0,can_show_hotels= 0 WHERE id= \'86\'',`log_description`= 'Agent 86 updated For - modify_date=2026-08-19+09%3A06%3A47&can_book=1&accounts_processed=1&allow_quotation= changed to - modify_date=2026-08-20+05%3A24%3A49&can_book=&accounts_processed=0&allow_quotation=1',`ip`= '103.104.226.130'; [08/20/2026 05:24:49], [Script File: agent.php, File: UserLog.php, Function: user_log_link, Line: 174],insert into user_log_link Set `user_logs_id`='449173', `entity`='Agents', `value`='86' ; [08/20/2026 05:24:49], [Script File: agent.php, File: Agent.php, Function: update, Line: 4808],UPDATE agents SET cd_credit_limit=credit_limit-'86' , cd_credit_value=cd_credit_limit-cd_credit_usage WHERE id= ?; [08/20/2026 05:24:49], [Script File: agent.php, File: Agent.php, Function: agent_credit_log, Line: 5876],insert into agent_credit_log SET agent_id= '86',credit_value= '49204.265',credit_usage= '150795.735',credit_limit= '200000',receipt_id= '',amount= '', ip = '103.104.226.130', user_type = 'admin', admin_id = 'sujay_qtech', temp_credit_limit = '0', log_type = 'Edit_Agent', note = 'Agent Edited by sujay_qtech', ledger_balance = '301783.97', create_date = '2026-08-20 05:24:49'; [08/20/2026 05:24:49], [Script File: agent.php, File: Agent.php, Function: update, Line: 4883],UPDATE agents SET currency= '11',branch_id= '1',profile= '', agent_type= 'CC' WHERE parent_agent= '86'; [08/20/2026 05:24:49], [Script File: agent.php, File: Agent.php, Function: update, Line: 4904],delete from agent_supplier_debug where agent_id='86'; [08/20/2026 05:24:49], [Script File: agent.php, File: Agent.php, Function: update, Line: 4918],insert into agent_supplier_debug SET agent_id= '86',supplier= '298',supplier_type= 'Hotel',modify_date='2026-08-20 05:08:49',create_date='2026-08-20 05:08:49'; [08/20/2026 05:24:49], [Script File: agent.php, File: Agent.php, Function: update, Line: 4918],insert into agent_supplier_debug SET agent_id= '86',supplier= '309',supplier_type= 'Hotel',modify_date='2026-08-20 05:08:49',create_date='2026-08-20 05:08:49'; [08/20/2026 05:24:49], [Script File: agent.php, File: Agent.php, Function: update, Line: 4918],insert into agent_supplier_debug SET agent_id= '86',supplier= '301',supplier_type= 'Hotel',modify_date='2026-08-20 05:08:49',create_date='2026-08-20 05:08:49'; [08/20/2026 05:24:49], [Script File: agent.php, File: Agent.php, Function: update, Line: 4918],insert into agent_supplier_debug SET agent_id= '86',supplier= '302',supplier_type= 'Hotel',modify_date='2026-08-20 05:08:49',create_date='2026-08-20 05:08:49'; [08/20/2026 05:24:49], [Script File: agent.php, File: Agent.php, Function: update, Line: 4918],insert into agent_supplier_debug SET agent_id= '86',supplier= '310',supplier_type= 'Hotel',modify_date='2026-08-20 05:08:49',create_date='2026-08-20 05:08:49'; [08/20/2026 05:24:49], [Script File: agent.php, File: Agent.php, Function: update, Line: 4918],insert into agent_supplier_debug SET agent_id= '86',supplier= '311',supplier_type= 'Hotel',modify_date='2026-08-20 05:08:49',create_date='2026-08-20 05:08:49'; [08/20/2026 05:24:49], [Script File: agent.php, File: Agent.php, Function: update, Line: 4918],insert into agent_supplier_debug SET agent_id= '86',supplier= '307',supplier_type= 'Hotel',modify_date='2026-08-20 05:08:49',create_date='2026-08-20 05:08:49'; [08/20/2026 05:24:49], [Script File: agent.php, File: Agent.php, Function: update, Line: 4918],insert into agent_supplier_debug SET agent_id= '86',supplier= '308',supplier_type= 'Hotel',modify_date='2026-08-20 05:08:49',create_date='2026-08-20 05:08:49'; [08/20/2026 05:24:49], [Script File: agent.php, File: Agent.php, Function: update, Line: 4918],insert into agent_supplier_debug SET agent_id= '86',supplier= '20',supplier_type= 'Hotel',modify_date='2026-08-20 05:08:49',create_date='2026-08-20 05:08:49'; [08/20/2026 05:24:49], [Script File: agent.php, File: Agent.php, Function: update, Line: 4918],insert into agent_supplier_debug SET agent_id= '86',supplier= '306',supplier_type= 'Hotel',modify_date='2026-08-20 05:08:49',create_date='2026-08-20 05:08:49'; [08/20/2026 05:25:14], [Script File: agent.php, File: Agent.php, Function: assign_gateway, Line: 2339],delete from agent_gateway where agent_id=86; [08/20/2026 05:25:14], [Script File: agent.php, File: Agent.php, Function: assign_gateway, Line: 2347],insert into agent_gateway(agent_id,gateway_id, created_datetime, created_by, ip_addr) values ('86','10', '2026-08-20 05:25:14', 'admin#sujay_qtech#sujay_qtech', '103.104.226.130'); [08/20/2026 05:25:14], [Script File: agent.php, File: Agent.php, Function: assign_gateway, Line: 2368],UPDATE agent_gateway SET agent_payment_gateway_markup=null WHERE gateway_id= '10' and agent_id= '86'; [08/20/2026 05:25:20], [Script File: backend_login.php, File: class.phpSecurityAdm.php, Function: login_log, Line: 3161],INSERT INTO psa_login_log SET username = 'Snehal_Test', user_type = 'A', branch_id = '1', login_datetime = '2026-08-20 05:25:20', ip = '103.104.226.130', action = 'Login', reason = 'Accessed by PSAuser::sujay_qtech' , error_code = 'BACKEND_ACCESSED' ; [08/20/2026 05:25:30], [Script File: agent_login.php, File: class.phpSecurityAdm.php, Function: login_log, Line: 3161],INSERT INTO psa_login_log SET username = 'Snehal_Test', user_type = 'A', branch_id = '1', login_datetime = '2026-08-20 05:25:30', ip = '103.104.226.130', action = 'Login', reason = 'Accessed by PSAuser::sujay_qtech' , error_code = 'BACKEND_ACCESSED' ; [08/20/2026 05:26:22], [Script File: hotel_search_list.php, File: hotel_search_list.php, Function: search_hotels, Line: 428],UPDATE keyword_clicks SET total_clicks = '11037' WHERE keyword = 'dubai' and record_type ='City' and record_id='71649'; [08/20/2026 05:26:22], [Script File: hotel_search_list.php, File: site.func.php, Function: getAvailability_Pre, Line: 876],INSERT INTO agent_logs SET agent_id = '86' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '103.104.226.130' , country_code = '138' , city_code = '71649' , city = 'dubai' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'AED' , currency_code = 'AED' , service_name = '' , country_of_residence = '47' , service_type = 'hotel' , arrival_date = '2026/09/22' , departure_date = '2026/09/23' , nights = '1' , room_types = '[{\"numberofAdults\":\"2\",\"noOfChildren\":\"0\",\"childrenages\":\"0,0\"}]' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2026-08-20 05:26:22' , total_adult = '2', nationality='47', total_children = '0', business_tracking = 'B2B', platform_language = 'en', admin_debug = '1' , site_id = '' , web_service = '0' ; [08/20/2026 05:26:22], [Script File: hotel_search_list.php, File: RoomType.php, Function: insert_logs, Line: 91],INSERT INTO room_type_logs (agent_logs_id, room_types, create_date,site_id) VALUES ('53766', 'double', '2026-08-20 :05:26:22',''); [08/20/2026 05:26:41], [Script File: xml_all.php, File: Otramsf.php, Function: agent_logs_update, Line: 1069],UPDATE agent_logs SET memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '53766') + '22412288',duration = '15.191',merge_duration = '0.021',assigned_supplier_count = '10',searched_supplier_count = '1',system_load_1_min = '0.27',system_load_5_min = '0.36',system_load_15_min = '0.44',system_memory_usage = '57.97',parallel_search_count = '1',is_cached = 'no' WHERE id = '53766'_update; [08/20/2026 05:27:44], [Script File: book_now.php, File: Logs.php, Function: ws_logs_insert, Line: 76],INSERT INTO ws_logs (userid, action_type, agent_log_id, log_date_time, end_time, xml_log_id, type, go_request, go_response, go_response_code, request_path, response_path, search_unique_id, booking_id, error_description, error_code, response_time, hotel_id, server_addr, hotel_count) VALUES ('86', 'hotel_cancellation_policy', '', '', '2026-08-20 05:27:44', '1431662', 'website', 'go/20_08_2026/request_valuation_Snehal_Test_53766_05_27_44_1787203664.json', 'go/20_08_2026/response_valuation_Snehal_Test_53766_05_27_44_1787203664.json', 'go/20_08_2026/response_valuation_Snehal_Test_53766_05_27_44_1787203664.json'_code, '', '', '', '', '', '', '', 'OT000050226', '', ''); [08/20/2026 05:39:22], [Script File: agent_login.php, File: class.phpSecurityAdm.php, Function: login_log, Line: 3161],INSERT INTO psa_login_log SET username = 'Snehal_Test', user_type = 'A', branch_id = '1', login_datetime = '2026-08-20 05:39:22', ip = '103.104.226.130', action = 'Login', reason = 'Accessed by PSAuser::sujay_qtech' , error_code = 'BACKEND_ACCESSED' ; [08/20/2026 05:40:49], [Script File: hotel_search_list.php, File: hotel_search_list.php, Function: search_hotels, Line: 428],UPDATE keyword_clicks SET total_clicks = '11038' WHERE keyword = 'dubai' and record_type ='City' and record_id='71649'; [08/20/2026 05:40:49], [Script File: hotel_search_list.php, File: site.func.php, Function: getAvailability_Pre, Line: 876],INSERT INTO agent_logs SET agent_id = '86' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '103.104.226.130' , country_code = '138' , city_code = '71649' , city = 'dubai' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'AED' , currency_code = 'AED' , service_name = '' , country_of_residence = '47' , service_type = 'hotel' , arrival_date = '2026/09/22' , departure_date = '2026/09/23' , nights = '1' , room_types = '[{\"numberofAdults\":\"2\",\"noOfChildren\":\"0\",\"childrenages\":\"0,0\"}]' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2026-08-20 05:40:49' , total_adult = '2', nationality='47', total_children = '0', business_tracking = 'B2B', platform_language = 'en', admin_debug = '1' , site_id = '' , web_service = '0' ; [08/20/2026 05:40:50], [Script File: hotel_search_list.php, File: RoomType.php, Function: insert_logs, Line: 91],INSERT INTO room_type_logs (agent_logs_id, room_types, create_date,site_id) VALUES ('53767', 'double', '2026-08-20 :05:40:50',''); [08/20/2026 05:41:03], [Script File: xml_all.php, File: Otramsf.php, Function: agent_logs_update, Line: 1069],UPDATE agent_logs SET memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '53767') + '22412352',duration = '10.155',merge_duration = '0.007',assigned_supplier_count = '10',searched_supplier_count = '1',system_load_1_min = '1.04',system_load_5_min = '0.64',system_load_15_min = '0.55',system_memory_usage = '57.54',parallel_search_count = '1',is_cached = 'no' WHERE id = '53767'_update; [08/20/2026 05:41:51], [Script File: book_now.php, File: Logs.php, Function: ws_logs_insert, Line: 76],INSERT INTO ws_logs (userid, action_type, agent_log_id, log_date_time, end_time, xml_log_id, type, go_request, go_response, go_response_code, request_path, response_path, search_unique_id, booking_id, error_description, error_code, response_time, hotel_id, server_addr, hotel_count) VALUES ('86', 'hotel_cancellation_policy', '', '', '2026-08-20 05:41:51', '1431728', 'website', 'go/20_08_2026/request_valuation_Snehal_Test_53767_05_41_51_1787204511.json', 'go/20_08_2026/response_valuation_Snehal_Test_53767_05_41_51_1787204511.json', 'go/20_08_2026/response_valuation_Snehal_Test_53767_05_41_51_1787204511.json'_code, '', '', '', '', '', '', '', 'OT000050226', '', ''); [08/20/2026 05:42:05], [Script File: agent_login.php, File: class.phpSecurityAdm.php, Function: login_log, Line: 3161],INSERT INTO psa_login_log SET username = 'Snehal_Test', user_type = 'A', branch_id = '1', login_datetime = '2026-08-20 05:42:05', ip = '103.104.226.130', action = 'Login', reason = 'Accessed by PSAuser::sujay_qtech' , error_code = 'BACKEND_ACCESSED' ; [08/20/2026 05:42:21], [Script File: agent_login.php, File: class.phpSecurityAdm.php, Function: login_log, Line: 3161],INSERT INTO psa_login_log SET username = 'Snehal_Test', user_type = 'A', branch_id = '1', login_datetime = '2026-08-20 05:42:21', ip = '103.104.226.130', action = 'Login', reason = 'Accessed by PSAuser::sujay_qtech' , error_code = 'BACKEND_ACCESSED' ; [08/20/2026 05:42:38], [Script File: agent_login.php, File: class.phpSecurityAdm.php, Function: login_log, Line: 3161],INSERT INTO psa_login_log SET username = 'Snehal_Test', user_type = 'A', branch_id = '1', login_datetime = '2026-08-20 05:42:38', ip = '103.104.226.130', action = 'Login', reason = 'Accessed by PSAuser::sujay_qtech' , error_code = 'BACKEND_ACCESSED' ; [08/20/2026 05:45:00], [Script File: agent_login.php, File: class.phpSecurityAdm.php, Function: login_log, Line: 3161],INSERT INTO psa_login_log SET username = 'Snehal_Test', user_type = 'A', branch_id = '1', login_datetime = '2026-08-20 05:45:00', ip = '103.104.226.130', action = 'Login', reason = 'Accessed by PSAuser::sujay_qtech' , error_code = 'BACKEND_ACCESSED' ; [08/20/2026 05:59:46], [Script File: agent_login.php, File: class.phpSecurityAdm.php, Function: login_log, Line: 3161],INSERT INTO psa_login_log SET username = 'Snehal_Test', user_type = 'A', branch_id = '1', login_datetime = '2026-08-20 05:59:46', ip = '103.104.226.130', action = 'Login', reason = 'Accessed by PSAuser::sujay_qtech' , error_code = 'BACKEND_ACCESSED' ;