별점 주는 소스인데 순위별이 될가용? > 그누4 질문답변

그누4 질문답변

그누보드4 관련 질문은 QA 로 이전됩니다. QA 그누보드4 바로가기
기존 게시물은 열람만 가능합니다.

별점 주는 소스인데 순위별이 될가용? 정보

별점 주는 소스인데 순위별이 될가용?

본문

아래 별점 주는 소스라고하더라구요 이것을 높은값을 위로 해서 순위별로 나열되게 할려고하는데 가능할가용?

<?
$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";
© SIRSOFT
현재 페이지 제일 처음으로