Utility Code diving - 3.10 list of sites and spells

Edi · #1 October 9th, 2007, 04:49 PM

Thanks! Take your time, it's nearly 11 pm here and I've got morning shift tomorrow from 8 to 4 pm, so you have no hurry.

DrPraetorious · #2 October 9th, 2007, 10:23 PM

Here's a nearly-readable version in .xls format. Here are the fields explained:

How to read it:
The Path and Rarity columns are pretty self-explanatory, and match to the number values used in the modding manual.

Each site has up to 5 powers, each of which has an argument.

Power1 corresponds to Argument1, Power2 corresponds to Argument2, and so forth.

The codes for powers and their arguments are (unused powers are not noted, but may do things - for example, I bet there's a power that generates temples):
Powers 1-8 are *gem income* - these are off by 1 from the ordinary path numbers (so fire is 1 instead of 0, etc.). Argument is the number of gems.

Power 10 was probably once extra-resources in capital. May not do anything now?

Power 11 is a recruitable troop. Argument is unit #.

Power 12 is a recruitable commander. Argument is unit #.

Power 13 is gold income. Argument is amount of gold.

Power 14 is resource income. Argument is number of resources.

Power 15 generates labs when found. Argument is just 1.

Power 16 generates temples when found, but is not used. Argument would presumably be 1 if it existed.

Power 17 makes fortresses when found. Argument is fort #.

Power 18 is enter-to-summon - it's repeated for each unit that appears. The type of mage automatically matches the type of site. Argument is unit #.

Power 19 is unrest adjustment - argument gives amount. Negative numbers increase unrest. Note that negative numbers are represented as very bug numbers in the spreadsheet (sorry).

Power 20 is supplies adjustment. Argument gives amount.

Power 21 is spreads disease. Argument is percent chance of disease per turn in the province.

Power 22 is enter for (argument) experience points.

Power 24 is horrormarking. Argument is percent chance of horrormark per turn in the province.

Power 29 is capital-only-unit. Argument is unit #.

Power 30 is capital-only-commander. Argument is unit #.

Power 31 is increase scales:
Argument 0 -> Order
Argument 1 -> Productivity
Argument 2 -> Heat
Argument 3 -> Growth
Argument 4 -> Fortune
Argument 5 -> Magic

Power 32 is *decrease scales*. Same arguments.

Power 57 is enter to summon void monsters. Argument is always 20 - might be base chance of success.

Power 60+X is a bonus for a given school of magic. Argument is %.

Power 67 is holy power. Argument is % chance of each undead being hit by AN10. "Your undead units in <province name> are being killed by a holy force native to this province."

Power 68 is holy fire. Argument is % chance of each undead or demon being hit by AN10. "Your undead and demonic troops in <province name> are being hit by holy fire".

Power 70 is probably remove battle afflictions. Argument would presumably be % chance.

Power 71 is curse. Once again, argument is % chance per unit per turn.

Power 72 is enter-to-scry.

Power 192 is enter for adventure. Edi speculates that the argument is % chance of getting anything useful.

D'oh! I had two field lengths wrong!

Replaced with a new attachment.

DrPraetorious · #3 October 9th, 2007, 10:45 PM

And here, god help us, is the new spell dump. The zip file contains my best guess about how to interpret the various fields.

Edi - this really should be part of the database. Let me know what you need in order to interpret it.

Updates:
I have added the new effect (Internal Alchemy) and the new enchantment (Dance of the Morrigans) from the 310 spells.

I have cleaned up the #spec field notes slightly, including figuring out that the extra-field in lightning makes the attack "grounded" - it always hit something in the target square.

DrPraetorious · #4 October 10th, 2007, 12:43 AM

The following sites do cool stuff (so not just money, labs, gems, etc.)

Site 566, the Temple of the Solar Bull
Fire 2, Rarity 2, any regular land
2 Fire Gems, commander Heliodramus

Site 567, Temple of the Sacred River
Water 2, Rarity 2, any regular land
1 Water Gem, 1 Death Gem, commanders Renata and Renatus

Site 568, Telesterion
Nature 2, Rarity 2, Forest
1 Nature Gem, 1 Earth Gem, commanders Mystes and Epoptes

Site 569, Grove of Revelry
Nature 2, Rarity 2, Forest
1 Nature Gem, commander Reveler

Site 617, Valley of the Dead
Death 1, Rarity 2, Plains/Forest/Wasteland
1 Death Gem, 1 Earth Gem, Enter to Summon Mummy

Site 619, Carrion Thicket
Death 1, Rarity 2, Forest
1 Death Gem, 1 Nature Gem, Enter to Summon Carrion Beast (715)

Site 633, Torture Tower
Blood 1, Rarity 1, Farmlands
Makes a simple hillfort, 3% horrormark

Site 634, Bloodshade Glen
Blood 2, Rarity 2, Unique (anywhere?)
Blood Magic Bonus 20, Conjuration Bonus 15, 1 Blood Slave

Site 635, The Slaughterhouse
Blood 2, Rarity 2, Unique (anywhere?)
Enter to summon Foul Spawn (460), Maenad (435) and Ghoul (198).

Ew.

Site 636, The Lodge
Blood 2, Rarity 2, Unique (anywhere?)
1 Blood Slave, Commanders Conjurer, Circle Master, Assassin

Site 637, Pool of Unhealthy Rites
Blood 2, Rarity 2, Any Land
Alteration 20, 1 Water Gem, 1 Death Gem, 3% Disease

Site 638, Bloodstone Mirror
Blood 2, Rarity 2, Any Land
Scrying, Thaum Bonus 20

Site 639, Tower of the Devil's Bride
Blood 1, Rarity 1, Unique/Any Land
+5 Unrest/turn, Enter to summon a lousy imp

Site 644, City of Dates
Nature 2, Rarity 0, Wasteland Unique
Makes 75 supplies, 50 gold, 1 water gem, 1 nature gem and a Motte-and-bailey*

*I'm begining to suspect that I have the fort #s wrong here....

Site 688, Nest of Bats
Blood 2, Rarity 1, Cave
1 Death Gem, Enter to summon Beast Bat

Site 689, The Lesser Abyss
Blood 2, Rarity 1, Cave Unique
+40 Unrest, Enter to summon Fiend of Darkness

Site 690, Splattermaid Gorge
Blood 2, Rarity 2, Cave Unique
1 Air Gem, Enter to summon Beast Bat

Site 691, Kelp Sea
Nature 2, Rarity 0, Shallows
2 Nature Gem, 1 Water Gem, Enter to summon Sea Stag

Site 692, Forest of Amber Kelp
Nature 2, Rarity 2, Shallows Unique
NFW Gem, Commander Air Elemental (572?)
NOTE: I bet this is a typo because the amber clan units are 573-576.

Site 693, Sentinent Current
Water 2, Rarity 2, Shallows
Conjuration 20, 1 WG
NOTE: Mis-spelled? Should be "Sentient"?

Site 694, The Darkness
Water 2, Rarity 2, Deeps Unique
Thaumaturgy 20, 1 WE Gem

Site 695, The Gate in the Deep
Water 2, Rarity 2, Deeps Unique
Conjuration 20, 2 W Gem

Site 696, The Basalt Forge
Earth 2, Rarity 2, Deeps Unique
Construction 20, 1 E Gem

Site 697, Tomb of Seven Oracles
Death 2, Rarity 3, Cave Unique
Enter-to-summon Cavern Wight, 2D1E Gem

Site 698, Infinite Cavern
Earth 2, Rarity 3, Cave Unique
Conjuration 20, 2 EG

Site 700, The Umbral Conclave
Death 2, Rarity 3, Cave Unique
Conjuration 20, 3 DG

Edi · #5 October 10th, 2007, 02:23 AM

Thanks, I'll get to work on those specials and terrain masks as soon as I get home. They should be in the DB by tonight. You are right about the air elemental being a bug, it should be Amber Clan Guard (573) and the site misspellings as well (Sentinent/Sentient and Chaft/Shaft). I've got those shortlisted in the beta forum, but having the level of detail from your code diving efforts is invaluable.

I'll look at the spell issue, but if it gets added, it gets added in a separate document, because the current DB file is starting to get REALLY unwieldy and that's on my state-of-the-art-as-of-this-time-last-year system. The spell system has too much stuff and requires too many pages, so it must be separate.

DrPraetorious · #6 October 10th, 2007, 09:22 AM

I noticed another (minor, this time) mistake in the output file for the sites. It's been fixed.

The accompanying text file has been slightly updated to include:

effect 10111 (internal alchemy)
enchantment #86 (dance of the morrigans)

Edi · #7 October 10th, 2007, 02:25 PM

The sites output file attached to the explanation post still has some errors:

Path column is actually site level column
# and name column headers should be one column to the left
C column is a complete mystery
arg2 seems to have random offsets that cause shifting everything in it and the following argument columns one column to the right, probably due to the negative numbers that overflow to 65k+
arg4 suffers from the same thing
Mystery column 1 & 2 are the column-shifted arguments

All of that means that everything regarding what the sites do must be decoded based on what we already know of them. Fortunately, that's not a problem. I've got all the visible stuff on the sites already and I know the units, so I can use the remaining data to fill in all the rest of the blanks with the help of your decoding guide above.