Template:5e Adventure Creatures List/Xref UL: Difference between revisions
Jump to navigation
Jump to search
Bandit Giant Centipede Giant Poisonous Snake Giant Weasel Green Slime Hobgoblin Lizardfolk Common Pirate Pirate Bosun Pirate Captain Pirate Deck Wizard Pirate First Mate Pseudodragon Scout Skeletal Alchemist Skeleton Stirge Swarm of Rog Grubs Swarm of Spiders
(Created page with "<includeonly>{{#cargo_query: tables=5e_Adventure_Creature_xRef, 5eMonster |join on=5e_Adventure_Creature_xRef.Creature HOLDS 5eMonster.Monster_Name |where=5e_Adventure_Creature_xRef.Adventure = "{{{1|}}}" |fields=COUNT(5eMonster._pageName) }} creatures in {{{1|}}}. <div style="overflow:auto; font-size:0.8em; max-width:90vw; max-height:90vh; columns:3;"> {{#cargo_query: tables=5e_Adventure_Creature_xRef, 5eMonster, Pages_Info |join on=5e_Adventure_Creature_xRef.Creature H...") |
mNo edit summary |
||
| (3 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
<includeonly>{{#cargo_query: | <includeonly>'''Creatures:'''<br /> | ||
tables=5e_Adventure_Creature_xRef, 5eMonster | {{#cargo_query: | ||
|join on=5e_Adventure_Creature_xRef.Creature HOLDS 5eMonster.Monster_Name | tables=5e_Adventure_Creature_xRef, 5eMonster, Pages_Info | ||
|join on=5e_Adventure_Creature_xRef.Creature HOLDS 5eMonster.Monster_Name, 5eMonster._pageName = Pages_Info._pageName | |||
|where=5e_Adventure_Creature_xRef.Adventure = "{{{1|}}}" AND (5eMonster.Individual = NULL OR 5eMonster.Individual = 0) | |||
|fields=COUNT(5eMonster._pageName) | |||
}} creatures in {{{1|}}}. | |||
<div style="overflow:auto; font-size:0.8em; max-width:90vw; <!--max-height:90vh;--> columns:3;"> | |||
{{#cargo_query: | |||
table=5e_Adventure_Creature_xRef | |||
|where=5e_Adventure_Creature_xRef.Adventure = "{{{1|}}}" | |where=5e_Adventure_Creature_xRef.Adventure = "{{{1|}}}" | ||
|fields=5e_Adventure_Creature_xRef.Creature | |||
|order by=5e_Adventure_Creature_xRef.Creature | |||
<!--|format=ul--> | |||
|format=template | |||
|template=5e Adventure Creatures List/Xref UL Creature | |||
|limit=1000 | |||
|more results text=More Creatures | |||
}} | |||
</div> | |||
'''Individuals:'''<br /> | |||
{{#cargo_query: | |||
tables=5e_Adventure_Creature_xRef, 5eMonster, Pages_Info | |||
|join on=5e_Adventure_Creature_xRef.Creature HOLDS 5eMonster.Monster_Name, 5eMonster._pageName = Pages_Info._pageName | |||
|where=5e_Adventure_Creature_xRef.Adventure = "{{{1|}}}" AND 5eMonster.Individual = TRUE | |||
|fields=COUNT(5eMonster._pageName) | |fields=COUNT(5eMonster._pageName) | ||
}} creatures in {{{1|}}}. | }} creatures in {{{1|}}}. | ||
| Line 9: | Line 32: | ||
tables=5e_Adventure_Creature_xRef, 5eMonster, Pages_Info | tables=5e_Adventure_Creature_xRef, 5eMonster, Pages_Info | ||
|join on=5e_Adventure_Creature_xRef.Creature HOLDS 5eMonster.Monster_Name, 5eMonster._pageName = Pages_Info._pageName | |join on=5e_Adventure_Creature_xRef.Creature HOLDS 5eMonster.Monster_Name, 5eMonster._pageName = Pages_Info._pageName | ||
|where=5e_Adventure_Creature_xRef.Adventure = "{{{1|}}}" | |where=5e_Adventure_Creature_xRef.Adventure = "{{{1|}}}" AND 5eMonster.Individual = TRUE | ||
|fields=5eMonster._pageName,5eMonster.Monster_Name,5eMonster.Type,5eMonster.Individual | |fields=5eMonster._pageName,5eMonster.Monster_Name,5eMonster.Type,5eMonster.Individual | ||
|order by=5eMonster.Sort_Text | |order by=5eMonster.Sort_Text | ||
| Line 26: | Line 49: | ||
==Example== | ==Example== | ||
<pre>{{Template:5e Adventure Creatures List/Xref UL| | <pre>{{Template:5e Adventure Creatures List/Xref UL|The Sinister Secret of Saltmarsh}}</pre> | ||
{{Template:5e Adventure Creatures List/Xref UL|The Sinister Secret of Saltmarsh}} | {{Template:5e Adventure Creatures List/Xref UL|The Sinister Secret of Saltmarsh}} | ||
Latest revision as of 15:40, 19 August 2024
Syntax
{{Template:5e Adventure Creatures List/Xref UL|adventure}}
Normally type is not used and only one subtype is specified.
Example
{{Template:5e Adventure Creatures List/Xref UL|The Sinister Secret of Saltmarsh}}
Creatures:
16 creatures in The Sinister Secret of Saltmarsh.
Individuals:
7 creatures in The Sinister Secret of Saltmarsh.