<?php
/***************************************************************************
*                 dm_vc_page.php
*                 -------------------
*     title            : DM Video Collection
*     version        : 1.0.0
*     begin            : Wednesday, Apr 16, 2008
*     copyright        : (C) 2008 femu
*     email            :
*
***************************************************************************/

/***************************************************************************
*     This MOD is based on the Music Online Mod 2.06 from CF Manager
*    (C) 2003 - 2004 by CF Manager
*    Email:
***************************************************************************/

/***************************************************************************
*
*     This program is free software; you can redistribute it and/or modify
*     it under the terms of the GNU General Public License as published by
*     the Free Software Foundation; either version 2 of the License, or
*     (at your option) any later version.
*
***************************************************************************/

define('IN_PHPBB', true);
$phpbb_root_path = './';
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'common.'.$phpEx);
$vc_root_path = $phpbb_root_path . 'video_box/';
$video_image_path = $phpbb_root_path . 'video_box/upload/video_image/';
$video_image_default = $video_image_path . 'no_img_b.gif';  // The default image


// ------------------------------------
// Start session management
// ------------------------------------
$userdata = session_pagestart($user_ip, PAGE_VC);
init_userprefs($userdata);
// ------------------------------------
// End session management
// ------------------------------------

// ------------------------------------
// Get general vc information
// ------------------------------------
include($vc_root_path . 'dm_vc_common.'.$phpEx);

// ------------------------------------
// Check the request
// ------------------------------------

if( isset($_GET['video_id']) )
{
    $video_id = intval($_GET['video_id']);
}
else if( isset($_POST['video_id']) )
{
    $video_id = intval($_POST['video_id']);
}
else
{
    message_die(GENERAL_ERROR, $lang['vc_error_no_id']);
}

        $sql = "SELECT video_id, video_cat_id, video_user_id
                FROM ". VC_TABLE ."
                WHERE video_id = $video_id";
if( !($result = $db->sql_query($sql)) )
{
            message_die(GENERAL_ERROR, $lang['vc_error_video_info'], '', __LINE__, __FILE__, $sql);
}



while( $row = $db->sql_fetchrow($result) )
{
    $vc_user_access = vc_user_access($row['video_id'], $row, 1, 0, 0, 0, 0, 0); // VIEW
    if ($vc_user_access['view'] == 1)
    {


        if( $row['video_id'] == $video_id )
        {

            $auth_data = vc_user_access($video_id, $row, 1, 1, 1, 1, 1, 1); // ALL

        }
    }
}



// ------------------------------------
// Check permissions
// ------------------------------------

if( !$auth_data['view'] )
{
    if ( !$userdata['session_logged_in'] )
    {
        redirect(append_sid(LOGIN_MG . '?redirect=dm_vc_page.' . $phpEx . '&amp;video_id=' . $video_id));
        exit;        
    }
    else
    {
        message_die(GENERAL_ERROR, $lang['Not_Authorised']);
    }
}
// ------------------------------------
// END check permissions
// ------------------------------------

// ------------------------------------
// Build Auth List
// ------------------------------------
$auth_key = array_keys($auth_data);

$auth_list = '';
for ($i = 0; $i < (count($auth_data) - 1); $i++) // ignore MODERATOR in this loop
{
    // ------------------------------------
    // we should skip a loop if RATE and COMMENT is disabled
    // ------------------------------------

    if( ( ($vc_config['rate'] == 0) and ($auth_key[$i] == 'rate') ) or ( ($vc_config['comment'] == 0) and ($auth_key[$i] == 'comment') ) )
    {
        continue;
    }

    $auth_list .= ($auth_data[$auth_key[$i]] == 1) ? $lang['Music_'. $auth_key[$i] .'_can'] : $lang['VC_'. $auth_key[$i] .'_cannot'];
    $auth_list .= '<br />';
}

// ------------------------------------
// Add Moderator Control Panel here
// ------------------------------------

if( ($userdata['user_level'] == ADMIN) or ($auth_data['moderator'] == 1) )
{
    $auth_list .= sprintf($lang['VC_moderate_can'], '<a href="'. append_sid("dm_vc_modcp.$phpEx?cat_id=$cat_id") .'">', '</a>');
}

// ------------------------------------
// END Auth List
// ------------------------------------

// ------------------------------------
// Previous & Next
// ------------------------------------

if( isset($_GET['mode']) )
{
    if( ($_GET['mode'] == 'next') or ($_GET['mode'] == 'previous') )
    {
        $sql = "SELECT video_id, video_cat_id, video_user_id
                FROM ". VC_TABLE ."
                WHERE video_id = $video_id";

        if( !($result = $db->sql_query($sql)) )
        {
            message_die(GENERAL_ERROR, $lang['vc_error_video_info'], '', __LINE__, __FILE__, $sql);
        }

        $row = $db->sql_fetchrow($result);

        if( empty($row) )
        {
            message_die(GENERAL_ERROR, 'Bad video_id');
        }

        $sql = "SELECT new.video_id, new.video_time
                FROM ". VC_TABLE ." AS new, ". VC_TABLE ." AS cur
                WHERE cur.video_id = $video_id
                    AND new.video_id <> cur.video_id
                    AND new.video_cat_id = cur.video_cat_id";

        $sql .= ($_GET['mode'] == 'next') ? " AND new.video_time >= cur.video_time" : " AND new.video_time <= cur.video_time";


        $sql .= ($_GET['mode'] == 'next') ? " ORDER BY video_time ASC LIMIT 1" : " ORDER BY video_time DESC LIMIT 1";

        if( !($result = $db->sql_query($sql)) )
        {
            message_die(GENERAL_ERROR, $lang['vc_error_video_info'], '', __LINE__, __FILE__, $sql);
        }

        $row = $db->sql_fetchrow($result);

        if( empty($row) )
        {
            message_die(GENERAL_ERROR, $lang['Video_not_exist']);
        }

        $video_id = $row['video_id']; // NEW video_id
    }
}


// ------------------------------------
// Get this video info
// ------------------------------------

$sql = "SELECT s.*, u.user_id, u.username, r.rate_video_id, AVG(r.rate_point) AS rating, COUNT(DISTINCT c.comment_id) AS comments
        FROM ". VC_TABLE ." AS s
            LEFT JOIN ". USERS_TABLE ." AS u ON s.video_user_id = u.user_id
            LEFT JOIN ". VC_RATE_TABLE ." AS r ON s.video_id = r.rate_video_id
            LEFT JOIN ". VC_COMMENT_TABLE ." AS c ON s.video_id = c.comment_video_id
        WHERE video_id = '$video_id'
        GROUP BY s.video_id";
if( !($result = $db->sql_query($sql)) )
{
    message_die(GENERAL_ERROR, $lang['vc_error_video_info'], '', __LINE__, __FILE__, $sql);
}
$thisvideo = $db->sql_fetchrow($result);

$cat_id = $thisvideo['video_cat_id'];
$user_id = $thisvideo['video_user_id'];

if(!$thisvideo['comments'])
{
    $thisvideo['comments'] = $lang['No_comment'];
}
else
{
    $thisvideo['comments'] = round($thisvideo['comments'], 2);
}

if ( $thisvideo['video_desc'] == '')
{
    $template->assign_block_vars('switch_no_lyrics_block', array());
}
else
{
    $template->assign_block_vars('switch_lyrics_block', array());
}

if( empty($thisvideo) )
{
    message_die(GENERAL_ERROR, $lang['Video_not_exist']);
}

if ( $thisvideo['video_imagename'] == '' )
{
    $img_id = $video_image_default;
}
else
{
    $img_id = ( $video_image_path . $thisvideo['video_imagename'] );
}

$video_filetype = 'youtube';
$video_url = $thisvideo['video_url'];

// ------------------------------------
// Get the current Category Info
// ------------------------------------

    $sql = "SELECT *
            FROM ". VC_CAT_TABLE ."
            WHERE cat_id = '$cat_id'";
    if( !($result = $db->sql_query($sql)) )
    {
        message_die(GENERAL_ERROR, $lang['vc_error_cat_info'], '', __LINE__, __FILE__, $sql);
    }

    $thiscat = $db->sql_fetchrow($result);

if (empty($thiscat))
{
    message_die(GENERAL_ERROR, $lang['Category_not_exist']);
}



// ------------------------------------
// Check video Approval
// ------------------------------------

if ($userdata['user_level'] != ADMIN)
{
    if( ($thiscat['cat_approval'] == ADMIN) or (($thiscat['cat_approval'] == MOD) and !$vc_user_access['moderator']) )
    {
        if ($thisvideo['video_approval'] != 1)
        {
            message_die(GENERAL_ERROR, $lang['Not_Authorised']);
        }
    }
}

// ------------------------------------
// Increase view counter
// ------------------------------------

$sql = "UPDATE ". VC_TABLE ."
        SET video_view_count = video_view_count + 1
        WHERE video_id = '$video_id'";
if( !($result = $db->sql_query($sql)) )
{
    message_die(GENERAL_ERROR, $lang['vc_error_video_upd'], '', __LINE__, __FILE__, $sql);
}

// ------------------------------------
// Show Info box
// ------------------------------------
if( $vc_config['show_info'] == 1)
{
    $template->assign_block_vars('switch_show_info', array());
}

// ------------------------------------
// End Show Info box
// ------------------------------------

//----------------------------------------------------------
// Main work here...
//----------------------------------------------------------

//
// Start output of page
//
$page_title = $lang['VC'];
include($phpbb_root_path . 'includes/page_header.'.$phpEx);

$template->set_filenames(array(
    'body' => 'dm_vc_page_body.tpl')
);

if( ($thisvideo['video_user_id'] == VC_GUEST) or ($thisvideo['username'] == '') )
{
    $poster = ($thisvideo['video_username'] == '') ? $lang['Guest'] : $thisvideo['video_username'];
}
else
{
    $poster = '<a href="'. append_sid("profile.$phpEx?mode=viewprofile&amp;". POST_USERS_URL .'='. $thisvideo['user_id']) .'">'. $thisvideo['username'] .'</a>';
}

if ($vc_config['show_listen_block'] == 1)
{
    $template->assign_block_vars('switch_show_listen_block', array());
}

$template->assign_vars(array(
    'L_VC' => $lang['VC'],
    'L_VC_ONLINE' => sprintf($lang['VC_Online'],$vc_config['version']),
    'L_VC_VIEW_EXPLAIN' => $lang['Video_view_explain'],
    'L_LISTEN_TO' => $lang['Video_listen_to'],
    'CAT_TITLE' => $thiscat['cat_title'],
    'U_VIEW_CAT' => append_sid("dm_vc_cat.$phpEx?cat_id=$cat_id"),
    'L_VC_HEADER' => $lang['VC_Header'],
    'L_VC_HEADER_EXPLAIN' => $lang['VC_Header_Explain'],
    'L_SEARCH_VIDEOS' => $lang['Search_video'],
    'SEARCH_VIDEO_IMG' => $images['search_video'],
    'VIDEO_IMG' => $images['video'],
    'L_VIDEO_IMAGE' => $lang['Video_image'],
    'L_VIDEO_IMAGE_SHOW' => $lang['Video_image_show'],
    'L_CLICK_IMAGE_TITLE' => $lang['Click_image_title'],

    
    'EDIT' => ( ($auth_data['moderator']) || ($userdata['_video_user_id'] == $thisvideo['video_user_id']) ) ? '<a href="'. append_sid("dm_vc_edit.$phpEx?video_id=$video_id") . '">' . $lang['Edit_video'] . '</a>' : '',


    'U_VIDEO' => append_sid("dm_vc_page.$phpEx?video_id=$video_id"),
    'U_SHOW_VIDEO' => append_sid("dm_vc_show.$phpEx?video_id=$video_id"),
    'L_SHOW_VIDEO' => $lang['show_video'],
    'U_IMG' => append_sid("$img_id"),
    'S_VC_SEARCH_ACTION' => append_sid("dm_vc_search.$phpEx"),

    'VIDEO_TITLE' => $thisvideo['video_title'],
    'VIDEO_URL' => $thisvideo['video_url'],
    'VIDEO_DESC' => nl2br($thisvideo['video_desc']),
    'SINGER' => $thisvideo['video_singer'],
    'VIDEO_DURATION' => $thisvideo['video_duration'],
    'L_VIDEO_DURATION' => $lang['Video_duration'],

    'POSTER' => $poster,

    'VIDEO_TIME' => create_date($board_config['default_dateformat'], $thisvideo['video_time'], $board_config['board_timezone']),

    'VIDEO_VIEW' => $thisvideo['video_view_count'],
    'VIDEO_DOWNLOAD' => $thisvideo['video_download_count'],

    'VIDEO_RATING' => ($thisvideo['rating'] != 0) ? round($thisvideo['rating'], 2) : $lang['Not_rated'],

    'VIDEO_COMMENTS' => $thisvideo['comments'],

    'U_RATE' => append_sid("dm_vc_rate.$phpEx?video_id=$video_id"),
    'U_COMMENT' => append_sid("dm_vc_comment.$phpEx?video_id=$video_id"),
    'U_VC_DOWNLOAD' => $thisvideo['video_download_link'],

    'U_NEXT' => append_sid("dm_vc_page.$phpEx?video_id=$video_id&amp;mode=next"),
    'U_PREVIOUS' => append_sid("dm_vc_page.$phpEx?video_id=$video_id&amp;mode=previous"),

    'L_NEXT' => $lang['Next'],
    'L_PREVIOUS' => $lang['Previous'],

    'L_FROM' => $lang['from'],
    'L_RATING' => $lang['Rating'],
    'L_VIDEO_TITLE' => $lang['Video_Title'],
    'L_VIDEO_DESC' => $lang['Video_Desc'],
    'L_SINGER' => $lang['Singer'],
    'L_POSTER' => $lang['Poster'],
    'L_POSTED' => $lang['Posted'],
    'L_VIEW' => $lang['View'],
    'L_VC_DOWNLOAD' => $lang['Download'],
    'L_COPYRIGHT' => sprintf($lang['VC_copyright'],$vc_config['version']),
    'L_COMMENTS' => $lang['Comments'])


);

if ($vc_config['rate'])
{
    $template->assign_block_vars('rate_switch', array());
}

if ($vc_config['comment'])
{
    $template->assign_block_vars('comment_switch', array());
}

if ( empty($thisvideo['video_download_link'] ))
{
    $template->assign_block_vars('no_download_switch', array());
}
else
{
    $template->assign_block_vars('download_switch', array());
}

// ------------------------------------
// Video Collection
// ------------------------------------
if ( $video_filetype == 'youtube' )
{
    $template->assign_block_vars('youtube', array());
}

// ------------------------------------
// Generate the page
// ------------------------------------
$template->pparse('body');

include($phpbb_root_path . 'includes/page_tail.'.$phpEx);

?>