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 i == 1 then
                            dbExec(db,"INSERT INTO `faction_ranks` (`id`, `faction_id`, `name`, `permissions`, `isDefault`,`wage`) VALUES (?,?,?,?,?,?)", rankID, row.id, row['rank_'..i],"",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
                        rankcount = rankcount + 1
                    end
                end
            end
        end
    end
    outputChatBox("Converted "..rankcount.." ranks.", root)
    dbFree(query)
end
addCommandHandler("convertranks", convertRanksToNewTable)