$ip = $_SERVER['REMOTE_ADDR']; $registered = 0; $valid = 0; $accounts = 0; $connect = mysqli_connect("localhost", "leestron_mgv_rp", "qJFn-^t[4D%z", "leestron_mgv_rp"); session_start(); if(isset($_SESSION["username"])) { ?> } if(isset($_POST["passwordc"])) { if(empty($_POST["user"]) && empty($_POST["password"])) { echo ''; } else { $username = mysqli_real_escape_string($connect, $_POST["user"]); $password = mysqli_real_escape_string($connect, $_POST["password"]); $passwordc = mysqli_real_escape_string($connect, $_POST["passwordc"]); $email = mysqli_real_escape_string($connect, $_POST["email"]); if(isset($_POST["password"]) && isset($_POST["passwordc"]) && isset($_POST["user"]) && isset($_POST["email"]) && $password == $passwordc){ $sql = "select * from accounts where socialName LIKE '$username' LIMIT 1"; $q = mysqli_query($connect, $sql); $row = mysqli_fetch_array($q); $accounts = mysqli_num_rows($q); if($accounts < 1){ $password = md5($password); $query = "INSERT INTO accounts (socialName, password, status, lastIp) VALUES('$username', '$password', -1, '$ip')"; if(mysqli_query($connect, $query)) { $registered = 1; $_SESSION['username'] = $username; $valid = 2; $content = "Logging you into the Mestro User Control Panel"; ?> } } else { $valid = 1; $content = "Please check those details and try again."; } } else { $valid = 1; $content = "An account already exists for this Social Club user, please try again."; } } } if(isset($_POST["user"]) && !isset($_POST["passwordc"])) { if(empty($_POST["user"]) && empty($_POST["password"])) { $valid = 1; $content = "Please ensure you fill in all fields."; } else { $username = mysqli_real_escape_string($connect, $_POST["user"]); $password = mysqli_real_escape_string($connect, $_POST["password"]); $password = md5($password); $query = "SELECT * FROM accounts WHERE socialName = '$username' AND password = '$password'"; $result = mysqli_query($connect, $query); if(mysqli_num_rows($result) > 0) { $_SESSION['username'] = $username; $valid = 2; $content = "Logging you into the Mestro User Control Panel"; $query = "UPDATE accounts SET lastip='$ip' WHERE socialName='$username';"; mysqli_query($connect, $query); ?> } else { $valid = 1; $content = "There was a problem logging you in, please check your credentials and try again."; } } } ?>