source: branches/posledni/pages/acclog.php

<?php

echo('&nbsp;<a href="'.$html->Link('/ucet/').'">&lt;- Zpět do správy účtu</a>');
$db->select_db($Config['Mangos']['DatabaseRealmd']);
echo('<table class="BaseTable">
  <tr>
    <td>Postava</td>
    <td>Akce</td>
    <td>Čas</td>
    <td>Provedeno z IP</td>
  </tr>');
$data = $db->query('SELECT * FROM `char_db` WHERE `guid` = "'.$_SESSION['UserId'].'" ORDER BY `time` ASC LIMIT 0,40');
while($row = $data->fetch_assoc())
{
  $date_arr = explode(' ', $row['time']);
  $date = explode('-', $date_arr[0]);
  $time_stp = explode(':', $date_arr[1]);
  $time = mktime($time_stp[0], $time_stp[1], $time_stp[2], $date[1], $date[2], $date[0]);
  $human_date = date('d.m.Y H:i:s', $time);
  echo('<tr>
      <th>'.$row['char_name'].'</th>
      <td>'.$row['action'].'</td>
      <td>'.$human_date.'</td>
      <td>'.$row['ip'].'</td>
    </tr>');
}
echo('<tr>
    <td align="left" colspan="3">Vaše současná IP adresa :</td>
    <td align="center"><b>'.$_SERVER['REMOTE_ADDR'].'</b></td>
  </tr>');
echo('</table>');

echo('<font size="1">Výpis omezen na 40 posledních aktivit</font>');

?>