Daten aus MySQL auslesen

function getPDCrime(Player)
    local crimes = {}
    if isElement(Player) then
        local pdcrimeresult = mysql_query(handler, "SELECT * FROM userdata_pd WHERE name LIKE '"..getPlayerName(Player).."'")
        if pdcrimeresult then
            pdcrimesatz = mysql_fetch_assoc(pdcrimeresult)
            while pdcrimesatz do
                crimes[pdcrimesatz['id']] = {
                    name = pdcrimesatz['name'],
                    crime = pdcrimesatz['crime'],
                    wanteds = pdcrimesatz['wanteds']
                }
            end
            return crimes;
        end
        mysql_free_result(pdcrimeresult)
    end
end


function getPlayerCrimeStory_func(player, command, player2)
    if player2 then
        local eplayer2 = getPlayerFromName(player2)
        if isElement(eplayer2) then
            local p2name = getPlayerName(eplayer2)
            local crimes = getPDCrime(eplayer2)
            outputChatBox(p2name .. ":")
            while crimes do
                outputChatBox(crimes['crime'] .. " - " .. crimes['wanteds'] .. " Wanteds",player,150,150,0)
            end
        else
            outputChatBox("Falscher Spieler")
        end
    else
        outputChatBox("Falscher Spieler")
    end
end
addCommandHandler("testpd",getPlayerCrimeStory_func)