Файловый менеджер

Файловый менеджер - Редактировать - /home/wuectly/www/03cbe/search.zip

Назад
PK��qq!]o��newsfeeds/newsfeeds.phpnu�&1i��<?php /* * @package Joomla.Plugin * @subpackage Search.newsfeeds * * @copyright (C) 2006 Open Source Matters, Inc. <https://www.joomla.org> * @license GNU General Public License version 2 or later; see LICENSE.txt / defined('_JEXEC') or die; /* * Newsfeeds search plugin. * * @since 1.6 / class PlgSearchNewsfeeds extends JPlugin { /* * Load the language file on instantiation. * * @var boolean * @since 3.1 / protected $autoloadLanguage = true; /* * Determine areas searchable by this plugin. * * @return array An array of search areas. * * @since 1.6 / public function onContentSearchAreas() { static $areas = array( 'newsfeeds' => 'PLG_SEARCH_NEWSFEEDS_NEWSFEEDS' ); return $areas; } /* * Search content (newsfeeds). * * The SQL must return the following fields that are used in a common display * routine: href, title, section, created, text, browsernav. * * @param string $text Target search string. * @param string $phrase Matching option (possible values: exact\|any\|all). Default is "any". * @param string $ordering Ordering option (possible values: newest\|oldest\|popular\|alpha\|category). Default is "newest". * @param mixed $areas An array if the search it to be restricted to areas or null to search all areas. * * @return array Search results. * * @since 1.6 / public function onContentSearch($text, $phrase = '', $ordering = '', $areas = null) { $db = JFactory::getDbo(); $app = JFactory::getApplication(); $user = JFactory::getUser(); $groups = implode(',', $user->getAuthorisedViewLevels()); if (is_array($areas) && !array_intersect($areas, array_keys($this->onContentSearchAreas()))) { return array(); } $sContent = $this->params->get('search_content', 1); $sArchived = $this->params->get('search_archived', 1); $limit = $this->params->def('search_limit', 50); $state = array(); if ($sContent) { $state[] = 1; } if ($sArchived) { $state[] = 2; } if (empty($state)) { return array(); } $text = trim($text); if ($text === '') { return array(); } switch ($phrase) { case 'exact': $text = $db->quote('%' . $db->escape($text, true) . '%', false); $wheres2 = array(); $wheres2[] = 'a.name LIKE ' . $text; $wheres2[] = 'a.link LIKE ' . $text; $where = '(' . implode(') OR (', $wheres2) . ')'; break; case 'all': case 'any': default: $words = explode(' ', $text); $wheres = array(); foreach ($words as $word) { $word = $db->quote('%' . $db->escape($word, true) . '%', false); $wheres2 = array(); $wheres2[] = 'a.name LIKE ' . $word; $wheres2[] = 'a.link LIKE ' . $word; $wheres[] = implode(' OR ', $wheres2); } $where = '(' . implode(($phrase === 'all' ? ') AND (' : ') OR ('), $wheres) . ')'; break; } switch ($ordering) { case 'alpha': $order = 'a.name ASC'; break; case 'category': $order = 'c.title ASC, a.name ASC'; break; case 'oldest': case 'popular': case 'newest': default: $order = 'a.name ASC'; } $searchNewsfeeds = JText::_('PLG_SEARCH_NEWSFEEDS_NEWSFEEDS'); $query = $db->getQuery(true); // SQLSRV changes. $case_when = ' CASE WHEN '; $case_when .= $query->charLength('a.alias', '!=', '0'); $case_when .= ' THEN '; $a_id = $query->castAsChar('a.id'); $case_when .= $query->concatenate(array($a_id, 'a.alias'), ':'); $case_when .= ' ELSE '; $case_when .= $a_id . ' END as slug'; $case_when1 = ' CASE WHEN '; $case_when1 .= $query->charLength('c.alias', '!=', '0'); $case_when1 .= ' THEN '; $c_id = $query->castAsChar('c.id'); $case_when1 .= $query->concatenate(array($c_id, 'c.alias'), ':'); $case_when1 .= ' ELSE '; $case_when1 .= $c_id . ' END as catslug'; $query->select('a.name AS title, \'\' AS created, a.link AS text, ' . $case_when . ',' . $case_when1) ->select($query->concatenate(array($db->quote($searchNewsfeeds), 'c.title'), ' / ') . ' AS section') ->select('\'1\' AS browsernav') ->from('#__newsfeeds AS a') ->join('INNER', '#__categories as c ON c.id = a.catid') ->where('(' . $where . ') AND a.published IN (' . implode(',', $state) . ') AND c.published = 1 AND c.access IN (' . $groups . ')') ->order($order); // Filter by language. if ($app->isClient('site') && JLanguageMultilang::isEnabled()) { $tag = JFactory::getLanguage()->getTag(); $query->where('a.language in (' . $db->quote($tag) . ',' . $db->quote('') . ')') ->where('c.language in (' . $db->quote($tag) . ',' . $db->quote('') . ')'); } $db->setQuery($query, 0, $limit); try { $rows = $db->loadObjectList(); } catch (RuntimeException $e) { $rows = array(); JFactory::getApplication()->enqueueMessage(JText::_('JERROR_AN_ERROR_HAS_OCCURRED'), 'error'); } if ($rows) { foreach ($rows as $key => $row) { $rows[$key]->href = 'index.php?option=com_newsfeeds&view=newsfeed&catid=' . $row->catslug . '&id=' . $row->slug; } } return $rows; } } PK��qq!]T��newsfeeds/newsfeeds.xmlnu�&1i��<?xml version="1.0" encoding="utf-8"?> <extension version="3.1" type="plugin" group="search" method="upgrade"> <name>plg_search_newsfeeds</name> <author>Joomla! Project</author> <creationDate>November 2005</creationDate> <copyright>(C) 2005 Open Source Matters, Inc.</copyright> <license>GNU General Public License version 2 or later; see LICENSE.txt</license> <authorEmail>admin@joomla.org</authorEmail> <authorUrl>www.joomla.org</authorUrl> <version>3.0.0</version> <description>PLG_SEARCH_NEWSFEEDS_XML_DESCRIPTION</description> <files> <filename plugin="newsfeeds">newsfeeds.php</filename> </files> <languages> <language tag="en-GB">en-GB.plg_search_newsfeeds.ini</language> <language tag="en-GB">en-GB.plg_search_newsfeeds.sys.ini</language> </languages> <config> <fields name="params"> <fieldset name="basic"> <field name="search_limit" type="number" label="JFIELD_PLG_SEARCH_SEARCHLIMIT_LABEL" description="JFIELD_PLG_SEARCH_SEARCHLIMIT_DESC" default="50" filter="integer" size="5" /> <field name="search_content" type="radio" label="JFIELD_PLG_SEARCH_ALL_LABEL" description="JFIELD_PLG_SEARCH_ALL_DESC" class="btn-group btn-group-yesno" default="0" filter="integer" > <option value="1">JYES</option> <option value="0">JNO</option> </field> <field name="search_archived" type="radio" label="JFIELD_PLG_SEARCH_ARCHIVED_LABEL" description="JFIELD_PLG_SEARCH_ARCHIVED_DESC" class="btn-group btn-group-yesno" default="0" filter="integer" > <option value="1">JON</option> <option value="0">JOFF</option> </field> </fieldset> </fields> </config> </extension> PK��qq!]�8�� tags/tags.phpnu�&1i��<?php /* * @package Joomla.Plugin * @subpackage Search.tags * * @copyright (C) 2014 Open Source Matters, Inc. <https://www.joomla.org> * @license GNU General Public License version 2 or later; see LICENSE.txt / defined('_JEXEC') or die; /* * Tags search plugin. * * @since 3.3 / class PlgSearchTags extends JPlugin { /* * Load the language file on instantiation. * * @var boolean * @since 3.3 / protected $autoloadLanguage = true; /* * Determine areas searchable by this plugin. * * @return array An array of search areas. * * @since 3.3 / public function onContentSearchAreas() { static $areas = array( 'tags' => 'PLG_SEARCH_TAGS_TAGS' ); return $areas; } /* * Search content (tags). * * The SQL must return the following fields that are used in a common display * routine: href, title, section, created, text, browsernav. * * @param string $text Target search string. * @param string $phrase Matching option (possible values: exact\|any\|all). Default is "any". * @param string $ordering Ordering option (possible values: newest\|oldest\|popular\|alpha\|category). Default is "newest". * @param string $areas An array if the search is to be restricted to areas or null to search all areas. * * @return array Search results. * * @since 3.3 / public function onContentSearch($text, $phrase = '', $ordering = '', $areas = null) { $db = JFactory::getDbo(); $query = $db->getQuery(true); $app = JFactory::getApplication(); $user = JFactory::getUser(); $lang = JFactory::getLanguage(); $section = JText::_('PLG_SEARCH_TAGS_TAGS'); $limit = $this->params->def('search_limit', 50); if (is_array($areas) && !array_intersect($areas, array_keys($this->onContentSearchAreas()))) { return array(); } $text = trim($text); if ($text === '') { return array(); } $text = $db->quote('%' . $db->escape($text, true) . '%', false); switch ($ordering) { case 'alpha': $order = 'a.title ASC'; break; case 'newest': $order = 'a.created_time DESC'; break; case 'oldest': $order = 'a.created_time ASC'; break; case 'popular': default: $order = 'a.title DESC'; } $query->select('a.id, a.title, a.alias, a.note, a.published, a.access' . ', a.checked_out, a.checked_out_time, a.created_user_id' . ', a.path, a.parent_id, a.level, a.lft, a.rgt' . ', a.language, a.created_time AS created, a.description'); $case_when_item_alias = ' CASE WHEN '; $case_when_item_alias .= $query->charLength('a.alias', '!=', '0'); $case_when_item_alias .= ' THEN '; $a_id = $query->castAsChar('a.id'); $case_when_item_alias .= $query->concatenate(array($a_id, 'a.alias'), ':'); $case_when_item_alias .= ' ELSE '; $case_when_item_alias .= $a_id . ' END as slug'; $query->select($case_when_item_alias); $query->from('#__tags AS a'); $query->where('a.alias <> ' . $db->quote('root')); $query->where('(a.title LIKE ' . $text . ' OR a.alias LIKE ' . $text . ')'); $query->where($db->qn('a.published') . ' = 1'); if (!$user->authorise('core.admin')) { $groups = implode(',', $user->getAuthorisedViewLevels()); $query->where('a.access IN (' . $groups . ')'); } if ($app->isClient('site') && JLanguageMultilang::isEnabled()) { $tag = JFactory::getLanguage()->getTag(); $query->where('a.language in (' . $db->quote($tag) . ',' . $db->quote('') . ')'); } $query->order($order); $db->setQuery($query, 0, $limit); try { $rows = $db->loadObjectList(); } catch (RuntimeException $e) { $rows = array(); JFactory::getApplication()->enqueueMessage(JText::_('JERROR_AN_ERROR_HAS_OCCURRED'), 'error'); } if ($rows) { JLoader::register('TagsHelperRoute', JPATH_SITE . '/components/com_tags/helpers/route.php'); foreach ($rows as $key => $row) { $rows[$key]->href = TagsHelperRoute::getTagRoute($row->slug); $rows[$key]->text = ($row->description !== '' ? $row->description : $row->title); $rows[$key]->text .= $row->note; $rows[$key]->section = $section; $rows[$key]->created = $row->created; $rows[$key]->browsernav = 0; } } if (!$this->params->get('show_tagged_items', 0)) { return $rows; } else { $final_items = $rows; JModelLegacy::addIncludePath(JPATH_SITE . '/components/com_tags/models'); $tag_model = JModelLegacy::getInstance('Tag', 'TagsModel'); $tag_model->getState(); foreach ($rows as $key => $row) { $tag_model->setState('tag.id', $row->id); $tagged_items = $tag_model->getItems(); if ($tagged_items) { foreach ($tagged_items as $k => $item) { // For 3rd party extensions we need to load the component strings from its sys.ini file $parts = explode('.', $item->type_alias); $comp = array_shift($parts); $lang->load($comp, JPATH_SITE, null, false, true) \|\| $lang->load($comp, JPATH_SITE . '/components/' . $comp, null, false, true); // Making up the type string $type = implode('_', $parts); $type = $comp . '_CONTENT_TYPE_' . $type; $new_item = new stdClass; $new_item->href = $item->link; $new_item->title = $item->core_title; $new_item->text = $item->core_body; if ($lang->hasKey($type)) { $new_item->section = JText::sprintf('PLG_SEARCH_TAGS_ITEM_TAGGED_WITH', JText::_($type), $row->title); } else { $new_item->section = JText::sprintf('PLG_SEARCH_TAGS_ITEM_TAGGED_WITH', $item->content_type_title, $row->title); } $new_item->created = $item->displayDate; $new_item->browsernav = 0; $final_items[] = $new_item; } } } return $final_items; } } } PK��qq!]�$?B�� tags/tags.xmlnu�&1i��<?xml version="1.0" encoding="utf-8"?> <extension version="3.1" type="plugin" group="search" method="upgrade"> <name>plg_search_tags</name> <author>Joomla! Project</author> <creationDate>March 2014</creationDate> <copyright>(C) 2014 Open Source Matters, Inc.</copyright> <license>GNU General Public License version 2 or later; see LICENSE.txt</license> <authorEmail>admin@joomla.org</authorEmail> <authorUrl>www.joomla.org</authorUrl> <version>3.0.0</version> <description>PLG_SEARCH_TAGS_XML_DESCRIPTION</description> <files> <filename plugin="tags">tags.php</filename> </files> <languages> <language tag="en-GB">en-GB.plg_search_tags.ini</language> <language tag="en-GB">en-GB.plg_search_tags.sys.ini</language> </languages> <config> <fields name="params"> <fieldset name="basic"> <field name="search_limit" type="number" label="JFIELD_PLG_SEARCH_SEARCHLIMIT_LABEL" description="JFIELD_PLG_SEARCH_SEARCHLIMIT_DESC" default="50" filter="integer" size="5" /> <field name="show_tagged_items" type="radio" label="PLG_SEARCH_TAGS_FIELD_SHOW_TAGGED_ITEMS_LABEL" description="PLG_SEARCH_TAGS_FIELD_SHOW_TAGGED_ITEMS_DESC" class="btn-group btn-group-yesno" default="0" filter="integer" > <option value="1">JYES</option> <option value="0">JNO</option> </field> </fieldset> </fields> </config> </extension> PK��qq!]��ֆ��content/content.xmlnu�&1i��<?xml version="1.0" encoding="utf-8"?> <extension version="3.1" type="plugin" group="search" method="upgrade"> <name>plg_search_content</name> <author>Joomla! Project</author> <creationDate>November 2005</creationDate> <copyright>(C) 2005 Open Source Matters, Inc.</copyright> <license>GNU General Public License version 2 or later; see LICENSE.txt</license> <authorEmail>admin@joomla.org</authorEmail> <authorUrl>www.joomla.org</authorUrl> <version>3.0.0</version> <description>PLG_SEARCH_CONTENT_XML_DESCRIPTION</description> <files> <filename plugin="content">content.php</filename> </files> <languages> <language tag="en-GB">en-GB.plg_search_content.ini</language> <language tag="en-GB">en-GB.plg_search_content.sys.ini</language> </languages> <config> <fields name="params"> <fieldset name="basic"> <field name="search_limit" type="number" label="PLG_SEARCH_CONTENT_FIELD_SEARCHLIMIT_LABEL" description="PLG_SEARCH_CONTENT_FIELD_SEARCHLIMIT_DESC" default="50" filter="integer" size="5" /> <field name="search_content" type="radio" label="PLG_SEARCH_CONTENT_FIELD_CONTENT_LABEL" description="PLG_SEARCH_CONTENT_FIELD_CONTENT_DESC" class="btn-group btn-group-yesno" default="1" filter="integer" > <option value="1">JYES</option> <option value="0">JNO</option> </field> <field name="search_archived" type="radio" label="PLG_SEARCH_CONTENT_FIELD_ARCHIVED_LABEL" description="PLG_SEARCH_CONTENT_FIELD_ARCHIVED_DESC" class="btn-group btn-group-yesno" default="1" filter="integer" > <option value="1">JYES</option> <option value="0">JNO</option> </field> </fieldset> </fields> </config> </extension> PK��qq!] �~�4��4��content/content.phpnu�&1i��<?php /** * @package Joomla.Plugin * @subpackage Search.content * * @copyright (C) 2006 Open Source Matters, Inc. <https://www.joomla.org> * @license GNU General Public License version 2 or later; see LICENSE.txt / defined('_JEXEC') or die; /* * Content search plugin. * * @since 1.6 / class PlgSearchContent extends JPlugin { /* * Determine areas searchable by this plugin. * * @return array An array of search areas. * * @since 1.6 / public function onContentSearchAreas() { static $areas = array( 'content' => 'JGLOBAL_ARTICLES' ); return $areas; } /* * Search content (articles). * The SQL must return the following fields that are used in a common display * routine: href, title, section, created, text, browsernav. * * @param string $text Target search string. * @param string $phrase Matching option (possible values: exact\|any\|all). Default is "any". * @param string $ordering Ordering option (possible values: newest\|oldest\|popular\|alpha\|category). Default is "newest". * @param mixed $areas An array if the search it to be restricted to areas or null to search all areas. * * @return array Search results. * * @since 1.6 / public function onContentSearch($text, $phrase = '', $ordering = '', $areas = null) { $db = JFactory::getDbo(); $serverType = $db->getServerType(); $app = JFactory::getApplication(); $user = JFactory::getUser(); $groups = implode(',', $user->getAuthorisedViewLevels()); $tag = JFactory::getLanguage()->getTag(); JLoader::register('ContentHelperRoute', JPATH_SITE . '/components/com_content/helpers/route.php'); JLoader::register('SearchHelper', JPATH_ADMINISTRATOR . '/components/com_search/helpers/search.php'); $searchText = $text; if (is_array($areas) && !array_intersect($areas, array_keys($this->onContentSearchAreas()))) { return array(); } $sContent = $this->params->get('search_content', 1); $sArchived = $this->params->get('search_archived', 1); $limit = $this->params->def('search_limit', 50); $nullDate = $db->getNullDate(); $date = JFactory::getDate(); $now = $date->toSql(); $text = trim($text); if ($text === '') { return array(); } switch ($phrase) { case 'exact': $text = $db->quote('%' . $db->escape($text, true) . '%', false); $wheres2 = array(); $wheres2[] = 'a.title LIKE ' . $text; $wheres2[] = 'a.introtext LIKE ' . $text; $wheres2[] = 'a.fulltext LIKE ' . $text; $wheres2[] = 'a.metakey LIKE ' . $text; $wheres2[] = 'a.metadesc LIKE ' . $text; $relevance[] = ' CASE WHEN ' . $wheres2[0] . ' THEN 5 ELSE 0 END '; // Join over Fields. $subQuery = $db->getQuery(true); $subQuery->select("cfv.item_id") ->from("#__fields_values AS cfv") ->join('LEFT', '#__fields AS f ON f.id = cfv.field_id') ->where('(f.context IS NULL OR f.context = ' . $db->q('com_content.article') . ')') ->where('(f.state IS NULL OR f.state = 1)') ->where('(f.access IS NULL OR f.access IN (' . $groups . '))') ->where('cfv.value LIKE ' . $text); // Filter by language. if ($app->isClient('site') && JLanguageMultilang::isEnabled()) { $subQuery->where('(f.language IS NULL OR f.language in (' . $db->quote($tag) . ',' . $db->quote('') . '))'); } if ($serverType == "mysql") { /* This generates a dependent sub-query so do no use in MySQL prior to version 6.0 ! * $wheres2[] = 'a.id IN( '. (string) $subQuery.')'; / $db->setQuery($subQuery); $fieldids = $db->loadColumn(); if (count($fieldids)) { $wheres2[] = 'a.id IN(' . implode(",", $fieldids) . ')'; } } else { $wheres2[] = $subQuery->castAsChar('a.id') . ' IN( ' . (string) $subQuery . ')'; } $where = '(' . implode(') OR (', $wheres2) . ')'; break; case 'all': case 'any': default: $words = explode(' ', $text); $wheres = array(); $cfwhere = array(); foreach ($words as $word) { $word = $db->quote('%' . $db->escape($word, true) . '%', false); $wheres2 = array(); $wheres2[] = 'LOWER(a.title) LIKE LOWER(' . $word . ')'; $wheres2[] = 'LOWER(a.introtext) LIKE LOWER(' . $word . ')'; $wheres2[] = 'LOWER(a.fulltext) LIKE LOWER(' . $word . ')'; $wheres2[] = 'LOWER(a.metakey) LIKE LOWER(' . $word . ')'; $wheres2[] = 'LOWER(a.metadesc) LIKE LOWER(' . $word . ')'; $relevance[] = ' CASE WHEN ' . $wheres2[0] . ' THEN 5 ELSE 0 END '; if ($phrase === 'all') { // Join over Fields. $subQuery = $db->getQuery(true); $subQuery->select("cfv.item_id") ->from("#__fields_values AS cfv") ->join('LEFT', '#__fields AS f ON f.id = cfv.field_id') ->where('(f.context IS NULL OR f.context = ' . $db->q('com_content.article') . ')') ->where('(f.state IS NULL OR f.state = 1)') ->where('(f.access IS NULL OR f.access IN (' . $groups . '))') ->where('LOWER(cfv.value) LIKE LOWER(' . $word . ')'); // Filter by language. if ($app->isClient('site') && JLanguageMultilang::isEnabled()) { $subQuery->where('(f.language IS NULL OR f.language in (' . $db->quote($tag) . ',' . $db->quote('') . '))'); } if ($serverType == "mysql") { $db->setQuery($subQuery); $fieldids = $db->loadColumn(); if (count($fieldids)) { $wheres2[] = 'a.id IN(' . implode(",", $fieldids) . ')'; } } else { $wheres2[] = $subQuery->castAsChar('a.id') . ' IN( ' . (string) $subQuery . ')'; } } else { $cfwhere[] = 'LOWER(cfv.value) LIKE LOWER(' . $word . ')'; } $wheres[] = implode(' OR ', $wheres2); } if ($phrase === 'any') { // Join over Fields. $subQuery = $db->getQuery(true); $subQuery->select("cfv.item_id") ->from("#__fields_values AS cfv") ->join('LEFT', '#__fields AS f ON f.id = cfv.field_id') ->where('(f.context IS NULL OR f.context = ' . $db->q('com_content.article') . ')') ->where('(f.state IS NULL OR f.state = 1)') ->where('(f.access IS NULL OR f.access IN (' . $groups . '))') ->where('(' . implode(($phrase === 'all' ? ') AND (' : ') OR ('), $cfwhere) . ')'); // Filter by language. if ($app->isClient('site') && JLanguageMultilang::isEnabled()) { $subQuery->where('(f.language IS NULL OR f.language in (' . $db->quote($tag) . ',' . $db->quote('') . '))'); } if ($serverType == "mysql") { $db->setQuery($subQuery); $fieldids = $db->loadColumn(); if (count($fieldids)) { $wheres[] = 'a.id IN(' . implode(",", $fieldids) . ')'; } } else { $wheres[] = $subQuery->castAsChar('a.id') . ' IN( ' . (string) $subQuery . ')'; } } $where = '(' . implode(($phrase === 'all' ? ') AND (' : ') OR ('), $wheres) . ')'; break; } switch ($ordering) { case 'oldest': $order = 'a.created ASC'; break; case 'popular': $order = 'a.hits DESC'; break; case 'alpha': $order = 'a.title ASC'; break; case 'category': $order = 'c.title ASC, a.title ASC'; break; case 'newest': default: $order = 'a.created DESC'; break; } $rows = array(); $query = $db->getQuery(true); // Search articles. if ($sContent && $limit > 0) { $query->clear(); // SQLSRV changes. $case_when = ' CASE WHEN '; $case_when .= $query->charLength('a.alias', '!=', '0'); $case_when .= ' THEN '; $a_id = $query->castAsChar('a.id'); $case_when .= $query->concatenate(array($a_id, 'a.alias'), ':'); $case_when .= ' ELSE '; $case_when .= $a_id . ' END as slug'; $case_when1 = ' CASE WHEN '; $case_when1 .= $query->charLength('c.alias', '!=', '0'); $case_when1 .= ' THEN '; $c_id = $query->castAsChar('c.id'); $case_when1 .= $query->concatenate(array($c_id, 'c.alias'), ':'); $case_when1 .= ' ELSE '; $case_when1 .= $c_id . ' END as catslug'; if (!empty($relevance)) { $query->select(implode(' + ', $relevance) . ' AS relevance'); $order = ' relevance DESC, ' . $order; } $query->select('a.title AS title, a.metadesc, a.metakey, a.created AS created, a.language, a.catid') ->select($query->concatenate(array('a.introtext', 'a.fulltext')) . ' AS text') ->select('c.title AS section, ' . $case_when . ',' . $case_when1 . ', ' . '\'2\' AS browsernav') ->from('#__content AS a') ->join('INNER', '#__categories AS c ON c.id=a.catid') ->where( '(' . $where . ') AND a.state=1 AND c.published = 1 AND a.access IN (' . $groups . ') ' . 'AND c.access IN (' . $groups . ')' . 'AND (a.publish_up = ' . $db->quote($nullDate) . ' OR a.publish_up <= ' . $db->quote($now) . ') ' . 'AND (a.publish_down = ' . $db->quote($nullDate) . ' OR a.publish_down >= ' . $db->quote($now) . ')' ) ->group('a.id, a.title, a.metadesc, a.metakey, a.created, a.language, a.catid, a.introtext, a.fulltext, c.title, a.alias, c.alias, c.id') ->order($order); // Filter by language. if ($app->isClient('site') && JLanguageMultilang::isEnabled()) { $query->where('a.language in (' . $db->quote($tag) . ',' . $db->quote('') . ')') ->where('c.language in (' . $db->quote($tag) . ',' . $db->quote('') . ')'); } $db->setQuery($query, 0, $limit); try { $list = $db->loadObjectList(); } catch (RuntimeException $e) { $list = array(); JFactory::getApplication()->enqueueMessage(JText::_('JERROR_AN_ERROR_HAS_OCCURRED'), 'error'); } $limit -= count($list); if (isset($list)) { foreach ($list as $key => $item) { $list[$key]->href = ContentHelperRoute::getArticleRoute($item->slug, $item->catid, $item->language); } } $rows[] = $list; } // Search archived content. if ($sArchived && $limit > 0) { $query->clear(); // SQLSRV changes. $case_when = ' CASE WHEN '; $case_when .= $query->charLength('a.alias', '!=', '0'); $case_when .= ' THEN '; $a_id = $query->castAsChar('a.id'); $case_when .= $query->concatenate(array($a_id, 'a.alias'), ':'); $case_when .= ' ELSE '; $case_when .= $a_id . ' END as slug'; $case_when1 = ' CASE WHEN '; $case_when1 .= $query->charLength('c.alias', '!=', '0'); $case_when1 .= ' THEN '; $c_id = $query->castAsChar('c.id'); $case_when1 .= $query->concatenate(array($c_id, 'c.alias'), ':'); $case_when1 .= ' ELSE '; $case_when1 .= $c_id . ' END as catslug'; if (!empty($relevance)) { $query->select(implode(' + ', $relevance) . ' AS relevance'); $order = ' relevance DESC, ' . $order; } $query->select('a.title AS title, a.metadesc, a.metakey, a.created AS created, a.language, a.catid') ->select($query->concatenate(array('a.introtext', 'a.fulltext')) . ' AS text') ->select('c.title AS section, ' . $case_when . ',' . $case_when1 . ', ' . '\'2\' AS browsernav') ->from('#__content AS a') ->join('INNER', '#__categories AS c ON c.id=a.catid AND c.access IN (' . $groups . ')') ->where( '(' . $where . ') AND a.state = 2 AND c.published = 1 AND a.access IN (' . $groups . ') AND c.access IN (' . $groups . ') ' . 'AND (a.publish_up = ' . $db->quote($nullDate) . ' OR a.publish_up <= ' . $db->quote($now) . ') ' . 'AND (a.publish_down = ' . $db->quote($nullDate) . ' OR a.publish_down >= ' . $db->quote($now) . ')' ) ->order($order); // Join over Fields is no longer needed // Filter by language. if ($app->isClient('site') && JLanguageMultilang::isEnabled()) { $query->where('a.language in (' . $db->quote($tag) . ',' . $db->quote('') . ')') ->where('c.language in (' . $db->quote($tag) . ',' . $db->quote('') . ')'); } $db->setQuery($query, 0, $limit); try { $list3 = $db->loadObjectList(); } catch (RuntimeException $e) { $list3 = array(); JFactory::getApplication()->enqueueMessage(JText::_('JERROR_AN_ERROR_HAS_OCCURRED'), 'error'); } if (isset($list3)) { foreach ($list3 as $key => $item) { $list3[$key]->href = ContentHelperRoute::getArticleRoute($item->slug, $item->catid, $item->language); } } $rows[] = $list3; } $results = array(); if (count($rows)) { foreach ($rows as $row) { $new_row = array(); foreach ($row as $article) { // Not efficient to get these ONE article at a TIME // Lookup field values so they can be checked, GROUP_CONCAT would work in above queries, but isn't supported by non-MySQL DBs. $query = $db->getQuery(true); $query->select('fv.value') ->from('#__fields_values as fv') ->join('left', '#__fields as f on fv.field_id = f.id') ->where('f.context = ' . $db->quote('com_content.article')) ->where('fv.item_id = ' . $db->quote((int) $article->slug)); $db->setQuery($query); $article->jcfields = implode(',', $db->loadColumn()); if (SearchHelper::checkNoHtml($article, $searchText, array('text', 'title', 'jcfields', 'metadesc', 'metakey'))) { $new_row[] = $article; } } $results = array_merge($results, (array) $new_row); } } return $results; } } PK��qq!]�i��categories/categories.phpnu�&1i��<?php /* * @package Joomla.Plugin * @subpackage Search.categories * * @copyright (C) 2006 Open Source Matters, Inc. <https://www.joomla.org> * @license GNU General Public License version 2 or later; see LICENSE.txt / defined('_JEXEC') or die; JLoader::register('ContentHelperRoute', JPATH_SITE . '/components/com_content/helpers/route.php'); /* * Categories search plugin. * * @since 1.6 / class PlgSearchCategories extends JPlugin { /* * Load the language file on instantiation. * * @var boolean * @since 3.1 / protected $autoloadLanguage = true; /* * Determine areas searchable by this plugin. * * @return array An array of search areas. * * @since 1.6 / public function onContentSearchAreas() { static $areas = array( 'categories' => 'PLG_SEARCH_CATEGORIES_CATEGORIES' ); return $areas; } /* * Search content (categories). * * The SQL must return the following fields that are used in a common display * routine: href, title, section, created, text, browsernav. * * @param string $text Target search string. * @param string $phrase Matching option (possible values: exact\|any\|all). Default is "any". * @param string $ordering Ordering option (possible values: newest\|oldest\|popular\|alpha\|category). Default is "newest". * @param mixed $areas An array if the search is to be restricted to areas or null to search all areas. * * @return array Search results. * * @since 1.6 / public function onContentSearch($text, $phrase = '', $ordering = '', $areas = null) { $db = JFactory::getDbo(); $user = JFactory::getUser(); $app = JFactory::getApplication(); $groups = implode(',', $user->getAuthorisedViewLevels()); $searchText = $text; if (is_array($areas) && !array_intersect($areas, array_keys($this->onContentSearchAreas()))) { return array(); } $sContent = $this->params->get('search_content', 1); $sArchived = $this->params->get('search_archived', 1); $limit = $this->params->def('search_limit', 50); $state = array(); if ($sContent) { $state[] = 1; } if ($sArchived) { $state[] = 2; } if (empty($state)) { return array(); } $text = trim($text); if ($text === '') { return array(); } / TODO: The $where variable does not seem to be used at all switch ($phrase) { case 'exact': $text = $db->quote('%' . $db->escape($text, true) . '%', false); $wheres2 = array(); $wheres2[] = 'a.title LIKE ' . $text; $wheres2[] = 'a.description LIKE ' . $text; $where = '(' . implode(') OR (', $wheres2) . ')'; break; case 'any': case 'all'; default: $words = explode(' ', $text); $wheres = array(); foreach ($words as $word) { $word = $db->quote('%' . $db->escape($word, true) . '%', false); $wheres2 = array(); $wheres2[] = 'a.title LIKE ' . $word; $wheres2[] = 'a.description LIKE ' . $word; $wheres[] = implode(' OR ', $wheres2); } $where = '(' . implode(($phrase == 'all' ? ') AND (' : ') OR ('), $wheres) . ')'; break; } / switch ($ordering) { case 'alpha': $order = 'a.title ASC'; break; case 'category': case 'popular': case 'newest': case 'oldest': default: $order = 'a.title DESC'; } $text = $db->quote('%' . $db->escape($text, true) . '%', false); $query = $db->getQuery(true); // SQLSRV changes. $case_when = ' CASE WHEN '; $case_when .= $query->charLength('a.alias', '!=', '0'); $case_when .= ' THEN '; $a_id = $query->castAsChar('a.id'); $case_when .= $query->concatenate(array($a_id, 'a.alias'), ':'); $case_when .= ' ELSE '; $case_when .= $a_id . ' END as slug'; $query->select('a.title, a.description AS text, a.created_time AS created, \'2\' AS browsernav, a.id AS catid, ' . $case_when) ->from('#__categories AS a') ->where( '(a.title LIKE ' . $text . ' OR a.description LIKE ' . $text . ') AND a.published IN (' . implode(',', $state) . ') AND a.extension = ' . $db->quote('com_content') . 'AND a.access IN (' . $groups . ')' ) ->group('a.id, a.title, a.description, a.alias, a.created_time') ->order($order); if ($app->isClient('site') && JLanguageMultilang::isEnabled()) { $query->where('a.language in (' . $db->quote(JFactory::getLanguage()->getTag()) . ',' . $db->quote('') . ')'); } $db->setQuery($query, 0, $limit); try { $rows = $db->loadObjectList(); } catch (RuntimeException $e) { $rows = array(); JFactory::getApplication()->enqueueMessage(JText::_('JERROR_AN_ERROR_HAS_OCCURRED'), 'error'); } $return = array(); if ($rows) { foreach ($rows as $i => $row) { if (searchHelper::checkNoHtml($row, $searchText, array('name', 'title', 'text'))) { $row->href = ContentHelperRoute::getCategoryRoute($row->slug); $row->section = JText::_('JCATEGORY'); $return[] = $row; } } } return $return; } } PK��qq!]6\}��categories/categories.xmlnu�&1i��<?xml version="1.0" encoding="utf-8"?> <extension version="3.1" type="plugin" group="search" method="upgrade"> <name>plg_search_categories</name> <author>Joomla! Project</author> <creationDate>November 2005</creationDate> <copyright>(C) 2005 Open Source Matters, Inc.</copyright> <license>GNU General Public License version 2 or later; see LICENSE.txt</license> <authorEmail>admin@joomla.org</authorEmail> <authorUrl>www.joomla.org</authorUrl> <version>3.0.0</version> <description>PLG_SEARCH_CATEGORIES_XML_DESCRIPTION</description> <files> <filename plugin="categories">categories.php</filename> </files> <languages> <language tag="en-GB">en-GB.plg_search_categories.ini</language> <language tag="en-GB">en-GB.plg_search_categories.sys.ini</language> </languages> <config> <fields name="params"> <fieldset name="basic"> <field name="search_limit" type="number" label="JFIELD_PLG_SEARCH_SEARCHLIMIT_LABEL" description="JFIELD_PLG_SEARCH_SEARCHLIMIT_DESC" default="50" filter="integer" size="5" /> <field name="search_content" type="radio" label="JFIELD_PLG_SEARCH_ALL_LABEL" description="JFIELD_PLG_SEARCH_ALL_DESC" class="btn-group btn-group-yesno" default="0" filter="integer" > <option value="1">JYES</option> <option value="0">JNO</option> </field> <field name="search_archived" type="radio" label="JFIELD_PLG_SEARCH_ARCHIVED_LABEL" description="JFIELD_PLG_SEARCH_ARCHIVED_DESC" class="btn-group btn-group-yesno" default="0" filter="integer" > <option value="1">JYES</option> <option value="0">JNO</option> </field> </fieldset> </fields> </config> </extension> PK��qq!]�V��icagenda/index.htmlnu�&1i��<!DOCTYPE html><title></title> PK��qq!]E�d<-��<-��icagenda/icagenda.phpnu�&1i��<?php /** * Plugin Search - iCagenda :: Search ---------------------------------------------------------------------------- @package com_icagenda * @copyright Copyright (c)2012-2015 Cyril Rezé, Jooml!C - All rights reserved * @license GNU General Public License version 3 or later; see LICENSE.txt * @author Cyril Rezé (Lyr!C) * @link http://www.joomlic.com * * @update 3.4.2 2015-01-31 * @version 1.4 * * This program is free software: you can redistribute it and/or modify * it under the terms of the GNU General Public License as published by * the Free Software Foundation, either version 3 of the License, or * (at your option) any later version. * * This program is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * GNU General Public License for more details. * * You should have received a copy of the GNU General Public License * along with this program. If not, see <http://www.gnu.org/licenses/>. ---------------------------------------------------------------------------- / // No direct access to this file defined('_JEXEC') or die( 'Restricted access' ); // Require the component's router file require_once JPATH_SITE . '/components/com_icagenda/router.php'; /** * All functions need to get wrapped in class PlgSearchiCagenda / class PlgSearchiCagenda extends JPlugin { /* * Constructor * * @access protected * @param object $subject The object to observe * @param array $config An array that holds the plugin configuration * @since 1.0 / public function __construct(& $subject, $config) { parent::__construct($subject, $config); $this->loadLanguage(); } // Define a function to return an array of search areas. // Note the value of the array key is normally a language string function onContentSearchAreas() { $search_name = $this->params->get('search_name', JText::_('ICAGENDA_PLG_SEARCH_SECTION_EVENTS') ); if ($search_name == 'ICAGENDA_PLG_SEARCH_SECTION_EVENTS') $search_name = 'Events'; return array('icagenda' => $search_name); } // The real function has to be created. The database connection should be made. // The function will be closed with an } at the end of the file. /* * 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 mathcing option, exact\|any\|all * @param string ordering option, newest\|oldest\|popular\|alpha\|category * @param mixed An array if the search it to be restricted to areas, null if search all / function onContentSearch( $text, $phrase='', $ordering='', $areas=null ) { $db = JFactory::getDBO(); $app = JFactory::getApplication(); $tag = JFactory::getLanguage()->getTag(); $user = JFactory::getUser(); $groups = implode(',', $user->getAuthorisedViewLevels()); // If the array is not correct, return it: if (is_array( $areas )) { if (!array_intersect( $areas, array_keys( $this->onContentSearchAreas() ) )) { return array(); } } // Now retrieve the plugin parameters $search_name = $this->params->get('search_name', JText::_('ICAGENDA_PLG_SEARCH_SECTION_EVENTS') ); if ($search_name == 'ICAGENDA_PLG_SEARCH_SECTION_EVENTS') $search_name = 'Events'; $search_limit = $this->params->get('search_limit', '50' ); $search_target = $this->params->get('search_target', '0' ); // Use the PHP function trim to delete spaces in front of or at the back of the searching terms $text = trim( $text ); // Return Array when nothing was filled in. if ($text == '') { return array(); } // Database part. $wheres = array(); switch ($phrase) { // Search exact case 'exact': $text = $db->Quote( '%'.$db->escape( $text, true ).'%', false ); $wheres2 = array(); $wheres2[] = 'LOWER(e.title) LIKE '.$text; $wheres2[] = 'LOWER(e.shortdesc) LIKE '.$text; $wheres2[] = 'LOWER(e.desc) LIKE '.$text; $wheres2[] = 'LOWER(e.metadesc) LIKE '.$text; $wheres2[] = 'LOWER(e.place) LIKE '.$text; $wheres2[] = 'LOWER(e.city) LIKE '.$text; $wheres2[] = 'LOWER(e.country) LIKE '.$text; $wheres2[] = 'LOWER(e.address) LIKE '.$text; $wheres2[] = 'LOWER(c.title) LIKE '.$text; $where = '(' . implode( ') OR (', $wheres2 ) . ')'; break; // Search all or any case 'all': case 'any': // Set default default: $words = explode( ' ', $text ); $wheres = array(); foreach ($words as $word) { $word = $db->Quote( '%'.$db->escape( $word, true ).'%', false ); $wheres2 = array(); $wheres2[] = 'LOWER(e.title) LIKE '.$word; $wheres2[] = 'LOWER(e.shortdesc) LIKE '.$word; $wheres2[] = 'LOWER(e.desc) LIKE '.$word; $wheres2[] = 'LOWER(e.metadesc) LIKE '.$word; $wheres2[] = 'LOWER(e.place) LIKE '.$word; $wheres2[] = 'LOWER(e.city) LIKE '.$word; $wheres2[] = 'LOWER(e.country) LIKE '.$word; $wheres2[] = 'LOWER(e.address) LIKE '.$word; $wheres2[] = 'LOWER(c.title) LIKE '.$word; $wheres[] = implode( ' OR ', $wheres2 ); } $where = '(' . implode( ($phrase == 'all' ? ') AND (' : ') OR ('), $wheres ) . ')'; break; } // Ordering of the results switch ( $ordering ) { //Alphabetic, ascending case 'alpha': $order = 'e.title ASC'; break; // Oldest first case 'oldest': $order = 'e.next ASC'; break; // Popular first case 'popular': // Newest first case 'newest': $order = 'e.next DESC'; break; // Category case 'category': $order = 'c.title ASC'; break; // Default setting: alphabetic, ascending default: $order = 'e.title ASC'; } // Section $section = $search_name; // List of Events menu Itemid Request $iC_list_menus = self::iClistMenuItemsInfo(); $nb_menu = count($iC_list_menus); $nolink = $nb_menu ? false : true; // Get User groups allowed to approve event submitted $userID = $user->id; $userLevels = $user->getAuthorisedViewLevels(); if (version_compare(JVERSION, '3.0', 'lt')) { $userGroups = $user->getAuthorisedGroups(); } else { $userGroups = $user->groups; } $groupid = JComponentHelper::getParams('com_icagenda')->get('approvalGroups', array("8")); jimport( 'joomla.access.access' ); $adminUsersArray = array(); foreach ($groupid AS $gp) { $adminUsers = JAccess::getUsersByGroup($gp, false); $adminUsersArray = array_merge($adminUsersArray, $adminUsers); } // The database query; $query = $db->getQuery(true); $query->select('e.title AS title, e.created AS created, e.next AS next, e.displaytime AS displaytime, e.desc AS text, e.id AS eventID, e.alias AS alias, c.id AS catid, e.language AS language'); $query->select($query->concatenate(array($db->Quote($section), 'c.title'), " / ").' AS section'); $query->select('"'.$search_target.'" AS browsernav'); $query->from('#__icagenda_events AS e'); $query->innerJoin('#__icagenda_category as c ON c.id = e.catid'); $query->where('c.state = 1'); // START Hack for Upcoming Filtering // $datetime_today = JHtml::date('now', 'Y-m-d H:i'); // Joomla Time Zone // $query->where('e.next >= ' . $db->q($datetime_today)); // END Hack for Upcoming Filtering $query->where('('. $where .')' . 'AND e.state = 1 AND e.access IN ('. $groups .') '); // if user logged-in has no Approval Rights, not approved events won't be displayed. if (!in_array($userID, $adminUsersArray) AND !in_array('8', $userGroups)) { $query->where(' e.approval <> 1 '); } // Filter by language. if ($app->isSite() && JLanguageMultilang::isEnabled()) { $query->where('e.language in (' . $db->quote($tag) . ',' . $db->quote('') . ')'); } $query->order($order); // Set query $db->setQuery( $query, 0, $search_limit ); $iCevents = $db->loadObjectList(); // $limit -= count($list); // The 'output' of the displayed link. if (isset($iCevents)) { foreach($iCevents as $key => $iCevent) { // set menu link for each event (itemID) depending of category and/or language $onecat = $multicat = '0'; $link_one = $link_multi = ''; $item_catid = $iCevent->catid; $array_menus_cat_not_set = array(); foreach ($iC_list_menus AS $iCm) { $value = explode('-', $iCm); $iCmenu_id = $value['0']; $iCmenu_mcatid = $value['1']; $iCmenu_lang = $value['2']; $iCmenu_mcatid_array = !is_array ($iCmenu_mcatid) ? explode(',', $iCmenu_mcatid) : ''; if ($iCmenu_mcatid && $iCmenu_lang == $iCevent->language) { $nb_cat_filter = count($iCmenu_mcatid_array); for ($i = $iCevent->catid; in_array($i, $iCmenu_mcatid_array); $i++) { if ($nb_cat_filter == 1) { $link_one = $iCmenu_id; } elseif ($nb_cat_filter > 1) { $link_multi = $iCmenu_id; } } } else { array_push($array_menus_cat_not_set, $iCmenu_id); } } if ($link_one) { $linkid = $link_one; } elseif ($link_multi) { $linkid = $link_multi; } else { $linkid = count($array_menus_cat_not_set) ? $array_menus_cat_not_set['0'] : null; } $event_slug = empty($iCevent->alias) ? $iCevent->eventID : $iCevent->eventID . ':' . $iCevent->alias; $date_next = JHtml::date($iCevent->next, JText::_( 'DATE_FORMAT_LC3' ), null); $time_next = JHtml::date($iCevent->next, 'H:i', null); $display_time = $iCevent->displaytime ? ' ' . $time_next : ''; $iCevents[$key]->title = $iCevent->title . ' (' . $date_next . $display_time . ')'; $iCevents[$key]->href = 'index.php?option=com_icagenda&view=list&layout=event&id=' . $event_slug . '&Itemid=' . $linkid; } } // If menu item iCagenda list of events exists, returns events found. if ($nolink) { // Displays a warning that no menu item to the list of events is published. $app->enqueueMessage(JText::_( 'ICAGENDA_PLG_SEARCH_ALERT_NO_ICAGENDA_MENUITEM' ), 'warning'); } else { //Return the search results in an array return $iCevents; } } /** * Function to return all published 'List of Events' menu items * * @access public static * @param none * @return array of menu item info this way : Itemid-mcatid-lang * * @since 1.2 / static public function iClistMenuItemsInfo() { $app = JFactory::getApplication(); // List all menu items linking to list of events $db = JFactory::getDbo(); $query = $db->getQuery(true); $query->select('m.title, m.published, m.id, m.params, m.language') ->from('`#__menu` AS m') ->where( "(link = 'index.php?option=com_icagenda&view=list') AND (published = 1)" ); $db->setQuery($query); $link = $db->loadObjectList(); $iC_list_menus = array(); foreach ($link as $iClistMenu) { $menuitemid = $iClistMenu->id; $menulang = $iClistMenu->language; if ($menuitemid) { $menu = $app->getMenu(); $menuparams = $menu->getParams( $menuitemid ); } $mcatid = $menuparams->get('mcatid'); if (is_array($mcatid)) { $mcatid = implode(',', $mcatid); } array_push($iC_list_menus, $menuitemid . '-' . $mcatid . '-' . $menulang); } return $iC_list_menus; } } PK��qq!]��<��icagenda/icagenda.xmlnu�&1i��<?xml version="1.0" encoding="utf-8"?> <extension version="2.5" type="plugin" group="search" method="upgrade"> <name>ICAGENDA_PLG_SEARCH</name> <creationDate>2015-01-31</creationDate> <author>Jooml!C</author> <authorEmail>info@joomlic.com</authorEmail> <authorUrl>www.joomlic.com</authorUrl> <copyright>Copyright (c)2012-2015 Cyril Rezé, Jooml!C - All rights reserved</copyright> <license>GNU General Public License version 3 or later; see LICENSE.txt</license> <version>1.4</version> <description>ICAGENDA_PLG_SEARCH_XML_DESCRIPTION</description> <files> <filename plugin="icagenda">icagenda.php</filename> <filename>index.html</filename> </files> <languages> <language tag="en-GB">language/en-GB/en-GB.plg_search_icagenda.ini</language> <language tag="en-GB">language/en-GB/en-GB.plg_search_icagenda.sys.ini</language> <language tag="fr-FR">language/fr-FR/fr-FR.plg_search_icagenda.ini</language> <language tag="fr-FR">language/fr-FR/fr-FR.plg_search_icagenda.sys.ini</language> <language tag="it-IT">language/it-IT/it-IT.plg_search_icagenda.ini</language> <language tag="it-IT">language/it-IT/it-IT.plg_search_icagenda.sys.ini</language> </languages> <config> <fields name="params"> <fieldset name="basic"> <field name="search_name" type="text" default="" label="ICAGENDA_PLG_SEARCH_NAME_LABEL" description="ICAGENDA_PLG_SEARCH_NAME_DESC" /> <field name="search_limit" type="text" default="50" label="JFIELD_PLG_SEARCH_SEARCHLIMIT_LABEL" description="JFIELD_PLG_SEARCH_SEARCHLIMIT_DESC" size="5" /> <field name="search_target" type="list" default="0" label="ICAGENDA_PLG_SEARCH_TARGET_LABEL" description="ICAGENDA_PLG_SEARCH_TARGET_DESC" > <option value="0">JBROWSERTARGET_PARENT</option> <option value="1">JBROWSERTARGET_NEW</option> </field> </fieldset> </fields> </config> </extension> PK��qq!]�"(�7��7��contacts/contacts.phpnu�&1i��<?php /* * @package Joomla.Plugin * @subpackage Search.contacts * * @copyright (C) 2006 Open Source Matters, Inc. <https://www.joomla.org> * @license GNU General Public License version 2 or later; see LICENSE.txt / defined('_JEXEC') or die; /* * Contacts search plugin. * * @since 1.6 / class PlgSearchContacts extends JPlugin { /* * Load the language file on instantiation. * * @var boolean * @since 3.1 / protected $autoloadLanguage = true; /* * Determine areas searchable by this plugin. * * @return array An array of search areas. * * @since 1.6 / public function onContentSearchAreas() { static $areas = array( 'contacts' => 'PLG_SEARCH_CONTACTS_CONTACTS' ); return $areas; } /* * Search content (contacts). * * The SQL must return the following fields that are used in a common display * routine: href, title, section, created, text, browsernav. * * @param string $text Target search string. * @param string $phrase Matching option (possible values: exact\|any\|all). Default is "any". * @param string $ordering Ordering option (possible values: newest\|oldest\|popular\|alpha\|category). Default is "newest". * @param string $areas An array if the search is to be restricted to areas or null to search all areas. * * @return array Search results. * * @since 1.6 / public function onContentSearch($text, $phrase = '', $ordering = '', $areas = null) { JLoader::register('ContactHelperRoute', JPATH_SITE . '/components/com_contact/helpers/route.php'); $db = JFactory::getDbo(); $app = JFactory::getApplication(); $user = JFactory::getUser(); $groups = implode(',', $user->getAuthorisedViewLevels()); if (is_array($areas) && !array_intersect($areas, array_keys($this->onContentSearchAreas()))) { return array(); } $sContent = $this->params->get('search_content', 1); $sArchived = $this->params->get('search_archived', 1); $limit = $this->params->def('search_limit', 50); $state = array(); if ($sContent) { $state[] = 1; } if ($sArchived) { $state[] = 2; } if (empty($state)) { return array(); } $text = trim($text); if ($text === '') { return array(); } $section = JText::_('PLG_SEARCH_CONTACTS_CONTACTS'); switch ($ordering) { case 'alpha': $order = 'a.name ASC'; break; case 'category': $order = 'c.title ASC, a.name ASC'; break; case 'popular': case 'newest': case 'oldest': default: $order = 'a.name DESC'; } $text = $db->quote('%' . $db->escape($text, true) . '%', false); $query = $db->getQuery(true); // SQLSRV changes. $case_when = ' CASE WHEN '; $case_when .= $query->charLength('a.alias', '!=', '0'); $case_when .= ' THEN '; $a_id = $query->castAsChar('a.id'); $case_when .= $query->concatenate(array($a_id, 'a.alias'), ':'); $case_when .= ' ELSE '; $case_when .= $a_id . ' END as slug'; $case_when1 = ' CASE WHEN '; $case_when1 .= $query->charLength('c.alias', '!=', '0'); $case_when1 .= ' THEN '; $c_id = $query->castAsChar('c.id'); $case_when1 .= $query->concatenate(array($c_id, 'c.alias'), ':'); $case_when1 .= ' ELSE '; $case_when1 .= $c_id . ' END as catslug'; $query->select( 'a.name AS title, \'\' AS created, a.con_position, a.misc, ' . $case_when . ',' . $case_when1 . ', ' . $query->concatenate(array('a.name', 'a.con_position', 'a.misc'), ',') . ' AS text,' . $query->concatenate(array($db->quote($section), 'c.title'), ' / ') . ' AS section,' . '\'2\' AS browsernav' ); $query->from('#__contact_details AS a') ->join('INNER', '#__categories AS c ON c.id = a.catid') ->where( '(a.name LIKE ' . $text . ' OR a.misc LIKE ' . $text . ' OR a.con_position LIKE ' . $text . ' OR a.address LIKE ' . $text . ' OR a.suburb LIKE ' . $text . ' OR a.state LIKE ' . $text . ' OR a.country LIKE ' . $text . ' OR a.postcode LIKE ' . $text . ' OR a.telephone LIKE ' . $text . ' OR a.fax LIKE ' . $text . ') AND a.published IN (' . implode(',', $state) . ') AND c.published=1 ' . ' AND a.access IN (' . $groups . ') AND c.access IN (' . $groups . ')' ) ->order($order); // Filter by language. if ($app->isClient('site') && JLanguageMultilang::isEnabled()) { $tag = JFactory::getLanguage()->getTag(); $query->where('a.language in (' . $db->quote($tag) . ',' . $db->quote('') . ')') ->where('c.language in (' . $db->quote($tag) . ',' . $db->quote('') . ')'); } $db->setQuery($query, 0, $limit); try { $rows = $db->loadObjectList(); } catch (RuntimeException $e) { $rows = array(); JFactory::getApplication()->enqueueMessage(JText::_('JERROR_AN_ERROR_HAS_OCCURRED'), 'error'); } if ($rows) { foreach ($rows as $key => $row) { $rows[$key]->href = ContactHelperRoute::getContactRoute($row->slug, $row->catslug); $rows[$key]->text = $row->title; $rows[$key]->text .= $row->con_position ? ', ' . $row->con_position : ''; $rows[$key]->text .= $row->misc ? ', ' . $row->misc : ''; } } return $rows; } } PK��qq!]f ��contacts/contacts.xmlnu�&1i��<?xml version="1.0" encoding="utf-8"?> <extension version="3.1" type="plugin" group="search" method="upgrade"> <name>plg_search_contacts</name> <author>Joomla! Project</author> <creationDate>November 2005</creationDate> <copyright>(C) 2005 Open Source Matters, Inc.</copyright> <license>GNU General Public License version 2 or later; see LICENSE.txt</license> <authorEmail>admin@joomla.org</authorEmail> <authorUrl>www.joomla.org</authorUrl> <version>3.0.0</version> <description>PLG_SEARCH_CONTACTS_XML_DESCRIPTION</description> <files> <filename plugin="contacts">contacts.php</filename> </files> <languages> <language tag="en-GB">en-GB.plg_search_contacts.ini</language> <language tag="en-GB">en-GB.plg_search_contacts.sys.ini</language> </languages> <config> <fields name="params"> <fieldset name="basic"> <field name="search_limit" type="number" label="JFIELD_PLG_SEARCH_SEARCHLIMIT_LABEL" description="JFIELD_PLG_SEARCH_SEARCHLIMIT_DESC" default="50" filter="integer" size="5" /> <field name="search_content" type="radio" label="JFIELD_PLG_SEARCH_ALL_LABEL" description="JFIELD_PLG_SEARCH_ALL_DESC" class="btn-group btn-group-yesno" default="0" filter="integer" > <option value="1">JYES</option> <option value="0">JNO</option> </field> <field name="search_archived" type="radio" label="JFIELD_PLG_SEARCH_ARCHIVED_LABEL" description="JFIELD_PLG_SEARCH_ARCHIVED_DESC" class="btn-group btn-group-yesno" default="0" filter="integer" > <option value="1">JYES</option> <option value="0">JNO</option> </field> </fieldset> </fields> </config> </extension> PK��qq!]o��newsfeeds/newsfeeds.phpnu�&1i��PK��qq!]T��Y��newsfeeds/newsfeeds.xmlnu�&1i��PK��qq!]�8�� x��tags/tags.phpnu�&1i��PK��qq!]�$?B�� 2��tags/tags.xmlnu�&1i��PK��qq!]��ֆ��l8��content/content.xmlnu�&1i��PK��qq!] �~�4��4��?��content/content.phpnu�&1i��PK��qq!]�i��pt��categories/categories.phpnu�&1i��PK��qq!]6\}��=��categories/categories.xmlnu�&1i��PK��qq!]�V��f��icagenda/index.htmlnu�&1i��PK��qq!]E�d<-��<-��ȏ��icagenda/icagenda.phpnu�&1i��PK��qq!]��<��I��icagenda/icagenda.xmlnu�&1i��PK��qq!]�"(�7��7��!��contacts/contacts.phpnu�&1i��PK��qq!]f ��contacts/contacts.xmlnu�&1i��PK�� G��

| ver. 1.4 | Github | . | PHP 8.1.34 | Генерация страницы: 0 | proxy | phpinfo | Настройка