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
Alchemist's Fire				5 turns	30m / 100ft	-	1d4Fire
Blazing Retaliation				4 turns	Self	DEX save	1d6Fire
Burning Avarice				-	m / ft  4m / 13ft (Radius)	-	2d8+2Fire 1d6Fire
Burning Overflow				1 turn	m / ft  5m / 16ft (Radius)	-	6d6Fire
Cinderous Swipe				-	m / ft  5m / 16ft (Cone)	DEX save	weaponFire 1d6Fire
Death Burst				-	m / ft  2m / 6.5ft (Radius)	DEX save	2d6Fire
Detonate				-	m / ft  2m / 6.5ft	-	100Fire
Embrace of the Inferno				-	18 m / 60 ft	Attack roll	2d6Fire
Erupting Cinder				-	18 m / 60 ft  3m / 10ft (Radius)	DEX save	4d6Fire
Fiery Regurgitation				-	4m / ft  2m / ft (Radius)	CON save	6d10Fire
Fire Breath				-	Self  5m / 17ft	DEX save	2d6Fire
Fire Breath				-	30m / 100ft	DEX save	14d6Fire
Fire Breath				-	Self  5m / 17ft (Cone)	DEX save	2d6Fire
Fire Breath (Magma Mephit)				-	m / ft  5m / 16ft (Cone)	DEX save	2d6Fire
Firewine Explosion				-	m / ft  4m / 13ft (Radius)	-	2d6Fire
Flames of the Phoenix				-	18 m / 60 ft  4m / 13ft (Radius)	DEX save	8d6Fire
Forever Indebted				-	3m / 10ft  4m / 13ft (Radius)	DEX save	6d8Fire
Hellcrawler				-	18m / 60ft	-	2d8Fire
Hellfire Exhaust				1 turn	18 m / 60 ft	DEX save	3d8Fire 3d8Fire
Hellfire Missiles				-	100m / 333ft	DEX save	96d6Fire
Immolating Gaze				3 turns	9m / 30ft	INT save	2d8Fire
Incinerate				-	m / ft  5m / 17ft (Cone)	DEX save	10d6Fire
Incineration Caster: Overheat				-	m / ft	DEX save	8d8Fire
Kith'raki Inferno				-	30m / 60ft	DEX save	12d6Fire
Lorroakan's Firestorm				-	18m / 60ft  6m / 12ft (Radius)	DEX save	10d6Fire 10d6Force
Overheat				3 turns	Self  2m / 7ft (Radius)	CON save	1d10Fire
Ram				-	1.5 m / 5 ft	DEX save	6d6Fire
Ram				-	1.5 m / 5 ft	DEX save	2d6Fire
Rolan's Firestorm				-	18m / 60ft  6m / 12ft (Radius)	DEX save	10d6Fire 10d6Force
Self-Detonate				-	Self  5m / 15ft	DEX save	4d12+26Fire
Self-Detonate				-	5m / 15ft	DEX save	12d12+78Fire
Smouldering Touch				2 turns	1.5 m / 5 ft  1m / 3ft (Radius)	Attack roll	2d6Fire
Sphere of Elemental Balance: Fire				-	18 m / 60 ft	Attack roll	2d8Fire
Sweeping Cinder Strike				-	m / ft  5m / 17ft (Cone)	DEX save	3d6Fire
Fiery Bolt	C			-	8m / 25ft	Attack roll	1d4Fire
Fire Bolt	C			-	18m / 60ft	Attack roll	1d10Fire
Firebolt?	C			-	18m / 60ft	Attack roll	1d10Fire
Hellflame Cleave	C			1 turn	m / ft  3m / 10ft (Cone)	DEX save	weaponFire 2d6Fire
Produce Flame: Hurl	C			-	9m / 30ft	Attack roll	1d8Fire
Rays of Fire	C			-	18 m / 60 ft	Attack roll	3d6Fire
Burning Hands	1			-	Self  5m / 17ft (Cone)	DEX save	3d6Fire
Chromatic Orb: Fire	1			-	18 m / 60 ft	Attack roll	2d8Fire
Hellish Rebuke	1			-	m / ft	-	2d10Fire
Flaming Sphere	2			-	18 m / 60 ft  2m / 7ft (Radius)	DEX save	2d6Fire
Heat Metal	2			10 turns	18 m / 60 ft	CON save	2d8Fire
Rays of Fire	2			-	18 m / 60 ft	Attack roll	3d6Fire
Reapply Heat Metal	2			10 turns	18 m / 60 ft	CON save	2d8Fire
Scorching Ray	2			-	18 m / 60 ft	Attack roll	2d6Fire
Fireball	3			-	18m / 60ft  4m / 13ft (Radius)	DEX save	8d6Fire
Glyph of Warding: Fire	3			-	9m / 30ft  4m / 13ft (Radius)	CON save	5d8Fire
Igniting Spark	4			2 turns	18m / 60ft	DEX save	6d6Fire
Wall of Fire	4			-	18m / 60ft	DEX save	5d8Fire
Flame Strike	5			-	18m / 60ft  3m / 10ft (Radius)	DEX save	5d6Fire 5d6Radiant
Diabolic Chains	6			-	18m / 60ft	DEX save	6d6Fire
Hellfire Orb	6			-	18m / 60ft  4m / 13ft (Radius)	DEX save	20d6Fire
Incinerate	6			-	m / ft  3m / 10ft (Radius)	DEX save	8d8Fire
Ravaging Inferno	6			-	18m / 60ft  4m / ft (Radius)	Attack roll DEX save	20d6Fire

Template data

No description.

Template parameters

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