Shops: Difference between revisions
From Zed Wiki
(Created page with " == Blackmarket == {{#cargo_query: |tables=ShopRestock=SR, Items=I |fields=I._pageName=Title, I.Type, SR.StoreId, SR.Codename, SR.ItemCodename, SR.Qty, SR.MaxQty, SR.RestockWait, CONCAT('https://www.zed.city/items/', SR.ItemCodename, '.png')=Image |where=I.Codename=SR.ItemCodename and SR.StoreId="store_blackmarket" |order=I._pageName |format=table |named args=yes }}") |
No edit summary |
||
| Line 3: | Line 3: | ||
{{#cargo_query: | {{#cargo_query: | ||
|tables=ShopRestock=SR, Items=I | |tables=ShopRestock=SR, Items=I | ||
|join on SR.ItemCodename = I.Codename | |||
|fields=I._pageName=Title, I.Type, SR.StoreId, SR.Codename, SR.ItemCodename, SR.Qty, SR.MaxQty, SR.RestockWait, CONCAT('https://www.zed.city/items/', SR.ItemCodename, '.png')=Image | |fields=I._pageName=Title, I.Type, SR.StoreId, SR.Codename, SR.ItemCodename, SR.Qty, SR.MaxQty, SR.RestockWait, CONCAT('https://www.zed.city/items/', SR.ItemCodename, '.png')=Image | ||
|where=I.Codename=SR.ItemCodename and SR.StoreId="store_blackmarket" | |where=I.Codename=SR.ItemCodename and SR.StoreId="store_blackmarket" | ||
Revision as of 19:29, 4 November 2025
Blackmarket
Error: join conditions must be set for tables.