From 16bd0b5f539c435f1dcd854b5edf5078ba1167e6 Mon Sep 17 00:00:00 2001
From: "Ryan C. Gordon" <icculus@icculus.org>
Date: Fri, 30 Jan 2009 16:56:26 -0500
Subject: [PATCH] Fixed problem with MySQL 5.

---
 IcculusNews_daemon.pl | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/IcculusNews_daemon.pl b/IcculusNews_daemon.pl
index 51195d5..af05894 100755
--- 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");