User:BHY4A/sandbox: Difference between revisions
From IdleOn MMO Wiki
mNo edit summary |
mNo edit summary |
||
Line 8: | Line 8: | ||
|fields=_pageName=item | |fields=_pageName=item | ||
|where=Type='Monster Drop' AND Source LIKE '%Green Mushroom%' | |where=Type='Monster Drop' AND Source LIKE '%Green Mushroom%' | ||
|format=template | |||
|template=CraftReq | |||
|default= | |||
}}</div> | |||
</div> | |||
<div class="tile-halves"> | |||
<div class="tile-top-best tile-image-best">[[File:Walking Stick Idle.gif|link=]]</div> | |||
<div class="tile-bottom link-button"><h3>[[Walking Stick]]</h3></div> | |||
<div>{{#cargo_query:tables=Items | |||
|fields=_pageName=item | |||
|where=Type='Monster Drop' AND Source LIKE '%Walking Stick%' | |||
|limit=1 | |||
|format=template | |format=template | ||
|template=CraftReq | |template=CraftReq |
Revision as of 11:02, 13 December 2023
Border images waiting club
Error 1054: Unknown column 'Source' in 'where clause'
Function: CargoSQLQuery::run Query: SELECT `_pageName` AS `item` FROM `mw_cargo__Items` WHERE Type='Monster Drop' AND Source LIKE '%Green Mushroom%' ORDER BY `_pageName` LIMIT 500
Error 1054: Unknown column 'Source' in 'where clause'
Function: CargoSQLQuery::run Query: SELECT `_pageName` AS `item` FROM `mw_cargo__Items` WHERE Type='Monster Drop' AND Source LIKE '%Walking Stick%' ORDER BY `_pageName` LIMIT 1
Error 1054: Unknown column 'Source' in 'where clause'
Function: CargoSQLQuery::run Query: SELECT `_pageName` AS `item` FROM `mw_cargo__Items` WHERE Type='Monster Drop' AND Source LIKE '%King Frog%' ORDER BY `_pageName` LIMIT 500
[[File:{{{1}}} Idle.gif|link={{{1}}}]]