Data Room

\n"; echo "

"; mysql_close($conn); echo "

"; echo ""; exit; } if($mode == "write_insert" ){ if ($Theme=="") { echo " "; exit; } if ($Contents=="") { echo " "; exit; } if ($passwd=="") { echo " "; exit; } if ($name =="") { 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 (!$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; } include("file_tech.inc"); if($userfile_size == "" ) { $userfile_size=""; } $query2="INSERT INTO $table VALUES('$Tot_No','$Class_No','$ansnum',now(),'$Theme','$name','$email','$Contents','$passwd','0','$userfile_name','$userfile_size')"; $result2=mysql_query($query2,$conn); if(!$result2) { echo " "; } } if($mode == "reply_form"){ $query1 = "select Tot_No,Class_No,ansnum,Theme,Name,Contents,E_mail 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]"; $OutName= "$bbs_value[4]"; $OutCont = ereg_replace("\n","\n",$bbs_value[5]); $OutContents = "-> $OutCont"; $OutE_mail = $bbs_value[6]; 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 ""; echo ""; echo "

SUBJECT
NAME		PASSWORD
EMAIL
FILE
CONTENTS	$OutContents

"; echo "

"; echo ""; echo "

"; echo ""; exit; } if($mode == "reply_insert") { if ($Theme=="") { echo " "; exit; } if ($Contents=="") { echo " "; exit; } if ($passwd=="") { echo " "; exit; } if ($name =="") { 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; } include("file_tech2.inc"); if($myfile_size == "" ) { $myfile_size=""; } $query2="INSERT INTO $table VALUES('$Tot_No','$Class_No','$ansnum',now(),'$Theme','$name','$email','$Contents','$passwd','0','$myfile_name','$myfile_size')"; $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 ""; exit; } else { echo "

"; echo "

"; echo " \n"; echo " \n"; echo "

"; echo ""; echo ""; echo "

관리자 모드로 수정

"; echo ""; echo "

"; echo "

"; echo ""; echo "

"; echo "

"; echo ""; exit; } } if($mode == "fix_we") { if(!$admin_id) { $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,file_name 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]; $Outfile_name=$bbs_vaue[5]; mysql_free_result($result1); mysql_close($conn); echo "

"; echo ""; echo " \n"; echo ""; echo "

"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo "

SUBJECT
NAME		PASSWORD
EMAIL
FILE
CONTENTS	$OutContents

"; echo"

"; echo "

"; echo ""; echo ""; echo "

"; echo ""; exit; } if($mode == "fix_insert"){ if ($Theme=="") { echo " "; exit; } if ($Contents=="") { echo " "; exit; } if ($passwd=="") { echo " "; exit; } if ($name =="") { echo " "; exit; } $Tot_No="$No"; include("file_tech.inc"); if($userfile_size == "") { $query2 = "update $table Set Theme='$Theme',Contents='$Contents',Name='$name',E_mail='$email',Password='$passwd' where Tot_No='$No'"; } else { $query2 = "update $table Set Theme='$Theme',Contents='$Contents',Name='$name',E_mail='$email',Password='$passwd',file_name='$userfile_name',file_size='$userfile_size' where Tot_No='$No'"; } $result2 = mysql_query($query2,$conn); if(!$result2) { echo "result2 err $Date,$News,$Theme,$name,$email,$Contents,$passwd,$No" ; } } 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 ""; exit; } else { echo ""; echo "

"; echo " \n"; echo " \n"; echo "

"; echo ""; echo ""; echo "

Delete

"; echo ""; echo ""; echo "

PASSWORD:

"; echo "

"; echo ""; echo "

"; echo "

"; echo ""; exit; } } if($mode == "delete"){ if(!$admin_id){ $query = "select Password,file_name from $table where Password='$del_passwd' and Tot_No='$No'"; $result = mysql_query($query,$conn); $bb=mysql_fetch_row($result); $Outpasswd=$bb[0]; $file=$bb[1]; $savedir="/home/httpd/html/english/board/down_tech/$file"; if($Outpasswd != $del_passwd || $Outpasswd == "") { echo " "; myql_close($conn); exit; } else { if($file) { if(!unlink($savedir)) { echo "fail delete"; } } $query2 ="delete from $table where ToT_No='$No'"; $result2 = mysql_query($query2,$conn); if(!$result2) { echo "erro result2"; } } } else { if($file) { if(!unlink($savedir)) { echo "fail delete"; } } $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,file_name,file_size 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]; $file_name=$bbs_view[6]; $file_size=$bbs_view[7]; 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"

$OutTheme

"; echo""; echo ""; echo ""; echo ""; if($file_size != "") { echo ""; } else { echo ""; } echo "

NAME	$OutName	EMAIL	$OutE_mail
FILE	$file_name	FILE SIZE	$file_size byte
FILE SIZE	$file_size

"; echo""; echo "

$OutContents

"; $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 ""; 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>

> "; } if($ext == "xls") { $file_img="

"; } if($ext == "wav") { $file_img="

"; } if($ext == "ra") { $file_img="

"; } if($ext == "psd") { $file_img="

"; } if($ext == "ppt") { $file_img="

"; } if($ext == "png") { $file_img="

"; } if($ext == "mp3") { $file_img="

"; } if($ext == "jpg") { $file_img="

"; } if($ext == "gif") { $file_img="

"; } if($ext == "hwp") { $file_img="

"; } if($ext == "exe") { $file_img="

"; } if($ext == "doc") { $file_img="

"; } if($ext == "mid") { $file_img="

"; } if($ext == "bmp") { $file_img="

"; } if($ext == "st3") { $file_img="

"; } } else { $file_img =""; } $my_date =explode( " ",$my_date); echo(""); ########## 회원 정보 ########## echo(" "); echo ""; if($my_email != "") { echo ""; } else { echo ""; } echo ""; echo ""; echo ""; echo""; } echo("

No.	size="-1">SUBJECT	size=-1>NAME	size=-1>DATE	size=-1>FILE	size=-1>COUNT
$my_num	"; if($Outansnum != 0){ echo " "; } echo " $Theme	$my_name	$my_name	$my_date[0]	$file_img	$my_Contact_No

"); ?> border="0" cellspacing="0" cellpadding="0" align="center">

1) { $my_page = $first_page; echo("[NEXT ${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("[BEFORE ${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("