Exemple #1
0
if ($action == 'adduser') {
    $user = $_POST['new_user'];
    $user = str_replace("\\'", '', $user);
    AddUser($user);
    print "<CENTER><H1 dir={$langdir}>{$l10nstr['118']}: ";
    /* user */
    print "{$user} ";
    print "<H1>{$l10nstr['158']}</H1>\n";
    /* added to system */
    print "<A HREF=guides.php>{$l10nstr['158']}</A>\n";
    exit;
}
if ($action == 'deluser') {
    $user = $_GET['user'];
    $user = str_replace("\\'", '', $user);
    DelUser($user);
    print "<CENTER><H1 dir=RTL>{$l10nstr['118']}: ";
    /* user */
    print "{$user} ";
    print "{$l10nstr['159']}</H1>\n";
    /* deleted from system */
    print "<A HREF=guides.php>{$l10nstr['158']}</A>\n";
    exit;
}
if ($action == 'users') {
    EditUserList();
    exit;
}
if ($level == 2) {
    print "<P dir=RTL>\n";
    print "<A HREF=guides.php?action=users>";
Exemple #2
0
<?php

DelUser($_GET["idUsr"]);
function DelUser($strID)
{
    $con = odbc_connect("DRIVER={SQL Server}; SERVER=i9yueekhr9.database.windows.net;\n            DATABASE=lotus;", "TSI", "SistemasInternet123");
    if (validaCategoria($strID) > 0) {
        $SQL = " DELETE Usuario WHERE IDUsuario = '" . $strID . "'";
        odbc_exec($con, $SQL);
        echo "Usuario Excluido";
    } else {
        echo "ID " . $strID . " nao existe.";
    }
}
function validaCategoria($strID)
{
    $con = odbc_connect("DRIVER={SQL Server}; SERVER=i9yueekhr9.database.windows.net;\n            DATABASE=lotus;", "TSI", "SistemasInternet123");
    $SQL = "select count(*) as 'QTD' from Usuario where IdUsuario = '" . $strID . "'";
    $res = odbc_exec($con, $SQL);
    $RFP = odbc_fetch_array($res);
    if ($RFP['QTD'] >= 1) {
        return 1;
    } else {
        return 0;
    }
}
function validaExclucao($strID)
{
    $con = odbc_connect("DRIVER={SQL Server}; SERVER=i9yueekhr9.database.windows.net;\n            DATABASE=lotus;", "TSI", "SistemasInternet123");
    $SQL = "select count(*) as 'QTD' from Usuario where IDUsuario = '" . $strID . "'";
    $res = odbc_exec($con, $SQL);
    $styleid = $_POST['styleid'];
    AddUser($username, $password, $repassword, $groupid, $adminclass, $checked, $styleid, $logininid, $loginin);
} elseif ($enews == "EditUser") {
    $userid = $_POST['userid'];
    $username = $_POST['username'];
    $password = $_POST['password'];
    $repassword = $_POST['repassword'];
    $groupid = $_POST['groupid'];
    $adminclass = $_POST['adminclass'];
    $oldusername = $_POST['oldusername'];
    $checked = $_POST['checked'];
    $styleid = $_POST['styleid'];
    EditUser($userid, $username, $password, $repassword, $groupid, $adminclass, $oldusername, $checked, $styleid, $logininid, $loginin);
} elseif ($enews == "DelUser") {
    $userid = $_GET['userid'];
    DelUser($userid, $logininid, $loginin);
}
$page = (int) $_GET['page'];
$start = 0;
$line = 25;
//每页显示条数
$page_line = 12;
//每页显示链接数
$offset = $page * $line;
//总偏移量
$url = "<a href=ListUser.php>管理用户</a>";
//排序
$mydesc = (int) $_GET['mydesc'];
$desc = $mydesc ? 'asc' : 'desc';
$orderby = (int) $_GET['orderby'];
if ($orderby == 1) {
Exemple #4
0
$ordr = (int) $param->order;
switch ($ordr) {
    case 1:
        GetUsers();
        break;
    case 2:
        InsertUser($param);
        break;
    case 3:
        UpdateUser($param);
        break;
    case 4:
        GetUserInfo($param);
        break;
    case 5:
        DelUser($param);
        break;
}
function GetUsers()
{
    $sql = "SELECT `user_name` FROM `keys` WHERE 1";
    $rr = array();
    include "db_config.php";
    $result = mysqli_query($con, $sql);
    $i = 0;
    while ($row = $result->fetch_row()) {
        $rr[$i] = array("user" => strval($row[0]));
        $i++;
    }
    if ($i == 0) {
        $rr[0] = array("user" => "لا يوجد");