-* @version $Id: fulltext_postgres.php,v 1.47 2007/06/09 11:08:57 acydburn Exp $

- $db->sql_query("SELECT set_curcfg('" . $db->sql_escape($config['fulltext_postgres_ts_name']) . "')");

- $sql = "SELECT c.relname

- FROM pg_catalog.pg_class c

- WHERE c.relkind = 'r'

- AND c.relname = 'pg_ts_cfg'

- AND pg_catalog.pg_table_is_visible(c.oid)";

- $result = $db->sql_query($sql);

- $row = $db->sql_fetchrow($result);

- $db->sql_freeresult($result);

- if (empty ($row['relname']))

- {

- return $user->lang['FULLTEXT_POSTGRES_TS_NOT_FOUND'];

- $split_keywords = preg_replace("#[\n\r\t]+#", ' ', trim(htmlspecialchars_decode($keywords)));

- * @param string &$fields contains either titleonly (topic titles should be searched), msgonly (only message bodies should be searched), firstpost (only subject and body of the first post should be searched) or all (all post bodies and subjects should be searched)

- * @param string &$terms is either 'all' (use query as entered, words without prefix should default to "have to be in field") or 'any' (ignore search query parts and just return all posts that contain any of the specified words)

- * @param array &$sort_by_sql contains SQL code for the ORDER BY part of a query

- * @param string &$sort_key is the key of $sort_by_sql for the selected sorting

- * @param string &$sort_dir is either a or d representing ASC and DESC

- * @param string &$sort_days specifies the maximum amount of days a post may be old

- * @param array &$ex_fid_ary specifies an array of forum ids which should not be searched

- * @param array &$m_approve_fid_ary specifies an array of forum ids in which the searcher is allowed to view unapproved posts

- * @param int &$topic_id is set to 0 or a topic id, if it is not 0 then only posts in this topic should be searched

- * @param array &$author_ary an array of author ids if the author should be ignored during the search the array is empty

- function keyword_search($type, &$fields, &$terms, &$sort_by_sql, &$sort_key, &$sort_dir, &$sort_days, &$ex_fid_ary, &$m_approve_fid_ary, &$topic_id, &$author_ary, &$id_ary, $start, $per_page)

-

- $sql_where_options .= (sizeof($author_ary)) ? ' AND p.poster_id ' . $sql_author : '';

- $tmp_sql_match[] = "to_tsvector (" . $sql_match_column . ") @@ to_tsquery ('" . $db->sql_escape($this->tsearch_query) . "')";

- * @param array &$id_ary passed by reference, to be filled with ids for the page specified by $start and $per_page, should be ordered

- * @param int $start indicates the first index of the page

- * @param int $per_page number of ids each page is supposed to contain

- * @return total number of results

- function author_search($type, $firstpost_only, &$sort_by_sql, &$sort_key, &$sort_dir, &$sort_days, &$ex_fid_ary, &$m_approve_fid_ary, &$topic_id, &$author_ary, &$id_ary, $start, $per_page)

- implode(',', $author_ary)

-

- $sql_author = $db->sql_in_set('p.poster_id', $author_ary);

- $sql_sort_table = ($type == 'posts') ? TOPICS_TABLE . ' t, ' : '';

- $sql_sort_join = ($type == 'posts') ? ' AND t.topic_id = p.topic_id ' : '';

-

- GROUP BY t.topic_id

- global $db;

- $db->sql_query('CREATE INDEX ' . POSTS_TABLE . '_post_subject ON ' . POSTS_TABLE . ' USING gist (to_tsvector (post_subject))');

- $db->sql_query('CREATE INDEX ' . POSTS_TABLE . '_post_text ON ' . POSTS_TABLE . ' USING gist (to_tsvector (post_text))');

- $db->sql_query('DROP INDEX ' . POSTS_TABLE . '_post_subject');

- $db->sql_query('DROP INDEX ' . POSTS_TABLE . '_post_text');

- if ($row['relname'] == POSTS_TABLE . '_post_text')

- else if ($row['relname'] == POSTS_TABLE . '_post_subject')

- $sql = 'SELECT *

- FROM pg_ts_cfg';