User:Kiokurashi/sandbox: Difference between revisions
From IdleOn MMO Wiki
imported>Kiokurashi No edit summary |
imported>Kiokurashi No edit summary |
||
| Line 1: | Line 1: | ||
{{#vardefine:used|{{Usedin|Bleach Logs}}}}{{#if:{{#var:used}}|{{Usedin/head}} | {{#cargo_query:tables=Items | ||
|fields=CONCAT("{{#sub:",_pageName,"|{{#pos:",_pageName,"| }}|0}}")=Name | |||
|where=type="Circle Obol" AND Source NOT LIKE "%Unobtainable%" | |||
|format=table | |||
|template=InfoItem/Obolrow | |||
|named args=yes | |||
|default= | |||
|intro= | |||
|outro= | |||
}} | |||
{{Obol/head|Circle Obols}} | |||
<!--{{#sub:{{{Name}}}|{{#pos:{{{Name}}}| }}|0}}--> | |||
</table> | |||
<!--{#vardefine:used|{{Usedin|Bleach Logs}}}}{{#if:{{#var:used}}|{{Usedin/head}} | |||
{{#var:used}} | {{#var:used}} | ||
{{!}}} | {{!}}} | ||
| Line 5: | Line 19: | ||
Used in items: | Used in items: | ||
| Line 18: | Line 31: | ||
''Queried:'' | ''Queried:'' | ||
<s>Quests, recipes, stamps (Queried & Lots)</s> | <s>Quests, recipes, stamps (Queried & Lots)</s> | ||
--> | |||
Revision as of 20:15, 28 June 2021
Error 1054: Unknown column 'Source' in 'where clause'
Function: CargoSQLQuery::run Query: SELECT CONCAT("",_pageName,"") AS `Name` FROM `mw_cargo__Items` WHERE type="Circle Obol" AND Source NOT LIKE "%Unobtainable%" ORDER BY CONCAT("",_pageName,"") LIMIT 500
| Name | Image | Type | WP | SP | Str | Agi | Wis | Luk | Def | Misc | Source |
|---|
