User:Toancaro/List of utilities spells/Armour Class: Difference between revisions

From bg3.wiki
Jump to navigation Jump to search
Line 5: Line 5:


/>{{#arrayunion: joinORItems | spellsArmourClassBuff }}<nowiki
/>{{#arrayunion: joinORItems | spellsArmourClassBuff }}<nowiki
/>{{#vardefine: queryNamesSpellsArmourClassBuff | {{#lst:User:Toancaro/List of utilities spells/Join OR|joinOR}} }}<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 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

Bg3 content hr.png

Armour Class debuff spells

These are spells that decrease Armour Class Armour Class.

No results

Name Spell School Classes C C R A Saving Throw Icon.png Range Icon.png D Description
Melf's Acid Arrow Melf's Acid Arrow Evocation Evocation Wizard Wizard Action Attack roll 18m Damage Types Shoot a green arrow that bursts in a spray of acid. Deals 4d4Damage TypesAcid damage immediately and 2d4Damage TypesAcid 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 Spiritual Weapon Evocation Evocation Cleric Cleric Bonus Action 18m Damage Types Create a floating, spectral weapon of your choice that attacks your enemies alongside you. The weapon is Ethereal, Immune to Damage TypesPsychic and Damage TypesPoison damage, and Resistant to all other Damage Types. Duration: 10 turns. Only one Spiritual Weapon may be summoned at any time.

No results

No results

No results

No results

￪ Back to top

Bg3 content hr.png
Retrieved from "https://bg3.wiki/w/index.php?title=User:Toancaro/List_of_utilities_spells/Armour_Class&oldid=144142"