Difference between revisions of "Dragalia Lost Wiki/New Content"

From Dragalia Lost Wiki
Jump to navigation Jump to search
>Boblers
(ManaSpiralDate field seems to be in place now)
>Caledor92
(removing weapon scroll due to conflict with tooltip)
 
(64 intermediate revisions by 2 users not shown)
Line 1: Line 1:
 
<div style="display:flex;flex-flow:row wrap;justify-content:center">
 
<div style="display:flex;flex-flow:row wrap;justify-content:center">
 
<div style="width:100%;margin:5px;text-align:center;border:1px solid #9aa99a;">
 
<div style="width:100%;margin:5px;text-align:center;border:1px solid #9aa99a;">
<div style="margin:5px 5px 0;font-weight:bold;background-color:orange;">Summon Showcases</div>
+
<div style="margin:5px 5px 0;font-weight:bold;background-color:orange;">[[Summon Showcase]]s</div>
 
<div style="padding:10px;text-align:center">
 
<div style="padding:10px;text-align:center">
 
{{#invoke:CargoQuery|main
 
{{#invoke:CargoQuery|main
Line 19: Line 19:
 
{{#invoke:CargoQuery|main
 
{{#invoke:CargoQuery|main
 
|q?tables=Adventurers
 
|q?tables=Adventurers
|q?fields=CONCAT('Adventurer')=Type,FullName=Name
+
|q?fields=CONCAT('Adventurer')=Type,FullName=Name,Spoiler,CONCAT('1')=text
|q?where=IsPlayable=1 AND Name not like "Laxi" AND (ReleaseDate>="{{#cargo_query:tables=SummonShowcase
+
|q?where=(ReleaseDate <= NOW()) AND (ReleaseDate>="{{#cargo_query:tables=SummonShowcase
 
|fields=StartDate
 
|fields=StartDate
 
|where=NOW() between StartDate and EndDate
 
|where=NOW() between StartDate and EndDate
Line 39: Line 39:
 
|q?groupBy=_pageName
 
|q?groupBy=_pageName
 
|q?orderBy= ReleaseDate ASC, Rarity DESC, ElementalTypeId ASC, WeaponTypeId ASC, Id DESC, FullName ASC
 
|q?orderBy= ReleaseDate ASC, Rarity DESC, ElementalTypeId ASC, WeaponTypeId ASC, Id DESC, FullName ASC
|template=TooltipIcon
+
|template=SpoilerIconSelector
 
|more results text=
 
|more results text=
 
|default=''No recent adventurers.''
 
|default=''No recent adventurers.''
Line 50: Line 50:
 
|q?tables=Dragons
 
|q?tables=Dragons
 
|q?fields=CONCAT('Dragon')=Type,FullName=Name
 
|q?fields=CONCAT('Dragon')=Type,FullName=Name
|q?where=IsPlayable=1 AND (ReleaseDate>="{{#cargo_query:tables=SummonShowcase
+
|q?where=IsPlayable=1 AND (ReleaseDate <= NOW()) AND (ReleaseDate>="{{#cargo_query:tables=SummonShowcase
 
|fields=StartDate
 
|fields=StartDate
 
|where=NOW() between StartDate and EndDate
 
|where=NOW() between StartDate and EndDate
Line 80: Line 80:
 
|q?tables=Wyrmprints
 
|q?tables=Wyrmprints
 
|q?fields=CONCAT('Wyrmprint')=Type,Name=Name
 
|q?fields=CONCAT('Wyrmprint')=Type,Name=Name
|q?where=IsPlayable=1 AND (ReleaseDate>="{{#cargo_query:tables=SummonShowcase
+
|q?where=IsPlayable=1 AND (ReleaseDate <= NOW()) AND (ReleaseDate>="{{#cargo_query:tables=SummonShowcase
 
|fields=StartDate
 
|fields=StartDate
 
|where=NOW() between StartDate and EndDate
 
|where=NOW() between StartDate and EndDate
Line 106: Line 106:
  
 
<div style="width:100%;margin:5px;text-align:center;border:1px solid #9aa99a;">
 
<div style="width:100%;margin:5px;text-align:center;border:1px solid #9aa99a;">
<div style="margin:5px 5px 0;font-weight:bold;background-color:#87cc93;">New Mana Spirals</div>
+
<div style="margin:5px 5px 0;font-weight:bold;background-color:#87cc93;">New [[Mana Spiral]]s</div>
 
{{#invoke:CargoQuery|main
 
{{#invoke:CargoQuery|main
 
|q?tables=Adventurers
 
|q?tables=Adventurers
 
|q?fields=CONCAT('Adventurer')=Type,FullName=Name
 
|q?fields=CONCAT('Adventurer')=Type,FullName=Name
|q?where=IsPlayable=1 AND (ManaSpiralDate>="{{#cargo_query:tables=SummonShowcase
+
|q?where=IsPlayable=1 AND ManaSpiralDate <= NOW() AND (ManaSpiralDate>="{{#cargo_query:tables=SummonShowcase
 
|fields=StartDate
 
|fields=StartDate
 
|where=NOW() between StartDate and EndDate
 
|where=NOW() between StartDate and EndDate
Line 132: Line 132:
 
|more results text=
 
|more results text=
 
|default=''No recent mana spirals.''
 
|default=''No recent mana spirals.''
 +
}}
 +
</div>
 +
 +
<div style="width:100%;margin:5px;text-align:center;border:1px solid #9aa99a;">
 +
<div style="margin:5px 5px 0;font-weight:bold;background-color:#699dc7;">New Weapons</div>
 +
{{#invoke:CargoQuery|main
 +
|q?tables=Weapons
 +
|q?fields=CONCAT('Weapon')=Type, WeaponName=Name
 +
|q?where=(ReleaseDate <= NOW()) AND (ReleaseDate>="{{#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 ReleaseDate>="{{#cargo_query:tables=Events
 +
|fields=StartDate
 +
|where=NOW() between StartDate and EndDate
 +
|group by=StartDate
 +
|order by=StartDate ASC
 +
|limit=1
 +
|more results text=
 +
|no html
 +
}}") AND ((CraftNodeId>=301 AND CraftNodeId<=308) OR Availability="Limited" OR Availability="Agito" OR (WeaponName LIKE "Chimeratech%" AND CraftNodeId=201))
 +
|q?groupBy=_pageName
 +
|q?orderBy=Rarity DESC, ReleaseDate ASC, CraftNodeId ASC, BaseId ASC, Name ASC
 +
|template=TooltipIcon
 +
|more results text=
 +
|default=''No recent weapons.''
 
}}
 
}}
 
</div>
 
</div>
Line 138: Line 168:
 
<div style="margin:5px;text-align:center;border:1px solid #9aa99a;height: 95%">
 
<div style="margin:5px;text-align:center;border:1px solid #9aa99a;height: 95%">
 
<div style="margin:5px 5px 0;font-weight:bold;background-color:#e89090;">Latest Patch</div>
 
<div style="margin:5px 5px 0;font-weight:bold;background-color:#e89090;">Latest Patch</div>
<div class="VersionUpdate" style="padding:10px;display:inline-block;">[[File:Banner_Version_Update.png|300px|link=Version_Changelog]]</div>
+
<div class="VersionUpdate" style="padding:17px;display:inline-block;">[[File:Banner_Version_Update.png|300px|link=Version_Changelog]]</div>
 
'''Version:''' [[Version_Changelog|{{#cargo_query:tables=VersionChangelogs
 
'''Version:''' [[Version_Changelog|{{#cargo_query:tables=VersionChangelogs
 
|fields=Version,
 
|fields=Version,
Line 166: Line 196:
 
<div class="np-container-50">
 
<div class="np-container-50">
 
<div style="margin:5px;text-align:center;border:1px solid #9aa99a;height: 95%">
 
<div style="margin:5px;text-align:center;border:1px solid #9aa99a;height: 95%">
<div style="margin:5px 5px 0;font-weight:bold;background-color:#ffd800;">Latest Dragalia Life</div>
+
<div style="margin:5px 5px 0;font-weight:bold;background-color:#ffd800;">Latest [[Dragalia Life]]</div>
 
{{#invoke:CargoQuery|main
 
{{#invoke:CargoQuery|main
 
|q?tables=Comics
 
|q?tables=Comics
|q?fields=Id,Title,ReleaseDate,DirectLink
+
|q?fields=Id,Title,ReleaseDate,DirectLink,Spoiler
 
|q?orderBy=ReleaseDate DESC
 
|q?orderBy=ReleaseDate DESC
 
|q?limit=1
 
|q?limit=1
Line 175: Line 205:
 
|q?where=_pageName='Dragalia Life'
 
|q?where=_pageName='Dragalia Life'
 
|template=DragaliaLifeIssueMP
 
|template=DragaliaLifeIssueMP
 +
|default=
 +
|more results text=
 +
}}
 +
</div>
 +
</div>
 +
 +
<div class="np-container-50">
 +
<div style="margin:5px;text-align:center;border:1px solid #9aa99a;height: 95%">
 +
<div style="margin:5px 5px 0;font-weight:bold;background-color:#87cc93;">Latest [[Promotional Art]]</div>
 +
{{#invoke:CargoQuery|main
 +
|q?tables=Art
 +
|q?fields=Caption,ReleaseDate,FileName,SourceLink
 +
|q?orderBy=ReleaseDate DESC
 +
|q?limit=1
 +
|q?groupBy=
 +
|q?where=_pageName='Promotional Art'
 +
|template=ArtMP
 +
|default=
 +
|more results text=
 +
}}
 +
</div>
 +
</div>
 +
 +
<div class="np-container-50">
 +
<div style="margin:5px;text-align:center;border:1px solid #9aa99a;height: 95%">
 +
<div style="margin:5px 5px 0;font-weight:bold;background-color:#9a69c7;">Latest [[Dragalia Minis]]</div>
 +
{{#invoke:CargoQuery|main
 +
|q?tables=Comics
 +
|q?fields=Id,Title,ReleaseDate,DirectLink
 +
|q?orderBy=ReleaseDate DESC
 +
|q?limit=1
 +
|q?groupBy=
 +
|q?where=_pageName='Dragalia Minis'
 +
|template=DragaliaMinisIssueMP
 
|default=
 
|default=
 
|more results text=
 
|more results text=

Latest revision as of 19:48, 28 July 2020

Lua error: Error: Table SummonShowcase not found..

New Adventurers

Lua error: Error: Table Adventurers not found..

New Dragons

Lua error: Error: Table Dragons not found..

New Wyrmprints

Lua error: Error: Table Wyrmprints not found..

Lua error: Error: Table Adventurers not found..

New Weapons

Lua error: Error: Table Weapons not found..

Latest Patch
Banner Version Update.png
Version:
Error: Table VersionChangelogs not found.
-
Error: Table VersionChangelogs not found.

Release Date:
Error: Table VersionChangelogs not found.

Lua error: Error: Table Comics not found..

Lua error: Error: Table Art not found..

Lua error: Error: Table Comics not found..