5 commits

Author	SHA1	Message	Date
Peter Goodhall	4440582389	Sanitize IDs and migrate SQL to Query Builder ... Replace ad-hoc xss_clean calls with explicit casting and stronger type checks for ID/parameter handling, and convert many raw SQL strings to CodeIgniter Query Builder usage. Added normalize_location_ids helpers (Activators_model, Oqrs_model) to safely parse location lists and used where_in/parameter binding/escaping to avoid injection and improve maintainability. Also adjusted session user_id handling, improved LIKE/DATE/TIMEDIFF usage, and tightened several model/controller methods (Labels, Activators, Bands, Contesting, Labels_model, Modes, Oqrs_model, Qsl_model, Setup_model, Sstv_model, User_model) for safer, clearer DB queries and inputs.	2026-06-24 22:15:31 +01:00
Peter Goodhall	1583590ecf	Improve logbook ownership checks and permissions ... Updated Logbooks controller to use profile_clean for station lookup and added a notice for missing stations. Enhanced Setup_model to count logbooks a user owns or has permissions for, ensuring accurate logbook statistics for users with shared access. Fixes #3389	2025-12-20 21:50:21 +00:00
Peter Goodhall	046dc4b4ef	Optimize dashboard data retrieval with consolidated queries ... Replaced multiple individual queries in Dashboard controller with consolidated methods for setup counts and country statistics. Added getAllSetupCounts to Setup_model and get_countries_statistics_consolidated to Logbook_model to improve performance and reduce database load.	2025-08-09 21:24:35 +01:00
phl0	5b7a31fe11	count rows returns 1 even with 0 as result ...	2023-10-31 08:29:12 +01:00
Andreas	70504c5022	[Dashboard] Added some warnings	2023-10-30 12:15:08 +01:00