[研究] phpbb 3.0.10 安裝TOP5模組(Integrated Topiclist 2.0 beta)

[研究] phpbb 3.0.10 安裝TOP5模組(Integrated Topiclist 2.0 beta)

本篇是接續

[研究] phpbb 3.0.10 快速安裝程式 (CentOS 6.2 x86)
http://shaurong.blogspot.com/2012/01/phpbb-3.html
[研究] phpbb 3.0.10 安裝RSS模組(simple syndication 1.1.1b)
http://shaurong.blogspot.com/2012/01/phpbb-3010-rsssimple-syndication-111b.html


Integrated Topiclist 2.0 beta下載
http://phpbb-tw.net/phpbb/viewtopic.php?f=134&t=50165
http://phpbb-tw.net/phpbb/download/file.php?id=11

IT2.rar這個模組的缺點是只支援subsilver2，不支援prosilver。所以 phpbb 需要先將風格從預設的 prosilver 切換為 subsilver2

安裝步驟如下(這個寫快速安裝程式會累死)：

打開 

代碼:

index.php

找到 

代碼:

// Assign index specific vars

在後面加入

代碼:

//
// Integrated Topiclist v 2.0 START
// 

// Topics text length
$MAX_STR_LEN = 40;
   
// Topics to display (Default: 5)
$MAX_TOPICS = 5;
   
// Order by
// topic_last_post_id (Default)
// topic_replies
// topic_views
$sortby="topic_last_post_id";

//
// Option of Toplist End
//

function cutStr($str) {
   global $MAX_STR_LEN;
   $str = (strlen($str) > $MAX_STR_LEN) ? (substr($str, 0, $MAX_STR_LEN - 1) . "...") : $str;
   return $str;
} 

$raw_auth_forums = $auth->acl_getf('f_read');

$auth_forums = array();

while(list($k,$v)=each($raw_auth_forums)) if($v['f_read'] == 1) $auth_forums[] =$k;

$auth_forums_sql = implode(',',$auth_forums);

$sql_array['SELECT'] = array('t.topic_id','t.topic_replies','t.topic_views','t.forum_id','f.forum_name','t.topic_title','t.topic_first_poster_colour','t.topic_first_poster_name','t.topic_last_poster_id','t.topic_last_post_id','t.topic_last_poster_name','t.topic_last_poster_colour','t.topic_last_post_time','t.topic_poster');
$sql_array['FROM'] = array(TOPICS_TABLE      => 't',FORUMS_TABLE => 'f');

// SQL array for obtaining topics/stickies
$sql_array = array(
   'SELECT'      => implode(',',$sql_array['SELECT']),
   'FROM'         =>  $sql_array['FROM'],
   'WHERE'         => ' t.forum_id IN ('.$auth_forums_sql .') AND f.forum_id = t.forum_id',
   'ORDER_BY'      => 't.'.$sortby.' DESC'
);

$sql = $db->sql_build_query('SELECT', $sql_array);
$result = $db->sql_query_limit($sql, $MAX_TOPICS, 0);

while ($row = $db->sql_fetchrow($result))
{
      $view_topic_url = append_sid("{$phpbb_root_path}viewtopic.$phpEx", 'f=' . (($row['forum_id']) ? $row['forum_id'] : $forum_id) . '&t=' . $row['topic_id']);
      
      $template->assign_block_vars('topiclist', array(
            'TOPIC_TITLE' => cutStr($row['topic_title']),
            'FORUM_NAME' => $row['forum_name'],
            'FORUM_ID' => $row['forum_id'],
            
            'LAST_REPLY_TIME' => $user->format_date($row['topic_last_post_time']),
            'LAST_REPLYER' => get_username_string('full', $row['topic_last_poster_id'], $row['topic_last_poster_name'], $row['topic_last_poster_colour']),
            
            'U_LAST_POST_POSTER'   => get_username_string('profile', $row['topic_last_poster_id'], $row['topic_last_poster_name'], $row['topic_last_poster_colour']),
            
            'U_TOPIC_POSTER'      => get_username_string('profile', $row['topic_poster'], $row['topic_first_poster_name'], $row['topic_first_poster_colour']),
            'TOPIC_REPLIES' => $row['topic_replies'],
            'TOPIC_VIEWS' => $row['topic_views'],
            'U_LAST_POST'         => $view_topic_url . '&p=' . $row['topic_last_post_id'] . '#p' . $row['topic_last_post_id'],
            
            'TOPIC_POSTER' => get_username_string('full', $row['topic_poster'], $row['topic_first_poster_name'], $row['topic_first_poster_colour']),
            
            'FORUM_ID' => $row['forum_id'],
            
            'FORUM_URL' => append_sid("{$phpbb_root_path}viewforum.$phpEx", 'f=' . $row['forum_id']),
            'TOPIC_URL'  => $view_topic_url
         )
      );
}
$db->sql_freeresult($result);
//
// Integrated Topiclist V 2.0 END
//

然後請打開

代碼:

styles/subsilver2/template/index_body.html

找到

代碼:

<!-- INCLUDE overall_footer.html -->

在其前加上
(原來版本)

代碼:

<!-- MOD: Integrated Topiclist 2.0 START -->
   <br clear="all" />
   <br>
   <table class="tablebg" width="95%" cellspacing="1">
      <tr>
         <th width="20%">&nbsp;{L_FORUM}&nbsp;</th>
         <th width="30%">&nbsp;{L_TOPICS}&nbsp;</th>
         <th width="20%">&nbsp;{L_AUTHOR}&nbsp;</th>
         <th width="5%">&nbsp;{L_REPLIES}&nbsp;</th>
         <th width="5%">&nbsp;{L_VIEWS}&nbsp;</th>
         <th width="20%">&nbsp;{L_LAST_POST}&nbsp;</th>
      </tr>
<!-- BEGIN topiclist -->
      <tr>
         <td class="row1" align="center"><a class="forumlink" href="{topiclist.FORUM_URL}">{topiclist.FORUM_NAME}</a></td>
         <td class="row2" align="center"><a href="{topiclist.TOPIC_URL}" class="topictitle">{topiclist.TOPIC_TITLE}</a></td>
         <td class="row1" align="center"><p class="topiclist"><a href="{topiclist.U_TOPIC_POSTER}">{topiclist.TOPIC_POSTER}</a></p></td>
         <td class="row2" align="center">{topiclist.TOPIC_REPLIES}</td>
         <td class="row1" align="center">{topiclist.TOPIC_VIEWS}</td>
         <td class="row2" align="center">{topiclist.LAST_REPLY_TIME}<br />{topiclist.LAST_REPLYER}<a href="{topiclist.U_LAST_POST}">{LAST_POST_IMG}</a></td>
      </tr>
<!-- END topiclist -->
   </table>
   <br>
<!-- MOD: Integrated Topiclist 2.0 END -->

(小弟的改良版本)

代碼:

<!-- MOD: Integrated Topiclist 2.0 START -->
   <br clear="all" />
   
   <table class="tablebg" width="100%" cellspacing="1">
      <tr>
         <th>&nbsp;{L_FORUM}&nbsp;</th>
         <th>&nbsp;{L_TOPICS}&nbsp;</th>
         <th>&nbsp;{L_AUTHOR}&nbsp;</th>
         <th>&nbsp;{L_REPLIES}&nbsp;</th>
         <th>&nbsp;{L_VIEWS}&nbsp;</th>
         <th>&nbsp;{L_LAST_POST}&nbsp;</th>
      </tr>
<!-- BEGIN topiclist -->
      <tr>
         <td class="row1" align="left"><a class="forumlink" href="{topiclist.FORUM_URL}">{topiclist.FORUM_NAME}</a></td>
         <td class="row2" align="left"><a href="{topiclist.TOPIC_URL}" class="topictitle">{topiclist.TOPIC_TITLE}</a></td>
         <td class="row1" align="left"><p class="topiclist"><a href="{topiclist.U_TOPIC_POSTER}">{topiclist.TOPIC_POSTER}</a></p></td>
         <td class="row2" align="left">{topiclist.TOPIC_REPLIES}</td>
         <td class="row1" align="left">{topiclist.TOPIC_VIEWS}</td>
         <td class="row2" align="left">{topiclist.LAST_REPLY_TIME}<br />{topiclist.LAST_REPLYER}<a href="{topiclist.U_LAST_POST}">{LAST_POST_IMG}</a></td>
      </tr>
<!-- END topiclist -->
   </table>
<!-- MOD: Integrated Topiclist 2.0 END -->

index.php補充說明

代碼:

// Topics text length
$MAX_STR_LEN = 40; 主題名稱最長長度(建議改400)

// Topics to display (Default: 5)
$MAX_TOPICS = 5; 顯示主題個數 (建議改20)

// Order by
// topic_last_post_id 發表時間(預設)
// topic_replies 回覆數
// topic_views 觀看數
$sortby="topic_last_post_id"; 依何而排? (自上方三種選來用)

//
// Option of Toplist End
//

如果畫面沒有變化，把 phpbb 根目錄下的 cache 子目錄下的檔案全砍。

若仍沒用，把

代碼:

$template->set_filenames(array(
   'body' => 'index_body.html')
);

改為

代碼:

$template->set_filenames(array(
   'body' => 'index_body2.html')
);

./styles/subsilver2/template 目錄中
把 index_body.html 改為 index_body2.html 

如果發生index_body載入過，怎麼修改都無效時，可每改一次index_body.html就換一次名稱。

(完)