X-Git-Url: https://git.sesse.net/?p=pr0n;a=blobdiff_plain;f=perl%2FSesse%2Fpr0n%2FCommon.pm;h=1f1eac878537ebaffcfdb4e0c54187d0bfdf1841;hp=4ddc0daedc581c9461a6787ddb702696271a9672;hb=aebd301b01c9b4e75e382fb7c1fcb9347c48ffd0;hpb=150143c86481611f06d86a0956b6b7965b1c0c88 diff --git a/perl/Sesse/pr0n/Common.pm b/perl/Sesse/pr0n/Common.pm index 4ddc0da..1f1eac8 100644 --- a/perl/Sesse/pr0n/Common.pm +++ b/perl/Sesse/pr0n/Common.pm @@ -12,6 +12,7 @@ use Apache2::Log; use ModPerl::Util; use Carp; +use Encode; use DBI; use DBD::Pg; use Image::Magick; @@ -22,6 +23,7 @@ use MIME::Types; use LWP::Simple; # use Image::Info; use Image::ExifTool; +use HTML::Entities; BEGIN { use Exporter (); @@ -32,7 +34,7 @@ BEGIN { require Sesse::pr0n::Config_local; }; - $VERSION = "v2.11"; + $VERSION = "v2.21"; @ISA = qw(Exporter); @EXPORT = qw(&error &dberror); %EXPORT_TAGS = qw(); @@ -128,7 +130,7 @@ sub get_query_string { next unless defined($value); next if (defined($defparam->{$key}) && $value == $defparam->{$key}); - $str .= ($first) ? "?" : '&'; + $str .= ($first) ? "?" : ';'; $str .= "$key=$value"; $first = 0; } @@ -361,7 +363,12 @@ sub ensure_cached { # Strip EXIF tags etc. $cimg->Strip(); - $err = $cimg->write(filename=>$cachename, quality=>$quality); + if (($nwidth >= 640 && $nheight >= 480) || + ($nwidth >= 480 && $nheight >= 640)) { + $err = $cimg->write(filename=>$cachename, quality=>$quality, interlace=>'Plane'); + } else { + $err = $cimg->write(filename=>$cachename, quality=>$quality); + } undef $cimg; @@ -525,6 +532,48 @@ sub gcd { return gcd($b, $a % $b); } +sub add_new_event { + my ($dbh, $id, $date, $desc, $vhost) = @_; + my @errors = (); + + if (!defined($id) || $id =~ /^\s*$/ || $id !~ /^([a-zA-Z0-9-]+)$/) { + push @errors, "Manglende eller ugyldig ID."; + } + if (!defined($date) || $date =~ /^\s*$/ || $date =~ /[<>&]/ || length($date) > 100) { + push @errors, "Manglende eller ugyldig dato."; + } + if (!defined($desc) || $desc =~ /^\s*$/ || $desc =~ /[<>&]/ || length($desc) > 100) { + push @errors, "Manglende eller ugyldig beskrivelse."; + } + + if (scalar @errors > 0) { + return @errors; + } + + $dbh->do("INSERT INTO events (id,date,name,vhost) VALUES (?,?,?,?)", + undef, $id, $date, $desc, $vhost) + or return ("Kunne ikke sette inn ny hendelse" . $dbh->errstr); + $dbh->do("INSERT INTO last_picture_cache (event,last_picture) VALUES (?,NULL)", + undef, $id) + or return ("Kunne ikke sette inn ny cache-rad" . $dbh->errstr); + + return (); +} + +sub guess_charset { + my $text = shift; + my $decoded; + + eval { + $decoded = Encode::decode("utf-8", $text, Encode::FB_CROAK); + }; + if ($@) { + $decoded = Encode::decode("iso8859-1", $text); + } + + return $decoded; +} + 1;