$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);