OwlCyberSecurity - MANAGER

Edit File: NewPlayer.php

<?PHP include("Connect.php"); $login = $_POST ["login"]; $password = $_POST ["password"]; $email = $_POST ["email"]; $query = "SELECT * FROM Player WHERE name ='" . $login . "' LIMIT 1"; $results = mysql_query($query); if(mysql_num_rows($results)==0) { $date = date("d-m-Y") . " " . date("H:i:s"); $query = "INSERT INTO Player VALUES(NULL,'" . $login. "','" . $password . "','" . $email . "','" . $date . "','" . $date . "',1)"; mysql_query($query); } $query = "SELECT * FROM Player WHERE name ='" . $login . "' AND password='" . $password ."' LIMIT 1"; $results = mysql_query($query); while($line = mysql_fetch_assoc($results)) { echo "<PLAYER>\n"; echo " <id>" . $line["id"] . "</id>\n"; echo " <name>" . $line["name"] . "</name>\n"; echo " <password>" . $line["password"] . "</password>\n"; echo " <email>" . $line["email"] . "</email>\n"; echo "</PLAYER>\n"; } mysql_close($link); ?>