if (!defined("IN_FUSION")) { die("Access Denied"); }



if (file_exists(INFUSIONS."video/locale/".$settings['locale'].".php")) {

    include INFUSIONS."video/locale/English.php";

	include INFUSIONS."video/locale/".$settings['locale'].".php";

} else {

	include INFUSIONS."video/locale/English.php";

}



include INFUSIONS . "video/infusion_db.php";

require_once INCLUDES . "bbcode_include.php";



$admin = dbquery("SELECT * FROM " . DB_VIDEO_SET . " LIMIT 0,1");

while ($d = dbarray($admin)) {

    $access = $d['sub_enable'];

    $t_width = $d['t_width'];

    $t_height = $d['t_height'];

    $maxi = $d['items'];

}

$column = dbquery("SELECT columns FROM " . DB_VIDEO_SET);

if ($column) {

    $columns = dbresult($column, 0);

} else {

    $columns = 2;

}



$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 0,4");

if (dbrows($result)) {

    opentable($locale['latest-videos']);

    $counter = 0;

    $count = 1;

    echo "<table cellpadding='0' cellspacing='1' class='tbl-border center' width='100%'>\n<tr>";

	while($data = dbarray($result)) {

	if ($counter != 0 && ($counter % $columns == 0)) {

                echo "</tr>\n<tr>\n";

            }

            echo "<td valign='top' class='tbl' width='1%' style='padding: 0;'>";

            echo "<table cellpadding='0' cellspacing='1' width='100%' class='center'>\n";

            echo "<tr><td colspan='3' class='forum-caption'>";

            echo "<a href='".INFUSIONS."video/video.php?id=" . $data['id'] . "'>" . $data['name'] . "</a>\n";

            echo "</td></tr>";

            echo "<tr><td width='1%' rowspan='2' class='tbl' valign='top'>";

            echo "<a href='".INFUSIONS."video/video.php?id=" . $data['id'] . "'>";

            if ($data['video_type'] == "youtube" && $data['url']) {

                echo "<img src='http://img.youtube.com/vi/{$data['url']}/0.jpg' alt='' style='border:0; width: {$t_width}px; height: {$t_height}px;' />\n";

            } elseif (!empty($data['file_image_thumb']) && file_exists(INFUSIONS."video/images/" . $data['file_image_thumb'])) {

                echo "<img src='".INFUSIONS."video/images/" . $data['file_image_thumb'] .

                    "' alt='' style='border:0; width: {$t_width}px; height: {$t_height}px;' />\n";

            } else {

                echo "<img src='".INFUSIONS."video/images/cat_images/cat1.png' alt='' style='border:0; width: {$t_width}px; height: {$t_height}px;' />\n";

            }

            echo "</a></td><td width='99%' valign='top' class='tbl' colspan='2'>";

            if ($data['description'] != "") {

                $data['description'] = strip_bbcodes($data['description']);

                $data['description'] = trimlink($data['description'], 90);

                echo nl2br(parseubb(parsesmileys($data['description']),

                    "b|i|u|small|url|mail|img|color"));

            } else {

                echo $locale['no_description_p'];

            }

            echo "</tr><tr><td width='50%' class='tbl' valign='bottom'><small>";

            echo number_format($data['views']) . " " . $locale['v_tv'] . "</small><br />\n";

            echo ($data['allow_ratings'] ? "" . ($data['count_votes'] > 0 ? str_repeat("<img src='" .

                get_image("star") . "' alt='*' style='vertical-align:middle; width: 13px; height: 13px;' />",

                ceil($data['sum_rating'] / $data['count_votes'])) : "<small>" . $locale['n_y_r'] .

                "</small>") : "<small>" . $locale['n_y_r'] . "</small>");

            echo "</td><td width='50%' class='tbl' valign='bottom'>";

            echo "<small><b>{$locale['video_author']} <a href='".BASEDIR."profile.php?lookup=" . $data['user_id'] .

                "' target='_self'>" . trimlink($data['user_name'], 12) .

                "</a></b></small><br />";

            echo "<small>" . showdate("shortdate", $data['time']) . "</small>";

            echo "</td></tr></table>";

            echo "</td>\n";

            $counter++;

            $count++;	

	}

     echo "</tr>\n</table>\n";

     closetable();

}