<?
include_once("./_common.php");
$g4[title] = "사이트맵";
include_once("$g4[path]/_head.php");
if (!defined("_GNUBOARD_")) exit; // 개별 페이지 접근 불가
$row_my=array(); 
  $sql2 = "select gr_id,bo_table,bo_subject from $g4[board_table] where bo_table !='datatest' order by gr_id,bo_table"; 
  $result2 = sql_query($sql2);   
  for($mi=0; $row2=sql_fetch_array($result2); $mi++){    
   $tmp_write_table =""; 
   $tmp_write_table = $g4[write_prefix] . $row2[bo_table]; 
   $sql3 = "select * from $tmp_write_table where wr_is_comment = 0 order by wr_id";   //원글만   
   $result3 = sql_query($sql3); 
   $old_res_cnt=$res_cnt; $tmp_res_cnt="";    
   $tmp_res_cnt=mysql_num_rows($result3); //게시판별 구한수 
   $res_cnt=$old_res_cnt+$tmp_res_cnt; 
   $old_wr_hit=$res_wr_hit;     $res_wr_hit="";    
   $tmp_wr_hit=@mysql_result(@mysql_query("select sum(wr_hit) from $tmp_write_table"),0,0);            
   $res_wr_hit=$old_wr_hit+$tmp_wr_hit; 
   $res_wr_hit1=number_format($res_wr_hit); 
  }//for  
$time = date("Y-m-d"); 
$target1 = "1";
$target = "0";//지정일(지정일 이후에 등록된 글만 추출하기 위함(by nasca)
    $duration = date("Y-m-d", $g4[server_time] - ($target * 86400));
    $duration1 = date("Y-m-d", $g4[server_time] + ($target1 * 86400));
$sql = " select count(bn_id) as cnt from $g4[board_new_table]
              where bn_datetime between '$duration' and '$duration1'
              order by bn_datetime "; 
$row = sql_fetch($sql); 
$width= "97%";
?>
<table width='678' cellpadding='0' cellspacing='0' border='0'>
 <tr>
  <td><img src='<?=$g4['path']?>/img/out_bco01.gif' width='7' height='6'></td>
  <td background='<?=$g4['path']?>/img/out_bbg01.gif'></td>
  <td><img src='<?=$g4['path']?>/img/out_bco02.gif' width='6' height='6'></td>
 </tr>
 <tr><td background='<?=$g4['path']?>/img/out_bbg02.gif' ></td>
  <td>
   <table width='665' cellpadding='0' cellspacing='0' border='0'>
    <tr>
     <td>
      <table width='97%' cellpadding='0' cellspacing='0' border='0' align='center'>
       <tr>
        <td height='20' align='right' valign='bottom'><a href='<?=$g4['path'];?>/'><img src='<?=$g4['path']?>/img/icon_home.gif' width='38' height='15' align='absmiddle' border='0'></a> ><?=$g4['title']?></td>
       </tr>
       <tr>
        <td align='left'><img src='<?=$g4['path']?>/img/sitemap.gif'></td>
       </tr>
       <tr><td height='20'></td></tr>
      </table>
     </td>
    </tr>
   </table>
  
ㆍ<span class='' style='#666666;'> 게시판명 <font color=red> 오늘등록글(<?=$row[cnt]?>)</font>/전체글(<?=$res_cnt?>)/<font color=blue>총열람수(<?=$res_wr_hit1?>)</font></span>
<table width="<?=$width?>" height="380" cellpadding=0 cellspacing=0 align="center" border="0">
<tr><td bgcolor="#CCCCCC" height="1"></td></tr>
<tr><td height="20"></td></tr>
<tr><td valign="top">
<table width="100%" cellpadding="0" cellspacing="0" border="0" >
<tr>
<?
 
$cells = 0; 
switch(true) 
{
 case $member[mb_level] <= 4 : // 정회원 5 미만일때
  $except="'member','content'"; // 제외 그룹
  break;
 case $member[mb_level] <= 5 : // 정회원일때
  $except="'content'"; // 제외그룹
  break;
 default:
  $except="''";
}
$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='$g4[path]/img/sitemap_bg1.gif' width='179' height='42' style='padding-left:22px;'><img src='$g4[path]/img/38.gif' align='absmiddle'>  <strong>$row[gr_subject]</strong></td></tr></table><table width='190' height='100%' cellpadding='0' cellspacing='0' border='0'>"; // 그룹명 출력
 $sql2 = " select bo_8, bo_table, bo_subject,bo_count_write 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)) {
 
 $time = date("Y-m-d"); 
    $target1 = "1";
    $target = "0";//지정일(지정일 이후에 등록된 글만 추출하기 위함(by nasca)
    $duration = date("Y-m-d", $g4[server_time] - ($target * 86400));
    $duration1 = date("Y-m-d", $g4[server_time] + ($target1 * 86400));
    $sql3 = " select count(*) as cnt from $g4[write_prefix]$row2[bo_table] where wr_datetime between '$duration' and '$duration1'  "; 
              
    $row3 = sql_fetch($sql3); 
 
 $tmp_wr_hit=@mysql_result(@mysql_query("select sum(wr_hit) from $g4[write_prefix]$row2[bo_table]"),0,0);
  if ($row3[cnt] > 0)
   $new = "<span class='' style='color:#666666;'>(<font color=red>$row3[cnt]</font>/$row2[bo_count_write]/<font color=blue>$tmp_wr_hit</font>) <img src='$g4[path]/img/icon_new.gif'> </span> "; // new 아이콘
  else
   $new = "<span class='' style='#666666;'>(<font color=red>$row3[cnt]</font>/$row2[bo_count_write]/<font color=blue>$tmp_wr_hit</font>) </span>"; //new 아이콘 없음
 echo "<tr><td style='padding-left:0px; height:26px;'>ㆍ<a href='$g4[bbs_path]/board.php?bo_table=$row2[bo_table]'>$row2[bo_subject]</a>$new <br /></td>";
 echo "<tr><td height='1' bgcolor='#E9E9E9'></td></tr>";
 }
 echo "<tr><td height='20'></td></tr></table>";
 echo "</td>";
}
?>
</tr>
</table>
 
</td></tr>
<tr><td height="10"></td><tr>
<tr><td bgcolor="#E9E9E9" height="1"></td></tr>
<tr><td height="10"></td><tr>
</table>

  </td>
  <td background="<?=$g4['path']?>/img/out_bbg03.gif"></td>
 </tr>
 <tr>
  <td><img src="<?=$g4['path']?>/img/out_bco03.gif" width="7" height="6"></td>
  <td background="<?=$g4['path']?>/img/out_bbg04.gif"></td>
  <td><img src="<?=$g4['path']?>/img/out_bco04.gif" width="6" height="6"></td>
 </tr>
</table>

<?
include_once("$g4[path]/_tail.php"); 
?>