setDamageOnAge

[Mat43]

Hi I have a server I host on Vilayer and am trying to get the setDamageOnAge query to work in the data base.

I have placed down some test building and when I run the event

UPDATE `Object_DATA` SET `Damage`=0.2 WHERE `ObjectUID` <> 0 AND `CharacterID` <> 0 AND `Datestamp` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 1 DAY) AND ( (`Inventory` IS NULL) OR (`Inventory` = '[]') )

It does not seem to do anything. I can see the buildings in the database, but when the query is ran it affects 0 rows and the items remain @ 0 damage.

 

I have this set up on my local test server and it works fine. I am using Navicat lite

 

Can any one help me please?

 

PS. what is the difference between an "event" & a "query"?

[SadBoy1981]

If u use Vilayer, then in Control Panel  click Epoch Manager - BETA and then use Add Recommended Events and just execute it

[syco]

With that event the object(s) need to be at least 1 day old before they are affected. After that it will place 0.2 damage on them.

[jahangir13]

An event is something like an scheduled query. It's executed by the database alone (not invoked from an application like your epoch).

So if it does not really matter when this is called (so from a games logic point of view) it's the best you can do to let the db do it automatically.