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 spell_level="0" AND ((`cargo__spells`.`_ID` IN (SELECT `_rowID` FROM `cargo__spells__classes` WHERE `_value`= "Wizard") OR `cargo__spells`.`_ID` IN (SELECT `_rowID` FROM `cargo__spells__classes` WHERE `_value`= "Sorcerer") OR `cargo__spells`.`_ID` IN (SELECT `_rowID` FROM `cargo__spells__classes` WHERE `_value`= "Cleric") OR `cargo__spells`.`_ID` IN (SELECT `_rowID` FROM `cargo__spells__classes` WHERE `_value`= "Bard") OR `cargo__spells`.`_ID` IN (SELECT `_rowID` FROM `cargo__spells__classes` WHERE `_value`= "Ranger") OR `cargo__spells`.`_ID` IN (SELECT `_rowID` FROM `cargo__spells__classes` WHERE `_value`= "Druid") OR `cargo__spells`.`_ID` IN (SELECT `_rowID` FROM `cargo__spells__classes` WHERE `_value`= "Paladin") OR `cargo__spells`.`_ID` IN (SELECT `_rowID` FROM `cargo__spells__classes` WHERE `_value`= "Warlock") ) AND (is_npc = false OR is_npc IS NULL)) AND joinORResult ORDER BY `cargo__spells`.`_pageID`,`_pageName`,`name`,`cargo__spells`.`classes__full` ,`description` LIMIT 100
User:Toancaro/List of utilities spells/Armour Class: Difference between revisions
| Line 5: | Line 5: | ||
/>{{#arrayunion: joinORItems | spellsArmourClassBuff }}<nowiki | />{{#arrayunion: joinORItems | spellsArmourClassBuff }}<nowiki | ||
/> | />{{#lst:User:Toancaro/List of utilities spells/Join OR|joinOR}}<nowiki | ||
/>{{#vardefine: queryNamesSpellsArmourClassBuff | joinORResult }}<nowiki | |||
/>Test: {{#var: queryNamesSpellsArmourClassBuff}}<nowiki | />Test: {{#var: queryNamesSpellsArmourClassBuff}}<nowiki | ||
Revision as of 18:34, 15 January 2024
Armour Class buff spells
These are spells that increase
Armour Class.Test: joinORResultFunction: 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 spell_level="1" AND ((`cargo__spells`.`_ID` IN (SELECT `_rowID` FROM `cargo__spells__classes` WHERE `_value`= "Wizard") OR `cargo__spells`.`_ID` IN (SELECT `_rowID` FROM `cargo__spells__classes` WHERE `_value`= "Sorcerer") OR `cargo__spells`.`_ID` IN (SELECT `_rowID` FROM `cargo__spells__classes` WHERE `_value`= "Cleric") OR `cargo__spells`.`_ID` IN (SELECT `_rowID` FROM `cargo__spells__classes` WHERE `_value`= "Bard") OR `cargo__spells`.`_ID` IN (SELECT `_rowID` FROM `cargo__spells__classes` WHERE `_value`= "Ranger") OR `cargo__spells`.`_ID` IN (SELECT `_rowID` FROM `cargo__spells__classes` WHERE `_value`= "Druid") OR `cargo__spells`.`_ID` IN (SELECT `_rowID` FROM `cargo__spells__classes` WHERE `_value`= "Paladin") OR `cargo__spells`.`_ID` IN (SELECT `_rowID` FROM `cargo__spells__classes` WHERE `_value`= "Warlock") ) AND (is_npc = false OR is_npc IS NULL)) AND joinORResult ORDER BY `cargo__spells`.`_pageID`,`_pageName`,`name`,`cargo__spells`.`classes__full` ,`description` LIMIT 100
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 spell_level="2" AND ((`cargo__spells`.`_ID` IN (SELECT `_rowID` FROM `cargo__spells__classes` WHERE `_value`= "Wizard") OR `cargo__spells`.`_ID` IN (SELECT `_rowID` FROM `cargo__spells__classes` WHERE `_value`= "Sorcerer") OR `cargo__spells`.`_ID` IN (SELECT `_rowID` FROM `cargo__spells__classes` WHERE `_value`= "Cleric") OR `cargo__spells`.`_ID` IN (SELECT `_rowID` FROM `cargo__spells__classes` WHERE `_value`= "Bard") OR `cargo__spells`.`_ID` IN (SELECT `_rowID` FROM `cargo__spells__classes` WHERE `_value`= "Ranger") OR `cargo__spells`.`_ID` IN (SELECT `_rowID` FROM `cargo__spells__classes` WHERE `_value`= "Druid") OR `cargo__spells`.`_ID` IN (SELECT `_rowID` FROM `cargo__spells__classes` WHERE `_value`= "Paladin") OR `cargo__spells`.`_ID` IN (SELECT `_rowID` FROM `cargo__spells__classes` WHERE `_value`= "Warlock") ) AND (is_npc = false OR is_npc IS NULL)) AND joinORResult ORDER BY `cargo__spells`.`_pageID`,`_pageName`,`name`,`cargo__spells`.`classes__full` ,`description` LIMIT 100
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 spell_level="3" AND ((`cargo__spells`.`_ID` IN (SELECT `_rowID` FROM `cargo__spells__classes` WHERE `_value`= "Wizard") OR `cargo__spells`.`_ID` IN (SELECT `_rowID` FROM `cargo__spells__classes` WHERE `_value`= "Sorcerer") OR `cargo__spells`.`_ID` IN (SELECT `_rowID` FROM `cargo__spells__classes` WHERE `_value`= "Cleric") OR `cargo__spells`.`_ID` IN (SELECT `_rowID` FROM `cargo__spells__classes` WHERE `_value`= "Bard") OR `cargo__spells`.`_ID` IN (SELECT `_rowID` FROM `cargo__spells__classes` WHERE `_value`= "Ranger") OR `cargo__spells`.`_ID` IN (SELECT `_rowID` FROM `cargo__spells__classes` WHERE `_value`= "Druid") OR `cargo__spells`.`_ID` IN (SELECT `_rowID` FROM `cargo__spells__classes` WHERE `_value`= "Paladin") OR `cargo__spells`.`_ID` IN (SELECT `_rowID` FROM `cargo__spells__classes` WHERE `_value`= "Warlock") ) AND (is_npc = false OR is_npc IS NULL)) AND joinORResult ORDER BY `cargo__spells`.`_pageID`,`_pageName`,`name`,`cargo__spells`.`classes__full` ,`description` LIMIT 100
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 spell_level="4" AND ((`cargo__spells`.`_ID` IN (SELECT `_rowID` FROM `cargo__spells__classes` WHERE `_value`= "Wizard") OR `cargo__spells`.`_ID` IN (SELECT `_rowID` FROM `cargo__spells__classes` WHERE `_value`= "Sorcerer") OR `cargo__spells`.`_ID` IN (SELECT `_rowID` FROM `cargo__spells__classes` WHERE `_value`= "Cleric") OR `cargo__spells`.`_ID` IN (SELECT `_rowID` FROM `cargo__spells__classes` WHERE `_value`= "Bard") OR `cargo__spells`.`_ID` IN (SELECT `_rowID` FROM `cargo__spells__classes` WHERE `_value`= "Ranger") OR `cargo__spells`.`_ID` IN (SELECT `_rowID` FROM `cargo__spells__classes` WHERE `_value`= "Druid") OR `cargo__spells`.`_ID` IN (SELECT `_rowID` FROM `cargo__spells__classes` WHERE `_value`= "Paladin") OR `cargo__spells`.`_ID` IN (SELECT `_rowID` FROM `cargo__spells__classes` WHERE `_value`= "Warlock") ) AND (is_npc = false OR is_npc IS NULL)) AND joinORResult ORDER BY `cargo__spells`.`_pageID`,`_pageName`,`name`,`cargo__spells`.`classes__full` ,`description` LIMIT 100
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 spell_level="5" AND ((`cargo__spells`.`_ID` IN (SELECT `_rowID` FROM `cargo__spells__classes` WHERE `_value`= "Wizard") OR `cargo__spells`.`_ID` IN (SELECT `_rowID` FROM `cargo__spells__classes` WHERE `_value`= "Sorcerer") OR `cargo__spells`.`_ID` IN (SELECT `_rowID` FROM `cargo__spells__classes` WHERE `_value`= "Cleric") OR `cargo__spells`.`_ID` IN (SELECT `_rowID` FROM `cargo__spells__classes` WHERE `_value`= "Bard") OR `cargo__spells`.`_ID` IN (SELECT `_rowID` FROM `cargo__spells__classes` WHERE `_value`= "Ranger") OR `cargo__spells`.`_ID` IN (SELECT `_rowID` FROM `cargo__spells__classes` WHERE `_value`= "Druid") OR `cargo__spells`.`_ID` IN (SELECT `_rowID` FROM `cargo__spells__classes` WHERE `_value`= "Paladin") OR `cargo__spells`.`_ID` IN (SELECT `_rowID` FROM `cargo__spells__classes` WHERE `_value`= "Warlock") ) AND (is_npc = false OR is_npc IS NULL)) AND joinORResult ORDER BY `cargo__spells`.`_pageID`,`_pageName`,`name`,`cargo__spells`.`classes__full` ,`description` LIMIT 100
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 spell_level="6" AND ((`cargo__spells`.`_ID` IN (SELECT `_rowID` FROM `cargo__spells__classes` WHERE `_value`= "Wizard") OR `cargo__spells`.`_ID` IN (SELECT `_rowID` FROM `cargo__spells__classes` WHERE `_value`= "Sorcerer") OR `cargo__spells`.`_ID` IN (SELECT `_rowID` FROM `cargo__spells__classes` WHERE `_value`= "Cleric") OR `cargo__spells`.`_ID` IN (SELECT `_rowID` FROM `cargo__spells__classes` WHERE `_value`= "Bard") OR `cargo__spells`.`_ID` IN (SELECT `_rowID` FROM `cargo__spells__classes` WHERE `_value`= "Ranger") OR `cargo__spells`.`_ID` IN (SELECT `_rowID` FROM `cargo__spells__classes` WHERE `_value`= "Druid") OR `cargo__spells`.`_ID` IN (SELECT `_rowID` FROM `cargo__spells__classes` WHERE `_value`= "Paladin") OR `cargo__spells`.`_ID` IN (SELECT `_rowID` FROM `cargo__spells__classes` WHERE `_value`= "Warlock") ) AND (is_npc = false OR is_npc IS NULL)) AND joinORResult ORDER BY `cargo__spells`.`_pageID`,`_pageName`,`name`,`cargo__spells`.`classes__full` ,`description` LIMIT 100
Armour Class debuff spells
These are spells that decrease Armour Class.No results
| Name | Spell School | Classes | C | C | R | A |  |
 |
 |
D | Description | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
 |
Chromatic Orb |  Evocation |
 Sorcerer Wizard |
 |
 |
18m | Hurl a sphere of energy.
It deals 3d8 Thunder damage, or 2d8  Acid,  Cold,  Fire,  Lightning or  Poison damage and creates a surface. |
| Name | Spell School | Classes | C | C | R | A | |
|
|
D | Description | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
 |
Melf's Acid Arrow | Evocation |
Wizard |
|
|
18m | |
Shoot a green arrow that bursts in a spray of acid. Deals 4d4Acid damage immediately and 2d4Acid damage at the end of the target's next turn.
If the spell misses, the target still takes half the initial damage, but no damage at the end of its next turn. |
||||
 |
Spiritual Weapon | Evocation |
 Cleric |
 |
18m |  |
Summon a floating, spectral weapon that attacks your enemies alongside you. |
No results
No results
No results
No results