Template:Mod table with items: Difference between revisions

From Path of Exile Wiki
Jump to navigation Jump to search
>Illviljan
mNo edit summary
>Illviljan
(HOLDS is unreliable using __FULL and REGEXP instead in Cargos list of strings.)
Line 3: Line 3:
     <td>{{{2|}}}</td>  
     <td>{{{2|}}}</td>  
     <td>{{{3|}}}</td>
     <td>{{{3|}}}</td>
     <td> {{#cargo_query:  
     <td>{{#cargo_query:  
|tables = items
            |tables = items
|fields = items._pageName
            |fields = items._pageName
|where = items.class LIKE "%" AND items.mods HOLDS "{{{2}}}"
            |where = items.class LIKE "%" AND items.mods__FULL REGEXP "(,{{!}}^){{{2}}}(,{{!}}$)"
|group by = items._pageName
            |group by = items._pageName
|order by = items.release_version
            |order by = items.release_version
|default =  
            |default =  
|delimiter = <br>
            |delimiter = <br>
}}</td>
        }}
  </tr></includeonly><noinclude>
    </td>
</tr></includeonly><noinclude>
{{documentation}}
{{documentation}}
</noinclude>
</noinclude>

Revision as of 19:59, 18 June 2018

Template documentation[view] [edit] [history] [purge]

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__FULL' 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__FULL` REGEXP "(,|^)LocalIncreasedPhysicalDamagePercentUniqueOneHandMace1(,|$)" GROUP BY `cargo__items`.`_pageName` ORDER BY `cargo__items`.`release_version` LIMIT 100

Modifier:LocalIncreasedPhysicalDamagePercentUnique~~15 LocalIncreasedPhysicalDamagePercentUnique__15 (50-75)% increased Physical Damage
Error 1054: Unknown column 'cargo__items.mods__FULL' 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__FULL` REGEXP "(,|^)LocalIncreasedPhysicalDamagePercentUnique__15(,|$)" GROUP BY `cargo__items`.`_pageName` ORDER BY `cargo__items`.`release_version` LIMIT 100

The above documentation is transcluded from Template:Mod table with items/doc. (edit | history)
Editors can experiment in this template's sandbox (create | mirror) and testcases (create) pages.
Please add categories to the /doc subpage. Subpages of this template.
Retrieved from "https://www.poewiki.net/index.php?title=Template:Mod_table_with_items&oldid=894499"