X-Git-Url: https://git.sesse.net/?p=pr0n;a=blobdiff_plain;f=perl%2FSesse%2Fpr0n%2FIndex.pm;h=74c6566ea184744ce2d05b8c1d4f674342d9a7ae;hp=88e0e49339311096ae02bc6ae7af355aa4957cea;hb=a08252beeb4a35f3561f6a052ea80a27ec9eba52;hpb=d8b85d84e5e0b16a2d5e64eb8899324d6011cbbf

diff --git a/perl/Sesse/pr0n/Index.pm b/perl/Sesse/pr0n/Index.pm
index 88e0e49..74c6566 100644
--- a/perl/Sesse/pr0n/Index.pm
+++ b/perl/Sesse/pr0n/Index.pm
@@ -37,7 +37,7 @@ sub handler {
 		xres => -1,
 		yres => -1,
 		start => 1,
-		num => -1,
+		num => 100,
 		all => 1,
 		infobox => 1,
 		rot => 0,
@@ -154,7 +154,7 @@ sub handler {
 				TRIM(model.value) AS model,
 				coalesce(TRIM(lens_spec.value), TRIM(lens.value)) AS lens,
 				COUNT(*) AS num
-			FROM ( SELECT * FROM images WHERE event=? AND vhost=? $where ORDER BY (date - INTERVAL '6 hours')::date,takenby,date,filename $limit ) i
+			FROM ( SELECT * FROM images WHERE event=? AND vhost=? $where ORDER BY (date - INTERVAL '6 hours')::date,takenby,date,filename ) i
 				LEFT JOIN exif_info model ON i.id=model.image
 				LEFT JOIN ( SELECT * FROM exif_info WHERE tag='Lens' ) lens ON i.id=lens.image
 				LEFT JOIN ( SELECT * FROM exif_info WHERE tag='LensSpec') lens_spec ON i.id=lens_spec.image