User:Toancaro/Cleric/Template:ExtraSpellTable: Difference between revisions
mNo edit summary |
mNo edit summary |
||
| Line 14: | Line 14: | ||
{{#vardefine: spellNamesQuery3 | {{#replace:{{#var: query3}} | OR | <nowiki/> <nowiki/>OR<nowiki/> <nowiki/>}}}} | {{#vardefine: spellNamesQuery3 | {{#replace:{{#var: query3}} | OR | <nowiki/> <nowiki/>OR<nowiki/> <nowiki/>}}}} | ||
{{#vardefine: spellNamesQuery | {{#var: spellNamesQuery1}} | {{#vardefine: spellNamesQuery | {{#var: spellNamesQuery1}} AND {{#var: spellNamesQuery3}} AND {{#var: spellNamesQuery3}} }} | ||
Test: {{#var: | {{#vardefine: finalQuery | ({{#var: spellNamesQuery}}) AND {{#if: {{{where|}}} | {{{where}}} | TRUE}} }} | ||
Test: {{#var: finalQuery }} | |||
{{#cargo_query: | {{#cargo_query: | ||
tables = spells | tables = spells | ||
| fields=_pageName=spell,name,classes,description,spell_school,damage_type=damage | | fields=_pageName=spell,name,classes,description,spell_school,damage_type=damage | ||
| where= | | where={{#var: finalQuery }} | ||
| intro={{User:Toancaro/Cleric/Template:ExtraSpellTable/Header}} | | intro={{User:Toancaro/Cleric/Template:ExtraSpellTable/Header}} | ||
| outro={{User:Toancaro/Cleric/Template:ExtraSpellTable/Footer}} | | outro={{User:Toancaro/Cleric/Template:ExtraSpellTable/Footer}} | ||
| Line 29: | Line 32: | ||
</includeonly> | </includeonly> | ||
<noinclude> | <noinclude> | ||
{{User:Toancaro/Cleric/Template:ExtraSpellTable | |||
| where=spell_level="0" | | where=spell_level="0" | ||
}} | }} | ||
</noinclude> | </noinclude> | ||
Revision as of 08:11, 6 January 2024
Test: (_pageName = "Aid" OR _pageName = "Animal Friendship" OR _pageName = "Barkskin" OR _pageName = "Beacon of Hope" OR _pageName = "Bestow Curse" OR _pageName = "Bless" OR _pageName = "Burning Hands" OR _pageName = "Call Lightning" OR _pageName = "Calm Emotions" OR _pageName = "Charm Person" OR _pageName = "Command" OR _pageName = "Confusion" OR _pageName = "Crusader's Mantle" OR _pageName = "Cure Wounds" OR _pageName = "Daylight" OR _pageName = "Death Ward" OR _pageName = "Destructive Wave" OR _pageName = "Dimension Door" OR _pageName = "Disguise Self" OR _pageName = "Divine Favour" OR _pageName = "Dominate Beast" OR _pageName = "Dominate Person" OR _pageName = "Faerie Fire" OR _pageName = "Fear" OR _pageName = "Fireball" AND _pageName = "Seeming" OR _pageName = "Shatter" OR _pageName = "Shield of Faith" OR _pageName = "Shillelagh" OR _pageName = "Sleep" OR _pageName = "Sleet Storm" OR _pageName = "Slow" OR _pageName = "Speak with Animals" OR _pageName = "Speak with Dead" OR _pageName = "Spike Growth" OR _pageName = "Spirit Guardians" OR _pageName = "Spiritual Weapon" OR _pageName = "Stoneskin" OR _pageName = "Telekinesis" OR _pageName = "Thorn Whip" OR _pageName = "Thunderwave" OR _pageName = "Wall of Fire" OR _pageName = "Wall of Stone" AND _pageName = "Seeming" OR _pageName = "Shatter" OR _pageName = "Shield of Faith" OR _pageName = "Shillelagh" OR _pageName = "Sleep" OR _pageName = "Sleet Storm" OR _pageName = "Slow" OR _pageName = "Speak with Animals" OR _pageName = "Speak with Dead" OR _pageName = "Spike Growth" OR _pageName = "Spirit Guardians" OR _pageName = "Spiritual Weapon" OR _pageName = "Stoneskin" OR _pageName = "Telekinesis" OR _pageName = "Thorn Whip" OR _pageName = "Thunderwave" OR _pageName = "Wall of Fire" OR _pageName = "Wall of Stone") AND spell_level="0"
| Name | Subclass | Spell School | Classes | C | C | R | A |  |
 |
 |
D | Description | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
 |
Shillelagh |  Nature |
 Transmutation |
 Druid |
{{{range}}}m |  Quarterstaff or Club Required.
Your staff or club becomes magical: it deals  1d8 + Wisdom Modifier Bludgeoning damage, and uses your Spellcasting Ability for  Attack rolls. |
|||||||
 |
Thorn Whip | Nature |
Transmutation |
Druid |
{{{range}}}m |  |
Pulls the creature  3 m / 10 ft closer to you. |