Template:SpellRaritiesSpell: Difference between revisions
From Wizardia Community Wiki
Content added Content deleted
No edit summary |
mNo edit summary Tag: Manual revert |
||
| (22 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" |
|||
|+ {{Spells|spell={{{shortname}}}|image={{{imagelink}}}}} |
|+ {{Spells|spell={{{shortname}}}|image={{{imagelink}}}}} |
||
|- |
|- |
||
! style="border-top-left-radius: 10px;" | Wizard !! Rarity !! Affinity !! Type !! Targets !! Cost !! |
! style="border-top-left-radius: 10px;" | Wizard !! Rarity !! Affinity !! Type !! Targets !! Cost !! style="border-top-right-radius: 10px;" | Value |
||
! 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 |
||
|named args=yes |
|named args=yes |
||
}} |
}} |
||
|} |
|} |
||
</div> |
|||
Latest revision as of 14:08, 8 March 2023
| Wizard | Rarity | Affinity | Type | Targets | Cost | Value
No results |
|---|
