amaliel

<?php/***   ZNP****   $Id: search.php,v 1.25 2006-11-13 12:20:30 qyon Exp $****   File name :   search.php**   Started   :   28.08.2006 r.**   License   :   GPL***************************************************************************/    require_once('commons.php');    $q = trim($_GET['q']);    $drop_char_match = array('%','--', '\'', ',', '@', '\\', '/', '\'', "'");    $q = str_replace($drop_char_match, '', $q);    $results_count = 0;    if ($q)    {        $drop_char_match = array('-','+','%','*','--', '\'', ',', '@', '\\', '/', '\'', "'");        $test = str_replace($drop_char_match, '', $q);        // wyszukujemy slowa        $list = explode(' ', $test);        $first = true;        foreach ($list as $item)        {            if(strlen($item) < 3)            {                trigger_error("Ka&#380;de z szukanych s&#322;ów musi mie&#263; minimum 3 znaki!", E_USER_WARNING);            }        }        $sql = 'SELECT                             distinct(co_id) AS ID,                            co_title AS TITLE,                            te2.te_text AS TEXT,                            co_ca_id AS CA_ID,                            ca.ca_name AS CA_NAME,                            co_disp AS DISPLAY,                            us_first_name AS AUTHOR_FIRST_NAME,                            us_last_name AS AUTHOR_LAST_NAME                    FROM '.TABLE_CONTENTS.' co                    JOIN '.TABLE_TEXTS.' te2 ON te2.te_id = co.co_content_te_id                    JOIN '.TABLE_CATEGORIES.' ca ON ca.ca_id = co.co_ca_id                    LEFT JOIN '.TABLE_USERS.' us ON us.us_id = co.co_us_id                    JOIN '. TABLE_OSOBY_GRUP . ' og ON og.og_us_id = us.us_id                    JOIN '. TABLE_UPRAWINIENIA_GRUP . ' ug ON (ug.upr_gr_id =og.og_gr_id) AND (ug.upr_ca_id = co.co_ca_id) AND (ug.upr_action = '.ACTION_READ.')                    WHERE MATCH(te2.te_text)                    AGAINST(\''.$q.'\' IN BOOLEAN MODE)                    AND co.co_special = 0';        $db->sql_query($sql);        $result = Array();        while($row = $db->sql_fetch())        {            $row['TEXT'] = strip_tags($row['TEXT']);            $row['TEXT'] = highlight(smart_substr($row['TEXT'],find_first($row['TEXT'], $list),SEARCH_RESULT_SHORT), $list);            $result[$row['CA_NAME']][] = $row;        }                if ($result)        {            foreach($result as $key => $value)            {                $template->assign_block('GROUP', Array('NAME' => $key));                foreach($value as $text)                {                    $template->assign_block('GROUP.TEXT', $text);                }            }        }        $results_count = count($result);                if ($_GET['comments'])        {            $sql = 'SELECT                                distinct(com.com_id) AS COM_ID,                                co.co_id AS ID,                                co_title AS TITLE,                                com.com_text AS TEXT,                                com.com_visible AS DISPLAY,                                co_ca_id AS CA_ID,                                ca.ca_name AS CA_NAME,                                us_first_name AS AUTHOR_NAME,                                us_first_name AS AUTHOR_FIRST_NAME,                                us_last_name AS AUTHOR_LAST_NAME                        FROM '.TABLE_COMMENTS.' com                        LEFT JOIN '.TABLE_USERS.' us ON us.us_id = com.com_us_id                        JOIN '.TABLE_CONTENTS.' co ON co.co_id = com.com_co_id                        JOIN '.TABLE_CATEGORIES.' ca ON ca.ca_id = co.co_ca_id                        WHERE MATCH(com.com_text)                        AGAINST(\''.$q.'\' IN BOOLEAN MODE)';            $db->sql_query($sql);            $result = Array();            while($row = $db->sql_fetch())            {                $row['TEXT'] = strip_tags($row['TEXT']);                $row['TEXT'] = highlight(smart_substr($row['TEXT'],find_first($row['TEXT'], $list),SEARCH_RESULT_SHORT), $list);                $result[$row['CA_NAME']][] = $row;            }            if ($result)            {                foreach($result as $key => $value)                {                    $template->assign_block('COMMENTS', Array('NAME' => $key));                    foreach($value as $text)                    {                        $template->assign_block('COMMENTS.TEXT', $text);                    }                }            }            $results_count += count($result);            $template->assign('COMMENTS', true);        }        $template->assign('QUERY', htmlspecialchars($q));        $template->assign('RESULTS_COUNT', $results_count);        page_display('search_results.tpl');    }    else    {        page_display('search.tpl');    }?>