Example #1
0
/**
 * Load data from sql
 */
function load_user_data($user_id, $domain_id)
{
    global $sub, $als, $mail, $ftp, $sql_db, $sql_user, $traff, $disk;
    $sql = EasySCP_Registry::get('Db');
    $query = "\n\t\tSELECT\n\t\t\t`domain_id`\n\t\tFROM\n\t\t\t`domain`\n\t\tWHERE\n\t\t\t`domain_id` = ?\n\t\tAND\n\t\t\t`domain_created_id` = ?\n\t";
    $rs = exec_query($sql, $query, array($domain_id, $user_id));
    if ($rs->recordCount() == 0) {
        set_page_message(tr('User does not exist or you do not have permission to access this interface!'), 'error');
        user_goto('users.php?psi=last');
    }
    list(, $sub, , $als, , $mail, , $ftp, , $sql_db, , $sql_user, $traff, $disk) = generate_user_props($domain_id);
    load_additional_data($user_id, $domain_id);
}
function load_user_data($user_id, $domain_id)
{
    global $sql;
    global $domain_name, $domain_ip, $php_sup;
    global $cgi_supp, $sub, $als;
    global $mail, $ftp, $sql_db;
    global $sql_user, $traff, $disk;
    global $username;
    $query = <<<SQL_QUERY
        select
            domain_id
        from
            domain
        where
            domain_id = ?
          and
            domain_created_id = ?
SQL_QUERY;
    $rs = exec_query($sql, $query, array($domain_id, $user_id));
    if ($rs->RecordCount() == 0) {
        set_page_message(tr('User does not exist or you do not have permission to access this interface!'));
        header('Location: users.php');
        die;
    }
    list($a, $sub, $b, $als, $c, $mail, $d, $ftp, $e, $sql_db, $f, $sql_user, $traff, $disk) = generate_user_props($domain_id);
    load_additional_data($user_id, $domain_id);
}