· 7 years ago · Nov 25, 2018, 01:02 AM
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 query = dbPoll(dbQuery(db, "SELECT * FROM Jogadores WHERE serial=?", serial),-1)
8 if #query == 0 then
9 dbExec(db, "INSERT INTO Jogadores VALUES (?,?,?,?), getPlayerName(source), getAccountName(getPlayerAccount(source)), serial, getElementData(source,"ID"))
10 end
11 end
12)