X-Git-Url: https://git.sesse.net/?p=pr0n;a=blobdiff_plain;f=perl%2FSesse%2Fpr0n%2FImage.pm;h=23b7d1b60c93fc12d63afb6f120581f0f6f9c1bc;hp=e436428950b6adc9d5a8e56e23755d3eab4ae710;hb=7ed166d00c60530874566d5e67130464e6fc0415;hpb=6e87d26481ba152a8504c3c6c8650d1927206331 diff --git a/perl/Sesse/pr0n/Image.pm b/perl/Sesse/pr0n/Image.pm index e436428..23b7d1b 100644 --- a/perl/Sesse/pr0n/Image.pm +++ b/perl/Sesse/pr0n/Image.pm @@ -16,16 +16,16 @@ 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/(nobox/)?([a-zA-Z0-9._-]+)$#) { + if ($r->uri =~ m#^/([a-zA-Z0-9-]+)/original/(nobox/)?([a-zA-Z0-9._()-]+)$#) { $event = $1; $filename = $3; - } elsif ($r->uri =~ m#^/([a-zA-Z0-9-]+)/(\d+)x(\d+)/(nobox/)?([a-zA-Z0-9._-]+)$#) { + } elsif ($r->uri =~ m#^/([a-zA-Z0-9-]+)/(\d+)x(\d+)/(nobox/)?([a-zA-Z0-9._()-]+)$#) { $event = $1; $filename = $5; $xres = $2; $yres = $3; $infobox = 0 if (defined($4)); - } elsif ($r->uri =~ m#^/([a-zA-Z0-9-]+)/(nobox/)?([a-zA-Z0-9._-]+)$#) { + } elsif ($r->uri =~ m#^/([a-zA-Z0-9-]+)/(nobox/)?([a-zA-Z0-9._()-]+)$#) { $event = $1; $filename = $3; $xres = -1; @@ -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);