User:Dreddie/sandbox: Difference between revisions
Jump to navigation
Jump to search
Line 5: | Line 5: | ||
vaal.boss_monster_ids HOLDS bosses.metadata_id, | vaal.boss_monster_ids HOLDS bosses.metadata_id, | ||
bosses.skill_ids HOLDS skill.skill_id | bosses.skill_ids HOLDS skill.skill_id | ||
|fields=vaal. | |fields=concat('[[',vaal.name,'|',vaal.name,']]')=Name, | ||
group_concat(distinct '*[[', if(normal.act < 11, concat('Act ', normal.act),'Maps'), '|', if(normal.act < 11, concat('Act ', normal.act),'Maps'), ']]: [[',normal.name,'|', normal.name,']]' SEPARATOR "\n")=Area, | group_concat(distinct '*[[', if(normal.act < 11, concat('Act ', normal.act),'Maps'), '|', if(normal.act < 11, concat('Act ', normal.act),'Maps'), ']]: [[',normal.name,'|', normal.name,']]' SEPARATOR "\n")=Area, | ||
group_concat(distinct '[[',bosses.name,'|', bosses.name,']]' SEPARATOR ", ")=Boss, | group_concat(distinct '[[',bosses.name,'|', bosses.name,']]' SEPARATOR ", ")=Boss, | ||
group_concat(distinct '*[[',skill.active_skill_name,'|', skill.active_skill_name,']]: ', skill.description SEPARATOR "\n")=Abilities | group_concat(distinct '*[[',if(skill.active_skill_name != "",skill.active_skill_name, skill.skill_id),'|', if(skill.active_skill_name != "",skill.active_skill_name, skill.skill_id),']]: ', if(skill.description != "",skill.description, "") SEPARATOR "\n")=Abilities | ||
|where=normal.is_vaal_area="0" | |where=normal.is_vaal_area="0" | ||
and vaal.is_vaal_area="1" | and vaal.is_vaal_area="1" | ||
and bosses.is_boss="1" | and bosses.is_boss="1" | ||
|group by=vaal.name | |||
|group by=vaal. | |order by=vaal.name, normal.act, normal.area_level, normal.name, skill.active_skill_name | ||
|order by=vaal. | |||
}} | }} | ||
Revision as of 12:15, 14 August 2023
Vaal areas
Name | Area | Boss | Abilities |
---|---|---|---|
Abandoned Dam | Quetzerxi |
|
|
Ancient Catacomb | Commander of Flesh |
|
|
Arcane Chambers | Beheader Ataguchu |
|
|
Blind Alley | M'gaska, the Living Pyre |
|
|
Clouded Ledge | Simi, the Nature Touched |
|
|
Clouded Ridge | Konu, Maker of Wind |
|
|
Concealed Caldarium | Cava, Artist of Pain |
|
|
Concealed Cavity | The All-seeing Eye |
|
|
Covered-up Hollow | Cintiq, the Inescapable |
|
|
Cremated Archives | Exartze, the Woven Stone |
|
|
Deathly Chambers | Harbinger of Disorder |
|
|
Desolate Isle | Wiraqucha, Ancient Guardian |
|
|
Desolate Track | Quetzerxi |
|
|
Disused Furnace | Curator Miem | ||
Dusty Bluff | Quetzerxi |
|
|
Entombed Alcove | Shrapnelbearer |
|
|
Entombed Chamber | Ossecati, Boneshaper |
|
|
Evacuated Quarter | Curator Miem | ||
Flooded Complex | M'gaska, the Living Pyre |
|
|
Forbidden Archives | Exartze, the Woven Stone |
|
|
Forbidden Chamber | Haviri, Vaal Metalsmith |
|
|
Forbidden Shrine | Shrapnelbearer |
|
|
Forgotten Conduit | Torrent of Fear |
|
|
Forgotten Gulch | Curator Miem | ||
Forgotten Oubliette | Coniraya, Shadow of Malice |
|
|
Frozen Springs | Beheader Ataguchu |
|
|
Haunted Mineshaft | Calxipher |
|
|
Hidden Patch | Thornrunner | ||
Inner Grounds | Inti of the Blood Moon |
|
|
Isolated Sound | Torrent of Fear |
|
|
Moonlit Chambers | Beheader Ataguchu |
|
|
Mystical Clearing | Simi, the Nature Touched |
|
|
Narrow Ravine | Kamaq, Soilmaker |
|
|
Neglected Cellar | Rima, Deep Temptress |
|
|
Quarantined Quarters | The Sunburst Queen |
|
|
Radiant Pools | Perquil the Lucky |
|
|
Reclaimed Barracks | Huitepa the Blind |
|
|
Remote Gulch | Sheaq, Maker of Floods |
|
|
Restricted Collection | Iorphia, Dream Eater |
|
|
Restricted Gallery | Ch'aska, Maker of Rain |
|
|
Sacred Chambers | Shadow of Vengeance |
|
|
Sealed Basement | Guraq, Daylight's Blade |
|
|
Sealed Corridors | Wiraq, the Impaler |
|
|
Sealed Repository | Inti of the Blood Moon |
|
|
Secluded Canal | Xuatl, Cutting Wind |
|
|
Secluded Copse | Kutec, Vaal Fleshsmith |
|
|
Secret Laboratory | Atziri's Pride |
|
|
Shifting Sands | Wiraq, the Impaler |
|
|
Side Chapel | Daluatti, Stoneraiser |
|
|
Stagnant Canal | Wiraqucha, Ancient Guardian |
|
|
Strange Sinkhole |
|
Mother of the Hive |
|
Suffocating Fissure | M'gaska, the Living Pyre |
|
|
Sunken Shingle | Perquil the Lucky |
|
|
Twisted Inquisitorium | Anacuacotli, Death's Worship |
|
|
Walled-off Ducts | Cava, Artist of Pain |
|
Mastery queries
Mastery | Effects |
---|---|
Leech Mastery |
|
Mana Mastery |
|
Recovery Mastery |
|