Template:Map tier table: Difference between revisions
Jump to navigation
Jump to search
>Illviljan mNo edit summary |
>OmegaK2 (fixing busted holds) |
||
| Line 8: | Line 8: | ||
|join on = items._pageName=maps._pageName | |join on = items._pageName=maps._pageName | ||
|fields = ROUND(MIN(maps.tier)) | |fields = ROUND(MIN(maps.tier)) | ||
|where = items.class="Maps" AND items. | |where = items.class="Maps" AND items.tags__full LIKE "%low_tier_map%" AND items.drop_enabled=true | ||
}} - {{#cargo_query: table=items, maps | }} - {{#cargo_query: table=items, maps | ||
|join on = items._pageName=maps._pageName | |join on = items._pageName=maps._pageName | ||
|fields = ROUND(MAX(maps.tier)) | |fields = ROUND(MAX(maps.tier)) | ||
|where = items.class="Maps" AND items. | |where = items.class="Maps" AND items.tags__full LIKE "%low_tier_map%" AND items.drop_enabled=true | ||
}} | }} | ||
| Line 18: | Line 18: | ||
|join on = items._pageName=maps._pageName | |join on = items._pageName=maps._pageName | ||
|fields = ROUND(MIN(maps.area_level)) | |fields = ROUND(MIN(maps.area_level)) | ||
|where = items.class="Maps" AND items. | |where = items.class="Maps" AND items.tags__full LIKE "%low_tier_map%" AND items.drop_enabled=true | ||
}} - {{#cargo_query: table=items, maps | }} - {{#cargo_query: table=items, maps | ||
|join on = items._pageName=maps._pageName | |join on = items._pageName=maps._pageName | ||
|fields = ROUND(MAX(maps.area_level)) | |fields = ROUND(MAX(maps.area_level)) | ||
|where = items.class="Maps" AND items. | |where = items.class="Maps" AND items.tags__full LIKE "%low_tier_map%" AND items.drop_enabled=true | ||
}} | }} | ||
|- | |- | ||
| Line 29: | Line 29: | ||
|join on = items._pageName=maps._pageName | |join on = items._pageName=maps._pageName | ||
|fields = ROUND(MIN(maps.tier)) | |fields = ROUND(MIN(maps.tier)) | ||
|where = items.class="Maps" AND items. | |where = items.class="Maps" AND items.tags__full LIKE "%mid_tier_map%" AND items.drop_enabled=true | ||
}} - {{#cargo_query: table=items, maps | }} - {{#cargo_query: table=items, maps | ||
|join on = items._pageName=maps._pageName | |join on = items._pageName=maps._pageName | ||
|fields = ROUND(MAX(maps.tier)) | |fields = ROUND(MAX(maps.tier)) | ||
|where = items.class="Maps" AND items. | |where = items.class="Maps" AND items.tags__full LIKE "%mid_tier_map%" AND items.drop_enabled=true | ||
}} | }} | ||
| Line 39: | Line 39: | ||
|join on = items._pageName=maps._pageName | |join on = items._pageName=maps._pageName | ||
|fields = ROUND(MIN(maps.area_level)) | |fields = ROUND(MIN(maps.area_level)) | ||
|where = items.class="Maps" AND items. | |where = items.class="Maps" AND items.tags__full LIKE "%mid_tier_map%" AND items.drop_enabled=true | ||
}} - {{#cargo_query: table=items, maps | }} - {{#cargo_query: table=items, maps | ||
|join on = items._pageName=maps._pageName | |join on = items._pageName=maps._pageName | ||
|fields = ROUND(MAX(maps.area_level)) | |fields = ROUND(MAX(maps.area_level)) | ||
|where = items.class="Maps" AND items. | |where = items.class="Maps" AND items.tags__full LIKE "%mid_tier_map%" AND items.drop_enabled=true | ||
}} | }} | ||
| Line 52: | Line 52: | ||
|join on = items._pageName=maps._pageName | |join on = items._pageName=maps._pageName | ||
|fields = ROUND(MIN(maps.tier)) | |fields = ROUND(MIN(maps.tier)) | ||
|where = items.class="Maps" AND items. | |where = items.class="Maps" AND items.tags__full LIKE "%top_tier_map%" AND items.drop_enabled=true | ||
}} | }} | ||
- {{#cargo_query: table=items, maps | - {{#cargo_query: table=items, maps | ||
|join on = items._pageName=maps._pageName | |join on = items._pageName=maps._pageName | ||
|fields = ROUND(MAX(maps.tier)) | |fields = ROUND(MAX(maps.tier)) | ||
|where = items.class="Maps" AND items. | |where = items.class="Maps" AND items.tags__full LIKE "%top_tier_map%" AND items.drop_enabled=true | ||
}} | }} | ||
| Line 63: | Line 63: | ||
|join on = items._pageName=maps._pageName | |join on = items._pageName=maps._pageName | ||
|fields = ROUND(MIN(maps.area_level)) | |fields = ROUND(MIN(maps.area_level)) | ||
|where = items.class="Maps" AND items. | |where = items.class="Maps" AND items.tags__full LIKE "%top_tier_map%" AND items.drop_enabled=true | ||
}} - {{#cargo_query: table=items, maps | }} - {{#cargo_query: table=items, maps | ||
|join on = items._pageName=maps._pageName | |join on = items._pageName=maps._pageName | ||
|fields = ROUND(MAX(maps.area_level)) | |fields = ROUND(MAX(maps.area_level)) | ||
|where = items.class="Maps" AND items. | |where = items.class="Maps" AND items.tags__full LIKE "%top_tier_map%" AND items.drop_enabled=true | ||
}} | }} | ||
|}<noinclude> | |}<noinclude> | ||
{{documentation}} | {{documentation}} | ||
</noinclude> | </noinclude> | ||
Revision as of 20:36, 9 June 2018
| Map tier | Tier range | Map level range |
|---|---|---|
| Low tier maps |
- |
- |
| Mid tier maps | - | - |
| Top tier maps |
- |
- |
Creates a table that displays the map tier ranges.
The above documentation is transcluded from Template:Map tier table/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.