Template:Spell table: Difference between revisions

From bg3.wiki
Jump to navigation Jump to search
(Create initial version)
 
(Update for new params)
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_range=spell_range, is_aoe=aoe, has_attack_roll=attack,damage_save=save,damage_type=damage
|fields= _pageName=spell, is_concentration=conc, is_ritual=ritual, action_type=casttime, description, spell_range=spell_range, aoe, has_attack_roll=attack, damage_save=save, damage_type=damage, condition_duration=duration
|where={{{where|_pageName = "Firebolt?"}}}
|where={{{where|_pageName = "Firebolt?"}}}
|order by=_pageName
|order by=_pageName

Revision as of 18:28, 16 October 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={{{name}}}|class=bg3wiki-icon ]] {{{name}}} Bonus Action  5 turns  {{{range}}}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=Blazing Retaliation|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}} Bonus Action  4 turns  {{{range}}}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=Burning Avarice|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}} Action
-
  {{{range}}}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=Burning Hands|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}} Action
-
  {{{range}}}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=Burning Overflow|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}} Action  1 turn  {{{range}}}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=Chromatic Orb: Fire|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}} Action
-
  {{{range}}}m / 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=Cinderous Swipe|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}} Action
-
  {{{range}}}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=Death Burst (Fire)|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}} Action
-
  {{{range}}}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=Detonate|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}} Action
-
  {{{range}}}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=Diabolic Chains|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}} Action
-
  {{{range}}}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=Embrace of the Inferno|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}} Action
-
  {{{range}}}m / 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={{{name}}}|class=bg3wiki-icon ]] {{{name}}} Action
-
  {{{range}}}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=Fiery Bolt|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}} Action
-
  {{{range}}}m / 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=Fiery Regurgitation|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}} Action
-
  {{{range}}}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=Fire Bolt|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}} Action
-
  {{{range}}}m / 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=Fire Breath (Cone)|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}} Action
-
  {{{range}}}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=Fire Breath (Dragons)|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}} Action
-
  {{{range}}}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=Fire Breath (Line)|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}} Action
-
  {{{range}}}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=Fire Breath (Magma Mephit)|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}} Action
-
  {{{range}}}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=Fireball|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}} Action
-
  {{{range}}}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=Firebolt?|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}} Action
-
  {{{range}}}m / 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=Firewine Explosion|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}} Action
-
  {{{range}}}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=Flame Strike|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}} Action
-
  {{{range}}}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=Flames of the Phoenix|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}} Action
-
  {{{range}}}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={{{name}}}|class=bg3wiki-icon ]] {{{name}}}  Action
-
  {{{range}}}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=Forever Indebted|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}} Action
-
  {{{range}}}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=Glyph of Warding: Fire|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}} Action
-
  {{{range}}}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=Heat Metal|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}}  Action  10 turns  {{{range}}}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=Heat Metal: Reapply Damage|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}}  Bonus Action  10 turns  {{{range}}}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=Hellcrawler|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}} Bonus Action
-
  {{{range}}}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=Hellfire Exhaust|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}} Action  1 turn  {{{range}}}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=Hellfire Missiles|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}} Action
-
  {{{range}}}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=Hellfire Orb|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}} Action
-
  {{{range}}}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=Hellflame Cleave|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}} Action  1 turn  {{{range}}}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=Hellish Rebuke|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}} Reaction
-
  {{{range}}}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=Igniting Spark|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}} Action  2 turns  {{{range}}}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=Immolating Gaze|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}} Action  3 turns  {{{range}}}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=Incinerate|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}} Action
-
  {{{range}}}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=Incinerate (Incineration Caster)|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}} Action
-
  {{{range}}}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=Incineration Caster: Overheat|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}} Action
-
  {{{range}}}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={{{name}}}|class=bg3wiki-icon ]] {{{name}}} Action
-
  {{{range}}}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=Lorroakan's Firestorm|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}} Action
-
  {{{range}}}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=Overheat|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}} Bonus Action  3 turns  {{{range}}}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=Produce Flame: Hurl|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}} Action
-
  {{{range}}}m / 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=Ram|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}} Bonus Action
-
  {{{range}}}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=Ram (Hell Sphere)|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}} Bonus Action
-
  {{{range}}}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=Ravaging Inferno|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}} Action
-
  {{{range}}}m / 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=Rays of Fire|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}} Action
-
  {{{range}}}m / 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=Rays of Fire (Cantrip)|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}} Action
-
  {{{range}}}m / 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=Rolan's Firestorm|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}} Action
-
  {{{range}}}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=Scorching Ray|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}} Action
-
  {{{range}}}m / 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=Self-Detonate|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}} Action
-
  {{{range}}}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=Self-Detonate (Steel Watcher Titan)|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}} Action
-
  {{{range}}}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=Smouldering Touch|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}} Action  2 turns  {{{range}}}m / 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={{{name}}}|class=bg3wiki-icon ]] {{{name}}} Action
-
  {{{range}}}m / 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={{{name}}}|class=bg3wiki-icon ]] {{{name}}} Action
-
  {{{range}}}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=Wall of Fire|x40px|alt={{{name}}}|class=bg3wiki-icon ]] {{{name}}}  Action
-
  {{{range}}}m / ft
-
 Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}}

Template data

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