[geeklog-hg] geeklog: Fixed mistake in mssql and pgsql statements

[geeklog-cvs at lists.geeklog.net]

changeset 9189:df2e6539cbf6
url:  http://project.geeklog.net/cgi-bin/hgwebdir.cgi/geeklog/rev/df2e6539cbf6
user: Tom <websitemaster at cogeco.net>
date: Sat Jul 13 13:37:30 2013 -0400
description:
Fixed mistake in mssql and pgsql statements

diffstat:

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

diffs (21 lines):

diff -r d2185e02e82d -r df2e6539cbf6 public_html/index.php
--- a/public_html/index.php	Sat Jul 13 13:32:01 2013 -0400
+++ b/public_html/index.php	Sat Jul 13 13:37:30 2013 -0400
@@ -305,7 +305,7 @@
          . $userfields . ", t.topic, t.imageurl "
          . "FROM {$_TABLES['stories']} AS s, {$_TABLES['topic_assignments']} AS ta, {$_TABLES['users']} AS u, "
          . "{$_TABLES['topics']} AS t WHERE (s.uid = u.uid) AND (ta.tid = t.tid) AND"
-         . " ta.type = 'article' AND ta.id = s.sid AND " . COM_getLangSQL('sid', 'AND', 's') . " AND "
+         . " ta.type = 'article' AND ta.id = s.sid " . COM_getLangSQL('sid', 'AND', 's') . " AND "
          . $sql . " GROUP BY s.sid ORDER BY featured DESC, date DESC LIMIT $offset, $limit";   
          
 $msql['pgsql'] = "SELECT s.*, ta.tid, UNIX_TIMESTAMP(s.date) AS unixdate,
@@ -313,7 +313,7 @@
             {$userfields}, t.topic, t.imageurl
             FROM {$_TABLES['stories']} AS s, {$_TABLES['topic_assignments']} AS ta, {$_TABLES['users']} AS u,
             {$_TABLES['topics']} AS t WHERE (s.uid = u.uid) AND (ta.tid = t.tid) AND 
-            ta.type = 'article' AND ta.id = s.sid AND  " . COM_getLangSQL('sid', 'AND', 's') . " AND 
+            ta.type = 'article' AND ta.id = s.sid " . COM_getLangSQL('sid', 'AND', 's') . " AND 
             {$sql} GROUP BY s.sid, ta.tid, expireunix, {$userfields}, t.topic, t.imageurl ORDER BY featured DESC, date DESC LIMIT {$offset}, {$limit}";   
 
 $result = DB_query ($msql);