Utility: Code diving - 3.10 list of sites and spells

[DrPraetorious]

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]

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.

[DrPraetorious]

Redownload the attachment, I think I fixed all that

[Edi]

Actually, you didn't. Doesn't matter, I can easily work with this since I've got most of the things down, the things I don't wil stick out like a sore thumb.

[Edi]

Aaaaand it's done! Sites have been fully updated with terrain masks, levels and specials! Thank you, DrPraetorious!

[DrPraetorious]

I must've uploaded the wrong attachment or failed to overwrite it or something, but if it's not a problem it's not a problem.

I'm perfectly happy to make the spell-list nice myself, but do not know how to do it. Can you suggest a tutorial on how to make dependent sheets and list lookups as is done in the main guidebook? It's a useful thing for me to know anyway.

[Edi]

The spell list as such seems just fine, I can actually read most of it fairly well. In order to make the thing more readable, to create the kind of display pages the Dom3 DB has for units, you actually need to have the whole main page roughly as it is right now. Basically, that's your BaseS page.

Then you need a separate page which lists Effects, which would be BaseE, a list of Powers, which would be BaseP and possibly also a list of Arguments, which would be BaseA, but that depends on whether the argument values are fixed. I know there are some effect lists lying around, which could help in this.

Once you have all of that together, all you need for the display page is list the spell numbers in the ID column and everything else is retrieved from the Base tables by VLOOKUP functions. Some of those might even need to be conditional, but I don't think so, not in the same way they are in the unit DB. This project would be big enough that it'd need to be a separate document, so it could be called Dom3 Spell DB, I guess. If anyone can get me a half-decent list of the basic effects, just copying the id# and name columns from the BaseU, BaseW and BaseA tables of Dom3DB would give me enough to work with to get a rudimentary legible spell DB ready at a pretty short notice.