Difference between revisions of "New Content"

From Dragalia Lost Wiki
Jump to navigation Jump to search
>Caledor92
>FlareKyn
 
(25 intermediate revisions by 3 users not shown)
Line 72: Line 72:
 
|q?fields=Image,BannerTopImage,Title,Type,MaxSummons,StartDate,EndDate,Adventurer,Dragons,Wyrmprints,Video
 
|q?fields=Image,BannerTopImage,Title,Type,MaxSummons,StartDate,EndDate,Adventurer,Dragons,Wyrmprints,Video
 
|q?where=NOW() between StartDate and EndDate
 
|q?where=NOW() between StartDate and EndDate
−
|q?orderBy=StartDate DESC, Title ASC
+
|q?orderBy=Type DESC, StartDate DESC, Title ASC
 
|q?groupBy=Title
 
|q?groupBy=Title
 
|template=CT
 
|template=CT
Line 82: Line 82:
 
{{#invoke:CargoQuery|main
 
{{#invoke:CargoQuery|main
 
|q?tables=Adventurers
 
|q?tables=Adventurers
−
|q?fields=FullName=Name
+
|q?fields=CONCAT('Adventurer')=Type,FullName=Name
−
|q?where=ReleaseDate="{{#cargo_query:tables=Events
+
|q?where=IsPlayable=1 AND (ReleaseDate>="{{#cargo_query:tables=SummonShowcase
 
|fields=StartDate
 
|fields=StartDate
 
|where=NOW() between StartDate and EndDate
 
|where=NOW() between StartDate and EndDate
 
|group by=StartDate
 
|group by=StartDate
−
|order by=StartDate DESC
+
|order by=StartDate ASC,
−
|limit=1
+
|limit=
 
|more results text=
 
|more results text=
 
|no html
 
|no html
−
}}" OR ReleaseDate="{{#cargo_query:tables=SummonShowcase
+
}}" OR ReleaseDate>="{{#cargo_query:tables=Events
 
|fields=StartDate
 
|fields=StartDate
−
|where=StartDate < NOW()
+
|where=NOW() between StartDate and EndDate
 
|group by=StartDate
 
|group by=StartDate
−
|order by=StartDate DESC
+
|order by=StartDate ASC
−
|limit=1
+
|limit=
 
|more results text=
 
|more results text=
 
|no html
 
|no html
−
}}"
+
}}")
 
|q?groupBy=_pageName
 
|q?groupBy=_pageName
 
|q?orderBy= ReleaseDate DESC, Rarity DESC, ElementalTypeId ASC, WeaponTypeId ASC, Id DESC, FullName ASC
 
|q?orderBy= ReleaseDate DESC, Rarity DESC, ElementalTypeId ASC, WeaponTypeId ASC, Id DESC, FullName ASC
 +
|more results text=
 +
|template=Character info card
 +
|default=
 +
}}
 +
 +
==Mana Spirals==
 +
{{#invoke:CargoQuery|main
 +
|q?tables=Adventurers
 +
|q?fields=CONCAT('Adventurer')=Type,FullName=Name
 +
|q?where=IsPlayable=1 AND (ManaSpiralDate>="{{#cargo_query:tables=SummonShowcase
 +
|fields=StartDate
 +
|where=NOW() between StartDate and EndDate
 +
|group by=StartDate
 +
|order by=StartDate ASC,
 +
|limit=
 +
|more results text=
 +
|no html
 +
}}" OR ManaSpiralDate>="{{#cargo_query:tables=Events
 +
|fields=StartDate
 +
|where=NOW() between StartDate and EndDate
 +
|group by=StartDate
 +
|order by=StartDate ASC
 +
|limit=
 +
|more results text=
 +
|no html
 +
}}")
 +
|q?groupBy=_pageName
 +
|q?orderBy= ManaSpiralDate DESC, Rarity DESC, ElementalTypeId ASC, WeaponTypeId ASC, Id DESC, FullName ASC
 
|more results text=
 
|more results text=
 
|template=Character info card
 
|template=Character info card
Line 110: Line 138:
 
{{#invoke:CargoQuery|main
 
{{#invoke:CargoQuery|main
 
|q?tables=Dragons
 
|q?tables=Dragons
−
|q?fields=FullName=Name
+
|q?fields=CONCAT('Dragon')=Type,FullName=Name
−
|q?where=ReleaseDate="{{#cargo_query:tables=Events
+
|q?where=IsPlayable=1 AND (ReleaseDate>="{{#cargo_query:tables=SummonShowcase
 
|fields=StartDate
 
|fields=StartDate
 
|where=NOW() between StartDate and EndDate
 
|where=NOW() between StartDate and EndDate
 
|group by=StartDate
 
|group by=StartDate
−
|order by=StartDate DESC
+
|order by=StartDate ASC
−
|limit=1
+
|limit=
 
|more results text=
 
|more results text=
 
|no html
 
|no html
−
}}" OR ReleaseDate="{{#cargo_query:tables=SummonShowcase
+
}}" OR ReleaseDate>="{{#cargo_query:tables=Events
 
|fields=StartDate
 
|fields=StartDate
−
|where=StartDate < NOW()
+
|where=NOW() between StartDate and EndDate
 
|group by=StartDate
 
|group by=StartDate
−
|order by=StartDate DESC
+
|order by=StartDate ASC
−
|limit=1
+
|limit=
 
|more results text=
 
|more results text=
 
|no html
 
|no html
−
}}"
+
}}")
 
|q?groupBy=_pageName
 
|q?groupBy=_pageName
 
|q?orderBy=ReleaseDate DESC, Rarity DESC, ElementalTypeId ASC, Id DESC, FullName ASC
 
|q?orderBy=ReleaseDate DESC, Rarity DESC, ElementalTypeId ASC, Id DESC, FullName ASC
Line 138: Line 166:
 
{{#invoke:CargoQuery|main
 
{{#invoke:CargoQuery|main
 
|q?tables=Wyrmprints
 
|q?tables=Wyrmprints
−
|q?fields=Name
+
|q?fields=CONCAT('Wyrmprint')=Type,Name=Name
−
|q?where=ReleaseDate between "{{#cargo_query:tables=Events
+
|q?where=IsPlayable=1 AND (ReleaseDate>="{{#cargo_query:tables=SummonShowcase
 
|fields=StartDate
 
|fields=StartDate
 
|where=NOW() between StartDate and EndDate
 
|where=NOW() between StartDate and EndDate
 
|group by=StartDate
 
|group by=StartDate
−
|order by=StartDate DESC
+
|order by=StartDate ASC
−
|limit=1
+
|limit=
 
|more results text=
 
|more results text=
 
|no html
 
|no html
−
}}" and "{{#cargo_query:tables=Events
+
}}" OR ReleaseDate>="{{#cargo_query:tables=Events
−
|fields=EndDate
+
|fields=StartDate
 
|where=NOW() between StartDate and EndDate
 
|where=NOW() between StartDate and EndDate
−
|group by=EndDate
 
−
|order by=EndDate DESC
 
−
|limit=1
 
−
|more results text=
 
−
|no html
 
−
}}"
 
−
OR ReleaseDate="{{#cargo_query:tables=SummonShowcase
 
−
|fields=StartDate
 
−
|where=StartDate < NOW()
 
 
|group by=StartDate
 
|group by=StartDate
−
|order by=StartDate DESC
+
|order by=StartDate ASC
 
|limit=1
 
|limit=1
 
|more results text=
 
|more results text=
 
|no html
 
|no html
−
}}"
+
}}")
 
|q?groupBy=_pageName
 
|q?groupBy=_pageName
 
|q?orderBy=ReleaseDate DESC, Rarity DESC, BaseId DESC, Name ASC
 
|q?orderBy=ReleaseDate DESC, Rarity DESC, BaseId DESC, Name ASC

Latest revision as of 14:41, 13 April 2020

See: New Content, Upcoming Content, Unconfirmed Content, Version Changelog


Quests

Void Battles

Main article: Void Battles

Banner Top Void Battles (November 2019).png

See: Void Battles Exchange

Void Battles become available after completing Chapter 7/5-6, and rotate every day of the week at 6:00 AM UTC. They are the primary source of event materials used to craft weapons that have special abilities. Additional quests to take on and weapons to craft will be added every month.

Events

Lua error: Error: Table Events not found..

Castle Stories

Error: Table CastleStories not found.

Facilities

Lua error: Error: Table Facilities not found..

Summon Showcase

Lua error: Error: Table SummonShowcase not found..

Adventurers

Lua error: Error: Table Adventurers not found..

Mana Spirals

Lua error: Error: Table Adventurers not found..

Dragons

Lua error: Error: Table Dragons not found..

Wyrmprints

Lua error: Error: Table Wyrmprints not found..

Weapons

Lua error: Error: Table Weapons not found..

Retrieved from "https://dlwiki.cherrymint.live/index.php?title=New_Content&oldid=364149"