"새로운글"에서 특정게시판은 제외시키고 싶은데 어디를 손보죠? > 그누3질답

그누3질답

"새로운글"에서 특정게시판은 제외시키고 싶은데 어디를 손보죠? 정보

그누보드 "새로운글"에서 특정게시판은 제외시키고 싶은데 어디를 손보죠?

본문

아래는 현재 제가 사용하고 있는 새로운글 소스입니다.
여기서 특정게시판은 새로운글이 있어도 새로운글 보기에서 제외시키고 싶습니다.
어디를 손봐야 할지 난감합니다.

==================================== 소스시작 ========================================

<?
if (!defined("_GNUBOARD_")) exit; // 개별 페이지 접근 불가

define("_DOCTYPE_", "DESIGN");

if ($hours < 1 || $hours > 168) {
  $hours = 24;
}

$html_title = "$hours 시간 이내에 올라온 글 보기";
?>

<table width=95% cellpadding=3 cellspacing=0 align=center>
<tr><td height=1 background='./<?=$cfg[bbs_dir]?>/line.gif'></td></tr>
<tr><td  class='subject subjectbg ht'> <?=$html_title?></td></tr>
<tr><td height=1 background='./<?=$cfg[bbs_dir]?>/line.gif'></td></tr>
</table>
<p>

<table width=95% cellpadding=0 cellspacing=0 align=center>
<tr>
  <td width='' valign=top>

<?
$intime = date("Y-m-d H:i:s", time() - (int)(60 * 60 * $hours));

$sql = " select bo_subject, bo_table
          from $cfg[table_board]
        where bo_use_search = '1'
        order by bo_order_search ";
$result = sql_query($sql);
while ($row = mysql_fetch_array($result)) {
  $tbl = "{$cfg[write_table_prefix]}{$row[bo_table]}";
  $sql2 = " select wr_id,
                    wr_parent_id,
                    mb_id,
                    wr_name,
                    wr_email,
                    wr_homepage,
                    wr_num,
                    wr_subject,
                    wr_comment,
                    wr_commentcnt,
                    wr_datetime
              from $tbl
              where wr_datetime >= '$intime'
              order by wr_id desc ";
  $result2 = sql_query($sql2);
  for ($i = 0; $row2 = mysql_fetch_array($result2); $i++) {
      if ($row2[wr_comment] > 0) {
          $sql3 = " select wr_subject
                      from $tbl
                      where wr_comment = 0
                        and wr_parent_id = '$row2[wr_parent_id]' ";
          $row3 = sql_fetch($sql3);
          $wr_subject = $row3[wr_subject];
      } else {
          $wr_subject = $row2[wr_subject];
      }
      $wr_subject = get_text($wr_subject);

      $key = $row2[wr_datetime] . $row[bo_table] . $row2[wr_id];
      $list[$key]->bo_subject = $row[bo_subject];
      $list[$key]->bo_table = $row[bo_table];
      $list[$key]->mb_id = $row2[mb_id];
      $list[$key]->mb_open = $row2[mb_open];
      $list[$key]->wr_id = $row2[wr_id];
      $list[$key]->wr_parent_id = $row2[wr_parent_id];
      $list[$key]->wr_email = $row2[wr_email];
      $list[$key]->wr_homepage = $row2[wr_homepage];
      $list[$key]->wr_name = get_text(cut_str($row2[wr_name],12));
      $list[$key]->wr_subject = get_text(cut_str($wr_subject,80,'…'));
      $list[$key]->wr_comment = $row2[wr_comment];
      $list[$key]->wr_commentcnt = $row2[wr_commentcnt];
      $list[$key]->wr_datetime = $row2[wr_datetime];
  }
  mysql_free_result($result2);
}
mysql_free_result($result);
?>

<table width=100% border=0 cellspacing=0 cellpadding=0>
<?
if (count($list) > 0) {
  krsort($list);
  foreach ($list as $key=>$value) {
      $comment = "";
      $atag_comment = "";
      if ($value->wr_comment > 0) {
          $comment = "<span style='font-size:8pt;'>[c]</span> ";
          $atag_comment = "#c{$value->wr_id}";
      }

      $commentcnt = "";
      if ($value->wr_commentcnt > 0) {
          $commentcnt = "<font size=-2>({$value->wr_commentcnt})</font>";
      }

      $name = gblayer($value->mb_id, cut_str($value->wr_name,12), $value->wr_email, $value->wr_homepage);

      $value->bo_subject = cut_str($value->bo_subject, 20);

      echo "
      <tr height=22>
          <td width=150 align=left>[<a href='./?doc=$cfg[bbs_dir]/gnuboard.php&bo_table=".$value->bo_table."'>".$value->bo_subject."</a>]</td>
          <td align=left>  <a href='./?doc=$cfg[bbs_dir]/gnuboard.php&bo_table=".$value->bo_table."&wr_id=".$value->wr_parent_id."$atag_comment'>$comment{$value->wr_subject} {$commentcnt}</a></td>
          <td width=120 align=right> $name &nbsp;</td>
      </tr>\n";

      echo "<tr><td colspan=3 background='{$gnu_path}image/line_width.gif'></td></tr>\n";
  }
} else
  echo "<td height=25 align=center>등록된 글이 없습니다.</td>";
?>
</table>

<p>
 
<a href='./?doc=<?=$doc?>&hours=1'>1시간</a> |
<a href='./?doc=<?=$doc?>&hours=2'>2시간</a> |
<a href='./?doc=<?=$doc?>&hours=3'>3시간</a> |
<a href='./?doc=<?=$doc?>&hours=6'>6시간</a> |
<a href='./?doc=<?=$doc?>&hours=12'>12시간</a> |
<a href='./?doc=<?=$doc?>&hours=24'>24시간</a> |
<a href='./?doc=<?=$doc?>&hours=48'>48시간</a> |
<a href='./?doc=<?=$doc?>&hours=72'>72시간</a> |
<a href='./?doc=<?=$doc?>&hours=168'>1주일</a>

<p>

</td>
</tr>
</table>

==================================== 소스 끝 ========================================
  • 복사

댓글 전체

© SIRSOFT
현재 페이지 제일 처음으로