Fixed problem with MySQL 5.

icculus · Jan 30, 2009 · 16bd0b5 · 16bd0b5
1 parent fb59ff5
commit 16bd0b5
Showing 1 changed file with 1 addition and 1 deletion.
diff --git a/IcculusNews_daemon.pl b/IcculusNews_daemon.pl
@@ -935,7 +935,7 @@ sub generate_pword {
               " q.created, q.owner, u.name, q.flags, r.rights" .
               " from $dbtable_queues as q, $dbtable_users as u" .
               " left outer join $dbtable_queue_rights as r" .
-              " on r.qid=q.id and r.uid=$auth_uid" .
+              " on r.qid=$id and r.uid=$auth_uid" .
               " where q.id=$id and q.owner=u.id";
     my $sth = $link->prepare($sql);
     $sth->execute() or report_fatal("can't execute query: $sth->errstr");