accountS.lua

-- \\ writed by Jack // --
--Regisztráció
--Bejelentkezés
--Karakter létrehozás random név táblából
--Adatok mentése
--Ellenőrizni hogy a játékosnak van -e accountja, ha van akkor a login-t tesszük elé


local con = exports.le_mysql:getConnection()
local player = source;

addEvent("checkAccount", true)
addEventHandler("checkAccount", root,
    function()
        local serial = _serial
        local serial = dbExec(con, "INSERT INTO accounts SET serial=?", serial);
        local _serial = row["serial"];
        if (_serial ~= nil) then
            triggerClientEvent(client, "showLogin", client)
        else
            triggerClientEvent(client, "showRegister", client)
        end
    end
)

addEvent("acc:Register")
addEventHandler("acc:Register", root,
    function()
        local serial = getPlayerSerial(source);
        local qh = dbQuery(con, "SELECT * FROM accounts WHERE serial=?",serial);
        local res = dbPoll(qh, 0);
        triggerClientEvent(source, "sendDatas:server", source, _username, _password, _passwordconfirm, _email)
        setTimer(function()
            if (#res > 0) then
                if (serial == nil) then
                    if (_username ~= nil) and (_password ~= nil) and (_passwordconfirm ~= nil) and (_email ~= nil) then
                        dbExec(con, "INSERT INTO accounts SET username = ?, password = ?, email = ?, serial = ?", _username, _password, _email, serial);
                    end
                end
            end
        end, 1000, 1)
    end
)

addEvent("acc:Login")
addEventHandler("acc:Login", root,
    function()


    end
)

function player_Spawn()
    triggerClientEvent(source, "cancelMoveCamera", source)
    spawnPlayer(source, 0, 0, 3)
end
addEventHandler("onPlayerLogin", getRootElement(), player_Spawn)