diff options
author | Yorhel <git@yorhel.nl> | 2011-04-01 12:58:40 +0200 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2011-04-01 12:58:40 +0200 |
commit | ebfeb4a90beb584aea17e821012e1975f9332031 (patch) | |
tree | a913e1aae60c3f3034876356b5c7a68a1a3f70ff | |
parent | 36fa28da9586d136448221918b277eec59bad917 (diff) |
Multi::IRC: Don't spam the channel with old trait announcements
-rw-r--r-- | lib/Multi/IRC.pm | 4 |
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 > ? |