uRegister

event onLoad(){
	database.execute("CREATE TABLE IF NOT EXISTS uRegister(
    steamid VARCHAR(17) PRIMARY KEY,
    email VARCHAR(255) NOT NULL DEFAULT 0,
    password VARCHAR(255) NOT NULL DEFAULT 0
    );");
}
command uregister(email, password){
	permission = "uRegister";
	execute(){
		if(isSet(email) and isSet(password)){
			DBcheck = database.execute("SELECT * FROM uRegister WHERE steamid = '" + player.id + "';");
			DBcheck = DBcheck[0];
			if(DBcheck.count != 1){
                database.execute("INSERT INTO uRegister (steamid, email, password) VALUES ('" + player.id + "', '" + email + "', '" + password + "');");
                player.message("Registration Complete!");
                player.release();
                player.speed = 1;
                player.god = false;
                player.vanish = false;
			}
			else{
				player.message("You have already registered!");
			}
		}
		else{
			player.message("Usage: /uregister EMAIL PASSWORD");
		}
	}
}
command ulogin(password){
    permission = "uRegister";
    execute(){
        DBcheck = database.execute("SELECT * FROM uRegister WHERE steamid = '" + player.id + "';");
        DBcheck = DBcheck[0];
        if(DBcheck.count != 0){
            if(toString(DBcheck[2]) == toString(password)){
                player.message("Password Correct!");
                player.release();
                player.speed = 1;
                player.god = false;
                player.vanish = false;
            }
            else{
                player.message("Incorrect Password");
            }
        }
        else{
            player.message("Register First Using /uregister EMAIL PASSWORD");
        }
    }
}

event onPlayerJoined(player){
    DBcheck = database.execute("SELECT * FROM uRegister WHERE steamid = '" + player.id + "';");
	DBcheck = DBcheck[0];
	if(DBcheck.count != 0){
        player.message("Please Login Using /uLogin password");
        player.arrest();
        player.speed = 0;
        player.god = true;
        player.vanish = true;
    }
    else{
        player.message("Please Register Your Account Using /uRegister EMAIL PASSWORD");
        player.arrest();
        player.speed = 0;
        player.god = true;
        player.vanish = true;
    }
}