User:Kiokurashi/sandbox: Difference between revisions
From IdleOn MMO Wiki
Kiokurashi (talk | contribs) No edit summary |
Kiokurashi (talk | contribs) No edit summary |
||
| Line 1: | Line 1: | ||
Old | <!--Old | ||
{| class='wikitable' | {| class='wikitable' | ||
! Enemies/Droptables | ! Enemies/Droptables | ||
| Line 48: | Line 48: | ||
|default= | |default= | ||
}} | }} | ||
|} | |}--> | ||
| Line 86: | Line 86: | ||
</div>--> | </div>--> | ||
https://idleon.info/wiki/Special:CargoTables <br/> | |||
{{#cargo_query: | {{#cargo_query: | ||
tables= | tables=Quests | ||
|fields= | |fields=Quests._pageName | ||
|where= | |where=Quests.QuestName NOT IN ({{#cargo_query: | ||
tables= | tables=Quests__NEXT | ||
|fields=CONCAT('"', | |fields=CONCAT('"',Quests__NEXT.QuestName,'"') | ||
|order by= | |order by=Quests__NEXT.QuestName | ||
|format:ul | |format:ul | ||
|limit=1500 | |limit=1500 | ||
| Line 99: | Line 99: | ||
|no html | |no html | ||
}}) | }}) | ||
|order by= | |order by=Quests.QuestName | ||
|format=ol | |format=ol | ||
|columns=4 | |columns=4 | ||
|limit=2000 | |limit=2000 | ||
}} | }} | ||
Revision as of 19:14, 7 September 2022
https://idleon.info/wiki/Special:CargoTables
Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '<div class="error">Error: Table Quests__NEXT not found.</div>) ORDER BY `mw_...' at line 1
Function: CargoSQLQuery::run Query: SELECT `mw_cargo__Quests`.`_pageName` AS `_pageName` FROM `mw_cargo__Quests` WHERE `mw_cargo__Quests`.`QuestName` NOT IN (<div class="error">Error: Table Quests__NEXT not found.</div>) ORDER BY `mw_cargo__Quests`.`QuestName` LIMIT 2000
