bane_
Howardianism High-Priest
- Joined
- Nov 27, 2013
- Messages
- 1,559
Is it possible to do a 'flexible' update with SQL, only changing some value IF another value exists?
I want to create new entries in the table Buildings as <TibetMountain> and <TibetMountainNearby> with 'false' as the default, and want to update each building that has 'Mountain' to be turned 'false' and get 'true' on <TibetMountain>; then a similar process to <TibetMountainNearby> and 'NearbyMountainRequired'.
The reason I want to do this instead of manually changing the three BNW buildings with those requirements is because I want my mod to be modular, so any new building/wonder with a Mountain or NearbyMountainRequired will be updated when my mod loads.
I want to create new entries in the table Buildings as <TibetMountain> and <TibetMountainNearby> with 'false' as the default, and want to update each building that has 'Mountain' to be turned 'false' and get 'true' on <TibetMountain>; then a similar process to <TibetMountainNearby> and 'NearbyMountainRequired'.
The reason I want to do this instead of manually changing the three BNW buildings with those requirements is because I want my mod to be modular, so any new building/wonder with a Mountain or NearbyMountainRequired will be updated when my mod loads.