但奇怪的是並沒有辦法顯示目前所有的投票活動~~~
以下~小小的修改就能達到！
在我新架站的 demo screen shot
代碼: 選擇全部
#
# ---------[ OPEN] -------------------
# portal.php
# ---------[FIND]---------------------
#
//
// Fetch Poll
#
# ---------[BEFORE ADD] ---------
#
if(isset($HTTP_GET_VARS['viewpoll']))
{
$poll_per_page = 10;
global $db;
$poll_start = ( isset($HTTP_GET_VARS['start']) ) ? intval($HTTP_GET_VARS['start']) : 0;
$poll_order_by = ' t.topic_time DESC LIMIT ' . $poll_start . ', ' . $poll_per_page;
$sql = 'SELECT
t.*,
vd.*
FROM
' . TOPICS_TABLE . ' AS t,
' . VOTE_DESC_TABLE . " AS vd
WHERE
t.topic_status <> 1 AND
t.topic_status <> 2 AND
t.topic_vote = 1 AND
t.topic_id = vd.topic_id
ORDER BY
$poll_order_by";
if (!$query = $db->sql_query($sql))
message_die(GENERAL_ERROR, 'Could not query poll information', '', __LINE__, __FILE__, $sql);
else
{
while ($row = $db->sql_fetchrow($query))
{
$polltotal++;
$template->assign_block_vars('view_poll_row', array(
'VOTE_ID' => $row['vote_id'],
'VOTE_URL' => append_sid('viewtopic.'.$phpEx.'?'.POST_TOPIC_URL.'='.$row['topic_id']),
'VOTE_TITLE' => $row['vote_text'])
);
}
$sql = "SELECT count(*) AS total
FROM
" . TOPICS_TABLE . " AS t,
" . VOTE_DESC_TABLE . " AS vd
WHERE
t.topic_id = vd.topic_id ";
if (!($result = $db->sql_query($sql)))
{
message_die(GENERAL_ERROR, 'Error getting total users', '', __LINE__, __FILE__, $sql);
}
if ( $polltotal = $db->sql_fetchrow($result) )
{
$polltotal = $polltotal['total'];
$pagination = generate_pagination("{$phpbb_root_path}portal.$phpEx?viewpoll=1&", $polltotal, $poll_per_page, $poll_start). ' ';
}
$template->assign_vars(array(
'PAGINATION' => $pagination,
'PAGE_NUMBER' => sprintf($lang['Page_of'], ( floor( $poll_start / $poll_per_page ) + 1 ), ceil( $polltotal / $poll_per_page )),
'L_GOTO_PAGE' => $lang['Goto_page'])
);
}
}
#
# ---------[ OPEN] -------------------
# portal_body.ptl
#
#
#----------[ADD] ----------------
# 放在 你想要的地方\r
<!-- BEGIN view_poll_row -->
<table width="100%" cellpadding="0" cellspacing="0" border="0" >
<tr>
<td align="left" height="30"> <span class="gensmall">no.{view_poll_row.VOTE_ID} <a href={view_poll_row.VOTE_URL}>{view_poll_row.VOTE_TITLE}</a></span></td>
<td align="right"><a href={view_poll_row.VOTE_URL}><img src="templates/SoftBlue/images/button.gif" border="0" alt="View Vote" align="absmiddle"></a></td>
</tr>
</table>
<!-- END view_poll_row -->
{PAGE_NUMBER}<div align="right"> {PAGINATION}</div>
#
# ------------ [SAVE/CLOSE] -------------
#
portal.php?viewpoll=1
自行加在 portal_body.tpl 內的任何地方