X-Git-Url: https://git.sesse.net/?p=pr0n;a=blobdiff_plain;f=perl%2FSesse%2Fpr0n%2FImage.pm;h=7f3e3c09825a015f9295c40f2541c2c53dea60a6;hp=6df8ea25e29509a643ef829120f110c59dffea32;hb=4e9898a97f5c3c52d1277ed73cb4365b8644870a;hpb=576c411da9608bb7155e89811694f9f19e542773 diff --git a/perl/Sesse/pr0n/Image.pm b/perl/Sesse/pr0n/Image.pm index 6df8ea2..7f3e3c0 100644 --- a/perl/Sesse/pr0n/Image.pm +++ b/perl/Sesse/pr0n/Image.pm @@ -16,9 +16,9 @@ sub handler { # Find the event and file name my ($event,$filename,$xres,$yres); my $infobox = 1; - if ($r->uri =~ m#^/([a-zA-Z0-9-]+)/original/([a-zA-Z0-9._-]+)$#) { + if ($r->uri =~ m#^/([a-zA-Z0-9-]+)/original/(nobox/)?([a-zA-Z0-9._-]+)$#) { $event = $1; - $filename = $2; + $filename = $3; } elsif ($r->uri =~ m#^/([a-zA-Z0-9-]+)/(\d+)x(\d+)/(nobox/)?([a-zA-Z0-9._-]+)$#) { $event = $1; $filename = $5; @@ -34,26 +34,20 @@ sub handler { } my ($id, $dbwidth, $dbheight); - if ($event eq 'single' && $filename =~ /^(\d+)\.jpeg$/) { - $id = $1; - } else { - # Alas, we obviously need to do this :-) - # my $evq = $dbh->prepare('SELECT count(*) AS numev FROM events WHERE id=? AND vhost=?') - # or die "prepare(): $!"; - # my $ref = $dbh->selectrow_hashref($evq, undef, $event, $r->get_server_name) - # or dberror($r, "Could not look up $event"); - # $ref->{'numev'} == 1 - # or error($r, "Could not find $event", 404, "File not found"); + #if ($event eq 'single' && $filename =~ /^(\d+)\.jpeg$/) { + # $id = $1; + #} else { - # Look it up in the database - my $ref = $dbh->selectrow_hashref('SELECT id,width,height FROM images WHERE event=? AND filename=?', - undef, $event, $filename); - error($r, "Could not find $event/$filename", 404, "File not found") unless (defined($ref)); + # Look it up in the database + my $ref = $dbh->selectrow_hashref('SELECT id,width,height FROM images WHERE event=? AND vhost=? AND filename=?', + undef, $event, $r->get_server_name, $filename); + error($r, "Could not find $event/$filename", 404, "File not found") unless (defined($ref)); - $id = $ref->{'id'}; - $dbwidth = $ref->{'width'}; - $dbheight = $ref->{'height'}; - } + $id = $ref->{'id'}; + $dbwidth = $ref->{'width'}; + $dbheight = $ref->{'height'}; + + #} $dbwidth = -1 unless defined($dbwidth); $dbheight = -1 unless defined($dbheight);