Template:List - Revision history

Kattiara: Trying to fix name ref

2013-08-08T03:33:05Z

Trying to fix name ref

Kattiara: Trying to fix name ref

2013-08-08T03:31:20Z

Trying to fix name ref

Kattiara: Trying to fix name ref

2013-08-08T03:22:31Z

Trying to fix name ref

Kattiara: Trying to fix arena calc

2013-08-08T02:49:57Z

Trying to fix arena calc

Kattiara: Testing list row template that calls on db

2013-08-08T02:33:10Z

Testing list row template that calls on db

New page

<noinclude>Usage: <nowiki>{{List|UnitName}}</nowiki></noinclude><includeonly>{{#get_db_data:
db=fantawiki
|from=units
|where=name='{{PAGENAME}}'
|limit=1
|data=name=`name`,gender=`gender`,rarity=`rarity`,type=`type`,cost=`cost`,speed=`speed`,speednum=`speednum`,range=`range`,land=`land`,air=`air`,sea=`sea`,land2=`landlb`,air2=`airlb`,sea2=`sealb`,skill1=`skill1`,skill2=`skill2`,source=`source`,arena=`arena`
}}
{{List_row_base
|name={{#external_value:name}}
|type={{#external_value:type}}
|cost={{#external_value:cost}}
|speed={{#external_value:speed}}
|atkdel={{#external_value:speednum}}
|range={{#external_value:range}}
|ground={{#external_value:land}}
|air={{#external_value:air}}
|sea={{#external_value:sea}}
|total={{#expr: {{#external_value:land|0}}+{{#external_value:air|0}}+{{#external_value:sea|0}} }}
|arena={{#external_value:arena}}
|skill={{#external_value:skill1}}{{#if: {{#external_value:skill2}} | , {{#external_value:skill2}}}}
|source={{#external_value:source}}
}}</includeonly>

@@ Line 2: / Line 2: @@
 db=fantawiki
 |from=units
-|where=name={{{1}}}
+|where=name='{{{1}}}'
 |limit=1
 |data=name=`name`,gender=`gender`,rarity=`rarity`,type=`type`,cost=`cost`,speed=`speed`,speednum=`speednum`,range=`range`,land=`land`,air=`air`,sea=`sea`,land2=`landlb`,air2=`airlb`,sea2=`sealb`,skill1=`skill1`,skill2=`skill2`,source=`source`

@@ Line 4: / Line 4: @@
 |where=name='{{PAGENAME}}'
 |limit=1
-|data=name=`name`,gender=`gender`,rarity=`rarity`,type=`type`,cost=`cost`,speed=`speed`,speednum=`speednum`,range=`range`,land=`land`,air=`air`,sea=`sea`,land2=`landlb`,air2=`airlb`,sea2=`sealb`,skill1=`skill1`,skill2=`skill2`,source=`source`,arena=`arena`
+|data=name=`name`,gender=`gender`,rarity=`rarity`,type=`type`,cost=`cost`,speed=`speed`,speednum=`speednum`,range=`range`,land=`land`,air=`air`,sea=`sea`,land2=`landlb`,air2=`airlb`,sea2=`sealb`,skill1=`skill1`,skill2=`skill2`,source=`source`
 }}
 {{List_row_base
 |name={{#external_value:name}}
 |type={{#external_value:type}}
 |cost={{#external_value:cost}}
@@ Line 17: / Line 18: @@
 |sea={{#external_value:sea}}
 |total={{#expr: {{#external_value:land|0}}+{{#external_value:air|0}}+{{#external_value:sea|0}} }}
-|arena={{#external_value:arena}}
+|arena={{#iferror: {{#expr:trunc((1-({{{rarity|1}}})^2/100)*(floor(1.2*{{#if: {{{ground|1}}}>{{{air|1}}} | {{#if: {{{ground|1}}}>{{{sea|1}}} | {{{ground|1}}} | {{{sea|1}}} }} | {{#if: {{{air|1}}} > {{{sea|1}}} | {{{air|1}}} | {{{sea|1}}} }} }}+0.5)+floor(1.2*({{{total|1}}} - {{#if: {{{ground|1}}}>{{{air|1}}} | {{#if: {{{ground|1}}}>{{{sea|1}}} | {{{ground|1}}} | {{{sea|1}}} }} | {{#if: {{{air|1}}} > {{{sea|1}}} | {{{air|1}}} | {{{sea|1}}} }} }} - {{#if: {{{ground|1}}}>{{{air|1}}} | {{#if: {{{sea|1}}}>{{{air|1}}} | {{{air|1}}} | {{{sea|1}}} }} | {{#if: {{{ground|1}}} > {{{sea|1}}} | {{{sea|1}}} | {{{ground|1}}} }} }}+0.5))))}}|0}}
 |skill={{#external_value:skill1}}{{#if: {{#external_value:skill2}} | , {{#external_value:skill2}}}}
 |source={{#external_value:source}}
 }}</includeonly>