clocwork
-
Posts
3 -
Joined
-
Last visited
Content Type
Profiles
Forums
Articles
Posts posted by clocwork
-
-
Also, whats the format of crating an event, because I wanna add in some mroe SQL event
I dont understand what does this part mean
ON COMPLETION NOT PRESERVE ENABLE
AND `Object_DATA`.`Datestamp` < now() - INTERVAL 3 DAY This makes it so you have to wait a minimum of 3 days since the last maintenance or from placing the object before maintaining will work. This value can be adjusted/removed as preferred.
ON COMPLETION NOT PRESERVE ENABLE just makes it so the sql event doesn't expire and get dropped after completing the first time and will allow it to be a repeating event.
-
CREATE EVENT `Maintenance` ON SCHEDULE EVERY 1 DAY STARTS '2014-12-25 00:00:00' ENDS '2026-12-25 00:00:00' ON COMPLETION NOT PRESERVE ENABLE DO UPDATE `object_data`SET `Object_DATA`.`Damage`=0.3WHERE `Object_DATA`.`ObjectUID` <> 0AND `Object_DATA`.`CharacterID` <> 0AND `Object_DATA`.`Datestamp` < now() - INTERVAL 3 DAYAND ( (`Object_DATA`.`Inventory` IS NULL) OR (`Object_DATA`.`Inventory` = '[]') )
[Release] Taxi script v0.2
in Scripts
Posted
Just add ---> !"callcab" to the end of the first line in publicvariable.txt to keep BE from kicking.
Click for a great BE guide by Ebay.