Template:Map tier table: Difference between revisions

From Path of Exile Wiki
Jump to navigation Jump to search
>OmegaK2
(fixing busted holds)
>Illviljan
m (low_tier_map etc. are not in the item tags anymore.)
Line 1: Line 1:
{| class="wikitable sortable {{{class}}}"
{{#vardefine:low_tier|
    {{#cargo_query: table=items, maps
        |join on =  items._pageName=maps._pageName
        |fields = ROUND(MIN(maps.tier))
        |where = items.class="Maps" AND maps.tier = 1 AND items.drop_enabled=true
    }} - {{#cargo_query: table=items, maps
        |join on =  items._pageName=maps._pageName
        |fields = ROUND(MAX(maps.tier))
        |where = items.class="Maps" AND maps.tier = 5 AND items.drop_enabled=true
    }}
}}{{#vardefine:low_level|
    {{#cargo_query: table=items, maps
        |join on = items._pageName=maps._pageName
        |fields = ROUND(MIN(maps.area_level))
        |where = items.class="Maps" AND maps.tier = 1 AND items.drop_enabled=true
    }} - {{#cargo_query: table=items, maps
        |join on = items._pageName=maps._pageName
        |fields = ROUND(MAX(maps.area_level))
        |where = items.class="Maps" AND maps.tier = 5 AND items.drop_enabled=true
    }}
}}{{#vardefine:mid_tier|
    {{#cargo_query: table=items, maps
        |join on = items._pageName=maps._pageName
        |fields = ROUND(MIN(maps.tier))
        |where = items.class="Maps" AND maps.tier = 6 AND items.drop_enabled=true
    }} - {{#cargo_query: table=items, maps
        |join on =  items._pageName=maps._pageName
        |fields = ROUND(MAX(maps.tier))
        |where = items.class="Maps" AND maps.tier = 10 AND items.drop_enabled=true
    }}
}}{{#vardefine:mid_level|
    {{#cargo_query: table=items, maps
        |join on =  items._pageName=maps._pageName
        |fields = ROUND(MIN(maps.area_level))
        |where = items.class="Maps" AND maps.tier = 6 AND items.drop_enabled=true
    }} - {{#cargo_query: table=items, maps
        |join on =  items._pageName=maps._pageName
        |fields = ROUND(MAX(maps.area_level))
        |where = items.class="Maps" AND maps.tier = 10 AND items.drop_enabled=true
    }}
}}{{#vardefine:top_tier|
    {{#cargo_query: table=items, maps
        |join on =  items._pageName=maps._pageName
        |fields = ROUND(MIN(maps.tier))
        |where = items.class="Maps" AND maps.tier = 11 AND items.drop_enabled=true
    }} - {{#cargo_query: table=items, maps
        |join on =  items._pageName=maps._pageName
        |fields = ROUND(MAX(maps.tier))
        |where = items.class="Maps" AND maps.tier > 11 AND items.drop_enabled=true
        |order by = maps.tier ASC
    }}
}}{{#vardefine:top_level|
    {{#cargo_query: table=items, maps
        |join on =  items._pageName=maps._pageName
        |fields = ROUND(MIN(maps.area_level))
        |where = items.class="Maps" AND maps.tier = 11 AND items.drop_enabled=true
    }} - {{#cargo_query: table=items, maps
        |join on =  items._pageName=maps._pageName
        |fields = ROUND(MAX(maps.area_level))
        |where = items.class="Maps" AND maps.tier > 11 AND items.drop_enabled=true
        |order by = maps.tier ASC
    }}
}}{| class="wikitable sortable {{{class}}}"
|-
|-
! Map tier !! Tier range !! Map level range
! Map tier !! Tier range !! Map level range
|-
|-
| Low tier maps
| Low tier maps || {{#var:low_tier}} || {{#var:low_level}}
||  
{{#cargo_query: table=items, maps
|join on =  items._pageName=maps._pageName
|fields = ROUND(MIN(maps.tier))
|where = items.class="Maps" AND items.tags__full LIKE "%low_tier_map%" AND items.drop_enabled=true
}} - {{#cargo_query: table=items, maps
|join on =  items._pageName=maps._pageName
|fields = ROUND(MAX(maps.tier))
|where = items.class="Maps" AND items.tags__full LIKE "%low_tier_map%" AND items.drop_enabled=true
}}
 
|| {{#cargo_query: table=items, maps
|join on =  items._pageName=maps._pageName
|fields = ROUND(MIN(maps.area_level))
|where = items.class="Maps" AND items.tags__full LIKE "%low_tier_map%"  AND items.drop_enabled=true
}} - {{#cargo_query: table=items, maps
|join on =  items._pageName=maps._pageName
|fields = ROUND(MAX(maps.area_level))
|where = items.class="Maps" AND items.tags__full LIKE "%low_tier_map%"  AND items.drop_enabled=true
}}
|-
|-
| Mid tier maps
| Mid tier maps || {{#var:mid_tier}} || {{#var:mid_level}}
||{{#cargo_query: table=items, maps
|join on =  items._pageName=maps._pageName
|fields = ROUND(MIN(maps.tier))
|where = items.class="Maps" AND items.tags__full LIKE "%mid_tier_map%"  AND items.drop_enabled=true
}} - {{#cargo_query: table=items, maps
|join on =  items._pageName=maps._pageName
|fields = ROUND(MAX(maps.tier))
|where = items.class="Maps" AND items.tags__full LIKE "%mid_tier_map%" AND items.drop_enabled=true
}}
 
|| {{#cargo_query: table=items, maps
|join on =  items._pageName=maps._pageName
|fields = ROUND(MIN(maps.area_level))
|where = items.class="Maps" AND items.tags__full LIKE "%mid_tier_map%" AND items.drop_enabled=true
}} - {{#cargo_query: table=items, maps
|join on =  items._pageName=maps._pageName
|fields = ROUND(MAX(maps.area_level))
|where = items.class="Maps" AND items.tags__full LIKE "%mid_tier_map%" AND items.drop_enabled=true
}}
 
|-
|-
| Top tier maps  
| Top tier maps || {{#var:top_tier}} || {{#var:top_level}}
||  
{{#cargo_query: table=items, maps
|join on =  items._pageName=maps._pageName
|fields = ROUND(MIN(maps.tier))
|where = items.class="Maps" AND items.tags__full LIKE "%top_tier_map%" AND items.drop_enabled=true
}}
- {{#cargo_query: table=items, maps
|join on =  items._pageName=maps._pageName
|fields = ROUND(MAX(maps.tier))
|where = items.class="Maps" AND items.tags__full LIKE "%top_tier_map%" AND items.drop_enabled=true
}}
 
|| {{#cargo_query: table=items, maps
|join on =  items._pageName=maps._pageName
|fields = ROUND(MIN(maps.area_level))
|where = items.class="Maps" AND items.tags__full LIKE "%top_tier_map%" AND items.drop_enabled=true
}} - {{#cargo_query: table=items, maps
|join on =  items._pageName=maps._pageName
|fields = ROUND(MAX(maps.area_level))
|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 21:03, 6 January 2019

Map tier Tier range Map level range
Low tier maps - -
Mid tier maps - -
Top tier maps - -
Template documentation[view] [edit] [history] [purge]


Creates a table that displays the map tier ranges.

The above documentation is transcluded from Template:Map tier table/doc. (edit | history)
Editors can experiment in this template's sandbox (create | mirror) and testcases (create) pages.
Please add categories to the /doc subpage. Subpages of this template.
Retrieved from "https://www.poewiki.net/index.php?title=Template:Map_tier_table&oldid=894155"