class User_Board_Data_List extends User_Board_Data {
//var $b_num; ##°Ô½Ã¹°¹øÈ£
//var $b_id; ##ÀÛ¼ºÀÚ¾ÆÀ̵ð
//var $b_name; ##ÀÛ¼ºÀÚ À̸§
//var $b_email; ##ÀÛ¼ºÀÚ À̸ÞÀÏ
//var $b_homepage; ##ÀÛ¼ºÀÚ È¨ÆäÀÌÁö
//var $b_avata_img; ##¾Æ¹ÙŸ ¾ÆÀÌÄÜ
//var $b_user_ip; ##ÀÛ¼ºÀÚ ¾ÆÀÌÇÇ
//var $b_regdate; ##ÀÛ¼ºÀÚ µî·ÏÀÏ
//var $b_modifydate; ##ÀÛ¼ºÀÚ ¼öÁ¤ÀÏ
//var $b_subject; ##ÀÛ¼ºÀÚ Á¦¸ñ
//var $b_content; ##ÀÛ¼º ³»¿ë
//var $b_userfile; ##µî·ÏµÈ ÆÄÀÏ
//var $b_userfile_size; ##µî·Ï ÆÄÀÏ Å©±â
//var $b_read; ##Á¶È¸¼ö
//var $b_pwss; ##ºñ¹Ð¹øÈ£
//var $b_depth1;
//var $b_depth2;
//var $b_depth3;
//var $b_qus;
//var $b_color;
//var $b_fontline;
var $list_tbl_line_subject;
var $m_num;
var $m_id ;
var $m_name;
var $m_comment;
var $m_avata;
var $m_reg_date;
var $m_mod_date;
var $board_list_tbl_head_message;
var $board_list_tbl_tail_message;
var $board_list_width;
var $memo_result;
var $save_dir = "../upload_file";
function data_list($data_table,$page,$field,$key) { //¸®½ºÆ® º¸À̱â
$Error_Path = new Error_Path();
$Function_Etc = new Function_Etc();
$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_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= "
";
}
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 .= "
$virtual_count
| ";
$this->table_result .= "
b_email>$id
| ";
$this->table_result .= "
$file_icon_down
| ";
$this->table_result .= "
$font_width$subject$font_width1 $new_icon $hot_icon
| ";
$this->table_result .= "
$reg_date[0]
| ";
$this->table_result .= "
$this->b_read
| ";
$this->table_result .= "
";
$this->table_result .="
";
$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';
}
}
}
?>