Difference between revisions of "Template:Arena Skill"

From Unofficial Fantasica Wiki
Jump to: navigation, search
(Undo revision 60681 by ZachBora (talk))
(testing)
 
(One intermediate revision by one user not shown)
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=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`}}
+
|data=isMLB=IF(`name` like '%_mlb', 'X',''),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}}}]] {{{isx}}}
+
{{!}} [[Image:{{{name}}}_icon.png|48px|link={{{realname}}}]]<br>[[{{{realname}}}|{{{realname}}} {{{isMLB}}}]]
 
{{!}} {{{rarity}}}★
 
{{!}} {{{rarity}}}★
 
{{!}} {{{type}}}
 
{{!}} {{{type}}}

Latest revision as of 19:20, 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}}

Personal tools
Namespaces

Variants
Actions
Menu
Game Menu
Card Lists
Trading
External Resources
Toolbox