Template:Item location table: Difference between revisions

Template:Item location table (view source)

293 bytes added , 23 August

m

Only uncommon and above items

64,734

edits

@@ Line 3: / Line 3: @@
 |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
-|where=(locations.region = "{{#replace:{{{1}}}|&#39;|\'}}" OR locations.name = "{{#replace:{{{1}}}|&#39;|\'}}")
+|where=(locations.region = "{{#replace:{{{1}}}|&#39;|\'}}" OR locations.name = "{{#replace:{{{1}}}|&#39;|\'}}") 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")
 |order by=item_locations.location, item_locations.x, item_locations.y, name
 |intro={{Item location table row/header}}