user_board_config($data_table); if($check_board=='0') { $Error_Path->error_page1('°Ô½ÃÆÇÀÇ È¯°æ¼³Á¤À» °¡Á® ¿Ã¼ö¾ø½À´Ï´Ù.'); } $User_board_Display ->display_etc_info(); $User_board_Display -> display_list(); $this->board_list_tbl_head_message= $User_board_Display->display_list_tbl_head_message; $this->board_list_tbl_tail_message= $User_board_Display->display_list_tbl_foot_message; global $File_check_img; if($page == '') { $page=1; } $Error_Path = new Error_Path(); $Dbconnect=new Dbconn(); $total_select = "select b_num,b_id,b_name,b_email,b_homepage,b_avata_img,b_user_ip,b_regdate,b_modifydate,b_subject,b_content,b_userfile,b_userfile_size,b_read,b_pwss,b_depth1,b_depth2,b_depth3,b_color,b_fontline from $data_table order by b_depth1 desc,b_depth3 asc"; $total_result = mysql_query($total_select); if($total_result) { $this->t_count = mysql_num_rows($total_result); //Àüü ·¹ÄÚµå ¼ö } if($key != '' && $field != '') { $search_select = "select b_num,b_id,b_name,b_email,b_homepage,b_avata_img,b_user_ip,b_regdate,b_modifydate,b_subject,b_content,b_userfile,b_userfile_size,b_read,b_pwss,b_depth1,b_depth2,b_depth3,b_color,b_fontline from $data_table where $field like '%$key%' order by b_depth1 desc,b_depth3 asc"; //echo $search_select; $search_result = mysql_query($search_select); if($search_result) { $this->s_count = mysql_num_rows($search_result); //°Ë»öµÈ ·¹ÄÚµå ¼ö } } else { $search_select = "select b_num,b_id,b_name,b_email,b_homepage,b_avata_img,b_user_ip,b_regdate,b_modifydate,b_subject,b_content,b_userfile,b_userfile_size,b_read,b_pwss,b_depth1,b_depth2,b_depth3,b_color,b_fontline from $data_table order by b_depth1 desc,b_depth3 asc"; $search_result = mysql_query($search_select); if($search_result) { $this->s_count = mysql_num_rows($search_result); //°Ë»öµÈ ·¹ÄÚµå ¼ö } } #############################ÅäÅ» °¹¼ö¿Í °Ë»öµÈ °¹¼ö¸¦ ±¸ÇÏ´Â ºÎºÐ################# ############################################################################### $virtual_count = ($this->s_count - ($page-1)* $User_board_Display->display_list_tbl_page_count); //°¡»óÀÇ ¹øÈ£ ºÎ¿© $first_record = (int)(($page-1) * $User_board_Display->display_list_tbl_page_count); //ÆäÀÌÁöº° ù·¹ÄÚµå $last_record = $page * $User_board_Display->display_list_tbl_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 / $User_board_Display->display_list_tbl_page_count); //Àüü ÆäÀÌÁö $total_block = ceil($this->total_page / $User_board_Display->display_list_tbl_block_count); //Àüü ºí·° $search_page = $total_block/$User_board_Display->display_list_tbl_block_count; $now_block = ceil($page/$User_board_Display->display_list_tbl_block_count); $start_page = (int)(($now_block-1)*$User_board_Display->display_list_tbl_block_count); //½ÃÀÛ ÆäÀÌÁö $end_page = (int)($now_block*$User_board_Display->display_list_tbl_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 = ""; } if($User_board_Display->display_list_icon_gon!=0) { $User_board_Display->display_list_tbl_line_subject; $this->list_tbl_line_subject= "
°øÁö display_list_adminemail>$User_board_Display->display_list_adminname b_num&data_table=$data_table&page=$page&field=$field&key=$key&user=admin_gons> $User_board_Display->display_list_tbl_line_subject
"; } for($i=$first_record; $i <= $last_record; $i++) { $this->b_num=mysql_result($search_result,$i,0); ##°Ô½Ã¹°¹øÈ£ $this->b_id=mysql_result($search_result,$i,1); ##ÀÛ¼ºÀÚ¾ÆÀ̵ð $this->b_name=mysql_result($search_result,$i,2); ##ÀÛ¼ºÀÚ À̸§ $this->b_email=mysql_result($search_result,$i,3); ##ÀÛ¼ºÀÚ À̸ÞÀÏ $this->b_homepage=mysql_result($search_result,$i,4); ##ÀÛ¼ºÀÚ È¨ÆäÀÌÁö $this->b_avata_img=mysql_result($search_result,$i,5); ##¾Æ¹ÙŸ ¾ÆÀÌÄÜ $this->b_user_ip=mysql_result($search_result,$i,6); ##ÀÛ¼ºÀÚ ¾ÆÀÌÇÇ $this->b_regdate=mysql_result($search_result,$i,7); ##ÀÛ¼ºÀÚ µî·ÏÀÏ $this->b_modifydate=mysql_result($search_result,$i,8); ##ÀÛ¼ºÀÚ ¼öÁ¤ÀÏ $this->b_subject=mysql_result($search_result,$i,9); ##ÀÛ¼ºÀÚ Á¦¸ñ $this->b_content=mysql_result($search_result,$i,10); ##ÀÛ¼º ³»¿ë $this->b_userfile=mysql_result($search_result,$i,11); ##µî·ÏµÈ ÆÄÀÏ $this->b_userfile_size=mysql_result($search_result,$i,12);##µî·Ï ÆÄÀÏ Å©±â $this->b_read=mysql_result($search_result,$i,13); ##Á¶È¸¼ö $this->b_pwss=mysql_result($search_result,$i,14); ##ºñ¹Ð¹øÈ£ $this->b_depth1=mysql_result($search_result,$i,15); $this->b_depth2=mysql_result($search_result,$i,16); $this->b_depth3=mysql_result($search_result,$i,17); $this->b_color=mysql_result($search_result,$i,18); $this->b_fontline=mysql_result($search_result,$i,19); $reg_date = explode(' ',$this->b_regdate); if($User_board_Display->display_list_auth==0) { $id = $this->b_name; } else { $id = $this->b_id; //."(".$this->b_name.")"; } if($i%2 == 0) { $line_bg = $User_board_Display->display_list_one_list; } else { $line_bg = $User_board_Display->display_list_two_list; } if($User_board_Display->display_list_send_font_color!=0) { $font_color=$this->b_color; } else { $font_color="000000"; } if($this->b_fontline != 0) { $font_width=""; $font_width1=""; } //echo $User_board_Display->display_list_new; if($User_board_Display->display_list_icon_new != 0) { if($User_board_Display->display_list_new != 0) { $now_date = date("Y-n-d"); $source_date = $reg_date[0]; $cmp_day=$User_board_Display->display_list_new; ////echo "$source_date"; //echo "$cmp_day"; //±â±³ÇÒ ±â°£ //echo $now_date; //echo "
"; $check_new=$Function_Etc->Date_cmp($now_date,$source_date,$cmp_day); if($check_new == '1') { $new_icon = ""; } } } if($User_board_Display->display_list_icon_hot != 0) { if($User_board_Display->display_list_hot!=0) { if($User_board_Display->display_list_hot <= $this->b_read) { $hot_icon = ""; } } } if($User_board_Display->display_list_pds_gesi !=0) { if($User_board_Display->display_list_file_icon !=0) { $full_filename= explode(".", " $this->b_userfile"); //È®ÀåÀÚ¸¦ °¡Áö°í ¿Í¼­ $extention = $full_filename[sizeof($full_filename)-1]; $size_array=sizeof($File_check_img); $e=0; while($e<=$size_array) { if($extention==$File_check_img[$e]) { $file_icon="$File_check_img[$e]."."gif"; break; } else { $file_icon = "default.gif"; } $e++; } $file_icon_img = ""; } if($User_board_Display->display_list_pds_down !=0) { if($this->b_userfile == '') { $file_icon_down=$file_icon_img; } else { $file_icon_down = "".$file_icon_img.""; } } } $this->b_subject=stripslashes($this->b_subject); $this->b_subject=$Function_Etc->Cut_String_dot($this->b_subject,$User_board_Display->display_list_subject_length); if($this->b_depth2 > 0){ $depth=$this->b_depth2; $nbsp=""; while($depth >= 1) { if($User_board_Display->display_list_subject_class >= $depth) { $nbsp .= "  "; } $depth--; } $this->b_subject = "".$this->b_subject; } else { $nbsp=""; $this->b_subject = $this->b_subject; } if($User_board_Display->display_list_popup_check==0) { $subject=$nbsp."b_num&data_table=$data_table&page=$page&field=$field&key=$key>".$this->b_subject.""; } else { $subject=$nbsp."b_num','$data_table')>".$this->b_subject.""; } $this->table_result .= ""; $this->table_result .= ""; $this->table_result .= ""; $this->table_result .= ""; $this->table_result .= ""; $this->table_result .= ""; $this->table_result .= ""; $this->table_result .= ""; $this->table_result .= ""; $this->table_result .="
$virtual_count b_email>$id $file_icon_down $font_width$subject$font_width1 $new_icon $hot_icon $reg_date[0] $this->b_read
"; $this->table_result .="
"; $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 data_read($data_table,$page,$field,$key,$num) { //µ¥ÀÌŸ ¸®µå °¡Áö°í ¿À±â $Error_Path = new Error_Path(); //¿¡·¯°¡ ³ª¿Ã°æ¿ì ÆäÀÌÁö À̵¿ $Function_Etc = new Function_Etc; //±âŸ ³»¿ë Ŭ·¡½º $Dbconnect=new Dbconn(); $User_board_Display=new User_board_Display(); $check_board=$User_board_Display->user_board_config($data_table); //µ¥ÀÌŸ º£À̽º ȯ°æ if($check_board=='0') { $Error_Path->error_page1('°Ô½ÃÆÇÀÇ È¯°æ¼³Á¤À» °¡Á® ¿Ã¼ö¾ø½À´Ï´Ù.'); } $User_board_Display ->display_etc_info(); $User_board_Display -> display_read(); $this->board_list_tbl_head_message= $User_board_Display->display_list_tbl_head_message; $this->board_list_tbl_tail_message= $User_board_Display->display_list_tbl_foot_message; $this->board_list_width=$User_board_Display->c_list_width; global $File_check_img; $update_read_query = "update $data_table set b_read=b_read+1 where b_num='$num'"; $update_read_result = mysql_query($update_read_query); $select_read_query = "select * from $data_table where b_num='$num'"; $select_read_result = mysql_query($select_read_query); if(!$select_read_result) { $Error_Path->error_page1('ÀڷḦ °¡Áö°í ¿Ã¼ö ¾ø½À´Ï´Ù.'); } $data_table_memo = $data_table."_"."memo"; $select_read_memo_query = "select * from $data_table_memo where num='$num' order by m_num desc"; $select_read_memo_result = mysql_query($select_read_memo_query); if($select_read_memo_result) { while($select_read_memo_rows = mysql_fetch_array($select_read_memo_result)) { $this->m_num=$select_read_memo_rows[m_num]; $this->m_id =$select_read_memo_rows[m_id]; $this->m_name=$select_read_memo_rows[m_name]; $this->m_comment=$select_read_memo_rows[m_comment]; $this->m_avata =$select_read_memo_rows[m_avata]; $this->m_reg_date=$select_read_memo_rows[m_reg_date]; $this->m_mod_date=$select_read_memo_rows[m_mod_date]; $this->m_comment=stripslashes($this->m_comment); $this->m_comment=htmlspecialchars($this->m_comment); $this->m_comment = nl2br($this->m_comment); if($User_board_Display->display_list_auth != 0){ //ºñȸ¿ø ȸ¿ø °Ô½ÃÆÇ $m_id = "(".$this->m_id .")"; } if($this->m_avata == '') { $this->m_avata='memo_avata.gif'; } if($User_board_Display->display_list_memo_avata_check) { include "../skin/$User_board_Display->display_list_tblskin/user_board_memo_avata_list.html"; } else { include "../skin/$User_board_Display->display_list_tblskin/user_board_memo_list.html"; } } } $select_read_rows = mysql_fetch_array($select_read_result); $this->b_num=$select_read_rows[b_num]; $this->b_id=$select_read_rows[b_id]; $this->b_name=$select_read_rows[b_name]; $this->b_email=$select_read_rows[b_email]; $this->b_homepage=$select_read_rows[b_homepage]; $this->b_avata_img=$select_read_rows[b_avata_img]; $this->b_user_ip=$select_read_rows[b_user_ip]; $this->b_regdate=$select_read_rows[b_regdate]; $this->b_modifydate=$select_read_rows[b_modifydate]; $this->b_subject=$select_read_rows[b_subject]; $this->b_content=$select_read_rows[b_content]; $this->b_userfile=$select_read_rows[b_userfile]; $this->b_userfile_size=$select_read_rows[b_userfile_size]; $this->b_read=$select_read_rows[b_read]; $this->b_pwss=$select_read_rows[b_pwss]; $this->b_depth1=$select_read_rows[b_depth1]; $this->b_depth2=$select_read_rows[b_depth2]; $this->b_depth3=$select_read_rows[b_depth3]; $this->b_color=$select_read_rows[b_color]; $this->b_fontline=$select_read_rows[b_fontline]; $this->b_subject=stripslashes($this->b_subject); $this->b_content=stripslashes($this->b_content); if($User_board_Display->display_list_html_comment!=1) { $this->b_content=htmlspecialchars($this->b_content); } $this->b_content = nl2br($this->b_content); if($User_board_Display->display_list_avata_check!=0) { $this->b_avata_img="../avata_icon/$this->b_avata_img"; } else { $this->b_avata_img='../img/top_avata.gif'; } if($User_board_Display->display_list_send_font_color!=0) { $font_color=$this->b_color; } else { $font_color="#000000"; } if($this->b_fontline != 0) { $font_width=""; $font_width1=""; } $this->b_subject = "$font_width$this->b_subject$font_width1"; //Á¦¸ñ ºÎºÐ »ö»ó ¹× ±½±â if($User_board_Display->display_list_ip_check != 0){ $this->b_user_ip = "ip : $this->b_user_ip"; } else { $this->b_user_ip =""; } if($User_board_Display->display_list_auth == 0){ //ºñȸ¿ø ȸ¿ø °Ô½ÃÆÇ $this->b_name = $this->b_name; } else { $this->b_name = $this->b_id." (".$this->b_name.")"; } $this->b_homepage="b_homepage target=_blank>".$this->b_homepage.""; if($User_board_Display->display_list_pds_gesi !=0) { if($User_board_Display->display_list_file_icon !=0) { $full_filename= explode(".", " $this->b_userfile"); //È®ÀåÀÚ¸¦ °¡Áö°í ¿Í¼­ $extention = $full_filename[sizeof($full_filename)-1]; $size_array=sizeof($File_check_img); $e=0; while($e<=$size_array) { if($extention==$File_check_img[$e]) { $file_icon="$File_check_img[$e]."."gif"; break; } else { $file_icon = "default.gif"; } $e++; } $file_icon_img = ""; } if($User_board_Display->display_list_pds_down !=1) { if($this->b_userfile == '') { $this->b_userfile="ÆÄÀϸí : $file_icon_img"; } else { $this->b_userfile = "ÆÄÀϸí : $file_icon_img ".$this->b_userfile." "; } } } } //data_read ¸Þ¼Òµå //Àб⠸ðµå¿¡¼­ ¸Þ¸ð±ÛÀ» µî·ÏÇÏ´Â ¸Þ¼Òµå function data_memo_insert($data_table,$m_id,$m_name,$m_comment,$m_avata,$key,$num,$m_pwss) { $Error_Path = new Error_Path(); $Dbconnect = new Dbconn(); $memo_board = $data_table."_"."memo"; $m_reg_date = date("Y-m-d"); $m_comment = addslashes($m_comment); $memo_insert_query = "insert into $memo_board (m_id,m_name,m_avata,m_comment,m_reg_date,m_pwss,num) values ('$m_id','$m_name','$m_avata','$m_comment','$m_reg_date','$m_pwss','$num')"; $memo_insert_result = mysql_query($memo_insert_query); if(!$memo_insert_result) { $Error_Path->error_page1('¸Þ¸ð ÀԷ¿¡ ½ÇÆÐÇÏ¿´½À´Ï´Ù.'); } } function modify_form($num,$data_table) { //´äº¯À» ´Þ±â À§ÇÑ Æû¿¡ ³»¿ëÀ» °¡Á® ¿À´Â °÷ $Error_Path = new Error_Path(); $Dbconnect = new Dbconn(); $reply_form_query = "select * from $data_table where b_num='$num'"; $reply_form_result = mysql_query($reply_form_query); if($reply_form_result) { $reply_form_rows = mysql_fetch_array($reply_form_result); } else { $Error_Path->error_page1('¿ø±Û¿¡ ´ëÇÑ ³»¿ëÀ» °¡Á® ¿Ã¼ö ¾ø½À´Ï´Ù.'); } $this->b_id = $reply_form_rows[b_id]; $this->b_name = $reply_form_rows[b_name]; $this->b_email = $reply_form_rows[b_email]; $this->b_homepage = $reply_form_rows[b_homepage]; $this->b_subject = $reply_form_rows[b_subject]; $this->b_content = $reply_form_rows[b_content]; $this->b_pwss = $reply_form_rows[b_pwss]; } // ´äº¯ ´Þ±â ÇÔ¼ö function delete_form($num,$data_table) { $Error_Path = new Error_Path(); $Dbconnect = new Dbconn(); $User_board_Display=new User_board_Display(); $User_board_Display ->display_etc_info(); $User_board_Display -> display_delete(); $this->board_list_tbl_head_message= $User_board_Display->display_list_tbl_head_message; $this->board_list_tbl_tail_message= $User_board_Display->display_list_tbl_foot_message; $delete_form_query = "select * from $data_table where b_num='$num'"; $delete_form_result = mysql_query($delete_form_query); if($delete_form_result) { $delete_form_rows = mysql_fetch_array($delete_form_result); } else { $Error_Path->error_page1('¿ø±Û¿¡ ´ëÇÑ ³»¿ëÀ» °¡Á® ¿Ã¼ö ¾ø½À´Ï´Ù.'); } $this->b_id = $delete_form_rows[b_id]; $this->b_name = $delete_form_rows[b_name]; $this->b_email = $delete_form_rows[b_email]; $this->b_homepage = $delete_form_rows[b_homepage]; $this->b_subject = $delete_form_rows[b_subject]; $this->b_content = $delete_form_rows[b_content]; $this->b_pwss = $delete_form_rows[b_pwss]; $this->b_read = $delete_form_rows[b_read]; $this->b_avata_img = $delete_form_rows[b_avata_img]; if($User_board_Display->display_list_avata_check!=0) { $this->b_avata_img="../avata_icon/$this->b_avata_img"; } else { $this->b_avata_img='../img/top_avata.gif'; } } function delete_memo_form($data_table,$page,$field,$key,$num,$m_num) { $Error_Path = new Error_Path(); $Dbconnect = new Dbconn(); //$User_board_Display=new User_board_Display(); //$User_board_Display ->display_etc_info(); //$User_board_Display -> display_delete(); //$this->board_list_tbl_head_message= $User_board_Display->display_list_tbl_head_message; //$this->board_list_tbl_tail_message= $User_board_Display->display_list_tbl_foot_message; $data_table_memo = $data_table."_"."memo"; $delete_memo_form_query = "select * from $data_table_memo where m_num='$m_num' and num='$num'"; $delete_memo_form_result = mysql_query($delete_memo_form_query); if($delete_memo_form_result) { $delete_form_rows = mysql_fetch_array($delete_memo_form_result); } else { $Error_Path->error_page1('¸Þ¸ð±Û¿¡ ´ëÇÑ ³»¿ëÀ» °¡Á® ¿Ã¼ö ¾ø½À´Ï´Ù.'); } $this->b_id = $delete_form_rows[m_id]; $this->b_name = $delete_form_rows[m_name]; $this->b_content = $delete_form_rows[m_comment]; $this->b_avata_img = $delete_form_rows[m_avata]; $this->b_regdate = $delete_form_rows[m_reg_date]; $this->b_pwss = $delete_form_rows[m_num]; $this->b_num = $delete_form_rows[num]; if($User_board_Display->display_list_avata_check!=0) { $this->b_avata_img="../avata_memo_icon/$this->b_avata_img"; } else { $this->b_avata_img='../img/top_avata.gif'; } } } ?>