Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $link = mysqli_connect ('host', 'name', 'passwort', 'datenbank auswählen')
- or die('<p style="color: red;">Fehler (Verbinden)'. mysqli_error().'</p>');
- if(isset($_POST['freischalten'])){
- trankAendern($_POST['username']);
- }
- ?>
- <head>
- <title>Userverwaltung</title>
- </head>
- <div class="mainE shadow" style="height: 100%">
- <div class="admin_titel">Userverwaltung</div>
- <div class="admin_text">
- <table width="100%" border="2" cellpadding="5" class="table" style="margin:0">
- <tr>
- <th width="20%" class="success"> Username </th>
- <th width="30%" class="danger"> Rang </th>
- <th width="50%" class="success"> Funktionen </th>
- </tr>
- </table>
- <?php
- $query = "SELECT * FROM benutzerdaten ORDER BY id";
- $result = mysqli_query($link,$query) or die("Fehler");
- while ($row = mysqli_fetch_array($result))
- {
- ?>
- <table width="100%" border="2" cellpadding="5" class="table" style="margin:0">
- <tr>
- <!------------ Usernamen ------------>
- <td width="20%" class="success"> <?php echo $row["Username"]; ?> </td>
- <!------------ Rang + Umwandlung ------------>
- <td width="30%" class="danger">
- <?php
- $ranga = $row["trank"];
- switch ($ranga) {
- case 1:
- echo "<font color='red'> Freischaltung! </font>";
- break;
- case 2:
- echo "Mitarbeiter Zugriff";
- break;
- case 3:
- echo "Supporter Zugriff";
- break;
- case 4:
- echo "Mod Zugriff";
- break;
- case 5:
- echo "Admin Zugriff";
- break;
- case 10:
- echo "Admin+ Zugriff";
- break;
- case 20:
- echo "OP Zugriff";
- break;
- }
- ?>
- </td>
- <!------------ Funktionen ------------>
- <td width="50%" class="success">
- <form method="post">
- <input type="hidden" value="<?php echo $row["Username"]; ?>" name="username">
- <input type="submit" value="Freischalten" name="freischalten">
- <input type="submit" value="Rang ändern" name="rangan">
- <input type="submit" value="Nutzer sperren" name="sperren">
- </form>
- </td>
- </tr>
- </table>
- <?php
- }
- ?>
- </div>
- </div>
- <!-- PHP-Funktionen -->
- <?php
- function trankAendern($nutzername){
- //MySql Verbindung
- $link = mysqli_connect ('host', 'name', 'passwort', 'datenbank auswählen')
- or die('<p style="color: red;">Fehler (Verbinden)'. mysqli_error().'</p>');
- $sql = 'UPDATE benutzerdaten SET trank = 2 WHERE Username = "'.$nutzername.'"';
- mysqli_query($link,$sql) or exit("Konnte Eintrag nicht vornehmen!");
- }
- ?>
Add Comment
Please, Sign In to add comment