Consumables: Difference between revisions

Revision as of 15:12, 6 November 2023

Time Candy
Name	Image	Type	Description	Sell Price	Source Error: No field named "Source" found for the database table "Items".

EXP Balloons
Name	Image	Type	Description	Sell Price	Source Error: No field named "Source" found for the database table "Items".

Character Consumables
Name	Image	Type	Description	Sell Price	Source Error: No field named "Source" found for the database table "Items".

Character Consumables
Name	Image	Type	Description	Sell Price	Source Error: No field named "Source" found for the database table "Items".

Account Consumables
Name	Image	Type	Description	Sell Price	Source Error: No field named "Source" found for the database table "Items".

@@ Line 31: / Line 31: @@
 |named args=yes
 |where=type IN ("Teleport", "Usable", "Reset Potion") AND NOT Items.Source LIKE "%Unobtainable%"
+|format=template
+|template=InfoItem/Miscrow
+|default=
+|order by=SlabOrder.Number
+}}
+|}
+{{Misc/head|Character Consumables}}
+{{#cargo_query:tables=Items, SlabOrder
+|join on=Items._pageName=SlabOrder.Item
+|fields=Items._pageName=Name, Items.Image=Image, Items.Type=type, Items.Description=description, Items.SellPrice=sellprice, Items.Source=source
+|named args=yes
+|where=type IN ("Teleport") AND NOT Items.Source LIKE "%Unobtainable%"
 |format=template
 |template=InfoItem/Miscrow