User:Illviljan/cargo: Difference between revisions
Jump to navigation
Jump to search
>Illviljan mNo edit summary |
>Illviljan mNo edit summary |
||
Line 17: | Line 17: | ||
query = { | query = { | ||
where = 'versions.version <> ""', | where = 'versions.version <> ""', | ||
orderBy = 'versions.version DESC, versions.release_date ASC', | orderBy = 'versions.version DESC, versions.release_date ASC', | ||
limit = 10, | limit = 10, | ||
offset = 2, | offset = 2, | ||
Line 64: | Line 64: | ||
<!-- OR ... --> | <!-- OR ... --> | ||
|orderBy = mods.id, mods.mod_group, mods.mod_type, mods.required_level | |orderBy = mods.id, mods.mod_group, mods.mod_type, mods.required_level | ||
|groupBy = mods._pageID | |||
|limit = 10 | |limit = 10 | ||
|offset = 0 | |offset = 0 |
Revision as of 06:12, 19 December 2017
Intro
- https://www.mediawiki.org/wiki/Extension:Cargo/Querying_data
- Lua: https://www.mediawiki.org/wiki/Extension:Cargo/Other_features
- results[2][version.version]
version | release date |
---|---|
0.10.0c | 2013-01-26 |
0.10.0d | 2013-01-27 |
0.10.0e | 2013-01-30 |
0.10.0f | 2013-02-04 |
0.10.0g | 2013-02-07 |
0.10.1 | 2013-02-12 |
0.10.1b | 2013-02-13 |
0.10.1c | 2013-02-19 |
0.10.1d | 2013-02-21 |
0.10.1e | 2013-02-22 |
tables = 'versions' fields = 'versions.version, versions.release_date' query = { where = 'versions.version <> ""', orderBy = 'versions.version DESC, versions.release_date ASC', limit = 10, offset = 2, } results = mw.ext.cargo.query(tables, fields, query) print(results[1]['versions.version'])
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'] )
spawnable, named 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".