oi galera estou tentando 

SELECT `player_id`,`pid`,`sid`,CONVERT(`attributes` USING latin1 ) FROM `player_items` WHERE CONVERT(`attributes` USING latin1 ) LIKE '%timerOnExp%'

Recebo os seguintes resultados

 

a idéia é usá-lo em um globalvent

 

if timerOnExp < os.time() then

delete items

end

 

-- <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 test1 = result.getStream(resultId, "attr")
			local test2 = result.getString(resultId, "attr")
			local test3 = tonumber(test1)
			local test4 = tonumber(test2)
			player:sendTextMessage(MESSAGE_STATUS_CONSOLE_BLUE, "test 1: " .. test1 .. " (stream), test 2:" .. test2 .. " (string), test 3: ".. test3 .." (number-stream) and test 4: ".. test4.." (numer-string).")
		until not result.next(resultId)
	end
	return false
end

Send me result ...

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

22 horas 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 test1 = result.getStream(resultId, "attr")
			local test2 = result.getString(resultId, "attr")
			local test3 = tonumber(test1)
			local test4 = tonumber(test2)
			player:sendTextMessage(MESSAGE_STATUS_CONSOLE_BLUE, "test 1: " .. test1 .. " (stream), test 2:" .. test2 .. " (string), test 3: ".. test3 .." (number-stream) and test 4: ".. test4.." (numer-string).")
		until not result.next(resultId)
	end
	return false
end

Send me result ...

 

 

 

 

-- <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 test1 = result.getStream(resultId, "attr")
			local test2 = result.getString(resultId, "attr")
			local test3 = tonumber(test1)
			local test4 = tonumber(test2)
			
			if test1 then print(test1) end
			if test2 then print(test2) end
			if test3 then print(test3) end
			if test4 then print(test4) end

		until not result.next(resultId)
	end
	return false
end