X-Git-Url: https://git.sesse.net/?p=pr0n;a=blobdiff_plain;f=perl%2FSesse%2Fpr0n%2FSelect.pm;h=a2b15e7d65fe306552c68e629e407151f1c0d181;hp=1086587ae77769df03fbf93864e662de94d370ba;hb=54772c93b534979ab28f88a42eca429edf15d483;hpb=2d6536cab108c937e2af49f7dcf15f2230f44d1a

diff --git a/perl/Sesse/pr0n/Select.pm b/perl/Sesse/pr0n/Select.pm
index 1086587..a2b15e7 100644
--- a/perl/Sesse/pr0n/Select.pm
+++ b/perl/Sesse/pr0n/Select.pm
@@ -23,20 +23,14 @@ sub handler {
 		local $dbh->{AutoCommit} = 0;
 		local $dbh->{RaiseError} = 1;
 
-		$dbh->do('UPDATE images SET selected=\'f\' WHERE event=?', undef, $event);
-
-		my @params = $apr->param();
-		my $key;
-		for $key (@params) {
-			if ($key =~ /^sel-(\d+)/ && $apr->param($key) eq 'on') {
-				my $id = $1;
-				my $q = $dbh->do('UPDATE images SET selected=\'t\' WHERE id=?', undef, $id)
-					or dberror($r, "Selection of $id failed: $!");
-				$r->print("    <p>Selected image ID `$id'.</p>\n");
-			}
-		}
+		# FIXME: need to support disable too
+		my $filename = $apr->param('filename');
+		$dbh->do('UPDATE images SET selected=\'t\' WHERE vhost=? AND event=? AND filename=?', undef, $r->get_server_name, $event, $filename);
 	}
 
+	$dbh->do('UPDATE last_picture_cache SET last_update=CURRENT_TIMESTAMP WHERE vhost=? AND event=?', undef, $r->get_server_name, $event)
+		or dberror($r, "Cache invalidation failed");
+
 	Sesse::pr0n::Common::footer($r);
 
 	return Apache2::Const::OK;