<?PHP
//////////////////
/// CREATED BY ///
///   SAMME    ///
/////  FROM  /////
/// OTLAND.NET ///
//////////////////

//Please respect the copyrights!//

// AND banend < UNIX_TIMESTAMP(NOW())

$ban_reason = array("offensive name", "name containing part of sentence", "name with nonsensical letter combination", "invalid name format", "name not describing person", "name of celebrity", "name reffering to country", "Offtopic (Forum)", "name to fake official position", "offensive statement", "spamming", "advertisement not related to game", "macro use", "<center>--></center>", "off-topic public statement", "inciting rule violation", "bug abuse", "game weakness abuse", "Macro Use", "Destructive Behaviour", "<center>--></center>", "multi-clienting", "account trading", "<center>--></center>", "threatening gamemaster", "pretending to have official position", "pretending to have influence on gamemaster", "false report to gamemaster", "excessive unjustified player killing", "destructive behaviour", "spoiling auction", "invalid payment");

$players_banned = $SQL->query('SELECT name, id, level, account_id, banned, banstart, banend, comment, reason, banrealtime FROM `players`
    GROUP BY `name`
    ORDER BY `banrealtime` DESC, `reason` ASC
    LIMIT 0, 100')->fetchAll();

$number_of_players = 0;
if(!$players_banned)
{
$main_content .= '<center><i>There are no players banned on '.$config['site']['serverName'].'</i></center>';
} else {
foreach($players_banned as $player) {
		if($player['banned'] == 0) continue;

		//$main_content .= '<br><pre>'.print_r($player, true).'</pre><br>';

    //$banby = "Auto Ban";
    $time = $player['banrealtime'];

    $number_of_players++;
    if(is_int($number_of_players / 2))
        $bgcolor = $config['site']['darkborder'];
    else
        $bgcolor = $config['site']['lightborder'];
    $players_rows .= '<TR BGCOLOR='.$bgcolor.'><TD WIDTH=20%><A HREF="?subtopic=characters&name='.$player['name'].'">'.$player['name'].'</A></TD><TD WIDTH=25%>'.$player['reason'].'</TD><TD>'.$banby.'</TD><TD>'.$time.'</TD></TR>';
}
    //list of players
    $main_content .= '<TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%><TR BGCOLOR="'.$config['site']['vdarkborder'].'"><TD CLASS=white><b><center>Banned Player</center></b></TD><TD class="white"><b><center>Reason</center></b></TD><TD WIDTH=10%><TD class="white"><b><center>Expires</center></b></TD></TR>'.$players_rows.'</TABLE>';
}
?>