Вход Регистрация
Файл: InstantSocial/uploud/components/blogs/psearch.php
Строк: 57
<?php
/******************************************************************************/
//                                                                            //
//                             InstantCMS v1.9                                //
//                        http://www.instantcms.ru/                           //
//                                                                            //
//                   written by InstantCMS Team, 2007-2011                    //
//                produced by InstantSoft, (www.instantsoft.ru)               //
//                                                                            //
//                        LICENSED BY GNU/GPL v2                              //
//                                                                            //
/******************************************************************************/

if(!defined('VALID_CMS')) { die('ACCESS DENIED'); }
    
function 
search_blogs($query$look){

        
$inCore cmsCore::getInstance();
        
$inDB   cmsDatabase::getInstance();
        
$searchModel cms_model_search::initModel();

        global 
$_LANG;

        
$sql "SELECT con.*, cat.title cat_title, cat.id cat_id, cat.owner owner, cat.user_id user_id, cat.seolink as bloglink
                FROM cms_blog_posts con
                INNER JOIN cms_blogs cat ON cat.id = con.blog_id AND cat.allow_who = 'all'
                WHERE MATCH(con.title, con.content) AGAINST ('
$query' IN BOOLEAN MODE) AND con.published = 1 LIMIT 100";

        
$result $inDB->query($sql);
        
        if (
$inDB->num_rows($result)){

            
$inCore->loadLanguage('components/blog');
            
$inCore->loadModel('blogs');
            
$model = new cms_model_blogs();            
            
            while(
$item $inDB->fetch_assoc($result)){

                
$result_array = array();

                if (
$item['owner'] == 'club') {
                    
$item['cat_title'] = $inDB->get_field('cms_clubs','id='.$item['user_id'],'title');
                }

                
$result_array['link']        = $model->getPostURL(0$item['bloglink'], $item['seolink']);
                
$result_array['place']       = $_LANG['BLOG'].' &laquo;'.$item['cat_title'].'&raquo;';
                
$result_array['placelink']   = $model->getBlogURL(0$item['bloglink']);
                
$result_array['description'] = $searchModel->getProposalWithSearchWord($item['content_html']);
                
$result_array['title']       = $item['title'];
                
$result_array['pubdate']     = $item['pubdate'];
                
$result_array['session_id']  = session_id();

                
$searchModel->addResult($result_array);

            }
        }
        
        return;
        
}


?>
Онлайн: 1
Реклама