다운로드수가 많은게시물 보여주기 정보
다운로드수가 많은게시물 보여주기본문
인기게시물있잖아요
그건 wr_hit 가지고 하잖아요..
이거말고..
다운로드수가 많은 게시물순위를 보여주고 싶거던요..
히트순은 wr_hit 하면되는데..
변수를 어떻게 해야하지요 ?
$sql = " select * from $tmp_write_table where wr_is_comment = 0 order by wr_hit desc limit 0, $rows ";
위에서
wr_hit 대신에 넣으면 될거 같은데요. 어떻게 해야하나요 .?
수고하세요..
댓글 전체
$sql = " select
w.*, sum(f.bf_download) as down_hit
from
$tmp_write_table as w
,$g4[board_file_table] as f
where
w.wr_is_comment = 0
and f.bo_table = 'free'
and f.wr_id = w.wr_id
group by
f.wr_id
order by
down_hit desc
limit
0, $rows
";
하시면 될 것 같습니다.
w.*, sum(f.bf_download) as down_hit
from
$tmp_write_table as w
,$g4[board_file_table] as f
where
w.wr_is_comment = 0
and f.bo_table = 'free'
and f.wr_id = w.wr_id
group by
f.wr_id
order by
down_hit desc
limit
0, $rows
";
하시면 될 것 같습니다.
<?
if (!defined('_GNUBOARD_')) exit;
function cmp($a, $b)
{
return $b['wr_hit'] - $a['wr_hit'];
}
// 최신글 추출
function glatest($skin_dir="", $bo_table, $rows=10, $subject_len=40, $options="")
{
global $g4;
if ($skin_dir)
$latest_skin_path = "$g4[path]/skin/latest/$skin_dir";
else
$latest_skin_path = "$g4[path]/skin/latest/basic";
$list = array();
$sql= "select bo_table from {$g4['board_table']} where bo_table = '$bo_table'";
$ress = sql_query($sql);
for( $i=0, $ii=0; $board = sql_fetch_array($ress); $ii++) {
$tmp_write_table = $g4['write_prefix'] . $board['bo_table']; // 게시판 테이블 전체이름
$sql = " select
w.*, sum(f.bf_download) as down_hit
from
$tmp_write_table as w
,$g4[board_file_table] as f
where
w.wr_is_comment = 0
and f.bo_table = 'free'
and f.wr_id = w.wr_id
group by
f.wr_id
order by
down_hit desc
limit
0, $rows
";
//explain($sql);
$result = sql_query($sql);
for (; $row = sql_fetch_array($result); $i++)
$list[$i] = get_list($row, $board, $latest_skin_path, $subject_len);
}
usort( $list, 'cmp'); $list= array_slice( $list, 0, $rows);
ob_start();
include "$latest_skin_path/latest.skin.php";
$content = ob_get_contents();
ob_end_clean();
return $content;
}
?>
넣었는데요. 게시물이 없다고 나오는데요,
상단에 이부분도 바까야할거 같은데요..
return $b['wr_hit'] - $a['wr_hit'];
수고하세요.. ㅠㅠ
if (!defined('_GNUBOARD_')) exit;
function cmp($a, $b)
{
return $b['wr_hit'] - $a['wr_hit'];
}
// 최신글 추출
function glatest($skin_dir="", $bo_table, $rows=10, $subject_len=40, $options="")
{
global $g4;
if ($skin_dir)
$latest_skin_path = "$g4[path]/skin/latest/$skin_dir";
else
$latest_skin_path = "$g4[path]/skin/latest/basic";
$list = array();
$sql= "select bo_table from {$g4['board_table']} where bo_table = '$bo_table'";
$ress = sql_query($sql);
for( $i=0, $ii=0; $board = sql_fetch_array($ress); $ii++) {
$tmp_write_table = $g4['write_prefix'] . $board['bo_table']; // 게시판 테이블 전체이름
$sql = " select
w.*, sum(f.bf_download) as down_hit
from
$tmp_write_table as w
,$g4[board_file_table] as f
where
w.wr_is_comment = 0
and f.bo_table = 'free'
and f.wr_id = w.wr_id
group by
f.wr_id
order by
down_hit desc
limit
0, $rows
";
//explain($sql);
$result = sql_query($sql);
for (; $row = sql_fetch_array($result); $i++)
$list[$i] = get_list($row, $board, $latest_skin_path, $subject_len);
}
usort( $list, 'cmp'); $list= array_slice( $list, 0, $rows);
ob_start();
include "$latest_skin_path/latest.skin.php";
$content = ob_get_contents();
ob_end_clean();
return $content;
}
?>
넣었는데요. 게시물이 없다고 나오는데요,
상단에 이부분도 바까야할거 같은데요..
return $b['wr_hit'] - $a['wr_hit'];
수고하세요.. ㅠㅠ
