db_table."_memo_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 = "insert into $avata_table (ma_code,ma_name) values ('$avata_img_name','$name')"; $insert_avata_result = mysql_query($insert_avata_query); //µ¥ÀÌŸ º£À̽º Äõ¸®¸¦ ³¯¸°´Ù. if($insert_avata_result) { $Error_Path->error_page2('¿Ã¹Ù¸£°Ô µî·ÏµÇ¾ú½À´Ï´Ù.','./admin_avata_memo_list_function.html?admin_mode=avata_list&mode=a_list'); } } //avata_add ÇÔ¼ö ºÎºÐ function avata_list1($page,$field,$key) { //¸®½ºÆ® º¸À̱â if($page == '') { $page=1; } $Error_Path = new Error_Path(); $Dbconnect=new Dbconn(); $avata_table=$Dbconnect->db_table."_memo_avata"; $total_select = "select * from $avata_table order by ma_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 * from $avata_table where $field like $key order by ma_num desc"; $search_result = mysql_query($search_select); if($search_result) { $this->s_count = mysql_num_rows($search_result); //°Ë»öµÈ ·¹ÄÚµå ¼ö } } else { $search_select = "select * from $avata_table"; $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->name=mysql_result($search_result,$i,1); $this->code=mysql_result($search_result,$i,2); if($i%6 == 0) { if($i != 0) { $this->table_result .= ""; } else { $this->table_result .= ""; } $this->table_result .= "
$this->name
avata_savedir/$this->code border=0 height=50 width=60>
num>¼öÁ¤|num>»èÁ¦
"; } else { $this->table_result .= "
$this->name
avata_savedir/$this->code border=0 height=50 width=60>
num>¼öÁ¤|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."_memo_avata"; $modify_select = "select * from $avata_table where ma_num = $num"; $modify_result = mysql_query($modify_select); if($modify_result) { $modify_rows = mysql_fetch_array($modify_result); $this->modify_num = $modify_rows[ma_num]; $this->modify_name = $modify_rows[ma_name]; $this->modify_code = $modify_rows[ma_code]; } } function avata_modify($num,$name,$imgavata,$imgavata_name) { $Error_Path = new Error_Path(); // ¿¡·¯ °´Ã¼ »ý¼º $Dbconnect = new Dbconn(); // µ¥ÀÌŸ º£À̽º °´Ã¼ »ý¼º $avata_table=$Dbconnect->db_table."_memo_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 ma_code='$avata_img_name',ma_name='$name' where ma_num='$num'"; $insert_avata_result = mysql_query($insert_avata_query); //µ¥ÀÌŸ º£À̽º Äõ¸®¸¦ ³¯¸°´Ù. if($insert_avata_result) { $Error_Path->error_page2('¿Ã¹Ù¸£°Ô ¼öÁ¤µÇ¾ú½À´Ï´Ù.','./admin_avata_memo_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."_memo_avata"; $delete_query = "delete from $avata_table where ma_num = '$num'"; $delete_result = mysql_query($delete_query); if($delete_result) { $Error_Path->error_page2('¿Ã¹Ù¸£°Ô »èÁ¦µÇ¾ú½À´Ï´Ù.','./admin_avata_memo_list_function.html?admin_mode=avata_list&mode=a_list'); } } } //Ŭ·¡½º ¸¶Áö¸· ºí·° $Error_Path = new Error_Path();; include "./admin_cookie_check.html"; //·Î±×ÀÎ µÈ »ç¿ëÀÚÀÎÁö È®ÀÎ $Dbconnect = new Dbconn(); include "./admin_cookie_check.html"; //·Î±×ÀÎ µÈ »ç¿ëÀÚÀÎÁö È®ÀÎ $Avata_list = new Avata_Memo_list(); switch($admin_mode) { //ÇÔ¼ö¸¦ È£ÃâÇÏ´Â ºÎºÐ case 'avata_add' : $Avata_list->avata_add($name,$imgavata_name,$imgavata); break; case 'avata_modify' : $Avata_list->avata_modify($num,$name,$imgavata,$imgavata_name); break; case 'avata_del' : $Avata_list->avata_delete($num); break; case 'avata_list' : //$Avata_list->avata_list1($page,$field,$key); break; case 'admin_modify' : $Avata_list->admin_modify($num); $modify_img=$Avata_list->avata_savedir."/".$Avata_list->modify_code; break; } switch($mode) { case 'a_insert' : include "./admin_avata_add_memo_form.html"; break; case 'a_modify' : include "./admin_avata_modify_memo_form.html"; break; case 'a_list' : include "./admin_avata_list_memo_form.html"; break; } ?>