Template:Mod table with items/doc: Difference between revisions
Jump to navigation
Jump to search
>Illviljan (Created page with "This template is intended to help finding mods that unique items uses and then add it to the {{tlx|Item}} template. Items that uses the same mod are sorted by the items re...") |
>Illviljan mNo edit summary |
||
Line 22: | Line 22: | ||
</pre> | </pre> | ||
yields | yields: | ||
{{#cargo_query: | {{#cargo_query: | ||
|tables=mods, mod_stats, spawn_weights | |tables=mods, mod_stats, spawn_weights | ||
Line 44: | Line 45: | ||
<includeonly> | <includeonly> | ||
<!-- CATEGORIES AND INTERWIKIS HERE, THANKS --> | <!-- CATEGORIES AND INTERWIKIS HERE, THANKS --> | ||
[[Category: | [[Category:Result formatting templates]] | ||
</includeonly> | </includeonly> |
Revision as of 00:07, 20 January 2018
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 |join on=mods._pageName=mod_stats._pageName, mods._pageName=spawn_weights._pageName |fields=mods._pageName, mods.id, mods.stat_text |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 | Brightbeak | ||
Modifier:LocalIncreasedPhysicalDamagePercentUnique~~15 | LocalIncreasedPhysicalDamagePercentUnique__15 | (50-75)% increased Physical Damage | Reach of the Council |