/** * 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; }
/** * 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); }