Difference between revisions of "Template:MonsterQuery"
| Line 1: | Line 1: | ||
<noinclude>{{ | <noinclude>{{MonsterQuery|CR=1}} | ||
{{ | {{#cargo_attach:_table = Monsters}}</noinclude><includeonly><!-- | ||
-->{{#vardefine:where1|<!-- | |||
-->{{#if:{{{Category|}}}|(Categories HOLDS "{{{Category}}}")}}<!-- | |||
-->{{IfAnd|{{{Category|}}}|{{{CR|}}}|,}}<!-- | |||
-->{{#if:{{{CR|}}}|(CR = "{{{CR}}}")}}<!-- | |||
-->{{IfAnd|{{{CR|}}}|{{{CustomCR|}}}|,}}<!-- | |||
-->{{#if:{{{CustomCR|}}}|(CustomCR = "{{{CR}}}")}}<!-- | |||
-->{{IfAnd|{{{CustomCR|}}}|{{{Race|}}}|,}}<!-- | |||
-->{{#if:{{{Race|}}}|(Race= "{{{Race}}}")}}<!-- | |||
-->{{IfAnd|{{{Race|}}}|{{{Class|}}}|,}}<!-- | |||
-->{{#if:{{{Class|}}}|(Class= "{{{Class}}}")}}<!-- | |||
-->{{IfAnd|{{{Class|}}}|{{{Alignment|}}}|,}}<!-- | |||
-->{{#if:{{{Alignment|}}}|(Alignment= "{{{Alignment}}}")}}<!-- | |||
-->{{IfAnd|{{{Alignment|}}}|{{{Size|}}}|,}}<!-- | |||
-->{{#if:{{{Size|}}}|(Size= "{{{Size}}}")}}<!-- | |||
-->{{IfAnd|{{{Size|}}}|{{{Type|}}}|,}}<!-- | |||
-->{{#if:{{{Type|}}}|(Type= "{{{Type}}}")}}<!-- | |||
-->{{IfAnd|{{{Type|}}}|{{{Subtype|}}}|,}}<!-- | |||
-->{{#if:{{{Subtype|}}}|(Subtypes HOLDS "{{{Subtypes}}}")}}<!-- | |||
-->{{IfAnd|{{{Subtype|}}}|{{{Climate|}}}|,}}<!-- | |||
-->{{#if:{{{Climate|}}}|(Climate HOLDS "Any" OR Climate HOLDS "{{{Climate}}}")}}<!-- | |||
-->{{IfAnd|{{{Climate|}}}|{{{Terrain|}}}|,}}<!-- | |||
-->{{#if:{{{Terrain|}}}|(Terrain HOLDS "Any" OR Terrain HOLDS "{{{Terrain}}}")}}<!-- | |||
-->{{IfAnd|{{{Terrain|}}}|{{{Region|}}}|,}}<!-- | |||
-->{{#if:{{{Region|}}}|(Regions HOLDS "All" OR Regions HOLDS "{{{Region}}}")}}<!-- | |||
-->{{IfAnd|{{{Region|}}}|{{{ActivityCycle|}}}|,}}<!-- | |||
-->{{#if:{{{ActivityCycle|}}}|(ActivityCycle= "{{{ActivityCycle}}}")}}<!-- | |||
-->{{IfAnd|{{{ActivityCycle|}}}|{{{Diet|}}}|,}}<!-- | |||
-->{{#if:{{{Diet|}}}|(Diet= "{{{Diet}}}")}}<!-- | |||
-->}}<!-- | |||
-->{{#vardefine:where2|{{#replace:{{#var:where1}}|,|\s AND \s}}}}<!-- | |||
-->{{#var:where2}} | |||
{{MonsterListLinks|where={{#var:where2}}}} | |||
{{MonsterListAbreviated|custom={{#var:where2}}}}</includeonly> | |||
Revision as of 16:27, 20 November 2021
(CR = "1")
Function: CargoSQLQuery::run Query: SELECT CONCAT( '', Name, '' ) AS `LinkName`,`CR` AS `CR`,`XP` AS `XP` FROM `cargo__Monsters` WHERE (CR = "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 (CR = "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.