Changeset 7329

Timestamp:

May 22, 2008, 9:26:47 PM (14 years ago)

Author:

ebihara

Message:

#2365:ポータルにコミュニティ書き込みを表示する場合、掲示板の公開範囲設定を考慮するようにした

File:

• OpenPNE/branches/stable-2.12.x/webapp/modules/portal/lib/db_portal.php (modified) (2 diffs)

OpenPNE/branches/stable-2.12.x/webapp/modules/portal/lib/db_portal.php

@@ -257 +257 @@
 function db_portal_c_commu_event($today, $from, $count)
 {
-    $sql = 'select cc.name as community_name, cct.name as event_name, cct.open_date as open_date from c_commu cc, c_commu_topic cct where cc.c_commu_id = cct.c_commu_id and cct.event_flag = ? and cct.open_date > ? and public_flag = ? order by cct.open_date';
-    $params = array('1', $today, 'public');
+    $sql = 'select cc.name as community_name, cct.name as event_name, cct.open_date as open_date from c_commu cc, c_commu_topic cct where cc.c_commu_id = cct.c_commu_id and cct.event_flag = ? and cct.open_date > ? and public_flag <> ? order by cct.open_date';
+    $params = array('1', $today, 'auth_commu_member');
     return db_get_all_limit($sql, $from, $count, $params);
 }
@@ -277 +277 @@
     $from = " FROM c_commu_topic as ct"
           . " LEFT JOIN c_commu as c ON c.c_commu_id = ct.c_commu_id";
-    $where = " WHERE c.public_flag = 'public'";
+    $where = " WHERE c.public_flag <> 'auth_commu_member'";
     $order = " ORDER BY ct.u_datetime DESC";