Quest Items: Difference between revisions
From IdleOn MMO Wiki
Kiokurashi (talk | contribs) No edit summary |
Kiokurashi (talk | contribs) 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. | 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. | |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. | |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. | |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. | 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. | |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. | |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. | |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. | 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. | |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. | |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. | |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
Name | Image | Quest | Sell Price | Source
Error: No field named "Source" found for any of the specified database tables.
|
---|
Items used outside of Quests
Name | Image | Quest | Sell Price | Source
Error: No field named "Source" found for any of the specified database tables.
|
---|
Blunderhills Tokens
Name | Image | Quest | Sell Price | Source
Error: No field named "Source" found for any of the specified database tables.
|
---|
Name | Image | Quest | Sell Price | Source
Error: No field named "Source" found for the database table "Items".
|
---|
Yum-Yum Desert Tokens
Name | Image | Quest | Sell Price | Source
Error: No field named "Source" found for any of the specified database tables.
|
---|
Name | Image | Quest | Sell Price | Source
Error: No field named "Source" found for the database table "Items".
|
---|
Frostbite Tundra Tokens
Name | Image | Quest | Sell Price | Source
Error: No field named "Source" found for any of the specified database tables.
|
---|
Name | Image | Quest | Sell Price | Source
Error: No field named "Source" found for the database table "Items".
|
---|