목록으로

각그누보드로 통합게시판을... 채택완료

김성민황 9년 전 조회 2,924

답변 1

아는 분이 각 폴더마다 그누보드 설치해서 게시판글 끌어오게 만드는 통합게시판을 만들어줬는데요..

http://boardview.iposkorea.com/" style="color: rgb(0, 0, 0);">http://boardview.iposkorea.com/

이 주소인데 에러가 나요... 그 분이 퇴사하셔서 ㅠㅠ 제가 봐야하는데...

도와주세요...ㅠㅠㅠㅠ

index.php소스입니당...

<?$search_category = $_GET['search_category'];$search_text = $_GET['search_text'];?><? include './function.php';?><? include './dbcon.php';?><!DOCTYPE html><html><head><title></title><style >body{margin:0px auto;} .div_head{width:100%;height:68px;margin-bottom:18px;box-shadow:1px 1px 1px 1px #eaeaea;margin-top:4px;}.div_head a{color:#3b3b3b;text-decoration:none;}.img_logo{width:35px;} .h2_title{font-family:'나눔고딕';font-weight:normal;margin-top:18px;font-weight:bold;}.new{color:#ff8787;font-weight:bold;font-size:12px;} .table_integrated {border-collapse: collapse;width:98%;}.table_integrated tr:hover{background-color:#f7fdfe;}.table_integrated td {border:1px solid #bdbdbd;color:#585858;font-size:15px;font-family:'나눔고딕';border-left:0px;border-right:0px;}.table_integrated a{text-decoration:none;color:#585858;}.table_integrated a:hover{text-decoration:underline;}.tr_first {text-align:center;background-color: #fbfbfb;font-weight:bold;}.tr_first:hover{background-color:#fbfbfb !important;}.td_idx{padding-left:12px;width:40px;}.a_go_detail{text-decoration:none;color:#585858;} .a_pager {text-decoration:none;font-size:24px;color:#8c8c8c;display:inline-block;width:30px;} .table_search select,input{font-family:'나눔고딕'}.table_search select{height:25px;}.table_search input{height:19px;}.table_search input[type=submit],input[type=button] {height:25px;cursor:pointer;}</style></head><body><?$startRow = 0;if($_GET['startRow']) $startRow = $_GET['startRow'];$listInOne = 15;$endRow = $listInOne; $numRows = get_num_rows();$qry_for_select_board = get_qry();$res_for_select_board = mysql_query($qry_for_select_board." order by wr_datetime desc limit $startRow, $endRow"); echo "<center>";echo "<div class='div_head'><table style='margin-top:-10px;' cellpadding='5'> <tr> <td><img class='img_logo' src='./img/logo_mini.gif'></td> <td ><h2 class='h2_title'><a href='<a href="<a href="http://boardview.iposkorea.com" target="_blank" rel="noopener noreferrer">http://boardview.iposkorea.com</a>"><a href="http://boardview.iposkorea.com" target="_blank" rel="noopener noreferrer">http://boardview.iposkorea.com</a></a>'>아이포스 게시판 통합 관리 (그누보드)</a></h2></td> </tr></table></div>"; echo "<table cellpadding='12' border=0 class='table_integrated'>";echo "<tr class='tr_first'><td>번호</td><td>제목</td><td>작성자</td><td>업체</td><td>날짜</td><td>조회수</td></tr>"; $idx = $startRow;while($arr_for_select_board = mysql_fetch_array($res_for_select_board)){ //테이블 $strPos = strpos($arr_for_select_board[table_name],'write_')+6; $table = substr($arr_for_select_board[table_name],$strPos); //client_id는 테이블에 사용하는 g5_<client_id>write_board $client_id= str_replace('g5_','',$arr_for_select_board[table_name]); $client_id = str_replace('write_board','',$client_id); $client_id = str_replace('write_board2','',$client_id); $client_id = str_replace('write_qna','',$client_id); //Get URL $qry_for_url = "SELECT * FROM client_list where id='$client_id'"; $res_for_url = mysql_query($qry_for_url); $arr_for_url = mysql_fetch_array($res_for_url); //번호카운팅 $idx++; //새글(new) $new = ""; $today = date('Y-m-d h:i:s'); $wr_date = $arr_for_select_board[wr_datetime]; $gap = _date_diff(strtotime($today),strtotime($wr_date)); if($gap['days'] < 2) $new = "N"; $wr_subect = $arr_for_select_board[wr_subject]; $stx =""; if($search_category == 'subject'){ $wr_subect = str_replace( $search_text, "$search_text", $wr_subect); //$search_text = urlencode($search_text); //$stx = "&sfl=wr_subject&stx=$search_text&sop=and"; } else if($search_category == 'content'){ $stx = "&sfl=wr_content&stx=$search_text&sop=and"; } echo "<tr>"; echo "<td align='left' class='td_idx'>$idx</td> <td> <a class='a_go_detail' target='_blank' href='{$arr_for_url[url]}/bbs/board.php?bo_table=board&wr_id={$arr_for_select_board[wr_id]}'> $wr_subect </a> $new </td> <td align='center'>{$arr_for_select_board[wr_name]}</td> <td align='center'><a target='_blank' href='{$arr_for_url[url]}'>$client_id</a></td> <td align='center'>{$arr_for_select_board[wr_datetime]}</td> <td align='center'>{$arr_for_select_board[wr_hit]}</td>"; echo "</tr>"; $qry_for_get_reply = "SELECT * FROM $arr_for_select_board[table_name] WHERE wr_num='$arr_for_select_board[wr_num]' AND wr_reply in ('A') order by wr_datetime"; $res_for_get_reply = mysql_query($qry_for_get_reply); $rows_for_get_reply = mysql_num_rows($res_for_get_reply); //echo $qry_for_get_reply."; "; $idx_reply = 0; if($rows_for_get_reply > 0) { while($arr_for_get_reply = mysql_fetch_array($res_for_get_reply)) { $wr_date = $arr_for_get_reply[wr_datetime]; $gap = _date_diff(strtotime($today),strtotime($wr_date)); if($gap['days'] < 2) $new = "N"; $idx_reply++; echo "<tr>"; echo "<td align='left' class='td_idx'>{$idx}_{$idx_reply}</td> <td> <img src='./img/icon_reply.gif'> <a class='a_go_detail' target='_blank' href='$arr_for_url[url]/bbs/board.php?bo_table=board&wr_id=$arr_for_get_reply[wr_id]'>$arr_for_get_reply[wr_subject] </a>$new </td> <td align='center'>$arr_for_get_reply[wr_name]</td> <td align='center'><a target='_blank' href='{$arr_for_url[url]}'>$client_id</a></td> <td align='center'>$arr_for_get_reply[wr_datetime]</td> <td align='center'>$arr_for_get_reply[wr_hit]</td>"; echo "</tr>"; } }}echo "</table>";echo "</center>";?> <?php//페이징echo " ";echo "<center>";//전체자료개수(1page당 10개 rows, 1chpater는 4)//$numRows = $numRows;//전체 리스트 갯수 가져오기(select all)$chapterSize = 20;//▶ 이거로 넘어갈때 몇개씩 이냐( < 1,2,3,4,5,6,7,8,9,10 > )$beginPage = floor($startRow/($chapterSize*$listInOne));//(0/50),(10/50),(20/50),(30/50),(40/50) -> 0$beginPage *= $chapterSize;$endPage = ceil($numRows/$listInOne);if(($endPage-$beginPage) > $chapterSize) $endPage = $beginPage+$chapterSize;$nowPage = $startRow/$listInOne;//이전 페이지가 있으면 (맨처음 <를 가지는 $beginPage의 값은 10(10~19까지의 tutor list)이기 때문에 맨처음 <를 가지는 값 이상(10포함)이면 <(전페이지)를 갖는다if($beginPage >= $chapterSize){?><a class='a_pager' href="<a href="<a href="http://boardview.iposkorea.com/index.php?startRow=<?=($beginPage-$chapterSize)*$listInOne?>" target="_blank" rel="noopener noreferrer">http://boardview.iposkorea.com/index.php?startRow=<?=($beginPage-$chapterSize)*$listInOne?></a>"><a href="http://boardview.iposkorea.com/index.php?startRow=<?=($beginPage-$chapterSize)*$listInOne?>" target="_blank" rel="noopener noreferrer">http://boardview.iposkorea.com/index.php?startRow=<?=($beginPage-$chapterSize)*$listInOne?></a></a>"><</a><?php }//출력 (숫자)for($i=$beginPage;$i<$endPage;$i++){ if($i == $nowPage){ ?><a class='a_pager' href="<a href="<a href="http://boardview.iposkorea.com/index.php?startRow=<?=($i*$listInOne)?>&search_category=<?php" target="_blank" rel="noopener noreferrer">http://boardview.iposkorea.com/index.php?startRow=<?=($i*$listInOne)?>&search_category=<?php</a>"><a href="http://boardview.iposkorea.com/index.php?startRow=<?=($i*$listInOne)?>&search_category=<?php" target="_blank" rel="noopener noreferrer">http://boardview.iposkorea.com/index.php?startRow=<?=($i*$listInOne)?>&search_category=<?php</a></a> echo $search_category;?>&search_text=<?php echo $search_text;?>" style="color:#FF6C6C;font-weight:bold;"><?=$i+1?></a> <?php } else { ?><a class='a_pager' href="<a href="<a href="http://boardview.iposkorea.com/index.php?startRow=<?=($i*$listInOne)?>&search_category=<?php" target="_blank" rel="noopener noreferrer">http://boardview.iposkorea.com/index.php?startRow=<?=($i*$listInOne)?>&search_category=<?php</a>"><a href="http://boardview.iposkorea.com/index.php?startRow=<?=($i*$listInOne)?>&search_category=<?php" target="_blank" rel="noopener noreferrer">http://boardview.iposkorea.com/index.php?startRow=<?=($i*$listInOne)?>&search_category=<?php</a></a> echo $search_category;?>&search_text=<?php echo $search_text;?>"><?=$i+1?></a> <?php }}//다음 행이 있는지 확인하고 있으면 다음 챕터로 이동할 수 있게$nextStartRow = $i*$listInOne;if($nextStartRow < $numRows){?><a class='a_pager' href="<a href="<a href="http://boardview.iposkorea.com/index.php?startRow=<?=($nextStartRow)?>" target="_blank" rel="noopener noreferrer">http://boardview.iposkorea.com/index.php?startRow=<?=($nextStartRow)?></a>"><a href="http://boardview.iposkorea.com/index.php?startRow=<?=($nextStartRow)?>" target="_blank" rel="noopener noreferrer">http://boardview.iposkorea.com/index.php?startRow=<?=($nextStartRow)?></a></a>">></a><?php }echo "</center>";echo " ";?> <center><script type="text/javascript">function ckFrm(frm){ var search_text = frm.search_text.value; if(search_text.length < 1){ alert("검색어를 입력하세요!"); frm.search_text.focus(); return false; } return true;}function go_new(){ location.href='<a href="<a href="http://boardview.iposkorea.com/index.php?startRow=0&latest=y" target="_blank" rel="noopener noreferrer">http://boardview.iposkorea.com/index.php?startRow=0&latest=y</a>"><a href="http://boardview.iposkorea.com/index.php?startRow=0&latest=y" target="_blank" rel="noopener noreferrer">http://boardview.iposkorea.com/index.php?startRow=0&latest=y</a></a>';}</script><form class="" action="./index.php" method="get" onsubmit="return ckFrm(this)"><table class='table_search'><tr> <td> <select class="select_search" name="search_category"> <option value='subject'>제목</option> <option value='content'>내용</option> </select> </td> <td> <input type="text" size='30' name="search_text" placeholder="검색어를 입력하세요."> </td> <td> <input type='submit' value='검색'> </td></tr></table></form></center></body> </html><div>

index.php소스입니당...

[code]

// 날짜 차이 구하기

function dateDiff($sStartDate, $sEndDate) {

$sStartTime = strtotime($sStartDate);

$sEndTime = strtotime($sEndDate);

if($sStartTime > $sEndTime)

return false;

$sDiffTime = $sEndTime - $sStartTime;

$aReturnValue['d'] = floor($sDiffTime/60/60/24);

$aReturnValue['H'] = sprintf("%02d", ($sDiffTime/60/60)%24);

$aReturnValue['i'] = sprintf("%02d", ($sDiffTime/60)%60);

$aReturnValue['s'] = sprintf("%02d", ($sDiffTime%60));

return $aReturnValue;

}

function _date_range_limit($start, $end, $adj, $a, $b, $result)

{

if ($result[$a] < $start) {

$result[$b] -= intval(($start - $result[$a] - 1) / $adj) + 1;

$result[$a] += $adj * intval(($start - $result[$a] - 1) / $adj + 1);

}

if ($result[$a] >= $end) {

$result[$b] += intval($result[$a] / $adj);

$result[$a] -= $adj * intval($result[$a] / $adj);

}

return $result;

}

function _date_range_limit_days($base, $result)

{

$days_in_month_leap = array(31, 31, 29, 31, 30, 31, 30, 31, 31, 30, 31, 30, 31);

$days_in_month = array(31, 31, 28, 31, 30, 31, 30, 31, 31, 30, 31, 30, 31);

_date_range_limit(1, 13, 12, "m", "y", &$base);

$year = $base["y"];

$month = $base["m"];

if (!$result["invert"]) {

while ($result["d"] < 0

#그누보드 #게시판

댓글을 작성하려면 로그인이 필요합니다.

답변 1개

정렬:

채택된 답변
+20 포인트

빨간망토의비밀

9년 전

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/hosting_users/hsquarec/www/board_manage/function.php on line 129

접속하면 위와 같이 오류가 나오네요.

이부분 부터 확인하세요.

로그인 후 평가할 수 있습니다

답변에 대한 댓글 1개

�

김성민황

9년 전

소스 어디가 잘못된건지 모르겠어요..ㅠㅠ

소스 어디가 잘못된건지 모르겠어요..ㅠㅠ

댓글을 작성하려면 로그인이 필요합니다.

답변을 작성하려면 로그인이 필요합니다.
로그인

지금 질문하기

질문하는방법

모든질문 129,285

답변없는질문 8

미채택된질문 18,376

채택된질문 101,681

모든답변

5 그누보드5 62,905

영카트5 17,535

태그전체보기

관심태그

#영카트5 #그누보드4 #영카트4 #정규식 #테마 #그누보드5 #네이버페이 #그누커머스 #php #그누보드6

인기태그

#그누보드5 (62,905) #영카트5 (17,535) #php (15,830) #그누보드4 (10,649) #게시판 (3,273) #javascript (2,678) #그누보드 (2,463) #css (2,129) #mysql (1,556) #영카트 (1,295) #모바일 (1,293) #그누커머스 (1,178) #html (1,133) #jquery (1,027) #최신글 (970) #자바스크립트 (953) #DB (850) #로그인 (821) #이미지 (785) #여분필드 (784)

공유하기

이 게시물을 신고 하시겠습니까?
신고사유를 선택해주세요.

광고성 게시물

음란성 게시물

상대방 비방 및 혐오

기타
기타 신고사유