Template:SpellRaritiesSpell: Difference between revisions
From Wizardia Community Wiki
Content added Content deleted
(Created page with "{| class="wikitable" |+ {{Spells|spell={{{shortname}}}|image={{{imagelink}}}}} |- ! Wizard !! Rarity !! Affinity !! Type !! Targets !! Cost !! Value {{#cargo_query: table=Spells |fields=WizardLink,Rarity,Affinity,Type,Targets,Cost,Value |where=Link='{{{spelllink}}}' |order by=Value ASC |format=template |template=SpellRarities |named args=yes }} |}") |
mNo edit summary Tag: Manual revert |
||
(26 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
<div style="overflow-x:auto;margin-bottom:1em;"> |
|||
{| class="wikitable" |
{| class="wikitable" |
||
|+ {{Spells|spell={{{shortname}}}|image={{{imagelink}}}}} |
|+ {{Spells|spell={{{shortname}}}|image={{{imagelink}}}}} |
||
|- |
|- |
||
! Wizard !! Rarity !! Affinity !! Type !! Targets !! Cost !! Value |
! style="border-top-left-radius: 10px;" | Wizard !! Rarity !! Affinity !! Type !! Targets !! Cost !! style="border-top-right-radius: 10px;" | Value |
||
{{#cargo_query: |
{{#cargo_query: |
||
table=Spells |
table=Spells,Wizards |
||
|join on=Spells.WizardLink=Wizards.Link |
|||
|fields=WizardLink,Rarity,Affinity,Type,Targets,Cost,Value |
|||
|fields=Wizards.Name_full,CONCAT(Wizards.Link)=Link,Spells.Rarity,Spells.Affinity,Spells.Type,Spells.Targets,Spells.Cost,Spells.Value |
|||
|where=Link='{{{spelllink}}}' |
|where=Spells.Link='{{{spelllink}}}' AND Spells.Rarity=Wizards.Rarity |
||
|order by=Value ASC |
|order by=Spells.Value ASC |
||
|format=template |
|format=template |
||
|template=SpellRarities |
|template=SpellRarities |
||
Line 13: | Line 15: | ||
}} |
}} |
||
|} |
|} |
||
</div> |
Latest revision as of 14:08, 8 March 2023
Wizard | Rarity | Affinity | Type | Targets | Cost | Value
No results |
---|