List of items granting respec points: Difference between revisions
>Illviljan mNo edit summary |
>Illviljan mNo edit summary |
||
Line 2: | Line 2: | ||
{{Query base items | {{Query base items | ||
|tables=quest_rewards | |||
|join=items._pageName = quest_rewards.reward | |||
|where= | |where= | ||
items.description LIKE "%Passive%Respec%Point%" | items.description LIKE "%Passive%Respec%Point%" | ||
OR items.description LIKE "%Passive%Refund%Point%" | OR items.description LIKE "%Passive%Refund%Point%" | ||
|q_orderBy = quest_rewards.act, items._pageName | |||
|large=1 | |large=1 | ||
|description=1 | |description=1 | ||
|quest=1 | |||
}} | }} | ||
[[Category:Item lists]] | [[Category:Item lists]] |
Revision as of 23:56, 31 July 2018
The list below displays items that grants passive respec points.
Lua error: Error 1054: Unknown column 'cargo__quest_rewards.reward' in 'on 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__quest_rewards` ON ((`cargo__items`.`_pageName`=`cargo__quest_rewards`.`reward`)) 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` < 20240520195102 ) 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`.`description` LIKE "%Passive%Respec%Point%" OR `cargo__items`.`description` LIKE "%Passive%Refund%Point%")) 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
.