WordPress.org

Arbitrary section

Search options: Sphinx extended queries syntax allows the following special operators to be used: * operator OR: hello | world * operator NOT: hello -world hello !world * field search operator: @title hello @body world * phrase search operator: "hello world" * proximity search operator: "hello world"~10 Here's an example query which uses all these operators: "hello world" @title "example program"~5 @body python -(php|perl) More information about extended syntax you can find at: http://sphinxsearch.com/doc.html#extended-syntax

The following field operators are available: @title - search in post or page title @body - search in post, page, comment body @category - search search in blog categories

Semi live update - "main+delta" scheme: To enable semi-live index updates also known as "main+delta" scheme, the plugin will create the following table in your MySQL database:

CREATE TABLE wpsphcounter ( counterid INTEGER PRIMARY KEY NOT NULL, maxdocid INTEGER NOT NULL ); If your WordPress installation's table prefix is not "wp", substitute the correct value.

Top and last tags: In order to be able to store search statistics the plugin will run the following SQL query during the activation process:

CREATE TABLE wp_sph_stats ( id int(11) unsigned NOT NULL autoincrement, keywords varchar(255) NOT NULL default '', dateadded datetime NOT NULL default '0000-00-00 00:00:00', keywordsfull varchar(255) NOT NULL default '', PRIMARY KEY (id), KEY keywords (keywords) ); If your WordPress installation's table prefix is not "wp", substitute the correct value.

The plugin folder structure: ./cron - contains crontab scripts, see crontab instructions below; ./php - contains php classes and libs; ./tags - contains sphinx search tags implementation; ./templates - contains html templates, that you can change to suit more to your blog design;

How to automatically start Sphinx search daemon at boot: In Debian based systems i.e. Ubuntu: % update-rc.d "/path/to/bin/searchd --config /path/to/etc/sphinx.conf" defaults In Redhat based systems i.e. Fedora: % chkconfig --add "/path/to/bin/searchd --config /path/to/etc/sphinx.conf"