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

From Dragalia Lost Wiki
Jump to navigation Jump to search
>Caledor92
>Caledor92
(removing weapon scroll due to conflict with tooltip)
 
(88 intermediate revisions by 3 users not shown)
Line 1: Line 1:
<div style="min-width:150px;margin:5px;text-align:center;border:1px solid #9aa99a;">
+
<div style="display:flex;flex-flow:row wrap;justify-content:center">
<div style="margin:5px 5px 0;font-weight:bold;background-color:orange;">Summon Showcases</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: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
 
|q?tables=SummonShowcase
 
|q?tables=SummonShowcase
 
|q?fields=Title,StartDate,EndDate
 
|q?fields=Title,StartDate,EndDate
|q?orderBy=StartDate DESC, Title ASC
+
|q?orderBy=Type DESC, StartDate ASC, Title ASC
 
|q?groupBy=_pageName
 
|q?groupBy=_pageName
 
|q?where=NOW() between StartDate and EndDate OR StartDate >= NOW()  
 
|q?where=NOW() between StartDate and EndDate OR StartDate >= NOW()  
Line 14: Line 15:
 
</div>
 
</div>
 
</div>
 
</div>
<div style="min-width:150px;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 Adventurers</div>
 
<div style="margin:5px 5px 0;font-weight:bold;background-color:#87cc93;">New Adventurers</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,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
 
|group by=StartDate
 
|group by=StartDate
|order by=StartDate ASC
+
|order by=StartDate ASC,
 
|limit=
 
|limit=
 
|more results text=
 
|more results text=
Line 37: Line 38:
 
}}")
 
}}")
 
|q?groupBy=_pageName
 
|q?groupBy=_pageName
|q?orderBy= ReleaseDate DESC, 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 44: Line 45:
 
</div>
 
</div>
  
<div style="min-width:150px;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:#9a69c7;">New Dragons</div>
 
<div style="margin:5px 5px 0;font-weight:bold;background-color:#9a69c7;">New Dragons</div>
 
{{#invoke:CargoQuery|main|
 
{{#invoke:CargoQuery|main|
 
|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 67: Line 68:
 
}}")
 
}}")
 
|q?groupBy=_pageName
 
|q?groupBy=_pageName
|q?orderBy= ReleaseDate DESC, Rarity DESC, ElementalTypeId ASC, Id DESC, FullName ASC
+
|q?orderBy= ReleaseDate ASC, Rarity DESC, ElementalTypeId ASC, Id DESC, FullName ASC
 
|template=TooltipIcon
 
|template=TooltipIcon
 
|more results text=
 
|more results text=
Line 74: Line 75:
 
</div>
 
</div>
  
<div style="min-width:150px;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:#699dc7;">New Wyrmprints</div>
 
<div style="margin:5px 5px 0;font-weight:bold;background-color:#699dc7;">New Wyrmprints</div>
 
{{#invoke:CargoQuery|main
 
{{#invoke:CargoQuery|main
 
|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 97: Line 98:
 
}}")
 
}}")
 
|q?groupBy=_pageName
 
|q?groupBy=_pageName
|q?orderBy=ReleaseDate DESC, Rarity DESC, BaseId DESC, Name ASC
+
|q?orderBy=ReleaseDate ASC, Rarity DESC, BaseId DESC, Name ASC
 
|template=TooltipIcon
 
|template=TooltipIcon
 
|more results text=
 
|more results text=
Line 104: Line 105:
 
</div>
 
</div>
  
<div style="min-width:150px;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 Spiral]]s</div>
 +
{{#invoke:CargoQuery|main
 +
|q?tables=Adventurers
 +
|q?fields=CONCAT('Adventurer')=Type,FullName=Name
 +
|q?where=IsPlayable=1 AND ManaSpiralDate <= NOW() 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 ASC, Rarity DESC, ElementalTypeId ASC, WeaponTypeId ASC, Id DESC, FullName ASC
 +
|template=TooltipIcon
 +
|more results text=
 +
|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 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:#e89090;">Latest Patch</div>
 
<div style="margin:5px 5px 0;font-weight:bold;background-color:#e89090;">Latest Patch</div>
<div style="padding:10px 0;display:inline-block;">[[File:Banner_Version_Update.png|300x158px|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 129: Line 191:
 
|more results text=
 
|more results text=
 
}}
 
}}
 +
</div>
 
</div>
 
</div>
  
<div style="min-width:150px;margin:5px;text-align:center;border:1px solid #9aa99a;">
+
<div class="np-container-50">
<div style="margin:5px 5px 0;font-weight:bold;background-color:#ffd800;">Latest Dragalia Life</div>
+
<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>
 
{{#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 144: Line 208:
 
|more results text=
 
|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=
 +
|more results text=
 +
}}
 +
</div>
 +
</div>
 
</div>
 
</div>

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..