﻿<?php

echo('<center><table border="0">
<tr><td><center><font color="green" face="verdana" size="3"><b>Kontrola IP adresy</b></font></center></td></tr>
<tr><td><center><font color="blue" face="verdana" size="1">Zadejte prosím vaší IP adresu</font></center></td></tr>
<tr><td><form action="?page=banip" method="post"><input type="text" name="ip" value="127.0.0.1"><input type="submit" name="odeslat" value="zkontroluj"></form></td></tr>
<tr><td><center>');

$ipcko = getenv('REMOTE_ADDR');
if($ipcko != false) 
{
  echo('<font color="red" size="1" face="verdana">Vaše IP adresa je: '.$ipcko.'</font>');
}

echo('</center></td></tr>
</table></center>
<br />
<center><table border="0">
<tr><td><center><font color="green" face="verdana" size="3"><b>Kontrola účtu</b></font></center></td></tr>
<tr><td><center><font color="blue" face="verdana" size="1">Zadejte prosím jméno účtu</font></center></td></tr>
<tr><td><form action="?page=banacc" method="post"><input type="text" name="jmeno" value="name"><input type="submit" name="odeslat" value="zkontroluj"></form></td></tr>
</table></center>
<center><font face="verdana" size="1" color="red">váš <span style="color: red">předpokládaný</span> účet je:');


$db->select_db($Config['Mangos']['DatabaseRealmd']);

$DbResult = $db->query('SELECT * FROM `account` WHERE `last_ip` = "'.$ipcko.'" ORDER BY `last_login` DESC LIMIT 3');
while($DbRow = $DbResult->fetch_assoc())
{
  $i = $DbRow['username'];
  echo($i.', ');
}

echo('</font></center>
<br /><center>
<h2>Seznam banů</h2>');

$sqldata = $db->query('SELECT `account`.`last_ip`,`ip_banned`.`bandate`,`ip_banned`.`unbandate`,`ip_banned`.`bannedby`,`ip_banned`.`banreason` FROM `account` INNER join `ip_banned` ON `account`.`last_ip`=`ip_banned`.`ip`');

echo('<table class="BaseTable">');
echo('<tr><th>IP</th><th>Od</th><th>Do</th><th>Banoval</th><th>Důvod</th></tr>');

while($row = $sqldata->fetch_assoc())
{
  $start = Date('d-m-Y H:i:s', $row['bandate']);
  $end = Date('d-m-Y H:i:s', $row['unbandate']);
  
  echo('<tr><td>'.$row['last_ip'].'</td><td>'.$start.'</td><td>'.$end.'</td><td>'.$row['bannedby'].'</td><td>'.$row['banreason'].'</td></tr>');
}
echo('</table>');

?>
