local QBCore = exports['qb-core']:GetCoreObject()


CreateThread(function()
    for _, allias in pairs(Config.command_alliases) do
        QBCore.Commands.Add(allias, Lang:t("command.info"),{{name = 'id', help = Lang:t("command.playerid")}}, true, function(source, args)
            local src = source
            local playerId = args[1]
            local Player = QBCore.Functions.GetPlayer(tonumber(playerId))
            if Player then
                local citizenid = Player.PlayerData.citizenid
                DropPlayer(playerId,Lang:t("info.kick_message"))
                CreateThread(function()
                    Wait(200)
        
                    exports.oxmysql:execute('DELETE FROM players WHERE citizenid = ?', { citizenid })
                    exports.oxmysql:execute('DELETE FROM player_vehicles WHERE citizenid = ?', { citizenid })
                    exports.oxmysql:execute('DELETE FROM player_outfits WHERE citizenid = ?', { citizenid })
                    exports.oxmysql.execute('DELETE FROM player_contacts WHERE citizenid =?', { citizenid })
                    exports.oxmysql.execute('DELETE FROM properties WHERE owner_citizdenid =?', { citizenid })
                    exports.oxmysql.execute('DELETE FROM playerskins WHERE citizenid =?', { citizenid })
                    exports.oxmysql.execute('DELETE FROM gksphone_settings WHERE identifier =?', { citizenid })
                    exports.oxmysql.execute('DELETE FROM gksphone_bank_transfer WHERE identifier =?', { citizenid })
                    exports.oxmysql.execute('DELETE FROM mdt_convictions WHERE cid =?', { citizenid })
                    exports.oxmysql.execute('DELETE FROM gksphone_vehicle_sales WHERE owner =?', { citizenid })
                    exports.oxmysql.execute('DELETE FROM players_bills WHERE citizenid =?', { citizenid })
                    exports.oxmysql.execute('DELETE FROM playerskins WHERE citizenid =?', { citizenid })
                    TriggerClientEvent("QBCore:Notify",src,Lang:t("info.command_executed"))
                    Config.finish_function(src,playerId)
                end)
            else
                TriggerClientEvent('QBCore:Notify', src, Lang:t("command.player_not_found"), 'error')
            end
        end, 'admin')
    end
end)