Файл: group_forum/inc/search_act.php
Строк: 16
<?
include_once '../sys/inc/stemmer.php';
$stemmer = new Lingua_Stem_Ru();
if (!isset($_POST['text']) || strlen2($_POST['text'])<3)$err[]='Ошибочный запрос';
else
{
$s_arr=split("(t|n|r| )+", $_POST['text']);
$searched['text']=implode(' ',$s_arr);
for ($i=0;$i<count($s_arr) ;$i++ )
{
$st=$stemmer->stem_word($s_arr[$i]);
if (strlen2($st)<3)continue;
$searched['mark'][$i]='#('.$st.'[a-zа-я0-9]*)#uim';
$s_arr_mysql[$i]=my_esc('+'.$st.'*');
}
}
if (isset($s_arr_mysql))
{
$searched['query']=implode(' ', $s_arr_mysql);
$searched['sql_query']="SELECT * FROM `group_forum_p` INNER JOIN `group_forum_t` ON `group_forum_t`.`id`=`group_forum_p`.`id_them` WHERE `group_forum_p`.`id_group` = '$group[id]' AND `group_forum_t`.`id_group` = '$group[id]' AND (`group_forum_t`.`name` like '%".mysql_escape_string($searched['text'])."%' || `group_forum_t`.`opis` like '%".mysql_escape_string($searched['text'])."%' || `group_forum_p`.`msg` like '%".mysql_escape_string($searched['text'])."%') ORDER BY `group_forum_t`.`id`";
$q=my_esc(mysql_query($searched['sql_query']));
while ($result=mysql_fetch_assoc($q)){
$searched['result'][]=$result;
}
}
?>