Template:Spell table: Difference between revisions

From bg3.wiki
Jump to navigation Jump to search
← Older editNewer edit →
VisualWikitext
Bandaid fix to avoid issue with intro/outro parameters not being parsed correctly. This workaround will cause issues with queries that return no results, but should work otherwise
Tag: Reverted
Undo revision 234340 by NtCarlson (talk)
Tag: Undo
Line 1: Line 1:
<includeonly>{{Spell list table row/header}}{{#cargo_query:
<includeonly>{{#cargo_query:
tables = spells
tables = spells
|fields= _pageName=spell, controller_icon, name, is_spell, is_concentration=conc, is_ritual=ritual, action_type=casttime, spell_level=level, can_upcast=upcastable, spell_range=range, aoe, aoe_size=area, has_attack_roll=attack, {{#if:save|save|damage_save}}=save, damage, damage_type, extra_damage, extra_damage_type, condition_duration=duration
|fields= _pageName=spell, controller_icon, name, is_spell, is_concentration=conc, is_ritual=ritual, action_type=casttime, spell_level=level, can_upcast=upcastable, spell_range=range, aoe, aoe_size=area, has_attack_roll=attack, {{#if:save|save|damage_save}}=save, damage, damage_type, extra_damage, extra_damage_type, condition_duration=duration
Line 5: Line 5:
|order by=spell_level,name
|order by=spell_level,name
|limit=500
|limit=500
|intro={{Spell list table row/header}}
|outro={{Spell list table row/footer}}
|more results text=
|more results text=
|format=template
|format=template
|template=Spell list table row
|template=Spell list table row
|named args=yes
|named args=yes
}}{{Spell list table row/footer}}</includeonly><noinclude>
}}</includeonly><noinclude>
This template generates a table filled with spells that satisfy the provided condition. It requires some knowledge of SQL to operate.
This template generates a table filled with spells that satisfy the provided condition. It requires some knowledge of SQL to operate.


Revision as of 06:42, 5 October 2024

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
Alchemist's Fire Alchemist's Fire Bonus Action  5 turns  30m / 100ft
-
 1d4Damage TypesFire
Blazing Retaliation Blazing Retaliation Bonus Action  4 turns  Self 1d6Damage TypesFire
Burning Avarice Burning Avarice Action
-
  m / ft
 4m / 13ft (Radius)
-
 2d8+2Damage TypesFire
1d6Damage TypesFire
Burning Overflow Burning Overflow Action  1 turn  m / ft
 5m / 16ft (Radius)
-
 6d6Damage TypesFire
Cinderous Swipe Cinderous Swipe Action
-
  m / ft
 5m / 16ft (Cone)		 weaponDamage TypesFire
1d6Damage TypesFire
Death Burst Death Burst Action
-
  m / ft
 2m / 6.5ft (Radius)		 2d6Damage TypesFire
Detonate Detonate Action
-
  m / ft
 2m / 6.5ft
-
 100Damage TypesFire
Embrace of the Inferno Embrace of the Inferno Action
-
  18 m / 60 ft Attack roll 2d6Damage TypesFire
Erupting Cinder Erupting Cinder Action
-
  18 m / 60 ft
 3m / 10ft (Radius)		 4d6Damage TypesFire
Fiery Regurgitation Fiery Regurgitation Action
-
  4m / ft
 2m / ft (Radius)		 6d10Damage TypesFire
Fire Breath Fire Breath Action
-
  Self
 5m / 17ft (Cone)		 2d6Damage TypesFire
Fire Breath Fire Breath Action
-
  Self
 5m / 17ft		 2d6Damage TypesFire
Fire Breath Fire Breath Action
-
  30m / 100ft 14d6Damage TypesFire
Fire Breath (Magma Mephit) Fire Breath (Magma Mephit) Action
-
  m / ft
 5m / 16ft (Cone)		 2d6Damage TypesFire
Firewine Explosion Firewine Explosion Action
-
  m / ft
 4m / 13ft (Radius)
-
 2d6Damage TypesFire
Flames of the Phoenix Flames of the Phoenix Action
-
  18 m / 60 ft
 4m / 13ft (Radius)		 8d6Damage TypesFire
Forever Indebted Forever Indebted Action
-
  3m / 10ft
 4m / 13ft (Radius)		 6d8Damage TypesFire
Hellcrawler Hellcrawler Bonus Action
-
  18m / 60ft
-
 2d8Damage TypesFire
Hellfire Exhaust Hellfire Exhaust Action  1 turn  18 m / 60 ft 3d8Damage TypesFire
3d8Damage TypesFire
Hellfire Missiles Hellfire Missiles Action
-
  100m / 333ft 96d6Damage TypesFire
Immolating Gaze Immolating Gaze Action  3 turns  9m / 30ft 2d8Damage TypesFire
Incinerate Incinerate Action
-
  m / ft
 5m / 17ft (Cone)		 10d6Damage TypesFire
Incineration Caster: Overheat Incineration Caster: Overheat Action
-
  m / ft 8d8Damage TypesFire
Kith'raki Inferno Kith'raki Inferno Action
-
  30m / 60ft 12d6Damage TypesFire
Lorroakan's Firestorm Lorroakan's Firestorm Action
-
  18m / 60ft
 6m / 12ft (Radius)		 10d6Damage TypesFire
10d6Damage TypesForce
Overheat Overheat Bonus Action  3 turns  Self
 2m / 7ft (Radius)		 1d10Damage TypesFire
Ram Ram Bonus Action
-
  1.5 m / 5 ft 2d6Damage TypesFire
Ram Ram Bonus Action
-
  1.5 m / 5 ft 6d6Damage TypesFire
Rolan's Firestorm Rolan's Firestorm Action
-
  18m / 60ft
 6m / 12ft (Radius)		 10d6Damage TypesFire
10d6Damage TypesForce
Self-Detonate Self-Detonate Action
-
  Self
 5m / 15ft		 4d12+26Damage TypesFire
Self-Detonate Self-Detonate Action
-
  5m / 15ft 12d12+78Damage TypesFire
Smouldering Touch Smouldering Touch Action  2 turns  1.5 m / 5 ft
 1m / 3ft (Radius)		 Attack roll 2d6Damage TypesFire
Sphere of Elemental Balance: Fire Sphere of Elemental Balance: Fire Action
-
  18 m / 60 ft Attack roll 2d8Damage TypesFire
Sweeping Cinder Strike Sweeping Cinder Strike Action
-
  m / ft
 5m / 17ft (Cone)		 3d6Damage TypesFire
Fiery Bolt Fiery Bolt C Action
-
  8m / 25ft Attack roll 1d4Damage TypesFire
Fire Bolt Fire Bolt C Action
-
  18m / 60ft Attack roll 1d10Damage TypesFire
Firebolt? Firebolt? C Action
-
  18m / 60ft Attack roll 1d10Damage TypesFire
Hellflame Cleave Hellflame Cleave C Action  1 turn  m / ft
 3m / 10ft (Cone)		 weaponDamage TypesFire
2d6Damage TypesFire
Produce Flame: Hurl Produce Flame: Hurl C Action
-
  9m / 30ft Attack roll 1d8Damage TypesFire
Rays of Fire Rays of Fire C Action
-
  18 m / 60 ft Attack roll 3d6Damage TypesFire
Burning Hands Burning Hands 1 Action
-
  Self
 5m / 17ft (Cone)		 3d6Damage TypesFire
Chromatic Orb: Fire Chromatic Orb: Fire 1 Action
-
  18 m / 60 ft Attack roll 2d8Damage TypesFire
Hellish Rebuke Hellish Rebuke 1 Reaction
-
  m / ft
-
 2d10Damage TypesFire
Flaming Sphere Flaming Sphere  2 Action
-
  18 m / 60 ft
 2m / 7ft (Radius)		 2d6Damage TypesFire
Heat Metal Heat Metal  2 Action  10 turns  18 m / 60 ft 2d8Damage TypesFire
Rays of Fire Rays of Fire 2 Action
-
  18 m / 60 ft Attack roll 3d6Damage TypesFire
Reapply Heat Metal Reapply Heat Metal  2 Bonus Action  10 turns  18 m / 60 ft 2d8Damage TypesFire
Scorching Ray Scorching Ray 2 Action
-
  18 m / 60 ft Attack roll 2d6Damage TypesFire
Fireball Fireball 3 Action
-
  18m / 60ft
 4m / 13ft (Radius)		 8d6Damage TypesFire
Glyph of Warding: Fire Glyph of Warding: Fire 3 Action
-
  9m / 30ft
 4m / 13ft (Radius)		 5d8Damage TypesFire
Igniting Spark Igniting Spark 4 Action  2 turns  18m / 60ft 6d6Damage TypesFire
Wall of Fire Wall of Fire  4 Action
-
  18m / 60ft 5d8Damage TypesFire
Flame Strike Flame Strike 5 Action
-
  18m / 60ft
 3m / 10ft (Radius)		 5d6Damage TypesFire
5d6Damage TypesRadiant
Diabolic Chains Diabolic Chains 6 Action
-
  18m / 60ft 6d6Damage TypesFire
Hellfire Orb Hellfire Orb 6 Action
-
  18m / 60ft
 4m / 13ft (Radius)		 20d6Damage TypesFire
Incinerate Incinerate 6 Action
-
  m / ft
 3m / 10ft (Radius)		 8d8Damage TypesFire
Ravaging Inferno Ravaging Inferno 6 Action
-
  18m / 60ft
 4m / ft (Radius)		 Attack roll 20d6Damage TypesFire

Template data

No description.

Template parameters[Edit template data]

ParameterDescriptionTypeStatus
wherewhere

A "where" clause for the SQL query.

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