bMUipws5

1local db = dbConnect("sqlite", "db_royal/users.db")
2 
3local newTable = dbExec(db, "CREATE TABLE IF NOT EXISTS RoyalUsers (id INT, name TEXT, login TEXT, pass TEXT, serial TEXT)")
4
5function registerPlayer(user, pass, conf)
6    if user == "" then
7        outputLoginMsg(source, "Preencha todos os campos!", "error") 
8    else 
9        if pass == "" then
10            outputLoginMsg(source, "Preencha todos os campos!", "error") 
11        else
12            if conf == "" then
13                outputLoginMsg(source, "Preencha todos os campos!", "error") 
14            else
15                if conf == pass then
16                    addAccount(tostring(user),tostring(pass))
17                    triggerClientEvent(source, "onRoyalRegister", source)
18                    local serial = getPlayerSerial(source)
19                    local query = dbPoll(dbQuery(db, "SELECT * FROM RoyalUsers WHERE login=?", user),-1)
20                    if #query == 0 then
21                        dbExec(db, "INSERT INTO RoyalUsers VALUES (?, ?, ?, ?, ?)", countIDs(), getPlayerName(source), user, pass, serial)      
22                    end
23                    outputLoginMsg(source, "Conta criada com sucesso! Aguarde...", "success")
24                    if not getAccount(user, pass) then
25                        outputLoginMsg(source, "Esta conta já está sendo utilizada!", "error")
26                    end
27                else
28                    outputLoginMsg(source, "As senhas não estão iguais.", "error")
29                end
30            end 
31        end
32    end
33end
34addEvent("onPlayerRequestRegister",true)
35addEventHandler("onPlayerRequestRegister", root, registerPlayer)
36
37function countIDs()
38    local table = dbPoll(dbQuery(db, "SELECT * FROM RoyalUsers"), -1)
39    local count = 1
40    for i, result in pairs(table) do
41        count = count + 1
42    end
43    return count
44end