Gesior ACC Banned players.

[nevix]

Its not looks awesome but anyway better than nothing:

Code:

<style type="text/css">
.tg  {border-collapse:collapse;border-spacing:0;}
.tg td{font-family:Arial, sans-serif;font-size:14px;padding:10px 50px;border-style:solid;border-width:1px;overflow:hidden;word-break:normal;}
.tg th{font-family:Arial, sans-serif;font-size:14px;font-weight:normal;padding:10px 5px;border-style:solid;border-width:1px;overflow:hidden;word-break:normal;}
</style>


<?PHP

///
$data = $SQL->query('SELECT `players_data`.`name`, `account_bans`.`account_id`, `account_bans`.`reason`, `account_bans`.`banned_at`, `account_bans`.`expires_at`, `account_bans`.`banned_by` FROM `account_bans` INNER JOIN (SELECT * FROM (SELECT `account_id`, `name` FROM `players` WHERE `players`.`account_id` IN (SELECT `account_id` FROM `account_bans`) ORDER BY `level` DESC) x GROUP BY `account_id`) players_data ON `account_bans`.`account_id` = `players_data`.`account_id`')->fetchAll();
echo '<p align="center"><img src="images/banned.png" alt="*"><br/>


<font color=red>- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -</font><br/><br/></p>


';
echo ' <table class="tg">
<th class="tg-031e">Number.</th>
<th class="tg-031e">Player</th>
<th class="tg-031e">Reason</th>
<th class="tg-031e">Expires</th>
<tr>

';

foreach($data as $i => $ban)
{
if(!htmlspecialchars($ban['reason'])){
$ban['reason'] = "(None)";
}

$kada1 = $ban['expires_at'] - time();
$kada2 = date("i",$kada1);
$kada3 = date("s",$kada1);
$kada4 = $kada1/60/60;
$kada4 = current(explode(".", $kada4));

if($kada1 < 60)
{
$zodis = "<b>Expires at: $kada1 sec.</b>";
}
elseif($kada4 >= 1)
{
$zodis = "<b>Expires at: $kada4 h, $kada2 min.</b>";
}
elseif($kada2 >= 1)
{
$zodis = "<b>Expires at: $kada2 min, $kada3 sec.</b>";
}

    echo '<td>' .($i+1) . '.</td><td><a href="?subtopic=characters&name=' . urlencode($ban['name']) . '">' . htmlspecialchars($ban['name']) . '</a></td>
   
    <td>' . htmlspecialchars($ban['reason']) . '<br /></td>
    <td>   ' . $zodis . ' </td><tr>';
}
  echo '</table>';
 
  ?>

Adding image.

 

[nevix]

Code edit:
Adding extra (unban function and few style bugs)

<style type="text/css">
.tg  {border-collapse:collapse;border-spacing:0;}
.tg td{font-family:Arial, sans-serif;font-size:14px;padding:10px 50px;border-style:solid;border-width:1px;overflow:hidden;word-break:normal;}
.tg th{font-family:Arial, sans-serif;font-size:14px;font-weight:normal;padding:10px 5px;border-style:solid;border-width:1px;overflow:hidden;word-break:normal;}
</style>


<?PHP


$idas = mysql_escape_string($_GET['idas']);


if($idas == true AND $group_id_of_acc_logged >= $config['site']['access_admin_panel'])
{
echo'<font color=green> Player unbanned succesfull.</font>';
$SQL->query("DELETE FROM account_bans WHERE account_id = $idas");
}


///

$data = $SQL->query('SELECT `players_data`.`name`, `account_bans`.`account_id`, `account_bans`.`reason`, `account_bans`.`banned_at`, `account_bans`.`expires_at`, `account_bans`.`banned_by` FROM `account_bans` INNER JOIN (SELECT * FROM (SELECT `account_id`, `name` FROM `players` WHERE `players`.`account_id` IN (SELECT `account_id` FROM `account_bans`) ORDER BY `level` DESC) x GROUP BY `account_id`) players_data ON `account_bans`.`account_id` = `players_data`.`account_id`')->fetchAll();
echo '<p align="center"><img src="images/banned.png" alt="*"><br/>


<font color=red>- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -</font><br/><br/></p>


';

if($data == true){
echo ' <table class="tg">
<th class="tg-031e">Number.</th>
<th class="tg-031e">Player</th>
<th class="tg-031e">Reason</th>
<th class="tg-031e">Expires</th>
<tr>

';
}else
{
echo '<font color=green>[#] Nothing banned at this moment.</font>';
}
foreach($data as $i => $ban)
{
if(!htmlspecialchars($ban['reason'])){
$ban['reason'] = "(None)";
}

$kada1 = $ban['expires_at'] - time();
$kada2 = date("i",$kada1);
$kada3 = date("s",$kada1);
$kada4 = $kada1/60/60;
$kada4 = current(explode(".", $kada4));

if($kada1 < 60)
{
$zodis = "<b>Expires at: $kada1 sec.</b>";
}
elseif($kada4 >= 1)
{
$zodis = "<b>Expires at: $kada4 h, $kada2 min.</b>";
}
elseif($kada2 >= 1)
{
$zodis = "<b>Expires at: $kada2 min, $kada3 sec.</b>";
}


if($group_id_of_acc_logged >= $config['site']['access_admin_panel'])
{
$extra = ' (<a href="?subtopic=bannedplayers&idas=' . urlencode($ban['account_id']) . '">Unban</a>)';
}
    echo '<td>' .($i+1) .'.'.$extra.'</td><td><a href="?subtopic=characters&name=' . urlencode($ban['name']) . '">' . htmlspecialchars($ban['name']) . '</a></td>
   
    <td>' . htmlspecialchars($ban['reason']) . '<br /></td>
    <td>   ' . $zodis . ' </td><tr>';
}
  echo '</table>';
 
  ?>

 

[Himii]

Nice work!

 

[WibbenZ]

I suppose this is for 1.0 with gesior latest query?
I think you should tab the script and fix the table, having undefined tables will make it look really bad, Ex the number row is to big
Try fixing it using ex. width="5%" to have the number width smaller to be able to have the name row on one line insted of 2.