dúvida [Globalevents] Stamina

[lucas502 18]

Ae beleza?

 

Moveram o outro topico, mas encontrei problemas no script de stamina do jhon:

 

Script:

function onThink(interval, lastExecution, thinkInterval)
local stamina = db.getResult("SELECT `id`, `stamina` FROM `players` WHERE `group_id` <= 2;")
local stamina_hour = 3600000 -- 1 hra de stamina, o tempo é calculado em milesegundos. Exemplo: 1 min = 600000 mileseg.
repeat
	if stamina:getID() == -1 then
			break
	end
	id, stamina_now = stamina:getDataInt("id"), stamina:getDataInt("stamina")
	if stamina_now < 151200000 then
			stamina_verifica = 151200000 - stamina_now
			if stamina_verifica < stamina_hour then
					db.executeQuery("UPDATE `players` SET `stamina` = '"..stamina_now+stamina_verifica.."' WHERE `id` == '"..id.."';")
			else
					db.executeQuery("UPDATE `players` SET `stamina` = '"..stamina_now+stamina_hour.."' WHERE `id` == '"..id.."';")
			end
	end
until stamina:next() == false
return true
end

 

 

 

 

Erro:

 

 

 

 

[3:23:04.848] mysql_real_query(): UPDATE `players` SET `stamina` = '151200000' WHERE `id` == '197'; - MYSQL ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '== '197'' at line 1 (1064)

 

 

Aguardo solução, obrigado!

 

xD

Editado Junho 24, 2012 por Lucas502

[Vodkart 1515]

function onThink(interval, lastExecution, thinkInterval)
local total,minutes = 151200000,1800000
local query = db.getResult("SELECT `id`, `stamina` FROM `players` WHERE `id` > 6 AND `group_id` < 3;")
if (query:getID() ~= -1) then
while true do
local id, stamina_now = query:getDataInt("id"), query:getDataInt("stamina")
if stamina_now < (total-minutes) then
db.executeQuery("UPDATE `players` SET `stamina` = "..stamina_now+minutes.." WHERE `id` = "..id)
end
if not(query:next()) then
break
end
end
query:free()
end
return true
end