function search_clubs($query, $look)
{
$inDB = cmsDatabase::getInstance();
$searchModel = cms_model_search::initModel();
global $_LANG;
cmsCore::loadModel('clubs');
$model = new cms_model_clubs();
/////// поиск по клубным блогам //////////
$sql = "SELECT con.*, cat.title cat_title, cat.id cat_id, cat.owner owner, cat.user_id, img.fileurl\r\n\t\t\tFROM cms_blog_posts con\r\n\t\t\tINNER JOIN cms_blogs cat ON cat.id = con.blog_id AND cat.allow_who = 'all' AND cat.owner = 'club'\r\n LEFT JOIN cms_upload_images img ON img.target_id = con.id AND img.target = 'blog_post' AND img.component = 'clubs'\r\n\t\t\tWHERE 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)) {
while ($item = $inDB->fetch_assoc($result)) {
$result_array = array();
$result_array['link'] = $model->getPostURL($item['user_id'], $item['seolink']);
$result_array['place'] = ' «' . $item['cat_title'] . '»';
$result_array['placelink'] = $model->getBlogURL($item['user_id']);
$result_array['description'] = $searchModel->getProposalWithSearchWord($item['content_html']);
$result_array['title'] = $item['title'];
$result_array['pubdate'] = $item['pubdate'];
$result_array['imageurl'] = $item['fileurl'];
$result_array['session_id'] = session_id();
$searchModel->addResult($result_array);
}
}
/////// поиск по клубным фоткам //////////
$sql = "SELECT f.*, a.title as cat, a.id as cat_id\r\n\t\t\tFROM cms_photo_files f\r\n\t\t\tINNER JOIN cms_photo_albums a ON a.id = f.album_id AND a.published = 1 AND a.NSDiffer != ''\r\n\t\t\tWHERE MATCH(f.title, f.description) AGAINST ('{$query}' IN BOOLEAN MODE) AND f.published = 1";
$result = $inDB->query($sql);
if ($inDB->num_rows($result)) {
while ($item = $inDB->fetch_assoc($result)) {
$result_array = array();
$result_array['link'] = "/clubs/photo" . $item['id'] . ".html";
$result_array['place'] = $_LANG['CLUBS_PHOTOALBUM'] . ' «' . $item['cat'] . '»';
$result_array['placelink'] = '/clubs/photoalbum' . $item['cat_id'];
$result_array['description'] = $searchModel->getProposalWithSearchWord($item['description']);
$result_array['title'] = $item['title'];
$result_array['pubdate'] = $item['pubdate'];
$result_array['imageurl'] = HOST . '/images/photos/medium/' . $item['file'] ? '/images/photos/medium/' . $item['file'] : '';
$result_array['session_id'] = session_id();
$searchModel->addResult($result_array);
}
}
return;
}
