List of helmet enchantment mods: Difference between revisions
Jump to navigation
Jump to search
>OmegaK2 No edit summary |
>Neokowloon No edit summary |
||
| Line 1: | Line 1: | ||
List of [[enchantment]] [[modifiers]] that can spawn on [[helmets]]. | List of [[enchantment]] [[modifiers]] that can spawn on [[helmets]]. | ||
{{Query spawnable modifiers | |||
|where=mods.generation_type = 10 AND spawn_weights.tag = "helmet" | |||
|q_orderBy = mods.id, mods.required_level | |||
|q_limit=3000 | |||
|stat_text=1 | |||
|spawn_weights=1 | |||
|enchantment=1 | |||
|level=0 | |||
}} | |||
===Legacy helmet enchantments=== | |||
{{Modifier table | {{Modifier table | ||
|q_tables = spawn_weights | |q_tables = mod_stats, spawn_weights | ||
|q_join = mods._pageID=spawn_weights._pageID | |q_join = mods._pageID=mod_stats._pageID, mods._pageID=spawn_weights._pageID | ||
|q_where = mods.generation_type = 10 AND spawn_weights.tag = "helmet" | |q_where = mods.generation_type = 10 AND spawn_weights.tag = "helmet" | ||
|q_having = SUM(spawn_weights.weight) = 0 | |||
|q_groupBy = spawn_weights._pageID | |||
|q_orderBy = mods.id, mods.required_level | |q_orderBy = mods.id, mods.required_level | ||
|stat_text=1 | |stat_text=1 | ||
|enchantment=1 | |enchantment=1 | ||
}} | |||
}}<noinclude> | <noinclude> | ||
[[Category:Enchantment mod lists]] | [[Category:Enchantment mod lists]] | ||
Revision as of 08:30, 29 September 2020
List of enchantment modifiers that can spawn on helmets.
Lua error: Error 1054: Unknown column 'spawn_weights.tag' in 'where clause' Function: CargoSQLQuery::run Query: SELECT `cargo__mods`.`_pageID` AS `mods._pageID`,`cargo__mods`.`_pageName` AS `mods._pageName`,`cargo__mods`.`id` AS `mods.id`,`cargo__mods`.`name` AS `mods.name`,CONCAT(
CASE `cargo__mods`.`required_level`
WHEN 32 THEN "Normal Labyrinth"
WHEN 53 THEN "Cruel Labyrinth"
WHEN 66 THEN "Merciless Labyrinth"
WHEN 75 THEN "Eternal Labyrinth"
WHEN 83 THEN "Eternal Labyrinth of Potential"
END
) AS `labyrinth_text`,`cargo__mods`.`stat_text` AS `mods.stat_text` FROM `cargo__mods` LEFT OUTER JOIN `cargo__mod_spawn_weights` ON ((`cargo__mods`.`_pageID`=`cargo__mod_spawn_weights`.`_pageID`)) LEFT OUTER JOIN `cargo__mod_stats` ON ((`cargo__mods`.`_pageID`=`cargo__mod_stats`.`_pageID`)) WHERE `cargo__mod_spawn_weights`.`value` > 0
AND (`cargo__mods`.`generation_type` = 10 AND spawn_weights.tag = "helmet") GROUP BY `cargo__mods`.`_pageID` ORDER BY `cargo__mods`.`id`,`cargo__mods`.`required_level` LIMIT 3000
.
Legacy helmet enchantments
No results found ru:Список свойств зачарований для шлема de:Liste der Helmverzauberung-Modifikatoren