Difference between revisions of "Materials"

From Dragalia Lost Wiki
Jump to navigation Jump to search
imported>Elaeagnifolia
>Boblers
(placeholder for event item sections)
 
(67 intermediate revisions by 3 users not shown)
Line 1: Line 1:
 +
{{See|[[Material Dropsheet]] for a crowdsourced dropsheet of where to most efficiently farm for certain materials.}}
 
__TOC__
 
__TOC__
 
==Upgrade Materials==
 
==Upgrade Materials==
−
{| class="wikitable" style="width:100%"
+
{| class="wikitable sortable" style="width:100%"
−
! Icon !! Name !! Description !! Where to Obtain !! Uses
+
! Icon !! Name !! style="width: 32%" | Description !! style="width: 25%" | Where to Obtain !! Uses !! Drop Rarity
−
{{#cargo_query:tables=Materials
+
{{#invoke:CargoQuery|main
−
|fields=Id=Id,Name=Name,_pageName=pageName,Description=Description,Obtain=Obtain,Uses=Uses
+
|q?tables=Materials
−
|where=Category LIKE "1%"
+
|q?fields=Id=Id,Name=Name,_pageName=pageName,Description=Description,Obtain=Obtain,Uses=Uses, PouchRarity=PouchRarity
−
|order by=SortId
+
|q?where=Category LIKE "1%"
−
|group by=_pageName
+
|q?orderBy=SortId
−
|format=template
+
|q?groupBy=_pageName
 +
|q?limit=999
 
|template=Material Table Row
 
|template=Material Table Row
−
|named args=yes
 
 
}}
 
}}
 
|}
 
|}
  
 
==Treasure==
 
==Treasure==
−
{{#cargo_query:tables=Materials
+
{| class="wikitable sortable" style="width:100%"
−
|fields=CONCAT('[[File:',Id,'.png]]'),Name=Name,_pageName=pageName,Description=Description,Obtain=Obtain,Uses=Uses
+
! Icon !! Name !! style="width: 32%" | Description !! style="width: 25%" | Where to Obtain !! Uses !! Drop Rarity
−
|where=Category LIKE "2%"
+
{{#invoke:CargoQuery|main
−
|order by=SortId
+
|q?tables=Materials
−
|group by=_pageName
+
|q?fields=Id=Id,Name=Name,_pageName=pageName,Description=Description,Obtain=Obtain,Uses=Uses, PouchRarity=PouchRarity
−
|format=table
+
|q?where=Category LIKE "2%"
 +
|q?orderBy=SortId
 +
|q?groupBy=_pageName
 +
|q?limit=999
 +
|template=Material Table Row
 +
}}
 +
|}
 +
 
 +
==Event Items==
 +
===Raid Event Items===
 +
{| class="wikitable sortable" style="width:100%"
 +
! Icon !! Name !! style="width: 32%" | Description !! style="width: 25%" | Where to Obtain !! Uses !! Drop Rarity
 +
{{#invoke:CargoQuery|main
 +
|q?tables=Materials
 +
|q?fields=Id=Id,Name=Name,_pageName=pageName,Description=Description,Obtain=Obtain,Uses=Uses, PouchRarity=PouchRarity
 +
|q?where=Category LIKE "%Raid%"
 +
|q?orderBy=SortId
 +
|q?groupBy=_pageName
 +
|q?limit=999
 +
|template=Material Table Row
 
}}
 
}}
 
|}
 
|}
 +
===Facility Event Items===
 +
{| class="wikitable sortable" style="width:100%"
 +
! Icon !! Name !! style="width: 32%" | Description !! style="width: 25%" | Where to Obtain !! Uses !! Drop Rarity
 +
{{#invoke:CargoQuery|main
 +
|q?tables=Materials
 +
|q?fields=Id=Id,Name=Name,_pageName=pageName,Description=Description,Obtain=Obtain,Uses=Uses, PouchRarity=PouchRarity
 +
|q?where=Category LIKE "%Facility%"
 +
|q?orderBy=SortId
 +
|q?groupBy=_pageName
 +
|q?limit=999
 +
|template=Material Table Row
 +
}}
 +
|}
 +
===Story Event Items===
 +
{| class="wikitable sortable" style="width:100%"
 +
! Icon !! Name !! style="width: 32%" | Description !! style="width: 25%" | Where to Obtain !! Uses !! Drop Rarity
 +
{{#invoke:CargoQuery|main
 +
|q?tables=Materials
 +
|q?fields=Id=Id,Name=Name,_pageName=pageName,Description=Description,Obtain=Obtain,Uses=Uses, PouchRarity=PouchRarity
 +
|q?where=Category LIKE "%Story%"
 +
|q?orderBy=SortId
 +
|q?groupBy=_pageName
 +
|q?limit=999
 +
|template=Material Table Row
 +
}}
 +
|}
 +
===Defensive Event Items===
 +
{| class="wikitable sortable" style="width:100%"
 +
! Icon !! Name !! style="width: 32%" | Description !! style="width: 25%" | Where to Obtain !! Uses !! Drop Rarity
 +
{{#invoke:CargoQuery|main
 +
|q?tables=Materials
 +
|q?fields=Id=Id,Name=Name,_pageName=pageName,Description=Description,Obtain=Obtain,Uses=Uses, PouchRarity=PouchRarity
 +
|q?where=Category LIKE "%Defensive%"
 +
|q?orderBy=SortId
 +
|q?groupBy=_pageName
 +
|q?limit=999
 +
|template=Material Table Row
 +
}}
 +
|}
 +
===Onslaught Event Items===
 +
{| class="wikitable sortable" style="width:100%"
 +
! Icon !! Name !! style="width: 32%" | Description !! style="width: 25%" | Where to Obtain !! Uses !! Drop Rarity
 +
{{#invoke:CargoQuery|main
 +
|q?tables=Materials
 +
|q?fields=Id=Id,Name=Name,_pageName=pageName,Description=Description,Obtain=Obtain,Uses=Uses, PouchRarity=PouchRarity
 +
|q?where=Category LIKE "%Onslaught%"
 +
|q?orderBy=SortId
 +
|q?groupBy=_pageName
 +
|q?limit=999
 +
|template=Material Table Row
 +
}}
 +
|}
 +
===Collab Event Items===
 +
{| class="wikitable sortable" style="width:100%"
 +
! Icon !! Name !! style="width: 32%" | Description !! style="width: 25%" | Where to Obtain !! Uses !! Drop Rarity
 +
{{#invoke:CargoQuery|main
 +
|q?tables=Materials
 +
|q?fields=Id=Id,Name=Name,_pageName=pageName,Description=Description,Obtain=Obtain,Uses=Uses, PouchRarity=PouchRarity
 +
|q?where=Category LIKE "%Collab%"
 +
|q?orderBy=SortId
 +
|q?groupBy=_pageName
 +
|q?limit=999
 +
|template=Material Table Row
 +
}}
 +
|}
 +
 +
{{Menus navbox}}

Latest revision as of 05:16, 2 July 2020

See: Material Dropsheet for a crowdsourced dropsheet of where to most efficiently farm for certain materials.

Upgrade Materials

Icon Name Description Where to Obtain Uses Drop Rarity

Lua error: Error: Table Materials not found..

Treasure

Icon Name Description Where to Obtain Uses Drop Rarity

Lua error: Error: Table Materials not found..

Event Items

Raid Event Items

Icon Name Description Where to Obtain Uses Drop Rarity

Lua error: Error: Table Materials not found..

Facility Event Items

Icon Name Description Where to Obtain Uses Drop Rarity

Lua error: Error: Table Materials not found..

Story Event Items

Icon Name Description Where to Obtain Uses Drop Rarity

Lua error: Error: Table Materials not found..

Defensive Event Items

Icon Name Description Where to Obtain Uses Drop Rarity

Lua error: Error: Table Materials not found..

Onslaught Event Items

Icon Name Description Where to Obtain Uses Drop Rarity

Lua error: Error: Table Materials not found..

Collab Event Items

Icon Name Description Where to Obtain Uses Drop Rarity

Lua error: Error: Table Materials not found..

v · d · eMenus
Home
Quests
Upgrade
Teams
Castle
Summon
Gift Box
More (green book)
Items (Consumables, Materials)  •  Player Info (Epithets, Stickers, The Royal Regimen)  •  Dragalia Life  •  Adventurer's Guide
Other
Retrieved from "https://dlwiki.cherrymint.live/index.php?title=Materials&oldid=394251"