Commit graph

22 commits

Author SHA1 Message Date
Peter Goodhall
3e944f71cc Normalize location lists and sanitize SQL
Replace fragile quoted-implode station lists with normalized integer CSVs and where_in usage to ensure station_id lists are numeric. Add normalize_location_list helpers in multiple models (Lookup_model, Sig, Timeline_model) and update controllers to cast inputs (e.g. dxcc_id) to ints. Escape user-supplied SQL fragments with $this->db->escape_str/escape_like_str and sanitize band/mode parameters; consolidate band/mode filtering into add_band_mode_filters in Timeline_model. Add guards for empty location lists (returning empty results) and a method_exists check around a legacy vucc_shit call. Overall this improves input validation and reduces SQL injection risk while removing duplicated list-building logic.
2026-06-24 22:29:00 +01:00
Peter Goodhall
d6fe6e8110 Sanitize and escape query inputs in models
Sanitize location lists and escape query parameters across multiple models to prevent SQL injection and fix query formatting. Changes include: converting location arrays to comma-separated integer lists (array_map('intval')) instead of quoted implode, adding escape_str for band/mode/sat, adding a sanitize_location_list helper and early-return checks in CQ, escaping band lists, and updating Adif_data date where clauses to use $this->db->escape(..., NULL, FALSE). Files modified: Accumulate_model, Activated_gridmap_model, Adif_data, Cq, and Gridmap_model.
2026-06-24 22:19:35 +01:00
phl0
0ae34b51bc
Handle incorrect CQ zones 2024-02-14 08:49:51 +01:00
HB9HIL
3f4857e6db fixed worked and confirmed badges in awards 2023-11-25 23:54:14 +01:00
phl0
75cf2c7c7c
Implement eQSL and QSL filter for CQ awards 2023-01-18 13:35:58 +01:00
Andreas
09144a5589 [Bands] Only use selected bands in total in awards 2022-09-07 20:40:31 +02:00
Andreas
1bedfbb919 [CQ Award] Added filtering to the summary 2022-01-06 19:35:08 +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
841bec5d31 [CQ Award] Updated code to support station logbooks 2021-09-08 22:07:00 +02:00
Andreas
946f11d538 [QSO Entry] Maritime Mobile identification fix 2021-07-30 09:06:53 +02:00
Andreas
b2f2b329c4 [Awards CQ Zone] Added mode filtering. 2021-07-26 09:00:52 +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
5979cceb33 [Awards CQ] Added index for speedup. Removed some unused code and reduced number of queries by a few. 2021-03-27 14:28:29 +01:00
Andreas
1af82d5dea Added total to CQ award summary 2020-10-15 12:27:45 +02:00
Andreas
161798c44d Added summary for the CQ award. 2020-10-11 14:46:35 +02:00
Andreas
f138d84dc1 Added bootstrapdialog for CQ award. 2020-09-20 11:02:29 +02:00
AndreasK79
2cfd8efdf2 Enhanced the CQ award with a table and form. 2020-03-30 21:03:38 +02:00
Peter Goodhall
0a03fa7fbf Awards are shown based on the active station profile 2019-09-25 00:05:45 +01:00
Tobias Mädel
7d74359455
also replace hardcoded table name 2019-06-17 18:44:50 +02:00
Andy
c99f6ceb5a Rename cq to Cq 2018-11-24 21:03:59 +00:00
Renamed from application/models/cq.php (Browse further)