|
|
Line 1: |
Line 1: |
− | <noinclude>
| + | {{#ifexist:File:{{{name}}}_card_back.jpg|| |
− | 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: <nowiki>{{Team|CardName|Ascension}}</nowiki></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}}]] | + | {{!}} {{{name}}} |
− | {{!!}} {{#external_value:rarity}}
| + | {{!}} {{{rarity}}} |
− | {{!!}} {{#external_value:type}} | + | {{!}} {{{source}}} }} |
− | {{!!}} {{{2}}}
| + | |
− | {{!!}} {{#ifexpr: {{{2}}}>0 and {{#external_value:asccostmlb}}!=0 | <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}}}=4 and {{#if: {{#external_value:ascspdmlb}}|1|0}}=1 and {{#ifeq:{{#external_value:speedmlb}}|S|1|0}}=1 | <span style="color:red">SS</span> | {{#ifexpr:{{{2}}}=4 and {{#if: {{#external_value:ascspdmlb}}|1|0}}=1 and {{#ifeq:{{#external_value:speedmlb}}|A|1|0}}=1 | <span style="color:red">S</span> | {{#ifexpr:{{{2}}}=4 and {{#if: {{#external_value:ascspdmlb}}|1|0}}=1 and {{#ifeq:{{#external_value:speedmlb}}|B|1|0}}=1 | <span style="color:red">A</span> |{{#ifexpr:{{{2}}}=4 and {{#if: {{#external_value:ascspdmlb}}|1|0}}=1 and {{#ifeq:{{#external_value:speedmlb}}|C|1|0}}=1 | <span style="color:red">B</span> |{{#ifexpr:{{{2}}}=4 and {{#if: {{#external_value:ascspdmlb}}|1|0}}=1 and {{#ifeq:{{#external_value:speedmlb}}|D|1|0}}=1 | <span style="color:red">C</span> | {{#ifexpr: {{{2}}}>0 and {{{2}}}<4 and {{#if: {{#external_value:ascspdmlb}}|1|0}}=1 | <span style="color:red">{{#external_value:speedmlb}}+</span> | {{#external_value:speedmlb}}}}}}}}}}}}}}
| + | |
− | {{!!}} {{#ifexpr: {{{2}}}>0 and {{#external_value:ascrngmlb}}!=0 | <span style="color:red"> {{#expr:{{#external_value:rangemlb}}+({{{2}}}*5)}} </span> | {{#external_value:rangemlb}}}}
| + | |
− | {{!!}} {{#ifexpr: {{{2}}}>0 and {{#external_value:asclandmlb}}>0 | <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}}>0 | <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}}>0 | <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}}>0 | <span style="color:red"> {{formatnum: {{#expr:{{#external_value:mlbhpmlb}}+({{{2}}}/10*{{#external_value:mlbhpmlb}})}}}} </span> | {{formatnum:{{#external_value:mlbhpmlb}}}}}}
| + | |
− | {{!!}} {{#ifexpr: {{#external_value:rarity}}=10 | {{formatnum:{{#expr:{{#external_value:arenalbmlb}}*(12/11)*({{{2}}}+20)/20 round 0}}}} | {{formatnum:{{#expr:{{#external_value:arenalbmlb}}*(1.08333433)*({{{2}}}+20)/20 round 0}}}}}}
| + | |
− | {{!!}} {{#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:asccost}}!=0 | <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}}}=4 and {{#if: {{#external_value:ascspd}}|1|0}}=1 and {{#ifeq:{{#external_value:speed}}|S|1|0}}=1 | <span style="color:red">SS</span> | {{#ifexpr:{{{2}}}=4 and {{#if: {{#external_value:ascspd}}|1|0}}=1 and {{#ifeq:{{#external_value:speed}}|A|1|0}}=1 | <span style="color:red">S</span> | {{#ifexpr:{{{2}}}=4 and {{#if: {{#external_value:ascspd}}|1|0}}=1 and {{#ifeq:{{#external_value:speed}}|B|1|0}}=1 | <span style="color:red">A</span> |{{#ifexpr:{{{2}}}=4 and {{#if: {{#external_value:ascspd}}|1|0}}=1 and {{#ifeq:{{#external_value:speed}}|C|1|0}}=1 | <span style="color:red">B</span> |{{#ifexpr:{{{2}}}=4 and {{#if: {{#external_value:ascspd}}|1|0}}=1 and {{#ifeq:{{#external_value:speed}}|D|1|0}}=1 | <span style="color:red">C</span> | {{#ifexpr: {{{2}}}>0 and {{{2}}}<4 and {{#if: {{#external_value:ascspd}}|1|0}}=1 | <span style="color:red">{{#external_value:speed}}+</span> | {{#external_value:speed}}}}}}}}}}}}}}
| + | |
− | {{!!}} {{#ifexpr: {{{2}}}>0 and {{#external_value:ascrng}}!=0 | <span style="color:red"> {{#expr:{{#external_value:range}}+({{{2}}}*5)}} </span> | {{#external_value:range}}}}
| + | |
− | {{!!}} {{#ifexpr: {{{2}}}>0 and {{#external_value:ascland}}>0 | <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:ascair}}>0 | <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:ascsea}}>0 | <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:aschp}}>0 | <span style="color:red"> {{formatnum: {{#expr:{{#external_value:mlbhp}}+({{{2}}}/10*{{#external_value:mlbhp}})}}}} </span> | {{formatnum:{{#external_value:mlbhp}}}}}}
| + | |
− | {{!!}} {{#ifexpr: {{#external_value:rarity}}=12 | {{formatnum:{{#expr:{{#external_value:arenalb}}*(14/13)*({{{2}}}+20)/20 round 0}}}} | {{formatnum: {{#expr:{{#external_value:arenalb}}*({{{2}}}+20)/20 round 0}}}}}}
| + | |
− | {{!!}} {{#external_value:skill1}}{{#if: {{#external_value:skill2}} | , {{#external_value:skill2}}}}{{#if: {{#external_value:arenaskill}} | , {{#external_value:arenaskill}}}}{{#clear_external_data:}}}}</includeonly>
| + | |