Template:5e Monster List: Difference between revisions
mNo edit summary |
mNo edit summary |
||
| Line 20: | Line 20: | ||
tables=5eMonster, Pages_Info | tables=5eMonster, Pages_Info | ||
|join on=5eMonster._pageName=Pages_Info._pageName | |join on=5eMonster._pageName=Pages_Info._pageName | ||
|where={{#if: {{{2|}}}|(5eMonster.Type="{{{1|}}}" AND 5eMonster.Monster_Tags HOLDS "{{{2}}}")|(5eMonster.Type="{{{1|}}}" OR 5eMonster.Monster_Tags HOLDS "{{{1}}}" | |where={{#if: {{{2|}}}|(5eMonster.Type="{{{1|}}}" AND 5eMonster.Monster_Tags HOLDS "{{{2}}}")|(5eMonster.Type="{{{1|}}}" OR 5eMonster.Monster_Tags HOLDS "{{{1}}}")|}} | ||
|fields=5eMonster._pageName | |fields=5eMonster._pageName | ||
<!--|fields=5eMonster._pageName,5eMonster.Monster_Name,5eMonster.Monster_Size,5eMonster.Type,5eMonster.Monster_Tags,5eMonster.Monster_Alignment,5eMonster.Hit_Points,5eMonster.Hit_Dice,5eMonster.Challenge_Rating,5eMonster.Experience_Points,5eMonster.Monster_Features,Pages_Info.Canon,Pages_Info.Pointer,Pages_Info.UA,Pages_Info.User,Pages_Info.Sources,Pages_Info.Hidden--> | <!--|fields=5eMonster._pageName,5eMonster.Monster_Name,5eMonster.Monster_Size,5eMonster.Type,5eMonster.Monster_Tags,5eMonster.Monster_Alignment,5eMonster.Hit_Points,5eMonster.Hit_Dice,5eMonster.Challenge_Rating,5eMonster.Experience_Points,5eMonster.Monster_Features,Pages_Info.Canon,Pages_Info.Pointer,Pages_Info.UA,Pages_Info.User,Pages_Info.Sources,Pages_Info.Hidden--> | ||
| Line 43: | Line 43: | ||
{{5e Monster List|Gnoll}} | {{5e Monster List|Gnoll}} | ||
</noinclude> | |||
Revision as of 16:58, 23 May 2022
Syntax
{{5e Monster List|type|subtype}}
Normally type is not used and only one subtype is specified.
Add'l Fields
|5eh= <!--blank, true if 5eh. Used by Admin only-->
Example
{{5e Monster List|Gnoll}}
Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5eMonster`.`_pageID` AS `cargo_backlink_page_id_5eMonster`,COUNT(`rly2_cargo__5eMonster`.`_pageName`) AS `_pageName)` FROM `rly2_cargo__5eMonster` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5eMonster`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE (`rly2_cargo__5eMonster`.`Type`="Gnoll" OR `rly2_cargo__5eMonster`.`_ID` IN (SELECT `_rowID` FROM `rly2_cargo__5eMonster__Monster_Tags` WHERE `_value`= "Gnoll") )AND (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL) ORDER BY `rly2_cargo__Pages_Info`.`_pageID`,`rly2_cargo__5eMonster`.`_pageID`,COUNT(`rly2_cargo__5eMonster`.`_pageName`) LIMIT 100
Gnolls
| Monster | Size | Type | Tags | Alignment | HP | CR | Marked | Source | |
|---|---|---|---|---|---|---|---|---|---|
| Gnoll Overview | Overview | Humanoid, Gnoll | Noncanon | Varied | |||||
| Gnoll | Medium | Humanoid | Gnoll | Chaotic Evil | 22 | 1/2 | Desert, Forest, Grassland, Hill | Canon | SRD-OGL v5.1 |
| Gnoll Fang of Yeenoghu | Medium | Fiend | Gnoll | Chaotic Evil | 49 | 4 | Desert, Forest, Grassland, Hill | Canon, Pointer | Monster Manual (5e) |
| Gnoll Pack Lord | Medium | Humanoid | Gnoll | Chaotic Evil | 49 | 2 | Desert, Forest, Grassland, Hill | Canon, Pointer | Monster Manual (5e) |
| Gnolloch | Medium | Humanoid | Gnoll, Gnolloch | any alignment | 17 | 1/4 | Arctic, Coastal, Forest, Grassland, Hill | Noncanon, User Creation | Rlyehable |
| Gnolloch Bandit or Pirate | Medium | Humanoid | Gnoll, Gnolloch | Any Non-Lawful Alignment | 9 | 1/8 | Arctic, Coastal, Forest, Grassland, Hill | Noncanon, User Creation | Rlyehable |