Upgrades: Difference between revisions

From IdleOn MMO Wiki
imported>Kiokurashi
imported>Wekhter
mNo edit summary
Line 1: Line 1:
=== Capacity Bags ===
{{Upgrade/head|Carry Bags - Logs}}
{{#cargo_query:tables=Items
|fields=_pageName=Name, Image=Image, Tier=tier, Level=level, Description=description, SellPrice=sellprice, Source=source
|named args=yes
|where=type="Carry Bag" AND Description LIKE "%Logs%" AND NOT Source LIKE "%Unobtainable%"
|format=template
|template=InfoItem/Upgraderow
|default=
|order by=sellprice ASC
}}
|}
{{Upgrade/head|Carry Bags - Food}}
{{#cargo_query:tables=Items
|fields=_pageName=Name, Image=Image, Tier=tier, Level=level, Description=description, SellPrice=sellprice, Source=source
|named args=yes
|where=type="Carry Bag" AND Description LIKE "%Food%" AND NOT Source LIKE "%Unobtainable%"
|format=template
|template=InfoItem/Upgraderow
|default=
|order by=sellprice ASC
}}
|}
{{Upgrade/head|Carry Bags - Parts}}
{{#cargo_query:tables=Items
|fields=_pageName=Name, Image=Image, Tier=tier, Level=level, Description=description, SellPrice=sellprice, Source=source
|named args=yes
|where=type="Carry Bag" AND Description LIKE "%Parts%" AND NOT Source LIKE "%Unobtainable%"
|format=template
|template=InfoItem/Upgraderow
|default=
|order by=sellprice ASC
}}
|}
{{Upgrade/head|Carry Bags - Fish}}
{{#cargo_query:tables=Items
|fields=_pageName=Name, Image=Image, Tier=tier, Level=level, Description=description, SellPrice=sellprice, Source=source
|named args=yes
|where=type="Carry Bag" AND Description LIKE "%Fish%" AND NOT Source LIKE "%Unobtainable%"
|format=template
|template=InfoItem/Upgraderow
|default=
|order by=sellprice ASC
}}
|}
{{Upgrade/head|Carry Bags - Bugs}}
{{#cargo_query:tables=Items
|fields=_pageName=Name, Image=Image, Tier=tier, Level=level, Description=description, SellPrice=sellprice, Source=source
|named args=yes
|where=type="Carry Bag" AND Description LIKE "%Bugs%" AND NOT Source LIKE "%Unobtainable%"
|format=template
|template=InfoItem/Upgraderow
|default=
|order by=sellprice ASC
}}
|}
{{Upgrade/head|Carry Bags - Bars}}
{{#cargo_query:tables=Items
|fields=_pageName=Name, Image=Image, Tier=tier, Level=level, Description=description, SellPrice=sellprice, Source=source
|named args=yes
|where=type="Carry Bag" AND Description LIKE "%Bars%" AND NOT Source LIKE "%Unobtainable%"
|format=template
|template=InfoItem/Upgraderow
|default=
|order by=sellprice ASC
}}
|}
{{Upgrade/head|Carry Bags - Critters}}
{{#cargo_query:tables=Items
|fields=_pageName=Name, Image=Image, Tier=tier, Level=level, Description=description, SellPrice=sellprice, Source=source
|named args=yes
|where=type="Carry Bag" AND Description LIKE "%Critters%" AND NOT Source LIKE "%Unobtainable%"
|format=template
|template=InfoItem/Upgraderow
|default=
|order by=sellprice ASC
}}
|}
{{Upgrade/head|Carry Bags - Souls}}
{{#cargo_query:tables=Items
|fields=_pageName=Name, Image=Image, Tier=tier, Level=level, Description=description, SellPrice=sellprice, Source=source
|named args=yes
|where=type="Carry Bag" AND Description LIKE "%Souls%" AND NOT Source LIKE "%Unobtainable%"
|format=template
|template=InfoItem/Upgraderow
|default=
|order by=sellprice ASC
}}
|}
=== Upgrade Stones ===
{{Upgrade/head|Armor Stones}}
{{Upgrade/head|Armor Stones}}
{{#cargo_query:tables=Items
{{#cargo_query:tables=Items
Line 123: Line 32:
}}
}}
|}
|}
{{Upgrade/head|Special Stones}}
{{Upgrade/head|Helmet Stones}}
{{#cargo_query:tables=Items
{{#cargo_query:tables=Items
|fields=_pageName=Name, Image=Image, Type=type, Tier=tier, Level=level, Description=description, SellPrice=sellprice, Source=source
|fields=_pageName=Name, Image=Image, Type=type, Tier=tier, Level=level, Description=description, SellPrice=sellprice, Source=source
|named args=yes
|named args=yes
|where=type="Upgrade" AND NOT Source LIKE "%Unobtainable%" AND (_pageName LIKE "%Myster%" OR _pageName LIKE "%Helmet%")
|where=type="Upgrade" AND NOT Source LIKE "%Unobtainable%" AND _pageName LIKE "%Helmet%"
|format=template
|format=template
|template=InfoItem/Upgraderow
|template=InfoItem/Upgraderow
Line 134: Line 43:
}}
}}
|}
|}
{{Upgrade/head|Premium Stones}}
{{Upgrade/head|Mystery Stones}}
{{#cargo_query:tables=Items
{{#cargo_query:tables=Items
|fields=_pageName=Name, Image=Image, Type=type, Tier=tier, Level=level, Description=description, SellPrice=sellprice, Source=source
|fields=_pageName=Name, Image=Image, Type=type, Tier=tier, Level=level, Description=description, SellPrice=sellprice, Source=source
|named args=yes
|named args=yes
|where=(type="Upgrade" AND NOT Source LIKE "%Unobtainable%" AND _pageName LIKE "%Premium%") OR (type="Usable" AND _pageName LIKE "%Premium%")
|where=type="Upgrade" AND NOT Source LIKE "%Unobtainable%" AND _pageName LIKE "%Mystery%"
|format=template
|format=template
|template=InfoItem/Upgraderow
|template=InfoItem/Upgraderow
|default=
|default=
|order by=SellPrice, Name
|order by=Name, Tier
}}
}}
|}
|}
 
==Premium Stones==
=== Inventory & Storage ===
{{Upgrade/head|Premium Stones}}
{{Upgrade/head|Inventory Bags|buyprice=yes}}
{{#cargo_query:tables=Items,VendorItems
|join on=Items._pageName=VendorItems.Item
|fields=Items._pageName=Name, Items.Image=Image, Items.Tier=tier, Items.Level=level, Items.Description=description, VendorItems.Price=sellprice, Items.Source=source
|named args=yes
|where=Items.Type="Inventory" AND NOT Items.Source LIKE "%Gem Shop%" AND NOT Items.Source LIKE "%Unobtainable%"
|format=template
|template=InfoItem/Upgraderow
|default=
|order by=InternalGameID
}}
|}
 
{{Upgrade/head|Gem Shop Inventory Bags}}
{{#cargo_query:tables=Items
{{#cargo_query:tables=Items
|fields=_pageName=Name, Image=Image, Tier=tier, Level=level, Description=description, SellPrice=sellprice, Source=source
|fields=_pageName=Name, Image=Image, Type=type, Tier=tier, Level=level, Description=description, SellPrice=sellprice, Source=source
|named args=yes
|named args=yes
|where=type="Inventory" AND Source LIKE "%Gem Shop%" AND NOT Source LIKE "%Unobtainable%"
|where=(type="Upgrade" AND NOT Source LIKE "%Unobtainable%" AND _pageName LIKE "%Premium%") OR (type="Usable" AND _pageName LIKE "%Premium%")
|format=template
|format=template
|template=InfoItem/Upgraderow
|template=InfoItem/Upgraderow
|default=
|default=
|order by=InternalGameID
|order by=SellPrice, Name
}}
|}
 
{{Upgrade/head|Storage Chests|buyprice=yes}}
{{#cargo_query:tables=Items,VendorItems
|join on=Items._pageName=VendorItems.Item
|fields=Items._pageName=Name, Items.Image=Image, Items.Tier=tier, Items.Level=level, Items.Description=description, VendorItems.Price=sellprice, Items.Source=source
|named args=yes
|where=Items.Type="Storage" AND NOT Items.Source LIKE "%Gem Shop%" AND NOT Items.Source LIKE "%Unobtainable%"
|format=template
|template=InfoItem/Upgraderow
|default=
|order by=InternalGameID
}}
|}
 
{{Upgrade/head|Gem Shop Storage Chests}}
{{#cargo_query:tables=Items
|fields=_pageName=Name, Image=Image, Tier=tier, Level=level, Description=description, SellPrice=sellprice, Source=source
|named args=yes
|where=type="Storage" AND Source LIKE "%Gem Shop%" AND NOT Source LIKE "%Unobtainable%"
|format=template
|template=InfoItem/Upgraderow
|default=
|order by=InternalGameID
}}
}}
|}
|}
 
== Other Upgrades or Expansions ==
=== Other Upgrades or Expansions ===
{{Misc/head|Anvil Expansions}}
{{Misc/head|Anvil Expansions}}
{{#cargo_query:tables=Items
{{#cargo_query:tables=Items

Revision as of 04:58, 23 March 2022

Armor Stones
Name Image Tier Description Sell Price Source
Error: No field named "Source" found for any of the specified database tables.
Weapon Stones
Name Image Tier Description Sell Price Source
Error: No field named "Source" found for any of the specified database tables.
Tool Stones
Name Image Tier Description Sell Price Source
Error: No field named "Source" found for any of the specified database tables.
Helmet Stones
Name Image Tier Description Sell Price Source
Error: No field named "Source" found for any of the specified database tables.
Mystery Stones
Name Image Tier Description Sell Price Source
Error: No field named "Source" found for any of the specified database tables.

Premium Stones

Premium Stones
Name Image Tier Description Sell Price Source
Error: No field named "Source" found for any of the specified database tables.

Other Upgrades or Expansions

Anvil Expansions
Name Image Type Description Sell Price Source
Error: No field named "Source" found for any of the specified database tables.