\n"; echo "
"; echo "
"; echo " \n"; echo "
                    
"; echo "
"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo "
 SUBJECT  
  NAME   PASSWORD 
  EMAIL 
  CONTENTS 
"; echo "
"; echo "
  "; echo "                    
"; echo "
"; echo "
"; echo "
"; mysql_close($conn); exit; } if($mode == "write_insert" ){ if ($Theme=="") { echo " "; exit; } if ($Contents=="") { echo " "; exit; } if ($name=="") { echo " "; exit; } if ($passwd=="") { echo " "; exit; } $query1 = "select Tot_No from $table order by Tot_No desc"; $result1 = mysql_query($query1,$conn); if(!$result1){ $Tot[0] = 0; } else { $Tot = mysql_fetch_row($result1); } $Tot_No=$Tot[0] + 1; } $dbresult = mysql_query("select Tot_No from $table order by Tot_No desc",$conn); $totalnumber = mysql_num_rows($dbresult); $dbresult1 = mysql_query("select Class_No from $table order by Class_No desc",$conn); if($mode == "write_insert"){ if (!$totalnumber) { $Tot_No=1; $Class_No=1; } else { $maxnumber = mysql_result($dbresult,0,"Tot_No"); $maxrefnum = mysql_result($dbresult1,0,"Class_No"); $Tot_No = $maxnumber + 1; $Class_No = $maxrefnum +1; } } if($mode == "write_insert") { $query2="INSERT INTO $table VALUES('$Tot_No','$Class_No','$ansnum',now(),'$Theme','$name','$email','$Contents','$passwd','0')"; $result2=mysql_query($query2,$conn); if(!$result2) { echo " "; } } if($mode == "reply_form"){ $query1 = "select Tot_No,Class_No,ansnum,Theme,Contents from $table where Tot_No='$No'"; $result1 = mysql_query($query1,$conn); $bbs_value = mysql_fetch_row($result1); $OutTot_No = $bbs_value[0]; $Class_No = $bbs_value[1]; $ansnum = $bbs_value[2]; $OutTheme = "[RE]$bbs_value[3]"; $OutCont = ereg_replace("\n","\n",$bbs_value[4]); $OutContents = "-> $OutCont"; mysql_free_result($result1); mysql_close($conn); } if($mode == "reply_form"){ echo "
"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo "


"; echo "
"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo "
  SUBJECT 
  NAME   PASSWORD 
  EMAIL 
  CONTENTS 
"; echo "
"; echo "
  "; echo "                    
"; echo ""; echo "
"; echo ""; exit; } if($mode == "reply_insert") { if ($Theme=="") { echo " "; exit; } if ($Contents=="") { echo " "; exit; } if ($name=="") { echo " "; exit; } if ($passwd=="") { echo " "; exit; } $dbresult = mysql_query("select Tot_No from $table order by Tot_No desc",$conn); $Tot_No = mysql_result($dbresult,0,"Tot_No"); $Tot_No = $Tot_No +1; $dbansresult = mysql_query("select ansnum from $table where Class_No = $Class_No order by ansnum desc",$conn); $maxansnum =mysql_result($dbansresult,0,"ansnum"); if ($ansnum > 0) { mysql_query("update $table set ansnum = ansnum+1 where Class_No = $Class_No and ansnum > $ansnum",$conn); $ansnum = $ansnum +1; } else { $ansnum =$maxansnum +1; } $query2="INSERT INTO $table VALUES('$Tot_No','$Class_No','$ansnum',now(),'$Theme','$name','$email','$Contents','$passwd','0')"; $result2=mysql_query($query2,$conn); if(!$result2) { echo " "; } } if($mode == "fix_form") { if($admin_sid == "") { echo "


"; echo "
"; echo " \n"; echo " \n"; echo "
"; echo ""; echo ""; echo "
Edit
"; echo ""; echo ""; echo "
PASSWORD:
"; echo "
 
"; echo ""; echo "
"; echo "


"; echo "
 
"; echo "
"; echo ""; exit; } else { echo "


"; echo "
"; echo " \n"; echo " \n"; echo "
"; echo ""; echo ""; echo "
관리자 모드로 수정
"; echo ""; echo "
"; echo "
 
"; echo ""; echo "
"; echo "


"; echo "
 
"; echo "
"; echo ""; exit; } } if($mode == "fix_we") { if($admin_sid == "" ) { $query ="select Password from $table where Password='$passwd' and Tot_No='$No'"; $result= mysql_query($query,$conn); if(!$result) { echo "result error fix"; } $Outpasswd=mysql_result($result,0,'Password'); if($Outpasswd != $passwd || $Outpasswd == "") { echo ""; myql_close($conn); exit; } } $query1 = "select Theme,Name,E_mail,Contents,Password from $table where Tot_No='$No'"; $result1 = mysql_query($query1,$conn); $bbs_value = mysql_fetch_row($result1); $OutTheme = $bbs_value[0]; $OutName = $bbs_value[1]; $OutE_mail = $bbs_value[2]; $OutContents =$bbs_value[3]; $OutPasswd =$bbs_value[4]; mysql_free_result($result1); mysql_close($conn); echo "
"; echo ""; echo " \n"; echo "\n"; echo "\n"; echo "
"; echo "
"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo "
  SUBJECT 
  NAME   PASSWORD 
  EMAIL 
  CONTENTS 
"; echo"
"; echo "
  "; echo "                    
";; echo ""; echo "
"; echo ""; exit; } if($mode == "fix_insert"){ if ($Theme=="") { echo " "; exit; } if ($Contents=="") { echo " "; exit; } if ($name=="") { echo " "; exit; } if ($passwd=="") { echo " "; exit; } $query2 = "update $table Set Theme='$Theme',Contents='$Contents',Name='$name',E_mail='$email',Password='$passwd' where Tot_No='$No'"; $result2 = mysql_query($query2,$conn); } if($mode == "delete_form" ) { if($admin_id) { echo "
"; echo "
"; echo " \n"; echo " \n"; echo "
"; echo ""; echo ""; echo "
정말로 삭제 하시겠습니까
"; echo ""; echo ""; echo "
"; echo "
 
"; echo ""; echo "
"; echo "


"; echo "
 
"; echo "
"; echo ""; exit; } else { echo "
"; echo "
"; echo " \n"; echo " \n"; echo "
"; echo ""; echo ""; echo "
Delete
"; echo ""; echo ""; echo "
PASSWORD:
"; echo "
 
"; echo ""; echo "
"; echo "


"; echo "
 
"; echo "
"; echo ""; exit; } } if($mode == "delete"){ if(!$admin_id){ $query = "select Password from $table where Password='$del_passwd' and Tot_No='$No'"; $result = mysql_query($query,$conn); $Outpasswd=mysql_result($result,0,'Password'); if($Outpasswd != $del_passwd || $Outpasswd == "") { echo " "; myql_close($conn); exit; } else { $query2 ="delete from $table where ToT_No='$No'"; $result2 = mysql_query($query2,$conn); if(!$result2) { echo "erro result2"; } } } else { $query2 ="delete from $table where ToT_No='$No'"; $result2 = mysql_query($query2,$conn); } } if($mode == "view"){ $query1 = "select Date,Theme,Name,E_mail,Contents,Contact_No from $table where Tot_No='$No'"; $result1 = mysql_query($query1,$conn); $bbs_view = mysql_fetch_row($result1); $OutDate = $bbs_view[0]; $OutTheme = $bbs_view[1]; $OutName = $bbs_view[2]; $OutE_mail = $bbs_view[3]; $OutContents = ereg_replace("\n","
",$bbs_view[4]); $OutCN = $bbs_view[5]; mysql_free_result($result1); $OutCN = $OutCN+1; $query2 = "update $table Set Contact_No='$OutCN' where Tot_No='$No'"; $result2 = mysql_query($query2,$conn); if($postcolor == "" || $postfont == "") { $postcolor="white"; $postfont="black"; } echo ""; echo "
"; echo "
"; echo " "; echo " "; echo "                     
"; echo "
"; echo ""; echo "
"; echo ""; echo ""; echo ""; echo ""; echo"
$OutTheme
"; echo""; echo ""; echo "
 NAME $OutName EMAIL $OutE_mail
"; echo""; echo "
 $OutContents
"; echo " 
"; $queryTOT = "select Tot_No from $table order by Tot_No desc"; $resultTOT = mysql_query($queryTOT,$conn); $LastNo = mysql_fetch_row($resultTOT); $Last_No = $LastNo[0]; mysql_free_result($resultTOT); echo "
"; echo "
NEXT:"; if($Last_No != $No){ $L_No=$No+1; $queryNext = "select Theme from $table where Tot_No='$L_No'"; $resultNext = mysql_query($queryNext,$conn); $bbs_viewNext = mysql_fetch_row($resultNext); $OutThemeNext = $bbs_viewNext[0]; mysql_free_result($resultNext); echo " $OutThemeNext"; } echo "
BEFORE:"; if($No != "1"){ $B_No=$No-1; $queryBefore = "select Theme from $table where Tot_No='$B_No'"; $resultBefore = mysql_query($queryBefore,$conn); $bbs_viewBefore = mysql_fetch_row($resultBefore); $OutThemeBefore = $bbs_viewBefore[0]; mysql_free_result($resultBefore); echo " $OutThemeBefore "; } echo "


"; echo "
"; echo "
"; echo ""; mysql_close($conn); exit; } ########### 한 페이지당 출력할 게시물의 수 $num_per_page ="$list"; ########### 게시물 출력목록 하단에 링크를 걸 페이지의 개수 $page_per_block = 10; ########## 데이터베이스에 연결한다. ########### if(!$page) { $page = 1; } ########## 전체게시물의 총 개수를 각각 구한다. ########## if(!eregi("[^[:space:]]+",$key)) { $query = "SELECT count(Tot_No) FROM $table"; } else { $encoded_key = urlencode($key); $query = "SELECT count(Tot_No) FROM $table WHERE $keyfield LIKE '%$key%'"; } $result = mysql_query($query,$conn); if (!$result) { echo ("QUERY_ERROR"); exit; } $total_record = mysql_result($result,0,0); ########## 현재의 페이지에서 출력할 게시물의 범위를 결정한다. ########## if(!$total_record) { $first = 1; $last = 0; } else { $first = $num_per_page*($page-1); $last = $num_per_page*$page; $IsNext = $total_record - $last; if($IsNext > 0) { $last -= 1; } else { $last = $total_record - 1; } } ########## 전체 페이지수를 계산한다. ########## $total_page = ceil($total_record/$num_per_page); ?>

&keyfield=&key="> border="0" align="center" cellspacing="0" cellpadding="0">
( / )
border=0 CELLSPACING=0 CELLPADDING=0>
> "); $Theme = substr($my_theme,0,48); $my_date=explode(" ",$my_date); ########## 회원 정보 ########## echo(" "); echo ""; echo ""; } echo ""; echo ""; echo""; } echo("
No. size="-1">SUBJECT size=-1>NAME size=-1>DATE size=-1>COUNT
$my_num"; if($Outansnum != 0){ echo " "; } echo " $Theme "; if($my_email !=""){ echo "$my_name"; } else { echo "$my_name"; echo "$my_date[0]"; echo "$my_Contact_No
"); ?> border="0" cellspacing="0" cellpadding="0" align="center">
1) { $my_page = $first_page; echo("[Before ${page_per_block}]"); } ########## 현재의 페이지 블럭범위내에서 각 페이지로 바로 이동할 수 있는 하이퍼링크를 출력한다. ########## for($direct_page = $first_page+1; $direct_page <= $last_page; $direct_page++) { if($page == $direct_page) { echo("[$direct_page]"); } else { echo("[$direct_page]"); } } ########## 다음페이지블록에 대한 페이지 링크 ########## if($block < $total_block) { $my_page = $last_page+1; echo("[Next ${page_per_block}]"); } ?>
border="0" cellspacing="0" cellpadding="0" align="center"> "); } else { echo(""); } ?>
 "; if ($page > 1) { $page_num = $page - 1; echo(" "); } else { echo(""); } ########## 게시물이 다음페이지에도 존재할 경우 다음페이지로 가는 링크를 활성화시킨다. ########## if ($IsNext > 0) { $page_num = $page + 1; echo(" 
>

 

>