[08/24/2026 07:00:50], [Script File: agent.php, File: Agent.php, Function: update_agent_countries, Line: 1906],UPDATE agent_allowed_countries set allowed_countries="United Arab Emirates" WHERE agent_id= '699' limit 1; [08/24/2026 07:00:50], [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-24 07:00:50',`log_type`= 'SUBAgent Updated Allow Countries for Booking',`sql_query`= 'UPDATE agent_allowed_countries set allowed_countries=\"United Arab Emirates\" WHERE agent_id= \'699\' limit 1',`log_description`= 'Sub Agent 699 updated For - allowed_countries=United+Arab+Emirates%2CIndia changed to - allowed_countries=United+Arab+Emirates',`ip`= '103.104.226.130'; [08/24/2026 07:00:50], [Script File: agent.php, File: UserLog.php, Function: user_log_link, Line: 174],insert into user_log_link Set `user_logs_id`='449227', `entity`='Agents', `value`='699' ; [08/24/2026 07:01:07], [Script File: logout.php, File: class.phpSecurityAdm.php, Function: logout_log, Line: 3220],INSERT INTO psa_login_log set username = 'rutuja' , user_type = 'rutuja'_type , branch_id = '23' , login_datetime = '2026-08-24 07:01:07' , ip = '103.104.226.130' , action = 'Logout' , reason = '' , error_code = 'BACKEND_ACCESSED' ; [08/24/2026 07:01:32], [Script File: agent_login.php, File: class.phpSecurityAdm.php, Function: login_log, Line: 3161],INSERT INTO psa_login_log SET username = 'rutuja', user_type = 'A', branch_id = '23', login_datetime = '2026-08-24 07:01:32', ip = '103.104.226.130', action = 'Login', reason = 'Accessed by PSAuser::sujay_qtech' , error_code = 'BACKEND_ACCESSED' ; [08/24/2026 07:01:46], [Script File: hotel_search_list.php, File: site.func.php, Function: getAvailability_Pre, Line: 876],INSERT INTO agent_logs SET agent_id = '699' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '23' , ip = '103.104.226.130' , country_code = '138' , city_code = '71649' , city = 'dubai' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2026/10/14' , departure_date = '2026/10/15' , nights = '1' , room_types = '[{\"numberofAdults\":\"2\",\"noOfChildren\":\"0\",\"childrenages\":\"0,0\"}]' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2026-08-24 07:01:46' , total_adult = '2', nationality='106', total_children = '0', business_tracking = 'B2B', platform_language = 'en', admin_debug = '1' , site_id = '' , web_service = '0' ; [08/24/2026 07:01:46], [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 ('53848', 'double', '2026-08-24 :07:01:46',''); [08/24/2026 07:01:53], [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 = '53848') + '22412576',duration = '7.118',merge_duration = '0.006',assigned_supplier_count = '10',searched_supplier_count = '1',system_load_1_min = '1.48',system_load_5_min = '0.90',system_load_15_min = '0.55',system_memory_usage = '53.22',parallel_search_count = '1',is_cached = 'no' WHERE id = '53848'_update; [08/24/2026 07:02:03], [Script File: agent.php, File: Agent.php, Function: assign_gateway, Line: 2339],delete from agent_gateway where agent_id=699; [08/24/2026 07:02:03], [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 ('699','10', '2026-08-24 07:02:03', 'admin#sujay_qtech#sujay_qtech', '103.104.226.130'); [08/24/2026 07:02:03], [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= '699'; [08/24/2026 07:02:09], [Script File: backend_login.php, File: class.phpSecurityAdm.php, Function: login_log, Line: 3161],INSERT INTO psa_login_log SET username = 'rutuja', user_type = 'A', branch_id = '23', login_datetime = '2026-08-24 07:02:09', ip = '103.104.226.130', action = 'Login', reason = 'Accessed by PSAuser::sujay_qtech' , error_code = 'BACKEND_ACCESSED' ; [08/24/2026 07:02:14], [Script File: frontendfunc.php, File: HotelLogs.php, Function: insert, Line: 191],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service) VALUES ('Unique Hostel Dubai', '', '', '699', '', '23', '', 'hoteldetails', '2026-08-24 :07:02:14',''); [08/24/2026 07:03:14], [Script File: agent_login.php, File: class.phpSecurityAdm.php, Function: login_log, Line: 3161],INSERT INTO psa_login_log SET username = 'rutuja', user_type = 'A', branch_id = '23', login_datetime = '2026-08-24 07:03:14', ip = '103.104.226.130', action = 'Login', reason = 'Accessed by PSAuser::sujay_qtech' , error_code = 'BACKEND_ACCESSED' ; [08/24/2026 07:03:23], [Script File: hotel_search_list.php, File: site.func.php, Function: getAvailability_Pre, Line: 876],INSERT INTO agent_logs SET agent_id = '699' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '23' , ip = '103.104.226.130' , country_code = '138' , city_code = '71649' , city = 'dubai' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2026/10/14' , departure_date = '2026/10/15' , nights = '1' , room_types = '[{\"numberofAdults\":\"2\",\"noOfChildren\":\"0\",\"childrenages\":\"0,0\"}]' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2026-08-24 07:03:23' , total_adult = '2', nationality='106', total_children = '0', business_tracking = 'B2B', platform_language = 'en', admin_debug = '1' , site_id = '' , web_service = '0' ; [08/24/2026 07:03:23], [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 ('53849', 'double', '2026-08-24 :07:03:23',''); [08/24/2026 07:03:30], [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 = '53849') + '22412640',duration = '6.094',merge_duration = '0.005',assigned_supplier_count = '10',searched_supplier_count = '1',system_load_1_min = '0.51',system_load_5_min = '0.75',system_load_15_min = '0.53',system_memory_usage = '53.76',parallel_search_count = '1',is_cached = 'no' WHERE id = '53849'_update; [08/24/2026 07:03:48], [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 ('699', 'hotel_cancellation_policy', '', '', '2026-08-24 07:03:48', '1433303', 'website', 'go/24_08_2026/request_valuation_rutuja_53849_07_03_48_1787555028.json', 'go/24_08_2026/response_valuation_rutuja_53849_07_03_48_1787555028.json', 'go/24_08_2026/response_valuation_rutuja_53849_07_03_48_1787555028.json'_code, '', '', '', '', '', '', '', '', '', ''); [08/24/2026 07:04:15], [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 ('699', 'hotel_cancellation_policy', '', '', '2026-08-24 07:04:15', '1433305', 'website', 'go/24_08_2026/request_valuation_rutuja_53849_07_04_15_1787555055.json', 'go/24_08_2026/response_valuation_rutuja_53849_07_04_15_1787555055.json', 'go/24_08_2026/response_valuation_rutuja_53849_07_04_15_1787555055.json'_code, '', '', '', '', '', '', '', '', '', ''); [08/24/2026 07:09:59], [Script File: agent.php, File: Agent.php, Function: update_agent_countries, Line: 1906],UPDATE agent_allowed_countries set allowed_countries="United Arab Emirates" WHERE agent_id= '86' limit 1; [08/24/2026 07:09:59], [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-24 07:09:59',`log_type`= 'SUBAgent Updated Allow Countries for Booking',`sql_query`= 'UPDATE agent_allowed_countries set allowed_countries=\"United Arab Emirates\" WHERE agent_id= \'86\' limit 1',`log_description`= 'Sub Agent 86 updated For - allowed_countries=United+Arab+Emirates%2CIndia changed to - allowed_countries=United+Arab+Emirates',`ip`= '103.104.226.130'; [08/24/2026 07:09:59], [Script File: agent.php, File: UserLog.php, Function: user_log_link, Line: 174],insert into user_log_link Set `user_logs_id`='449228', `entity`='Agents', `value`='86' ; [08/24/2026 07:10:12], [Script File: agent.php, File: Agent.php, Function: set_priority, Line: 2026],DELETE FROM agent_supplier_settings WHERE 1 and agent_id= ? ; [08/24/2026 07:10:12], [Script File: agent.php, File: Agent.php, Function: set_priority, Line: 2060],INSERT INTO agent_supplier_settings SET agent_id = '86',supplier_id = '309' ,status = '' ,priority = '24' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '24'; [08/24/2026 07:10:12], [Script File: agent.php, File: Agent.php, Function: set_priority, Line: 2060],INSERT INTO agent_supplier_settings SET agent_id = '86',supplier_id = '301' ,status = '' ,priority = '24' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '24'; [08/24/2026 07:10:12], [Script File: agent.php, File: Agent.php, Function: set_priority, Line: 2060],INSERT INTO agent_supplier_settings SET agent_id = '86',supplier_id = '302' ,status = '' ,priority = '24' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '24'; [08/24/2026 07:10:12], [Script File: agent.php, File: Agent.php, Function: set_priority, Line: 2060],INSERT INTO agent_supplier_settings SET agent_id = '86',supplier_id = '310' ,status = '' ,priority = '24' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '24'; [08/24/2026 07:10:12], [Script File: agent.php, File: Agent.php, Function: set_priority, Line: 2060],INSERT INTO agent_supplier_settings SET agent_id = '86',supplier_id = '311' ,status = '' ,priority = '24' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '24'; [08/24/2026 07:10:12], [Script File: agent.php, File: Agent.php, Function: set_priority, Line: 2060],INSERT INTO agent_supplier_settings SET agent_id = '86',supplier_id = '307' ,status = '' ,priority = '24' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '24'; [08/24/2026 07:10:12], [Script File: agent.php, File: Agent.php, Function: set_priority, Line: 2060],INSERT INTO agent_supplier_settings SET agent_id = '86',supplier_id = '308' ,status = '' ,priority = '24' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '24'; [08/24/2026 07:10:12], [Script File: agent.php, File: Agent.php, Function: set_priority, Line: 2060],INSERT INTO agent_supplier_settings SET agent_id = '86',supplier_id = '20' ,status = '1' ,priority = '24' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '24'; [08/24/2026 07:10:12], [Script File: agent.php, File: Agent.php, Function: set_priority, Line: 2060],INSERT INTO agent_supplier_settings SET agent_id = '86',supplier_id = '298' ,status = '' ,priority = '24' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '24'; [08/24/2026 07:10:12], [Script File: agent.php, File: Agent.php, Function: set_priority, Line: 2060],INSERT INTO agent_supplier_settings SET agent_id = '86',supplier_id = '299' ,status = '' ,priority = '24' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '24'; [08/24/2026 07:10:12], [Script File: agent.php, File: Agent.php, Function: set_priority, Line: 2060],INSERT INTO agent_supplier_settings SET agent_id = '86',supplier_id = '306' ,status = '' ,priority = '24' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '24'; [08/24/2026 07:10:12], [Script File: agent.php, File: Agent.php, Function: set_priority, Line: 2060],INSERT INTO agent_supplier_settings SET agent_id = '86',supplier_id = '92' ,status = '' ,priority = '24' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '24'; [08/24/2026 07:10:12], [Script File: agent.php, File: Agent.php, Function: set_priority, Line: 2060],INSERT INTO agent_supplier_settings SET agent_id = '86',supplier_id = '304' ,status = '' ,priority = '24' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '24'; [08/24/2026 07:10:12], [Script File: agent.php, File: Agent.php, Function: set_priority, Line: 2060],INSERT INTO agent_supplier_settings SET agent_id = '86',supplier_id = '303' ,status = '' ,priority = '24' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '24'; [08/24/2026 07:10:12], [Script File: agent.php, File: Agent.php, Function: set_priority, Line: 2060],INSERT INTO agent_supplier_settings SET agent_id = '86',supplier_id = '300' ,status = '' ,priority = '24' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '24'; [08/24/2026 07:10:12], [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-24 07:10:12',`log_type`= 'Agent Supplier settings',`sql_query`= '======INSERT INTO agent_supplier_settings SET agent_id = \'86\',supplier_id = 309 ,status = \'\' ,priority = \'24\' ,lead_time = \'96\',branch_id = \'\',visible_supplier_on_voucher = \'0\',pricing_profile_id = \'24\'======INSERT INTO agent_supplier_settings SET agent_id = \'86\',supplier_id = 301 ,status = \'\' ,priority = \'24\' ,lead_time = \'96\',branch_id = \'\',visible_supplier_on_voucher = \'0\',pricing_profile_id = \'24\'======INSERT INTO agent_supplier_settings SET agent_id = \'86\',supplier_id = 302 ,status = \'\' ,priority = \'24\' ,lead_time = \'96\',branch_id = \'\',visible_supplier_on_voucher = \'0\',pricing_profile_id = \'24\'======INSERT INTO agent_supplier_settings SET agent_id = \'86\',supplier_id = 310 ,status = \'\' ,priority = \'24\' ,lead_time = \'96\',branch_id = \'\',visible_supplier_on_voucher = \'0\',pricing_profile_id = \'24\'======INSERT INTO agent_supplier_settings SET agent_id = \'86\',supplier_id = 311 ,status = \'\' ,priority = \'24\' ,lead_time = \'0\',branch_id = \'\',visible_supplier_on_voucher = \'0\',pricing_profile_id = \'24\'======INSERT INTO agent_supplier_settings SET agent_id = \'86\',supplier_id = 307 ,status = \'\' ,priority = \'24\' ,lead_time = \'96\',branch_id = \'\',visible_supplier_on_voucher = \'0\',pricing_profile_id = \'24\'======INSERT INTO agent_supplier_settings SET agent_id = \'86\',supplier_id = 308 ,status = \'\' ,priority = \'24\' ,lead_time = \'96\',branch_id = \'\',visible_supplier_on_voucher = \'0\',pricing_profile_id = \'24\'======INSERT INTO agent_supplier_settings SET agent_id = \'86\',supplier_id = 20 ,status = \'1\' ,priority = \'24\' ,lead_time = \'96\',branch_id = \'\',visible_supplier_on_voucher = \'0\',pricing_profile_id = \'24\'======INSERT INTO agent_supplier_settings SET agent_id = \'86\',supplier_id = 298 ,status = \'\' ,priority = \'24\' ,lead_time = \'96\',branch_id = \'\',visible_supplier_on_voucher = \'0\',pricing_profile_id = \'24\'======INSERT INTO agent_supplier_settings SET agent_id = \'86\',supplier_id = 299 ,status = \'\' ,priority = \'24\' ,lead_time = \'96\',branch_id = \'\',visible_supplier_on_voucher = \'0\',pricing_profile_id = \'24\'======INSERT INTO agent_supplier_settings SET agent_id = \'86\',supplier_id = 306 ,status = \'\' ,priority = \'24\' ,lead_time = \'96\',branch_id = \'\',visible_supplier_on_voucher = \'0\',pricing_profile_id = \'24\'======INSERT INTO agent_supplier_settings SET agent_id = \'86\',supplier_id = 92 ,status = \'\' ,priority = \'24\' ,lead_time = \'96\',branch_id = \'\',visible_supplier_on_voucher = \'0\',pricing_profile_id = \'24\'======INSERT INTO agent_supplier_settings SET agent_id = \'86\',supplier_id = 304 ,status = \'\' ,priority = \'24\' ,lead_time = \'96\',branch_id = \'\',visible_supplier_on_voucher = \'0\',pricing_profile_id = \'24\'======INSERT INTO agent_supplier_settings SET agent_id = \'86\',supplier_id = 303 ,status = \'\' ,priority = \'24\' ,lead_time = \'96\',branch_id = \'\',visible_supplier_on_voucher = \'0\',pricing_profile_id = \'24\'======INSERT INTO agent_supplier_settings SET agent_id = \'86\',supplier_id = 300 ,status = \'\' ,priority = \'24\' ,lead_time = \'96\',branch_id = \'\',visible_supplier_on_voucher = \'0\',pricing_profile_id = \'24\'',`log_description`= 'Supplier setting updated Previous data-- agent_id-86 ## supplier_id- 20 ## company_name - Hotelbeds ## supplier_code-hotelbeds ## percentage - 0.00 ## lead_time - 96 ',`ip`= '103.104.226.130'; [08/24/2026 07:10:12], [Script File: agent.php, File: UserLog.php, Function: user_log_link, Line: 174],insert into user_log_link Set `user_logs_id`='449229', `entity`='Agents', `value`='86' ; [08/24/2026 07:10: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-24 07:10:20', ip = '103.104.226.130', action = 'Login', reason = 'Accessed by PSAuser::sujay_qtech' , error_code = 'BACKEND_ACCESSED' ; [08/24/2026 07:10:32], [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-24 07:10:32', ip = '103.104.226.130', action = 'Login', reason = 'Accessed by PSAuser::sujay_qtech' , error_code = 'BACKEND_ACCESSED' ; [08/24/2026 07:10:35], [Script File: service_search.php, File: common.func.php, Function: check_ip2location_valid_country, Line: 8439],INSERT INTO agent_allowed_countries_log (agent_id,session_info,country,create_date,request_url,ip_address) VALUES ('86','a:65:{s:15:"uniqueSearchRef";s:28:"2026082407103200000056747658";s:18:"csrf_session_token";N;s:17:"additional_markup";s:0:"";s:15:"consultant_data";a:5:{s:5:"fname";s:7:"SRIJITH";s:5:"lname";s:12:"GOPALAPILLAI";s:5:"email";s:21:"arc@lamarholidays.com";s:5:"phone";s:13:"971-547031357";s:16:"consultant_image";s:0:"";}s:31:"backoffice_agent_login_with_otp";i:0;s:3:"tms";i:1;s:10:"error_code";s:16:"BACKEND_ACCESSED";s:15:"backoffice_user";s:11:"sujay_qtech";s:12:"login_reason";s:32:"Accessed by PSAuser::sujay_qtech";s:26:"agentLastLoggedInIpaddress";a:1:{i:0;s:15:"103.104.226.130";}s:14:"user_remote_ip";s:15:"103.104.226.130";s:10:"user_agent";s:101:"Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36";s:8:"is_admin";i:0;s:11:"allow_debug";i:1;s:26:"can_check_foreign_currency";i:0;s:23:"search_by_multicurrency";s:1:"1";s:15:"allow_sub_agent";N;s:14:"allow_sub_user";N;s:29:"allow_book_under_cancellation";s:1:"1";s:11:"can_voucher";s:1:"1";s:12:"parent_agent";s:1:"0";s:17:"apply_service_tax";s:2:"no";s:15:"allow_quotation";s:1:"1";s:10:"admin_user";s:0:"";s:9:"can_debug";i:1;s:17:"ALLOW_ADMIN_DEBUG";i:1;s:11:"mailtoagent";N;s:14:"mailtosupplier";N;s:16:"mailtoconsultant";N;s:11:"mailtoadmin";N;s:12:"mailtocommon";N;s:8:"usertype";s:2:"CC";s:8:"can_book";s:1:"1";s:9:"sort_type";s:5:"price";s:9:"branch_id";s:1:"1";s:8:"loggedin";s:16:"24-08-2026 07:10";s:12:"agent_markup";N;s:16:"sub_agent_markup";N;s:8:"username";s:11:"Snehal_Test";s:6:"userid";s:2:"86";s:8:"currency";s:2:"11";s:13:"currency_code";s:3:"AED";s:13:"agent_country";s:2:"47";s:18:"agent_country_name";s:10:"Azerbaijan";s:15:"agent_city_name";s:4:"Baku";s:11:"sub_user_id";s:0:"";s:10:"agent_type";s:2:"CC";s:4:"logo";s:0:"";s:21:"user_time_zone_offset";s:3:"5.5";s:10:"db_caching";s:1:"1";s:10:"ChildArray";s:0:"";s:10:"flag_image";s:0:"";s:6:"allow_";s:3:"5.5";s:26:"allow_login_otp_validation";i:2;s:10:"lead_times";a:1:{s:9:"hotelbeds";s:2:"96";}s:27:"cancellation_markup_amounts";s:0:"";s:13:"tax_commision";s:1:"1";s:16:"backoffice_login";s:11:"sujay_qtech";s:7:"referer";s:48:"https://uat.lamarholidays.com/service_search.php";s:9:"csp_nonce";s:32:"cf7fed64f8661f6193cfc87a2081b03d";s:12:"browser_info";s:29:"GoogleChrome/127.0.0.0(linux)";s:8:"language";s:7:"english";s:3:"b2c";i:0;s:13:"agent_details";a:221:{s:2:"id";s:2:"86";s:8:"admin_id";s:5:"Qtech";s:11:"agency_name";s:5:"Qtech";s:15:"accounting_name";s:0:"";s:10:"first_name";s:6:"Snehal";s:11:"middle_name";s:0:"";s:9:"last_name";s:7:"Valanju";s:10:"agent_type";s:2:"CC";s:9:"sort_type";s:5:"price";s:12:"credit_limit";s:6:"200000";s:21:"credit_limit_assigned";s:6:"200000";s:12:"credit_value";s:9:"49204.265";s:12:"credit_usage";s:10:"150795.735";s:17:"outstanding_limit";s:5:"0.000";s:17:"temp_credit_limit";s:1:"0";s:15:"cd_credit_limit";s:10:"200000.000";s:15:"cd_credit_usage";s:10:"150795.735";s:15:"cd_credit_value";s:9:"49204.265";s:19:"credit_distribution";s:1:"1";s:15:"opening_balance";s:1:"0";s:9:"lead_time";s:1:"0";s:7:"address";s:13:"Mumbai, India";s:4:"city";s:5:"49095";s:7:"pincode";s:5:"40000";s:16:"focus_agent_code";N;s:7:"country";s:2:"47";s:16:"time_zone_offset";s:3:"5.5";s:10:"enable_dst";s:1:"0";s:5:"phone";s:13:"91-7208049129";s:6:"mobile";s:13:"91-7891919191";s:3:"fax";s:0:"";s:5:"email";s:35:"vishwanath.dhotre@qtechsoftware.com";s:8:"username";s:11:"Snehal_Test";s:8:"password";s:64:"3bb494becbab6af7d296500f7d514764f6c38a390acadfdffa071e08b37e123a";s:4:"hash";N;s:11:"designation";s:0:"";s:11:"iata_status";s:1:"0";s:11:"iata_number";s:0:"";s:18:"nature_of_business";s:0:"";s:4:"logo";s:0:"";s:8:"currency";s:2:"11";s:6:"status";s:1:"A";s:11:"create_date";s:19:"2022-03-21 15:37:54";s:11:"modify_date";s:19:"2026-08-20 11:50:27";s:12:"parent_agent";s:1:"0";s:5:"debug";s:1:"1";s:8:"can_book";s:1:"1";s:20:"can_allocate_receipt";s:1:"1";s:11:"can_voucher";s:1:"1";s:6:"markup";N;s:13:"hidden_markup";N;s:9:"branch_id";s:1:"1";s:13:"consultant_id";s:7:"Srijith";s:16:"sales_manager_id";s:0:"";s:13:"is_super_user";s:1:"1";s:10:"block_mail";s:1:"0";s:29:"allow_book_under_cancellation";s:1:"1";s:10:"updateflag";N;s:10:"created_by";N;s:7:"website";s:0:"";s:4:"ukey";N;s:7:"profile";s:0:"";s:13:"account_email";N;s:8:"send_sms";N;s:8:"acc_name";s:0:"";s:9:"acc_email";s:0:"";s:9:"acc_phone";s:0:"";s:8:"man_name";s:0:"";s:9:"man_email";s:0:"";s:9:"man_phone";s:0:"";s:8:"res_name";s:0:"";s:9:"res_email";s:0:"";s:9:"res_phone";s:0:"";s:12:"agency_email";s:0:"";s:12:"payment_type";N;s:7:"remarks";s:0:"";s:18:"accounts_processed";s:1:"0";s:7:"site_id";s:1:"0";s:8:"wh_agent";s:2:"no";s:13:"wh_main_agent";N;s:15:"last_login_date";s:19:"2026-08-24 07:10:32";s:17:"apply_service_tax";s:2:"no";s:15:"allow_quotation";s:1:"1";s:13:"credit_option";s:15:"on_voucher_date";s:10:"no_of_days";s:1:"0";s:14:"ledger_balance";s:9:"301783.97";s:7:"ip_addr";s:14:"103.26.226.116";s:7:"referer";s:52:"https://b2b.lamarholidays.com/agent_registration.php";s:11:"comp_reg_no";s:0:"";s:10:"db_caching";s:1:"1";s:23:"search_by_multicurrency";s:1:"1";s:11:"web_service";s:0:"";s:19:"web_service_pacakge";s:1:"0";s:17:"web_service_tours";s:1:"0";s:14:"web_service_ip";N;s:13:"accounting_id";s:6:"CD0086";s:12:"executive_id";N;s:16:"business_unit_id";N;s:17:"additional_markup";s:0:"";s:12:"cal_hashcode";s:64:"5e1864f11c6a99583ffdc75462dc10db52484f9c89760cbbbfd152e4ec518af2";s:13:"calender_feed";s:1:"0";s:13:"calendar_date";N;s:15:"loyalty_tier_id";N;s:16:"loyalty_email_id";N;s:16:"loyalty_password";N;s:10:"acc_export";s:1:"0";s:10:"acc_posted";s:1:"0";s:11:"status_flag";s:1:"A";s:18:"amadeus_agent_sign";N;s:22:"amadeus_user_duty_code";N;s:20:"contracted_list_icon";N;s:11:"expiry_date";s:10:"2026-04-08";s:15:"allow_ticketing";s:0:"";s:12:"allow_survey";s:1:"0";s:12:"branch_agent";s:1:"N";s:21:"invoice_generate_time";N;s:18:"excluded_countries";N;s:23:"country_currency_search";s:1:"0";s:12:"messanger_id";N;s:16:"allow_credit_use";s:1:"0";s:25:"exchange_currency_display";s:1:"0";s:29:"agency_name_in_other_language";N;s:25:"address_in_other_language";N;s:26:"other_language_agency_name";s:0:"";s:22:"other_language_address";s:0:"";s:16:"Foreign_currency";N;s:30:"web_service_only_mapped_hotels";s:1:"1";s:6:"tts_id";s:1:"0";s:21:"auto_voucher_bookings";s:1:"0";s:10:"txt_tax_no";N;s:26:"allow_frontend_rate_change";s:1:"0";s:16:"ws_supplier_rate";s:1:"0";s:16:"ws_supplier_name";s:1:"0";s:16:"ws_customer_type";s:8:"external";s:14:"allow_encoding";s:1:"0";s:13:"allow_iprange";s:1:"0";s:22:"floating_deposits_type";s:1:"0";s:10:"ws_caching";s:1:"0";s:9:"ws_liquid";s:1:"0";s:14:"agent_category";N;s:15:"can_show_hotels";s:0:"";s:17:"can_show_location";s:1:"1";s:12:"rate_profile";s:1:"0";s:6:"pan_no";s:0:"";s:6:"gst_no";s:0:"";s:6:"vat_no";s:0:"";s:12:"is_corporate";s:1:"0";s:8:"login_ip";s:15:"103.104.226.130";s:10:"login_time";N;s:13:"login_attempt";s:1:"0";s:16:"personal_booking";s:1:"0";s:20:"inside_travel_policy";s:1:"0";s:16:"secondary_emails";N;s:19:"secondary_acc_email";N;s:19:"secondary_man_email";N;s:19:"secondary_res_email";N;s:16:"currency_profile";s:1:"0";s:13:"tax_commision";s:1:"1";s:9:"tax_id_no";N;s:17:"multiple_currency";N;s:11:"ws_password";N;s:15:"staff_reference";N;s:13:"displaymarkup";s:1:"1";s:5:"level";N;s:6:"branch";N;s:11:"nationality";N;s:10:"department";N;s:11:"cost_center";N;s:15:"travel_arranger";N;s:10:"preference";N;s:11:"passport_no";N;s:14:"passport_issue";N;s:15:"passport_expiry";N;s:21:"driver_licence_number";N;s:20:"driver_licence_issue";N;s:21:"driver_licence_expiry";N;s:9:"telephone";N;s:9:"extension";N;s:17:"emergency_contact";N;s:13:"travel_policy";N;s:4:"role";N;s:8:"approver";N;s:11:"credit_days";N;s:13:"credit_remark";N;s:23:"temp_credit_expiry_date";N;s:5:"state";N;s:6:"sso_id";N;s:19:"room_mapping_access";s:1:"0";s:3:"pcc";N;s:14:"static_data_ip";N;s:13:"profile_image";s:0:"";s:33:"ws_reservation_with_supplier_name";s:1:"0";s:11:"auth_secret";N;s:9:"save_logs";s:3:"yes";s:23:"allow_search_can_policy";s:1:"0";s:15:"accounting_flag";s:1:"0";s:15:"allow_login_otp";s:1:"2";s:21:"allow_frontend_access";s:1:"1";s:18:"allow_whatsapp_otp";s:1:"0";s:19:"secondary_otp_email";s:0:"";s:12:"tcs_verified";s:1:"0";s:10:"tcs_req_id";N;s:12:"tcs_link_url";N;s:24:"enable_cheapest_supplier";s:1:"0";s:14:"auth_2fa_login";s:1:"0";s:19:"auth_2fa_on_booking";s:1:"0";s:21:"search_merging_method";s:3:"old";s:14:"allow_web_book";s:1:"0";s:20:"limited_hotel_search";s:1:"0";s:10:"auth_check";N;s:11:"secure_auth";s:1:"0";s:23:"new_cancellation_policy";s:1:"0";s:13:"fields_access";s:35:"Narration Text,Commission Narration";s:14:"search_rule_id";N;s:13:"request_limit";N;s:11:"otp_service";N;s:31:"backoffice_agent_login_with_otp";N;s:13:"allow_chatbot";s:1:"0";s:25:"apply_to_all_distributors";s:1:"0";s:13:"currency_code";s:3:"AED";s:10:"agent_code";s:6:"CD0086";}s:9:"key_agent";s:15:"ncFClBRslZQJTiy";}','India',now(),'uat.lamarholidays.com/service_search.php','103.104.226.130'); [08/24/2026 07:10:38], [Script File: logout.php, File: class.phpSecurityAdm.php, Function: logout_log, Line: 3220],INSERT INTO psa_login_log set username = 'Snehal_Test' , user_type = 'Snehal_Test'_type , branch_id = '1' , login_datetime = '2026-08-24 07:10:38' , ip = '103.104.226.130' , action = 'Logout' , reason = '' , error_code = 'BACKEND_ACCESSED' ; [08/24/2026 07:12:42], [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-24 07:12:42', ip = '103.104.226.130', action = 'Login', reason = 'Accessed by PSAuser::sujay_qtech' , error_code = 'BACKEND_ACCESSED' ; [08/24/2026 07:12:45], [Script File: service_search.php, File: common.func.php, Function: check_ip2location_valid_country, Line: 8439],INSERT INTO agent_allowed_countries_log (agent_id,session_info,country,create_date,request_url,ip_address) VALUES ('86','a:64:{s:15:"uniqueSearchRef";s:28:"2026082407124200000018371376";s:18:"csrf_session_token";N;s:17:"additional_markup";s:0:"";s:15:"consultant_data";a:5:{s:5:"fname";s:7:"SRIJITH";s:5:"lname";s:12:"GOPALAPILLAI";s:5:"email";s:21:"arc@lamarholidays.com";s:5:"phone";s:13:"971-547031357";s:16:"consultant_image";s:0:"";}s:31:"backoffice_agent_login_with_otp";i:0;s:3:"tms";i:1;s:10:"error_code";s:16:"BACKEND_ACCESSED";s:15:"backoffice_user";s:11:"sujay_qtech";s:12:"login_reason";s:32:"Accessed by PSAuser::sujay_qtech";s:26:"agentLastLoggedInIpaddress";a:1:{i:0;s:15:"103.104.226.130";}s:14:"user_remote_ip";s:15:"103.104.226.130";s:10:"user_agent";s:101:"Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36";s:8:"is_admin";i:0;s:26:"can_check_foreign_currency";i:0;s:23:"search_by_multicurrency";s:1:"1";s:15:"allow_sub_agent";N;s:14:"allow_sub_user";N;s:29:"allow_book_under_cancellation";s:1:"1";s:11:"can_voucher";s:1:"1";s:12:"parent_agent";s:1:"0";s:17:"apply_service_tax";s:2:"no";s:15:"allow_quotation";s:1:"1";s:10:"admin_user";s:11:"sujay_qtech";s:9:"can_debug";i:1;s:17:"ALLOW_ADMIN_DEBUG";i:1;s:11:"mailtoagent";s:1:"1";s:14:"mailtosupplier";s:1:"1";s:16:"mailtoconsultant";s:1:"1";s:11:"mailtoadmin";s:1:"1";s:12:"mailtocommon";s:1:"1";s:8:"usertype";s:2:"CC";s:8:"can_book";s:1:"1";s:9:"sort_type";s:5:"price";s:9:"branch_id";s:1:"1";s:8:"loggedin";s:16:"24-08-2026 07:12";s:12:"agent_markup";N;s:16:"sub_agent_markup";N;s:8:"username";s:11:"Snehal_Test";s:6:"userid";s:2:"86";s:8:"currency";s:2:"11";s:13:"currency_code";s:3:"AED";s:13:"agent_country";s:2:"47";s:18:"agent_country_name";s:10:"Azerbaijan";s:15:"agent_city_name";s:4:"Baku";s:11:"sub_user_id";s:0:"";s:10:"agent_type";s:2:"CC";s:4:"logo";s:0:"";s:21:"user_time_zone_offset";s:3:"5.5";s:10:"db_caching";s:1:"1";s:10:"ChildArray";s:0:"";s:10:"flag_image";s:0:"";s:6:"allow_";s:3:"5.5";s:26:"allow_login_otp_validation";i:2;s:10:"lead_times";a:1:{s:9:"hotelbeds";s:2:"96";}s:27:"cancellation_markup_amounts";s:0:"";s:13:"tax_commision";s:1:"1";s:16:"backoffice_login";s:11:"sujay_qtech";s:7:"referer";s:48:"https://uat.lamarholidays.com/service_search.php";s:9:"csp_nonce";s:32:"c3b881319ec51a2913201c146b4d17d6";s:12:"browser_info";s:29:"GoogleChrome/127.0.0.0(linux)";s:8:"language";s:7:"english";s:3:"b2c";i:0;s:13:"agent_details";a:221:{s:2:"id";s:2:"86";s:8:"admin_id";s:5:"Qtech";s:11:"agency_name";s:5:"Qtech";s:15:"accounting_name";s:0:"";s:10:"first_name";s:6:"Snehal";s:11:"middle_name";s:0:"";s:9:"last_name";s:7:"Valanju";s:10:"agent_type";s:2:"CC";s:9:"sort_type";s:5:"price";s:12:"credit_limit";s:6:"200000";s:21:"credit_limit_assigned";s:6:"200000";s:12:"credit_value";s:9:"49204.265";s:12:"credit_usage";s:10:"150795.735";s:17:"outstanding_limit";s:5:"0.000";s:17:"temp_credit_limit";s:1:"0";s:15:"cd_credit_limit";s:10:"200000.000";s:15:"cd_credit_usage";s:10:"150795.735";s:15:"cd_credit_value";s:9:"49204.265";s:19:"credit_distribution";s:1:"1";s:15:"opening_balance";s:1:"0";s:9:"lead_time";s:1:"0";s:7:"address";s:13:"Mumbai, India";s:4:"city";s:5:"49095";s:7:"pincode";s:5:"40000";s:16:"focus_agent_code";N;s:7:"country";s:2:"47";s:16:"time_zone_offset";s:3:"5.5";s:10:"enable_dst";s:1:"0";s:5:"phone";s:13:"91-7208049129";s:6:"mobile";s:13:"91-7891919191";s:3:"fax";s:0:"";s:5:"email";s:35:"vishwanath.dhotre@qtechsoftware.com";s:8:"username";s:11:"Snehal_Test";s:8:"password";s:64:"3bb494becbab6af7d296500f7d514764f6c38a390acadfdffa071e08b37e123a";s:4:"hash";N;s:11:"designation";s:0:"";s:11:"iata_status";s:1:"0";s:11:"iata_number";s:0:"";s:18:"nature_of_business";s:0:"";s:4:"logo";s:0:"";s:8:"currency";s:2:"11";s:6:"status";s:1:"A";s:11:"create_date";s:19:"2022-03-21 15:37:54";s:11:"modify_date";s:19:"2026-08-20 11:50:27";s:12:"parent_agent";s:1:"0";s:5:"debug";s:1:"1";s:8:"can_book";s:1:"1";s:20:"can_allocate_receipt";s:1:"1";s:11:"can_voucher";s:1:"1";s:6:"markup";N;s:13:"hidden_markup";N;s:9:"branch_id";s:1:"1";s:13:"consultant_id";s:7:"Srijith";s:16:"sales_manager_id";s:0:"";s:13:"is_super_user";s:1:"1";s:10:"block_mail";s:1:"0";s:29:"allow_book_under_cancellation";s:1:"1";s:10:"updateflag";N;s:10:"created_by";N;s:7:"website";s:0:"";s:4:"ukey";N;s:7:"profile";s:0:"";s:13:"account_email";N;s:8:"send_sms";N;s:8:"acc_name";s:0:"";s:9:"acc_email";s:0:"";s:9:"acc_phone";s:0:"";s:8:"man_name";s:0:"";s:9:"man_email";s:0:"";s:9:"man_phone";s:0:"";s:8:"res_name";s:0:"";s:9:"res_email";s:0:"";s:9:"res_phone";s:0:"";s:12:"agency_email";s:0:"";s:12:"payment_type";N;s:7:"remarks";s:0:"";s:18:"accounts_processed";s:1:"0";s:7:"site_id";s:1:"0";s:8:"wh_agent";s:2:"no";s:13:"wh_main_agent";N;s:15:"last_login_date";s:19:"2026-08-24 07:12:42";s:17:"apply_service_tax";s:2:"no";s:15:"allow_quotation";s:1:"1";s:13:"credit_option";s:15:"on_voucher_date";s:10:"no_of_days";s:1:"0";s:14:"ledger_balance";s:9:"301783.97";s:7:"ip_addr";s:14:"103.26.226.116";s:7:"referer";s:52:"https://b2b.lamarholidays.com/agent_registration.php";s:11:"comp_reg_no";s:0:"";s:10:"db_caching";s:1:"1";s:23:"search_by_multicurrency";s:1:"1";s:11:"web_service";s:0:"";s:19:"web_service_pacakge";s:1:"0";s:17:"web_service_tours";s:1:"0";s:14:"web_service_ip";N;s:13:"accounting_id";s:6:"CD0086";s:12:"executive_id";N;s:16:"business_unit_id";N;s:17:"additional_markup";s:0:"";s:12:"cal_hashcode";s:64:"5e1864f11c6a99583ffdc75462dc10db52484f9c89760cbbbfd152e4ec518af2";s:13:"calender_feed";s:1:"0";s:13:"calendar_date";N;s:15:"loyalty_tier_id";N;s:16:"loyalty_email_id";N;s:16:"loyalty_password";N;s:10:"acc_export";s:1:"0";s:10:"acc_posted";s:1:"0";s:11:"status_flag";s:1:"A";s:18:"amadeus_agent_sign";N;s:22:"amadeus_user_duty_code";N;s:20:"contracted_list_icon";N;s:11:"expiry_date";s:10:"2026-04-08";s:15:"allow_ticketing";s:0:"";s:12:"allow_survey";s:1:"0";s:12:"branch_agent";s:1:"N";s:21:"invoice_generate_time";N;s:18:"excluded_countries";N;s:23:"country_currency_search";s:1:"0";s:12:"messanger_id";N;s:16:"allow_credit_use";s:1:"0";s:25:"exchange_currency_display";s:1:"0";s:29:"agency_name_in_other_language";N;s:25:"address_in_other_language";N;s:26:"other_language_agency_name";s:0:"";s:22:"other_language_address";s:0:"";s:16:"Foreign_currency";N;s:30:"web_service_only_mapped_hotels";s:1:"1";s:6:"tts_id";s:1:"0";s:21:"auto_voucher_bookings";s:1:"0";s:10:"txt_tax_no";N;s:26:"allow_frontend_rate_change";s:1:"0";s:16:"ws_supplier_rate";s:1:"0";s:16:"ws_supplier_name";s:1:"0";s:16:"ws_customer_type";s:8:"external";s:14:"allow_encoding";s:1:"0";s:13:"allow_iprange";s:1:"0";s:22:"floating_deposits_type";s:1:"0";s:10:"ws_caching";s:1:"0";s:9:"ws_liquid";s:1:"0";s:14:"agent_category";N;s:15:"can_show_hotels";s:0:"";s:17:"can_show_location";s:1:"1";s:12:"rate_profile";s:1:"0";s:6:"pan_no";s:0:"";s:6:"gst_no";s:0:"";s:6:"vat_no";s:0:"";s:12:"is_corporate";s:1:"0";s:8:"login_ip";s:15:"103.104.226.130";s:10:"login_time";N;s:13:"login_attempt";s:1:"0";s:16:"personal_booking";s:1:"0";s:20:"inside_travel_policy";s:1:"0";s:16:"secondary_emails";N;s:19:"secondary_acc_email";N;s:19:"secondary_man_email";N;s:19:"secondary_res_email";N;s:16:"currency_profile";s:1:"0";s:13:"tax_commision";s:1:"1";s:9:"tax_id_no";N;s:17:"multiple_currency";N;s:11:"ws_password";N;s:15:"staff_reference";N;s:13:"displaymarkup";s:1:"1";s:5:"level";N;s:6:"branch";N;s:11:"nationality";N;s:10:"department";N;s:11:"cost_center";N;s:15:"travel_arranger";N;s:10:"preference";N;s:11:"passport_no";N;s:14:"passport_issue";N;s:15:"passport_expiry";N;s:21:"driver_licence_number";N;s:20:"driver_licence_issue";N;s:21:"driver_licence_expiry";N;s:9:"telephone";N;s:9:"extension";N;s:17:"emergency_contact";N;s:13:"travel_policy";N;s:4:"role";N;s:8:"approver";N;s:11:"credit_days";N;s:13:"credit_remark";N;s:23:"temp_credit_expiry_date";N;s:5:"state";N;s:6:"sso_id";N;s:19:"room_mapping_access";s:1:"0";s:3:"pcc";N;s:14:"static_data_ip";N;s:13:"profile_image";s:0:"";s:33:"ws_reservation_with_supplier_name";s:1:"0";s:11:"auth_secret";N;s:9:"save_logs";s:3:"yes";s:23:"allow_search_can_policy";s:1:"0";s:15:"accounting_flag";s:1:"0";s:15:"allow_login_otp";s:1:"2";s:21:"allow_frontend_access";s:1:"1";s:18:"allow_whatsapp_otp";s:1:"0";s:19:"secondary_otp_email";s:0:"";s:12:"tcs_verified";s:1:"0";s:10:"tcs_req_id";N;s:12:"tcs_link_url";N;s:24:"enable_cheapest_supplier";s:1:"0";s:14:"auth_2fa_login";s:1:"0";s:19:"auth_2fa_on_booking";s:1:"0";s:21:"search_merging_method";s:3:"old";s:14:"allow_web_book";s:1:"0";s:20:"limited_hotel_search";s:1:"0";s:10:"auth_check";N;s:11:"secure_auth";s:1:"0";s:23:"new_cancellation_policy";s:1:"0";s:13:"fields_access";s:35:"Narration Text,Commission Narration";s:14:"search_rule_id";N;s:13:"request_limit";N;s:11:"otp_service";N;s:31:"backoffice_agent_login_with_otp";N;s:13:"allow_chatbot";s:1:"0";s:25:"apply_to_all_distributors";s:1:"0";s:13:"currency_code";s:3:"AED";s:10:"agent_code";s:6:"CD0086";}s:9:"key_agent";s:15:"CeidQV9GD9zPt5i";}','India',now(),'uat.lamarholidays.com/service_search.php','103.104.226.130'); [08/24/2026 07:12:49], [Script File: logout.php, File: class.phpSecurityAdm.php, Function: logout_log, Line: 3220],INSERT INTO psa_login_log set username = 'Snehal_Test' , user_type = 'Snehal_Test'_type , branch_id = '1' , login_datetime = '2026-08-24 07:12:49' , ip = '103.104.226.130' , action = 'Logout' , reason = '' , error_code = 'BACKEND_ACCESSED' ; [08/24/2026 07:12:59], [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-24 07:12:59', ip = '103.104.226.130', action = 'Login', reason = 'Accessed by PSAuser::sujay_qtech' , error_code = 'BACKEND_ACCESSED' ; [08/24/2026 07:13:45], [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-24 07:13:45', ip = '103.104.226.130', action = 'Login', reason = 'Accessed by PSAuser::sujay_qtech' , error_code = 'BACKEND_ACCESSED' ; [08/24/2026 07:14: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-24 07:14:21', ip = '103.104.226.130', action = 'Login', reason = 'Accessed by PSAuser::sujay_qtech' , error_code = 'BACKEND_ACCESSED' ; [08/24/2026 07:14:32], [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-24 07:14:32', ip = '103.104.226.130', action = 'Login', reason = 'Accessed by PSAuser::sujay_qtech' , error_code = 'BACKEND_ACCESSED' ; [08/24/2026 07:14:36], [Script File: service_search.php, File: common.func.php, Function: check_ip2location_valid_country, Line: 8439],INSERT INTO agent_allowed_countries_log (agent_id,session_info,country,create_date,request_url,ip_address) VALUES ('86','a:68:{s:7:"referer";s:48:"https://uat.lamarholidays.com/service_search.php";s:9:"csp_nonce";s:32:"5e536191b45e30865446065fe098aa78";s:15:"uniqueSearchRef";s:28:"2026082403143200000027534150";s:12:"browser_info";s:29:"GoogleChrome/127.0.0.0(linux)";s:8:"language";s:7:"english";s:23:"search_by_multicurrency";s:1:"1";s:29:"allow_book_under_cancellation";s:0:"";s:11:"can_voucher";s:0:"";s:8:"can_book";s:0:"";s:10:"can_cancel";i:0;s:17:"view_all_bookings";s:1:"0";s:17:"additional_markup";N;s:8:"usertype";s:2:"CC";s:9:"sort_type";s:5:"price";s:8:"username";s:11:"Snehal_Test";s:13:"sub_firstname";s:9:"qtechtest";s:12:"sub_lastname";s:5:"qtech";s:12:"sub_username";s:5:"qtech";s:9:"sub_email";s:15:"qtech@qtech.com";s:9:"sub_phone";s:11:"91-87654345";s:9:"branch_id";s:1:"1";s:8:"loggedin";s:16:"24-08-2026 07:14";s:12:"agent_markup";N;s:16:"sub_agent_markup";N;s:9:"lead_time";s:1:"0";s:8:"currency";s:2:"11";s:13:"currency_code";s:3:"AED";s:13:"agent_country";s:2:"47";s:11:"sub_user_id";s:2:"11";s:6:"userid";s:2:"86";s:16:"op_staff_country";s:3:"106";s:10:"agent_type";s:2:"CC";s:4:"logo";s:0:"";s:21:"user_time_zone_offset";s:3:"5.5";s:31:"backoffice_agent_login_with_otp";i:0;s:3:"tms";i:1;s:10:"error_code";s:16:"BACKEND_ACCESSED";s:15:"backoffice_user";s:11:"sujay_qtech";s:12:"login_reason";s:32:"Accessed by PSAuser::sujay_qtech";s:26:"agentLastLoggedInIpaddress";a:1:{i:0;s:15:"103.104.226.130";}s:14:"user_remote_ip";s:15:"103.104.226.130";s:10:"user_agent";s:101:"Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36";s:8:"is_admin";i:0;s:26:"can_check_foreign_currency";i:0;s:12:"parent_agent";s:1:"0";s:17:"apply_service_tax";s:2:"no";s:15:"allow_quotation";s:1:"1";s:10:"admin_user";s:11:"sujay_qtech";s:9:"can_debug";i:1;s:17:"ALLOW_ADMIN_DEBUG";i:1;s:11:"mailtoagent";s:1:"1";s:14:"mailtosupplier";s:1:"1";s:16:"mailtoconsultant";s:1:"1";s:11:"mailtoadmin";s:1:"1";s:12:"mailtocommon";s:1:"1";s:18:"agent_country_name";s:10:"Azerbaijan";s:15:"agent_city_name";s:4:"Baku";s:10:"db_caching";s:1:"1";s:10:"ChildArray";s:0:"";s:10:"flag_image";s:0:"";s:6:"allow_";s:3:"5.5";s:26:"allow_login_otp_validation";i:2;s:10:"lead_times";a:1:{s:9:"hotelbeds";s:2:"96";}s:27:"cancellation_markup_amounts";s:0:"";s:13:"tax_commision";s:1:"1";s:3:"b2c";i:0;s:13:"agent_details";a:221:{s:2:"id";s:2:"86";s:8:"admin_id";s:5:"Qtech";s:11:"agency_name";s:5:"Qtech";s:15:"accounting_name";s:0:"";s:10:"first_name";s:6:"Snehal";s:11:"middle_name";s:0:"";s:9:"last_name";s:7:"Valanju";s:10:"agent_type";s:2:"CC";s:9:"sort_type";s:5:"price";s:12:"credit_limit";s:6:"200000";s:21:"credit_limit_assigned";s:6:"200000";s:12:"credit_value";s:9:"49204.265";s:12:"credit_usage";s:10:"150795.735";s:17:"outstanding_limit";s:5:"0.000";s:17:"temp_credit_limit";s:1:"0";s:15:"cd_credit_limit";s:10:"200000.000";s:15:"cd_credit_usage";s:10:"150795.735";s:15:"cd_credit_value";s:9:"49204.265";s:19:"credit_distribution";s:1:"1";s:15:"opening_balance";s:1:"0";s:9:"lead_time";s:1:"0";s:7:"address";s:13:"Mumbai, India";s:4:"city";s:5:"49095";s:7:"pincode";s:5:"40000";s:16:"focus_agent_code";N;s:7:"country";s:2:"47";s:16:"time_zone_offset";s:3:"5.5";s:10:"enable_dst";s:1:"0";s:5:"phone";s:13:"91-7208049129";s:6:"mobile";s:13:"91-7891919191";s:3:"fax";s:0:"";s:5:"email";s:35:"vishwanath.dhotre@qtechsoftware.com";s:8:"username";s:11:"Snehal_Test";s:8:"password";s:64:"3bb494becbab6af7d296500f7d514764f6c38a390acadfdffa071e08b37e123a";s:4:"hash";N;s:11:"designation";s:0:"";s:11:"iata_status";s:1:"0";s:11:"iata_number";s:0:"";s:18:"nature_of_business";s:0:"";s:4:"logo";s:0:"";s:8:"currency";s:2:"11";s:6:"status";s:1:"A";s:11:"create_date";s:19:"2022-03-21 15:37:54";s:11:"modify_date";s:19:"2026-08-20 11:50:27";s:12:"parent_agent";s:1:"0";s:5:"debug";s:1:"1";s:8:"can_book";s:1:"1";s:20:"can_allocate_receipt";s:1:"1";s:11:"can_voucher";s:1:"1";s:6:"markup";N;s:13:"hidden_markup";N;s:9:"branch_id";s:1:"1";s:13:"consultant_id";s:7:"Srijith";s:16:"sales_manager_id";s:0:"";s:13:"is_super_user";s:1:"1";s:10:"block_mail";s:1:"0";s:29:"allow_book_under_cancellation";s:1:"1";s:10:"updateflag";N;s:10:"created_by";N;s:7:"website";s:0:"";s:4:"ukey";N;s:7:"profile";s:0:"";s:13:"account_email";N;s:8:"send_sms";N;s:8:"acc_name";s:0:"";s:9:"acc_email";s:0:"";s:9:"acc_phone";s:0:"";s:8:"man_name";s:0:"";s:9:"man_email";s:0:"";s:9:"man_phone";s:0:"";s:8:"res_name";s:0:"";s:9:"res_email";s:0:"";s:9:"res_phone";s:0:"";s:12:"agency_email";s:0:"";s:12:"payment_type";N;s:7:"remarks";s:0:"";s:18:"accounts_processed";s:1:"0";s:7:"site_id";s:1:"0";s:8:"wh_agent";s:2:"no";s:13:"wh_main_agent";N;s:15:"last_login_date";s:19:"2026-08-24 07:12:59";s:17:"apply_service_tax";s:2:"no";s:15:"allow_quotation";s:1:"1";s:13:"credit_option";s:15:"on_voucher_date";s:10:"no_of_days";s:1:"0";s:14:"ledger_balance";s:9:"301783.97";s:7:"ip_addr";s:14:"103.26.226.116";s:7:"referer";s:52:"https://b2b.lamarholidays.com/agent_registration.php";s:11:"comp_reg_no";s:0:"";s:10:"db_caching";s:1:"1";s:23:"search_by_multicurrency";s:1:"1";s:11:"web_service";s:0:"";s:19:"web_service_pacakge";s:1:"0";s:17:"web_service_tours";s:1:"0";s:14:"web_service_ip";N;s:13:"accounting_id";s:6:"CD0086";s:12:"executive_id";N;s:16:"business_unit_id";N;s:17:"additional_markup";s:0:"";s:12:"cal_hashcode";s:64:"5e1864f11c6a99583ffdc75462dc10db52484f9c89760cbbbfd152e4ec518af2";s:13:"calender_feed";s:1:"0";s:13:"calendar_date";N;s:15:"loyalty_tier_id";N;s:16:"loyalty_email_id";N;s:16:"loyalty_password";N;s:10:"acc_export";s:1:"0";s:10:"acc_posted";s:1:"0";s:11:"status_flag";s:1:"A";s:18:"amadeus_agent_sign";N;s:22:"amadeus_user_duty_code";N;s:20:"contracted_list_icon";N;s:11:"expiry_date";s:10:"2026-04-08";s:15:"allow_ticketing";s:0:"";s:12:"allow_survey";s:1:"0";s:12:"branch_agent";s:1:"N";s:21:"invoice_generate_time";N;s:18:"excluded_countries";N;s:23:"country_currency_search";s:1:"0";s:12:"messanger_id";N;s:16:"allow_credit_use";s:1:"0";s:25:"exchange_currency_display";s:1:"0";s:29:"agency_name_in_other_language";N;s:25:"address_in_other_language";N;s:26:"other_language_agency_name";s:0:"";s:22:"other_language_address";s:0:"";s:16:"Foreign_currency";N;s:30:"web_service_only_mapped_hotels";s:1:"1";s:6:"tts_id";s:1:"0";s:21:"auto_voucher_bookings";s:1:"0";s:10:"txt_tax_no";N;s:26:"allow_frontend_rate_change";s:1:"0";s:16:"ws_supplier_rate";s:1:"0";s:16:"ws_supplier_name";s:1:"0";s:16:"ws_customer_type";s:8:"external";s:14:"allow_encoding";s:1:"0";s:13:"allow_iprange";s:1:"0";s:22:"floating_deposits_type";s:1:"0";s:10:"ws_caching";s:1:"0";s:9:"ws_liquid";s:1:"0";s:14:"agent_category";N;s:15:"can_show_hotels";s:0:"";s:17:"can_show_location";s:1:"1";s:12:"rate_profile";s:1:"0";s:6:"pan_no";s:0:"";s:6:"gst_no";s:0:"";s:6:"vat_no";s:0:"";s:12:"is_corporate";s:1:"0";s:8:"login_ip";s:15:"103.104.226.130";s:10:"login_time";N;s:13:"login_attempt";s:1:"0";s:16:"personal_booking";s:1:"0";s:20:"inside_travel_policy";s:1:"0";s:16:"secondary_emails";N;s:19:"secondary_acc_email";N;s:19:"secondary_man_email";N;s:19:"secondary_res_email";N;s:16:"currency_profile";s:1:"0";s:13:"tax_commision";s:1:"1";s:9:"tax_id_no";N;s:17:"multiple_currency";N;s:11:"ws_password";N;s:15:"staff_reference";N;s:13:"displaymarkup";s:1:"1";s:5:"level";N;s:6:"branch";N;s:11:"nationality";N;s:10:"department";N;s:11:"cost_center";N;s:15:"travel_arranger";N;s:10:"preference";N;s:11:"passport_no";N;s:14:"passport_issue";N;s:15:"passport_expiry";N;s:21:"driver_licence_number";N;s:20:"driver_licence_issue";N;s:21:"driver_licence_expiry";N;s:9:"telephone";N;s:9:"extension";N;s:17:"emergency_contact";N;s:13:"travel_policy";N;s:4:"role";N;s:8:"approver";N;s:11:"credit_days";N;s:13:"credit_remark";N;s:23:"temp_credit_expiry_date";N;s:5:"state";N;s:6:"sso_id";N;s:19:"room_mapping_access";s:1:"0";s:3:"pcc";N;s:14:"static_data_ip";N;s:13:"profile_image";s:0:"";s:33:"ws_reservation_with_supplier_name";s:1:"0";s:11:"auth_secret";N;s:9:"save_logs";s:3:"yes";s:23:"allow_search_can_policy";s:1:"0";s:15:"accounting_flag";s:1:"0";s:15:"allow_login_otp";s:1:"2";s:21:"allow_frontend_access";s:1:"1";s:18:"allow_whatsapp_otp";s:1:"0";s:19:"secondary_otp_email";s:0:"";s:12:"tcs_verified";s:1:"0";s:10:"tcs_req_id";N;s:12:"tcs_link_url";N;s:24:"enable_cheapest_supplier";s:1:"0";s:14:"auth_2fa_login";s:1:"0";s:19:"auth_2fa_on_booking";s:1:"0";s:21:"search_merging_method";s:3:"old";s:14:"allow_web_book";s:1:"0";s:20:"limited_hotel_search";s:1:"0";s:10:"auth_check";N;s:11:"secure_auth";s:1:"0";s:23:"new_cancellation_policy";s:1:"0";s:13:"fields_access";s:35:"Narration Text,Commission Narration";s:14:"search_rule_id";N;s:13:"request_limit";N;s:11:"otp_service";N;s:31:"backoffice_agent_login_with_otp";N;s:13:"allow_chatbot";s:1:"0";s:25:"apply_to_all_distributors";s:1:"0";s:13:"currency_code";s:3:"AED";s:10:"agent_code";s:6:"CD0086";}s:9:"key_agent";s:15:"zZlMU6jKJ05GTiS";}','India',now(),'uat.lamarholidays.com/service_search.php','103.104.226.130'); [08/24/2026 07:14: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-24 07:14:46', ip = '103.104.226.130', action = 'Login', reason = 'Accessed by PSAuser::sujay_qtech' , error_code = 'BACKEND_ACCESSED' ; [08/24/2026 07:14:49], [Script File: service_search.php, File: common.func.php, Function: check_ip2location_valid_country, Line: 8439],INSERT INTO agent_allowed_countries_log (agent_id,session_info,country,create_date,request_url,ip_address) VALUES ('86','a:68:{s:7:"referer";s:48:"https://uat.lamarholidays.com/service_search.php";s:9:"csp_nonce";s:32:"c409a342acc02fd6049d580c372c334e";s:15:"uniqueSearchRef";s:28:"2026082403143200000027534150";s:12:"browser_info";s:29:"GoogleChrome/127.0.0.0(linux)";s:8:"language";s:7:"english";s:23:"search_by_multicurrency";s:1:"1";s:29:"allow_book_under_cancellation";s:0:"";s:11:"can_voucher";s:0:"";s:8:"can_book";s:0:"";s:10:"can_cancel";i:0;s:17:"view_all_bookings";s:1:"0";s:17:"additional_markup";N;s:8:"usertype";s:2:"CC";s:9:"sort_type";s:5:"price";s:8:"username";s:11:"Snehal_Test";s:13:"sub_firstname";s:9:"qtechtest";s:12:"sub_lastname";s:5:"qtech";s:12:"sub_username";s:5:"qtech";s:9:"sub_email";s:15:"qtech@qtech.com";s:9:"sub_phone";s:11:"91-87654345";s:9:"branch_id";s:1:"1";s:8:"loggedin";s:16:"24-08-2026 07:14";s:12:"agent_markup";N;s:16:"sub_agent_markup";N;s:9:"lead_time";s:1:"0";s:8:"currency";s:2:"11";s:13:"currency_code";s:3:"AED";s:13:"agent_country";s:2:"47";s:11:"sub_user_id";s:2:"11";s:6:"userid";s:2:"86";s:16:"op_staff_country";s:3:"106";s:10:"agent_type";s:2:"CC";s:4:"logo";s:0:"";s:21:"user_time_zone_offset";s:3:"5.5";s:31:"backoffice_agent_login_with_otp";i:0;s:3:"tms";i:1;s:10:"error_code";s:16:"BACKEND_ACCESSED";s:15:"backoffice_user";s:11:"sujay_qtech";s:12:"login_reason";s:32:"Accessed by PSAuser::sujay_qtech";s:26:"agentLastLoggedInIpaddress";a:1:{i:0;s:15:"103.104.226.130";}s:14:"user_remote_ip";s:15:"103.104.226.130";s:10:"user_agent";s:101:"Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36";s:8:"is_admin";i:0;s:26:"can_check_foreign_currency";i:0;s:12:"parent_agent";s:1:"0";s:17:"apply_service_tax";s:2:"no";s:15:"allow_quotation";s:1:"1";s:10:"admin_user";s:11:"sujay_qtech";s:9:"can_debug";i:1;s:17:"ALLOW_ADMIN_DEBUG";i:1;s:11:"mailtoagent";s:1:"1";s:14:"mailtosupplier";s:1:"1";s:16:"mailtoconsultant";s:1:"1";s:11:"mailtoadmin";s:1:"1";s:12:"mailtocommon";s:1:"1";s:18:"agent_country_name";s:10:"Azerbaijan";s:15:"agent_city_name";s:4:"Baku";s:10:"db_caching";s:1:"1";s:10:"ChildArray";s:0:"";s:10:"flag_image";s:0:"";s:6:"allow_";s:3:"5.5";s:26:"allow_login_otp_validation";i:2;s:10:"lead_times";a:1:{s:9:"hotelbeds";s:2:"96";}s:27:"cancellation_markup_amounts";s:0:"";s:13:"tax_commision";s:1:"1";s:3:"b2c";i:0;s:13:"agent_details";a:221:{s:2:"id";s:2:"86";s:8:"admin_id";s:5:"Qtech";s:11:"agency_name";s:5:"Qtech";s:15:"accounting_name";s:0:"";s:10:"first_name";s:6:"Snehal";s:11:"middle_name";s:0:"";s:9:"last_name";s:7:"Valanju";s:10:"agent_type";s:2:"CC";s:9:"sort_type";s:5:"price";s:12:"credit_limit";s:6:"200000";s:21:"credit_limit_assigned";s:6:"200000";s:12:"credit_value";s:9:"49204.265";s:12:"credit_usage";s:10:"150795.735";s:17:"outstanding_limit";s:5:"0.000";s:17:"temp_credit_limit";s:1:"0";s:15:"cd_credit_limit";s:10:"200000.000";s:15:"cd_credit_usage";s:10:"150795.735";s:15:"cd_credit_value";s:9:"49204.265";s:19:"credit_distribution";s:1:"1";s:15:"opening_balance";s:1:"0";s:9:"lead_time";s:1:"0";s:7:"address";s:13:"Mumbai, India";s:4:"city";s:5:"49095";s:7:"pincode";s:5:"40000";s:16:"focus_agent_code";N;s:7:"country";s:2:"47";s:16:"time_zone_offset";s:3:"5.5";s:10:"enable_dst";s:1:"0";s:5:"phone";s:13:"91-7208049129";s:6:"mobile";s:13:"91-7891919191";s:3:"fax";s:0:"";s:5:"email";s:35:"vishwanath.dhotre@qtechsoftware.com";s:8:"username";s:11:"Snehal_Test";s:8:"password";s:64:"3bb494becbab6af7d296500f7d514764f6c38a390acadfdffa071e08b37e123a";s:4:"hash";N;s:11:"designation";s:0:"";s:11:"iata_status";s:1:"0";s:11:"iata_number";s:0:"";s:18:"nature_of_business";s:0:"";s:4:"logo";s:0:"";s:8:"currency";s:2:"11";s:6:"status";s:1:"A";s:11:"create_date";s:19:"2022-03-21 15:37:54";s:11:"modify_date";s:19:"2026-08-20 11:50:27";s:12:"parent_agent";s:1:"0";s:5:"debug";s:1:"1";s:8:"can_book";s:1:"1";s:20:"can_allocate_receipt";s:1:"1";s:11:"can_voucher";s:1:"1";s:6:"markup";N;s:13:"hidden_markup";N;s:9:"branch_id";s:1:"1";s:13:"consultant_id";s:7:"Srijith";s:16:"sales_manager_id";s:0:"";s:13:"is_super_user";s:1:"1";s:10:"block_mail";s:1:"0";s:29:"allow_book_under_cancellation";s:1:"1";s:10:"updateflag";N;s:10:"created_by";N;s:7:"website";s:0:"";s:4:"ukey";N;s:7:"profile";s:0:"";s:13:"account_email";N;s:8:"send_sms";N;s:8:"acc_name";s:0:"";s:9:"acc_email";s:0:"";s:9:"acc_phone";s:0:"";s:8:"man_name";s:0:"";s:9:"man_email";s:0:"";s:9:"man_phone";s:0:"";s:8:"res_name";s:0:"";s:9:"res_email";s:0:"";s:9:"res_phone";s:0:"";s:12:"agency_email";s:0:"";s:12:"payment_type";N;s:7:"remarks";s:0:"";s:18:"accounts_processed";s:1:"0";s:7:"site_id";s:1:"0";s:8:"wh_agent";s:2:"no";s:13:"wh_main_agent";N;s:15:"last_login_date";s:19:"2026-08-24 07:12:59";s:17:"apply_service_tax";s:2:"no";s:15:"allow_quotation";s:1:"1";s:13:"credit_option";s:15:"on_voucher_date";s:10:"no_of_days";s:1:"0";s:14:"ledger_balance";s:9:"301783.97";s:7:"ip_addr";s:14:"103.26.226.116";s:7:"referer";s:52:"https://b2b.lamarholidays.com/agent_registration.php";s:11:"comp_reg_no";s:0:"";s:10:"db_caching";s:1:"1";s:23:"search_by_multicurrency";s:1:"1";s:11:"web_service";s:0:"";s:19:"web_service_pacakge";s:1:"0";s:17:"web_service_tours";s:1:"0";s:14:"web_service_ip";N;s:13:"accounting_id";s:6:"CD0086";s:12:"executive_id";N;s:16:"business_unit_id";N;s:17:"additional_markup";s:0:"";s:12:"cal_hashcode";s:64:"5e1864f11c6a99583ffdc75462dc10db52484f9c89760cbbbfd152e4ec518af2";s:13:"calender_feed";s:1:"0";s:13:"calendar_date";N;s:15:"loyalty_tier_id";N;s:16:"loyalty_email_id";N;s:16:"loyalty_password";N;s:10:"acc_export";s:1:"0";s:10:"acc_posted";s:1:"0";s:11:"status_flag";s:1:"A";s:18:"amadeus_agent_sign";N;s:22:"amadeus_user_duty_code";N;s:20:"contracted_list_icon";N;s:11:"expiry_date";s:10:"2026-04-08";s:15:"allow_ticketing";s:0:"";s:12:"allow_survey";s:1:"0";s:12:"branch_agent";s:1:"N";s:21:"invoice_generate_time";N;s:18:"excluded_countries";N;s:23:"country_currency_search";s:1:"0";s:12:"messanger_id";N;s:16:"allow_credit_use";s:1:"0";s:25:"exchange_currency_display";s:1:"0";s:29:"agency_name_in_other_language";N;s:25:"address_in_other_language";N;s:26:"other_language_agency_name";s:0:"";s:22:"other_language_address";s:0:"";s:16:"Foreign_currency";N;s:30:"web_service_only_mapped_hotels";s:1:"1";s:6:"tts_id";s:1:"0";s:21:"auto_voucher_bookings";s:1:"0";s:10:"txt_tax_no";N;s:26:"allow_frontend_rate_change";s:1:"0";s:16:"ws_supplier_rate";s:1:"0";s:16:"ws_supplier_name";s:1:"0";s:16:"ws_customer_type";s:8:"external";s:14:"allow_encoding";s:1:"0";s:13:"allow_iprange";s:1:"0";s:22:"floating_deposits_type";s:1:"0";s:10:"ws_caching";s:1:"0";s:9:"ws_liquid";s:1:"0";s:14:"agent_category";N;s:15:"can_show_hotels";s:0:"";s:17:"can_show_location";s:1:"1";s:12:"rate_profile";s:1:"0";s:6:"pan_no";s:0:"";s:6:"gst_no";s:0:"";s:6:"vat_no";s:0:"";s:12:"is_corporate";s:1:"0";s:8:"login_ip";s:15:"103.104.226.130";s:10:"login_time";N;s:13:"login_attempt";s:1:"0";s:16:"personal_booking";s:1:"0";s:20:"inside_travel_policy";s:1:"0";s:16:"secondary_emails";N;s:19:"secondary_acc_email";N;s:19:"secondary_man_email";N;s:19:"secondary_res_email";N;s:16:"currency_profile";s:1:"0";s:13:"tax_commision";s:1:"1";s:9:"tax_id_no";N;s:17:"multiple_currency";N;s:11:"ws_password";N;s:15:"staff_reference";N;s:13:"displaymarkup";s:1:"1";s:5:"level";N;s:6:"branch";N;s:11:"nationality";N;s:10:"department";N;s:11:"cost_center";N;s:15:"travel_arranger";N;s:10:"preference";N;s:11:"passport_no";N;s:14:"passport_issue";N;s:15:"passport_expiry";N;s:21:"driver_licence_number";N;s:20:"driver_licence_issue";N;s:21:"driver_licence_expiry";N;s:9:"telephone";N;s:9:"extension";N;s:17:"emergency_contact";N;s:13:"travel_policy";N;s:4:"role";N;s:8:"approver";N;s:11:"credit_days";N;s:13:"credit_remark";N;s:23:"temp_credit_expiry_date";N;s:5:"state";N;s:6:"sso_id";N;s:19:"room_mapping_access";s:1:"0";s:3:"pcc";N;s:14:"static_data_ip";N;s:13:"profile_image";s:0:"";s:33:"ws_reservation_with_supplier_name";s:1:"0";s:11:"auth_secret";N;s:9:"save_logs";s:3:"yes";s:23:"allow_search_can_policy";s:1:"0";s:15:"accounting_flag";s:1:"0";s:15:"allow_login_otp";s:1:"2";s:21:"allow_frontend_access";s:1:"1";s:18:"allow_whatsapp_otp";s:1:"0";s:19:"secondary_otp_email";s:0:"";s:12:"tcs_verified";s:1:"0";s:10:"tcs_req_id";N;s:12:"tcs_link_url";N;s:24:"enable_cheapest_supplier";s:1:"0";s:14:"auth_2fa_login";s:1:"0";s:19:"auth_2fa_on_booking";s:1:"0";s:21:"search_merging_method";s:3:"old";s:14:"allow_web_book";s:1:"0";s:20:"limited_hotel_search";s:1:"0";s:10:"auth_check";N;s:11:"secure_auth";s:1:"0";s:23:"new_cancellation_policy";s:1:"0";s:13:"fields_access";s:35:"Narration Text,Commission Narration";s:14:"search_rule_id";N;s:13:"request_limit";N;s:11:"otp_service";N;s:31:"backoffice_agent_login_with_otp";N;s:13:"allow_chatbot";s:1:"0";s:25:"apply_to_all_distributors";s:1:"0";s:13:"currency_code";s:3:"AED";s:10:"agent_code";s:6:"CD0086";}s:9:"key_agent";s:15:"SmLcpkJv3ifnowa";}','India',now(),'uat.lamarholidays.com/service_search.php','103.104.226.130'); [08/24/2026 07:14:53], [Script File: logout.php, File: class.phpSecurityAdm.php, Function: logout_log, Line: 3220],INSERT INTO psa_login_log set username = 'Snehal_Test' , user_type = 'Snehal_Test'_type , branch_id = '1' , login_datetime = '2026-08-24 07:14:53' , ip = '103.104.226.130' , action = 'Logout' , reason = '' , error_code = 'BACKEND_ACCESSED' ; [08/24/2026 07:15:03], [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-24 07:15:03', ip = '103.104.226.130', action = 'Login', reason = 'Accessed by PSAuser::sujay_qtech' , error_code = 'BACKEND_ACCESSED' ; [08/24/2026 07:15:07], [Script File: service_search.php, File: common.func.php, Function: check_ip2location_valid_country, Line: 8439],INSERT INTO agent_allowed_countries_log (agent_id,session_info,country,create_date,request_url,ip_address) VALUES ('86','a:71:{s:7:"referer";s:48:"https://uat.lamarholidays.com/service_search.php";s:9:"csp_nonce";s:32:"57a632112ac300c40fda4e0fe7a77732";s:15:"uniqueSearchRef";s:28:"2026082403145300000058398955";s:12:"browser_info";s:29:"GoogleChrome/127.0.0.0(linux)";s:8:"language";s:7:"english";s:9:"key_agent";s:15:"P7ot47N9Z3eJaJF";s:8:"otp_page";s:5:"login";s:14:"csrf_token_arr";a:1:{s:17:"agent_login_smnm5";s:69:"smnm5e530772cf6ad5e3dc47e99d1760a1861155c96125a2f823605bd6be6f41def6e";}s:6:"secret";s:10:"6Pe2Z8xWEC";s:23:"search_by_multicurrency";s:1:"1";s:29:"allow_book_under_cancellation";s:0:"";s:11:"can_voucher";s:0:"";s:8:"can_book";s:0:"";s:10:"can_cancel";i:0;s:17:"view_all_bookings";s:1:"0";s:17:"additional_markup";N;s:8:"usertype";s:2:"CC";s:9:"sort_type";s:5:"price";s:8:"username";s:11:"Snehal_Test";s:13:"sub_firstname";s:9:"qtechtest";s:12:"sub_lastname";s:5:"qtech";s:12:"sub_username";s:5:"qtech";s:9:"sub_email";s:15:"qtech@qtech.com";s:9:"sub_phone";s:11:"91-87654345";s:9:"branch_id";s:1:"1";s:8:"loggedin";s:16:"24-08-2026 07:15";s:12:"agent_markup";N;s:16:"sub_agent_markup";N;s:9:"lead_time";s:1:"0";s:8:"currency";s:2:"11";s:13:"currency_code";s:3:"AED";s:13:"agent_country";s:2:"47";s:11:"sub_user_id";s:2:"11";s:6:"userid";s:2:"86";s:16:"op_staff_country";s:3:"106";s:10:"agent_type";s:2:"CC";s:4:"logo";s:0:"";s:21:"user_time_zone_offset";s:3:"5.5";s:31:"backoffice_agent_login_with_otp";i:0;s:3:"tms";i:1;s:10:"error_code";s:16:"BACKEND_ACCESSED";s:15:"backoffice_user";s:11:"sujay_qtech";s:12:"login_reason";s:32:"Accessed by PSAuser::sujay_qtech";s:26:"agentLastLoggedInIpaddress";a:1:{i:0;s:15:"103.104.226.130";}s:14:"user_remote_ip";s:15:"103.104.226.130";s:10:"user_agent";s:101:"Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36";s:8:"is_admin";i:0;s:26:"can_check_foreign_currency";i:0;s:12:"parent_agent";s:1:"0";s:17:"apply_service_tax";s:2:"no";s:15:"allow_quotation";s:1:"1";s:10:"admin_user";s:11:"sujay_qtech";s:9:"can_debug";i:1;s:17:"ALLOW_ADMIN_DEBUG";i:1;s:11:"mailtoagent";s:1:"1";s:14:"mailtosupplier";s:1:"1";s:16:"mailtoconsultant";s:1:"1";s:11:"mailtoadmin";s:1:"1";s:12:"mailtocommon";s:1:"1";s:18:"agent_country_name";s:10:"Azerbaijan";s:15:"agent_city_name";s:4:"Baku";s:10:"db_caching";s:1:"1";s:10:"ChildArray";s:0:"";s:10:"flag_image";s:0:"";s:6:"allow_";s:3:"5.5";s:26:"allow_login_otp_validation";i:2;s:10:"lead_times";a:1:{s:9:"hotelbeds";s:2:"96";}s:27:"cancellation_markup_amounts";s:0:"";s:13:"tax_commision";s:1:"1";s:3:"b2c";i:0;s:13:"agent_details";a:221:{s:2:"id";s:2:"86";s:8:"admin_id";s:5:"Qtech";s:11:"agency_name";s:5:"Qtech";s:15:"accounting_name";s:0:"";s:10:"first_name";s:6:"Snehal";s:11:"middle_name";s:0:"";s:9:"last_name";s:7:"Valanju";s:10:"agent_type";s:2:"CC";s:9:"sort_type";s:5:"price";s:12:"credit_limit";s:6:"200000";s:21:"credit_limit_assigned";s:6:"200000";s:12:"credit_value";s:9:"49204.265";s:12:"credit_usage";s:10:"150795.735";s:17:"outstanding_limit";s:5:"0.000";s:17:"temp_credit_limit";s:1:"0";s:15:"cd_credit_limit";s:10:"200000.000";s:15:"cd_credit_usage";s:10:"150795.735";s:15:"cd_credit_value";s:9:"49204.265";s:19:"credit_distribution";s:1:"1";s:15:"opening_balance";s:1:"0";s:9:"lead_time";s:1:"0";s:7:"address";s:13:"Mumbai, India";s:4:"city";s:5:"49095";s:7:"pincode";s:5:"40000";s:16:"focus_agent_code";N;s:7:"country";s:2:"47";s:16:"time_zone_offset";s:3:"5.5";s:10:"enable_dst";s:1:"0";s:5:"phone";s:13:"91-7208049129";s:6:"mobile";s:13:"91-7891919191";s:3:"fax";s:0:"";s:5:"email";s:35:"vishwanath.dhotre@qtechsoftware.com";s:8:"username";s:11:"Snehal_Test";s:8:"password";s:64:"3bb494becbab6af7d296500f7d514764f6c38a390acadfdffa071e08b37e123a";s:4:"hash";N;s:11:"designation";s:0:"";s:11:"iata_status";s:1:"0";s:11:"iata_number";s:0:"";s:18:"nature_of_business";s:0:"";s:4:"logo";s:0:"";s:8:"currency";s:2:"11";s:6:"status";s:1:"A";s:11:"create_date";s:19:"2022-03-21 15:37:54";s:11:"modify_date";s:19:"2026-08-20 11:50:27";s:12:"parent_agent";s:1:"0";s:5:"debug";s:1:"1";s:8:"can_book";s:1:"1";s:20:"can_allocate_receipt";s:1:"1";s:11:"can_voucher";s:1:"1";s:6:"markup";N;s:13:"hidden_markup";N;s:9:"branch_id";s:1:"1";s:13:"consultant_id";s:7:"Srijith";s:16:"sales_manager_id";s:0:"";s:13:"is_super_user";s:1:"1";s:10:"block_mail";s:1:"0";s:29:"allow_book_under_cancellation";s:1:"1";s:10:"updateflag";N;s:10:"created_by";N;s:7:"website";s:0:"";s:4:"ukey";N;s:7:"profile";s:0:"";s:13:"account_email";N;s:8:"send_sms";N;s:8:"acc_name";s:0:"";s:9:"acc_email";s:0:"";s:9:"acc_phone";s:0:"";s:8:"man_name";s:0:"";s:9:"man_email";s:0:"";s:9:"man_phone";s:0:"";s:8:"res_name";s:0:"";s:9:"res_email";s:0:"";s:9:"res_phone";s:0:"";s:12:"agency_email";s:0:"";s:12:"payment_type";N;s:7:"remarks";s:0:"";s:18:"accounts_processed";s:1:"0";s:7:"site_id";s:1:"0";s:8:"wh_agent";s:2:"no";s:13:"wh_main_agent";N;s:15:"last_login_date";s:19:"2026-08-24 07:12:59";s:17:"apply_service_tax";s:2:"no";s:15:"allow_quotation";s:1:"1";s:13:"credit_option";s:15:"on_voucher_date";s:10:"no_of_days";s:1:"0";s:14:"ledger_balance";s:9:"301783.97";s:7:"ip_addr";s:14:"103.26.226.116";s:7:"referer";s:52:"https://b2b.lamarholidays.com/agent_registration.php";s:11:"comp_reg_no";s:0:"";s:10:"db_caching";s:1:"1";s:23:"search_by_multicurrency";s:1:"1";s:11:"web_service";s:0:"";s:19:"web_service_pacakge";s:1:"0";s:17:"web_service_tours";s:1:"0";s:14:"web_service_ip";N;s:13:"accounting_id";s:6:"CD0086";s:12:"executive_id";N;s:16:"business_unit_id";N;s:17:"additional_markup";s:0:"";s:12:"cal_hashcode";s:64:"5e1864f11c6a99583ffdc75462dc10db52484f9c89760cbbbfd152e4ec518af2";s:13:"calender_feed";s:1:"0";s:13:"calendar_date";N;s:15:"loyalty_tier_id";N;s:16:"loyalty_email_id";N;s:16:"loyalty_password";N;s:10:"acc_export";s:1:"0";s:10:"acc_posted";s:1:"0";s:11:"status_flag";s:1:"A";s:18:"amadeus_agent_sign";N;s:22:"amadeus_user_duty_code";N;s:20:"contracted_list_icon";N;s:11:"expiry_date";s:10:"2026-04-08";s:15:"allow_ticketing";s:0:"";s:12:"allow_survey";s:1:"0";s:12:"branch_agent";s:1:"N";s:21:"invoice_generate_time";N;s:18:"excluded_countries";N;s:23:"country_currency_search";s:1:"0";s:12:"messanger_id";N;s:16:"allow_credit_use";s:1:"0";s:25:"exchange_currency_display";s:1:"0";s:29:"agency_name_in_other_language";N;s:25:"address_in_other_language";N;s:26:"other_language_agency_name";s:0:"";s:22:"other_language_address";s:0:"";s:16:"Foreign_currency";N;s:30:"web_service_only_mapped_hotels";s:1:"1";s:6:"tts_id";s:1:"0";s:21:"auto_voucher_bookings";s:1:"0";s:10:"txt_tax_no";N;s:26:"allow_frontend_rate_change";s:1:"0";s:16:"ws_supplier_rate";s:1:"0";s:16:"ws_supplier_name";s:1:"0";s:16:"ws_customer_type";s:8:"external";s:14:"allow_encoding";s:1:"0";s:13:"allow_iprange";s:1:"0";s:22:"floating_deposits_type";s:1:"0";s:10:"ws_caching";s:1:"0";s:9:"ws_liquid";s:1:"0";s:14:"agent_category";N;s:15:"can_show_hotels";s:0:"";s:17:"can_show_location";s:1:"1";s:12:"rate_profile";s:1:"0";s:6:"pan_no";s:0:"";s:6:"gst_no";s:0:"";s:6:"vat_no";s:0:"";s:12:"is_corporate";s:1:"0";s:8:"login_ip";s:15:"103.104.226.130";s:10:"login_time";N;s:13:"login_attempt";s:1:"0";s:16:"personal_booking";s:1:"0";s:20:"inside_travel_policy";s:1:"0";s:16:"secondary_emails";N;s:19:"secondary_acc_email";N;s:19:"secondary_man_email";N;s:19:"secondary_res_email";N;s:16:"currency_profile";s:1:"0";s:13:"tax_commision";s:1:"1";s:9:"tax_id_no";N;s:17:"multiple_currency";N;s:11:"ws_password";N;s:15:"staff_reference";N;s:13:"displaymarkup";s:1:"1";s:5:"level";N;s:6:"branch";N;s:11:"nationality";N;s:10:"department";N;s:11:"cost_center";N;s:15:"travel_arranger";N;s:10:"preference";N;s:11:"passport_no";N;s:14:"passport_issue";N;s:15:"passport_expiry";N;s:21:"driver_licence_number";N;s:20:"driver_licence_issue";N;s:21:"driver_licence_expiry";N;s:9:"telephone";N;s:9:"extension";N;s:17:"emergency_contact";N;s:13:"travel_policy";N;s:4:"role";N;s:8:"approver";N;s:11:"credit_days";N;s:13:"credit_remark";N;s:23:"temp_credit_expiry_date";N;s:5:"state";N;s:6:"sso_id";N;s:19:"room_mapping_access";s:1:"0";s:3:"pcc";N;s:14:"static_data_ip";N;s:13:"profile_image";s:0:"";s:33:"ws_reservation_with_supplier_name";s:1:"0";s:11:"auth_secret";N;s:9:"save_logs";s:3:"yes";s:23:"allow_search_can_policy";s:1:"0";s:15:"accounting_flag";s:1:"0";s:15:"allow_login_otp";s:1:"2";s:21:"allow_frontend_access";s:1:"1";s:18:"allow_whatsapp_otp";s:1:"0";s:19:"secondary_otp_email";s:0:"";s:12:"tcs_verified";s:1:"0";s:10:"tcs_req_id";N;s:12:"tcs_link_url";N;s:24:"enable_cheapest_supplier";s:1:"0";s:14:"auth_2fa_login";s:1:"0";s:19:"auth_2fa_on_booking";s:1:"0";s:21:"search_merging_method";s:3:"old";s:14:"allow_web_book";s:1:"0";s:20:"limited_hotel_search";s:1:"0";s:10:"auth_check";N;s:11:"secure_auth";s:1:"0";s:23:"new_cancellation_policy";s:1:"0";s:13:"fields_access";s:35:"Narration Text,Commission Narration";s:14:"search_rule_id";N;s:13:"request_limit";N;s:11:"otp_service";N;s:31:"backoffice_agent_login_with_otp";N;s:13:"allow_chatbot";s:1:"0";s:25:"apply_to_all_distributors";s:1:"0";s:13:"currency_code";s:3:"AED";s:10:"agent_code";s:6:"CD0086";}}','India',now(),'uat.lamarholidays.com/service_search.php','103.104.226.130'); [08/24/2026 07:15:10], [Script File: logout.php, File: class.phpSecurityAdm.php, Function: logout_log, Line: 3220],INSERT INTO psa_login_log set username = 'Snehal_Test' , user_type = 'Snehal_Test'_type , branch_id = '1' , login_datetime = '2026-08-24 07:15:10' , ip = '103.104.226.130' , action = 'Logout' , reason = '' , error_code = 'BACKEND_ACCESSED' ; [08/24/2026 07:15: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-24 07:15:22', ip = '103.104.226.130', action = 'Login', reason = 'Accessed by PSAuser::sujay_qtech' , error_code = 'BACKEND_ACCESSED' ; [08/24/2026 07:15:47], [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-24 07:15:47',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/24/2026 07:15:47], [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-24 07:15:47',`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-24 07:15:47\',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-20+11%3A50%3A27&can_book=1&can_voucher=1&allow_book_under_cancellation=1 changed to - modify_date=2026-08-24+07%3A15%3A47&can_book=&can_voucher=&allow_book_under_cancellation=0',`ip`= '103.104.226.130'; [08/24/2026 07:15:47], [Script File: agent.php, File: UserLog.php, Function: user_log_link, Line: 174],insert into user_log_link Set `user_logs_id`='449230', `entity`='Agents', `value`='86' ; [08/24/2026 07:15:47], [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/24/2026 07:15:47], [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-24 07:15:47'; [08/24/2026 07:15:47], [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/24/2026 07:15:47], [Script File: agent.php, File: Agent.php, Function: update, Line: 4904],delete from agent_supplier_debug where agent_id='86'; [08/24/2026 07:15:47], [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-24 07:08:47',create_date='2026-08-24 07:08:47'; [08/24/2026 07:15:47], [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-24 07:08:47',create_date='2026-08-24 07:08:47'; [08/24/2026 07:15:47], [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-24 07:08:47',create_date='2026-08-24 07:08:47'; [08/24/2026 07:15:47], [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-24 07:08:47',create_date='2026-08-24 07:08:47'; [08/24/2026 07:15:47], [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-24 07:08:47',create_date='2026-08-24 07:08:47'; [08/24/2026 07:15:47], [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-24 07:08:47',create_date='2026-08-24 07:08:47'; [08/24/2026 07:15:47], [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-24 07:08:47',create_date='2026-08-24 07:08:47'; [08/24/2026 07:15:47], [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-24 07:08:47',create_date='2026-08-24 07:08:47'; [08/24/2026 07:15:47], [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-24 07:08:47',create_date='2026-08-24 07:08:47'; [08/24/2026 07:15:47], [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-24 07:08:47',create_date='2026-08-24 07:08:47'; [08/24/2026 07:16:01], [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-24 07:16:01', ip = '103.104.226.130', action = 'Login', reason = 'Accessed by PSAuser::sujay_qtech' , error_code = 'BACKEND_ACCESSED' ; [08/24/2026 07:16:41], [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-24 07:16:41', ip = '103.104.226.130', action = 'Login', reason = 'Accessed by PSAuser::sujay_qtech' , error_code = 'BACKEND_ACCESSED' ; [08/24/2026 07:16:47], [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-24 07:16:47',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/24/2026 07:16:47], [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-24 07:16:47',`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-24 07:16:47\',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-24+07%3A15%3A47 changed to - modify_date=2026-08-24+07%3A16%3A47',`ip`= '103.104.226.130'; [08/24/2026 07:16:47], [Script File: agent.php, File: UserLog.php, Function: user_log_link, Line: 174],insert into user_log_link Set `user_logs_id`='449231', `entity`='Agents', `value`='86' ; [08/24/2026 07:16:47], [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/24/2026 07:16:47], [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-24 07:16:47'; [08/24/2026 07:16:47], [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/24/2026 07:16:47], [Script File: agent.php, File: Agent.php, Function: update, Line: 4904],delete from agent_supplier_debug where agent_id='86'; [08/24/2026 07:16:47], [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-24 07:08:47',create_date='2026-08-24 07:08:47'; [08/24/2026 07:16:47], [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-24 07:08:47',create_date='2026-08-24 07:08:47'; [08/24/2026 07:16:47], [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-24 07:08:47',create_date='2026-08-24 07:08:47'; [08/24/2026 07:16:47], [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-24 07:08:47',create_date='2026-08-24 07:08:47'; [08/24/2026 07:16:47], [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-24 07:08:47',create_date='2026-08-24 07:08:47'; [08/24/2026 07:16:47], [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-24 07:08:47',create_date='2026-08-24 07:08:47'; [08/24/2026 07:16:47], [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-24 07:08:47',create_date='2026-08-24 07:08:47'; [08/24/2026 07:16:47], [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-24 07:08:47',create_date='2026-08-24 07:08:47'; [08/24/2026 07:16:47], [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-24 07:08:47',create_date='2026-08-24 07:08:47'; [08/24/2026 07:16:47], [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-24 07:08:47',create_date='2026-08-24 07:08:47'; [08/24/2026 07:16:59], [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-24 07:16:59', ip = '103.104.226.130', action = 'Login', reason = 'Accessed by PSAuser::sujay_qtech' , error_code = 'BACKEND_ACCESSED' ; [08/24/2026 07:19:40], [Script File: hotel_search_list.php, File: hotel_search_list.php, Function: search_hotels, Line: 428],UPDATE keyword_clicks SET total_clicks = '11050' WHERE keyword = 'dubai' and record_type ='City' and record_id='71649'; [08/24/2026 07:20:15], [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-24 07:20:15',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/24/2026 07:20:15], [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-24 07:20:15',`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-24 07:20:15\',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-24+07%3A16%3A47&accounts_processed=1 changed to - modify_date=2026-08-24+07%3A20%3A15&accounts_processed=0',`ip`= '103.104.226.130'; [08/24/2026 07:20:15], [Script File: agent.php, File: UserLog.php, Function: user_log_link, Line: 174],insert into user_log_link Set `user_logs_id`='449232', `entity`='Agents', `value`='86' ; [08/24/2026 07:20:15], [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/24/2026 07:20:15], [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-24 07:20:15'; [08/24/2026 07:20:15], [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/24/2026 07:20:15], [Script File: agent.php, File: Agent.php, Function: update, Line: 4904],delete from agent_supplier_debug where agent_id='86'; [08/24/2026 07:20:15], [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-24 07:08:15',create_date='2026-08-24 07:08:15'; [08/24/2026 07:20:15], [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-24 07:08:15',create_date='2026-08-24 07:08:15'; [08/24/2026 07:20:15], [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-24 07:08:15',create_date='2026-08-24 07:08:15'; [08/24/2026 07:20:15], [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-24 07:08:15',create_date='2026-08-24 07:08:15'; [08/24/2026 07:20:15], [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-24 07:08:15',create_date='2026-08-24 07:08:15'; [08/24/2026 07:20:15], [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-24 07:08:15',create_date='2026-08-24 07:08:15'; [08/24/2026 07:20:15], [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-24 07:08:15',create_date='2026-08-24 07:08:15'; [08/24/2026 07:20:15], [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-24 07:08:15',create_date='2026-08-24 07:08:15'; [08/24/2026 07:20:15], [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-24 07:08:15',create_date='2026-08-24 07:08:15'; [08/24/2026 07:20:15], [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-24 07:08:15',create_date='2026-08-24 07:08:15'; [08/24/2026 07:20:23], [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-24 07:20:23',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/24/2026 07:20:23], [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-24 07:20:23',`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-24 07:20:23\',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-24+07%3A20%3A15 changed to - modify_date=2026-08-24+07%3A20%3A23',`ip`= '103.104.226.130'; [08/24/2026 07:20:23], [Script File: agent.php, File: UserLog.php, Function: user_log_link, Line: 174],insert into user_log_link Set `user_logs_id`='449233', `entity`='Agents', `value`='86' ; [08/24/2026 07:20:23], [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/24/2026 07:20:23], [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-24 07:20:23'; [08/24/2026 07:20:23], [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/24/2026 07:20:23], [Script File: agent.php, File: Agent.php, Function: update, Line: 4904],delete from agent_supplier_debug where agent_id='86'; [08/24/2026 07:20:23], [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-24 07:08:23',create_date='2026-08-24 07:08:23'; [08/24/2026 07:20:23], [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-24 07:08:23',create_date='2026-08-24 07:08:23'; [08/24/2026 07:20:23], [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-24 07:08:23',create_date='2026-08-24 07:08:23'; [08/24/2026 07:20:23], [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-24 07:08:23',create_date='2026-08-24 07:08:23'; [08/24/2026 07:20:23], [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-24 07:08:23',create_date='2026-08-24 07:08:23'; [08/24/2026 07:20:23], [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-24 07:08:23',create_date='2026-08-24 07:08:23'; [08/24/2026 07:20:23], [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-24 07:08:23',create_date='2026-08-24 07:08:23'; [08/24/2026 07:20:23], [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-24 07:08:23',create_date='2026-08-24 07:08:23'; [08/24/2026 07:20:23], [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-24 07:08:23',create_date='2026-08-24 07:08:23'; [08/24/2026 07:20:23], [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-24 07:08:23',create_date='2026-08-24 07:08:23'; [08/24/2026 07:20:52], [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-24 07:20:52', ip = '103.104.226.130', action = 'Login', reason = 'Accessed by PSAuser::sujay_qtech' , error_code = 'BACKEND_ACCESSED' ; [08/24/2026 07:21:14], [Script File: hotel_search_list.php, File: hotel_search_list.php, Function: search_hotels, Line: 428],UPDATE keyword_clicks SET total_clicks = '11051' WHERE keyword = 'dubai' and record_type ='City' and record_id='71649'; [08/24/2026 07:21:14], [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/04' , departure_date = '2026/09/05' , nights = '1' , room_types = '[{\"numberofAdults\":\"2\",\"noOfChildren\":\"0\",\"childrenages\":\"0,0\"}]' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2026-08-24 07:21:14' , total_adult = '2', nationality='47', total_children = '0', business_tracking = 'B2B', platform_language = 'en', admin_debug = '1' , site_id = '' , web_service = '0' ; [08/24/2026 07:21:14], [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 ('53850', 'double', '2026-08-24 :07:21:14',''); [08/24/2026 07:21:23], [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 = '53850') + '22412328',duration = '5.119',merge_duration = '0.020',assigned_supplier_count = '1',searched_supplier_count = '1',system_load_1_min = '0.61',system_load_5_min = '0.34',system_load_15_min = '0.36',system_memory_usage = '50.97',parallel_search_count = '1',is_cached = 'no' WHERE id = '53850'_update; [08/24/2026 07:21:55], [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-24 07:21:55', '1433311', 'website', 'go/24_08_2026/request_valuation_Snehal_Test_53850_07_21_54_1787556114.json', 'go/24_08_2026/response_valuation_Snehal_Test_53850_07_21_54_1787556114.json', 'go/24_08_2026/response_valuation_Snehal_Test_53850_07_21_54_1787556114.json'_code, '', '', '', '', '', '', '', 'OT000050226', '', ''); [08/24/2026 07:22:23], [Script File: agent.php, File: Agent.php, Function: assign_gateway, Line: 2339],delete from agent_gateway where agent_id=86; [08/24/2026 07:22:23], [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-24 07:22:23', 'admin#sujay_qtech#sujay_qtech', '103.104.226.130'); [08/24/2026 07:22:23], [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/24/2026 07:22:55], [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-24 07:22:55', '1433313', 'website', 'go/24_08_2026/request_valuation_Snehal_Test_53850_07_22_54_1787556174.json', 'go/24_08_2026/response_valuation_Snehal_Test_53850_07_22_54_1787556174.json', 'go/24_08_2026/response_valuation_Snehal_Test_53850_07_22_54_1787556174.json'_code, '', '', '', '', '', '', '', 'OT000050226', '', ''); [08/24/2026 07:24:31], [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-24 07:24:31', ip = '103.104.226.130', action = 'Login', reason = 'Accessed by PSAuser::sujay_qtech' , error_code = 'BACKEND_ACCESSED' ; [08/24/2026 07:24:54], [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/04' , departure_date = '2026/09/05' , nights = '1' , room_types = '[{\"numberofAdults\":\"2\",\"noOfChildren\":\"0\",\"childrenages\":\"0,0\"}]' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2026-08-24 07:24:54' , total_adult = '2', nationality='47', total_children = '0', business_tracking = 'B2B', platform_language = 'en', admin_debug = '1' , site_id = '' , web_service = '0' ; [08/24/2026 07:24:54], [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 ('53851', 'double', '2026-08-24 :07:24:54',''); [08/24/2026 07:25: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 = '53851') + '22412560',duration = '5.105',merge_duration = '0.006',assigned_supplier_count = '1',searched_supplier_count = '1',system_load_1_min = '0.07',system_load_5_min = '0.30',system_load_15_min = '0.36',system_memory_usage = '50.62',parallel_search_count = '1',is_cached = 'no' WHERE id = '53851'_update; [08/24/2026 07:25:30], [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-24 07:25:30', '1433319', 'website', 'go/24_08_2026/request_valuation_Snehal_Test_53851_07_25_30_1787556330.json', 'go/24_08_2026/response_valuation_Snehal_Test_53851_07_25_30_1787556330.json', 'go/24_08_2026/response_valuation_Snehal_Test_53851_07_25_30_1787556330.json'_code, '', '', '', '', '', '', '', 'OT000050226', '', ''); [08/24/2026 07:28:04], [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= '1',sales_manager_id= '',comp_reg_no= '',allow_quotation= '1',can_allocate_receipt= '1',can_voucher= '1',allow_book_under_cancellation='1',modify_date='2026-08-24 07:28:04',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/24/2026 07:28:04], [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-24 07:28:04',`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= \'1\',sales_manager_id= \'\',comp_reg_no= \'\',allow_quotation= \'1\',can_allocate_receipt= \'1\',can_voucher= \'1\',allow_book_under_cancellation=\'1\',modify_date=\'2026-08-24 07:28:04\',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-24+07%3A20%3A23&can_book=&can_voucher=&allow_book_under_cancellation=0&accounts_processed=1 changed to - modify_date=2026-08-24+07%3A28%3A04&can_book=1&can_voucher=1&allow_book_under_cancellation=1&accounts_processed=0',`ip`= '103.104.226.130'; [08/24/2026 07:28:04], [Script File: agent.php, File: UserLog.php, Function: user_log_link, Line: 174],insert into user_log_link Set `user_logs_id`='449234', `entity`='Agents', `value`='86' ; [08/24/2026 07:28:04], [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/24/2026 07:28:04], [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-24 07:28:04'; [08/24/2026 07:28:04], [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/24/2026 07:28:04], [Script File: agent.php, File: Agent.php, Function: update, Line: 4904],delete from agent_supplier_debug where agent_id='86'; [08/24/2026 07:28:04], [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-24 07:08:04',create_date='2026-08-24 07:08:04'; [08/24/2026 07:28:04], [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-24 07:08:04',create_date='2026-08-24 07:08:04'; [08/24/2026 07:28:04], [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-24 07:08:04',create_date='2026-08-24 07:08:04'; [08/24/2026 07:28:04], [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-24 07:08:04',create_date='2026-08-24 07:08:04'; [08/24/2026 07:28:04], [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-24 07:08:04',create_date='2026-08-24 07:08:04'; [08/24/2026 07:28:04], [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-24 07:08:04',create_date='2026-08-24 07:08:04'; [08/24/2026 07:28:04], [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-24 07:08:04',create_date='2026-08-24 07:08:04'; [08/24/2026 07:28:04], [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-24 07:08:04',create_date='2026-08-24 07:08:04'; [08/24/2026 07:28:04], [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-24 07:08:04',create_date='2026-08-24 07:08:04'; [08/24/2026 07:28:04], [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-24 07:08:04',create_date='2026-08-24 07:08:04'; [08/24/2026 07:28:12], [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= '1',sales_manager_id= '',comp_reg_no= '',allow_quotation= '1',can_allocate_receipt= '1',can_voucher= '1',allow_book_under_cancellation='1',modify_date='2026-08-24 07:28:12',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/24/2026 07:28:12], [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-24 07:28:12',`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= \'1\',sales_manager_id= \'\',comp_reg_no= \'\',allow_quotation= \'1\',can_allocate_receipt= \'1\',can_voucher= \'1\',allow_book_under_cancellation=\'1\',modify_date=\'2026-08-24 07:28:12\',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-24+07%3A28%3A04 changed to - modify_date=2026-08-24+07%3A28%3A12',`ip`= '103.104.226.130'; [08/24/2026 07:28:12], [Script File: agent.php, File: UserLog.php, Function: user_log_link, Line: 174],insert into user_log_link Set `user_logs_id`='449235', `entity`='Agents', `value`='86' ; [08/24/2026 07:28:12], [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/24/2026 07:28:12], [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-24 07:28:12'; [08/24/2026 07:28:12], [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/24/2026 07:28:12], [Script File: agent.php, File: Agent.php, Function: update, Line: 4904],delete from agent_supplier_debug where agent_id='86'; [08/24/2026 07:28:12], [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-24 07:08:12',create_date='2026-08-24 07:08:12'; [08/24/2026 07:28:12], [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-24 07:08:12',create_date='2026-08-24 07:08:12'; [08/24/2026 07:28:12], [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-24 07:08:12',create_date='2026-08-24 07:08:12'; [08/24/2026 07:28:12], [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-24 07:08:12',create_date='2026-08-24 07:08:12'; [08/24/2026 07:28:12], [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-24 07:08:12',create_date='2026-08-24 07:08:12'; [08/24/2026 07:28:12], [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-24 07:08:12',create_date='2026-08-24 07:08:12'; [08/24/2026 07:28:12], [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-24 07:08:12',create_date='2026-08-24 07:08:12'; [08/24/2026 07:28:12], [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-24 07:08:12',create_date='2026-08-24 07:08:12'; [08/24/2026 07:28:12], [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-24 07:08:12',create_date='2026-08-24 07:08:12'; [08/24/2026 07:28:12], [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-24 07:08:12',create_date='2026-08-24 07:08:12'; [08/24/2026 07:31:25], [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-24 07:31:25', ip = '103.104.226.130', action = 'Login', reason = 'Accessed by PSAuser::sujay_qtech' , error_code = 'BACKEND_ACCESSED' ; [08/24/2026 07:31:59], [Script File: hotel_search_list.php, File: hotel_search_list.php, Function: search_hotels, Line: 428],UPDATE keyword_clicks SET total_clicks = '11052' WHERE keyword = 'dubai' and record_type ='City' and record_id='71649'; [08/24/2026 07:31:59], [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/05' , departure_date = '2026/09/06' , nights = '1' , room_types = '[{\"numberofAdults\":\"2\",\"noOfChildren\":\"0\",\"childrenages\":\"0,0\"}]' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2026-08-24 07:31:59' , total_adult = '2', nationality='47', total_children = '0', business_tracking = 'B2B', platform_language = 'en', admin_debug = '1' , site_id = '' , web_service = '0' ; [08/24/2026 07:31:59], [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 ('53852', 'double', '2026-08-24 :07:31:59',''); [08/24/2026 07:32:08], [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 = '53852') + '22412624',duration = '5.098',merge_duration = '0.006',assigned_supplier_count = '1',searched_supplier_count = '1',system_load_1_min = '0.48',system_load_5_min = '0.34',system_load_15_min = '0.33',system_memory_usage = '51.13',parallel_search_count = '1',is_cached = 'no' WHERE id = '53852'_update; [08/24/2026 07:32:40], [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-24 07:32:40', '1433325', 'website', 'go/24_08_2026/request_valuation_Snehal_Test_53852_07_32_38_1787556758.json', 'go/24_08_2026/response_valuation_Snehal_Test_53852_07_32_38_1787556758.json', 'go/24_08_2026/response_valuation_Snehal_Test_53852_07_32_38_1787556758.json'_code, '', '', '', '', '', '', '', 'OT000050226', '', ''); [08/24/2026 07:33:28], [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-24 07:33:28', '1433327', 'website', 'go/24_08_2026/request_valuation_Snehal_Test_53852_07_33_27_1787556807.json', 'go/24_08_2026/response_valuation_Snehal_Test_53852_07_33_27_1787556807.json', 'go/24_08_2026/response_valuation_Snehal_Test_53852_07_33_27_1787556807.json'_code, '', '', '', '', '', '', '', 'OT000050226', '', ''); [08/24/2026 07:35: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= '1',sales_manager_id= '',comp_reg_no= '',allow_quotation= '1',can_allocate_receipt= '1',can_voucher= '',allow_book_under_cancellation='0',modify_date='2026-08-24 07:35: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/24/2026 07:35: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-24 07:35: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= \'1\',sales_manager_id= \'\',comp_reg_no= \'\',allow_quotation= \'1\',can_allocate_receipt= \'1\',can_voucher= ,allow_book_under_cancellation=\'0\',modify_date=\'2026-08-24 07:35: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-24+07%3A28%3A12&can_voucher=1&allow_book_under_cancellation=1&accounts_processed=1 changed to - modify_date=2026-08-24+07%3A35%3A49&can_voucher=&allow_book_under_cancellation=0&accounts_processed=0',`ip`= '103.104.226.130'; [08/24/2026 07:35:49], [Script File: agent.php, File: UserLog.php, Function: user_log_link, Line: 174],insert into user_log_link Set `user_logs_id`='449236', `entity`='Agents', `value`='86' ; [08/24/2026 07:35: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/24/2026 07:35: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-24 07:35:49'; [08/24/2026 07:35: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/24/2026 07:35:49], [Script File: agent.php, File: Agent.php, Function: update, Line: 4904],delete from agent_supplier_debug where agent_id='86'; [08/24/2026 07:35: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-24 07:08:49',create_date='2026-08-24 07:08:49'; [08/24/2026 07:35: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-24 07:08:49',create_date='2026-08-24 07:08:49'; [08/24/2026 07:35: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-24 07:08:49',create_date='2026-08-24 07:08:49'; [08/24/2026 07:35: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-24 07:08:49',create_date='2026-08-24 07:08:49'; [08/24/2026 07:35: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-24 07:08:49',create_date='2026-08-24 07:08:49'; [08/24/2026 07:35: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-24 07:08:49',create_date='2026-08-24 07:08:49'; [08/24/2026 07:35: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-24 07:08:49',create_date='2026-08-24 07:08:49'; [08/24/2026 07:35: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-24 07:08:49',create_date='2026-08-24 07:08:49'; [08/24/2026 07:35: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-24 07:08:49',create_date='2026-08-24 07:08:49'; [08/24/2026 07:35: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-24 07:08:49',create_date='2026-08-24 07:08:49'; [08/24/2026 07:36: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-24 07:36:05', ip = '103.104.226.130', action = 'Login', reason = 'Accessed by PSAuser::sujay_qtech' , error_code = 'BACKEND_ACCESSED' ; [08/24/2026 07:36:27], [Script File: hotel_search_list.php, File: hotel_search_list.php, Function: search_hotels, Line: 428],UPDATE keyword_clicks SET total_clicks = '11053' WHERE keyword = 'dubai' and record_type ='City' and record_id='71649'; [08/24/2026 07:36:27], [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/04' , departure_date = '2026/09/05' , nights = '1' , room_types = '[{\"numberofAdults\":\"2\",\"noOfChildren\":\"0\",\"childrenages\":\"0,0\"}]' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2026-08-24 07:36:27' , total_adult = '2', nationality='47', total_children = '0', business_tracking = 'B2B', platform_language = 'en', admin_debug = '1' , site_id = '' , web_service = '0' ; [08/24/2026 07:36:27], [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 ('53853', 'double', '2026-08-24 :07:36:27',''); [08/24/2026 07:36:34], [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 = '53853') + '22412624',duration = '4.096',merge_duration = '0.005',assigned_supplier_count = '1',searched_supplier_count = '1',system_load_1_min = '0.34',system_load_5_min = '0.34',system_load_15_min = '0.33',system_memory_usage = '50.56',parallel_search_count = '1',is_cached = 'no' WHERE id = '53853'_update; [08/24/2026 07:37:06], [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-24 07:37:06', '1433333', 'website', 'go/24_08_2026/request_valuation_Snehal_Test_53853_07_37_05_1787557025.json', 'go/24_08_2026/response_valuation_Snehal_Test_53853_07_37_05_1787557025.json', 'go/24_08_2026/response_valuation_Snehal_Test_53853_07_37_05_1787557025.json'_code, '', '', '', '', '', '', '', 'OT000050226', '', ''); [08/24/2026 07:40:52], [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-24 07:40:52', '1433335', 'website', 'go/24_08_2026/request_valuation_Snehal_Test_53853_07_40_51_1787557251.json', 'go/24_08_2026/response_valuation_Snehal_Test_53853_07_40_51_1787557251.json', 'go/24_08_2026/response_valuation_Snehal_Test_53853_07_40_51_1787557251.json'_code, '', '', '', '', '', '', '', 'OT000091930', '', ''); [08/24/2026 07:41:48], [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='1',modify_date='2026-08-24 07:41:48',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/24/2026 07:41:48], [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-24 07:41:48',`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=\'1\',modify_date=\'2026-08-24 07:41:48\',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-24+07%3A35%3A49&can_book=1&allow_book_under_cancellation=0&accounts_processed=1 changed to - modify_date=2026-08-24+07%3A41%3A48&can_book=&allow_book_under_cancellation=1&accounts_processed=0',`ip`= '103.104.226.130'; [08/24/2026 07:41:48], [Script File: agent.php, File: UserLog.php, Function: user_log_link, Line: 174],insert into user_log_link Set `user_logs_id`='449237', `entity`='Agents', `value`='86' ; [08/24/2026 07:41:48], [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/24/2026 07:41:48], [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-24 07:41:48'; [08/24/2026 07:41:48], [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/24/2026 07:41:48], [Script File: agent.php, File: Agent.php, Function: update, Line: 4904],delete from agent_supplier_debug where agent_id='86'; [08/24/2026 07:41:48], [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-24 07:08:48',create_date='2026-08-24 07:08:48'; [08/24/2026 07:41:48], [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-24 07:08:48',create_date='2026-08-24 07:08:48'; [08/24/2026 07:41:48], [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-24 07:08:48',create_date='2026-08-24 07:08:48'; [08/24/2026 07:41:48], [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-24 07:08:48',create_date='2026-08-24 07:08:48'; [08/24/2026 07:41:48], [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-24 07:08:48',create_date='2026-08-24 07:08:48'; [08/24/2026 07:41:48], [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-24 07:08:48',create_date='2026-08-24 07:08:48'; [08/24/2026 07:41:48], [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-24 07:08:48',create_date='2026-08-24 07:08:48'; [08/24/2026 07:41:48], [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-24 07:08:48',create_date='2026-08-24 07:08:48'; [08/24/2026 07:41:48], [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-24 07:08:48',create_date='2026-08-24 07:08:48'; [08/24/2026 07:41:48], [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-24 07:08:48',create_date='2026-08-24 07:08:48'; [08/24/2026 07:42:15], [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-24 07:42:15', ip = '103.104.226.130', action = 'Login', reason = 'Accessed by PSAuser::sujay_qtech' , error_code = 'BACKEND_ACCESSED' ; [08/24/2026 07:42:45], [Script File: hotel_search_list.php, File: hotel_search_list.php, Function: search_hotels, Line: 428],UPDATE keyword_clicks SET total_clicks = '11054' WHERE keyword = 'dubai' and record_type ='City' and record_id='71649'; [08/24/2026 07:42:45], [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/10/07' , departure_date = '2026/10/08' , nights = '1' , room_types = '[{\"numberofAdults\":\"2\",\"noOfChildren\":\"0\",\"childrenages\":\"0,0\"}]' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2026-08-24 07:42:45' , total_adult = '2', nationality='47', total_children = '0', business_tracking = 'B2B', platform_language = 'en', admin_debug = '1' , site_id = '' , web_service = '0' ; [08/24/2026 07:42:45], [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 ('53854', 'double', '2026-08-24 :07:42:45',''); [08/24/2026 07:42:53], [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 = '53854') + '22412624',duration = '5.084',merge_duration = '0.005',assigned_supplier_count = '1',searched_supplier_count = '1',system_load_1_min = '0.39',system_load_5_min = '0.37',system_load_15_min = '0.33',system_memory_usage = '50.29',parallel_search_count = '1',is_cached = 'no' WHERE id = '53854'_update; [08/24/2026 07:43:56], [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-24 07:43:56', '1433341', 'website', 'go/24_08_2026/request_valuation_Snehal_Test_53854_07_43_55_1787557435.json', 'go/24_08_2026/response_valuation_Snehal_Test_53854_07_43_55_1787557435.json', 'go/24_08_2026/response_valuation_Snehal_Test_53854_07_43_55_1787557435.json'_code, '', '', '', '', '', '', '', 'OT000076816', '', ''); [08/24/2026 07:44:59], [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-24 07:44:59', '1433343', 'website', 'go/24_08_2026/request_valuation_Snehal_Test_53854_07_44_58_1787557498.json', 'go/24_08_2026/response_valuation_Snehal_Test_53854_07_44_58_1787557498.json', 'go/24_08_2026/response_valuation_Snehal_Test_53854_07_44_58_1787557498.json'_code, '', '', '', '', '', '', '', 'OT000076816', '', ''); [08/24/2026 07:48:01], [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= '1',allow_book_under_cancellation='0',modify_date='2026-08-24 07:48:01',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/24/2026 07:48:01], [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-24 07:48:01',`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= \'1\',allow_book_under_cancellation=\'0\',modify_date=\'2026-08-24 07:48:01\',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-24+07%3A41%3A48&can_voucher=&allow_book_under_cancellation=1&accounts_processed=1 changed to - modify_date=2026-08-24+07%3A48%3A01&can_voucher=1&allow_book_under_cancellation=0&accounts_processed=0',`ip`= '103.104.226.130'; [08/24/2026 07:48:01], [Script File: agent.php, File: UserLog.php, Function: user_log_link, Line: 174],insert into user_log_link Set `user_logs_id`='449238', `entity`='Agents', `value`='86' ; [08/24/2026 07:48:01], [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/24/2026 07:48:01], [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-24 07:48:01'; [08/24/2026 07:48:01], [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/24/2026 07:48:01], [Script File: agent.php, File: Agent.php, Function: update, Line: 4904],delete from agent_supplier_debug where agent_id='86'; [08/24/2026 07:48:01], [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-24 07:08:01',create_date='2026-08-24 07:08:01'; [08/24/2026 07:48:01], [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-24 07:08:01',create_date='2026-08-24 07:08:01'; [08/24/2026 07:48:01], [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-24 07:08:01',create_date='2026-08-24 07:08:01'; [08/24/2026 07:48:01], [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-24 07:08:01',create_date='2026-08-24 07:08:01'; [08/24/2026 07:48:01], [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-24 07:08:01',create_date='2026-08-24 07:08:01'; [08/24/2026 07:48:01], [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-24 07:08:01',create_date='2026-08-24 07:08:01'; [08/24/2026 07:48:01], [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-24 07:08:01',create_date='2026-08-24 07:08:01'; [08/24/2026 07:48:01], [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-24 07:08:01',create_date='2026-08-24 07:08:01'; [08/24/2026 07:48:01], [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-24 07:08:01',create_date='2026-08-24 07:08:01'; [08/24/2026 07:48:01], [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-24 07:08:01',create_date='2026-08-24 07:08:01'; [08/24/2026 07:48:09], [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= '1',allow_book_under_cancellation='0',modify_date='2026-08-24 07:48:09',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/24/2026 07:48:09], [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-24 07:48:09',`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= \'1\',allow_book_under_cancellation=\'0\',modify_date=\'2026-08-24 07:48:09\',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-24+07%3A48%3A01 changed to - modify_date=2026-08-24+07%3A48%3A09',`ip`= '103.104.226.130'; [08/24/2026 07:48:09], [Script File: agent.php, File: UserLog.php, Function: user_log_link, Line: 174],insert into user_log_link Set `user_logs_id`='449239', `entity`='Agents', `value`='86' ; [08/24/2026 07:48:09], [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/24/2026 07:48:09], [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-24 07:48:09'; [08/24/2026 07:48:09], [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/24/2026 07:48:09], [Script File: agent.php, File: Agent.php, Function: update, Line: 4904],delete from agent_supplier_debug where agent_id='86'; [08/24/2026 07:48:09], [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-24 07:08:09',create_date='2026-08-24 07:08:09'; [08/24/2026 07:48:09], [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-24 07:08:09',create_date='2026-08-24 07:08:09'; [08/24/2026 07:48:09], [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-24 07:08:09',create_date='2026-08-24 07:08:09'; [08/24/2026 07:48:09], [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-24 07:08:09',create_date='2026-08-24 07:08:09'; [08/24/2026 07:48:09], [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-24 07:08:09',create_date='2026-08-24 07:08:09'; [08/24/2026 07:48:09], [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-24 07:08:09',create_date='2026-08-24 07:08:09'; [08/24/2026 07:48:09], [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-24 07:08:09',create_date='2026-08-24 07:08:09'; [08/24/2026 07:48:09], [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-24 07:08:09',create_date='2026-08-24 07:08:09'; [08/24/2026 07:48:09], [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-24 07:08:09',create_date='2026-08-24 07:08:09'; [08/24/2026 07:48:09], [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-24 07:08:09',create_date='2026-08-24 07:08:09'; [08/24/2026 07:48:25], [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-24 07:48:25', ip = '103.104.226.130', action = 'Login', reason = 'Accessed by PSAuser::sujay_qtech' , error_code = 'BACKEND_ACCESSED' ; [08/24/2026 07:50:21], [Script File: hotel_search_list.php, File: hotel_search_list.php, Function: search_hotels, Line: 428],UPDATE keyword_clicks SET total_clicks = '55' WHERE keyword = 'mumbai' and record_type ='City' and record_id='64440'; [08/24/2026 07:51:06], [Script File: hotel_search_list.php, File: hotel_search_list.php, Function: search_hotels, Line: 428],UPDATE keyword_clicks SET total_clicks = '508' WHERE keyword = 'london' and record_type ='City' and record_id='63265'; [08/24/2026 07:51:51], [Script File: hotel_search_list.php, File: hotel_search_list.php, Function: search_hotels, Line: 428],UPDATE keyword_clicks SET total_clicks = '11055' WHERE keyword = 'dubai' and record_type ='City' and record_id='71649'; [08/24/2026 07:52:39], [Script File: agent.php, File: Agent.php, Function: update, Line: 4636],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= '1',allow_book_under_cancellation='0',modify_date='2026-08-24 07:52:39',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/24/2026 07:52:39], [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-24 07:52:39',`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= \'1\',allow_book_under_cancellation=\'0\',modify_date=\'2026-08-24 07:52:39\',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-24+07%3A48%3A09&accounts_processed=1 changed to - modify_date=2026-08-24+07%3A52%3A39&accounts_processed=0',`ip`= '103.104.226.130'; [08/24/2026 07:52:39], [Script File: agent.php, File: UserLog.php, Function: user_log_link, Line: 174],insert into user_log_link Set `user_logs_id`='449240', `entity`='Agents', `value`='86' ; [08/24/2026 07:52:39], [Script File: agent.php, File: Agent.php, Function: update, Line: 4741],UPDATE agents SET cd_credit_limit=credit_limit-'86' , cd_credit_value=cd_credit_limit-cd_credit_usage WHERE id= ?; [08/24/2026 07:52:39], [Script File: agent.php, File: Agent.php, Function: agent_credit_log, Line: 5809],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-24 07:52:39'; [08/24/2026 07:52:39], [Script File: agent.php, File: Agent.php, Function: update, Line: 4816],UPDATE agents SET currency= '11',branch_id= '1',profile= '', agent_type= 'CC' WHERE parent_agent= '86'; [08/24/2026 07:52:39], [Script File: agent.php, File: Agent.php, Function: update, Line: 4837],delete from agent_supplier_debug where agent_id='86'; [08/24/2026 07:52:39], [Script File: agent.php, File: Agent.php, Function: update, Line: 4851],insert into agent_supplier_debug SET agent_id= '86',supplier= '298',supplier_type= 'Hotel',modify_date='2026-08-24 07:08:39',create_date='2026-08-24 07:08:39'; [08/24/2026 07:52:39], [Script File: agent.php, File: Agent.php, Function: update, Line: 4851],insert into agent_supplier_debug SET agent_id= '86',supplier= '309',supplier_type= 'Hotel',modify_date='2026-08-24 07:08:39',create_date='2026-08-24 07:08:39'; [08/24/2026 07:52:39], [Script File: agent.php, File: Agent.php, Function: update, Line: 4851],insert into agent_supplier_debug SET agent_id= '86',supplier= '301',supplier_type= 'Hotel',modify_date='2026-08-24 07:08:39',create_date='2026-08-24 07:08:39'; [08/24/2026 07:52:39], [Script File: agent.php, File: Agent.php, Function: update, Line: 4851],insert into agent_supplier_debug SET agent_id= '86',supplier= '302',supplier_type= 'Hotel',modify_date='2026-08-24 07:08:39',create_date='2026-08-24 07:08:39'; [08/24/2026 07:52:39], [Script File: agent.php, File: Agent.php, Function: update, Line: 4851],insert into agent_supplier_debug SET agent_id= '86',supplier= '310',supplier_type= 'Hotel',modify_date='2026-08-24 07:08:39',create_date='2026-08-24 07:08:39'; [08/24/2026 07:52:39], [Script File: agent.php, File: Agent.php, Function: update, Line: 4851],insert into agent_supplier_debug SET agent_id= '86',supplier= '311',supplier_type= 'Hotel',modify_date='2026-08-24 07:08:39',create_date='2026-08-24 07:08:39'; [08/24/2026 07:52:39], [Script File: agent.php, File: Agent.php, Function: update, Line: 4851],insert into agent_supplier_debug SET agent_id= '86',supplier= '307',supplier_type= 'Hotel',modify_date='2026-08-24 07:08:39',create_date='2026-08-24 07:08:39'; [08/24/2026 07:52:39], [Script File: agent.php, File: Agent.php, Function: update, Line: 4851],insert into agent_supplier_debug SET agent_id= '86',supplier= '308',supplier_type= 'Hotel',modify_date='2026-08-24 07:08:39',create_date='2026-08-24 07:08:39'; [08/24/2026 07:52:39], [Script File: agent.php, File: Agent.php, Function: update, Line: 4851],insert into agent_supplier_debug SET agent_id= '86',supplier= '20',supplier_type= 'Hotel',modify_date='2026-08-24 07:08:39',create_date='2026-08-24 07:08:39'; [08/24/2026 07:52:39], [Script File: agent.php, File: Agent.php, Function: update, Line: 4851],insert into agent_supplier_debug SET agent_id= '86',supplier= '306',supplier_type= 'Hotel',modify_date='2026-08-24 07:08:39',create_date='2026-08-24 07:08:39'; [08/24/2026 07:52:55], [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-24 07:52:55', ip = '103.104.226.130', action = 'Login', reason = 'Accessed by PSAuser::sujay_qtech' , error_code = 'BACKEND_ACCESSED' ; [08/24/2026 07:53:17], [Script File: hotel_search_list.php, File: hotel_search_list.php, Function: search_hotels, Line: 428],UPDATE keyword_clicks SET total_clicks = '11056' WHERE keyword = 'dubai' and record_type ='City' and record_id='71649'; [08/24/2026 07:53:17], [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/05' , departure_date = '2026/09/06' , nights = '1' , room_types = '[{\"numberofAdults\":\"2\",\"noOfChildren\":\"0\",\"childrenages\":\"0,0\"}]' , room_type='[{"numberOfAdults":2}]' , available='1' , create_date = '2026-08-24 07:53:17' , total_adult = '2', nationality='47', total_children = '0', business_tracking = 'B2B', platform_language = 'en', admin_debug = '1' , site_id = '' , web_service = '0' ; [08/24/2026 07:53:17], [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 ('53855', 'double', '2026-08-24 :07:53:17',''); [08/24/2026 07:53:25], [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 = '53855') + '22405504',duration = '5.106',merge_duration = '0.005',assigned_supplier_count = '1',searched_supplier_count = '1',system_load_1_min = '0.34',system_load_5_min = '0.41',system_load_15_min = '0.40',system_memory_usage = '51.02',parallel_search_count = '1',is_cached = 'no' WHERE id = '53855'_update; [08/24/2026 07:53:50], [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-24 07:53:50', '1433349', 'website', 'go/24_08_2026/request_valuation_Snehal_Test_53855_07_53_49_1787558029.json', 'go/24_08_2026/response_valuation_Snehal_Test_53855_07_53_49_1787558029.json', 'go/24_08_2026/response_valuation_Snehal_Test_53855_07_53_49_1787558029.json'_code, '', '', '', '', '', '', '', 'OT000580896', '', ''); [08/24/2026 07:54:45], [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-24 07:54:45', '1433351', 'website', 'go/24_08_2026/request_valuation_Snehal_Test_53855_07_54_36_1787558076.json', 'go/24_08_2026/response_valuation_Snehal_Test_53855_07_54_36_1787558076.json', 'go/24_08_2026/response_valuation_Snehal_Test_53855_07_54_36_1787558076.json'_code, '', '', '', '', '', '', '', 'OT000050226', '', ''); [08/24/2026 07:58:43], [Script File: agent.php, File: Agent.php, Function: set_priority, Line: 1959],DELETE FROM agent_supplier_settings WHERE 1 and agent_id= ? ; [08/24/2026 07:58:43], [Script File: agent.php, File: Agent.php, Function: set_priority, Line: 1993],INSERT INTO agent_supplier_settings SET agent_id = '86',supplier_id = '309' ,status = '' ,priority = '24' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '24'; [08/24/2026 07:58:43], [Script File: agent.php, File: Agent.php, Function: set_priority, Line: 1993],INSERT INTO agent_supplier_settings SET agent_id = '86',supplier_id = '301' ,status = '' ,priority = '24' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '24'; [08/24/2026 07:58:43], [Script File: agent.php, File: Agent.php, Function: set_priority, Line: 1993],INSERT INTO agent_supplier_settings SET agent_id = '86',supplier_id = '302' ,status = '' ,priority = '24' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '24'; [08/24/2026 07:58:43], [Script File: agent.php, File: Agent.php, Function: set_priority, Line: 1993],INSERT INTO agent_supplier_settings SET agent_id = '86',supplier_id = '310' ,status = '' ,priority = '24' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '24'; [08/24/2026 07:58:43], [Script File: agent.php, File: Agent.php, Function: set_priority, Line: 1993],INSERT INTO agent_supplier_settings SET agent_id = '86',supplier_id = '311' ,status = '' ,priority = '24' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '24'; [08/24/2026 07:58:43], [Script File: agent.php, File: Agent.php, Function: set_priority, Line: 1993],INSERT INTO agent_supplier_settings SET agent_id = '86',supplier_id = '307' ,status = '' ,priority = '24' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '24'; [08/24/2026 07:58:43], [Script File: agent.php, File: Agent.php, Function: set_priority, Line: 1993],INSERT INTO agent_supplier_settings SET agent_id = '86',supplier_id = '308' ,status = '1' ,priority = '24' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '24'; [08/24/2026 07:58:43], [Script File: agent.php, File: Agent.php, Function: set_priority, Line: 1993],INSERT INTO agent_supplier_settings SET agent_id = '86',supplier_id = '20' ,status = '' ,priority = '24' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '24'; [08/24/2026 07:58:43], [Script File: agent.php, File: Agent.php, Function: set_priority, Line: 1993],INSERT INTO agent_supplier_settings SET agent_id = '86',supplier_id = '298' ,status = '' ,priority = '24' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '24'; [08/24/2026 07:58:43], [Script File: agent.php, File: Agent.php, Function: set_priority, Line: 1993],INSERT INTO agent_supplier_settings SET agent_id = '86',supplier_id = '299' ,status = '' ,priority = '24' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '24'; [08/24/2026 07:58:43], [Script File: agent.php, File: Agent.php, Function: set_priority, Line: 1993],INSERT INTO agent_supplier_settings SET agent_id = '86',supplier_id = '306' ,status = '' ,priority = '24' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '24'; [08/24/2026 07:58:43], [Script File: agent.php, File: Agent.php, Function: set_priority, Line: 1993],INSERT INTO agent_supplier_settings SET agent_id = '86',supplier_id = '92' ,status = '' ,priority = '24' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '24'; [08/24/2026 07:58:43], [Script File: agent.php, File: Agent.php, Function: set_priority, Line: 1993],INSERT INTO agent_supplier_settings SET agent_id = '86',supplier_id = '304' ,status = '' ,priority = '24' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '24'; [08/24/2026 07:58:43], [Script File: agent.php, File: Agent.php, Function: set_priority, Line: 1993],INSERT INTO agent_supplier_settings SET agent_id = '86',supplier_id = '303' ,status = '' ,priority = '24' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '24'; [08/24/2026 07:58:43], [Script File: agent.php, File: Agent.php, Function: set_priority, Line: 1993],INSERT INTO agent_supplier_settings SET agent_id = '86',supplier_id = '300' ,status = '' ,priority = '24' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '24'; [08/24/2026 07:58:43], [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-24 07:58:43',`log_type`= 'Agent Supplier settings',`sql_query`= '======INSERT INTO agent_supplier_settings SET agent_id = \'86\',supplier_id = 309 ,status = \'\' ,priority = \'24\' ,lead_time = \'96\',branch_id = \'\',visible_supplier_on_voucher = \'0\',pricing_profile_id = \'24\'======INSERT INTO agent_supplier_settings SET agent_id = \'86\',supplier_id = 301 ,status = \'\' ,priority = \'24\' ,lead_time = \'96\',branch_id = \'\',visible_supplier_on_voucher = \'0\',pricing_profile_id = \'24\'======INSERT INTO agent_supplier_settings SET agent_id = \'86\',supplier_id = 302 ,status = \'\' ,priority = \'24\' ,lead_time = \'96\',branch_id = \'\',visible_supplier_on_voucher = \'0\',pricing_profile_id = \'24\'======INSERT INTO agent_supplier_settings SET agent_id = \'86\',supplier_id = 310 ,status = \'\' ,priority = \'24\' ,lead_time = \'96\',branch_id = \'\',visible_supplier_on_voucher = \'0\',pricing_profile_id = \'24\'======INSERT INTO agent_supplier_settings SET agent_id = \'86\',supplier_id = 311 ,status = \'\' ,priority = \'24\' ,lead_time = \'0\',branch_id = \'\',visible_supplier_on_voucher = \'0\',pricing_profile_id = \'24\'======INSERT INTO agent_supplier_settings SET agent_id = \'86\',supplier_id = 307 ,status = \'\' ,priority = \'24\' ,lead_time = \'96\',branch_id = \'\',visible_supplier_on_voucher = \'0\',pricing_profile_id = \'24\'======INSERT INTO agent_supplier_settings SET agent_id = \'86\',supplier_id = 308 ,status = \'1\' ,priority = \'24\' ,lead_time = \'96\',branch_id = \'\',visible_supplier_on_voucher = \'0\',pricing_profile_id = \'24\'======INSERT INTO agent_supplier_settings SET agent_id = \'86\',supplier_id = 20 ,status = \'\' ,priority = \'24\' ,lead_time = \'96\',branch_id = \'\',visible_supplier_on_voucher = \'0\',pricing_profile_id = \'24\'======INSERT INTO agent_supplier_settings SET agent_id = \'86\',supplier_id = 298 ,status = \'\' ,priority = \'24\' ,lead_time = \'96\',branch_id = \'\',visible_supplier_on_voucher = \'0\',pricing_profile_id = \'24\'======INSERT INTO agent_supplier_settings SET agent_id = \'86\',supplier_id = 299 ,status = \'\' ,priority = \'24\' ,lead_time = \'96\',branch_id = \'\',visible_supplier_on_voucher = \'0\',pricing_profile_id = \'24\'======INSERT INTO agent_supplier_settings SET agent_id = \'86\',supplier_id = 306 ,status = \'\' ,priority = \'24\' ,lead_time = \'96\',branch_id = \'\',visible_supplier_on_voucher = \'0\',pricing_profile_id = \'24\'======INSERT INTO agent_supplier_settings SET agent_id = \'86\',supplier_id = 92 ,status = \'\' ,priority = \'24\' ,lead_time = \'96\',branch_id = \'\',visible_supplier_on_voucher = \'0\',pricing_profile_id = \'24\'======INSERT INTO agent_supplier_settings SET agent_id = \'86\',supplier_id = 304 ,status = \'\' ,priority = \'24\' ,lead_time = \'96\',branch_id = \'\',visible_supplier_on_voucher = \'0\',pricing_profile_id = \'24\'======INSERT INTO agent_supplier_settings SET agent_id = \'86\',supplier_id = 303 ,status = \'\' ,priority = \'24\' ,lead_time = \'96\',branch_id = \'\',visible_supplier_on_voucher = \'0\',pricing_profile_id = \'24\'======INSERT INTO agent_supplier_settings SET agent_id = \'86\',supplier_id = 300 ,status = \'\' ,priority = \'24\' ,lead_time = \'96\',branch_id = \'\',visible_supplier_on_voucher = \'0\',pricing_profile_id = \'24\'',`log_description`= 'Supplier setting updated Previous data-- agent_id-86 ## supplier_id- 20 ## company_name - Hotelbeds ## supplier_code-hotelbeds ## percentage - 0.00 ## lead_time - 96 ',`ip`= '103.104.226.130'; [08/24/2026 07:58:43], [Script File: agent.php, File: UserLog.php, Function: user_log_link, Line: 174],insert into user_log_link Set `user_logs_id`='449241', `entity`='Agents', `value`='86' ; [08/24/2026 07:58:56], [Script File: agent.php, File: Agent.php, Function: set_priority, Line: 1959],DELETE FROM agent_supplier_settings WHERE 1 and agent_id= ? ; [08/24/2026 07:58:56], [Script File: agent.php, File: Agent.php, Function: set_priority, Line: 1993],INSERT INTO agent_supplier_settings SET agent_id = '86',supplier_id = '309' ,status = '' ,priority = '24' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '24'; [08/24/2026 07:58:56], [Script File: agent.php, File: Agent.php, Function: set_priority, Line: 1993],INSERT INTO agent_supplier_settings SET agent_id = '86',supplier_id = '301' ,status = '' ,priority = '24' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '24'; [08/24/2026 07:58:56], [Script File: agent.php, File: Agent.php, Function: set_priority, Line: 1993],INSERT INTO agent_supplier_settings SET agent_id = '86',supplier_id = '302' ,status = '' ,priority = '24' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '24'; [08/24/2026 07:58:56], [Script File: agent.php, File: Agent.php, Function: set_priority, Line: 1993],INSERT INTO agent_supplier_settings SET agent_id = '86',supplier_id = '310' ,status = '' ,priority = '24' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '24'; [08/24/2026 07:58:56], [Script File: agent.php, File: Agent.php, Function: set_priority, Line: 1993],INSERT INTO agent_supplier_settings SET agent_id = '86',supplier_id = '311' ,status = '' ,priority = '24' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '24'; [08/24/2026 07:58:56], [Script File: agent.php, File: Agent.php, Function: set_priority, Line: 1993],INSERT INTO agent_supplier_settings SET agent_id = '86',supplier_id = '307' ,status = '' ,priority = '24' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '24'; [08/24/2026 07:58:56], [Script File: agent.php, File: Agent.php, Function: set_priority, Line: 1993],INSERT INTO agent_supplier_settings SET agent_id = '86',supplier_id = '308' ,status = '1' ,priority = '24' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '24'; [08/24/2026 07:58:56], [Script File: agent.php, File: Agent.php, Function: set_priority, Line: 1993],INSERT INTO agent_supplier_settings SET agent_id = '86',supplier_id = '20' ,status = '' ,priority = '24' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '24'; [08/24/2026 07:58:56], [Script File: agent.php, File: Agent.php, Function: set_priority, Line: 1993],INSERT INTO agent_supplier_settings SET agent_id = '86',supplier_id = '298' ,status = '' ,priority = '24' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '24'; [08/24/2026 07:58:56], [Script File: agent.php, File: Agent.php, Function: set_priority, Line: 1993],INSERT INTO agent_supplier_settings SET agent_id = '86',supplier_id = '299' ,status = '' ,priority = '24' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '24'; [08/24/2026 07:58:56], [Script File: agent.php, File: Agent.php, Function: set_priority, Line: 1993],INSERT INTO agent_supplier_settings SET agent_id = '86',supplier_id = '306' ,status = '' ,priority = '24' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '24'; [08/24/2026 07:58:56], [Script File: agent.php, File: Agent.php, Function: set_priority, Line: 1993],INSERT INTO agent_supplier_settings SET agent_id = '86',supplier_id = '92' ,status = '' ,priority = '24' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '24'; [08/24/2026 07:58:56], [Script File: agent.php, File: Agent.php, Function: set_priority, Line: 1993],INSERT INTO agent_supplier_settings SET agent_id = '86',supplier_id = '304' ,status = '' ,priority = '24' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '24'; [08/24/2026 07:58:56], [Script File: agent.php, File: Agent.php, Function: set_priority, Line: 1993],INSERT INTO agent_supplier_settings SET agent_id = '86',supplier_id = '303' ,status = '' ,priority = '24' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '24'; [08/24/2026 07:58:56], [Script File: agent.php, File: Agent.php, Function: set_priority, Line: 1993],INSERT INTO agent_supplier_settings SET agent_id = '86',supplier_id = '300' ,status = '' ,priority = '24' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '24'; [08/24/2026 07:58:56], [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-24 07:58:56',`log_type`= 'Agent Supplier settings',`sql_query`= '======INSERT INTO agent_supplier_settings SET agent_id = \'86\',supplier_id = 309 ,status = \'\' ,priority = \'24\' ,lead_time = \'96\',branch_id = \'\',visible_supplier_on_voucher = \'0\',pricing_profile_id = \'24\'======INSERT INTO agent_supplier_settings SET agent_id = \'86\',supplier_id = 301 ,status = \'\' ,priority = \'24\' ,lead_time = \'96\',branch_id = \'\',visible_supplier_on_voucher = \'0\',pricing_profile_id = \'24\'======INSERT INTO agent_supplier_settings SET agent_id = \'86\',supplier_id = 302 ,status = \'\' ,priority = \'24\' ,lead_time = \'96\',branch_id = \'\',visible_supplier_on_voucher = \'0\',pricing_profile_id = \'24\'======INSERT INTO agent_supplier_settings SET agent_id = \'86\',supplier_id = 310 ,status = \'\' ,priority = \'24\' ,lead_time = \'96\',branch_id = \'\',visible_supplier_on_voucher = \'0\',pricing_profile_id = \'24\'======INSERT INTO agent_supplier_settings SET agent_id = \'86\',supplier_id = 311 ,status = \'\' ,priority = \'24\' ,lead_time = \'0\',branch_id = \'\',visible_supplier_on_voucher = \'0\',pricing_profile_id = \'24\'======INSERT INTO agent_supplier_settings SET agent_id = \'86\',supplier_id = 307 ,status = \'\' ,priority = \'24\' ,lead_time = \'96\',branch_id = \'\',visible_supplier_on_voucher = \'0\',pricing_profile_id = \'24\'======INSERT INTO agent_supplier_settings SET agent_id = \'86\',supplier_id = 308 ,status = \'1\' ,priority = \'24\' ,lead_time = \'96\',branch_id = \'\',visible_supplier_on_voucher = \'0\',pricing_profile_id = \'24\'======INSERT INTO agent_supplier_settings SET agent_id = \'86\',supplier_id = 20 ,status = \'\' ,priority = \'24\' ,lead_time = \'96\',branch_id = \'\',visible_supplier_on_voucher = \'0\',pricing_profile_id = \'24\'======INSERT INTO agent_supplier_settings SET agent_id = \'86\',supplier_id = 298 ,status = \'\' ,priority = \'24\' ,lead_time = \'96\',branch_id = \'\',visible_supplier_on_voucher = \'0\',pricing_profile_id = \'24\'======INSERT INTO agent_supplier_settings SET agent_id = \'86\',supplier_id = 299 ,status = \'\' ,priority = \'24\' ,lead_time = \'96\',branch_id = \'\',visible_supplier_on_voucher = \'0\',pricing_profile_id = \'24\'======INSERT INTO agent_supplier_settings SET agent_id = \'86\',supplier_id = 306 ,status = \'\' ,priority = \'24\' ,lead_time = \'96\',branch_id = \'\',visible_supplier_on_voucher = \'0\',pricing_profile_id = \'24\'======INSERT INTO agent_supplier_settings SET agent_id = \'86\',supplier_id = 92 ,status = \'\' ,priority = \'24\' ,lead_time = \'96\',branch_id = \'\',visible_supplier_on_voucher = \'0\',pricing_profile_id = \'24\'======INSERT INTO agent_supplier_settings SET agent_id = \'86\',supplier_id = 304 ,status = \'\' ,priority = \'24\' ,lead_time = \'96\',branch_id = \'\',visible_supplier_on_voucher = \'0\',pricing_profile_id = \'24\'======INSERT INTO agent_supplier_settings SET agent_id = \'86\',supplier_id = 303 ,status = \'\' ,priority = \'24\' ,lead_time = \'96\',branch_id = \'\',visible_supplier_on_voucher = \'0\',pricing_profile_id = \'24\'======INSERT INTO agent_supplier_settings SET agent_id = \'86\',supplier_id = 300 ,status = \'\' ,priority = \'24\' ,lead_time = \'96\',branch_id = \'\',visible_supplier_on_voucher = \'0\',pricing_profile_id = \'24\'',`log_description`= 'Supplier setting updated Previous data-- agent_id-86 ## supplier_id- 308 ## company_name - Expedia Package ## supplier_code-expediapackage ## percentage - 0.00 ## lead_time - 96 ',`ip`= '103.104.226.130'; [08/24/2026 07:58:56], [Script File: agent.php, File: UserLog.php, Function: user_log_link, Line: 174],insert into user_log_link Set `user_logs_id`='449242', `entity`='Agents', `value`='86' ; [08/24/2026 07:59:06], [Script File: agent.php, File: Agent.php, Function: update, Line: 4636],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= '1',allow_book_under_cancellation='0',modify_date='2026-08-24 07:59:06',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/24/2026 07:59:06], [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-24 07:59:06',`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= \'1\',allow_book_under_cancellation=\'0\',modify_date=\'2026-08-24 07:59:06\',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-24+07%3A52%3A39&accounts_processed=1 changed to - modify_date=2026-08-24+07%3A59%3A06&accounts_processed=0',`ip`= '103.104.226.130'; [08/24/2026 07:59:06], [Script File: agent.php, File: UserLog.php, Function: user_log_link, Line: 174],insert into user_log_link Set `user_logs_id`='449243', `entity`='Agents', `value`='86' ; [08/24/2026 07:59:06], [Script File: agent.php, File: Agent.php, Function: update, Line: 4741],UPDATE agents SET cd_credit_limit=credit_limit-'86' , cd_credit_value=cd_credit_limit-cd_credit_usage WHERE id= ?; [08/24/2026 07:59:06], [Script File: agent.php, File: Agent.php, Function: agent_credit_log, Line: 5809],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-24 07:59:06'; [08/24/2026 07:59:06], [Script File: agent.php, File: Agent.php, Function: update, Line: 4816],UPDATE agents SET currency= '11',branch_id= '1',profile= '', agent_type= 'CC' WHERE parent_agent= '86'; [08/24/2026 07:59:06], [Script File: agent.php, File: Agent.php, Function: update, Line: 4837],delete from agent_supplier_debug where agent_id='86'; [08/24/2026 07:59:06], [Script File: agent.php, File: Agent.php, Function: update, Line: 4851],insert into agent_supplier_debug SET agent_id= '86',supplier= '298',supplier_type= 'Hotel',modify_date='2026-08-24 07:08:06',create_date='2026-08-24 07:08:06'; [08/24/2026 07:59:06], [Script File: agent.php, File: Agent.php, Function: update, Line: 4851],insert into agent_supplier_debug SET agent_id= '86',supplier= '309',supplier_type= 'Hotel',modify_date='2026-08-24 07:08:06',create_date='2026-08-24 07:08:06'; [08/24/2026 07:59:06], [Script File: agent.php, File: Agent.php, Function: update, Line: 4851],insert into agent_supplier_debug SET agent_id= '86',supplier= '301',supplier_type= 'Hotel',modify_date='2026-08-24 07:08:06',create_date='2026-08-24 07:08:06'; [08/24/2026 07:59:06], [Script File: agent.php, File: Agent.php, Function: update, Line: 4851],insert into agent_supplier_debug SET agent_id= '86',supplier= '302',supplier_type= 'Hotel',modify_date='2026-08-24 07:08:06',create_date='2026-08-24 07:08:06'; [08/24/2026 07:59:06], [Script File: agent.php, File: Agent.php, Function: update, Line: 4851],insert into agent_supplier_debug SET agent_id= '86',supplier= '310',supplier_type= 'Hotel',modify_date='2026-08-24 07:08:06',create_date='2026-08-24 07:08:06'; [08/24/2026 07:59:06], [Script File: agent.php, File: Agent.php, Function: update, Line: 4851],insert into agent_supplier_debug SET agent_id= '86',supplier= '311',supplier_type= 'Hotel',modify_date='2026-08-24 07:08:06',create_date='2026-08-24 07:08:06'; [08/24/2026 07:59:06], [Script File: agent.php, File: Agent.php, Function: update, Line: 4851],insert into agent_supplier_debug SET agent_id= '86',supplier= '307',supplier_type= 'Hotel',modify_date='2026-08-24 07:08:06',create_date='2026-08-24 07:08:06'; [08/24/2026 07:59:06], [Script File: agent.php, File: Agent.php, Function: update, Line: 4851],insert into agent_supplier_debug SET agent_id= '86',supplier= '308',supplier_type= 'Hotel',modify_date='2026-08-24 07:08:06',create_date='2026-08-24 07:08:06'; [08/24/2026 07:59:06], [Script File: agent.php, File: Agent.php, Function: update, Line: 4851],insert into agent_supplier_debug SET agent_id= '86',supplier= '20',supplier_type= 'Hotel',modify_date='2026-08-24 07:08:06',create_date='2026-08-24 07:08:06'; [08/24/2026 07:59:06], [Script File: agent.php, File: Agent.php, Function: update, Line: 4851],insert into agent_supplier_debug SET agent_id= '86',supplier= '306',supplier_type= 'Hotel',modify_date='2026-08-24 07:08:06',create_date='2026-08-24 07:08:06'; [08/24/2026 07:59:23], [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-24 07:59:23', ip = '103.104.226.130', action = 'Login', reason = 'Accessed by PSAuser::sujay_qtech' , error_code = 'BACKEND_ACCESSED' ; [08/24/2026 07:59:39], [Script File: hotel_search_list.php, File: hotel_search_list.php, Function: search_hotels, Line: 428],UPDATE keyword_clicks SET total_clicks = '509' WHERE keyword = 'london' and record_type ='City' and record_id='63265';