Template:5e Monster List: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 2: | Line 2: | ||
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 " | |where={{#if: {{{2|}}}|(5eMonster.Type="{{{1|}}}" AND 5eMonster.Monster_Tags HOLDS "{{{2}}}")|(5eMonster.Type="{{{1|}}}" OR 5eMonster.Monster_Tags HOLDS "{{{1}}}")|}}{{#if: {{{5eh|}}}| AND (Pages_Info.Pointer=0 OR Pages_Info.Pointer IS NULL)| AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL)|}} | ||
|fields=COUNT(5eMonster._pageName) | |fields=COUNT(5eMonster._pageName) | ||
}} {{Type Array|{{#if: {{{2|}}}|{{{2}}}|{{{1}}}}}}} | }} {{Type Array|{{#if: {{{2|}}}|{{{2}}}|{{{1}}}}}}} | ||
| 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 " | |where={{#if: {{{2|}}}|(5eMonster.Type="{{{1|}}}" AND 5eMonster.Monster_Tags HOLDS "{{{2}}}")|(5eMonster.Type="{{{1|}}}" OR 5eMonster.Monster_Tags HOLDS "{{{1}}}")|}}{{#if: {{{5eh|}}}| AND (Pages_Info.Pointer=0 OR Pages_Info.Pointer IS NULL)| AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL)|}} | ||
|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 | ||
|order by=5eMonster.Sort_Text | |order by=5eMonster.Sort_Text | ||
Revision as of 07:16, 13 May 2020
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}}
Cannot access the database: :real_connect(): (HY000/1226): User 'a1618b_wiki5' has exceeded the 'max_user_connections' resource (current value: 10)
Gnolls
Cannot access the database: :real_connect(): (HY000/1226): User 'a1618b_wiki5' has exceeded the 'max_user_connections' resource (current value: 10)
| Monster | Size | Type | Tags | Alignment | HP | CR | Marked | Source |
|---|