scrisot skull

function getPlayerFrags(cid)
	local time = os.time()
	local times = {today = (time - 86400), week = (time - (7 * 86400))}

	local contents, result = {day = {}, week = {}, month = {}}, db.getResult("SELECT `pd`.`date`, `pd`.`level`, `p`.`name` FROM `player_killers` pk LEFT JOIN `killers` k ON `pk`.`kill_id` = `k`.`id` LEFT JOIN `player_deaths` pd ON `k`.`death_id` = `pd`.`id` LEFT JOIN `players` p ON `pd`.`player_id` = `p`.`id` WHERE `pk`.`player_id` = " .. getPlayerGUID(cid) .. " AND `k`.`unjustified` = 1 AND `pd`.`date` >= " .. (time - (30 * 86400)) .. " ORDER BY `pd`.`date` DESC")
	if(result:getID() ~= -1) then
		repeat
			local content = {date = result:getDataInt("date")}
			if(content.date > times.today) then
				table.insert(contents.day, content)
			elseif(content.date > times.week) then
				table.insert(contents.week, content)
			else
				table.insert(contents.month, content)
			end
		until not result:next()
		result:free()
	end

	local size = {
		day = table.maxn(contents.day),
		week = table.maxn(contents.week),
		month = table.maxn(contents.month)
	}
	return size.day + size.week + size.month
end

local fragSkulls = {
	{ from = 10, to = 20, skull = SKULL_YELLOW },
	{ from = 21, to = 50, skull = SKULL_GREEN },
	{ from = 51, to = 100, skull = SKULL_WHITE },
	{ from = 101, to = 200, skull = SKULL_RED },
	{ from = 201, to = 300, skull = SKULL_BLACK }
}

function onThink(cid, interval)
	if not isPlayer(cid) then
		return
	end

	local accountManager = getPlayerAccountManager(cid)
	if accountManager == MANAGER_NONE then
		local frags = getPlayerFrags(cid)
		local skull = getPlayerSkullType(cid)
		for index, skullInfo in pairs(fragSkulls) do
			if frags >= skullInfo.from and frags <= skullInfo.to then
				doCreatureSetSkullType(cid, skullInfo.skull)
				return
			end
		end
		doCreatureSetSkullType(cid, SKULL_NONE)
	end

end