<?php include("top.php"); ?>

<?php
$form = "

  <form action='registrierung.php' method='post'>
  <table cellspacing='10'>
  <tr><td>Username</td><td><input type='text' name='username'></td></tr>
  <tr><td>eMail</td><td><input type='text' name='email'></td></tr>
  <tr><td>Passwort</td><td><input type='password' name='passwort'></td></tr>
  <tr><td>Passwort wiederholen</td><td><input type='password' name='passwort2'></td></tr>
  <tr><td>&nbsp;</td><td><input type='submit' name='regabschicken' value='Registrierung'></td></tr>
  </table>
  </form>

";
echo $form;

if($_POST['regabschicken'])
{
  $name = $_POST['username'];
  $email = $_POST['email'];
  $passwort = $_POST['passwort'];
  $passwort2 = $_POST['passwort2'];

  $pass = md5($passwort);

  if($name && $email && $passwort && passwort2)
  {
    if($passwort==$passwort2)
    {
      include('connect.php');
      $abfrage = mysql_query("SELECT * FROM spieler WHERE email='$email'");
      $numrows = mysql_num_rows($abfrage);

      if($numrows == 0)
      {
        mysql_query("INSERT INTO spieler VALUES('','$name','$pass','$email','1','0')");
        echo "Sie haben sich erfolgreich angemeldet.";
      }
    }
    else
    echo "Dein Passwort stimmt nicht überein.";
  }
  else
  echo "Sie haben nicht alle nötigen Felder ausgefüllt!";
}

?>

<?php include("bottom.php"); ?>