User:MoonOverMira: Difference between revisions
Jump to navigation
Jump to search
MoonOverMira (talk | contribs) |
MoonOverMira (talk | contribs) |
||
| Line 18: | Line 18: | ||
===Works=== | ===Works=== | ||
{{#cargo_query: | {{#cargo_query: | ||
tables=monsters | tables=areas,monsters | ||
|join on=areas. | |join on=areas.boss_monster_ids HOLDS monsters.metadata_id | ||
|fields=monsters.is_boss,monsters.metadata_id,monsters.monster_type_id,monsters.name, | |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 | ||
|where=monsters.rarity_id="unique" | |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 | |||
|limit=10 | |limit=10 | ||
}} | }} | ||
Revision as of 06:21, 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 | id |
|---|---|---|---|---|---|---|---|
| Yes | Metadata/Monsters/ZombieBoss/ZombieBossHillockNormal | ZombieBossNormal | Hillock | The Twilight Strand | 1 | 1 | 1_1_1 |
| Yes | Metadata/Monsters/Cannibal/CannibalFemaleBossWitch | CannibalBossFireFury | Fire Fury | The Coast | 1 | 2 | 1_1_2 |
| Yes | Metadata/Monsters/Cannibal/CannibalMaleBossHailrake | CannibalBossHailrake | Hailrake | The Tidal Island | 1 | 3 | 1_1_2a |
| Yes | Metadata/Monsters/Rhoas/RhoaBoss | BigRhoaBoss | Oozeback Bloom | The Mud Flats | 1 | 4 | 1_1_3 |
| Yes | Metadata/Monsters/Necromancer/NecromancerBossFetidPool | NecromancerKadavrus | Kadavrus the Defiler | The Fetid Pool | 1 | 5 | 1_1_3a |
| Yes | Metadata/Monsters/ShieldCrabs/ShieldCrabBossSlowAura | ShieldCrabBoss | The Dweller of the Deep | The Flooded Depths | 1 | 6 | 1_1_4_0 |
| Yes | Metadata/Monsters/Totems/TotemBossSpark | MonsterTotemBossKuduku | Kuduku, the False God | The Ledge | 1 | 6 | 1_1_5 |
| Yes | Metadata/Monsters/Goatman/GoatmanLeapSlamNavaliBoss | GoatmanBossNavali | The Faun | The Climb | 1 | 7 | 1_1_6 |
| Yes | Metadata/Monsters/Skeletons/SkeletonBossPrisonMelee | SkeletonBoss | Chatters | The Lower Prison | 1 | 8 | 1_1_7_1 |
| Yes | Metadata/Monsters/Necromancer/NecromancerBossPrison | NecromancerSawbones | Sawbones | The Upper Prison | 1 | 9 | 1_1_7_2 |