Alternate skill effect: Difference between revisions
>Illviljan No edit summary |
>Vinifera7 No edit summary |
||
| Line 6: | Line 6: | ||
|tables=stackables | |tables=stackables | ||
|join=items._pageID=stackables._pageID | |join=items._pageID=stackables._pageID | ||
|where=items.class="Microtransactions" AND items.metadata_id LIKE "Metadata/Items/MicrotransactionSkillEffects/%" AND stackables.cosmetic_type LIKE "%Skin" | |where=items.class="Microtransactions" AND items.metadata_id LIKE "Metadata/Items/MicrotransactionSkillEffects/%" AND ( stackables.cosmetic_type LIKE "%Skin" OR stackables.cosmetic_type LIKE "Skill Gem Effect" ) | ||
|q_limit=2000 | |q_limit=2000 | ||
|description=1 | |description=1 | ||
Revision as of 00:58, 4 September 2020
Alternate skill effects are a type of microtransaction that add effects to various skills.
Related items
The list below shows microtransaction that are related to 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`.`rarity_id` = "normal" AND `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` < 20240505113021) AND (`cargo__items`.`class`="Microtransactions" AND `cargo__items`.`metadata_id` LIKE "Metadata/Items/MicrotransactionSkillEffects/%" AND ( `cargo__stackables`.`cosmetic_type` LIKE "%Skin" OR `cargo__stackables`.`cosmetic_type` LIKE "Skill Gem Effect" ))) AND `cargo__items`.`_pageNamespace` IN (0,10016) GROUP BY `cargo__items`.`_pageID` ORDER BY `cargo__items`.`required_level_range_maximum`,`cargo__items`.`name` LIMIT 2000 .