竹貓星球

代碼: 選擇全部

====[ 打開 ]=====
viewforum.php
====[ 找到 ]=====
// End initial var setup
====[ 下面加入 ]=====
//熱門討論區列表\r

$sql = "UPDATE `phpbb_forums` 
SET forums_hot =  forums_hot + 1
WHERE `forum_id` = '$forum_id'"; 
if ( !($result = $db->sql_query($sql)) ) 
{ 
message_die(GENERAL_ERROR, '無法連接資料庫取得熱門討論區列表', '', __LINE__, __FILE__, $sql); 
}
====[ 儲存,關閉 ]=====




====[ 打開 ]=====
viewtopic.php
====[ 找到 ]=====
$sql = "SELECT t.topic_id, t.topic_title, 
====[ 同一行中搜尋 ]=====
f.forum_name, 
====[ 同一行中後面加入 ]=====
f.forums_hot, 
====[ 找到 ]=====
//
// Generate a 'Show posts in previous x days' select box. If the postdays var is POSTed
// then get it's value, find the number of topics with dates newer than it (to properly
// handle pagination) and alter the main query
//
====[ 下面加入 ]=====
//熱門討論區列表 

$sql = "UPDATE `phpbb_forums` 
SET forums_hot =  forums_hot + 1
WHERE `forum_id` = '$forum_id'"; 
if ( !($result = $db->sql_query($sql)) ) 
{ 
message_die(GENERAL_ERROR, '無法連接資料庫取得熱門討論區列表', '', __LINE__, __FILE__, $sql); 
}
====[ 儲存,關閉 ]=====

====[ 打開 ]=====
index.php
====[ 找到 ]=====
// Generate the page
====[ 下面加入 ]=====
//熱門討論區列表\r

$hotforum_sql="SELECT * FROM phpbb_forums ORDER BY `hot_views` DESC LIMIT 0,5"; 
  
$hotforum_result = $db->sql_query($hotforum_sql); 
while (($line = mysql_fetch_array($hotforum_result))) 
{ 
$template->assign_block_vars('forum_hot', array( 
'FORUM_ID' => $line['forum_id'], 
'FORUM_NAME' =>$line['forum_name'],        
'FORUM_HOTVIEWS' => $line['hot_views'], 
));
} 
====[ 儲存,關閉 ]=====






====[ 打開 ]=====
index_body.tpl
====[ 最上面加入 ]=====
//熱門討論區列表\

<table width="100%" cellpadding="2" cellspacing="1" border="0" class="forumline"> 
<tr> 
<td class="row2" height="25"colspan="2"><b>熱門討論區</b></td> 
</tr> 
<!-- BEGIN forum_hot --> 
<td class="row1" align="left" valign="middle"><span class="gensmall"><a href="viewforum.php?f={hot_forum.FORUM_ID}">{hot_forum.FORUM_NAME}</a></span></td> 
<td class="row1" align="left" valign="middle"><span class="gensmall">{hot_forum.FORUM_HOTVIEWS}</span></td> 
</tr> 
<!-- END forum_hot --> 
</table> 
<table border="0" cellpadding="0" cellspacing="0" class="tbl"><tr><td class="tbll"><img src="images/spacer.gif" alt="" width="8" height="4" /></td><td class="tblbot"><img src="images/spacer.gif" alt="" width="8" height="4" /></td><td class="tblr"><img src="images/spacer.gif" alt="" width="8" height="4" /></td></tr></table> 
<br />
====[ 儲存,關閉 ]=====