· 7 years ago · Nov 25, 2018, 12:54 AM
1local db = dbConnect("sqlite", "db/royaldb.db")
2
3local newTable = dbQuery(db, "CREATE TABLE IF NOT EXISTS Jogadores (nome TEXT, login TEXT, serial TEXT, id TEXT)")
4
5function insetOnLogin()
6 for i, player in ipairs(getElementsByType("player")) do
7 dbQuery("INSERT INTO Jogadores (nome, login, serial, id) VALUES (?, ?, ?, ?)", getPlayerName(player), getPlayerAccount(player), getPlayerSerial(player), getElementData(player, "ID"))
8 end
9end
10addEventHandler("onPlayerLogin", root, insetOnLogin)