#!/usr/bin/perl # $Id: blog.pl,v 1.29 2003/07/08 04:09:36 in2 Exp $ use CGI qw/:standard/; use lib qw/./; use LocalVars; use DB_File; use strict; use Data::Dumper; use Date::Calc qw(:all); use Template; use HTML::Calendar::Simple; use OurNet::FuzzyIndex; use DBI; use DBD::mysql; use POSIX; use MD5; use vars qw/@emonth @cnumber %config %attr %article %th $dbh $brdname/; sub main { my($fn, $y, $m, $d); my($tmpl); $dbh = undef; @emonth = ('', 'January', 'February', 'March', 'April', 'May', 'June', 'July', 'August', 'September', 'October', 'November', 'December'); @cnumber = ('零', '一', '二', '三', '四', '五', '六', '七', '八', '九', '十', '十一', '十二'); if( !$ENV{PATH_INFO} ){ print header(-status => 400); return; } if( !(($brdname, $fn) = $ENV{PATH_INFO} =~ m|^/([\w\-]+?)/([\.,\w]*)$|) || !( ($fn, $y, $m, $d) = parsefn($fn) ) || !(-e "$BLOGDATA/$brdname/$fn") || !(tie %config, 'DB_File', "$BLOGDATA/$brdname/config.db", O_RDONLY, 0666, $DB_HASH) || !(tie %attr, 'DB_File', "$BLOGDATA/$brdname/attr.db", O_RDONLY, 0666, $DB_HASH) ){ return redirect("/blog.pl/$1/") if( $ENV{PATH_INFO} =~ m|^/([\w\-]+?)$| ); print header(-status => 404); return; } charset(''); print header(-type => GetType($fn)); $fn ||= 'index.html'; # first, import all settings in %config %th = %config; $th{BOARDNAME} = $brdname; $th{key} = $y * 10000 + $m * 100 + $d; # loadBlog --------------------------------------------------------------- tie %article, 'DB_File', "$BLOGDATA/$brdname.db", O_RDONLY, 0666, $DB_HASH; if( $attr{"$fn.loadBlog"} =~ /article/i ){ AddArticle('blog', $attr{"$fn.loadBlogFields"}, packdate($y, $m, $d)); } elsif( $attr{"$fn.loadBlog"} =~ /monthly/i ){ my($s, $y1, $m1, $d1); for( ($y1, $m1, $d1) = ($y, $m, 32) ; $d1 > 0 ; --$d1 ){ AddArticle('blog', $attr{"$fn.loadBlogFields"}, packdate($y1, $m1, $d1)); } } elsif( $attr{"$fn.loadBlog"} =~ /^last(\d+)/i ){ my($ptr, $i); for( $ptr = $article{last}, $i = 0 ; $ptr && $i < $1 ; $ptr = $article{"$ptr.prev"}, ++$i ){ AddArticle('blog', $attr{"$fn.loadBlogFields"}, $ptr); } } elsif( $attr{"$fn.loadBlog"} =~ /FuzzySearch/i ){ my $idx = OurNet::FuzzyIndex->new("$BLOGDATA/$brdname.idx"); my %result = $idx->query($th{SearchKey} = param('SearchKey'), MATCH_FUZZY); foreach my $t (sort { $result{$b} <=> $result{$a} } keys(%result)) { AddArticle('blog', $attr{"$fn.loadBlogFields"}, $idx->getkey($t), sprintf("%5.1f", $result{$t} / 10)); } } if( $attr{"$fn.loadBlogPrevNext"} ){ my $s = packdate($y, $m, $d); AddArticle('next', $attr{"$fn.loadBlogPrevNext"}, $article{"$s.next"}); AddArticle('prev', $attr{"$fn.loadBlogPrevNext"}, $article{"$s.prev"}); } # loadArchives ----------------------------------------------------------- if( $attr{"$fn.loadArchives"} =~ /^monthly/i ){ # 找尋 +-1 year 內有資料的月份 my($c, $y1, $m1); for( $c = 0, ($y1, $m1) = ($y + 1, $m) ; $c < 48 ; ++$c, --$m1 ) { if( $m1 == 0 ){ $m1 = 12; --$y1; } if( $article{ sprintf('%04d%02d', $y1, $m1) } ){ push @{$th{Archives}}, {year => $y1, month => $m1, emonth => $emonth[$m1], cmonth => $cnumber[$m1], key => packdate($y1, $m1, 1)}; } } } # loadRecentEntries ------------------------------------------------------ if( $attr{"$fn.loadRecentEntries"} ){ my($i, $ptr, $y, $m, $d); print $attr{"$fn.loadRecentEntries:"}; for( $i = 0, $ptr = $article{'last'} ; $ptr && $i < $attr{"$fn.loadRecentEntries"} ; ++$i, $ptr = $article{"$ptr.prev"} ){ ($y, $m, $d) = unpackdate($ptr); push @{$th{RecentEntries}}, {year => $y, month => $m, emonth => $emonth[$m], cmonth => $cnumber[$m], title => $article{"$ptr.title"}, key => $ptr}; } } # topBlogs my($t); foreach $t ( ['loadTopBlogs', 'v', 'topBlogs'], ['loadRandomBlogs', 'RAND()', 'randomBlogs'] ){ if( $attr{"$fn.$t->[0]"} ){ dodbi(sub { my($dbh) = @_; my($sth); $sth = $dbh->prepare("select k, v from counter ". "order by $t->[1] desc ". ($attr{"$fn.$t->[0]"} eq 'all' ? '' : 'limit 0,'. $attr{"$fn.$t->[0]"})); $sth->execute(); while( $_ = $sth->fetchrow_hashref() ){ push @{$th{$t->[2]}}, {brdname => $_->{k}, counter => $_->{v}}; } }); } } # Counter ---------------------------------------------------------------- if( $attr{"$fn.loadCounter"} ){ $th{counter} = dodbi(sub { my($dbh) = @_; my($sth, $t, $time); $time = time(); $dbh->do("update counter set v = v + 1, mtime = $time ". "where k = '$brdname' && mtime < ". ($time - 2)); $sth = $dbh->prepare("select v from counter where k='$brdname'"); $sth->execute(); $t = $sth->fetchrow_hashref(); return $t->{v} if( $t->{v} ); $dbh->do("insert into counter (k, v) ". "values ('$brdname', 1)"); return 1; }); } # Calendar --------------------------------------------------------------- if( $attr{"$fn.loadCalendar"} ){ # 沒有合適的 module , 自己寫一個 |||b my($c, $week, $day, $t, $link, $newtr); $c = ("\n". "\n". "\n"); $c .= ("\n") foreach( ['Sunday', 'Sun'], ['Monday', 'Mon'], ['Tuesday', 'Tue'], ['Wednesday', 'Wed'], ['Thursday', 'Thu'], ['Friday', 'Fri'], ['Saturday', 'Sat'] ); $week = Day_of_Week($y, $m, 1); $c .= "\n\n"; if( $week == 7 ){ $week = 0; } else{ $c .= ("\n") foreach( 1..$week ); } foreach( 1..31 ){ last if( !check_date($y, $m, $_) ); $c .= "\n" if( $newtr ); $c .= "\n"; if( ++$week == 7 ){ $c .= "\n\n"; $week = 0; $newtr = 1; } else{ $newtr = 0; } } $c .= "\n" if( !$newtr ); $c .= "
$emonth[$m] $y
[0]\" align=\"center\">". "$_->[1]
". " 
"; $t = packdate($y, $m, $_); if( !$article{"$t.title"} ){ $c .= "$_"; } else{ my $link = $attr{"$fn.loadCalendar"}; $link =~ s/\[\% key \%\]/$t/g; $c .= "$_"; } $c .= "
\n"; $th{calendar} = $c; #my $cal = HTML::Calendar::Simple->new({month => $m, year => $y}); #$th{calendar} = $cal->calendar_month; } # Comments --------------------------------------------------------------- if( $attr{"$fn.loadRecentComments"} ){ dodbi(sub { my($dbh) = @_; my($sth, $t); $sth = $dbh->prepare("select artid,name,mail,mtime ". "from comment ". "where brdname='$brdname' ". "order by mtime desc ". "LIMIT 0,". $attr{"$fn.loadRecentComments"}); $sth->execute(); while( $t = $sth->fetchrow_hashref() ){ $t->{title} = $article{"$t->{artid}.title"}; $t->{key} = $t->{artid}; $t->{time} = POSIX::strftime('%D', localtime($t->{mtime})); push @{$th{RecentComments}}, $t; } }); } if( $attr{"$fn.loadComments"} ){ my($name, $mail, $comment) = (param('name'), param('mail'), param('comment')); if( $name && $comment ){ dodbi(sub { my($dbh) = @_; my($t, $hash); $t = time(); $name = $dbh->quote($name); $mail = $dbh->quote($mail); $comment = $dbh->quote($comment); $hash = MD5->hexhash("$t$th{key}$name$mail$comment"); $dbh->do('insert into comment '. '(brdname, artid, name, mail, content, mtime, hash) '. "values ('$brdname', '$th{key}', $name, $mail, ". "$comment, '$t', '$hash')"); }); } dodbi(sub { my($dbh) = @_; my($sth, $t); $sth = $dbh->prepare("select mtime,name,mail,content,hash ". "from comment ". "where brdname='$brdname'&&artid='$th{key}' ". "order by mtime desc"); $sth->execute(); while( $t = $sth->fetchrow_hashref() ){ $t->{time} = POSIX::ctime($t->{mtime}); $t->{content} = applyfilter($t->{content}, $config{outputfilter}); push @{$th{comment}}, $t; } }); } # 用 Template Toolkit 輸出 mkdir "$BLOGCACHE/$brdname"; $tmpl = Template->new({INCLUDE_PATH => '.', ABSOLUTE => 0, RELATIVE => 0, RECURSION => 0, EVAL_PERL => 0, COMPILE_EXT => '.pl', COMPILE_DIR => "$BLOGCACHE/$brdname/", }); chdir "$BLOGDATA/$brdname/"; $tmpl->process($fn, \%th) || print "
template error: ". $tmpl->error();
    $dbh->disconnect() if( $dbh );
}

sub AddArticle($$$;$)
{
    my($cl, $fields, $s, $score) = @_;
    my($content, $short, $nComments) = ();
    $content = applyfilter($article{"$s.content"}, $config{outputfilter})
	if( $fields =~ /content/i );

    $short = applyfilter($article{"$s.short"}, $config{outputfilter})
	if( $fields =~ /short/i );

    if( $fields =~ /nComments/i ){
	$nComments = dodbi(sub {
	    my($dbh) = @_;
	    my $sth = $dbh->prepare("select count(*) from comment ".
				    "where brdname='$brdname'&&artid='$s'");
	    $sth->execute();
	    return $sth->fetchrow_hashref()->{'count(*)'};
	}) || 0;
    }

    my($y, $m, $d) = unpackdate($s);
    push @{$th{$cl}}, {year   => $y,
		       month  => $m,
		       emonth => $emonth[$m],
		       cmonth => $cnumber[$m],
		       day    => $d,
		       key    => $s,
		       title  => (($fields !~ /title/i) ? '' :
				  $article{"$s.title"}),
		       content=> $content,
		       author => (($fields !~ /author/i) ? '' :
				  $article{"$s.author"}),
		       short  => $short,
		       score  => $score,
		       nComments => $nComments,
		   }
        if( $article{"$s.title"} );
}

sub applyfilter($$)
{
    my($c, $filter) = @_;
    foreach( split(',', $filter) ){
	if( /^generic$/i ){
	    $c =~ s/\n/
\n/gs; } elsif( /^strict$/i ){ $c =~ s/\/>/gs; $c =~ s/\"/"/gs; $c =~ s/\'/'/gs; $c =~ s/ / /gs; } elsif( /^ubb$/i ){ $c =~ s|\[url\](.*?)\[/url\]|$1|gsi; $c =~ s|\[url=(.*?)\](.*?)\[/url\]|$2|gsi; $c =~ s|\[email\](.*?)\[/email\]|$1|gsi; $c =~ s|\[b\](.*?)\[/b\]|$1|gsi; $c =~ s|\[i\](.*?)\[/i\]|$1|gsi; $c =~ s|\[img\](.*?)\[/img\]|(null)|gsi; } } return $c; } sub parsefn($) { my($fs) = @_; return ("$1.$3", unpackdate($2)) if( $fs =~ /^(.*),(\w+)\.(.*)$/ ); return ($fs, Today()); } sub GetType($) { my($f) = @_; return 'text/css' if( $f =~ /.css$/i ); return 'text/html'; } sub packdate($$$) { return $_[0] * 10000 + $_[1] * 100 + $_[2]; } sub unpackdate($) { return (int($_[0] / 10000), (int($_[0] / 100)) % 100, $_[0] % 100); } sub dodbi { my($func) = @_; my($ret); my $dbh = DBI->connect("DBI:mysql:database=$BLOGdbname;". "host=$BLOGdbhost", $BLOGdbuser, $BLOGdbpasswd, {'RaiseError' => 1}) if( !$dbh ); eval { $ret = &{$func}($dbh); }; print "SQL: $@\n" if( $@ ); return $ret; } main(); 1;