View Single Post
  #20  
Old October 10th, 2007, 05:01 PM
Edi's Avatar

Edi Edi is offline
National Security Advisor
 
Join Date: Oct 2003
Location: Helsinki, Finland
Posts: 5,425
Thanks: 174
Thanked 695 Times in 267 Posts
Edi is on a distinguished road
Default Re: Code diving

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.
Reply With Quote