Database Tables Question (Maintain Objects)

[Pavillin]

I have a simple question regarding my server database. I'm having an issue regarding maintaining my base (0 Building Parts In Range) so I checked the event that sets damage in my database.

This is the SQL event I have

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

I noticed it says "Object_DATA", the table in my database is called "object_data". I'm curious is this is the reason it's not damaging the buildables? Are the tables/events case sensitive?

Also just to make sure, this SQL will damage the buildables every 3 days correct?

 

[bFe]

It will damage the buildables every third day, yes.
I'm not sure if its case sensitive or not, but have you tried changing the name in the event?

You can also put this in your init if you want to be able to maintain 24/7 

DZE_DamageBeforeMaint = 0.00;

Edited October 19, 2015 by bFe

[sampson42002]

Hello, Did you manage to figure it out?  I have a different one and it's set for 1 day testing to see if it works.  It's been 3 days and still 0 building parts in range.  If you did what was the issue?

[Pavillin]

In the SQL I noticed it said 'Object_DATA' I changed it to 'object_data' to match the table in my database (guess they are case sensitive).

I then set the damage for maintain to the following:

DZE_DamageBeforeMaint = 0.09