Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- local mysql = dbConnect(bd, bdstr, bdname, bdpass)
- function getJSONMassiveForPlayer( gh, player )
- if(gh ~= nil) then
- local result = dbPoll(gh, 0)
- if(result ~= false) then
- if(result[1] ~= false) then
- if(result[1]["Inv"] ~= false) then
- if(isElement(player)) then
- local data = fromJSON(result[1]["Inv"])
- for i,n in pairs(data) do
- setElementData(player, i, n)
- end
- end
- end
- end
- end
- end
- end
- function onPlayerJoin( )
- local argTable = { source }
- local query = dbQuery(getJSONMassiveForPlayer, argTable, mysql, "SELECT (`Inv`, `Serial`) FROM `Accounts` WHERE `Serial` = ?", getPlayerSerial(source))
- end
- function onPlayerQuit( reason )
- local data = getAllElementData(source)
- local JSONString = toJSON(data)
- dbExec(mysql, "UPDATE `Accounts` SET `Inv` = ? WHERE `Serial` = ?", JSONString, getPlayerSerial(source))
- end
- addEventHandler("onPlayerQuit", root, onPlayerQuit)
- addEventHandler("onPlayerJoin", root, onPlayerJoin)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement