Ejemplo n.º 1
0
    /**
     * Generates the human readable allowed video formats string
     *
     * @return       $code
     */
	function generateVideoDetails($row, $player_width=null, $player_height=null, $thumb_width=null, $hwdvsItemid=null, $tooltip=null, $lightbox=null, $autoplay=null)
	{
		global $hwdvsItemid, $option, $mainframe, $smartyvs;
		$c = hwd_vs_Config::get_instance();
		$my = & JFactory::getUser();

		if (!isset($row->username)) { $row->username = ""; }
		if (!isset($row->name)) { $row->name = ""; }
		if (!isset($row->avatar)) { $row->avatar = null; }
		if ($c->cbint == 3) { $row->avatar = $row->username; }

		$quality = JRequest::getWord( 'quality', '' );
		if (empty($quality))
		{
			if ($c->usehq == "1" || $c->usehq == "3")
			{
				$quality = "hd";
			}
			else if ($c->usehq == "0" || $c->usehq == "2")
			{
				$quality = "sd";
			}
		}

		$details->id = intval($row->id);
		$details->titleText = stripslashes($row->title);
		$details->title = hwd_vs_tools::generateVideoLink( $row->id, $row->title, $hwdvsItemid, null, 10000 );
		$details->player = hwd_vs_tools::generateVideoPlayer($row, $player_width, $player_height, $autoplay, $quality);
		$details->videourl = hwd_vs_tools::generateVideoUrl($row);
		$details->embedcode = hwd_vs_tools::generateEmbedCode($row);
		$details->socialbmlinks = hwd_vs_tools::generateSocialBookmarks();
		$details->duration = $row->video_length;
		$details->ratingsystem = hwd_vs_tools::generateRatingSystem($row);
		$details->favouritebutton = hwd_vs_tools::generateFavouriteButton($row);
		$details->thumbnail = hwd_vs_tools::generateVideoThumbnailLink($row->id, $row->video_id, $row->video_type, $row->thumbnail, 0, $thumb_width, null, null, null, $hwdvsItemid, null, $tooltip, $lightbox);
		$details->avatar = hwd_vs_tools::generateAvatar($row->user_id, $row->avatar, 0);
		$details->category = hwd_vs_tools::generateCategoryLink($row->category_id);
		$details->description_truncated = hwd_vs_tools::truncateText($row->description, $c->trunvdesc);
		$details->rating = hwd_vs_tools::generateRatingImg($row->updated_rating);
		$details->deletevideo = hwd_vs_tools::generateDeleteVideoLink($row);
		$details->editvideo = hwd_vs_tools::generateEditVideoLink($row);
		$details->publishvideo = hwd_vs_tools::generatePublishVideoLink($row);
		$details->approvevideo = hwd_vs_tools::generateApproveVideoLink($row);
		$details->views = intval($row->number_of_views);
		$details->upload_date = strftime("%l%P - %b %e, %Y", strtotime($row->date_uploaded));
		$details->sendToFriend = hwd_vs_tools::sendToFriend($row);
		$details->uploader = hwd_vs_tools::generateUserFromID($row->user_id, $row->username, $row->name);
		$details->k = 0;

		$details->addtogroup = hwd_vs_tools::generateAddToGroupButton($row);
		$details->nextprev = hwd_vs_tools::generateNextPrevLinks($row);
		$details->switchquality = hwd_vs_tools::generateSwitchQuality($row);
		$details->downloadoriginal = hwd_vs_tools::generateDownloadVideoLink($row);
		$details->vieworiginal = hwd_vs_tools::generateViewOriginalLink($row);
		$details->reportmedia = hwd_vs_tools::generateReportMediaButton($row);
		$details->tags = hwd_vs_tools::generateTagListString($row->tags);
		$details->favourties = hwd_vs_tools::generateFavouriteButton($row);
		$details->addtoplaylist = hwd_vs_tools::generateAddToPlaylistButton($row);

		if ($option == "com_hwdvideoshare")
		{
			$details->comments = hwd_vs_tools::generateVideoComments($row);
		}

		if ($c->showdesc == "1")
		{
			$smartyvs->assign("print_description", 1);
			$details->description = stripslashes($row->description);

			//$item                 = JTable::getInstance('content');
			//$dispatcher           = JDispatcher::getInstance();
			//$params               = new JParameter('');
			//JPluginHelper::importPlugin('content');
			//$item->parameters     = new JParameter('');
			//$item->text           = $details->description;
			//// Apply content plugins to custom text
			//$results              = $dispatcher->trigger('onPrepareContent', array ($item, $params, 0));
			//$details->description = $item->text;
		}
		return $details;
    }
Ejemplo n.º 2
0
    /**
     * Outputs frontpage HTML
     *
     * @return       Nothing
     */
	function viewChannel()
	{
		global $smartyvs, $mainframe, $mosConfig_live_site, $limitstart, $Itemid, $hwdvs_joinv, $hwdvs_selectv, $hwdvs_joing, $hwdvs_selectg;
		$c = hwd_vs_Config::get_instance();
		$db = & JFactory::getDBO();
		$my = & JFactory::getUser();
		$acl= & JFactory::getACL();
		$usersConfig = &JComponentHelper::getParams( 'com_users' );

		$user_id = JRequest::getInt( 'user_id', 0, 'request' );
		$sort = JRequest::getWord( 'sort', 'none', 'request' );

		$db->SetQuery( 'SELECT count(*) FROM #__hwdvidschannels WHERE user_id = '.$user_id );
  		$channel_exists = $db->loadResult();

		if ( $channel_exists == 0 && $user_id == $my->id && $sort == "none" )
		{
			$mainframe->redirect( JURI::root() . 'index.php?option=com_hwdvideoshare&task=createChannel&Itemid='.$Itemid );
		}

		if ( $channel_exists == 0)
		{
			$db->SetQuery( 'SELECT username FROM #__users WHERE id = '.$user_id );
			$username = $db->loadResult();

			if (!isset($username) || empty($username))
			{
				$smartyvs->assign("showconnectionbox", 0);
				hwd_vs_tools::infomessage(4, 0, _HWDVIDS_TITLE_NOACCESS, "This channel does not exist", "exclamation.png", 0);
				return;
			}

			$smartyvs->assign("channelExists", null);
			$channel->user_id = $user_id;
		}
		else
		{
			$smartyvs->assign("channelExists", 1);

			$query = 'SELECT * FROM #__hwdvidschannels WHERE user_id = '.$user_id;
			$db->SetQuery($query);
			$channel = $db->loadObject();

			$channel->views++;
			$db->SetQuery("UPDATE #__hwdvidschannels SET views = $channel->views WHERE id = $channel->id");
			$db->Query();

			$query = 'SELECT registerDate, lastvisitDate FROM #__users WHERE id = '.$channel->user_id;
			$db->SetQuery($query);
			$channelUser = $db->loadObject();

			$channel->registerDate = $channelUser->registerDate;
			$channel->lastvisitDate = $channelUser->lastvisitDate;

			$query = 'SELECT count(*) FROM #__hwdvidssubs WHERE memberid = '.$channel->user_id;
			$db->SetQuery($query);
			$channel->subscribers = $db->loadResult();

			$query = 'SELECT count(*) FROM #__hwdvidsvideos WHERE user_id = '.$channel->user_id;
			$db->SetQuery($query);
			$channel->uploads = $db->loadResult();

			if ($c->cbavatar == "2" && $c->cbint !== "5")
			{
				$channel->thumbnail = hwd_vs_tools::generateAvatar($channel->user_id, null, 0);
			}
			else
			{
				if (file_exists(JPATH_SITE.DS."hwdvideos".DS."thumbs".DS.$channel->channel_thumbnail))
				{
					$channel->thumbnail = JURI::root()."hwdvideos/thumbs/".$channel->channel_thumbnail;
				}
				else
				{
					$channel->thumbnail = null;
				}
			}
		}

		jimport('joomla.html.pagination');
		switch ($sort)
		{
			case "uploads":
			case "none":

				$limit     = intval($c->vpp);

				$where = ' WHERE video.published = 1';
				$where .= ' AND video.approved = "yes"';
				$where .= ' AND video.user_id = '.$channel->user_id;

				$db->SetQuery( "SELECT count(*) FROM #__hwdvidsvideos AS video $hwdvs_joinv $where" );
				$total = $db->loadResult();

				$pageNav = new JPagination( $total, $limitstart, $limit );

				$query = 'SELECT'.$hwdvs_selectv
						. ' FROM #__hwdvidsvideos AS video'
						. $hwdvs_joinv
						. ' LEFT JOIN #__hwdvidscategories AS `access` ON access.id = video.category_id'
						. $where
						. ' ORDER BY video.date_uploaded DESC'
						;
				$db->SetQuery($query, $pageNav->limitstart, $pageNav->limit);
				$rows = $db->loadObjectList();

				$smartyvs->assign("title", "Uploads");
				$smartyvs->assign("select_uploads", "selected=\"selected\"");
				$type = "videos";

			break;
			case "favourites":

				$limit     = intval($c->vpp);

				$where = ' WHERE video.approved = "yes"';
				$where .= ' AND video.published = 1';
				$where .= ' AND f.userid = '.$channel->user_id;

				$db->SetQuery( "SELECT count(*) FROM #__hwdvidsvideos AS video $hwdvs_joinv LEFT JOIN #__hwdvidsfavorites AS f ON video.id = f.videoid $where" );
				$total = $db->loadResult();

				$pageNav = new JPagination( $total, $limitstart, $limit );

				$query = 'SELECT'.$hwdvs_selectv
						. ' FROM #__hwdvidsvideos AS video'
						. $hwdvs_joinv
						. ' LEFT JOIN #__hwdvidsfavorites AS f ON video.id = f.videoid'
						. $where
						. ' ORDER BY video.date_uploaded DESC'
						;
				$db->SetQuery($query, $pageNav->limitstart, $pageNav->limit);
				$rows = $db->loadObjectList();

				$smartyvs->assign("title", "Favourite Videos");
				$smartyvs->assign("select_favourites", "selected=\"selected\"");
				$type = "videos";

			break;
			case "viewed":

				$limit     = intval($c->vpp);

				$where = ' WHERE video.approved = "yes"';
				$where .= ' AND video.published = 1';
				$where .= ' AND f.userid = '.$channel->user_id;

				$db->SetQuery( "SELECT count(*) FROM #__hwdvidsvideos AS video $hwdvs_joinv LEFT JOIN #__hwdvidslogs_views AS f ON video.id = f.videoid $where" );
				$total = $db->loadResult();

				$pageNav = new JPagination( $total, $limitstart, $limit );

				$query = 'SELECT'.$hwdvs_selectv
						. ' FROM #__hwdvidsvideos AS video'
						. $hwdvs_joinv
						. ' LEFT JOIN #__hwdvidslogs_views AS f ON video.id = f.videoid'
						. $where
						. ' ORDER BY f.date DESC'
						;
				$db->SetQuery($query, $pageNav->limitstart, $pageNav->limit);
				$rows = $db->loadObjectList();

				$smartyvs->assign("title", "Recently Viewed");
				$smartyvs->assign("select_viewed", "selected=\"selected\"");
				$type = "videos";

			break;
			case "liked":

				$limit     = intval($c->vpp);

				$where = ' WHERE video.approved = "yes"';
				$where .= ' AND video.published = 1';
				$where .= ' AND f.userid = '.$channel->user_id;
				$where .= ' AND f.vote > 3';

				$db->SetQuery( "SELECT count(*) FROM #__hwdvidsvideos AS video $hwdvs_joinv LEFT JOIN #__hwdvidslogs_votes AS f ON video.id = f.videoid $where" );
				$total = $db->loadResult();

				$pageNav = new JPagination( $total, $limitstart, $limit );

				$query = 'SELECT'.$hwdvs_selectv
						. ' FROM #__hwdvidsvideos AS video'
						. $hwdvs_joinv
						. ' LEFT JOIN #__hwdvidslogs_votes AS f ON video.id = f.videoid'
						. $where
						. ' ORDER BY f.date DESC'
						;
				$db->SetQuery($query, $pageNav->limitstart, $pageNav->limit);
				$rows = $db->loadObjectList();

				$smartyvs->assign("title", "Recently Liked Videos");
				$smartyvs->assign("select_liked", "selected=\"selected\"");
				$type = "videos";

			break;
			case "disliked":

				$limit     = intval($c->vpp);

				$where = ' WHERE video.approved = "yes"';
				$where .= ' AND video.published = 1';
				$where .= ' AND f.userid = '.$channel->user_id;
				$where .= ' AND f.vote < 3';

				$db->SetQuery( "SELECT count(*) FROM #__hwdvidsvideos AS video $hwdvs_joinv LEFT JOIN #__hwdvidslogs_votes AS f ON video.id = f.videoid $where" );
				$total = $db->loadResult();

				$pageNav = new JPagination( $total, $limitstart, $limit );

				$query = 'SELECT'.$hwdvs_selectv
						. ' FROM #__hwdvidsvideos AS video'
						. $hwdvs_joinv
						. ' LEFT JOIN #__hwdvidslogs_votes AS f ON video.id = f.videoid'
						. $where
						. ' ORDER BY f.date DESC'
						;
				$db->SetQuery($query, $pageNav->limitstart, $pageNav->limit);
				$rows = $db->loadObjectList();

				$smartyvs->assign("title", "Recently Disliked Videos");
				$smartyvs->assign("select_disliked", "selected=\"selected\"");
				$type = "videos";

			break;
			case "groups":

				$limit     = intval($c->gpp);

				$where = ' WHERE g.adminid = '.$user_id;
				$where .= ' AND g.published = 1';

				$db->SetQuery( "SELECT count(*) FROM #__hwdvidsgroups AS g $where" );
				$total = $db->loadResult();

				$pageNav = new JPagination( $total, $limitstart, $limit );

				$query = 'SELECT'.$hwdvs_selectg
						. ' FROM #__hwdvidsgroups AS g'
						. $hwdvs_joing
						. $where
						. ' ORDER BY g.date DESC'
						;
				$db->SetQuery($query, $pageNav->limitstart, $pageNav->limit);
				$rows = $db->loadObjectList();

				$smartyvs->assign("title", "Groups");
				$smartyvs->assign("select_groups", "selected=\"selected\"");
				$type = "groups";

			break;
			case "playlists":

				$limit     = intval($c->gpp);

				$where = ' WHERE pl.published = 1';
				$where.= ' AND pl.user_id = '.$user_id;

				$db->SetQuery( "SELECT count(*) FROM #__hwdvidsplaylists AS pl $where" );
				$total = $db->loadResult();

				$pageNav = new JPagination( $total, $limitstart, $limit );

				$query = 'SELECT * FROM #__hwdvidsplaylists AS pl'
						. $where
						. ' ORDER BY pl.date_created DESC'
						;
				$db->SetQuery($query, $pageNav->limitstart, $pageNav->limit);
				$rows = $db->loadObjectList();

				$smartyvs->assign("title", "Playlists");
				$smartyvs->assign("select_playlists", "selected=\"selected\"");
				$type = "playlists";

			break;
			case "memberships":

				$limit     = intval($c->gpp);

				$where = ' WHERE m.approved = 1';
				$where.= ' AND m.memberid = '.$user_id;
				$where.= ' AND g.published = 1';

				$db->SetQuery( "SELECT count(*) FROM #__hwdvidsgroup_membership AS m LEFT JOIN #__hwdvidsgroups AS g ON m.groupid = g.id $where" );
				$total = $db->loadResult();

				$pageNav = new JPagination( $total, $limitstart, $limit );

				$query = 'SELECT'.$hwdvs_selectg
						. ' FROM #__hwdvidsgroup_membership AS m'
						. ' LEFT JOIN #__hwdvidsgroups AS g ON m.groupid = g.id'
						. $hwdvs_joing
						. $where
						. ' ORDER BY m.date DESC'
						;
				$db->SetQuery($query, $pageNav->limitstart, $pageNav->limit);
				$rows = $db->loadObjectList();

				$smartyvs->assign("title", "Group Memberships");
				$smartyvs->assign("select_memberships", "selected=\"selected\"");
				$type = "groups";

			break;
			case "subscriptions":

				$smartyvs->assign("title", "Subscriptions");
				$smartyvs->assign("select_subscriptions", "selected=\"selected\"");
				$type = "subscriptions";

			break;
		}

        ////////////////////

		$where = ' WHERE video.approved = "yes"';
		$where .= ' AND video.published = 1';
		$where .= ' AND f.userid = '.$channel->user_id;

		$query = 'SELECT'.$hwdvs_selectv
               	. ' FROM #__hwdvidsvideos AS video'
				. $hwdvs_joinv
				. ' LEFT JOIN #__hwdvidsfavorites AS f ON video.id = f.videoid'
				. $where
				. ' ORDER BY video.date_uploaded DESC'
				. ' LIMIT 0, 5'
				;

		$db->SetQuery($query);
		$rows_favourites = $db->loadObjectList();

        ////////////////////

		$where = ' WHERE video.approved = "yes"';
		$where .= ' AND video.published = 1';
		$where .= ' AND f.userid = '.$channel->user_id;

		$query = 'SELECT'.$hwdvs_selectv
               	. ' FROM #__hwdvidsvideos AS video'
				. $hwdvs_joinv
				. ' LEFT JOIN #__hwdvidslogs_views AS f ON video.id = f.videoid'
				. $where
				. ' ORDER BY f.date DESC'
				. ' LIMIT 0, 5'
				;

		$db->SetQuery($query);
		$rows_recentlyviewed = $db->loadObjectList();

        ////////////////////

		hwd_vs_html::viewChannel($channel, $rows, $type, $pageNav, $total, $rows_favourites, $rows_recentlyviewed);
	}