Kill the limit in the equipment list.
authorSteinar H. Gunderson <sesse@debian.org>
Tue, 24 Jul 2007 20:50:23 +0000 (22:50 +0200)
committerSteinar H. Gunderson <sesse@debian.org>
Tue, 24 Jul 2007 20:50:23 +0000 (22:50 +0200)
perl/Sesse/pr0n/Index.pm

index 88e0e49339311096ae02bc6ae7af355aa4957cea..74c6566ea184744ce2d05b8c1d4f674342d9a7ae 100644 (file)
@@ -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