New Flavor's for better AI gameplay (GnK/BNW/All DLC/CP/CBP/CSD/E&D) 10

meRlinX_AT · May 26, 2015

New flavor's for better AI gameplay (Vanilla/GnK/BNW/+DLC/CP/CBP/CSD/E&D)
+wrong or forgotten flavor's are now eliminated!

This Mod auto-generates new Flavor's for better AI selection from Buildings, Policies, Technologies, Processes, Resources, Specialist, Yields, Improvements and Builds - based on the real yields/function's.

Compatible with all Versions of CIV5 (STOCK, STOCK+GnK or STOCK+GnK+BNW) and is also compatible to the following (if installed):

CP v88
CBP/CPO v13
CSD
E&D
out of the box with any other mod (if there are no new important tables/columns added)

This Mod must be loaded after all Buildings, Policies, Technologies, Processes, Resources, Specialist, Yields, Improvements, Builds and Units are added to the DB!
Please

clear your cache
activate your mod's in the proper order
activate this mod as the last one

References for

Community Patch
Community Balance Patch/Community Balance Overhaul
City-State Diplomacy Mod - CBP Edition
Community Balance Patch - Compatibility Files (EUI)
Community Balance Patch - Compatibility Files (No-EUI)
Events and Decisions - Community Balance Patch Edition
and all Civ V DLC's

are already set.

After load, you can check the AnC_DebugCheck_NE VIEW in the Civ5DebugDatabase.db for error's.

Think, this mod will not affect saved games.

Have fun and download here

------------------------------------------------------------------------------------------------------------------------------------------------------

Feedback, info, impressions, discussions are welcome!
- Info about changed names from tables/columns (old --> new) in the different versions of CIV or listed Mod's would be great - thx.
- Flavor's for Policies are calculated now smarter... how performs the AI?
- stored queries are not possible with sqlite - or is there a solution? Maybe someone can help with a sqlite_prepare/sqlite_userfunction?

------------------------------------------------------------------------------------------------------------------------------------------------------

FAQ
Mod load-order:
- Add the reference in the AnC-some new Flavors.modinfo file (use a UTF-8 Editor like Notepad++)

Spoiler :

- Clear cache
- Activate Mod's in the right order
then
- Always load the mods (without any changes in the menu) and then load the savegame
- your stopwatch.log should then look something like this

Spoiler :

- all Update Database - AnC_XXX should be the last one

Yes - There are maybe error's in the database.log from this mod:
- this is ok, because the mod loads all file's for all version's/mod's
--> check the AnC_DebugCheck_NE VIEW in the Civ5DebugDatabase.db for error's

------------------------------------------------------------------------------------------------------------------------------------------------------

History/Done
- flavor's for league proposals/processes --> done! (v3)
- flavor's for policies, technologies --> done (v6)
- smarter flavor's for policies (v9, v11)
- speed optimization --> should now collect all entry's faster (<=v7)
- ~350 "yields" are now unified in 1 view for better adjustment (<=v6)
- buff's & nerf's (<=v9)
- bugfixes, bugfixes (v7)
- ~~failsafe switches for the query's (<V4)~~
--> no switches - all files are now separate (v7) --> should now run like Forest Gump

- better reporting (v9)
- better calculation for FreeBuildings from Buildings/Policies (v9)
- extension to leader flavor's --> Have a look here @Leader Personalities Idea from jma22tb
- first adaption to CP v88 (v10)
------------------------------------------------------------------------------------------------------------------------------------------------------

Feature's/Pending:
- new flavor's for units --> needed/useful? (another 1-2k sqllines)
- frontend reporting - can someone help?
- more speed optimization, if possible
- more buff's & nerf's --> feedback is welcome!
- incorporate existing auto-text for buildings (new TXT_help will be generated too) --> will be a separate mod
- calculate the real flavor for (Free)Promotion's
- better logging

jma22tb · May 26, 2015

Oh wow. That is epic.

It looks like it rearranges flavors so that it fits everything you build, specialists, etc. based on the Leader flavors. Is that the idea?

If so all I can do is :worship:

. I have no idea how to build SQL like that and what you built must have taken a very long time.

Gonna test them out

Gazebo · May 26, 2015

Great work, Merlin. We'll test this out a bit and fold it in a few versions down the road.
G

jma22tb · May 26, 2015

To clarify you need CP, CBP, CSD right? Do you need E&D as well?

meRlinX_AT · May 27, 2015

jma22tb said:
To clarify you need CP, CBP, CSD right? Do you need E&D as well?

not 100% sure... i have all running. the query will check a lot of tables and columns. did E&D add some columns? - then yes (but i think it will not)
if it fails, the proper query can be deactivated easily in the Flavor4All. --> made a look. 2 tables will be added from E&D but not calculated atm within my query. but all decision buildings will become flavor's (which i think, will not taken into account - i investigate further).

btw, who will play without E&D?

will check, maybe the next version will have switches.

Gazebo said:
Great work, Merlin. We'll test this out a bit and fold it in a few versions down the road.
G

thx. some calculations need maybe a buff or nerf.
when i know more about the calc within the DLL, i can tweak it more.
will negative flavor's from buildings crash the game or taken into account?

jma22tb said:
Oh wow. That is epic.

It looks like it rearranges flavors so that it fits everything you build, specialists, etc. based on the Leader flavors. Is that the idea?

If so all I can do is . I have no idea how to build SQL like that and what you built must have taken a very long time.

Gonna test them out

it will just generate a "few" flavor's based on the yields and function of buildings :cool:

it took me less time, as to rearrange all flavor's from the existing stuff be hand.

oh, pls don't worship me :lol:

made this for my "personal use", because i get bored over the bad decisions from the AI.

meRlinX_AT · May 27, 2015

there is still some work needed and ideas pending:

- flavor's for league proposals/processes
- flavor's for policy's
- failsafe switches for the query's
- incorporate flavor's for technologies
- speed optimization
- buff's & nerf's
... and an extension - after i have a clue about the AIEconomicStrategy_City_Flavors, AIMilitaryStrategy_City_Flavors, and the other's

WileyNg · May 27, 2015

Can you briefly describe how this mod work?

Great work!

Gazebo · May 27, 2015

meRlinX_AT said:
when i know more about the calc within the DLL, i can tweak it more.
will negative flavor's from buildings crash the game or taken into account?

Whatcha need from me?

G

meRlinX_AT · May 27, 2015

WileyNg said:
Can you briefly describe how this mod work?

Great work!

thx.

the mod will query "some" :lol:

tables for entry's and calculate flavor's based on the given yield or function.

as example:
first, yields become flavor's: 1 YIELD_FOOD = 5 FLAVOR_GROWTH, aso...

then we check some tables, which building gives which YIELD_XXX and multiply with the flavor

for the BUILDING_GRANARY, we become (based on the DB from CP/CBP/AnC)

Flavor Type, Building Type, calculated Flavor, from which Table
"FLAVOR_EXPANSION", "BUILDING_GRANARY", "20", "Unit_ProductionModifierBuildings" <-- we speed up the production of settler's
"FLAVOR_GROWTH","BUILDING_GRANARY","20","Building_ResourceYieldChanges" < -- we change yields from resources
"FLAVOR_GROWTH","BUILDING_GRANARY","10","Building_YieldChanges" <-- we provide yields
"FLAVOR_GROWTH","BUILDING_GRANARY","5","Buildings.AllowsFoodTradeRoutes" <-- we allow food trade routes, which helps growth
"FLAVOR_I_LAND_TRADE_ROUTE","BUILDING_GRANARY","5","Buildings.AllowsFoodTradeRoutes" <-- we allow a traderoute
"FLAVOR_I_SEA_TRADE_ROUTE","BUILDING_GRANARY","5","Buildings.AllowsFoodTradeRoutes" <-- we allow a traderoute

(... and htf can i add a nice table with columns?)

thats the short story

if you are familiar with sql, have a look in the sql files.
you can delete the AnC_Cleaning, generate a new Civ5Debug.db and look the tables and views with AnC_

jma22tb · May 27, 2015

Yeah it really helps unify the AI's priorities and choices.

Btw, the policies, leader flavors, and grand strategies have all been unified to fit the archetypes talked about in the testing AI personalities thread.

That's why I was so excited because now with your work, the buildings, units, etc reflect those archetypes even more, making it more likely for the AI to build their civs in that vision.

I did a test game, but not a long one, just until Medieval. It's already clear that the AI is a lot smarter. Their population growth and yields were better, and I'm convinced that from Medieval on, the pressure will be on for Tourism, Diplomacy, Technology, etc.

Gazebo · May 27, 2015

Two bugs in the database:

[351.532] no such column: YieldBase
[351.532] no such table: AnC_Focus2SpecialistType

They seem benign, in that the necessary flavor tables are in the database, however I didn't look too hard.

G

meRlinX_AT · May 27, 2015

Gazebo said:
Whatcha need from me?

G

mmh... some information, how the AI uses the flavor's from this stuff within the DLL would be helpful. (have no C++ coding skill, but can read it a little)
how will the AI make a decision, what to build?
how will the AICityStrategy_Flavors, AIEconomicStrategy_City_Flavors and the other's taken into account?
know the AI, that growth = more science? ... or should YIELD_FOOD also become a a small FLAVOR_SCIENCE?

as ex.: YIELD_GOLDEN_AGE_POINTS did not directly provide anything. but if we have a golden age, then we become a boost to Gold, Production & Science

so i gave them half the flavor from the normal yields (2.5/5)
"FLAVOR_GOLD","YIELD_GOLDEN_AGE_POINTS","2.5"
"FLAVOR_GROWTH","YIELD_GOLDEN_AGE_POINTS","2.5"
"FLAVOR_PRODUCTION","YIELD_GOLDEN_AGE_POINTS","2.5"
"FLAVOR_SCIENCE","YIELD_GOLDEN_AGE_POINTS","2.5"

all buildings which provide YIELD_GOLDEN_AGE_POINTS or triggers a golden age, will be further calculated based on this 4 flavor's.

a flowchart of the calculations would be also helpful

thanks for your help

Gazebo · May 27, 2015

meRlinX_AT said:
mmh... some information, how the AI uses the flavor's from this stuff within the DLL would be helpful. (have no C++ coding skill, but can read it a little)
how will the AI make a decision, what to build?
how will the AICityStrategy_Flavors, AIEconomicStrategy_City_Flavors and the other's taken into account?
know the AI, that growth = more science? ... or should YIELD_FOOD also become a a small FLAVOR_SCIENCE?

as ex.: YIELD_GOLDEN_AGE_POINTS did not directly provide anything. but if we have a golden age, then we become a boost to Gold, Production & Science

so i gave them half the flavor from the normal yields (2.5/5)
"FLAVOR_GOLD","YIELD_GOLDEN_AGE_POINTS","2.5"
"FLAVOR_GROWTH","YIELD_GOLDEN_AGE_POINTS","2.5"
"FLAVOR_PRODUCTION","YIELD_GOLDEN_AGE_POINTS","2.5"
"FLAVOR_SCIENCE","YIELD_GOLDEN_AGE_POINTS","2.5"

all buildings which provide YIELD_GOLDEN_AGE_POINTS or triggers a golden age, will be further calculated based on this 4 flavor's.

a flowchart of the calculations would be also helpful

thanks for your help

Essentially, the AI checks through all available strategies (city, military, player, etc.) at set intervals (usually once a turn), enabling/disabling them as needed. These values then ramp up the innate flavor of the AI in that category. For example, if a city is landlocked, all flavors related to water (FLAVOR_NAVAL_GROWTH, et. al.) are severely reduced.

Now, how do these work? There is a 'chooseproduction' AI function that gets every possible building/unit/process/wonder for the city, and then weights them based on these flavors. Higher flavors = higher weights, though Ilteroi and I have added a few 'sanity checks' in there to make sure that the AI doesn't do anything utterly stupid. Some things, like AI units for military operations, are innately weighed higher to encourage the AI to build its armies ASAP.

Once all items are weighed, the AI picks from the top X, where X is the value set in the handicaps ('NumProductionOptions'). So, theoretically, the AI could have one item with a flavor of 100000, one with a flavor of 4000, and one with a flavor of 5, all three the top, and choose the flavor 5 option (if the NumProductionOptions is set to 3). In most cases, though, this disparity is unlikely to happen.

Beliefs are calculated differently there are no belief flavors, as Firaxis decided to hard-code all of the belief choosing logic into the DLL based on yields and personality attributes. Not the worst system, mind you, but it is an aberration.

G

meRlinX_AT · May 27, 2015

Gazebo said:
Two bugs in the database:

They seem benign, in that the necessary flavor tables are in the database, however I didn't look too hard.

G

sry!
just 1 Bug, which causes this 2 error's

new Version is updated

should not affect savegame, because it just rebuilds the flavor's

meRlinX_AT · May 27, 2015

Gazebo said:
Essentially, the AI checks through all available strategies (city, military, player, etc.) at set intervals (usually once a turn), enabling/disabling them as needed. These values then ramp up the innate flavor of the AI in that category. For example, if a city is landlocked, all flavors related to water (FLAVOR_NAVAL_GROWTH, et. al.) are severely reduced.

Now, how do these work? There is a 'chooseproduction' AI function that gets every possible building/unit/process/wonder for the city, and then weights them based on these flavors. Higher flavors = higher weights, though Ilteroi and I have added a few 'sanity checks' in there to make sure that the AI doesn't do anything utterly stupid. Some things, like AI units for military operations, are innately weighed higher to encourage the AI to build its armies ASAP.

Once all items are weighed, the AI picks from the top X, where X is the value set in the handicaps ('NumProductionOptions'). So, theoretically, the AI could have one item with a flavor of 100000, one with a flavor of 4000, and one with a flavor of 5, all three the top, and choose the flavor 5 option (if the NumProductionOptions is set to 3). In most cases, though, this disparity is unlikely to happen.

Beliefs are calculated differently there are no belief flavors, as Firaxis decided to hard-code all of the belief choosing logic into the DLL based on yields and personality attributes. Not the worst system, mind you, but it is an aberration.

G

i understand.
how will flavors for resources/improvements are taken into account? also in a range from 5-100+? (like buildings)

did not found much info about columns/tables, which are present (and maybe also filled) and not used with the DLL.

is there a way, to look into the DLL code, without installing a bunch of programs?

Gazebo · May 27, 2015

meRlinX_AT said:
i understand.
how will flavors for resources/improvements are taken into account? also in a range from 5-100+? (like buildings)

did not found much info about columns/tables, which are present (and maybe also filled) and not used with the DLL.

is there a way, to look into the DLL code, without installing a bunch of programs?

Resources and improvements have tables for flavors that aren't really used.

You can hop on github and take a look:

meRlinX_AT · May 28, 2015

New Version 3 is here UP

Done:
- flavor's for league proposals/processes --> done!
- speed optimization --> should now collect all entry's faster
- ~215 "yields" are now unified in 1 view for better adjustment

Spoiler :

- buff's & nerf's --> some already balanced
- bugfixes

Pending:
- flavor's for policy's --> preparing
- new flavor's for units --> needed/useful? (another 1-2k sqllines :undecide:

)
- failsafe switches for the query's --> first incorporated
- frontend reporting
- incorporate flavor's for technologies --> overhaul existing CBPTechFlavors
- more speed optimization, if possible
- more buff's & nerf's --> feedback is welcome!
- incorporate existing auto-text for buildings --> preparing
... and an extension - after i have a clue about the AIEconomicStrategy_City_Flavors, AIMilitaryStrategy_City_Flavors, and the other's

Have fun

meRlinX_AT · May 28, 2015

Gazebo said:
Resources and improvements have tables for flavors that aren't really used.

You can hop on github and take a look:

one more registration? :sad:

another question... i working on a a way to identify, which tables/columns are added/altered from which mod.

i think about something like this:

Code:

SELECT Flavors.Type AS FT, 'DoFToVotes' AS YT, 50 AS Flavor
FROM Flavors
WHERE Flavors.Type IN ('FLAVOR_DIPLOMACY') /* CSD */ AND EXISTS (SELECT Value FROM Defines WHERE Name = 'EMBASSY_IMPROVEMENT')

but then i see, that in Community Balance Patch - Compatibility Files (EUI) (5-13) are also some changes to tables from CSD.

at this point, i need 2 switches - which is to much overhead

which Defines can i use with freedom, that will not be changed in future... so i can include switches to make my mod compatible to all extensions separate?

Gazebo · May 28, 2015

meRlinX_AT said:
one more registration?

another question... i working on a a way to identify, which tables/columns are added/altered from which mod.

i think about something like this:

Code:

SELECT Flavors.Type AS FT, 'DoFToVotes' AS YT, 50 AS Flavor FROM Flavors WHERE Flavors.Type IN ('FLAVOR_DIPLOMACY') /* CSD */ AND EXISTS (SELECT Value FROM Defines WHERE Name = 'EMBASSY_IMPROVEMENT')

but then i see, that in Community Balance Patch - Compatibility Files (EUI) (5-13) are also some changes to tables from CSD.

at this point, i need 2 switches - which is to much overhead

which Defines can i use with freedom, that will not be changed in future... so i can include switches to make my mod compatible to all extensions separate?

Why not use the custommodtable or custommodoptions as your 'defines?'
G

Gazebo · May 29, 2015

Two more database errors for you:

[9954.049] no such column: loaded
[9955.937] no such column: Buildings.DPToVotes

Seem to be occurring in:

AnC_QuerryViews.sql (should this be query, or quarry perhaps?)

and

AnC_Flavor4All.sql

and

AnC_Cleaning.sql

G

New Flavor's for better AI gameplay (GnK/BNW/All DLC/CP/CBP/CSD/E&D) 10

JustMe

Prince

Lord of the Community Patch

Prince

JustMe

JustMe

Prince

Lord of the Community Patch

JustMe

Prince

Lord of the Community Patch

JustMe

Lord of the Community Patch

JustMe

JustMe

Lord of the Community Patch

JustMe

JustMe

Lord of the Community Patch

Lord of the Community Patch

Similar threads