Template:5e Monster List: Difference between revisions

From Rlyehwiki
Jump to navigation Jump to search
(adjusted "where" to limit selection to 1 and 2 if 2 is not null)
mNo edit summary
 
(25 intermediate revisions by the same user not shown)
Line 1: Line 1:
<noinclude></noinclude><includeonly>{{#cargo_query:
<includeonly>{{#cargo_query:
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 "{{#if: {{{2|}}}|{{{2}}}|{{{1}}}}}")|(5eMonster.Type="{{{1|}}}" OR 5eMonster.Monster_Tags HOLDS "{{#if: {{{2|}}}|{{{2}}}|{{{1}}}}}")|}} AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL)
|where={{#if: {{{2|}}}|(5eMonster.Type="{{{1|}}}" AND 5eMonster.Monster_Tags HOLDS "{{{2}}}")|(5eMonster.Type="{{{1|}}}" OR 5eMonster.Monster_Tags HOLDS "{{{1|}}}")|}}
|fields=COUNT(5eMonster._pageName)
|fields=COUNT(5eMonster._pageName)
}} {{Type Array|{{#if: {{{2|}}}|{{{2}}}|{{{1}}}}}}}
}} {{Type Array|{{#if: {{{2|}}}|{{{2}}}|{{{1}}}}}}}
<div style="overflow:scroll; font-size:0.9em; max-width:80vw; max-height:80vh;">
<div style="display:block; overflow:auto; font-size:0.8em; max-width:75svw; max-height:80vh;">
{|
{|class="zebra sortable"
!Monster
!style="position: sticky; top: 0;"|Monster
!Size
!style="position: sticky; top: 0;"|Size
!Type
!style="position: sticky; top: 0;"|Type
!Tags
!style="position: sticky; top: 0;"|Tags
!Alignment
!style="position: sticky; top: 0;"|Alignment
!HP
!style="position: sticky; top: 0;"|HP
!CR
!style="position: sticky; top: 0;"|CR
!Marked
!style="position: sticky; top: 0;"|Habitat
!Source
!style="position: sticky; top: 0;"|Marked
!style="position: sticky; top: 0;"|Source
|-
|-
{{#cargo_query:
{{#cargo_query:
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 "{{#if: {{{2|}}}|{{{2}}}|{{{1}}}}}")|(5eMonster.Type="{{{1|}}}" OR 5eMonster.Monster_Tags HOLDS "{{#if: {{{2|}}}|{{{2}}}|{{{1}}}}}")|}} AND (Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL)
|where={{#if: {{{2|}}}|(5eMonster.Type="{{{1|}}}" AND 5eMonster.Monster_Tags HOLDS "{{{2}}}")|(5eMonster.Type="{{{1|}}}" OR 5eMonster.Monster_Tags HOLDS "{{{1}}}")|}}
|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,5eMonster.Canon,5eMonster.Pointer,5eMonster.UA,Pages_Info.User,Pages_Info.Sources
|fields=5eMonster._pageName
|order by=5eMonster.Sort_Text
|order by=5eMonster.Sort_Text
|format=template
|format=template
|template=5e Monster List Row
|template=5e Monster Row Preprocess
|limit=1000
|limit=1000
|more results text=More {{Type Array|{{#if: {{{2|}}}|{{{2}}}|{{{1}}}}}}}
|more results text=More {{Type Array|{{#if: {{{2|}}}|{{{2}}}|{{{1}}}}}}}
Line 35: Line 36:


==Example==
==Example==
<pre>{{5e Monster List|Gnoll}}</pre>
<pre>{{5e Monster List|Beholder}}</pre>


{{5e Monster List|Gnoll}}
{{5e Monster List|Beholder}}
 
[[Category:5e Templates]]
</noinclude>

Latest revision as of 17:51, 25 August 2024

Syntax

{{5e Monster List|type|subtype}}

Normally type is not used and only one subtype is specified.

Example

{{5e Monster List|Beholder}}
Cannot access the database: :real_connect(): (HY000/1226): User 'a1618b_wiki5' has exceeded the 'max_user_connections' resource (current value: 10)

Beholders

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 Habitat Marked Source
Retrieved from "https://wiki.rlyehable.com/index.php?title=Template:5e_Monster_List&oldid=24651"