Monster Database

[Charon]

Introducing the Official DndGamer.net Monster Database.
Monster Database

This is a work in progress. Please read the following important information.

Database currently contains 226 monsters from MM1 beginning with A-D. Monsters are currently searchable by Name, CR, Size and Type. Subtypes are a work in progress and do not currently filter the results! Filters for Alignment, Home Plane, Environment and Book will follow. If the page is down, assume I am updating it, functionality will return.

This database does not contain monster stats. It is an index allowing you to filter monsters by categories in order to get a list of monsters that match your criteria along with a book and page number for easy lookup. The goal here is to recreate the functionality of DnDrunde.de which I used to use for this purpose and sadly no longer exists.
It's ugly, prettying it up will be the last step. Functionality first.

The code is messy and may get tidied up as the project grows. Last week I couldn't tell you a single thing about php, so I am completely new to coding this sort of thing. I am also filling the database by hand. The chances of me inputting over two thousand monsters without making a mistake are slim so if you do notice anything incorrect about an entry, please post here so I can amend. As for page number alignment, where possible, the number listed is the page the monster's stat block appears on, not where their entry begins. These don't always perfectly align (the dragon tables don't conform to normal standards) so if a stat block straddles a page, assume the block that gives their type is the start of their page.

I will update this thread as significant progress is made.

[Charon]

Subtype search now functions in an OR position.
To wit, searching Air and Extraplanar will return monsters that are air, monsters that are extraplanar and monsters that are air and extraplanar. I've spent two days damn near ripping my dick off getting this working. AND functionality will follow when I figure out how the hell that's gonna work.
Database contains monsters A-E.

[Charon]

Making some major updates to the table to account for alignment and book lookups. Results might be odd for a couple of days while I sort this out and realign everything but this will expedite the rest of the code.
Database contains monsters A-G from MM1.

EDIT: Database back online. Please report any unusual statistics. Ability to filter by alignment has been added. True Neutral will be displayed as Neutral Neutral until I figure out how to override it.

Further EDIT: Filter by Environment and Home Plane is now functional. Environment Any will show as Any Any until I figure out how to override it.

Final EDIT (for this post):
Filter by book is added. Note that database currently only contains monsters from MM1, beginning with A-K.

All that remains is to work out the AND logic for subtypes, add in the monsters and pretty it up with some CSS.

[Charon]

Finally. I figured out the AND logic.
All searches now functional. Database contains MM1 from A-S.
Will slowly work on prettifying it as I fill it up.

It is still returning some testing syntax like the Array header, I will clear that up somewhere down the line.

[Charon]

Entire MM1 is now in database. 602 monsters.
Started inputting MM2. It's a great book, but obviously cursed with some 3.0 decisions so I am applying common sense logic to its entries, specifically, reverting all beast types back to animal and putting things on their correct Home Plane, so The Abyss for Demons and the Hells for Devils, for example. Where possible I've consulted the official MM2 update documentation but I've still had to add some common sense things in like giving the planetouched the native subtype, a seeming oversight.

Edit: MM2 added. Database now stands at 865 monsters.

[Charon]

MM3 added. Database contains 1049 monsters.
All errata factored in.

[Charon]

MM4 added. Database contains 1160 monsters.

[Charon]

Things I have done.

The Githyanki presented in the MM4 and the Illithid presented in the MM5 do not have psionics listed as a special attack. Their spell-like abilities are not listed as psionics. Neither do they have any side bar suggesting psionic use, beyond one use of the word psionic in the Thoon fluff. As such, in lines with those MMs, I have not assigned them the psionic subtype. Personally, I find Wizards' abandonment of Psionics to be a disgrace but to be fair, I've never met anyone with the slightest interest in Psionics other than myself, which is bizarre because psions are so freaking cool.
Anyways. I am open to a discussion on whether these creatures deserve the psionic subtype.

Another troublesome monster is the Spawn of Juiblex which is the only creature listed as living on the Demiplane of Filth. It seems unnecessary to add this as a filter for one monster and so, as it is a demiplane born of the Plane of Water, I have assigned them there.

Another thing I'm interested in is what to do about monsters that have had a revision. For example. The Fang Dragon exists both in Monsters of Faerun and in the Draconomicon. Should we just include the newer source? Or for the sake of completeness shall we include both entries?
Why don't the MM1 eladrins have the chaotic subtype like other eladrins?

Monster Manual 5 is complete.
Database contains 1259 monsters.

Book of Exalted Deeds added.
Database contains 1321 monsters.

[Charon]

Book of Vile Darkness added, what a mess that book is. Will add filters for the two new books when I get a moment.
Database contains 1399 monsters.

We hit our first dupe so for the sake of completeness, I tagged the extra Babau Demon with (BOVD Revision) in its name. Where possible I will list dupes with the appropriate book code and either 'revision' if the dupe is a newer source or 'original' if the dupe is an older source as I am going through books alphabetically not publication order in order to keep track of where I'm up to. If there's ambiguity about the dates or more than one iteration I'll simple list the second instance as 'version'.

Working on City of Splendors: Waterdeep, adding in anyone who has a CR rating.
Waterdeep added.
Database contains 1424 monsters.

Cityscape added.
Database contains 1458 monsters.

Deities and Demigods added.
Database contains 1467 monsters.
Note I have not added the gods as they do not have a CR. Nor have I added animal companions of gods such as Thor's goats. I have included all other monsters that appear. Basically a smattering of Egyptian, Nordic and Greek mobs with one thing from the Positive Energy plane.

[Charon]

Draconomicon added.
Database contains 1646 monsters.
That was a lot of freaking dragons.

I have not included the sample dragons on the basis that they are all just the MM dragons with elite score arrays over standard and if you're running a campaign so dragon-heavy that you need elite array dragons then you really should be perusing the whole Draconomicon anyway.

Drow of the Underdark added.
Database contains 1714 monsters.

Dungeonscape added.
Database contains 1725 monsters.

DMG2 added.
Database contains 1738 monsters.

Eberron Campaign Setting added with some caveats. Not added Quori subtype for one monster, nor symbiont for three. Also not added two planes for the two monsters that live offworld in Eberron's unique cosmology so those are assigned to the material. Not included the level 2 unnamed warforged from the adventure nor the two recurring villains that are given multiple stat blocks for different levels. Everything else is in.
Database contains 1809 monsters.

Started on Epic Level Handbook. Abominations have had their dual typing removed as I didn't set it up that way, so the two that do that have had the Outsider type removed.
EDIT: Man what a mess this book is. XD Fixed a couple of dodgy entries that weren't corrected in the errata (Monster with Shapechanger type when it should be Aberration with Shapechanger subtype, for example).
ELH fully added.
Database contains 1925 monsters.

Exemplars of Evil added. Skipped a few that were just normal monsters with names (and in some cases extra hit dice but not class levels). Also skipped anything that already exists in other books as these are not revisions, just reprints.
Database contains 1972 monsters.

[Charon]

Expanded Psionic Handbook added.
Database contains 2015 monsters.

Faiths and Pantheons added.
Database contains 2029 monsters.

[Charon]

Fiend Folio added.
Database contains 2197 monsters.

Frostburn added.
Database contains 2280 monsters.

Fiendish Codex 1: Hordes of the Abyss added.
Loumara subtype added.
Database contains 2310 monsters.

Started adding Tyrants. We have a new contender for worst book. So far we have an aasimar monk who is chaotic good (monks must be lawful) and the Hell Louse which is a Vermin with the subtypes magical beast and fiendish... neither of which are valid subtypes. Magical Beast is a type and fiendish is not a thing. After some debate, I've altered the Hell Louse to be a Magical Beast with the Augmented Vermin subtype. Left the monk as is.

EDIT: More clarification on the Hell Louse.
It has mostly Vermin traits. Its BAB is 3/4 prog as per vermin as opposed to full for magical beast. It has a strong Fort save as vermin and not strong fort/ref as per magical beast.
However, it definitely has some magical beast traits, specifically an intelligence score of 3 and a supernatural ability.
It has 36 HP with 6 of that derived from con mod. This leaves 30hp to account for. Monsters are usually given average across the board (only players and special NPCs get full HP for first HD). The average for vermin (6d8) would be 28 hp. The average for a magical beast (6d10) would be 36. It also has the toughness feat, which gives it 3 extra HP.
Jesus. Well, if it was a Vermin, it would have 37HP which is as close as we're getting.
So ultimately, it has mostly vermin traits, if poorly calculated, but the fact that it deviates into magical beast territory, especially with the intelligence of 3 which gives it "humanlike intelligence" beyond the animal intelligence of 1 or 2 leave no doubt that it has to be considered a magical beast.
This is my justification. :) Thank you for coming to my ted talk.

No progress neatening it up. Cannot get the javascript functioning and really struggling to add a horizontal line between results.
EDIT: Figured out the horizontal line. Got some javascript toggling working so will slowly begin to add instructions to the sections.
Went with a lighter shade of brown, added help texts. Plenty more tidying up to do.
I hate coding. :)

Fiendish Codex II: Tyrants of the Nine Hells added.
Database contains 2350 monsters.

[Charon]

FRCS added.
Database contains 2399 monsters.

[Charon]

Heroes of Battle added.
Database contains 2463 monsters.

Fixed error with book lookup returning surplus entries.

I broke it again, will fix it when I get time.

Fixed it again, will break it when I get time. ¬¬

[Charon]

Been a while. Libris Mortis is now fully added.
Database contains 2593 monsters.

[Charon]

Lords of Madness added. Database contains 2655 monsters.

Magic of Faerun added. Database contains 2668 monsters.

[Charon]

Magic of Incarnum added.
Database contains 2726 monsters.

[Charon]

Massive update to the code. I would really appreciate any feedback.
Link is here again for your convenience:
mlookup.php

Here's some info.

• PHP code optimised to form queries to filter from database rather than pulling the whole DB and then filtering. If you noticed any slowness before, especially when using multiple filters, that should be resolved.
• Colours rechosen to improve readable visibility with high contrast ratio. I am super interested if you guys like or hate this or have any suggestions, as this is one of the trickier areas for me.
• Slight redesigns on buttons and presentation of results. How do you feel about how the results are displayed?
• Overrides on some parameters. Neutral Neutral alignment now returns True Neutral. Any Any environment/climate now returns Any. Subtypes and alignments now have spaces between commas.
• Get replaced with Post so the url remains clean.

Feel free to stress test it a little. Try some super specific searches and see if the results satisfy.

Still to do.
Return "no results found" when no results are found.
Retain form data for tweaking. (clear button for no tweaks? toggle?)
Add Spaces where multiple home planes are returned.

[Charon]

Side note while working on Manual of the Planes:

The Dao is listed with an Air subtype in MOTP. This was not corrected in errata, but clearly this is an error and it should be Earth. The monster database will return the Dao under the Earth subtype as intended.
Evidence for this is the fact that Dao are earth based in mythology, they speak Terran but not Auran, they look earthy (copper skin tone), are native to the elemental plane of earth and have the special attack Earth Mastery and an array of earth based spells.

Wood Element template.
There is no wood subtype and I doubt many people run an elemental plane of wood, so this has been sorted under the plant type and material plane as per instructions in the flavour text.

Energons are listed as incorporeal outsiders in the book but were made standard elementals in the errata. The database will reflect the errata typing but will keep the incorporeal subtype, as the flavour text makes it clear they are intended to be incorporeal. In fact, despite having a subtype column the errata seems to completely ignore subtypes so all erratad monsters will retain their subtyping in the database.
Thank you for coming to my ted talk.

Manual of the Planes added.
Database contains 2789 monsters.

[Charon]

Note for Monsters of Faerun

• Any creatures with the "Beast" type will return under "Animal" type for consistency.
• Beast of Malar changed from Type "Shapechanger" to Type "Magical Beast", Subtype "Shapechanger".
• Doppelganger, Greater changed from Type "Shapechanger" to Type "Monstrous Humanoid", Subtype "Shapechanger".
• Shadow Dragons have the "Shadow" subtype which does not exist. This has been removed and their home plane noted as Material/Shadow in line with their revised counterparts.
• Song Dragons have the Electricity subtype, which does not exist. Blue dragons have lightning breath and are Earth type, but Bronze have lightning breath and are water type. Storm elementals and storm drakes are air type. I'm open to discussion on this but for now, I have left them without a subtype as I see no particular affinity in their stat blocks.
• Player races, such as Dwarves, have only partial stat blocks and as such have been left out.
• Gibberlings have the gibberling subtype. What the actual fuck? What even are these things? XD For now, I've left them with no subtype.
• Malaugrym type changed to Aberration, subtype Shapechanger. This is also one of those rare cases where I have set the Home Plane to none as the flavour text clearly states they are native to some alien place and do not live on the Material nor Shadow Plane despite predominantly being encountered there.
• Nishruu set to home plane: None.
• Planetouched have no native subtype but I have left them this way for contrast with their revised counterparts. Could change this if people think it makes more sense to keep them up to date regardless.

Monsters of Faerun added.
Database contains 2940 monsters.

[Charon]

Notes for Oriental Adventures:

• This book adds the "Spirit" and "Shadowlands" subtypes. I'm not adding these in for the sake of one book, especially one so unlikely to be used. I figure if you're running Rokugan, you'd be looking through this as your primary MM anyway, so such a filter is unnecessary, and if you're looking to use these monsters in a non-Rokugan campaign then you're probably not looking by spirit/shadowlands subtype.
• As with previous 3e books, beasts and shapechangers will be recategorised accordingly, in line with revisions, or, if unique, in line with general consensus or common sense.
• Monsters with a climate/terrain of "Shadowlands" will be returned under "Any Land".
• Outsiders are largely given the material plane as their home plane, as the way this system handles them they are essentially spirits.
• The Dokufu is listed as both huge and medium. The flavour text notes that the Huge monstrous spider is its natural form and thus this monster will return under Huge. There is no official conversion of this monster so type has been changed to Magical Beast.
• Hengeyokai. The text makes it clear that these are animals in their natural form but with humanlike intelligence. Thus their type has been set to Magical Beast.
• The art in this book is awesome. Give it a look if you haven't.

Oriental Adventures added.
Database contains 3072 monsters.

[Charon]

Planar Handbook added.
Database contains 3122 monsters.