Template:Spell table: Difference between revisions

From Baldur's Gate 3 Wiki
Jump to navigation Jump to search
(bump limit higher :()
No edit summary
Line 1: Line 1:
<includeonly>{{#cargo_query:
<includeonly>{{#cargo_query:
tables = spells
tables = spells
|fields= _pageName=spell, is_concentration=conc, is_ritual=ritual, action_type=casttime, description, spell_level=level, can_upcast=upcastable, spell_range=range, aoe, aoe_size=area, has_attack_roll=attack, damage_save=save, damage_type=damage, condition_duration=duration
|fields= _pageName=spell, name, is_concentration=conc, is_ritual=ritual, action_type=casttime, description, spell_level=level, can_upcast=upcastable, spell_range=range, aoe, aoe_size=area, has_attack_roll=attack, damage_save=save, damage_type=damage, condition_duration=duration
|where={{{where|_pageName = "Firebolt?"}}}
|where={{{where|_pageName = "Firebolt?"}}}
|order by=spell_level,_pageName
|order by=spell_level,name
|limit=500
|limit=500
|intro={{Spell list table row/header}}
|intro={{Spell list table row/header}}

Revision as of 20:44, 22 November 2023

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 (Action)|class=bg3wiki-icon ]] Alchemist's Fire (Action) Bonus Action  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 Bonus Action  4 turns  Self
-
 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 Action
-
  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 Action  1 turn  m / ft
 3m / 10ft (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 Action
-
  1.5 m / 5 ft
 5m / 16ft (Cone)
-
 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 Action
-
  m / ft
 2m / 6.5ft (Radius)
-
 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 Action
-
  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 Action
-
  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 Action
-
  18 m / 60 ft
 2m / 7ft (Radius)
-
 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 Action
-
  4m / ft
 2m / ft (Radius)
-
 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 Action
-
  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=Fire Breath (Cone)|x40px|alt=Fire Breath|class=bg3wiki-icon ]] Fire Breath Action
-
  Self
 5m / 17ft (Cone)
-
 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 Action
-
  Self
 5m / 17ft
-
 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) Action
-
  m / ft
 5m / 16ft (Cone)
-
 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 Action
-
  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 Action
-
  18 m / 60 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=Forever Indebted|x40px|alt=Forever Indebted|class=bg3wiki-icon ]] Forever Indebted Action
-
  3m / 10ft
 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=Hellcrawler|x40px|alt=Hellcrawler|class=bg3wiki-icon ]] Hellcrawler Bonus Action
-
  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 Action  1 turn  18 m / 60 ft
-
 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 Action
-
  100m / 333ft
-
 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 Action  3 turns  9m / 30ft 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 Action
-
  m / ft
 5m / 17ft (Cone)
-
 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 Action
-
  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=Kith'raki Inferno|x40px|alt=Kith'raki Inferno|class=bg3wiki-icon ]] Kith'raki Inferno Action
-
  30m / 60ft
-
 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 Action
-
  18m / 60ft
 6m / 12ft (Radius)
-
 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 Bonus Action  3 turns  1.5 m / 5 ft 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 Bonus Action
-
  1.5 m / 5 ft
-
 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 Bonus Action
-
  1.5 m / 5 ft
-
 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 Action
-
  18m / 60ft
 6m / 12ft (Radius)
-
 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 Action
-
  Self
-
 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 Action
-
  Self
-
 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 Action  2 turns  1.5 m / 5 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=Sphere of Elemental Balance: Fire|x40px|alt=Sphere of Elemental Balance: Fire|class=bg3wiki-icon ]] Sphere of Elemental Balance: Fire Action
-
  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 Action
-
  m / ft
 5m / 17ft (Cone)
-
 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 Action
-
  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 Action
-
  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 Action
-
  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=Produce Flame: Hurl|x40px|alt=Produce Flame: Hurl|class=bg3wiki-icon ]] Produce Flame: Hurl C Action
-
  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 Action
-
  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 Action
-
  Self
 5m / 17ft (Cone)		 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 Action
-
  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 Reaction
-
  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 Action
-
  18 m / 60 ft
 2m / 7ft (Radius)
-
 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 Action  10 turns  18 m / 60 ft
-
 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 Action
-
  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 Bonus Action  10 turns  18 m / 60 ft
-
 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 Action
-
  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 Action
-
  18m / 60ft
 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=Glyph of Warding: Fire|x40px|alt=Glyph of Warding: Fire|class=bg3wiki-icon ]] Glyph of Warding: Fire 3 Action
-
  9m / 30ft
 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=Igniting Spark|x40px|alt=Igniting Spark|class=bg3wiki-icon ]] Igniting Spark 4 Action
-
  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=Wall of Fire|x40px|alt=Wall of Fire|class=bg3wiki-icon ]] Wall of Fire  4 Action
-
  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=Flame Strike|x40px|alt=Flame Strike|class=bg3wiki-icon ]] Flame Strike 5 Action
-
  18 m / 60 ft
 3m / 10ft (Radius)
-
 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 Action
-
  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=Hellfire Orb|x40px|alt=Hellfire Orb|class=bg3wiki-icon ]] Hellfire Orb 6 Action
-
  18m / 60ft
 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=Incinerate|x40px|alt=Incinerate|class=bg3wiki-icon ]] Incinerate 6 Action
-
  m / ft
 3m / 10ft (Radius)
-
 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 Action
-
  18m / 60ft
 4m / ft (Radius)		 Attack roll 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

ParameterDescriptionTypeStatus
wherewhere

A "where" clause for the SQL query.

Unknownsuggested
Retrieved from "https://bg3.wiki/w/index.php?title=Template:Spell_table&oldid=115555"