Difference between revisions of "Template:MonsterListLinks"

From Epic Paths
Jump to navigation Jump to search
(Created page with "<noinclude> One (and only one) of the following * type: type that should be included * where: a where statement <hr> <nowiki>{{</nowiki>MonsterListLinks|type=magical beast<n...")
 
 
(One intermediate revision by the same user not shown)
Line 1: Line 1:
<noinclude>
<noinclude>
One (and only one) of the following
One of:


* type: type that should be included
* type: type that should be included
* subtype: type that should be included
* where: a where statement
* where: a where statement


Line 10: Line 11:
{{MonsterListLinks|type=magical beast}}
{{MonsterListLinks|type=magical beast}}


<nowiki>{{</nowiki>MonsterListLinks|where=Subtypes HOLDS "human"<nowiki>}}</nowiki>
<nowiki>{{</nowiki>MonsterListLinks|subtype=undead<nowiki>}}</nowiki>


{{MonsterListLinks|where=Subtypes HOLDS "human"}}
{{MonsterListLinks|subtype=undead}}
 
<nowiki>{{</nowiki>MonsterListLinks|where=Type = "humanoid" AND Subtypes HOLDS "human"<nowiki>}}</nowiki>
 
{{MonsterListLinks|where=Type = "humanoid" AND Subtypes HOLDS "human"}}


</noinclude><!--
</noinclude><!--


--><includeonly>{{#vardefine:where|{{{where|Type = "{{{type}}}"}}}}}<!--
--><includeonly>{{#vardefine:where|{{{where|<!--
  -->{{#if: {{{type|}}}|Type = "{{{type}}}"|<!--
    -->{{#if: {{{subtype|}}}|Subtypes HOLDS "{{{subtype}}}"|}}<!--
  -->}}<!--
-->}}}}}<!--
 
-->{{Grid|type=begin|border=true|cols=1}}
-->{{Grid|type=begin|border=true|cols=1}}
{{#cargo_query:tables=Monsters
{{#cargo_query:tables=Monsters

Latest revision as of 14:31, 20 November 2021

One of:

  • type: type that should be included
  • subtype: type that should be included
  • where: a where statement

{{MonsterListLinks|type=magical beast}}

Error 1055: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'my_wiki.cargo__Monsters._pageName' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by (localhost)

Function: CargoSQLQuery::run Query: SELECT CONCAT( '', Name, '' ) AS `LinkName`,`CR` AS `CR`,`XP` AS `XP` FROM `cargo__Monsters` WHERE Type = "magical beast" GROUP BY `Name` ORDER BY `XP`,`Name` LIMIT 100

{{MonsterListLinks|subtype=undead}}

Error 1055: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'my_wiki.cargo__Monsters._pageName' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by (localhost)

Function: CargoSQLQuery::run Query: SELECT CONCAT( '', Name, '' ) AS `LinkName`,`CR` AS `CR`,`XP` AS `XP` FROM `cargo__Monsters` WHERE `cargo__Monsters`.`_ID` IN (SELECT `_rowID` FROM `cargo__Monsters__Subtypes` WHERE `_value`= "undead") GROUP BY `Name` ORDER BY `XP`,`Name` LIMIT 100

{{MonsterListLinks|where=Type = "humanoid" AND Subtypes HOLDS "human"}}

Error 1055: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'my_wiki.cargo__Monsters._pageName' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by (localhost)

Function: CargoSQLQuery::run Query: SELECT CONCAT( '', Name, '' ) AS `LinkName`,`CR` AS `CR`,`XP` AS `XP` FROM `cargo__Monsters` WHERE Type = "humanoid" AND `cargo__Monsters`.`_ID` IN (SELECT `_rowID` FROM `cargo__Monsters__Subtypes` WHERE `_value`= "human") GROUP BY `Name` ORDER BY `XP`,`Name` LIMIT 100


Retrieved from "http://epicpaths.games/epicpaths/index.php?title=Template:MonsterListLinks&oldid=2865"