diff options
author | Benjamin Franzke <benjaminfranzke@googlemail.com> | 2013-01-30 15:43:52 +0100 |
---|---|---|
committer | Benjamin Franzke <benjaminfranzke@googlemail.com> | 2013-01-30 15:43:52 +0100 |
commit | 8ea6ea6db019f68436a69f36aae55a9f205efa35 (patch) | |
tree | 5c367520523c42b1935491d199b4e8f3c17b4708 /doc/niels-diplom/Dateistruktur/admin/user_admin.php | |
parent | ec6e82dbcdc153b9973240cdff91a03b6d2dc886 (diff) | |
download | sqltutor-plugin-8ea6ea6db019f68436a69f36aae55a9f205efa35.tar.gz sqltutor-plugin-8ea6ea6db019f68436a69f36aae55a9f205efa35.tar.bz2 sqltutor-plugin-8ea6ea6db019f68436a69f36aae55a9f205efa35.zip |
doc: Nils Weber doesnt have an 'e' in his firstname
Diffstat (limited to 'doc/niels-diplom/Dateistruktur/admin/user_admin.php')
-rwxr-xr-x | doc/niels-diplom/Dateistruktur/admin/user_admin.php | 406 |
1 files changed, 0 insertions, 406 deletions
diff --git a/doc/niels-diplom/Dateistruktur/admin/user_admin.php b/doc/niels-diplom/Dateistruktur/admin/user_admin.php deleted file mode 100755 index 01e7578..0000000 --- a/doc/niels-diplom/Dateistruktur/admin/user_admin.php +++ /dev/null @@ -1,406 +0,0 @@ -<?php - -include("../header.php"); - -if ($_SESSION['type'] == 0) // Session Zugangscheck für den Administrator - { - - //print "<meta HTTP-EQUIV=\"Refresh\" CONTENT=5; URL=\"/dipl/praktikum.php\">"; - print "<tr><td class=\"titel_15\">KEINE ADMINSESSION...</td></tr>"; - print "<tr><td class=\"titel_15\">Bitte Loggen sie sich erneut als Admin ein...</td></tr>"; - print "</td></tr></table></table>"; - include("../footer.php"); - exit; - - } - -include("adminfuncs.php"); - -if (isset($_POST['new_group'])) -{ - - add_group($_POST['gruppe']); //user anlegen - -} - -if (isset($_POST['add_user'])) -{ - - add_user($_POST['name'], $_POST['vorname'], $_POST['login'], $_POST['typ'], $_POST['user2group']); //user anlegen - -} - -if (isset($_POST['deakt_user'])) -{ - $message = del_user($_POST['deakt_him']); //user deaktivieren - unset($message); -} - -if (isset($_POST['akt_user'])) -{ - $message = akt_user($_POST['akt_ihn']); //user deaktivieren - unset($message); -} - -if (isset($_POST['chng_akt_group'])) -{ - $message = akt_group($_POST['all_group']); //Gruppe komplett aktivieren - unset($message); -} - -if (isset($_POST['chng_inakt_group'])) -{ - $message = inakt_group($_POST['all_group']); //Gruppe komplett deaktivieren - unset($message); -} - - -?> - -<a name="start"></a> - -<tr> -<td class="titel_15">NUTZERVERWALTUNG</td> -</tr> -<tr> -<td> -<table width=560> -<form action="<?=$_POST['PHP_SELF'] . "?" . SID?>" method="post"> - - <tr><td colspan=3 class="titel"><br>einzelne aktuelle Nutzer deaktivieren...<?print $message;?></td></tr> - <tr><td colspan=3> </td></tr> - <tr><td class="text" width=50>USER</td> - <td width=100> - <select class="inputtext" name="deakt_him" size="1" width=95> - - <? - - $sql = "SELECT name FROM students where aktiv=1"; - - $stmt = dbconnect($sql); - - OCIExecute($stmt); - - $nrows = OCIFetchStatement($stmt, $results); - - - for ( $i = 0; $i < $nrows; $i++ ) - { - reset($results); - - while ( $column = each($results) ) - { - $data = $column['value']; - //Liste mit vorhandenen Benutzern füllen - } - - echo "<option>$data[$i]</option>\n"; - } - - ?> - - </select> - </td> - - <td align=right> - <input class="inputsubmit" type="Submit" name="deakt_user" value="inaktiv setzen"> - </td> - - </tr> -</table> -</form> - -<table width=560> -<form action="<?=$_POST['PHP_SELF'] . "?" . SID?>" method="post"> - - <tr><td colspan=5 class="randoben"> </td></tr> - - <tr><td colspan=5 class="titel" >einzelne inaktive Nutzer aktivieren...nach Gruppen selektiert</td></tr> - <tr><td colspan=5> </td></tr> - - - - <tr><td class="text" width=50>GRUPPE</td> - <td width=100> - <select type=submit class="inputtext" name="group" size="1" onchange="this.form.submit()" width=95> - <? - - $sql = "SELECT distinct groups FROM students"; - - $stmt = dbconnect($sql); - - OCIExecute($stmt); - - $nrows = OCIFetchStatement($stmt, $results); - - - for ( $i = 0; $i < $nrows; $i++ ) - { - reset($results); - - while ( $column = each($results) ) - { - $data = $column['value']; //Liste mit vorhandenen Benutzern füllen - } - - if ($_POST['group'] == $data[$i]) print "<option selected>" . $data[$i] . "</option>\n"; else print "<option>$data[$i]</option>\n"; - } - - ?> - - </select> - </td> - - - <td class="text" align=right width=200>inaktive Nutzer aus der Gruppe: <?print $_POST['group'];?></td> - <td> - <select class="inputtext" name="akt_ihn" size="1"> - <? - $gruppe = $_POST['group']; - - $sql = "SELECT name FROM students where aktiv=0 and groups='$gruppe'"; - - $stmt = dbconnect($sql); - - OCIExecute($stmt); - - $nrows = OCIFetchStatement($stmt, $results); - - - for ( $i = 0; $i < $nrows; $i++ ) - { - reset($results); - - while ( $column = each($results) ) - { - $data = $column['value']; - //Liste mit vorhandenen Benutzern füllen - } - - echo "<option>$data[$i]</option>\n"; - } - - ?> - - </select> - </td> - <td align=right> - <input class="inputsubmit" type="Submit" name="akt_user" value="aktiv setzen"> - </td> - </tr> - <tr><td colspan=5> </td></tr> -</form> -</table> - - - -<table width=560> -<form action="<?=$_POST['PHP_SELF'] . "?" . SID?>" method="post"> - - <tr><td colspan=4 class="randoben"> </td></tr> - - <tr><td colspan=4 class="titel">gesamte Gruppen aktivieren oder deaktivieren...<?print $message;?></td></tr> - <tr><td colspan=4> </td></tr> - <tr><td class="text" width=50>GRUPPE</td> - <td width=100> - <select type=submit class="inputtext" name="all_group" size="1" onchange="this.form.submit()" width=95> - <? - - $sql = "SELECT distinct groups FROM students"; - - $stmt = dbconnect($sql); - - OCIExecute($stmt); - - $nrows = OCIFetchStatement($stmt, $results); - - - for ( $i = 0; $i < $nrows; $i++ ) - { - reset($results); - - while ( $column = each($results) ) - { - $data = $column['value']; //Liste mit vorhandenen Benutzern füllen - } - - if ($_POST['all_group'] == $data[$i]) print "<option selected>" . $data[$i] . "</option>\n"; else print "<option>$data[$i]</option>\n"; - } - - ?> - - </select> - </td> - - <td align=right> - <input class="inputsubmit" type="Submit" name="chng_akt_group" value="Gr. aktiv setzen"> - </td> - <td align=right> - <input class="inputsubmit" type="Submit" name="chng_inakt_group" value="Gr. inaktiv setzen"> - </td> - - </tr> - <tr><td> </td></tr> - </form> -</table> - -<table width=560> -<form action="<?=$_POST['PHP_SELF'] . "?" . SID?>" method="Post"> - - - <tr><td colspan=3 class="randoben"> </td></tr> - - <tr> - <td valign="center" colspan=3 class="titel">Hinzufügen einzelner Nutzer zu bestehenden Gruppen<br></td> - </tr> - <tr><td colspan=3> </td></tr> - -<tr><td class="text" width=150>in welche GRUPPE einfügen?</td> - <td width=100> - <select type=submit class="inputtext" name="user2group" size="1" onchange="this.form.submit()" width=95> - <? - - $sql = "SELECT groups FROM groups"; - //$sql = "SELECT distinct groups FROM students"; - - $stmt = dbconnect($sql); - - OCIExecute($stmt); - - $nrows = OCIFetchStatement($stmt, $results); - - - for ( $i = 0; $i < $nrows; $i++ ) - { - reset($results); - - while ( $column = each($results) ) - { - $data = $column['value']; //Liste mit vorhandenen Benutzern füllen - } - - if ($_POST['user2group'] == $data[$i]) print "<option selected>" . $data[$i] . "</option>\n"; else print "<option>$data[$i]</option>\n"; - } - - ?> - - </select> - </td> - </tr> - - - <tr> - <td class="text">NAME</td> - <td> - <input class="inputtext" type="title" name="name" size=40> - </td> - </tr> - - <tr> - <td class="text">VORNAME</td> - <td> - <input class="inputtext" type="title" name="vorname" size=40> - </td> - </tr> - - <tr> - <td class="text">LOGIN</td> - <td> - <input class="inputtext" type="Password" name="login" size=40> - </td> - </tr> - - <tr><td> </td></tr> - - <tr> - <td class="text">TYP</td> - <td> - <select class="inputtext" name="typ" size="1"> - <option value=0>USER</option> - <option value=1>ADMIN</option> - </select> - </td> - <td> - <input class="inputsubmit" type="Submit" name="add_user" size="30" value="Nutzer in <?print $_POST['user2group'];?> anlegen"> - </td> - </tr> - - <tr><td> </td></tr> - - </form> - - - - </table> - -<table width=560> -<form action="<?=$_POST['PHP_SELF'] . "?" . SID?>" method="post"> - <tr><td colspan=5 class="randoben"> </td></tr> - <tr><td colspan=3 class="titel">Neue Gruppe anlegen...</td></tr> - <tr><td colspan=3> </td></tr> - <tr><td class="text" width=50>Gruppenname:</td> - <td> - <input class="inputtext" type="title" name="gruppe" size=40> - </td> - <td align=right> - <input class="inputsubmit" type="Submit" name="new_group" value="Gruppe anlegen"> - </td> - - </tr> -</table> -</form> - - -<table width=560> -<form action="<?$_POST['PHP_SELF'] . SID?>" method="post" enctype="multipart/form-data"> - -<tr><td colspan=5 class="randoben"> </td></tr> -<tr><td colspan=5 class="titel" >EXCEL-LISTE HOCHLADEN</td></tr> - <tr><td colspan=5> </td></tr> - <tr> - <td class=text>Bitte wählen Sie eine .XLS-Datei mit den Userdaten: - <input type="hidden" name="MAX_FILE_SIZE" value="100000"> - <input class="inputsubmit" name="userfile" type="file" size="40" accept="*.xls"></td> - <td><br> - <input class="inputsubmit" type="submit" value="Upload File" name=upload align=right> - </td> - </tr> - <tr><td colspan=5> </td></tr> -</form> - -<? - -$uploadDir = '/usr/local/apache/htdocs_ssl/dipl/admin/LIST/'; -$uploadFile = $uploadDir . $_FILES['userfile']['name']; - -if ( $_FILES['userfile']['type'] == "application/vnd.ms-excel" ) -{ - $up = move_uploaded_file($_FILES['userfile']['tmp_name'], $uploadFile); - $_SESSION['file'] = $_FILES['userfile']['name']; -} - -if ( $up == 1 ) -{ - print "<tr><td class=text>Datei ist akzeptiert und wurde erfolgreich hochgeladen. <br>"; - print "<B>Debugging info:</B><br>" . "Datei: " . $_FILES['userfile']['name'] . "<br>Typ: " . $_FILES['userfile']['type'] . "<br>Größe: " . $_FILES['userfile']['size'] . " Byte"; - print "</td></tr><tr><td colspan=5> </td></tr>"; - print "<tr><td class=text><a href=get_user.php?".SID.">Zum Datenbankupload...</a></td></tr>"; -} -elseif (isset($_POST['upload'])) -{ - print "<tr><td class=text>Datei ist fehlerhaft oder keine EXCEL-DATEI und wurde nicht hochgeladen.<br>"; - print "<B>Debugging info:</B><br>" . "Datei: " . $_FILES['userfile']['name'] . "<br>Typ: " . $_FILES['userfile']['type'] . "<br>Größe: " . $_FILES['userfile']['size'] . " Byte"; -} -?> - -</table> - - </td> -</tr> -</table> -</table> - - -<? -include("../footer.php"); -?>
\ No newline at end of file |