$sql%'or content1 like '%\n$sql%'
or content2 like '$sql%' or content2 like '% $sql%'
or content2 like '%>$sql%' or content2 like '%\n$sql%')
and (type<2 or active)
order by type,priority");
*/
$cond=($tmp=make_search_condition($text,array('title','content1','content2'))) ?
" and $tmp" : ' and 0';
$res=db_query("select pageID,type,static_page,title,
if(url_name!='',url_name,pageID) as url_name
from site_pages
where (type<2 or active) $cond
order by type,priority");
$t=-1;
while ($row=@$sql_fetch_assoc($res)) {
@extract($row);
$uri=make_url($static_page,$url_name,$type);
$title=to_html($title);
if ($t<0 && $type<2) echo "
• Found regular pages:
";
elseif ($t<2 && $type==2) echo "
• Found articles:
";
echo "$title ";
$t=$type;
}
//-------------------- News ---------------------\
/*
$res=db_query("select nwsID,archive,title from news
where (title like '$sql%' or title like '% $sql%'
or content like '$sql%' or content like '% $sql%'
or content like '%>$sql%' or content like '%\n$sql%')
order by archive,time DESC");
*/
$cond=($tmp=make_search_condition($text,array('title','content'))) ?
$tmp : 0;
$res=db_query("select nwsID,archive,title
from news where $cond
order by archive,time DESC");
$t=0;
while ($row=@$sql_fetch_assoc($res)) {
@extract($row);
$uri="news".($archive ? '_1' : '').".html#$nwsID";
$title=to_html($title);
if (!$t) echo "
• Found news:
";
echo "$title ";
$t=1;
}
//-------------------- Product Categories ---------------------\
if ($CAN_ADMIN_CATS) {
$cond=($tmp=make_search_condition($text,array('title','comment','description'))) ?
$tmp : 0;
$query="select c.catID as catID,title,comment,description
from sc_category as c
inner join sc_category_stat as cs on c.catID=cs.catID and cs.n_prod>0
where c.catID in ($CategItemsActKeys) and $cond
order by parID,priority,c.catID";
}
else {
$cond=($tmp=make_search_condition($text,
array(
"IF(cn.title!='',cn.title,c.title)",
"IF(cn.comment!='',cn.comment,c.comment)",
"IF(cn.description!='',cn.description,c.description)"
))) ?
$tmp : 0;
$query="select c.catID as catID,
IF(cn.title!='',cn.title,c.title) as title,
IF(cn.comment!='',cn.comment,c.comment) as comment,
IF(cn.description!='',cn.description,c.description) as description
from (sc_category as c
inner join sc_category_stat as cs on c.catID=cs.catID and cs.n_prod>0)
left join sc_category_newval as cn on c.catID=cn.catID
where c.catID in ($CategItemsActKeys) and $cond
order by parID,c.priority,c.catID";
}
$res=db_query($query);
$t=0;
while ($row=@$sql_fetch_assoc($res)) {
if (!$t) echo "