diff options
| author | Aleksey Lim <alsroot@member.fsf.org> | 2010-09-13 01:00:00 (GMT) |
|---|---|---|
| committer | Aleksey Lim <alsroot@member.fsf.org> | 2010-09-13 01:00:00 (GMT) |
| commit | a6b73a1741f0b9e3dd61435958a44fc153221390 (patch) | |
| tree | f90236d27c0c6fcd82fbd76d31313bfda2fdc7f1 | |
| parent | ed52d9ab8f5a5b95fa9602cd876d547e5cfcae82 (diff) | |
Hide empty nick message on channel index page
| -rwxr-xr-x | cgi/channel-index.pl | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/cgi/channel-index.pl b/cgi/channel-index.pl index 7771120..19c9075 100755 --- a/cgi/channel-index.pl +++ b/cgi/channel-index.pl @@ -67,8 +67,8 @@ sub get_channel_index { # we are evil and create a calendar entry for month between the first # and last date - my $get_dates = 'SELECT DISTINCT day FROM irclog WHERE nick IS NOT NULL '. - 'AND channel = ? '. + my $get_dates = 'SELECT DISTINCT day FROM irclog WHERE channel = ? '. + 'AND LENGTH(nick) > 0 ' . ($meetings ? 'AND meeting IS NOT NULL ' : ''). 'ORDER BY day'; my $dates = $dbh->selectcol_arrayref($get_dates, undef, '#' . $channel); |