db_table."_config"; // Å×À̺í Á¤º¸ $board_code_config = $board_code."_userconfig"; if($board_code == '' || $board_name == '') { $Error_Path->error_page1('°Ô½ÃÆÇ ÄÚµå ¶Ç´Â °Ô½ÃÆÇ À̸§À» ÀÔ·ÂÇϼ¼¿ä.'); } $dup_select_query = "select c_list_tblcode from $table where c_list_tbl_code='$board_code_config'"; $dup_select_result = mysql_query($dup_select_query); $dup_result = mysql_list_tables($Dbconnect->db_database); $i = 0; //echo $Dbconnect->db_database; while($i < mysql_num_rows($dup_result)) { $tb_name[$i] = mysql_tablename($dup_result,$i); if($board_code == $tb_name[$i]) { $dup_check1 = '1'; } $i++; } if($dup_select_result) { $dup_select_row = mysql_num_rows($dup_select_result); if($dup_select_row > 0) { $dup_check2 = '1'; } } // echo "$board_code; $board_code_memo;"; // exit; $create_tbl_query = "create table $board_code ( b_num int not null, ##°Ô½Ã¹°¹øÈ£ b_id char(14), ##ÀÛ¼ºÀÚ¾ÆÀ̵ð b_name varchar(30), ##ÀÛ¼ºÀÚ À̸§ b_email varchar(60), ##ÀÛ¼ºÀÚ À̸ÞÀÏ b_homepage varchar(70), ##ÀÛ¼ºÀÚ È¨ÆäÀÌÁö b_avata_img varchar(30), ##¾Æ¹ÙŸ ¾ÆÀÌÄÜ b_user_ip varchar(40), ##ÀÛ¼ºÀÚ ¾ÆÀÌÇÇ b_regdate varchar(30), ##ÀÛ¼ºÀÚ µî·ÏÀÏ b_modifydate varchar(30), ##ÀÛ¼ºÀÚ ¼öÁ¤ÀÏ b_subject varchar(50), ##ÀÛ¼ºÀÚ Á¦¸ñ b_content text, ##ÀÛ¼º ³»¿ë b_userfile varchar(80), ##µî·ÏµÈ ÆÄÀÏ b_userfile_size varchar(50), ##µî·Ï ÆÄÀÏ Å©±â b_read varchar(20), ##Á¶È¸¼ö b_pwss varchar(14), ##ºñ¹Ð¹øÈ£ b_depth1 double, b_depth2 double, b_depth3 double, b_color varchar(40), b_fontline int(1), primary key(b_num))"; $create_tbl_result = mysql_query($create_tbl_query); $board_code_memo = $board_code."_memo"; $make_memo_tbl_query = "create table $board_code_memo ( ##¸Þ¸ð °Ô½ÃÆÇ m_num int auto_increment, m_id char(14), m_name varchar(30), m_comment text, m_avata varchar(50), m_reg_date date, m_mod_date date, m_table varchar(40), m_tnum int(20), m_userip varchar(30), m_pwss varchar(14), num varchar(20), primary key(m_num))"; //echo $make_memo_tbl_query; //exit; $make_memo_tbl_result = mysql_query($make_memo_tbl_query); ##¸Þ¸ð°Ô½ÃÆÇ »ý¼º if(!$create_tbl_result) { $Error_Path->error_page1('°Ô½ÃÆÇ »ý¼º¿¡ ½ÇÆÐÇÏ¿´½À´Ï´Ù.'); } $insert_into_query = "insert into $table ( c_list_tblcode, c_list_tblname, c_list_adminid, c_list_adminpwss, c_list_adminemail, c_list_adminhomepage, c_list_adminname, c_list_tblskin, c_list_tbl_page_count, c_list_tbl_block_count, c_list_width, c_list_auth, c_list_pds_gesi, c_list_pds_down, c_list_file_icon, c_list_total_list, c_list_html_comment, c_list_one_list, c_list_two_list, c_list_send_mail_check, c_list_send_font_color, c_list_send_font_width, c_list_icon_new, c_list_icon_hot, c_list_new, c_list_hot, c_list_icon_gon, c_list_subject_length, c_list_memo_check, c_list_ip_check, c_list_avata_check, c_list_memo_avata_check, c_list_class_check, c_list_popup_check, c_list_subject_class, c_list_delete, c_list_tbl_head_message, c_list_tbl_foot_message ) values ( '$board_code', '$board_name', '$c_list_adminid', '$c_list_adminpwss', '$email', '$homepage', '$name', 'josskin', '10', '10', '700', '1', '0', '1', '0', '0', '1', 'white', 'white', '3', '1', '1', '1', '1', '3', '3', '1', '40', '1', '1', '1', '1', '1', '0', '10', '0', '
', '
JOSBBS :: CHO FHAN SUNG
' )"; $insert_into_result = mysql_query($insert_into_query); if($insert_into_result) { $Error_Path->error_page2('Å×ÀÌºí »ý¼ºÀÌ ¿Ï·áµÇ¾ú½À´Ï´Ù.','./admin_gesi_list_function.html?mode=c_list&admin_mode=board_list'); } else { $Error_Path->error_page1('Å×ÀÌºí »ý¼ºÁß ¿À·ù°¡ ¹ß»ýÇÏ¿´½À´Ï´Ù.'); }//avata_add ÇÔ¼ö ºÎºÐ } function board_list($page,$field,$key) { //¸®½ºÆ® º¸À̱â if($page == '') { $page=1; } $Error_Path = new Error_Path(); $Dbconnect=new Dbconn(); $db_table=$Dbconnect->db_table."_config"; $total_select = "select c_num,c_list_tblcode,c_list_tblname from $db_table order by c_num desc"; $total_result = mysql_query($total_select); if($total_result) { $this->t_count = mysql_num_rows($total_result); //Àüü ·¹ÄÚµå ¼ö } if($key != '' && $field != '') { $search_select = "select c_num,c_list_tblcode,c_list_tblname from $db_table where $field like '%$key%' order by c_num desc"; $search_result = mysql_query($search_select); if($search_result) { $this->s_count = mysql_num_rows($search_result); //°Ë»öµÈ ·¹ÄÚµå ¼ö } } else { $search_select = "select c_num,c_list_tblcode,c_list_tblname from $db_table order by c_num desc"; $search_result = mysql_query($search_select); if($search_result) { $this->s_count = mysql_num_rows($search_result); //°Ë»öµÈ ·¹ÄÚµå ¼ö } } #############################ÅäÅ» °¹¼ö¿Í °Ë»öµÈ °¹¼ö¸¦ ±¸ÇÏ´Â ºÎºÐ################# ############################################################################### $virtual_count = $this->s_count / $page; //°¡»óÀÇ ¹øÈ£ ºÎ¿© $first_record = (int)(($page-1) * $this->page_count); //ÆäÀÌÁöº° ù·¹ÄÚµå $last_record = $page * $this->page_count; //ÆäÀÌÁöº° ¸¶Áö¸· ·¹ÄÚµå $next_page = $this->s_count - $last_record; if($next_page > 0) { $last_record -= 1; } else { $last_record = $this->s_count - 1; } $prev_button = $page-1; //ÀÌÀü ÆäÀÌÁö $next_button = $page+1; //´ÙÀ½ÆäÀÌÁö $this->total_page = ceil($this->s_count / $this->page_count); //Àüü ÆäÀÌÁö $total_block = ceil($this->total_page / $this->block_count); //Àüü ºí·° $search_page = $total_block/$this->block_count; $now_block = ceil($page/$this->block_count); $start_page = (int)(($now_block-1)*$this->block_count); //½ÃÀÛ ÆäÀÌÁö $end_page = (int)($now_block*$this->block_count); //¸¶Áö¸· ÆäÀÌÁö if($now_block >= $total_block) { $end_page = $this->total_page; } if($this->s_count != 0){ if($prev_button > 0) { //ÀÌÀü ÆäÀÌÁö $this->prev_page1 = "<-"; } if($next_button <= $this->total_page) { //´ÙÀ½ ÆäÀÌÁö $this->next_page1 = "->"; } if($now_block > 1) { $prev_button = $start_page; $this->prev_block = "<<-"; } if($now_block < $total_block) { $next_button = $end_page +1; $this->next_block = "->>"; } for($i=$first_record; $i <= $last_record; $i++) { $this->num=mysql_result($search_result,$i,0); $this->code=mysql_result($search_result,$i,1); $this->name=mysql_result($search_result,$i,2); $this->table_result .= " $virtual_count$this->code$this->namenum>¼³Á¤ | num>»èÁ¦ "; $virtual_count--; } //for } else {//0ÀÌ ¾Æ´Ò °æ¿ì $this->table_result = "°Ë»öµÈ ÀÚ·á°¡ ¾ø½À´Ï´Ù."; } //0ÀÏ °æ¿ì if($this->s_count != 0){ for($list_page=$start_page+1; $list_page <=$end_page; $list_page++) { if($page != $list_page) { $this->page_list .= "[$list_page]"; } else { $this->page_list .= "[$list_page]"; } } } else { $this->page_list .= "[1]"; } //Àüü °ü¸®ÀÚ ·Î±×ÀÎÀÌ µÇ¾úÀ» °æ¿ì } function admin_modify($num) { $Error_Path = new Error_Path(); $Dbconnect = new Dbconn(); $avata_table=$Dbconnect->db_table."_avata"; $modify_select = "select * from $avata_table where a_num = $num"; $modify_result = mysql_query($modify_select); if($modify_result) { $modify_rows = mysql_fetch_array($modify_result); $this->modify_num = $modify_rows[a_num]; $this->modify_name = $modify_rows[a_name]; $this->modify_code = $modify_rows[a_code]; } } function avata_modify($num,$name,$imgavata,$imgavata_name) { $Error_Path = new Error_Path(); // ¿¡·¯ °´Ã¼ »ý¼º $Dbconnect = new Dbconn(); // µ¥ÀÌŸ º£À̽º °´Ã¼ »ý¼º $avata_table=$Dbconnect->db_table."_avata"; // ¾Æ¹ÙŸ Å×À̺í Á¤º¸ ######################################################################################## #########################ÆÄÀÏ Á¤º¸¿¡ ´ëÇÑ ±ÔÄ¢À» Àû¿ë###################################### ####################################################################################### if($imgavata_name == '' || $imgavata_name == 'none') { //ÆÄÀÏÀ» ¼±ÅÃÇÏ¿´´ÂÁö üũ $Error_Path->error_page1('ÆÄÀÏÀ» ¼±ÅÃÇÏ¿© Áֽñ⠹ٶø´Ï´Ù.'); } if(ereg("[[:space:]]",$imgavata_name) ) { //ÆÄÀÏ¸í¿¡ °ø¹éÀÌ ÀÖ´ÂÁö üũ $Error_Path->error_page1('ÆÄÀÏÀ̸§¿¡ °ø¹éÀÌ ÀÖ½À´Ï´Ù.'); } $full_filename = explode(".",$imgavata_name); $extention = $full_filename[sizeof($full_filename)-1]; $a=sizeof($full_filename); while($a >= 2) { $filename .=$full_filename[sizeof($full_filename)-$a]; $filename .="."; $a--; } $avata_img_name = $filename.$extention; if($extention != 'jpeg' && $extention != 'jpg' && $extention != 'gif' && $extention != 'png') { $Error_Path->error_page1('¿Ã¹Ù¸¥ À̹ÌÁö ÆÄÀÏÀÌ ¾Æ´Õ´Ï´Ù.'); } if(!file_exists("$this->avata_savedir")){mkdir($this->avata_savedir,0777);} $file_serch = file_exists("$this->avata_savedir/$avata_img_name"); $k=0; while($file_serch) //°°Àº ÆÄÀÏÀÌ ÀÖ´Â °æ¿ì { $full_filename= explode(".", "$avata_img_name"); //È®ÀåÀÚ¸¦ °¡Áö°í ¿Í¼­ $extention = $full_filename[sizeof($full_filename)-1]; $filename .="_1"; $avata_img_name=$filename.".".$extention ; $file_serch = file_exists("$this->avata_savedir/$avata_img_name"); } if(!copy($imgavata,"$this->avata_savedir/$avata_img_name")) { $Error_Path->error_page1('ÆÄÀÏÀ» º¹»çÇϴµ¥ ½ÇÆÐÇÏ¿´½À´Ï´Ù.'); } if(!unlink($imgavata)) { $Error_Path->error_page1('ÀÓ½ÃÆÄÀÏÀ» »èÁ¦Çϴµ¥ ½ÇÆÐÇÏ¿´½À´Ï´Ù.'); } $insert_avata_query = "update $avata_table set a_code='$avata_img_name',a_name='$name' where a_num='$num'"; $insert_avata_result = mysql_query($insert_avata_query); //µ¥ÀÌŸ º£À̽º Äõ¸®¸¦ ³¯¸°´Ù. if($insert_avata_result) { $Error_Path->error_page2('¿Ã¹Ù¸£°Ô ¼öÁ¤µÇ¾ú½À´Ï´Ù.','./admin_avata_list_function.html?admin_mode=avata_list&mode=a_list'); } } function avata_delete($num) { $Error_Path = new Error_Path(); $Dbconnect = new Dbconn(); $avata_table=$Dbconnect->db_table."_avata"; $delete_query = "delete from $avata_table where a_num = '$num'"; $delete_result = mysql_query($delete_query); if($delete_result) { $Error_Path->error_page2('¿Ã¹Ù¸£°Ô »èÁ¦µÇ¾ú½À´Ï´Ù.','./admin_avata_list_function.html?admin_mode=avata_list&mode=a_list'); } } function board_login($board_id,$board_pwss) { $Error_Path = new Error_Path(); $Dbconnect = new Dbconn(); $select_login_query = "select i_num from $Dbconnect->db_table where i_admin_id='$board_id' and i_admin_pwss='$board_pwss'"; $select_login_result = mysql_query($select_login_query); if($select_login_result) { $select_login_rows = mysql_num_rows($select_login_result); if($select_login_rows > 0) { $Error_Path->error_page2('°Ô½ÃÆÇ Àüü°ü¸®ÀÚ ·Î±×ÀÎÀÌ µÇ¾ú½À´Ï´Ù.',"./admin_gesi_tlogin_ok.html?id=$board_id&pwss=$board_pwss"); } else { $Error_Path->error_page1('¾ÆÀ̵ð ¶Ç´Â ºñ¹Ð¹øÈ£°¡ ÀÏÄ¡ÇÏÁö ¾Ê½À´Ï´Ù.'); } } } } //Ŭ·¡½º ¸¶Áö¸· ºí·° $Error_Path = new Error_Path(); include "./admin_cookie_check.html"; //·Î±×ÀÎ µÈ »ç¿ëÀÚÀÎÁö È®ÀÎ $Dbconnect = new Dbconn(); include "./admin_cookie_check.html"; //·Î±×ÀÎ µÈ »ç¿ëÀÚÀÎÁö È®ÀÎ $Board_Config_List = new Board_Config_List(); switch($admin_mode) { //ÇÔ¼ö¸¦ È£ÃâÇÏ´Â ºÎºÐ case 'board_make' : $Board_Config_List->board_make($board_code,$board_name,$email,$homepage,$name,$c_list_adminid,$c_list_adminpwss); break; case 'board_login' : $Board_Config_List->board_login($board_id,$board_pwss); break; case 'avata_add' : $Board_Config_List->avata_add($name,$imgavata_name,$imgavata); break; case 'admin_modify' : $Board_Config_List->avata_modify($num,$name,$imgavata,$imgavata_name); break; case 'admin_delete' : $Board_Config_List->avata_delete($num); break; case 'board_list' : if($board_root != '' && $board_check != '') { $board_root_form ="
Àüü °Ô½ÃÆÇ °ü¸®ÀÚ·Î ·Î±×ÀÎ µÇ¾ú½À´Ï´Ù.
"; }else { $board_root_form ="
¾ÆÀ̵ð : (±âÁ¸ °ü¸®ÀÚ ¾ÆÀ̵ð ¹× ÆÐ½º¿öµå¸¦ ÀÔ·ÂÇÏ½Ã¸é µË´Ï´Ù.)
ºñ¹Ð¹øÈ£ :
"; } $Board_Config_List->board_list($page,$field,$key); break; case 'admin_modify' : $Board_Config_List->admin_modify($num); //$modify_img=Board_Config_List->avata_savedir."/".Board_Config_List->modify_code; break; } switch($mode) { case 'a_insert' : include "./admin_avata_add_form.html"; break; case 'c_modify' : include "./admin_gesi_modify_form.html"; break; case 'c_list' : include "./admin_gesi_list_form.html"; break; } ?>