Difference between revisions of "MundaneItemGmList"
From Titan's Teeth
Dicemonger (talk | contribs) |
Dicemonger (talk | contribs) |
||
| Line 10: | Line 10: | ||
|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 20: | ||
|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 30: | ||
|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 40: | ||
|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 50: | ||
|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 60: | ||
|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 70: | ||
|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 80: | ||
|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> | ||
Revision as of 20:57, 9 January 2020
- Category: Category of mundane item to display
- Min: Minimum gear level to display (Optional)
- Max: Maximum gear level to display (Optional)