Quest Items: Difference between revisions

From IdleOn MMO Wiki
No edit summary
mNo edit summary
Line 2: Line 2:
== Items tied to a Quest ==
== Items tied to a Quest ==
{{Questitem/head|Quest Items}}
{{Questitem/head|Quest Items}}
{{#cargo_query:tables=Items
{{#cargo_query:tables=Items, SlabOrder
|fields=_pageName=Name, Image=Image, Quest=quest, SellPrice=sellprice, Source=source
|join on=Items._pageName=SlabOrder.Item
|fields=Items._pageName=Name, Image=Image, Quest=quest, SellPrice=sellprice, Source=source
|named args=yes
|named args=yes
|where=type="Quest Item" AND NOT Source LIKE "%Unobtainable%" AND NOT Quest IS NULL
|where=type="Quest Item" AND NOT Source LIKE "%Unobtainable%" AND NOT Quest IS NULL
Line 9: Line 10:
|template=InfoItem/Questitemrow
|template=InfoItem/Questitemrow
|default=
|default=
|order by=SlabOrder
|order by=SlabOrder.Number
}}
}}
|}
|}
== Items used outside of Quests ==
== Items used outside of Quests ==
{{Questitem/head|Other Quest Items}}
{{Questitem/head|Other Quest Items}}
{{#cargo_query:tables=Items
{{#cargo_query:tables=Items, SlabOrder
|fields=_pageName=Name, Image=Image, Quest=quest, SellPrice=sellprice, Source=source
|join on=Items._pageName=SlabOrder.Item
|fields=Items._pageName=Name, Image=Image, Quest=quest, SellPrice=sellprice, Source=source
|named args=yes
|named args=yes
|where=type="Quest Item" AND NOT Source LIKE "%Unobtainable%" AND _pageName NOT LIKE "%Token%" AND Quest IS NULL
|where=type="Quest Item" AND NOT Source LIKE "%Unobtainable%" AND Items._pageName NOT LIKE "%Token%" AND Quest IS NULL
|format=template
|format=template
|template=InfoItem/Questitemrow
|template=InfoItem/Questitemrow
|default=
|default=<tr><td colspan='5'>None at this time.</td></tr>
|order by=SlabOrder
|order by=SlabOrder.Number
}}
}}
|}
|}
Line 27: Line 29:
== Blunderhills Tokens ==
== Blunderhills Tokens ==
{{Questitem/head|Blunderhills Completion Tokens}}
{{Questitem/head|Blunderhills Completion Tokens}}
{{#cargo_query:tables=Items
{{#cargo_query:tables=Items, SlabOrder
|fields=_pageName=Name, Image=Image, Quest=quest, SellPrice=sellprice, Source=source
|join on=Items._pageName=SlabOrder.Item
|fields=Items._pageName=Name, Image=Image, Quest=quest, SellPrice=sellprice, Source=source
|named args=yes
|named args=yes
|where=type="Quest Item" AND _pageName LIKE "%Token%" AND _pageName LIKE "%NPC%" AND _pageName LIKE "%Blunderhills%"
|where=type="Quest Item" AND Items._pageName LIKE "%Token%" AND Items._pageName LIKE "%NPC%" AND Items._pageName LIKE "%Blunderhills%"
|format=template
|format=template
|template=InfoItem/Questitemrow
|template=InfoItem/Questitemrow
|default=
|default=
|order by=SlabOrder
|order by=SlabOrder.Number
}}
}}
|}
|}
{{Questitem/head|Blunderhills Completion Token Components}}
{{Questitem/head|Blunderhills Completion Token Components}}
{{#cargo_compound_query:
{{#cargo_compound_query:
tables=Items,AnvilCraft;join on=Items._pageName=AnvilCraft.Resource1;where=type="Quest Item" AND Items._pageName LIKE "%Token%" AND AnvilCraft._pageName LIKE "%Blunderhills NPC T%";fields=Items._pageName=Name, Items.Image=Image, AnvilCraft._pageName=quest, Items.SellPrice=sellprice, Items.Source=source
tables=Items,AnvilCraft,SlabOrder;join on=Items._pageName=SlabOrder.Item,Items._pageName=AnvilCraft.Resource1;where=type="Quest Item" AND Items._pageName LIKE "%Token%" AND AnvilCraft.Item LIKE "%Blunderhills NPC T%";fields=Items._pageName=Name, Items.Image=Image, AnvilCraft.Item=quest, Items.SellPrice=sellprice, Items.Source=source
|tables=Items,AnvilCraft;join on=Items._pageName=AnvilCraft.Resource2;where=type="Quest Item" AND Items._pageName LIKE "%Token%" AND AnvilCraft._pageName LIKE "%Blunderhills NPC T%";fields=Items._pageName=Name, Items.Image=Image, AnvilCraft._pageName=quest, Items.SellPrice=sellprice, Items.Source=source
|tables=Items,AnvilCraft,SlabOrder;join on=Items._pageName=SlabOrder.Item,Items._pageName=AnvilCraft.Resource2;where=type="Quest Item" AND Items._pageName LIKE "%Token%" AND AnvilCraft.Item LIKE "%Blunderhills NPC T%";fields=Items._pageName=Name, Items.Image=Image, AnvilCraft.Item=quest, Items.SellPrice=sellprice, Items.Source=source
|tables=Items,AnvilCraft;join on=Items._pageName=AnvilCraft.Resource3;where=type="Quest Item" AND Items._pageName LIKE "%Token%" AND AnvilCraft._pageName LIKE "%Blunderhills NPC T%";fields=Items._pageName=Name, Items.Image=Image, AnvilCraft._pageName=quest, Items.SellPrice=sellprice, Items.Source=source
|tables=Items,AnvilCraft,SlabOrder;join on=Items._pageName=SlabOrder.Item,Items._pageName=AnvilCraft.Resource3;where=type="Quest Item" AND Items._pageName LIKE "%Token%" AND AnvilCraft.Item LIKE "%Blunderhills NPC T%";fields=Items._pageName=Name, Items.Image=Image, AnvilCraft.Item=quest, Items.SellPrice=sellprice, Items.Source=source
|tables=Items,AnvilCraft;join on=Items._pageName=AnvilCraft.Resource4;where=type="Quest Item" AND Items._pageName LIKE "%Token%" AND AnvilCraft._pageName LIKE "%Blunderhills NPC T%";fields=Items._pageName=Name, Items.Image=Image, AnvilCraft._pageName=quest, Items.SellPrice=sellprice, Items.Source=source
|tables=Items,AnvilCraft,SlabOrder;join on=Items._pageName=SlabOrder.Item,Items._pageName=AnvilCraft.Resource4;where=type="Quest Item" AND Items._pageName LIKE "%Token%" AND AnvilCraft.Item LIKE "%Blunderhills NPC T%";fields=Items._pageName=Name, Items.Image=Image, AnvilCraft.Item=quest, Items.SellPrice=sellprice, Items.Source=source
|named args=yes
|named args=yes
|format=template
|format=template
|template=InfoItem/Questitemrow
|template=InfoItem/Questitemrow
|default=
|default=
|order by=SlabOrder
|order by=SlabOrder.Number
}}
}}
|}
|}
Line 53: Line 56:
== Yum-Yum Desert Tokens ==
== Yum-Yum Desert Tokens ==
{{Questitem/head|Yum-Yum Desert Completion Tokens}}
{{Questitem/head|Yum-Yum Desert Completion Tokens}}
{{#cargo_query:tables=Items
{{#cargo_query:tables=Items, SlabOrder
|fields=_pageName=Name, Image=Image, Quest=quest, SellPrice=sellprice, Source=source
|join on=Items._pageName=SlabOrder.Item
|fields=Items._pageName=Name, Image=Image, Quest=quest, SellPrice=sellprice, Source=source
|named args=yes
|named args=yes
|where=type="Quest Item" AND _pageName LIKE "%Token%" AND _pageName LIKE "%NPC%" AND _pageName LIKE "%Yumyum%"
|where=type="Quest Item" AND Items._pageName LIKE "%Token%" AND Items._pageName LIKE "%NPC%" AND Items._pageName LIKE "%Yumyum%"
|format=template
|format=template
|template=InfoItem/Questitemrow
|template=InfoItem/Questitemrow
|default=
|default=
|order by=SlabOrder
|order by=SlabOrder.Number
}}
}}
|}
|}
{{Questitem/head|Yum-Yum Desert Completion Token Components}}
{{Questitem/head|Yum-Yum Desert Completion Token Components}}
{{#cargo_compound_query:
{{#cargo_compound_query:
tables=Items,AnvilCraft;join on=Items._pageName=AnvilCraft.Resource1;where=type="Quest Item" AND Items._pageName LIKE "%Token%" AND AnvilCraft._pageName LIKE "%Yumyum Dez%";fields=Items._pageName=Name, Items.Image=Image, AnvilCraft._pageName=quest, Items.SellPrice=sellprice, Items.Source=source
tables=Items,AnvilCraft,SlabOrder;join on=Items._pageName=SlabOrder.Item,Items._pageName=AnvilCraft.Resource1;where=type="Quest Item" AND Items._pageName LIKE "%Token%" AND AnvilCraft.Item LIKE "%Yumyum Dez%";fields=Items._pageName=Name, Items.Image=Image, AnvilCraft.Item=quest, Items.SellPrice=sellprice, Items.Source=source
|tables=Items,AnvilCraft;join on=Items._pageName=AnvilCraft.Resource2;where=type="Quest Item" AND Items._pageName LIKE "%Token%" AND AnvilCraft._pageName LIKE "%Yumyum Dez%";fields=Items._pageName=Name, Items.Image=Image, AnvilCraft._pageName=quest, Items.SellPrice=sellprice, Items.Source=source
|tables=Items,AnvilCraft,SlabOrder;join on=Items._pageName=SlabOrder.Item,Items._pageName=AnvilCraft.Resource2;where=type="Quest Item" AND Items._pageName LIKE "%Token%" AND AnvilCraft.Item LIKE "%Yumyum Dez%";fields=Items._pageName=Name, Items.Image=Image, AnvilCraft.Item=quest, Items.SellPrice=sellprice, Items.Source=source
|tables=Items,AnvilCraft;join on=Items._pageName=AnvilCraft.Resource3;where=type="Quest Item" AND Items._pageName LIKE "%Token%" AND AnvilCraft._pageName LIKE "%Yumyum Dez%";fields=Items._pageName=Name, Items.Image=Image, AnvilCraft._pageName=quest, Items.SellPrice=sellprice, Items.Source=source
|tables=Items,AnvilCraft,SlabOrder;join on=Items._pageName=SlabOrder.Item,Items._pageName=AnvilCraft.Resource3;where=type="Quest Item" AND Items._pageName LIKE "%Token%" AND AnvilCraft.Item LIKE "%Yumyum Dez%";fields=Items._pageName=Name, Items.Image=Image, AnvilCraft.Item=quest, Items.SellPrice=sellprice, Items.Source=source
|tables=Items,AnvilCraft;join on=Items._pageName=AnvilCraft.Resource4;where=type="Quest Item" AND Items._pageName LIKE "%Token%" AND AnvilCraft._pageName LIKE "%Yumyum Dez%";fields=Items._pageName=Name, Items.Image=Image, AnvilCraft._pageName=quest, Items.SellPrice=sellprice, Items.Source=source
|tables=Items,AnvilCraft,SlabOrder;join on=Items._pageName=SlabOrder.Item,Items._pageName=AnvilCraft.Resource4;where=type="Quest Item" AND Items._pageName LIKE "%Token%" AND AnvilCraft.Item LIKE "%Yumyum Dez%";fields=Items._pageName=Name, Items.Image=Image, AnvilCraft.Item=quest, Items.SellPrice=sellprice, Items.Source=source
|named args=yes
|named args=yes
|format=template
|format=template
|template=InfoItem/Questitemrow
|template=InfoItem/Questitemrow
|default=
|default=
|order by=SlabOrder
|order by=SlabOrder.Number
}}
}}
|}
|}
Line 79: Line 83:
== Frostbite Tundra Tokens ==
== Frostbite Tundra Tokens ==
{{Questitem/head|Frostbite Tundra Completion Tokens}}
{{Questitem/head|Frostbite Tundra Completion Tokens}}
{{#cargo_query:tables=Items
{{#cargo_query:tables=Items, SlabOrder
|fields=_pageName=Name, Image=Image, Quest=quest, SellPrice=sellprice, Source=source
|join on=Items._pageName=SlabOrder.Item
|fields=Items._pageName=Name, Image=Image, Quest=quest, SellPrice=sellprice, Source=source
|named args=yes
|named args=yes
|where=type="Quest Item" AND _pageName LIKE "%Token%" AND _pageName LIKE "%NPC%" AND _pageName LIKE "%Tundra%"
|where=type="Quest Item" AND Items._pageName LIKE "%Token%" AND Items._pageName LIKE "%NPC%" AND Items._pageName LIKE "%Tundra%"
|format=template
|format=template
|template=InfoItem/Questitemrow
|template=InfoItem/Questitemrow
|default=
|default=
|order by=SlabOrder
|order by=SlabOrder.Number
}}
}}
|}
|}
{{Questitem/head|Frostbite Tundra Completion Token Components}}
{{Questitem/head|Frostbite Tundra Completion Token Components}}
{{#cargo_compound_query:
{{#cargo_compound_query:
tables=Items,AnvilCraft;join on=Items._pageName=AnvilCraft.Resource1;where=type="Quest Item" AND Items._pageName LIKE "%Token%" AND AnvilCraft._pageName LIKE "%FB Tundra%";fields=Items._pageName=Name, Items.Image=Image, AnvilCraft._pageName=quest, Items.SellPrice=sellprice, Items.Source=source
tables=Items,AnvilCraft,SlabOrder;join on=Items._pageName=SlabOrder.Item,Items._pageName=AnvilCraft.Resource1;where=type="Quest Item" AND Items._pageName LIKE "%Token%" AND AnvilCraft.Item LIKE "%FB Tundra%";fields=Items._pageName=Name, Items.Image=Image, AnvilCraft.Item=quest, Items.SellPrice=sellprice, Items.Source=source
|tables=Items,AnvilCraft;join on=Items._pageName=AnvilCraft.Resource2;where=type="Quest Item" AND Items._pageName LIKE "%Token%" AND AnvilCraft._pageName LIKE "%FB Tundra%";fields=Items._pageName=Name, Items.Image=Image, AnvilCraft._pageName=quest, Items.SellPrice=sellprice, Items.Source=source
|tables=Items,AnvilCraft,SlabOrder;join on=Items._pageName=SlabOrder.Item,Items._pageName=AnvilCraft.Resource2;where=type="Quest Item" AND Items._pageName LIKE "%Token%" AND AnvilCraft.Item LIKE "%FB Tundra%";fields=Items._pageName=Name, Items.Image=Image, AnvilCraft.Item=quest, Items.SellPrice=sellprice, Items.Source=source
|tables=Items,AnvilCraft;join on=Items._pageName=AnvilCraft.Resource3;where=type="Quest Item" AND Items._pageName LIKE "%Token%" AND AnvilCraft._pageName LIKE "%FB Tundra%";fields=Items._pageName=Name, Items.Image=Image, AnvilCraft._pageName=quest, Items.SellPrice=sellprice, Items.Source=source
|tables=Items,AnvilCraft,SlabOrder;join on=Items._pageName=SlabOrder.Item,Items._pageName=AnvilCraft.Resource3;where=type="Quest Item" AND Items._pageName LIKE "%Token%" AND AnvilCraft.Item LIKE "%FB Tundra%";fields=Items._pageName=Name, Items.Image=Image, AnvilCraft.Item=quest, Items.SellPrice=sellprice, Items.Source=source
|tables=Items,AnvilCraft;join on=Items._pageName=AnvilCraft.Resource4;where=type="Quest Item" AND Items._pageName LIKE "%Token%" AND AnvilCraft._pageName LIKE "%FB Tundra%";fields=Items._pageName=Name, Items.Image=Image, AnvilCraft._pageName=quest, Items.SellPrice=sellprice, Items.Source=source
|tables=Items,AnvilCraft,SlabOrder;join on=Items._pageName=SlabOrder.Item,Items._pageName=AnvilCraft.Resource4;where=type="Quest Item" AND Items._pageName LIKE "%Token%" AND AnvilCraft.Item LIKE "%FB Tundra%";fields=Items._pageName=Name, Items.Image=Image, AnvilCraft.Item=quest, Items.SellPrice=sellprice, Items.Source=source
|named args=yes
|named args=yes
|format=template
|format=template
|template=InfoItem/Questitemrow
|template=InfoItem/Questitemrow
|default=
|default=
|order by=SlabOrder
|order by=SlabOrder.Number
}}
}}
|}
|}


[[Category:Quest Items]]
[[Category:Quest Items]]

Revision as of 17:48, 2 March 2023

Items tied to a Quest

Quest Items
Name Image Quest Sell Price Source
Error: No field named "Source" found for any of the specified database tables.

Items used outside of Quests

Other Quest Items
Name Image Quest Sell Price Source
Error: No field named "Source" found for any of the specified database tables.

Blunderhills Tokens

Blunderhills Completion Tokens
Name Image Quest Sell Price Source
Error: No field named "Source" found for any of the specified database tables.
Blunderhills Completion Token Components
Name Image Quest Sell Price Source
Error: No field named "Source" found for the database table "Items".

Yum-Yum Desert Tokens

Yum-Yum Desert Completion Tokens
Name Image Quest Sell Price Source
Error: No field named "Source" found for any of the specified database tables.
Yum-Yum Desert Completion Token Components
Name Image Quest Sell Price Source
Error: No field named "Source" found for the database table "Items".

Frostbite Tundra Tokens

Frostbite Tundra Completion Tokens
Name Image Quest Sell Price Source
Error: No field named "Source" found for any of the specified database tables.
Frostbite Tundra Completion Token Components
Name Image Quest Sell Price Source
Error: No field named "Source" found for the database table "Items".