Template:Alternate skill effect list
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:
Alternate skill effects
Alternate skill effect list 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__versions`.`release_date` < 20240520102106
) 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
.
Editors can experiment in this template's sandbox and testcases pages.
Please add categories to the /doc subpage. Subpages of this template.