User:MoonOverMira: Difference between revisions
Jump to navigation
Jump to search
MoonOverMira (talk | contribs) |
MoonOverMira (talk | contribs) |
||
Line 16: | Line 16: | ||
* [[Special:CargoTables/monsters]] | * [[Special:CargoTables/monsters]] | ||
* [[Special:CargoTables/monster_types]] | * [[Special:CargoTables/monster_types]] | ||
{{#cargo_query: | {{#cargo_query: | ||
tables=areas,monsters,monster_types=mt | tables=areas,monsters,monster_types=mt | ||
|join on=areas.boss_monster_ids HOLDS monsters.metadata_id,monsters.monster_type_id=mt.id | |join on=areas.boss_monster_ids HOLDS monsters.metadata_id,monsters.monster_type_id=mt.id | ||
|fields=monsters. | |fields=CONCAT("[[", monsters.name, "|", monsters.name, "]]")=Name, areas.area_level=Level, CONCAT("[[", areas.name, "]]")=Area, areas.act, monsters.metadata_id, monsters.monster_type_id=monsters.monster_type_id, mt.id=monster_types.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:36, 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
Name | Level | Area | act | metadata id | monsters.monster_type_id | monster_types.id |
---|---|---|---|---|---|---|
Hillock | 1 | The Twilight Strand | 1 | Metadata/Monsters/ZombieBoss/ZombieBossHillockNormal | ZombieBossNormal | ZombieBossNormal |
Fire Fury | 2 | The Coast | 1 | Metadata/Monsters/Cannibal/CannibalFemaleBossWitch | CannibalBossFireFury | CannibalBossFireFury |
Hailrake | 3 | The Tidal Island | 1 | Metadata/Monsters/Cannibal/CannibalMaleBossHailrake | CannibalBossHailrake | CannibalBossHailrake |
Oozeback Bloom | 4 | The Mud Flats | 1 | Metadata/Monsters/Rhoas/RhoaBoss | BigRhoaBoss | BigRhoaBoss |
Kadavrus the Defiler | 5 | The Fetid Pool | 1 | Metadata/Monsters/Necromancer/NecromancerBossFetidPool | NecromancerKadavrus | NecromancerKadavrus |
The Dweller of the Deep | 6 | The Flooded Depths | 1 | Metadata/Monsters/ShieldCrabs/ShieldCrabBossSlowAura | ShieldCrabBoss | ShieldCrabBoss |
Kuduku, the False God | 6 | The Ledge | 1 | Metadata/Monsters/Totems/TotemBossSpark | MonsterTotemBossKuduku | MonsterTotemBossKuduku |
The Faun | 7 | The Climb | 1 | Metadata/Monsters/Goatman/GoatmanLeapSlamNavaliBoss | GoatmanBossNavali | GoatmanBossNavali |
Chatters | 8 | The Lower Prison | 1 | Metadata/Monsters/Skeletons/SkeletonBossPrisonMelee | SkeletonBoss | SkeletonBoss |
Sawbones | 9 | The Upper Prison | 1 | Metadata/Monsters/Necromancer/NecromancerBossPrison | NecromancerSawbones | NecromancerSawbones |