별점 주는 소스인데 순위별이 될가용? 정보
별점 주는 소스인데 순위별이 될가용?
본문
아래 별점 주는 소스라고하더라구요 이것을 높은값을 위로 해서 순위별로 나열되게 할려고하는데 가능할가용?
<?
$cmtpoint ='0';
$totalcount = '0';
$userrating = '0';
$tbl = "{$g4[write_prefix]}{$bo_table}";
$sql2 = " select wr_3 from $tbl where wr_is_comment > 0 && wr_parent = '{$list[$i][wr_id]}' && wr_3 > '0' ";
$result2 = sql_query($sql2);
while($row2 = mysql_fetch_array($result2) ) {
$point=$row2[0];
$cmtpoint=$cmtpoint + $point;
$totalcount++;
}
if ($totalcount!=0) {
$cmtpoint= $cmtpoint/$totalcount;
$cmtpoint= number_format($cmtpoint,2);
}
echo "<a href='{$list[$i][href]}'>";
?>
<font color="gray">
<? if ($cmtpoint > "9"){?>
<img src="<?=$board_skin_path?>/img/st1.gif"><img src="<?=$board_skin_path?>/img/st1.gif"><img src="<?=$board_skin_path?>/img/st1.gif"><img src="<?=$board_skin_path?>/img/st1.gif"><img src="<?=$board_skin_path?>/img/st1.gif">
<? } else if ($cmtpoint > "8"){?>
<img src="<?=$board_skin_path?>/img/st1.gif"><img src="<?=$board_skin_path?>/img/st1.gif"><img src="<?=$board_skin_path?>/img/st1.gif"><img src="<?=$board_skin_path?>/img/st1.gif"><img src="<?=$board_skin_path?>/img/st2.gif">
<? } else if ($cmtpoint > "7"){?>
<img src="<?=$board_skin_path?>/img/st1.gif"><img src="<?=$board_skin_path?>/img/st1.gif"><img src="<?=$board_skin_path?>/img/st1.gif"><img src="<?=$board_skin_path?>/img/st1.gif"><img src="<?=$board_skin_path?>/img/st3.gif">
<? } else if ($cmtpoint > "6"){?>
<img src="<?=$board_skin_path?>/img/st1.gif"><img src="<?=$board_skin_path?>/img/st1.gif"><img src="<?=$board_skin_path?>/img/st1.gif"><img src="<?=$board_skin_path?>/img/st2.gif"><img src="<?=$board_skin_path?>/img/st3.gif">
<? } else if ($cmtpoint > "5"){?>
<img src="<?=$board_skin_path?>/img/st1.gif"><img src="<?=$board_skin_path?>/img/st1.gif"><img src="<?=$board_skin_path?>/img/st1.gif"><img src="<?=$board_skin_path?>/img/st3.gif"><img src="<?=$board_skin_path?>/img/st3.gif">
<? } else if ($cmtpoint > "4"){?>
<img src="<?=$board_skin_path?>/img/st1.gif"><img src="<?=$board_skin_path?>/img/st1.gif"><img src="<?=$board_skin_path?>/img/st2.gif"><img src="<?=$board_skin_path?>/img/st3.gif"><img src="<?=$board_skin_path?>/img/st3.gif">
<? } else if ($cmtpoint > "3"){?>
<img src="<?=$board_skin_path?>/img/st1.gif"><img src="<?=$board_skin_path?>/img/st1.gif"><img src="<?=$board_skin_path?>/img/st3.gif"><img src="<?=$board_skin_path?>/img/st3.gif"><img src="<?=$board_skin_path?>/img/st3.gif">
<? } else if ($cmtpoint > "2"){?>
<img src="<?=$board_skin_path?>/img/st1.gif"><img src="<?=$board_skin_path?>/img/st2.gif"><img src="<?=$board_skin_path?>/img/st3.gif"><img src="<?=$board_skin_path?>/img/st3.gif"><img src="<?=$board_skin_path?>/img/st3.gif">
<? } else if ($cmtpoint > "1"){?>
<img src="<?=$board_skin_path?>/img/st1.gif"><img src="<?=$board_skin_path?>/img/st3.gif"><img src="<?=$board_skin_path?>/img/st3.gif"><img src="<?=$board_skin_path?>/img/st3.gif"><img src="<?=$board_skin_path?>/img/st3.gif">
<? } else if ($cmtpoint > "0"){?>
<img src="<?=$board_skin_path?>/img/st2.gif"><img src="<?=$board_skin_path?>/img/st3.gif"><img src="<?=$board_skin_path?>/img/st3.gif"><img src="<?=$board_skin_path?>/img/st3.gif"><img src="<?=$board_skin_path?>/img/st3.gif">
<? } else {?>
<img src="<?=$board_skin_path?>/img/st3.gif"><img src="<?=$board_skin_path?>/img/st3.gif"><img src="<?=$board_skin_path?>/img/st3.gif"><img src="<?=$board_skin_path?>/img/st3.gif"><img src="<?=$board_skin_path?>/img/st3.gif">
<? }?>
<?
$cmtpoint ='0';
$totalcount = '0';
$userrating = '0';
$tbl = "{$g4[write_prefix]}{$bo_table}";
$sql2 = " select wr_3 from $tbl where wr_is_comment > 0 && wr_parent = '{$list[$i][wr_id]}' && wr_3 > '0' ";
$result2 = sql_query($sql2);
while($row2 = mysql_fetch_array($result2) ) {
$point=$row2[0];
$cmtpoint=$cmtpoint + $point;
$totalcount++;
}
if ($totalcount!=0) {
$cmtpoint= $cmtpoint/$totalcount;
$cmtpoint= number_format($cmtpoint,2);
}
echo "<a href='{$list[$i][href]}'>";
?>
<font color="gray">
<? if ($cmtpoint > "9"){?>
<img src="<?=$board_skin_path?>/img/st1.gif"><img src="<?=$board_skin_path?>/img/st1.gif"><img src="<?=$board_skin_path?>/img/st1.gif"><img src="<?=$board_skin_path?>/img/st1.gif"><img src="<?=$board_skin_path?>/img/st1.gif">
<? } else if ($cmtpoint > "8"){?>
<img src="<?=$board_skin_path?>/img/st1.gif"><img src="<?=$board_skin_path?>/img/st1.gif"><img src="<?=$board_skin_path?>/img/st1.gif"><img src="<?=$board_skin_path?>/img/st1.gif"><img src="<?=$board_skin_path?>/img/st2.gif">
<? } else if ($cmtpoint > "7"){?>
<img src="<?=$board_skin_path?>/img/st1.gif"><img src="<?=$board_skin_path?>/img/st1.gif"><img src="<?=$board_skin_path?>/img/st1.gif"><img src="<?=$board_skin_path?>/img/st1.gif"><img src="<?=$board_skin_path?>/img/st3.gif">
<? } else if ($cmtpoint > "6"){?>
<img src="<?=$board_skin_path?>/img/st1.gif"><img src="<?=$board_skin_path?>/img/st1.gif"><img src="<?=$board_skin_path?>/img/st1.gif"><img src="<?=$board_skin_path?>/img/st2.gif"><img src="<?=$board_skin_path?>/img/st3.gif">
<? } else if ($cmtpoint > "5"){?>
<img src="<?=$board_skin_path?>/img/st1.gif"><img src="<?=$board_skin_path?>/img/st1.gif"><img src="<?=$board_skin_path?>/img/st1.gif"><img src="<?=$board_skin_path?>/img/st3.gif"><img src="<?=$board_skin_path?>/img/st3.gif">
<? } else if ($cmtpoint > "4"){?>
<img src="<?=$board_skin_path?>/img/st1.gif"><img src="<?=$board_skin_path?>/img/st1.gif"><img src="<?=$board_skin_path?>/img/st2.gif"><img src="<?=$board_skin_path?>/img/st3.gif"><img src="<?=$board_skin_path?>/img/st3.gif">
<? } else if ($cmtpoint > "3"){?>
<img src="<?=$board_skin_path?>/img/st1.gif"><img src="<?=$board_skin_path?>/img/st1.gif"><img src="<?=$board_skin_path?>/img/st3.gif"><img src="<?=$board_skin_path?>/img/st3.gif"><img src="<?=$board_skin_path?>/img/st3.gif">
<? } else if ($cmtpoint > "2"){?>
<img src="<?=$board_skin_path?>/img/st1.gif"><img src="<?=$board_skin_path?>/img/st2.gif"><img src="<?=$board_skin_path?>/img/st3.gif"><img src="<?=$board_skin_path?>/img/st3.gif"><img src="<?=$board_skin_path?>/img/st3.gif">
<? } else if ($cmtpoint > "1"){?>
<img src="<?=$board_skin_path?>/img/st1.gif"><img src="<?=$board_skin_path?>/img/st3.gif"><img src="<?=$board_skin_path?>/img/st3.gif"><img src="<?=$board_skin_path?>/img/st3.gif"><img src="<?=$board_skin_path?>/img/st3.gif">
<? } else if ($cmtpoint > "0"){?>
<img src="<?=$board_skin_path?>/img/st2.gif"><img src="<?=$board_skin_path?>/img/st3.gif"><img src="<?=$board_skin_path?>/img/st3.gif"><img src="<?=$board_skin_path?>/img/st3.gif"><img src="<?=$board_skin_path?>/img/st3.gif">
<? } else {?>
<img src="<?=$board_skin_path?>/img/st3.gif"><img src="<?=$board_skin_path?>/img/st3.gif"><img src="<?=$board_skin_path?>/img/st3.gif"><img src="<?=$board_skin_path?>/img/st3.gif"><img src="<?=$board_skin_path?>/img/st3.gif">
<? }?>
댓글 전체
$sql2 = " select wr_3 from $tbl where wr_is_comment > 0 && wr_parent = '{$list[$i][wr_id]}' && wr_3 > '0' ";
윗부분을 아래처럼
$sql2 = " select wr_3 from $tbl where wr_is_comment > 0 && wr_parent = '{$list[$i][wr_id]}' && wr_3 > '0' ORDER BY 점수필드 DESC";
윗부분을 아래처럼
$sql2 = " select wr_3 from $tbl where wr_is_comment > 0 && wr_parent = '{$list[$i][wr_id]}' && wr_3 > '0' ORDER BY 점수필드 DESC";