Jump to content
  • 0

Database Tables Question (Maintain Objects)


Pavillin

Question

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?

 

Link to comment
Share on other sites

3 answers to this question

Recommended Posts

  • 0

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 by bFe
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Discord

×
×
  • Create New...