:~Spade Mini Shell~:

Spade
Mini Shell
Directory:~$ /home/lmsyaran/public_html/joomla4/
Current File:~$ /home/lmsyaran/public_html/joomla4/rsticketsprocontent.zip
PKRI�[�#o,,
index.htmlnu�[���<html><body
bgcolor="#FFFFFF"></body></html>PKRI�[���ddrsticketsprocontent.phpnu�[���<?php
/**
 * @package    RSTickets! Pro
 *
 * @copyright  (c) 2010 - 2016 RSJoomla!
 * @link       https://www.rsjoomla.com
 * @license    GNU General Public License
http://www.gnu.org/licenses/gpl-3.0.en.html
 */

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

class plgSearchRsticketsprocontent extends JPlugin
{
	/**
	 * Load the language file on instantiation.
	 *
	 * @var    boolean
	 * @since  3.1
	 */
	protected $autoloadLanguage = true;
	
	/**
	 * @return array An array of search areas
	 */
	public function onContentSearchAreas() {
		static $areas = array(
			'rsticketsprocontent' => 'Knowledgebase'
		);
		return $areas;
	}
	
	/**
	 * Contacts Search method
	 *
	 * The sql must return the following fields that are used in a common
display
	 * routine: href, title, section, created, text, browsernav
	 *
	 * @param string Target search string
	 * @param string matching option, exact|any|all
	 * @param string ordering option, newest|oldest|popular|alpha|category
	 */
	public function onContentSearch($text, $phrase = '', $ordering =
'', $areas = null) {
		if
(!file_exists(JPATH_ADMINISTRATOR.'/components/com_rsticketspro/helpers/rsticketspro.php'))
			return false;
			
		require_once
JPATH_ADMINISTRATOR.'/components/com_rsticketspro/helpers/rsticketspro.php';
		
		if (is_array($areas)) {
			if (!array_intersect($areas,
array_keys($this->onContentSearchAreas()))) {
				return array();
			}
		}
		
		$db			= JFactory::getDbo();
		$query		= $db->getQuery(true);
		$searchText = $text;
		$text		= trim($text);
		$results	= array();

		if ($text == '') {
			return array();
		}
		
		$limit			= $this->params->def('search_limit', 50);
		$uncategorised	=
$this->params->def('search_uncategorised', 1);
		$itemid			= $this->params->def('Itemid',0);
		$itemid			= $itemid ? '&Itemid='.$itemid : '';
		
		$query->select($db->qn('a.id'))
			->select($db->qn('a.category_id'))
			->select($db->qn('a.name','title'))
			->select($db->qn('a.created'))->select($db->qn('a.text'))
			->select($db->qn('c.name','section'))
			->from($db->qn('#__rsticketspro_kb_content','a'))
			->join('LEFT',$db->qn('#__rsticketspro_kb_categories','c').'
ON '.$db->qn('a.category_id').' =
'.$db->qn('c.id'))
			->where($db->qn('a.published').' =
'.$db->q(1));
		
		if (!RSTicketsProHelper::isStaff()) {
			$query->where($db->qn('a.private').' =
'.$db->q(0));
		}
		
		if (!$uncategorised) {
			$query->where($db->qn('a.category_id').' >
'.$db->q(0));
		}
		
		switch ($phrase) {
			case 'exact':
				$text = $db->q('%' . $db->escape($text, true) .
'%', false);
				$query->where('('.$db->qn('a.name').'
LIKE '.$text.' OR '.$db->qn('a.text').'
LIKE '.$text.')');
				break;

			case 'all':
			case 'any':
			default:
				$words	= explode(' ', $text);
				$wheres	= array();
				
				foreach ($words as $word) {
					$word = $db->q('%' . $db->escape($word, true) .
'%', false);
					$wheres2   = array();
					$wheres2[] = $db->qn('a.name').' LIKE ' .
$word;
					$wheres2[] = $db->qn('a.text').' LIKE ' .
$word;
					$wheres[]  = implode(' OR ', $wheres2);
				}
				
				$where = '(' . implode(($phrase == 'all' ? ')
AND (' : ') OR ('), $wheres) . ')';
				$query->where($where);
				break;
		}

		switch ($ordering) {
			case 'oldest':
				$query->order($db->qn('a.created').'  ASC');
			break;

			case 'alpha':
				$query->order($db->qn('a.name').'  ASC');
			break;

			case 'category':
				$query->order($db->qn('section').'  ASC');
			break;

			case 'newest':
			default:
				$query->order($db->qn('a.created').' 
DESC');
			break;
		}

		$db->setQuery($query, 0, $limit);
		if ($rows = $db->loadObjectList()) {
			foreach ($rows as $i => $row) {
				$row->href			=
JRoute::_('index.php?option=com_rsticketspro&view=article&cid='.$row->id.':'.JFilterOutput::stringURLSafe($row->title).$itemid);
				$row->browsernav	= 2;
				$row->created		= $row->created;
				
				if (!$row->category_id && $uncategorised)
					$row->section = JText::_('Uncategorised Content');
				
				$results[] = $row;
			}
		}
		
		return $results;
	}
}PKRI�[8��JJrsticketsprocontent.xmlnu�[���<?xml
version="1.0" encoding="utf-8"?>
<extension method="upgrade" version="2.5"
type="plugin" group="search">
	<name>plg_search_rsticketsprocontent</name>
	<author>RSJoomla!</author>
	<creationDate>February 2014</creationDate>
	<copyright>Copyright (C) 2010-2014 www.rsjoomla.com. All rights
reserved.</copyright>
	<license>GNU General Public License</license>
	<authorEmail>support@rsjoomla.com</authorEmail>
	<authorUrl>www.rsjoomla.com</authorUrl>
	<version>1.0.0</version>
	<description>RST_SEARCH_KB_DESC</description>
	
	<files>
		<filename
plugin="rsticketsprocontent">rsticketsprocontent.php</filename>
		<filename>index.html</filename>
	</files>
	
	<languages>
		<language
tag="en-GB">language/en-GB/en-GB.plg_search_rsticketsprocontent.ini</language>
		<language
tag="en-GB">language/en-GB/en-GB.plg_search_rsticketsprocontent.sys.ini</language>
	</languages>
	
	<config>
		<fields name="params">
			<fieldset name="basic">
				<field name="Itemid" type="text"
size="5" default="" label="RST_SEARCH_ITEMID"
description="RST_SEARCH_ITEMID_DESC"/>
				<field name="search_limit" type="text"
size="5" default="50"
label="RST_SEARCH_LIMIT"
description="RST_SEARCH_LIMIT_DESC"/>
				<field name="@spacer" type="spacer"
default="" label="" description="" />
				<field name="search_uncategorised" type="radio"
class="btn-group btn-group-yesno" default="1"
label="RST_SEARCH_UNCATEGORISED"
description="RST_SEARCH_UNCATEGORISED_DESC">
					<option value="0">JNO</option>
					<option value="1">JYES</option>
				</field>
			</fieldset>
		</fields>
	</config>
</extension>PKRI�[�#o,,
index.htmlnu�[���PKRI�[���ddfrsticketsprocontent.phpnu�[���PKRI�[8��JJrsticketsprocontent.xmlnu�[���PK��