Difference between revisions of "User:ZachBora"

From Unofficial Fantasica Wiki
Jump to: navigation, search
(Replaced content with " {{Card_test2|Ada}}")
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>
+

Revision as of 03:32, 28 January 2016

Ada, Tribal Warrior
Ada icon.png
Ada.gif
Ada
Blank album 1.png
Melee icon.png Melee 130 Range C Speed
30 Cost
Lvl Ground icon.png Air icon.png Sea icon.png Total Arena HP
20 5,273 0 3,456 8,729 1,719 0
40 10,345 0 8,086 18,431 7,261 192,427
Increase per Ascension Step:
Spd Ground grey icon.png Air grey icon.png Sea grey icon.png Cost Range HP
95,000
Standard Card Packs
Training


Ada card.jpg Ada card back.jpg

JP Version Artwork:
Ada jp.jpgAda back jp.jpg

KR Version Artwork:
Ada kr.jpgAda back kr.jpg

CN Version Artwork:
Ada cn.jpgAda back cn.jpg

Personal tools
Namespaces

Variants
Actions
Menu
Game Menu
Card Lists
Trading
External Resources
Toolbox