PHP get_sql_user_count Examples

Example #1

File: index.php Project: svenjantzen/imscp

/**
 * Generates admin general informations
 *
 * @param  iMSCP_pTemplate $tpl iMSCP_pTemplate instance
 * @return void
 */
function admin_getAdminGeneralInfo($tpl)
{
    $cfg = iMSCP_Registry::get('config');
    $totalMails = records_count('mail_users', 'mail_type NOT RLIKE \'_catchall\'', '');
    if ($cfg['COUNT_DEFAULT_EMAIL_ADDRESSES']) {
        $showTotalMails = $totalMails;
    } else {
        $totalDefaultMails = records_count('mail_users', 'mail_acc', 'abuse');
        $totalDefaultMails += records_count('mail_users', 'mail_acc', 'webmaster');
        $totalDefaultMails += records_count('mail_users', 'mail_acc', 'postmaster');
        $showTotalMails = $totalMails - $totalDefaultMails . '/' . $totalMails;
    }
    $tpl->assign(array('ACCOUNT_NAME' => tohtml($_SESSION['user_logged']), 'ADMIN_USERS' => records_count('admin', 'admin_type', 'admin'), 'RESELLER_USERS' => records_count('admin', 'admin_type', 'reseller'), 'NORMAL_USERS' => records_count('admin', 'admin_type', 'user'), 'DOMAINS' => records_count('domain', '', ''), 'SUBDOMAINS' => records_count('subdomain', '', '') + records_count('subdomain_alias', 'subdomain_alias_id', '', ''), 'DOMAINS_ALIASES' => records_count('domain_aliasses', '', ''), 'MAIL_ACCOUNTS' => $showTotalMails, 'FTP_ACCOUNTS' => records_count('ftp_users', '', ''), 'SQL_DATABASES' => records_count('sql_database', '', ''), 'SQL_USERS' => get_sql_user_count()));
}

Example #2

File: admin-functions.php Project: gOOvER/EasySCP

/**
 * @param EasySCP_TemplateEngine $tpl
 */
function get_admin_general_info($tpl)
{
    $tpl->assign(array('TR_GENERAL_INFORMATION' => tr('General information'), 'TR_ACCOUNT_NAME' => tr('Account name'), 'TR_ADMIN_USERS' => tr('Admin users'), 'TR_RESELLER_USERS' => tr('Reseller users'), 'TR_NORMAL_USERS' => tr('Normal users'), 'TR_DOMAINS' => tr('Domains'), 'TR_SUBDOMAINS' => tr('Subdomains'), 'TR_DOMAINS_ALIASES' => tr('Domain aliases'), 'TR_MAIL_ACCOUNTS' => tr('Mail accounts'), 'TR_FTP_ACCOUNTS' => tr('FTP accounts'), 'TR_SQL_DATABASES' => tr('SQL databases'), 'TR_SQL_USERS' => tr('SQL users'), 'TR_SYSTEM_MESSAGES' => tr('System messages'), 'TR_NO_NEW_MESSAGES' => tr('No new messages'), 'TR_SERVER_TRAFFIC' => tr('Server traffic')));
    $show_total_emails = records_count('mail_users', "mail_type NOT RLIKE '_catchall'", '');
    $tpl->assign(array('ACCOUNT_NAME' => $_SESSION['user_logged'], 'ADMIN_USERS' => records_count('admin', 'admin_type', 'admin'), 'RESELLER_USERS' => records_count('admin', 'admin_type', 'reseller'), 'NORMAL_USERS' => records_count('admin', 'admin_type', 'user'), 'DOMAINS' => records_count('domain', '', ''), 'SUBDOMAINS' => records_count('subdomain', '', '') + records_count('subdomain_alias', 'subdomain_alias_id', '', ''), 'DOMAINS_ALIASES' => records_count('domain_aliasses', '', ''), 'MAIL_ACCOUNTS' => $show_total_emails, 'FTP_ACCOUNTS' => records_count('ftp_users', '', ''), 'SQL_DATABASES' => records_count('sql_database', '', ''), 'SQL_USERS' => get_sql_user_count()));
}