summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2011-04-01 12:58:40 +0200
committerYorhel <git@yorhel.nl>2011-04-01 12:58:40 +0200
commitebfeb4a90beb584aea17e821012e1975f9332031 (patch)
treea913e1aae60c3f3034876356b5c7a68a1a3f70ff
parent36fa28da9586d136448221918b277eec59bad917 (diff)
Multi::IRC: Don't spam the channel with old trait announcements
-rw-r--r--lib/Multi/IRC.pm4
1 files changed, 2 insertions, 2 deletions
diff --git a/lib/Multi/IRC.pm b/lib/Multi/IRC.pm
index 620e6a25..839911ff 100644
--- a/lib/Multi/IRC.pm
+++ b/lib/Multi/IRC.pm
@@ -172,7 +172,7 @@ sub _start {
$_[KERNEL]->post(pg => query => q|SELECT
(SELECT id FROM changes ORDER BY id DESC LIMIT 1) AS rev,
(SELECT id FROM tags ORDER BY id DESC LIMIT 1) AS tag,
- (SELECT id FROM traits ORDER BY id DESC LIMIT 1) AS tag,
+ (SELECT id FROM traits ORDER BY id DESC LIMIT 1) AS trait,
(SELECT date FROM threads_posts ORDER BY date DESC LIMIT 1) AS post|,
undef, 'notify_init');
@@ -299,7 +299,7 @@ sub notify { # name, pid, payload
WHERE tp.date > ? AND tp.num = 1
ORDER BY tp.date|
: $_[ARG0] eq 'newtrait' ? q|SELECT
- 'i' AS type, t.id, t.name AS title, u.username, t.id AS lastrait
+ 'i' AS type, t.id, t.name AS title, u.username, t.id AS lasttrait
FROM traits t
JOIN users u ON u.id = t.addedby
WHERE t.id > ?