Template:5e Monster Data: Difference between revisions

From Rlyehwiki
Jump to navigation Jump to search
mNo edit summary
m (wip)
Line 1: Line 1:
<includeonly>
<includeonly>
----
----
'''Spell data:'''<br />
'''Monster data:'''<br />
<div style="overflow:auto; width:100%; font-size:0.75em;">
<div style="overflow:auto; width:100%; font-size:0.75em;">
{{#cargo_query:
{{#cargo_query:
tables=5eMonster,Pages_Info
tables=5eMonster,Pages_Info
|join on=5eMonster.Page_Name=Pages_Info.Page_Name
|join on=5eMonster.Page_Name=Pages_Info.Page_Name
|where={{#if: {{{1|}}}|5eMonster.Monster_Name='{{{1}}}'|5eMonster.Monster_Name={{PAGENAME}}|}}
|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.Challenge_Rating=CR,5eMonster.Legendary_Monster=Legendary,5eMonster.Has_Lair,5eMonster.NPC, 5eMonster.Canon,5eMonster.Pointer,5eMonster.Hidden,5eMonster.UA,Pages_Info.Sources
|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.Challenge_Rating=CR,5eMonster.Legendary_Monster=Legendary,5eMonster.Has_Lair,5eMonster.NPC, 5eMonster.Canon,5eMonster.Pointer,5eMonster.Hidden,5eMonster.UA,Pages_Info.Sources
|order by=5eMonster.Sort_Text
|order by=5eMonster.Sort_Text
Line 14: Line 14:
|default=Not Found
|default=Not Found
}}
}}
<!--{{#cargo_query:
{{#cargo_query:
tables=5eMonster,5e_Features
tables=5e_Features
|join on=5eMonster.Page_Name=5e_Features.Page_Name
|where=Page_Name={{FULLPAGENAME}}
|where={{#if: {{{1|}}}|5eMonster.Monster_Name='{{{1}}}'|5eMonster.Monster_Name={{PAGENAME}}|}}
|fields=5e_Features.Features
|fields=CONCAT( '[[', 5eMonster._pageName, '|', 5eMonster.Monster_Name, ']]' )=Monster,5e_Features.Features
|order by=5eMonster.Sort_Text
|limit=100
|limit=100
|format=table
|format=table
|more results text=More Monsters
|more results text=More Features
|default=Not Found
|default=Not Found
}}--></div></includeonly><noinclude>
}}</div></includeonly><noinclude>
===Syntax===
===Syntax===
<pre>{{5e Monster Data|optMonsterName}}</pre>
<pre>{{5e Monster Data|optMonsterName}}</pre>

Revision as of 07:31, 1 March 2020

Syntax

{{5e Monster Data|optMonsterName}}

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


Monster data:

Error: No field named "Canon" found for the database table "5eMonster".
Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ':5e Monster Data ORDER BY `rly2_cargo__5e_Features`.`_pageID`,`rly2_cargo__5e_F' at line 1

Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__5e_Features`.`_pageID` AS `cargo_backlink_page_id_5e_Features`,`Features__full` AS `Features` FROM `rly2_cargo__5e_Features` WHERE Page_Name=Template:5e Monster Data ORDER BY `rly2_cargo__5e_Features`.`_pageID`,`rly2_cargo__5e_Features`.`Features__full` LIMIT 100


Monster data:

Error: No field named "Canon" found for the database table "5eMonster".
Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ':5e Monster Data ORDER BY `rly2_cargo__5e_Features`.`_pageID`,`rly2_cargo__5e_F' at line 1

Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__5e_Features`.`_pageID` AS `cargo_backlink_page_id_5e_Features`,`Features__full` AS `Features` FROM `rly2_cargo__5e_Features` WHERE Page_Name=Template:5e Monster Data ORDER BY `rly2_cargo__5e_Features`.`_pageID`,`rly2_cargo__5e_Features`.`Features__full` LIMIT 100

Retrieved from "https://wiki.rlyehable.com/index.php?title=Template:5e_Monster_Data&oldid=3613"