List of vaal side area modifiers: Difference between revisions
Neokowloon (talk | contribs) No edit summary |
Neokowloon (talk | contribs) No edit summary |
||
| Line 1: | Line 1: | ||
List of [[vaal side area]] modifiers | List of [[vaal side area]] modifiers | ||
==Prefix== | ==Acts version== | ||
===Prefix=== | |||
{{Query spawnable modifiers | {{Query spawnable modifiers | ||
|where=mods.domain=5 AND spawn_weights.tag in ("secret_area") AND mods.generation_type = 1 | |where=mods.domain=5 AND spawn_weights.tag in ("secret_area") AND mods.generation_type = 1 AND mods.required_level = 1 | ||
|spawn_weights=1 | |spawn_weights=1 | ||
}} | }} | ||
==Suffix== | ===Suffix=== | ||
{{Query spawnable modifiers | {{Query spawnable modifiers | ||
|where=mods.domain=5 AND spawn_weights.tag in ("secret_area") AND mods.generation_type = 2 | |where=mods.domain=5 AND spawn_weights.tag in ("secret_area") AND mods.generation_type = 2 AND mods.required_level = 1 | ||
|spawn_weights=1 | |spawn_weights=1 | ||
}} | }} | ||
[[Category:Mod lists by domain | ==Map version== | ||
]] | ===Prefix=== | ||
{{Query spawnable modifiers | |||
|where=mods.domain=5 AND spawn_weights.tag in ("secret_area") AND mods.generation_type = 1 AND mods.required_level > 1 | |||
|spawn_weights=1 | |||
}} | |||
===Suffix=== | |||
{{Query spawnable modifiers | |||
|where=mods.domain=5 AND spawn_weights.tag in ("secret_area") AND mods.generation_type = 2 AND mods.required_level > 1 | |||
|spawn_weights=1 | |||
}} | |||
[[Category:Mod lists by domain]] | |||
Revision as of 20:04, 14 February 2022
List of vaal side area modifiers
Acts version
Prefix
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`,`cargo__mods`.`required_level` AS `mods.required_level`,`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`.`domain`=5 AND spawn_weights.tag in ("secret_area") AND `cargo__mods`.`generation_type` = 1 AND `cargo__mods`.`required_level` = 1) GROUP BY `cargo__mods`.`_pageID` ORDER BY `cargo__mods`.`domain`,`cargo__mods`.`generation_type`,`cargo__mods`.`mod_groups__full` ,`cargo__mods`.`mod_type`,`cargo__mods`.`required_level`,`cargo__mod_spawn_weights`.`ordinal` LIMIT 5000
.
Suffix
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`,`cargo__mods`.`required_level` AS `mods.required_level`,`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`.`domain`=5 AND spawn_weights.tag in ("secret_area") AND `cargo__mods`.`generation_type` = 2 AND `cargo__mods`.`required_level` = 1) GROUP BY `cargo__mods`.`_pageID` ORDER BY `cargo__mods`.`domain`,`cargo__mods`.`generation_type`,`cargo__mods`.`mod_groups__full` ,`cargo__mods`.`mod_type`,`cargo__mods`.`required_level`,`cargo__mod_spawn_weights`.`ordinal` LIMIT 5000
.
Map version
Prefix
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`,`cargo__mods`.`required_level` AS `mods.required_level`,`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`.`domain`=5 AND spawn_weights.tag in ("secret_area") AND `cargo__mods`.`generation_type` = 1 AND `cargo__mods`.`required_level` > 1) GROUP BY `cargo__mods`.`_pageID` ORDER BY `cargo__mods`.`domain`,`cargo__mods`.`generation_type`,`cargo__mods`.`mod_groups__full` ,`cargo__mods`.`mod_type`,`cargo__mods`.`required_level`,`cargo__mod_spawn_weights`.`ordinal` LIMIT 5000
.
Suffix
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`,`cargo__mods`.`required_level` AS `mods.required_level`,`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`.`domain`=5 AND spawn_weights.tag in ("secret_area") AND `cargo__mods`.`generation_type` = 2 AND `cargo__mods`.`required_level` > 1) GROUP BY `cargo__mods`.`_pageID` ORDER BY `cargo__mods`.`domain`,`cargo__mods`.`generation_type`,`cargo__mods`.`mod_groups__full` ,`cargo__mods`.`mod_type`,`cargo__mods`.`required_level`,`cargo__mod_spawn_weights`.`ordinal` LIMIT 5000
.