og峹byz[] PttBlog, ̫᪺sפΪO:
$Id$

Ъ`N,  PttBlogӥDnO]p Ptt2 xϥ, ثeb}oq,
åYK, iٯʤ֫ܦh\, HΥi঳\h bug.

ziHӤUCBJw˦n PttBlog.
1.w˦nUCF, ڭ̨æPɦCW FreeBSD portsؿ:
	apache		/usr/ports/www/apache13/
	perl		/usr/ports/lang/perl5.8/
	mod_perl	/usr/ports/www/mod_perl/
	mysql		/usr/ports/databases/mysql323-server/

  HΤUC module
	Template	/usr/ports/www/p5-Template-Toolkit/
	Date::Calc	/usr/ports/devel/p5-Date-Calc/
	DBI		/usr/ports/databases/p5-DBI/
	DBD::mysql	/usr/ports/databases/p5-DBD-mysql/
	MD5		/usr/ports/security/p5-MD5/
	Mail::Sender	/usr/ports/mail/p5-Mail-Sender/
	OurNet::FuzzyIndex (٨Si ports, Х cpan )

2.]w apache iHzL mod_perl Ӷ] perl script .
  bz apache.conf (or httpd.conf), ӷ|:
	LoadModule perl_module        libexec/apache/libperl.so
	AddModule mod_perl.c
  b<IfModule mod_mime.c></IfModule>, [Wo:
	AddHandler perl-script .pl
	PerlHandler Apache::Registry

3.]wn blog  webؿ. ̭ܤ֭n index.pl, blog.pl, LocalVars.pm
   (䤤 LocalVars.pm ĳ symbolic link  /home/bbs/bin/@)
  䤤 *.pl vnOiH檺 (ex: chmod 755 *.pl)

4.]w apache  blog ؿ. ñNӥؿ}l ExecCGI option.
  Ҧpϥ Virtual Host :
	NameVirtualHost *
	<VirtualHost *>
		ServerName	blog.ptt2.cc
		DocumentRoot	/home/bbs/blog/web
		<Directory "/home/bbs/blog/web">
			Options ExecCGI
		</Directory>
	</VirtualHost>

5.N builddb.pl, BBSFileHeader.pm i ~bbs/bin
  ziHե perl -c ~bbs/bin/builddb.pl  լݬݯणL.
  Y檺, q`O LocalVars.pm ̭֪F,
  аѦ pttbbs/sample/LocalVars.pm  blog .

6.Ѧ pttbbs/sample/pttbbs.conf, bz pttbbs.conf[J
  BLOGDB_HOST, BLOGDB_USER, BLOGDB_PASSWD, BLOGDB_DB, BLOGDB_PORT, BLOGDB_SOCK
  åBs compile mbbsd, b make ɥ[J WITH_BLOG=yes .
  M install åB restart

7. Mysql@nU table (iHƻsLh])
	CREATE TABLE `comment` (
	  `brdname` varchar(13) NOT NULL default '',
	  `artid` int(11) NOT NULL default '0',
	  `name` varchar(32) NOT NULL default '',
	  `mail` varchar(64) NOT NULL default '',
	  `content` text NOT NULL,
	  `mtime` int(11) NOT NULL default '0',
	  `hash` varchar(32) NOT NULL default ''
	) TYPE=MyISAM;

	CREATE TABLE `counter` (
	  `k` char(32) NOT NULL default '',
	  `v` int(11) NOT NULL default '0',
	  `mtime` int(11) NOT NULL default '0',
	  PRIMARY KEY  (`k`)
	) TYPE=MyISAM;

	CREATE TABLE `wcounter` (
	  `k` char(32) NOT NULL default '',
	  `v` int(11) NOT NULL default '0',
	  `mtime` int(11) NOT NULL default '0',
	  PRIMARY KEY  (`k`)
	) TYPE=MyISAM;
