Difference between revisions of "User:ZachBora"

From Unofficial Fantasica Wiki
Jump to: navigation, search
(Created page with "Works with Uriel_10 and Uriel. Just replace the name='' {{#get_db_data: db=fantawiki |from=units |where=name='Uriel_10' |limit=1 |data=name=`name`,fullname=`fullname`,gender...")
 
Line 1: Line 1:
Works with Uriel_10 and Uriel. Just replace the name=''
 
 
  
 +
Top Dmg/Cost cards
 
{{#get_db_data:
 
{{#get_db_data:
 
db=fantawiki
 
db=fantawiki
 
|from=units
 
|from=units
|where=name='Uriel_10'
+
|limit=20
|limit=1
+
|order by=(air+sea+land)/cost DESC
|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=`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`
}}{{#ifexpr: {{#external_value:rarity}}>9 |
+
<tabber>
+
Regular Form=  
+
{{Infobox_Card
+
|name={{#external_value:name}}
+
|fullname={{#external_value:fullname}}
+
|rarity={{#external_value:rarity}}
+
|type={{#external_value:type}}
+
|cost={{#external_value:cost}}
+
|speed={{#external_value:speed}}
+
|range={{#external_value:range}}
+
|ground={{formatnum:{{#external_value:land}}}}
+
|arena={{formatnum:{{#external_value:arena}}}}
+
|air={{formatnum:{{#external_value:air}}}}
+
|sea={{formatnum:{{#external_value:sea}}}}
+
|total={{formatnum:{{#expr: {{#external_value:land|}}+{{#external_value:air|}}+{{#external_value:sea|}} }} }}
+
|ground2={{formatnum:{{#external_value:land2}}}}
+
|air2={{formatnum:{{#external_value:air2}}}}
+
|sea2={{formatnum:{{#external_value:sea2}}}}
+
|arenalb={{formatnum:{{#external_value:arenalb}}}}
+
|total2={{formatnum:{{#expr: {{#external_value:land2|0}}+{{#external_value:air2|0}}+{{#external_value:sea2|0}} }} }}
+
|skill={{#external_value:skill1}}{{#if: {{#external_value:skill2}} | , {{#external_value:skill2}}}}{{#if: {{#external_value:arenaskill}} | , {{#external_value:arenaskill}}}}
+
|source={{#external_value:source}}
+
 
}}
 
}}
{{Card_artwork|{{#external_value:name}}}}{{#clear_external_data:}}
 
|-|
 
Empowered Form=
 
{{#get_db_data:
 
db=fantawiki
 
|from=units
 
|where=name='Uriel_10_mlb'
 
|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`
 
}}
 
{{Infobox_Card
 
|name={{#external_value:name}}
 
|fullname={{#external_value:fullname}}
 
|rarity={{#external_value:rarity}}
 
|type={{#external_value:type}}
 
|cost={{#external_value:cost}}
 
|speed={{#external_value:speed}}
 
|range={{#external_value:range}}
 
|ground={{formatnum:{{#external_value:land}}}}
 
|arena={{formatnum:{{#external_value:arena}}}}
 
|air={{formatnum:{{#external_value:air}}}}
 
|sea={{formatnum:{{#external_value:sea}}}}
 
|total={{formatnum:{{#expr: {{#external_value:land|}}+{{#external_value:air|}}+{{#external_value:sea|}} }} }}
 
|ground2={{formatnum:{{#external_value:land2}}}}
 
|air2={{formatnum:{{#external_value:air2}}}}
 
|sea2={{formatnum:{{#external_value:sea2}}}}
 
|arenalb={{formatnum:{{#external_value:arenalb}}}}
 
|total2={{formatnum:{{#expr: {{#external_value:land2|0}}+{{#external_value:air2|0}}+{{#external_value:sea2|0}} }} }}
 
|skill={{#external_value:skill1}}{{#if: {{#external_value:skill2}} | , {{#external_value:skill2}}}}{{#if: {{#external_value:arenaskill}} | , {{#external_value:arenaskill}}}}
 
|source={{#external_value:source}}
 
}}
 
{{Card_artwork|{{#external_value:name}}}}{{#clear_external_data:}}
 
</tabber>
 
| {{Infobox_Card
 
|name={{#external_value:name}}
 
|fullname={{#external_value:fullname}}
 
|rarity={{#external_value:rarity}}
 
|type={{#external_value:type}}
 
|cost={{#external_value:cost}}
 
|speed={{#external_value:speed}}
 
|range={{#external_value:range}}
 
|ground={{formatnum:{{#external_value:land}}}}
 
|arena={{formatnum:{{#external_value:arena}}}}
 
|air={{formatnum:{{#external_value:air}}}}
 
|sea={{formatnum:{{#external_value:sea}}}}
 
|total={{formatnum:{{#expr: {{#external_value:land|}}+{{#external_value:air|}}+{{#external_value:sea|}} }} }}
 
|ground2={{formatnum:{{#external_value:land2}}}}
 
|air2={{formatnum:{{#external_value:air2}}}}
 
|sea2={{formatnum:{{#external_value:sea2}}}}
 
|arenalb={{formatnum:{{#external_value:arenalb}}}}
 
|total2={{formatnum:{{#expr: {{#external_value:land2|0}}+{{#external_value:air2|0}}+{{#external_value:sea2|0}} }} }}
 
|skill={{#external_value:skill1}}{{#if: {{#external_value:skill2}} | , {{#external_value:skill2}}}}{{#if: {{#external_value:arenaskill}} | , {{#external_value:arenaskill}}}}
 
|source={{#external_value:source}}
 
}}
 
{{Card_artwork|{{#external_value:name}}}} }}
 
  
  
 
+
{| class="wikitable sortable" style="text-align:center;"
 
+
! {{*}}
 
+
! Sprite
 
+
! Name
{{#get_db_data:
+
! Type
db=fantawiki
+
! Cost
|from=units
+
! Speed
|where=name='Uriel'
+
! Delay
|limit=1
+
! Range
|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`
+
! [[Image:Ground_icon.png]]
}}{{#ifexpr: {{#external_value:rarity}}>9 |
+
! [[Image:Air_icon.png]]
<tabber>
+
! [[Image:Sea_icon.png]]
Regular Form=
+
! Total
{{Infobox_Card
+
! Dmg/Cost
|name={{#external_value:name}}
+
<!--
|fullname={{#external_value:fullname}}
+
! Land DPS
|rarity={{#external_value:rarity}}
+
-->
|type={{#external_value:type}}
+
! Skill
|cost={{#external_value:cost}}
+
! Arena<br>Skill
|speed={{#external_value:speed}}
+
! Source
|range={{#external_value:range}}
+
|-
|ground={{formatnum:{{#external_value:land}}}}
+
{{#for_external_table:<nowiki/>
|arena={{formatnum:{{#external_value:arena}}}}
+
{{!}} {{{rarity}}}
|air={{formatnum:{{#external_value:air}}}}
+
{{!}} [[Image:{{{name}}}.gif]]
|sea={{formatnum:{{#external_value:sea}}}}
+
{{!}} [[Image:{{{name}}}_icon.png|32px|link={{{name}}}]]<br/>[[{{{name}}}]]
|total={{formatnum:{{#expr: {{#external_value:land|}}+{{#external_value:air|}}+{{#external_value:sea|}} }} }}
+
{{!}} {{{type}}}
|ground2={{formatnum:{{#external_value:land2}}}}
+
{{!}} {{{cost}}}
|air2={{formatnum:{{#external_value:air2}}}}
+
{{!}} {{{speed}}}
|sea2={{formatnum:{{#external_value:sea2}}}}
+
{{!}} {{{speednum}}}
|arenalb={{formatnum:{{#external_value:arenalb}}}}
+
{{!}} {{{range}}}
|total2={{formatnum:{{#expr: {{#external_value:land2|0}}+{{#external_value:air2|0}}+{{#external_value:sea2|0}} }} }}
+
{{!}} {{{land}}}<br/>({{{landlb}}})
|skill={{#external_value:skill1}}{{#if: {{#external_value:skill2}} | , {{#external_value:skill2}}}}{{#if: {{#external_value:arenaskill}} | , {{#external_value:arenaskill}}}}
+
{{!}} {{{air}}}<br/>({{{airlb}}})
|source={{#external_value:source}}
+
{{!}} {{{sea}}}<br/>({{{sealb}}})
}}
+
{{!}} {{{total}}}<br/>({{{totallb}}})
{{Card_artwork|{{#external_value:name}}}}{{#clear_external_data:}}
+
{{!}} {{{dmgcost}}}
|-|
+
<!--
Empowered Form=
+
{{!}} {{{landdps}}}
{{#get_db_data:
+
-->
db=fantawiki
+
{{!}} {{{skill1}}} {{{skill2}}}
|from=units
+
{{!}} {{{arenaskill}}}
|where=name='Uriel_mlb'
+
{{!}} {{{source}}}
|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`
+
{{!}}- }}{{#clear_external_data:}}
}}
+
|}
{{Infobox_Card
+
|name={{#external_value:name}}
+
|fullname={{#external_value:fullname}}
+
|rarity={{#external_value:rarity}}
+
|type={{#external_value:type}}
+
|cost={{#external_value:cost}}
+
|speed={{#external_value:speed}}
+
|range={{#external_value:range}}
+
|ground={{formatnum:{{#external_value:land}}}}
+
|arena={{formatnum:{{#external_value:arena}}}}
+
|air={{formatnum:{{#external_value:air}}}}
+
|sea={{formatnum:{{#external_value:sea}}}}
+
|total={{formatnum:{{#expr: {{#external_value:land|}}+{{#external_value:air|}}+{{#external_value:sea|}} }} }}
+
|ground2={{formatnum:{{#external_value:land2}}}}
+
|air2={{formatnum:{{#external_value:air2}}}}
+
|sea2={{formatnum:{{#external_value:sea2}}}}
+
|arenalb={{formatnum:{{#external_value:arenalb}}}}
+
|total2={{formatnum:{{#expr: {{#external_value:land2|0}}+{{#external_value:air2|0}}+{{#external_value:sea2|0}} }} }}
+
|skill={{#external_value:skill1}}{{#if: {{#external_value:skill2}} | , {{#external_value:skill2}}}}{{#if: {{#external_value:arenaskill}} | , {{#external_value:arenaskill}}}}
+
|source={{#external_value:source}}
+
}}
+
{{Card_artwork|{{#external_value:name}}}}{{#clear_external_data:}}
+
</tabber>
+
| {{Infobox_Card
+
|name={{#external_value:name}}
+
|fullname={{#external_value:fullname}}
+
|rarity={{#external_value:rarity}}
+
|type={{#external_value:type}}
+
|cost={{#external_value:cost}}
+
|speed={{#external_value:speed}}
+
|range={{#external_value:range}}
+
|ground={{formatnum:{{#external_value:land}}}}
+
|arena={{formatnum:{{#external_value:arena}}}}
+
|air={{formatnum:{{#external_value:air}}}}
+
|sea={{formatnum:{{#external_value:sea}}}}
+
|total={{formatnum:{{#expr: {{#external_value:land|}}+{{#external_value:air|}}+{{#external_value:sea|}} }} }}
+
|ground2={{formatnum:{{#external_value:land2}}}}
+
|air2={{formatnum:{{#external_value:air2}}}}
+
|sea2={{formatnum:{{#external_value:sea2}}}}
+
|arenalb={{formatnum:{{#external_value:arenalb}}}}
+
|total2={{formatnum:{{#expr: {{#external_value:land2|0}}+{{#external_value:air2|0}}+{{#external_value:sea2|0}} }} }}
+
|skill={{#external_value:skill1}}{{#if: {{#external_value:skill2}} | , {{#external_value:skill2}}}}{{#if: {{#external_value:arenaskill}} | , {{#external_value:arenaskill}}}}
+
|source={{#external_value:source}}
+
}}
+
{{Card_artwork|{{#external_value:name}}}} }}
+

Revision as of 03:29, 15 July 2015

Top Dmg/Cost cards


Sprite Name Type Cost Speed Delay Range Ground icon.png Air icon.png Sea icon.png Total Dmg/Cost Skill Arena
Skill
Source
12 Jacqueline 12.gif Jacqueline 12 icon.png
Jacqueline_12
Magic 10 C 0.00 150 296008
(379000)
296008
(379000)
389654
(491000)
981670
(1249000)
98167.0000 Knockback Acid Deluge Heroic Packs 44
12 Hydiconica.gif Hydiconica icon.png
Hydiconica
Melee 10 C 0.00 130 376984
(477000)
306008
(389000)
275722
(351000)
958714
(1217000)
95871.4000 Knockback Piercing Flash Paper Hearts
1st-100th Rank Reward
12 Elf Princess.gif Elf Princess icon.png
Elf_Princess
Magic 10 C 0.00 150 277456
(0)
308742
(0)
372048
(0)
958246
(0)
95824.6000 Slow Angelic Aura 5 Star Plus Packs 84
11 Tiwaz mlb.gif Tiwaz mlb icon.png
Tiwaz_mlb
Melee 10 B 0.00 130 351248
(406500)
315976
(372500)
279206
(343000)
946430
(1122000)
94643.0000 Knockback Critical Shot Elders of Edda
1st Place
Pullable with
Star Ticket icon.png Star Tickets &
Star SP Ticket icon.png Star SP Tickets &
Star DX Ticket icon.png Star DX Tickets
11 Mattis mlb.gif Mattis mlb icon.png
Mattis_mlb
Melee 10 B 0.00 130 277751
(341000)
313976
(370500)
353566
(409000)
945293
(1120500)
94529.3000 Slow Piercing Flash The Fantasica Chronicles 64
1st-20th Rank Reward
10 Calcabrina.gif Calcabrina icon.png
Calcabrina
Melee 10 SS 0.00 130 303061
(700000)
288218
(700000)
276691
(700000)
867970
(2100000)
86797.0000 Poison
Frenzy
Symphony of Destruction
Group Rank Reward
1st - 200th
400 units awarded
11 Tiwaz.gif Tiwaz icon.png
Tiwaz
Melee 10 B 0.00 130 294063
(339500)
268109
(315000)
223194
(255000)
785366
(909500)
78536.6000 Knockback Critical Shot Elders of Edda
1st Place
Pullable with
Star Ticket icon.png Star Tickets &
Star SP Ticket icon.png Star SP Tickets &
Star DX Ticket icon.png Star DX Tickets
11 Mattis.gif Mattis icon.png
Mattis
Melee 10 B 0.00 130 222057
(253500)
265927
(313000)
295563
(341000)
783547
(907500)
78354.7000 Slow Piercing Flash The Fantasica Chronicles 64
1st-20th Rank Reward
8 Debonnaire.gif Debonnaire icon.png
Debonnaire
Melee 5 C 0.00 130 134001
(145024)
106116
(114927)
120002
(129996)
360119
(389947)
72023.8000 Knockback
Penta Attack
Extreme Packs Season 103
12 Donuts.gif Donuts icon.png
Donuts
Missile 15 B 0.00 150 358442
(0)
358442
(0)
358442
(0)
1075326
(0)
71688.4000 Slow Atk Boost (Female) Atrophy Ultimate Plus Packs 89
12 Ely.gif Ely icon.png
Ely
Magic 15 B 0.00 150 301402
(0)
434630
(0)
301402
(0)
1037434
(0)
69162.2667 Slow Knockback Lightning Fury Heroic Packs 42
11 Mirtes mlb.gif Mirtes mlb icon.png
Mirtes_mlb
Missile 15 S 0.00 150 346842
(409000)
363616
(430500)
326071
(393500)
1036529
(1233000)
69101.9333 Knockback Dancing Lightning Ultimate Plus Packs 79
12 Jogasaki Nanao v2.gif Jogasaki Nanao v2 icon.png
Jogasaki_Nanao_v2
Magic 15 B 0.00 150 317811
(0)
413519
(0)
300870
(0)
1032200
(0)
68813.3333 Slow Mirror Shield Extreme Packs Season 127
12 Rolans.gif Rolans icon.png
Rolans
Missile 15 B 0.00 150 396738
(0)
290594
(0)
340230
(0)
1027562
(0)
68504.1333 Slow Critical Shot Three Step Packs 106
12 Tapio.gif Tapio icon.png
Tapio
Magic 15 B 0.00 150 362511
(460000)
302306
(384500)
362511
(460000)
1027328
(1304500)
68488.5333 Slow Bunker Down Between the Leaves
1st-100th Rank Reward
12 Tantan.gif Tantan icon.png
Tantan
Missile 15 B 0.00 150 393536
(0)
292530
(0)
339028
(0)
1025094
(0)
68339.6000 Knockback Big Bang 5 Star Plus Packs 82
11 Gerbera v2 mlb.gif Gerbera v2 mlb icon.png
Gerbera_v2_mlb
Missile 15 A 0.00 150 310659
(371000)
343887
(405500)
362842
(425000)
1017388
(1201500)
67825.8667 Poison 5 Area Attack 6 Atrophy In Elysium
2nd Place
Pullable with
Star Ticket 4 icon.png Star Tickets &
Star SP Ticket 4 icon.png Star SP Tickets &
Star DX Ticket 4 icon.png Star DX Tickets
11 Sanosuke Harada mlb.gif Sanosuke Harada mlb icon.png
Sanosuke_Harada_mlb
Melee 15 S 0.00 110 377982
(450500)
319433
(382500)
319433
(382500)
1016848
(1215500)
67789.8667 Knockback Nerve Strike Footsies
11 Queen Nightmare mlb.gif Queen Nightmare mlb icon.png
Queen_Nightmare_mlb
Missile 15 B 0.00 150 328023
(388000)
378023
(438000)
304845
(375000)
1010891
(1201000)
67392.7333 Poison Bale Storm Liars_&_Lullabies
1st-300th Rank Reward
11 Rossetto 11 mlb.gif Rossetto 11 mlb icon.png
Rossetto_11_mlb
Missile 15 C 0.00 150 376339
(430500)
337752
(403000)
293934
(361000)
1008025
(1194500)
67201.6667 Knockback
Mirror Shield
Make It All Up
1st Place
Pullable with
Beauty Ticket icon.png Beauty Tickets &
Beauty SP Ticket icon.png Beauty SP Tickets &
Beauty DX Ticket icon.png Beauty DX Tickets
Personal tools
Namespaces

Variants
Actions
Menu
Game Menu
Card Lists
Trading
External Resources
Toolbox