User:Illviljan/cargo: Difference between revisions
Jump to navigation
Jump to search
>Illviljan mNo edit summary |
>Illviljan mNo edit summary |
||
Line 141: | Line 141: | ||
|tables = mods, spawn_weights | |tables = mods, spawn_weights | ||
|join on = mods._pageID=spawn_weights._pageID | |join on = mods._pageID=spawn_weights._pageID | ||
|fields = mods. | |fields = mods._pageName, CONCAT( | ||
CASE mods.required_level | CASE mods.required_level | ||
WHEN 32 THEN "normal" | WHEN 32 THEN "normal" | ||
Line 148: | Line 148: | ||
WHEN 75 THEN "uber" | WHEN 75 THEN "uber" | ||
END | END | ||
)= | )=[[Labyrinth]], | ||
|where = mods.generation_type = 10 AND spawn_weights.tag = "boots" AND spawn_weights.weight > 0 | |where = mods.generation_type = 10 AND spawn_weights.tag = "boots" AND spawn_weights.weight > 0 | ||
|order by = mods.id, mods.required_level | |order by = mods.id, mods.required_level |
Revision as of 20:36, 27 July 2018
Intro
- https://www.mediawiki.org/wiki/Extension:Cargo/Querying_data
- Lua: https://www.mediawiki.org/wiki/Extension:Cargo/Other_features
- results[2][version.version]
Lists of strings
HOLDS
Abyss • Hardcore Abyss • SSF Abyss • SSF Abyss HC
Multiple holds
Abyss league
__FULL LIKE
Abyss league
__FULL REGEXP
Abyss league
HOLDS NOT
No results
Lua equivalents
No results
tables = 'mods, spawn_weights' fields = 'mods.id, spawn_weights.weight' query = { join = 'mods._pageID=spawn_weights._pageID', where = 'mods.domain=5 AND mods.name="Fecund" AND spawn_weights.weight > 0', limit = 10, offset = 2 } results = mw.ext.cargo.query(tables, fields, query) print( results[1]['mods.id'], results[1]['spawn_weights.weight'] )
Offset
We have the following list:
- No results
Limit to 3 results:
- No results
Add the rest:
- No results
mods that can spawn on items
item_tags = axe, one_hand_weapon, onehand, weapon, default
Error: No field named "mod_group" found for the database table "mods".
Incursion
Error: No field named "mod_group" found for the database table "mods".
Boots enchantments
No results