save_dir; $User_Board_Setting = new User_Board_Setting(); //°Ô½ÃÆÇÀÇ È¯°æ¼³Á¤³»¿ëÀ» °¡Áö°í ¿Â´Ù. $check_board=$User_Board_Setting->user_board_config($data_table); //ÀÔ·ÂµÈ Å×ÀÌºí °Ë»ö if($check_board=='1') { //°Ô½ÃÆÇÀÌ Á¸ÀçÇÏ´Â °æ¿ì //echo $f_userfile_name; //exit; if($f_userfile_name != '' && $f_userfile_name != 'none') { //echo $this->save_dir; //exit; $Function_Etc->Upload_file($f_userfile_name,$f_userfile,$this->save_dir,$Upload_error_file_check);//À̹ÌÁö ¾÷·Îµå Ŭ·¡½º ÇÔ¼ö $f_userfile_size=$Function_Etc->upload_file_result1_size; //ÆÄÀÏ»çÀÌÁî } $f_user_ip = $_SERVER[REMOTE_ADDR]; $f_regdate =date("Y-n-d H:i:s"); $f_depth2=0; $f_depth3=0; $f_read=0; if($f_color==''){ $f_color='#000000'; } $insert_icrement_query = "select max(b_num) from $data_table"; $insert_increment_result = mysql_query($insert_icrement_query); if(!$insert_increment_result) { $f_depth1=1; //(group) $f_depth2=0; //Áõ°¡µÈ ¼ö $f_depth3=0; $f_num =$f_depth1; } else { $insert_increment_rows = mysql_fetch_array($insert_increment_result); $f_num = $insert_increment_rows[0]+1; $f_depth1=$f_num; $f_depth2=0; $f_depth3=0; } if($f_avata_img==''){ $f_avata_img='default_avata.gif'; } $f_subject = addslashes($f_subject); $f_content = addslashes($f_content); $insert_into_query = "insert into $data_table (b_num,b_id,b_name,b_email,b_homepage,b_avata_img,b_user_ip,b_regdate,b_subject,b_content,b_userfile,b_userfile_size,b_read,b_pwss,b_depth1,b_depth2,b_depth3,b_color,b_fontline) values ('$f_num','$f_id','$f_name','$f_email','$f_homepage','$f_avata_img','$f_user_ip','$f_regdate','$f_subject','$f_content','$f_userfile_name','$f_userfile_size','$f_read','$pwss','$f_depth1','$f_depth2','$f_depth3','$f_color','$f_fontline')"; $insert_into_result = mysql_query($insert_into_query); if($insert_into_result) { $Total_admin_info = new Total_admin_info(); $Total_admin_info->admin_info(); //°ü¸®ÀÚÀÇ Á¤º¸¸¦ °¡Áö°í ¿Â´Ù. $Total_admin_info->i_admin_name; //Àüü°ü¸®ÀÚ À̸§ $Total_admin_info->i_admin_email; //Àüü °ü¸®ÀÚ À̸ÞÀÏ $Total_admin_info->i_admin_homepage; //Àüü °ü¸®ÀÚ È¨ÆäÀÌÁö $User_Board_Setting->display_list_adminemail; $User_Board_Setting->display_list_adminhomepage; $User_Board_Setting->display_list_adminname; //echo $User_Board_Setting->c_list_send_mail_check; switch($User_Board_Setting->c_list_send_mail_check) { case '0' : break; case '1' : //±Û¾´ÀÌ $e_to = $f_email; $e_name = $f_name; break; case '2' : //ÇØ´ç °ü¸®ÀÚ¿¡°Ô¸¸ $e_to = $User_Board_Setting->display_list_adminemail; $e_name = $User_Board_Setting->display_list_adminname; //¸ÞÀÏÀ» º¸³»´Â ºÎºÐ $e_subject=$f_subject; $Function_Etc->mail_user($e_to,$e_name,$e_subject,$f_content); break; case '3' : //»ç¿ëÀÚ ¹× ÇØ´ç °ü¸®ÀÚ $e_subject=$f_subject; $Function_Etc->mail_user($f_email,$f_name,$e_subject,$f_content); // ÇØ´ç»ç¿ëÀÚ $Function_Etc->mail_user($User_Board_Setting->display_list_adminemail,$User_Board_Setting->display_list_adminname,$e_subject,$f_content); //ÇØ´ç°ü¸®ÀÚ break; case '4' : //ÇØ´ç °ü¸®ÀÚ ¹× Àüü °ü¸®ÀÚ $e_subject=$f_subject; $Function_Etc->mail_user($Total_admin_info->i_admin_email,$Total_admin_info->i_admin_name,$e_subject,$f_content); // Àüü°ü¸®ÀÚ $Function_Etc->mail_user($User_Board_Setting->display_list_adminemail,$User_Board_Setting->display_list_adminname,$e_subject,$f_content); //ÇØ´ç °ü¸®ÀÚ break; case '5' : // ¸ðµÎ ´Ù¿¡°Ô $e_subject=$f_subject; $Function_Etc->mail_user($f_email,$f_name,$e_subject,$f_content); // ÇØ´ç»ç¿ëÀÚ $Function_Etc->mail_user($Total_admin_info->i_admin_email,$Total_admin_info->i_admin_name,$e_subject,$f_content); // Àüü°ü¸®ÀÚ $Function_Etc->mail_user($User_Board_Setting->display_list_adminemail,$User_Board_Setting->display_list_adminname,$e_subject,$f_content);//ÇØ´ç°ü¸®ÀÚ break; } $Error_Path->ok_page1("$PHP_SELF?data_table=$data_table"); } else { $Function_Etc->Upload_file_del($file); $Error_Path->error_page1('ÀÚ·á ÀԷ¿¡ ½ÇÆÐÇÏ¿´½À´Ï´Ù.'); } } } function data_modify($data_table,$f_name,$f_email,$f_homepage,$f_avata_img,$f_subject,$f_content,$f_userfile,$f_userfile_name,$pwss,$num,$f_color,$f_fontline) { $Error_Path = new Error_Path(); $Dbconnect = new Dbconn(); $User_Board_Setting = new User_Board_Setting(); //°Ô½ÃÆÇÀÇ È¯°æ¼³Á¤³»¿ëÀ» °¡Áö°í ¿Â´Ù. $Function_Etc = new Function_Etc(); //±âŸ ÇÔ¼ö Ŭ·¡½º $save_dir=$this->save_dir; $check_board=$User_Board_Setting->user_board_config($data_table); //ÀÔ·ÂµÈ Å×ÀÌºí °Ë»ö if($check_board=='1') { //°Ô½ÃÆÇÀÌ Á¸ÀçÇÏ´Â °æ¿ì $f_user_ip = $REMOTE_ADDR; $f_modifydate =date("Y-n-d H:i:s"); $check_query = "select * from $data_table where b_num='$num' and b_pwss='$f_pwss' limit 1"; $check_result = mysql_query($check_query); if(!$check_result) { $Error_Path->error_page1('±Û ¼öÁ¤¿¡ ½ÇÆÐÇÏ¿´½À´Ï´Ù.'); } $check_rows = mysql_num_rows($check_result); if($check_rows < 1) { $Error_Path->error_page1('ÆÐ½º¿öµå°¡ ¿Ã¹Ù¸£Áö ¾Ê½À´Ï´Ù.'); } $mysql_rows = mysql_fetch_array($check_result); $old_file = $mysql_rows[b_userfile]; if($f_userfile) { $Function_Etc->Upload_file($file_name,$file,$save_dir,$Upload_error_file_check);//À̹ÌÁö ¾÷·Îµå Ŭ·¡½º ÇÔ¼ö $f_userfile_size=$Function_Etc->upload_file_result1_size; //ÆÄÀÏ»çÀÌÁî if($old_file) { $Function_Etc->Upload_file_delete($old_file,$save_dir); } } if($f_avata_img==''){ $f_avata_img='default_avata.gif'; } $f_subject = addslashes($f_subject); $f_content = addslashes($f_content); if($f_userfile) { $update_into_query = "update $data_table set b_name=$f_name,b_email=$f_email,b_homepage=$f_homepage,b_avata_img=$f_avata_img,b_user_ip=$f_user_ip,b_modifydate=$f_modifydate,b_subject=$f_subject,b_content=$f_content,b_userfile=$f_userfile_name,b_userfile_size=$f_userfile_size"; } else { $update_into_query = "update $data_table set b_name='$f_name',b_email='$f_email',b_homepage='$f_homepage',b_avata_img='$f_avata_img',b_user_ip='$f_user_ip',b_modifydate='$f_modifydate',b_subject='$f_subject',b_content='$f_content' where b_num='$num'"; } } $update_into_result = mysql_query($update_into_query); if(!$update_into_result) { $Error_Path->error_page1('°Ô½Ã¹°¿¡ ´ëÇÑ ¼öÁ¤¿¡ ½ÇÆÐÇÏ¿´½À´Ï´Ù.'); } $Error_Path->ok_page1("$PHP_SELF?data_table=$data_table&mode=list&page=$page&field=$field&key=$key"); } function data_reply($data_table,$f_id,$f_name,$f_email,$f_homepage,$f_avata_img,$f_subject,$f_content,$pwss,$num,$f_depth1,$f_depth2,$f_depth3,$f_color,$f_fontline) { $Error_Path = new Error_Path(); $Dbconnect = new Dbconn(); $User_Board_Setting = new User_Board_Setting(); //°Ô½ÃÆÇÀÇ È¯°æ¼³Á¤³»¿ëÀ» °¡Áö°í ¿Â´Ù. $Function_Etc = new Function_Etc(); //±âŸ ÇÔ¼ö Ŭ·¡½º $save_dir=$this->save_dir; $check_board=$User_Board_Setting->user_board_config($data_table); //ÀÔ·ÂµÈ Å×ÀÌºí °Ë»ö $insert_max_query = "select max(b_num) as max from $data_table"; //ÃÖ´ë°ª $insert_max_result = mysql_query($insert_max_query); if(!$insert_max_result) { $Error_Path -> error_page1('¼±ÅÃÇÑ °Ô½Ã¹°¿¡ ´ëÇÑ Á¸À縦 ãÀ» ¼ö ¾ø½À´Ï´Ù.'); } $insert_max_rows = mysql_fetch_array($insert_max_result); $insert_max = $insert_max_rows[0] + 1; if($check_board=='1') { //°Ô½ÃÆÇÀÌ Á¸ÀçÇÏ´Â °æ¿ì $reply_select_query = "select b_num,b_depth1,b_depth2,b_depth3 from $data_table where b_num='$num'"; $reply_select_result = mysql_query($reply_select_query); if(!$reply_select_result) { $Error_Path->error_page1('´ä±ÛÀ» ´Þ±â À§ÇÑ ¿øº» µ¥ÀÌŸ¸¦ ãÀ» ¼ö ¾ø½À´Ï´Ù.'); } if($f_avata_img==''){ $f_avata_img='default_avata.gif'; } $update_query = "update $data_table set b_depth3 = b_depth3+1 where b_depth1='$f_depth1' and b_depth3 >= $f_depth3+1"; $update_result = mysql_query($update_query); $f_user_ip = $REMOTE_ADDR; $f_regdate =date("Y-n-d H:i:s"); $f_subject='[RE] '.$f_subject; $f_depth2_1=$f_depth2+1; $f_depth3_1=$f_depth3+1; $f_subject = addslashes($f_subject); $f_content = addslashes($f_content); $insert_into_query = "insert into $data_table (b_num,b_id,b_name,b_email,b_homepage,b_avata_img,b_user_ip,b_regdate,b_subject,b_content,b_userfile,b_userfile_size,b_read,b_pwss,b_depth1,b_depth2,b_depth3,b_color,b_fontline) values ('$insert_max','$f_id','$f_name','$f_email','$f_homepage','$f_avata_img','$f_user_ip','$f_regdate','$f_subject','$f_content','$f_userfile_name','$f_userfile_size','0','$pwss','$f_depth1','$f_depth2_1','$f_depth3_1','$f_color','$f_fontline')"; //echo $insert_into_query; //exit; $insert_into_result = mysql_query($insert_into_query); if(!$insert_into_result) { $Error_Path->error_page1('´äº¯ ´Þ±â¿¡ ½ÇÆÐÇÏ¿´½À´Ï´Ù.'); } else { $Error_Path->ok_page1("$PHP_SELF?data_table=$data_table&mode=list&page=$page&field=$field&key=$key"); } } } function data_delete($data_table,$pwss,$num,$page,$field,$key) { $Error_Path = new Error_Path(); $Dbconnect = new Dbconn(); $Function_Etc = new Function_Etc(); //±âŸ ÇÔ¼ö Ŭ·¡½º $User_Board_Setting = new User_Board_Setting(); //°Ô½ÃÆÇÀÇ È¯°æ¼³Á¤³»¿ëÀ» °¡Áö°í ¿Â´Ù. $Function_Etc = new Function_Etc(); //±âŸ ÇÔ¼ö Ŭ·¡½º $save_dir=$this->save_dir; $check_board=$User_Board_Setting->user_board_config($data_table); //ÀÔ·ÂµÈ Å×ÀÌºí °Ë»ö if($check_board=='1') { //°Ô½ÃÆÇÀÌ Á¸ÀçÇÏ´Â °æ¿ì $delete_select_query = "select b_num,b_userfile,b_depth2,b_depth3 from $data_table where b_num='$num' and b_pwss='$pwss'"; $delete_select_result = mysql_query($delete_select_query); if(!$delete_select_result) { $Error_Path->error_page1('»èÁ¦¸¦ À§ÇÑ ¿øº» µ¥ÀÌŸ¸¦ ãÀ» ¼ö ¾ø½À´Ï´Ù.'); } $check_rows = mysql_num_rows($delete_select_result); if($check_rows < 1) { $Error_Path->error_page1('ÆÐ½º¿öµå°¡ ¿Ã¹Ù¸£Áö ¾Ê½À´Ï´Ù.'); } $mysql_rows = mysql_fetch_array($delete_select_result); $old_file = $mysql_rows[b_userfile]; //Ŭ·¡½º ÇÔ¼ö if($old_file) { $Function_Etc->Upload_file_delete($old_file,$save_dir); } $delete_data_query = "delete from $data_table where b_num='$num' and b_pwss='$pwss'"; $delete_data_result = mysql_query($delete_data_query); if(!$delete_data_result) { $Error_Path->error_page1('µ¥ÀÌÅÍ »èÁ¦¿¡ ½ÇÆÐÇÏ¿´½À´Ï´Ù.'); } if($User_Board_Setting->c_list_delete == 1) { if($mysql_rows[b_depth2] == 0 && $mysql_rows[b_depth3]==0) { $delete_reply_query = "delete from $data_table where b_depth1='$num'"; $delete_reply_result= mysql_query($delete_reply_query); } $memo_table = $data_table."_memo"; $delete_memo_query = "delete from $memo_table where num='$num'"; $delete_memo_result = mysql_query($delete_memo_query); } $Error_Path->ok_page1("$PHP_SELF?data_table=$data_table&mode=list&page=$page&field=$field&key=$key"); } } function memo_delete($data_table,$pwss,$num,$page,$field,$key,$m_num) { $Error_Path = new Error_Path(); $Dbconnect = new Dbconn(); $data_table_memo = $data_table."_"."memo"; $select_read_memo_query = "select * from $data_table_memo where m_num='$m_num' and num = '$num' and m_pwss='$pwss'"; $select_read_memo_result = mysql_query($select_read_memo_query); if(!$select_read_memo_result) { $Error_Path->error_page1('ÆÐ½º¿öµå°¡ ÀÏÄ¡ÇÏÁö ¾Ê½À´Ï´Ù.'); } else { $select_memo_rows = mysql_num_rows($select_read_memo_result); if($select_memo_rows<1) { $Error_Path->error_page1('ÆÐ½º¿öµå°¡ ÀÏÄ¡ÇÏÁö ¾Ê½À´Ï´Ù.'); } } $delete_memo_query = "delete from $data_table_memo where m_num='$m_num' and num = '$num' and m_pwss='$pwss'"; $delete_memo_result = mysql_query($delete_memo_query); if(!$delete_memo_result) { $Error_Path->error_page1('¸Þ¸ð±Û »èÁ¦¿¡ ½ÇÆÐÇÏ¿´½À´Ï´Ù.'); } $Error_Path->ok_page1("$PHP_SELF?data_table=$data_table&mode=read&page=$page&field=$field&key=$key&num=$num"); } //¸Þ¸ð »èÁ¦ } ?>