1 package Sesse::pr0n::NewEvent;
5 use Sesse::pr0n::Common qw(error dberror);
10 my $apr = Apache2::Request->new($r);
11 my $dbh = Sesse::pr0n::Common::get_dbh();
12 my $user = Sesse::pr0n::Common::check_access($r);
13 if (!defined($user)) {
14 return Apache2::Const::OK;
17 Sesse::pr0n::Common::header($r, "Legger til ny hendelse");
21 my $id = $apr->param('id');
22 if (!defined($id) || $id =~ /^\s*$/ || $id !~ /^([a-zA-Z0-9-]+)$/) {
23 $r->print(" <p>Feil: Manglende eller ugyldig ID.</p>\n");
27 my $date = $apr->param('date');
28 if (!defined($date) || $date =~ /^\s*$/ || $date =~ /[<>&]/ || length($date) > 100) {
29 $r->print(" <p>Feil: Manglende eller ugyldig dato.</p>\n");
33 my $desc = $apr->param('desc');
34 if (!defined($desc) || $desc =~ /^\s*$/ || $desc =~ /[<>&]/ || length($desc) > 100) {
35 $r->print(" <p>Feil: Manglende eller ugyldig beskrivelse.</p>\n");
40 $r->print(" <p>Rett opp i feilene over før du går videre.</p>\n");
42 $dbh->do("INSERT INTO events (id,date,name,vhost) VALUES (?,?,?,?)",
43 undef, $id, $date, $desc, $r->get_server_name)
44 or dberror($r, "Kunne ikke sette inn ny hendelse");
45 $dbh->do("INSERT INTO last_picture_cache (event,last_picture) VALUES (?,NULL)",
47 or dberror($r, "Kunne ikke sette inn ny cache-rad");
48 $r->print(" <p>Hendelsen '$id' lagt til.</p>");
51 Sesse::pr0n::Common::footer($r);
53 return Apache2::Const::OK;