{$locale['submit_video']}";
}
if (!isset($_GET['rowstart']) || !isnum($_GET['rowstart'])) {
$_GET['rowstart'] = 0;
}
$column = dbquery("SELECT columns FROM " . DB_VIDEO_SET);
if ($column) {
$columns = dbresult($column, 0);
} else {
$columns = 2;
}
opentable($locale['top_rated_videos']);
echo "
";
include_once "nav.php";
$result = dbquery("SELECT v.*, vc.*, u.user_id, u.user_name, SUM(tr.rating_vote) AS sum_rating, COUNT(tr.rating_item_id) AS count_votes FROM " .
DB_VIDEO . " v
LEFT JOIN " . DB_VIDEO_CAT . " vc ON v.cat_id=vc.cat_id
LEFT JOIN " . DB_USERS . " u ON u.user_id=v.uid
LEFT JOIN " . DB_RATINGS .
" tr ON tr.rating_item_id = v.id AND tr.rating_type='V'
WHERE " . groupaccess('vc.cat_access') . " GROUP BY v.id ORDER BY time DESC LIMIT " . $_GET['rowstart'] . ",{$maxi}");
$rows = dbrows($result);
$rows2 = dbcount("(id)", DB_VIDEO);
if ($rows) {
$counter = 0;
$count = 1;
echo "\n";
while ($data = dbarray($result)) {
if ($counter != 0 && ($counter % $columns == 0)) {
echo "
\n\n";
}
echo "";
echo "";
echo " | \n";
$counter++;
$count++;
}
echo "
\n
\n";
if ($rows2 > $maxi) {
echo "\n" . makepagenav($_GET['rowstart'],
$maxi, $rows2, 3, FUSION_SELF . "?") . "\n
\n";
}
} else {
echo "\n\n";
echo "" . $locale['no_rated_videos'] .
" | ";
echo "
";
}
footer();
closetable();
require_once THEMES . "templates/footer.php";
?>