Commit graph

28 commits

Author SHA1 Message Date
Peter Goodhall
a56f1b8773 Added EME to DXCC Awards page 2026-07-21 13:16:10 +01:00
Peter Goodhall
c6bdee1bc5 Sanitize location lists and harden SQL
Replace string-quoted station_id lists with comma-separated, integer-casted lists and harden SQL across awards models. This diff converts constructions like "'a','b'" to implode(',', array_map('intval', ...)) and uses $this->db->escape_str() for band/mode values and band lists to reduce injection/format issues. Added helper methods (addModeToQuery, addBandToQuery variants) to centralize mode/band filtering, parameterized time/mode/band queries in Gmdxsummer_model, and escaped band arrays when building IN() lists. Also added null/empty-checks for logbook arrays in several models and small refactors (e.g. VUCC addBandToQuery) to keep SQL building consistent.
2026-06-24 22:26:11 +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
Peter Goodhall
2a2f62ccbc Add filtering and localization to WAB award view
Introduces band, mode, and confirmed-only filters to the Worked All Britain (WAB) award view and details AJAX endpoint. Updates the controller, model, and view logic to support filtering, and adds new localized strings for WAB award UI elements in multiple languages. Also ensures the correct script is loaded for the WAB section and improves the Bands model to check for field existence before filtering by award.
2026-01-21 16:54:24 +00:00
Peter Goodhall
62380e0181 Expand band support and improve band display in bandmap
Added support for additional LF, MF, UHF, SHF, and EHF amateur radio bands in Bands model and bandmap view. Updated band ranges and ordering, and improved band name formatting in the bandmap UI for better clarity and consistency across all supported bands.
2025-10-04 23:05:20 +01:00
Peter Goodhall
5f0c95804a Add user-specific bands to bandmap and persist radio selection
The bandmap now displays only the bands configured for the current user, using a new Bands model method to retrieve and order them. The band selection dropdown in the bandmap view is dynamically generated based on user bands, with a fallback to defaults. Additionally, the selected radio is now persisted in localStorage and synchronized across selects, and the bandmap window width was adjusted for better display.
2025-10-02 17:40:49 +01:00
Danny
4235bbb2de Distances worked analytics: filter on mode and power 2024-09-03 00:03:06 +02:00
HB9HIL
bb5355d32f bug fix for getFreqFromBand 2023-11-09 21:49:17 +01:00
Andreas
587660383e [SimpleFLE] Replaced hardcoded bands with bands from db 2023-10-26 19:59:02 +02:00
Andreas Kristiansen
9917b14199
Merge branch 'dev' into online_qsl_request 2022-12-14 12:37:22 +01:00
phl0
034fa625fb
Add support for POTA fields according to ADIF update 2022-11-30 15:38:40 +01:00
Andreas
9d1f30d8e8 [OQRS] Added OQRS system 2022-11-15 18:29:33 +01:00
Andreas
ccacc244db [Bands] Added master checkbox for award 2022-10-06 11:41:01 +02:00
phl0
f556e6319f
Added POTA to awards section
Signed-off-by: phl0 <github@florian-wolters.de>
2022-10-05 22:13:12 +02:00
Andreas
9e110039f3 [Bands] Added WWFF support to bands 2022-09-20 17:25:50 +02:00
Andreas
6b4a09d653 [Bands] Editing QSO now fetches bands from DB. Includes also disabled bands. 2022-09-09 23:11:52 +02:00
Andreas
4eae240fb9 [Bands] Updated edit/create band to include bandgroup, cw/ssb/data qrg 2022-09-09 18:52:57 +02:00
Andreas
be72a332b6 [Bands] QSO entry band/bandrx dropdown is now fetched from db 2022-09-08 20:12:11 +02:00
Andreas
e777fcfc5a [Bands] DOK support added 2022-09-06 20:31:53 +02:00
Andreas
1114973f8d [Bands] Added edit band 2022-09-06 20:18:17 +02:00
Andreas
7326c7ec35 [Bands] Can now create new band 2022-09-06 19:35:27 +02:00
Andreas
a9c6acf255 [Bands] User settings can now be saved. 2022-09-05 20:26:08 +02:00
Andreas
a7375c0bdc [Bands] Added logic to fetch bands from database 2022-09-04 18:26:21 +02:00
Andreas
c55ea49675 [Bands] Added a controller and a view to display bands with options 2022-09-04 08:49:58 +02:00
Ryan Zink
6b4a328bc1 Addition of 33cm and 1.25m bands where appropriate, reclassification of some bands as Microwave rather than UHF 2022-01-20 21:10:16 -07:00
Andreas
8c7fa355fb [Awards] Fixed implode error when logbook is empty 2021-11-14 17:11:59 +01:00
Andreas
7dec9a7684 Removed constructor in the newly added bands-model. 2021-11-13 20:04:29 +01:00
Andreas
939434090d [Bands] Consolidated get_worked_bands to it's own model. This will make it easier to have everything in one place, and perhaps also move bands to db. 2021-11-13 15:55:17 +01:00