User:Illviljan/cargo: Difference between revisions
>Illviljan mNo edit summary |
>Pcj (test) |
||
| Line 4: | Line 4: | ||
tables = events | tables = events | ||
|fields = events.id | |fields = events.id | ||
|where = events.id HOLDS "abyss" | |where = events.id HOLDS BINARY "abyss" | ||
}} | }} | ||
| Line 10: | Line 10: | ||
tables = events | tables = events | ||
|fields = events.id | |fields = events.id | ||
|where = events.id HOLDS "Abyss" | |where = events.id HOLDS BINARY "Abyss" | ||
}} | }} | ||
| Line 16: | Line 16: | ||
tables = events | tables = events | ||
|fields = events.id | |fields = events.id | ||
|where = events.id HOLDS "SSF abyss" | |where = events.id HOLDS BINARY "SSF abyss" | ||
}} | }} | ||
| Line 22: | Line 22: | ||
tables = events | tables = events | ||
|fields = events.id | |fields = events.id | ||
|where = events.id HOLDS "SsF abyss" | |where = events.id HOLDS BINARY "SsF abyss" | ||
}} | }} | ||
Revision as of 22:13, 24 January 2018
Case sensitivity in HOLDS
Function: CargoSQLQuery::run Query: SELECT `id__full` AS `id` FROM `cargo__events` WHERE `cargo__events`.`_ID` IN (SELECT `_rowID` FROM `cargo__events__id` WHERE `_value`= BINARY ) "abyss" ORDER BY `cargo__events`.`id__full` LIMIT 100
Function: CargoSQLQuery::run Query: SELECT `id__full` AS `id` FROM `cargo__events` WHERE `cargo__events`.`_ID` IN (SELECT `_rowID` FROM `cargo__events__id` WHERE `_value`= BINARY ) "Abyss" ORDER BY `cargo__events`.`id__full` LIMIT 100
Function: CargoSQLQuery::run Query: SELECT `id__full` AS `id` FROM `cargo__events` WHERE `cargo__events`.`_ID` IN (SELECT `_rowID` FROM `cargo__events__id` WHERE `_value`= BINARY ) "SSF abyss" ORDER BY `cargo__events`.`id__full` LIMIT 100
Function: CargoSQLQuery::run Query: SELECT `id__full` AS `id` FROM `cargo__events` WHERE `cargo__events`.`_ID` IN (SELECT `_rowID` FROM `cargo__events__id` WHERE `_value`= BINARY ) "SsF abyss" ORDER BY `cargo__events`.`id__full` LIMIT 100
Intro
- https://www.mediawiki.org/wiki/Extension:Cargo/Querying_data
- Lua: https://www.mediawiki.org/wiki/Extension:Cargo/Other_features
- results[2][version.version]
testtal
Abyss • Hardcore Abyss • SSF Abyss • SSF Abyss HC
| 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']
)
mods that can spawn on items
item_tags = axe, one_hand_weapon, onehand, weapon, default
Items
| _pageName | name |
|---|---|
| Blue Pearl Amulet | Blue Pearl Amulet |
-->