I have a Pod page that requires paging, but a PCI scan reports that the ‘pg’ parameter used to indicate page number is potentially vulnerable to SQL injection. I don’t know if malicious code can in fact be executed, however if you change ‘pg’ to a string of characters rather than a number, you definitely get a nasty error along the lines of ‘your SQL contains errors’.
I determined the ultimate cause to be that page numbering starts at 1 rather than 0, and the simplest solution I then found was to change line 36 of Pod.php from:-
This works, because casting any non-number or indeed the empty string to int will result in 0, in which case a value of 1 will be assigned. Likewise any other ‘potentially unsafe’ values will simply result in the first page being shown.
There’s probably a better place to report bugs, but I couldn’t find it on the quick, sorry.