ps-mdt

QBCore.Functions.CreateCallback('mdt:server:GetProfileData', function(source, cb, sentId)
	if not sentId then return cb({}) end
 
	local src = source
	local PlayerData = GetPlayerData(src)
	if not PermCheck(src, PlayerData) then return cb({}) end
	local JobType = GetJobType(PlayerData.job.name)
	local target = GetPlayerDataById(sentId)
	local JobName = PlayerData.job.name
 
	local apartmentData
 
	if not target or not next(target) then return cb({}) end
 
	if type(target.job) == 'string' then target.job = json.decode(target.job) end
	if type(target.charinfo) == 'string' then target.charinfo = json.decode(target.charinfo) end
	if type(target.metadata) == 'string' then target.metadata = json.decode(target.metadata) end
 
	local licenses = MySQL.query.await("SELECT license FROM licenses WHERE owner = ?", { sentId })
	local licencesdata = {}
	local p = promise.new()
	exports.bcs_licensemanager:GetLicensesList(function(list)
		for i = 1, #list do
			if licenses then
				for j = 1, #licenses do
					if list[i].type == licenses[j].license then
						licencesdata[list[i].type] = true
					end
				end
			end
			if not licencesdata[list[i].type] then
				licencesdata[list[i].type] = false
			end
		end
		p:resolve()
	end)
	Citizen.Await(p)
 
    ... -- and so on

function GetPlayerLicenses(identifier)
    local response = false
    local Player = QBCore.Functions.GetPlayerByCitizenId(identifier)
    if Player ~= nil then
        local p = promise.new()
        exports.bcs_licensemanager:GetLicenses(Player.PlayerData.source, function(list)
            local licenses = {}
            for k, v in pairs(list) do
                licenses[v.type] = true
            end
            if #licenses == 0 then
                licenses = {
                    ['driver_car'] = false,
                    ['weapon'] = false,
                }
            end
            p:resolve(licenses)
        end)
        return Citizen.Await(p)
    else
        local result = MySQL.scalar.await('SELECT metadata FROM players WHERE citizenid = @identifier',
            { ['@identifier'] = identifier })
        if result ~= nil then
            local metadata = json.decode(result)
            if metadata["licences"] ~= nil and metadata["licences"] then
                return metadata["licences"]
            else
                return {
                    ['driver_car'] = false,
                    ['weapon'] = false,
                }
            end
        end
    end
end
 
function ManageLicense(identifier, type, status, source)
    local Player = QBCore.Functions.GetPlayerByCitizenId(identifier)
    local licenseStatus = nil
    if status == "give" then
        if Player ~= nil then
            licenseStatus = true
            TriggerClientEvent('LicenseManager:addLicense', Player.PlayerData.source, type)
        else
            licenseStatus = false
        end
    elseif status == "revoke" then
        licenseStatus = false
        exports.bcs_licensemanager:RevokeLicense(identifier, type, source)
    end
    if Player ~= nil then
        local licences = Player.PlayerData.metadata["licences"]
        local newLicenses = {}
        for k, v in pairs(licences) do
            local status = v
            if k == type then
                status = licenseStatus
            end
            newLicenses[k] = status
        end
        Player.Functions.SetMetaData("licences", newLicenses)
    else
        local licenseType = '$.licences.' .. type
        local result = MySQL.query.await(
            'UPDATE `players` SET `metadata` = JSON_REPLACE(`metadata`, ?, ?) WHERE `citizenid` = ?',
            { licenseType, licenseStatus, identifier }) --seems to not work on older MYSQL versions, think about alternative
    end
end
 
function UpdateAllLicenses(identifier, incomingLicenses, source)
    local Player = QBCore.Functions.GetPlayerByCitizenId(identifier)
    if Player ~= nil then
        for k, v in pairs(incomingLicenses) do
            if v and not exports.bcs_licensemanager:HasLicense(Player.PlayerData.source, k) then
                TriggerClientEvent('LicenseManager:addLicense', Player.PlayerData.source, k)
            elseif not v and exports.bcs_licensemanager:HasLicense(Player.PlayerData.source, k) then
                exports.bcs_licensemanager:RevokeLicense(identifier, k, source)
            end
        end
        Player.Functions.SetMetaData("licences", incomingLicenses)
    else
        local result = MySQL.scalar.await('SELECT metadata FROM players WHERE citizenid = @identifier',
            { ['@identifier'] = identifier })
        result = json.decode(result)
 
        result.licences = result.licences or {
            ['driver_car'] = false,
            ['weapon'] = false,
        }
 
        for k, _ in pairs(incomingLicenses) do
            result.licences[k] = incomingLicenses[k]
            if not incomingLicenses[k] then
                exports.bcs_licensemanager:RevokeLicense(identifier, k, source)
            end
        end
        MySQL.query.await('UPDATE `players` SET `metadata` = @metadata WHERE citizenid = @citizenid',
            { ['@metadata'] = json.encode(result), ['@citizenid'] = identifier })
    end
end

    ManageLicense(cid, type, status, src)
 
    UpdateAllLicenses(cid, licenses, src)