sql help

[Tormented Being]

how can i make this only do the query for the play that kills the creature?

local dano = damage
function onKill(cid, target, damage, flags)
     if isMonster(target) then    
     db.executeQuery("UPDATE `player_storage` SET `value` = `value` + ".. dano .." WHERE `key` = ".. 7854 .." WHERE `player_id` = ".. getPlayerGUID(cid) .."")
end    
return true
end

 

[Cykotitan]

did you mean last hit?
and you should be using lua function instead of query

function onKill(cid, target, damage, flags)
	if bit.band(flags, 1) == 1 and isMonster(target) then
		doCreatureSetStorage(cid, 7854, math.max(0, getCreatureStorage(cid, 7854)) + damage)
	end
	return true
end

 

[Tormented Being]

will this still update it instantly? anyways thanks i will test it!