function buildAdminTicketListArray($result)
{
global $departmentsarray;
global $tabledata;
global $aInt;
global $tickets;
while ($data = mysql_fetch_array($result)) {
$id = $data['id'];
$ticketnumber = $data['tid'];
$did = $data['did'];
$puserid = $data['userid'];
$name = $data['name'];
$email = $data['email'];
$date = $data['date'];
$title = $data['title'];
$message = $data['message'];
$tstatus = $data['status'];
$priority = $data['urgency'];
$rawlastactivity = $data['lastreply'];
$flag = $data['flag'];
$firstname = $data['firstname'];
$lastname = $data['lastname'];
$companyname = $data['companyname'];
$groupid = $data['groupid'];
$adminread = $data['adminunread'];
$adminread = explode(",", $adminread);
$tickets->addTagCloudID($id);
if (!in_array($_SESSION['adminid'], $adminread)) {
$unread = 1;
} else {
$unread = 0;
}
$alttitle = "";
$title = trim($title);
if (!$title) {
$title = " - " . $aInt->lang("emails", "nosubject") . " - ";
}
if (80 < strlen($title)) {
$alttitle = $title;
$title = substr($title, 0, 80) . "...";
}
if ($alttitle) {
$alttitle .= "\r\n";
}
$alttitle .= trim(ticketsummary($message, 250));
$flaggedto = "";
if ($flag == $_SESSION['adminid']) {
$showflag = "user";
} else {
if ($flag == 0) {
$showflag = "none";
} else {
$showflag = "other";
$flaggedto = getAdminName($flag);
}
}
$department = $departmentsarray[$did];
if ($flaggedto) {
$department .= " (" . $flaggedto . ")";
}
$date = fromMySQLDate($date, "time");
$lastactivity = fromMySQLDate($rawlastactivity, "time");
$tstatus = getStatusColour($tstatus);
$lastreply = getShortLastReplyTime($rawlastactivity);
$title = "#" . $ticketnumber . " - " . $title;
if ($unread) {
$title = "<strong>" . $title . "</strong>";
}
$clientinfo = $puserid != "0" ? $aInt->outputClientLink($puserid, $firstname, $lastname, $companyname, $groupid) : $name;
$ticketlink = "<a href=\"?action=viewticket&id=" . $id . "\"" . ($alttitle ? " title=\"" . $alttitle . "\"" : "") . "" . $ainject . ">";
$tabledata[] = array("<input type=\"checkbox\" name=\"selectedtickets[]\" value=\"" . $id . "\" class=\"checkall\">", "<img src=\"images/" . strtolower($priority) . ("priority.gif\" width=\"16\" height=\"16\" alt=\"" . $priority . "\" class=\"absmiddle\" />"), $department, "<div style=\"text-align:left;\">" . $ticketlink . $title . "</a></div>", $clientinfo, $tstatus, $lastreply);
}
}
} else {
if ($flag == 0) {
$showflag = "none";
} else {
$showflag = "other";
$flaggedto = getAdminName($flag);
}
}
$department = $departmentsarray[$did];
if ($flaggedto) {
$department .= " (" . $flaggedto . ")";
}
$date = fromMySQLDate($date, "time");
$lastactivity = fromMySQLDate($rawlastactivity, "time");
$tstatus = getStatusColour($tstatus);
$lastreply = getShortLastReplyTime($rawlastactivity);
$flagstyle = $showflag == "user" ? "<span class=\"ticketflag\">" : "";
$title = "#" . $ticketnumber . " - " . $title;
if ($unread || $showflag == "user") {
$title = "<strong>" . $title . "</strong>";
}
$ticketlink = "<a href=\"" . $PHP_SELF . "?action=viewticket&id=" . $id . "\"" . $ainject . ">";
$tabledata[] = array("<img src=\"images/" . strtolower($priority) . ("priority.gif\" width=\"16\" height=\"16\" alt=\"" . $priority . "\" class=\"absmiddle\" />"), $flagstyle . $date, $flagstyle . $department, "<div style=\"text-align:left;\">" . $flagstyle . $ticketlink . $title . "</a></div>", $flagstyle . $tstatus, $flagstyle . $lastreply);
}
echo $aInt->sortableTable(array("", $aInt->lang("support", "datesubmitted"), $aInt->lang("support", "department"), $aInt->lang("fields", "subject"), $aInt->lang("fields", "status"), $aInt->lang("support", "lastreply")), $tabledata);
echo "<table width=\"80%\" align=\"center\"><tr><td style=\"text-align:left;\">";
if (0 < $offset) {
echo "<a href=\"#\" onclick=\"loadTab(" . $target . ",'tickets'," . ($offset - $qlimit) . ");return false\">";
}
echo "« Previous</a></td><td style=\"text-align:right;\">";
if ($endnum < $totaltickets) {