Difference between revisions of "Materials"

From Dragalia Lost Wiki
Jump to navigation Jump to search
>Boblers
(increasing query size limit)
>Boblers
(placeholder for event item sections)
 
Line 22: Line 22:
 
|q?fields=Id=Id,Name=Name,_pageName=pageName,Description=Description,Obtain=Obtain,Uses=Uses, PouchRarity=PouchRarity
 
|q?fields=Id=Id,Name=Name,_pageName=pageName,Description=Description,Obtain=Obtain,Uses=Uses, PouchRarity=PouchRarity
 
|q?where=Category LIKE "2%"
 
|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?orderBy=SortId
 
|q?groupBy=_pageName
 
|q?groupBy=_pageName

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