Template:SpellRaritiesSpell: Difference between revisions
From Wizardia Community Wiki
Content added Content deleted
No edit summary |
mNo edit summary Tag: Manual revert |
||
| (14 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 7: | Line 7: | ||
table=Spells,Wizards |
table=Spells,Wizards |
||
|join on=Spells.WizardLink=Wizards.Link |
|join on=Spells.WizardLink=Wizards.Link |
||
|fields=Wizards.Name_full,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 |
|---|
