Template:Mod table with items/doc: Difference between revisions
Jump to navigation
Jump to search
Mefisto1029 (talk | contribs) (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 release version(!), the mods are often numbered so try to assign the highest numbered mod to the newest item. ==Examples== <pre> {{#cargo_query: |tables=mods, mod_stats, spawn_weights, _pageData |join on=mods._pageName=mod_stats._pageName, mods._pageName=spawn_weights._pageName, mods._pageName=_pa...") |
Mefisto1029 (talk | contribs) No edit summary |
||
| Line 4: | Line 4: | ||
<pre> | <pre> | ||
{{#cargo_query: | {{#cargo_query: | ||
|tables=mods, mod_stats | |tables=mods, mod_stats, _pageData | ||
|join on=mods._pageName=mod_stats | |join on=mods._pageName=mod_stats._pageName, mods._pageName=_pageData._pageName | ||
|fields=mods._pageName, mods.id, mods.stat_text, _pageData._creationDate, _pageData._modificationDate | |fields=mods._pageName, mods.id, mods.stat_text, _pageData._creationDate, _pageData._modificationDate | ||
|where= | |where= | ||
mods. | mods.stat_text_raw LIKE "%to all attributes%" | ||
AND mods.domain=1 | |||
AND mods.generation_type=3 | AND mods.generation_type=3 | ||
AND mod_stats.min= | AND mod_stats.min=10 | ||
AND mod_stats.max= | AND mod_stats.max=15 | ||
|limit=5000 | |limit=5000 | ||
|order by=mods.stat_text | |order by=mods.stat_text | ||
|group by=mods._pageName, mod_stats | |group by=mods._pageName, mod_stats._pageName | ||
|format=template | |format=template | ||
|template=Mod table with items | |template=Mod table with items | ||
| Line 25: | Line 26: | ||
{{#cargo_query: | {{#cargo_query: | ||
|tables=mods, mod_stats | |tables=mods, mod_stats, _pageData | ||
|join on=mods._pageName=mod_stats | |join on=mods._pageName=mod_stats._pageName, mods._pageName=_pageData._pageName | ||
|fields=mods._pageName, mods.id, mods.stat_text, _pageData._creationDate, _pageData._modificationDate | |fields=mods._pageName, mods.id, mods.stat_text, _pageData._creationDate, _pageData._modificationDate | ||
|where= | |where= | ||
mods. | mods.stat_text_raw LIKE "%to all attributes%" | ||
AND mods.domain=1 | |||
AND mods.generation_type=3 | AND mods.generation_type=3 | ||
AND mod_stats.min= | AND mod_stats.min=10 | ||
AND mod_stats.max= | AND mod_stats.max=15 | ||
|limit=5000 | |limit=5000 | ||
|order by=mods.stat_text | |order by=mods.stat_text | ||
|group by=mods._pageName, mod_stats | |group by=mods._pageName, mod_stats._pageName | ||
|format=template | |format=template | ||
|template=Mod table with items | |template=Mod table with items | ||
Latest revision as of 10:12, 17 December 2025
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, _pageData
|join on=mods._pageName=mod_stats._pageName, mods._pageName=_pageData._pageName
|fields=mods._pageName, mods.id, mods.stat_text, _pageData._creationDate, _pageData._modificationDate
|where=
mods.stat_text_raw LIKE "%to all attributes%"
AND mods.domain=1
AND mods.generation_type=3
AND mod_stats.min=10
AND mod_stats.max=15
|limit=5000
|order by=mods.stat_text
|group by=mods._pageName, mod_stats._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:UniqueAllAttributes7 | UniqueAllAttributes7 | +(10-15) to all Attributes | Quecholli | 2025-12-07 18:25:21 | 2025-12-09 18:22:06 |
| Modifier:UniqueAllAttributes8 | UniqueAllAttributes8 | +(10-15) to all Attributes | Pariah's Embrace | 2025-12-07 18:25:22 | 2025-12-09 18:22:10 |
| Modifier:UniqueAllAttributes11 | UniqueAllAttributes11 | +(10-15) to all Attributes | Eye of Chayula | 2025-12-07 18:25:24 | 2025-12-09 18:22:23 |
| Modifier:UniqueAllAttributes12 | UniqueAllAttributes12 | +(10-15) to all Attributes | The Road Warrior | 2025-12-07 18:25:25 | 2025-12-09 18:22:27 |
| Modifier:UniqueAllAttributes13 | UniqueAllAttributes13 | +(10-15) to all Attributes | Crown of Eyes | 2025-12-07 18:25:25 | 2025-12-09 18:22:31 |
| Modifier:UniqueAllAttributes14 | UniqueAllAttributes14 | +(10-15) to all Attributes | Constricting Command | 2025-12-07 18:25:26 | 2025-12-09 18:22:38 |