Template:Map tier table: Difference between revisions

From Path of Exile Wiki
Jump to navigation Jump to search
>Illviljan
mNo edit summary
No edit summary
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.class="Maps" AND maps.tier = 1 AND items.drop_enabled=true
         |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="Maps" AND maps.tier = 5 AND items.drop_enabled=true
         |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.class="Maps" AND maps.tier = 1 AND items.drop_enabled=true
         |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.class="Maps" AND maps.tier = 5 AND items.drop_enabled=true
         |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.class="Maps" AND maps.tier = 6 AND items.drop_enabled=true
         |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.class="Maps" AND maps.tier = 10 AND items.drop_enabled=true
         |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.class="Maps" AND maps.tier = 6 AND items.drop_enabled=true
         |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.class="Maps" AND maps.tier = 10 AND items.drop_enabled=true
         |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.class="Maps" AND maps.tier = 11 AND items.drop_enabled=true
         |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.class="Maps" AND maps.tier > 11 AND items.drop_enabled=true
         |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.class="Maps" AND maps.tier = 11 AND items.drop_enabled=true
         |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.class="Maps" AND maps.tier > 11 AND items.drop_enabled=true
         |where = items.class_id="Map" AND maps.tier > 11 AND items.drop_enabled=true
         |order by = maps.tier ASC
         |order by = maps.tier ASC
     }}  
     }}  

Revision as of 02:31, 2 October 2022

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
Template documentation[view] [edit] [history] [purge]


Creates a table that displays the map tier ranges.