ENIGMA

local sql = dbConnect("mysql", "dbname=mta;hostname=localhost", "root", "", 3306)

function join(player, felhNev, passW)
    setCameraMatrix(source, 1468.8785400391, -919.25317382813, 100.153465271, 1468.388671875, -918.42474365234, 99.881813049316)
    fadeCamera(source, true, 3.5)
end
addEventHandler("onPlayerJoin", getRootElement(), join)

addEvent("registerEvent", true)
addEventHandler("registerEvent", getRootElement(),
    function(player, felhNev, passW, ID)
        if #felhNev < 6 then outputChatBox("#A52A2ANe 6 karakter legyen a nevedben!", player, true) return end
        if #passW < 8 then outputChatBox("#A52A2ANe 8 karakter legyen a jelszavadban!", player, true) return end
        if getElementData(player, "LoggedIn") == 0 or getElementData(player, "LoggedIn") == nil then
            outputChatBox("Nem vagy bejelentkezve.",player, true)
        end


        local qh = dbQuery(sql, "SELECT * FROM `accounts`")
        local result = dbPoll ( qh, -1 )
        dbFree(qh)
        for i, accountInfo in ipairs(result) do
            if accountInfo["username"] == felhNev then
                outputChatBox("Már van ilyen karakter az adatbázisomban!", player, 152, 0, 0, true)
            return
            else
                outputChatBox("#00F6FFSikeresen regisztráltad A ".. felhNev .. " Nevű karaktered!", player, 152, 0, 0, true)
            end
        end

        local sqlInster = dbExec( sql, "INSERT INTO accounts SET username = ?, password = ?, id = ?", felhNev, passW, ID)
        if sqlInster then
            showCursor(player, false)
            triggerClientEvent(player, "loginEltuntetes", getRootElement())
            triggerClientEvent(player, "karakterKeszites", getRootElement())
        else
            outputChatBox("Retek gyorsan keress fel egy admint.!", true)
            return
        end
    end
)

addEvent("loginEvent", true)
addEventHandler("loginEvent", root,
    function(player, felhNev, passW, ID)
        dbQuery(function(qh, player)
        query = dbQuery(sql, "SELECT * FROM accounts WHERE id = ?", ID)
        local result, rows, errorMsg = dbPoll(qh, 0)
        fadeCamera ( player, true, 1.0, 255, 0, 0 )
        if rows > 0 then
            for k, v in pairs(result) do
                if v["username"] ~= felhNev or v["password"] ~= passW then
                    outputChatBox("#A52A2Hibás jelszó avagy felhasználónév!", player, 255, 255, 255, true)
                else
                    outputChatBox("Üdvözöllek kedves ".. felhNev.. " A szerveren!", player, 152, 0, 0, true)
                    showCursor(player, false)
                    setCameraTarget(player, player)
                    spawnPlayer(player, 0, 0, 3)
                    triggerClientEvent(player, "loginEltuntetes", getRootElement())
                end
            end
        else
            outputChatBox("Nincs ilyen felhasználónévvel ellátott account!", player)
        end
    end, {player}, sql, "SELECT * FROM accounts WHERE username = ? AND password = ? LIMIT 1", felhNev, passW)
end)

function jatekosmentes( kilepestipus )
    if getElementData(source, "LoggedIn") == 1 then
        local x,y,z = getElementPosition( source )
        local rx,ry,rz = getElementRotation ( source )
        local playerHealth = getElementHealth ( source )
        local playerArmor = getPedArmor ( source )
        local mentes = dbQuery(sql,"UPDATE accounts SET X='"..x.."', Y='"..y.."', Z='"..z.."', R='"..rz.."', HP='"..playerHealth.."'BankMoney='"..getElementData(source,"char:bankmoney").."', Money='"..getElementData(source,"char:money").."', Armor='"..playerArmor.."")
        for i = 0, 31 do
            local itemSave = dbQuery(sql,"UPDATE accounts SET item_"..i.."='"..getElementData(source,"item_"..i).."', item_"..i.."_db='"..getElementData(source,"item_"..i.."_db").."', item_"..i.."_info='"..getElementData(source,"item_"..i.."_info").."' WHERE Serial='"..getPlayerSerial ( source ).."'")
        end
    end
end
addEventHandler ( "onPlayerQuit", getRootElement(), jatekosmentes )

addEvent("karakterKeszites2", true)
addEventHandler("karakterKeszites2", getRootElement(),
    function(player, mtaUser, Email)
        dbQuery(function(qh, player)
        query = dbQuery(sql, "SELECT * FROM accounts")
            local result, rows, errorMsg = dbPoll(qh, 0)
            if rows > 0 then
                for k, v in ipairs(result) do
                    if v["mtausername"] ~= mtaUser then
                        outputChatBox("Ilyen karakter már van létrehozva!", player, true)
                    else
                        outputChatBox("Üdvözöllek a játékban "..mtaUser.."!!",player, true)
                        return
                    end
                end
            else
                outputChatBox("Beszoptad.",player, true)
            end
        end)


        local sqlInster = dbExec( sql, "INSERT INTO accounts SET mtausername = ?, email = ?", mtaUser, Email)
            if sqlInster then
                spawnPlayer(source, 0, 0, 3)
                setCameraTarget(source, source)
                triggerClientEvent(source, "loginEltuntetes", getRootElement())
                return
            end
        end
    end)
-- ITT A BIBI