Template:Spell table

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|class=bg3wiki-icon ]] Alchemist's Fire				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				4 turns	Self	DEX save	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				-	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				1 turn	m / ft  5m / 16ft (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				-	m / ft  5m / 16ft (Cone)	DEX save	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				-	m / ft  2m / 6.5ft (Radius)	DEX save	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				-	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				-	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				-	18 m / 60 ft  3m / 10ft (Radius)	DEX save	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				-	4m / ft  2m / ft (Radius)	CON save	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				-	Self  5m / 17ft (Cone)	DEX save	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				-	Self  5m / 17ft	DEX save	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				-	30m / 100ft	DEX save	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)				-	m / ft  5m / 16ft (Cone)	DEX save	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				-	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				-	18 m / 60 ft  4m / 13ft (Radius)	DEX save	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				-	3m / 10ft  4m / 13ft (Radius)	DEX save	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				-	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				1 turn	18 m / 60 ft	DEX save	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				-	100m / 333ft	DEX save	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				3 turns	9m / 30ft	INT save	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				-	m / ft  5m / 17ft (Cone)	DEX save	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				-	m / ft	DEX save	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				-	30m / 60ft	DEX save	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				-	18m / 60ft  6m / 12ft (Radius)	DEX save	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				3 turns	Self  2m / 7ft (Radius)	CON save	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				-	1.5 m / 5 ft	DEX save	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				-	1.5 m / 5 ft	DEX save	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				-	18m / 60ft  6m / 12ft (Radius)	DEX save	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				-	Self  5m / 15ft	DEX save	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				-	5m / 15ft	DEX save	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				2 turns	1.5 m / 5 ft  1m / 3ft (Radius)	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				-	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				-	m / ft  5m / 17ft (Cone)	DEX save	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			-	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			-	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			-	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=Hellflame Cleave|x40px|alt=Hellflame Cleave|class=bg3wiki-icon ]] Hellflame Cleave	C			1 turn	m / ft  3m / 10ft (Cone)	DEX save	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			-	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			-	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			-	Self  5m / 17ft (Cone)	DEX save	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			-	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			-	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			-	18 m / 60 ft  2m / 7ft (Radius)	DEX save	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			10 turns	18 m / 60 ft	CON save	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			-	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			10 turns	18 m / 60 ft	CON save	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			-	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			-	18m / 60ft  4m / 13ft (Radius)	DEX save	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			-	9m / 30ft  4m / 13ft (Radius)	CON save	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			2 turns	18m / 60ft	DEX save	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			-	18m / 60ft	DEX save	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			-	18m / 60ft  3m / 10ft (Radius)	DEX save	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			-	18m / 60ft	DEX save	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			-	18m / 60ft  4m / 13ft (Radius)	DEX save	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			-	m / ft  3m / 10ft (Radius)	DEX save	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			-	18m / 60ft  4m / ft (Radius)	Attack roll DEX save	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[Edit template data]

Parameter		Description	Type	Status
where	where	A "where" clause for the SQL query.	Unknown	suggested