XoopsModules25x / xoopstube

singlevideo.php

<?php

/**
 * Module: XoopsTube
 *
 * You may not change or alter any portion of this comment or credits
 * of supporting developers from this source code or any supporting source code
 * which is considered copyrighted (c) material of the original comment or credit authors.
 *
 * PHP version 5
 *
 * @category        Module
 * @package         Xoopstube
 * @author          XOOPS Development Team
 * @copyright       2001-2013 The XOOPS Project
 * @license         GNU GPL 2 or later (http://www.gnu.org/licenses/gpl-2.0.html)
 * @version         $Id$
 * @link            http://sourceforge.net/projects/xoops/
 * @since           1.0.6
 */

include __DIR__ . '/header.php';

$lid = xtubeCleanRequestVars($_REQUEST, 'lid', 0);
$cid = xtubeCleanRequestVars($_REQUEST, 'cid', 0);
$lid = intval($lid);
$cid = intval($cid);

$sql2 = 'SELECT count(*) FROM ' . $xoopsDB->prefix('xoopstube_videos') . ' a LEFT JOIN ' . $xoopsDB->prefix(
        'xoopstube_altcat'
    ) . ' b' . ' ON b.lid = a.lid' . ' WHERE a.published > 0 AND a.published <= ' . time() . ' AND (a.expired = 0 OR a.expired > ' . time() . ') AND a.offline = 0' . ' AND (b.cid=a.cid OR (a.cid='
    . intval($cid) . ' OR b.cid=' . intval($cid) . '))';
list($count) = $xoopsDB->fetchRow($xoopsDB->query($sql2));

if (false == xtubeCheckGroups($cid) || $count == 0) {
    redirect_header('index.php', 1, _MD_XOOPSTUBE_MUSTREGFIRST);
    exit();
}

$sql       = 'SELECT * FROM ' . $xoopsDB->prefix('xoopstube_videos') . ' WHERE lid=' . intval($lid) . '
        AND (published > 0 AND published <= ' . time() . ')
        AND (expired = 0 OR expired > ' . time() . ')
        AND offline = 0
        AND cid > 0';
$result    = $xoopsDB->query($sql);
$video_arr = $xoopsDB->fetchArray($result);

if (!is_array($video_arr)) {
    redirect_header('index.php', 1, _MD_XOOPSTUBE_NOVIDEOLOAD);
    exit();
}

$xoopsOption['template_main'] = 'xoopstube_singlevideo.tpl';

include XOOPS_ROOT_PATH . '/header.php';

// tags support
if (xtubeIsModuleTagInstalled()) {
    include_once XOOPS_ROOT_PATH . '/modules/tag/include/tagbar.php';
    $xoopsTpl->assign('tagbar', tagBar($video_arr['lid'], 0));
}

$video['imageheader']  = xtubeRenderImageHeader();
$video['id']           = $video_arr['lid'];
$video['cid']          = $video_arr['cid'];
$video['vidid']        = $video_arr['vidid'];
$video['description2'] = $xtubemyts->displayTarea($video_arr['description'], 1, 1, 1, 1, 1);

$mytree     = new XoopstubeTree($xoopsDB->prefix('xoopstube_cat'), 'cid', 'pid');
$pathstring = '<a href="index.php">' . _MD_XOOPSTUBE_MAIN . '</a>&nbsp;:&nbsp;';
$pathstring .= $mytree->getNicePathFromId($cid, 'title', 'viewcat.php?op=');
$video['path'] = $pathstring;
// Get video from source
$video['showvideo'] = xtubeShowVideo(
    $video_arr['vidid'],
    $video_arr['vidsource'],
    $video_arr['screenshot'],
    $video_arr['picurl']
);

// Get Social Bookmarks
$video['sbmarks'] = getSocialBookmarks($video_arr['lid']);

// Start of meta tags
global $xoopsTpl, $xoTheme, $xoopsModuleConfig;

Use of global functionality is not recommended; it makes your code harder to test, and less reusable.

$maxWords = 100;
$words    = array();
$words    = explode(' ', xtubeConvertHtml2Text($video_arr['description']));
$newWords = array();
$i        = 0;
while ($i < $maxWords - 1 && $i < count($words)) {
    if (isset($words[$i])) {
        $newWords[] = trim($words[$i]);
    }
    ++$i;
}
$video_meta_description = implode(' ', $newWords);

if (is_object($xoTheme)) {
    if ($video_arr['keywords']) {
        $xoTheme->addMeta('meta', 'keywords', $video_arr['keywords']);
    }
    $xoTheme->addMeta('meta', 'title', $video_arr['title']);
    if ($xoopsModuleConfig['usemetadescr'] == 1) {
        $xoTheme->addMeta('meta', 'description', $video_meta_description);
    }
} else {
    if ($video_arr['keywords']) {
        $xoopsTpl->assign('xoops_meta_keywords', $video_arr['keywords']);
    }
    if ($xoopsModuleConfig['usemetadescr'] == 1) {
        $xoopsTpl->assign('xoops_meta_description', $video_meta_description);
    }
}
$xoopsTpl->assign('xoops_pagetitle', $video_arr['title']);
// End of meta tags

$moderate = 0;
include_once XOOPS_ROOT_PATH . '/modules/' . $xoopsModule->getvar('dirname') . '/include/videoloadinfo.php';

$xoopsTpl->assign('show_screenshot', false);
if (isset($xoopsModuleConfig['screenshot']) && $xoopsModuleConfig['screenshot'] == 1) {

This code seems to be duplicated across your project.

    $xoopsTpl->assign('shotwidth', $xoopsModuleConfig['shotwidth']);
    $xoopsTpl->assign('shotheight', $xoopsModuleConfig['shotheight']);
    $xoopsTpl->assign('show_screenshot', true);
}

if ($video['isadmin'] == false) {
    $count = xtubeUpdateCounter($lid);

Are you sure the assignment to $count is correct as xtubeUpdateCounter($lid) (which targets xtubeUpdateCounter()) seems to always return null.

}

// Show other author videos
$sql    = 'SELECT lid, cid, title, published FROM ' . $xoopsDB->prefix('xoopstube_videos') . '
        WHERE submitter=' . $video_arr['submitter'] . '
        AND lid <> ' . $video_arr['lid'] . '
        AND published > 0 AND published <= ' . time() . ' AND (expired = 0 OR expired > ' . time() . ')
        AND offline = 0 ORDER by published DESC';
$result = $xoopsDB->query($sql, 10, 0);

while ($arr = $xoopsDB->fetchArray($result)) {
    if (xtubeCheckGroups($arr['cid']) == true) {
        $videouid['title']     = $xtubemyts->htmlSpecialCharsStrip($arr['title']);
        $videouid['lid']       = $arr['lid'];
        $videouid['cid']       = $arr['cid'];
        $videouid['published'] = xtubeGetTimestamp(
            formatTimestamp($arr['published'], $xoopsModuleConfig['dateformat'])
        );
        $xoopsTpl->append('video_uid', $videouid);
    }
}

// Copyright notice
if (isset($xoopsModuleConfig['copyright']) && $xoopsModuleConfig['copyright'] == 1) {
    $xoopsTpl->assign(
        'lang_copyright',
        '' . $video['publisher'] . ' &#0169; ' . _MD_XOOPSTUBE_COPYRIGHT . ' ' . formatTimestamp(time(), 'Y') . ' - ' . XOOPS_URL
    );
}

// Show other videos by submitter
if (isset($xoopsModuleConfig['othervideos']) && $xoopsModuleConfig['othervideos'] == 1) {
    $xoopsTpl->assign('other_videos', '<b>' . _MD_XOOPSTUBE_OTHERBYUID . '</b>' . $video['submitter'] . '<br />');
} else {
    $xoopsTpl->assign('other_videos', '<b>' . _MD_XOOPSTUBE_NOOTHERBYUID . '</b>' . $video['submitter'] . '<br />');
}

$video['showsubmitterx'] = $xoopsModuleConfig['showsubmitter'];
$video['showsbookmarx']  = $xoopsModuleConfig['showsbookmarks'];
$video['othervideox']    = $xoopsModuleConfig['othervideos'];
$xoopsTpl->assign('video', $video);

$xoopsTpl->assign(
    'back',
    '<a href="javascript:history.go(-1)"><img src="' . XOOPS_URL . '/modules/' . $xoopsModule->getvar('dirname') . '/assets/images/icon/back.png" /></a>'
); // Displays Back button
$xoopsTpl->assign('module_dir', $xoopsModule->getVar('dirname'));

include XOOPS_ROOT_PATH . '/include/comment_view.php';
include XOOPS_ROOT_PATH . '/footer.php';