Fixed problem with MySQL 5.
authorRyan C. Gordon <icculus@icculus.org>
Fri, 30 Jan 2009 16:56:26 -0500
changeset 79 b44bfedcd689
parent 78 608833945e55
child 80 8a8041c74e65
Fixed problem with MySQL 5.
IcculusNews_daemon.pl
--- a/IcculusNews_daemon.pl	Wed Dec 12 12:31:44 2007 +0000
+++ b/IcculusNews_daemon.pl	Fri Jan 30 16:56:26 2009 -0500
@@ -935,7 +935,7 @@
               " 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");