Quest Items: Difference between revisions
From IdleOn MMO Wiki
imported>Kiokurashi |
imported>Wekhter mNo edit summary |
||
Line 5: | Line 5: | ||
|fields=_pageName=Name, Image=Image, Quest=quest, SellPrice=sellprice, Source=source | |fields=_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 | |where=type="Quest Item" AND NOT Source LIKE "%Unobtainable%" AND NOT Quest IS NULL | ||
|format=template | |format=template | ||
|template=InfoItem/Questitemrow | |template=InfoItem/Questitemrow | ||
Line 16: | Line 16: | ||
|fields=_pageName=Name, Image=Image, Quest=quest, SellPrice=sellprice, Source=source | |fields=_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 Quest IS NULL | |where=type="Quest Item" AND NOT Source LIKE "%Unobtainable%" AND _pageName NOT LIKE "%Token%" AND Quest IS NULL | ||
|format=template | |format=template | ||
|template=InfoItem/Questitemrow | |template=InfoItem/Questitemrow | ||
Line 59: | Line 59: | ||
|} | |} | ||
{{Questitem/head|Yum-Yum Desert Token Components}} | {{Questitem/head|Yum-Yum Desert Token Components}} | ||
{{# | {{#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%";fields=Items._pageName=Name, Items.Image=Image, AnvilCraft._pageName=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%";fields=Items._pageName=Name, Items.Image=Image, AnvilCraft._pageName=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%";fields=Items._pageName=Name, Items.Image=Image, AnvilCraft._pageName=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%";fields=Items._pageName=Name, Items.Image=Image, AnvilCraft._pageName=quest, Items.SellPrice=sellprice, Items.Source=source | |||
| | |||
| | |||
|named args=yes | |named args=yes | ||
|format=template | |format=template | ||
|template=InfoItem/Questitemrow | |template=InfoItem/Questitemrow |
Revision as of 06:22, 10 November 2021
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 | Used In | 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 | Used In | Sell Price | Source
Error: No field named "Source" found for the database table "Items".
|
---|