| |
...............................................................................................................................,,,,,,,,,,,,,,HOME < 고객게시판
|
");
/////////// ===================== (1) 몰 탑을 인클루딩 =================== /////////////////
echo("
");
//----------------------------------------------------------------------------------------------------
// * 글지우기
//----------------------------------------------------------------------------------------------------
if($mode == 'del' && $id ) {
if(!$passwd) {
echo("
");
} else {
$que1 = "select user_file from $code where id = $id and passwd = '$passwd'";
$result = mysql_query($que1,$dbconn);
$row = mysql_fetch_array($result);
if($row[user_file]) {
unlink($row[user_file]);
}
$que1 = "delete from $code where id = $id and passwd = '$passwd'";
mysql_query($que1,$dbconn);
$del_ok = mysql_affected_rows();
if(!$del_ok) {
$que1 = "select admin_pw from bbs_info where code = '$code' and admin_pw = '$passwd'";
$result=mysql_query($que1,$dbconn );
$admin_ok = mysql_affected_rows();
if($admin_ok) {
$que1 = "select user_file from $code where id = $id " ;
$result= mysql_query($que1,$dbconn );
$row = mysql_fetch_array($result);
if($row[user_file]) {
@unlink($row[user_file]);
}
$que1 = "delete from $code where id = $id";
mysql_query($que1,$dbconn);
$del_ok = mysql_affected_rows();
}
}
if($del_ok) {
echo "";
exit;
} else {
error(" 암호가 틀려 지울수가 없어요!");
exit;
}
}
}
//----------------------------------------------------------------------------------------------------
// * 새글 올리기
//----------------------------------------------------------------------------------------------------
if($mode=='up') {
if(!$title || !$body || !$name ) {
error(" 이름, 제목, 내용을 입력해 주세요 !");
exit;
}
if(!$passwd) {
error(" \\n[ 암호필요! ] \\n이글을 고치거나 지우기 위해서는 \\n반드시 암호가 필요합니다");
exit;
}
$file_name = substr( strrchr($up_file_name,"."),1);
if($file_name==php3 || $file_name==html || $file_name==php || $file_name==html || $file_name==inc) {
error(" 확장자가 PHP 스크립트로 등록된 파일은 첨부 할 수 없습니다.");
exit;
}
$que1 = " LOCK TABLES $code WRITE" ;
mysql_query($que1,$dbconn);
if($bbs[use_tag] == 'y') {
$title = EnableHTML($title);
$body = EnableHTML($body);
$body = nl2br($body);
}else{
$body = DisableHTML($body);
$body = nl2br($body);
}
$body = ereg_replace(" "," ",$body);
if($home) {
$home_true = eregi("http://", $home);
if(!$home_true) {
$home="http://$home";
}
}
$title = addslashes($title);
$body = addslashes($body);
$name = substr($name,0,29);
$title = substr($title,0,79);
$que1 = "select MAX(thread) from $code" ;
$result = mysql_query($que1,$dbconn );
$row = mysql_fetch_array($result);
$thread = $row[0]+1;
$que1 = "select MIN(pos) from $code" ;
$result = mysql_query($que1,$dbconn );
$row = mysql_fetch_array($result);
$pos = $row[0]+1;
mysql_query("update $code set pos=pos+1 where pos>0");
if($bbs[use_file] && $up_file_name) {
if(!filetype("./".$code)) {
if(!@mkdir("./".$code,0777)) {
echo "디렉토리를 만들수 없습니다.- check permissions
\n";
exit;
}
}
$up_file_name = ereg_replace(" ","",$up_file_name);
$dest = "./$code/$up_file_name";
if(@exec("cp $up_file $dest")!=0) {
echo " $dest 를 만들수 없네! - check permissions
\n";
exit;
}
@unlink($up_file);
}
if($bbs[mail_notice]=='y') {
$body_trim = eregi_replace("
","",$body);
$to = $bbs[admin_mail];
$sub = "$bbs[name]에 새로운 게시물이 등록되었습니다";
$mail_body = "
$bbs[name] - 새로운 게시물이 등록되었습니다\n\n제목 : $title \n이름 : $name \n내용 : $body_trim \n\n";
mail("$to", "$sub", "$mail_body", "from:$bbs[admin_mail]");
}
$result = mysql_query("insert into $code values ('','$name','$mail', '$home','$title','$body',now(),1,$thread,1,1,'$passwd','$dest','$REMOTE_ADDR',0)");
$que1 = " UNLOCK TABLES " ;
mysql_query($que1,$dbconn );
if($result) {
echo("");
exit;
}else{
error("새글 입력 중 오류가 발생했습니다.");
exit;
}
}
//----------------------------------------------------------------------------------------------------
// * 응답글 올리기
//----------------------------------------------------------------------------------------------------
if($mode=='re_up') {
if(!$title || !$body || !$name) {
error(" 이름, 제목, 내용을 입력해 주세요 ! ");
exit;
}
if(!$passwd) {
error(" \\n[ 암호필요! ] \\n이글을 고치거나 지우기 위해서는 \\n반드시 암호가 필요합니다 ");
exit;
}
if($bbs[use_tag] == 'y') {
$title = EnableHTML($title);
$body = EnableHTML($body);
}else{
$body = DisableHTML($body);
$body = nl2br($body);
}
$body = ereg_replace(" "," ",$body);
if($home) {
$home_true = eregi("http://", $home);
if(!$home_true) {
$home="http://$home";
}
}
$que1 = " LOCK TABLES$code WRITE" ;
mysql_query($que1,$dbconn );
$title = addslashes($title);
$body = addslashes($body);
$name = substr($name,0,29);
$title = substr($title,0,79);
mysql_query("update $code set pos=pos+1 where pos>=$pos");
if($bbs[use_file] && $up_file_name) {
if(!filetype("./".$code)) {
if(!@mkdir("./".$code,0777)) {
echo "디렉토리를 만들수 없습니다.- check permissions
\n";
exit;
}
}
$up_file_name = ereg_replace(" ","",$up_file_name);
$dest = "./$code/$up_file_name";
if(@exec("cp $up_file $dest")!=0) {
echo " $dest 를 만들수 없네! - check permissions
\n";
exit;
}
unlink($up_file);
}
if($bbs[mail_notice]=='y') {
$body_trim = eregi_replace("
","",$body);
$to = "$bbs[admin_mail]" ;
$sub = "$bbs[name] 에 새로운 게시물이 등록되었습니다";
$mail_body = "$bbs[name] 에 새로운 게시물이 등록되었습니다\n\n제목 : $title \n 이름 : $name \n 내용 : $body_trim \n\n ";
mail("$to", "$sub", "$mail_body", "from:게시판관리자");
}
$result = mysql_query("insert into $code values ('','$name','$mail','$home','$title','$body',now(),1,$thread,$depth,$pos,'$passwd','$dest','$REMOTE_ADDR',0)");
$que1 = " UNLOCK TABLES " ;
mysql_query($que1,$dbconn );
if($result) {
echo "";
}else{
error(" 응답글 입력 중 오류가 발생했습니다. ");
exit;
}
}
//----------------------------------------------------------------------------------------------------
// * 글 수정완료
//----------------------------------------------------------------------------------------------------
if($mode == 'update') {
if(!$title || !$body || !$name) {
error("이름, 제목, 내용을 입력해 주세요! ");
exit;
}
if(!$passwd) {
error(" \\n[ 암호필요! ] \\n이글을 고치거나 지우기 위해서는 \\n반드시 암호가 필요합니다 ");
exit;
}
$que1 = "select * from $code where id = $id";
$result = mysql_query($que1,$dbconn );
$row = mysql_fetch_array($result);
$que2 = "select * from bbs_info where code = '$code'";
$result2 = mysql_query($que2,$dbconn );
$row2 = mysql_fetch_array($result2);
if(($passwd != $row[passwd]) && ($passwd != $row2[admin_pw])) {
error(" 암호가 일치하지 않습니다. 올바른 암호를 입력하여 주세요. ");
exit;
}
$file_name = substr( strrchr($up_file_name,"."),1);
if($file_name==php3 || $file_name==html || $file_name==php || $file_name==html || $file_name==inc) {
error(" 확장자가 PHP 스크립트로 등록된 파일은 첨부 할 수 없습니다. ");
exit;
}
$body = ereg_replace(" "," ",$body);
if($bbs[use_tag] == 'y') {
$title = EnableHTML($title);
$body = EnableHTML($body);
$body = nl2br($body);
}else{
$body = DisableHTML($body);
$body = nl2br($body);
}
$body = ereg_replace(" "," ",$body);
if($home) {
$home_true = eregi("http://", $home);
if(!$home_true) {
$home="http://$home";
}
}
$title = addslashes($title);
$body = addslashes($body);
$name = substr($name,0,29);
$title = substr($title,0,79);
if($bbs[use_file] && $up_file_name) {
if(!filetype("./".$code)) {
if(!@mkdir("./".$code,0777)) {
echo "디렉토리를 만들수 없습니다.- check permissions
\n";
exit;
}
}
$up_file_name = ereg_replace(" ","",$up_file_name);
$dest = "./$code/$up_file_name";
if(@exec("cp $up_file $dest")!=0) {
echo " $dest 를 만들수 없네! - check permissions
\n";
exit;
}
unlink($up_file);
}
$que1 = "update $code set name = '$name', mail = '$mail', home = '$home', title = '$title', body = '$body', user_file = '$dest', reg_date = now(), passwd = '$passwd' where id = $id";
$result = mysql_query($que1,$dbconn);
if($result) {
echo "";
}else{
error(" 내용 변경중 중 오류가 발생했습니다. ");
exit;
}
}
//----------------------------------------------------------------------------------------------------
// * 답변글 작성하는 폼을 디스플레이
//----------------------------------------------------------------------------------------------------
if($mode=='re') {
if(!$id) {
error(" 글번호가 필요합니다 ");
exit;
}
$que1 = "select name,title,thread,pos,depth,body from $code where id=$id";
$result = mysql_query($que1, $dbconn);
$row = mysql_fetch_array($result);
$p_pos = $row[pos];
$p_thread = $row[thread];
$p_depth = $row[depth];
$thread = $row[thread] ;
$depth = $row[depth] +1;
$que2 = "select count(*) from $code where thread = $thread and depth > $p_depth" ;
$result2 = mysql_query($que2,$dbconn );
$row2 = mysql_fetch_array($result2);
$plus_pos = $row2[0] ;
$pos = $row[pos] + $plus_pos + 1 ;
$row[title]= stripslashes($row[title]);
$row[body] = stripslashes($row[body]);
$row[body] = eregi_replace("
","",$row[body]);
$row[body]="\n$row[name]님의 글\n-------------------------------------------------------------\n$row[body]\n-------------------------------------------------------------\n";
echo("
");
}
//----------------------------------------------------------------------------------------------------
// * 글 수정시 비밀번호 확인및 수정폼 디스플레이
//----------------------------------------------------------------------------------------------------
if($mode == 'edit') {
if(!$id) {
error(" 글 번호가 필요합니다 ");
exit;
}
$que1 = "select id, passwd, home, title, name,DATE_FORMAT(reg_date,'Y년 m월 d일 k:i'),body,mail from $code where id = $id";
$result=mysql_query($que1,$dbconn );
$row=mysql_fetch_array($result);
$row[body] = stripslashes($row[body]);
$row[title] = stripslashes($row[title]);
$row[body] = eregi_replace("
","",$row[body]);
echo("
");
}
//----------------------------------------------------------------------------------------------------
// * 새글을 올릴 폼을 작성
//----------------------------------------------------------------------------------------------------
if(!$mode) {
if($bbs[board_form] == 'admin') {
if(!$admin_sid) {
echo "";
exit;
}
$id = "관리자";
$name = "관리자";
$email = "$bbs[admin_mail]";
$homepage = "$member_homepage";
}
if($bbs[board_form] == 'member') {
if(!$member_sid) {
echo "";
exit;
}
$id = "$member_id";
$name = "$member_name";
$email = "$member_email";
$homepage = "$member_homepage";
}
echo("
");
}
echo " | ";
/////////// ===================== (2) 몰 카피라이트 인클루딩 =================== /////////////////
echo("
|
|
|
|
|
