User:MoonOverMira: Difference between revisions
Jump to navigation
Jump to search
MoonOverMira (talk | contribs) |
MoonOverMira (talk | contribs) |
||
Line 20: | Line 20: | ||
{{#cargo_query: | {{#cargo_query: | ||
tables=areas,monsters | tables=areas,monsters,monster_types=mt | ||
|join on=areas.boss_monster_ids HOLDS monsters.metadata_id | |join on=areas.boss_monster_ids HOLDS monsters.metadata_id,monsters.monster_type_id=mt.id | ||
|fields=monsters.is_boss,monsters.metadata_id,monsters.monster_type_id,monsters.name=monster name,areas.name=area name,areas.act,areas.area_level,areas.id | |fields=monsters.is_boss,monsters.metadata_id,monsters.monster_type_id,monsters.name=monster name,areas.name=area name,areas.act,areas.area_level,areas.id=area id,mt.id | ||
|where=monsters.rarity_id="unique" AND areas.act BETWEEN 1 AND 10 AND areas.id LIKE '1_%' AND areas.is_vaal_area=0 | |where=monsters.rarity_id="unique" AND areas.act BETWEEN 1 AND 10 AND areas.id LIKE '1_%' AND areas.is_vaal_area=0 | ||
|order by=areas.act, areas.area_level, areas.id | |order by=areas.act, areas.area_level, areas.id | ||
|limit=10 | |limit=10 | ||
}} | }} |
Revision as of 06:29, 3 March 2023
Character class attributes
Cargo queries like this one could be helpful for sections like Attribute#Base Attributes and Strength#Base Strength.
Class | Strength | Dexterity | Intelligence |
---|---|---|---|
Marauder | 32 | 14 | 14 |
Duelist | 23 | 23 | 14 |
Templar | 23 | 14 | 23 |
Scion | 20 | 20 | 20 |
Ranger | 14 | 32 | 14 |
Shadow | 14 | 23 | 23 |
Witch | 14 | 14 | 32 |
List of unique monsters
Some draft work for Cargo-izing List of unique monsters
Works
is boss | metadata id | monster type id | monster name | area name | act | area level | area id | id |
---|---|---|---|---|---|---|---|---|
Yes | Metadata/Monsters/ZombieBoss/ZombieBossHillockNormal | ZombieBossNormal | Hillock | The Twilight Strand | 1 | 1 | 1_1_1 | ZombieBossNormal |
Yes | Metadata/Monsters/Cannibal/CannibalFemaleBossWitch | CannibalBossFireFury | Fire Fury | The Coast | 1 | 2 | 1_1_2 | CannibalBossFireFury |
Yes | Metadata/Monsters/Cannibal/CannibalMaleBossHailrake | CannibalBossHailrake | Hailrake | The Tidal Island | 1 | 3 | 1_1_2a | CannibalBossHailrake |
Yes | Metadata/Monsters/Rhoas/RhoaBoss | BigRhoaBoss | Oozeback Bloom | The Mud Flats | 1 | 4 | 1_1_3 | BigRhoaBoss |
Yes | Metadata/Monsters/Necromancer/NecromancerBossFetidPool | NecromancerKadavrus | Kadavrus the Defiler | The Fetid Pool | 1 | 5 | 1_1_3a | NecromancerKadavrus |
Yes | Metadata/Monsters/ShieldCrabs/ShieldCrabBossSlowAura | ShieldCrabBoss | The Dweller of the Deep | The Flooded Depths | 1 | 6 | 1_1_4_0 | ShieldCrabBoss |
Yes | Metadata/Monsters/Totems/TotemBossSpark | MonsterTotemBossKuduku | Kuduku, the False God | The Ledge | 1 | 6 | 1_1_5 | MonsterTotemBossKuduku |
Yes | Metadata/Monsters/Goatman/GoatmanLeapSlamNavaliBoss | GoatmanBossNavali | The Faun | The Climb | 1 | 7 | 1_1_6 | GoatmanBossNavali |
Yes | Metadata/Monsters/Skeletons/SkeletonBossPrisonMelee | SkeletonBoss | Chatters | The Lower Prison | 1 | 8 | 1_1_7_1 | SkeletonBoss |
Yes | Metadata/Monsters/Necromancer/NecromancerBossPrison | NecromancerSawbones | Sawbones | The Upper Prison | 1 | 9 | 1_1_7_2 | NecromancerSawbones |