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) |
||
| Line 9: | Line 9: | ||
{{#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=Name, CONCAT(CostGp, ' gp') = Cost | ||
|format=ul | |format=ul | ||
| Line 19: | Line 19: | ||
{{#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=Name, CONCAT(CostGp, ' gp') = Cost | ||
|format=ul | |format=ul | ||
| Line 29: | Line 29: | ||
{{#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=Name, CONCAT(CostGp, ' gp') = Cost | ||
|format=ul | |format=ul | ||
| Line 39: | Line 39: | ||
{{#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=Name, CONCAT(CostGp, ' gp') = Cost | ||
|format=ul | |format=ul | ||
| Line 49: | Line 49: | ||
{{#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=Name, CONCAT(CostGp, ' gp') = Cost | ||
|format=ul | |format=ul | ||
| Line 59: | Line 59: | ||
{{#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=Name, CONCAT(CostGp, ' gp') = Cost | ||
|format=ul | |format=ul | ||
| Line 69: | Line 69: | ||
{{#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=Name, CONCAT(CostGp, ' gp') = Cost | ||
|format=ul | |format=ul | ||
| Line 79: | Line 79: | ||
{{#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=Name, CONCAT(CostGp, ' gp') = Cost | ||
|format=ul | |format=ul | ||
Revision as of 20:46, 9 January 2020
- Category: Category of mundane item to display
- Min: Minimum gear level to display (Optional)
- Max: Maximum gear level to display (Optional)