컨텐츠관리 가 업데이트후 작동되지않습니다.
해적K
9년 전
조회 1,894
간만에 그누보드G5 영카드 버전을 업데이트 하였는데 업데이트전까지 잘 작동하던 조회수및 컨텐츠관리 가 작동하지 않습니다 업데이트로 인하여 소스를 수정해야되는부분이 있는걸까요 ?
</p><p><?php</p><p>$sub_menu = "300110";</p><p>include_once('./_common.php');</p><p> </p><p>include_once("./admin.head.php");</p><p>?></p><p><script></p><p> </p><p>function startafterminute(){</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>interval = document.frm.interval.value;</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>timer = setInterval ("myfn()", 1000 * 60 * interval);</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>myfn();</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>}</p><p> </p><p>function myfn(myform){</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>if(myform.bo_tbl.value == ""){alert('* 게시판을 선택해 주세요! *');myform.bo_tbl.focus();return false;}</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>if(myform.myinc.value == "0"){alert('* 증가값을 0이상으로 해주세요! *');myform.myinc.focus();return false;}</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>return true;</p><p>}</p><p> </p><p> </p><p> </p><p></script></p><p><style></p><p>.hd{border-top:1px #6b95bd solid;border-bottom:1px #6b95bd solid;font-size:11px}</p><p></style></p><p><?php</p><p>if(empty($mode))$mode = "new";</p><p> </p><p>if($mode == "new"){</p><p>?></p><p> </p><p><form name="myfrm" method="post" action="<?php echo $PHP_SELF?>" onsubmit="return myfn(this);"></p><p><input type="hidden" name="mode" value="insert"></p><p><input type="hidden" name="type" value="inc"></p><p><fieldset></p><p> <legend>게시물 조회수 관리</legend></p><p> </p><p><span class="Apple-tab-span" style="white-space:pre"> </span> - 게시물 조회수 증가 : <select name="bo_tbl"></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><option value="" selected>게시판 선택!!</option></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><option value="all">전체게시판</option></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><?php</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$sql = "select * from g5_board order by bo_order";</p><p> </p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$result = sql_query($sql); </p><p><span class="Apple-tab-span" style="white-space:pre"> </span>while($row=sql_fetch_array($result)){ </p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$sql2 = "select * from g5_group where gr_id = '$row[gr_id]'";</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$result2 = sql_query($sql2);</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$row2=sql_fetch_array($result2);</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>echo "<option value='".$row[bo_subject]." - ".$row[bo_table]."'>".$row2[gr_subject]."-".$row[bo_subject]."</option>";</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>}</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>?></p><p><span class="Apple-tab-span" style="white-space:pre"> </span></select></p><p><span class="Apple-tab-span" style="white-space:pre"> </span>증가값: <input type="test" name = "myinc" size="5" value="231"> </p><p><span class="Apple-tab-span" style="white-space:pre"> </span>갯수(최근글 순): <input type="test" name = "mycnt" size="5" value="100"> </p><p><span class="Apple-tab-span" style="white-space:pre"> </span><input type="submit" value="=처리=" onClick="document.frm.auto.value='Y';startafterminute(600);"></p><p></fieldset></p><p></form></p><p> </p><p><?php } else if($mode == "insert"){</p><p> </p><p> </p><p><span class="Apple-tab-span" style="white-space:pre"> </span>if($bo_tbl == "all"){ //게시판 전체</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$sql = "select * from g5_board order by bo_table";</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$result = mysql_query($sql); </p><p><span class="Apple-tab-span" style="white-space:pre"> </span>for ($i=0; $row=mysql_fetch_array($result); $i++){ </p><p><span class="Apple-tab-span" style="white-space:pre"> </span> $arr[$i] = $row[bo_table];</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>}</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>for($i = 0 ; $i < sizeof($arr);$i++){</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$sql1 = "select * from g5_write_".$arr[$i]." where wr_is_comment=0 order by wr_id desc limit 0, ".$mycnt;</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$result1 = mysql_query($sql1);</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>for ($j=0; $row1=mysql_fetch_array($result1); $j++){</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$myinc2 = $row1[wr_hit] + rand(1, $myinc);</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$sql2 = "update g5_write_".$arr[$i]." set wr_hit =".$myinc2." where wr_is_comment=0 and wr_id = '$row1[wr_id]'";</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>sql_query($sql2); </p><p> </p><p><span class="Apple-tab-span" style="white-space:pre"> </span>}</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>}</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>}else{ //특정게시판</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$lnk = explode(" - ",$bo_tbl);</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$sql1 = "select * from g5_write_".$lnk[1]." where wr_is_comment=0 order by wr_id desc limit 0, ".$mycnt;</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>echo $sql11;</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$result1 = mysql_query($sql1);</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$tot = mysql_num_rows($result1);</p><p> </p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$nn = 0;</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>while($row1=mysql_fetch_array($result1)){</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$nn++;</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$myinc2 = $row1[wr_hit] + rand(1, $myinc);</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$sql2 = "update g5_write_".$lnk[1]." set wr_hit =".$myinc2." where wr_is_comment=0 and wr_id = '".$row1[wr_id]."'";</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>mysql_query($sql2);</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>}</p><p> </p><p><span class="Apple-tab-span" style="white-space:pre"> </span>} //inner-if</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>if($bo_tbl == "all")$bo_tbl="전체";</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$sql = "insert into g5_board_count(wr_type, bo_tbl, wr_value, wr_count,wr_date) value('증가','$bo_tbl','$myinc','$mycnt',now())";</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>mysql_query($sql);</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>echo "<script>location.href='$PHP_SELF';</script>";</p><p>} //outer-if</p><p> </p><p>$qry = "select count(*) as cnt from g5_board_count";</p><p>$row = sql_fetch($qry);</p><p>$total_count = $row[cnt];</p><p>$rows = $config[cf_page_rows];</p><p>$total_page = ceil($total_count / $rows); // 전체 페이지 계산</p><p>if ($page == "") { $page = 1; } // 페이지가 없으면 첫 페이지 (1 페이지)</p><p>$from_record = ($page - 1) * $rows; // 시작 열을 구함</p><p>?></p><p><table width=90% cellpadding=0 border=0 cellspacing=0 align="center" style="margin:20px 5px 5px 5px;border:0px solid #ccc"></p><p><tr bgcolor='#f8f8f9'></p><p> <th class="hd" align="center"width="5%" height="30" >번호</th></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><th class="hd" width="15%" >조회수처리</th></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><th class="hd" width="25%" >테이블</th></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><th class="hd" width="15%" >증가값</th></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><th class="hd" width="15%" >범위(최신글)</th></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><th class="hd" width="25%" >처리일자</th></p><p></tr></p><p><?php</p><p>$qry = "select * from g5_board_count order by wr_id desc limit $from_record, $rows";</p><p>$res= mysql_query($qry);</p><p>while($li = mysql_fetch_array($res)){</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>?></p><p> </p><p><span class="Apple-tab-span" style="white-space:pre"> </span><tr bgcolor='#f8f8f9'></p><p> <td align="center" height="30"><?php echo $li[wr_id]?></td></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><td align="center"><?php echo $li[wr_type]?></td></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><td align="center"></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><?php</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$lnk = explode(" - ",$li[bo_tbl]);</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>if($li[bo_tbl] == "전체") echo $li[bo_tbl];</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>else echo "<a href=".$g4['path']."/bbs/board.php?bo_table=".$lnk[1].">".$li[bo_tbl]."</a>";</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>?></p><p><span class="Apple-tab-span" style="white-space:pre"> </span></td></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><td align="center"><?php echo $li[wr_value]?></td></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><td align="center"><?php echo $li[wr_count]?></td></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><td align="center"><?php echo $li[wr_date]?></td></p><p></tr></p><p><?php</p><p>}</p><p>?></p><p> </p><p></table></p><p><?php</p><p>$pagelist = get_paging($config[cf_write_pages], $page, $total_page, "$_SERVER[PHP_SELF]?$qstr&page=");</p><p>echo "<table width=90% cellpadding=3 cellspacing=1>";</p><p>echo "<tr><td width=100% align=right>$pagelist</td></tr></table>\n";</p><p>?></p><p><?php</p><p>include_once("./admin.tail.php");</p><p>?></p><p> </p><p>
댓글을 작성하려면 로그인이 필요합니다.
답변 2개
9년 전
자문자답 입니다
php7 지원업데이트 이후 mysql 및 mysqli 함수 차이점에서 생기는 문제였습니다 .
편리님 말씀대로
MySQLi 지원 버전으로 패치를 한 경우 mysql_query 함수 등을 사용하면 mysqli 와 혼용으로
오류가 발생합니다. config.php 파일의 G5_MYSQLI_USE 설정을 false 로 변경해 보시기 바랍니다.
참고하시면 작동합니다.
로그인 후 평가할 수 있습니다
댓글을 작성하려면 로그인이 필요합니다.
답변을 작성하려면 로그인이 필요합니다.
로그인