Freischalten

 <?php  if (!defined('IN_SITE')) { echo "Zugriff verweigert!"; die(); }


	mysql_connect($host, $user, $pass);
	mysql_select_db($db);
	unset($host,$user,$pass,$db);

 ?>



<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 = mysql_query($query);
  while ($row = mysql_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">

		<?php
		$userpre = $row["Username"];

			if (isset($_POST['freischalten'])) {

			$sql = "UPDATE benutzerdaten SET trank = '2' WHERE Username = '".$userpre."';".


			mysql_query($sql) or exit("Konnte Eintrag nicht vornehmen!");


			}






		?>



		<form method="post">
		<input type="hidden" value="<?php echo $userpre; ?>" 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>