Difference between revisions of "Template:MagicItemTable Slot"
Jump to navigation
Jump to search
| Line 11: | Line 11: | ||
|where=Slot="{{{1}}}" AND Cost < "{{{2|2000}}}" | |where=Slot="{{{1}}}" AND Cost < "{{{2|2000}}}" | ||
|order by=Cost,Name | |order by=Cost,Name | ||
|fields=CONCAT( '[[', _pageName, '|', Name, ' | |fields=CONCAT( '[[', _pageName, '|', Name, ' ', IF(IsAbility==1, '(*)', ''), ']]' ) = Item,CostGp=Price,WeightLbs=Weight | ||
|format=table | |format=table | ||
|outro={{Grid|type=div}} | |outro={{Grid|type=div}} | ||
Revision as of 03:28, 30 January 2022
All lower-case
- 1: slot of magic item (armor, head, shoulders, etc)
- 2: price (first table will contain items price 0 to price, next price to 4xprice, etc), default 2000
Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '==1, '(*)', ), ']]' ) AS `Item`,`CostGp` AS `Price`,`WeightLbs` AS `Weight` F' at line 1 (localhost)
Function: CargoSQLQuery::run Query: SELECT CONCAT( '', Name, ' ', IF(IsAbility==1, '(*)', ), '' ) AS `Item`,`CostGp` AS `Price`,`WeightLbs` AS `Weight` FROM `cargo__MagicItems` WHERE Slot="Shoulders" AND Cost < "2000" ORDER BY `Cost`,`Name` LIMIT 100
| Item | Price | Weight |
|---|---|---|
| Cloak of Escape | 2,000 gp | 1 lb. |
| Feathered Cloak | 2,000 gp | 1 lb. |
| Climbing Cloak | 2,400 gp | 1 lb. |
| Guard Stole | 2,400 gp | 1 lb. |
| Cloak of Smiting | 2,450 gp | 1 lb. |
| Cloak of Smiting | 2,450 gp | 1 lb. |
| Spell-Legion’s Mantle | 2,450 gp | 1 lb. |
| Gossamer Shielding Mantle | 2,500 gp | — |
| Intimidating Cloak | 2,500 gp | 1 lb. |
| Cloak of Resistance | 4,000 gp | 1 lb. |
| Item | Price | Weight |
|---|---|---|
| Mantle of Resistance | 9,000 gp | 1 lb. |