<?php
$ip = "localhost";  // Ip к базе данных
$login = "root";  // Логин к базе данных
$password = "";   // Пароль к базе данных
$cbd = "characters";  // База данных Characters
$width = "500";   // Ширина таблицы.
?>

<?php
$db = mysql_connect($ip, $login, $password) or die ("База Данных не найдена!!!");

$sql = mysql_select_db($cbd) or die ("Нет соединения с базой $cbd !!!");

$data = mysql_query("SELECT ticketId, guid, message, createTime, closedBy, viewed FROM gm_tickets WHERE closedBy = 0 ORDER BY ticketId DESC", $db) or die("Таблица не найдена!!!");

echo "<table width=\"$width\" border=\"1\"><tr><td><center>#</center></td><td><center>Имя отправителя</center></td><td><center>Дата</center></td><td><center>Текст</center></td><td><center>Проверено</center></td></tr>";

$i = 0;

while ($res = mysql_fetch_array($data))
{
$char = mysql_query("SELECT guid, name FROM characters WHERE guid = $res[guid] LIMIT 1", $db) or die("Нет соединения с таблицей");
$char = mysql_fetch_array($char);

$i++;
echo "<tr><td>",$i,"</td>";
echo "<td>",$char[name],"</td>";
echo "<td>",date("H:i d.m.Y", $res['createTime']),"</td>";
echo "<td>",$res[message],"</td>";
if ($res[viewed] == 1) {
echo "<td>да</td></tr>";
}
else {
echo "<td>нет</td></tr>";
}
}
if ($i == 0){echo "<tr><td colspan=\"5\"><center>Сейчас нету активных тикетов.</center></td></tr>";}

echo "</table>";
?>