Файл: adultscript-2.0.3-pro/SPHINX.txt
Строк: 23
A simple example for setting up Sphinx Search:
source videos
{
type
= mysql
sql_host = localhost
sql_user = asp
sql_pass
= asp
sql_db = asp_b4
sql_sock =
/var/run/mysqld/mysqld.sock
sql_port = 3306
sql_query_pre = SET
NAMES utf8
sql_query = \
SELECT v.video_id, v.title, v.description,
v.mobile, v.add_time, \
v.rating, v.total_views, v.duration,
v.video_id AS video, \
GROUP_CONCAT(DISTINCT t.name SEPARATOR ' ')
AS tags \
FROM video AS v \
LEFT JOIN video_tags AS t ON (t.video_id =
v.video_id) \
AND v.status = 1 \
GROUP BY v.video_id
sql_attr_uint =
video
sql_attr_uint = mobile
sql_attr_uint =
total_views
sql_attr_float = duration
sql_attr_float =
rating
sql_attr_timestamp = add_time
sql_attr_multi = uint categories
FROM query; SELECT video_id, cat_id FROM video_category
sql_query_info =
SELECT video_id, add_date FROM video WHERE video_id=$id
}
index videos
{
source = videos
path =
/var/lib/sphinxsearch/data/videos
charset_type = utf-8
min_prefix_len
= 3
enable_star = 1
}
searchd
{
port = 3312
log =
/var/log/sphinxsearch/searchd.log
query_log =
/var/log/sphinxsearch/query.log
pid_file =
/var/log/sphinxsearch/searchd.pid
}