//Getting List of Featured Videos
$query_param = "broadcast='public' AND active='yes' AND status='Successful'";
$show = 'featured';
$query = "SELECT * FROM video WHERE $query_param ORDER BY today_views DESC limit 25";
$text = 'Най-нови видео клипове';
Assign('text',$text);
$link = BASEURL.videos_link.'?order=fr';
Assign('link',$link);
$data = $db->Execute($query);
$videos = $data->getrows();
$total = $data->recordcount() + 0;
for($id=0;$id<$total;$id++){
$videos[$id]['thumb'] = GetThumb($videos[$id]['flv']);
$videos[$id]['duration'] = SetTime($videos[$id]['duration']);
$videos[$id]['comments'] = $myquery->GetTotalVideoComments($videos[$id]['videoid']);
@$videos[$id]['show_rating'] = pullRating($videos[$id]['videoid'],false,false,false,novote);
$videos[$id]['url'] = VideoLink($videos[$id]['videokey'],$videos[$id]['title']);
}
Assign('videos',$videos);
Assign('show',$show);
$query_param = "broadcast='public' AND active='yes' AND status='Successful'";
$show = 'featured';
$query = "SELECT * FROM video WHERE $query_param ORDER BY today_views DESC limit 25";
$text = 'Най-нови видео клипове';
Assign('text',$text);
$link = BASEURL.videos_link.'?order=fr';
Assign('link',$link);
$data = $db->Execute($query);
$videos = $data->getrows();
$total = $data->recordcount() + 0;
for($id=0;$id<$total;$id++){
$videos[$id]['thumb'] = GetThumb($videos[$id]['flv']);
$videos[$id]['duration'] = SetTime($videos[$id]['duration']);
$videos[$id]['comments'] = $myquery->GetTotalVideoComments($videos[$id]['videoid']);
@$videos[$id]['show_rating'] = pullRating($videos[$id]['videoid'],false,false,false,novote);
$videos[$id]['url'] = VideoLink($videos[$id]['videokey'],$videos[$id]['title']);
}
Assign('videos',$videos);
Assign('show',$show);