User:Illviljan/cargo: Difference between revisions
Jump to navigation
Jump to search
>Illviljan mNo edit summary |
>Illviljan No edit summary |
||
| Line 1: | Line 1: | ||
==Intro== | |||
* https://www.mediawiki.org/wiki/Extension:Cargo/Querying_data | * https://www.mediawiki.org/wiki/Extension:Cargo/Querying_data | ||
* Lua: https://www.mediawiki.org/wiki/Extension:Cargo/Other_features | * Lua: https://www.mediawiki.org/wiki/Extension:Cargo/Other_features | ||
| Line 51: | Line 52: | ||
==spawnable, named mods that can spawn on items== | |||
item_tags = axe, one_hand_weapon, onehand, weapon, default | |||
{{#cargo_query: | |||
tables = mods, spawn_weights | |||
|fields = mods.id, mods.stat_text, spawn_weights.weight, spawn_weights.tag, mods.required_level, mods.mod_group, mods.mod_type, mods.generation_type | |||
|join on = mods._pageID=spawn_weights._pageID | |||
|where = (spawn_weights.tag="weapon" AND mods.generation_type=1 AND spawn_weights.weight>0 AND mods.name <> "") | |||
OR (spawn_weights.tag="axe" AND mods.generation_type=1 AND spawn_weights.weight>0 AND mods.name <> "") | |||
OR (spawn_weights.tag="axe" AND mods.generation_type=2 AND spawn_weights.weight>0 AND mods.name <> "") | |||
OR (spawn_weights.tag="axe" AND mods.generation_type=2 AND spawn_weights.weight>0 AND mods.name <> "") | |||
<!-- OR ... --> | |||
|orderBy = mods.mod_group, mods.mod_type, mods.required_level | |||
|limit = 10 | |||
|offset = 0 | |||
}} | |||
==Built in timeline== | |||
{{#cargo_query: | {{#cargo_query: | ||
tables = versions | tables = versions | ||
Revision as of 10:54, 17 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".