XoopsModules25x / lexikon

search.php

<?PHP
/**
 * $Id: search.php v 1.0 8 May 2004 hsalazar Exp $
 * Module: Lexikon -  glossary module
 * Version: v 1.00
 * Release Date: 18 Dec 2011
 * Author: hsalazar
 * Licence: GNU
 */
    #$xoopsOption['pagetype'] = "search";

67% of this comment could be valid code. Did you maybe forget this after debugging?

    
    include("header.php");
    $xoopsOption['template_main'] = 'lx_search.html';
    include XOOPS_ROOT_PATH."/header.php";
    
    global $xoTheme, $xoopsDB, $xoopsModule, $xoopsModuleConfig, $searchtype;
    $myts =& MyTextSanitizer::getInstance();
    // -- options
    include_once XOOPS_ROOT_PATH.'/modules/lexikon/include/common.inc.php';
    $highlight = false;
    $highlight = ( $xoopsModuleConfig['config_highlighter'] = 1 ) ? 1:0;
    //$highlight = lx_getmoduleoption('config_highlighter');

56% of this comment could be valid code. Did you maybe forget this after debugging?

    $hightlight_key = '';
    
    include_once XOOPS_ROOT_PATH . '/class/pagenav.php';
    
    // Check if search is enabled site-wide
    $config_handler =& xoops_gethandler('config');
    $xoopsConfigSearch =& $config_handler->getConfigsByCat(XOOPS_CONF_SEARCH);
    if ($xoopsConfigSearch['enable_search'] != 1) {
        header('location: '.XOOPS_URL.'/modules/' .$xoopsModule->dirname(). '/index.php');
        exit();
    }

    // permissions
    $gperm_handler =& xoops_gethandler('groupperm');
    $groups = is_object($xoopsUser) ? $xoopsUser->getGroups() : XOOPS_GROUP_ANONYMOUS;
    $module_id = $xoopsModule->getVar('mid');
    $allowed_cats = $gperm_handler->getItemIds("lexikon_view", $groups, $module_id);
    $catids = implode(',', $allowed_cats);
    
    extract($_GET);
    extract($_POST, EXTR_OVERWRITE);
        
    $action = isset($action) ? trim($action) : "search";
    $query = isset($term) ? trim($term) : "";
    $start = isset($start) ? intval($start) : 0;
    $categoryID = isset($categoryID) ? intval($categoryID) : 0;
    $type = isset($type) ? intval($type) : 3;
    $queries = array();
    
    if ($xoopsModuleConfig['multicats'] == 1) {
        $xoopsTpl->assign('multicats', 1);
        $totalcats = lx_countCats();
        $xoopsTpl->assign('totalcats', $totalcats);
    } else {
        $xoopsTpl->assign('multicats', 0);
    }

    // Configure search parameters according to selector
    $query = stripslashes($query);
    if ($type == "1") { $searchtype = "( w.term LIKE '%$query%' )"; }
    if ($type == "2") { $searchtype = "( definition LIKE '%$query%' )"; }
    if ($type == "3") { $searchtype = "(( term LIKE '%$query%' OR definition LIKE '%$query%' OR ref LIKE '%$query%' ))"; }
    
    if ($xoopsModuleConfig['multicats'] == 1) {
        // If the search is in a particular category
        if ($categoryID > 0 ) {
            $andcatid = "AND categoryID = '$categoryID' ";
        } else {
            $andcatid = "";
        }
    } else {
        $andcatid = "";
    }
    
    // Counter
    $publishedwords = lx_countWords();
    $xoopsTpl->assign('publishedwords', $publishedwords);
    
    // If there's no term here (calling directly search page)
    if (!$query) {
        // Display message saying there's no term and explaining how to search
        $xoopsTpl -> assign ('intro', _MD_LEXIKON_NOSEARCHTERM );
        // Display search form
        $searchform = lx_showSearchForm();
        $xoopsTpl->assign('searchform', $searchform);
    } else {
        // IF results, count number
        $catrestrict = " categoryID IN ($catids) ";
        $searchquery = $xoopsDB -> query ("SELECT COUNT(*) as nrows FROM ".$xoopsDB->prefix ("lxentries")." w WHERE offline='0' AND ".$catrestrict." ".$andcatid." AND $searchtype   ORDER BY term DESC");
        list($results) = $xoopsDB->fetchRow($searchquery);
        
        if ($results == 0) {
            // There's been no correspondences with the searched terms
            $xoopsTpl -> assign ('intro', _MD_LEXIKON_NORESULTS );
    
            // Display search form
            $searchform = lx_showSearchForm();
            $xoopsTpl->assign('searchform', $searchform);
        // $results > 0 -> there were search results
        } else {
            // Show paginated list of results
            // We'll put the results in an array
            $resultset = array();

            // -- highlighter
            if ( is_array( $resultset ) ) {
                if ($highlight) {
                    $xoopsTpl -> assign ('highlight', true);
                    $hightlight_key = "&keywords=" . urlencode(trim($query));
                    //$hightlight_key = '&keywords='.urlencode(trim(implode(' ',$query)));

64% of this comment could be valid code. Did you maybe forget this after debugging?

                } else {
                    $xoopsTpl -> assign ('highlight', false);
                }
            }

        // How many results will we show in this page?
            if ($xoopsModuleConfig['multicats'] == 1) {
                // If the search is in a particular category
                if ($categoryID > 0 ) {
                    $andcatid2 = "AND w.categoryID = '$categoryID' ";
                } else {
                    $andcatid2 = "";
                }
            } else {
                $andcatid2 = "";
            }
            $catsallow = " w.categoryID IN ($catids) ";
            $queryA = "SELECT w.entryID, w.categoryID, w.term, w.init, w.definition, w.datesub, w.ref, c.name AS catname FROM ".$xoopsDB -> prefix( 'lxentries' )." w LEFT JOIN ".$xoopsDB -> prefix( 'lxcategories' )." c ON w.categoryID = c.categoryID WHERE w.offline = '0' AND ".$catsallow." ".$andcatid2." AND ".$searchtype." ";
            $queryA .= "  ORDER BY w.term ASC";
            $resultA = $xoopsDB -> query ($queryA, $xoopsModuleConfig['indexperpage'], $start );
    
            while (list( $entryID, $categoryID, $term, $init, $definition, $datesub, $ref, $catname ) = $xoopsDB->fetchRow($resultA)) {
                    $eachresult = array();
                    $xoopsModule = XoopsModule::getByDirname("lexikon");
                    $eachresult['dir'] = $xoopsModule->dirname();
                    $eachresult['id'] = $entryID;
                    $eachresult['categoryID'] = $categoryID;
                    $eachresult['term'] = ucfirst($myts -> htmlSpecialChars( $term ));
                    $eachresult['date'] = formatTimestamp($datesub,$xoopsModuleConfig['dateformat']);
                    $eachresult['ref'] = lx_getHTMLHighlight($query,$myts -> htmlSpecialChars( $ref ), '<b style="background-color: #FFFF80; ">', '</b>' );
                    $eachresult['catname'] = $myts -> htmlSpecialChars( $catname );
                    $tempdef = $myts -> displayTarea ( $definition, 1, 1, 1, 1, 1);
                    $eachresult['definition'] = lx_getHTMLHighlight( $query, $tempdef, '<b style="background-color: #FFFF80; ">', '</b>' );
                    if ($highlight) {
                        $eachresult['keywords'] = $hightlight_key;
                    }
                // Functional links
                $microlinks = lx_serviceLinks ( $eachresult );
                $eachresult['microlinks'] = $microlinks;
                $resultset['match'][] = $eachresult;
            }

            // Msg: there's # results
            $xoopsTpl -> assign ('intro', sprintf( _MD_LEXIKON_THEREWERE, $results, $query ) );
    
            $linkstring = "term=".$query."&start";
            $pagenav = new XoopsPageNav( $results, $xoopsModuleConfig['indexperpage'], $start, $linkstring );
            $resultset['navbar'] = '<div style="text-align:right;">' . $pagenav -> renderNav(6) . '</div>';
    
            $xoopsTpl -> assign ('resultset', $resultset);
    
            // Display search form
            $searchform = lx_showSearchForm();
            $xoopsTpl->assign('searchform', $searchform);
        }
    }
    // Assign variables and close
    $xoopsTpl -> assign ( 'lang_modulename', $xoopsModule->name() );
    $xoopsTpl -> assign ( 'lang_moduledirname', $xoopsModule->getVar('dirname') );
    
    $xoopsTpl->assign("xoops_module_header", '<link rel="stylesheet" type="text/css" href="style.css" />');
    $xoopsTpl->assign('xoops_pagetitle', _MD_LEXIKON_SEARCHENTRY . ' - ' . $myts->htmlSpecialChars($xoopsModule->name()));

    // Meta data
    $meta_description = _MD_LEXIKON_SEARCHENTRY. ' - ' .$myts->htmlSpecialChars($xoopsModule->name());
    if (isset($xoTheme) && is_object($xoTheme)) {
        $xoTheme->addMeta( 'meta', 'description', $meta_description);
    } else {
        $xoopsTpl->assign('xoops_meta_description', $meta_description);
    }

    include(XOOPS_ROOT_PATH."/footer.php");