연혁게시판 카테고리를 사용할 수 없나요?? 채택완료
위드컴
4년 전
조회 1,820
Rini님이 올려주신 연혁게시판 감사히 사용중인데요~
https://sir.kr/g5_skin/16421?sfl=wr_subject%7C%7Cwr_content&stx=%EC%97%B0%ED%98%81
분류설정으로 연혁을 나누려고 분류기능 설정하고 게시글 등록하니까
등록/저장까지는 잘되는데요~
게시판 목록에서 분류명 클릭하면 계속 같은 내용만 나오고
해당분류명대로 걸러지지가 않습니다ㅠㅠ
뭐가 문제일까요???
/bbs/board.php?bo_table=history&sca=분류명
</p>
<p><?
if (!defined("_GNUBOARD_")) exit; // 개별 페이지 접근 불가
include_once(G5_LIB_PATH.'/thumbnail.lib.php');
include_once $board_skin_path."/board_head.skin.php";
add_stylesheet('<link rel="stylesheet" href="'.$board_skin_url.'/css/style.css">', 20);
add_stylesheet('<link rel="stylesheet" href="'.$board_skin_url.'/css/lightbox.css">', 21);
?></p>
<p><div class="sub_con widthfix"></p>
<p> <div class="history_div mt55">
<form name="fboardlist" id="fboardlist" action="./board_list_update.php" onsubmit="return fboardlist_submit(this);" method="post">
<input type="hidden" name="bo_table" value="<?php echo $bo_table ?>">
<input type="hidden" name="sfl" value="<?php echo $sfl ?>">
<input type="hidden" name="stx" value="<?php echo $stx ?>">
<input type="hidden" name="spt" value="<?php echo $spt ?>">
<input type="hidden" name="page" value="<?php echo $page ?>">
<input type="hidden" name="sw" value=""></p>
<p> <!-- 게시판 목록 시작 -->
<?
$sql = "SELECT * FROM $write_table ORDER BY wr_subject $board[bo_4], wr_1, wr_2 ";</p>
<p> $result=sql_query($sql);
//$num_rows = mysql_num_rows($result);
$count = 0;
while($data=sql_fetch_array($result)) {
$count++;
$hList[]=$data; </p>
<p> if($preYear != $data[wr_subject]) {
$preYear = $data[wr_subject];</p>
<p> if($count > 1) {
$cicle_img = '<div class="year_body"><span>'.$data[wr_subject].'</span></div>';
}elseif($count == 1){
$cicle_img = '<div class="year_body first"><span>'.$data[wr_subject].'</span></div>';
}</p>
<p> echo ' <div class="p_box '.$margin_top.'">';
echo ' <div class="history_img">'.$cicle_img.'</div>';
echo ' <div class="history_txt">';</p>
<p>
$tmp_write_table = $g5['write_prefix'] . $board['bo_table']; // 게시판 테이블 전체이름
$sql_detail = " select * from {$tmp_write_table} where wr_subject = {$data[wr_subject]} order by wr_subject $board[bo_4], wr_1, wr_2 ";
$result_detail = sql_query($sql_detail);
$history_icon = '';
for ($i=0; $hList = sql_fetch_array($result_detail); $i++) {
if($i == 0) {
if($i > -1) $margin_top = "mt30";
echo '<div class="tit">';
echo ' <h4>'.$hList[wr_subject].'</h4>';
echo ' <div class="bar"></div>';
echo '</div>';
}
$disp_month = $hList[wr_1];
$disp_day = $hList[wr_2];
if($board[bo_3]=="d") {
$display = $disp_month.".".$disp_day." ";
}else{
$display = $disp_month.". ";
}</p>
<p> echo '<p class="mt5">';
if($is_admin || $is_checkbox) echo '<input type="checkbox" name="chk_wr_id[]" value="'.$hList[wr_id].'" title="'.$hList[wr_subject].'"> ';</p>
<p> if($is_admin) {
echo ' <a href="'.G5_BBS_URL.'/write.php?bo_table='.$bo_table.'&w=u&wr_id='.$hList[wr_id].'">';
}</p>
<p> echo $display.rtrim(nl2br($hList[wr_content]));</p>
<p> if ($is_admin)
{
set_session("ss_delete_token", $token = uniqid(time()));
$delete_href ='./delete_all.php?bo_table='.$bo_table.'&wr_id='.$hList[wr_id];
echo ' </a> ';
echo '<a href="javascript:del(\''.$delete_href.'\');"><img src="'.$board_skin_url.'/img/btn_close.gif" alt="Delete" width="15px" height="14px" /></a>';
}
echo '</p>';</p>
<p> $thumb = get_list_thumbnail($bo_table, $hList['wr_id'], $board['bo_gallery_width'], $board['bo_gallery_height']);
$sql = " select bf_file, bf_content from {$g5['board_file_table']}
where bo_table = '$bo_table' and wr_id = '$hList[wr_id]' and bf_type between '1' and '3' order by bf_no limit 0, 1 ";
$row = sql_fetch($sql);</p>
<p> if($thumb['src']) {
$history_icon .= '<div class="history_icon">';
$history_icon .= '<strong>'.$hList[wr_subject].'</strong>';
$history_icon .= '<p class="tit">'.$thumb['alt'].'</p>';
$history_icon .= '<p class="mt5"><a href="'.G5_DATA_URL.'/file/'.$bo_table.'/'.$row['bf_file'].'" data-lightbox="history-image-set" class="light-box-image"><img src="'.$thumb['src'].'" alt="'.$thumb['alt'].'" width="'.$board['bo_gallery_width'].'" height="'.$board['bo_gallery_height'].'"></a></p>';
$history_icon .= '</div>';
}</p>
<p> }
echo ' </div>';
echo $history_icon;
echo ' </div>';
}
}</p>
<p> ?>
<div class="p_box">
<div class="history_img"><img src="<?=$board_skin_url?>/img/history_start.gif" style="position:absolute;bottom:0;left:83px;" alt="history_start"></div>
<div class="history_txt">
</div>
</div></p>
<p>
</div></p>
<p> <div class="mt40"></div></p>
<p>
<?php if ($is_admin || $list_href || $is_checkbox || $write_href) { ?>
<div class="bo_fx">
<?php if ($is_checkbox) { ?>
<ul class="btn_bo_adm">
<li><input type="submit" name="btn_submit" value="선택삭제" onclick="document.pressed=this.value"></li>
<li><input type="submit" name="btn_submit" value="선택복사" onclick="document.pressed=this.value"></li>
<li><input type="submit" name="btn_submit" value="선택이동" onclick="document.pressed=this.value"></li>
</ul>
<?php } ?></p>
<p> <?php if ($list_href || $rss_href || $write_href) { ?>
<ul class="btn_bo_user">
<?php if ($rss_href) { ?><li><a href="<?php echo $rss_href ?>" class="btn_b01">RSS</a></li><?php } ?>
<?php if ($admin_href) { ?><li><a href="<?php echo $admin_href ?>" class="btn_admin">관리자</a></li><?php } ?>
<?php if ($list_href) { ?><li><a href="<?php echo $list_href ?>" class="btn_b01">목록</a></li><?php } ?>
<?php if ($write_href) { ?><li><a href="<?php echo $write_href ?>" class="btn_b02">글쓰기</a></li><?php } ?>
</ul>
<?php } ?>
</div>
<?php } ?>
</form></p>
<p><!-- 페이지 -->
<?php //echo $write_pages; ?></p>
<p></div></p>
<p>
<script type="text/javascript">
var num = 0;
jQuery(document).ready(function(){
jQuery(".history_img").animate({opacity:0, marginTop:"-200px"}, 0);
jQuery(".history_txt").animate({opacity:0, marginTop:"-50px"}, 0);
$(".history_icon").animate({opacity:0, marginTop:"-50px"}, 0);
})
jQuery(window).load(function(){
jQuery(".history_img").each(function(index){
jQuery.easing.def = "easeOutQuart";
num++;
jQuery(".history_img").eq(index).delay((450 * num)).animate({opacity:1, marginTop:"0px"}, 900);
jQuery(".history_txt").eq(index).delay((650 * num)).animate({opacity:1, marginTop:"0px"}, 900);
$(".history_icon").eq(index).delay((650 * num)).animate({opacity:1, marginTop:"0px"}, 600);
})
})
</script>
<script type="text/javascript">
if ('<?=$sca?>') document.fcategory.sca.value = '<?=$sca?>';
/*
if ('<?=$stx?>') {
document.fsearch.sfl.value = '<?=$sfl?>';</p>
<p> if ('<?=$sop?>' == 'and')
document.fsearch.sop[0].checked = true;</p>
<p> if ('<?=$sop?>' == 'or')
document.fsearch.sop[1].checked = true;
} else {
document.fsearch.sop[0].checked = true;
}
*/
</script></p>
<p><?php if ($is_checkbox) { ?>
<script>
function all_checked(sw) {
var f = document.fboardlist;</p>
<p> for (var i=0; i<f.length; i++) {
if (f.elements[i].name == "chk_wr_id[]")
f.elements[i].checked = sw;
}
}</p>
<p>function fboardlist_submit(f) {
var chk_count = 0;</p>
<p> for (var i=0; i<f.length; i++) {
if (f.elements[i].name == "chk_wr_id[]" && f.elements[i].checked)
chk_count++;
}</p>
<p> if (!chk_count) {
alert(document.pressed + "할 게시물을 하나 이상 선택하세요.");
return false;
}</p>
<p> if(document.pressed == "선택복사") {
select_copy("copy");
return;
}</p>
<p> if(document.pressed == "선택이동") {
select_copy("move");
return;
}</p>
<p> if(document.pressed == "선택삭제") {
if (!confirm("선택한 게시물을 정말 삭제하시겠습니까?\n\n한번 삭제한 자료는 복구할 수 없습니다"))
return false;
}</p>
<p> return true;
}</p>
<p>// 선택한 게시물 복사 및 이동
function select_copy(sw) {
var f = document.fboardlist;</p>
<p> if (sw == "copy")
str = "복사";
else
str = "이동";</p>
<p> var sub_win = window.open("", "move", "left=50, top=50, width=500, height=550, scrollbars=1");</p>
<p> f.sw.value = sw;
f.target = "move";
f.action = "./move.php";
f.submit();
}
</script>
<?php } ?>
<!-- } 게시판 목록 끝 -->
<script type="text/javascript" src="<?php echo $board_skin_url ?>/js/lightbox-2.6.min.js"></script>
댓글을 작성하려면 로그인이 필요합니다.
답변 1개
채택된 답변
+20 포인트
4년 전
</p>
<pre>
<code>$sql = "SELECT * FROM $write_table where ca_name = '{$sca}'</code></pre>
<pre>
<code>ORDER BY wr_subject $board[bo_4], wr_1, wr_2 ";
$result=sql_query($sql);</code></pre>
<p><code>
위처럼 조건 값이 없네요.. 위처럼 추가히시면 됩니다.
로그인 후 평가할 수 있습니다
답변에 대한 댓글 1개
�
위드컴
4년 전
뭡니까!!!! 너무 잘됩니다아아아ㅠㅠㅠ 아아앜 너무너무 감사합니당!!!!!!!!!!!
댓글을 작성하려면 로그인이 필요합니다.
답변을 작성하려면 로그인이 필요합니다.
로그인