 |
 |
 |
|
 |
|
 |
|
 |
|
 |
|
|
|
";
################################################################################################
########################################## 공지사항 ############################################
$n_sql = "select * from $board_table where db='$board_db' && notice='Y' $addboard order by num desc ";
$n_res = mysql_query($n_sql);
while($n_row = @mysql_fetch_array($n_res)){
########################################## 코멘트 갯수 ############################################
$c_sql = "select count(num) from $comment_table where usernum = '$n_row[num]'";
$c_row = mysql_fetch_array(mysql_query($c_sql));
if($c_row[0]) $comment_cnt = " [$c_row[0]]";
else $comment_cnt = "";
########################################## 코멘트 갯수 ############################################
$n_subject = b_string_cut($n_row[subject], 30, "...");
$n_subject = "$n_subject $comment_cnt";
if(date("Y-m-d") == substr($n_row[wdate], 0, 10)){
$n_date = "".substr($n_row[wdate], 0, 10)."";
$newIco = "
";
} else {
$n_date = substr($n_row[wdate], 0, 10);
$newIco = "";
}
$n_file = explode("||", $n_row[exname]);
$n_file_name = explode("||", $n_row[file_name]);
if($n_file_name[0]) $n_ficon1 = "
";
else $n_ficon1 = "";
if($n_file_name[1]) $n_ficon2 = "";
else $n_ficon2 = "";
if($n_file_name[2]) $n_ficon3 = "";
else $n_ficon3 = "";
echo"
| [공지] |
|
$n_subject $newIco |
|
".b_string_cut($n_row[name], $name_length, "..")." |
|
$n_date |
|
$n_ficon1 $n_ficon2 $n_ficon3 |
|
$n_row[hit] |
|
";
}
########################################## 공지사항 ############################################
################################################################################################
#################################### 게시물 리스트 S ###########################################
$item = $page_skip;
if(!$item) $item = 10;
$pageitem = $pagenumber;
if(!$pageitem) $pageitem = 10;
if(!$page) $page = 1;
$start = ($page - 1) * $item;
$totalpage = ceil($total / $item);
$pnum = $total - (($page-1) * $item);
$sql = "select * from $board_table where db='$board_db' && notice!='Y' $addwhere order by idx desc, sort asc limit $start, $item";
$res = mysql_query($sql);
while($row = mysql_fetch_array($res)){
########################################## 코멘트 갯수 ############################################
$c_sql = "select count(num) from $comment_table where usernum='$row[num]'";
$c_row = mysql_fetch_array(mysql_query($c_sql));
if($c_row[0]) $comment_cnt = " [$c_row[0]]";
else $comment_cnt = "";
########################################## 코멘트 갯수 ############################################
if($open_print == "yes" && $row[secret] == "Y"){
if(($login_id == $row[id] && $row[id]) || $login_level>=$secret_level){
$close_icon = "
";
$write_name = $row[name];
$subject = "$row[subject]";
$close_icon = "";
$write_name = $row[name];
$subject = b_string_cut(html_entity_decode($row[subject]), $subject_length, "...");
$t_subject = strip_tags(html_entity_decode($row[subject]));
$cut_subject = b_string_cut($t_subject, $subject_length, "...");
$subject = ereg_replace($t_subject, $cut_subject, html_entity_decode($row[subject]));
$subject = "$subject";
} else {
$close_icon = "";
$write_name = $row[name];
$t_subject = strip_tags(html_entity_decode($row[subject]));
$cut_subject = b_string_cut($t_subject, $subject_length, "...");
$subject = ereg_replace($t_subject, $cut_subject, html_entity_decode($row[subject]));
$subject = "$subject";
}
} else {
$close_icon = "";
$write_name = $row[name];
$subject = b_string_cut(html_entity_decode($row[subject]), $subject_length, "...");
$t_subject = strip_tags(html_entity_decode($row[subject]));
$cut_subject = b_string_cut($t_subject, $subject_length, "...");
//$subject = ereg_replace("$t_subject", "$cut_subject", html_entity_decode($row[subject]));
$subject = "$subject";
}
if($row[sort]){
$subject = "
".$subject;
for($i=0; $i";
$newIco = "";
} else {
$wdate = substr($row[wdate],0,10);
$newIco = "";
}
$file = explode("||", $row[exname]);
$file_name = explode("||", $row[file_name]);
if($file_name[0]) $ficon1 = "";
else $ficon1 = "";
if($file_name[1]) $ficon2 = "";
else $ficon2 = "";
if($file_name[2]) $ficon3 = "";
else $ficon3 = "";
if($pnum%2) $bgcolor = "#F8F8F8";
else $bgcolor = "#FFFFFF";
echo"
| ".$pnum--." |
|
$subject $newIco $close_icon |
|
".b_string_cut($write_name, $name_length, "..")." |
|
$wdate |
|
$ficon1 $ficon2 $ficon3 |
|
$row[hit] |
|
";
}
if(!$total){
echo"
| 등록(검색)된 글이 없습니다. |
|
";
}
?>
|
|
|
|
|
";
}
#### 검색 폼 E ####
?>