diff options
| author | Yorhel <git@yorhel.nl> | 2009-08-09 09:57:22 +0200 |
|---|---|---|
| committer | Yorhel <git@yorhel.nl> | 2009-08-09 10:12:06 +0200 |
| commit | f0417c6752873c4d6191c7b5f90ac4e44853fd55 (patch) | |
| tree | cfd3d7033c3564e04ac2f8c5458683b64f68f485 /lib/Multi/IRC.pm | |
| parent | bf4ee54dbc1a3d6a358883baedde7602a8232da4 (diff) | |
Converted changes.added to timestamptz
That was the last one. I hope I haven't forgotten to update anything.
Diffstat (limited to 'lib/Multi/IRC.pm')
| -rw-r--r-- | lib/Multi/IRC.pm | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/lib/Multi/IRC.pm b/lib/Multi/IRC.pm index 8c5d4143..6b3a1dbb 100644 --- a/lib/Multi/IRC.pm +++ b/lib/Multi/IRC.pm @@ -261,7 +261,7 @@ sub notify { # name, pid, payload LEFT JOIN releases_rev rr ON c.type = 1 AND c.id = rr.id LEFT JOIN producers_rev pr ON c.type = 2 AND c.id = pr.id JOIN users u ON u.id = c.requester - WHERE c.added > ? + WHERE c.added > to_timestamp(?) ORDER BY c.added| : $_[ARG0] eq 'newpost' ? q|SELECT 't' AS type, tp.tid AS id, tp.num AS rev, t.title, u.username, |.GETBOARDS.q| |