public function ticket_replies($ticket)
{
$_link = $this->getDBH();
$query = $_link->prepare('SELECT * FROM `ticket_replies` WHERE `ticket_id` = :uniqid');
$query->bindParam(':uniqid', $ticket, PDO::PARAM_STR);
$query->execute();
$users = new users();
$time = new time();
while ($result = $query->fetch(PDO::FETCH_ASSOC)) {
if ($users->idtocolumn($result['user'], 'user_group') == 1) {
$level = 'Administrator';
} else {
$level = 'General user';
}
echo '<div class="row">
<div class="ticket-insert">
<div class="columns three">
<div class="profile">
<img src="//gravatar.com/avatar/' . md5($users->idtocolumn($result['user'], 'email')) . '?s=100">
<ul>
<li><b>' . $users->idtocolumn($result['user'], 'nick_name') . '</b></li>
<li>' . $level . '</li>';
if ($users->idtocolumn($result['user'], 'id') == $_COOKIE['user']) {
echo '<li><a href="#">Edit Account</a></li>';
}
echo '</ul>
</div>
</div>
<div class="columns nine">
<div class="reply-text-wrap" style="word-wrap:break-word;">
' . $result['text'] . '
<ul>
<li>Posted ' . $time->ago($result['date']) . '</li>
</ul>
</div>
</div>
</div>
</div>';
}
}
