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

Changeset 2183


Ignore:
Timestamp:
Mar 19, 2007, 7:26:15 PM (13 years ago)
Author:
takanashi
Message:

#520 2.7.3のコミュニティ検索で非公開の内容が見えてしまうバグの修正確認(r2142)

File:
1 edited

Legend:

Unmodified
Added
Removed
  • OpenPNE/trunk/webapp/lib/db/commu.php

    r2040 r2183  
    26542654
    26552655        $params = array();
    2656         $from = ' FROM c_commu_topic_comment as ctc, c_commu_topic as ct';
    2657         $where = ' WHERE ct.c_commu_topic_id = ctc.c_commu_topic_id';
     2656        $from = ' FROM c_commu_topic_comment as ctc, c_commu_topic as ct, c_commu as c';
     2657        $where = ' WHERE ct.c_commu_topic_id = ctc.c_commu_topic_id'.
     2658                 ' AND c.c_commu_id = ct.c_commu_id'.
     2659                 ' AND c.public_flag <> ?';
     2660        $params[] = 'auth_commu_member';
    26582661
    26592662        $words = explode(' ', $search_word);
     
    26712674               ' order by ctc.r_datetime DESC';
    26722675    } else {
    2673         $from = ' FROM c_commu_topic_comment';
    2674         $where = '';
    2675         $sql = 'SELECT *' . $from . ' order by r_datetime DESC';
     2676        $from = ' FROM c_commu_topic_comment as ctc, c_commu as c';
     2677        $where = ' WHERE c.c_commu_id = ctc.c_commu_id'.
     2678                 ' AND c.public_flag <> ?';
     2679        $params[] = 'auth_commu_member';
     2680
     2681        $sql = 'SELECT ctc.*' . $from . $where . ' order by ctc.r_datetime DESC';
    26762682    }
    26772683
Note: See TracChangeset for help on using the changeset viewer.