Joomla! Forum - community, help and support

Code: Select all

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

jimport('joomla.plugin.plugin');

class plgSearchMediaWiki extends JPlugin
{
	public function onContentSearchAreas() {
		static $areas = array(
			'mediawiki' => 'Wiki'
		);
		return $areas;
	}

	function onContentSearch( $text, $phrase='', $ordering='', $areas=null )
	{
		$db = JFactory::getDBO();
		$user = JFactory::getUser();

		if (is_array( $areas )) {
			if (!array_intersect($areas, array_keys($this->onContentSearchAreas()))) {
				return array();
			}
		}

		// load plugin params info
	 	$limit = $this->params->def('search_limit', 50);
	 	$searchResultsTitle = $this->params->get('search_results_title', 'Wiki'); 
		$mediawikiDatabase = $this->params->get('mediawiki_database', 'dosideas_mwiki');
		$mediawikiTablePrefix = $this->params->get('mediawiki_table_prefix', '');
		$mediawikiUrl = $this->params->get('mediawiki_url', '/wiki/index.php?title=');
	 	
		$text = trim( $text );
		if ($text == '') {
			return array();
		}

		switch ($ordering) {
			case 'newest':
				$order = 'page.page_touched DESC';
				break;
			case 'oldest':
				$order = 'page.page_touched ASC';
				break;
			default:
				$order = 'page.page_touched DESC';
				break;
		}

		$text = $db->getEscaped($text);
	
	    $searchterm = '';
		switch ($phrase) {
		    case 'any':
		    	$searchterm = $text;
		    	break;
		    case 'all':
		    default: 
			$words = explode(' ', $text);
			foreach ($words as $word) {
			    $searchterm .= '+'.$word.' ';	            
			}
		}
	
	    //This variables contains the names of the MediaWiki tables used in the SQL query
		$tablePage = '`'. $mediawikiDatabase . '`.' . $mediawikiTablePrefix . 'page';
		$tableSearchindex = '`'. $mediawikiDatabase . '`.' . $mediawikiTablePrefix . 'searchindex';
		$tableRevision = '`'. $mediawikiDatabase . '`.' . $mediawikiTablePrefix . 'revision';
		$tableText = '`'. $mediawikiDatabase . '`.' . $mediawikiTablePrefix . 'text';
	
	    //About searching on MediaWiki tables:  http://www.mediawiki.org/wiki/Manual:Searchindex_table
		$query  = 'SELECT "2" AS browsernav, page.page_title as titleurl, REPLACE(page.page_title, "_", " ") as title, SUBSTRING(text.old_text, 1, 240) as description'
		.' FROM '.$tablePage.' AS page, '.$tableSearchindex.' AS searchindex, '.$tableRevision.' AS revision, '.$tableText.' AS text'
		.' WHERE page.page_id = searchindex.si_page'
		.' AND page.page_latest = revision.rev_id'
		.' AND revision.rev_text_id = text.old_id'
		.' AND page.page_namespace IN (0)'
		.' AND page.page_is_redirect = 0' 
		.' AND (MATCH(searchindex.si_title) AGAINST("'.$searchterm.'" IN BOOLEAN MODE)'
		.'   OR MATCH(searchindex.si_text) AGAINST("'.$searchterm.'" IN BOOLEAN MODE)'
		.' ) ORDER BY '.$order
		;
		
		$db->setQuery( $query, 0, $limit );
		$rows = $db->loadObjectList();
		$count = count( $rows );

		for ( $i = 0; $i < $count; $i++ ) 
		{	
			$wikitext = $rows[$i]->description;
			$wikitext .= "...";
			$input = explode("\n", $wikitext);				
			$output = WikiTextToHTML::convertWikiTextToHTML($input);
		
			$htmltext = '';
			foreach($output as $line) {
				$htmltext .= $line;
			}		    

			$rows[$i]->href 	= $mediawikiUrl . $rows[$i]->titleurl;
			$rows[$i]->section 	= $searchResultsTitle;
			$rows[$i]->text 	= $htmltext;
		}

		return $rows;
	}
}

Code: Select all

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

$mainframe =& JFactory::getApplication();

$mainframe->registerEvent( 'onContentSearch', 'plgSearchMediaWiki' );
$mainframe->registerEvent( 'onContentSearchAreas', 'plgSearchMediaWikiAreas' );
	
function &plgSearchMediaWikiAreas() {
	static $areas = array(
		'mediawiki' => 'HoeraufWiki'
	);
	return $areas;
}

function plgSearchMediaWiki( $text, $phrase='', $ordering='', $areas=null ){
	//-------------------------------------------------------
	// Pre-processing
	//-------------------------------------------------------
	$mainframe	=& JFactory::getApplication();
	$db			=& JFactory::getDBO();
	$user		=& JFactory::getUser();
	$conf 		=& JFactory::getConfig();
	
	if (is_array( $areas )) {
		if (!array_intersect( $areas, array_keys( plgSearchMediaWikiAreas() ) )) {
			return array();
		}
	}
	
	$searchText = $text;	

	$text = trim( $text );
    if ($text == '') {
        return array();
    }


	// load plugin params info
	$plugin =& JPluginHelper::getPlugin('search', 'modules');
	$plg_params = new JRegistry;
	$plg_params->loadJSON($plugin->params);
    $limit = $plg_params->def('search_limit', 50);
    $searchResultsTitle = $plg_params->def('search_results_title', 'Wiki'); 
    $mediawikiDatabase = $plg_params->def('mediawiki_database', 'dosideas_mwiki');
    $mediawikiTablePrefix = $plg_params->def('mediawiki_table_prefix', '');
    $mediawikiUrl = $plg_params->def('mediawiki_url', '/wiki/index.php?title=');

    switch ($ordering) {
        case 'newest':
			$order = 'page.page_touched DESC';
			break;
        case 'oldest':
            $order = 'page.page_touched ASC';
            break;
        default:
            $order = 'page.page_touched DESC';
            break;
    }

    $text = $db->getEscaped($text);
   
    $searchterm = '';
    switch ($phrase) {
        case 'any':
             $searchterm = $text;
             break;
        case 'all':
        default: 
        $words = explode(' ', $text);
        foreach ($words as $word) {
            $searchterm .= '+'.$word.' ';               
        }
    }
   
    //This variables contains the names of the MediaWiki tables used in the SQL query
    $tablePage = '`'. $mediawikiDatabase . '`.' . $mediawikiTablePrefix . 'page';
    $tableSearchindex = '`'. $mediawikiDatabase . '`.' . $mediawikiTablePrefix . 'searchindex';
    $tableRevision = '`'. $mediawikiDatabase . '`.' . $mediawikiTablePrefix . 'revision';
    $tableText = '`'. $mediawikiDatabase . '`.' . $mediawikiTablePrefix . 'text';
   
    //About searching on MediaWiki tables:  http://www.mediawiki.org/wiki/Manual:Searchindex_table
    $query  = 'SELECT "2" AS browsernav, page.page_title as titleurl, REPLACE(page.page_title, "_", " ") as title, SUBSTRING(text.old_text, 1, 240) as description'
    .' FROM '.$tablePage.' AS page, '.$tableSearchindex.' AS searchindex, '.$tableRevision.' AS revision, '.$tableText.' AS text'
    .' WHERE page.page_id = searchindex.si_page'
    .' AND page.page_latest = revision.rev_id'
    .' AND revision.rev_text_id = text.old_id'
    .' AND page.page_namespace IN (0)'
    .' AND page.page_is_redirect = 0' 
    .' AND (MATCH(searchindex.si_title) AGAINST("'.$searchterm.'" IN BOOLEAN MODE)'
    .'   OR MATCH(searchindex.si_text) AGAINST("'.$searchterm.'" IN BOOLEAN MODE)'
    .' ) ORDER BY '.$order
    ;
      
    $db->setQuery( $query, 0, $limit );
    $rows = $db->loadObjectList();
    $count = count( $rows );

    for ( $i = 0; $i < $count; $i++ ) {   
        $wikitext = $rows[$i]->description;
        $wikitext .= "...";
        $input = explode("\n", $wikitext);            
        $output = WikiTextToHTML::convertWikiTextToHTML($input);
      
        $htmltext = '';
        foreach($output as $line) {
            $htmltext .= $line;
        }          

        $rows[$i]->href    = $mediawikiUrl . $rows[$i]->titleurl;
        $rows[$i]->section    = $searchResultsTitle;
        $rows[$i]->text    = $htmltext;
    }

    return $rows;
}