Server Upgrade Kit Download

[Eichi 4505]

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

[Eichi 4505]

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