4 Star Units - Revision history

Kattiara: Pulling goddesses out of results

2016-11-23T01:56:14Z

Pulling goddesses out of results

Kattiara: adjusting for awakened units

2014-05-18T02:21:11Z

adjusting for awakened units

Kattiara: Adding Recruitment tab

2014-05-18T02:00:08Z

Adding Recruitment tab

Rice9817 at 04:28, 2 May 2014

2014-05-02T04:28:25Z

Kattiara: type tabs

2014-05-02T00:23:50Z

type tabs

Show changes

Froswyth at 18:30, 4 February 2014

2014-02-04T18:30:38Z

Krisnasutanto: Undo revision 16829 by Krisnasutanto (talk)

2013-10-27T22:26:26Z

Undo revision 16829 by Krisnasutanto (talk)

Krisnasutanto at 22:25, 27 October 2013

2013-10-27T22:25:40Z

Krisnasutanto at 22:08, 27 October 2013

2013-10-27T22:08:53Z

Krisnasutanto at 22:06, 27 October 2013

2013-10-27T22:06:31Z

@@ Line 38: / Line 38: @@
 {{#get_db_data:db=fantawiki
 |from=units
-|where=rarity=4 and released=1
+|where=rarity=4 and released=1 and name NOT in ("Anu", "Danu", "Tartu", "Epona", "Enurta")
 |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 86: / Line 86: @@
 {{#get_db_data:db=fantawiki
 |from=units
-|where=rarity=4 and released=1 and source like "%Rank%"
+|where=rarity=4 and released=1 and source like "%Rank%" and name NOT in ("Anu", "Danu", "Tartu", "Epona", "Enurta")
 |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 134: / Line 134: @@
 {{#get_db_data:db=fantawiki
 |from=units
-|where=rarity=4 and released=1 and source not like "%rank%" and source like "%reward%"
+|where=rarity=4 and released=1 and source not like "%rank%" and source like "%reward%" and name NOT in ("Anu", "Danu", "Tartu", "Epona", "Enurta")
 |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 182: / Line 182: @@
 {{#get_db_data:db=fantawiki
 |from=units
-|where=rarity=4 and released=1 and (source like "%Recruit%" or source like "%awaken%") and source not like "%pandora%"
+|where=rarity=4 and released=1 and (source like "%Recruit%" or source like "%awaken%") and source not like "%pandora%" and name NOT in ("Anu", "Danu", "Tartu", "Epona", "Enurta")
 |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=4 and released=1 and source not like "%reward%" and source not like "%standard%" and source not like "%awaken%"
+|where=rarity=4 and released=1 and source not like "%reward%" and source not like "%standard%" and source not like "%awaken%" and name NOT in ("Anu", "Danu", "Tartu", "Epona", "Enurta")
 |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 278: / Line 278: @@
 {{#get_db_data:db=fantawiki
 |from=units
-|where=rarity=4 and released=1 and source like "%standard card pack%"
+|where=rarity=4 and released=1 and source like "%standard card pack%" and name NOT in ("Anu", "Danu", "Tartu", "Epona", "Enurta")
 |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 326: / Line 326: @@
 {{#get_db_data:db=fantawiki
 |from=units
-|where=rarity=4 and released=0
+|where=rarity=4 and released=0 and name NOT in ("Anu", "Danu", "Tartu", "Epona", "Enurta")
 |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 5: / Line 5: @@
 Please do not edit this page directly.
-To edit unit stats, please use http://www.fantasicawiki.com/edit.php?rarity=7
+To edit unit stats, please use http://www.fantasicawiki.com/edit.php?rarity=4
 This page is dynamically generated from the data in the database.
@@ Line 86: / Line 86: @@
 {{#get_db_data:db=fantawiki
 |from=units
-|where=rarity=4 and released=1 and source like "%rank%"
+|where=rarity=4 and released=1 and source like "%Rank%"
 |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 99: / Line 99: @@
 ! D
 ! R
-! [[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
 ! Arena Skill
@@ Line 147: / Line 147: @@
 ! D
 ! R
-! [[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
 ! Arena Skill
@@ 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=4 and released=1 and source like "%Recruit%" and source not like "%pandora%"
+|where=rarity=4 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=4 and released=1 and source not like "%reward%" and source not like "%standard%"
+|where=rarity=4 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 243: / Line 243: @@
 ! D
 ! R
-! [[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
 ! Arena Skill
@@ Line 339: / Line 339: @@
 ! D
 ! R
-! [[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
 ! Arena Skill

@@ Line 152: / Line 152: @@
 ! Total
 ! Arena
 ! Skill
 ! Arena Skill

@@ Line 51: / Line 51: @@
 ! D
 ! R
-! [[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
 ! Arena Skill

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

@@ Line 37: / Line 37: @@
 |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`}}
-{| class="wikitable sortable" style="text-align:center;"
+{| class="wikitable sortable" style="text-align:center;min-width:980px"
 ! Sprite
 ! Name
@@ Line 53: / Line 53: @@
 ! Skill
 ! Arena Skill
-! Source
+! width="150" | Source
 |-
 {{#for_external_table:<nowiki/>