$lastupdate = fromMySQLDate($data['lastupdate'], true);
if (!is_null($data['enddate'])) {
$enddate = fromMySQLDate($data['enddate'], true);
} else {
$enddate = "";
}
$priority = $_LANG["networkissuespriority" . strtolower($data['priority'])];
$status = $_LANG["networkissuesstatus" . str_replace(" ", "", strtolower($data['status']))];
$type = $_LANG["networkissuestype" . strtolower($data['type'])];
$affected = false;
if ($data['server']) {
if (in_array($data['server'], $users_servers)) {
$affected = true;
}
$result2 = select_query("tblservers", "name", array("id" => $data['server']));
$data2 = mysql_fetch_array($result2);
$servername = $data2['name'];
} else {
$affected = false;
$servername = "";
}
$issues[] = array("id" => $data['id'], "startdate" => $startdate, "enddate" => $enddate, "title" => $data['title'], "description" => $data['description'], "type" => $type, "affecting" => $data['affecting'], "server" => $servername, "priority" => $priority, "status" => $status, "lastupdate" => $lastupdate, "clientaffected" => $affected);
}
$smartyvalues['issues'] = $issues;
$smartyvalues['view'] = $view;
$smartyvalues = array_merge($smartyvalues, clientAreaTablePageNav($numitems));
$smartyvalues['noissuesmsg'] = sprintf($_LANG['networkstatusnone'], $_LANG["networkissuesstatus" . $view]);
if (!$fromserverstatus) {
$templatefile = "networkissues";
outputClientArea($templatefile);
}
$a = $_GET['a'];
if (!$a) {
$tplfile = "templates/clienthome";
$result = select_query("mod_project", "COUNT(*)", array("userid" => $_SESSION['uid']));
$data = mysql_fetch_array($result);
$numitems = $data[0];
list($orderby, $sort, $limit) = clientAreaTableInit("projects", "lastmodified", "DESC", $numitems);
$projects = array();
$result = select_query("mod_project", "", array("userid" => $_SESSION['uid']), $orderby, $sort, $limit);
while ($data = mysql_fetch_array($result)) {
$projects[] = array("id" => $data['id'], "title" => $data['title'], "adminid" => $data['adminid'], "adminname" => get_query_val("tbladmins", "CONCAT(firstname,' ',lastname)", array("id" => $data['adminid'])), "created" => fromMySQLDate($data['created'], 0, 1), "duedate" => fromMySQLDate($data['duedate'], 0, 1), "lastmodified" => fromMySQLDate($data['lastmodified'], 0, 1), "status" => $data['status']);
}
$tplvars['projects'] = $projects;
$tplvars['orderby'] = $orderby;
$tplvars['sort'] = strtolower($sort);
$tplvars = array_merge($tplvars, clientAreaTablePageNav($numitems));
return 1;
}
if ($a == "view") {
$tplfile = "templates/clientview";
$result = select_query("mod_project", "", array("userid" => $_SESSION['uid'], "id" => $_REQUEST['id']));
$data = mysql_fetch_array($result);
$projectid = $data['id'];
if (!$projectid) {
exit("Access Denied");
}
if (in_array("addtasks", $features) && trim($_POST['newtask'])) {
insert_query("mod_projecttasks", array("projectid" => $projectid, "task" => trim($_POST['newtask']), "created" => "now()", "order" => get_query_val("mod_projecttasks", "`order`", array("projectid" => $projectid), "order", "DESC") + 1));
redir("m=project_management&a=view&id=" . $projectid);
}
if (in_array("files", $features) && $_POST['upload']) {
