Water's Blessing - Revision history

>Mornsta-gpuser at 21:08, 24 March 2019

2019-03-24T21:08:29Z

2019-03-24T21:08:29Z

2019-03-24T21:08:29Z

2019-03-22T15:49:31Z

2019-03-22T15:49:31Z

2019-03-22T15:49:31Z

2019-03-22T15:36:45Z

2019-03-22T15:36:45Z

2019-03-22T15:36:45Z

2019-03-22T14:53:31Z

← Older revision		Revision as of 21:08, 24 March 2019
Line 1:		Line 1:
−	~~<!--~~
−	~~Input the Summon Showcase's data from SummonData and TextLabel.~~
−
−	~~If unsure or inaccessible, fill in the following:~~
−	~~\|Title= Name of Summon Showcase.~~
−	~~\|StartDate= Start Date and Time with timezone in preferably UTC, e.g. December 17, 2018 6:00:00 AM UTC~~
−	~~\|EndDate= End Date and Time with timezone in preferably UTC, e.g. December 31, 2018 5:59:59 AM UTC~~
−	~~\|Adventurer= Featured Adventurers, e.g. Dragonyule Cleo, Dragonyule Nefaria, Dragonyule Xander~~
−	~~\|Dragon= Featured Dragons, e.g. Dragonyule Jeanne, Vodyanoy~~
−	~~\|Wyrmprint= Featured Wyrmprints, e.g. A Wish Upon the Yuletree, The Prince of Dragonyule, Trove of Knowledge, Saintly Delivery, Roast Feast~~
−	~~-->~~
	{{SummonShowcase		{{SummonShowcase
	\|Title=Water's Blessing		\|Title=Water's Blessing

@@ Line 20: / Line 20: @@
 |q?tables=Adventurers
 |q?fields=CONCAT('Adventurer')=Type,FullName=Name
-|q?where=IsPlayable!=0 AND ElementalType="Water" AND Obtain="Summoning"
+|q?where=IsPlayable!=0 AND Obtain="Summoning" AND ElementalType="Water" AND ReleaseDate <= "2019-3-20 6:00:00"
 |q?groupBy=_pageName
 |q?orderBy= Rarity DESC, ElementalTypeId ASC, WeaponTypeId ASC, Id DESC, FullName ASC
@@ Line 30: / Line 30: @@
 |tables=Adventurers
 |fields=FullName=Name
-|where=IsPlayable!=0 AND ElementalType="Water" AND Obtain="Summoning"
+|where=IsPlayable!=0 AND Obtain="Summoning" AND ElementalType="Water" AND ReleaseDate <= "2019-3-20 6:00:00"
 |group by=_pageName
 |order by= Rarity DESC, ElementalTypeId ASC, WeaponTypeId ASC, Id DESC, FullName ASC
@@ Line 40: / Line 40: @@
 |q?tables=Dragons
 |q?fields=CONCAT('Dragon')=Type,FullName=Name
-|q?where=IsPlayable!=0 AND ElementalType="Water" AND Obtain="Summoning"
+|q?where=IsPlayable!=0 AND Obtain="Summoning" AND ElementalType="Water" AND ReleaseDate <= "2019-3-20 6:00:00"
 |q?groupBy=_pageName
 |q?orderBy= Rarity DESC, ElementalTypeId ASC, Id DESC, FullName ASC
@@ Line 50: / Line 50: @@
 |tables=Dragons
 |fields=FullName=Name
-|where=IsPlayable!=0 AND ElementalType="Water" AND Obtain="Summoning"
+|where=IsPlayable!=0 AND Obtain="Summoning" AND ElementalType="Water" AND ReleaseDate <= "2019-3-20 6:00:00"
 |group by=_pageName
 |order by= Rarity DESC, ElementalTypeId ASC, Id DESC, FullName ASC

@@ Line 23: / Line 23: @@
 |q?groupBy=_pageName
 |q?orderBy= Rarity DESC, ElementalTypeId ASC, WeaponTypeId ASC, Id DESC, FullName ASC
-|template=TooltipIcon
+|template=UnitIcon
 |more results text=
 |default=
@@ Line 43: / Line 43: @@
 |q?groupBy=_pageName
 |q?orderBy= Rarity DESC, ElementalTypeId ASC, Id DESC, FullName ASC
-|template=TooltipIcon
+|template=UnitIcon
 |more results text=
 |default=
@@ Line 53: / Line 53: @@
 |group by=_pageName
 |order by= Rarity DESC, ElementalTypeId ASC, Id DESC, FullName ASC
-|template=TooltipIcon
+|template=UnitIcon
 |more results text=
 |default=

← Older revision	Revision as of 21:08, 24 March 2019
(No difference)

← Older revision	Revision as of 15:49, 22 March 2019
(No difference)

← Older revision	Revision as of 15:36, 22 March 2019
(No difference)

← Older revision	Revision as of 14:53, 22 March 2019
(No difference)