Template:Query spawnable modifiers: Difference between revisions

Latest revision as of 06:30, 9 October 2024

Template documentation[view] [edit] [history] [purge]

This template queries for modifiers based on {{modifier table}}. It excludes mods that can not spawn by default.

Parameters that can be specified in addition to the default {{modifier table}} parameters.

Parameter	Value	Description
tables	str	Any extra tables. This should be used instead of `q_tables` to avoid overriding the defaults from this template. By default the spawn_weights and mod_stats tables are queried and joined.
join	str	any extra joins. This should be used instead of `q_join` to avoid overriding the defaults from this template By default the spawn_weights and mod_stats tables are queried and joined.
where	str	Any extra conditions. This should be used instead of `q_where` to avoid overriding the defaults from this template.

The above documentation is transcluded from Template:Query spawnable modifiers/doc.
Editors can experiment in this template's sandbox and testcases pages.
Please add categories to the /doc subpage. Subpages of this template.

@@ Line 1: / Line 1: @@
-<includeonly>{{Modifier table
+<includeonly>{{#invoke: Modifier table|mod_table
-|q_tables=spawn_weights{{#if: {{{tables}}}|,{{{tables}}}|}}
+|q_tables = mod_spawn_weights, mod_stats{{#if: {{{tables|}}} | ,{{{tables}}} }}
-|q_join=mods._pageID=spawn_weights._pageID{{#if: {{{join}}}|,{{{join}}}|}}
+|q_join = mods._pageID=mod_spawn_weights._pageID, mods._pageID=mod_stats._pageID{{#if: {{{join|}}} | ,{{{join}}} }}
-|q_where=
+|q_where = mod_spawn_weights.value > 0
-    spawn_weights.weight > 0
+  {{#if: {{{where|}}} | AND ({{{where}}}) }}
-    {{#if: {{{where}}}| AND {{{where}}}|}}
+|q_orderBy = mods.domain ASC, mods.generation_type ASC, mods.mod_groups ASC, mods.mod_type ASC, mods.required_level ASC, mod_spawn_weights.ordinal ASC
 |stat_text=1
 |level=1
-}}</includeonly><noinclude>{{documentation}}</noinclude>
+}}</includeonly><noinclude>
+{{Documentation}}
+</noinclude>