前言:
原本系統預設, 瀏覽相冊時, 只能顯示個人所拍照保存的相片.
因為, 網友
yuei 的建議 '[改寫問題]Face MOD相簿如何顯示所有拍照?',
所以, 改寫了部份語法, 讓
相冊分頁顯示所有會員的拍照.
http://phpbb-tw.net/phpbb/viewtopic.php?t=42517
#
#-----[ OPEN ]-----
#
facealbum.php
#
#-----[ FIND ]-----
#
代碼: 選擇全部
//現實保存照片開始
$albumcookie = $db->sql_query("SELECT * FROM week9_facealbum where userid = $userdata[user_id] order by albumtime DESC");
$break = 1;
while ($useralbum = $db->sql_fetchrow($albumcookie))
{
$userface = $useralbum[useralbum];
//$week9face = "<img src=pic/$useralbum[useralbum]>";
$week9face = "<img src=\"$useralbum[useralbum]\" border=\"0\" alt=\"Fly In Beijing\">";
eval('$xiangpian .= "' . gettemplate('face_album_xiangpian') . '";');
if ($break%4 == 0)
{
$huanhang = "</td></tr><tr><td>";
}
else
{
$huanhang = "";
}
$break++;
$xiangpian = $xiangpian.$huanhang;
}
$db->sql_freeresult($albumcookie);
//結束
#
#-----[ REPLACE WITH ]-----
#
代碼: 選擇全部
/*//現實保存照片開始
$albumcookie = $db->sql_query("SELECT * FROM week9_facealbum where userid = $userdata[user_id] order by albumtime DESC");
$break = 1;
while ($useralbum = $db->sql_fetchrow($albumcookie))
{
$userface = $useralbum[useralbum];
//$week9face = "<img src=pic/$useralbum[useralbum]>";
$week9face = "<img src=\"$useralbum[useralbum]\" border=\"0\" alt=\"Fly In Beijing\">";
eval('$xiangpian .= "' . gettemplate('face_album_xiangpian') . '";');
if ($break%4 == 0)
{
$huanhang = "</td></tr><tr><td>";
}
else
{
$huanhang = "";
}
$break++;
$xiangpian = $xiangpian.$huanhang;
}
$db->sql_freeresult($albumcookie);
//結束*/
// 分頁顯示所有會員拍照 -> 開始
// + 分頁
$start = ( isset($HTTP_GET_VARS['start']) ) ? intval($HTTP_GET_VARS['start']) : 0;
$board_config['useralbum_per_page'] = 10;// 控制每一分頁的相片張數
$order_by = "albumtime DESC LIMIT $start, " . $board_config['useralbum_per_page'];
// - 分頁
$sql = "SELECT *
FROM week9_facealbum
ORDER BY $order_by";
if( !$result = $db->sql_query($sql) )
{
message_die(GENERAL_ERROR, '無法取得相冊資訊', __LINE__, __FILE__, $sql);
}
while ($useralbum = $db->sql_fetchrow($result))
{
$userface = $useralbum[useralbum];
//$week9face = "<img src=pic/$useralbum[useralbum]>";
$week9face = "<img src=\"$useralbum[useralbum]\" border=\"0\" alt=\"$useralbum[albumjianjie]\">";
eval('$xiangpian .= "' . gettemplate('face_album_xiangpian') . '";');
if ($break%4 == 0)
{
$huanhang = "</td></tr><tr><td>";
}
else
{
$huanhang = "";
}
$break++;
$xiangpian = $xiangpian.$huanhang;
}
// + 分頁
$sql = "SELECT count(*) AS total
FROM week9_facealbum";
if( !$result = $db->sql_query($sql) )
{
message_die(GENERAL_ERROR, '無法取得相冊資訊', __LINE__, __FILE__, $sql);
}
if ( $total = $db->sql_fetchrow($result) )
{
$total_useralbum = $total['total'];
$pagination = generate_pagination("facealbum.$phpEx?", $total_useralbum, $board_config['useralbum_per_page'], $start);
}
$template->assign_vars(array(
'PAGINATION' => $pagination,
'PAGE_NUMBER' => sprintf($lang['Page_of'], ( floor( $start / $board_config['useralbum_per_page']) + 1 ), ceil( $total_useralbum / $board_config['useralbum_per_page'] )),
'L_GOTO_PAGE' => $lang['Goto_page'])
);
// - 分頁
// 分頁顯示所有會員拍照 -> 結束
#
#-----[ FIND ]-----
#
代碼: 選擇全部
感謝您使用$board_config[sitename]提供的虛擬形象。相片刪除成功！
#
#-----[ REPLACE WITH ]-----
#
代碼: 選擇全部
如果這張相片是您本人所拍的, 那麼相片刪除成功; 否則, 您只是白費力氣!
#
#-----[ OPEN ]-----
#
templates/subSilver/facealbum.tpl
#
#-----[ FIND ]-----
#
代碼: 選擇全部
<table><tr><td>
{CENTER}
</td></tr></table>
#
#-----[ REPLACE WITH ]-----
#
代碼: 選擇全部
<table width="100%" cellspacing="2" border="0" align="center" cellpadding="2">
<tr>
<td align="left"><span class="nav">{PAGE_NUMBER}</span></td>
<td align="right" valign="middle" nowrap="nowrap"><span class="nav">{PAGINATION}</span></td>
</tr>
</table>
<table><tr><td>
{CENTER}
</td></tr></table>
<table width="100%" cellspacing="2" border="0" align="center" cellpadding="2">
<tr>
<td align="left"><span class="nav">{PAGE_NUMBER}</span></td>
<td align="right" valign="middle" nowrap="nowrap"><span class="nav">{PAGINATION}</span></td>
</tr>
</table>
#
#-----[ OPEN ]-----
# ps. 進入 phpMyAdmin 找到論壇資料庫
phpbb -> (資料表) template -> (欄位) face_album_xiangpian -> 按 '
編輯'
#
#-----[ FIND ]-----
#
代碼: 選擇全部
<tr>
<td align="center"><a class="mainmenu" href=facealbum.php?action=delalbum&id=$useralbum[id] title="$useralbum[albumjianjie]">刪除相片</a><br></td>
</tr>
#
#-----[ BEFORE, ADD ]-----
# ps. 修改後, 按 '
執行'
代碼: 選擇全部
<tr>
<td align="center"><a class="mainmenu" href="profile.php?mode=viewprofile&u=$useralbum[userid]" title="檢視個人資料">會員編號: $useralbum[userid]</a></td>
</tr>
#
#-----[ SAVE & CLOSE ]-----
#
#EoM
圖片展示:
