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	-	1d4Fire
Blazing Retaliation				4 turns	Self	DEX save	1d6Fire
Burning Avarice				-	Self  4m / 13ft (Radius)	-	2d8 + 2Fire 1d6Fire
Burning Claws				-	1.5 m / 5 ft	Attack roll	1d4 + Strength or Dexterity modifierSlashing 1d4Fire
Burning Overflow				1 turn	Self  5m / 17ft (Radius)	-	6d6Fire
Cinderous Swipe				-	5m / 17ft (Cone)	DEX save	Normal weapon damage 2d6Fire
Death Burst				-	Self  2m / 7ft (Radius)	DEX save	2d6Fire
Detonate				-	2m / 7ft	-	100Fire
Divine Strike: Fire (Melee)				-	1.5 m / 5 ft	Attack roll	Normal weapon damage 1d8Fire
Divine Strike: Fire (Ranged)				-	18 m / 60 ft	Attack roll	Normal weapon damage 1d8Fire
Embrace of the Inferno				-	18 m / 60 ft	Attack roll	2d6Fire 2d6Fire 2d6Fire
Erupting Cinder				-	18 m / 60 ft  3m / 10ft (Radius)	DEX save	4d6Fire
Fangs of the Fire Snake				1 turn	6 m / 20ft	Attack roll	UnarmedBludgeoning 1d10Fire
Fiendish Flameblast				2 turns	2m / 7ft (Radius)	-	4d8Force 4d8Fire
Fiery Regurgitation				-	4 m / 13ft  2m / 7ft (Radius)	CON save	6d10 + Strength modifierFire
Fire Breath				-	Self  5m / 17ft	DEX save	2d6Fire
Fire Breath				-	5m / 17ft (Cone)	DEX save	2d6Fire
Fire Breath				-	Self  5m / 17ft (Cone)	DEX save	2d6Fire
Fire Breath				2 turns	30 m / 100ft  6m / 20ft (Radius)	DEX save	14d6Fire
Firewine Explosion				-	4m / 13ft (Radius)	DEX save	2d6Fire
Flames of the Phoenix				-	18 m / 60 ft  4m / 13ft (Radius)	DEX save	8d6Fire
Flaming Blade				-	1.5 m / 5 ft	Attack roll	1d8Bludgeoning 2d6Fire
Flaming Fury				-	Weapon Range	Attack roll	Normal weapon damage 3d6Fire
Forever Indebted				-	3 m / 10ft  4m / 13ft (Radius)	DEX save	6d8Fire
Hellcrawler				-	18 m / 60ft  3m / 10ft (Radius)	DEX save	2d8Fire
Hellfire Exhaust				1 turn	Self  3m / 10ft (Cone)	DEX save	3d8Fire 3d8Fire
Hellfire Missiles				-	100 m / 333ft  6m / 20ft (Radius)	DEX save	4d6Fire
Immolating Gaze				3 turns	9 m / 30ft	INT save	2d8Fire
Incinerate				3 turns	5m / 17ft (Cone)	DEX save	10d6Fire
Incineration Caster: Overheat				-	4m / 13ft (Radius)	DEX save	8d8Fire
Kith'raki Inferno				-	30 m / 100ft	DEX save	12d6Fire
Lorroakan's Firestorm				-	30 m / 100ft  6m / 20ft (Radius)	DEX save	10d6Fire 10d6Force
Multiattack				-	1.5 m / 5 ft	Attack roll	2d6 + Strength modifierBludgeoning 2d6Fire 2d6 + Strength modifierBludgeoning 2d6Fire
Multiattack				-	1.5 m / 5 ft	Attack roll	2d4 + Strength modifierBludgeoning 2d4Fire 2d4 + Strength modifierBludgeoning 2d4Fire
Multiattack				2 turns	4 m / 13ft	Attack roll	4d8 + Strength modifierBludgeoning 3d8 + Strength modifierPiercing 4d6Fire
Overheat				3 turns	Self  2m / 7ft (Radius)	CON save	1d10Fire
Ram				-	1.5 m / 5 ft	DEX save	2d6Fire
Ram				-	1.5 m / 5 ft	DEX save	6d6Fire
Rolan's Firestorm				-	30 m / 100ft  6m / 20ft (Radius)	DEX save	10d6Fire 10d6Force
Scorching Strike				2 turns	-	Attack roll	Normal weapon damage 1d10Fire
Searing Blood				2 turns	-	Attack roll	Normal weapon damage Proficiency bonusFire 1d6Fire
Self Immolation				2 turns	Self	-	1d4Fire
Self-Detonate				-	Self  5m / 17ft	DEX save	4d12 + 26Fire
Self-Detonate				-	Self  10m / 33ft (Radius)	DEX save	12d12 + 78Fire
Slam				-	1.5 m / 5 ft  1.5m / 5ft (Radius)	Attack roll	2d6 + Strength modifierBludgeoning 2d6Fire
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
Spiderling Burst				-	2m / 7ft (Radius)	DEX save	3d6Fire
Sweeping Cinder Strike				-	5m / 17ft (Cone)	DEX save	3d6Fire
Targeting Protocol: Hellfire Missiles				-	18 m / 60ft	-	4d6Fire
Volatile Cluster				2 turns	14m / 45ft	Attack roll	2d4 + 2Bludgeoning 4d8Force 4d8Fire
Fiery Bolt	C			-	8 m / 27ft	Attack roll	1d4Fire
Fire Bolt	C			-	18 m / 60ft	Attack roll	1d10Fire
Firebolt?	C			-	18 m / 60ft	Attack roll	1d10Fire
Hellflame Cleave	C			1 turn	3m / 10ft (Cone)	DEX save	Normal weapon damage 2d6Fire
Produce Flame	C			Long Rest	Self	-	1d8Fire
Produce Flame: Hurl	C			-	9 m / 30ft	Attack roll	1d8Fire
Rays of Fire	C			-	18 m / 60 ft	Attack roll	3d6Fire 3d6Fire 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			-	-	-	2d10Fire
Incongruent Splash	1			3 turns	Self  5m / 17ft (Cone)	DEX save	3d6Fire
Legacy of Avernus: Searing Smite	1			10 turns	Weapon Range	Attack roll	Normal weapon damage 2d6Fire 1d6Fire
Searing Smite	1			10 turns	Weapon Range	Attack roll	Normal weapon damage 1d6Fire 1d6Fire
Searing Smite	1			10 turns	1.5 m / 5 ft	Attack roll CON save	Normal weapon damage 1d6Fire 1d6Fire
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 3d6Fire 3d6Fire
Reapply Heat Metal	2			10 turns	18 m / 60 ft	CON save	2d8Fire
Scorching Ray	2			-	18 m / 60 ft	Attack roll	2d6Fire 2d6Fire 2d6Fire
Fireball	3			-	18 m / 60ft  4m / 13ft (Radius)	DEX save	8d6Fire
Glyph of Warding: Fire	3			-	9 m / 30ft  4m / 13ft (Radius)	DEX save	5d8Fire
Fire Shield: Warm	4			10 turns	1.5 m / 5 ft	-	2d8Fire
Igniting Spark	4			2 turns	18 m / 60ft	DEX save	6d6Fire
Wall of Fire	4			-	18 m / 60ft	DEX save	5d8Fire
Elemental Retort	5			-	18 m / 60ft	DEX save	3d8Lightning 3d8Poison 3d8Fire 3d8Cold
Flame Strike	5			-	18 m / 60ft  3m / 10ft (Radius)	DEX save	5d6Fire 5d6Radiant
Diabolic Chains	6			-	18 m / 60ft	DEX save	6d6Fire 6d6Fire 6d6Fire
Flames of Avernus	6			-	Self  5m / 17ft (Cone)	DEX save	6d6Fire
Hellfire Orb	6			-	18 m / 60ft  4m / 13ft (Radius)	DEX save	20d6Fire
Incinerate	6			-	3m / 10ft (Radius)	DEX save	8d8Fire
Ravaging Inferno	6			-	18 m / 60ft  4m / 13ft (Radius)	Attack roll DEX save	20d6Fire

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.