Template:5e Monster Data: Difference between revisions

From Rlyehwiki
Jump to navigation Jump to search
No edit summary
mNo edit summary
 
Line 7: Line 7:
tables=5eMonster,Pages_Info
tables=5eMonster,Pages_Info
|join on=5eMonster._pageName=Pages_Info._pageName
|join on=5eMonster._pageName=Pages_Info._pageName
|where=5eMonster.Monster_Name='{{#if: {{{1|}}}|{{{1}}}|{{PAGENAME}} }}' AND ({{#if: {{{hid|}}}|Pages_Info.Pointer=0 OR Pages_Info.Pointer IS NULL|Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL|}})
|where=5eMonster.Monster_Name='{{#if: {{{1|}}}|{{{1}}}|{{PAGENAME}} }}'
|fields=CONCAT( '[[', 5eMonster._pageName, '|', 5eMonster.Monster_Name, ']]' )=Monster,5eMonster.Monster_Size=Size,5eMonster.Type,5eMonster.Monster_Tags=Subtypes,5eMonster.Monster_Alignment=Alignment,5eMonster.Hit_Points=HP,5eMonster.Movement_Type,5eMonster.Challenge_Rating=CR,5eMonster.Monster_Features=Features,5eMonster.Legendary_Monster=Legendary,5eMonster.Has_Lair,5eMonster.NPC, Pages_Info.Canon,Pages_Info.Pointer,Pages_Info.Hidden,Pages_Info.UA,Pages_Info.User,Pages_Info.Sources
|fields=CONCAT( '[[', 5eMonster._pageName, '|', 5eMonster.Monster_Name, ']]' )=Monster,5eMonster.Sort_Text=Sort Text,5eMonster.Monster_Size=Size,5eMonster.Type,5eMonster.Monster_Tags=Subtypes,5eMonster.Monster_Alignment=Alignment,5eMonster.Hit_Points=HP,5eMonster.Movement_Type,5eMonster.Challenge_Rating=CR,5eMonster.Monster_Features=Features,5eMonster.Legendary_Monster=Legendary,5eMonster.Has_Lair,5eMonster.NPC, Pages_Info.Canon,Pages_Info.Pointer,Pages_Info.UA,Pages_Info.User,Pages_Info.Sources
|order by=5eMonster.Sort_Text
|order by=5eMonster.Sort_Text
|limit=10
|limit=10

Latest revision as of 17:09, 12 September 2022

Syntax

{{5e Monster Data|optMonsterName}}

Note: For monster names with an apostrophe ('), you must double the apostrophe ('').



Monster data +

Cannot access the database: :real_connect(): (HY000/1226): User 'a1618b_wiki5' has exceeded the 'max_user_connections' resource (current value: 10)



Monster data +

Cannot access the database: :real_connect(): (HY000/1226): User 'a1618b_wiki5' has exceeded the 'max_user_connections' resource (current value: 10)