Converting ranks

function convertRanksToNewTable()
    local db = exports.mysql:getConn("mta")
    local query = dbQuery(db, "SELECT `id`, `rank_1`, `rank_2`, `rank_3`, `rank_4`, `rank_5`, `rank_6`, `rank_7`, `rank_8`, `rank_9`, `rank_10`, `rank_11`, `rank_12`, `rank_13`, `rank_14`, `rank_15`, `rank_16`, `rank_17`, `rank_18`, `rank_19`, `rank_20`, `wage_1`, `wage_2`, `wage_3`, `wage_4`, `wage_5`, `wage_6`, `wage_7`, `wage_8`, `wage_9`, `wage_10`, `wage_11`, `wage_12`, `wage_13`, `wage_14`, `wage_15`, `wage_16`, `wage_17`, `wage_18`, `wage_19`, `wage_20` FROM `factions`")
    local rankcount = 0
    if query then
        outputChatBox("Query gevonden", root)

        local pollResult = dbPoll(query, 0)
        if not pollResult then
            outputChatBox("No Result", root)
            dbFree(query)
            return
        else
            outputChatBox("Result", root)
            for i, row in pairs(pollResult) do
                if row.id ~= 1 then
                    for i=1,20 do
                        maxFactionRank = maxFactionRank + 1
                        local rankID = tonumber(maxFactionRank)
                        if not (row['rank_'..i] == "") then -- Making sure we are not converting unused ranks
                            if i == 1 then
                                dbExec(db,"INSERT INTO `faction_ranks` (`id`, `faction_id`, `name`, `permissions`, `isDefault`,`wage`) VALUES (?,?,?,?,?,?)", rankID, row.id, row['rank_'..i],"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16",1,row['wage_'..i])
                            else
                                dbExec(db,"INSERT INTO `faction_ranks` (`id`, `faction_id`, `name`, `permissions`, `isDefault`,`wage`) VALUES (?,?,?,?,?,?)", rankID, row.id, row['rank_'..i],"",0,row['wage_'..i])
                            end
                        end
                        rankcount = rankcount + 1
                    end
                end
            end
        end
    end
    outputChatBox("Converted "..rankcount.." ranks.", root)
    dbFree(query)
end
addCommandHandler("convertranks", convertRanksToNewTable)

function swapRanks()
    local db = exports.mysql:getConn("mta")
    local query = dbQuery(db, "SELECT `id`, `faction_id` FROM `characters`")
    if query then
        outputChatBox("Query gevonden", root)

        local pollResult = dbPoll(query, -1)
        if not pollResult then
            outputChatBox("No Result", root)
            dbFree(query)
            return
        else
            outputChatBox("Result", root)
            for i, row in pairs(pollResult) do
                if row.id ~= -1 then
                    local factionID = tonumber(row['faction_id'])
                    local defaultRank = tonumber(getDefaultRank(factionID))
                    dbExec(db, "UPDATE `characters` SET `faction_rank` = ? WHERE `id` = ?", defaultRank, row.id)
                end
            end
        end
    end
    outputChatBox("Swapped "..rankcount.." ranks.", root)
    dbFree(query)
end
addCommandHandler("swapranks", swapRanks)