diff options
author | Yorhel <git@yorhel.nl> | 2019-06-27 13:39:23 +0200 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2019-06-27 13:39:25 +0200 |
commit | 0096b8af096ce08ef7ebb6bb5e8f91a4a6042d8a (patch) | |
tree | 59419893bd7fd0fa7f608f54491b068584b38980 /lib/Multi/IRC.pm | |
parent | 7eacaba4ab19e4a57d02e0ac35f66bb10e85823a (diff) |
Add support for "private" threads
Currently a mod-only feature. Each thread now has a 'private' flag
which, when set, will make the thread visible only to users mentioned in
the boards.
Diffstat (limited to 'lib/Multi/IRC.pm')
-rw-r--r-- | lib/Multi/IRC.pm | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/lib/Multi/IRC.pm b/lib/Multi/IRC.pm index b1be1a24..b9b8a035 100644 --- a/lib/Multi/IRC.pm +++ b/lib/Multi/IRC.pm @@ -297,7 +297,7 @@ sub handleid { $t eq 'p' ? 'p.name AS title FROM producers p WHERE p.id = $2' : $t eq 'c' ? 'c.name AS title FROM chars c WHERE c.id = $2' : $t eq 's' ? 'sa.name AS title FROM staff s JOIN staff_alias sa ON sa.aid = s.aid AND sa.id = s.id WHERE s.id = $2' : - $t eq 't' ? 'title, '.$GETBOARDS.' FROM threads t WHERE id = $2' : + $t eq 't' ? 'title, '.$GETBOARDS.' FROM threads t WHERE NOT t.hidden AND NOT t.private AND t.id = $2' : $t eq 'g' ? 'name AS title FROM tags WHERE id = $2' : $t eq 'i' ? 'name AS title FROM traits WHERE id = $2' : $t eq 'd' ? 'title FROM docs WHERE id = $2' : @@ -312,7 +312,7 @@ sub handleid { $t eq 'c' ? 'ch.name AS title, u.username, c.comments FROM changes c JOIN chars_hist ch ON c.id = ch.chid JOIN users u ON u.id = c.requester WHERE c.type = \'c\' AND c.itemid = $2 AND c.rev = $3' : $t eq 's' ? 'sah.name AS title, u.username, c.comments FROM changes c JOIN staff_hist sh ON c.id = sh.chid JOIN users u ON u.id = c.requester JOIN staff_alias_hist sah ON sah.chid = c.id AND sah.aid = sh.aid WHERE c.type = \'s\' AND c.itemid = $2 AND c.rev = $3' : $t eq 'd' ? 'dh.title, u.username, c.comments FROM changes c JOIN docs_hist dh ON c.id = dh.chid JOIN users u ON u.id = c.requester WHERE c.type = \'d\' AND c.itemid = $2 AND c.rev = $3' : - 't.title, u.username, '.$GETBOARDS.' FROM threads t JOIN threads_posts tp ON tp.tid = t.id JOIN users u ON u.id = tp.uid WHERE t.id = $2 AND tp.num = $3'), + 't.title, u.username, '.$GETBOARDS.' FROM threads t JOIN threads_posts tp ON tp.tid = t.id JOIN users u ON u.id = tp.uid WHERE NOT t.hidden AND NOT t.private AND t.id = $2 AND tp.num = $3'), [ $t, $id, $rev], $c if $rev && $t =~ /[dvprtcs]/; } @@ -359,7 +359,7 @@ sub notify { FROM threads_posts tp JOIN threads t ON t.id = tp.tid JOIN users u ON u.id = tp.uid - WHERE tp.date > $1 AND tp.num = 1 + WHERE tp.date > $1 AND tp.num = 1 AND NOT t.hidden AND NOT t.private ORDER BY tp.date}, trait => q{ SELECT 'i' AS type, t.id, t.name AS title, u.username, t.id AS lastid |