From: Steinar H. Gunderson Date: Mon, 31 Jul 2006 17:32:38 +0000 (+0200) Subject: Don't LIMIT/OFFSET if we're in fullscreen mode; we're only showing one at X-Git-Url: https://git.sesse.net/?p=pr0n;a=commitdiff_plain;h=4dff0d92d7b4b79e4ed3d7293b7456aceaecd5c5 Don't LIMIT/OFFSET if we're in fullscreen mode; we're only showing one at a time anyhow, and it confuses all the other logic. --- diff --git a/perl/Sesse/pr0n/Index.pm b/perl/Sesse/pr0n/Index.pm index c0c89a7..44a57f8 100644 --- a/perl/Sesse/pr0n/Index.pm +++ b/perl/Sesse/pr0n/Index.pm @@ -92,7 +92,7 @@ sub handler { my $q; my $where = ($all == 0) ? ' AND selected=\'t\'' : ''; - if (defined($start) && defined($num)) { + if (defined($start) && defined($num) && !$settings{'fullscreen'}) { $q = $dbh->prepare("SELECT *, (date - INTERVAL '6 hours')::date AS day FROM images WHERE event=? $where ORDER BY (date - INTERVAL '6 hours')::date,takenby,date,filename LIMIT $num OFFSET " . ($start-1)) or dberror($r, "prepare()"); } else {