Template:Spell table

Template page
Revision as of 23:00, 17 October 2023 by Sky (talk | contribs) (Order by spell level first)

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={{{name}}}|class=bg3wiki-icon ]] {{{name}}} 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={{{name}}}|class=bg3wiki-icon ]] {{{name}}} 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={{{name}}}|class=bg3wiki-icon ]] {{{name}}} 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={{{name}}}|class=bg3wiki-icon ]] {{{name}}} 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={{{name}}}|class=bg3wiki-icon ]] {{{name}}} 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={{{name}}}|class=bg3wiki-icon ]] {{{name}}} 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={{{name}}}|class=bg3wiki-icon ]] {{{name}}} 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={{{name}}}|class=bg3wiki-icon ]] {{{name}}} 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={{{name}}}|class=bg3wiki-icon ]] {{{name}}} 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={{{name}}}|class=bg3wiki-icon ]] {{{name}}} 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 (Cone)|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}} 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 (Dragons)|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}} 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 (Line)|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}} 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={{{name}}}|class=bg3wiki-icon ]] {{{name}}} 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={{{name}}}|class=bg3wiki-icon ]] {{{name}}} 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={{{name}}}|class=bg3wiki-icon ]] {{{name}}} 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={{{name}}}|class=bg3wiki-icon ]] {{{name}}} 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={{{name}}}|class=bg3wiki-icon ]] {{{name}}} 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={{{name}}}|class=bg3wiki-icon ]] {{{name}}} 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={{{name}}}|class=bg3wiki-icon ]] {{{name}}} 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={{{name}}}|class=bg3wiki-icon ]] {{{name}}} 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={{{name}}}|class=bg3wiki-icon ]] {{{name}}} 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={{{name}}}|class=bg3wiki-icon ]] {{{name}}} 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={{{name}}}|class=bg3wiki-icon ]] {{{name}}} 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={{{name}}}|class=bg3wiki-icon ]] {{{name}}} 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={{{name}}}|class=bg3wiki-icon ]] {{{name}}} 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|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}} 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 (Hell Sphere)|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}} 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={{{name}}}|class=bg3wiki-icon ]] {{{name}}} 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|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}} 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 (Steel Watcher Titan)|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}} 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={{{name}}}|class=bg3wiki-icon ]] {{{name}}} 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={{{name}}}|class=bg3wiki-icon ]] {{{name}}} 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={{{name}}}|class=bg3wiki-icon ]] {{{name}}} 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={{{name}}}|class=bg3wiki-icon ]] {{{name}}} 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={{{name}}}|class=bg3wiki-icon ]] {{{name}}} 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={{{name}}}|class=bg3wiki-icon ]] {{{name}}} 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={{{name}}}|class=bg3wiki-icon ]] {{{name}}} 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={{{name}}}|class=bg3wiki-icon ]] {{{name}}} 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={{{name}}}|class=bg3wiki-icon ]] {{{name}}} 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={{{name}}}|class=bg3wiki-icon ]] {{{name}}} 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={{{name}}}|class=bg3wiki-icon ]] {{{name}}} 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={{{name}}}|class=bg3wiki-icon ]] {{{name}}} 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={{{name}}}|class=bg3wiki-icon ]] {{{name}}} 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=Heat Metal: Reapply Damage|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}} 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=Rays of Fire|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}} 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=Scorching Ray|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}} 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={{{name}}}|class=bg3wiki-icon ]] {{{name}}} 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={{{name}}}|class=bg3wiki-icon ]] {{{name}}} 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={{{name}}}|class=bg3wiki-icon ]] {{{name}}} 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={{{name}}}|class=bg3wiki-icon ]] {{{name}}} 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={{{name}}}|class=bg3wiki-icon ]] {{{name}}} 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={{{name}}}|class=bg3wiki-icon ]] {{{name}}} 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={{{name}}}|class=bg3wiki-icon ]] {{{name}}} 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={{{name}}}|class=bg3wiki-icon ]] {{{name}}} 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={{{name}}}|class=bg3wiki-icon ]] {{{name}}} 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