mp.events.addCommand('creaaccount', (player, username, password) =>
{
	let loggedIn = false;
    console.log(username);
    console.log(password);
	if(username.length <= 16 && password.length <= 128)
	{
        console.log("inizio la query");
		gm.mysql.handle.query("SELECT * FROM 'accounts' WHERE 'Username' = ?", [username], function(err, res)
		{
            console.log("query");
            if(res.length > 0)
            {
            	player.outputChatBox('Username già in uso.');
            }
            else
            {
            	bcrypt.hash(password, null, null, function(err, hash)
                {
                	if(!err)
                	{
                		gm.mysql.handle.query("INSERT INTO 'accounts' SET Username = ?, Password = ?, LoggedIn = ?", [username, hash, loggedIn], function(err, res)
                		{
                		 	if(!err)
                		 	{
                		 		player.outputChatBox('Account registrato.');
                		 	} else {
                		 		throw err
                		 	 	console.log("\x1b[31m[ERROR] " + err)
                            }

                        });
                    } else {
                    	throw err
                    }
                });
            }
        });
    }
    else
    {
    	player.outputChatBox('Parametri errati.');
   	}

});