2 Star Units - Revision history

Kattiara: adjusting for awakened units

2014-05-18T02:18:11Z

adjusting for awakened units

Kattiara: type tabs

2014-05-18T02:12:17Z

type tabs

Kattiara: type tabs

2014-05-18T02:09:06Z

type tabs

Show changes

Rice9817 at 04:26, 2 May 2014

2014-05-02T04:26:10Z

Froswyth at 18:30, 4 February 2014

2014-02-04T18:30:09Z

Kattiara: Fixing comments

2013-11-20T19:47:04Z

Fixing comments

D-Troxx at 17:30, 20 November 2013

2013-11-20T17:30:30Z

Krisnasutanto at 22:02, 27 October 2013

2013-10-27T22:02:01Z

Krisnasutanto at 22:01, 27 October 2013

2013-10-27T22:01:02Z

Krisnasutanto at 21:52, 27 October 2013

2013-10-27T21:52:00Z

@@ Line 178: / Line 178: @@
 |-|
 Recruited Units =
-{{*}} units that must be [[Recruitment|Recruited]] from their [[Monsters|Monster]] forms:
+{{*}} units that must be [[Recruitment|Recruited]] or [[Awakening|Awakened]] from their [[Monsters|Monster]] forms:
 {{#get_db_data:db=fantawiki
 |from=units
-|where=rarity=2 and released=1 and source like "%Recruit%" and source not like "%pandora%"
+|where=rarity=2 and released=1 and (source like "%Recruit%" or source like "%awaken%") and source not like "%pandora%"
 |order by=name
 |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`}}
@@ Line 230: / Line 230: @@
 {{#get_db_data:db=fantawiki
 |from=units
-|where=rarity=2 and released=1 and source not like "%reward%" and source not like "%standard%"
+|where=rarity=2 and released=1 and source not like "%reward%" and source not like "%standard%" and source not like "%awaken%"
 |order by=name
 |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`}}

@@ Line 248: / Line 248: @@
 ! data-sort-type="number" | Total
 ! data-sort-type="number" | Arena
 ! Skill
 ! Arena Skill

@@ Line 46: / Line 46: @@
 ! Delay
 ! Range
-! [[Image:Ground_icon.png]]
+! data-sort-type="number" | [[Image:Ground_icon.png]]
-! [[Image:Air_icon.png]]
+! data-sort-type="number" | [[Image:Air_icon.png]]
-! [[Image:Sea_icon.png]]
+! data-sort-type="number" | [[Image:Sea_icon.png]]
-! Total
+! data-sort-type="number" | Total
-! Arena
+! data-sort-type="number" | Arena
 ! Skill
 ! Source

@@ Line 56: / Line 56: @@
 {{#for_external_table:<nowiki/>
 {{!}} [[Image:{{{name}}}.gif]]
-{{!}} [[Image:{{{name}}}_icon.png]]<br/>[[{{{name}}}]]
+{{!}} [[Image:{{{name}}}_icon.png|link={{{name}}}]]<br/>[[{{{name}}}]]
 {{!}} {{{gender}}}
 {{!}} {{{type}}}

@@ Line 5: / Line 5: @@
 Please do not edit this page directly.
-To edit unit stats, please use http://www.fantasicawiki.com/edit.php?rarity=4
+To edit unit stats, please use http://www.fantasicawiki.com/edit.php?rarity=2
 This page is dynamically generated from the data in the database.
@@ Line 11: / Line 11: @@
 If the changes don't show up right away, you can force a refresh by loading this url:
-http://www.fantasicawiki.com/wiki/4_Star_Units?action=purge
+http://www.fantasicawiki.com/wiki/2_Star_Units?action=purge

@@ Line 1: / Line 1: @@
 <!--
- rows = number of item
 -->
-<!-- Static column begin -->
+{{#get_db_data:db=fantawiki
-{{Static column begin |rows=26 |header-text=No |header-height=45px |row-height=100px |text-align=center}}
+|from=units
-<!-- Sorted table start -->
+|where=rarity=2 and released=1
 {| class="wikitable sortable" style="text-align:center;"
-|- style="height:50px"
+! Sprite
-! !! Unit Name !! Rarity !! Type!! Cost !! Speed !! Range !! Max Land !! Max Air !! Max Sea !! Skill !! Source
+! Name
-|- style="height:100px"
+! Gender
-| [[Image:Adelaide.gif]] || {{Icon|Adelaide}}<br>[[Adelaide]] || 2 || Magic || 15 || D || 150 || 9438 || 7850 || 5918 ||  ||
+! Type
-|- style="height:100px"
+! Cost
-| [[Image:Alicia.gif]] || {{Icon|Alicia}}<br>[[Alicia]] || 2 || Missile || 15 || C || 175 || 5980 || 7906 || 6230 ||  ||
+! Speed
-|- style="height:100px"
+! Delay
-| [[Image:Anna.gif]] || {{Icon|Anna}}<br>[[Anna]] || 2 || Magic || 10 || D || 150 || 9602 || 3831 || 9205 ||  ||
+! Range
-|- style="height:100px"
+! [[Image:Ground_icon.png]]
-| [[Image:Bjorn.gif]] || {{Icon|Bjorn}}<br>[[Bjorn]] || 2 || Magic || 30 || E || 150 || 10168 || 6855 || 8491 || Knockback ||
+! [[Image:Air_icon.png]]
-|- style="height:100px"
+! [[Image:Sea_icon.png]]
-| [[Image:Claudio.gif]] || {{Icon|Claudio}}<br>[[Claudio]] || 2 || Missile || 15 || D || 150 || 6252 || 4371 || 2563 || Atk Boost (Female) ||
+! Total
-|- style="height:100px"
+! Arena
-| [[Image:Damien.gif]] || {{Icon|Damien}}<br>[[Damien]] || 2 || Magic || 15 || D || 150 || 9921 || 8816 || 3675 ||  ||
+! Skill
-|- style="height:100px"
+! Source
-| [[Image:Dominique.gif]] || {{Icon|Dominique}}<br>[[Dominique]] || 2 || Melee || 15 || B || 130 || 9607 || 0 || 2664 ||  ||
-|- style="height:100px"
-| [[Image:Elmer.gif]] || {{Icon|Elmer}}<br>[[Elmer]] || 2 || Magic || 25 || D || 150 || 8022 || 3855 || 8022 || Poison ||
-|- style="height:100px"
-| [[Image:Enrique.gif]] || {{Icon|Enrique}}<br>[[Enrique]] || 2 || Melee || 25 || C || 110 || 12274 || 0 || 2431 || Knockback ||
-|- style="height:100px"
-| [[Image:Harore.gif]] || {{Icon|Harore}}<br>[[Harore]] || 2 || Melee || 15 || B || 130 || 0 || 0 || 0 || Poison || [[The Elder Tree]]
-|- style="height:100px"
-| [[Image:Igor.gif]] || {{Icon|Igor}}<br>[[Igor]] || 2 || Magic || 10 || D || 150 || 8971 || 3831 || 1277 || Slow ||
-|- style="height:100px"
-| [[Image:Iwan.gif]] || {{Icon|Iwan}}<br>[[Iwan]] || 2 || Melee || 30 || C || 130 || 11842 || 0 || 12583 ||  ||
-|- style="height:100px"
-| [[Image:Jane.gif]] || {{Icon|Jane}}<br>[[Jane]] || 2 || Missile || 15 || E || 200 || 12314 || 15158 || 8961 || Knockback ||
-|- style="height:100px"
-| [[Image:Kappa_2.gif]] || {{Icon|Kappa_2}}<br>[[Kappa_2|Kappa]] || 2 || Melee || 20 || B || 130 || 8475 || 0 || 12113 || Knockback || [[Awakening]]
-|- style="height:100px"
-| [[Image:Killer Bee_2.gif]] || {{Icon|Killer Bee_2}}<br>[[Killer Bee_2|Killer Bee]] || 2 || Missile || 15 || C || 150 || 6440 || 7240 || 7280 || Poison || [[Awakening]]
-|- style="height:100px"
-| [[Image:Kira.gif]] || {{Icon|Kira}}<br>[[Kira]] || 2 || Melee || 15 || C || 130 || 10890 || 0 || 7850 ||  ||
-|- style="height:100px"
-| [[Image:Kirill.gif]] || {{Icon|Kirill}}<br>[[Kirill]] || 2 || Missile || 25 || C || 150 || 9543 || 7104 || 7578 || Speed Order (Arena Only)  ||
-|- style="height:100px"
-| [[Image:Notte.gif]] || {{Icon|Notte}}<br>[[Notte]] || 2 || Magic || 15 || D || 150 || 4035 || 9788 || 1637 ||  ||
-|- style="height:100px"
-| [[Image:Orlando.gif]] || {{Icon|Orlando}}<br>[[Orlando]] || 2 || Melee || 15 || B || 130 || 9269 || 0 || 6036 ||  ||
-|- style="height:100px"
-| [[Image:Pernilla.gif]] || {{Icon|Pernilla}}<br>[[Pernilla]] || 2 || Magic || 15 || D || 150 || 7088 || 5452 || 10946 || Slow ||
-|- style="height:100px"
-| [[Image:Rick.gif]] || {{Icon|Rick}}<br>[[Rick]] || 2 || Magic || 10 || D || 150 || 9586 || 3525 || 1207 ||  ||
-|- style="height:100px"
-| [[Image:Ritter.gif]] || {{Icon|Ritter}}<br>[[Ritter]] || 2 || Melee || 10 || B || 130 || 0 || 0 || 0 || Slow || [[The Elder Tree]]
-|- style="height:100px"
-| [[Image:Solveig.gif]] || {{Icon|Solveig}}<br>[[Solveig]] || 2 || Magic || 10 || D || 150 || 6262 || 4609 || 5140 || Poison ||
-|- style="height:100px"
-| [[Image:Veronika.gif]] || {{Icon|Veronika}}<br>[[Veronika]] || 2 || Magic || 10 || D || 150 || 8644 || 3659 || 1191 || Poison ||
-|- style="height:100px"
-| [[Image:Willy.gif]] || {{Icon|Willy}}<br>[[Willy]] || 2 || Melee || 15 || B || 130 || 7866 || 0 || 12972 ||  ||
-|- style="height:100px"
-| [[Image:Yakov.gif]] || {{Icon|Yakov}}<br>[[Yakov]] || 2 || Melee || 10 || C || 130 || 8840 || 0 || 8038 ||  ||
 |-
 |}