User:MoonOverMira: Difference between revisions
Jump to navigation
Jump to search
MoonOverMira (talk | contribs) No edit summary |
MoonOverMira (talk | contribs) |
||
| Line 9: | Line 9: | ||
==List of unique monsters== | ==List of unique monsters== | ||
===Works=== | |||
{{#cargo_query: | |||
tables=monsters | |||
|fields=monsters.is_boss,monsters.metadata_id,monsters.monster_type_id,monsters.name,monsters.rarity_id | |||
|where=monsters.rarity_id="unique" | |||
|limit=3 | |||
}} | |||
===Doesn't work=== | |||
{{#cargo_query: | |||
tables=monsters,areas | |||
|join on=areas.monster_boss_ids HOLDS monsters.metadata_id | |||
|fields=monsters.is_boss,monsters.metadata_id,monsters.monster_type_id,monsters.name,monsters.rarity_id | |||
|where=monsters.rarity_id="unique" | |||
|limit=10 | |||
}} | |||
Revision as of 05:32, 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
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