function display_suspend_log($user_id, $type = "all", $rowstart = 0, $limit = 0)
{
global $locale;
$db_type = $type != "all" && isnum($type) ? " AND suspend_type='{$type}'" : "";
$rows = dbcount("(suspend_id)", DB_SUSPENDS, "suspended_user='******'{$db_type}");
$result = dbquery("SELECT sp.suspend_id, sp.suspend_ip, sp.suspend_ip_type, sp.suspend_date, sp.suspend_reason,\n\t\tsp.suspend_type, sp.reinstate_date, sp.reinstate_reason, sp.reinstate_ip, sp.reinstate_ip_type,\n\t\ta.user_name AS admin_name, b.user_name AS admin_name_b \n\t\tFROM " . DB_SUSPENDS . " sp \n\t\tLEFT JOIN " . DB_USERS . " a ON sp.suspending_admin=a.user_id \n\t\tLEFT JOIN " . DB_USERS . " b ON sp.reinstating_admin=b.user_id \n\t\tWHERE suspended_user='******'{$db_type}\n\t\tORDER BY suspend_date DESC" . ($limit > 0 ? " LIMIT {$limit}" : ""));
$rows = dbrows($result);
$udata = dbarray(dbquery("SELECT user_name FROM " . DB_USERS . " WHERE user_id='{$user_id}' LIMIT 1"));
if ($type == "all") {
opentable(sprintf($locale['susp100'], $udata['user_name']));
member_nav(member_url("view", $user_id) . "|" . $udata['user_name'], member_url("log", $user_id) . "|" . $locale['susp114']);
} else {
opentable(sprintf($locale['susp100b'], getsuspension($type, true), $udata['user_name']));
}
if ($rows) {
echo "<table width='80%' cellpadding='1' cellspacing='0' class='tbl-border center'>\n<tr>\n";
if ($type == "all") {
$description = sprintf($locale['susp101'], $udata['user_name']);
} else {
$description = sprintf($locale['susp102'], getsuspension($type), $udata['user_name']);
}
echo "<td class='tbl2' width='30'>" . $locale['susp103'] . "</td>\n";
echo "<td class='tbl2' width='120'>" . $locale['susp104'] . "</td>\n";
echo "<td class='tbl2' width='250'>" . $locale['susp105'] . "</td>\n";
echo "<td class='tbl2' width='150'>" . $locale['susp106'] . "</td>\n";
echo "</tr>\n";
$i = 1;
while ($data = dbarray($result)) {
$class = "tbl{$i}";
$suspension = $data['suspend_type'] != 2 ? getsuspension($data['suspend_type']) : $locale['susp111'];
$reason = $data['suspend_reason'] ? ": " . $data['suspend_reason'] : "";
$admin = $data['admin_name'] ? $data['admin_name'] . " (" . $locale['susp108'] . ": " . $data['suspend_ip'] . ")" : $locale['susp109'];
echo "<tr><td class='{$class}' valign='top'>#" . $data['suspend_id'] . "</td>\n";
echo "<td class='{$class}' valign='top'>" . showdate('forumdate', $data['suspend_date']) . "</td>\n";
echo "<td class='{$class}' valign='top'><strong>{$suspension}</strong>{$reason}</td>\n";
echo "<td class='{$class}' valign='top'>{$admin}</td>\n";
echo "</tr>\n<tr>\n";
if ($data['reinstate_date']) {
$r_reason = $data['reinstate_reason'] ? ": " . $data['reinstate_reason'] : "";
$admin = $data['admin_name_b'] ? $data['admin_name_b'] . " (" . $locale['susp112'] . $data['reinstate_ip'] . ")" : $locale['susp109'];
echo "<td class='{$class}' valign='top' align='right'> </td>\n";
echo "<td class='{$class}' valign='top'>" . showdate('forumdate', $data['reinstate_date']) . "</td>\n";
echo "<td class='{$class}' valign='top'>" . $locale['susp113'] . $r_reason . "</td>\n";
echo "<td class='{$class}' valign='top'>{$admin}</td>\n";
echo "</tr>\n<tr>\n";
} elseif ($data['suspend_type'] != 2) {
echo "<td class='{$class}' valign='top' align='right'> </td>\n";
echo "<td class='{$class}' valign='top'> </td>\n";
echo "<td class='{$class}' valign='top'> </td>\n";
echo "<td class='{$class}' valign='top'> </td>\n";
echo "</tr>\n<tr>\n";
}
echo "<td class='tbl1' colspan='4'><hr /></td>\n";
echo "</tr>\n";
if ($i == 2 ? $i = 1 : $i++) {
}
}
echo "</table>\n";
} else {
echo "<div id='close-message'><div class='admin-message'>" . $locale['susp110'] . "</div></div>\n";
}
closetable();
}
echo "<li><a href='{$cancel_link}'>" . getsuspension(5, TRUE) . "</a></li>\n";
echo "<li><a href='{$anon_link}'>" . getsuspension(6, TRUE) . "</a></li>\n";
echo "<li><a href='{$deac_link}'>" . getsuspension(7, TRUE) . "</a></li>\n";
echo "<li><a href='{$inac_link}'>" . getsuspension(8, TRUE) . "</a></li>\n";
echo "</ul>\n";
}
echo "</div>\n";
echo "</td>\n</tr>\n";
$i++;
}
echo "</tbody>\n</table>\n";
} else {
if (isset($_GET['search_text']) && preg_check("/^[-0-9A-Z_@\\s]+\$/i", $_GET['search_text'])) {
echo "<div style='text-align:center'><br />" . sprintf($locale['411'], $status == 0 ? "" : getsuspension($status)) . $locale['413'] . "'" . stripinput($_GET['search_text']) . "'<br /><br />\n</div>\n";
} else {
echo "<div style='text-align:center'><br />" . sprintf($locale['411'], $status == 0 ? "" : getsuspension($status)) . ($_GET['sortby'] == "all" ? "" : $locale['412'] . $_GET['sortby']) . ".<br /><br />\n</div>\n";
}
}
$alphanum = array("A", "B", "C", "D", "E", "F", "G", "H", "I", "J", "K", "L", "M", "N", "O", "P", "Q", "R", "S", "T", "U", "V", "W", "X", "Y", "Z", "0", "1", "2", "3", "4", "5", "6", "7", "8", "9");
echo "<div style='margin-top:10px;'></div>\n";
echo "<table cellpadding='0' cellspacing='1' width='450' class='table table-responsive tbl-border center'>\n<tr>\n";
echo "<td rowspan='2' class='tbl2'><a href='" . FUSION_SELF . $aidlink . "&status=" . $status . "'>" . $locale['414'] . "</a></td>";
for ($i = 0; $i < 36; $i++) {
echo "<td align='center' class='tbl1'><div class='small'><a href='" . FUSION_SELF . $aidlink . "&sortby=" . $alphanum[$i] . "&status={$status}'>" . $alphanum[$i] . "</a></div></td>";
echo $i == 17 ? "<td rowspan='2' class='tbl2'><a href='" . FUSION_SELF . $aidlink . "&status=" . $status . "'>" . $locale['414'] . "</a></td>\n</tr>\n<tr>\n" : "\n";
}
echo "</tr>\n</table>\n";
echo "<hr />\n";
echo openform('searchform', 'searchform', 'post', FUSION_SELF, array('downtime' => 0, 'notice' => 0));
echo "<div style='text-align:center'>\n";
echo form_hidden('', 'aid', 'aid', iAUTH);
