if (!defined("IN_FUSION")) { die("Access Denied"); }
include INFUSIONS."ogladaj/functions.php";
echo "";
makeheader();
$antal = "0,7"; // how many to show
$movieH = 169; // image height size
$movieW = 126; // image width size
echo "
";
if ($kroaxsettings['kroax_set_playingnow'] == "1")
{
$count = dbcount("(movie_id)", "".$db_prefix."kroax_active");
if ($count > 2) {
echo "
".$locale['KROAXC716']."
";
echo "
";
echo "";
echo "
| ";
echo "
";
}
}
if($kroaxsettings['kroax_set_showpop'] == "1") {
echo "
";
$result =dbquery("select * FROM ".$db_prefix."kroax WHERE ".groupaccess('kroax_access')." AND ".groupaccess('kroax_access_cat')." AND kroax_approval='' ORDER BY kroax_hits DESC limit $antal");
echo "
";
}
if($kroaxsettings['kroax_set_showtop'] == "1") {
echo "
";
$result5 = dbquery("SELECT id, SUM(total_value) / COUNT(total_votes) as rating_rating , kroax_url,kroax_id, kroax_titel,kroax_tumb,kroax_uploader FROM ".$db_prefix."kroax_rating,
".$db_prefix."kroax WHERE ".groupaccess('kroax_access')." AND ".groupaccess('kroax_access_cat')." AND kroax_approval='' AND id =kroax_id GROUP BY id ORDER BY rating_rating DESC LIMIT $antal");
echo "
";
}
if($kroaxsettings['kroax_set_showlast'] == "1") {
echo "
";
$result3 =dbquery("select * FROM ".$db_prefix."kroax WHERE ".groupaccess('kroax_access')." AND ".groupaccess('kroax_access_cat')." AND kroax_approval='' ORDER BY kroax_lastplayed DESC limit $antal");
echo "
";
}
if($kroaxsettings['kroax_set_showlatest'] == "1") {
echo "
";
$result1 =dbquery("select * FROM ".$db_prefix."kroax WHERE ".groupaccess('kroax_access')." AND kroax_approval='' ORDER BY kroax_id DESC limit $antal");
echo "
";
}
if($kroaxsettings['kroax_set_showrandom'] == "1") {
echo "
";
$result4 = dbquery ("SELECT * FROM ".$db_prefix."kroax WHERE ".groupaccess('kroax_access')." AND ".groupaccess('kroax_access_cat')." AND kroax_approval='' ORDER BY RAND() LIMIT $antal");
echo "
";
}
echo "
";
echo "