User:MoonOverMira: Difference between revisions
Jump to navigation
Jump to search
MoonOverMira (talk | contribs) |
MoonOverMira (talk | contribs) |
||
Line 7: | Line 7: | ||
tables=character_classes=c | tables=character_classes=c | ||
|fields=CONCAT('[[', c.name, ']]')=Class, c.strength=Strength, c.dexterity=Dexterity, c.intelligence=Intelligence | |fields=CONCAT('[[', c.name, ']]')=Class, c.strength=Strength, c.dexterity=Dexterity, c.intelligence=Intelligence | ||
| | }} | ||
<br> | |||
Looks like Cargo doesn't support arithmetic on columns from the same table<ref name="no arithmetic"/>, so displaying a Total column in the table is not easy. Perhaps something ungodly could be done with joins and a SUM. | |||
{{reflist|refs= | |||
<ref name="no arithmetic">{{cite web|url=https://www.mediawiki.org/wiki/Extension_talk:Cargo/Archive_May_to_July_2020#Cargo_equivalent_to_SQL_arithmetic_operations_between_2_or_more_columns?}}</ref> | |||
}} | }} | ||
Revision as of 06:54, 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 |
---|---|---|---|
Duelist | 23 | 23 | 14 |
Marauder | 32 | 14 | 14 |
Ranger | 14 | 32 | 14 |
Scion | 20 | 20 | 20 |
Shadow | 14 | 23 | 23 |
Templar | 23 | 14 | 23 |
Witch | 14 | 14 | 32 |
Looks like Cargo doesn't support arithmetic on columns from the same table[1], so displaying a Total column in the table is not easy. Perhaps something ungodly could be done with joins and a SUM.
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 |
Hmm, how can we get the pretty monster type name for these unique monsters?
- Not all of the monster_type_ids are present in monster_types
- monster_types doesn't even have a column for a pretty representation
- Pages like Cannibal all look to be manually edited, not generated from game data.
- The closest we get to a category is the third part in the metadata_id, like Metadata/Monsters/Rhoas/RhoaBoss
If no mapping exists, maybe a pretty monster type column should be sacrificed?