$result = select_query("tblnetworkissues", "COUNT(*)", "status='Resolved'"); $data = mysql_fetch_array($result); $smartyvalues['resolvedcount'] = $data[0]; $users_servers = array(); if (isset($_SESSION['uid'])) { $result = select_query("tblhosting", "DISTINCT server", array("userid" => $_SESSION['uid'])); while ($data = mysql_fetch_array($result)) { if ($data['server']) { $users_servers[] = $data['server']; } } } $result = select_query("tblnetworkissues", "COUNT(*)", $query_where); $data = mysql_fetch_array($result); $numitems = $data[0]; list($orderby, $sort, $limit) = clientAreaTableInit("networkissues", "lastupdate", "DESC", $numitems); $smartyvalues['orderby'] = $orderby; $smartyvalues['sort'] = strtolower($sort); $issues = array(); $result = select_query("tblnetworkissues", "", $query_where, $orderby, $sort, $limit); while ($data = mysql_fetch_array($result)) { $startdate = fromMySQLDate($data['startdate'], true); $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'])];
$deptid = get_query_val("tblticketdepartments", "id", array("id" => $CONFIG['AffiliateDepartment'])); } if (!$deptid) { $deptid = get_query_val("tblticketdepartments", "id", array("hidden" => ""), "order", "ASC"); } $message = "Affiliate Account Withdrawal Request. Details below:\n\nClient ID: " . $_SESSION['uid'] . ("\nAffiliate ID: " . $id . "\nBalance: " . $balance); $ticketdetails = openNewTicket($_SESSION['uid'], $_SESSION['cid'], $deptid, "Affiliate Withdrawal Request", $message, "Medium"); redir("withdraw=1"); } } if ($whmcs->get_req_var("withdraw")) { $smarty->assign("withdrawrequestsent", "true"); } $content .= "\n<p><b>" . $_LANG['affiliatesreferals'] . "</b></p>\n<table align=\"center\" id=\"affiliates\" cellspacing=\"1\">\n<tr><td id=\"affiliatesheading\">" . $_LANG['affiliatessignupdate'] . "</td><td id=\"affiliatesheading\">" . $_LANG['affiliateshostingpackage'] . "</td><td id=\"affiliatesheading\">" . $_LANG['affiliatesamount'] . "</td><td id=\"affiliatesheading\">" . $_LANG['affiliatescommision'] . "</td><td id=\"affiliatesheading\">" . $_LANG['affiliatesstatus'] . "</td></tr>\n"; $numitems = get_query_val("tblaffiliatesaccounts", "COUNT(*)", array("affiliateid" => $affiliateid), "", "", "", "tblhosting ON tblhosting.id=tblaffiliatesaccounts.relid INNER JOIN tblproducts ON tblproducts.id=tblhosting.packageid INNER JOIN tblclients ON tblclients.id=tblhosting.userid"); list($orderby, $sort, $limit) = clientAreaTableInit("affiliates", "regdate", "DESC", $numitems); $smartyvalues['orderby'] = $orderby; $smartyvalues['sort'] = strtolower($sort); if ($orderby == "product") { $orderby = "tblproducts`.`name"; } else { if ($orderby == "amount") { $orderby = "tblhosting`.`amount"; } else { if ($orderby == "billingcycle") { $orderby = "tblhosting`.`billingcycle"; } else { if ($orderby == "status") { $orderby = "tblhosting`.`domainstatus"; } else { $orderby = "tblhosting`.`regdate";
$tstatus = $data['status']; $urgency = $data['urgency']; $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); } } else { $result = select_query("tbltickets", "COUNT(id)", array("userid" => $_SESSION['uid'])); $data = mysql_fetch_array($result); $numtickets = $data[0]; $smartyvalues['numtickets'] = $numtickets; list($orderby, $sort, $limit) = clientAreaTableInit("tickets", "lastreply", "DESC", $numtickets); $smartyvalues['orderby'] = $orderby; $smartyvalues['sort'] = strtolower($sort); if ($orderby == "date") { $orderby = "date"; } else { if ($orderby == "dept") { $orderby = "deptname"; } else { if ($orderby == "subject") { $orderby = "title"; } else { if ($orderby == "status") { $orderby = "status"; } else { if ($orderby == "urgency") {
if (!defined("WHMCS")) { exit("This file cannot be accessed directly"); } if (!$vars['clientenable']) { redir(); } $tplvars = array(); $tplvars['_lang'] = $vars['_lang']; $tplvars['features'] = $features = explode(",", $vars['clientfeatures']); $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);
if ($partialpayments) { $smartyvalues['partialpayments'] = formatCurrency($partialpayments); } $smartyvalues['total'] = formatCurrency($total - $partialpayments); $smartyvalues['invoiceitems'] = $invoiceitems; $gatewayslist = showPaymentGatewaysList(); $smartyvalues['gateways'] = $gatewayslist; $smartyvalues['defaultgateway'] = key($gatewayslist); } else { if ($action == "quotes") { $ca->setTemplate("clientareaquotes"); require ROOTDIR . "/includes/quotefunctions.php"; $result = select_query("tblquotes", "COUNT(*)", array("userid" => $client->getID())); $data = mysql_fetch_array($result); $numitems = $data[0]; list($orderby, $sort, $limit) = clientAreaTableInit("quote", "id", "DESC", $numitems); if (!in_array($orderby, array("id", "date", "duedate", "total", "stage"))) { $orderby = "validuntil"; } $smartyvalues['orderby'] = $orderby; $smartyvalues['sort'] = strtolower($sort); $quotes = array(); $result = select_query("tblquotes", "", array("userid" => $client->getID(), "stage" => array("sqltype" => "NEQ", "value" => "Draft")), $orderby, $sort, $limit); while ($data = mysql_fetch_assoc($result)) { $data['datecreated'] = fromMySQLDate($data['datecreated'], 0, 1); $data['validuntil'] = fromMySQLDate($data['validuntil'], 0, 1); $data['lastmodified'] = fromMySQLDate($data['lastmodified'], 0, 1); $data['stage'] = getQuoteStageLang($data['stage']); $quotes[] = $data; } $smartyvalues['quotes'] = $quotes;