Unapprove and undelete an item when moving it between queues, so you …

…can't sneak an item onto the frontpage through someone else's queue.
icculus · Jun 14, 2002 · 3a2f793 · 3a2f793
1 parent b8bd1e9
commit 3a2f793
Showing 1 changed file with 2 additions and 1 deletion.
diff --git a/IcculusNews_daemon.pl b/IcculusNews_daemon.pl
@@ -1088,7 +1088,8 @@ sub generate_pword {
     report_error($err), return 1 if defined $err;
 
     my $link = get_database_link();
-    my $sql = "update $dbtable_items set queueid=$newqueue" .
+    my $sql = "update $dbtable_items" .
+              " set queueid=$newqueue, deleted=0, approved=0" .
               " where id=$id and queueid=$queue";
 
     my $rc = $link->do($sql);