Difference between revisions of "Template:MonsterQuery"
| (One intermediate revision by the same user not shown) | |||
| Line 2: | Line 2: | ||
<!--{{MonsterQuery|CR=1|Race=human}}--> | <!--{{MonsterQuery|CR=1|Race=human}}--> | ||
{{MonsterQuery| | {{MonsterQuery|Subtype=undead}} | ||
{{#cargo_attach:_table = Monsters}} (It actually doesn't. It is used to query the table.)</noinclude><includeonly><!-- | {{#cargo_attach:_table = Monsters}} (It actually doesn't. It is used to query the table.)</noinclude><includeonly><!-- | ||
| Line 15: | Line 15: | ||
-->{{#if:{{{Size|}}}|(Size= "{{{Size}}}") AND }}<!-- | -->{{#if:{{{Size|}}}|(Size= "{{{Size}}}") AND }}<!-- | ||
-->{{#if:{{{Type|}}}|(Type= "{{{Type}}}") AND }}<!-- | -->{{#if:{{{Type|}}}|(Type= "{{{Type}}}") AND }}<!-- | ||
-->{{#if:{{{Subtype|}}}|(Subtypes HOLDS "{{{ | -->{{#if:{{{Subtype|}}}|(Subtypes HOLDS "{{{Subtype}}}") AND }}<!-- | ||
-->{{#ifeq:{{{Climate|}}}|Any|(Climate HOLDS "Any") AND }}<!-- | |||
-->{{#if:{{{Climate|}}}|(Climate HOLDS "Any" OR Climate HOLDS "{{#replace:{{{Climate}}}|,|" OR Climate HOLDS "}}") AND }}<!-- | -->{{#if:{{{Climate|}}}|(Climate HOLDS "Any" OR Climate HOLDS "{{#replace:{{{Climate}}}|,|" OR Climate HOLDS "}}") AND }}<!-- | ||
-->{{#ifeq:{{{Terrain|}}}|Any|(Terrain HOLDS "Any") AND }}<!-- | |||
-->{{#if:{{{Terrain|}}}|(Terrain HOLDS "Any" OR Terrain HOLDS "{{#replace:{{{Terrain}}}|,|" OR Terrain HOLDS "}}") AND }}<!-- | -->{{#if:{{{Terrain|}}}|(Terrain HOLDS "Any" OR Terrain HOLDS "{{#replace:{{{Terrain}}}|,|" OR Terrain HOLDS "}}") AND }}<!-- | ||
-->{{#ifeq:{{{Regions|}}}|All|(Regions HOLDS "All") AND }}<!-- | |||
-->{{#if:{{{Regions|}}}|(Regions HOLDS "All" OR Regions HOLDS "{{#replace:{{{Regions}}}|,|" OR Regions HOLDS "}}") AND }}<!-- | -->{{#if:{{{Regions|}}}|(Regions HOLDS "All" OR Regions HOLDS "{{#replace:{{{Regions}}}|,|" OR Regions HOLDS "}}") AND }}<!-- | ||
-->{{#if:{{{ActivityCycle|}}}|(ActivityCycle= "{{{ActivityCycle}}}") AND }}<!-- | -->{{#if:{{{ActivityCycle|}}}|(ActivityCycle= "{{{ActivityCycle}}}") AND }}<!-- | ||
Latest revision as of 07:36, 27 December 2021
{{MonsterQuery|CR=1|Race=human}}
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") ) AND(1) GROUP BY `Name` ORDER BY `XP`,`Name` LIMIT 100
Function: CargoSQLQuery::run Query: SELECT `_pageName` AS `Page`,`Name` AS `Name`,`Fluff` AS `Fluff`,`Alignment` AS `Alignment`,`Size` AS `Size`,`Type` AS `Type`,`Subtypes__full` AS `Subtypes`,`CR` AS `CR`,`XP` AS `XP`,`Init` AS `Init`,`Perception` AS `Perception`,`Senses` AS `Senses`,`Speed` AS `Speed`,`hp` AS `hp`,`hpBonus` AS `hpBonus`,`AC` AS `AC`,`TouchAC` AS `TouchAC`,`FlatfootedAC` AS `FlatfootedAC`,`ACBonus` AS `ACBonus`,`Fort` AS `Fort`,`Reflex` AS `Reflex`,`Will` AS `Will`,`saveBonus` AS `saveBonus`,`SR` AS `SR`,`DR` AS `DR`,`CMB` AS `CMB`,`AltCMB` AS `AltCMB`,`CMD` AS `CMD`,`AltCMD` AS `AltCMD`,`MMD` AS `MMD`,`AltMMD` AS `AltMMD`,`Tenacity` AS `Tenacity`,`AltTenacity` AS `AltTenacity`,`SP` AS `SP`,`MSB` AS `MSB`,`AltMSB` AS `AltMSB`,`MSD` AS `MSD`,`AltMSD` AS `AltMSD`,`Concentration` AS `Concentration`,`Immune` AS `Immune`,`StandardActions` AS `StandardActions`,`FullroundActions` AS `FullroundActions`,`MoveActions` AS `MoveActions`,`SwiftActions` AS `SwiftActions`,`ImmediateActions` AS `ImmediateActions`,`FreeActions` AS `FreeActions`,`SpecialQualities` AS `SpecialQualities`,`Skills` AS `Skills`,`Strength` AS `Str`,`Dexterity` AS `Dex`,`Constitution` AS `Con`,`Intelligence` AS `Int`,`Wisdom` AS `Wis`,`Charisma` AS `Cha`,`Equipment` AS `Equipment` FROM `cargo__Monsters` WHERE (`cargo__Monsters`.`_ID` IN (SELECT `_rowID` FROM `cargo__Monsters__Subtypes` WHERE `_value`= "undead") ) AND(1) GROUP BY `Name` ORDER BY `Name` LIMIT 100
This template adds rows to the table "Monsters", which is declared by the template Monster. View table. (It actually doesn't. It is used to query the table.)