Difference between revisions of "Template:Template sandbox"

From Unofficial Fantasica Wiki
Jump to: navigation, search
(Replaced content with "{{#ifexist:File:{{{name}}}_card_back.jpg|| {{!}}- {{!}} {{{name}}} {{!}} {{{rarity}}} {{!}} {{{source}}} }}")
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>
+

Revision as of 20:36, 11 December 2018

|- | {{{name}}} | {{{rarity}}} | {{{source}}}

Personal tools
Namespaces

Variants
Actions
Menu
Game Menu
Card Lists
Trading
External Resources
Toolbox