Difference between revisions of "Template:Arena Skill"
From Unofficial Fantasica Wiki
(testing) |
(testing) |
||
| Line 10: | Line 10: | ||
|where=arenaskill LIKE '%{{{1}}}' and released=1 | |where=arenaskill LIKE '%{{{1}}}' and released=1 | ||
|order by=rarity desc, name | |order by=rarity desc, name | ||
| − | |data=realname=replace(`name`,'_mlb',''),name=`name`,gender=`gender`,rarity=`rarity`,type=`type`,cost=`cost`,speed=`speed`,speednum=`speednum`,range=`range`,land=`land`,air=`air`,sea=`sea`,total=`land`+`air`+`sea`,landlb=`landlb`,airlb=`airlb`,sealb=`sealb`,totallb=`landlb`+`airlb`+`sealb`,arena=`arena`,arenalb=`arenalb`,skill1=`skill1`,skill2=`skill2`,arenaskill=`arenaskill`,source=`source`}} | + | |data=isx=CASE WHEN `name` like '%_mlb' THEN 'X' else '' END CASE,realname=replace(`name`,'_mlb',''),name=`name`,gender=`gender`,rarity=`rarity`,type=`type`,cost=`cost`,speed=`speed`,speednum=`speednum`,range=`range`,land=`land`,air=`air`,sea=`sea`,total=`land`+`air`+`sea`,landlb=`landlb`,airlb=`airlb`,sealb=`sealb`,totallb=`landlb`+`airlb`+`sealb`,arena=`arena`,arenalb=`arenalb`,skill1=`skill1`,skill2=`skill2`,arenaskill=`arenaskill`,source=`source`}} |
{| class="wikitable sortable" style="text-align:center;" | {| class="wikitable sortable" style="text-align:center;" | ||
! Unit | ! Unit | ||
| Line 23: | Line 23: | ||
|- | |- | ||
{{#for_external_table:<nowiki/> | {{#for_external_table:<nowiki/> | ||
| − | {{!}} [[Image:{{{name}}}_icon.png|48px|link={{{realname}}}]]<br>[[{{{realname}}}]] | + | {{!}} [[Image:{{{name}}}_icon.png|48px|link={{{realname}}}]]<br>[[{{{realname}}}]] {{{isx}}} |
{{!}} {{{rarity}}}★ | {{!}} {{{rarity}}}★ | ||
{{!}} {{{type}}} | {{!}} {{{type}}} | ||
Revision as of 19:12, 9 August 2015
DO NOT EDIT THIS TEMPLATE UNLESS YOU KNOW WHAT YOU ARE DOING! :D
If you're trying to update stats for a unit, go here instead: http://www.fantasicawiki.com/units.php
Usage: {{Arena_Skill|SkillName}}
