Template:SpellRaritiesSpell: Difference between revisions
From Wizardia Community Wiki
Content added Content deleted
No edit summary |
mNo edit summary Tag: Manual revert |
||
(17 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
<div style="overflow-x:auto;"> |
<div style="overflow-x:auto;margin-bottom:1em;"> |
||
{| class="wikitable" |
{| class="wikitable" |
||
|+ {{Spells|spell={{{shortname}}}|image={{{imagelink}}}}} |
|+ {{Spells|spell={{{shortname}}}|image={{{imagelink}}}}} |
||
Line 5: | Line 5: | ||
! style="border-top-left-radius: 10px;" | Wizard !! Rarity !! Affinity !! Type !! Targets !! Cost !! style="border-top-right-radius: 10px;" | 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 |
Latest revision as of 14:08, 8 March 2023
Wizard | Rarity | Affinity | Type | Targets | Cost | Value
No results |
---|