Advertisement
Guest User

Untitled

a guest
Aug 22nd, 2019
87
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.99 KB | None | 0 0
  1. local mysql = dbConnect(bd, bdstr, bdname, bdpass)
  2.  
  3. function getJSONMassiveForPlayer( gh, player )
  4. if(gh ~= nil) then
  5. local result = dbPoll(gh, 0)
  6. if(result ~= false) then
  7. if(result[1] ~= false) then
  8. if(result[1]["Inv"] ~= false) then
  9. if(isElement(player)) then
  10. local data = fromJSON(result[1]["Inv"])
  11. for i,n in pairs(data) do
  12. setElementData(player, i, n)
  13. end
  14. end
  15. end
  16. end
  17. end
  18. end
  19. end
  20.  
  21. function onPlayerJoin( )
  22. local argTable = { source }
  23. local query = dbQuery(getJSONMassiveForPlayer, argTable, mysql, "SELECT (`Inv`, `Serial`) FROM `Accounts` WHERE `Serial` = ?", getPlayerSerial(source))
  24. end
  25.  
  26.  
  27. function onPlayerQuit( reason )
  28. local data = getAllElementData(source)
  29. local JSONString = toJSON(data)
  30. dbExec(mysql, "UPDATE `Accounts` SET `Inv` = ? WHERE `Serial` = ?", JSONString, getPlayerSerial(source))
  31. end
  32.  
  33. addEventHandler("onPlayerQuit", root, onPlayerQuit)
  34. addEventHandler("onPlayerJoin", root, onPlayerJoin)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement