<?
session_start();
include("include/config.php");
//connect sever
$link=mysql_connect($db_sever,$db_user,$db_pass)or die("無法連接資料庫");
mysql_select_db($db,$link)or die("選擇的資料庫不存在");
$date=date("y-m-d");
//插入留言資料
if($insert==yes){
if(md5($_POST[authkey])==$_SESSION[se_auth_num]){
$query_insert="INSERT INTO $post_table (p_name, p_email, p_content, p_date, p_web, p_private ,p_time) VALUES ('$name','$mail', '$content', '$date', '$web', '$private' ,'$post_time')";
$result=mysql_query($query_insert)or die("插入資料表失敗");
echo "<script>
javascript:alert('完成留言');
location.href=\"main.php\";
</script>";
exit();
}else{
echo "<script>
javascript:alert('驗證碼錯誤');
</script>";
}
}
########################記入私人留言cookie###############################
if(!($_COOKIE["aurabbs"])){
$time=time();
setcookie("aurabbs","$time",time()+311040000);
}else{
$time=$_COOKIE["aurabbs"];
}
#####記入驗證號碼#####
srand((double)microtime()*1000000);
$auth_num=rand()%10000;
session_register("se_auth_num");
$_SESSION[se_auth_num]=md5($auth_num);
###登出###
if($logout==true){
session_destroy();
echo "<div align=center><a href=admin.php target=_top>重新登入</a> | <a href=main.php target=_top>回留言板</a></div>";
exit();
}elseif($s_user){
echo
?>
<table width=100% bgcolor=#cccccc>
<tr><td>Ｈi,<? echo $s_user ; ?>您好</td><td></tr><tr><td><table align=right><tr><td><a href=main.php>留言管理</a></td>
<td><a href=<? $PHP_SELF ?>?logout=true target=_top>登出</a></td>
</tr></table></table>
<? } ?>
<P></P>
<?
//管理者刪除留言資料
if($s_user){if($delete==yes){
$query_delete="DELETE FROM $repost_table WHERE re_sn='$re_sn'";
$result=mysql_query($query_delete)or die("刪除失敗");
}elseif($deleteall==yes){
$query_delete="DELETE FROM $repost_table WHERE sn='$sn'";
$query_delete2="DELETE FROM $post_table WHERE sn='$sn'";
mysql_query($query_delete)or die("刪除失敗");
mysql_query($query_delete2)or die("刪除失敗");
}}
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=big5">
<title>正統香功全球資訊網</title>
<link href="include/bbs.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
body {
margin-left: 40px;
margin-top: 0px;
margin-right: 0px;
margin-bottom: 0px;
}
-->
</style>
<script language="JavaScript" type="text/JavaScript">
<!--
function MM_jumpMenu(targ,selObj,restore){ //v3.0
eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'");
if (restore) selObj.selectedIndex=0;
}
//-->
</script>
</head>
<body topmargin="10">
<form name="form1" method="post" action="main.php">
<table width="49%" border="0">
<tr>
<td> <font size="1"> </font></td>
</tr>
</table>
<table width="500" border="0" cellpadding="3" cellspacing="0" bgcolor="#FFFFFF" class="bd2">
<tr bgcolor="#CCCCCC">
<td><div align="center"><font color="#0000FF" size="4" face="標楷體"><strong>香友問答精華</strong></font></div></td>
</tr>
</table>
</form>
<?
//列出留言
$query_string2="SELECT * FROM $post_table ORDER by sn DESC";
$result2=mysql_query($query_string2);
### 分頁 ###
if(!isset($page)) $page=1;
if($page==0) $page=1;
$nNumRows= mysql_num_rows($result2);
if($nNumRows<=0)
{
echo "<p align=center>沒有留言紀錄</p>";
exit();
};
//得到最大頁碼數
$MaxPage = (int)ceil($nNumRows/$pagesize);
if((int)$page > $MaxPage)
$page=$maxPage;
//用mysql_data_seek得到偏移量
if(mysql_data_seek($result2,($page-1)*$pagesize) ) {
?>
<?
$n=0;
while($list2=mysql_fetch_array($result2)){
$n++;
if($n>$pagesize){break;}//超過$n筆數就停止迴圈
echo
?>
<?
//錨點
echo "<a name=\"l$n\"></a>"
?>
<table width="500" border="0" class="bd1">
<tr>
<td colspan="2"><font color="#336699"><? echo $list2['p_name'] ;?></font>
<?
#### 判斷網址 ####
if(empty($list2['p_web'])){
echo "<img src=image/nourl.gif>";
}else{
echo "<a href=".$list2['p_web']." target=_blank ><img src=image/url.gif border=0 align=absmiddle></a>";
}
?>
<?
#### 判斷郵件 ####
if(empty($list2['p_email'])){
echo "<img src=image/noemail.gif>";
}else{
echo "<a href=mailto:".$list2['p_email']."><img src=image/email.gif border=0 align=absmiddle></a>";
}
?>
<?
###顯示管理選項###
if($s_user){
echo "<a href=main.php?sn=".$list2['sn']."&deleteall=yes><img src=image/delall.gif border=0></a>";
echo "<a href=modifyform.php?sn=".$list2['sn']."><img src=image/mod.gif border=0></a>";
}
?>
<?
###顯示時間###
echo "<font size=2 color=999999>".$list2['p_date']."</font>";
?>
</td>
</tr>
<tr>
<td colspan="2" style="word-break:break-all"><?
#### 顯示留言/判斷私密留言及管理者 ####
if($s_user){
echo $list2['p_content'];
}elseif($_COOKIE['aurabbs']==$list2['p_time']){
echo $list2['p_content'];
}elseif(($list2['p_private']==1)&&$_COOKIE['aurabbs']!=$list2['p_time']){
echo "<font color=#ff3333>這個是給版主的私人留言,只有版主能看..^^..</font>";
}else{echo $list2['p_content'];}
?>
</td>
</tr>
<tr>
<td width="4">
</td>
<td width="416" style="word-break:break-all" ><?
//列出回覆留言
$query_string3="SELECT * FROM $repost_table order by re_sn";
$result3=mysql_query($query_string3);
#### 顯示回覆留言 ####
while($list3=mysql_fetch_array($result3)){
if(($list2['sn'])==($list3['sn'])){
echo
?>
<hr align="left" width=95% height=1>
<font color="#996600"><? echo $list3['re_name'] ;?></font>
<?
#### 判斷回覆網址 ####
if(empty($list3['re_web'])){
echo "<img src=image/nourl.gif>";
}else{
echo "<a href=".$list3['re_web']." target=_blank ><img src=image/url.gif border=0></a>";
}
?>
<?
#### 判斷回覆郵件 ####
if(empty($list3['re_email'])){
echo "<img src=image/noemail.gif>";
}else{
echo "<a href=mailto:".$list3['re_email']."><img src=image/email.gif border=0></a>";
}
?>
<?
###顯示回覆時間###
echo "<font size=2 color=999999>".$list3['re_date']."</font>";
?>
<?
###顯示管理選項###
if($s_user){
echo "<a href=main.php?re_sn=".$list3['re_sn']."&delete=yes><img src=image/del.gif border=0></a>";
echo "<a href=modifyform.php?re_sn=".$list3['re_sn']."><img src=image/mod.gif border=0></a>";
}
?>
<?
###顯示回覆內容###
echo "<br>".$list3['re_content'];
?>
<?
}//end if
} //end while2
?>
</td>
</tr>
<tr>
<td colspan="2"><div align="right"><font size="2" color="#339966"> </a> </font></div></td>
</tr>
</table>
<p></p>
<?
}//end while
?>
<table width="500" border="0">
<tr>
<td><div align="center"><font size="2"><?
//首頁和上一頁的鏈結
if( $nNumRows>1 && $page>1) {
$prevPage=$page-1;
echo "<a href=main.php?page=1>第一頁</a> ";
echo "<a href=main.php?page=$prevPage >上一頁</a> ";
}
//下一頁和末頁的鏈結
if( $page>=1 && $page<$MaxPage) {
$nextPage= $page+1;
echo "<a href=main.php?page=$nextPage >下一頁</a> ";
echo " <a href=main.php?page=$MaxPage >最末頁</a> ";
} ?></font></div></td>
</tr>
</table>
<table width="500" border="0" class="table_fontstyle1">
<tr>
<td width="48%" valign="top"><? echo "<font size=2>共 <font color=red>$MaxPage</font> 頁，目前位於第<font color=red> $page </font>頁</font>";?></td>
<td width="52%" valign="top"><div align=right>
<form action="main.php" name="form1">
<div align="right"><font size="2">快速跳頁：
<select name="menu1" onChange="MM_jumpMenu('self',this,0)">
<option value="#" selected>頁數</option>
<? for($i=1;$i<=$MaxPage;$i++){
echo "<option value=main.php?page=$i>第".$i."頁</option>";
}
?>
</select>
</font></div>
</form>
</div></td>
</tr>
</table>
<p></p>
<?
}//end 分頁
?>
<p> </p>
</body>
</html>