$pageicon = "images/domains_big.gif";
initialiseClientArea($pagetitle, $pageicon, $breadcrumbnav);
$search = $whmcs->get_req_var("search");
$domain = $whmcs->get_req_var("domain");
$bulkdomains = $whmcs->get_req_var("bulkdomains");
$tld = $whmcs->get_req_var("tld");
$tlds = $whmcs->get_req_var("tlds");
$ext = $whmcs->get_req_var("ext");
$direct = $whmcs->get_req_var("direct");
$sld = "";
$invalidtld = "";
$availabilityresults = array();
$search_tlds = array();
$tldslist = array();
$client = new WHMCS_Client(WHMCS_Session::get("uid"));
$uid = $client->getID();
$currencyid = isset($_SESSION['currency']) ? $_SESSION['currency'] : "";
$currency = getCurrency($uid, $currencyid);
$smartyvalues['currency'] = $currency;
$action = isset($_REQUEST['a']) ? $_REQUEST['a'] : "";
$domain = isset($_REQUEST['domain']) ? $_REQUEST['domain'] : "";
$document_download = isset($_REQUEST['dl']) ? $_REQUEST['dl'] : "";
$search_domain = $_POST['search_domain'] != "Enter Domain to Find" ? $_POST['search_domain'] : "";
$current_date = date('Y-m-d');
$where = array("registrar" => "domainku");
if ($domain || $search_domain) {
$where["domain"] = $domain ? $domain : $search_domain;
$where_document = array("domain" => $domain);
}
$query = full_query("\n SELECT t.id, t.userid, t.type, t.domain, t.registrar, t.registrationdate, t.registrationperiod, t.status AS domstatus, i.status, o.nameservers, o.transfersecret,\n m.domain AS coza_domain, m.domainid AS coza_domainid, m.userid AS coza_userid, m.id_doc_storage_name, m.id_doc_type, m.le_doc_storage_name, \n m.le_doc_type, m.su_doc_storage_name, m.su_doc_type, m.domain_approval_date, m.domain_status,\n c.firstname, c.lastname, c.companyname, c.email, c.address1, c.address2, c.city, c.state, c.postcode, c.country, c.phonenumber\n FROM tbldomains t \n LEFT JOIN mod_domaincloudregistrar m ON t.domain = m.domain \n LEFT JOIN tblorders o ON t.orderid = o.id\n LEFT JOIN tblinvoices i ON o.invoiceid = i.id\n LEFT JOIN tblclients c ON t.userid = c.id\n WHERE t.userid = " . $uid . " AND t.status <> 'Cancelled' AND t.status <> 'Expired' AND " . (!empty($domain) || !empty($search_domain) ? "t.domain LIKE '" . (!empty($domain) ? $domain : $search_domain) . "%'" : "t.domain LIKE '%.id'") . ";\n ");
$rows = array();
}
$client = new WHMCS_Client(WHMCS_Session::get("uid"));
$currency = $client->getCurrency();
$ca->assign("action", $action);
$ca->assign("clientareaaction", $action);
if ($action == "") {
$ca->setTemplate("clientareahome");
require "includes/ticketfunctions.php";
$tickets = array();
$statusfilter = "";
$result = select_query("tblticketstatuses", "title", array("showactive" => "1"));
while ($data = mysql_fetch_array($result)) {
$statusfilter .= "'" . $data[0] . "',";
}
$statusfilter = substr($statusfilter, 0, 0 - 1);
$result = select_query("tbltickets", "", "userid='" . mysql_real_escape_string($client->getID()) . ("' AND status IN (" . $statusfilter . ")"), "lastreply", "DESC");
while ($data = mysql_fetch_array($result)) {
$id = $data['id'];
$tid = $data['tid'];
$c = $data['c'];
$deptid = $data['did'];
$date = $data['date'];
$date = fromMySQLDate($date, 1, 1);
$subject = $data['title'];
$tstatus = $data['status'];
$urgency = $data['urgency'];
$lastreply = $data['lastreply'];
$lastreply = fromMySQLDate($lastreply, 1, 1);
$clientunread = $data['clientunread'];
$tstatus = getStatusColour($tstatus);
$dept = getDepartmentName($deptid);
