Template:Spell table: Difference between revisions
Jump to navigation
Jump to search
m same as last |
properly add aoe area |
||
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, aoe=area, has_attack_roll=attack, damage_save=save, damage_type=damage, condition_duration=duration | |fields= _pageName=spell, is_concentration=conc, is_ritual=ritual, action_type=casttime, description, spell_range=spell_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=_pageName | |order by=_pageName |
Revision as of 18:33, 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 | |
---|---|---|---|---|---|---|---|
![]() |
5 turns | {{{range}}}m / ft | -
|
Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | |||
![]() |
4 turns | {{{range}}}m / ft | -
|
Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | |||
![]() |
- |
4m / 13ft (Radius) |
{{{range}}}m / ft -
|
Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | |||
![]() |
- |
5m / 17ft (Cone) |
{{{range}}}m / ft Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | ||||
![]() |
1 turn | 5m / 16ft (Radius) |
{{{range}}}m / ft -
|
Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | |||
![]() |
- |
{{{range}}}m / ft | Attack roll | Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | |||
![]() |
- |
5m / 16ft (Cone) |
{{{range}}}m / ft -
|
Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | |||
![]() |
- |
2m / 6.5ft (Radius) |
{{{range}}}m / ft -
|
Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | |||
![]() |
- |
2m / 6.5ft |
{{{range}}}m / ft -
|
Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | |||
![]() |
- |
{{{range}}}m / ft | Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | ||||
![]() |
- |
{{{range}}}m / ft | Attack roll | Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | |||
![]() |
- |
3m / 10ft (Radius) |
{{{range}}}m / ft -
|
Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | |||
![]() |
- |
{{{range}}}m / ft | Attack roll | Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | |||
![]() |
- |
2m / ft (Radius) |
{{{range}}}m / ft -
|
Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | |||
![]() |
- |
{{{range}}}m / ft | Attack roll | Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | |||
![]() |
- |
5m / 17ft (Cone) |
{{{range}}}m / ft -
|
Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | |||
![]() |
- |
{{{range}}}m / ft | -
|
Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | |||
![]() |
- |
5m / 17ft |
{{{range}}}m / ft -
|
Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | |||
![]() |
- |
5m / 16ft (Cone) |
{{{range}}}m / ft -
|
Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | |||
![]() |
- |
4m / 13ft (Radius) |
{{{range}}}m / ft -
|
Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | |||
![]() |
- |
{{{range}}}m / ft | Attack roll | Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | |||
![]() |
- |
4m / 13ft (Radius) |
{{{range}}}m / ft -
|
Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | |||
![]() |
- |
3m / 10ft (Radius) |
{{{range}}}m / ft -
|
Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | |||
![]() |
- |
4m / 13ft (Radius) |
{{{range}}}m / ft -
|
Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | |||
![]() |
- |
2m / 7ft (Radius) |
{{{range}}}m / ft -
|
Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | |||
![]() |
- |
4m / 13ft (Radius) |
{{{range}}}m / ft -
|
Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | |||
![]() |
- |
4m / 13ft (Radius) |
{{{range}}}m / ft -
|
Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | |||
![]() |
10 turns | {{{range}}}m / ft | Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | ||||
![]() |
10 turns | {{{range}}}m / ft | -
|
Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | |||
![]() |
- |
{{{range}}}m / ft | -
|
Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | |||
![]() |
1 turn | {{{range}}}m / ft | -
|
Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | |||
![]() |
- |
{{{range}}}m / ft | -
|
Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | |||
![]() |
- |
4m / 13ft (Radius) |
{{{range}}}m / ft -
|
Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | |||
![]() |
1 turn | 3m / 10ft (Cone) |
{{{range}}}m / ft Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | ||||
![]() |
- |
{{{range}}}m / ft | Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | ||||
![]() |
2 turns | {{{range}}}m / ft | Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | ||||
![]() |
3 turns | {{{range}}}m / ft | Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | ||||
![]() |
- |
3m / 10ft (Radius) |
{{{range}}}m / ft -
|
Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | |||
![]() |
- |
5m / 17ft (Cone) |
{{{range}}}m / ft -
|
Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | |||
![]() |
- |
{{{range}}}m / ft | -
|
Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | |||
![]() |
- |
{{{range}}}m / ft | -
|
Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | |||
![]() |
- |
6m / 12ft (Radius) |
{{{range}}}m / ft -
|
Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | |||
![]() |
3 turns | 2m / 7ft (Radius) |
{{{range}}}m / ft Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | ||||
![]() |
- |
{{{range}}}m / ft | Attack roll | Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | |||
![]() |
- |
{{{range}}}m / ft | -
|
Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | |||
![]() |
- |
{{{range}}}m / ft | -
|
Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | |||
![]() |
- |
4m / ft (Radius) |
{{{range}}}m / ft Attack roll | Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | |||
![]() |
- |
{{{range}}}m / ft | Attack roll | Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | |||
![]() |
- |
{{{range}}}m / ft | Attack roll | Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | |||
![]() |
- |
6m / 12ft (Radius) |
{{{range}}}m / ft -
|
Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | |||
![]() |
- |
{{{range}}}m / ft | Attack roll | Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | |||
![]() |
- |
5m / 15ft |
{{{range}}}m / ft -
|
Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | |||
![]() |
- |
{{{range}}}m / ft | -
|
Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | |||
![]() |
2 turns | 1m / 3ft (Radius) |
{{{range}}}m / ft Attack roll | Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | |||
![]() |
- |
{{{range}}}m / ft | Attack roll | Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | |||
![]() |
- |
5m / 17ft (Cone) |
{{{range}}}m / ft -
|
Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} | |||
![]() |
- |
{{{range}}}m / ft | -
|
Fire[[File:{{{damage type}}} Damage Icon.png|link=Damage Types|x25px|alt=Damage Types|class=bg3wiki-icon ]]{{{damage type}}} |