전체글보기 어디가 문젠지 모르겠네요~ 정보
전체글보기 어디가 문젠지 모르겠네요~첨부파일
본문
================================================================================
아무리 봐도 찾질 못하겠습니다
현재 전체글보기에 아무것도 나타나지 안아요
제 컴 윈도우 환경에선 잘되는데 웹호스팅에 올리면 안되네요
웹호스팅은 비누넷입니다. ( http://www.byus.net/ )
이미지는 제 컴에서 캡쳐한거구요
그누보드용 솔루션 22CAFE v.1.1 빌더 설치했습니다 =>1000c.org
답 좀찾아주세요 부탁드립니다.
================================ /new/new.skin.php ===============================
<?
if (!defined("_GNUBOARD_")) exit; // 개별 페이지 접근 불가
$g4[title] = "최근게시물";
if (!$latest_date) $latest_date = "60"; // 최근게시물 기간설정
$new_icon = 1; // 뉴 아이콘 생성 기간 설정
$page_count = 15; // 페이지 목록수 지정
$sqlc = " SELECT * from $g4[board_new_table] WHERE wr_id <> wr_parent AND write_mb_id = ''";
$resultc = mysql_query($sqlc);
for ($i=0; $rowc = sql_fetch_array($resultc); $i++){
$sql8 = "SELECT * from $g4[write_prefix]$rowc[bo_table] where wr_id = '$rowc[wr_parent]' ";
$row8 = sql_fetch($sql8);
if ($row8[wr_is_comment] == '0') { // 코멘트가 아닌경우
sql_fetch(" UPDATE $g4[board_new_table] set write_mb_id = '$row8[mb_id]' where bn_id = '$rowc[bn_id]' ");
}
}
// 최근게시물 기간설정
$before_time = date("Y-m-d H:i:s", $g4[server_time] - (86400 * $latest_date));
// 최신 코멘트 new 아이콘 생성관련 기간 설정
$newicon_time = date("Y-m-d H:i:s", $g4[server_time] - (86400 * $new_icon));
$sql_common = " from $g4[board_new_table] a, $g4[board_table] b, $g4[group_table] c
where a.bo_table = b.bo_table and b.gr_id = c.gr_id and b.bo_use_search = '1' and a.bn_datetime > '$before_time' ";
if ($gr_id)
$sql_common .= " and b.gr_id = '$gr_id' ";
if ($view == "w")
$sql_common .= " and a.wr_id = a.wr_parent ";
else if ($view == "c")
$sql_common .= " and a.wr_id <> a.wr_parent ";
if ($mb_id)
$sql_common .= " and a.mb_id = '$mb_id' ";
if($is_admin != super) {
$sql_common .=" and a.bo_table <> 'mypage'
and a.bo_table <> 'postit' "; }
$sql_order = " order by a.bn_id desc ";
$sql = " select count(*) as cnt $sql_common ";
$row = sql_fetch($sql);
$total_count = $row[cnt];
$rows = $page_count;
$total_page = ceil($total_count / $rows); // 전체 페이지 계산
if (!$page) $page = 1; // 페이지가 없으면 첫 페이지 (1 페이지)
$from_record = ($page - 1) * $rows; // 시작 열을 구함
$group_select = "<select name=gr_id id=gr_id onchange='select_change();'><option value=''>전체그룹";
$sql = " select gr_id, gr_subject from $g4[group_table] order by gr_id ";
$result = sql_query($sql);
for ($i=0; $row=sql_fetch_array($result); $i++)
{
$group_select .= "<option value='$row[gr_id]'>$row[gr_subject]";
}
$group_select .= "</select>";
$list = array();
$sql = " select a.*, b.bo_subject, c.gr_subject, c.gr_id
$sql_common
$sql_order
limit $from_record, $rows ";
$result = sql_query($sql);
for ($i=0; $row=sql_fetch_array($result); $i++)
{
$tmp_write_table = $g4[write_prefix] . $row[bo_table];
if ($row[wr_id] == $row[wr_parent]) // 원글
{
$comment = "";
$comment_link = "";
$row2 = sql_fetch(" select * from $tmp_write_table where wr_id = '$row[wr_id]' ");
$name = get_sideview($row2[mb_id], cut_str($row2[wr_name], $config[cf_cut_name]), $row2[wr_email], $row2[wr_homepage]);
// 당일인 경우 시간으로 표시함
$datetime = substr($row2[wr_datetime],0,10);
$datetime2 = $row2[wr_datetime];
if ($datetime == $g4[time_ymd])
$datetime2 = substr($datetime2,11,5);
else
$datetime2 = substr($datetime2,5,5);
}
else // 코멘트
{
$comment = "[코] ";
$comment_link = "#c_{$row[wr_id]}";
$row2 = sql_fetch(" select * from $tmp_write_table where wr_id = '$row[wr_parent]' ");
$row3 = sql_fetch(" select mb_id, wr_name, wr_email, wr_homepage, wr_datetime from $tmp_write_table where wr_id = '$row[wr_id]' ");
$list[$i] = $row2;
$list[$i][mb_id] = $row3[mb_id];
$list[$i][wr_name] = $row3[wr_name];
$list[$i][wr_email] = $row3[wr_email];
$list[$i][wr_homepage] = $row3[wr_homepage];
$name = get_sideview($row3[mb_id], cut_str($row3[wr_name], $config[cf_cut_name]), $row3[wr_email], $row3[wr_homepage]);
// 당일인 경우 시간으로 표시함
$datetime = substr($row3[wr_datetime],0,10);
$datetime2 = $row3[wr_datetime];
if ($datetime == $g4[time_ymd])
$datetime2 = substr($datetime2,11,5);
else
$datetime2 = substr($datetime2,5,5);
}
if($row[bn_datetime] > $newicon_time)
{ $list[$i][newicon] = "<img src='$g4[path]/img/icon_new.gif'>";
}else{ $list[$i][newicon] = ''; }
$list[$i][gr_id] = $row[gr_id];
$list[$i][bo_table] = $row[bo_table];
$list[$i][name] = $name;
$list[$i][comment] = $comment;
$list[$i][href] = "./board.php?bo_table=$row[bo_table]&wr_id=$row2[wr_id]{$comment_link}";
$list[$i][datetime] = $datetime;
$list[$i][datetime2] = $datetime2;
$list[$i][gr_subject] = $row[gr_subject];
$list[$i][bo_subject] = $row[bo_subject];
$list[$i][wr_subject] = $row2[wr_subject];
}
$write_pages = get_paging($config[cf_write_pages], $page, $total_page, "?gr_id=$gr_id&view=$view&mb_id=$mb_id&page=");
// 최근게시물 스킨을 불러와서 처리할수도 있고 그냥 한 화일에서 처리할수도있습니다.
$new_skin_path = "$g4[path]/skin/new/$config[cf_new_skin]";
echo "<script language=\"javascript\" src=\"$g4[path]/js/sideview.js\"></script>\n";
$color = array('#669999');
shuffle($color);
for( $i = 0; $i < 1; $i++ )
{
$ran_color = $color[$i];
}
?>
<style>
.n_title1 { font-family:굴림;돋움; font-size:9pt; color:#FFFFFF; }
.n_title2 { font-family:굴림;돋움; font-size:9pt; color:<? echo $ran_color?>; }
.line_bg {background-color: <? echo $ran_color?>; filter: Alpha(Opacity=60); -moz-opacity:0.6;}
</style>
<table width="99%" border="0" cellspacing="0" cellpadding="0"><tr><td align="center" bgcolor=#ffffff>
<table width=100% cellspacing=1 cellpadding=10 border=1><td bgcolor=#ffffff>
<font color='#666666'>▒ <b>최근 게시물</b></font> <br>
<font color='#666666'>- 최근 <font color='#555555'><?=$latest_date?> 일 동안 올라온 전체 게시물은 <b><font color='#555555'><?=$total_count?></font></b> 건 입니다. </font><br>
</td></table></td></tr></table><br><br>
<form name=fnew method=get style="margin:0px;">
<table width="95%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height=30>
<p><!-- Radio 버튼 처리 (by nasca) -->
<input type='radio' name='view' value='' onClick="select_change('')" <?=($view == "") ? "checked" : "";?>>전체게시물
<input type='radio' name='view' value='w' onClick="select_change('w')" <?=($view == "w") ? "checked" : "";?>>원글만
<input type='radio' name='view' value='c' onClick="select_change('c')" <?=($view == "c") ? "checked" : "";?>>코멘트만
<b>회원아이디 : </b><input type=text id='mb_id' name='mb_id' value='<?=$mb_id?>'>
<input type=submit value='검색'>
<a href="<?=$g4[bbs_path]?>/new.php">전체보기</a>
<script language="JavaScript">
function select_change()
{
document.fnew.submit();
}
//document.getElementById("view").value = "<?=$view?>";//원본
</script>
</p>
</td>
</tr>
</table>
</form>
<table width="100%" align="center" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr><td>
<tr>
<td>
<table width="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#ffffff">
<tr>
<td bgcolor="#dddddd">
<table width="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr>
<td>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="5"></td>
</tr>
<tr>
<td height="100" valign="top">
<p><!-- 분류 끝 -->
<!-- 제목 시작 -->
</p>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td colspan=5 bgcolor="#cccccc" height=1></td>
</tr>
<tr bgcolor="#ffffff">
<td align=center width="8%" height=30><b>번호</b></td>
<td align=center width="22%" height=30><b>게시판</b></td>
<td align=center width=""><b>내용</b></td>
<td align=center width="10%"><b>글쓴이</b></td>
<td align=center width="10%"><b>날짜</b></td>
</tr>
<tr>
<td colspan=5 bgcolor="#cccccc" height=1></td>
</tr>
<?
for ($i=0; $i<count($list); $i++)
{
$gr_subject = cut_str($list[$i][gr_subject], 25);
$bo_subject = cut_str($list[$i][bo_subject], 25);
$wr_subject = get_text(cut_str($list[$i][wr_subject], 80));
$list[$i][name] = strip_tags($list[$i][name]);
$list[$i][num] = number_format($total_count - ($page - 1) * $rows - $i);
?>
<tr bgcolor="#ffffff">
<td align=center height=25> <?=$list[$i][num]?> </td>
<td align=center height=25> <a href='./board.php?bo_table=<?=$list[$i][bo_table]?>' title='<?=$list[$i][bo_subject]?>'><font style='color:#CC9999;'><B><?=$bo_subject?></B></font></a></td>
<td align=left height=25> <a href='<?=$list[$i][href]?>' title='<?=$list[$i][wr_subject]?>'> <?=$list[$i][comment]?><?=$wr_subject?></a> <?=$list[$i][newicon]?></td>
<td align=center height=25> <font style='font-size:8pt;font-family:tahoma;color:#bbbbbb; text-align=right;'> <?=$list[$i][name]?> </font> </td>
<td align=center height=25> <font style='font-size:8pt;font-family:tahoma;color:#bbbbbb;'> <?=$list[$i][datetime2]?></font> </td>
</tr>
<tr>
<td colspan="5" height="1" bgcolor="#e1e1e1"></td>
</tr>
<? } ?>
<? if ($i == 0) { ?>
<tr><td colspan="5" height=50 align=center>최근 등록된 글이 없습니다.</td></tr>
<? } ?>
<tr>
<td colspan="9" height="50" align="center"><?=$write_pages?></td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="3"></td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
아무리 봐도 찾질 못하겠습니다
현재 전체글보기에 아무것도 나타나지 안아요
제 컴 윈도우 환경에선 잘되는데 웹호스팅에 올리면 안되네요
웹호스팅은 비누넷입니다. ( http://www.byus.net/ )
이미지는 제 컴에서 캡쳐한거구요
그누보드용 솔루션 22CAFE v.1.1 빌더 설치했습니다 =>1000c.org
답 좀찾아주세요 부탁드립니다.
================================ /new/new.skin.php ===============================
<?
if (!defined("_GNUBOARD_")) exit; // 개별 페이지 접근 불가
$g4[title] = "최근게시물";
if (!$latest_date) $latest_date = "60"; // 최근게시물 기간설정
$new_icon = 1; // 뉴 아이콘 생성 기간 설정
$page_count = 15; // 페이지 목록수 지정
$sqlc = " SELECT * from $g4[board_new_table] WHERE wr_id <> wr_parent AND write_mb_id = ''";
$resultc = mysql_query($sqlc);
for ($i=0; $rowc = sql_fetch_array($resultc); $i++){
$sql8 = "SELECT * from $g4[write_prefix]$rowc[bo_table] where wr_id = '$rowc[wr_parent]' ";
$row8 = sql_fetch($sql8);
if ($row8[wr_is_comment] == '0') { // 코멘트가 아닌경우
sql_fetch(" UPDATE $g4[board_new_table] set write_mb_id = '$row8[mb_id]' where bn_id = '$rowc[bn_id]' ");
}
}
// 최근게시물 기간설정
$before_time = date("Y-m-d H:i:s", $g4[server_time] - (86400 * $latest_date));
// 최신 코멘트 new 아이콘 생성관련 기간 설정
$newicon_time = date("Y-m-d H:i:s", $g4[server_time] - (86400 * $new_icon));
$sql_common = " from $g4[board_new_table] a, $g4[board_table] b, $g4[group_table] c
where a.bo_table = b.bo_table and b.gr_id = c.gr_id and b.bo_use_search = '1' and a.bn_datetime > '$before_time' ";
if ($gr_id)
$sql_common .= " and b.gr_id = '$gr_id' ";
if ($view == "w")
$sql_common .= " and a.wr_id = a.wr_parent ";
else if ($view == "c")
$sql_common .= " and a.wr_id <> a.wr_parent ";
if ($mb_id)
$sql_common .= " and a.mb_id = '$mb_id' ";
if($is_admin != super) {
$sql_common .=" and a.bo_table <> 'mypage'
and a.bo_table <> 'postit' "; }
$sql_order = " order by a.bn_id desc ";
$sql = " select count(*) as cnt $sql_common ";
$row = sql_fetch($sql);
$total_count = $row[cnt];
$rows = $page_count;
$total_page = ceil($total_count / $rows); // 전체 페이지 계산
if (!$page) $page = 1; // 페이지가 없으면 첫 페이지 (1 페이지)
$from_record = ($page - 1) * $rows; // 시작 열을 구함
$group_select = "<select name=gr_id id=gr_id onchange='select_change();'><option value=''>전체그룹";
$sql = " select gr_id, gr_subject from $g4[group_table] order by gr_id ";
$result = sql_query($sql);
for ($i=0; $row=sql_fetch_array($result); $i++)
{
$group_select .= "<option value='$row[gr_id]'>$row[gr_subject]";
}
$group_select .= "</select>";
$list = array();
$sql = " select a.*, b.bo_subject, c.gr_subject, c.gr_id
$sql_common
$sql_order
limit $from_record, $rows ";
$result = sql_query($sql);
for ($i=0; $row=sql_fetch_array($result); $i++)
{
$tmp_write_table = $g4[write_prefix] . $row[bo_table];
if ($row[wr_id] == $row[wr_parent]) // 원글
{
$comment = "";
$comment_link = "";
$row2 = sql_fetch(" select * from $tmp_write_table where wr_id = '$row[wr_id]' ");
$name = get_sideview($row2[mb_id], cut_str($row2[wr_name], $config[cf_cut_name]), $row2[wr_email], $row2[wr_homepage]);
// 당일인 경우 시간으로 표시함
$datetime = substr($row2[wr_datetime],0,10);
$datetime2 = $row2[wr_datetime];
if ($datetime == $g4[time_ymd])
$datetime2 = substr($datetime2,11,5);
else
$datetime2 = substr($datetime2,5,5);
}
else // 코멘트
{
$comment = "[코] ";
$comment_link = "#c_{$row[wr_id]}";
$row2 = sql_fetch(" select * from $tmp_write_table where wr_id = '$row[wr_parent]' ");
$row3 = sql_fetch(" select mb_id, wr_name, wr_email, wr_homepage, wr_datetime from $tmp_write_table where wr_id = '$row[wr_id]' ");
$list[$i] = $row2;
$list[$i][mb_id] = $row3[mb_id];
$list[$i][wr_name] = $row3[wr_name];
$list[$i][wr_email] = $row3[wr_email];
$list[$i][wr_homepage] = $row3[wr_homepage];
$name = get_sideview($row3[mb_id], cut_str($row3[wr_name], $config[cf_cut_name]), $row3[wr_email], $row3[wr_homepage]);
// 당일인 경우 시간으로 표시함
$datetime = substr($row3[wr_datetime],0,10);
$datetime2 = $row3[wr_datetime];
if ($datetime == $g4[time_ymd])
$datetime2 = substr($datetime2,11,5);
else
$datetime2 = substr($datetime2,5,5);
}
if($row[bn_datetime] > $newicon_time)
{ $list[$i][newicon] = "<img src='$g4[path]/img/icon_new.gif'>";
}else{ $list[$i][newicon] = ''; }
$list[$i][gr_id] = $row[gr_id];
$list[$i][bo_table] = $row[bo_table];
$list[$i][name] = $name;
$list[$i][comment] = $comment;
$list[$i][href] = "./board.php?bo_table=$row[bo_table]&wr_id=$row2[wr_id]{$comment_link}";
$list[$i][datetime] = $datetime;
$list[$i][datetime2] = $datetime2;
$list[$i][gr_subject] = $row[gr_subject];
$list[$i][bo_subject] = $row[bo_subject];
$list[$i][wr_subject] = $row2[wr_subject];
}
$write_pages = get_paging($config[cf_write_pages], $page, $total_page, "?gr_id=$gr_id&view=$view&mb_id=$mb_id&page=");
// 최근게시물 스킨을 불러와서 처리할수도 있고 그냥 한 화일에서 처리할수도있습니다.
$new_skin_path = "$g4[path]/skin/new/$config[cf_new_skin]";
echo "<script language=\"javascript\" src=\"$g4[path]/js/sideview.js\"></script>\n";
$color = array('#669999');
shuffle($color);
for( $i = 0; $i < 1; $i++ )
{
$ran_color = $color[$i];
}
?>
<style>
.n_title1 { font-family:굴림;돋움; font-size:9pt; color:#FFFFFF; }
.n_title2 { font-family:굴림;돋움; font-size:9pt; color:<? echo $ran_color?>; }
.line_bg {background-color: <? echo $ran_color?>; filter: Alpha(Opacity=60); -moz-opacity:0.6;}
</style>
<table width="99%" border="0" cellspacing="0" cellpadding="0"><tr><td align="center" bgcolor=#ffffff>
<table width=100% cellspacing=1 cellpadding=10 border=1><td bgcolor=#ffffff>
<font color='#666666'>▒ <b>최근 게시물</b></font> <br>
<font color='#666666'>- 최근 <font color='#555555'><?=$latest_date?> 일 동안 올라온 전체 게시물은 <b><font color='#555555'><?=$total_count?></font></b> 건 입니다. </font><br>
</td></table></td></tr></table><br><br>
<form name=fnew method=get style="margin:0px;">
<table width="95%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height=30>
<p><!-- Radio 버튼 처리 (by nasca) -->
<input type='radio' name='view' value='' onClick="select_change('')" <?=($view == "") ? "checked" : "";?>>전체게시물
<input type='radio' name='view' value='w' onClick="select_change('w')" <?=($view == "w") ? "checked" : "";?>>원글만
<input type='radio' name='view' value='c' onClick="select_change('c')" <?=($view == "c") ? "checked" : "";?>>코멘트만
<b>회원아이디 : </b><input type=text id='mb_id' name='mb_id' value='<?=$mb_id?>'>
<input type=submit value='검색'>
<a href="<?=$g4[bbs_path]?>/new.php">전체보기</a>
<script language="JavaScript">
function select_change()
{
document.fnew.submit();
}
//document.getElementById("view").value = "<?=$view?>";//원본
</script>
</p>
</td>
</tr>
</table>
</form>
<table width="100%" align="center" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr><td>
<tr>
<td>
<table width="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#ffffff">
<tr>
<td bgcolor="#dddddd">
<table width="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr>
<td>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="5"></td>
</tr>
<tr>
<td height="100" valign="top">
<p><!-- 분류 끝 -->
<!-- 제목 시작 -->
</p>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td colspan=5 bgcolor="#cccccc" height=1></td>
</tr>
<tr bgcolor="#ffffff">
<td align=center width="8%" height=30><b>번호</b></td>
<td align=center width="22%" height=30><b>게시판</b></td>
<td align=center width=""><b>내용</b></td>
<td align=center width="10%"><b>글쓴이</b></td>
<td align=center width="10%"><b>날짜</b></td>
</tr>
<tr>
<td colspan=5 bgcolor="#cccccc" height=1></td>
</tr>
<?
for ($i=0; $i<count($list); $i++)
{
$gr_subject = cut_str($list[$i][gr_subject], 25);
$bo_subject = cut_str($list[$i][bo_subject], 25);
$wr_subject = get_text(cut_str($list[$i][wr_subject], 80));
$list[$i][name] = strip_tags($list[$i][name]);
$list[$i][num] = number_format($total_count - ($page - 1) * $rows - $i);
?>
<tr bgcolor="#ffffff">
<td align=center height=25> <?=$list[$i][num]?> </td>
<td align=center height=25> <a href='./board.php?bo_table=<?=$list[$i][bo_table]?>' title='<?=$list[$i][bo_subject]?>'><font style='color:#CC9999;'><B><?=$bo_subject?></B></font></a></td>
<td align=left height=25> <a href='<?=$list[$i][href]?>' title='<?=$list[$i][wr_subject]?>'> <?=$list[$i][comment]?><?=$wr_subject?></a> <?=$list[$i][newicon]?></td>
<td align=center height=25> <font style='font-size:8pt;font-family:tahoma;color:#bbbbbb; text-align=right;'> <?=$list[$i][name]?> </font> </td>
<td align=center height=25> <font style='font-size:8pt;font-family:tahoma;color:#bbbbbb;'> <?=$list[$i][datetime2]?></font> </td>
</tr>
<tr>
<td colspan="5" height="1" bgcolor="#e1e1e1"></td>
</tr>
<? } ?>
<? if ($i == 0) { ?>
<tr><td colspan="5" height=50 align=center>최근 등록된 글이 없습니다.</td></tr>
<? } ?>
<tr>
<td colspan="9" height="50" align="center"><?=$write_pages?></td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="3"></td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
댓글 전체