Template:Query atlas maps/testcases: Difference between revisions
Jump to navigation
Jump to search
KickahaOta (talk | contribs) (Template seems to be broken; creating test cases) |
KickahaOta (talk | contribs) (Trying a subst) |
||
| Line 14: | Line 14: | ||
{{Query atlas maps/sandbox | {{Query atlas maps/sandbox | ||
|region=Valdo's Rest | |region=Valdo's Rest | ||
}} | |||
===Subst (sandbox)=== | |||
{{#invoke: Item table|item_table | |||
|q_tables=versions{{#if: |,|}} | |||
|q_join=items.release_version=versions.version{{#if: |,|}} | |||
|q_where= | |||
items.rarity_id = "normal" | |||
AND items.drop_enabled = true | |||
AND (items.release_version IS NULL OR items.release_version IS NOT NULL AND versions.release_date < {{CURRENTTIMESTAMP}}) | |||
AND atlas_maps.region_id = "{{#cargo_query: |tables=atlas_regions|fields=id|where=name="{{PAGENAME}}"|no html}}" | |||
{{#if: |AND ()|}} | |||
|q_orderBy=maps.tier | |||
|map_tier=1 | |||
|atlas_tier=1 | |||
|atlas_level=1 | |||
}} | }} | ||
Revision as of 02:39, 29 November 2021
Basic test
Query
{{Query atlas maps
|region=Valdo's Rest
}}>
Result (live)
| Item | Map Tier | Atlas map tier based on region | Atlas map level based on region | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
Result (sandbox)
| Item | Map Tier | Atlas map tier based on region | Atlas map level based on region | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
Subst (sandbox)
| Item | Map Tier | Atlas map tier based on region | Atlas map level based on region | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|