User:MoonOverMira
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
Works
is boss | metadata id | monster type id | name | rarity id |
---|---|---|---|---|
No | Metadata/Monster/Blackguard/BlackguardJaegerMelee | BlackguardJaegerMelee | Blackguard Jaeger | unique |
No | Metadata/Monster/Blackguard/BlackguardJaegerMeleeMemoryLine | BlackguardJaegerMelee | Blackguard Jaeger | unique |
No | Metadata/Monster/Blackguard/BlackguardJaegerRanged | BlackguardJaegerRanged | Blackguard Jaeger | unique |
Doesn't work
Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'HOLDS `cargo__areas`.`monster_boss_ids`)) WHERE `cargo__monsters`.`rarity_i...' at line 1
Function: CargoSQLQuery::run Query: SELECT `cargo__monsters`.`is_boss` AS `is boss`,`cargo__monsters`.`metadata_id` AS `metadata id`,`cargo__monsters`.`monster_type_id` AS `monster type id`,`cargo__monsters`.`name` AS `name`,`cargo__monsters`.`rarity_id` AS `rarity id` FROM `cargo__monsters` LEFT OUTER JOIN `cargo__areas` ON ((`cargo__monsters`.`metadata_id` HOLDS `cargo__areas`.`monster_boss_ids`)) WHERE `cargo__monsters`.`rarity_id`="unique" ORDER BY `cargo__monsters`.`is_boss`,`cargo__monsters`.`metadata_id`,`cargo__monsters`.`monster_type_id`,`cargo__monsters`.`name`,`cargo__monsters`.`rarity_id` LIMIT 10