Difference between revisions of "Template:Material"

From Dragalia Lost Wiki
Jump to navigation Jump to search
>Mornsta-gpuser
>Mornsta-gpuser
Line 66: Line 66:
 
</div>
 
</div>
  
<p style="margin:15px auto;border-bottom:1px solid;margin-bottom:15px;font-size:1.2em;font-variant-caps: small-caps;font-weight:bold">Craft Material For</p>
+
{{#ifeq:{{#cargo_query:tables=Weapons|fields=_pageName|where=CraftMaterial1="{{{Name|}}}" OR CraftMaterial2="{{{Name|}}}" OR CraftMaterial3="{{{Name|}}}" OR CraftMaterial4="{{{Name|}}}" OR CraftMaterial5="{{{Name|}}}"|group by=_pageName|default=0}}|0||<p style="margin:15px auto;border-bottom:1px solid;margin-bottom:15px;font-size:1.2em;font-variant-caps: small-caps;font-weight:bold">Craft Material For</p>
 
<div style="max-height: 600px; overflow: auto;">
 
<div style="max-height: 600px; overflow: auto;">
 
{{#cargo_query:tables=Weapons|fields=CONCAT('[[File:',BaseId,' 01 ',FormId,'.png|24px|link=',_pageName,']] [[',_pageName,']]')|where=CraftMaterial1="{{{Name|}}}" OR CraftMaterial2="{{{Name|}}}" OR CraftMaterial3="{{{Name|}}}" OR CraftMaterial4="{{{Name|}}}" OR CraftMaterial5="{{{Name|}}}"|format=ul|group by=_pageName|default=:-|order by= ElementalTypeId ASC, TypeId ASC, Rarity DESC, Id DESC, WeaponName ASC}}
 
{{#cargo_query:tables=Weapons|fields=CONCAT('[[File:',BaseId,' 01 ',FormId,'.png|24px|link=',_pageName,']] [[',_pageName,']]')|where=CraftMaterial1="{{{Name|}}}" OR CraftMaterial2="{{{Name|}}}" OR CraftMaterial3="{{{Name|}}}" OR CraftMaterial4="{{{Name|}}}" OR CraftMaterial5="{{{Name|}}}"|format=ul|group by=_pageName|default=:-|order by= ElementalTypeId ASC, TypeId ASC, Rarity DESC, Id DESC, WeaponName ASC}}
</div>
+
</div>}}
  
 
</div>
 
</div>
 
</div><!--
 
</div><!--
 
-->[[Category:Items]][[Category:Materials]]</includeonly>
 
-->[[Category:Items]][[Category:Materials]]</includeonly>

Revision as of 14:08, 22 March 2019

50px Documentation

Usage

{{Material
|Id=
|Name=
|Description=
|Rarity=
|QuestEventId=
|Category=
|SortId=
|Obtain=
|Usage=
|MoveQuest1=
|MoveQuest2=
|MoveQuest3=
|MoveQuest4=
|MoveQuest5=
|PouchRarity=
|Exp=
|MaterialType=
}}

This template defines the table "Materials". This table has not been created yet.