Sign in to follow this  
Followers 0
Eichi

Server Upgrade Kit Download

2 posts in this topic

As many server owners have requested to get an insight of how the data and data structure will change in the upcoming version; here you go!

Be aware that these files are subject to change until the release! There is no guarantee that they will stay the same until then!

Also, our time is currently limited as we are working every minute on the new update, ensuring that everything works fine. Thus we cannot answer any questions. Please understand.

Download
Download from server #1

26 people like this

Share this post


Link to post
Share on other sites

I have been asked about cleaning things up. This is what the server now does on boot:

;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
;; Garbage Collector
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;

; Removes containers outside territories that were not accessed within ? days
[deleteOldContainers]
SQL1_1 = DELETE FROM container WHERE last_updated_at < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL ? DAY)) AND territory_id = NULL
Number Of Inputs = 1
SQL1_INPUTS = 1

; Removes contructions outside territories after ? days
[deleteOldConstructions]
SQL1_1 = DELETE FROM construction WHERE last_updated_at < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL ? DAY)) AND territory_id = NULL
Number Of Inputs = 1
SQL1_INPUTS = 1

; Removes vehicles that were not used within ? days
[deleteOldVehicles]
SQL1_1 = DELETE FROM vehicle WHERE last_updated_at < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL ? DAY))
Number Of Inputs = 1
SQL1_INPUTS = 1

; Removes territories (and all containers/constructions) that were not paid within ? days
[deleteUnpaidTerritories]
SQL1_1 = DELETE FROM territory WHERE last_paid_at < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL ? DAY))
Number Of Inputs = 1
SQL1_INPUTS = 1

The ? can be configured in exile_server_config.pbo

25 people like this

Share this post


Link to post
Share on other sites
Advertisement
Guest
This topic is now closed to further replies.
Sign in to follow this  
Followers 0

  • Recently Browsing   0 members

    No registered users viewing this page.