게시판 목록 오류인데 해석좀 부탁드립니다 ㅠㅠ; > 그누4 질문답변

그누4 질문답변

그누보드4 관련 질문은 QA 로 이전됩니다. QA 그누보드4 바로가기
기존 게시물은 열람만 가능합니다.

게시판 목록 오류인데 해석좀 부탁드립니다 ㅠㅠ; 정보

게시판 목록 오류인데 해석좀 부탁드립니다 ㅠㅠ;

본문

오류가 나는곳의 주소를 알려주시면 더 빠르고 정확하게 답변 받을 수 있습니다.

오류 주소 :  torrent.cafe24.com (자료공유실 -> 게임) 목록화면

아래 링크의 게임게시판을 계정에 업로드해서 글을 작성했는데요.
http://www.sir.co.kr/bbs/board.php?bo_table=g4_skin&wr_id=69629&sca=&sfl=wr_subject&stx=%B0%D4%C0%D3&sop=and

아래의 경고메세지가 게시글 목록에 표시가 됩니다.
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/hosting_users/torrent/www/skin/board/game/list.skin.php on line 164

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/hosting_users/torrent/www/skin/board/game/list.skin.php on line 168

아..; 해결하고 싶은데 뭘 알아야 해결을 하는데 너무 막막하네요 ㅠㅠ

아래가 소스 화면인데요

부탁드립니다.(__)  아래쪽이 좀 정신없어서 다시; 수정해서 올립니다.


<?
if (!defined("_GNUBOARD_")) exit;
$colspan = 5;
if ($is_category) $colspan++;
if ($is_checkbox) $colspan++;

include "$board_skin_path/style.php";

$list_width = "100";
?>

<!-- 게시판 목록 시작 -->
<table width="<?=$width?>" align=center cellpadding=0 cellspacing=0>
<tr><td>

<!-- 부분나눔 열기  -->
<TABLE height="20" width="100%" cellpadding="0" cellspacing="0" border="0">
  <tr>
    <td align=left>

<table cellpadding=0 cellspacing=0 border=0>
<form name=fsearch method=get style="margin:0px;">
<input type=hidden name=bo_table value="<?=$bo_table?>">
<input type=hidden name=sca      value="<?=$sca?>">
<tr><td>
        <select name=sfl>
            <option value='wr_subject'>게임명</option>
            <option value='wr_2'>게임장르</option>           
        </select>
<input name=stx maxlength=15 size=20 itemname="검색어" required value='<?=$stx?>'>
<select name=sop>
            <option value=and>and</option>
            <option value=or>or</option>
        </select>
        <input type=image src="<?=$board_skin_path?>/img/btn_list_search.gif" border=0 align=absmiddle></td>
</tr>
</form>
</table>
 

</td>

<td align=right>

<TABLE cellpadding="0" cellspacing="0" border="0">
<tr>
<? if ($is_category) { ?><form name="fcategory" method="get"><td><select name=sca onchange="location='<?=$category_location?>'+this.value;"><option value=''>전체</option><?=$category_option?></select></td></form><? } ?>
&nbsp;&nbsp;<td>
Total <?=number_format($total_count)?>
        <? if ($rss_href) { ?><a href='<?=$rss_href?>'><img src='<?=$board_skin_path?>/img/btn_rss.gif' border=0 align=absmiddle></a><?}?>
        <? if ($admin_href) { ?><a href="<?=$admin_href?>"><img src="<?=$board_skin_path?>/img/btn_admin.gif" title="관리자" width="63" height="22" border="0" align="absmiddle"></a><?}?>&nbsp;
</td>
</tr>
</table>

</td>
  </tr> 
</table>
<!-- 부분나눔 닫기  -->

<!-- 부분나눔 열기  -->
<TABLE width="100%" cellpadding="0" cellspacing="0" border="0">
  <tr><td height=5></td></tr>
</table>
<!-- 부분나눔 닫기  -->

<!-- 제목 -->
<form name="fboardlist" method="post" style="margin:0px;">
<input type='hidden' name='bo_table' value='<?=$bo_table?>'>
<input type='hidden' name='sfl'  value='<?=$sfl?>'>
<input type='hidden' name='stx'  value='<?=$stx?>'>
<input type='hidden' name='spt'  value='<?=$spt?>'>
<input type='hidden' name='page' value='<?=$page?>'>
<input type='hidden' name='sw'  value=''>

<TABLE width="100%" cellpadding="0" cellspacing="0" border="0">
<tr><td height="1" bgcolor="#CCCCCC"></td></tr>
<tr><td height="3" bgcolor="#F6F6F6"></td></tr>
</table>

<table border="0" cellpadding="0" cellspacing="0">
<!-- 목록 -->
<? for ($i=0; $i<count($list); $i++) { ?>
<tr>
<!-- 카테고리 -->
    <? if ($is_category) { ?><td><a href="<?=$list[$i][ca_name_href]?>"><span class=small style='color:#999999;'><?=$list[$i][ca_name]?></span></a></td><? } ?>

<!-- 체크박스 -->
    <? if ($is_checkbox) { ?><td width=30><input type=checkbox name=chk_wr_id[] value="<?=$list[$i][wr_id]?>"></td><? } ?>

  <?
if($list[$i][file][0][file]){
$image = $list[$i][file][0][file];
$image= "<img src='$g4[path]/data/file/$board[bo_table]/$image' width='$list_width' border='0'>";}

if ($wr_id == $list[$i][wr_id]) // 현재위치
echo "<td align=center valign=top width=120><table align=center cellpadding='5' cellspacing='5' border='0'>
<tr><td bgcolor=#2892CF align=center>";
else
echo "<td align=center valign=top width=120><table align=center cellpadding='3' cellspacing='3' border='0'>
<tr><td bgcolor=#000000 align=center>";
?>

<a href="<?=$list[$i][href]?>" onfocus='blur()'><?=$image?></a>

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

</td>

<!-- 여백 -->
<td width=10></td>

<td>

<style>
.cross_color1 {
color:#2381B6;
text-align:center;
vertical-align:middle;
font-size:7pt;
}
</style>

<!-- <img src="<?=$board_skin_path?>/img/sub.gif"> -->

<?
$cross_color1 = "<span class='cross_color'>▶</span>";
?>

<TABLE cellpadding="1" cellspacing="1" border="0">
 <tr>
<td valign=top><?=$cross_color1?>&nbsp;</td>
<td><b>게임명:</b>&nbsp;<span style='font:normal 11px tahoma; color:#777777;'><a href='<?=$list[$i][href]?>'><b><?=$list[$i][subject]?></span>
</td></tr>

    <tr>
<td valign=top><?=$cross_color1?>&nbsp;</td>
<td><b>제작/유통:</b>&nbsp;<span style='font:normal 11px tahoma; color:#777777;'><?=$list[$i][wr_3]?></span>
</td></tr>

<tr>
<td valign=top><?=$cross_color1?>&nbsp;</td>
<td><B>서비스 형태</b>&nbsp;<span style='font:normal 11px tahoma; color:#777777;'><?=$list[$i][wr_1]?></span></td>
</tr>


<tr>
<td valign=top><?=$cross_color1?>&nbsp;</td>
<td><b>게임장르</b>&nbsp;<span style='font:normal 11px tahoma; color:#777777;'><?=$list[$i][wr_2]?></span></td>
</tr>




<tr>
<td valign=top><?=$cross_color1?>&nbsp;</td>
<td><?
  $row5_sql = " SELECT wr_10 FROM g4_write_movie where wr_is_comment = '1' and wr_parent = '{$list[$i][wr_id]}' order by wr_10 ";
  $row5_result = mysql_query($row5_sql);

  $row6_sql = " SELECT wr_10 FROM g4_write_movie where wr_is_comment = '1' and wr_parent = '{$list[$i][wr_id]}' order by wr_10 ";
  $row6_result = mysql_query($row6_sql);
  $row6 = mysql_num_rows($row6_result);
 


for ($r=0; $row5 = mysql_fetch_array($row5_result); $r++) {
$p5 += $row5[wr_10];
}

if ($row6 > 0) {

  $total_sum5 = round($p5/$row6, 2);
  $sum5 = round($p5/$row6, 1);

}

?>

<table cellpadding='0' cellspacing='0' border='0'>
<tr><td><B>게임평점</b>&nbsp;

<span class='star_style123'><?
if ($sum5 <= 1.0) {
echo "<span class='star_style123'>☆&nbsp;</span>";
}elseif ($sum5 <= 2.0) {
    echo "<span class='star_style123'>★&nbsp;</span>";
}elseif ($sum5 <= 3.0) {
    echo "<span class='star_style123'>★☆&nbsp;</span>";
}elseif ($sum5 <= 4.0) {
    echo "<span class='star_style123'>★★&nbsp;</span>";
}elseif ($sum5 <= 5.0) {
    echo "<span class='star_style123'>★★☆&nbsp;</span>";
}elseif ($sum5 <= 6.0) {
    echo "<span class='star_style123'>★★★&nbsp;</span>";
}elseif ($sum5 <= 7.0) {
    echo "<span class='star_style123'>★★★☆&nbsp;</span>";
}elseif ($sum5 <= 8.0) {
    echo "<span class='star_style123'>★★★★&nbsp;</span>";
}elseif ($sum5 <= 9.0) {
    echo "<span class='star_style123'>★★★★☆&nbsp;</span>";
}elseif ($sum5 <= 10.0) {
    echo "<span class='star_style123'>★★★★★&nbsp;</span>";
}
?></span>&nbsp;&nbsp;<?=$total_sum5?>&nbsp;&nbsp;참여인원 : <?=$row6?> 명
</td></tr>
</table>
<? unset($p5);?>
</td>
</tr>
<tr>
<td valign=top><?=$cross_color1?>&nbsp;</td>
<td valign=top><b>권장사양</b>&nbsp;<span style='font:normal 11px tahoma; color:#777777;'><?=cut_str(strip_tags($list[$i][wr_content]),200,"...")?></span></td>
</tr>


</table>

</td>

</tr>
<Tr><td height=5></td></tr>
<?}?>

<!-- 게시물이 없을때 -->
<? if (count($list) == 0) { echo "<tr><td colspan='$colspan' height=100 align=center>게시물이 없습니다.</td></tr><tr><td colspan=$colspan bgcolor='#DDDDDD' height='1'></td></tr>"; } ?>

</table>
</form>

<!-- 여백 열기  -->
<TABLE width="100%" cellpadding="0" cellspacing="0" border="0">
  <tr><td height="2" bgcolor="#dddddd"></td></tr>
</table>
<!-- 여백 닫기  -->

<!-- 페이지 -->
<table width="100%" cellspacing="0" cellpadding="0">
<tr>
    <td width="100%" align="center" height=30 valign=bottom>
        <? if ($prev_part_href) { echo "<a href='$prev_part_href'><img src='$board_skin_path/img/btn_search_prev.gif' border=0 align=absmiddle title='이전검색'></a>"; } ?>
        <?
        // 기본으로 넘어오는 페이지를 아래와 같이 변환하여 이미지로도 출력할 수 있습니다.
        //echo $write_pages;
        $write_pages = str_replace("처음", "<img src='$board_skin_path/img/begin.gif' border='0' align='absmiddle' title='처음'>", $write_pages);
        $write_pages = str_replace("이전", "<img src='$board_skin_path/img/prev.gif' border='0' align='absmiddle' title='이전'>", $write_pages);
        $write_pages = str_replace("다음", "<img src='$board_skin_path/img/next.gif' border='0' align='absmiddle' title='다음'>", $write_pages);
        $write_pages = str_replace("맨끝", "<img src='$board_skin_path/img/end.gif' border='0' align='absmiddle' title='맨끝'>", $write_pages);
        $write_pages = preg_replace("/<span>([0-9]*)<\/span>/", "<b><font style=\"font-family:tahoma; font-size:11px; color:#000000\">$1</font></b>", $write_pages);
        $write_pages = preg_replace("/<b>([0-9]*)<\/b>/", "<b><font style=\"font-family:tahoma; font-size:11px; color:#E15916;\">$1</font></b>", $write_pages);
        ?>
        <?=$write_pages?>
        <? if ($next_part_href) { echo "<a href='$next_part_href'><img src='$board_skin_path/img/btn_search_next.gif' border=0 align=absmiddle title='다음검색'></a>"; } ?>
    </td>
</tr>
</table>

<!-- 링크 버튼, 검색 -->
<form name=fsearch method=get style="margin:0px;">
<input type=hidden name=bo_table value="<?=$bo_table?>">
<input type=hidden name=sca      value="<?=$sca?>">
<table width=100% cellpadding=0 cellspacing=0>
<tr>
    <td align=right height="40">
        <? if ($list_href) { ?><a href="<?=$list_href?>"><img src="<?=$board_skin_path?>/img/btn_list.gif" border="0"></a><? } ?>
        <? if ($write_href) { ?><a href="<?=$write_href?>"><img src="<?=$board_skin_path?>/img/btn_write.gif" border="0"></a><? } ?>
        <? if ($is_checkbox) { ?>
            <a href="javascript:select_delete();"><img src="<?=$board_skin_path?>/img/btn_select_delete.gif" border="0"></a>
            <a href="javascript:select_copy('copy');"><img src="<?=$board_skin_path?>/img/btn_select_copy.gif" border="0"></a>
            <a href="javascript:select_copy('move');"><img src="<?=$board_skin_path?>/img/btn_select_move.gif" border="0"></a>
        <? } ?>
    </td> 
</tr>
</table>
</form>

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

<script language="JavaScript">
if ('<?=$sca?>') document.fcategory.sca.value = '<?=$sca?>';
if ('<?=$stx?>') {
    document.fsearch.sfl.value = '<?=$sfl?>';
    document.fsearch.sop.value = '<?=$sop?>';
}
</script>

<? if ($is_checkbox) { ?>
<script language="JavaScript">
function all_checked(sw) {
    var f = document.fboardlist;

    for (var i=0; i<f.length; i++) {
        if (f.elements[i].name == "chk_wr_id[]")
            f.elements[i].checked = sw;
    }
}

function check_confirm(str) {
    var f = document.fboardlist;
    var chk_count = 0;

    for (var i=0; i<f.length; i++) {
        if (f.elements[i].name == "chk_wr_id[]" && f.elements[i].checked)
            chk_count++;
    }

    if (!chk_count) {
        alert(str + "할 게시물을 하나 이상 선택하세요.");
        return false;
    }
    return true;
}

// 선택한 게시물 삭제
function select_delete() {
    var f = document.fboardlist;

    str = "삭제";
    if (!check_confirm(str))
        return;

    if (!confirm("선택한 게시물을 정말 "+str+" 하시겠습니까?\n\n한번 "+str+"한 자료는 복구할 수 없습니다"))
        return;

    f.action = "./delete_all.php";
    f.submit();
}

// 선택한 게시물 복사 및 이동
function select_copy(sw) {
    var f = document.fboardlist;

    if (sw == "copy")
        str = "복사";
    else
        str = "이동";
                     
    if (!check_confirm(str))
        return;

    var sub_win = window.open("", "move", "left=50, top=50, width=500, height=550, scrollbars=1");

    f.sw.value = sw;
    f.target = "move";
    f.action = "./move.php";
    f.submit();
}
</script>
<? } ?>
<!-- 게시판 목록 끝 -->

댓글 전체

$row5_sql = " SELECT wr_10 FROM g4_write_movie where wr_is_comment = '1' and wr_parent = '{$list[$i][wr_id]}' order by wr_10 ";
  $row5_result = mysql_query($row5_sql);

이거 다음에

echo mysql_error();

를 적어 보세요. query문에 무슨 에러가 있는지 보세요.
Table 'torrent.g4_write_movie' doesn't exist
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/hosting_users/torrent/www/skin/board/game/list.skin.php on line 164

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/hosting_users/torrent/www/skin/board/game/list.skin.php on line 168

라고 나옵니다^^;;
전체 66,554 |RSS
그누4 질문답변 내용 검색

회원로그인

(주)에스아이알소프트 / 대표:홍석명 / (06211) 서울특별시 강남구 역삼동 707-34 한신인터밸리24 서관 1402호 / E-Mail: admin@sir.kr
사업자등록번호: 217-81-36347 / 통신판매업신고번호:2014-서울강남-02098호 / 개인정보보호책임자:김민섭(minsup@sir.kr)
© SIRSOFT