| Server IP : 49.231.201.246 / Your IP : 216.73.216.149 Web Server : Apache/2.4.18 (Ubuntu) System : Linux 246 4.4.0-210-generic #242-Ubuntu SMP Fri Apr 16 09:57:56 UTC 2021 x86_64 User : root ( 0) PHP Version : 7.0.33-0ubuntu0.16.04.16 Disable Function : exec,passthru,shell_exec,system,proc_open,popen,pcntl_exec MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /var/www/html/old/plugins/editors/jckeditor/plugins/jtreelink/dialogs/ |
Upload File : |
<?php
/*------------------------------------------------------------------------
# Copyright (C) 2005-2012 WebxSolution Ltd. All Rights Reserved.
# @license - GPLv2.0
# Author: WebxSolution Ltd
# Websites: http://www.webxsolution.com
# Terms of Use: An extension that is derived from the JoomlaCK editor will only be allowed under the following conditions: http://joomlackeditor.com/terms-of-use
# ------------------------------------------------------------------------*/
require_once(JPATH_CONFIGURATION.DS.'components'.DS.'com_content'.DS.'helpers'.DS.'route.php');
require_once('nodes.php');
defined( '_JEXEC' ) or die( 'Restricted access' );
class contentLinkNodes extends linkNodes
{
public function __construct()
{
parent::__construct();
}
public function getItems()
{
return $this->_getItems16();
}
private function _getItems16()
{
$db = JFactory::getDBO();
$sectionid = (int) JRequest::getVar('sectionid',0);
$catid = (int) JRequest::getVar('catid',0);
$user = JFactory::getUser();
$groups = implode(',', $user->getAuthorisedViewLevels());
$query = '';
if($sectionid || $catid)
{
$section_catid = $sectionid + $catid;
$query = '
SELECT c.title AS name,0 AS sectionid,c.id AS catid, 0 AS id,
1 AS expandible,
1 as selectable,
0 as doc_icon,
"category" AS type
FROM #__categories s
INNER JOIN #__categories c ON c.parent_id = s.id
WHERE s.id = '. $section_catid .'
AND c.published = 1 AND c.extension = "com_content"
AND c.access IN ('.$groups.')
UNION
SELECT title AS name,0 AS sectionid,catid,id,
0 AS expandible,
1 as selectable,
1 as doc_icon,
"article" AS type
FROM #__content WHERE catid=' . $section_catid .
' And state = 1
AND access IN ('.$groups.')'; //filter access level
}
else
{
$query = 'SELECT s.title AS name,s.id AS catid,0 AS sectionid, 0 AS id,
1 AS expandible,
1 as selectable,
0 as doc_icon,
"category" AS type
FROM #__categories s
WHERE EXISTS (select 1 FROM #__categories c WHERE c.parent_id = s.id)
AND s.published = 1 AND s.extension = "com_content" AND s.parent_id = 1
AND s.access IN ('.$groups.')
UNION
SELECT s.title AS name,s.id AS catid,0 AS sectionid, 0 AS id,
1 AS expandible,
1 as selectable,
0 as doc_icon,
"category" AS type
FROM #__categories s
WHERE EXISTS (select 1 FROM #__content i WHERE i.catid = s.id)
AND s.published = 1 AND s.extension = "com_content" AND s.parent_id = 1
AND s.access IN ('.$groups.')
UNION
SELECT DISTINCT s.title AS name,s.id AS catid,0 AS sectionid, 0 AS id,
0 AS expandible,
1 as selectable,
1 as doc_icon,
"category" AS type
FROM #__categories s
LEFT JOIN #__content i ON i.catid = s.id
LEFT JOIN #__categories c ON c.parent_id = s.id
WHERE s.published = 1 AND i.id IS NULL AND c.id IS NULL
AND s.extension = "com_content" AND s.parent_id = 1
AND s.access IN ('.$groups.')';
}
$db->setQuery($query);
$nodeList = $db->loadObjectList();
//var_dump($db->stderr(true),$nodeList);
//die();
return $nodeList;
}
public function getLoadLink($node)
{
$config = JFactory::getConfig();
$config->set('live_site','');
return JURI::root() . 'links.php?sectionid='.$node->sectionid.'&catid='.$node->catid. '&extension=content';
}
public function getUrl($node)
{
return $this->_getUrl16($node);
}
private function _getUrl16($node)
{
$url = '';
switch($node->type)
{
case 'article' :
$url = str_replace('&','&',ContentHelperRoute::getArticleRoute($node->id,$node->catid));
break;
case 'category':
$url = str_replace('&','&', ContentHelperRoute::getCategoryRoute($node->catid));
break;
}
return $url;
}
}
?>