$lastreply = $data['lastreply'];
$lastreply = fromMySQLDate($lastreply, 1, 1);
$clientunread = $data['clientunread'];
$tstatus = getStatusColour($tstatus);
$dept = getDepartmentName($deptid);
$urgency = $_LANG["supportticketsticketurgency" . strtolower($urgency)];
$tickets[] = array("id" => $id, "tid" => $tid, "c" => $c, "date" => $date, "department" => $dept, "subject" => $subject, "status" => $tstatus, "urgency" => $urgency, "lastreply" => $lastreply, "unread" => $clientunread);
}
$ca->assign("tickets", $tickets);
$invoice = new WHMCS_Invoice();
$invoices = $invoice->getInvoices("Unpaid", $client->getID(), "id", "DESC");
$ca->assign("invoices", $invoices);
$ca->assign("totalbalance", $invoice->getTotalBalanceFormatted());
$ca->assign("masspay", $CONFIG['EnableMassPay']);
$ca->assign("defaultpaymentmethod", getGatewayName($clientsdetails['defaultgateway']));
$files = $client->getFiles($client->getID());
$ca->assign("files", $files);
$ca->assign("addfundsenabled", $CONFIG['AddFundsEnabled']);
$announcements = array();
$result = select_query("tblannouncements", "", array("published" => "on"), "date", "DESC", "0,3");
while ($data = mysql_fetch_array($result)) {
$id = $data['id'];
$date = $data['date'];
$title = $data['title'];
$announcement = $data['announcement'];
$result2 = select_query("tblannouncements", "", array("parentid" => $id, "language" => $_SESSION['Language']));
$data = mysql_fetch_array($result2);
if ($data['title']) {
$title = $data['title'];
}
if ($data['announcement']) {
