sir 게시판 메뉴처럼 배추라이트 왼쪽메뉴에 뉴아이콘이나 오늘올라온 글갯수 표시방법 정보
sir 게시판 메뉴처럼 배추라이트 왼쪽메뉴에 뉴아이콘이나 오늘올라온 글갯수 표시방법본문
배추 라이트 사용자입니다
라이트에 왼쪽 메뉴쪽에.
뉴아이콘 이나 sir 홈 왼쪽메뉴처럼 글개수 표시되게 하는방법
<div class="sm_border">
<div class="sm_margin">
<?
$sql = "select * from $g4[group_table] ";
if ($gr_id)
$sql .= " where gr_id = '$gr_id' ";
$sql.= " order by gr_1 ";
$qry = sql_query($sql);
for ($i=0; $row=sql_fetch_array($qry); $i++) {
?>
<div class="sm_item">
<div class="sm_title"><a href="<?=$g4[bbs_path]?>/group.php?gr_id=<?=$row[gr_id]?>"><?=$row[gr_subject]?></a></div>
<?
//$sql2 = "select * from $g4[board_table] where gr_id = '$row[gr_id]' order by bo_order_search asc";
$sql2 = "select * from $g4[board_table] where gr_id = '$row[gr_id]' and bo_table != 'B11' order by bo_order_search asc";
$qry2 = sql_query($sql2);
for ($j=0; $row2=sql_fetch_array($qry2); $j++) {
if ($row2[bo_table] == $bo_table) $class = "sm_sub selected"; else $class = "sm_sub";
?>
<div class="<?=$class?>"><a href="<?=$g4[bbs_path]?>/board.php?bo_table=<?=$row2[bo_table]?>"><?=$row2[bo_subject]?></a></div>
<? } ?>
</div> <!-- sm_item -->
<? } ?>
</div> <!-- sm_margin -->
</div> <!-- sm_border -->
라이트에 왼쪽 메뉴쪽에.
뉴아이콘 이나 sir 홈 왼쪽메뉴처럼 글개수 표시되게 하는방법
<div class="sm_border">
<div class="sm_margin">
<?
$sql = "select * from $g4[group_table] ";
if ($gr_id)
$sql .= " where gr_id = '$gr_id' ";
$sql.= " order by gr_1 ";
$qry = sql_query($sql);
for ($i=0; $row=sql_fetch_array($qry); $i++) {
?>
<div class="sm_item">
<div class="sm_title"><a href="<?=$g4[bbs_path]?>/group.php?gr_id=<?=$row[gr_id]?>"><?=$row[gr_subject]?></a></div>
<?
//$sql2 = "select * from $g4[board_table] where gr_id = '$row[gr_id]' order by bo_order_search asc";
$sql2 = "select * from $g4[board_table] where gr_id = '$row[gr_id]' and bo_table != 'B11' order by bo_order_search asc";
$qry2 = sql_query($sql2);
for ($j=0; $row2=sql_fetch_array($qry2); $j++) {
if ($row2[bo_table] == $bo_table) $class = "sm_sub selected"; else $class = "sm_sub";
?>
<div class="<?=$class?>"><a href="<?=$g4[bbs_path]?>/board.php?bo_table=<?=$row2[bo_table]?>"><?=$row2[bo_subject]?></a></div>
<? } ?>
</div> <!-- sm_item -->
<? } ?>
</div> <!-- sm_margin -->
</div> <!-- sm_border -->
댓글 전체
험.... 그냥 주는건줄알고
왔는뎅..... ㅜㅠ
왔는뎅..... ㅜㅠ
<?
// 총 게시물의 갯수
$q_count = mysql_query("select * from $g4[board_table] where bo_table = '게시판아이디'");
$count_write = 0;
while($data=mysql_fetch_array($q_count)) {
$count_write += $data[bo_count_write];
}
?>
붙이고 싶은곳에
(<?=number_format($count_write)?>)개
// 총 게시물의 갯수
$q_count = mysql_query("select * from $g4[board_table] where bo_table = '게시판아이디'");
$count_write = 0;
while($data=mysql_fetch_array($q_count)) {
$count_write += $data[bo_count_write];
}
?>
붙이고 싶은곳에
(<?=number_format($count_write)?>)개
이렇게 고치면 7일꺼
<div class="sm_border">
<div class="sm_margin">
<?
$sql = "select * from $g4[group_table] ";
if ($gr_id)
$sql .= " where gr_id = '$gr_id' ";
$sql.= " order by gr_1 ";
$qry = sql_query($sql);
for ($i=0; $row=sql_fetch_array($qry); $i++) {
?>
<div class="sm_item">
<div class="sm_title"><a href="<?=$g4[bbs_path]?>/group.php?gr_id=<?=$row[gr_id]?>"><?=$row[gr_subject]?></a></div>
<?
//$sql2 = "select * from $g4[board_table] where gr_id = '$row[gr_id]' order by bo_order_search asc";
$sql2 = "select * from $g4[board_table] where gr_id = '$row[gr_id]' and bo_table != 'B11' order by bo_order_search asc";
$qry2 = sql_query($sql2);
for ($j=0; $row2=sql_fetch_array($qry2); $j++) {
$tmp_write_table = $g4['write_prefix'] . $row2[bo_table]; // 게시판 테이블 전체이름
$tmp_row = sql_fetch(" select count(wr_id) as cnt from $tmp_write_table where wr_is_comment = 0 and wr_datetime > (now() - INTERVAL 7 DAY) ");
if ($row2[bo_table] == $bo_table) $class = "sm_sub selected"; else $class = "sm_sub";
?>
<div class="<?=$class?>"><a href="<?=$g4[bbs_path]?>/board.php?bo_table=<?=$row2[bo_table]?>"><?=$row2[bo_subject]?><?=$tmp_row[cnt];?></a></div>
<? } ?>
</div> <!-- sm_item -->
<? } ?>
</div> <!-- sm_margin -->
</div> <!-- sm_border -->
<div class="sm_border">
<div class="sm_margin">
<?
$sql = "select * from $g4[group_table] ";
if ($gr_id)
$sql .= " where gr_id = '$gr_id' ";
$sql.= " order by gr_1 ";
$qry = sql_query($sql);
for ($i=0; $row=sql_fetch_array($qry); $i++) {
?>
<div class="sm_item">
<div class="sm_title"><a href="<?=$g4[bbs_path]?>/group.php?gr_id=<?=$row[gr_id]?>"><?=$row[gr_subject]?></a></div>
<?
//$sql2 = "select * from $g4[board_table] where gr_id = '$row[gr_id]' order by bo_order_search asc";
$sql2 = "select * from $g4[board_table] where gr_id = '$row[gr_id]' and bo_table != 'B11' order by bo_order_search asc";
$qry2 = sql_query($sql2);
for ($j=0; $row2=sql_fetch_array($qry2); $j++) {
$tmp_write_table = $g4['write_prefix'] . $row2[bo_table]; // 게시판 테이블 전체이름
$tmp_row = sql_fetch(" select count(wr_id) as cnt from $tmp_write_table where wr_is_comment = 0 and wr_datetime > (now() - INTERVAL 7 DAY) ");
if ($row2[bo_table] == $bo_table) $class = "sm_sub selected"; else $class = "sm_sub";
?>
<div class="<?=$class?>"><a href="<?=$g4[bbs_path]?>/board.php?bo_table=<?=$row2[bo_table]?>"><?=$row2[bo_subject]?><?=$tmp_row[cnt];?></a></div>
<? } ?>
</div> <!-- sm_item -->
<? } ?>
</div> <!-- sm_margin -->
</div> <!-- sm_border -->
g4_board.bo_count_write
사용하시면 더 편해요.
사용하시면 더 편해요.