Difference between revisions of "MundaneItemGmList"
From Titan's Teeth
Dicemonger (talk | contribs) (Created page with "<noinclude> * Category: Category of mundane item to display * Min: Minimum gear level to display (Optional) * Max: Maximum gear level to display (Optional) </noinclude><inclu...") |
Dicemonger (talk | contribs) |
||
| (2 intermediate revisions 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> | ||
| − | |||
{{#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;"> | ||
{{#cargo_query:tables=Equipment | {{#cargo_query:tables=Equipment | ||
|where=Category LIKE "%{{{Category|}}}%" AND GL = 1 | |where=Category LIKE "%{{{Category|}}}%" AND GL = 1 | ||
| − | |order by= | + | |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 19: | Line 18: | ||
{{#cargo_query:tables=Equipment | {{#cargo_query:tables=Equipment | ||
|where=Category LIKE "%{{{Category|}}}%" AND GL = 2 | |where=Category LIKE "%{{{Category|}}}%" AND GL = 2 | ||
| − | |order by= | + | |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 29: | Line 28: | ||
{{#cargo_query:tables=Equipment | {{#cargo_query:tables=Equipment | ||
|where=Category LIKE "%{{{Category|}}}%" AND GL = 3 | |where=Category LIKE "%{{{Category|}}}%" AND GL = 3 | ||
| − | |order by= | + | |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 39: | Line 38: | ||
{{#cargo_query:tables=Equipment | {{#cargo_query:tables=Equipment | ||
|where=Category LIKE "%{{{Category|}}}%" AND GL = 4 | |where=Category LIKE "%{{{Category|}}}%" AND GL = 4 | ||
| − | |order by= | + | |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 49: | Line 48: | ||
{{#cargo_query:tables=Equipment | {{#cargo_query:tables=Equipment | ||
|where=Category LIKE "%{{{Category|}}}%" AND GL = 5 | |where=Category LIKE "%{{{Category|}}}%" AND GL = 5 | ||
| − | |order by= | + | |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 59: | Line 58: | ||
{{#cargo_query:tables=Equipment | {{#cargo_query:tables=Equipment | ||
|where=Category LIKE "%{{{Category|}}}%" AND GL = 6 | |where=Category LIKE "%{{{Category|}}}%" AND GL = 6 | ||
| − | |order by= | + | |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 69: | Line 68: | ||
{{#cargo_query:tables=Equipment | {{#cargo_query:tables=Equipment | ||
|where=Category LIKE "%{{{Category|}}}%" AND GL = 7 | |where=Category LIKE "%{{{Category|}}}%" AND GL = 7 | ||
| − | |order by= | + | |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 79: | Line 78: | ||
{{#cargo_query:tables=Equipment | {{#cargo_query:tables=Equipment | ||
|where=Category LIKE "%{{{Category|}}}%" AND GL = 8 | |where=Category LIKE "%{{{Category|}}}%" AND GL = 8 | ||
| − | |order by= | + | |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)