cs8Ps3U6

1local db = dbConnect("sqlite", "db/royaldb.db")
2 
3local newTable = dbExec(db, "CREATE TABLE IF NOT EXISTS Jogadores (nome TEXT, login TEXT, serial TEXT, id TEXT)")
4 
5addEventHandler("onPlayerLogin", root,
6    function()
7		local serial = getPlayerSerial(source)
8        local query = dbPoll(dbQuery(db, "SELECT * FROM Jogadores WHERE serial=?", serial),-1)
9        if #query == 0 then
10            dbExec(db, "INSERT INTO Jogadores VALUES (?,?,?,?), getPlayerName(source), getAccountName(getPlayerAccount(source)), serial, getElementData(source,"ID"))      
11        end
12    end
13)