"나의 최근 게시물"기능 그룹에 따른 설정.. 정보
"나의 최근 게시물"기능 그룹에 따른 설정..본문
아래는 제가 현재 수정해서 사용중인 소스입니다.
<?
global $g4;
global $g4;
// 나의 최근게시물
if ($member[mb_id])
{
$new_count = 10;
if ($member[mb_id])
{
$new_count = 10;
$cnt = 0;
$sql = " select a.bo_table, a.wr_parent, b.gr_id
from $g4[board_new_table] a,
g4_board b
where a.mb_id = '$member[mb_id]'
and a.wr_id = a.wr_parent
and a.bo_table = b.bo_table
group by a.bo_table, a.wr_parent
order by a.bn_id desc
limit $new_count ";
$res = sql_query($sql);
$sql = " select a.bo_table, a.wr_parent, b.gr_id
from $g4[board_new_table] a,
g4_board b
where a.mb_id = '$member[mb_id]'
and a.wr_id = a.wr_parent
and a.bo_table = b.bo_table
group by a.bo_table, a.wr_parent
order by a.bn_id desc
limit $new_count ";
$res = sql_query($sql);
echo "<table width=150 cellpadding=0 cellspacing=0 style=border-color:#AAAAAA; border-width:0px; border-style:solid>";
echo '<tr><td><img src='.$g4[bbs_path].'/images/box_01.gif border="0"></td></tr>';
echo "<tr><td background='$g4[bbs_path]/images/box_02.gif'> <a href='$g4[bbs_path]/new.php?view=w&mb_id=$member[mb_id]'><b><span class=webfont>◈ 나의 최근게시물</span></b></a></td></tr>
<tr><td background='$g4[bbs_path]/images/box_02.gif' height=10></td></tr>";
for ($i=0; $row=sql_fetch_array($res), $i<$new_count; $i++)
{
if (!$row[bo_table])
{
continue;
}
$tmp_table = $g4[write_prefix].$row[bo_table];
$sql2 = " select wr_subject, wr_comment from $tmp_table where wr_id = '$row[wr_parent]' ";
$row2 = sql_fetch($sql2);
$subj = get_text($row2[wr_subject]);
$subj = conv_subject($subj,16, "…");
$comment = "";
if ($row2[wr_comment])
$comment = "<span class='webfont'>($row2[wr_comment])</span> ";
echo "<tr><td background='$g4[bbs_path]/images/box_02.gif' title='$subj'>";
echo "<nobr style='display:block;overflow:hidden;width:130px;'>";
echo '<tr><td><img src='.$g4[bbs_path].'/images/box_01.gif border="0"></td></tr>';
echo "<tr><td background='$g4[bbs_path]/images/box_02.gif'> <a href='$g4[bbs_path]/new.php?view=w&mb_id=$member[mb_id]'><b><span class=webfont>◈ 나의 최근게시물</span></b></a></td></tr>
<tr><td background='$g4[bbs_path]/images/box_02.gif' height=10></td></tr>";
for ($i=0; $row=sql_fetch_array($res), $i<$new_count; $i++)
{
if (!$row[bo_table])
{
continue;
}
$tmp_table = $g4[write_prefix].$row[bo_table];
$sql2 = " select wr_subject, wr_comment from $tmp_table where wr_id = '$row[wr_parent]' ";
$row2 = sql_fetch($sql2);
$subj = get_text($row2[wr_subject]);
$subj = conv_subject($subj,16, "…");
$comment = "";
if ($row2[wr_comment])
$comment = "<span class='webfont'>($row2[wr_comment])</span> ";
echo "<tr><td background='$g4[bbs_path]/images/box_02.gif' title='$subj'>";
echo "<nobr style='display:block;overflow:hidden;width:130px;'>";
if ($row[gr_id] == 'club')
{
echo " <a href='$g4[path]/club/club_main.php?doc=http://tfh.or.kr/bbs/bbs/board.php?bo_table=$row[bo_table]&cb_id=$row[bo_table]&wr_id=$row[wr_parent]'>";
}
else
{
echo " <a href='$g4[bbs_path]/board.php?bo_table=$row[bo_table]&wr_id=$row[wr_parent]'>";
}
echo "<span class=webfont>"."$comment$subj</a></span>";
echo "</nobr></td></tr>";
$cnt++;
}
if (!$cnt)
echo "<tr><td background='$g4[bbs_path]/images/box_02.gif'><span class='webfont'> 게시글이 없습니다.</span></td></tr>";
echo "<tr><td><img src='$g4[bbs_path]/images/box_04.gif' border=0></td></tr>";
echo "</table>\n";
}
?>
{
echo " <a href='$g4[path]/club/club_main.php?doc=http://tfh.or.kr/bbs/bbs/board.php?bo_table=$row[bo_table]&cb_id=$row[bo_table]&wr_id=$row[wr_parent]'>";
}
else
{
echo " <a href='$g4[bbs_path]/board.php?bo_table=$row[bo_table]&wr_id=$row[wr_parent]'>";
}
echo "<span class=webfont>"."$comment$subj</a></span>";
echo "</nobr></td></tr>";
$cnt++;
}
if (!$cnt)
echo "<tr><td background='$g4[bbs_path]/images/box_02.gif'><span class='webfont'> 게시글이 없습니다.</span></td></tr>";
echo "<tr><td><img src='$g4[bbs_path]/images/box_04.gif' border=0></td></tr>";
echo "</table>\n";
}
?>
나라오름님의 클럽을 설치하다보니 club게시물의 링크는 따로 걸어줘야 해서
수정했는데 그전까진 최근에 코멘트 단 글도 리스팅이 되었는데 지금은 새로 작성한
글만 리스팅이 됩니다.
어느부분이 잘못된 걸까요?
답변 부탁드립니다.
댓글 전체