Ad placeholder

Template:Item location table: Difference between revisions

Jump to navigation Jump to search
Added act parameter to further separate a location
m (Only uncommon and above items)
Tag: Reverted
(Added act parameter to further separate a location)
Tag: Reverted
Line 3: Line 3:
|join on=item_locations.location=locations.name,item_locations._pageName = equipment._pageName, item_locations._pageName = weapons._pageName
|join on=item_locations.location=locations.name,item_locations._pageName = equipment._pageName, item_locations._pageName = weapons._pageName
|fields=equipment.name, equipment.rarity, equipment.icon, equipment.passives, equipment.special, weapons.name=weapons name, weapons.rarity=weapons rarity, weapons.icon=weapons icon, weapons.weapon_passives=weapons passives, weapons.passives_main_hand, weapons.passives_off_hand, weapons.special_weapon_actions, weapons.special=weapons special, item_locations._pageName=page, item_locations.description=description, item_locations.x=x, item_locations.y=y, item_locations.location, locations.region
|fields=equipment.name, equipment.rarity, equipment.icon, equipment.passives, equipment.special, weapons.name=weapons name, weapons.rarity=weapons rarity, weapons.icon=weapons icon, weapons.weapon_passives=weapons passives, weapons.passives_main_hand, weapons.passives_off_hand, weapons.special_weapon_actions, weapons.special=weapons special, item_locations._pageName=page, item_locations.description=description, item_locations.x=x, item_locations.y=y, item_locations.location, locations.region
|where=(locations.region = "{{#replace:{{{1}}}|'|\'}}" OR locations.name = "{{#replace:{{{1}}}|'|\'}}") AND (equipment.rarity="uncommon" OR equipment.rarity="rare" OR equipment.rarity="very rare" OR equipment.rarity="legendary" OR equipment.rarity="story" OR weapons.rarity="uncommon" OR weapons.rarity="rare" OR weapons.rarity="very rare" OR weapons.rarity="legendary" OR weapons.rarity="story")
|where=(locations.region = "{{#replace:{{{1}}}|'|\'}}" OR locations.name = "{{#replace:{{{1}}}|'|\'}}") {{#if: {{{act|}}} | AND locations.act = "{{#replace:{{{act}}}|'|\'}}"}}
|order by=item_locations.location, item_locations.x, item_locations.y, name
|order by=item_locations.location, item_locations.x, item_locations.y, name
|intro={{Item location table row/header}}
|intro={{Item location table row/header}}
Line 28: Line 28:
             "type": "string",
             "type": "string",
"required": true
"required": true
},
        "act": {
            "label": "act",
"description": "If needed, filter out the location by the act",
            "type": "string"
}
}
}
}
}
}
</templatedata></noinclude>
</templatedata></noinclude>

Navigation menu