rendered paste body $ban_acc=("select count(access_level) as ban from $login_db.accounts where access_level<0 ");
$result =mysql_query($ban_acc);
$row = mysql_fetch_array($result);
$acc_ban=($row['ban']);
if ($acc_ban==0) $acc_ban="none";
echo "Banned accounts: $acc_ban ";
$ban_accs="select login from accounts where access_level<0";
$result =mysql_query($ban_accs);
while ($row = mysql_fetch_array($result)){
$accs_ban=($row['login']);
echo " $accs_ban, ";
}
echo "<br />";
$ban_chars = "SELECT count(accesslevel) AS nonban FROM characters WHERE accesslevel > 0";
$result = mysql_query($nonban_chars);
$row = mysql_fetch_array($result);
$nonban_chars = $row['nonban'];
//$ban_chars = ($row['ban']);
If ($ban_chars==0) $ban_chars="none";
echo"Banned characters: $ban_chars <br />";