Template:Spell table: Difference between revisions
Jump to navigation
Jump to search
HiddenDragon (talk | contribs) No edit summary |
(The save field now uses the save parameter, and only if that is empty it checks the damage save parameter,) |
||
Line 1: | Line 1: | ||
<includeonly>{{#cargo_query: | <includeonly>{{#cargo_query: | ||
tables = spells | tables = spells | ||
|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 | |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, {{#if:save|save|damage_save}}=save, damage_type=damage, condition_duration=duration | ||
|where={{{where|_pageName = "Firebolt?"}}} | |where={{{where|_pageName = "Firebolt?"}}} | ||
|order by=spell_level,name | |order by=spell_level,name |
Revision as of 10:25, 19 January 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 | |
---|---|---|---|---|---|---|---|
![]() |
![]() |
![]() |
-
|
Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | |||
![]() |
![]() |
![]() |
Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | ||||
![]() |
- |
![]() ![]() |
-
|
Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | |||
![]() |
![]() |
![]() ![]() |
-
|
Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | |||
![]() |
- |
![]() ![]() |
Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | ||||
![]() |
- |
![]() ![]() |
Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | ||||
![]() |
- |
![]() ![]() |
-
|
Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | |||
![]() |
- |
![]() |
![]() |
Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | |||
![]() |
- |
![]() ![]() |
Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | ||||
![]() |
- |
![]() ![]() |
Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | ||||
![]() |
- |
![]() |
Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | ||||
![]() |
- |
![]() ![]() |
Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | ||||
![]() |
- |
![]() ![]() |
Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | ||||
![]() |
- |
![]() ![]() |
Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | ||||
![]() |
- |
![]() ![]() |
-
|
Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | |||
![]() |
- |
![]() ![]() |
Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | ||||
![]() |
- |
![]() ![]() |
Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | ||||
![]() |
- |
![]() |
-
|
Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | |||
![]() |
![]() |
![]() |
Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | ||||
![]() |
- |
![]() |
Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | ||||
![]() |
![]() |
![]() |
Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | ||||
![]() |
- |
![]() ![]() |
Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | ||||
![]() |
- |
![]() |
Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | ||||
![]() |
- |
![]() |
Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | ||||
![]() |
- |
![]() ![]() |
Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | ||||
![]() |
![]() |
![]() ![]() |
Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | ||||
![]() |
- |
![]() |
Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | ||||
![]() |
- |
![]() |
Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | ||||
![]() |
- |
![]() ![]() |
Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | ||||
![]() |
- |
![]() |
Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | ||||
![]() |
- |
![]() |
Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | ||||
![]() |
![]() |
![]() |
![]() |
Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | |||
![]() |
- |
![]() |
![]() |
Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | |||
![]() |
- |
![]() ![]() |
Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | ||||
C | ![]() |
- |
![]() |
![]() |
Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | ||
C | ![]() |
- |
![]() |
![]() |
Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | ||
C | ![]() |
- |
![]() |
-
|
Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | ||
C | ![]() |
- |
![]() |
![]() |
Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | ||
C | ![]() |
- |
![]() |
![]() |
Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | ||
1 | ![]() |
- |
![]() ![]() |
Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | |||
1 | ![]() |
- |
![]() |
![]() |
Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | ||
1 | ![]() |
- |
![]() |
-
|
Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | ||
![]() |
2 | ![]() |
- |
![]() ![]() |
Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | ||
![]() |
2 | ![]() |
![]() |
![]() |
Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | ||
2 | ![]() |
- |
![]() |
![]() |
Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | ||
![]() |
2 | ![]() |
![]() |
![]() |
Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | ||
2 | ![]() |
- |
![]() |
![]() |
Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | ||
3 | ![]() |
- |
![]() ![]() |
Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | |||
3 | ![]() |
- |
![]() ![]() |
Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | |||
4 | ![]() |
- |
![]() |
![]() |
Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | ||
![]() |
4 | ![]() |
- |
![]() |
Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | ||
5 | ![]() |
- |
![]() ![]() |
Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | |||
6 | ![]() |
- |
![]() |
![]() |
Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | ||
6 | ![]() |
- |
![]() ![]() |
Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | |||
6 | ![]() |
- |
![]() ![]() |
Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | |||
6 | ![]() |
- |
![]() ![]() |
![]() |
Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} |
Template data
No description.
Parameter | Description | Type | Status | |
---|---|---|---|---|
where | where | A "where" clause for the SQL query. | Unknown | suggested |