Changeset 7083

Timestamp:

May 9, 2008, 7:24:51 PM (14 years ago)

Author:

ebihara

Message:

#2377:コミュニティ指定がなく、かつキーワード指定がないトピック検索の総数が取得できていなかったのを修正

File:

• OpenPNE/trunk/webapp/lib/db/commu.php (modified) (1 diff)

OpenPNE/trunk/webapp/lib/db/commu.php

@@ -3052 +3052 @@
     }
 
-    $sql = 'SELECT COUNT(ct.c_commu_topic_id) FROM c_commu'
+    $sql = 'SELECT COUNT(ct.c_commu_topic_id) FROM c_commu AS c'
          . ' INNER JOIN c_commu_topic AS ct USING(c_commu_id)' . $where;
     $total_num = db_get_one($sql, $params);