SQL Issue

[Slowpoke]

The following code doesn't appear to be working (Hard to tell with A.I., but some A.I.s have only 2 cities where others have 5, and many civs have no city walls at all mid game so it almost definately is not working)

UPDATE Leader_Flavors SET 'Flavor' = 10 WHERE LeaderType <> 'LEADER_BARBARIAN' and FlavorType = 'FLAVOR_CITY_DEFENSE';

UPDATE Leader_Flavors SET 'Flavor' = 10 WHERE LeaderType <> 'LEADER_BARBARIAN' and FlavorType = 'FLAVOR_EXPANSION';

I haven't done an sql where it needs 2 wheres yet, so I'm really not sure this is even supposed to work.

 

[smellymummy]

!= is the not equal you need to use, the AND in the where clause is good

edit: nevermind <> seems to work just as well. your SQL is good. the major civs have too many flavors to go through so they aren't too bright to build city walls. minor civs on the other hand have barely any flavors so they always build them

 

[Slowpoke]

I wish there were a simple "build more settlers" variable , or a settler weight or something :/ Everything is "strategy flavor" this "startegy flavor" that and none of them do anything.

 

[risikawi]

I wish there were a simple "build more settlers" variable , or a settler weight or something

I`ve been noticing that settlers are only unit related to expansion flavour, I think it is that one. As for your issue - I think city states have nothing better to do than to build, while AI seems over occupied with building armies

 

[Slowpoke]

Well after some more fiddling, I've got it to work somewhat. It seems that flavor_expansion affects a strategy in AIeconomicstrats which then effects the unit making. Setting that strategy to a weight threshold of -1000 then makes it work. Apparently A.I.s have more than one strategy which together influence A.I. behavior. So giving everyone 100% chance of early expansion still results in varying, but increased, levels of expansion.