[geeklog-hg] geeklog: Fixed incorrect article count in topics block for multi...

[geeklog-cvs at lists.geeklog.net]

changeset 9190:36ec7e9cfbbb
url:  http://project.geeklog.net/cgi-bin/hgwebdir.cgi/geeklog/rev/36ec7e9cfbbb
user: Tom <websitemaster at cogeco.net>
date: Sat Jul 13 13:39:23 2013 -0400
description:
Fixed incorrect article count in topics block for multi language setups

diffstat:

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

diffs (12 lines):

diff -r df2e6539cbf6 -r 36ec7e9cfbbb public_html/lib-common.php
--- a/public_html/lib-common.php	Sat Jul 13 13:37:30 2013 -0400
+++ b/public_html/lib-common.php	Sat Jul 13 13:39:23 2013 -0400
@@ -2995,7 +2995,7 @@
                             $sql = "SELECT sid FROM {$_TABLES['stories']}, {$_TABLES['topic_assignments']} ta "
                                  . 'WHERE (draft_flag = 0) AND (date <= NOW()) '
                                  . COM_getPermSQL('AND')
-                                 . "AND ta.type = 'article' AND ta.id = sid "
+                                 . "AND ta.type = 'article' AND ta.id = sid " . COM_getLangSQL('sid', 'AND')
                                  . "AND (ta.tid IN({$tid_list}) AND (ta.inherit = 1 OR (ta.inherit = 0 AND ta.tid = '{$_TOPICS[$count_topic]['id']}'))) "
                                  . ' GROUP BY sid';