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

From Dragalia Lost Wiki
Jump to navigation Jump to search
>Canim44
(Please avoid directly using the CSS extension. Keep suggested changes in sandboxes and notify an Admin when they are ready to implement. The CSS extension will be disabled at some point, and the admins do not know when this will occur.)
>Caledor92
(removing weapon scroll due to conflict with tooltip)
 
(78 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
 
|q?tables=SummonShowcase
 
|q?tables=SummonShowcase
 
|q?fields=Title,StartDate,EndDate
 
|q?fields=Title,StartDate,EndDate
−
|q?orderBy=Type DESC, 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 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 38: 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 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 68: 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 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 98: 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=
 
|default=''No recent wyrmprints.''
 
|default=''No recent wyrmprints.''
 +
}}
 +
</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:#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>
Line 108: 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 136: 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 145: 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..

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