주요 코드
[code]<![CDATA[ $sql = "select count(*) as cnt from yt_movies where rank=0";<br />
$newmovie = mysqli_fetch_object(mysqli_query($ccon, $sql));<br />
if($newmovie->cnt>0) { // new movie가 있으면....<br />
$rank=1;<br />
$sql=mysqli_query($ccon,"select no from yt_movies order by date DESC");<br />
while($value_no=mysqli_fetch_object($sql)) {<br />
mysqli_query($ccon, "update yt_movies set rank=$rank where no=$value_no->no");<br />
$rank++;<br />
}<br />
echo "영상 순서 업데이트 됨.<br>";<br />
}<br />
echo "<center>";<br />
$sql=mysqli_query($ccon, "select * from yt_movies order by value asc limit 4");<br />
while($movie = mysqli_fetch_object($sql)){<br />
$randon_update=number_format((rand(0, 1000)+rand(0, $movie->rank*500))/10000, 4);<br />
mysqli_query($ccon, "update yt_movies set value=value+(hit*0.1)+$randon_update where no=$movie->no");<br />
mysqli_query($ccon, "update yt_movies set value=TRUNCATE(value, 4) where no=$movie->no");<br />
echo "<div style='display:inline-block;margin:1 1 1 1;width:48%;border-style:dotted;border-color:white;border:1px;'>";<br />
echo "<br><a href=005_movie.php?no=$movie->no target=_blank>";<br />
if($movie->img_error) echo "<img src=https://img.youtube.com/vi/".$movie->yid."/mqdefault.jpg width=96% style='border:1px solid #eaeaea;border-radius:10%'>";<br />
else echo "<img src=https://img.youtube.com/vi/".$movie->yid."/maxresdefault.jpg width=96% style='border:1px solid #eaeaea;border-radius:10%'>";<br />
echo "</a><br>";<br />
echo substr($movie->date, 0,4).".";<br />
echo substr($movie->date, 4,2).".";<br />
echo substr($movie->date, 6,2);<br />
echo "</div><br />
";<br />
}]]>[/code] |
치악고등학교 영상들을 등록해놓은 후
썸네일이 랜덤으로 보이도록 함.
최근에 등록한 영상이 더 자주 보이도록 처리.