Untitled

<!doctype html>
<?php
	include("db_verbindung.php");

	if(isset($_POST["register"])){
		if(isset($_POST["username"]) && isset($_POST["password"]) && isset($_POST["password2"]) && isset($_POST["mail"]) && isset($_POST["playername"])){
			$isUserTaken = "Select *
							From user
							Where u_name = '". $_POST['username']."'";
			$usererg = mysqli_fetch_row(mysqli_query($db_verb,$isUserTaken));
			if($usererg == null){
				if($_POST["password"] != $_POST["password2"]){
					echo "Passwörter müssen übereinstimmen!";
				}
				else{
					$isPlayerInDatabase = "Select * From player Where p_name = '". $_POST['username']."'";
					$playererg = mysqli_fetch_row(mysqli_query($db_verb,$isPlayerInDatabase));
					if($playererg == 0){
						$json = file_get_contents("https://api.worldoftanks.eu/wot/account/list/?application_id=42d746c1cf05b66ea62edd8647563b20&search=".$_POST['playername']."");
						$objPlayer = json_decode($json,TRUE);
						$accountId = $objPlayer["data"][0]["account_id"];
						$json = file_get_contents("https://api.worldoftanks.eu/wot/account/info/?application_id=42d746c1cf05b66ea62edd8647563b20&account_id=".$objPlayer["data"][0]["account_id"]."");
            $objPlayerData = json_decode($json,TRUE);
						echo $objPlayerData["data"][$accountId]["statistics"]["all"]["battles"];
					}
					$playerIdSql = "Select p_id From player Where p_name = '". $_POST['playername']."'";
					$playerIdErg = mysqli_fetch_row(mysqli_query($db_verb,$playerIdSql));
					$playerId = $playerIdErg[0];
					$hash = md5($_POST["password"]);
					$user = $_POST["username"];
					$mail = $_POST["mail"];
					$adduser = "INSERT INTO user (u_name, u_pass, u_mail, p_id) VALUES('$user','$hash','$mail','$playerId')";
					mysqli_query($db_verb,$adduser);
				}
			}
			else{
				echo "RIPPPPP";
			}
		}
		else{
			echo "SQL WTF!";
		}
	}
	else{
		echo "nope";
	}
?>


<html lang="de">
  <head>
    <link rel="stylesheet" type="text/css" href="../styles/mainstyle.css" />
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Login</title>
  </head>
  <body>
	<div class="loginarea">
		<form  action="" method="post">
			<p> Username: </><br/>
			<input type="Text" name="username"><br/>
			<p> Password: </><br/>
			<input type="Password" name="password"><br/>
			<p> Confirm Password: </><br/>
			<input type="Password" name="password2"><br/>
			<p> E-mail: </><br/>
			<input name="mail"><br/>
			<p> WoT-name: </><br/>
			<input name="playername"><br/>
			<input type="submit" name="register" value="Registrieren" >
		</form>
	</div>
  </body>
</html>