Template:Map tier table: Difference between revisions
Jump to navigation
Jump to search
>Illviljan mNo edit summary |
No edit summary |
||
(One intermediate revision by one other user not shown) | |||
Line 7: | Line 7: | ||
|join on = items._pageName=maps._pageName | |join on = items._pageName=maps._pageName | ||
|fields = ROUND(MIN(maps.tier)) | |fields = ROUND(MIN(maps.tier)) | ||
|where = items. | |where = items.class_id="Map" AND maps.tier = 1 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=" | |where = items.class="Map" AND maps.tier = 5 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(MIN(maps.area_level)) | |fields = ROUND(MIN(maps.area_level)) | ||
|where = items. | |where = items.class_id="Map" AND maps.tier = 1 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. | |where = items.class_id="Map" AND maps.tier = 5 AND items.drop_enabled=true | ||
}} | }} | ||
|- | |- | ||
Line 27: | Line 27: | ||
|join on = items._pageName=maps._pageName | |join on = items._pageName=maps._pageName | ||
|fields = ROUND(MIN(maps.tier)) | |fields = ROUND(MIN(maps.tier)) | ||
|where = items. | |where = items.class_id="Map" AND maps.tier = 6 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. | |where = items.class_id="Map" AND maps.tier = 10 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(MIN(maps.area_level)) | |fields = ROUND(MIN(maps.area_level)) | ||
|where = items. | |where = items.class_id="Map" AND maps.tier = 6 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. | |where = items.class_id="Map" AND maps.tier = 10 AND items.drop_enabled=true | ||
}} | }} | ||
|- | |- | ||
Line 47: | Line 47: | ||
|join on = items._pageName=maps._pageName | |join on = items._pageName=maps._pageName | ||
|fields = ROUND(MIN(maps.tier)) | |fields = ROUND(MIN(maps.tier)) | ||
|where = items. | |where = items.class_id="Map" AND maps.tier = 11 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. | |where = items.class_id="Map" AND maps.tier > 11 AND items.drop_enabled=true | ||
|order by = maps.tier ASC | |order by = maps.tier ASC | ||
}} | }} | ||
Line 57: | Line 57: | ||
|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. | |where = items.class_id="Map" AND maps.tier = 11 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. | |where = items.class_id="Map" AND maps.tier > 11 AND items.drop_enabled=true | ||
|order by = maps.tier ASC | |order by = maps.tier ASC | ||
}} | }} | ||
|- | |||
| Special | |||
|| 17 | |||
|| 84 | |||
|}<noinclude> | |}<noinclude> | ||
{{documentation}} | {{documentation}} | ||
</noinclude> | </noinclude> |
Latest revision as of 23:28, 21 March 2024
Map tier | Tier range | Map level range |
---|---|---|
Low tier maps | 1 - 5 | 68 - 72 |
Mid tier maps | 6 - 10 | 73 - 77 |
Top tier maps | 11 - 17 | 78 - 84 |
Special | 17 | 84 |
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.