留言版管理模式

]*>", "", $addname1); $email1 = addslashes($email); ##處理$email $email = ereg_replace("<[^>]*>", "", $email1); $addkommentar = addslashes($comment); ##處理$comment if($htmlcode=="true"){ $comment = $addkommentar; } else { $comment = ereg_replace("<[^>]*>", "", $addkommentar); } mysql_query("update $userstable set name='$name',email='$email',url='$url',comment='$comment' where id=$id"); header("Location:$PHP_SELF"); } #################################執行刪除留言程式######################## if ($active=="delete") { $result=mysql_query("select * from $userstable where id='$id'") or die(mysql_error()); $row=mysql_fetch_Array($result); $sort=$row[sort]; $inputdate=$row[inputdate]; $thread=$row[thread]; $sortlen=strlen($sort); mysql_query("delete from $userstable where id=$id"); //刪除該筆留言 if($sort>0){ mysql_query("delete from $userstable where LEFT(sort,$sortlen)='$sort'"); //刪除該筆留言的子留言 } $result=mysql_query("select * from $userstable where thread='$thread' order by inputdate desc limit 0,1") or die(mysql_error()); //找出該組留言內最新的一筆 $temp_num = mysql_num_rows($result); //判斷該組留言是否還存在 if($temp_num>0){ $row=mysql_fetch_Array($result); $inputdate=$row[inputdate]; //該組留言最新一筆的留言日期 $pre_result=mysql_query("select show_index,thread from $userstable where inputdate<'$inputdate' order by inputdate desc limit 0,1") or die(mysql_error()); //比該筆留言還要舊 $pre_show_index=@mysql_result($pre_result,0,"show_index"); $pre_thread=@mysql_result($pre_result,0,"thread"); $next_result=mysql_query("select show_index from $userstable where inputdate>'$inputdate' and thread<>'$pre_thread' order by inputdate limit 0,1") or die(mysql_error()); //比該筆留言還要新 $next_show_index=@mysql_result($next_result,0,"show_index"); if(($next_show_index-$pre_show_index)<2){ //差距太小時，予以重整資料庫 include("recreat_showindex.php"); exit; } $show_index=($pre_show_index+$next_show_index)/2; mysql_query("update $userstable set show_index='$show_index' where thread='$thread'"); } $local_url=$PHP_SELF."?show=$show"; header("Location:$local_url"); } ###################################HTML前導################################ ?> 留言版管理模式
目前為管理模式 [退出管理模式] "; print "沒有任何留言"; print "

"; } elseif ($total > 0) { if ($total%$limit!=0) { $totalpage=intval($total/$limit)+1; } else { $totalpage=intval($total/$limit); } $nowpage=intval($show/$limit)+1; print "HTML: "; if ($htmlcode=="true"){$htmlswitch="開";} elseif ($htmlcode=="false"){$htmlswitch="關";} print "$htmlswitch"; print "　總留言數：$total 　　"; print "/共$totalpage.頁

"; while ($i < $number){ $row = mysql_fetch_array($result); $name = stripslashes($row[name]); $email = $row[email]; $url = $row[url]; $sex = $row[sex]; $comment = stripslashes(nl2br($row[comment])); $face = $row[face]; $sort=$row[sort]; $lev=explode(".",$sort); $level=count($lev)-1; $id=$row[id]; $inputdate = $row[inputdate]; if ($level == 0 OR $i==0){ print "

"; } print "

"; print ""; if ($level == 0){ $color="99CCFF"; } else { $color="CCFFFF"; } print ""; $k=0; $black=""; while ($k < $level){ $black.="　　"; $k++; } $comment=$black.$comment; $replacestr="
".$black; $comment=str_replace("
",$replacestr,$comment); print ""; print "

"; $j=0; while ($j < $level){ print "　　"; $j++; } if ($level == 0){ print "