Template:Query atlas maps: Difference between revisions
Jump to navigation
Jump to search
>OmegaK2 (Created page with "<includeonly>{{#invoke: Item table|item_table |q_tables=versions, atlas_maps{{#if: {{{tables|}}}|,{{{tables|}}}|}} |q_join=items.release_version=versions.version, items._pageI...") |
>OmegaK2 No edit summary |
||
(4 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
<includeonly>{{#invoke: Item table|item_table | <includeonly>{{#invoke: Item table|item_table | ||
|q_tables=versions | |q_tables=versions{{#if: {{{tables|}}}|,{{{tables|}}}|}} | ||
|q_join=items.release_version=versions.version | |q_join=items.release_version=versions.version{{#if: {{{join|}}}|,{{{join|}}}|}} | ||
|q_where= | |q_where= | ||
items.rarity_id = "normal" | items.rarity_id = "normal" | ||
AND items.drop_enabled = true | AND items.drop_enabled = true | ||
AND (items.release_version IS NULL OR items.release_version IS NOT NULL AND versions.release_date < {{CURRENTTIMESTAMP}}) | AND (items.release_version IS NULL OR items.release_version IS NOT NULL AND versions.release_date < {{CURRENTTIMESTAMP}}) | ||
AND atlas_maps.region_id = "{{#cargo_query: |tables=atlas_regions|fields=id|where=name="{{region_name|{{PAGENAME}}}}}"|no html}}" | AND atlas_maps.region_id = "{{#cargo_query: |tables=atlas_regions|fields=id|where=name="{{{region_name|{{PAGENAME}}}}}"|no html}}" | ||
{{#if: {{{where|}}}|AND ({{{where|}}})|}} | {{#if: {{{where|}}}|AND ({{{where|}}})|}} | ||
|q_orderBy={{{q_orderBy|maps.tier}} | |q_orderBy={{{q_orderBy|maps.tier}}} | ||
|map_tier={{{map_tier|1}}} | |map_tier={{{map_tier|1}}} | ||
| | |atlas_tier={{{atlas_tier|1}}} | ||
|atlas_level={{{atlas_level|1}}} | |||
}}</includeonly><noinclude>{{documentation}}</noinclude> | }}</includeonly><noinclude>{{documentation}}</noinclude> |
Latest revision as of 22:52, 29 December 2019
Overview
This template queries for maps present on the atlas in a specific region.
For more information, see Template:Item table.
Parameters
Parameters that can be specified in addition to the default {{item table}}
parameters.
Parameter | Value | Description |
---|---|---|
region_name | str | Name of the atlas region. Defaults to the name of current page if not specified. |
tables | str | Any extra tables. This should be used instead of q_tables to avoid overriding the defaults from this template.
|
where | str | Any extra conditions. This should be used instead of q_where to avoid overriding the defaults from this template.
|
join | str | any extra joins. This should be used instead of q_join to avoid overriding the defaults from this template.
|
The above documentation is transcluded from Template:Query atlas maps/doc.
Editors can experiment in this template's sandbox and testcases pages.
Please add categories to the /doc subpage. Subpages of this template.
Editors can experiment in this template's sandbox and testcases pages.
Please add categories to the /doc subpage. Subpages of this template.