ここの情報は古いです。ご理解頂いた上でお取り扱いください。

Changeset 7329


Ignore:
Timestamp:
May 22, 2008, 9:26:47 PM (11 years ago)
Author:
ebihara
Message:

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

File:
1 edited

Legend:

Unmodified
Added
Removed
  • OpenPNE/branches/stable-2.12.x/webapp/modules/portal/lib/db_portal.php

    r7272 r7329  
    257257function db_portal_c_commu_event($today, $from, $count)
    258258{
    259     $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';
    260     $params = array('1', $today, 'public');
     259    $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';
     260    $params = array('1', $today, 'auth_commu_member');
    261261    return db_get_all_limit($sql, $from, $count, $params);
    262262}
     
    277277    $from = " FROM c_commu_topic as ct"
    278278          . " LEFT JOIN c_commu as c ON c.c_commu_id = ct.c_commu_id";
    279     $where = " WHERE c.public_flag = 'public'";
     279    $where = " WHERE c.public_flag <> 'auth_commu_member'";
    280280    $order = " ORDER BY ct.u_datetime DESC";
    281281
Note: See TracChangeset for help on using the changeset viewer.