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?
Question
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
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
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 accountSign in
Already have an account? Sign in here.
Sign In Now