Changeset 6399 for OpenPNE/branches/work/toraneko/prj_commentmail/webapp/lib/db/commu.php

Timestamp:

Apr 8, 2008, 12:20:33 AM (14 years ago)

Author:

toraneko

Message:

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

File:

• OpenPNE/branches/work/toraneko/prj_commentmail/webapp/lib/db/commu.php (modified) (1 diff)

OpenPNE/branches/work/toraneko/prj_commentmail/webapp/lib/db/commu.php

@@ -3023 +3023 @@
 }
 
+/*
+ * 新着トピック
+ */
+function p_h_home_c_topic_all_list($limit)
+{
+    $sql = 'SELECT ct.*,c.name as c_commu_name, c.c_commu_id'
+          . ' FROM c_commu_topic as ct'
+          . ' INNER JOIN c_commu as c USING(c_commu_id)'
+          . ' WHERE c.public_flag IN (\'public\', \'auth_sns\')'
+          . ' ORDER BY r_datetime_comment DESC';
+    $c_topic_all_list = db_get_all_limit($sql,0,$limit);
+    foreach($c_topic_all_list as $key=>$value) {
+        $number = db_commu_get_max_number4topic($value['c_commu_topic_id']);
+        $c_topic_all_list[$key]['number'] = $number;
+    }
+    return $c_topic_all_list;
+}
+
 ?>