[livejournal] r18760: LJSUP-8451. "Moderate Community Submissi...

U   trunk/cgi-bin/LJ/Browse.pm

Modified: trunk/cgi-bin/LJ/Browse.pm
===================================================================
--- trunk/cgi-bin/LJ/Browse.pm	2011-03-31 08:56:38 UTC (rev 18759)
+++ trunk/cgi-bin/LJ/Browse.pm	2011-03-31 09:21:03 UTC (rev 18760)
@@ -1347,8 +1347,8 @@
         or die "unable to contact global db master to create category";
 
     $dbh->do("UPDATE categoryjournals_pending SET status=?, " .
-             "modid=?, lastupdate=UNIX_TIMESTAMP() WHERE pendid IN(?)", undef,
-             'D', $mod_u->userid, @pendids);
+             "modid=?, lastupdate=UNIX_TIMESTAMP() WHERE pendid IN(".join(",", @pendids).")", undef,
+             'D', $mod_u->userid);
     die $dbh->errstr if $dbh->err;
 
     return;
@@ -1376,7 +1376,7 @@
     # Update moderation table
     $dbh->do("UPDATE categoryjournals_pending SET status=?, " .
              "modid=?, lastupdate=UNIX_TIMESTAMP() WHERE pendid IN(".join(",", @pendids).")", undef,
-             'A', $mod_u->userid, @pendids);
+             'A', $mod_u->userid);
     die $dbh->errstr if $dbh->err;
 
     $self->clear_journals_memcache;