////////////////////////////COMMANDS//////////////////////////////////////
    .add(new Command('register')
    .timeout(180000)
    .description('Create an ingame account')
    .handler((player, args) => {
      let password = args.join(" ");

    if(pLogged[player.name]) {
      return player.SendChatMessage("Vous êtes déjà enregistré.");
    }

    let connection = gm.utility.dbConnect();

    connection.connect();

    connection.query("SELECT username FROM users WHERE username = '" + player.name + "'", function(err, results) {

      let numRows = results.length;

      if(numRows >= 1) {
        connection.end();
        return player.SendChatMessage("Vous etes déjà enregistré, connectez vous avec: /login [Motdepasse]");
      }
    });

    //let confirreg; // Variable que se asigna al jugador para que confirme la pwd

    if(ConfirmReg[player.name])
    {
      if(ConfirmPwd[player.name] == password)
      {
        var sha1 = require('sha1');
        password = connection.escape(password);
        let pwdhash = sha1(password);
        console.log("Hash created: " + pwdhash);
        let SQLQuery = "INSERT INTO users (username, password) VALUES ('" + player.name+ "','" + pwdhash + "');";
        connection.query(SQLQuery, function(err) {

          if(!err) {
              console.log("user "+ player.name + " registered sucesfull \n\n");
              player.SendChatMessage("Vous avez été inscrit avec succès");
              connection.query("SELECT id FROM users WHERE username = '" + player.name + "'", function(err2, results)
              {
                    PlayerInfo[player.name].id = results[0].id;


                    gm.events.onPlayerUpdate(player);
                    pLogged[player.name]  = true;

                  });
                connection.end();
          } else {
              console.log("Ha ocurrido un error al registrar al jugador \n\n");
              console.log("Error: " + err)
              player.SendChatMessage("Une erreur est survenue pendant votre inscription, Essayez a nouveaux" + err);
          }

        });


      } else {
        player.SendChatMessage("Les mot de passes ne correspondent pas, Essayez à nouveaux");
        ConfirmPwd[player.name] = "";
        ConfirmReg[player.name] = false;
      }

    } else {
      ConfirmPwd[player.name] = password;
      ConfirmReg[player.name] = true;
      player.SendChatMessage("Pour confirmer votre inscription tapez à nouveaux la commande /register [motdepasse]");
    }
     }))




     .add(new Command('login')
     .timeout(180000)
     .description('login youre account')
     .handler((player, args) => {
       if(!Registered[player.name]) {
           return player.SendChatMessage("Vous n'etes pas inscrit, Pour vous inscrire tapez la commande: /register [motdepasse]");
         } else {

           let password = args.join(" ");

           let connection = gm.utility.dbConnect();
           connection.connect();
           var sha1 = require('sha1');
           password = connection.escape(password);
           let pwdhash = connection.escape(sha1(password));
           let playername = connection.escape(player.name);
           console.log(playername);
           let SQLQuery = "SELECT * FROM users WHERE username = " + playername + " AND password = " + pwdhash;
           console.log(SQLQuery);

           connection.query(SQLQuery, function(err, results) {
             let num_rows = results.length;

             if(num_rows >= 1) {

               if(results[0].banned) {
                 player.Kick("Vous avez été bannis du serveur");
               }
               let stringLicenses = JSON.stringify(results[0]);
               console.log(stringLicenses);
               gm.events.onPlayerLogin(player, results[0]);

               player.SendChatMessage("Connection réussie");

             } else {
               player.SendChatMessage("Mot de passe incorrect, Réessayez.")
             }

           });

           connection.end();

         }      }))


///////////////////////////////////EVENTS//////////////////////////////


events.Add('PlayerCreated', function(player) {
  pLogged[player.name]    = false;
  ConfirmReg[player.name] = false;

  PlayerInfo[player.name] = {
    id: 0,
    adminlvl: 0,
    death : 0,
    banned: 0


  };

  // REG SYSTEM

    let connection = gm.utility.dbConnect();

    connection.connect(function(err){

      if(!err) {
          console.log("Database is connected ... \n\n");
      } else {
          console.log("Error connecting database ... \n\n");
      }

    });

    connection.query("SELECT username FROM users WHERE username = '" + player.name + "'", function(err, results) {

        let numRows = results.length;

        if(numRows >= 1) {
          player.SendChatMessage("Use /login [PASSWORD] to connect");   // show the login UI
          Registered[player.name] = true;

        } else {
          player.SendChatMessage("You are not registered, use /register [PASSWORD] to register");      // show the register UI
          Registered[player.name] = false;
        }
    });
    connection.end();




  console.log('Player ' + player.name + ' has successfully joined the server.');
  gm.chat.broadcast(player.name + ' has joined the server.', gm.config.color.orange);

});

events.Add('onPlayerLogin',function(player, dbData)  {
  console.log("dbData \n" + dbData);

  gm.utility.print("Player " + player.name + " logged in");




  PlayerInfo[player.name] = {
    id: dbData.id,
    adminlvl: dbData.adminlvl,
    death: dbData.death,
    banned: dbData.banned


  };

});



events.Add('onPlayerUpdate',function(player, callback, info)   {

    info = typeof info !== 'undefined' ? info : true;
    let connection = gm.utility.dbConnect();



    connection.connect();

    let SQLQuery = "UPDATE users SET" +
    " adminlvl=" + PlayerInfo[player.name].adminlvl +
        " ,death=" + PlayerInfo[player.name].death +
        " ,banned=" + PlayerInfo[player.name].banned +
    " WHERE id = " + PlayerInfo[player.name].id;

    connection.query(SQLQuery, function(err) {
      if(err) {
            gm.utility.print("An error ocurred trying to upload the info of " + player.name);
            gm.utility.print("QUERY: " + SQLQuery);
            gm.utility.print("[ERROR]: " + err);
            if(callback) callback(false);
          } else {
            if(info) { gm.utility.print("player data of " + player.name + " has been updated " + info); }
            if(callback) callback(true);
          }
    });

    connection.end();

});