Advertisement
Guest User

Untitled

a guest
Jul 3rd, 2018
100
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.11 KB | None | 0 0
  1. local playerSerial = getPlayerSerial(source)
  2. if username and password then
  3. dbQuery(function(queryHandler, source, username, password)
  4. local result, rows = dbPoll(queryHandler, -1)
  5. for _, data in ipairs(result) do
  6. if data["Username"] == username and data["Password"] == password then
  7. if tonumber(data["Online"]) == (0) then
  8. if data["Serial"] == playerSerial then
  9.  
  10. dbExec(mysql:getConnection(), "UPDATE accounts SET Online = '1' WHERE Username = ?", username)
  11. else
  12. outputChatBox("A kiválasztott account nem a te serialodhoz van társítva!", source)
  13. return
  14. end
  15. end
  16. else
  17. outputChatBox("A kiválasztott account nem található.", source)
  18. end
  19. end
  20. end, {source, username, password}, mysql:getConnection(), "SELECT * FROM accounts WHERE Username=? AND Password=?", username, password)
  21. else
  22. outputChatBox("Nem adtad meg a felhasználónevet vagy a jelszót!", source)
  23. end
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement