Units Missing All Stats - Revision history

Kattiara at 11:17, 27 March 2019

2019-03-27T11:17:42Z

Kattiara: Pulling goddesses out of results

2016-11-23T01:33:19Z

Pulling goddesses out of results

Kattiara at 18:05, 6 November 2016

2016-11-06T18:05:59Z

Mwilkens37 at 06:49, 12 October 2016

2016-10-12T06:49:06Z

Mwilkens37 at 06:44, 12 October 2016

2016-10-12T06:44:21Z

Mwilkens37 at 06:43, 12 October 2016

2016-10-12T06:43:01Z

Mwilkens37: Created page with "

@@ Line 44: / Line 44: @@
 <tabber>
 * Units =
 {{#get_db_data:db=fantawiki

@@ Line 47: / Line 47: @@
 {{#get_db_data:db=fantawiki
 |from=units
-|where=rarity=11 and released=1 and land+air+sea=0 and landlb+airlb+sealb=0
+|where=rarity=11 and released=1 and land+air+sea=0 and landlb+airlb+sealb=0 and name NOT like "Aeroma"
 |order by=rarity DESC, 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 91: / Line 91: @@
 {{#get_db_data:db=fantawiki
 |from=units
-|where=rarity=10 and released=1 and land+air+sea=0 and landlb+airlb+sealb=0
+|where=rarity=10 and released=1 and land+air+sea=0 and landlb+airlb+sealb=0 and name NOT like "Aerora"
 |order by=rarity DESC, 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 135: / Line 135: @@
 {{#get_db_data:db=fantawiki
 |from=units
-|where=rarity=9 and released=1 and land+air+sea=0 and landlb+airlb+sealb=0
+|where=rarity=9 and released=1 and land+air+sea=0 and landlb+airlb+sealb=0 and name NOT like "Aery"
 |order by=rarity DESC, 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 178: / Line 178: @@
 {{#get_db_data:db=fantawiki
 |from=units
-|where=rarity=8 and released=1 and land+air+sea=0 and landlb+airlb+sealb=0
+|where=rarity=8 and released=1 and land+air+sea=0 and landlb+airlb+sealb=0 and name NOT like "Aeru"
 |order by=rarity DESC, 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 221: / Line 221: @@
 {{#get_db_data:db=fantawiki
 |from=units
-|where=rarity=7 and released=1 and land+air+sea=0 and landlb+airlb+sealb=0
+|where=rarity=7 and released=1 and land+air+sea=0 and landlb+airlb+sealb=0 and name NOT like "Aer"
 |order by=rarity DESC, 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 350: / Line 350: @@
 {{#get_db_data:db=fantawiki
 |from=units
-|where=rarity=4 and released=1 and land+air+sea=0 and landlb+airlb+sealb=0
+|where=rarity=4 and released=1 and land+air+sea=0 and landlb+airlb+sealb=0 and name NOT in ("Anu", "Danu", "Tartu", "Epona")
 |order by=rarity DESC, 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 44: / Line 44: @@
 <tabber>
 * Units =
 {{#get_db_data:db=fantawiki

← Older revision		Revision as of 06:49, 12 October 2016
Line 474:		Line 474:
	{{!}}- }}{{#clear_external_data:}}		{{!}}- }}{{#clear_external_data:}}
	\|}		\|}
		+	[[Category:Missing Stats]]

@@ Line 32: / Line 32: @@
 -->
 * To update a unit's stats, please go to: http://www.fantasicawiki.com/edit_unit.php?unit=UnitName
@@ Line 45: / Line 40: @@
 * [http://www.fantasicawiki.com/wiki/Units_Missing_All_Stats?action=purge Click here] to refresh this page.
 <tabber>

← Older revision		Revision as of 06:43, 12 October 2016
Line 36:		Line 36:


−	== Units Missing ~~Max Level Broken~~ Stats ==	+	== Units Missing All Stats ==

	* To update a unit's stats, please go to: http://www.fantasicawiki.com/edit_unit.php?unit=UnitName		* To update a unit's stats, please go to: http://www.fantasicawiki.com/edit_unit.php?unit=UnitName