Template:Spell table: Difference between revisions

From Baldur's Gate 3 Wiki
Jump to navigation Jump to search
(The save field now uses the save parameter, and only if that is empty it checks the damage save parameter,)
(Fetch the icon from the cargo table as well)
Line 1: Line 1:
<includeonly>{{#cargo_query:
<includeonly>{{#cargo_query:
tables = spells
tables = spells
|fields= _pageName=spell, name, is_concentration=conc, is_ritual=ritual, action_type=casttime, description, spell_level=level, can_upcast=upcastable, spell_range=range, aoe, aoe_size=area, has_attack_roll=attack, {{#if:save|save|damage_save}}=save, damage_type=damage, condition_duration=duration
|fields= _pageName=spell, icon, name, is_concentration=conc, is_ritual=ritual, action_type=casttime, description, spell_level=level, can_upcast=upcastable, spell_range=range, aoe, aoe_size=area, has_attack_roll=attack, {{#if:save|save|damage_save}}=save, damage_type=damage, condition_duration=duration
|where={{{where|_pageName = "Firebolt?"}}}
|where={{{where|_pageName = "Firebolt?"}}}
|order by=spell_level,name
|order by=spell_level,name

Revision as of 22:14, 29 February 2024

This template generates a table filled with spells that satisfy the provided condition. It requires some knowledge of SQL to operate.

Example: 
{{Spell table
|where=damage_type = "fire"
}}
Name Level Cast time Duration Range/Area Attack/Save Damage/Effect
[[File:{{{controller icon}}}|link=Alchemist's Fire (Action)|x40px|alt=Alchemist's Fire (Action)|class=bg3wiki-icon ]] Alchemist's Fire (Action) Bonus Action  5 turns  30m / 100ft
-
 Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Blazing Retaliation|x40px|alt=Blazing Retaliation|class=bg3wiki-icon ]] Blazing Retaliation Bonus Action  4 turns  Self Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Burning Avarice|x40px|alt=Burning Avarice|class=bg3wiki-icon ]] Burning Avarice Action
-
  m / ft
 4m / 13ft (Radius)
-
 Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Burning Overflow|x40px|alt=Burning Overflow|class=bg3wiki-icon ]] Burning Overflow Action  1 turn  m / ft
 3m / 10ft (Radius)
-
 Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Cinderous Swipe|x40px|alt=Cinderous Swipe|class=bg3wiki-icon ]] Cinderous Swipe Action
-
  1.5 m / 5 ft
 5m / 16ft (Cone)		 Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Death Burst (Fire)|x40px|alt=Death Burst|class=bg3wiki-icon ]] Death Burst Action
-
  m / ft
 2m / 6.5ft (Radius)		 Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Detonate|x40px|alt=Detonate|class=bg3wiki-icon ]] Detonate Action
-
  m / ft
 2m / 6.5ft
-
 Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Embrace of the Inferno|x40px|alt=Embrace of the Inferno|class=bg3wiki-icon ]] Embrace of the Inferno Action
-
  18 m / 60 ft Attack roll Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Erupting Cinder|x40px|alt=Erupting Cinder|class=bg3wiki-icon ]] Erupting Cinder Action
-
  18 m / 60 ft
 2m / 7ft (Radius)		 Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Fiery Regurgitation|x40px|alt=Fiery Regurgitation|class=bg3wiki-icon ]] Fiery Regurgitation Action
-
  4m / ft
 2m / ft (Radius)		 Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Fire Breath (Dragons)|x40px|alt=Fire Breath|class=bg3wiki-icon ]] Fire Breath Action
-
  30m / 100ft Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Fire Breath (Cone)|x40px|alt=Fire Breath|class=bg3wiki-icon ]] Fire Breath Action
-
  Self
 5m / 17ft (Cone)		 Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Fire Breath (Line)|x40px|alt=Fire Breath|class=bg3wiki-icon ]] Fire Breath Action
-
  Self
 5m / 17ft		 Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Fire Breath (Magma Mephit)|x40px|alt=Fire Breath (Magma Mephit)|class=bg3wiki-icon ]] Fire Breath (Magma Mephit) Action
-
  m / ft
 5m / 16ft (Cone)		 Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Firewine Explosion|x40px|alt=Firewine Explosion|class=bg3wiki-icon ]] Firewine Explosion Action
-
  m / ft
 4m / 13ft (Radius)
-
 Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Flames of the Phoenix|x40px|alt=Flames of the Phoenix|class=bg3wiki-icon ]] Flames of the Phoenix Action
-
  18 m / 60 ft
 4m / 13ft (Radius)		 Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Forever Indebted|x40px|alt=Forever Indebted|class=bg3wiki-icon ]] Forever Indebted Action
-
  3m / 10ft
 4m / 13ft (Radius)		 Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Hellcrawler|x40px|alt=Hellcrawler|class=bg3wiki-icon ]] Hellcrawler Bonus Action
-
  18m / 60ft
-
 Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Hellfire Exhaust|x40px|alt=Hellfire Exhaust|class=bg3wiki-icon ]] Hellfire Exhaust Action  1 turn  18 m / 60 ft Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Hellfire Missiles|x40px|alt=Hellfire Missiles|class=bg3wiki-icon ]] Hellfire Missiles Action
-
  100m / 333ft Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Immolating Gaze|x40px|alt=Immolating Gaze|class=bg3wiki-icon ]] Immolating Gaze Action  3 turns  9m / 30ft Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Incinerate (Incineration Caster)|x40px|alt=Incinerate|class=bg3wiki-icon ]] Incinerate Action
-
  m / ft
 5m / 17ft (Cone)		 Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Incineration Caster: Overheat|x40px|alt=Incineration Caster: Overheat|class=bg3wiki-icon ]] Incineration Caster: Overheat Action
-
  m / ft Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Kith'raki Inferno|x40px|alt=Kith'raki Inferno|class=bg3wiki-icon ]] Kith'raki Inferno Action
-
  30m / 60ft Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Lorroakan's Firestorm|x40px|alt=Lorroakan's Firestorm|class=bg3wiki-icon ]] Lorroakan's Firestorm Action
-
  18m / 60ft
 6m / 12ft (Radius)		 Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Overheat|x40px|alt=Overheat|class=bg3wiki-icon ]] Overheat Bonus Action  3 turns  1.5 m / 5 ft
-
 Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Ram (Hell Sphere)|x40px|alt=Ram|class=bg3wiki-icon ]] Ram Bonus Action
-
  1.5 m / 5 ft Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Ram|x40px|alt=Ram|class=bg3wiki-icon ]] Ram Bonus Action
-
  1.5 m / 5 ft Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Rolan's Firestorm|x40px|alt=Rolan's Firestorm|class=bg3wiki-icon ]] Rolan's Firestorm Action
-
  18m / 60ft
 6m / 12ft (Radius)		 Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Self-Detonate (Steel Watcher Titan)|x40px|alt=Self-Detonate|class=bg3wiki-icon ]] Self-Detonate Action
-
  Self Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Self-Detonate|x40px|alt=Self-Detonate|class=bg3wiki-icon ]] Self-Detonate Action
-
  Self Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Smouldering Touch|x40px|alt=Smouldering Touch|class=bg3wiki-icon ]] Smouldering Touch Action  2 turns  1.5 m / 5 ft Attack roll Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Sphere of Elemental Balance: Fire|x40px|alt=Sphere of Elemental Balance: Fire|class=bg3wiki-icon ]] Sphere of Elemental Balance: Fire Action
-
  18 m / 60 ft Attack roll Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Sweeping Cinder Strike|x40px|alt=Sweeping Cinder Strike|class=bg3wiki-icon ]] Sweeping Cinder Strike Action
-
  m / ft
 5m / 17ft (Cone)		 Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Fiery Bolt|x40px|alt=Fiery Bolt|class=bg3wiki-icon ]] Fiery Bolt C Action
-
  8m / 25ft Attack roll Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Fire Bolt|x40px|alt=Fire Bolt|class=bg3wiki-icon ]] Fire Bolt C Action
-
  18m / 60ft Attack roll Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Firebolt?|x40px|alt=Firebolt?|class=bg3wiki-icon ]] Firebolt? C Action
-
  18m / 60ft
-
 Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Produce Flame: Hurl|x40px|alt=Produce Flame: Hurl|class=bg3wiki-icon ]] Produce Flame: Hurl C Action
-
  9m / 30ft Attack roll Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Rays of Fire (Cantrip)|x40px|alt=Rays of Fire|class=bg3wiki-icon ]] Rays of Fire C Action
-
  18 m / 60 ft Attack roll Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Burning Hands|x40px|alt=Burning Hands|class=bg3wiki-icon ]] Burning Hands 1 Action
-
  Self
 5m / 17ft (Cone)		 Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Chromatic Orb: Fire|x40px|alt=Chromatic Orb: Fire|class=bg3wiki-icon ]] Chromatic Orb: Fire 1 Action
-
  18 m / 60 ft Attack roll Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Hellish Rebuke|x40px|alt=Hellish Rebuke|class=bg3wiki-icon ]] Hellish Rebuke 1 Reaction
-
  m / ft
-
 Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Flaming Sphere|x40px|alt=Flaming Sphere|class=bg3wiki-icon ]] Flaming Sphere  2 Action
-
  18 m / 60 ft
 2m / 7ft (Radius)		 Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Heat Metal|x40px|alt=Heat Metal|class=bg3wiki-icon ]] Heat Metal  2 Action  10 turns  18 m / 60 ft Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Rays of Fire|x40px|alt=Rays of Fire|class=bg3wiki-icon ]] Rays of Fire 2 Action
-
  18 m / 60 ft Attack roll Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Heat Metal: Reapply Damage|x40px|alt=Reapply Heat Metal|class=bg3wiki-icon ]] Reapply Heat Metal  2 Bonus Action  10 turns  18 m / 60 ft Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Scorching Ray|x40px|alt=Scorching Ray|class=bg3wiki-icon ]] Scorching Ray 2 Action
-
  18 m / 60 ft Attack roll Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Fireball|x40px|alt=Fireball|class=bg3wiki-icon ]] Fireball 3 Action
-
  18m / 60ft
 4m / 13ft (Radius)		 Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Glyph of Warding: Fire|x40px|alt=Glyph of Warding: Fire|class=bg3wiki-icon ]] Glyph of Warding: Fire 3 Action
-
  9m / 30ft
 4m / 13ft (Radius)		 Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Igniting Spark|x40px|alt=Igniting Spark|class=bg3wiki-icon ]] Igniting Spark 4 Action
-
  18m / 60ft Attack roll Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Wall of Fire|x40px|alt=Wall of Fire|class=bg3wiki-icon ]] Wall of Fire  4 Action
-
  18m / 60ft Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Flame Strike|x40px|alt=Flame Strike|class=bg3wiki-icon ]] Flame Strike 5 Action
-
  18 m / 60 ft
 3m / 10ft (Radius)		 Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Diabolic Chains|x40px|alt=Diabolic Chains|class=bg3wiki-icon ]] Diabolic Chains 6 Action
-
  18m / 60ft Attack roll Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Hellfire Orb|x40px|alt=Hellfire Orb|class=bg3wiki-icon ]] Hellfire Orb 6 Action
-
  18m / 60ft
 4m / 13ft (Radius)		 Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Incinerate|x40px|alt=Incinerate|class=bg3wiki-icon ]] Incinerate 6 Action
-
  m / ft
 3m / 10ft (Radius)		 Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
[[File:{{{controller icon}}}|link=Ravaging Inferno|x40px|alt=Ravaging Inferno|class=bg3wiki-icon ]] Ravaging Inferno 6 Action
-
  18m / 60ft
 4m / ft (Radius)		 Attack roll Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}

Template data

No description.

Template parameters

ParameterDescriptionTypeStatus
wherewhere

A "where" clause for the SQL query.

Unknownsuggested
Retrieved from "https://bg3.wiki/w/index.php?title=Template:Spell_table&oldid=156434"