ArenaStats.lua

local addonName = "ArenaStats"
local addonTitle = select(2, C_AddOns.GetAddOnInfo(addonName))
local ArenaStats = _G.LibStub("AceAddon-3.0"):NewAddon(addonName,
                                                       "AceConsole-3.0",
                                                       "AceEvent-3.0")
local L = _G.LibStub("AceLocale-3.0"):GetLocale(addonName, true)
local libDBIcon = _G.LibStub("LibDBIcon-1.0")
local LibRaces = _G.LibStub("LibRaces-1.0")
local IsActiveBattlefieldArena = IsActiveBattlefieldArena
local GetBattlefieldStatus, GetBattlefieldTeamInfo, GetNumBattlefieldScores,
      GetBattlefieldScore, GetBattlefieldWinner, IsArenaSkirmish, IsInInstance,
      GetInstanceInfo = GetBattlefieldStatus, GetBattlefieldTeamInfo,
                        GetNumBattlefieldScores, GetBattlefieldScore,
                        GetBattlefieldWinner, IsArenaSkirmish, IsInInstance,
                        GetInstanceInfo
local UnitName, UnitRace, UnitClass, UnitGUID, UnitFactionGroup, UnitIsPlayer =
    UnitName, UnitRace, UnitClass, UnitGUID, UnitFactionGroup, UnitIsPlayer

function ArenaStats:OnInitialize()
    self.db = _G.LibStub("AceDB-3.0"):New(addonName, {
        profile = {
            minimapButton = {hide = false},
            maxHistory = 0,
            characterNamesOnHover = {hide = false},
            showSpec = { hide = false }
        },
        char = {history = {}}
    })

    self:Print("Tracking ready, have a nice session!")
    self.specSpells = self:GetSpecSpells();

    self:RegisterEvent("UPDATE_BATTLEFIELD_STATUS")
    self:RegisterEvent("UPDATE_BATTLEFIELD_SCORE")
    self:RegisterEvent("ZONE_CHANGED_NEW_AREA")

    self:RegisterEvent("ARENA_OPPONENT_UPDATE")
    self:RegisterEvent("UNIT_AURA")
    self:RegisterEvent("UNIT_SPELLCAST_START")
    self:RegisterEvent("UNIT_SPELLCAST_CHANNEL_START")
    self:RegisterEvent("UNIT_SPELLCAST_SUCCEEDED")

    self:DrawMinimapIcon()
    self:RegisterOptionsTable()

    self.specTable = {}
    self.arenaEnded = false
    self.current = { status = "none", stats = {}, units = {} }
    self:Reset()
end

function ArenaStats:OnSpecDetected(unitName, spec)
    local existingPlayer = self.specTable[unitName]

    if existingPlayer then
        return
    end

    self.specTable[unitName] = spec
end

function ArenaStats:ScanUnitBuffs(unit)
    for n = 1, 30 do
        local auraData = C_UnitAuras.GetAuraDataByIndex(unit, n, "HELPFUL")

        if (not auraData) then
            break
        end

        if (not auraData.name) then
            break
        end

        local spellID = auraData.spellId
        local unitCaster = auraData.sourceUnit

        if self.specSpells[spellID] and unitCaster then -- Check for auras that detect a spec
            local unitPet = string.gsub(unit, "%d$", "pet%1")
            if UnitIsUnit(unit, unitCaster) or UnitIsUnit(unitPet, unitCaster) then
                self:OnSpecDetected(GetUnitName(unitCaster, true), self.specSpells[spellID])
            end
        end
    end
end

function ArenaStats:ARENA_OPPONENT_UPDATE(unit, updateReason)
    self:ScanUnitBuffs(unit)
end

function ArenaStats:UNIT_AURA(unit, isFullUpdate, updatedAuras)
    ArenaStats:ScanUnitBuffs(unit)
end

function ArenaStats:UNIT_SPELLCAST_START(event, unit, castGUID)
    local spellName, _, _, _, _, _, _, _, spellID = CastingInfo(event)

    if event then
        ArenaStats:ScanUnitBuffs(unit)
    end

    if spellName then
        if self.specSpells[spellID] and event then
            local name = GetUnitName(unit, true)
            self:OnSpecDetected(name, self.specSpells[spellID])
        end
    end
end

function ArenaStats:UNIT_SPELLCAST_CHANNEL_START(event, unit, castGuid, spellId)
    if unit then 
        ArenaStats:ScanUnitBuffs(unit)
    end

    if spellId then
        if self.specSpells[spellId] and unit then
            local name = GetUnitName(unit, true)
            self:OnSpecDetected(name, self.specSpells[spellId])
        end
    end
end

function ArenaStats:UNIT_SPELLCAST_SUCCEEDED(event, unit, castGuid, spellId)
    if unit then
        ArenaStats:ScanUnitBuffs(unit)
    end

    if spellId then
        if self.specSpells[spellId] and unit then
            local name = GetUnitName(unit, true)
            self:OnSpecDetected(name, self.specSpells[spellId])
        end
    end
end

function ArenaStats:ZONE_CHANGED_NEW_AREA()
    local _, instanceType = IsInInstance()
    if (instanceType == "arena") then
        self.arenaEnded = false
        self.specTable = {}
    end
end

function ArenaStats:UPDATE_BATTLEFIELD_STATUS(_, index)
    local status, mapName, instanceID, levelRangeMin, levelRangeMax, teamSize,
    isRankedArena, suspendedQueue, bool, queueType =
        GetBattlefieldStatus(index)
    if (status == "active" and teamSize > 0 and IsActiveBattlefieldArena()) then
        self.current["status"] = status
        self.current["stats"]["teamSize"] = teamSize
        self.current["stats"]["isRanked"] = not IsArenaSkirmish()
        if (self.current["stats"]["startTime"] == nil or
                self.current["stats"]["startTime"] == '') then
            self.current["stats"]["startTime"] = _G.time()
        end
    end
end

function ArenaStats:GetSpecOrDefault(unitName)
    if not unitName then
        return "Unknown"
    end

    local detectedSpec = self.specTable[unitName]

    if detectedSpec then
        return detectedSpec
    end

    return "Unknown"
end

function ArenaStats:SetLastArenaRankingData()
    local playerTeam = ''
    local greenTeam = {}
    local goldTeam = {}
    local myName = UnitName("player")
    local numScores = GetNumBattlefieldScores()

    for i = 1, numScores do
        local data = { GetBattlefieldScore(i) }
        local teamIndex = data[6]
        if data[1] == myName then
            if teamIndex == 0 then
                playerTeam = 'GREEN'
            else
                playerTeam = 'GOLD'
            end
        end

        if teamIndex == 0 then
            table.insert(greenTeam, data)
        else
            table.insert(goldTeam, data)
        end
    end

    self.current["stats"]["teamColor"] = playerTeam

    for i = 0, 1 do
        local teamName, oldTeamRating, newTeamRating, teamMMR =
            GetBattlefieldTeamInfo(i)
        if teamMMR > 0 then
            if ((i == 0 and playerTeam == 'GREEN') or
                    (i == 1 and playerTeam == 'GOLD')) then
                self.current["stats"]["teamName"] = teamName
                self.current["stats"]["oldTeamRating"] = oldTeamRating
                self.current["stats"]["newTeamRating"] = newTeamRating
                self.current["stats"]["diffRating"] = newTeamRating -
                    oldTeamRating
                self.current["stats"]["mmr"] = teamMMR
            else
                self.current["stats"]["enemyTeamName"] = teamName
                self.current["stats"]["enemyOldTeamRating"] = oldTeamRating
                self.current["stats"]["enemyNewTeamRating"] = newTeamRating
                self.current["stats"]["enemyDiffRating"] = newTeamRating -
                    oldTeamRating
                self.current["stats"]["enemyMmr"] = teamMMR
            end
        end
    end

    self.current["stats"]["teamClass"] = {}
    self.current["stats"]["teamCharName"] = {}
    self.current["stats"]["teamRace"] = {}
    self.current["stats"]["teamSpec"] = {}

    self.current["stats"]["enemyClass"] = {}
    self.current["stats"]["enemyName"] = {}
    self.current["stats"]["enemyRace"] = {}
    self.current["stats"]["enemySpec"] = {}

    local playerTeamTable = goldTeam
    local enemyTeamTable = greenTeam
    if (playerTeam == 'GREEN') then
        playerTeamTable = greenTeam
        enemyTeamTable = goldTeam
    end

    -- playerName, killingBlows, honorKills, deaths, honorGained, faction, rank, race, class, classToken, damageDone, healingDone
    for i = 1, #playerTeamTable do
        local row = playerTeamTable[i]
        local raceUpper

        if not row[8] then
            raceUpper = ''
        else
            local race = LibRaces:GetRaceToken(row[8])
            if race == nil then
                raceUpper = ''
            else
                raceUpper = race:upper()
            end
        end

        self.current["stats"]["teamClass"][i - 1] = row[10]:upper()
        self.current["stats"]["teamCharName"][i - 1] = row[1]
        self.current["stats"]["teamRace"][i - 1] = raceUpper
        self.current["stats"]["teamSpec"][i - 1] = self:GetSpecOrDefault(row[1])
    end

    for i = 1, #enemyTeamTable do
        local row = enemyTeamTable[i]
        local raceUpper

        if not row[8] then
            raceUpper = ''
        else
            local race = LibRaces:GetRaceToken(row[8])
            if race == nil then
                raceUpper = ''
            else
                raceUpper = race:upper()
            end
        end

        self.current["stats"]["enemyClass"][i - 1] = row[10]:upper()
        self.current["stats"]["enemyName"][i - 1] = row[1]
        self.current["stats"]["enemyRace"][i - 1] = raceUpper
        self.current["stats"]["enemyFaction"] = self:RaceToFaction(raceUpper)
        self.current["stats"]["enemySpec"][i - 1] = self:GetSpecOrDefault(row[1])
    end
end

function ArenaStats:RaceToFaction(race)
    if race == "HUMAN" then
        return 1
    elseif race == "GNOME" then
        return 1
    elseif race == "NIGHTELF" then
        return 1
    elseif race == "DRAENEI" then
        return 1
    elseif race == "DWARF" then
        return 1
    elseif race == "WORGEN" then
        return 1
    else
        return 0
    end
end

function ArenaStats:UPDATE_BATTLEFIELD_SCORE()
    local battlefieldWinner = GetBattlefieldWinner()
    if battlefieldWinner == nil or self.arenaEnded then return end

    if self.current.status ~= 'none' then
        self.current["stats"]["zoneId"] = select(8, GetInstanceInfo())
        self.current["stats"]["endTime"] = _G.time()
        self.arenaEnded = true
        if (battlefieldWinner == 0) then
            self.current["stats"]["winnerColor"] = "GREEN";
        elseif (battlefieldWinner == 1) then
            self.current["stats"]["winnerColor"] = "GOLD";
        end
        self:SetLastArenaRankingData()
        if GetNumBattlefieldScores() ~= 0 then self:RecordArena() end
    end
end

function ArenaStats:Reset()
    self.current["status"] = "none"

    self.current["stats"] = {}
    self.current["units"] = {}
    self.specTable = {}
end

function ArenaStats:RecordArena()
    self:AddEntryToHistory(self.current["stats"])
    self:Print("Arena recorded")
    self:Reset()
end

function ArenaStats:AddEntryToHistory(stats)
    table.insert(self.db.char.history, stats)
    if self.db.profile.maxHistory > 0 then
        while (#self.db.char.history > self.db.profile.maxHistory) do
            table.remove(self.db.char.history, 1)
        end
    end
end

function ArenaStats:DrawMinimapIcon()
    libDBIcon:Register(addonName,
        _G.LibStub("LibDataBroker-1.1"):NewDataObject(addonName,
            {
                type = "data source",
                text = addonName,
                icon = "interface/icons/achievement_arena_2v2_7",
                OnClick = function(self, button)
                    if button == "RightButton" then
                        _G.InterfaceOptionsFrame_OpenToCategory(addonName)
                        _G.InterfaceOptionsFrame_OpenToCategory(addonName)
                    else
                        ArenaStats:Toggle()
                    end
                end,
                OnTooltipShow = function(tooltip)
                    tooltip:AddLine(string.format("%s |cff777777v%s|r", addonTitle,
                        "0.2.5"))
                    tooltip:AddLine(string.format("|cFFCFCFCF%s|r %s", L["Left Click"],
                        L["to open the main window"]))
                    tooltip:AddLine(string.format("|cFFCFCFCF%s|r %s", L["Right Click"],
                        L["to open options"]))
                    tooltip:AddLine(string.format("|cFFCFCFCF%s|r %s", L["Drag"],
                        L["to move this button"]))
                end
            }), self.db.profile.minimapButton)
end

function ArenaStats:ToggleMinimapButton()
    self.db.profile.minimapButton.hide = not self.db.profile.minimapButton.hide
    if self.db.profile.minimapButton.hide then
        libDBIcon:Hide(addonName)
    else
        libDBIcon:Show(addonName)
    end
end

function ArenaStats:CalculateTeamSize(row)
    if (row["teamSize"] ~= nil or row["teamClass"] == nil) then
        return row["teamSize"]
    end

    local teamSize = 0
    for i = 0, 5 do
        if row["teamClass"][i] ~= nil then teamSize = teamSize + 1 end
    end
    return teamSize
end

function ArenaStats:BuildTable()
    local tbl = {}

    local tableLength = #self.db.char.history

    for i = 1, tableLength do
        local row = self.db.char.history[tableLength + 1 - i]
        table.insert(tbl, {

            -- Common stats

            ["startTime"] = row["startTime"],
            ["endTime"] = row["endTime"],
            ["zoneId"] = ArenaStats:RemapZoneId(row["zoneId"]),
            ["isRanked"] = row["isRanked"],
            ["teamSize"] = ArenaStats:CalculateTeamSize(row),
            ["duration"] = (row["endTime"] and row["startTime"] and
                (row["endTime"] - row["startTime"]) or 0),

            -- Player's team

            ["teamName"] = row["teamName"],

            ["teamPlayerClass1"] = row["teamClass"] and row["teamClass"][0] or
                nil,
            ["teamPlayerClass2"] = row["teamClass"] and row["teamClass"][1] or
                nil,
            ["teamPlayerClass3"] = row["teamClass"] and row["teamClass"][2] or
                nil,
            ["teamPlayerClass4"] = row["teamClass"] and row["teamClass"][3] or
                nil,
            ["teamPlayerClass5"] = row["teamClass"] and row["teamClass"][4] or
                nil,
            ["teamPlayerName1"] = row["teamCharName"] and row["teamCharName"][0] or
                nil,
            ["teamPlayerName2"] = row["teamCharName"] and row["teamCharName"][1] or
                nil,
            ["teamPlayerName3"] = row["teamCharName"] and row["teamCharName"][2] or
                nil,
            ["teamPlayerName4"] = row["teamCharName"] and row["teamCharName"][3] or
                nil,
            ["teamPlayerName5"] = row["teamCharName"] and row["teamCharName"][4] or
                nil,
            ["teamPlayerRace1"] = row["teamRace"] and row["teamRace"][0] or nil,
            ["teamPlayerRace2"] = row["teamRace"] and row["teamRace"][1] or nil,
            ["teamPlayerRace3"] = row["teamRace"] and row["teamRace"][2] or nil,
            ["teamPlayerRace4"] = row["teamRace"] and row["teamRace"][3] or nil,
            ["teamPlayerRace5"] = row["teamRace"] and row["teamRace"][4] or nil,
            ["teamPlayerSpec1"] = row["teamSpec"] and row["teamSpec"][0] or nil,
            ["teamPlayerSpec2"] = row["teamSpec"] and row["teamSpec"][1] or nil,
            ["teamPlayerSpec3"] = row["teamSpec"] and row["teamSpec"][2] or nil,
            ["teamPlayerSpec4"] = row["teamSpec"] and row["teamSpec"][3] or nil,
            ["teamPlayerSpec5"] = row["teamSpec"] and row["teamSpec"][4] or nil,

            ["oldTeamRating"] = row["oldTeamRating"],
            ["newTeamRating"] = row["newTeamRating"],
            ["diffRating"] = row["diffRating"],
            ["mmr"] = row["mmr"],
            ["teamColor"] = row["teamColor"],
            ["winnerColor"] = row["winnerColor"],

            -- Enemy team

            ["enemyTeamName"] = row["enemyTeamName"],

            ["enemyPlayerClass1"] = row["enemyClass"] and row["enemyClass"][0] or
                nil,
            ["enemyPlayerClass2"] = row["enemyClass"] and row["enemyClass"][1] or
                nil,
            ["enemyPlayerClass3"] = row["enemyClass"] and row["enemyClass"][2] or
                nil,
            ["enemyPlayerClass4"] = row["enemyClass"] and row["enemyClass"][3] or
                nil,
            ["enemyPlayerClass5"] = row["enemyClass"] and row["enemyClass"][4] or
                nil,
            ["enemyPlayerName1"] = row["enemyName"] and row["enemyName"][0] or
                nil,
            ["enemyPlayerName2"] = row["enemyName"] and row["enemyName"][1] or
                nil,
            ["enemyPlayerName3"] = row["enemyName"] and row["enemyName"][2] or
                nil,
            ["enemyPlayerName4"] = row["enemyName"] and row["enemyName"][3] or
                nil,
            ["enemyPlayerName5"] = row["enemyName"] and row["enemyName"][4] or
                nil,
            ["enemyPlayerRace1"] = row["enemyRace"] and row["enemyRace"][0] or
                nil,
            ["enemyPlayerRace2"] = row["enemyRace"] and row["enemyRace"][1] or
                nil,
            ["enemyPlayerRace3"] = row["enemyRace"] and row["enemyRace"][2] or
                nil,
            ["enemyPlayerRace4"] = row["enemyRace"] and row["enemyRace"][3] or
                nil,
            ["enemyPlayerRace5"] = row["enemyRace"] and row["enemyRace"][4] or
                nil,
            ["enemyPlayerSpec1"] = row["enemySpec"] and row["enemySpec"][0] or nil,
            ["enemyPlayerSpec2"] = row["enemySpec"] and row["enemySpec"][1] or nil,
            ["enemyPlayerSpec3"] = row["enemySpec"] and row["enemySpec"][2] or nil,
            ["enemyPlayerSpec4"] = row["enemySpec"] and row["enemySpec"][3] or nil,
            ["enemyPlayerSpec5"] = row["enemySpec"] and row["enemySpec"][4] or nil,
            ["enemyFaction"] = row["enemyFaction"],

            ["enemyOldTeamRating"] = row["enemyOldTeamRating"],
            ["enemyNewTeamRating"] = row["enemyNewTeamRating"],
            ["enemyDiffRating"] = row["enemyDiffRating"],
            ["enemyMmr"] = row["enemyMmr"]

        })
    end
    return tbl
end

function ArenaStats:RemapZoneId(mapAreaId)
    -- remap old mapAreaId to instanceids (for backward compatibility)
    if mapAreaId == 3698 then
        return 559
    elseif mapAreaId == 3702 then
        return 562
    elseif mapAreaId == 3968 then
        return 572
    end
    return mapAreaId
end

function ArenaStats:ResetDatabase()
    self.db:ResetDB()
    self:Print(L["Database reset"])
end

function ArenaStats:ExportCSV()
    local csv =
        "isRanked,startTime,endTime,zoneId,duration,teamName,teamColor,winnerColor," ..
        "teamPlayerName1,teamPlayerName2,teamPlayerName3,teamPlayerName4,teamPlayerName5," ..
        "teamPlayerClass1,teamPlayerClass2,teamPlayerClass3,teamPlayerClass4,teamPlayerClass5," ..
        "teamPlayerRace1,teamPlayerRace2,teamPlayerRace3,teamPlayerRace4,teamPlayerRace5," ..
        "oldTeamRating,newTeamRating,diffRating,mmr," ..
        "enemyOldTeamRating,enemyNewTeamRating,enemyDiffRating,enemyMmr,enemyTeamName," ..
        "enemyPlayerName1,enemyPlayerName2,enemyPlayerName3,enemyPlayerName4,enemyPlayerName5," ..
        "enemyPlayerClass1,enemyPlayerClass2,enemyPlayerClass3,enemyPlayerClass4,enemyPlayerClass5," ..
        "enemyPlayerRace1,enemyPlayerRace2,enemyPlayerRace3,enemyPlayerRace4,enemyPlayerRace5,enemyFaction,"..
        "enemySpec1,enemySpec2,enemySpec3,enemySpec4,enemySpec5," ..
        "teamSpec1,teamSpec2,teamSpec3,teamSpec4,teamSpec5,"..
        "\n"

    for _, row in ipairs(self.db.char.history) do
        csv = csv .. (self:YesOrNo(row["isRanked"])) .. "," ..
            (row["startTime"] ~= nil and row["startTime"] or "") .. "," ..
            (row["endTime"] ~= nil and row["endTime"] or "") .. "," ..
            (row["zoneId"] ~= nil and row["zoneId"] or "") .. "," ..
            (row["startTime"] ~= nil and row["endTime"] ~= nil and
                row["endTime"] - row["startTime"] or "") .. "," ..
            (row["teamName"] ~= nil and row["teamName"] or "") .. "," ..
            (row["teamColor"] ~= nil and row["teamColor"] or "") .. "," ..
            (row["winnerColor"] ~= nil and row["winnerColor"] or "") ..
            "," ..

            (row["teamCharName"] and row["teamCharName"][0] ~= nil and
                row["teamCharName"][0] or "") .. "," ..
            (row["teamCharName"] and row["teamCharName"][1] ~= nil and
                row["teamCharName"][1] or "") .. "," ..
            (row["teamCharName"] and row["teamCharName"][2] ~= nil and
                row["teamCharName"][2] or "") .. "," ..
            (row["teamCharName"] and row["teamCharName"][3] ~= nil and
                row["teamCharName"][3] or "") .. "," ..
            (row["teamCharName"] and row["teamCharName"][4] ~= nil and
                row["teamCharName"][4] or "") .. "," ..
            (row["teamClass"] and row["teamClass"][0] ~= nil and
                row["teamClass"][0] or "") .. "," ..
            (row["teamClass"] and row["teamClass"][1] ~= nil and
                row["teamClass"][1] or "") .. "," ..
            (row["teamClass"] and row["teamClass"][2] ~= nil and
                row["teamClass"][2] or "") .. "," ..
            (row["teamClass"] and row["teamClass"][3] ~= nil and
                row["teamClass"][3] or "") .. "," ..
            (row["teamClass"] and row["teamClass"][4] ~= nil and
                row["teamClass"][4] or "") .. "," ..
            (row["teamRace"] and row["teamRace"][0] ~= nil and
                row["teamRace"][0] or "") .. "," ..
            (row["teamRace"] and row["teamRace"][1] ~= nil and
                row["teamRace"][1] or "") .. "," ..
            (row["teamRace"] and row["teamRace"][2] ~= nil and
                row["teamRace"][2] or "") .. "," ..
            (row["teamRace"] and row["teamRace"][3] ~= nil and
                row["teamRace"][3] or "") .. "," ..
            (row["teamRace"] and row["teamRace"][4] ~= nil and
                row["teamRace"][4] or "") .. "," ..

            (self:ComputeSafeNumber(row["oldTeamRating"])) .. "," ..
            (self:ComputeSafeNumber(row["newTeamRating"])) .. "," ..
            (self:ComputeSafeNumber(row["diffRating"])) .. "," ..
            (self:ComputeSafeNumber(row["mmr"])) .. "," ..

            (self:ComputeSafeNumber(row["enemyOldTeamRating"])) .. "," ..
            (self:ComputeSafeNumber(row["enemyNewTeamRating"])) .. "," ..
            (self:ComputeSafeNumber(row["enemyDiffRating"])) .. "," ..
            (self:ComputeSafeNumber(row["enemyMmr"])) .. "," ..
            (row["enemyTeamName"] ~= nil and row["enemyTeamName"] or "") ..
            "," ..

            (row["enemyName"] and row["enemyName"][0] ~= nil and
                row["enemyName"][0] or "") .. "," ..
            (row["enemyName"] and row["enemyName"][1] ~= nil and
                row["enemyName"][1] or "") .. "," ..
            (row["enemyName"] and row["enemyName"][2] ~= nil and
                row["enemyName"][2] or "") .. "," ..
            (row["enemyName"] and row["enemyName"][3] ~= nil and
                row["enemyName"][3] or "") .. "," ..
            (row["enemyName"] and row["enemyName"][4] ~= nil and
                row["enemyName"][4] or "") .. "," ..
            (row["enemyClass"] and row["enemyClass"][0] ~= nil and
                row["enemyClass"][0] or "") .. "," ..
            (row["enemyClass"] and row["enemyClass"][1] ~= nil and
                row["enemyClass"][1] or "") .. "," ..
            (row["enemyClass"] and row["enemyClass"][2] ~= nil and
                row["enemyClass"][2] or "") .. "," ..
            (row["enemyClass"] and row["enemyClass"][3] ~= nil and
                row["enemyClass"][3] or "") .. "," ..
            (row["enemyClass"] and row["enemyClass"][4] ~= nil and
                row["enemyClass"][4] or "") .. "," ..
            (row["enemyRace"] and row["enemyRace"][0] ~= nil and
                row["enemyRace"][0] or "") .. "," ..
            (row["enemyRace"] and row["enemyRace"][1] ~= nil and
                row["enemyRace"][1] or "") .. "," ..
            (row["enemyRace"] and row["enemyRace"][2] ~= nil and
                row["enemyRace"][2] or "") .. "," ..
            (row["enemyRace"] and row["enemyRace"][3] ~= nil and
                row["enemyRace"][3] or "") .. "," ..
            (row["enemyRace"] and row["enemyRace"][4] ~= nil and
                row["enemyRace"][4] or "") .. "," ..
            (self:ComputeFaction(row["enemyFaction"])) .. "," ..
            (row["teamSpec"] and row["teamSpec"][0] ~= nil and
                row["teamSpec"][0] or "") .. "," ..
            (row["teamSpec"] and row["teamSpec"][1] ~= nil and
                row["teamSpec"][1] or "") .. "," ..
            (row["teamSpec"] and row["teamSpec"][2] ~= nil and
                row["teamSpec"][2] or "") .. "," ..
            (row["teamSpec"] and row["teamSpec"][3] ~= nil and
                row["teamSpec"][3] or "") .. "," ..
            (row["teamSpec"] and row["teamSpec"][4] ~= nil and
                row["teamSpec"][4] or "") .. "," ..
            (row["enemySpec"] and row["enemySpec"][0] ~= nil and
                row["enemySpec"][0] or "") .. "," ..
            (row["enemySpec"] and row["enemySpec"][1] ~= nil and
                row["enemySpec"][1] or "") .. "," ..
            (row["enemySpec"] and row["enemySpec"][2] ~= nil and
                row["enemySpec"][2] or "") .. "," ..
            (row["enemySpec"] and row["enemySpec"][3] ~= nil and
                row["enemySpec"][3] or "") .. "," ..
            (row["enemySpec"] and row["enemySpec"][4] ~= nil and
                row["enemySpec"][4] or "") .. "," .. "\n"
    end
    ArenaStats:ExportFrame().eb:SetText(csv)
    ArenaStats:ExportFrame():SetTitle(L["Export"])
    ArenaStats:ExportFrame().eb:SetNumLines(29)
    ArenaStats:ExportFrame().eb:SetLabel(
        "Export String " .. " (" .. string.len(csv) .. ") ")
    ArenaStats:ExportFrame():Show()
    ArenaStats:ExportFrame().eb:SetFocus()
    ArenaStats:ExportFrame().eb:HighlightText()
end

function ArenaStats:WebsiteURL()
    ArenaStats:ExportFrame():SetTitle(L["Tool"])
    ArenaStats:ExportFrame().eb:SetLabel("Tool Website URL")
    ArenaStats:ExportFrame().eb:SetNumLines(1)
    ArenaStats:ExportFrame().eb:SetText(
        "https://denishamann.github.io/arena-stats-visualizer/")
    ArenaStats:ExportFrame():Show()
    ArenaStats:ExportFrame().eb:SetFocus()
    ArenaStats:ExportFrame().eb:HighlightText()
end

function ArenaStats:ComputeFaction(factionId)
    if factionId == 1 then
        return "ALLIANCE"
    elseif factionId == 0 then
        return "HORDE"
    end
    return ""
end

function ArenaStats:YesOrNo(bool)
    if bool then
        return "YES"
    elseif not bool then
        return "NO"
    end
    return ""
end

function ArenaStats:ComputeSafeNumber(number)
    if number == nil then
        return ""
    elseif number == 0 then
        return "0"
    end
    return number
end

function ArenaStats:ShouldHideCharacterNamesTooltips()
    return not self.db.profile.characterNamesOnHover.hide
end