Template:Spell table

From Baldur's Gate 3 Wiki
Revision as of 21:46, 16 April 2024 by HiddenDragon (talk | contribs) (Switch to controller icon and added is_spell check)
Jump to navigation Jump to search

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
Alchemist's Fire (Action) 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}}}
Blazing Retaliation 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}}}
Burning Avarice 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}}}
Burning Overflow 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}}}
Cinderous Swipe 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}}}
Death Burst 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}}}
Detonate 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}}}
Embrace of the Inferno 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}}}
Erupting Cinder 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}}}
Fiery Regurgitation 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}}}
Fire Breath Fire Breath Action
-
  30m / 100ft Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
Fire Breath 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}}}
Fire Breath 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}}}
Fire Breath (Magma Mephit) 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}}}
Firewine Explosion 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}}}
Flames of the Phoenix 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}}}
Forever Indebted 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}}}
Hellcrawler Hellcrawler Bonus Action
-
  18m / 60ft
-
 Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
Hellfire Exhaust 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}}}
Hellfire Missiles Hellfire Missiles Action
-
  100m / 333ft Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
Immolating Gaze 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}}}
Incinerate 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}}}
Incineration Caster: Overheat 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}}}
Kith'raki Inferno 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}}}
Lorroakan's Firestorm 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}}}
Overheat 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}}}
Ram 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}}}
Ram 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}}}
Rolan's Firestorm 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}}}
Self-Detonate Self-Detonate Action
-
  Self Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
Self-Detonate Self-Detonate Action
-
  Self Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
Smouldering Touch 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}}}
Sphere of Elemental Balance: Fire 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}}}
Sweeping Cinder Strike 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}}}
Fiery Bolt 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}}}
Fire Bolt 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}}}
Firebolt? Firebolt? C Action
-
  18m / 60ft
-
 Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}
Produce Flame: Hurl 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}}}
Rays of Fire 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}}}
Burning Hands 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}}}
Chromatic Orb: Fire 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}}}
Hellish Rebuke 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}}}
Flaming Sphere 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}}}
Heat Metal 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}}}
Rays of Fire 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}}}
Reapply Heat Metal 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}}}
Scorching Ray 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}}}
Fireball 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}}}
Glyph of Warding: Fire 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}}}
Igniting Spark 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}}}
Wall of Fire 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}}}
Flame Strike 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}}}
Diabolic Chains 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}}}
Hellfire Orb 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}}}
Incinerate 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}}}
Ravaging Inferno 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=174237"