Changeset 6399
- Timestamp:
- Apr 8, 2008, 12:20:33 AM (15 years ago)
- Location:
- OpenPNE/branches/work/toraneko/prj_commentmail
- Files:
-
- 2 added
- 6 edited
Legend:
- Unmodified
- Added
- Removed
-
OpenPNE/branches/work/toraneko/prj_commentmail/setup/sql/mysql41/update/update-for2.12-useroption.sql
r6393 r6399 18 18 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 19 19 20 /* 最新情報の表示オプション */ 21 INSERT INTO `c_member_config_option` VALUES (NULL,'DISPLAY_OFF_NEWDIARY_HOME'); 22 INSERT INTO `c_member_config_option` VALUES (NULL,'DISPLAY_OFF_NEWTOPIC_HOME'); 20 23 -
OpenPNE/branches/work/toraneko/prj_commentmail/webapp/lib/db/commu.php
r5885 r6399 3023 3023 } 3024 3024 3025 /* 3026 * 新着トピック 3027 */ 3028 function 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 3025 3043 ?> -
OpenPNE/branches/work/toraneko/prj_commentmail/webapp/lib/db/diary.php
r5998 r6399 1259 1259 } 1260 1260 1261 /** 1262 * SNS全体の最新日記リスト取得 1263 * 日記公開範囲を考慮 1264 * 1265 * @param int $limit 1266 * @return array_of_array (c_diary.*, nickname) 1267 */ 1268 function p_h_home_c_diary_all_list($limit) 1269 { 1270 static $is_recurred = false; //再帰処理中かどうかの判定フラグ 1271 1272 if (!$is_recurred) { //function cacheのために再帰処理を行う 1273 $is_recurred = true; 1274 $funcargs = func_get_args(); 1275 return pne_cache_recursive_call(OPENPNE_FUNCTION_CACHE_LIFETIME_FAST, __FUNCTION__, $funcargs); 1276 } 1277 1278 $is_recurred = false; 1279 1280 $sql = 'SELECT * FROM c_diary WHERE public_flag <> \'private\'' 1281 . ' ORDER BY c_diary.r_datetime DESC'; 1282 1283 $c_diary_list_all = db_get_all_limit($sql, 0, $limit); 1284 1285 foreach ($c_diary_list_all as $key => $value) { 1286 $c_member = db_common_c_member4c_member_id_LIGHT($value['c_member_id']); 1287 $c_diary_list_all[$key]['nickname'] = $c_member['nickname']; 1288 $c_diary_list_all[$key]['count_comments'] = db_diary_count_c_diary_comment4c_diary_id($value['c_diary_id']); 1289 } 1290 return $c_diary_list_all; 1291 } 1292 1261 1293 ?> -
OpenPNE/branches/work/toraneko/prj_commentmail/webapp/modules/pc/page/h_home.php
r4933 r6399 18 18 $inc_navi = fetch_inc_navi('h'); 19 19 $this->set('inc_navi', $inc_navi); 20 21 $OPTION = $this->get('C_MEMBER_CONFIG'); 20 22 21 23 /// infomation /// … … 68 70 /// 最新情報 /// 69 71 72 // 最新日記 73 if(DISPLAY_NEWDIARYTOPIC_HOME && !$OPTION['DISPLAY_OFF_NEWDIARY_HOME']){ 74 $this->set('c_diary_list_all', p_h_home_c_diary_all_list(5)); 75 } 70 76 // フレンド最新日記 71 77 $c_diary_friend_list = p_h_home_c_diary_friend_list4c_member_id($u, 5); … … 76 82 $c_diary_my_comment_list = p_h_home_c_diary_my_comment_list4c_member_id($u, 5); 77 83 $this->set('c_diary_my_comment_list', $c_diary_my_comment_list); 84 // コミュニティ全ての新着書き込み 85 if(DISPLAY_NEWDIARYTOPIC_HOME && !$OPTION['DISPLAY_OFF_NEWTOPIC_HOME']){ 86 $this->set('c_topic_list_all', p_h_home_c_topic_all_list(5)); 87 } 78 88 // 参加コミュニティの新着書き込み 79 89 $this->set('c_commu_topic_comment_list', db_commu_c_commu_topic_comment_list4c_member_id($u, 5)); -
OpenPNE/branches/work/toraneko/prj_commentmail/webapp/modules/pc/templates/h_config.tpl
r6102 r6399 198 198 </div></div> 199 199 ({* }}} *}) 200 201 ({if $smarty.const.DISPLAY_NEWDIARYTOPIC_HOME}) 202 ({* {{{ formTable *}) 203 <div class="dparts formTable"><div class="parts"> 204 <div class="partsHeading"><h3>その他オプション設定変更</h3></div> 205 ({t_form_block m=pc a=do_h_member_config}) 206 <table> 207 <tr> 208 <th>マイホームへの最新情報表示</th> 209 <td> 210 <p>SNS全体の最新日記</p> 211 <ul> 212 <li><input type="radio" class="input_radio" name="DISPLAY_OFF_NEWDIARY_HOME" id="display_off_newdiary_home_0" value="0"({if $C_MEMBER_CONFIG.DISPLAY_OFF_NEWDIARY_HOME == 0}) checked="checked"({/if}) /><label for="display_off_newdiary_home_0">表示する</label></li> 213 <li><input type="radio" class="input_radio" name="DISPLAY_OFF_NEWDIARY_HOME" id="display_off_newdiary_home_1" value="1"({if $C_MEMBER_CONFIG.DISPLAY_OFF_NEWDIARY_HOME == 1}) checked="checked"({/if}) /><label for="display_off_newdiary_home_1">表示しない</label></li> 214 </ul> 215 <p>SNS全体の最新トピック</p> 216 <ul> 217 <li><input type="radio" class="input_radio" name="DISPLAY_OFF_NEWTOPIC_HOME" id="display_off_newtopic_home_0" value="0"({if $C_MEMBER_CONFIG.DISPLAY_OFF_NEWTOPIC_HOME == 0}) checked="checked"({/if}) /><label for="display_off_newtopic_home_0">表示する</label></li> 218 <li><input type="radio" class="input_radio" name="DISPLAY_OFF_NEWTOPIC_HOME" id="display_off_newtopic_home_1" value="1"({if $C_MEMBER_CONFIG.DISPLAY_OFF_NEWTOPIC_HOME == 1}) checked="checked"({/if}) /><label for="display_off_newtopic_home_1">表示しない</label></li> 219 </ul> 220 <p>※マイホームに表示する情報を選択出来ます。</p> 221 </td> 222 </tr> 223 </table> 224 <div class="operation"> 225 <ul class="moreInfo button"> 226 <li><input type="submit" class="input_submit" value="設定変更" /></li> 227 </ul> 228 </div> 229 ({/t_form_block}) 230 </div></div> 231 ({* }}} *}) 232 ({/if}) 233 200 234 201 235 ({* {{{ formTable *}) -
OpenPNE/branches/work/toraneko/prj_commentmail/webapp/modules/pc/templates/h_home.tpl
r6014 r6399 379 379 ({if $inc_entry_point[9]})({$inc_entry_point[9]|smarty:nodefaults|t_url2cmd:'entry_point'|t_cmd:'entry_point'})({/if}) 380 380 381 ({if $c_diary_ friend_list || $c_rss_cache_list || $c_diary_my_comment_list || $c_commu_topic_comment_list || $c_friend_review_list || $bookmark_diary_list || $bookmark_blog_list})381 ({if $c_diary_list_all || $c_topic_list_all || $c_diary_friend_list || $c_rss_cache_list || $c_diary_my_comment_list || $c_commu_topic_comment_list || $c_friend_review_list || $bookmark_diary_list || $bookmark_blog_list}) 382 382 ({* {{{ homeMainTable *}) 383 383 <div class="dparts homeMainTable"><div class="parts"> 384 384 <div class="partsHeading"><h3>最新情報</h3></div> 385 385 <table> 386 ({if $c_diary_list_all}) 387 <tr><th>最新日記<br />一覧</th><td> 388 <dl class="articleList"> 389 ({foreach from=$c_diary_list_all item=item}) 390 <dt>({$item.r_datetime|date_format:"%m月%d日"})</dt><dd><a href="({t_url m=pc a=page_fh_diary})&target_c_diary_id=({$item.c_diary_id})&comment_count=({$item.count_comments})">({$item.subject|t_truncate:30}) (({$item.count_comments|default:0}))</a> (({$item.nickname|default:" "})) ({if $item.image_filename_1 || $item.image_filename_2 || $item.image_filename_3})<img src="({t_img_url_skin filename=icon_camera})" alt="写真あり" />({/if})</dd> 391 ({/foreach}) 392 </dl> 393 <div class="moreInfo"><ul class="moreInfo"> 394 <li><a href="({t_url m=pc a=page_h_diary_list_all})">もっと読む</a></li> 395 </ul></div> 396 </td></tr> 397 ({/if}) 386 398 ({if $c_diary_friend_list}) 387 399 <tr><th>({$WORD_MY_FRIEND})<br />最新日記</th><td> … … 417 429 <div class="moreInfo"><ul class="moreInfo"> 418 430 <li><a href="({t_url m=pc a=page_h_diary_comment_list})">もっと読む</a></li> 431 </ul></div> 432 </td></tr> 433 ({/if}) 434 ({if $c_topic_list_all}) 435 <tr><th>最新トピック<br />一覧</th><td> 436 <dl class="articleList"> 437 ({foreach from=$c_topic_list_all item=item}) 438 <dt>({$item.r_datetime|date_format:"%m月%d日"})</dt><dd><a href="({t_url m=pc a=page_c_topic_detail})&target_c_commu_topic_id=({$item.c_commu_topic_id})&comment_count=({$item.number})">({$item.name|t_truncate:30}) (({$item.number}))</a> (({$item.c_commu_name})) ({if $item.image_filename1 || $item.image_filename2 || $item.image_filename3})<img src="({t_img_url_skin filename=icon_camera})" alt="写真あり" />({/if})</dd> 439 ({/foreach}) 440 </dl> 441 <div class="moreInfo"><ul class="moreInfo"> 442 <li><a href="({t_url m=pc a=page_h_com_topic_find_all})">もっと読む</a></li> 419 443 </ul></div> 420 444 </td></tr>
Note: See TracChangeset
for help on using the changeset viewer.