사이트맵에서 게시판 제외 > 질문답변

//제외보드설정
    //$sql1 = " select bo_subject, bo_table from $g4[board_table] where bo_table not in ('z1_1', 'z2_1', 'z2_3', 'z5_1') and (bo_list_level <= $member[mb_level]) and (gr_id = '$row[gr_id]') order by bo_order_search";

응용해 보세요.

다운로드 디자인에서 찾아 보세요~!

고맙습니다 ^^  아래처럼 넣어봤는데 안되네요.

<?

$cells = 0;

//switch(true)
//{
// case $member[mb_level] <= 2 : // 정회원 5 미만일때
// $except="'banner','gust','html'"; // 제외 그룹
// break;
// case $member[mb_level] <= 5 : // 정회원일때
// $except="'banner','html'"; // 제외 그룹
// break;
// default:
// $except="''";
//}

//접근가능그룹 여분필드 1 순서로 추출
$sql = " SELECT a.gr_id, a.gr_subject, a.gr_use_access, b.mb_id FROM $g4[group_table] AS a LEFT JOIN $g4[group_member_table] AS b ON a.gr_id = b.gr_id WHERE  (b.mb_id = '$member[mb_id]' AND a.gr_use_access = '1' ) OR a.gr_use_access = '0'  ORDER BY a.gr_1";
   
// 제외그룹설정 root님
// html , banner , guest 라는 그룹은 제외시킴
$sql = " select * from $g4[group_table] where gr_id not in ('html', 'banner', 'guest') order by gr_1";

//$sql = " select  gr_id, gr_subject from $g4[group_table] where gr_id not in ($except) order by gr_subject desc ";
$rst1 = sql_query($sql);

while ($row=sql_fetch_array($rst1)) {

if($cells%3==0)
echo "</tr><tr>";

echo "<td width='33%' valign='top' align='center'>";
echo "<table width='179' height='100%' cellpadding='0' cellspacing='0' border='0'>";
echo "<tr><td background='img/sitemap_bg1.gif' width='179' height='42' style='padding-left:22px;'><img src='img/icon_dot.gif' width='2' height='2' align='absmiddle'>&nbsp;&nbsp;<strong>$row[gr_subject]</strong></td></tr>"; // 그룹명 출력

$sql2 = " select * from $g4[board_table] where gr_id = '$row[gr_id]' order by bo_order_search ";
$rst2 = sql_query($sql2);
$cells++;

    //제외보드설정
    //$sql1 = " select bo_subject, bo_table from $g4[board_table] where bo_table not in ('z1_1', 'z2_1', 'z2_3', 'z5_1') and (bo_list_level <= $member[mb_level]) and (gr_id = '$row[gr_id]') order by bo_order_search";


while ($row2=sql_fetch_array($rst2)) {
$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 ($row3[cnt] > 0)
$new = "&nbsp;<img src='img/icon_new.gif'>"; // new 아이콘
else
$new = ""; //new 아이콘 없음
echo "<tr><td style='padding-left:18px; height:26px;'>ㆍ<a href='$g4[bbs_path]/board.php?bo_table=$row2[bo_table]'>$row2[bo_subject]</a>&nbsp;$new <br /></td>";
echo "<tr><td height='1' bgcolor='#E9E9E9'></td></tr>";
}
echo "<tr><td height='20'></td></tr></table>";
echo "</td>";
}
?>

플래쉬쪽에도 아이콘은 있습니다~!