-- <talkaction words="!test" script="teste.lua" />

function onSay(player, words, param)
	local resultId = db.storeQuery("SELECT `player_id`,`pid`,`sid`,CONVERT(`attributes` USING latin1) AS `attr` FROM `player_items` WHERE CONVERT(`attributes` USING latin1) LIKE '%timerOnExp%'")	
	if resultId then
		repeat
			local attr = result.getStream(resultId, "attr")
			local timerOnExp = tonumber(string.sub(attr, 25, 34))
			if os.time() >= timerOnExp then	
				local sid = result.getNumber(resultId, "sid")
				db.storeQuery("DELETE FROM `player_items` WHERE `sid` = ".. sid)
				print("deleted!")
			end
		until not result.next(resultId)
	end
	return false
end

 

Editado Novembro 17, 2017 7 anos por luanluciano93 (veja o histórico de edições)

9 minutos atrás, luanluciano93 disse:

-- <talkaction words="!test" script="teste.lua" />

function onSay(player, words, param)
	local resultId = db.storeQuery("SELECT `player_id`,`pid`,`sid`,CONVERT(`attributes` USING latin1) AS `attr` FROM `player_items` WHERE CONVERT(`attributes` USING latin1) LIKE '%timerOnExp%'")	
	if resultId then
		repeat
			local attr = result.getStream(resultId, "attr")
			local timerOnExp = tonumber(string.sub(attr, 25, 34))
			if os.time() >= timerOnExp then	
                local sid = result.getNumber(resultId, "sid")
            	db.storeQuery("DELETE FROM `player_items` WHERE `sid` = ".. sid)
				print("deleted!")
			end
		until not result.next(resultId)
	end
	return false
end

 

 

 

only delete if the player is not connected

-- <talkaction words="!test" script="teste.lua" />

function onSay(player, words, param)
	local resultId = db.storeQuery("SELECT `player_id`,`sid`, CONVERT(`attributes` USING latin1) AS `attr` FROM `player_items` WHERE CONVERT(`attributes` USING latin1) LIKE '%timerOnExp%'")	
	if resultId then
		repeat
			local attr = result.getStream(resultId, "attr")
			local timerOnExp = tonumber(string.sub(attr, 25, 34))
			if os.time() >= timerOnExp then
				local player_id = result.getNumber(resultId, "player_id")
				local sid = result.getNumber(resultId, "sid")
				db.storeQuery("DELETE FROM `player_items` WHERE `player_id`=".. player_id .." AND `sid` = ".. sid)
				print("deleted!")
			end
		until not result.next(resultId)
	end
	return false
end

 

10 minutos atrás, luanluciano93 disse:

-- <talkaction words="!test" script="teste.lua" />

function onSay(player, words, param)
	local resultId = db.storeQuery("SELECT `player_id`,`sid`, CONVERT(`attributes` USING latin1) AS `attr` FROM `player_items` WHERE CONVERT(`attributes` USING latin1) LIKE '%timerOnExp%'")	
	if resultId then
		repeat
			local attr = result.getStream(resultId, "attr")
			local timerOnExp = tonumber(string.sub(attr, 25, 34))
			if os.time() >= timerOnExp then
				local player_id = result.getNumber(resultId, "player_id")
				local sid = result.getNumber(resultId, "sid")
				db.storeQuery("DELETE FROM `player_items` WHERE `player_id`=".. player_id .." AND `sid` = ".. sid)
				print("deleted!")
			end
		until not result.next(resultId)
	end
	return false
end

 

same result only delete for players not connected

 

-- <talkaction words="!test" script="teste.lua" />

function onSay(player, words, param)
	local resultId = db.storeQuery("SELECT `player_id`,`sid`, CONVERT(`attributes` USING latin1) AS `attr` FROM `player_items` WHERE CONVERT(`attributes` USING latin1) LIKE '%timerOnExp%'")	
	if resultId then
		repeat
			local attr = result.getStream(resultId, "attr")
			local timerOnExp = tonumber(string.sub(attr, 25, 34))
			if os.time() >= timerOnExp then
				local player_id = result.getNumber(resultId, "player_id")
				local sid = result.getNumber(resultId, "sid")
				db.query("DELETE FROM `player_items` WHERE `player_id`=".. player_id .." AND `sid` = ".. sid)
				print("deleted!")
			end
		until not result.next(resultId)
	end
	return false
end