Server : LiteSpeed System : Linux server 3.10.0-1160.90.1.el7.x86_64 #1 SMP Thu May 4 15:21:22 UTC 2023 x86_64 User : alsaif ( 1057) PHP Version : 7.4.33 Disable Function : show_source,posix_kill,posix_mkfifo,posix_getpwuid,posix_setpgid,posix_setsid,posix_setuid,posix_setgid,posix_seteuid,posix_setegid,posix_uname Directory :  /home/alsaif/domains/alsaif.group/private_html/components/com_allvideoshare/models/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

<?php
/*
 * @version		$Id: video.php 3.5.0 2020-01-25 $
 * @package		All Video Share
 * @copyright   Copyright (C) 2012-2020 MrVinoth
 * @license     GNU/GPL http://www.gnu.org/licenses/gpl-2.0.html
*/

// no direct access
defined( '_JEXEC' ) or die( 'Restricted access' );

class AllVideoShareModelVideo extends AllVideoShareModel {
	
	public function getItem() {
	
		$app = JFactory::getApplication();
        $db = JFactory::getDBO();
		 
        $query = "SELECT v.*, c.name as category FROM #__allvideoshare_videos AS v";
		$query.= " LEFT JOIN #__allvideoshare_categories AS c ON v.catid=c.id";
		 
		if ( $app->input->getInt( 'id' ) ) {
		 	$query .= " WHERE v.id=" . $app->input->getInt( 'id' );
		} else {		 
		 	$slug = AllVideoShareUtils::getSlug();
		 	$query .= " WHERE v.slug=" . $db->Quote( $slug );
		}
		
        $db->setQuery( $query );
        $item = $db->loadObject();
		 
        return $item;
		 
	}
	
	public function getVideos( $item, $params, $limit ) {
	
		$app = JFactory::getApplication();
		$db = JFactory::getDBO();
		 
		$limit = $app->getUserStateFromRequest( 'global.list.limit', 'limit', $limit, 'int' );
		$limitstart = $app->input->get( 'limitstart', '0', 'INT' );
		$limitstart = ( $limit != 0 ? ( floor( $limitstart / $limit ) * $limit ) : 0 );
 
		$this->setState( 'limit', $limit );
		$this->setState( 'limitstart', $limitstart );
		 
		$slug = AllVideoShareUtils::getSlug();
        $query = "SELECT * FROM #__allvideoshare_videos WHERE published=1 AND slug!=" . $db->Quote( $slug );
		 
		$or = array();		
		$or[] = 'catid=' . $item->catid .' OR catids LIKE ' . $db->Quote( '% ' . $item->catid . ' %' );
		if ( $item->catids ) {
			$catids = explode( ' ', trim( $item->catids ) );			
			foreach ( $catids as $catid ) {
				$or[] = 'catid=' . $catid . ' OR catids LIKE ' . $db->Quote( '% ' . $catid . ' %' );
			}
		}
		$query.= ' AND (' . implode( ' OR ', $or ) . ')';

		if ( 'featured' == $params->get( 'orderby' ) || 1 == $params->get( 'featured', 0 ) ) {
			$query .= " AND featured=1";
		}
		
		switch ( $params->get( 'orderby' ) ) {
		 	case 'latest' :
		 		$query .= " ORDER BY id DESC";
				break;
			case 'latest_by_date' :
		 		$query .= " ORDER BY created_date DESC";
				break;
			case 'popular' :
				$query .= " ORDER BY views DESC";
				break;
			case 'random' :
				$query .= " ORDER BY RAND()";
				break;
			default :
				$query .= " ORDER BY ordering";
		}
		 
        $db->setQuery( $query, $limitstart, $limit );
        $items = $db->loadObjectList();
		 
        return $items;
		
	}
	
	public function getTotal( $item, $params ) {
	
		$db = JFactory::getDBO();
		 
		$slug = AllVideoShareUtils::getSlug();
		$query = "SELECT COUNT(id) FROM #__allvideoshare_videos WHERE published=1 AND slug!=" . $db->Quote( $slug );
		
		$or = array();		
		$or[] = 'catid=' . $item->catid .' OR catids LIKE ' . $db->Quote( '% ' . $item->catid . ' %' );
		if ( $item->catids ) {
			$catids = explode( ' ', trim( $item->catids ) );			
			foreach ( $catids as $catid ) {
				$or[] = 'catid=' . $catid . ' OR catids LIKE ' . $db->Quote( '% ' . $catid . ' %' );
			}
		}
		$query.= ' AND (' . implode( ' OR ', $or ) . ')';
		
		if ( 'featured' == $params->get( 'orderby' ) || 1 == $params->get( 'featured', 0 ) ) {
			$query .= " AND featured=1";
		}
		
        $db->setQuery( $query );
        $total = $db->loadResult();
		 
        return $total;
		
	}
	
	public function getVideosPagination( $item, $params ) {
	
    	jimport( 'joomla.html.pagination' );
		$pagination = new JPagination( $this->getTotal( $item, $params ), $this->getState( 'limitstart' ), $this->getState( 'limit' ) );
		 
        return $pagination;
		 
	}
		
}