PlayerInfo = {}

Player = {}
Player.__index = Player

-- Meta table for users
setmetatable(Player, {
    __call = function(self, source, Mdp, Nom)
        local pl = {}

        pl.source = source
        pl.Mdp = Mdp
        pl.Nom = Nom

        return setmetatable(pl, Player)
    end
})


function LoadUser(source)
    local identifier = 2
    local executed_query = MySQL:executeQuery("SELECT * FROM comptes WHERE ID = '@id'", {['@id'] = identifier})
    local result = MySQL:getResults(executed_query, {'Mdp', 'Nom'})

    PlayerInfo[source] = Player(source, result[1].Mdp, result[1].Nom)

    TriggerClientEvent('chatMessage', -1, {0, 0, 200}, PlayerInfo[source].Mdp)
    TriggerClientEvent('chatMessage', -1, {0, 0, 200}, PlayerInfo[source].Nom)
end