Template:Spell table

Template documentation

This template generates a spell-oriented table filled with actions/spells from the actions Cargo table 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_1_type = "fire" 
OR damage_2_type = "fire" 
OR damage_3_type = "fire" 
OR damage_4_type = "fire"
}}

Renders as

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