User:MoonOverMira: Difference between revisions
Jump to navigation
Jump to search
MoonOverMira (talk | contribs) |
MoonOverMira (talk | contribs) |
||
| Line 23: | Line 23: | ||
|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= | |limit=5 | ||
}} | }} | ||
Revision as of 06:41, 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 |