Commit graph

5 commits

Author SHA1 Message Date
Peter Goodhall
35369a0996 Merge activator call variants
Canonicalize activator callsigns and combine results for variant forms such as portable suffixes and MM/MW prefixes. This updates activator listings, max-grid counts, and contact details to aggregate grids across matching calls while keeping the table output consistently sorted.
2026-07-17 13:49:42 +01:00
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
Andreas
9b787bbb1f Fixed hardcoding of tables 2023-01-28 15:21:09 +01:00
phl0
723adabe8f
Remove regex (to be compatible with earlier mySQL) 2022-03-27 12:17:35 +02:00
phl0
22e74b55e4
Add table for (VUCC) gridsquare activators top list
Squashed commit of the following:

commit 1091c0321e49b37f29d2997ff28051f137efc53f
Author: phl0 <florian@florian-wolters.de>
Date:   Tue Mar 22 17:31:08 2022 +0100

    Also take VUCC_GRIDS into account

commit c396e87c78e659c98c86ebf96ce21ba9a34203d0
Author: phl0 <florian@florian-wolters.de>
Date:   Thu Jan 27 23:19:39 2022 +0100

    Add ShowQSO function for detailed view

commit 52d3ef9b60de6a82c9239e6be387aa35050db203
Author: phl0 <florian@florian-wolters.de>
Date:   Thu Jan 27 20:59:58 2022 +0100

    Distinguish between LEO and GEO in SAT selection

commit 019d1d71bf3f06abbd38c65b0278c52c785bf407
Author: phl0 <florian@florian-wolters.de>
Date:   Thu Jan 27 19:57:48 2022 +0100

    Make sure mincount is numeric

commit 3802f9269d7e6bae7891e814909bd364afbfdf73
Author: phl0 <florian@florian-wolters.de>
Date:   Thu Jan 27 00:37:35 2022 +0100

    Implement optional minimin grid count

commit d206f2429d2bbaab1336c2266e7036e2ea77718d
Author: phl0 <florian@florian-wolters.de>
Date:   Wed Jan 26 23:21:55 2022 +0100

    Add table showing gridsquare activators
2022-03-22 17:41:03 +01:00