헐랭이님의 최신글 my_view 스킨 질문입니다. 정보
헐랭이님의 최신글 my_view 스킨 질문입니다.본문
최신글이 로그인한 회원에게만 보여지도록 되어 있는데 비회원도 보여지도록
할수 없을까요? 아시는 분 답변 부탁드립니다.
my_view.php
//////////////////////////////////////////////////////////////////////
<?
if (!defined("_GNUBOARD_")) exit; // 개별 페이지 접근 불가
/////////////////////////////////////////////////////////////////////
// 나의 최근게시물
//쿼리수정 및 페이징 처리변환 2007-02-05 by 헐랭이
/////////////////////////////////////////////////////////////////////
//회원이라면 출력
if ($member[mb_id]) {
if (!defined("_GNUBOARD_")) exit; // 개별 페이지 접근 불가
/////////////////////////////////////////////////////////////////////
// 나의 최근게시물
//쿼리수정 및 페이징 처리변환 2007-02-05 by 헐랭이
/////////////////////////////////////////////////////////////////////
//회원이라면 출력
if ($member[mb_id]) {
//////////////사용자설정///////////////////////
// 이스킨이 위치하는 경로를 넣어 주세요.
$new_my_skin_path ="{$g4[path]}/my_new";
$new_count = 8; //한번에 보여줄 갯수
$page_count = 5; //페이지출력수
$subjc = 25;//제목 글자수
$new_my_skin_path ="{$g4[path]}/my_new";
$new_count = 8; //한번에 보여줄 갯수
$page_count = 5; //페이지출력수
$subjc = 25;//제목 글자수
///////////////설정끝//////////////////
?>
<table width="100%" cellspacing="0" cellpadding="0">
<tr>
<td width="7" height="7"><img src="<?=$new_my_skin_path?>/img/line_mid_p1.gif"></td>
<td background="<?=$new_my_skin_path?>/img/line_mid_p5.gif"></td>
<td width="7"><img src="<?=$new_my_skin_path?>/img/line_mid_p2.gif"></td>
</tr>
<tr>
<td background="<?=$new_my_skin_path?>/img/line_mid_p8.gif"></td>
<td>
<?
$sql2 = " select count(*) as cnt from $g4[board_new_table]
where wr_id = wr_parent and mb_id = '$member[mb_id]' ";
$row2 = sql_fetch($sql2);
$total_count = number_format($row2[cnt]);
$rows = $page_count;
$total_page = ceil($total_count / $rows);
if (!$scpage) { $scpage = 1; }
$from_record = ($scpage - 1) * $rows;
$sql = " select bo_table, wr_id, wr_parent from $g4[board_new_table] a
where mb_id = '$member[mb_id]'
-- and a.wr_id = a.wr_parent
group by bo_table, wr_parent
order by bn_id desc limit $from_record, $new_count ";
$res = sql_query($sql);
<table width="100%" cellspacing="0" cellpadding="0">
<tr>
<td width="7" height="7"><img src="<?=$new_my_skin_path?>/img/line_mid_p1.gif"></td>
<td background="<?=$new_my_skin_path?>/img/line_mid_p5.gif"></td>
<td width="7"><img src="<?=$new_my_skin_path?>/img/line_mid_p2.gif"></td>
</tr>
<tr>
<td background="<?=$new_my_skin_path?>/img/line_mid_p8.gif"></td>
<td>
<?
$sql2 = " select count(*) as cnt from $g4[board_new_table]
where wr_id = wr_parent and mb_id = '$member[mb_id]' ";
$row2 = sql_fetch($sql2);
$total_count = number_format($row2[cnt]);
$rows = $page_count;
$total_page = ceil($total_count / $rows);
if (!$scpage) { $scpage = 1; }
$from_record = ($scpage - 1) * $rows;
$sql = " select bo_table, wr_id, wr_parent from $g4[board_new_table] a
where mb_id = '$member[mb_id]'
-- and a.wr_id = a.wr_parent
group by bo_table, wr_parent
order by bn_id desc limit $from_record, $new_count ";
$res = sql_query($sql);
echo "<table width=95% cellpadding=0 cellspacing=0 align=center>";
echo "<tr height=25><td><img src='$new_my_skin_path/img/list_icon.gif'> <a href='$g4[bbs_path]/new.php?view=w&mb_id=$member[mb_id]'><span style='color:#333333;'><b>나의 최근게시물 ({$total_count}) </b></span></a></td></tr><tr><td height=1 bgcolor=#FF9900></td></tr>";
$list = array();
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);
$list[$i] = $row2;
$subj = get_text($list[$i][wr_subject]);
$subj = cut_str($subj, $subjc);
$comment = "";
if ($list[$i][wr_comment])
$comment = "<span class=small>({$list[$i][wr_comment]})</span>";
echo "<tr height=23><td class=bg_menu2 title='$subj'>";
echo "<nobr style='display:block;overflow:hidden;width:160px;'>";
echo "<img src='$new_my_skin_path/img/list_icon2.gif'> <a href='$g4[bbs_path]/board.php?bo_table=$row[bo_table]&wr_id=$row[wr_parent]'>";
echo "<span style='color:#666666;'>$comment $subj</span></a>";
echo "</nobr></td></tr>";
}
if (!$total_count) {
echo "<tr><td><span style='color:gray;'>게시글이 없습니다.</span></td></tr>";
}else{
echo "<tr><td><span style='color:gray;'>";
$scpage = get_paging($page_count, $scpage, $total_page, "?gr_id=$gr_id&bo_table=$bo_table&scpage=");
echo "$scpage";
echo "</span></td></tr>";
}
echo "</table>\n";
?>
</td>
<td background="<?=$new_my_skin_path?>/img/line_mid_p6.gif"></td>
</tr>
<tr>
<td height="7"><img src="<?=$new_my_skin_path?>/img/line_mid_p4.gif"></td>
<td background="<?=$new_my_skin_path?>/img/line_mid_p7.gif"></td>
<td><img src="<?=$new_my_skin_path?>/img/line_mid_p3.gif"></td>
</tr>
</table>
<?
} else {
echo "로그인을 하셔야 보입니다.";
}
?>
echo "<tr height=25><td><img src='$new_my_skin_path/img/list_icon.gif'> <a href='$g4[bbs_path]/new.php?view=w&mb_id=$member[mb_id]'><span style='color:#333333;'><b>나의 최근게시물 ({$total_count}) </b></span></a></td></tr><tr><td height=1 bgcolor=#FF9900></td></tr>";
$list = array();
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);
$list[$i] = $row2;
$subj = get_text($list[$i][wr_subject]);
$subj = cut_str($subj, $subjc);
$comment = "";
if ($list[$i][wr_comment])
$comment = "<span class=small>({$list[$i][wr_comment]})</span>";
echo "<tr height=23><td class=bg_menu2 title='$subj'>";
echo "<nobr style='display:block;overflow:hidden;width:160px;'>";
echo "<img src='$new_my_skin_path/img/list_icon2.gif'> <a href='$g4[bbs_path]/board.php?bo_table=$row[bo_table]&wr_id=$row[wr_parent]'>";
echo "<span style='color:#666666;'>$comment $subj</span></a>";
echo "</nobr></td></tr>";
}
if (!$total_count) {
echo "<tr><td><span style='color:gray;'>게시글이 없습니다.</span></td></tr>";
}else{
echo "<tr><td><span style='color:gray;'>";
$scpage = get_paging($page_count, $scpage, $total_page, "?gr_id=$gr_id&bo_table=$bo_table&scpage=");
echo "$scpage";
echo "</span></td></tr>";
}
echo "</table>\n";
?>
</td>
<td background="<?=$new_my_skin_path?>/img/line_mid_p6.gif"></td>
</tr>
<tr>
<td height="7"><img src="<?=$new_my_skin_path?>/img/line_mid_p4.gif"></td>
<td background="<?=$new_my_skin_path?>/img/line_mid_p7.gif"></td>
<td><img src="<?=$new_my_skin_path?>/img/line_mid_p3.gif"></td>
</tr>
</table>
<?
} else {
echo "로그인을 하셔야 보입니다.";
}
?>
댓글 전체

my_view 의 의미가 내 글입니다..
비회원이 자신의 글이 있다고 생각하시면 오산입니다..
비회원이 자신의 글이 있다고 생각하시면 오산입니다..
답변 감사합니다.
제가 착각을 했습니다...^^
제가 착각을 했습니다...^^