public static function Template() { $currentuser = ctrl_users::GetUserDetail(ctrl_auth::CurrentUserID()); if ($currentuser['lastlogon']) { return date(ctrl_options::GetSystemOption('sentora_df'), $currentuser['lastlogon']); } else { return "<: Never :>"; } }
/** * Returns an array of infomation for the account details, package, groups and quota limits for a given UID. * @author Bobby Allen (ballen@bobbyallen.me) * @global db_driver $zdbh The ZPX database handle. * @param int $uid The ZPanel user account ID. * @return array */ static function GetUserDetail($uid = "") { global $zdbh; $userdetail = new runtime_dataobject(); if ($uid == "") { $uid = ctrl_auth::CurrentUserID(); } $rows = $zdbh->prepare("\n SELECT * FROM x_accounts\n LEFT JOIN x_profiles ON (x_accounts.ac_id_pk=x_profiles.ud_user_fk)\n LEFT JOIN x_groups ON (x_accounts.ac_group_fk=x_groups.ug_id_pk)\n LEFT JOIN x_packages ON (x_accounts.ac_package_fk=x_packages.pk_id_pk)\n LEFT JOIN x_quotas ON (x_accounts.ac_package_fk=x_quotas.qt_package_fk)\n WHERE x_accounts.ac_id_pk= :uid\n "); $rows->bindParam(':uid', $uid); $rows->execute(); $dbvals = $rows->fetch(); $userdetail->addItemValue('username', $dbvals['ac_user_vc']); $userdetail->addItemValue('userid', $dbvals['ac_id_pk']); $userdetail->addItemValue('password', $dbvals['ac_pass_vc']); $userdetail->addItemValue('email', $dbvals['ac_email_vc']); $userdetail->addItemValue('resellerid', $dbvals['ac_reseller_fk']); $userdetail->addItemValue('packageid', $dbvals['ac_package_fk']); $userdetail->addItemValue('enabled', $dbvals['ac_enabled_in']); $userdetail->addItemValue('usertheme', $dbvals['ac_usertheme_vc']); $userdetail->addItemValue('usercss', $dbvals['ac_usercss_vc']); $userdetail->addItemValue('lastlogon', $dbvals['ac_lastlogon_ts']); $userdetail->addItemValue('fullname', $dbvals['ud_fullname_vc']); $userdetail->addItemValue('packagename', $dbvals['pk_name_vc']); $userdetail->addItemValue('usergroup', $dbvals['ug_name_vc']); $userdetail->addItemValue('usergroupid', $dbvals['ac_group_fk']); $userdetail->addItemValue('address', $dbvals['ud_address_tx']); $userdetail->addItemValue('postcode', $dbvals['ud_postcode_vc']); $userdetail->addItemValue('phone', $dbvals['ud_phone_vc']); $userdetail->addItemValue('language', $dbvals['ud_language_vc']); $userdetail->addItemValue('diskquota', $dbvals['qt_diskspace_bi']); $userdetail->addItemValue('bandwidthquota', $dbvals['qt_bandwidth_bi']); $userdetail->addItemValue('domainquota', $dbvals['qt_domains_in']); $userdetail->addItemValue('subdomainquota', $dbvals['qt_subdomains_in']); $userdetail->addItemValue('parkeddomainquota', $dbvals['qt_parkeddomains_in']); $userdetail->addItemValue('ftpaccountsquota', $dbvals['qt_ftpaccounts_in']); $userdetail->addItemValue('mysqlquota', $dbvals['qt_mysql_in']); $userdetail->addItemValue('mailboxquota', $dbvals['qt_mailboxes_in']); $userdetail->addItemValue('forwardersquota', $dbvals['qt_fowarders_in']); $userdetail->addItemValue('distlistsquota', $dbvals['qt_distlists_in']); $userdetail->addItemValue('catorder', $dbvals['ac_catorder_vc']); return $userdetail->getDataObject(); }
/** * Used to translate a text string into the language preference of the user. * @author Pascal Peyremorte (p.peyremorte@wanadoo.fr) * @global db_driver $zdbh The ZPX database handle. * @param $message The string to translate. * @return string The transalated string. */ static function translate($message) { global $zdbh; if (empty(self::$LangCol)) { $uid = ctrl_auth::CurrentUserID(); $sql = $zdbh->prepare('SELECT ud_language_vc FROM x_profiles WHERE ud_user_fk=' . $uid); $sql->execute(); $lang = $sql->fetch(); self::$LangCol = 'tr_' . $lang['ud_language_vc'] . '_tx'; } if (self::$LangCol == 'tr_en_tx') { return $message; } //no translation required, english used $SlashedMessage = addslashes($message); //protect special chars $sql = $zdbh->prepare('SELECT ' . self::$LangCol . ' FROM x_translations WHERE tr_en_tx =:message'); $sql->bindParam(':message', $SlashedMessage); $sql->execute(); $result = $sql->fetch(); if ($result) { if (!fs_director::CheckForEmptyValue($result[self::$LangCol])) { return $result[self::$LangCol]; } else { return $message; } //translated message empty } else { //message not found in the table //add unfound message to the table with empties translations $sql = $zdbh->prepare('INSERT INTO x_translations SET tr_en_tx=:message'); $sql->bindParam(':message', $SlashedMessage); $sql->execute(); return $message; } }
static function getMailboxList($uid = null) { global $zdbh; global $controller; if ($uid == '' || empty($uid) || $uid == null) { $uid = ctrl_auth::CurrentUserID(); } $currentuser = ctrl_users::GetUserDetail($uid); $sql = "SELECT * FROM x_mailboxes WHERE mb_acc_fk=:userid AND mb_deleted_ts IS NULL ORDER BY mb_address_vc ASC"; $numrows = $zdbh->prepare($sql); $numrows->bindParam(':userid', $currentuser['userid']); $numrows->execute(); if ($numrows->fetchColumn() != 0) { $sqlRun = $zdbh->prepare($sql); $sqlRun->bindParam(':userid', $currentuser['userid']); $res = array(); $sqlRun->execute(); while ($rowmailboxes = $sqlRun->fetch()) { array_push($res, array('address' => $rowmailboxes['mb_address_vc'], 'id' => $rowmailboxes['mb_id_pk'])); } return $res; } else { return false; } }
static function getDomainList($uid = null) { global $zdbh; global $controller; if ($uid == '' || empty($uid) || $uid == null) { $uid = ctrl_auth::CurrentUserID(); } $currentuser = ctrl_users::GetUserDetail($uid); $sql = "SELECT * FROM x_vhosts WHERE vh_acc_fk=:userid AND vh_enabled_in=1 AND vh_deleted_ts IS NULL ORDER BY vh_name_vc ASC"; $numrows = $zdbh->prepare($sql); $numrows->bindParam(':userid', $currentuser['userid']); $numrows->execute(); if ($numrows->fetchColumn() != 0) { $sqlRun = $zdbh->prepare($sql); $sqlRun->bindParam(':userid', $currentuser['userid']); $res = array(); $sqlRun->execute(); while ($rowdomains = $sqlRun->fetch()) { array_push($res, array('domain' => $rowdomains['vh_name_vc'])); } return $res; } else { return false; } }