local playerstbl = "skin"
function start ()
executeSQLCreateTable(playerstbl, "accountname TEXT, skin INT")
outputDebugString ("Resource loaded.", 3)
end
addEventHandler("onResourceStart", getResourceRootElement(getThisResource()), start)
function login1(prev, account, autologin)
local result = executeSQLQuery("SELECT skin FROM skin WHERE accountname='" .. getAccountName(account) .. "'")
if result and #result > 0 then
for k, v in ipairs(result) do
setElementModel(source, v.skin)
end
else
outputDebugString(tostring(executeSQLInsert(playerstbl, "'0', '"..getAccountName(account).."'", "skin, accountname")))
end
end
addEventHandler("onPlayerLogin", getRootElement(), login1)
function onPlayerQuit()
local acc = getPlayerAccount(source)
if not isGuestAccount(acc) then
outputDebugString(tostring(executeSQLUpdate(playerstbl, "skin = '"..getElementModel(source).."'", "accountname = '"..getAccountName(acc).."'")))
end
end
addEventHandler("onPlayerQuit", getRootElement(), onPlayerQuit)
Try that.