1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
|
#!/usr/bin/perl
use warnings;
use strict;
use Carp qw(confess);
use CGI::Carp qw(fatalsToBrowser);
use Date::Simple qw(date);
use Encode::Guess;
use CGI;
use Encode;
use HTML::Template;
use Config::File;
use File::Slurp;
use lib 'lib';
use IrcLog qw(get_dbh gmt_today);
use IrcLog::WWW qw(http_header message_line my_encode);
use Cache::SizeAwareFileCache;
#use Data::Dumper;
# Configuration
# $base_url is the absoulte URL to the directoy where index.pl and out.pl live
# If they live in the root of their own virtual host, set it to "/".
my $conf = Config::File::read_config_file('cgi.conf');
my $base_url = $conf->{BASE_URL} || q{/};
# I'm too lazy right to move this to a config file, because Config::File seems
# unable to handle arrays, just hashes.
# map nicks to CSS classes.
my @colors = (
['TimToady', 'nick_timtoady'],
['audreyt', 'nick_audreyt'],
['evalbot', 'bots'],
['exp_evalbot', 'bots'],
['p6eval', 'bots'],
['lambdabot', 'bots'],
['pugs_svnbot', 'bots'],
['pugs_svn', 'bots'],
['specbot', 'bots'],
['speckbot', 'bots'],
['pasteling', 'bots'],
['rakudo_svn', 'bots'],
['purl', 'bots'],
['svnbotlt', 'bots'],
['dalek', 'bots'],
['hugme', 'bots'],
['garfield', 'bots'],
);
# additional classes for nicks, sorted by frequency of speech:
my @nick_classes = map { "nick$_" } (1 .. 9);
# Default channel: this channel will be shown if no channel=... arg is given
my $default_channel = 'perl6';
# End of config
my $q = new CGI;
my $dbh = get_dbh();
my $channel = $q->param('channel') || $default_channel;
my $date = $q->param('date') || gmt_today();
if ($date eq 'today') {
$date = gmt_today();
} elsif ($date eq 'yesterday') {
$date = date(gmt_today()) - 1;
}
if ($date eq gmt_today()) {
print http_header({ nocache => 1});
} else {
print http_header();
}
if ($channel !~ m/\A[.\w-]+\z/smx){
# guard against channel=../../../etc/passwd or so
confess 'Invalid channel name';
}
my $count;
{
my $sth = $dbh->prepare_cached('SELECT COUNT(*) FROM irclog WHERE day = ?');
$sth->execute($date);
$sth->bind_columns(\$count);
$sth->fetch();
$sth->finish();
}
{
my $cache_key = $channel . '|' . $date . '|' . $count;
# the average #perl6 day produces 100k to 400k of HTML, so with
# 50MB we have about 150 pages in the cache. Since most hits are
# the "today" page and those of the last 7 days, we still get a very
# decent speedup
# btw a cache hit is about 10 times faster than generating the page anew
my $cache = new Cache::SizeAwareFileCache( {
namespace => 'irclog',
max_size => 150 * 1048576,
} );
my $data = $cache->get($cache_key);
if (defined $data){
print $data;
} else {
$data = irclog_output($date, $channel);
$cache->set($cache_key, $data);
print $data;
}
}
sub irclog_output {
my ($date, $channel) = @_;
my $full_channel = q{#} . $channel;
my $t = HTML::Template->new(
filename => 'template/day.tmpl',
loop_context_vars => 1,
global_vars => 1,
die_on_bad_params => 0,
);
$t->param(ADMIN => 1) if ($q->param('admin'));
{
my $clf = "channels/$channel.tmpl";
if (-e $clf) {
$t->param(CHANNEL_LINKS => q{} . read_file($clf));
}
}
$t->param(BASE_URL => $base_url);
my $self_url = $base_url . "/$channel/$date";
my $db = $dbh->prepare('SELECT id, nick, timestamp, line FROM irclog '
. 'WHERE day = ? AND channel = ? AND NOT spam ORDER BY id');
$db->execute($date, $full_channel);
# determine which colors to use for which nick:
{
my $count = scalar @nick_classes + scalar @colors + 1;
my $q1 = $dbh->prepare('SELECT nick, COUNT(nick) AS c FROM irclog'
. ' WHERE day = ? AND channel = ? AND not spam'
. " GROUP BY nick ORDER BY c DESC LIMIT $count");
$q1->execute($date, $full_channel);
while (my @row = $q1->fetchrow_array and @nick_classes){
next unless length $row[0];
my $n = quotemeta $row[0];
unless (grep { $_->[0] =~ m/\A$n/smx } @colors){
push @colors, [$row[0], shift @nick_classes];
}
}
# $t->param(DEBUG => Dumper(\@colors));
}
my @msg;
my $line = 1;
my $prev_nick = q{};
my $c = 0;
# populate the template
my $line_number = 0;
while (my @row = $db->fetchrow_array){
my $id = $row[0];
my $nick = decode('utf8', ($row[1]));
my $timestamp = $row[2];
my $message = $row[3];
next if $message =~ m/^\s*\[off\]/i;
push @msg, message_line( {
id => $id,
nick => $nick,
timestamp => $timestamp,
message => $message,
line_number => ++$line_number,
prev_nick => $prev_nick,
colors => \@colors,
self_url => $self_url,
channel => $channel,
},
\$c,
);
$prev_nick = $nick;
}
$t->param(
CHANNEL => $channel,
MESSAGES => \@msg,
DATE => $date,
);
# check if previous/next date exists in database
{
my $q1 = $dbh->prepare('SELECT COUNT(*) FROM irclog '
. 'WHERE channel = ? AND day = ? AND NOT spam');
# Date::Simple magic ;)
my $tomorrow = date($date) + 1;
$q1->execute($full_channel, $tomorrow);
my ($res) = $q1->fetchrow_array();
if ($res){
my $next_url = $base_url . "$channel/$tomorrow";
# where the hell does the leading double slash come from?
$next_url =~ s{^//+}{/};
$t->param(NEXT_URL => $next_url);
}
my $yesterday = date($date) - 1;
$q1->execute($full_channel, $yesterday);
($res) = $q1->fetchrow_array();
if ($res){
my $prev_url = $base_url . "$channel/$yesterday";
$prev_url =~ s{^//+}{/};
$t->param(PREV_URL => $prev_url);
}
}
return my_encode($t->output);
}
# vim: sw=4 ts=4 expandtab
|
