Temat: [8.41+][CreatureScript] Licznik czasu online!

ALTER TABLE `players` ADD `ontime` int(11) NOT NULL ;

<event type="logout" name="PlayerLogout" script="logout.lua"/>

 
return TRUE

setPlayerStorageValue(cid, 9999, os.time())

function onLogout(cid)
	local online = math.floor(os.time() - getPlayerStorageValue(cid, 9999))
	setPlayerOnlineTime(cid, online)
end

function getPlayerOnlineTime(uid)
	if (isPlayer(uid) == TRUE) then
		local select = db.getResult("SELECT `ontime` FROM `players` WHERE `name` = '" .. getPlayerName(uid) .. "' LIMIT 1;")
		return select:getDataInt("ontime")
	else
		return FALSE
	end
end

function setPlayerOnlineTime(uid, value)
	if (isPlayer(uid) == TRUE) then
		db.executeQuery("UPDATE `players` SET `ontime` = `ontime` + " .. value .. " WHERE `name`='" .. getPlayerName(uid) .. "' LIMIT 1;")
		return TRUE
	else
		return FALSE
	end
end

local online = math.floor(os.time() - getPlayerStorageValue(cid, 9999))
setPlayerOnlineTime(cid, online)