User:Toancaro/Template:SpellTable: Difference between revisions
mNo edit summary |
mNo edit summary |
||
| Line 2: | Line 2: | ||
tables = spells | tables = spells | ||
| fields=_pageName=spell, name, classes, description, spell_school, action_type=casttime, damage_type=damage, is_concentration=conc, is_ritual=ritual, spell_level=level, can_upcast=upcastable, spell_range=range, aoe, aoe_size=area, has_attack_roll=attack, damage_save=save, condition_duration=duration | | fields=_pageName=spell, name, classes, description, spell_school, action_type=casttime, damage_type=damage, is_concentration=conc, is_ritual=ritual, spell_level=level, can_upcast=upcastable, spell_range=range, aoe, aoe_size=area, has_attack_roll=attack, damage_save=save, condition_duration=duration | ||
| where={{{where|classes HOLDS "Wizard"}}} | | where={{{where|level="1" AND classes HOLDS "Wizard"}}} | ||
| intro={{User:Toancaro/Template:SpellTable/Header}} | | intro={{User:Toancaro/Template:SpellTable/Header}} | ||
| outro={{User:Toancaro/Template:SpellTable/Footer}} | | outro={{User:Toancaro/Template:SpellTable/Footer}} | ||
Revision as of 16:06, 8 January 2024
Function: CargoSQLQuery::run Query: SELECT `cargo__spells`.`_pageID` AS `cargo_backlink_page_id_spells`,`_pageName` AS `spell`,`name` AS `name`,`classes__full` AS `classes`,`description` AS `description`,`spell_school` AS `spell school`,`action_type` AS `casttime`,`damage_type` AS `damage`,`is_concentration` AS `conc`,`is_ritual` AS `ritual`,`spell_level` AS `level`,`can_upcast` AS `upcastable`,`spell_range` AS `range`,`aoe` AS `aoe`,`aoe_size` AS `area`,`has_attack_roll` AS `attack`,`damage_save` AS `save`,`condition_duration` AS `duration` FROM `cargo__spells` WHERE level="1" AND `cargo__spells`.`_ID` IN (SELECT `_rowID` FROM `cargo__spells__classes` WHERE `_value`= "Wizard") ORDER BY `cargo__spells`.`_pageID`,`_pageName`,`name`,`cargo__spells`.`classes__full` ,`description` LIMIT 100