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

Ignore:
Timestamp:
Apr 8, 2008, 12:20:33 AM (14 years ago)
Author:
toraneko
Message:

#2181 SNSの最新情報をマイホームに出す(PC)

File:
1 edited

Legend:

Unmodified
Added
Removed
  • OpenPNE/branches/work/toraneko/prj_commentmail/webapp/lib/db/commu.php

    r5885 r6399  
    30233023}
    30243024
     3025/*
     3026 * 新着トピック
     3027 */
     3028function p_h_home_c_topic_all_list($limit)
     3029{
     3030    $sql = 'SELECT ct.*,c.name as c_commu_name, c.c_commu_id'
     3031          . ' FROM c_commu_topic as ct'
     3032          . ' INNER JOIN c_commu as c USING(c_commu_id)'
     3033          . ' WHERE c.public_flag IN (\'public\', \'auth_sns\')'
     3034          . ' ORDER BY r_datetime_comment DESC';
     3035    $c_topic_all_list = db_get_all_limit($sql,0,$limit);
     3036    foreach($c_topic_all_list as $key=>$value) {
     3037        $number = db_commu_get_max_number4topic($value['c_commu_topic_id']);
     3038        $c_topic_all_list[$key]['number'] = $number;
     3039    }
     3040    return $c_topic_all_list;
     3041}
     3042
    30253043?>
Note: See TracChangeset for help on using the changeset viewer.