Bug in Exile.ini preventing old constructions etc. to be deleted

[Nerexis 19]

Bugged query prevents Exile from deleting some constructions marked as deleted (probably the ones without territory assigned), because it unmarks deleted_at field in constructions/containers table due to logic error (I'm using ext3 version of ini):

Update your "markDeleteUnpaidTerritories" query to:

; Marks territories (and all containers/constructions) that were not paid within ? days as deleted
[markDeleteUnpaidTerritories]
SQL1_1 = UPDATE territory SET deleted_at = NOW() WHERE last_paid_at < DATE_SUB(NOW(), INTERVAL ?) AND deleted_at IS NULL
SQL2_1 = UPDATE construction SET deleted_at = NOW() WHERE EXISTS (select deleted_at from territory where territory.id=construction.territory_id and territory.deleted_at IS NOT NULL)
SQL3_1 = UPDATE container SET deleted_at = NOW() WHERE EXISTS (select deleted_at from territory where territory.id=container.territory_id and territory.deleted_at IS NOT NULL)

SQL1_INPUTS = 1
	

Edited February 6, 2018 by Nerexis