| | |
| | | |
| | | $limits[] = array('field' => 'limit_web_aliasdomain', |
| | | 'db_table' => 'web_domain', |
| | | 'db_where' => "type = 'alias'"); |
| | | 'db_where' => "(type = 'alias' OR type = 'vhostalias')"); |
| | | |
| | | $limits[] = array('field' => 'limit_ftp_user', |
| | | 'db_table' => 'ftp_user', |
| | |
| | | 'db_table' => 'client', |
| | | 'db_where' => ""); |
| | | |
| | | |
| | | $limits[] = array('field' => 'limit_domain', |
| | | 'db_table' => 'domain', |
| | | 'db_where' => ""); |
| | | |
| | | |
| | | //* Loading Template |
| | |
| | | $tpl->setVar('is_admin', $user_is_admin); |
| | | |
| | | if($user_is_admin == false) { |
| | | $client_group_id = $_SESSION["s"]["user"]["default_group"]; |
| | | $client = $app->db->queryOneRecord("SELECT * FROM sys_group, client WHERE sys_group.client_id = client.client_id and sys_group.groupid = $client_group_id"); |
| | | $client_group_id = $app->functions->intval($_SESSION["s"]["user"]["default_group"]); |
| | | $client = $app->db->queryOneRecord("SELECT * FROM sys_group, client WHERE sys_group.client_id = client.client_id and sys_group.groupid = ?", $client_group_id); |
| | | } |
| | | |
| | | $rows = array(); |
| | |
| | | } |
| | | if($value != 0 || $value == $wb['unlimited_txt']) { |
| | | $value_formatted = ($value == '-1')?$wb['unlimited_txt']:$value; |
| | | $usage = $this->_get_limit_usage($limit); |
| | | $percentage = ($value == '-1' || $value == 0 ? 0 : round(100 * $usage / $value)); |
| | | $rows[] = array('field' => $field, |
| | | 'field_txt' => $wb[$field.'_txt'], |
| | | 'value' => $value_formatted, |
| | | 'usage' => $this->_get_limit_usage($limit)); |
| | | 'value_raw' => $value, |
| | | 'usage' => $usage, |
| | | 'usage_raw' => $usage, |
| | | 'percentage' => $percentage); |
| | | } |
| | | } |
| | | $tpl->setLoop('rows', $rows); |
| | |
| | | function _get_limit_usage($limit) { |
| | | global $app; |
| | | |
| | | $sql = "SELECT count(sys_userid) as number FROM ".$limit['db_table']." WHERE "; |
| | | $sql = "SELECT count(sys_userid) as number FROM ?? WHERE "; |
| | | if($limit['db_where'] != '') $sql .= $limit['db_where']." AND "; |
| | | $sql .= $app->tform->getAuthSQL('r'); |
| | | $rec = $app->db->queryOneRecord($sql); |
| | | $rec = $app->db->queryOneRecord($sql, $limit['db_table']); |
| | | return $rec['number']; |
| | | |
| | | } |