User:Illviljan/cargo: Difference between revisions
Jump to navigation
Jump to search
>Illviljan mNo edit summary |
>Illviljan mNo edit summary |
||
| Line 119: | Line 119: | ||
OR (spawn_weights.tag="default" AND mods.generation_type=2 AND mods.domain=1 AND mods.name <> "") | OR (spawn_weights.tag="default" AND mods.generation_type=2 AND mods.domain=1 AND mods.name <> "") | ||
<!-- OR ... --> | <!-- OR ... --> | ||
| | |order by = mods.id, mods.mod_group, mods.mod_type, mods.required_level | ||
| | |group by = mods._pageID | ||
|limit = 10 | |limit = 10 | ||
|offset = 0 | |offset = 0 | ||
| Line 131: | Line 131: | ||
|join on = mods._pageID=spawn_weights._pageID, mods._pageID=mod_stats._pageID | |join on = mods._pageID=spawn_weights._pageID, mods._pageID=mod_stats._pageID | ||
|where = mods.id LIKE "%enhanced%" | |where = mods.id LIKE "%enhanced%" | ||
| | |order by = mods.name, mods.id, mods.mod_group, mods.mod_type, mods.required_level | ||
| | |group by = mods._pageID | ||
|limit = | |limit = 10 | ||
|offset = 0 | |offset = 0 | ||
}} | }} | ||
| Line 152: | Line 152: | ||
|order by = mods.id, mods.required_level | |order by = mods.id, mods.required_level | ||
|limit=10 | |limit=10 | ||
}} | |||
==Dates== | |||
{{#cargo_query: | |||
tables = events | |||
|fields = events._pageName, events.name, events.release_date | |||
|where = events.release_date IS NOT NULL | |||
|order by = events.release_date DESC | |||
|limit = 10 | |||
}} | }} | ||
| Line 159: | Line 168: | ||
|fields = versions.version, versions.release_date | |fields = versions.version, versions.release_date | ||
|where = versions.version <> "" | |where = versions.version <> "" | ||
| | |order by = versions.version DESC, versions.release_date ASC | ||
|limit = 5000 | |limit = 5000 | ||
|offset = 2 | |offset = 2 | ||
|format = timeline | |format = timeline | ||
}} | }} | ||
Revision as of 17:59, 14 November 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
Dates
| _pageName | name | release date |
|---|---|---|
| Path of Exile: Necropolis | Necropolis | 2024-03-29 6:00:00 PM |
| Necropolis league | Necropolis league | 2024-03-29 6:00:00 PM |
| Path of Exile: Affliction | Affliction | 2023-12-08 7:00:00 PM |
| Affliction league | Affliction league | 2023-12-08 7:00:00 PM |
| Path of Exile: Trial of the Ancestors | Trial of the Ancestors | 2023-08-18 8:00:00 PM |
| Ancestor league | Ancestor league | 2023-08-18 8:00:00 PM |
| Crucible league | Crucible league | 2023-04-07 8:00:00 PM |
| Path of Exile: Crucible | Crucible | 2023-04-07 |
| Sanctum league | Sanctum league | 2022-12-09 7:00:00 PM |
| Path of Exile: The Forbidden Sanctum | The Forbidden Sanctum | 2022-12-09 |