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['playername']."'";
					$playererg = mysqli_fetch_row(mysqli_query($db_verb,$isPlayerInDatabase));
					if($playererg == 0){
						echo "Hallo";
						$json = file_get_contents("https://api.worldoftanks.eu/wot/account/list/?application_id=42d746c1cf05b66ea62edd8647563b20&search=".$_POST['playername']."");
						$objPlayer = json_decode($json,TRUE);
						$playerName = $_POST['playername'];
						$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);
						$battles = $objPlayerData["data"][$accountId]["statistics"]["all"]["battles"];
						$wins = $objPlayerData["data"][$accountId]["statistics"]["all"]["wins"];
						$losses = $objPlayerData["data"][$accountId]["statistics"]["all"]["losses"];
						$draws = $objPlayerData["data"][$accountId]["statistics"]["all"]["draws"];
						$rating = $objPlayerData["data"][$accountId]["global_rating"];
						$created = $objPlayerData["data"][$accountId]["created_at"];
						$lastUpdated = $objPlayerData["data"][$accountId]["updated_at"];
						$lastPlayed = $objPlayerData["data"][$accountId]["last_battle_time"];
						$clanId = $objPlayerData["data"][$accountId]["clan_id"];
						$frags = $objPlayerData["data"][$accountId]["statistics"]["all"]["frags"];
						$battleAvgXp = $objPlayerData["data"][$accountId]["statistics"]["all"]["battle_avg_xp"];
						$capturePoints = $objPlayerData["data"][$accountId]["statistics"]["all"]["capture_points"];
						$damageDealt = $objPlayerData["data"][$accountId]["statistics"]["all"]["damage_dealt"];
						$damageReceived = $objPlayerData["data"][$accountId]["statistics"]["all"]["damage_received"];
						$maxDamage = $objPlayerData["data"][$accountId]["statistics"]["all"]["max_damage"];
						$survived = $objPlayerData["data"][$accountId]["statistics"]["all"]["survived_battles"];
						$shots = $objPlayerData["data"][$accountId]["statistics"]["all"]["shots"];
						$xp = $objPlayerData["data"][$accountId]["statistics"]["all"]["xp"];
						$addPlayer = "INSERT INTO player (p_name,p_battles,p_wins,p_losses,p_draws,p_rating,p_created,p_lastupdated,p_lastplayed,p_accountid,p_clanid,p_frags,p_battle_avg_xp,p_capturepoints,p_damagedealt,p_damagereceived,p_maxdamage,p_survived,p_shots,p_xp)
													VALUES ('$playerName','$battles','$wins','$losses','$draws','$rating','$created','$lastUpdated','$lastPlayed','$accountId','$clanId','$frags','$battleAvgXp','$capturePoints','$damageDealt','$damageReceived','$maxDamage','$survived','$shots','$xp')";
						mysqli_query($db_verb,$addPlayer);
					}
					$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>