고수님들 질문있습니다. > 그누4 질문답변

그누4 질문답변

그누보드4 관련 질문은 QA 로 이전됩니다. QA 그누보드4 바로가기
기존 게시물은 열람만 가능합니다.

고수님들 질문있습니다. 정보

고수님들 질문있습니다.

본문

<? if($gr_id){ ?>
<ul class="Submenu">
<!-- Nav_V -->
<?
$sql = " select gr_id, gr_subject from $g4[group_table] where gr_id = 'news'";//해당그룹 $gr_id를 해당그룹명으로 대체가능
$result = sql_query($sql);
echo "<li class=title><img src=$g4[path]/common/img/layout/sub_news.gif border=0></li>";
while ($row=mysql_fetch_array($result)) {
echo $line_shadow;
$sql2 = " select bo_subject, bo_table from $g4[board_table] where (bo_list_level <= $member[mb_level]) and (gr_id = '$row[gr_id]') and bo_use_search = '1' order by bo_order_search";
$result2 = sql_query($sql2);
$bar = "";
while ($row2=mysql_fetch_array($result2)) {
$new_time = date("Y-m-d H:i:s", time()-3600*$row2[bo_new]);
$sql3 = " select count(*) as cnt from $g4[write_prefix]$row2[bo_table] where wr_datetime >= '$new_time' ";
$row3 = sql_fetch($sql3);
if ($row2[bo_table] == $bo_table)
echo "<li class=active><a href='$g4[bbs_path]/board.php?bo_table=$row2[bo_table]'>$row2[bo_subject]</a></li>";
else
echo "<li class=list><a href='$g4[bbs_path]/board.php?bo_table=$row2[bo_table]'>$row2[bo_subject]</a></li>"; //네모 뷸릿 + 테이블명 + new 아이콘
}
}//}
echo "<li class=title><a href='$g4[bbs_path]/board.php?bo_table=preview'><img src=$g4[path]/common/img/layout/sub_preview.gif border=0></a></li>";
echo "<li class=title><a href='$g4[bbs_path]/board.php?bo_table=review'><img src=$g4[path]/common/img/layout/sub_review.gif border=0></a></li>";
$sql = " select gr_id, gr_subject from $g4[group_table] where gr_id = 'gallery'";//해당그룹 $gr_id를 해당그룹명으로 대체가능
$result = sql_query($sql);
echo "<li class=title><img src=$g4[path]/common/img/layout/sub_gallery.gif border=0></li>";
while ($row=mysql_fetch_array($result)) {
echo $line_shadow;
$sql2 = " select bo_subject, bo_table from $g4[board_table] where (bo_list_level <= $member[mb_level]) and (gr_id = '$row[gr_id]') and bo_use_search = '1' order by bo_order_search";
$result2 = sql_query($sql2);
$bar = "";
while ($row2=mysql_fetch_array($result2)) {
$new_time = date("Y-m-d H:i:s", time()-3600*$row2[bo_new]);
$sql3 = " select count(*) as cnt from $g4[write_prefix]$row2[bo_table] where wr_datetime >= '$new_time' ";
$row3 = sql_fetch($sql3);
if ($row2[bo_table] == $bo_table)
echo "<li class=active><a href='$g4[bbs_path]/board.php?bo_table=$row2[bo_table]'>$row2[bo_subject]</a></li>";
else
echo "<li class=list><a href='$g4[bbs_path]/board.php?bo_table=$row2[bo_table]'>$row2[bo_subject]</a></li>"; //네모 뷸릿 + 테이블명 + new 아이콘
}
}//}
$sql = " select gr_id, gr_subject from $g4[group_table] where gr_id = 'community'";//해당그룹 $gr_id를 해당그룹명으로 대체가능
$result = sql_query($sql);
echo "<li class=title><img src=$g4[path]/common/img/layout/sub_community.gif border=0></li>";
while ($row=mysql_fetch_array($result)) {
echo $line_shadow;
$sql2 = " select bo_subject, bo_table from $g4[board_table] where (bo_list_level <= $member[mb_level]) and (gr_id = '$row[gr_id]') and bo_use_search = '1' order by bo_order_search";
$result2 = sql_query($sql2);
$bar = "";
while ($row2=mysql_fetch_array($result2)) {
$new_time = date("Y-m-d H:i:s", time()-3600*$row2[bo_new]);
$sql3 = " select count(*) as cnt from $g4[write_prefix]$row2[bo_table] where wr_datetime >= '$new_time' ";
$row3 = sql_fetch($sql3);
if ($row2[bo_table] == $bo_table)
echo "<li class=active><a href='$g4[bbs_path]/board.php?bo_table=$row2[bo_table]'>$row2[bo_subject]</a></li>";
else
echo "<li class=list><a href='$g4[bbs_path]/board.php?bo_table=$row2[bo_table]'>$row2[bo_subject]</a></li>"; //네모 뷸릿 + 테이블명 + new 아이콘
}
}//}
?>

</ul>
<? } ?>
 제가 지금 이메뉴를 이용하고 있는데 아무리 봐두 너무 지저분해서..ㅡ.,ㅡ
좀 정리좀 해주심이..

댓글 전체

<? if ($gr_id) { ?>
 
<ul class="Submenu">
    <!-- Nav_V -->
    <?
    $sql = " select gr_id, gr_subject from $g4[group_table] where gr_id = 'news'";//해당그룹 $gr_id를 해당그룹명으로 대체가능
    $result = sql_query($sql);
    echo "<li class=title><img src=$g4[path]/common/img/layout/sub_news.gif border=0></li>";
    while ($row = mysql_fetch_array($result)) {
        echo $line_shadow;
        $sql2 = " select bo_subject, bo_table from $g4[board_table] where (bo_list_level <= $member[mb_level]) and (gr_id = '$row[gr_id]') and bo_use_search = '1' order by bo_order_search";
        $result2 = sql_query($sql2);
        $bar = "";
        while ($row2 = mysql_fetch_array($result2)) {
            $new_time = date("Y-m-d H:i:s", time() - 3600 * $row2[bo_new]);
            $sql3 = " select count(*) as cnt from $g4[write_prefix]$row2[bo_table] where wr_datetime >= '$new_time' ";
            $row3 = sql_fetch($sql3);
            if ($row2[bo_table] == $bo_table)
                echo "<li class=active><a href='$g4[bbs_path]/board.php?bo_table=$row2[bo_table]'>$row2[bo_subject]</a></li>";
            else
                echo "<li class=list><a href='$g4[bbs_path]/board.php?bo_table=$row2[bo_table]'>$row2[bo_subject]</a></li>"; //네모 뷸릿 + 테이블명 + new 아이콘
        }
    }//}
    echo "<li class=title><a href='$g4[bbs_path]/board.php?bo_table=preview'><img src=$g4[path]/common/img/layout/sub_preview.gif border=0></a></li>";
    echo "<li class=title><a href='$g4[bbs_path]/board.php?bo_table=review'><img src=$g4[path]/common/img/layout/sub_review.gif border=0></a></li>";
    $sql = " select gr_id, gr_subject from $g4[group_table] where gr_id = 'gallery'";//해당그룹 $gr_id를 해당그룹명으로 대체가능
    $result = sql_query($sql);
    echo "<li class=title><img src=$g4[path]/common/img/layout/sub_gallery.gif border=0></li>";
    while ($row = mysql_fetch_array($result)) {
        echo $line_shadow;
        $sql2 = " select bo_subject, bo_table from $g4[board_table] where (bo_list_level <= $member[mb_level]) and (gr_id = '$row[gr_id]') and bo_use_search = '1' order by bo_order_search";
        $result2 = sql_query($sql2);
        $bar = "";
        while ($row2 = mysql_fetch_array($result2)) {
            $new_time = date("Y-m-d H:i:s", time() - 3600 * $row2[bo_new]);
            $sql3 = " select count(*) as cnt from $g4[write_prefix]$row2[bo_table] where wr_datetime >= '$new_time' ";
            $row3 = sql_fetch($sql3);
            if ($row2[bo_table] == $bo_table)
                echo "<li class=active><a href='$g4[bbs_path]/board.php?bo_table=$row2[bo_table]'>$row2[bo_subject]</a></li>";
            else
                echo "<li class=list><a href='$g4[bbs_path]/board.php?bo_table=$row2[bo_table]'>$row2[bo_subject]</a></li>"; //네모 뷸릿 + 테이블명 + new 아이콘
        }
    }//}
    $sql = " select gr_id, gr_subject from $g4[group_table] where gr_id = 'community'";//해당그룹 $gr_id를 해당그룹명으로 대체가능
    $result = sql_query($sql);
    echo "<li class=title><img src=$g4[path]/common/img/layout/sub_community.gif border=0></li>";
    while ($row = mysql_fetch_array($result)) {
        echo $line_shadow;
        $sql2 = " select bo_subject, bo_table from $g4[board_table] where (bo_list_level <= $member[mb_level]) and (gr_id = '$row[gr_id]') and bo_use_search = '1' order by bo_order_search";
        $result2 = sql_query($sql2);
        $bar = "";
        while ($row2 = mysql_fetch_array($result2)) {
            $new_time = date("Y-m-d H:i:s", time() - 3600 * $row2[bo_new]);
            $sql3 = " select count(*) as cnt from $g4[write_prefix]$row2[bo_table] where wr_datetime >= '$new_time' ";
            $row3 = sql_fetch($sql3);
            if ($row2[bo_table] == $bo_table)
                echo "<li class=active><a href='$g4[bbs_path]/board.php?bo_table=$row2[bo_table]'>$row2[bo_subject]</a></li>";
            else
                echo "<li class=list><a href='$g4[bbs_path]/board.php?bo_table=$row2[bo_table]'>$row2[bo_subject]</a></li>"; //네모 뷸릿 + 테이블명 + new 아이콘
        }
    }//}
    ?>
</ul>
<? } ?>



들여쓰기 말입니까 ㅡㅡ?
전체 66,554 |RSS
그누4 질문답변 내용 검색

회원로그인

(주)에스아이알소프트 / 대표:홍석명 / (06211) 서울특별시 강남구 역삼동 707-34 한신인터밸리24 서관 1402호 / E-Mail: admin@sir.kr
사업자등록번호: 217-81-36347 / 통신판매업신고번호:2014-서울강남-02098호 / 개인정보보호책임자:김민섭(minsup@sir.kr)
© SIRSOFT