User:Dreddie/sandbox: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
|||
Line 1: | Line 1: | ||
==Vaal areas== | ==Vaal areas== | ||
{{#cargo_query: | {{#cargo_query: | ||
tables=areas=normal,areas=vaal,monsters=bosses | tables=areas=normal,areas=vaal,monsters=bosses,skill | ||
|join on=normal.vaal_area_ids HOLDS vaal.id,vaal.boss_monster_ids HOLDS bosses.metadata_id | |join on=normal.vaal_area_ids HOLDS vaal.id, | ||
|fields=concat('[[', | vaal.boss_monster_ids HOLDS bosses.metadata_id, | ||
group_concat('[[', | bosses.skill_ids HOLDS skill.skill_id | ||
group_concat('[[', | |fields=vaal.main_page=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 '[[',bosses.name,'|', bosses.name,']]' SEPARATOR ", ")=Boss, | |||
group_concat(distinct '*[[',skill.active_skill_name,'|', skill.active_skill_name,']]: ', skill.description SEPARATOR "\n")=Abilities | |||
|where=normal.is_vaal_area="0" | |where=normal.is_vaal_area="0" | ||
and vaal.main_page != "" | |||
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 | and skill.active_skill_name != "Default Attack" | ||
|group by=vaal.main_page | |||
|order by=vaal.main_page, normal.act, normal.area_level, normal.name, skill.active_skill_name | |||
}} | }} | ||
==Mastery queries== | ==Mastery queries== |
Revision as of 11:37, 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 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 (Act 10) | Exartze, the Woven Stone |
|
|
Cremated Archives (Act 5) | Exartze, the Woven Stone |
|
|
Desolate Track | Quetzerxi |
|
|
Disused Furnace | Curator Miem | ||
Entombed Alcove | Shrapnelbearer |
|
|
Forbidden Archives | Exartze, the Woven Stone |
|
|
Forbidden Chamber | Haviri, Vaal Metalsmith |
|
|
Forgotten Oubliette | Coniraya, Shadow of Malice |
|
|
Frozen Springs | Beheader Ataguchu |
|
|
Haunted Mineshaft | Calxipher |
|
|
Narrow Ravine | Kamaq, Soilmaker |
|
|
Neglected Cellar | Rima, Deep Temptress |
|
|
Quarantined Quarters | The Sunburst Queen |
|
|
Reclaimed Barracks | Huitepa the Blind |
|
|
Remote Gulch | Sheaq, Maker of Floods |
|
|
Restricted Gallery | Ch'aska, Maker of Rain |
|
|
Sacred Chambers | Shadow of Vengeance |
|
|
Sealed Basement | Guraq, Daylight's Blade |
|
|
Sealed Corridors | Wiraq, the Impaler |
|
|
Secluded Canal | Xuatl, Cutting Wind |
|
|
Secluded Copse | Kutec, Vaal Fleshsmith |
|
|
Secret Laboratory | Atziri's Pride |
|
|
Shifting Sands | Wiraq, the Impaler |
|
|
Stagnant Canal | Wiraqucha, Ancient Guardian |
|
|
Sunken Shingle | Perquil the Lucky |
|
|
Walled-off Ducts | Cava, Artist of Pain |
|
Mastery queries
Mastery | Effects |
---|---|
Leech Mastery |
|
Mana Mastery |
|
Recovery Mastery |
|