Template:Spell table

Template documentation

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

Example

List of spells that deal fire damage

Markup

{{Spell table
|where=damage_type = "fire" 
OR extra_damage_type = "fire" 
OR extra_damage_type_2 = "fire" 
OR extra_damage_type_3 = "fire"
}}

Renders as

Name	Level		Cast time	Duration	Range/Area	Attack/Save	Damage/Effect
Alchemist's Fire				5 turns	30 m / 100ft	-	1d4⁠Fire
Blazing Retaliation				4 turns	Self	DEX Save	1d6⁠Fire
Burning Avarice				-	Self  4m / 13ft (Radius)	-	2d8 + 2⁠Fire 1d6⁠Fire
Burning Claws				-	1.5 m / 5 ft	Attack Roll	1d4 + Strength or Dexterity modifier⁠Slashing 1d4⁠Fire
Burning Overflow				1 turn	Self  5m / 17ft (Radius)	-	6d6⁠Fire
Cinderous Swipe				-	5m / 17ft (Cone)	DEX Save	Normal weapon damage 2d6⁠Fire
Death Burst				-	Self  2m / 7ft (Radius)	DEX Save	2d6⁠Fire
Divine Strike: Fire (Melee)				-	1.5 m / 5 ft	Attack Roll	Normal weapon damage 1d8⁠Fire
Divine Strike: Fire (Ranged)				-	18 m / 60 ft	Attack Roll	Normal weapon damage 1d8⁠Fire
Elemental Cleaver				10 turns	Self	-	1d6⁠Fire
Embrace of the Inferno				-	18 m / 60 ft	Attack Roll	2d6⁠Fire 2d6⁠Fire 2d6⁠Fire
Erupting Cinder				-	18 m / 60 ft  3m / 10ft (Radius)	DEX Save	4d6⁠Fire
Fangs of the Fire Snake				1 turn	6 m / 20ft	Attack Roll	Unarmed⁠Bludgeoning 1d10⁠Fire
Fiendish Flameblast				2 turns	2m / 7ft (Radius)	-	4d8⁠Force 4d8⁠Fire
Fiery Regurgitation				-	4 m / 13ft  2m / 7ft (Radius)	CON Save	6d10 + Strength modifier⁠Fire
Fire Breath				2 turns	30 m / 100ft  6m / 20ft (Radius)	DEX Save	14d6⁠Fire
Fire Breath				-	Self  5m / 17ft	DEX Save	2d6⁠Fire
Fire Breath				-	5m / 17ft (Cone)	DEX Save	2d6⁠Fire
Fire Breath				-	Self  5m / 17ft (Cone)	DEX Save	2d6⁠Fire
Firewine Explosion				-	4m / 13ft (Radius)	DEX Save	2d6⁠Fire
Flames of the Phoenix				-	18 m / 60 ft  4m / 13ft (Radius)	DEX Save	8d6⁠Fire
Flaming Blade				-	1.5 m / 5 ft	Attack Roll	Normal weapon damage Proficiency bonus⁠Slashing 2d6⁠Fire
Flaming Fury				-	Weapon Range	Attack Roll	Normal weapon damage 3d6⁠Fire
Forever Indebted				-	3 m / 10ft  4m / 13ft (Radius)	DEX Save	6d8⁠Fire
Hellcrawler				-	18 m / 60ft  3m / 10ft (Radius)	DEX Save	2d8⁠Fire
Hellfire Exhaust				1 turn	Self  3m / 10ft (Cone)	DEX Save	3d8⁠Fire 3d8⁠Fire
Hellfire Missiles				-	100 m / 333ft  6m / 20ft (Radius)	DEX Save	4d6⁠Fire
Immolating Gaze				3 turns	9 m / 30ft	INT Save	2d8⁠Fire
Incinerate				3 turns	5m / 17ft (Cone)	DEX Save	10d6⁠Fire
Incineration Caster: Overheat				-	4m / 13ft (Radius)	DEX Save	8d8⁠Fire
Kith'raki Inferno				-	30 m / 100ft	DEX Save	12d6⁠Fire
Lorroakan's Firestorm				-	30 m / 100ft  6m / 20ft (Radius)	DEX Save	10d6⁠Fire 10d6⁠Force
Multiattack				-	1.5 m / 5 ft	Attack Roll	2d6 + Strength modifier⁠Bludgeoning 2d6⁠Fire 2d6 + Strength modifier⁠Bludgeoning 2d6⁠Fire
Multiattack				-	1.5 m / 5 ft	Attack Roll	2d4 + Strength modifier⁠Bludgeoning 2d4⁠Fire 2d4 + Strength modifier⁠Bludgeoning 2d4⁠Fire
Multiattack				2 turns	4 m / 13ft	Attack Roll	4d8 + Strength modifier⁠Bludgeoning 3d8 + Strength modifier⁠Piercing 4d6⁠Fire
Nautiloid Airstrike				-	-	-	5d6⁠Force 5d6⁠Fire
Overheat				3 turns	Self  2m / 7ft (Radius)	CON Save	1d10⁠Fire
Ram				-	1.5 m / 5 ft	DEX Save	2d6⁠Fire
Ram				-	1.5 m / 5 ft	DEX Save	6d6⁠Fire
Rolan's Firestorm				-	30 m / 100ft  6m / 20ft (Radius)	DEX Save	10d6⁠Fire 10d6⁠Force
Scorching Strike				2 turns	1.5 m / 5 ft	Attack Roll	Normal weapon damage 1d10⁠Fire
Searing Blood				2 turns	1.5 m / 5 ft	Attack Roll  CON Save	Normal weapon damage Proficiency bonus⁠Fire 1d6⁠Fire Proficiency bonus⁠Piercing
Self Immolation				2 turns	Self	-	1d4⁠Fire
Self-Detonate				-	Self  5m / 17ft	DEX Save	4d12 + 26⁠Fire
Self-Detonate				-	Self  10m / 33ft (Radius)	DEX Save	12d12 + 78⁠Fire
Slam				-	1.5 m / 5 ft  1.5m / 5ft (Radius)	Attack Roll	2d6 + Strength modifier⁠Bludgeoning 2d6⁠Fire
Smouldering Touch				2 turns	1.5 m / 5 ft  1m / 3ft (Radius)	Attack Roll	2d6⁠Fire
Sphere of Elemental Balance: Fire				-	18 m / 60 ft	Attack Roll	2d8⁠Fire
Spiderling Burst				-	2m / 7ft (Radius)	DEX Save	3d6⁠Fire
Sweeping Cinder Strike				-	5m / 17ft (Cone)	DEX Save	3d6⁠Fire
Targeting Protocol: Hellfire Missiles				-	18 m / 60ft	-	4d6⁠Fire
Volatile Cluster				2 turns	14m / 45ft	Attack Roll	2d4 + 2⁠Bludgeoning 4d8⁠Force 4d8⁠Fire
Fiery Bolt	C			-	8 m / 27ft	Attack Roll	1d4⁠Fire
Fire Bolt	C			-	18 m / 60ft	Attack Roll	1d10⁠Fire
Firebolt?	C			-	18 m / 60ft	Attack Roll	1d10⁠Fire
Hellflame Cleave	C			1 turn	3m / 10ft (Cone)	DEX Save	Normal weapon damage 2d6⁠Fire
Produce Flame	C			Long Rest	Self	-	1d8⁠Fire
Produce Flame: Hurl	C			-	9 m / 30ft	Attack Roll	1d8⁠Fire
Rays of Fire	C			-	18 m / 60 ft	Attack Roll	3d6⁠Fire 3d6⁠Fire 3d6⁠Fire
Burning Hands	1			-	Self  5m / 17ft (Cone)	DEX Save	3d6⁠Fire
Chromatic Orb: Fire	1			-	18 m / 60 ft	Attack Roll	2d8⁠Fire
Hellish Rebuke	1			-	-	-	2d10⁠Fire
Incongruent Splash	1			3 turns	Self  5m / 17ft (Cone)	DEX Save	3d6⁠Fire
Legacy of Avernus: Searing Smite	1			10 turns	Weapon Range	Attack Roll	Normal weapon damage 2d6⁠Fire 1d6⁠Fire
Searing Smite	1			10 turns	Weapon Range	Attack Roll	Normal weapon damage 1d6⁠Fire 1d6⁠Fire
Searing Smite	1			10 turns	1.5 m / 5 ft	Attack Roll  CON Save	Normal weapon damage 1d6⁠Fire 1d6⁠Fire
Flaming Sphere	2			-	18 m / 60 ft  2m / 7ft (Radius)	DEX Save	2d6⁠Fire
Heat Metal	2			-	18 m / 60 ft	CON Save	2d8⁠Fire
Rays of Fire	2			-	18 m / 60 ft	Attack Roll	3d6⁠Fire 3d6⁠Fire 3d6⁠Fire
Reapply Heat Metal	2			-	18 m / 60 ft	CON Save	2d8⁠Fire
Scorching Ray	2			-	18 m / 60 ft	Attack Roll	2d6⁠Fire 2d6⁠Fire 2d6⁠Fire
Fireball	3			-	18 m / 60ft  4m / 13ft (Radius)	DEX Save	8d6⁠Fire
Glyph of Warding: Fire	3			-	9 m / 30ft  4m / 13ft (Radius)	DEX Save	5d8⁠Fire
Fire Shield: Warm	4			10 turns	1.5 m / 5 ft	-	2d8⁠Fire
Igniting Spark	4			2 turns	18 m / 60ft	DEX Save	6d6⁠Fire
Rays of Fire	4			-	18 m / 60 ft	Attack Roll	3d6⁠Fire 3d6⁠Fire 3d6⁠Fire 3d6⁠Fire
Rolan's Fireball	4			10 turns	18 m / 60ft  4m / 13ft (Radius)	DEX Save	7d6⁠Fire
Wall of Fire	4			-	18 m / 60ft	DEX Save	5d8⁠Fire
Elemental Retort	5			-	18 m / 60ft	DEX Save	3d8⁠Lightning 3d8⁠Poison 3d8⁠Fire 3d8⁠Cold
Flame Strike	5			-	18 m / 60ft  3m / 10ft (Radius)	DEX Save	5d6⁠Fire 5d6⁠Radiant
Diabolic Chains	6			-	18 m / 60ft	DEX Save	6d6⁠Fire 6d6⁠Fire 6d6⁠Fire
Flames of Avernus	6			-	Self  5m / 17ft (Cone)	DEX Save	6d6⁠Fire
Hellfire Orb	6			-	18 m / 60ft  4m / 13ft (Radius)	DEX Save	20d6⁠Fire
Incinerate	6			-	3m / 10ft (Radius)	DEX Save	8d8⁠Fire
Ravaging Inferno	6			-	18 m / 60ft  4m / 13ft (Radius)	Attack Roll  DEX Save	20d6⁠Fire

Template data

No description.

Template parameters[Edit template data]

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

Subpages of this template.