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
HB9HIL
3f4857e6db
fixed worked and confirmed badges in awards
2023-11-25 23:54:14 +01:00
phl0
accf4add52
Implement eQSL and QSL filter for WAS awards
2023-01-18 14:08:56 +01:00
Andreas
09144a5589
[Bands] Only use selected bands in total in awards
2022-09-07 20:40:31 +02:00
Andreas
902d121015
[WAS Award] Added filtering to summary
2022-01-04 19:13:41 +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
45d8f56875
[WAS Award] Updated code to support station logbooks
2021-09-09 23:04:50 +02:00
Andreas
88c4a10d35
[Awards WAS] Added mode filtering.
2021-07-27 12:11:41 +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
503ac06599
Added total to WAS summary
2020-10-15 12:24:20 +02:00
Peter Goodhall
1290fb8073
Merge PR #614 from AndreasK79 - Improved WAS Dialog popups with bootstrap4-dialog
...
Improved WAS javascript dialog windows and also added bootstrap4-dialog as we move away from Fancybox
2020-09-13 11:57:53 +01:00
Andreas
712bbf1840
More work on QSO dialog for WAS award.
2020-08-24 20:16:06 +02:00
Andreas
f7cb30e3b9
Had to remove band from query as well.
2020-08-19 17:30:37 +02:00
Andreas
49a6ca53e1
Fixed summary to include SAT. Also split the query for the was summary in two. Some configurations of mysql didn't like this type of query.
2020-08-19 17:23:24 +02:00
Andreas
c8b999659c
Added summary on the WAS award page.
2020-08-18 14:41:16 +02:00
AndreasK79
bfe1a40260
Fixed a few bugs in the WAS award
2020-03-31 07:43:33 +02:00
AndreasK79
cde55ab338
Rewrote WAS (Worked All States) to the same design as DXCC And IOTA.
2020-03-29 00:36:18 +01:00
AndreasK79
e70039661a
Added WAS (Worked All States) under awards. It's based on the same layout as the DXCC award.
...
Display of qsoes when clicking a CQ-zone was also fixed.
2020-02-09 13:20:59 +01:00
