<h1>Чарт <strong>видео</strong> клипов</h1>
<?=advert('pod_h1')?>
<h4>Здесь показывается хит-парад новых и не очень, видеоклипов.</h4>
<h2>самые популярные видеоклипы</h2>
<div class="video_charts">
<?	$week = time()-$t[7];$i = 0;$sql = mysql_query("SELECT video.id, video.url, video.length, music.singer, music.star, music.song, music.hits, UNIX_TIMESTAMP(video.time) as time, count(music_load.track) as count
FROM `music`
INNER JOIN `music_load` ON (music_load.track=music.id)
INNER JOIN `video` ON (video.track=music.id)
WHERE
(UNIX_TIMESTAMP(music_load.time) > '$week')
GROUP BY music_load.track
ORDER BY count DESC LIMIT 20");while( $row = mysql_fetch_object($sql) ){$i++;if ((time() - $row->time) < $t[1]){$new=1}else{$new=0}?>
<? if ($i==1){?>
<div class="main_clip">
<div><a href="<?=$u?>/stars/<?=url($row->singer)?>"><?=$row->singer?></a> - <a href="<?=$u?>/video/<?=url($row->singer)?>/<?=url($row->song)?>"><?=$row->song?></a></div>
<object width="465" height="375">
<param name="movie" value="http://www.youtube.com/v/<?=$row->url?>&hl=ru&fs=1"></param>
<param name="allowFullScreen" value="true"></param>
<param name="allowscriptaccess" value="always"></param>
<embed src="http://www.youtube.com/v/<?=$row->url?>&hl=ru&fs=1" type="application/x-shockwave-flash" allowscriptaccess="always" allowfullscreen="true" width="465" height="375"></embed></object></div><?}else{?>
<? if ($i==2){?><div class="singer_videos"><?}?>
<a href="<?=$u?>/video/<?=url($row->singer)?>/<?=url($row->song)?>">
<div><p><?=$row->singer?></p></div>
<img src="<?=$u?>/preview/w110/<?=make_pic_video($row->id)?>" alt="видеоклип <?=$com->singer?> - <?=$row->song?>" width="110" height="82" border="0" />
<?=$row->song?> <span>(<?=$row->length?>)</span>
</a>
<?}?>
<?}?>
</div>
</div>
