{$num_permabans} mingebags have got themselves permabanned.
";
// select all bans to work out how many there are - this is required for pagenation
$sql = "SELECT * FROM gbans";
$result = mysql_query($sql);
$counttotal = mysql_num_rows($result); // work out how many bans there are
//select data to display in table
$sql = "SELECT steamid, name, time, unban_time, comment, adminname FROM gbans ORDER BY time DESC LIMIT $start, $items";
$result = mysql_query($sql);
?>
SteamID
Time
Name
Reason
Banned by
Time left
' || trim($name)=='')
{
$name = "Unknown";
}
//Check if banned via console
if (trim($bannedby)=='' || trim($bannedby)=='')
{
$bannedby = "Console";
}
//Determine time left, and display info accordingly
if ($banlift == "0000-00-00 00:00:00")
{
$timeleft = "Forever";
}
else
{
$banlift_unix = strtotime($banlift);
$secondsleft = round($banlift_unix - $timenow_unix);
if ($secondsleft > 0)
{
$minutesleft = floor(($secondsleft % 3600)/60);
$hoursleft = floor($secondsleft / 3600);
$timeleft = "{$hoursleft} hrs, {$minutesleft} mins";
}
else
{
$timeleft = "Ban is over!";
}
}
//Check if row is odd or even - this allows teh sexy alternating colours
if (($rownum % 2) == 0) // if the modulus is 0, then the row number is even,.
{
echo "
";
$total_pages = ceil($counttotal / $items); // dive the total, by the maximum results to show
if($page > 1)
{ // is the page number more than 1?
$prev = ($page - 1); // if so, do the following. take 1 away from the current page number
echo '<< Previous '; // echo a previous page link
}
for($i = 1; $i <= $total_pages; $i++){// for each page number
if($page == $i) // if this page were about to echo = the current page
{
echo '' . $i . ' '; // echo the page number bold
} else {
echo "{$i} "; // echo a link to the page
}
}
if($page < $total_pages)
{ // is there a next page?
$next = ($page + 1); // if so, add 1 to the current
echo 'Next >>'; // echo the next page link
}
echo "
";
mysql_close($con);
?>
Ban list page written by Lt. Smith, based upon an original idea by Ninjadude101.