\n";
$result = dbquery("
SELECT v.*, vc.* FROM " . DB_VIDEO . " v
LEFT JOIN " . DB_VIDEO_CAT . " vc ON v.cat_id=vc.cat_id
WHERE ".groupaccess('cat_access')." ORDER BY id DESC LIMIT 0,5
");
if (dbrows($result)) {
while($data = dbarray($result)) {
echo "
\n";
echo "\n";
echo "".$data['name']."\n";
if ($data['description'] = trimlink($data['description'], 100)) {
echo nl2br(parseubb(parsesmileys($data['description']), "b|i|u|small|url|mail|img|color")); }
echo " \n{$locale['v_tv']} ".number_format($data['views'])."\n";
echo " | \n
\n";
}
}
echo "";
closeside();
?>