<?php
if(!isset($_POST['username']) || !isset($_POST['passwort']) || !isset($_POST['mail'])) {
    header("Location: anmeldungsseite.php?error1=true");
} else {
    include 'include/mysqldatas.php';

    $nick = $_POST['username'];
    $pass = $_POST['passwort'];
    $mail = $_POST['mail'];


    $link = mysql_connect($mysqlhost, $mysqlusername, $mysqlpassword);
    mysql_select_db($mysqldatabase, $link);
    $befehl = mysql_query("SELECT * FROM Benutzerdaten WHERE Username ='$nick'");
    if (mysql_num_rows($befehl) > 0){
        echo "Username vergeben";
    } else {
        $insert = "INSERT INTO Benutzerdaten (Username, Kennwort, Email)
        VALUES ('$nick', '$pass', '$mail')";
        $ok = mysql_query($insert);

    if ($ok != 0) {

        $test = "SELECT * FROM Benutzerdaten WHERE Username = '$nick'";
        $result = mysql_query($test);
        $row = mysql_fetch_array($result, MYSQL_ASSOC);
        $nowtheid = $row['ID'];

        $befehl = mysql_query("SELECT * FROM Benutzerdaten WHERE Username ='$nick'");
        if (mysql_num_rows($befehl) > 0)
        {
            echo "Username vergeben";
        } else {
            $banner = "INSERT INTO Bannerklicks(ID) VALUES ('$nowtheid')";
            $input = mysql_query($banner);
            if($input != 0) {
                session_start();
                $_SESSION['ID'] = $nowtheid;
                header("Location: homeseite.php");
            } else {
                header("Location: anmeldungsseite.php?error2=true");
        }
    mysql_close($link);
    }
}
?>