From 4dff0d92d7b4b79e4ed3d7293b7456aceaecd5c5 Mon Sep 17 00:00:00 2001 From: "Steinar H. Gunderson" Date: Mon, 31 Jul 2006 19:32:38 +0200 Subject: [PATCH] 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. --- perl/Sesse/pr0n/Index.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) 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 { -- 2.39.2