[geeklog-cvs] geeklog: The last 10 comments for the User Profile should return...

[geeklog-cvs at lists.geeklog.net]

changeset 7872:acbf6b299bb6
url:  http://project.geeklog.net/cgi-bin/hgwebdir.cgi/geeklog/rev/acbf6b299bb6
user: Tom <websitemaster at cogeco.net>
date: Mon Apr 05 12:31:37 2010 -0400
description:
The last 10 comments for the User Profile should return the comment titles not the poll title that the comment is for.

diffstat:

 plugins/polls/functions.inc |  2 +-
 1 files changed, 1 insertions(+), 1 deletions(-)

diffs (12 lines):

diff -r 748f4dd90a4a -r acbf6b299bb6 plugins/polls/functions.inc
--- a/plugins/polls/functions.inc	Sun Apr 04 09:31:55 2010 +0200
+++ b/plugins/polls/functions.inc	Mon Apr 05 12:31:37 2010 -0400
@@ -1608,7 +1608,7 @@
             . " WHERE (pt.pid = sid) AND (pt.commentcode >= 0)" . COM_getPermSQL('AND', 0, 2, 'pt')
             . " AND (date >= (NOW()+ INTERVAL '{$_CONF['newcommentsinterval']} SECOND')) {$stwhere} GROUP BY sid,type, title, sid ORDER BY 5 DESC LIMIT 15";
     } else {
-        $sql = "SELECT {$_TABLES['comments']}.sid, pt.topic title, cid, UNIX_TIMESTAMP({$_TABLES['comments']}.date) AS unixdate FROM {$_TABLES['comments']}, {$_TABLES['polltopics']} pt"
+        $sql = "SELECT {$_TABLES['comments']}.sid, {$_TABLES['comments']}.title  title, cid, UNIX_TIMESTAMP({$_TABLES['comments']}.date) AS unixdate FROM {$_TABLES['comments']}, {$_TABLES['polltopics']} pt"
             . " WHERE (pt.pid = sid) AND (pt.commentcode >= 0)" . COM_getPermSQL('AND', 0, 2, 'pt')
             . "{$stwhere} ORDER BY unixdate DESC LIMIT $numreturn";
     }