Files
Testing/view_channel.php

171 lines
6.7 KiB
PHP
Raw Permalink Normal View History

2026-11-17 16:15:01 -05:00
<?php
/* $Id: video.php 142 2009-03-26 09:15:25Z szerrade $ */
$page = "view_channel";
include "header.php";
// DISPLAY ERROR PAGE IF USER IS NOT LOGGED IN AND ADMIN SETTING REQUIRES REGISTRATION
if( !$user->user_exists && !$setting['setting_permission_video'] )
{
$page = "error";
$smarty->assign('error_header', 639);
$smarty->assign('error_message', 656);
$smarty->assign('error_submit', 641);
include "footer.php";
}
// DISPLAY ERROR PAGE IF NO OWNER
if( !$owner->user_exists )
{
$page = "error";
$smarty->assign('error_header', 639);
$smarty->assign('error_message', 828);
$smarty->assign('error_submit', 641);
include "footer.php";
}
// DISPLAY ERROR FOR MEMBERS WITH INSUFFICIENT USER LEVEL
/*if ($user->user_info['user_level_id'] <= 1) :
$page = "error";
$smarty->assign('error_header', 9000000);
$smarty->assign('error_message', 9000001);
$smarty->assign('error_submit', 641);
include "footer.php";
endif;
*/
if(isset($_POST['task'])) { $task = $_POST['task']; } elseif(isset($_GET['task'])) { $task = $_GET['task']; } else { $task = "main"; }
if(isset($_POST['video_id'])) { $video_id = $_POST['video_id']; } elseif(isset($_GET['video_id'])) { $video_id = $_GET['video_id']; } else { $video_id = 0; }
$approval_needed = $_POST['admin_key'] == 'b4t3' ? '' : "AND video_admin_approved='1'";
// MAKE SURE VIDEO EXISTS
$video_query = $database->database_query("SELECT * FROM contest WHERE id='$video_id' AND user='{$owner->user_info['user_id']}' AND approved='1' LIMIT 1");
//if($database->database_num_rows($video_query) != 1) { header("Location: ".$url->url_create('profile', $owner->user_info['user_username'])); exit(); }
$video_info = $database->database_fetch_assoc($video_query);
// INSTANTIATE VIDEO AND SET VIDEO VARS
$video = new se_video($owner->user_info['user_id']);
$video_info['video_dir'] = "./contests/";
// ENSURE VIDEOS ARE ENABLED FOR THIS USER
// Changed for viewing videos of expired members
/*
if ((($video_info['video_type'] == 0) && (!$owner->level_info['level_video_allow'])) || (($video_info['video_type'] == 1) && (!$owner->level_info['level_youtube_allow'])))
{
header("Location: ".$url->url_create('profile', $owner->user_info['user_username']));
exit();
}
*/
$video_info['video_rating_full'] = floor($video_info['video_cache_rating']);
//echo $video_info['video_rating_full'];
$video_info['video_rating_part'] = (($video_info['video_cache_rating']-$video_info['video_rating_full']) == 0) ? 0 : 1;
$video_info['video_rating_none'] = 5-$video_info['video_rating_full']-$video_info['video_rating_part'];
$video_info['video_rating_total'] = $database->database_num_rows($database->database_query("SELECT NULL FROM contestratings WHERE videorating_video_id='{$video_info['id']}'"));
// GET VIDEO COMMENT PRIVACY
$allowed_to_comment = ($privacy_max & $video_info['video_comments']);
// CHECK IF USER IS ALLOWED TO RATE
$allowed_to_rate = 1;
if($database->database_num_rows($database->database_query("SELECT NULL FROM contestratings WHERE videorating_video_id='{$video_info['id']}' AND videorating_user_id='{$user->user_info['user_id']}'")) != 0 || !$user->user_exists) { $allowed_to_rate = 0; }
// RATE VIDEO
if($task == "rate_do")
{
$rating = (int) $_POST['rating'];
if($allowed_to_rate)
{
if($rating <= 5 && $rating >= 1)
{
$database->database_query("INSERT INTO contestratings (videorating_video_id, videorating_user_id, videorating_rating) VALUES ('{$video_info['id']}', '{$user->user_info['user_id']}', '{$rating}')");
// GET AVERAGE RATING / NUM VOTES FOR BAYESIAN WEIGHTED RATING
$avg = $database->database_fetch_assoc($database->database_query("SELECT avg(video_cache_rating) AS average_rating, avg(video_cache_rating_total) AS average_total FROM contestratings WHERE video_cache_rating_total<>'0'"));
// GET TOTAL RATING
$new_rating = ($video_info['video_cache_rating']*$video_info['video_rating_total']+$rating)/($video_info['video_rating_total']+1);
$new_total = $video_info['video_rating_total']+1;
$new_rating_weighted = ( ($avg['average_total'] * $avg['average_rating']) + ($new_total * $new_rating) ) / ($avg['average_total'] + $new_total);
// SET NEW CACHED RATINGS
$database->database_query("UPDATE contest SET video_cache_rating='{$new_rating}', video_cache_rating_weighted='{$new_rating_weighted}', video_cache_rating_total='{$new_total}' WHERE id='{$video_info['id']}'");
$allowed_to_rate = 0;
$video_info['video_rating_full'] = floor($new_rating);
$video_info['video_rating_part'] = (($new_rating-$video_info['video_rating_full']) == 0) ? 0 : 1;
$video_info['video_rating_none'] = 5-$video_info['video_rating_full']-$video_info['video_rating_part'];
$video_info['video_rating_total'] = $new_total;
}
}
$response_array = array(
'allowed_to_rate' => (bool) $allowed_to_rate,
'rating_full' => (int) $video_info['video_rating_full'],
'rating_part' => (int) $video_info['video_rating_part'],
'rating_none' => (int) $video_info['video_rating_none'],
'rating_total' => (int) $video_info['video_rating_total']
);
// OUTPUT JSON
echo json_encode($response_array);
exit();
}
// GET USER'S VIDEOS FOR CAROUSEL
$total_videos = $video->video_total("(video_is_converted='1')");
$video_array = $video->contest_list(0, $video->contest_total(), "id DESC", "", 1);
// GET VIDEO COMMENTS
$comment = new se_comment('contest', 'video_id', $video_info['id']);
$total_comments = $comment->comment_total();
// UPDATE VIDEO VIEWS
if($user->user_info['user_id'] != $owner->user_info['user_id'])
{
$video_views_new = $video_info['video_views'] + 1;
$database->database_query("UPDATE contest SET video_views='{$video_views_new}' WHERE id='{$video_info['id']}' LIMIT 1");
}
// UPDATE NOTIFICATIONS
/*if($user->user_info['user_id'] == $owner->user_info['user_id'])
{
$database->database_query("DELETE FROM se_notifys USING se_notifys LEFT JOIN se_notifytypes ON se_notifys.notify_notifytype_id=se_notifytypes.notifytype_id WHERE se_notifys.notify_user_id='{$owner->user_info['user_id']}' AND se_notifytypes.notifytype_name='videocomment' AND notify_object_id='{$video_info['video_id']}'");
}
*/
// SET GLOBAL PAGE TITLE
$global_page_title[0] = 5500151;
$global_page_title[1] = $owner->user_displayname;
$global_page_title[2] = $video_info['video_title'];
$global_page_description[0] = 5500102;
$global_page_description[1] = $video_info['video_desc'];
// ASSIGN VARIABLES AND DISPLAY VIDEO PAGE
$smarty->assign('video_info', $video_info);
$smarty->assign('total_comments', $total_comments);
$smarty->assign('allowed_to_comment', $allowed_to_comment);
$smarty->assign('allowed_to_rate', $allowed_to_rate);
$smarty->assign('videos', $video_array);
$smarty->assign('total_videos', $total_videos);
include "footer.php";
?>