<?php
include("krt.php3");
require("bbs.ini");
require("dbconnect.ini");

$default_span = $ini_treerows;

$d = new DbConnect($ini_dbname);

echo "<html>";
echo "<meta http-equiv=\"Content-Type\" CONTENT=\"text/html; charset=EUC-JP\">";
echo "<body bgcolor=\"$ini_bodycolor\">";
echo "<center>";
// 
if($ini_treeheader) {
	echo "<img src=$ini_treeheader><p></p>";
}
if($ini_preface) {
	echo $ini_preface;
}
//


$sql = "select count(*) from $ini_table";
$result = @pg_exec($sql);
if($result == false) {
    printf("ツリーが表示できません。code=-1");
}
$totalrec = pg_result($result,0,0);

echo "<font size=-1>";
echo "<a href=\"$ini_sitehome\" target=\"_top\">[HOME]</a>&nbsp;";
echo "<a href=\"#newentry\" >新しいメッセージを投稿する</a>&nbsp;";
echo "<a href=\"index.php3\">最新の情報に更新</a>&nbsp;";
echo "<a href=\"#search\">キーワード検索</a>";
echo "</font>";
echo "<br>";

echo "<P></P>";

echo "<font size=-2>";
if($offset >= $default_span) {
	$prevoffset = $offset - $default_span;
    echo "<a href=\"index.php3?offset=$prevoffset\">前の $default_span 件を表示</a>";
	echo "&nbsp;<a href=\"index.php3\">ツリーの先頭を表示</a>&nbsp;";
}
$nextoffset = $offset + $default_span;
if($nextoffset < $totalrec) {
    $disprec = $totalrec - $nextoffset > $default_span ? $default_span : $totalrec - $nextoffset;
    echo "<a href=\"index.php3?offset=$nextoffset\">次の $disprec 件を表示</a>";
}
echo "</font>";
echo "<br>";
$sql = "select id,thread_id,day,title,author from $ini_table order by substring(thread_id from 1 for 8)desc ,substring(thread_id from 9) limit $default_span";

if ($offset) {
	$sql .= " offset $offset";
}

$result = pg_exec($sql);
if($result == false) {
	printf("ツリーが表示できません。code=-2");
	exit;
}
$rows = pg_numrows($result);


echo "<table bordercolor=\"$ini_titlecolor\">\n";

print("<tr bgcolor=\"$ini_titlecolor\">");
print("<th></th><!---<th>ID</th>--><th>タイトル</th><th>投稿者</th><th>投稿日</th>");
print("</tr>\n");
$prev_thread = "00000000";
for($i = 0; $i < $rows; $i ++) {
	$id = pg_result($result,$i,0);
	$anchor = "<a href=\"bbsarticle.php3?id=" .$id ."\">";
	$thread_id = pg_result($result,$i,1);
	$title = pg_result($result,$i,3);
	$day=pg_result($result,$i,2);
	$author = pg_result($result,$i,4);
 
	$depth = 0;
	for($pos = 28; $pos > 7 ; $pos -= 2) {
		$num = substr($thread_id,$pos,2);
		if(0 == strcmp($num,"00")) {
			$depth ++;
		} else {
			break;
		}
	}
	$depth = 11 - $depth;
	$titleheader = substr("----------------------",0,$depth);
	$titleheader = "<b>" . $titleheader ."</b>&nbsp;";

	$current_thread = substr($thread_id,0,8);
	if(strcmp($prev_thread,$current_thread) != 0) {
		if($col_id) {
			echo "<tr bgcolor=\"$ini_articlecolor\">";
			echo "<td><a href=\"bbsarticle.php3?thread=$prev_thread\">☆</a></td>";
			echo "<!--<td>$col_id</td>--><td>$col_title</td><td>$col_author</td><td>$col_day</td></tr>\n";
			$col_thread = "";
			$col_id = "";
			$col_title = "";
			$col_day = "";
			$col_author = "";
		}
		$prev_thread = $current_thread;
	}

	//if(!$col_thread)$col_thread = $id;
	$col_id .= $anchor . $id . "</a><br>";
	$col_title .= $titleheader . $anchor . $title . "</a><br>";
	$col_day .= $anchor . $day . "</a><br>";
	$col_author .= $anchor . $author . "</a><br>";

}
if($col_id) {
		echo "<tr bgcolor=\"$ini_articlecolor\">";
		echo "<td><a href=\"bbsarticle.php3?thread=$current_thread\">☆</a></td>";
		echo "<!--<td>$col_id</td>--><td>$col_title</td><td>$col_author</td><td>$col_day</td></tr>\n";
}
echo "</table>";


pg_freeresult($result);
$d->doClose();

if($ini_treefooter) {
	echo "<p><a href=\"../index.shtml\" target=\"_top\"><img src=\"$ini_treefooter\" border=0></a></p>";
}

?>
<a name="newentry">

<hr width="50%">
<table border="0" cellpadding="3" width="400" bgcolor="<?php echo $ini_titlecolor?>">
    <tr>
        <?php echo "<td><b>新規投稿</b></td>";?>
    </tr>
</table>

<?php
if($err){
	print("<ul>");
	if($titleerr) print("<li>" . $titleerr . "<br>");
	if($authorerr) print("<li>" . $authorerr . "<br>");
	if($messageerr) print("<li>" . $messageerr . "<br>");
	if($othererr) print("<li>" . $othererr . "<br>");
	print("</ul>");
} else {
	echo "□管理者の判断で削除させていただく場合があります。";
}
?>
<form method="post" action="bbspost.php3">
    <table border="0" width="400">
        <tr>
            <td align="center" bgcolor="<?php echo $ini_titlecolor ?>">件名</td>
			<?php
            	echo "<td><input type=\"text\" size=\"40\" name=\"title\"></td>";
			?>
        </tr>
        <tr>
            <td align="center" bgcolor="<?php echo $ini_titlecolor ?>" nowrap>氏名</td>
            <td><input type="text" size="40" name="author" value=<?php if($err) echo $author ?>></td>
        </tr>
        <tr>
	<td align="center" bgcolor="<?php echo $ini_titlecolor ?>" nowrap>Eメール(省略可能) </td>
            <td><input type="text" size="40" name="mail" value=<?php if($err) echo $mail ?>></td>
        </tr>
        <tr>
			<td colspan="2" bgcolor="<?php echo $ini_titlecolor ?>"> メッセージをどうぞ： <br>
			<?php
			if($replyto && !$err) {
            	echo "<textarea name=\"message\" rows=\"10\" cols=\"50\">" . eregi_replace("^|\n","\n&gt; ",$message) . "</textarea>";
			} else {
            	echo "<textarea name=\"message\" rows=\"10\" cols=\"50\">$message</textarea>";
			}
			?>
			</td>
        </tr>
        <tr>
            <td align="center" nowrap></td>
			<?php
			if($replyto) {
				echo "<input type=hidden name=replyto value=$replyto>";
				echo "<input type=hidden name=orig_thread value=$thread_id>";
				echo "<input type=hidden name=orig_title value=$orig_title>";
			}
			?>
            <td><input type="submit" name="submit" value="投稿">
			<input type="reset" name="reset" value="リセット"></td>
        </tr>
    </table>
</form>

<?php
if($ini_treefooter) {
	echo "<p><a href=\"../index.shtml\" target=\"_top\"><img src=\"$ini_treefooter\" border=0></a></p>";
}
?>

<hr width="50%">
<a name="search">
<font size=+1><b><?php echo $ini_bbsname; ?>キーワード検索</b></font>
<p>
<table width="450"><tr><td>
<form method="post" action="search/search.php3" enctype="text/plain; charset=euc-jp">
キーワードを入力してください：<br>
<input type="text" size="20" name="keyword">
<input type="radio" name="andor" value="and" checked>の全て含む&nbsp;<input type="radio" name="andor" value="or">の何れかを含む<br>
<p>
<input type="submit" name="submit" value="検索">
<input type="reset" name="reset" value="リセット">
</p>
<font size=-1>
<p>
●キーワードを複数入力する時はスペースで区切ってください。<br>
●<a href="http://search.yahoo.co.jp/bin/search?p=%C0%B5%B5%AC%C9%BD%B8%BD" target="yahoo">正規表現</a>が使えます。(POSIX 1003.2 basic 準拠)<br>
</p>
</font>
</form>
</td></tr></table>
</P>
</center>

</body>
</html>

