Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- host = "localhost" // Host bazy danych
- username = "root" // Nazwa użytkownika bazy danych
- password = "admin" // Hasło użytkownika bazy danych
- database = "asd" // Nazwa bazy danych
- local SQL = mysql_connect(host, username, password, database)
- function onLogin(a, account)
- local query = SQL:query("SELECT * FROM mta WHERE user = '" .. getAccountName(account) .. "'")
- if query:num_rows() > 0 then
- local row = mysql_fetch_assoc(query)
- setPlayerMoney(source, tonumber(row.money))
- outptDebugString("* Gracz z nazwa konta " .. getAccountName(account) .. " ma " .. tostring(row.money) .. "pieniedzy")
- else
- outptDebugString("* Gracz z nazwa konta " .. getAccountName(account) .. " nie ma zapisanych pieniedzy")
- end
- end
- function onQuit()
- local money = getPlayerMoney(source)
- local name = getAccountName(getPlayerAccount(source))
- local query = SQL:query("SELECT * FROM mta WHERE user = '" .. name .. "'")
- if query:num_rows() > 0 then
- SQL:query("UPDATE mta SET money = " .. tostring(money) .. " WHERE user = '" .. name .. "'")
- else
- SQL:query("INSERT INTO mta VALUES(null, " .. name .. ", " .. tostring(money) .. ")")
- end
- end
- addEventHandler("onPlayerLogin", getRootElement(), onLogin)
- addEventHandler("onPlayerQuit", getRootElement(), onQuit)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement