<?
$cells = 0;

//switch(true)
//{
// case $member[mb_level] <= 4 : // 정회원 5 미만일때
// $except="'banner','html'"; // 제외 그룹
// break;
// case $member[mb_level] <= 5 : // 정회원일때
// $except="'content'"; // 제외그룹
// 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 ('website', 'Z', 'G', 'E', 'H', 'I', 'today', 'sample', 'service', 'offer', 'S', 'Y') 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%1==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>&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++;

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='$g4[path]/speedmap/img/icon_new.gif'>"; // new 아이콘
else
$new = ""; //new 아이콘 없음

echo "<tr><td><a href='$g4[bbs_path]/board.php?bo_table=$row2[bo_table]'>$row2[bo_subject]</a>&nbsp;$new</td>";
echo "<tr><td></td></tr>";
}
echo "<tr><td height='20'></td></tr></table>";
echo "</td>";
}
?>