function embedYoutubeId()
{
$ytLink = $_GET['vidlink'];
$youtube_id = getYouTubeIdFromURL($ytLink);
$youtubeCompleteLink = "http://www.youtube.com/embed/" . $youtube_id . "?modestbranding=1&autohide=1&showinfo=0&controls=0";
return $youtubeCompleteLink;
}
if (substr($inpt, 0, 4) == "www.") {
$inpt = "http://" . $inpt;
$is_url = true;
}
if (substr($inpt, 0, 8) == "youtube.") {
$inpt = "http://" . $inpt;
$is_url = true;
}
if (substr($inpt, 0, 8) == "youtu.be") {
$inpt = "http://" . $inpt;
$is_url = true;
}
// IF URL GET ID
if (substr($inpt, 0, 7) == "http://" or substr($inpt, 0, 8) == "https://") {
$is_url = true;
$id = getYouTubeIdFromURL($inpt);
}
// IF NOT URL TRY ID AS INPUT
if (!$is_url) {
$id = $inpt;
}
// FILENAME
$filename = $quality == "mq" ? $id . "-mq" : $id;
$filename .= $play_btn_file_name;
// IF EXISTS, GO
if (file_exists("i/" . $filename . ".jpg") and !isset($_GET['refresh'])) {
header("Location: i/" . $filename . ".jpg");
die;
}
// CHECK IF YOUTUBE VIDEO
$handle = curl_init("https://www.youtube.com/watch/?v=" . $id);
}
$auto_load = ot_get_option('auto_load_next_vieo');
//auto-load
if ($auto_load == '1') {
if (strpos($file, 'youtube.com') !== false || strpos($url, 'youtube.com') !== false || strpos($code, 'youtube.com') !== false) {
?>
<script src="http://www.youtube.com/player_api"></script>
<script>
// create youtube player
var player;
function onYouTubePlayerAPIReady() {
player = new YT.Player('player', {
height: '506',
width: '900',
videoId: '<?php
echo getYouTubeIdFromURL($url);
?>
',
events: {
'onReady': onPlayerReady,
'onStateChange': onPlayerStateChange
}
});
}
// autoplay video
function onPlayerReady(event) {
event.target.playVideo();
}
// when video ends
public function handle_video()
{
if (!$this->auth->acl_get('u_video_view_full')) {
trigger_error($this->user->lang['UNAUTHED']);
}
// Initial var setup
$video_id = $this->request->variable('id', 0);
$video_url = $this->request->variable('video_url', '', true);
$video_title = $this->request->variable('video_title', '', true);
$video_cat_id = $this->request->variable('cid', 0);
$video_cat_ids = $this->request->variable('id', 0);
$username = $this->request->variable('username', '', true);
$user_id = $this->request->variable('user_id', 0);
$youtube_id = $this->request->variable('youtube_id', '', true);
$create_time = $this->request->variable('create_time', '');
$video_views = $this->request->variable('video_views', 0);
$sql_start = $this->request->variable('start', 0);
$sql_limit = $this->request->variable('limit', 10);
$sql_limits = $this->request->variable('limit', $this->config['comments_per_page']);
//comments
// Comments
$cmnt_id = $this->request->variable('cmntid', 0);
$cmnt_video_id = $this->request->variable('v', 0);
$cmnt_text = utf8_normalize_nfc($this->request->variable('cmnt_text', '', true));
$mode = $this->request->variable('mode', '');
$submit = isset($_POST['submit']) ? true : false;
// Determine board url - we may need it later
$board_url = generate_board_url() . '/';
$web_path = defined('PHPBB_USE_BOARD_URL_PATH') && PHPBB_USE_BOARD_URL_PATH ? $board_url : $this->phpbb_root_path;
if (!$this->config['google_api_key']) {
if ($this->auth->acl_get('a_')) {
trigger_error($this->user->lang['NO_KEY_ADMIN']);
} else {
trigger_error($this->user->lang['NO_KEY_USER']);
}
}
/**
* Get youtube video ID from URL
* From: http://halgatewood.com/php-get-the-youtube-video-id-from-a-youtube-url/
*/
function getYouTubeIdFromURL($url)
{
$pattern = '/(?:youtube\\.com\\/(?:[^\\/]+\\/.+\\/|(?:v|e(?:mbed)?)\\/|.*[?&]v=)|youtu\\.be\\/)([^"&?\\/ ]{11})/i';
preg_match($pattern, $url, $matches);
return isset($matches[1]) ? $matches[1] : false;
}
$youtube_id = getYouTubeIdFromURL($video_url);
$jsonURL = file_get_contents("https://www.googleapis.com/youtube/v3/videos?id={$youtube_id}&key={$this->config['google_api_key']}&type=video&part=snippet");
$json = json_decode($jsonURL);
if (isset($json->items[0]->snippet)) {
$video_title = $json->items[0]->snippet->title;
}
$sql_ary = array('video_id' => $video_id, 'video_url' => $video_url, 'video_title' => $video_title, 'video_cat_id' => $video_cat_id, 'username' => $username, 'user_id' => $user_id, 'youtube_id' => $youtube_id, 'create_time' => (int) time(), 'video_views' => $video_views);
$error = $row = array();
$current_time = time();
$this->template->assign_vars(array('S_NEW_VIDEO' => $this->auth->acl_get('u_video_post') ? true : false, 'SCRIPT_NAME' => 'video', 'U_VIDEO' => $this->helper->route('dmzx_youtubegallery_controller')));
$this->template->assign_block_vars('navlinks', array('FORUM_NAME' => $this->user->lang['VIDEO_INDEX'], 'U_VIEW_FORUM' => $this->helper->route('dmzx_youtubegallery_controller')));
switch ($mode) {
case 'submit':
// User is a bot?!
if ($this->user->data['is_bot']) {
redirect(append_sid("{$this->phpbb_root_path}index.{$this->phpEx}"));
}
$redirect_url = $this->helper->route('dmzx_youtubegallery_controller', array('mode' => 'submit'));
// Is a guest?!
if ($this->user->data['user_id'] == ANONYMOUS) {
login_box($redirect_url);
}
// Can post?!
if (!$this->auth->acl_get('u_video_post')) {
trigger_error($this->user->lang['UNAUTHED']);
}
$l_title = $this->user->lang['VIDEO_SUBMIT'];
$template_html = 'video_editor.html';
$s_action = $this->helper->route('dmzx_youtubegallery_controller', array('mode' => 'submit'));
$s_hidden_fields = '';
$form_enctype = '';
add_form_key('postform');
// List of categories
$sql = 'SELECT *
FROM ' . $this->video_cat_table . '
ORDER BY video_cat_id DESC';
$result = $this->db->sql_query($sql);
while ($row = $this->db->sql_fetchrow($result)) {
$this->template->assign_block_vars('cat', array('VIDEO_CAT_ID' => censor_text($row['video_cat_id']), 'VIDEO_CAT_TITLE' => censor_text($row['video_cat_title'])));
}
// Start assigning vars for main posting page ...
$this->template->assign_vars(array('S_USER_ID' => $this->user->data['user_id'], 'S_USERNAME' => $this->user->data['username'], 'S_FORM_ENCTYPE' => $form_enctype, 'S_POST_ACTION' => $s_action, 'S_HIDDEN_FIELDS' => $s_hidden_fields, 'ERROR' => sizeof($error) ? implode('<br />', $error) : ''));
$this->template->assign_block_vars('navlinks', array('FORUM_NAME' => $this->user->lang['VIDEO_SUBMIT']));
add_form_key('postform');
if ($submit) {
if (!check_form_key('postform')) {
trigger_error('FORM_INVALID');
}
}
switch ($submit) {
case 'add':
if ($video_url == '') {
$meta_info = $this->helper->route('dmzx_youtubegallery_controller', array('mode' => 'submit'));
$message = $this->user->lang['NEED_VIDEO_URL'];
meta_refresh(3, $meta_info);
$message .= '<br /><br />' . sprintf($this->user->lang['PAGE_RETURN'], '<a href="' . $meta_info . '">', '</a>');
trigger_error($message);
} else {
$this->db->sql_query('INSERT INTO ' . $this->video_table . ' ' . $this->db->sql_build_array('INSERT', $sql_ary));
$u_action = $this->helper->route('dmzx_youtubegallery_controller');
$meta_info = $this->helper->route('dmzx_youtubegallery_controller');
$message = $this->user->lang['VIDEO_CREATED'];
meta_refresh(3, $meta_info);
$message .= '<br /><br />' . sprintf($this->user->lang['PAGE_RETURN'], '<a href="' . $meta_info . '">', '</a>');
trigger_error($message);
}
break;
}
break;
case 'comment':
$l_title = $this->user->lang['VIDEO_CMNT_SUBMIT'];
$template_html = '@dmzx_youtubegallery/video_cmnt_editor.html';
if (!$this->config['enable_comments']) {
trigger_error($this->user->lang['COMMENTS_DISABLED']);
}
// User is a bot?!
if ($this->user->data['is_bot']) {
redirect(append_sid("{$this->phpbb_root_path}index.{$this->phpEx}"));
}
// Can post?!
if (!$this->auth->acl_get('u_video_comment')) {
trigger_error($this->user->lang['UNAUTHED']);
}
$redirect_url = $this->helper->route('dmzx_youtubegallery_controller', array('mode' => 'comment', 'v' => (int) $video_id));
// Is a guest?!
if ($this->user->data['user_id'] == ANONYMOUS) {
login_box($redirect_url);
}
if (!function_exists('generate_smilies')) {
include $this->phpbb_root_path . 'includes/functions_posting.' . $this->phpEx;
}
if (!function_exists('display_custom_bbcodes')) {
include $this->phpbb_root_path . 'includes/functions_display.' . $this->phpEx;
}
//Settings for comments
$this->user->setup('posting');
display_custom_bbcodes();
generate_smilies('inline', 0);
$bbcode_status = $this->config['allow_bbcode'] ? true : false;
$smilies_status = $this->config['allow_smilies'] ? true : false;
$img_status = $bbcode_status ? true : false;
$url_status = $this->config['allow_post_links'] ? true : false;
$flash_status = $bbcode_status && $this->config['allow_post_flash'] ? true : false;
$quote_status = true;
$video_id = $this->request->variable('v', 0);
$uid = $bitfield = $options = '';
$allow_bbcode = $allow_urls = $allow_smilies = true;
$s_action = $this->helper->route('dmzx_youtubegallery_controller', array('mode' => 'comment', 'v' => (int) $video_id));
$s_hidden_fields = '';
$form_enctype = '';
add_form_key('postform');
// Start assigning vars for main posting page ...
$this->template->assign_vars(array('VIDEO_ID' => (int) $video_id, 'S_FORM_ENCTYPE' => $form_enctype, 'S_POST_ACTION' => $s_action, 'S_HIDDEN_FIELDS' => $s_hidden_fields, 'ERROR' => sizeof($error) ? implode('<br />', $error) : '', 'S_BBCODE_ALLOWED' => $bbcode_status ? 1 : 0, 'S_SMILIES_ALLOWED' => $smilies_status, 'S_BBCODE_IMG' => $img_status, 'S_BBCODE_URL' => $url_status, 'S_LINKS_ALLOWED' => $url_status, 'S_BBCODE_QUOTE' => $quote_status));
if (isset($_POST['submit'])) {
if (!check_form_key('postform')) {
trigger_error('FORM_INVALID');
}
$video_id = $this->request->variable('v', 0);
// Get video to redirect :D
$message = $this->request->variable('cmnt_text', '', true);
generate_text_for_storage($message, $uid, $bitfield, $options, $allow_bbcode, $allow_urls, $allow_smilies);
$data = array('cmnt_video_id' => $this->request->variable('cmnt_video_id', 0), 'cmnt_poster_id' => $this->user->data['user_id'], 'cmnt_text' => $message, 'create_time' => time(), 'bbcode_uid' => $uid, 'bbcode_bitfield' => $bitfield, 'bbcode_options' => $options);
if ($message == '') {
$meta_info = $this->helper->route('dmzx_youtubegallery_controller', array('mode' => 'comment', 'v' => (int) $video_id));
$message = $this->user->lang['NEED_VIDEO_MESSAGE'];
meta_refresh(3, $meta_info);
$message .= '<br /><br />' . sprintf($this->user->lang['PAGE_RETURN'], '<a href="' . $meta_info . '">', '</a>');
trigger_error($message);
} else {
$this->db->sql_query('INSERT INTO ' . $this->video_cmnts_table . ' ' . $this->db->sql_build_array('INSERT', $data));
$meta_info = $this->helper->route('dmzx_youtubegallery_controller', array('mode' => 'view', 'id' => (int) $video_id));
$message = $this->user->lang['COMMENT_CREATED'];
meta_refresh(3, $meta_info);
$message .= '<br /><br />' . sprintf($this->user->lang['PAGE_RETURN'], '<a href="' . $meta_info . '">', '</a>');
trigger_error($message);
}
}
$this->template->assign_block_vars('navlinks', array('FORUM_NAME' => $this->user->lang['VIDEO_CMNT_SUBMIT']));
break;
case 'delcmnt':
if (!$this->auth->acl_get('u_video_comment_delete')) {
trigger_error($this->user->lang['UNAUTHED']);
}
$video_id = $this->request->variable('v', 0);
// Get video to redirect :D
if (confirm_box(true)) {
$sql = 'DELETE FROM ' . $this->video_cmnts_table . '
WHERE cmnt_id = ' . (int) $cmnt_id;
$this->db->sql_query($sql);
$meta_info = $this->helper->route('dmzx_youtubegallery_controller', array('mode' => 'view', 'id' => (int) $video_id));
$message = $this->user->lang['COMMENT_DELETED_SUCCESS'];
meta_refresh(1, $meta_info);
$message .= '<br /><br />' . sprintf($this->user->lang['PAGE_RETURN'], '<a href="' . $meta_info . '">', '</a>');
trigger_error($message);
} else {
$s_hidden_fields = build_hidden_fields(array('id' => $cmnt_id, 'mode' => 'delcmnt'));
confirm_box(false, $this->user->lang['DELETE_COMMENT_CONFIRM'], $s_hidden_fields);
$meta_info = $this->helper->route('dmzx_youtubegallery_controller', array('mode' => 'view', 'id' => (int) $video_id));
meta_refresh(1, $meta_info);
}
break;
case 'delete':
if (!$this->auth->acl_get('u_video_delete')) {
trigger_error($this->user->lang['UNAUTHED']);
}
$l_title = $this->user->lang['DELETE_VIDEO'];
if (confirm_box(true)) {
$sql = 'DELETE FROM ' . $this->video_table . '
WHERE video_id = ' . $video_id;
$this->db->sql_query($sql);
$meta_info = $this->helper->route('dmzx_youtubegallery_controller');
$message = $this->user->lang['VIDEO_DELETED'];
meta_refresh(3, $meta_info);
$message .= '<br /><br />' . sprintf($this->user->lang['PAGE_RETURN'], '<a href="' . $meta_info . '">', '</a>');
trigger_error($message);
} else {
$s_hidden_fields = build_hidden_fields(array('mode' => 'delete', 'submit' => true, 'video_id' => $video_id));
confirm_box(false, $this->user->lang['DELETE_VIDEO'], $s_hidden_fields);
$meta_info = $this->helper->route('dmzx_youtubegallery_controller');
$message = $this->user->lang['RETURN_TO_VIDEO_INDEX'];
meta_refresh(3, $meta_info);
$message .= '<br /><br />' . sprintf($this->user->lang['PAGE_RETURN'], '<a href="' . $meta_info . '">', '</a>');
trigger_error($message);
}
break;
case 'view':
if (!$this->auth->acl_get('u_video_view')) {
trigger_error($this->user->lang['VIDEO_UNAUTHED']);
}
// Update video view... but only for humans
if (isset($this->user->data['session_page']) && !$this->user->data['is_bot']) {
$sql = 'UPDATE ' . $this->video_table . '
SET video_views = video_views + 1
WHERE video_id = ' . $video_id;
$this->db->sql_query($sql);
}
$sql_ary = array('SELECT' => 'v.*, u.*', 'FROM' => array($this->video_table => 'v', USERS_TABLE => 'u'), 'WHERE' => 'v.video_id = ' . (int) $video_id . ' and u.user_id = v.user_id', 'ORDER_BY' => 'v.video_id DESC');
$sql = $this->db->sql_build_query('SELECT', $sql_ary);
$result = $this->db->sql_query($sql);
$row = $this->db->sql_fetchrow($result);
$this->db->sql_freeresult($result);
$page_title = $row['video_title'];
$user_id = $row['user_id'];
$flash_status = $this->config['allow_post_flash'] ? true : false;
$delete_allowed = ($this->auth->acl_get('a_') or $this->auth->acl_get('m_') || $this->user->data['is_registered'] && $this->user->data['user_id'] == $row['user_id'] && $this->auth->acl_get('u_video_delete'));
$this->template->assign_vars(array('VIDEO_ID' => censor_text($row['video_id']), 'VIDEO_TITLE' => censor_text($row['video_title']), 'VIDEO_VIEWS' => $row['video_views'], 'USERNAME' => get_username_string('full', $row['user_id'], $row['username'], $row['user_colour']), 'YOUTUBE_ID' => censor_text($row['youtube_id']), 'VIDEO_TIME' => $this->user->format_date($row['create_time']), 'YOUTUBE_VIDEO' => 'http://www.youtube.com/watch?v=' . $row['youtube_id'], 'VIDEO_LINK' => generate_board_url() . $this->helper->route('dmzx_youtubegallery_controller', array('mode' => 'view', 'id' => $row['video_id'])), 'VIDEO_LINK_FLASH' => 'http://www.youtube.com/v/' . $row['youtube_id'], 'U_USER_VIDEOS' => $this->helper->route('dmzx_youtubegallery_controller', array('mode' => 'user_videos', 'user_id' => $this->user->data['user_id'])), 'U_DELETE' => $this->helper->route('dmzx_youtubegallery_controller', array('mode' => 'delete', 'id' => $row['video_id'])), 'DELETE_ALLOW' => $delete_allowed, 'S_BBCODE_FLASH' => $flash_status, 'FLASH_STATUS' => $flash_status ? $this->user->lang['FLASH_IS_ON'] : $this->user->lang['FLASH_IS_OFF'], 'S_VIDEO_WIDTH' => $this->config['video_width'], 'S_VIDEO_HEIGHT' => $this->config['video_height'], 'U_POST_COMMENT' => $this->helper->route('dmzx_youtubegallery_controller', array('mode' => 'comment', 'v' => $row['video_id'])), 'S_ENABLE_COMMENTS' => $this->config['enable_comments'], 'S_POST_COMMENT' => $this->auth->acl_get('u_video_comment')));
// Comments
$pagination_url = $this->helper->route('dmzx_youtubegallery_controller', array('mode' => 'view', 'id' => $video_id));
$sql_ary = array('SELECT' => 'v.*, cmnt.*, u.username,u.user_colour,u.user_id', 'FROM' => array($this->video_table => 'v', $this->video_cmnts_table => 'cmnt', USERS_TABLE => 'u'), 'WHERE' => 'v.video_id = ' . (int) $video_id . '
AND cmnt.cmnt_video_id = v.video_id
AND u.user_id = cmnt.cmnt_poster_id', 'ORDER_BY' => 'cmnt.cmnt_id DESC');
$sql = $this->db->sql_build_query('SELECT', $sql_ary);
$result = $this->db->sql_query_limit($sql, $sql_limits, $sql_start);
while ($row = $this->db->sql_fetchrow($result)) {
$delete_cmnt_allowed = ($this->auth->acl_get('a_') or $this->auth->acl_get('m_') || $this->user->data['is_registered'] && $this->user->data['user_id'] == $row['user_id'] && $this->auth->acl_get('u_video_comment_delete'));
$text = generate_text_for_display($row['cmnt_text'], $row['bbcode_uid'], $row['bbcode_bitfield'], $row['bbcode_options']);
$this->template->assign_block_vars('commentrow', array('COMMENT_ID' => $row['cmnt_id'], 'COMMENT_TEXT' => $text, 'COMMENT_TIME' => $this->user->format_date($row['create_time']), 'USERNAME' => get_username_string('full', $row['user_id'], $row['username'], $row['user_colour']), 'S_DELETE_ALLOWED' => $delete_cmnt_allowed, 'U_DELETE' => $this->helper->route('dmzx_youtubegallery_controller', array('mode' => 'delcmnt', 'cmntid' => (int) $row['cmnt_id'], 'v' => (int) $row['cmnt_video_id']))));
}
$this->db->sql_freeresult($result);
// We need another query for the video count
$sql = 'SELECT COUNT(*) as comment_count
FROM ' . $this->video_cmnts_table . '
WHERE cmnt_video_id = ' . (int) $video_id;
$result = $this->db->sql_query($sql);
$videorow['comment_count'] = $this->db->sql_fetchfield('comment_count');
$this->db->sql_freeresult($result);
//Start pagination
$start = $this->request->variable('start', 0);
$this->pagination->generate_template_pagination($pagination_url, 'pagination', 'start', $videorow['comment_count'], $sql_limits, $sql_start);
$this->template->assign_vars(array('TOTAL_COMMENTS' => $videorow['comment_count'] == 1 ? $this->user->lang['LIST_COMMENT'] : sprintf($this->user->lang['LIST_COMMENTS'], $videorow['comment_count'])));
//End pagination
// Count the videos user video ...
$sql = 'SELECT COUNT(video_id) AS total_videos
FROM ' . $this->video_table . '
WHERE user_id = ' . (int) $user_id;
$result = $this->db->sql_query($sql);
$total_videos = (int) $this->db->sql_fetchfield('total_videos');
$this->db->sql_freeresult($result);
$this->template->assign_vars(array('TOTAL_VIDEOS' => $total_videos));
// Count the video comments ...
$sql_cmnts = 'SELECT COUNT(cmnt_id) AS total_comments
FROM ' . $this->video_cmnts_table . '
WHERE cmnt_video_id = ' . (int) $video_id;
$result = $this->db->sql_query($sql_cmnts);
$total_comments = (int) $this->db->sql_fetchfield('total_comments');
$this->db->sql_freeresult($result);
$this->template->assign_vars(array('TOTAL_COMMENTS_TITLE' => $total_comments));
$l_title = $page_title;
$template_html = 'video_view.html';
$this->template->assign_block_vars('navlinks', array('FORUM_NAME' => $page_title));
break;
case 'cat':
$sql_limit = $sql_limit > 10 ? 10 : $sql_limit;
$pagination_url = $this->helper->route('dmzx_youtubegallery_controller', array('mode' => 'cat', 'id' => $video_cat_ids));
$sql_ary = array('SELECT' => 'v.*,
ct.video_cat_title,ct.video_cat_id,
u.username,u.user_colour,u.user_id', 'FROM' => array($this->video_table => 'v', $this->video_cat_table => 'ct', USERS_TABLE => 'u'), 'WHERE' => 'v.video_cat_id = ' . $video_cat_ids . '
AND ct.video_cat_id = ' . $video_cat_ids . '
AND v.user_id = u.user_id', 'ORDER_BY' => 'v.video_id DESC');
$sql = $this->db->sql_build_query('SELECT', $sql_ary);
$result = $this->db->sql_query_limit($sql, $sql_limit, $sql_start);
while ($row = $this->db->sql_fetchrow($result)) {
$this->template->assign_block_vars('video', array('VIDEO_TITLE' => $row['video_title'], 'VIDEO_CAT_ID' => $row['video_cat_id'], 'VIDEO_CAT_TITLE' => $row['video_cat_title'], 'VIDEO_VIEWS' => $row['video_views'], 'U_CAT' => $this->helper->route('dmzx_youtubegallery_controller', array('mode' => 'cat', 'id' => $row['video_cat_id'])), 'VIDEO_TIME' => $this->user->format_date($row['create_time']), 'VIDEO_ID' => censor_text($row['video_id']), 'U_VIEW_VIDEO' => $this->helper->route('dmzx_youtubegallery_controller', array('mode' => 'view', 'id' => $row['video_id'])), 'U_POSTER' => append_sid("{$this->phpbb_root_path}memberlist.{$this->phpEx}", array('mode' => 'viewprofile', 'u' => $row['user_id'])), 'USERNAME' => get_username_string('full', $row['user_id'], $row['username'], $row['user_colour']), 'S_VIDEO_THUMBNAIL' => 'http://img.youtube.com/vi/' . censor_text($row['youtube_id']) . '/default.jpg'));
}
$this->db->sql_freeresult($result);
// We need another query for the video count
$sql = 'SELECT COUNT(*) as video_count
FROM ' . $this->video_table . '
WHERE video_cat_id = ' . (int) $video_cat_ids;
$result = $this->db->sql_query($sql);
$videorow['video_count'] = $this->db->sql_fetchfield('video_count');
$this->db->sql_freeresult($result);
$start = $this->request->variable('start', 0);
$this->pagination->generate_template_pagination($pagination_url, 'pagination', 'start', $videorow['video_count'], $sql_limit, $sql_start);
$this->template->assign_vars(array('TOTAL_VIDEOS' => $videorow['video_count'] == 1 ? $this->user->lang['LIST_VIDEO'] : sprintf($this->user->lang['LIST_VIDEOS'], $videorow['video_count'])));
$sql = 'SELECT *
FROM ' . $this->video_cat_table . '
WHERE video_cat_id = ' . (int) $video_cat_ids;
$result = $this->db->sql_query($sql);
$row = $this->db->sql_fetchrow($result);
$this->db->sql_freeresult($result);
$this->template->assign_vars(array('CAT_NAME' => $row['video_cat_title']));
$l_title = $row['video_cat_title'];
$template_html = 'video_cat.html';
$this->template->assign_block_vars('navlinks', array('FORUM_NAME' => $row['video_cat_title']));
break;
case 'user_videos':
$this->template->assign_vars(array('S_SEARCH_USER_VIDEO' => true));
$sql_limit = $sql_limit > 10 ? 10 : $sql_limit;
$pagination_url = $this->helper->route('dmzx_youtubegallery_controller', array('mode' => 'user_videos', 'user_id' => $user_id));
$sql_ary = array('SELECT' => 'v.*,
ct.video_cat_title,ct.video_cat_id,
u.username,u.user_colour,u.user_id', 'FROM' => array($this->video_table => 'v', $this->video_cat_table => 'ct', USERS_TABLE => 'u'), 'WHERE' => 'u.user_id = v.user_id
AND ct.video_cat_id = v.video_cat_id
AND u.user_id = ' . $user_id, 'ORDER_BY' => 'v.video_id DESC');
$sql = $this->db->sql_build_query('SELECT', $sql_ary);
$result = $this->db->sql_query_limit($sql, $sql_limit, $sql_start);
while ($row = $this->db->sql_fetchrow($result)) {
$this->template->assign_block_vars('video', array('VIDEO_TITLE' => $row['video_title'], 'VIDEO_CAT_ID' => $row['video_cat_id'], 'VIDEO_CAT_TITLE' => $row['video_cat_title'], 'VIDEO_VIEWS' => $row['video_views'], 'U_CAT' => $this->helper->route('dmzx_youtubegallery_controller', array('mode' => 'cat', 'id' => $row['video_cat_id'])), 'VIDEO_TIME' => $this->user->format_date($row['create_time']), 'VIDEO_ID' => censor_text($row['video_id']), 'U_VIEW_VIDEO' => $this->helper->route('dmzx_youtubegallery_controller', array('mode' => 'view', 'id' => $row['video_id'])), 'U_POSTER' => append_sid("{$this->phpbb_root_path}memberlist.{$this->phpEx}", array('mode' => 'viewprofile', 'u' => $row['user_id'])), 'USERNAME' => get_username_string('full', $row['user_id'], $row['username'], $row['user_colour']), 'S_VIDEO_THUMBNAIL' => 'http://img.youtube.com/vi/' . censor_text($row['youtube_id']) . '/default.jpg'));
}
$this->db->sql_freeresult($result);
// We need another query for the video count
$sql = 'SELECT COUNT(*) as video_count
FROM ' . $this->video_table . '
WHERE user_id = ' . $user_id;
$result = $this->db->sql_query($sql);
$videorow['video_count'] = $this->db->sql_fetchfield('video_count');
$this->db->sql_freeresult($result);
$start = $this->request->variable('start', 0);
$this->pagination->generate_template_pagination($pagination_url, 'pagination', 'start', $videorow['video_count'], $sql_limit, $sql_start);
$this->template->assign_vars(array('TOTAL_VIDEOS' => $videorow['video_count'] == 1 ? $this->user->lang['LIST_VIDEO'] : sprintf($this->user->lang['LIST_VIDEOS'], $videorow['video_count'])));
$l_title = $this->user->lang['USER_VIDEOS'];
$template_html = 'video_search.html';
break;
default:
//Listing categories
$sql = 'SELECT *
FROM ' . $this->video_cat_table . "\n\t\t\t\tORDER BY video_cat_id";
$res = $this->db->sql_query($sql);
while ($row = $this->db->sql_fetchrow($res)) {
$this->template->assign_block_vars('videocat', array('VIDEO_CAT_ID' => $row['video_cat_id'], 'VIDEO_CAT_TITLE' => $row['video_cat_title'], 'U_CAT' => $this->helper->route('dmzx_youtubegallery_controller', array('mode' => 'cat', 'id' => $row['video_cat_id']))));
}
// Count the videos ...
$sql = 'SELECT COUNT(video_id) AS total_videos
FROM ' . $this->video_table;
$result = $this->db->sql_query($sql);
$total_videos = (int) $this->db->sql_fetchfield('total_videos');
$this->db->sql_freeresult($result);
// Count the videos categories ...
$sql = 'SELECT COUNT(video_cat_id) AS total_categories
FROM ' . $this->video_cat_table . '';
$result = $this->db->sql_query($sql);
$total_categories = (int) $this->db->sql_fetchfield('total_categories');
$this->db->sql_freeresult($result);
// Count the videos views ...
$sql = 'SELECT SUM(video_views) AS total_views
FROM ' . $this->video_table;
$result = $this->db->sql_query($sql);
$total_views = (int) $this->db->sql_fetchfield('total_views');
$this->db->sql_freeresult($result);
$total_videos;
// Count the videos comments ...
$sql = 'SELECT COUNT(cmnt_id) AS total_comments
FROM ' . $this->video_cmnts_table;
$result = $this->db->sql_query($sql);
$total_comments = (int) $this->db->sql_fetchfield('total_comments');
$this->db->sql_freeresult($result);
$l_title = $this->user->lang['VIDEO_INDEX'];
$template_html = 'video_body.html';
$l_total_video_s = $total_videos == 0 ? 'TOTAL_VIDEO_ZERO' : 'TOTAL_VIDEOS_OTHER';
$l_total_category_s = $total_categories == 0 ? 'TOTAL_CATEGORY_ZERO' : 'TOTAL_CATEGORIES_OTHER';
$l_total_view_s = $total_views == 0 ? 'TOTAL_VIEW_ZERO' : 'TOTAL_VIEWS_OTHER';
$l_total_comment_s = $total_comments == 0 ? 'TOTAL_COMMENT_ZERO' : 'TOTAL_COMMENTS_OTHER';
$this->template->assign_vars(array('U_VIDEO_SUBMIT' => $this->helper->route('dmzx_youtubegallery_controller', array('mode' => 'submit')), 'VIDEOSUBMIT' => $this->auth->acl_get('u_video_post'), 'U_MY_VIDEOS' => $this->helper->route('dmzx_youtubegallery_controller', array('mode' => 'user_videos', 'user_id' => $this->user->data['user_id'])), 'BUTTON_VIDEO_NEW' => "{$web_path}styles/" . $this->user->lang_name . '/button_video_new.gif', 'TOTAL_VIDEOS_INDEX' => sprintf($this->user->lang[$l_total_video_s], $total_videos), 'TOTAL_CATEGORIES' => sprintf($this->user->lang[$l_total_category_s], $total_categories), 'TOTAL_VIEWS' => sprintf($this->user->lang[$l_total_view_s], $total_views), 'TOTAL_COMMENTS' => sprintf($this->user->lang[$l_total_comment_s], $total_comments)));
$sql_limit = $sql_limit > 10 ? 10 : $sql_limit;
$pagination_url = $this->helper->route('dmzx_youtubegallery_controller');
$sql_ary = array('SELECT' => 'v.*,
ct.video_cat_title,ct.video_cat_id,
u.username,u.user_colour,u.user_id', 'FROM' => array($this->video_table => 'v', $this->video_cat_table => 'ct', USERS_TABLE => 'u'), 'WHERE' => 'ct.video_cat_id = v.video_cat_id AND u.user_id = v.user_id', 'ORDER_BY' => 'v.video_id DESC');
$sql = $this->db->sql_build_query('SELECT', $sql_ary);
$result = $this->db->sql_query_limit($sql, $sql_limit, $sql_start);
while ($row = $this->db->sql_fetchrow($result)) {
$this->template->assign_block_vars('video', array('VIDEO_TITLE' => $row['video_title'], 'VIDEO_CAT_ID' => $row['video_cat_id'], 'VIDEO_CAT_TITLE' => $row['video_cat_title'], 'VIDEO_VIEWS' => $row['video_views'], 'U_CAT' => $this->helper->route('dmzx_youtubegallery_controller', array('mode' => 'cat', 'id' => $row['video_cat_id'])), 'VIDEO_TIME' => $this->user->format_date($row['create_time']), 'VIDEO_ID' => censor_text($row['video_id']), 'U_VIEW_VIDEO' => $this->helper->route('dmzx_youtubegallery_controller', array('mode' => 'view', 'id' => $row['video_id'])), 'U_POSTER' => append_sid("{$this->phpbb_root_path}memberlist.{$this->phpEx}", array('mode' => 'viewprofile', 'u' => $row['user_id'])), 'USERNAME' => get_username_string('full', $row['user_id'], $row['username'], $row['user_colour']), 'YOUTUBE_ID' => censor_text($row['youtube_id'])));
}
$this->db->sql_freeresult($result);
// We need another query for the video count
$sql = 'SELECT COUNT(*) as video_count
FROM ' . $this->video_table;
$result = $this->db->sql_query($sql);
$videorow['video_count'] = $this->db->sql_fetchfield('video_count');
$this->db->sql_freeresult($result);
$start = $this->request->variable('start', 0);
$this->pagination->generate_template_pagination($pagination_url, 'pagination', 'start', $videorow['video_count'], $sql_limit, $sql_start);
$this->template->assign_vars(array('TOTAL_VIDEOS' => $videorow['video_count'] == 1 ? $this->user->lang['LIST_VIDEO'] : sprintf($this->user->lang['LIST_VIDEOS'], $videorow['video_count'])));
break;
}
if (!$row) {
$this->template->assign_vars(array('NO_ENTRY' => $this->user->lang['NO_VIDEOS']));
}
// Output page
page_header($l_title, false);
$this->template->set_filenames(array('body' => $template_html));
make_jumpbox(append_sid("{$this->phpbb_root_path}viewforum.{$this->phpEx}"));
page_footer();
}
<?php
$error = '';
function getYouTubeIdFromURL($url)
{
$url_string = parse_url($url, PHP_URL_QUERY);
parse_str($url_string, $args);
return isset($args['v']) ? $args['v'] : false;
}
if(isset($_POST['update']) && $_POST['page_name'] != '')
{
if($_POST["urlname"] != '')
{
$value = getYouTubeIdFromURL($_POST["urlname"]);
$sql = "UPDATE
videos
SET
video_name = '".$_POST["urlname"]."',
page_name = '".$_POST['page_name']."'
WHERE
id = '".$_GET['id']."'
";
mysql_query($sql);
header('Location:manage_videos.php');
}
else
{
</div>
</div>
<div class="show_room">
<div id="nav11">
</div>
<div id="section11"><br>
<?php
function getYouTubeIdFromURL($url)
{
$url_string = parse_url($url, PHP_URL_QUERY);
parse_str($url_string, $args);
return isset($args['v']) ? $args['v'] : false;
}
$youtube_id = getYouTubeIdFromURL($_GET['name']);
if ($youtube_id == "") {
$youtube_id = $_GET['search12'];
}
/*echo $_GET['name'];
echo "<br>";
echo $youtube_id;*/
echo '<center><iframe width="560" height="315" style="border: outset #000000 10px;" src="http://www.youtube.com/embed/' . $youtube_id . '" frameborder="0" allowfullscreen></iframe></center>';
exec("python samp.py " . $youtube_id, $output, $return);
sleep(1);
$neg = $output[0];
$pos = $output[1];
/*echo $neg;
echo $pos;*/
?>
?>
<script type="text/javascript">
alert('Please Enter Url..!');
window.location="director_dashboard.php";
</script>
<?php
}
else
{
$video = getYouTubeIdFromURL($_POST['video_url']);
$sql = "INSERT
INTO
video_gallery
(
director_id,
url
)
VALUES
(
'".$_SESSION['person_id']."',
'".$video."'
)
";
<?php
/*
function getYouTubeIdFromURL($url)
{
$pattern = '/(?:youtube.com/(?:[^/]+/.+/|(?:v|e(?:mbed)?)/|.*[?&]v=)|youtu.be/)([^"&?/ ]{11})/i';
preg_match($pattern, $url, $matches);
return isset($matches[1]) ? $matches[1] : false;
}
*/
function getYouTubeIdFromURL($url)
{
$url_string = parse_url($url, PHP_URL_QUERY);
parse_str($url_string, $args);
return isset($args['v']) ? $args['v'] : false;
}
$youtube_id = getYouTubeIdFromURL("http://www.youtube.com/watch?v=jhjhkum-kq8&feature=related");
echo $youtube_id;
// jhjhkum-kq8
?>
<script src="http://www.yvoschaap.com/ytpage/ytembed.js"> </script>
<div id="ytThumbs"></div>
<script>
ytEmbed.init({'block':'ytThumbs','key':'AIzaSyCnlDLEaKgx77brKXcyATdUwAAWuPM5_84','q':'gravity','type':'search','results':3,'meta':true,'player':'embed','layout':'full'});
</script>