Commit graph

13 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
Danny
61b40a010d Analytics: graph of QSOs for each day in the log 2024-11-30 16:53:52 +01:00
Danny
ef2ea82435 Statistics: number of QSOs par day of the week 2024-11-20 20:24:08 +01:00
Andreas
341e8f4a33 [Days with QSOs] Fix if no QSOs found 2021-11-14 17:49:35 +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
14bb2db47f [Days With QSOs] Updated code to support station logbooks 2021-09-10 20:04:03 +02:00
Andreas
f0f89de57d Datefix + added table-sm to tables. 2020-09-30 22:53:09 +02:00
Andreas
e4cddcdfdc Current streak is added. 2020-09-21 10:52:13 +02:00
Andreas
fda81b3304 10 longest streaks added to days with qsos 2020-09-10 18:09:31 +02:00
Peter Goodhall
a393ead899 forgot to remove debug #fail 2020-04-25 21:52:16 +01:00
Peter Goodhall
3f7d68aced Fixed SQL error 2020-04-25 21:51:44 +01:00
Peter Goodhall
03b00b223b Changed DaysWithQSO to Time_ON which is the field Cloudlog uses for Date/Time of qsos 2020-04-25 21:45:11 +01:00
AndreasK79
6dcdcca0bf Added statistics for number of days qrv each year. 2020-04-24 23:29:01 +02:00