<?php

echo('<table border="1" width="555">
    <tr>
      <th>Podal</th>
      <th>Podal</th>
      <th>Text</th>
      <th>Spravovat</th>
    </tr>');
    
$db->select_db($Config['Mangos']['DatabaseCharacters']);
$load_tickets = $db->query('SELECT * FROM `character_ticket` ORDER BY `ticket_id` ASC');
while($row = $load_tickets->fetch_assoc())
{
  $human_date = $server->HumanDate($row['ticket_lastchange']);
  $player_name = $player->GuidToCharName($row['guid']);
  echo('<tr>
      <td align="center">'.$player_name.'</td>
      <td align="center">'.$human_date.'</td>
      <td><font size="2">'.$row['ticket_text'].'</font></td>
      <td align="center"><a href="?ticket='.$row['ticket_id'].'">Spravovat</a></td>
    </tr>');
}
echo('</table>'); 

?>
