以下是 rpg/eol.php 部分擷取:
代碼: 選擇全部
// ?#125;亡列表\r
$dead_list = '';
if ( isset($HTTP_POST_VARS['go2disp']) )
{
$sql = 'delete from phpbb_rpg_event where event_class = 5 and event_time <= ' . (time() - 86400 * 3) . ' and user_id = ' . $profiledata['user_id'];
$db->sql_query($sql);
$sql = 'select * from phpbb_rpg_event where event_class = 5 and user_id = ' . $profiledata['user_id'] . ' order by event_time desc limit 0, 30';
$result = $db->sql_query($sql);
if ( $row = $db->sql_fetchrow($result) )
{
$i = 1;
$dead_list = '<table width="100%" cellpadding="3" cellspacing="1" border="0" class="forumline">
<tr><td align="center" class="catLeft"><b><span class="gen">#</span></b></td>
<td align="center" class="catLeft"><b><span class="gen">日期</span></b></td>
<td align="center" class="catLeft"><b><span class="gen">金額</span></b></td>
<td align="center" class="catLeft"><b><span class="gen">備註</span></b></td></tr>';
do
{
$dead_list .= '<tr>
<td align="center" class="row3"><span class="gensmall">' . $i . '</span></td>
<td align="center"><span class="gensmall">' . ($row['event_time'] ? create_date($userdata['user_dateformat'], $row['event_time'], $board_config['board_timezone']) : $lang['Never_last_logon']) . '</span></td>
<td align="right"><span class="gensmall">' . number_format($row['event_money']) . '</span></td>
<td><span class="gensmall">' . $row['event_note'] . '</span></td>
</tr>';
$i++;
}
while ( $row = $db->sql_fetchrow($result) );
$dead_list .= '</table>';
}
}
系統會將
三天內, event_class = 5 的會員按 event_time 依序排列出.