Difference between revisions of "Template:Card"
From Unofficial Fantasica Wiki
(reverting) |
|||
| Line 6: | Line 6: | ||
Usage: <nowiki>{{Card|CardName}}</nowiki></noinclude><includeonly>{{#get_db_data: | Usage: <nowiki>{{Card|CardName}}</nowiki></noinclude><includeonly>{{#get_db_data: | ||
db=fantawiki | db=fantawiki | ||
| − | |from=units | + | |from=units u1 left join units u2 on u2.name = CONCAT(u1.name, '_mlb') |
| − | |where=name='{{{1}}}' | + | |where=u1.name='{{{1}}}' |
|limit=1 | |limit=1 | ||
| − | |data=name=`name`,fullname=`fullname`,gender=`gender`,rarity=`rarity`,type=`type`,cost=`cost`,speed=`speed`,speednum=`speednum`,range=`range`,land=`land`,air=`air`,sea=`sea`,arena=`arena`,land2=`landlb`,air2=`airlb`,sea2=`sealb`,arenalb=`arenalb`,skill1=`skill1`,skill2=`skill2`,arenaskill=`arenaskill`,source=`source` | + | |data=name=u1.`name`,fullname=u1.`fullname`,gender=u1.`gender`,rarity=u1.`rarity`,type=u1.`type`,cost=u1.`cost`,speed=u1.`speed`,speednum=u1.`speednum`,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`,source=u1.`source`,namemlb=u2.`name`,fullnamemlb=u2.`fullname`,gendermlb=u2.`gender`,raritymlb=u2.`rarity`,typemlb=u2.`type`,costmlb=u2.`cost`,speedmlb=u2.`speed`,speednummlb=u2.`speednum`,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`,sourcemlb=u2.`source` |
}}{{#ifexpr: {{#external_value:rarity}}>9 | | }}{{#ifexpr: {{#external_value:rarity}}>9 | | ||
<tabber> | <tabber> | ||
| Line 37: | Line 37: | ||
|-| | |-| | ||
Empowered Form= | Empowered Form= | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
{{Infobox_Card | {{Infobox_Card | ||
| − | |name={{#external_value: | + | |name={{#external_value:namemlb}} |
| − | |fullname={{#external_value: | + | |fullname={{#external_value:fullnamemlb}} |
| − | |rarity={{#external_value: | + | |rarity={{#external_value:raritymlb}} |
| − | |type={{#external_value: | + | |type={{#external_value:typemlb}} |
| − | |cost={{#external_value: | + | |cost={{#external_value:costmlb}} |
| − | |speed={{#external_value: | + | |speed={{#external_value:speedmlb}} |
| − | |range={{#external_value: | + | |range={{#external_value:rangemlb}} |
| − | |ground={{formatnum:{{#external_value: | + | |ground={{formatnum:{{#external_value:landmlb}}}} |
| − | |arena={{formatnum:{{#external_value: | + | |arena={{formatnum:{{#external_value:arenamlb}}}} |
| − | |air={{formatnum:{{#external_value: | + | |air={{formatnum:{{#external_value:airmlb}}}} |
| − | |sea={{formatnum:{{#external_value: | + | |sea={{formatnum:{{#external_value:seamlb}}}} |
| − | |total={{formatnum:{{#expr: {{#external_value: | + | |total={{formatnum:{{#expr: {{#external_value:landmlb|}}+{{#external_value:airmlb|}}+{{#external_value:seamlb|}} }} }} |
| − | |ground2={{formatnum:{{#external_value: | + | |ground2={{formatnum:{{#external_value:land2mlb}}}} |
| − | |air2={{formatnum:{{#external_value: | + | |air2={{formatnum:{{#external_value:air2mlb}}}} |
| − | |sea2={{formatnum:{{#external_value: | + | |sea2={{formatnum:{{#external_value:sea2mlb}}}} |
| − | |arenalb={{formatnum:{{#external_value: | + | |arenalb={{formatnum:{{#external_value:arenalbmlb}}}} |
| − | |total2={{formatnum:{{#expr: {{#external_value: | + | |total2={{formatnum:{{#expr: {{#external_value:land2mlb|0}}+{{#external_value:air2mlb|0}}+{{#external_value:sea2mlb|0}} }} }} |
| − | |skill={{#external_value: | + | |skill={{#external_value:skill1mlb}}{{#if: {{#external_value:skill2mlb}} | , {{#external_value:skill2mlb}}}}{{#if: {{#external_value:arenaskillmlb}} | , {{#external_value:arenaskillmlb}}}} |
| − | |source={{#external_value: | + | |source={{#external_value:sourcemlb}} |
}} | }} | ||
| − | {{Card_artwork|{{#external_value: | + | {{Card_artwork|{{#external_value:namemlb}}}}{{#clear_external_data:}} |
</tabber> | </tabber> | ||
| {{Infobox_Card | | {{Infobox_Card | ||
Revision as of 01:40, 15 July 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: {{Card|CardName}}
