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>";
<?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) {
$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" => "لا يوجد");