escape_str($q); if (!user::active()->admin) { foreach (user::group_ids() as $id) { $fields[] = "`view_$id` = " . access::ALLOW; } $access_sql = "AND (" . join(" AND ", $fields) . ")"; } else { $access_sql = ""; } // Count the total number of rows. We can't do this with our regular query because of the // limit statement. It's possible that if we get rid of the limit (but keep the offset) on // the 2nd query and combine the two, it might be faster than making 2 separate queries. $count_query = "SELECT COUNT(*) AS C " . "FROM {items} JOIN {search_records} ON ({items}.`id` = {search_records}.`item_id`) " . "WHERE MATCH({search_records}.`data`) AGAINST ('$q' IN BOOLEAN MODE) " . $access_sql; $count = $db->query($count_query)->current()->C; $query = "SELECT {items}.*, MATCH({search_records}.`data`) AGAINST ('$q') AS `score` " . "FROM {items} JOIN {search_records} ON ({items}.`id` = {search_records}.`item_id`) " . "WHERE MATCH({search_records}.`data`) AGAINST ('$q' IN BOOLEAN MODE) " . $access_sql . "ORDER BY `score` DESC " . "LIMIT $offset, $limit"; return array($count, new ORM_Iterator(ORM::factory("item"), $db->query($query))); } static function check_index() { if ($count = ORM::factory("search_record")->where("dirty", 1)->count_all()) { site_status::warning( t('Your search index needs to be updated. Fix this now', array("url" => url::site("admin/maintenance/start/search_task::update_index?csrf=__CSRF__"))), "search_index_out_of_date"); } } static function update_record($record) { $data = array(); foreach (module::installed() as $module_name => $module_info) { $class_name = "{$module_name}_search"; if (method_exists($class_name, "item_index_data")) { $data[] = call_user_func(array($class_name, "item_index_data"), $record->item()); } } $record->data = join(" ", $data); $record->dirty = 0; $record->save(); } }