Template:Map tier table: Difference between revisions
Jump to navigation
Jump to search
>Illviljan m (cargo queries) |
>Illviljan mNo edit summary |
||
| Line 7: | Line 7: | ||
{{#cargo_query: table=items, maps | {{#cargo_query: table=items, maps | ||
|join on = items._pageName=maps._pageName | |join on = items._pageName=maps._pageName | ||
|fields = MIN(maps.tier) | |fields = ROUND(MIN(maps.tier)) | ||
|where = items.class="Maps" AND items.tags HOLDS "low_tier_map" AND items.drop_enabled=true | |where = items.class="Maps" AND items.tags HOLDS "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 = MAX(maps.tier) | |fields = ROUND(MAX(maps.tier)) | ||
|where = items.class="Maps" AND items.tags HOLDS "low_tier_map" AND items.drop_enabled=true | |where = items.class="Maps" AND items.tags HOLDS "low_tier_map" AND items.drop_enabled=true | ||
}} | }} | ||
| Line 17: | Line 17: | ||
|| {{#cargo_query: table=items, maps | || {{#cargo_query: table=items, maps | ||
|join on = items._pageName=maps._pageName | |join on = items._pageName=maps._pageName | ||
|fields = MIN(maps.area_level) | |fields = ROUND(MIN(maps.area_level)) | ||
|where = items.class="Maps" AND items.tags HOLDS "low_tier_map" AND items.drop_enabled=true | |where = items.class="Maps" AND items.tags HOLDS "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 = MAX(maps.area_level) | |fields = ROUND(MAX(maps.area_level)) | ||
|where = items.class="Maps" AND items.tags HOLDS "low_tier_map" AND items.drop_enabled=true | |where = items.class="Maps" AND items.tags HOLDS "low_tier_map" AND items.drop_enabled=true | ||
}} | }} | ||
| Line 29: | Line 29: | ||
||{{#cargo_query: table=items, maps | ||{{#cargo_query: table=items, maps | ||
|join on = items._pageName=maps._pageName | |join on = items._pageName=maps._pageName | ||
|fields = MIN(maps.tier) | |fields = ROUND(MIN(maps.tier)) | ||
|where = items.class="Maps" AND items.tags HOLDS "mid_tier_map" AND items.drop_enabled=true | |where = items.class="Maps" AND items.tags HOLDS "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 = MAX(maps.tier) | |fields = ROUND(MAX(maps.tier)) | ||
|where = items.class="Maps" AND items.tags HOLDS "mid_tier_map" AND items.drop_enabled=true | |where = items.class="Maps" AND items.tags HOLDS "mid_tier_map" AND items.drop_enabled=true | ||
}} | }} | ||
| Line 39: | Line 39: | ||
|| {{#cargo_query: table=items, maps | || {{#cargo_query: table=items, maps | ||
|join on = items._pageName=maps._pageName | |join on = items._pageName=maps._pageName | ||
|fields = MIN(maps.area_level) | |fields = ROUND(MIN(maps.area_level)) | ||
|where = items.class="Maps" AND items.tags HOLDS "mid_tier_map" AND items.drop_enabled=true | |where = items.class="Maps" AND items.tags HOLDS "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 = MAX(maps.area_level) | |fields = ROUND(MAX(maps.area_level)) | ||
|where = items.class="Maps" AND items.tags HOLDS "mid_tier_map" AND items.drop_enabled=true | |where = items.class="Maps" AND items.tags HOLDS "mid_tier_map" AND items.drop_enabled=true | ||
}} | }} | ||
| Line 52: | Line 52: | ||
{{#cargo_query: table=items, maps | {{#cargo_query: table=items, maps | ||
|join on = items._pageName=maps._pageName | |join on = items._pageName=maps._pageName | ||
|fields = MIN(maps.tier) | |fields = ROUND(MIN(maps.tier)) | ||
|where = items.class="Maps" AND items.tags HOLDS "top_tier_map" AND items.drop_enabled=true | |where = items.class="Maps" AND items.tags HOLDS "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 = MAX(maps.tier) | |fields = ROUND(MAX(maps.tier)) | ||
|where = items.class="Maps" AND items.tags HOLDS "top_tier_map" AND items.drop_enabled=true | |where = items.class="Maps" AND items.tags HOLDS "top_tier_map" AND items.drop_enabled=true | ||
}} | }} | ||
| Line 63: | Line 63: | ||
|| {{#cargo_query: table=items, maps | || {{#cargo_query: table=items, maps | ||
|join on = items._pageName=maps._pageName | |join on = items._pageName=maps._pageName | ||
|fields = MIN(maps.area_level) | |fields = ROUND(MIN(maps.area_level)) | ||
|where = items.class="Maps" AND items.tags HOLDS "top_tier_map" AND items.drop_enabled=true | |where = items.class="Maps" AND items.tags HOLDS "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 = MAX(maps.area_level) | |fields = ROUND(MAX(maps.area_level)) | ||
|where = items.class="Maps" AND items.tags HOLDS "top_tier_map" AND items.drop_enabled=true | |where = items.class="Maps" AND items.tags HOLDS "top_tier_map" AND items.drop_enabled=true | ||
}} | }} | ||
|} | |} | ||
Revision as of 18:38, 11 January 2018
| Map tier | Tier range | Map level range |
|---|---|---|
| Low tier maps |
- |
- |
| Mid tier maps | - | - |
| Top tier maps |
- |
- |