summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorschneefux <schneefux+commit@schneefux.xyz>2017-07-05 17:08:08 +0200
committerschneefux <schneefux+commit@schneefux.xyz>2017-07-05 17:08:08 +0200
commit0ed167ceaf1d32678b2887e56e3527ea4c0e46f6 (patch)
tree58a603453db7d697eaec86f4a673d7b716d49977
parent115b84b82063fe6d66f10f2d8469a46f6c678f9a (diff)
downloadcruncher-0ed167ceaf1d32678b2887e56e3527ea4c0e46f6.tar.gz
cruncher-0ed167ceaf1d32678b2887e56e3527ea4c0e46f6.zip
builds: do not cross role, daily; cross everything else
-rw-r--r--crunch_global.sql3
1 files changed, 1 insertions, 2 deletions
diff --git a/crunch_global.sql b/crunch_global.sql
index 1205dfc..787725c 100644
--- a/crunch_global.sql
+++ b/crunch_global.sql
@@ -42,8 +42,7 @@ join skill_tier st on ((p.skill_tier between st.start and st.end and s.show_in_w
join build b on (( -- only per patch global
s.show_in_web = true and
gm.name = 'all' and
- st.name = 'all' and
- reg.name = 'all' and
+ r.name = 'all' and
(
(b.item_1 is null or p_s.item_grants rlike concat(:build_regex_start, b.item_1, ';', b.item_1_count, :build_regex_end)) and