Template:Spell table: Difference between revisions
Jump to navigation
Jump to search
bump limit higher :( |
HiddenDragon (talk | contribs) Add cargo template |
||
(9 intermediate revisions by 4 users not shown) | |||
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 | |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 | ||
|where={{{where|_pageName = "Firebolt?"}}} | |where={{{where|_pageName = "Firebolt?"}}} | ||
|order by=spell_level, | |order by=spell_level,name | ||
|limit=500 | |limit=500 | ||
|intro={{Spell list table row/header}} | |intro={{Spell list table row/header}} | ||
Line 11: | Line 11: | ||
|template=Spell list table row | |template=Spell list table row | ||
|named args=yes | |named args=yes | ||
}}</includeonly><noinclude> | }}</includeonly><noinclude>{{Documentation|content= | ||
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. | ||
Example | == Example == | ||
{{Template demo | |||
| style = list | |||
| <nowiki>{{Spell table | |||
|where=damage_type = "fire" | |where=damage_type = "fire" | ||
}} | }} | ||
</ | </nowiki> | ||
}} | }} | ||
== Template data == | == Template data == | ||
<templatedata> | <templatedata> | ||
Line 32: | Line 33: | ||
} | } | ||
} | } | ||
</templatedata></noinclude> | </templatedata> | ||
}} | |||
[[Category:Templates]] | |||
[[Category:Cargo templates]] | |||
</noinclude> |
Latest revision as of 22:22, 19 January 2025
Template documentation
This template generates a table filled with spells that satisfy the provided condition. It requires some knowledge of SQL to operate.
Example
Markup
{{Spell table |where=damage_type = "fire" }}Renders as
Name | Level | Cast time | Duration | Range/Area | Attack/Save | Damage/Effect | |
---|---|---|---|---|---|---|---|
![]() |
5 turns | 30m / 100ft | -
|
1d4Fire | |||
![]() |
4 turns | Self | 1d6Fire | ||||
![]() |
- |
4m / 13ft (Radius) |
m / ft -
|
2d8+2Fire 1d6Fire |
|||
![]() |
1 turn | 5m / 16ft (Radius) |
m / ft -
|
6d6Fire | |||
![]() |
- |
5m / 16ft (Cone) |
m / ft weaponFire 1d6Fire |
||||
![]() |
- |
2m / 6.5ft (Radius) |
m / ft 2d6Fire | ||||
![]() |
- |
2m / 6.5ft |
m / ft -
|
100Fire | |||
![]() |
- |
18 m / 60 ft | Attack roll | 2d6Fire | |||
![]() |
- |
3m / 10ft (Radius) |
18 m / 60 ft 4d6Fire | ||||
![]() |
- |
2m / ft (Radius) |
4m / ft 6d10Fire | ||||
![]() |
- |
5m / 17ft (Cone) |
Self 2d6Fire | ||||
![]() |
- |
5m / 17ft |
Self 2d6Fire | ||||
![]() |
- |
30m / 100ft | 14d6Fire | ||||
![]() |
- |
5m / 16ft (Cone) |
m / ft 2d6Fire | ||||
![]() |
- |
4m / 13ft (Radius) |
m / ft -
|
2d6Fire | |||
![]() |
- |
4m / 13ft (Radius) |
18 m / 60 ft 8d6Fire | ||||
![]() |
- |
4m / 13ft (Radius) |
3m / 10ft 6d8Fire | ||||
![]() |
- |
18m / 60ft | -
|
2d8Fire | |||
![]() |
1 turn | 18 m / 60 ft | 3d8Fire 3d8Fire |
||||
![]() |
- |
100m / 333ft | 96d6Fire | ||||
![]() |
3 turns | 9m / 30ft | 2d8Fire | ||||
![]() |
- |
5m / 17ft (Cone) |
m / ft 10d6Fire | ||||
![]() |
- |
m / ft | 8d8Fire | ||||
![]() |
- |
30m / 60ft | 12d6Fire | ||||
![]() |
- |
6m / 12ft (Radius) |
18m / 60ft 10d6Fire 10d6Force |
||||
![]() |
3 turns | 2m / 7ft (Radius) |
Self 1d10Fire | ||||
![]() |
- |
1.5 m / 5 ft | 2d6Fire | ||||
![]() |
- |
1.5 m / 5 ft | 6d6Fire | ||||
![]() |
- |
6m / 12ft (Radius) |
18m / 60ft 10d6Fire 10d6Force |
||||
![]() |
- |
5m / 15ft |
Self 4d12+26Fire | ||||
![]() |
- |
5m / 15ft | 12d12+78Fire | ||||
![]() |
2 turns | 1m / 3ft (Radius) |
1.5 m / 5 ft Attack roll | 2d6Fire | |||
![]() |
- |
18 m / 60 ft | Attack roll | 2d8Fire | |||
![]() |
- |
5m / 17ft (Cone) |
m / ft 3d6Fire | ||||
C | ![]() |
- |
8m / 25ft | Attack roll | 1d4Fire | ||
C | ![]() |
- |
18m / 60ft | Attack roll | 1d10Fire | ||
C | ![]() |
- |
18m / 60ft | Attack roll | 1d10Fire | ||
C | ![]() |
1 turn | 3m / 10ft (Cone) |
m / ft weaponFire 2d6Fire |
|||
C | ![]() |
- |
9m / 30ft | Attack roll | 1d8Fire | ||
C | ![]() |
- |
18 m / 60 ft | Attack roll | 3d6Fire | ||
1 | ![]() |
- |
5m / 17ft (Cone) |
Self 3d6Fire | |||
1 | ![]() |
- |
18 m / 60 ft | Attack roll | 2d8Fire | ||
1 | ![]() |
- |
m / ft | -
|
2d10Fire | ||
2 | ![]() |
- |
2m / 7ft (Radius) |
18 m / 60 ft 2d6Fire | |||
2 | ![]() |
10 turns | 18 m / 60 ft | 2d8Fire | |||
2 | ![]() |
- |
18 m / 60 ft | Attack roll | 3d6Fire | ||
2 | ![]() |
10 turns | 18 m / 60 ft | 2d8Fire | |||
2 | ![]() |
- |
18 m / 60 ft | Attack roll | 2d6Fire | ||
3 | ![]() |
- |
4m / 13ft (Radius) |
18m / 60ft 8d6Fire | |||
3 | ![]() |
- |
4m / 13ft (Radius) |
9m / 30ft 5d8Fire | |||
4 | ![]() |
2 turns | 18m / 60ft | 6d6Fire | |||
4 | ![]() |
- |
18m / 60ft | 5d8Fire | |||
5 | ![]() |
- |
3m / 10ft (Radius) |
18m / 60ft 5d6Fire 5d6Radiant |
|||
6 | ![]() |
- |
18m / 60ft | 6d6Fire | |||
6 | ![]() |
- |
4m / 13ft (Radius) |
18m / 60ft 20d6Fire | |||
6 | ![]() |
- |
3m / 10ft (Radius) |
m / ft 8d8Fire | |||
6 | ![]() |
- |
4m / ft (Radius) |
18m / 60ft Attack roll | 20d6Fire |
Template data
No description.
Parameter | Description | Type | Status | |
---|---|---|---|---|
where | where | A "where" clause for the SQL query. | Unknown | suggested |