Template:Mod table with items
This template is intended to help finding mods that unique items uses and then add it to the {{Item}}
template. Items that uses the same mod are sorted by the items release version(!), the mods are often numbered so try to assign the highest numbered mod to the newest item.
Examples
{{#cargo_query: |tables=mods, mod_stats, spawn_weights, _pageData |join on=mods._pageName=mod_stats._pageName, mods._pageName=spawn_weights._pageName, mods._pageName=_pageData._pageName |fields=mods._pageName, mods.id, mods.stat_text, _pageData._creationDate, _pageData._modificationDate |where= mods.stat_text LIKE "%Physical Damage%" AND mods.generation_type=3 AND mod_stats.min=50 AND mod_stats.max=75 |limit=5000 |order by=mods.stat_text |group by=mods._pageName, mod_stats._pageName, spawn_weights._pageName |format=template |template=Mod table with items |intro={{Mod table with items/intro}} |outro={{Mod table with items/outro}} }}
yields:
Page | Mod id | Stat text | Is used in item | Created | Modified |
---|---|---|---|---|---|
Modifier:LocalIncreasedPhysicalDamagePercentUniqueOneHandMace1 | LocalIncreasedPhysicalDamagePercentUniqueOneHandMace1 | (50-75)% increased Physical Damage | Error 1054: Unknown column 'cargo__items.mods' in 'where clause'
Function: CargoSQLQuery::run Query: SELECT `cargo__items`.`_pageName` AS `_pageName` FROM `cargo__items` WHERE `cargo__items`.`class` LIKE "%" AND `cargo__items`.`mods`=LocalIncreasedPhysicalDamagePercentUniqueOneHandMace1 GROUP BY `cargo__items`.`_pageName` ORDER BY `cargo__items`.`release_date` LIMIT 100 |
||
Modifier:LocalIncreasedPhysicalDamagePercentUnique~~15 | LocalIncreasedPhysicalDamagePercentUnique__15 | (50-75)% increased Physical Damage | Error 1054: Unknown column 'cargo__items.mods' in 'where clause'
Function: CargoSQLQuery::run Query: SELECT `cargo__items`.`_pageName` AS `_pageName` FROM `cargo__items` WHERE `cargo__items`.`class` LIKE "%" AND `cargo__items`.`mods`=LocalIncreasedPhysicalDamagePercentUnique__15 GROUP BY `cargo__items`.`_pageName` ORDER BY `cargo__items`.`release_date` LIMIT 100 |
Editors can experiment in this template's sandbox and testcases pages.
Please add categories to the /doc subpage. Subpages of this template.