|
|
| Line 1: |
Line 1: |
| | | | |
| − | | + | {{Card_test2|Ada}} |
| − | | + | |
| − | | + | |
| − | <tabber>
| + | |
| − | My10★s=
| + | |
| − | {{#get_db_data:db=fantawiki | + | |
| − | |from=units | + | |
| − | |where=name in ("Uriel_10","Uriel_10_mlb", "Cwen", "Cwen_mlb", "Epimeleia_10", "Epimeleia_10_mlb", "Eira_10","Eira_10_mlb", "Morgoth", "Morgoth_mlb", "Nel", "Nel_mlb", "Gafgarion", "Gafgarion_mlb", "Ogilvy", "Ogilvy_mlb", "Katsuie_Shibata", "Katsuie_Shibata_mlb", "Desiree", "Desiree_mlb", "Faraine", "Faraine_mlb", "Zhanna", "Zhanna_mlb", "Moonstone", "Moonstone_mlb", "Samhain", "Samhain_mlb", "Ethelred_10", "Ethelred_10_mlb", "Liesse", "Liesse_mlb","Nobuharu_Baba"," Nobuharu_Baba_mlb","Juzo_Kakei","Juzo_Kakei_mlb","Archangel","Archangel_mlb","Xiulan","Xiulan_mlb")
| + | |
| − | |limit=60
| + | |
| − | |order by=land+air+sea DESC, rarity DESC, name ASC
| + | |
| − | |data=name=`name`,gender=`gender`,rarity=`rarity`,type=`type`,cost=`cost`,speed=`speed`,speednum=`speednum`,range=`range`,land=`land`,air=`air`,sea=`sea`,total=`land`+`air`+`sea`,landlb=`landlb`,airlb=`airlb`,sealb=`sealb`,totallb=`landlb`+`airlb`+`sealb`,arena=`arena`,arenalb=`arenalb`,skill1=`skill1`,skill2=`skill2`,arenaskill=`arenaskill`,source=`source`,landdps=`landlb`/`speednum`}}
| + | |
| − | | + | |
| − | {| class="wikitable sortable" style="text-align:center;"
| + | |
| − | ! {{*}}
| + | |
| − | ! Sprite
| + | |
| − | ! Name
| + | |
| − | ! Type
| + | |
| − | ! Cost
| + | |
| − | ! Speed
| + | |
| − | ! Delay
| + | |
| − | ! Range
| + | |
| − | ! [[Image:Ground_icon.png]]
| + | |
| − | ! [[Image:Air_icon.png]]
| + | |
| − | ! [[Image:Sea_icon.png]]
| + | |
| − | ! Total
| + | |
| − | ! Arena
| + | |
| − | <!--
| + | |
| − | ! Land DPS
| + | |
| − | -->
| + | |
| − | ! Skill
| + | |
| − | ! Arena<br>Skill
| + | |
| − | ! Source
| + | |
| − | |-
| + | |
| − | {{#for_external_table:<nowiki/>
| + | |
| − | {{!}} {{{rarity}}}
| + | |
| − | {{!}} [[Image:{{{name}}}.gif]]
| + | |
| − | {{!}} [[Image:{{{name}}}_icon.png|32px|link={{{name}}}]]<br/>[[{{{name}}}]]
| + | |
| − | {{!}} {{{type}}}
| + | |
| − | {{!}} {{{cost}}}
| + | |
| − | {{!}} {{{speed}}}
| + | |
| − | {{!}} {{{speednum}}}
| + | |
| − | {{!}} {{{range}}}
| + | |
| − | {{!}} {{{land}}}<br/>({{{landlb}}})
| + | |
| − | {{!}} {{{air}}}<br/>({{{airlb}}})
| + | |
| − | {{!}} {{{sea}}}<br/>({{{sealb}}})
| + | |
| − | {{!}} {{{total}}}<br/>({{{totallb}}})
| + | |
| − | {{!}} {{{arenalb}}}
| + | |
| − | <!--
| + | |
| − | {{!}} {{{landdps}}}
| + | |
| − | -->
| + | |
| − | {{!}} {{{skill1}}} {{{skill2}}}
| + | |
| − | {{!}} {{{arenaskill}}}
| + | |
| − | {{!}} {{{source}}}
| + | |
| − | {{!}}- }}
| + | |
| − | {{!}}- }}{{#clear_external_data:}}
| + | |
| − | |}
| + | |
| − | |-|
| + | |
| − | Top Dmg=
| + | |
| − | {{#get_db_data:
| + | |
| − | db=fantawiki
| + | |
| − | |from=units
| + | |
| − | |limit=50
| + | |
| − | |order by=(air+sea+land) DESC
| + | |
| − | |data=name=`name`,gender=`gender`,rarity=`rarity`,type=`type`,cost=`cost`,speed=`speed`,speednum=`speednum`,range=`range`,land=`land`,air=`air`,sea=`sea`,total=`land`+`air`+`sea`,landlb=`landlb`,airlb=`airlb`,sealb=`sealb`,totallb=`landlb`+`airlb`+`sealb`,arena=`arena`,arenalb=`arenalb`,skill1=`skill1`,skill2=`skill2`,arenaskill=`arenaskill`,source=`source`,landdps=`landlb`/`speednum`,dmgcost=(`air`+`sea`+`land`)/`cost`
| + | |
| − | }}
| + | |
| − | | + | |
| − | | + | |
| − | {| class="wikitable sortable" style="text-align:center;"
| + | |
| − | ! {{*}}
| + | |
| − | ! Sprite
| + | |
| − | ! Name
| + | |
| − | ! Type
| + | |
| − | ! Cost
| + | |
| − | ! Speed
| + | |
| − | ! Delay
| + | |
| − | ! Range
| + | |
| − | ! [[Image:Ground_icon.png]]
| + | |
| − | ! [[Image:Air_icon.png]]
| + | |
| − | ! [[Image:Sea_icon.png]]
| + | |
| − | ! Total
| + | |
| − | ! Arena
| + | |
| − | ! Dmg/Cost
| + | |
| − | <!--
| + | |
| − | ! Land DPS
| + | |
| − | -->
| + | |
| − | ! Skill
| + | |
| − | ! Arena<br>Skill
| + | |
| − | ! Source
| + | |
| − | |-
| + | |
| − | {{#for_external_table:<nowiki/>
| + | |
| − | {{!}} {{{rarity}}}
| + | |
| − | {{!}} [[Image:{{{name}}}.gif]]
| + | |
| − | {{!}} [[Image:{{{name}}}_icon.png|32px|link={{{name}}}]]<br/>[[{{{name}}}]]
| + | |
| − | {{!}} {{{type}}}
| + | |
| − | {{!}} {{{cost}}}
| + | |
| − | {{!}} {{{speed}}}
| + | |
| − | {{!}} {{{speednum}}}
| + | |
| − | {{!}} {{{range}}}
| + | |
| − | {{!}} {{{land}}}<br/>({{{landlb}}})
| + | |
| − | {{!}} {{{air}}}<br/>({{{airlb}}})
| + | |
| − | {{!}} {{{sea}}}<br/>({{{sealb}}})
| + | |
| − | {{!}} {{{total}}}<br/>({{{totallb}}})
| + | |
| − | {{!}} {{{arenalb}}}
| + | |
| − | {{!}} {{{dmgcost}}}
| + | |
| − | <!--
| + | |
| − | {{!}} {{{landdps}}}
| + | |
| − | -->
| + | |
| − | {{!}} {{{skill1}}} {{{skill2}}}
| + | |
| − | {{!}} {{{arenaskill}}}
| + | |
| − | {{!}} {{{source}}}
| + | |
| − | {{!}}- }}
| + | |
| − | {{!}}- }}{{#clear_external_data:}}
| + | |
| − | |}
| + | |
| − | | + | |
| − | |-|
| + | |
| − | | + | |
| − | Top Dmg/Cost=
| + | |
| − | {{#get_db_data:
| + | |
| − | db=fantawiki
| + | |
| − | |from=units
| + | |
| − | |limit=50
| + | |
| − | |order by=(air+sea+land)/cost DESC
| + | |
| − | |data=name=`name`,gender=`gender`,rarity=`rarity`,type=`type`,cost=`cost`,speed=`speed`,speednum=`speednum`,range=`range`,land=`land`,air=`air`,sea=`sea`,total=`land`+`air`+`sea`,landlb=`landlb`,airlb=`airlb`,sealb=`sealb`,totallb=`landlb`+`airlb`+`sealb`,arena=`arena`,arenalb=`arenalb`,skill1=`skill1`,skill2=`skill2`,arenaskill=`arenaskill`,source=`source`,landdps=`landlb`/`speednum`,dmgcost=(`air`+`sea`+`land`)/`cost`
| + | |
| − | }}
| + | |
| − | | + | |
| − | | + | |
| − | {| class="wikitable sortable" style="text-align:center;"
| + | |
| − | ! {{*}}
| + | |
| − | ! Sprite
| + | |
| − | ! Name
| + | |
| − | ! Type
| + | |
| − | ! Cost
| + | |
| − | ! Speed
| + | |
| − | ! Delay
| + | |
| − | ! Range
| + | |
| − | ! [[Image:Ground_icon.png]]
| + | |
| − | ! [[Image:Air_icon.png]]
| + | |
| − | ! [[Image:Sea_icon.png]]
| + | |
| − | ! Total
| + | |
| − | ! Dmg/Cost
| + | |
| − | <!--
| + | |
| − | ! Land DPS
| + | |
| − | -->
| + | |
| − | ! Skill
| + | |
| − | ! Arena<br>Skill
| + | |
| − | ! Source
| + | |
| − | |-
| + | |
| − | {{#for_external_table:<nowiki/>
| + | |
| − | {{!}} {{{rarity}}}
| + | |
| − | {{!}} [[Image:{{{name}}}.gif]]
| + | |
| − | {{!}} [[Image:{{{name}}}_icon.png|32px|link={{{name}}}]]<br/>[[{{{name}}}]]
| + | |
| − | {{!}} {{{type}}}
| + | |
| − | {{!}} {{{cost}}}
| + | |
| − | {{!}} {{{speed}}}
| + | |
| − | {{!}} {{{speednum}}}
| + | |
| − | {{!}} {{{range}}}
| + | |
| − | {{!}} {{{land}}}<br/>({{{landlb}}})
| + | |
| − | {{!}} {{{air}}}<br/>({{{airlb}}})
| + | |
| − | {{!}} {{{sea}}}<br/>({{{sealb}}})
| + | |
| − | {{!}} {{{total}}}<br/>({{{totallb}}})
| + | |
| − | {{!}} {{{dmgcost}}}
| + | |
| − | <!--
| + | |
| − | {{!}} {{{landdps}}}
| + | |
| − | -->
| + | |
| − | {{!}} {{{skill1}}} {{{skill2}}}
| + | |
| − | {{!}} {{{arenaskill}}}
| + | |
| − | {{!}} {{{source}}}
| + | |
| − | {{!}}- }}
| + | |
| − | {{!}}- }}{{#clear_external_data:}}
| + | |
| − | |}
| + | |
| − | | + | |
| − | |-|
| + | |
| − | Top ArenaDmg=
| + | |
| − | {{#get_db_data:
| + | |
| − | db=fantawiki
| + | |
| − | |from=units
| + | |
| − | |limit=50
| + | |
| − | |order by=arenalb DESC
| + | |
| − | |data=name=`name`,gender=`gender`,rarity=`rarity`,type=`type`,cost=`cost`,speed=`speed`,speednum=`speednum`,range=`range`,land=`land`,air=`air`,sea=`sea`,total=`land`+`air`+`sea`,landlb=`landlb`,airlb=`airlb`,sealb=`sealb`,totallb=`landlb`+`airlb`+`sealb`,arena=`arena`,arenalb=`arenalb`,skill1=`skill1`,skill2=`skill2`,arenaskill=`arenaskill`,source=`source`,landdps=`landlb`/`speednum`,arenadmgcost=(`arenalb`)/`cost`
| + | |
| − | }}
| + | |
| − | | + | |
| − | | + | |
| − | {| class="wikitable sortable" style="text-align:center;"
| + | |
| − | ! {{*}}
| + | |
| − | ! Sprite
| + | |
| − | ! Name
| + | |
| − | ! Type
| + | |
| − | ! Cost
| + | |
| − | ! Speed
| + | |
| − | ! Range
| + | |
| − | ! [[Image:Ground_icon.png]]
| + | |
| − | ! [[Image:Air_icon.png]]
| + | |
| − | ! [[Image:Sea_icon.png]]
| + | |
| − | ! Total
| + | |
| − | ! Arena
| + | |
| − | ! Arena/Cost
| + | |
| − | <!--
| + | |
| − | ! Land DPS
| + | |
| − | -->
| + | |
| − | ! Skill
| + | |
| − | ! Arena<br>Skill
| + | |
| − | ! Source
| + | |
| − | |-
| + | |
| − | {{#for_external_table:<nowiki/>
| + | |
| − | {{!}} {{{rarity}}}
| + | |
| − | {{!}} [[Image:{{{name}}}.gif]]
| + | |
| − | {{!}} [[Image:{{{name}}}_icon.png|32px|link={{{name}}}]]<br/>[[{{{name}}}]]
| + | |
| − | {{!}} {{{type}}}
| + | |
| − | {{!}} {{{cost}}}
| + | |
| − | {{!}} {{{speed}}}
| + | |
| − | {{!}} {{{range}}}
| + | |
| − | {{!}} {{{land}}}<br/>({{{landlb}}})
| + | |
| − | {{!}} {{{air}}}<br/>({{{airlb}}})
| + | |
| − | {{!}} {{{sea}}}<br/>({{{sealb}}})
| + | |
| − | {{!}} {{{total}}}<br/>({{{totallb}}})
| + | |
| − | {{!}} {{{arenalb}}}
| + | |
| − | {{!}} {{{arenadmgcost}}}
| + | |
| − | <!--
| + | |
| − | {{!}} {{{landdps}}}
| + | |
| − | -->
| + | |
| − | {{!}} {{{skill1}}} {{{skill2}}}
| + | |
| − | {{!}} {{{arenaskill}}}
| + | |
| − | {{!}} {{{source}}}
| + | |
| − | {{!}}- }}
| + | |
| − | {{!}}- }}{{#clear_external_data:}}
| + | |
| − | |}
| + | |
| − | | + | |
| − | |-|
| + | |
| − | Top ArenaDmg/cost=
| + | |
| − | {{#get_db_data:
| + | |
| − | db=fantawiki
| + | |
| − | |from=units
| + | |
| − | |limit=50
| + | |
| − | |order by=(arenalb)/cost DESC
| + | |
| − | |data=name=`name`,gender=`gender`,rarity=`rarity`,type=`type`,cost=`cost`,speed=`speed`,speednum=`speednum`,range=`range`,land=`land`,air=`air`,sea=`sea`,total=`land`+`air`+`sea`,landlb=`landlb`,airlb=`airlb`,sealb=`sealb`,totallb=`landlb`+`airlb`+`sealb`,arena=`arena`,arenalb=`arenalb`,skill1=`skill1`,skill2=`skill2`,arenaskill=`arenaskill`,source=`source`,landdps=`landlb`/`speednum`,arenadmgcost=(`arenalb`)/`cost`
| + | |
| − | }}
| + | |
| − | | + | |
| − | | + | |
| − | {| class="wikitable sortable" style="text-align:center;"
| + | |
| − | ! {{*}}
| + | |
| − | ! Sprite
| + | |
| − | ! Name
| + | |
| − | ! Type
| + | |
| − | ! Cost
| + | |
| − | ! Speed
| + | |
| − | ! Range
| + | |
| − | ! [[Image:Ground_icon.png]]
| + | |
| − | ! [[Image:Air_icon.png]]
| + | |
| − | ! [[Image:Sea_icon.png]]
| + | |
| − | ! Total
| + | |
| − | ! Arena
| + | |
| − | ! Arena/Cost
| + | |
| − | <!--
| + | |
| − | ! Land DPS
| + | |
| − | -->
| + | |
| − | ! Skill
| + | |
| − | ! Arena<br>Skill
| + | |
| − | ! Source
| + | |
| − | |-
| + | |
| − | {{#for_external_table:<nowiki/>
| + | |
| − | {{!}} {{{rarity}}}
| + | |
| − | {{!}} [[Image:{{{name}}}.gif]]
| + | |
| − | {{!}} [[Image:{{{name}}}_icon.png|32px|link={{{name}}}]]<br/>[[{{{name}}}]]
| + | |
| − | {{!}} {{{type}}}
| + | |
| − | {{!}} {{{cost}}}
| + | |
| − | {{!}} {{{speed}}}
| + | |
| − | {{!}} {{{range}}}
| + | |
| − | {{!}} {{{land}}}<br/>({{{landlb}}})
| + | |
| − | {{!}} {{{air}}}<br/>({{{airlb}}})
| + | |
| − | {{!}} {{{sea}}}<br/>({{{sealb}}})
| + | |
| − | {{!}} {{{total}}}<br/>({{{totallb}}})
| + | |
| − | {{!}} {{{arenalb}}}
| + | |
| − | {{!}} {{{arenadmgcost}}}
| + | |
| − | <!--
| + | |
| − | {{!}} {{{landdps}}}
| + | |
| − | -->
| + | |
| − | {{!}} {{{skill1}}} {{{skill2}}}
| + | |
| − | {{!}} {{{arenaskill}}}
| + | |
| − | {{!}} {{{source}}}
| + | |
| − | {{!}}- }}
| + | |
| − | {{!}}- }}{{#clear_external_data:}}
| + | |
| − | |}
| + | |
| − | | + | |
| − | |-|
| + | |
| − | Arena Skills=
| + | |
| − | | + | |
| − | {{#get_db_data:
| + | |
| − | db=fantawiki
| + | |
| − | |from=units
| + | |
| − | |where=released=1 and TRIM(arenaskill) <> ''
| + | |
| − | |order by=TRIM(REPLACE(REPLACE(REPLACE(`arenaskill`, '<br>', ''), '/>', ''), '<br', ''))
| + | |
| − | |group by=TRIM(REPLACE(REPLACE(REPLACE(`arenaskill`, '<br>', ''), '/>', ''), '<br', ''))
| + | |
| − | |data=arenaskill=TRIM(REPLACE(REPLACE(REPLACE(`arenaskill`, '<br>', ''), '/>', ''), '<br', ''))}}
| + | |
| − | {| class="wikitable sortable" style="text-align:center;"
| + | |
| − | ! data-sort-type="text" | Skill
| + | |
| − | |-
| + | |
| − | {{#for_external_table:<nowiki/>
| + | |
| − | {{!}} {{{arenaskill}}}
| + | |
| − | {{!}}- }}{{#clear_external_data:}}
| + | |
| − | |}
| + | |
| − | </tabber>
| + | |
