Difference between revisions of "Template:Template sandbox"

Revision as of 09:18, 14 November 2018

<noinclude>
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: {{Team|CardName|Ascension}}</noinclude><includeonly>{{#get_db_data:
db=fantawiki
|from=units u1 left join units u2 on u2.name = CONCAT(u1.name, '_mlb')
|where=u1.name='{{{1}}}'
|limit=1
|data=name=u1.`name`,rarity=u1.`rarity`,type=u1.`type`,cost=u1.`cost`,speed=u1.`speed`,range=u1.`range`,land=u1.`land`,air=u1.`air`,sea=u1.`sea`,arena=u1.`arena`,land2=u1.`landlb`,air2=u1.`airlb`,sea2=u1.`sealb`,arenalb=u1.`arenalb`,skill1=u1.`skill1`,skill2=u1.`skill2`,arenaskill=u1.`arenaskill`,maxhp=u1.`maxhp`,mlbhp=u1.`mlbhp`,aschp=u1.`aschp`,ascland=u1.`ascland`,ascair=u1.`ascair`,ascsea=u1.`ascsea`,ascrng=u1.`ascrng`,asccost=u1.`asccost`,ascspd=u1.`ascspd`,namemlb=u2.`name`,raritymlb=u2.`rarity`,typemlb=u2.`type`,costmlb=u2.`cost`,speedmlb=u2.`speed`,rangemlb=u2.`range`,landmlb=u2.`land`,airmlb=u2.`air`,seamlb=u2.`sea`,arenamlb=u2.`arena`,land2mlb=u2.`landlb`,air2mlb=u2.`airlb`,sea2mlb=u2.`sealb`,arenalbmlb=u2.`arenalb`,skill1mlb=u2.`skill1`,skill2mlb=u2.`skill2`,arenaskillmlb=u2.`arenaskill`,maxhpmlb=u2.`maxhp`,mlbhpmlb=u2.`mlbhp`,aschpmlb=u2.`aschp`,asclandmlb=u2.`ascland`,ascairmlb=u2.`ascair`,ascseamlb=u2.`ascsea`,ascrngmlb=u2.`ascrng`,asccostmlb=u2.`asccost`,ascspdmlb=u1.`ascspd`
}} {{#ifexpr: {{#external_value:rarity}}=10 or {{#external_value:rarity}}=11 |
{{!}}-
{{!!}} {{Icon|{{{1}}}_mlb}}<br/>[[{{#external_value:name}}]]
{{!!}} {{#external_value:rarity}}
{{!!}} {{#external_value:type}}
{{!!}} {{{2}}}
{{!!}} {{#ifexpr: {{{2}}}>0 and {{#external_value:asccostmlb}} | <span style="color:red"> {{#ifexpr: {{#external_value:costmlb}}=30 or {{#external_value:costmlb}}=40 | {{#expr:{{#external_value:costmlb}}-({{{2}}}*2)}} | {{#expr:{{#external_value:costmlb}}-({{{2}}}*1)}}}} </span> | {{#external_value:costmlb}}}} 
{{!!}} {{#ifexpr: {{{2}}}>0 and {{#external_value:ascspdmlb}} | <span style="color:red"> {{#external_value:speedmlb}}+ </span>| {{#external_value:speedmlb}}}}
{{!!}} {{#ifexpr: {{{2}}}>0 and {{#external_value:ascrngmlb}} | <span style="color:red"> {{#expr:{{#external_value:rangemlb}}+({{{2}}}*5)}} </span> | {{#external_value:rangemlb}}}}
{{!!}} {{#ifexpr: {{{2}}}>0 and {{#external_value:asclandmlb}} | <span style="color:red"> {{formatnum: {{#expr:{{#external_value:land2mlb}}+({{{2}}}/20*{{#external_value:land2mlb}})}}}} </span> | {{formatnum:{{#external_value:land2mlb}}}}}}
{{!!}} {{#ifexpr: {{{2}}}>0 and {{#external_value:ascairmlb}} | <span style="color:red"> {{formatnum: {{#expr:{{#external_value:air2mlb}}+({{{2}}}/20*{{#external_value:air2mlb}})}}}} </span> | {{formatnum:{{#external_value:air2mlb}}}}}}
{{!!}} {{#ifexpr: {{{2}}}>0 and {{#external_value:ascseamlb}} | <span style="color:red"> {{formatnum: {{#expr:{{#external_value:sea2mlb}}+({{{2}}}/20*{{#external_value:sea2mlb}})}}}} </span> | {{formatnum:{{#external_value:sea2mlb}}}}}}
{{!!}} {{#ifexpr: {{{2}}}>0 and {{#external_value:aschpmlb}} | <span style="color:red"> {{formatnum: {{#expr:{{#external_value:mlbhpmlb}}+({{{2}}}/10*{{#external_value:mlbhpmlb}})}}}} </span> | {{formatnum:{{#external_value:mlbhpmlb}}}}}}
{{!!}} {{formatnum: {{#expr:{{#external_value:arenalbmlb}}*(1+({{{2}}}/20))}}}}
{{!!}} {{#external_value:skill1mlb}}{{#if: {{#external_value:skill2mlb}} | , {{#external_value:skill2mlb}}}}{{#if: {{#external_value:arenaskillmlb}} | , {{#external_value:arenaskillmlb}}}}{{#clear_external_data:}}
| {{!}}-
{{!!}} {{Icon|{{{1}}}}}<br/>[[{{#external_value:name}}]]
{{!!}} {{#external_value:rarity}}
{{!!}} {{#external_value:type}}
{{!!}} {{{2}}}
{{!!}} {{#ifexpr: {{{2}}}>0 and {{#external_value:asccostmlb}} | <span style="color:red"> {{#ifexpr: {{#external_value:cost}}=30 or {{#external_value:cost}}=40 | {{#expr:{{#external_value:cost}}-({{{2}}}*2)}} | {{#expr:{{#external_value:cost}}-({{{2}}}*1)}}}} </span> | {{#external_value:cost}}}} 
{{!!}} {{#ifexpr: {{{2}}}>0 and {{#external_value:ascspdmlb}} | <span style="color:red"> {{#external_value:speed}}+ </span>| {{#external_value:speed}}}}
{{!!}} {{#ifexpr: {{{2}}}>0 and {{#external_value:ascrngmlb}} | <span style="color:red"> {{#expr:{{#external_value:range}}+({{{2}}}*5)}} </span> | {{#external_value:range}}}}
{{!!}} {{#ifexpr: {{{2}}}>0 and {{#external_value:asclandmlb}} | <span style="color:red"> {{formatnum: {{#expr:{{#external_value:land2}}+({{{2}}}/20*{{#external_value:land2}})}}}} </span> | {{formatnum:{{#external_value:land2}}}}}}
{{!!}} {{#ifexpr: {{{2}}}>0 and {{#external_value:ascairmlb}} | <span style="color:red"> {{formatnum: {{#expr:{{#external_value:air2}}+({{{2}}}/20*{{#external_value:air2}})}}}} </span> | {{formatnum:{{#external_value:air2}}}}}}
{{!!}} {{#ifexpr: {{{2}}}>0 and {{#external_value:ascseamlb}} | <span style="color:red"> {{formatnum: {{#expr:{{#external_value:sea2}}+({{{2}}}/20*{{#external_value:sea2}})}}}} </span> | {{formatnum:{{#external_value:sea2}}}}}}
{{!!}} {{#ifexpr: {{{2}}}>0 and {{#external_value:aschpmlb}} | <span style="color:red"> {{formatnum: {{#expr:{{#external_value:mlbhp}}+({{{2}}}/10*{{#external_value:mlbhp}})}}}} </span> | {{formatnum:{{#external_value:mlbhp}}}}}}
{{!!}} {{formatnum: {{#expr:{{#external_value:arenalb}}*(1+({{{2}}}/20))}}}}
{{!!}} {{#external_value:skill1}}{{#if: {{#external_value:skill2}} | , {{#external_value:skill2}}}}{{#if: {{#external_value:arenaskill}} | , {{#external_value:arenaskill}}}}{{#clear_external_data:}}}}</includeonly>