izens 님의 인기게시물 스킨질문입니다~ 채택완료

</span></p><p><? </p><p>if (!defined('_GNUBOARD_')) exit; </p><p> </p><p>/* </p><p>izen.group.lib.php </p><p>제작일 : 2006-12-08 </p><p> </p><p>지정 기간제 히트순 최근 게시물 수정본 </p><p><a href="<a href="http://www.sir.co.kr/bbs/tb.php/g4_tiptech/7328" target="_blank" rel="noopener noreferrer">http://www.sir.co.kr/bbs/tb.php/g4_tiptech/7328</a>"><a href="http://www.sir.co.kr/bbs/tb.php/g4_tiptech/7328" target="_blank" rel="noopener noreferrer">http://www.sir.co.kr/bbs/tb.php/g4_tiptech/7328</a></a> </p><p> </p><p>그룹 최신글 관련하여 통합하도록 하였다. </p><p>정렬 필드값에 의해서 SQL 문을 추가하도록 하면 된다. </p><p> </p><p>izen_group('스킨', '그룹명', 정렬필드, 출력갯수, 자를 문자열, 최근 몇일간을 출력할 것인가?); </p><p>예) echo izen_group('best10', '06', wr_hit, 10, 28, 30); </p><p>*/ </p><p> </p><p># 인기글 </p><p>function izen_usort1($a, $b) </p><p>{ </p><p>return $b['wr_hit'] - $a['wr_hit']; </p><p>} </p><p> </p><p># 추천순 </p><p>function izen_usort2($a, $b) </p><p>{ </p><p>return $b['wr_good'] - $a['wr_good']; </p><p>} </p><p> </p><p> </p><p># 최신글 추출 </p><p>function izen_group($skin_dir="", $gr_id, $izen_sort, $rows=10, $subject_len=40, $listdate) </p><p>{ </p><p>global $g5; </p><p> </p><p>$nowYmd = date(Ymd); # 시작시간을 구합니다. </p><p>$time = time(); </p><p>$startYmd = date("Ymd",strtotime("-".$listdate." day", $time)); </p><p> </p><p>if ($skin_dir) </p><p>{ </p><p>$latest_skin_path = G5_SKIN_PATH.'/latest/'.$skin_dir;</p><p>} </p><p>else </p><p>{ </p><p>$latest_skin_path = G5_SKIN_PATH.'/latest/'.$skin_dir;</p><p>} </p><p> </p><p>$list = array(); </p><p> </p><p>$sql= " select bo_table from {$g5['board_table']} "; </p><p>$ress = sql_query($sql); </p><p>for($i=0, $ii=0; $board=sql_fetch_array($ress); $ii++) </p><p>{ </p><p>$tmp_write_table = $g5['write_prefix'] . $board['bo_table']; # 게시판 테이블 전체이름 </p><p>#$sql = "select * from `$tmp_write_table` where wr_is_comment <> '1' and  date_format(wr_datetime, '%Y%m%d') between '$startYmd' and '$nowYmd' order by $sort desc limit 0, $rows "; </p><p> </p><p># 정렬 필드에 의해서 전체적으로 정렬, 관리한다. </p><p>if ($izen_sort == 'wr_hit') </p><p>{ </p><p>$sql_gr_Q = " wr_is_comment <> '1' and date_format(wr_datetime, '%Y%m%d') between '$startYmd' and '$nowYmd' order by $izen_sort desc limit 0, $rows "; </p><p>} </p><p>elseif ($izen_sort == 'wr_scrap') </p><p>{ </p><p>$sql_gr_Q = " wr_is_comment <> '1' and date_format(wr_datetime, '%Y%m%d') between '$startYmd' and '$nowYmd' and wr_scrap <> 0 order by $izen_sort desc limit 0, $rows "; </p><p>} </p><p>elseif ($izen_sort == 'wr_datetime') # wr_1 헤드라인 </p><p>{ </p><p>//$sql_gr_Q = " wr_is_comment <> '1' and date_format(wr_datetime, '%Y%m%d') between '$startYmd' and '$nowYmd' and wr_1 = 1 order by $izen_sort desc limit 0, $rows "; 2016-11-30 주석처리</p><p>$sql_gr_Q = " wr_is_comment <> '1' and date_format(wr_datetime, '%Y%m%d') between '$startYmd' and '$nowYmd' order by $izen_sort desc limit 0, $rows "; </p><p>} </p><p>elseif ($izen_sort == 'wr_good')</p><p>{ </p><p>$sql_gr_Q = " wr_is_comment <> '1' and date_format(wr_datetime, '%Y%m%d') between '$startYmd' and '$nowYmd' and wr_good <> '0'  order by $izen_sort desc limit 0, $rows "; </p><p>} </p><p>elseif ($izen_sort == 'wr_id') </p><p>{ </p><p>$sql_gr_Q = " wr_is_comment <> '1' order by $izen_sort desc limit 0, $rows "; </p><p>} </p><p> </p><p>$sql = " select * from `$tmp_write_table` where $sql_gr_Q "; </p><p>$result = sql_query($sql); </p><p> </p><p>#for (; $row=sql_fetch_array($result); $i++) # *오류* 전체 게시물 가운데 날짜에 상관없이 히트순으로 지정한 갯수만큼 출력된다. </p><p>for ($i==0; $row=sql_fetch_array($result); $i++) </p><p>{ </p><p>$list[$i] = get_list($row, $board, $latest_skin_path, $subject_len, $listdate); </p><p>} </p><p>} </p><p> </p><p>if ($izen_sort == 'wr_hit') </p><p>{ </p><p>usort($list, 'izen_usort1'); </p><p>} </p><p> </p><p>elseif ($izen_sort == 'wr_good') </p><p>{ </p><p>usort($list, 'izen_usort2'); </p><p>} </p><p> </p><p>$list= array_slice($list, 0, $rows); </p><p> </p><p>ob_start(); </p><p>include "$latest_skin_path/latest.skin.php"; </p><p>$content = ob_get_contents(); </p><p>ob_end_clean(); </p><p> </p><p> </p><p>return $content; } ?></p><p><span style="font-size: 11pt;">

</p><p><? echo izen_group('best10', '', wr_datetime, 10, 34, 7); ?>  </p><p>