Home of the Odd Duk

Category: Electrum Pieces (Page 56 of 156)

General heading for all RPGs.

Some Problems with Spell Building Systems

I love the idea of spell building systems, but not always the system itself. I absolutely love EABA v1.1 and the Universal Table. Going through the book of spell examples, I found myself building all kinds of magic items and spells. The whole time, I kept thinking that it was cool to be able to quantify just baout anything I could think of.

Then I found that I was beginning to create spells/items/whatever that didn't work. The system usually broke down because the effect was too novel to quantify. I should say that EABA could quantify it, but I felt like that I was shoehorning something that really didn't fit.

When Epic Magic came out for Pathfinder, I discovered Epic Magic for D20. I read them both excited about spell seeds as a building block for new spells. But then the same problem came up. A spell I couldn't really quantify. To make matters worse for me, I found that spells with the same effect made the "trappings" or "special effects" meaningless.

For example, there is a spell on an OSR blog that describes a one-time teleportation effect from one campfire to another campfire some distance away. (My google-fu is weak, I couldn't find it to link to it and give the author credit for coming up with a great spell. Sorry!) I found that using EABA, Epic Magic, or even Open D6 gave me a spell that was no different than a spell that simply teleported the magic-user a random distance away. I liked the idea of the campfire, but found it disappointing that there was really no reason to have the "cool" version because it was more limited than the "generic" version that worked everywhere. Sure, I could houserule the system, but that seemed to be quite daunting, to say the least.

Similarly, even the straight damage spells made the boring versions more useful. Why create a fire missile spell that does 1d6 damage when you already have Magic Missile.  Creatures have immunity to fire, but very few, if any, have immunity to force or whatever substance comprises a Magic Missile. So, there's little reason to use anything but Magic Missile.

This lead my two year long quest to come up with a spell building system that I actually like. Unfortunately, I kept coming back to the same two issues over and over. I could live with effect that couldn't be quantified well, but that whole business that favors generic spells over flavorful or colorful spells seemed to change the whole business from fun to math. I love math, but not the kind that gets into min/maxxing and optimization.

So, I think I'm on to something now that I have come up with reasons for a magic-user to research and/or cast the more flavorful spells. Using the emphases system that I mention a lot around here, a magic-user would choose a more flavorful spell because it would be faster, cheaper, easier and/or more effective than the generic version of the spell. For a different kind of spell caster, the emphases system would also make the colorful versions of spells more likely to suceed than the generic version.

For example, if a magic-user has an emphasis of Fire that provides a bonus to research Fire-based spells, the Fire Missile version of Magic Missile is easier to come up with. For spell casters that use a skill roll to succesfully use spells, a spell caster with a Fire Bonus will find that the Fire Missile is more likely to work compared to Magic Missile.

More than that, if a magic-user has a series of seemingly odd emphases, it is to the spell caster's advantage to find a way to combine as many of these bonuses as possible. When a magic-user has emphases of cold, small round objects, blue, and four, he or she is more likely to cast a spell that begins with four small blue pearls of energy zooming to a target and exploding in a 30 x 30 x 10 cylinder for 1d6/level cold damage rather than a fireball spell. The effect is the same (except that one does cold damage and the other does fire damage), but with all those emphases incorporated into the spell, the magic-user either invented that spell for a song, made it up in record time, or finds it trivial to cast this spell compared to the traditional fireball spell.

Even better, I can put the 30 or so traditional tags associated with spells (like fire, ice, illusion, protection, summon, transform ,etc.) and combine them with 50 or so others I've come up with based on classifiers in other languages (like small round objects, rows, seeds, stalks, thread, charcoal, tubes, etc.) to make a random table. I roll up for or five random emphases and now there is an interesting spell for the players to find on an adventure.

I've posted a bit on my Google+ Page, but I plan to write up details here.

And Now, The SW Monster Database

Last week, I mentioned the SW Monster Database project. At long last, it is finished. After the links below, I'll talk a bit about the spreadsheet.

To download an MS Excel version, click here.

To download an Open Office version, click here.

To add your own creation to the database, click here.

After looking around a bit, you may feel a bit underwhelmed.

Gee John, for all the build-up, it's a list of stats with no monster descriptions.

I get that. I struggled with how to get the descriptions in the spreadsheet easily, but everything up to this point would be days of copy and paste. I'm a bit embarassed to say that as someone that has passing familiarity with awk, sed, bash scripting, and VBA macros. Someone with more skill than me should be able to do it easily.

If you can, please do so. I welcome anything that will make this resource better.

Having said that, I believe I can get the descriptions included without manually pasting them into the submission form. We'll see how that goes. The beauty of the project is that it can grow and continue to add features.

What we can do now is make all kinds of useful tables. Some of the most obvious include a list of monsters by Challenge Level. Download and then Sort by CL and then by Num.

Guess what Challenge Level has the most monsters? CL 5. There are 104 monsters in the SRD with a CL 5. After that, there are 98 monsters with CL 8. Here's the full count.

CL Count
0 2
A 10
B 12
1 50
2 77
3 88
4 93
5 104
6 75
7 75
8 98
9 74
10 65
11 48
12 52
13 59
14 18
15 31
16 14
17 26
18 8
19 9
20 11
21 3
22 4
23 7
24 3
25 2
26 4
27 3
28 4
29 1
30 8
31 3
32 2
33 4
34 4
35 1
36 1
37 2
38 2
39 1
40 5
42 1
varies 12

Most of those varies entries are followers of a specific demon or devil. Later on, I plan to publish a few of those, with full stats.

Other possibilities have been mentioned on G+ already, but with this kind of spreadsheet, you can right a pretty good monster generator. Nothing beats writing one from scratch, but sometimes I need something that is "good enough" for right now. After all, a random encounter is truly random when even you don't know what the next monster around the corner will be.

I'll be adding more to this, but I'll be back to the S&W Magic project for the most part.

Sword & Wizardry Monster Database

Believe it or not, I'm one of the editors for the Swords & Wizardry SRD site. I haven't been able to do much recently, but the Frogs have put in a lot of time entering monsters from the Tome of Horrors Complete and Mosntrosities. There are also a handful of creatures from modules (like the Kamarupa from Splinters of Faith 10) and the Swords & Wizardry complete rule book (like the Giant Vampire Bat).

Recently, Jeff Barrett posted on G+ asking about a master index of all the S&W monsters from the various books. It's something I wanted to do for a long time, but all my attempts to get a project like this started had previously failed. The biggest hindrance was not owning either of the two big monster books.

Yet, when I saw the post, I tried again using only the data on the SRD site. This time I had great success. In about two hours I was able to get a list of 1150+ creatures' stat blocks into a spreadsheet. It wasn't pretty and some of the AC values were in the Attacks column and stuff like that, but it was a spreadsheet that just needed some data work.

That was eleven days ago.

Since then, I have been harkening back to my DBA days cleaning the data to make a good database. Specifically, this means a list of all the monsters from the SRD site with stat blocks, OGL section 15 information, and adding a column for a "catalog name" that allows me to sort the monsters in the same order as they appear on the SRD. Once finished, the monsters will be sortable by AC, HD, Challenge Level, etc. It is a lot of OCD type of work, but it will lead to what I hope is some useful features for all of us.

For example, after the data is all cleaned up, I wil have a field in the spreadsheet that is a one line stat block that you can copy from to paste into your own house rules/modules. Practically, that means finding the monster(s) you want by sorting, searching, and otherwise manipulating the spreadsheet. Then, copying the one line stat block(s) from the spreadsheet into your Word or LibreOffice document.

This will also lead to other benefits like a master index of creatures by Challenge Level. Looking into the future, it can also lead to indexes of creatures by attack type (acid, poison, teleporting victims into an Iron Maiden, etc.) or special abilities (breath weapon, pyromaniac, carousing, etc.).

The final benefit is that with a spreadsheet full of "good" data (I say that as a former DBA, not as a comment on S&W) it becomes easy to input new creatures from all of us. It also means it will be easier for me and others to publish third-party monsters to the SRD.

I have a Google Doc link that I have shared with the other SRD editors with my daily progress. I am still working on the OGL Sec 15 part, but the bulk of the work is done. Now I'm down to stuff like standardizing the Move stat (some monsters are flying 9, others are fly 9 or 9 fly or fly 9 on Tuesdays while flying twelve on February) I'm not going to change any stats, just make them all say fly 9 or swim 10 instead of fifteen other ways to say how fast a creature flies or swims.

To give you an idea what it look like at this point, here's a screen capture of the Giant Aardvark entry:
swmonsterspread

For what it is worth, I don't include any monsters from Tome of Horrors 4 or the Rappan Athuk bestiary because I don't own either one yet. I'm one of those folks that will file my taxes on the first possible day (Jan 31st) so maybe I'll be able to buy it soon.

I haven't forgotten about the Magic project and I have drafts of posts for it. Since Sum Bach o Hud, the magic systems book, is a goal for all of 2014, I decided to let my weakness for spreadsheets take over long enough to get this done.

« Older posts Newer posts »

© 2026 Sycarion Diversions

Theme by Anders NorenUp ↑