Jak zapisac serial gracza w mysql?
[lua]
addEvent("tryLogin", true)
addEventHandler("tryLogin", resourceRoot, function(login,pass)
local q = dbQuery(db, "SELECT * FROM users WHERE login=? AND pass=?", login, md5(pass))
local w = dbPoll(q, -1)
if w and #w > 0 then
triggerClientEvent(client, "closePanel", resourceRoot)
setCameraTarget(client, client)
outputChatBox("* Witaj na NAZWA_TWOJEGO_SERWERA!", client) -- Podmieni? 'NAZWA_TWOJEGO_SERWERA' na nazw? Twojego serwera.
setPlayerName(client, w[1].login)
setPlayerMoney(client, w[1].money)
setElementModel(client, w[1].skin)
setElementData(client, "player:logged", true)
setElementData(client, "player:id", w[1].id)
else
outputChatBox("* B??dny nick i/lub has?o!", client)
end
end)
addEvent("tryRegister", true)
addEventHandler("tryRegister", resourceRoot, function(login,pass)
local q = dbQuery(db, "SELECT login FROM users WHERE login=?", login)
local w = dbPoll(q, -1)
if w and #w > 0 then
outputChatBox("* Istnieje ju? konto o podanym nicku!", client)
else
setPlayerMoney(root, 800)
outputChatBox("* Rejestrujesz si? pomy?lnie!", client)
spawnPlayer(client, 2846.6465,1290.6720,11.3906,90)
dbExec(db, "INSERT INTO users SET login=?, pass=?, money=800, skin=134, pozX=2850.7278, pozY=1290.4128, pozZ=11.3906", login, md5(pass))
e... |