Help Please--Login mysql fix please
function asd()
local playerID = exports.server:playerID( source )
local weed = getElementData(source,"Weed")
local god = getElementData(source,"God")
local speed = getElementData(source,"Speed")
local lsd = getElementData(source,"Lsd")
local steroids = getElementData(source,"Steroids")
local heroin = getElementData(source,"Heroin")
local updateDatabase = exports.mysql:exec( "UPDATE drugs SET weed=?, god=?, speed=?, lsd=?, steroids=?, heroin=? WHERE id=?"
,weed
,god
,speed
,lsd
,steroids
,heroin
,playerID
)
end
addEventHandler ( "onPlayerQuit", root, asd )
addEventHandler ( "onPlayerWasted", root, asd )
addEventHandler ( "onPlayerLogout", root, asd )
function asd1()
local playerID = exports.server:playerID( source )
local weed = getAccountData(sourceAccount, "Weed")
local god = getElementData(source,"God")
local speed = getElementData(source,"Speed")
local lsd = getElementData(source,"Lsd")
local steroids = getElementData(source,"Steroids")
local heroin = getElementData(source,"Heroin")
local drugs = exports.mysql:querySingle( "SELECT * FROM drugs WHERE weed = ? AND god = ? AND speed = ? AND lsd = ? AND steroids = ? AND heroin = ? AND id = ?", weed, god, speed, lsd, steroids, heroin, playerID)
end
addEventHandler ( "onPlayerLogin", root, asd1 )
addEventHandler("onPlayerLogin", root,
function()
local playerID = exports.server:playerID( source )
local theDrug = exports.mysql:querySingle( "SELECT * FROM drugs WHERE id = '" .. playerID .. "'" )
if ( theDrug ) then
local weed = getAccountData(sourceAccount, "Weed")
getAccountData(sourceAccount, "Weed")
end