Commit graph

18 commits

Author SHA1 Message Date
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
a59bf0ce35 Fix SQL query to use 'in' for station_id comparison
Updated the SQL query to use 'station_id in (...)' instead of 'station_id = ...' in the subquery, ensuring correct filtering when multiple station IDs are provided.
2026-01-13 10:45:52 +00:00
HB9HIL
3f4857e6db fixed worked and confirmed badges in awards 2023-11-25 23:54:14 +01:00
Andreas
e1444c2abf [IOTA Map] Added map to display IOTA's 2022-12-11 17:47:36 +01:00
Andreas
09144a5589 [Bands] Only use selected bands in total in awards 2022-09-07 20:40:31 +02:00
Andreas
bbe3e989b8 [IOTA Award] Added filtering to summary 2022-01-06 20:02:53 +01:00
Andreas
8c7fa355fb [Awards] Fixed implode error when logbook is empty 2021-11-14 17:11:59 +01:00
Andreas Kristiansen
42fa1a06d0
Merge branch 'station_logbooks' into cloudlog_php8_compatible 2021-11-13 16:03:52 +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
Andreas
1b2a88b355 Removed all constructors in models, since this doesn't work in never CodeIgniter 2021-11-06 20:24:28 +01:00
Andreas
49fc109aa6 [IOTA Award] Updated code to support station logbooks 2021-09-09 22:18:55 +02:00
Andreas
0996f957fd [Awards IOTA] Added mode filtering. 2021-07-26 13:13:16 +02:00
Andreas
8b370c9783 [Awards] Fixed DXCC QSO details to also filter on modes. Made a generic function to display QSOs. It's now used for DXCC, WAS, IOTA, CQ, VUCC. This is also done in preparation for adding mode filter to WAS, IOTA and CQ Award. 2021-07-24 14:31:16 +02:00
Andreas
dbdbbdebf3 Added total count for summary in Iota award 2020-10-15 09:49:55 +02:00
Andreas
99df3c8290 Added summary for the IOTA award. 2020-10-11 14:54:23 +02:00
Andreas
c06baf39e3 Added bootstrapdialog for IOTA award. 2020-09-20 11:09:22 +02:00
AndreasK79
ead4e960de Cleaned up some code and filtered out sat qso when band not like SAT. 2020-03-18 19:26:26 +01:00
AndreasK79
13771e9a07 IOTA Award added. 2020-03-07 11:39:22 +01:00