root/trunk/gui/include/client-functions.php

<?php
/**
 * ispCP ω (OMEGA) a Virtual Hosting Control System
 *
 * @copyright     2001-2006 by moleSoftware GmbH
 * @copyright     2006-2008 by ispCP | http://isp-control.net
 * @version        SVN: $Id$
 * @link         http://isp-control.net
 * @author         ispCP Team
 *
 * @license
 *   This program is free software; you can redistribute it and/or modify it under
 *   the terms of the MPL General Public License as published by the Free Software
 *   Foundation; either version 1.1 of the License, or (at your option) any later
 *   version.
 *   You should have received a copy of the MPL Mozilla Public License along with
 *   this program; if not, write to the Open Source Initiative (OSI)
 *   http://opensource.org | osi@opensource.org
 */

function get_domain_default_props(&$sql, $domain_admin_id, $returnWKeys = false) {
    $query = <<<SQL_QUERY
        select
            domain_id,
            domain_name,
            domain_gid,
            domain_uid,
            domain_created_id,
            domain_created,
            domain_last_modified,
            domain_mailacc_limit,
            domain_ftpacc_limit,
            domain_traffic_limit,
            domain_sqld_limit,
            domain_sqlu_limit,
            domain_status,
            domain_alias_limit,
            domain_subd_limit,
            domain_ip_id,
            domain_disk_limit,
            domain_disk_usage,
            domain_php,
            domain_cgi
        from
            domain
        where
            domain_admin_id = ?
SQL_QUERY;

    $rs = exec_query($sql, $query, array($domain_admin_id));

    if (!$returnWKeys) {
        return array(
            $rs->fields['domain_id'],
            $rs->fields['domain_name'],
            $rs->fields['domain_gid'],
            $rs->fields['domain_uid'],
            $rs->fields['domain_created_id'],
            $rs->fields['domain_created'],
            $rs->fields['domain_last_modified'],
            $rs->fields['domain_mailacc_limit'],
            $rs->fields['domain_ftpacc_limit'],
            $rs->fields['domain_traffic_limit'],
            $rs->fields['domain_sqld_limit'],
            $rs->fields['domain_sqlu_limit'],
            $rs->fields['domain_status'],
            $rs->fields['domain_alias_limit'],
            $rs->fields['domain_subd_limit'],
            $rs->fields['domain_ip_id'],
            $rs->fields['domain_disk_limit'],
            $rs->fields['domain_disk_usage'],
            $rs->fields['domain_php'],
            $rs->fields['domain_cgi']);
    } else {
        return $rs->fields;
    }
}

function get_domain_running_sub_cnt(&$sql, $domain_id) {
    $query = <<<SQL_QUERY
        SELECT
            COUNT(`subdomain_id`) AS cnt
        FROM
            `subdomain`
        WHERE
            `domain_id` = ?
SQL_QUERY;

    $rs = exec_query($sql, $query, array($domain_id));

    $sub_count = $rs->fields['cnt'];

$query = <<<SQL_QUERY
        SELECT
            COUNT(`subdomain_alias_id`) AS cnt
        FROM
            `subdomain_alias`
        WHERE
            `alias_id` IN (SELECT `alias_id` FROM `domain_aliasses` WHERE `domain_id`=?)
SQL_QUERY;

    $rs = exec_query($sql, $query, array($domain_id));

    $alssub_count = $rs->fields['cnt'];

    return $sub_count+$alssub_count;
}

function get_domain_running_als_cnt(&$sql, $domain_id) {
    $query = <<<SQL_QUERY
        SELECT
            COUNT(alias_id) AS cnt
        FROM
            domain_aliasses
        WHERE
            domain_id = ?

SQL_QUERY;

    $rs = exec_query($sql, $query, array($domain_id));

    $als_count = $rs->fields['cnt'];

    return $als_count;
}

function get_domain_running_mail_acc_cnt(&$sql, $domain_id) {
    $query = <<<SQL_QUERY
        SELECT
            COUNT(mail_id) AS cnt
        FROM
            mail_users
        WHERE
            mail_type RLIKE 'normal_'
          AND
            mail_type NOT LIKE 'normal_catchall'
          AND
            domain_id = ?
SQL_QUERY;

    $rs = exec_query($sql, $query, array($domain_id));

    $dmn_mail_acc = $rs->fields['cnt'];

    $query = <<<SQL_QUERY
        SELECT
            COUNT(mail_id) AS cnt
        FROM
            mail_users
        WHERE
            mail_type RLIKE 'alias_'
          AND
            mail_type NOT LIKE 'alias_catchall'
          AND
            domain_id = ?
SQL_QUERY;

    $rs = exec_query($sql, $query, array($domain_id));

    $als_mail_acc = $rs->fields['cnt'];

    $query = <<<SQL_QUERY
        SELECT
            COUNT(mail_id) AS cnt
        FROM
            mail_users
        WHERE
            mail_type RLIKE 'subdom_'
        AND
            mail_type NOT LIKE 'subdom_catchall'
        AND
            domain_id = ?
SQL_QUERY;

    $rs = exec_query($sql, $query, array($domain_id));

    $sub_mail_acc = $rs->fields['cnt'];

    $query = <<<SQL_QUERY
        SELECT
            COUNT(mail_id) AS cnt
        FROM
            mail_users
        WHERE
            mail_type RLIKE 'alssub_'
        AND
            mail_type NOT LIKE 'alssub_catchall'
        AND
            domain_id = ?
SQL_QUERY;

    $rs = exec_query($sql, $query, array($domain_id));

    $alssub_mail_acc = $rs->fields['cnt'];

    return array($dmn_mail_acc + $als_mail_acc + $sub_mail_acc + $alssub_mail_acc,
        $dmn_mail_acc,
        $als_mail_acc,
        $sub_mail_acc,
        $alssub_mail_acc);
}

function get_domain_running_dmn_ftp_acc_cnt(&$sql, $domain_id) {
    $ftp_separator=Config::get('FTP_USERNAME_SEPARATOR');

    $query = <<<SQL_QUERY
        SELECT
            domain_name
        FROM
            domain
        WHERE
            domain_id = ?
SQL_QUERY;

    $rs = exec_query($sql, $query, array($domain_id));

    $dmn_name = $rs->fields['domain_name'];

    $query = <<<SQL_QUERY
        SELECT
            COUNT(userid) AS cnt
        FROM
            ftp_users
        WHERE
            userid RLIKE ?
SQL_QUERY;

    $rs = exec_query($sql, $query, array($ftp_separator . $dmn_name));

    $dmn_ftp_acc_cnt = $rs->fields['cnt'];

    return $dmn_ftp_acc_cnt;
}

function get_domain_running_sub_ftp_acc_cnt(&$sql, $domain_id) {
    $ftp_separator=Config::get('FTP_USERNAME_SEPARATOR');
    $query = <<<SQL_QUERY
        SELECT
            subdomain_name
        FROM
            subdomain
        WHERE
            domain_id = ?
        ORDER BY
            subdomain_id
SQL_QUERY;

    $query2 = <<<SQL_QUERY
        SELECT
            domain_name
        FROM
            domain
        WHERE
            domain_id = ?
SQL_QUERY;

    $dmn = exec_query($sql, $query2, array($domain_id));
    $rs = exec_query($sql, $query, array($domain_id));

    $sub_ftp_acc_cnt = 0;

    while (!$rs->EOF) {
        $sub_name = $rs->fields['subdomain_name'];

        $query = <<<SQL_QUERY
            SELECT
                COUNT(userid) AS cnt
            FROM
                ftp_users
            WHERE
                userid RLIKE ?
SQL_QUERY;

        $rs_cnt = exec_query($sql, $query, array($ftp_separator . $sub_name . '.' . $dmn->fields['domain_name']));

        $sub_ftp_acc_cnt += $rs_cnt->fields['cnt'];

        $rs->MoveNext();
    }

    return $sub_ftp_acc_cnt;
}

function get_domain_running_als_ftp_acc_cnt(&$sql, $domain_id) {
    $ftp_separator=Config::get('FTP_USERNAME_SEPARATOR');
    $query = <<<SQL_QUERY
        SELECT
            alias_name
        FROM
            domain_aliasses
        WHERE
            domain_id = ?
        ORDER BY
            alias_id
SQL_QUERY;

    $rs = exec_query($sql, $query, array($domain_id));

    $als_ftp_acc_cnt = 0;

    while (!$rs->EOF) {
        $als_name = $rs->fields['alias_name'];

        $query = <<<SQL_QUERY
            SELECT
                COUNT(userid) AS cnt
            FROM
                ftp_users
            WHERE
                userid RLIKE ?
SQL_QUERY;

        $rs_cnt = exec_query($sql, $query, array($ftp_separator . $als_name));

        $als_ftp_acc_cnt += $rs_cnt->fields['cnt'];

        $rs->MoveNext();
    }

    return $als_ftp_acc_cnt;
}

function get_domain_running_ftp_acc_cnt(&$sql, $domain_id) {

    $dmn_ftp_acc_cnt = get_domain_running_dmn_ftp_acc_cnt($sql, $domain_id);
    $sub_ftp_acc_cnt = get_domain_running_sub_ftp_acc_cnt($sql, $domain_id);
    $als_ftp_acc_cnt = get_domain_running_als_ftp_acc_cnt($sql, $domain_id);

    return array(
        $dmn_ftp_acc_cnt + $sub_ftp_acc_cnt + $als_ftp_acc_cnt,
        $dmn_ftp_acc_cnt,
        $sub_ftp_acc_cnt,
        $als_ftp_acc_cnt);
}

function get_domain_running_sqld_acc_cnt(&$sql, $domain_id) {
    $query = <<<SQL_QUERY
        SELECT
            COUNT(sqld_id) AS cnt
        FROM
            sql_database
        WHERE
            domain_id = ?
SQL_QUERY;

    $rs = exec_query($sql, $query, array($domain_id));

    $sqld_acc_cnt = $rs->fields['cnt'];

    return $sqld_acc_cnt;
}

function get_domain_running_sqlu_acc_cnt(&$sql, $domain_id) {
    $query = <<<SQL_QUERY
        SELECT DISTINCT
            t1.sqlu_name
        FROM
            sql_user AS t1, sql_database AS t2
        WHERE
            t2.domain_id = ?
          AND
            t2.sqld_id = t1.sqld_id
SQL_QUERY;

    $rs = exec_query($sql, $query, array($domain_id));

    $sqlu_acc_cnt = $rs->RecordCount();

    return $sqlu_acc_cnt;
}

function get_domain_running_sql_acc_cnt(&$sql, $domain_id) {

    $sqld_acc_cnt = get_domain_running_sqld_acc_cnt($sql, $domain_id);
    $sqlu_acc_cnt = get_domain_running_sqlu_acc_cnt($sql, $domain_id);

    return array($sqld_acc_cnt, $sqlu_acc_cnt);
}

function get_domain_running_props_cnt(&$sql, $domain_id) {

    $sub_cnt = get_domain_running_sub_cnt($sql, $domain_id);
    $als_cnt = get_domain_running_als_cnt($sql, $domain_id);

    list($mail_acc_cnt, $dmn_mail_acc_cnt, $sub_mail_acc_cnt, $als_mail_acc_cnt, $alssub_mail_acc_cnt) = get_domain_running_mail_acc_cnt($sql, $domain_id);
    list($ftp_acc_cnt, $dmn_ftp_acc_cnt, $sub_ftp_acc_cnt, $als_ftp_acc_cnt) = get_domain_running_ftp_acc_cnt($sql, $domain_id);
    list($sqld_acc_cnt, $sqlu_acc_cnt) = get_domain_running_sql_acc_cnt($sql, $domain_id);

    return array($sub_cnt, $als_cnt, $mail_acc_cnt, $ftp_acc_cnt, $sqld_acc_cnt, $sqlu_acc_cnt);
}

function gen_client_mainmenu(&$tpl, $menu_file) {
    $sql = Database::getInstance();

    $tpl->define_dynamic('menu', $menu_file);
    $tpl->define_dynamic('isactive_awstats', 'menu');
    $tpl->define_dynamic('isactive_domain', 'menu');
    $tpl->define_dynamic('isactive_email', 'menu');
    $tpl->define_dynamic('isactive_ftp', 'menu');
    $tpl->define_dynamic('isactive_sql', 'menu');
    $tpl->define_dynamic('isactive_support', 'menu');
    $tpl->define_dynamic('custom_buttons', 'menu');

    $tpl->assign(
            array(
                'TR_MENU_GENERAL_INFORMATION' => tr('General information'),
                'TR_MENU_CHANGE_PASSWORD' => tr('Change password'),
                'TR_MENU_CHANGE_PERSONAL_DATA' => tr('Change personal data'),
                'TR_MENU_MANAGE_DOMAINS' => tr('Manage domains'),
                'TR_MENU_ADD_SUBDOMAIN' => tr('Add subdomain'),
                'TR_MENU_MANAGE_USERS' => tr('Email and FTP accounts'),
                'TR_MENU_ADD_MAIL_USER' => tr('Add mail user'),
                'TR_MENU_ADD_FTP_USER' => tr('Add FTP user'),
                'TR_MENU_MANAGE_SQL' => tr('Manage SQL'),
                'TR_MENU_ERROR_PAGES' => tr('Error pages'),
                'TR_MENU_ADD_SQL_DATABASE' => tr('Add SQL database'),
                'TR_MENU_DOMAIN_STATISTICS' => tr('Domain statistics'),
                'TR_MENU_DAILY_BACKUP' => tr('Daily backup'),
                'TR_MENU_QUESTIONS_AND_COMMENTS' => tr('Support system'),
                'TR_MENU_NEW_TICKET' => tr('New ticket'),
                'TR_MENU_LOGOUT' => tr('Logout'),
                'PHP_MY_ADMIN' => tr('PhpMyAdmin'),
                'TR_WEBMAIL' => tr('Webmail'),
                'TR_FILEMANAGER' => tr('Filemanager'),
                'TR_MENU_WEBTOOLS' => tr('Webtools'),
                'TR_HTACCESS' => tr('Protected areas'),
                'TR_AWSTATS' => tr('Web statistics'),
                'TR_HTACCESS_USER' => tr('Group/User management'),
                'TR_MENU_OVERVIEW' => tr('Overview'),
                'TR_MENU_EMAIL_ACCOUNTS' => tr('Email Accounts'),
                'TR_MENU_FTP_ACCOUNTS' => tr('FTP Accounts'),
                'TR_MENU_LANGUAGE' => tr('Language'),
                'TR_MENU_CATCH_ALL_MAIL' => tr('Catch all'),
                'TR_MENU_ADD_ALIAS' => tr('Add alias'),
                'TR_MENU_UPDATE_HP' => tr('Update Hosting Package'),
                'SUPPORT_SYSTEM_PATH' => Config::get('ISPCP_SUPPORT_SYSTEM_PATH'),
                'SUPPORT_SYSTEM_TARGET' => Config::get('ISPCP_SUPPORT_SYSTEM_TARGET'),
                'WEBMAIL_PATH' => Config::get('WEBMAIL_PATH'),
                'WEBMAIL_TARGET' => Config::get('WEBMAIL_TARGET'),
                'PMA_PATH' => Config::get('PMA_PATH'),
                'PMA_TARGET' => Config::get('PMA_TARGET'),
                'FILEMANAGER_PATH' => Config::get('FILEMANAGER_PATH'),
                'FILEMANAGER_TARGET' => Config::get('FILEMANAGER_TARGET'),
            )
        );

    $query = <<<SQL_QUERY
        SELECT
            *
        FROM
            custom_menus
        WHERE
            menu_level = 'user'
          OR
            menu_level = 'all'
SQL_QUERY;

    $rs = exec_query($sql, $query, array());
    if ($rs->RecordCount() == 0) {
        $tpl->assign('CUSTOM_BUTTONS', '');
    } else {
        global $i;
        $i = 100;

        while (!$rs->EOF) {
            $menu_name = $rs->fields['menu_name'];
            $menu_link = get_menu_vars($rs->fields['menu_link']);
            $menu_target = $rs->fields['menu_target'];
            $menu_link = str_replace('{ispcp_uname}', $_SESSION['user_logged'], $menu_link);

            if ($menu_target === '') {
                $menu_target = "";
            } else {
                $menu_target = "target=\"" . $menu_target . "\"";
            }

            $tpl->assign(
                    array(
                        'BUTTON_LINK' => $menu_link,
                        'BUTTON_NAME' => $menu_name,
                        'BUTTON_TARGET' => $menu_target,
                        'BUTTON_ID' => $i,
                        )
                );

            $tpl->parse('CUSTOM_BUTTONS', '.custom_buttons');
            $rs->MoveNext();
            $i++;
        } // end while
    } // end else

    list($dmn_id, $dmn_name, $dmn_gid, $dmn_uid, $dmn_created_id, $dmn_created, $dmn_last_modified,
         $dmn_mailacc_limit, $dmn_ftpacc_limit, $dmn_traff_limit, $dmn_sqld_limit, $dmn_sqlu_limit,
         $dmn_status, $dmn_als_limit, $dmn_subd_limit, $dmn_ip_id, $dmn_disk_limit, $dmn_disk_usage,
         $dmn_php, $dmn_cgi) = get_domain_default_props($sql, $_SESSION['user_id']);

    if ($dmn_mailacc_limit == -1) $tpl->assign('ISACTIVE_EMAIL', '');
    if (($dmn_als_limit == -1) && ($dmn_subd_limit == -1)) $tpl->assign('ISACTIVE_DOMAIN', '');
    if ($dmn_ftpacc_limit == -1) $tpl->assign('ISACTIVE_FTP', '');
    if ($dmn_sqld_limit == -1) $tpl->assign('ISACTIVE_SQL', '');

    if (!Config::get('ISPCP_SUPPORT_SYSTEM')) {
        $tpl->assign('ISACTIVE_SUPPORT', '');
    }

    if (Config::get('AWSTATS_ACTIVE') == 'no') {
        $tpl->assign('ISACTIVE_AWSTATS', '');
    } else {
        $tpl->assign(
            array(
                'AWSTATS_PATH' => 'http://' . $_SESSION['user_logged'] . '/stats/',
                'AWSTATS_TARGET' => '_blank'
                )
            );
    }

    $tpl->parse('MAIN_MENU', 'menu');
}

function gen_client_menu(&$tpl, $menu_file) {
    $sql = Database::getInstance();

    $tpl->define_dynamic('menu', $menu_file);
    $tpl->define_dynamic('custom_buttons', 'menu');
    $tpl->define_dynamic('isactive_update_hp', 'menu');

    $tpl->assign(
            array(
                'TR_MENU_GENERAL_INFORMATION' => tr('General information'),
                'TR_MENU_CHANGE_PASSWORD' => tr('Change password'),
                'TR_MENU_CHANGE_PERSONAL_DATA' => tr('Change personal data'),
                'TR_MENU_MANAGE_DO