- Lawful: Will never use a desire path.
- Neutral: Will use a pre-existing desire path.
- Chaotic: Will start a new desire path.
Desire path (Wikipedia).
Math, history, and design of old-school D&D
Question: In what proportion do Gygaxian magic-users tend to prepare spells of different use-cases, such as offensive, defensive, or miscellaneous types?
This may be of interest in loading out wizard-types in the same sensibility as the original game designer. Obviously it doesn't make sense for wizards to sit around without any martial spells at all, nor would it make for an interesting game. On the other hand, there seems a need for wizards to have some spells usable for things like information-gathering and research, since presumably they are engaged in that most days in their lair, not combat.
"So, then, does a threatened cleric cast a know alignment spell upon an aggressor? Or a hold person? Obviously, the latter choice is far more logical in 99% of the cases..." (AD&D DMG, p. 105)
(ODS spreadsheet here.)
Conclusions: We found 18 magic-user types in this search. Broadly speaking, looking at the total percentages in the lower-right of the table, we can say that offensive-defensive-miscellaneous spells appear in a ratio of about 3:2:1 (suitable for d6 rolls). Initially I expected a higher proportion of the miscellaneous type at the lower levels, but this is not borne out: e.g., percentages for offensive spells by level run 62-42-59-62-45-60%, with no consistent pattern. Follow-up questions could be to detect patterns in load-out in terms of relative highest level per caster, or for bias compared to overall proportions in the rulebook spell roster, but these seem unlikely to be productive.
One thing I did look at was the few cases where spell books are specified for these magic-users, beyond just the spells they have memorized (N = 4; Burne, Falrinth, Deggum, and Senshock). In these cases, the proportions seem flipped for the additional spells: roughly in proportion 1:2:3. The number of added spells in one's book varies between about 100% and 200%, with an average close to 150% (somewhat higher than I might have initially guessed).
It should be pointed out that my list only includes spell levels 1-6, because (a) I'm mostly interested in the context of use for an OD&D game, and (b) only one caster in the series above has spell levels 7-9 (namely the lich Asberdies lurking in D1). Another observation is that the total number of detailed magic-users is itself smaller than I might have expected; to a large degree, Gygax's go-to spellcasting bad guys are predominantly evil clerics. (e.g., temple in B2, Lareth in T1, commander in T2, female Drow leaders in GDQ, etc., etc.). This is somewhat interesting in contrast with the near-nonexistence of spellcasting priest-types in the pulp literature (which I've written about on this blog too many times to count).
Image courtesy of Craiyon.