User:Toancaro/List of utilities spells/Armour Class

Armour Class buff spells

These are spells that increase

Armour Class.Test: joinORResult

Error 1054: Unknown column 'joinORResult' in 'where clause'

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

Error 1054: Unknown column 'joinORResult' in 'where clause'

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="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

Error 1054: Unknown column 'joinORResult' in 'where clause'

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

Error 1054: Unknown column 'joinORResult' in 'where clause'

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

Error 1054: Unknown column 'joinORResult' in 'where clause'

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

Error 1054: Unknown column 'joinORResult' in 'where clause'

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

Error 1054: Unknown column 'joinORResult' in 'where clause'

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

￪ Back to top

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 3d8Thunder 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			Create a floating, spectral weapon of your choice that attacks your enemies alongside you. The weapon is Ethereal, Immune to Psychic and Poison damage, and Resistant to all other Damage Types. Duration: 10 turns. Only one Spiritual Weapon may be summoned at any time.