Template:Anomaly drop list: Difference between revisions
From Tears of Themis Wiki
(Created page with "<noinclude>{{doc}}Category:Templates</noinclude><includeonly>{{#cargo_query:tables=StageDrop |fields={{#ifeq:{{{compact|}}}|false|stageName|SUBSTRING(stageName,15,5)}} |where=dropItem='{{#replace:{{{1}}}|"|"}}' AND stageName LIKE "Anomaly Level%" |format=list |order by=stageName ASC }}</includeonly>") |
(+links) |
||
Line 1: | Line 1: | ||
<noinclude>{{doc}}[[Category:Templates]]</noinclude><includeonly>{{#cargo_query:tables=StageDrop | <noinclude>{{doc}}[[Category:Templates]]</noinclude><includeonly>{{#cargo_query:tables=StageDrop | ||
|fields={{#ifeq:{{{compact|}}}|false|stageName|SUBSTRING(stageName,15,5)}} | |fields={{#ifeq:{{{compact|}}}|false|CONCAT('[[',stageName,']]'|CONCAT('[[',stageName,'|',SUBSTRING(stageName,15,5),']]')}} | ||
|where=dropItem='{{#replace:{{{1}}}|"|"}}' AND stageName LIKE "Anomaly Level%" | |where=dropItem='{{#replace:{{{1}}}|"|"}}' AND stageName LIKE "Anomaly Level%" | ||
|format=list | |format=list | ||
|order by=stageName ASC | |order by=stageName ASC | ||
}}</includeonly> | }}</includeonly> |
Revision as of 01:42, 10 December 2022
Description
Template for generating a list of anomaly drop stages from a cargo query, with compact or expanded modes.
Usage
{{Anomaly drop list|}}
Example
{{Anomaly drop list|Vyn "Entrapped"}}
Optional fields
The template defaults to compact mode. Set compact=false to expand. This can be useful for e.g. item drop page format. Additionally, set the delimiter field to change the list delimiter to something other than the default comma.
{{Anomaly drop list|Bluetooth Earpiece|compact=false|delimiter=•}}
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 'FROM `cargo__StageDrop` WHERE dropItem='Bluetooth Earpiece' AND stageName ...' at line 1
Function: CargoSQLQuery::run Query: SELECT CONCAT('',stageName,'' FROM `cargo__StageDrop` WHERE dropItem='Bluetooth Earpiece' AND stageName LIKE "Anomaly Level%" ORDER BY `stageName` LIMIT 100
The above documentation is transcluded from Template:Anomaly drop list/doc. (edit | history)