root/trunk/gui/include/admin-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
 */

/*
 * encode() - encode string to be valid as mail header
 *
 * source: php.net/manual/en/function.mail.php
 *
 * input:
 *   string $in_str - string to be encoded [should be in the $charset charset]
 *   string $charset - chanrset in that string will be encoded
 *
 * output:
 *   string - encoded string
 *
 * comment: need to check emails with ? and space in subject - some probs can occur
 */
function encode($in_str, $charset = 'UTF-8') {
    $out_str = $in_str;
    if ($out_str && $charset) {
        // define start delimimter, end delimiter and spacer
        $end = "?=";
        $start = "=?" . $charset . "?B?";
        $spacer = $end . "\r\n " . $start;
        // determine length of encoded text within chunks
        // and ensure length is even
        $length = 75 - strlen($start) - strlen($end);
        $length = floor($length / 4) * 4;
        // encode the string and split it into chunks
        // with spacers after each chunk
        $out_str = base64_encode($out_str);
        $out_str = chunk_split($out_str, $length, $spacer);
        // remove trailing spacer and
        // add start and end delimiters
        $spacer = preg_quote($spacer);
        $out_str = preg_replace("/" . $spacer . "$/", "", $out_str);
        $out_str = $start . $out_str . $end;
    }
    return $out_str;
}

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

    $tpl->define_dynamic('menu', $menu_file);
    $tpl->define_dynamic('isactive_support', 'menu');
    $tpl->define_dynamic('custom_buttons', 'menu');
    $tpl->assign(
        array(
            'TR_MENU_GENERAL_INFORMATION' => tr('General information'),
            'TR_MENU_HOSTING_PLANS' => tr('Manage hosting plans'),
            'TR_MENU_SYSTEM_TOOLS' => tr('System tools'),
            'TR_MENU_MANAGE_USERS' => tr('Manage users'),
            'TR_MENU_STATISTICS' => tr('Statistics'),
            'SUPPORT_SYSTEM_PATH' => Config::get('ISPCP_SUPPORT_SYSTEM_PATH'),
            'SUPPORT_SYSTEM_TARGET' => Config::get('ISPCP_SUPPORT_SYSTEM_TARGET'),
            'TR_MENU_SUPPORT_SYSTEM' => tr('Support system'),
            'TR_MENU_SETTINGS' => tr('Settings'),
            'TR_MENU_GENERAL_INFORMATION' => tr('General information'),
            'TR_MENU_HOSTING_PLANS' => tr('Manage hosting plans'),
            'TR_MENU_SYSTEM_TOOLS' => tr('System tools'),
            'TR_MENU_MANAGE_USERS' => tr('Manage users'),
            'TR_MENU_STATISTICS' => tr('Statistics'),
            'SUPPORT_SYSTEM_PATH' => Config::get('ISPCP_SUPPORT_SYSTEM_PATH'),
            'SUPPORT_SYSTEM_TARGET' => Config::get('ISPCP_SUPPORT_SYSTEM_TARGET'),
            'TR_MENU_SUPPORT_SYSTEM' => tr('Support system'),
            'TR_MENU_SETTINGS' => tr('Settings'),
            'TR_MENU_CHANGE_PASSWORD' => tr('Change password'),
            'TR_MENU_CHANGE_PERSONAL_DATA' => tr('Change personal data'),
            'TR_MENU_ADD_ADMIN' => tr('Add admin'),
            'TR_MENU_ADD_RESELLER' => tr('Add reseller'),
            'TR_MENU_RESELLER_ASIGNMENT' => tr('Reseller assignment'),
            'TR_MENU_USER_ASIGNMENT' => tr('User assignment'),
            'TR_MENU_EMAIL_SETUP' => tr('Email setup'),
            'TR_MENU_CIRCULAR' => tr('Email marketing'),
            'TR_MENU_ADD_HOSTING' => tr('Add hosting plan'),
            'TR_MENU_RESELLER_STATISTICS' => tr('Reseller statistics'),
            'TR_MENU_SERVER_STATISTICS' => tr('Server statistics'),
            'TR_MENU_ADMIN_LOG' => tr('Admin log'),
            'TR_MENU_MANAGE_IPS' => tr('Manage IPs'),
            'TR_MENU_SYSTEM_INFO' => tr('System info'),
            'TR_MENU_I18N' => tr('Internationalisation'),
            'TR_MENU_LANGUAGE' => tr('Language'),
            'TR_MENU_LAYOUT_TEMPLATES' => tr('Layout'),
            'TR_MENU_LOGOUT' => tr('Logout'),
            'TR_MENU_QUESTIONS_AND_COMMENTS' => tr('Support system'),
            'TR_MENU_SERVER_TRAFFIC_SETTINGS' => tr('Server traffic settings'),
            'TR_MENU_SERVER_STATUS' => tr('Server status'),
            'TR_MENU_ISPCP_UPDATE' => tr('ispCP updates'),
            'TR_MENU_ISPCP_DATABASE_UPDATE' => tr('ispCP database updates'),
            'TR_MENU_ISPCP_DEBUGGER' => tr('ispCP debugger'),
            'TR_CUSTOM_MENUS' => tr('Custom menus'),
            'TR_MENU_OVERVIEW' => tr('Overview'),
            'TR_MENU_MANAGE_SESSIONS' => tr('User sessions'),
            'TR_MENU_LOSTPW_EMAIL' => tr('Lostpw email setup'),
            'TR_MAINTENANCEMODE' => tr('Maintenance mode'),
            'TR_GENERAL_SETTINGS' => tr('General settings'),
            'TR_SERVERPORTS' => tr('Server ports')
            )
        );

    $query = "
        SELECT
            *
        FROM
            `custom_menus`
        WHERE
            `menu_level` = 'admin'
    ";

    $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'];

            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
    if (!Config::get('ISPCP_SUPPORT_SYSTEM')) {
        $tpl->assign('ISACTIVE_SUPPORT', '');
    }

    if (strtolower(Config::get('HOSTING_PLANS_LEVEL')) != 'admin') {
        $tpl->assign('HOSTING_PLANS', '');
    }

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

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

    $tpl->define_dynamic('menu', $menu_file);
    $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_USERS' => tr('Manage users'),
            'TR_MENU_ADD_ADMIN' => tr('Add admin'),
            'TR_MENU_ADD_RESELLER' => tr('Add reseller'),
            'TR_MENU_RESELLER_ASIGNMENT' => tr('Reseller assignment'),
            'TR_MENU_USER_ASIGNMENT' => tr('User assignment'),
            'TR_MENU_EMAIL_SETUP' => tr('Email setup'),
            'TR_MENU_CIRCULAR' => tr('Email marketing'),
            'TR_MENU_HOSTING_PLANS' => tr('Manage hosting plans'),
            'TR_MENU_ADD_HOSTING' => tr('Add hosting plan'),
            'TR_MENU_ROOTKIT_LOG' => tr('Rootkit Log'),
            'TR_MENU_RESELLER_STATISTICS' => tr('Reseller statistics'),
            'TR_MENU_SERVER_STATISTICS' => tr('Server statistics'),
            'TR_MENU_ADMIN_LOG' => tr('Admin log'),
            'TR_MENU_MANAGE_IPS' => tr('Manage IPs'),
            'TR_MENU_SUPPORT_SYSTEM' => tr('Support system'),
            'TR_MENU_SYSTEM_INFO' => tr('System info'),
            'TR_MENU_I18N' => tr('Internationalisation'),
            'TR_MENU_LANGUAGE' => tr('Language'),
            'TR_MENU_LAYOUT_TEMPLATES' => tr('Layout'),
            'TR_MENU_LOGOUT' => tr('Logout'),
            'TR_MENU_QUESTIONS_AND_COMMENTS' => tr('Support system'),
            'TR_MENU_STATISTICS' => tr('Statistics'),
            'TR_MENU_SYSTEM_TOOLS' => tr('System tools'),
            'TR_MENU_SERVER_TRAFFIC_SETTINGS' => tr('Server traffic settings'),
            'TR_MENU_SERVER_STATUS' => tr('Server status'),
            'TR_MENU_ISPCP_UPDATE' => tr('ispCP updates'),
            'TR_MENU_ISPCP_DEBUGGER' => tr('ispCP debugger'),
            'TR_CUSTOM_MENUS' => tr('Custom menus'),
            'TR_MENU_OVERVIEW' => tr('Overview'),
            'TR_MENU_MANAGE_SESSIONS' => tr('User sessions'),
            'SUPPORT_SYSTEM_PATH' => Config::get('ISPCP_SUPPORT_SYSTEM_PATH'),
            'SUPPORT_SYSTEM_TARGET' => Config::get('ISPCP_SUPPORT_SYSTEM_TARGET'),
            'TR_MENU_LOSTPW_EMAIL' => tr('Lostpw email setup'),
            'TR_MAINTENANCEMODE' => tr('Maintenance mode'),
            'TR_MENU_SETTINGS' => tr('Settings'),
            'TR_GENERAL_SETTINGS' => tr('General settings'),
            'TR_SERVERPORTS' => tr('Server ports'),
            'VERSION' => Config::get('Version'),
            'BUILDDATE' => Config::get('BuildDate'),
            'CODENAME' => Config::get('CodeName')
            )
        );
    $query = "
        SELECT
            *
        from
            custom_menus
        where
            menu_level = 'admin1'
";

    $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'];

            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
    if (!Config::get('ISPCP_SUPPORT_SYSTEM')) {
        $tpl->assign('SUPPORT_SYSTEM', '');
    }

    if (strtolower(Config::get('HOSTING_PLANS_LEVEL')) != 'admin') {
        $tpl->assign('HOSTING_PLANS', '');
    }

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

function get_cnt_of_user(&$sql, $user_type) {
    $query = "SELECT count(`admin_id`) as cnt FROM `admin` WHERE `admin_type`=?";

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

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

    return $admin_cnt;
}

function get_cnt(&$sql, $table, $field, $where, $value) {
    if ($where != '') {
        $query = "SELECT count(?) as cnt FROM $table WHERE $where = ?";
        $rs = exec_query($sql, $query, array($field, $value));
    } else {
        $query = "SELECT count(?) as cnt FROM $table ";
        $rs = exec_query($sql, $query, array($field));
    }

    $cnt = $rs->fields['cnt'];
    return $cnt;
}

function get_sql_user_count($sql) {
    $query = "SELECT DISTINCT `sqlu_name` FROM `sql_user` ";

    $rs = exec_query($sql, $query, false);

    return $rs->RecordCount();
}

function get_admin_general_info(&$tpl, &$sql) {
    $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')
            )
        );

    $tpl->assign(
        array('ACCOUNT_NAME' => $_SESSION['user_logged'],
            'ADMIN_USERS' => get_cnt($sql, 'admin', 'admin_id', 'admin_type', 'admin'),
            'RESELLER_USERS' => get_cnt($sql, 'admin', 'admin_id', 'admin_type', 'reseller'),
            'NORMAL_USERS' => get_cnt($sql, 'admin', 'admin_id', 'admin_type', 'user'),
            'DOMAINS' => get_cnt($sql, 'domain', 'domain_id', '', ''),
            'SUBDOMAINS' => get_cnt($sql, 'subdomain', 'subdomain_id', '', '') + get_cnt($sql, 'subdomain_alias', 'subdomain_alias_id', '', ''),
            'DOMAINS_ALIASES' => get_cnt($sql, 'domain_aliasses', 'alias_id', '', ''),
            'MAIL_ACCOUNTS' => get_cnt($sql, 'mail_users', 'mail_id', '', ''),
            'FTP_ACCOUNTS' => get_cnt($sql, 'ftp_users', 'userid', '', ''),
            'SQL_DATABASES' => get_cnt($sql, 'sql_database', 'sqld_id', '', ''),
            'SQL_USERS' => get_sql_user_count($sql)
            )
        );
}

function gen_admin_list(&$tpl, &$sql) {
    $query = "
            SELECT
                t1.`admin_id`, t1.`admin_name`, t1.`domain_created`, IFNULL(t2.`admin_name`, '') AS created_by
            FROM
                `admin` AS t1
            LEFT JOIN
                `admin` AS t2 ON t1.created_by = t2.admin_id
            WHERE
                t1.`admin_type`='admin'
            ORDER BY
                t1.`admin_name`
            ASC
    ";

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

    $i = 0;

    if ($rs->RecordCount() == 0) {
        $tpl->assign(
            array('ADMIN_MESSAGE' => tr('Administrators list is empty!'),
                'ADMIN_LIST' => ''
                )
            );

        $tpl->parse('ADMIN_MESSAGE', 'admin_message');
    } else {
        $tpl->assign(
            array(
                'TR_ADMIN_USERNAME' => tr('Username'),
                'TR_ADMIN_CREATED_ON' => tr('Creation date'),
                'TR_ADMIN_CREATED_BY' => tr('Created by'),
                'TR_ADMIN_OPTIONS' => tr('Options'),
                )
            );
        while (!$rs->EOF) {
            if ($i % 2 == 0) {
                $tpl->assign(
                    array('ADMIN_CLASS' => 'content',
                        )
                    );
            } else {
                $tpl->assign(
                    array('ADMIN_CLASS' => 'content2',
                        )
                    );
            }

            $admin_created = $rs->fields['domain_created'];

            if ($admin_created == 0) {
                $admin_created = tr('N/A');
            } else {
                $date_formt = Config::get('DATE_FORMAT');
                $admin_created = date($date_formt, $admin_created);
            }

            if ($rs->fields['created_by'] == '' || $rs->fields['admin_id'] == $_SESSION['user_id']) {
                $tpl->assign(
                    array('ADMIN_DELETE_LINK' => ''
                        )
                    );
                $tpl->parse('ADMIN_DELETE_SHOW', 'admin_delete_show');
            } else {
                $tpl->assign(
                    array('ADMIN_DELETE_SHOW' => '',
                        'TR_DELETE' => tr('Delete'),
                        'URL_DELETE_ADMIN' => "user_delete.php?delete_id=" . $rs->fields['admin_id'] . "&delete_username=" . $rs->fields['admin_name'],
                        'ADMIN_USERNAME' => $rs->fields['admin_name'],
                        )
                    );
                $tpl->parse('ADMIN_DELETE_LINK', 'admin_delete_link');
            }

            $tpl->assign(
                array('ADMIN_USERNAME' => $rs->fields['admin_name'],
                    'ADMIN_CREATED_ON' => $admin_created,
                    'ADMIN_CREATED_BY' => ($rs->fields['created_by'] != null) ? $rs->fields['created_by'] : tr("System"),
                    'URL_EDIT_ADMIN' => "admin_edit.php?edit_id=" . $rs->fields[