Template:Alternate skill effect list: Difference between revisions
No edit summary |
No edit summary |
||
| Line 8: | Line 8: | ||
AND stackables.cosmetic_type LIKE "Skill Gem Effect" | AND stackables.cosmetic_type LIKE "Skill Gem Effect" | ||
AND ( | AND ( | ||
BINARY items. | BINARY items.name LIKE "%{{{skill|{{PAGENAME}}}}}%" | ||
OR BINARY items.description LIKE "%{{{skill|{{PAGENAME}}}}}%" | OR BINARY items.description LIKE "%{{{skill|{{PAGENAME}}}}}%" | ||
) | ) | ||
Revision as of 01:43, 6 September 2020
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
{{Alternate skill effect 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__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`.`name` 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.