[外掛]在首頁顯示最後回覆主題

[動機不明]

許多論壇程式都有這功能，偏偏 phpbb 沒有，今天偶然看到的，裝了以後感覺不錯，於是分享給大家

來源：http://www.phpbb2-users.de/phpBB/viewtopic.php?t=77

代碼: 選擇全部

######################################################## 
## Mod Title:  last_topic_title_index    
## Mod Version: 1.0.0 
## Author:       Adam Ismay <admin@boardz.tk> 
## Description:  Gives the topic title in the last post box 
##         on index. 
## 
## Installation Level:  fairly easy 
## Installation Time:   3-5 minutes 
## Files To Edit:       index.php 
##            templates/????/index_body.tpl 
######################################################## 
## Notes: Does not do anything on Postgres or Oracle. The topic 
##      title is shortened to 25. This can be changed in the code 
##      or you can add $board_config['topic_title_index_size'] = ??; 
##      in the template config file which will override this 
##      value. Topic titles are not displayed if the user does 
##      not have the right to read the forum. The link goes to 
##      the start of the topic, the existing link to last post is 
##      unaffected. 
######################################################### 
## Before Adding This MOD To Your Forum, You Should Back Up All Files Related To This MOD 
######################################################### 



# 
#---- [ OPEN ] -------- 
# 

index.php 

# 
#----- [ FIND (line 156) ] ---- 
# 

         $sql = "SELECT f.*, p.post_time, p.post_username, u.username, u.user_id 
            FROM (( " . FORUMS_TABLE . " f 
            LEFT JOIN " . POSTS_TABLE . " p ON p.post_id = f.forum_last_post_id ) 
            LEFT JOIN " . USERS_TABLE . " u ON u.user_id = p.poster_id ) 
            ORDER BY f.cat_id, f.forum_order"; 


# 
#---- [ REPLACE WITH ] ---- 
# 

         $sql = "SELECT f.*, p.post_time, p.post_username, u.username, u.user_id, t.topic_title, t.topic_id 
            FROM ((( " . FORUMS_TABLE . " f 
            LEFT JOIN " . POSTS_TABLE . " p ON p.post_id = f.forum_last_post_id ) 
            LEFT JOIN " . TOPICS_TABLE . " t ON t.topic_id = p.topic_id ) 
            LEFT JOIN " . USERS_TABLE . " u ON u.user_id = p.poster_id ) 
            ORDER BY f.cat_id, f.forum_order"; 

# 
# --- [ FIND (line 250) ] ---- 
# 

$is_auth_ary = auth(AUTH_VIEW, AUTH_LIST_ALL, $userdata, $forum_data); 

# 
#-----[ REPLACE WITH ] ----- 
# 

   $is_auth_ary = auth(AUTH_ALL, AUTH_LIST_ALL, $userdata, $forum_data); 
    if (!isset($board_config['topic_title_index_size'])){ 
       $board_config['topic_title_index_size'] = [color=red]25[/color];  //Set this to size limit 
    } 


# 
# --- [ FIND (line 430) ] ---- 
# 

'MODERATORS' => $moderator_list, 

# 
# ---- [ AFTER, ADD ] --- 
# 

                        'LAST_TOPIC' => $is_auth_ary[$forum_data[$j]['forum_id']]['auth_read'] ? (strlen($forum_data[$j]['topic_title']) > $board_config['topic_title_index_size']) ? substr($forum_data[$j]['topic_title'], 0, ($board_config['topic_title_index_size'] - 2)) . "..." : $forum_data[$j]['topic_title'] : "", 
                        'U_LAST_TOPIC' => append_sid("viewtopic.$phpEx?"  . POST_TOPIC_URL . "=" . $forum_data[$j]['topic_id']), 

# 
#-----[ OPEN ]---- 
# 

templates/subSilver/index_body.tpl 

# 
#----[ FIND ]------- 
# 

   <td class="row2" align="center" valign="middle" height="50" nowrap="nowrap"> <span class="gensmall">{catrow.forumrow.LAST_POST}</span></td> 

# 
#-----[ REPLACE WITH ]--------- 
# 


   <td class="row2" align="center" valign="middle" height="50" nowrap="nowrap"> <span class="gensmall"><a href="{catrow.forumrow.U_LAST_TOPIC}">{catrow.forumrow.LAST_TOPIC}</a><br />{catrow.forumrow.LAST_POST}</span></td> 

# 
#-----[ SAVE ALL FILES ]------------------------------------------ 
# 
# EoM

修改

完成之後由於字數的限制，版面會被撐大一點點，所以請修改紅色的字串，將 25 改為 20 就很完美了！

demo : http://gop.pda.com.tw

[動機不明]

這是另一個版本的

Topics on index (Customisable)
http://www.phpbbhacks.com/viewhack.php?id=1545


此外掛除了在首頁顯示最後回覆外，控制台另外可以設定共要顯示多少字元出來 (預設為30)