Actions

Template

Difference between revisions of "MundaneItemGmList"

From Titan's Teeth

 
(One intermediate revision by the same user not shown)
Line 4: Line 4:
 
* Max: Maximum gear level to display (Optional)
 
* Max: Maximum gear level to display (Optional)
 
</noinclude><includeonly>
 
</noinclude><includeonly>
== Items by Gear Level ==
 
 
{{#ifexpr:{{{Min|1}}} <= 1|=== 1 ===
 
{{#ifexpr:{{{Min|1}}} <= 1|=== 1 ===
 
<div style="max-width:100%;margin:10px;background-color:white;padding:.8em;border:1px solid #DDDDDD;">
 
<div style="max-width:100%;margin:10px;background-color:white;padding:.8em;border:1px solid #DDDDDD;">
Line 10: Line 9:
 
     |where=Category LIKE "%{{{Category|}}}%" AND GL = 1
 
     |where=Category LIKE "%{{{Category|}}}%" AND GL = 1
 
     |order by=CostGp
 
     |order by=CostGp
     |fields=Name, CONCAT(CostGp, ' gp') = Cost
+
     |fields=CONCAT( '[[', _pageName, '|', Name, ']]' ) = Name, CONCAT(CostGp, ' gp') = Cost
 
     |format=ul
 
     |format=ul
 
     |columns=3
 
     |columns=3
Line 20: Line 19:
 
     |where=Category LIKE "%{{{Category|}}}%" AND GL = 2
 
     |where=Category LIKE "%{{{Category|}}}%" AND GL = 2
 
     |order by=CostGp
 
     |order by=CostGp
     |fields=Name, CONCAT(CostGp, ' gp') = Cost
+
     |fields=CONCAT( '[[', _pageName, '|', Name, ']]' ) = Name, CONCAT(CostGp, ' gp') = Cost
 
     |format=ul
 
     |format=ul
 
     |columns=3
 
     |columns=3
Line 30: Line 29:
 
     |where=Category LIKE "%{{{Category|}}}%" AND GL = 3
 
     |where=Category LIKE "%{{{Category|}}}%" AND GL = 3
 
     |order by=CostGp
 
     |order by=CostGp
     |fields=Name, CONCAT(CostGp, ' gp') = Cost
+
     |fields=CONCAT( '[[', _pageName, '|', Name, ']]' ) = Name, CONCAT(CostGp, ' gp') = Cost
 
     |format=ul
 
     |format=ul
 
     |columns=3
 
     |columns=3
Line 40: Line 39:
 
     |where=Category LIKE "%{{{Category|}}}%" AND GL = 4
 
     |where=Category LIKE "%{{{Category|}}}%" AND GL = 4
 
     |order by=CostGp
 
     |order by=CostGp
     |fields=Name, CONCAT(CostGp, ' gp') = Cost
+
     |fields=CONCAT( '[[', _pageName, '|', Name, ']]' ) = Name, CONCAT(CostGp, ' gp') = Cost
 
     |format=ul
 
     |format=ul
 
     |columns=3
 
     |columns=3
Line 50: Line 49:
 
     |where=Category LIKE "%{{{Category|}}}%" AND GL = 5
 
     |where=Category LIKE "%{{{Category|}}}%" AND GL = 5
 
     |order by=CostGp
 
     |order by=CostGp
     |fields=Name, CONCAT(CostGp, ' gp') = Cost
+
     |fields=CONCAT( '[[', _pageName, '|', Name, ']]' ) = Name, CONCAT(CostGp, ' gp') = Cost
 
     |format=ul
 
     |format=ul
 
     |columns=3
 
     |columns=3
Line 60: Line 59:
 
     |where=Category LIKE "%{{{Category|}}}%" AND GL = 6
 
     |where=Category LIKE "%{{{Category|}}}%" AND GL = 6
 
     |order by=CostGp
 
     |order by=CostGp
     |fields=Name, CONCAT(CostGp, ' gp') = Cost
+
     |fields=CONCAT( '[[', _pageName, '|', Name, ']]' ) = Name, CONCAT(CostGp, ' gp') = Cost
 
     |format=ul
 
     |format=ul
 
     |columns=3
 
     |columns=3
Line 70: Line 69:
 
     |where=Category LIKE "%{{{Category|}}}%" AND GL = 7
 
     |where=Category LIKE "%{{{Category|}}}%" AND GL = 7
 
     |order by=CostGp
 
     |order by=CostGp
     |fields=Name, CONCAT(CostGp, ' gp') = Cost
+
     |fields=CONCAT( '[[', _pageName, '|', Name, ']]' ) = Name, CONCAT(CostGp, ' gp') = Cost
 
     |format=ul
 
     |format=ul
 
     |columns=3
 
     |columns=3
Line 80: Line 79:
 
     |where=Category LIKE "%{{{Category|}}}%" AND GL = 8
 
     |where=Category LIKE "%{{{Category|}}}%" AND GL = 8
 
     |order by=CostGp
 
     |order by=CostGp
     |fields=Name, CONCAT(CostGp, ' gp') = Cost
+
     |fields=CONCAT( '[[', _pageName, '|', Name, ']]' ) = Name, CONCAT(CostGp, ' gp') = Cost
 
     |format=ul
 
     |format=ul
 
     |columns=3
 
     |columns=3
 
     }}
 
     }}
 
</div>}}</includeonly>
 
</div>}}</includeonly>

Latest revision as of 20:58, 9 January 2020

  • Category: Category of mundane item to display
  • Min: Minimum gear level to display (Optional)
  • Max: Maximum gear level to display (Optional)