[geeklog-hg] geeklog: Fixed comment notification sql error when a comment sub...

[geeklog-cvs at lists.geeklog.net]

changeset 9162:12833ad7e3f4
url:  http://project.geeklog.net/cgi-bin/hgwebdir.cgi/geeklog/rev/12833ad7e3f4
user: Tom <websitemaster at cogeco.net>
date: Thu Jul 04 09:11:42 2013 -0400
description:
Fixed comment notification sql error when a comment submission is approved.

diffstat:

 system/lib-comment.php |  2 +-
 1 files changed, 1 insertions(+), 1 deletions(-)

diffs (12 lines):

diff -r 752fa0420466 -r 12833ad7e3f4 system/lib-comment.php
--- a/system/lib-comment.php	Wed Jul 03 12:27:18 2013 -0400
+++ b/system/lib-comment.php	Thu Jul 04 09:11:42 2013 -0400
@@ -2017,7 +2017,7 @@
            . "FROM {$_TABLES['comments']} AS c, {$_TABLES['comments']} AS c2, "
            . "{$_TABLES['commentnotifications']} AS cn "
            . "WHERE c2.cid = cn.cid AND (c.lft >= c2.lft AND c.lft <= c2.rht) "
-           . "AND c.cid = $pid GROUP BY cn.uid";
+           . "AND c.cid = {$A['pid']} GROUP BY cn.uid";
         $result = DB_query($sql);        
         $B = DB_fetchArray($result);
         if ($B !== false) {