예제 #1
0
/**
 * Check input data.
 *
 * @return bool TRUE if data are valid and consistents, FALSE otherwise
 */
function check_user_data()
{
    $stmt = exec_query('SELECT admin_id FROM admin WHERE admin_type = ? ORDER BY admin_name', 'user');
    $selectedUsers = '';
    while ($row = $stmt->fetchRow(PDO::FETCH_ASSOC)) {
        $adminId = $row['admin_id'];
        $adminIdVarname = 'admin_id_' . $adminId;
        if (isset($_POST[$adminIdVarname]) && $_POST[$adminIdVarname] === 'on') {
            $selectedUsers .= $adminId . ';';
        }
    }
    if ($selectedUsers == '') {
        set_page_message(tr('Please select at least one user.'), 'error');
        return false;
    } else {
        if ($_POST['src_reseller'] == $_POST['dst_reseller']) {
            set_page_message(tr('Both source and destination are identical.'), 'error');
            return false;
        }
    }
    $toReseller = intval($_POST['dst_reseller']);
    $stmt = exec_query('SELECT reseller_ips FROM reseller_props WHERE reseller_id = ?', $toReseller);
    $errorsStack = '_off_';
    $toResellerIpAddr = $stmt->fields['reseller_ips'];
    check_ip_sets($toResellerIpAddr, $selectedUsers, $errorsStack);
    if ($errorsStack == '_off_') {
        admin_updateResellerLimits($_POST['dst_reseller'], $_POST['src_reseller'], $selectedUsers, $errorsStack);
    }
    if ($errorsStack != '_off_') {
        set_page_message($errorsStack, 'error');
        return false;
    }
    return true;
}
예제 #2
0
function check_user_data()
{
    $sql = EasySCP_Registry::get('Db');
    $query = "\n\t\tSELECT\n\t\t\t`admin_id`\n\t\tFROM\n\t\t\t`admin`\n\t\tWHERE\n\t\t\t`admin_type` = 'user'\n\t\tORDER BY\n\t\t\t`admin_name`\n\t";
    $rs = exec_query($sql, $query);
    $selected_users = '';
    while (!$rs->EOF) {
        $admin_id = $rs->fields['admin_id'];
        $admin_id_var_name = 'admin_id_' . $admin_id;
        if (isset($_POST[$admin_id_var_name]) && $_POST[$admin_id_var_name] === 'on') {
            $selected_users .= $rs->fields['admin_id'] . ';';
        }
        $rs->Movenext();
    }
    if ($selected_users == '') {
        set_page_message(tr('Please select at least one user!'), 'warning');
        return false;
    } else {
        if ($_POST['src_reseller'] == $_POST['dst_reseller']) {
            set_page_message(tr('Source and destination reseller are the same!'), 'error');
            return false;
        }
    }
    $dst_reseller = $_POST['dst_reseller'];
    $query = "\n\t\tSELECT\n\t\t\t`reseller_ips`\n\t\tFROM\n\t\t\t`reseller_props`\n\t\tWHERE\n\t\t\t`reseller_id` = ?\n\t";
    $rs = exec_query($sql, $query, $dst_reseller);
    $mru_error = '_off_';
    $dest_reseller_ips = $rs->fields['reseller_ips'];
    check_ip_sets($dest_reseller_ips, $selected_users, $mru_error);
    if ($mru_error == '_off_') {
        manage_reseller_limits($_POST['dst_reseller'], $_POST['src_reseller'], $selected_users, $mru_error);
    }
    if ($mru_error != '_off_') {
        set_page_message($mru_error, 'error');
        return false;
    }
    return true;
}
function check_user_data()
{
    global $sql;
    $query = <<<SQL_QUERY
        select
            admin_id
        from
            admin
        where
            admin_type = 'user'
        order by
            admin_id
SQL_QUERY;
    $rs = exec_query($sql, $query, array());
    $selected_users = '';
    while (!$rs->EOF) {
        $admin_id = $rs->fields['admin_id'];
        $admin_id_var_name = "admin_id_{$admin_id}";
        if (isset($_POST[$admin_id_var_name]) && $_POST[$admin_id_var_name] === 'on') {
            $selected_users .= $rs->fields['admin_id'] . ';';
        }
        $rs->Movenext();
    }
    if ($selected_users == '') {
        set_page_message(tr('Please select some user(s)!'));
        return false;
    } else {
        if ($_POST['src_reseller'] == $_POST['dst_reseller']) {
            set_page_message(tr('Source and destination reseller are the same!'));
            return false;
        }
    }
    $dst_reseller = $_POST['dst_reseller'];
    $query = <<<SQL_QUERY
        select
            reseller_ips
        from
            reseller_props
        where
            reseller_id = ?
SQL_QUERY;
    $rs = exec_query($sql, $query, array($dst_reseller));
    $mru_error = '_off_';
    $dest_reseller_ips = $rs->fields['reseller_ips'];
    check_ip_sets($dest_reseller_ips, $selected_users, $mru_error);
    if ($mru_error == '_off_') {
        manage_reseller_limits($_POST['dst_reseller'], $_POST['src_reseller'], $selected_users, $mru_error);
    }
    if ($mru_error != '_off_') {
        set_page_message($mru_error);
        return false;
    }
    return true;
}