Commit graph

17 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
a27b0cf571 Add input validation and parameterized queries to OQRS
Added server-side validation for callsign and station_id inputs in Oqrs controller to prevent invalid data and potential abuse. Updated Oqrs_model to use parameterized queries instead of string concatenation, improving security against SQL injection. Callsigns are now consistently uppercased before querying.
2025-10-10 22:34:06 +01:00
HB9HIL
61d4c15ec0 crlf and newline bugfix 2023-11-22 14:51:45 +01:00
HB9HIL
14ed03fa02 removed crlf and newline (not needed) 2023-11-21 12:33:06 +01:00
HB9HIL
9d020aca84 email fix 2023-11-21 10:22:14 +01:00
Andreas
694f9fbd80 [OQRS] Fixed error 500 with OQRS notification email 2023-11-21 10:07:59 +01:00
Andreas
020fd96ef9 [Email] Added email sender name 2023-06-17 09:03:00 +02:00
Andreas
bfcfad780b [Email] Added email address option 2023-06-16 10:56:06 +02:00
Andreas
0142209022 [OQRS] Now added option to search in all station locations with active OQRS 2023-04-25 14:00:30 +02:00
Andreas
bf607a5bf5 [OQRS] Added option to set global text to be displayed on top of OQRS page. 2023-04-17 20:04:23 +02:00
Andreas
c6aaf97c8a [OQRS] Changed to visitor header 2022-12-31 00:01:34 +01:00
phl0
5ba33a020a
Add reply to header 2022-12-29 18:10:51 +01:00
phl0
8695c52891
Add user message to email 2022-12-29 17:59:41 +01:00
Andreas
d5842bbc5a [OQRS] Created new view for OQRS requests 2022-12-29 17:14:18 +01:00
phl0
b2a932b125
Load eqsl and lotw lang to fix log warnings and display errors in check
log
2022-12-29 00:06:23 +01:00
Andreas
ca23cf8b0b [OQRS] Added it's own view for the QSO lookup 2022-12-14 12:35:48 +01:00
Andreas
9d1f30d8e8 [OQRS] Added OQRS system 2022-11-15 18:29:33 +01:00