Template:Alternate skill effect list: Difference between revisions

From Path of Exile 2 Wiki
Jump to navigation Jump to search
>OmegaK2
No edit summary
No edit summary
Line 1: Line 1:
<includeonly>==Microtransactions==
<includeonly>==Alternate skill effects==
The list below shows [[microtransaction]]s for {{PAGENAME}}.
{{{skill|{{PAGENAME}}}}} has the following [[alternate skill effect]]s:
{{Query base items
{{Query base items
|tables=stackables
|tables=stackables
|join=items._pageID=stackables._pageID
|join=items._pageID=stackables._pageID
|where=
|where={{{query|
    {{{query|
    items.class_id="Microtransaction"
        items.class_id="Microtransaction"  
    AND stackables.cosmetic_type LIKE "Skill Gem Effect"
        AND (
    AND (
            BINARY stackables.cosmetic_type LIKE "{{{skill|{{PAGENAME}}}}}%"
        BINARY items.help_text LIKE "%{{{skill|{{PAGENAME}}}}}%"
            OR BINARY items.help_text LIKE "%{{{skill|{{PAGENAME}}}}}%"
        OR BINARY items.description 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 23:40, 5 September 2020

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 No 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 No A custom query instead of the default one.

Example

{{Alternate skill effect list|skill=Fireball}}

yields:

Alternate skill effects

Fireball has the following alternate skill effects: 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__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_id`="Microtransaction"
   AND `cargo__stackables`.`cosmetic_type` LIKE "Skill Gem Effect"
   AND (
       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 (create | mirror) and testcases (create) pages.
Please add categories to the /doc subpage. Subpages of this template.
Retrieved from "https://www.poe2wiki.net/index.php?title=Template:Alternate_skill_effect_list&oldid=8148"