Commit graph

7 commits

Author SHA1 Message Date
Peter Goodhall
53019ade11 Add satellite orbit filters to grid maps
Extends Gridmap and Activated Gridmap to accept a new `sat_orbit` filter and applies it across worked/confirmed grid and VUCC queries, including SAT-specific SQL filtering for LEO, MEO (IO-117), and GEO (QO-100). Updates the gridmap UI to show/hide orbit controls with SAT selection, sends the new filter in AJAX requests, and adds activated-grid summary cards with worked/confirmed counts and satellite class breakdown data from new model methods.
2026-07-17 13:44:06 +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
int2001
609527b22d
Added QRZ-Logic to activated gridsquare map 2023-12-08 12:51:10 +00:00
int2001
338b28a641
Activated Grids were calculated by whole instance QSOs, not by owner 2023-11-30 09:54:03 +00:00
phl0
5fb7e75d90
Remove debug statement 2023-09-15 23:56:43 +02:00
phl0
21c332b0d8
Use QSL sent instead of rcvd 2023-09-15 23:54:37 +02:00
phl0
9ce313a902
Base implementation for gridmap for activated grids 2023-09-11 16:59:05 +02:00