Template:Alternate skill effect list: Difference between revisions

From Path of Exile Wiki
Jump to navigation Jump to search
>Illviljan
mNo edit summary
>Illviljan
mNo edit summary
Line 5: Line 5:
|join=items._pageID=stackables._pageID
|join=items._pageID=stackables._pageID
|where=
|where=
     items.class="Microtransactions"  
     {{{query|
    AND (
        items.class="Microtransactions"  
        BINARY stackables.cosmetic_type LIKE "{{{skill|{{PAGENAME}}}}}%"
        AND (
        OR BINARY items.help_text LIKE "%{{{skill|{{PAGENAME}}}}}%"
            BINARY stackables.cosmetic_type LIKE "{{{skill|{{PAGENAME}}}}}%"
        OR BINARY items.description LIKE "%{{{skill|{{PAGENAME}}}}}%"
            OR BINARY items.help_text LIKE "%{{{skill|{{PAGENAME}}}}}%"
     )
            OR BINARY items.description LIKE "%{{{skill|{{PAGENAME}}}}}%"
        )
     }}}
|description=1
|description=1
|large=1
|large=1
}}</includeonly><noinclude>{{documentation}}</noinclude>
}}</includeonly><noinclude>{{documentation}}</noinclude>

Revision as of 11:33, 24 July 2018

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


This template queries and displays the alternate skill effects that can be applied to a skill gem.

Usage

Place this template in the article for a skill gem to display a section that lists the alternate skill effects available for that skill.

Parameters

Depending on the skill, it may be necessary to use additional parameters to return the correct list of items.

Parameter Required Description
skill
✗
 Name of the skill to search for.
If it is omitted, the progression is assumed to be the name of the page the template is put on.
query
✗
 A custom query instead of the default one.

Example

{{Skill microtransaction list|skill=Fireball}}

yields:

Microtransactions

The list below shows microtransactions for Alternate skill effect list. Lua error: Error 1054: Unknown column 'cargo__stackables.cosmetic_type' in 'where clause' Function: CargoSQLQuery::run Query: SELECT `cargo__items`.`_pageID` AS `items._pageID`,`cargo__items`.`_pageName` AS `items._pageName`,`cargo__items`.`name` AS `items.name`,`cargo__items`.`inventory_icon` AS `items.inventory_icon`,`cargo__items`.`html` AS `items.html`,`cargo__items`.`size_x` AS `items.size_x`,`cargo__items`.`size_y` AS `items.size_y`,`cargo__items`.`description` AS `items.description` FROM `cargo__items` LEFT OUTER JOIN `cargo__versions` ON ((`cargo__items`.`release_version`=`cargo__versions`.`version`)) LEFT OUTER JOIN `cargo__stackables` ON ((`cargo__items`.`_pageID`=`cargo__stackables`.`_pageID`)) WHERE (`cargo__items`.`drop_enabled` = true 

 AND (`cargo__items`.`release_version` IS NULL 
   OR `cargo__items`.`release_version` IS NOT NULL
   AND `cargo__versions`.`release_date` < 20240520122419
 ) AND `cargo__items`.`base_item` IS NULL
 AND `cargo__items`.`base_item_id` IS NULL
 AND `cargo__items`.`base_item_page` IS NULL
 AND (`cargo__items`.`class`="Microtransactions" 
       AND (
           BINARY `cargo__stackables`.`cosmetic_type` LIKE "Fireball%"
           OR BINARY `cargo__items`.`help_text` LIKE "%Fireball%"
           OR BINARY `cargo__items`.`description` LIKE "%Fireball%"
       ))) AND `cargo__items`.`_pageNamespace` IN (0,10016)  GROUP BY `cargo__items`.`_pageID` ORDER BY `cargo__items`.`required_level_range_maximum`,`cargo__items`.`name` LIMIT 5000

.

The above documentation is transcluded from Template:Alternate skill effect list/doc. (edit | history)
Editors can experiment in this template's sandbox (edit | diff) 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:Alternate_skill_effect_list&oldid=896892"