Difference between revisions of "Template:Weapon Progression Table"

From Dragalia Lost Wiki
Jump to navigation Jump to search
>Mornsta-gpuser
>Mornsta-gpuser
Line 1: Line 1:
 
{{#cargo_query:|tables=Weapons|fields=CONCAT('[[File:Icon Rarity Row ',Rarity,'.png|90px|link=]]')|where=CraftGroupId={{{craftGroupId|0}}} AND ParentCraftNodeId=0|delimiter=<br/>|order by=CraftNodeId|group by=_pageName|default=[[File:Unknown.png|90x21px|link=]]}}
 
{{#cargo_query:|tables=Weapons|fields=CONCAT('[[File:Icon Rarity Row ',Rarity,'.png|90px|link=]]')|where=CraftGroupId={{{craftGroupId|0}}} AND ParentCraftNodeId=0|delimiter=<br/>|order by=CraftNodeId|group by=_pageName|default=[[File:Unknown.png|90x21px|link=]]}}
−
{{#switch:{{{craftGroupId|0}}}
+
{{#switch:{{#cargo_query:tables=Weapons|fields=COUNT(CraftNodeId)|where=ParentCraftNodeId=101 AND CraftGroupId={{{craftGroupId|0}}}|order by=CraftGroupId,CraftNodeId|group by=CraftGroupId|default=|delimiter=|no html}}
−
|102003
+
|1={{{!}} class="wikitable lightblue" style="margin:auto" <!-- 1 level-->
−
|106003
 
−
|107302={{{!}} class="wikitable lightblue" style="margin:auto"
 
 
! style="width: 33%" {{!}} Tier 1
 
! style="width: 33%" {{!}} Tier 1
 
! style="width: 33%" {{!}} Tier 2
 
! style="width: 33%" {{!}} Tier 2
 
! style="width: 33%" {{!}} Tier 3
 
! style="width: 33%" {{!}} Tier 3
 
{{!}}-
 
{{!}}-
−
{{!}} rowspan="3" style="padding:1em;" {{!}} {{#invoke:CargoQuery|main|q?tables=Weapons|q?fields=WeaponName|q?where=CraftGroupId={{{craftGroupId|0}}} AND ParentCraftNodeId=0|template=Weapon progression entry|delimiter=<br/>|q?orderBy=CraftNodeId|q?groupBy=_pageName|default=<center>-</center>}}
+
{{!}} style="padding:1em;" {{!}} {{#invoke:CargoQuery|main|q?tables=Weapons|q?fields=WeaponName|q?where=CraftGroupId={{{craftGroupId|0}}} AND ParentCraftNodeId=0|template=Weapon progression entry|delimiter=<br/>|q?orderBy=CraftNodeId|q?groupBy=_pageName|default=<center>-</center>}}
 
{{!}} style="padding:1em;" {{!}} {{#invoke:CargoQuery|main|q?tables=Weapons|q?fields=WeaponName|template=Weapon progression entry|q?where=CraftGroupId={{{craftGroupId|0}}} AND ParentCraftNodeId=101 AND CraftNodeId=201|delimiter=<br/>|q?orderBy=CraftNodeId|q?groupBy=_pageName|default=<center>-</center>}}
 
{{!}} style="padding:1em;" {{!}} {{#invoke:CargoQuery|main|q?tables=Weapons|q?fields=WeaponName|template=Weapon progression entry|q?where=CraftGroupId={{{craftGroupId|0}}} AND ParentCraftNodeId=101 AND CraftNodeId=201|delimiter=<br/>|q?orderBy=CraftNodeId|q?groupBy=_pageName|default=<center>-</center>}}
 
{{!}} style="padding:1em;" {{!}} {{#invoke:CargoQuery|main|q?tables=Weapons|q?fields=WeaponName|template=Weapon progression entry|q?where=CraftGroupId={{{craftGroupId|0}}} AND ParentCraftNodeId=201|delimiter=<br/>|q?orderBy=CraftNodeId|q?groupBy=_pageName|default=<center>-</center>}}
 
{{!}} style="padding:1em;" {{!}} {{#invoke:CargoQuery|main|q?tables=Weapons|q?fields=WeaponName|template=Weapon progression entry|q?where=CraftGroupId={{{craftGroupId|0}}} AND ParentCraftNodeId=201|delimiter=<br/>|q?orderBy=CraftNodeId|q?groupBy=_pageName|default=<center>-</center>}}
−
{{!}}-
 
−
{{!}} style="padding:1em;" {{!}} {{#invoke:CargoQuery|main|q?tables=Weapons|q?fields=WeaponName|template=Weapon progression entry|q?where=CraftGroupId={{{craftGroupId|0}}} AND ParentCraftNodeId=101 AND CraftNodeId=202|delimiter=<br/>|q?orderBy=CraftNodeId|q?groupBy=_pageName|default=<center>-</center>}}
 
−
{{!}} style="padding:1em;" {{!}} {{#invoke:CargoQuery|main|q?tables=Weapons|q?fields=WeaponName|template=Weapon progression entry|q?where=CraftGroupId={{{craftGroupId|0}}} AND ParentCraftNodeId=202|delimiter=<br/>|q?orderBy=CraftNodeId|q?groupBy=_pageName|default=<center>-</center>}}
 
−
{{!}}-
 
−
{{!}} style="padding:1em;" {{!}} {{#invoke:CargoQuery|main|q?tables=Weapons|q?fields=WeaponName|template=Weapon progression entry|q?where=CraftGroupId={{{craftGroupId|0}}} AND ParentCraftNodeId=101 AND CraftNodeId=203|delimiter=<br/>|q?orderBy=CraftNodeId|q?groupBy=_pageName|default=<center>-</center>}}
 
−
{{!}} style="padding:1em;" {{!}} {{#invoke:CargoQuery|main|q?tables=Weapons|q?fields=WeaponName|template=Weapon progression entry|q?where=CraftGroupId={{{craftGroupId|0}}} AND ParentCraftNodeId=203|delimiter=<br/>|q?orderBy=CraftNodeId|q?groupBy=_pageName|default=<center>-</center>}}
 
 
{{!}}}
 
{{!}}}
−
|101303
+
|2={{{!}} class="wikitable lightblue" style=";margin:auto" <!-- 2 level-->
−
|101402
 
−
|102302
 
−
|102402
 
−
|103303
 
−
|103402
 
−
|104402
 
−
|104403
 
−
|105402
 
−
|107402
 
−
|108302
 
−
|108402={{{!}} class="wikitable lightblue" style="margin:auto"
 
 
! style="width: 33%" {{!}} Tier 1
 
! style="width: 33%" {{!}} Tier 1
 
! style="width: 33%" {{!}} Tier 2
 
! style="width: 33%" {{!}} Tier 2
 
! style="width: 33%" {{!}} Tier 3
 
! style="width: 33%" {{!}} Tier 3
 
{{!}}-
 
{{!}}-
−
{{!}} style="padding:1em;" {{!}} {{#invoke:CargoQuery|main|q?tables=Weapons|q?fields=WeaponName|q?where=CraftGroupId={{{craftGroupId|0}}} AND ParentCraftNodeId=0|template=Weapon progression entry|delimiter=<br/>|q?orderBy=CraftNodeId|q?groupBy=_pageName|default=<center>-</center>}}
+
{{!}} rowspan="2" {{!}} {{#invoke:CargoQuery|main|q?tables=Weapons|q?fields=WeaponName|template=Weapon progression entry|q?where=CraftGroupId={{{craftGroupId|0}}} AND ParentCraftNodeId=0|delimiter=<br/>|q?orderBy=CraftNodeId|q?groupBy=_pageName|default=<center>-</center>}}
 
{{!}} style="padding:1em;" {{!}} {{#invoke:CargoQuery|main|q?tables=Weapons|q?fields=WeaponName|template=Weapon progression entry|q?where=CraftGroupId={{{craftGroupId|0}}} AND ParentCraftNodeId=101 AND CraftNodeId=201|delimiter=<br/>|q?orderBy=CraftNodeId|q?groupBy=_pageName|default=<center>-</center>}}
 
{{!}} style="padding:1em;" {{!}} {{#invoke:CargoQuery|main|q?tables=Weapons|q?fields=WeaponName|template=Weapon progression entry|q?where=CraftGroupId={{{craftGroupId|0}}} AND ParentCraftNodeId=101 AND CraftNodeId=201|delimiter=<br/>|q?orderBy=CraftNodeId|q?groupBy=_pageName|default=<center>-</center>}}
 
{{!}} style="padding:1em;" {{!}} {{#invoke:CargoQuery|main|q?tables=Weapons|q?fields=WeaponName|template=Weapon progression entry|q?where=CraftGroupId={{{craftGroupId|0}}} AND ParentCraftNodeId=201|delimiter=<br/>|q?orderBy=CraftNodeId|q?groupBy=_pageName|default=<center>-</center>}}
 
{{!}} style="padding:1em;" {{!}} {{#invoke:CargoQuery|main|q?tables=Weapons|q?fields=WeaponName|template=Weapon progression entry|q?where=CraftGroupId={{{craftGroupId|0}}} AND ParentCraftNodeId=201|delimiter=<br/>|q?orderBy=CraftNodeId|q?groupBy=_pageName|default=<center>-</center>}}
 +
{{!}}-
 +
{{!}} style="padding:1em;" {{!}} {{#invoke:CargoQuery|main|q?tables=Weapons|q?fields=WeaponName|template=Weapon progression entry|q?where=CraftGroupId={{{craftGroupId|0}}} AND ParentCraftNodeId=101 AND CraftNodeId=202|delimiter=<br/>|q?orderBy=CraftNodeId|q?groupBy=_pageName|default=<center>-</center>}}
 +
{{!}} style="padding:1em;" {{!}} {{#invoke:CargoQuery|main|q?tables=Weapons|q?fields=WeaponName|template=Weapon progression entry|q?where=CraftGroupId={{{craftGroupId|0}}} AND ParentCraftNodeId=202|delimiter=<br/>|q?orderBy=CraftNodeId|q?groupBy=_pageName|default=<center>-</center>}}
 
{{!}}}
 
{{!}}}
−
|#default={{{!}} class="wikitable lightblue" style=";margin:auto"
+
|3={{{!}} class="wikitable lightblue" style="margin:auto"<!--3 level-->
 
! style="width: 33%" {{!}} Tier 1
 
! style="width: 33%" {{!}} Tier 1
 
! style="width: 33%" {{!}} Tier 2
 
! style="width: 33%" {{!}} Tier 2
 
! style="width: 33%" {{!}} Tier 3
 
! style="width: 33%" {{!}} Tier 3
 
{{!}}-
 
{{!}}-
−
{{!}} rowspan="2" {{!}} {{#invoke:CargoQuery|main|q?tables=Weapons|q?fields=WeaponName|template=Weapon progression entry|q?where=CraftGroupId={{{craftGroupId|0}}} AND ParentCraftNodeId=0|delimiter=<br/>|q?orderBy=CraftNodeId|q?groupBy=_pageName|default=<center>-</center>}}
+
{{!}} rowspan="3" style="padding:1em;" {{!}} {{#invoke:CargoQuery|main|q?tables=Weapons|q?fields=WeaponName|q?where=CraftGroupId={{{craftGroupId|0}}} AND ParentCraftNodeId=0|template=Weapon progression entry|delimiter=<br/>|q?orderBy=CraftNodeId|q?groupBy=_pageName|default=<center>-</center>}}
 
{{!}} style="padding:1em;" {{!}} {{#invoke:CargoQuery|main|q?tables=Weapons|q?fields=WeaponName|template=Weapon progression entry|q?where=CraftGroupId={{{craftGroupId|0}}} AND ParentCraftNodeId=101 AND CraftNodeId=201|delimiter=<br/>|q?orderBy=CraftNodeId|q?groupBy=_pageName|default=<center>-</center>}}
 
{{!}} style="padding:1em;" {{!}} {{#invoke:CargoQuery|main|q?tables=Weapons|q?fields=WeaponName|template=Weapon progression entry|q?where=CraftGroupId={{{craftGroupId|0}}} AND ParentCraftNodeId=101 AND CraftNodeId=201|delimiter=<br/>|q?orderBy=CraftNodeId|q?groupBy=_pageName|default=<center>-</center>}}
 
{{!}} style="padding:1em;" {{!}} {{#invoke:CargoQuery|main|q?tables=Weapons|q?fields=WeaponName|template=Weapon progression entry|q?where=CraftGroupId={{{craftGroupId|0}}} AND ParentCraftNodeId=201|delimiter=<br/>|q?orderBy=CraftNodeId|q?groupBy=_pageName|default=<center>-</center>}}
 
{{!}} style="padding:1em;" {{!}} {{#invoke:CargoQuery|main|q?tables=Weapons|q?fields=WeaponName|template=Weapon progression entry|q?where=CraftGroupId={{{craftGroupId|0}}} AND ParentCraftNodeId=201|delimiter=<br/>|q?orderBy=CraftNodeId|q?groupBy=_pageName|default=<center>-</center>}}
Line 49: Line 33:
 
{{!}} style="padding:1em;" {{!}} {{#invoke:CargoQuery|main|q?tables=Weapons|q?fields=WeaponName|template=Weapon progression entry|q?where=CraftGroupId={{{craftGroupId|0}}} AND ParentCraftNodeId=101 AND CraftNodeId=202|delimiter=<br/>|q?orderBy=CraftNodeId|q?groupBy=_pageName|default=<center>-</center>}}
 
{{!}} style="padding:1em;" {{!}} {{#invoke:CargoQuery|main|q?tables=Weapons|q?fields=WeaponName|template=Weapon progression entry|q?where=CraftGroupId={{{craftGroupId|0}}} AND ParentCraftNodeId=101 AND CraftNodeId=202|delimiter=<br/>|q?orderBy=CraftNodeId|q?groupBy=_pageName|default=<center>-</center>}}
 
{{!}} style="padding:1em;" {{!}} {{#invoke:CargoQuery|main|q?tables=Weapons|q?fields=WeaponName|template=Weapon progression entry|q?where=CraftGroupId={{{craftGroupId|0}}} AND ParentCraftNodeId=202|delimiter=<br/>|q?orderBy=CraftNodeId|q?groupBy=_pageName|default=<center>-</center>}}
 
{{!}} style="padding:1em;" {{!}} {{#invoke:CargoQuery|main|q?tables=Weapons|q?fields=WeaponName|template=Weapon progression entry|q?where=CraftGroupId={{{craftGroupId|0}}} AND ParentCraftNodeId=202|delimiter=<br/>|q?orderBy=CraftNodeId|q?groupBy=_pageName|default=<center>-</center>}}
 +
{{!}}-
 +
{{!}} style="padding:1em;" {{!}} {{#invoke:CargoQuery|main|q?tables=Weapons|q?fields=WeaponName|template=Weapon progression entry|q?where=CraftGroupId={{{craftGroupId|0}}} AND ParentCraftNodeId=101 AND CraftNodeId=203|delimiter=<br/>|q?orderBy=CraftNodeId|q?groupBy=_pageName|default=<center>-</center>}}
 +
{{!}} style="padding:1em;" {{!}} {{#invoke:CargoQuery|main|q?tables=Weapons|q?fields=WeaponName|template=Weapon progression entry|q?where=CraftGroupId={{{craftGroupId|0}}} AND ParentCraftNodeId=203|delimiter=<br/>|q?orderBy=CraftNodeId|q?groupBy=_pageName|default=<center>-</center>}}
 
{{!}}}
 
{{!}}}
 
}}
 
}}

Revision as of 09:28, 20 March 2019

Error: Table Weapons not found.
Retrieved from "https://dlwiki.cherrymint.live/index.php?title=Template:Weapon_Progression_Table&oldid=242685"