Adult Script Pro Community Forums

I agree with Adrian.

You've got too many pop ups, I had to block them, they were driving me nuts.

This is what they want:

source videos
{
        type        = mysql
    sql_host    = localhost
    sql_user    = mysql-username
    sql_pass    = mysql-password
    sql_db      = mysql-database
    sql_sock    = /var/lib/mysqld/mysqld.sock (this depends on your server)
    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, \
         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           = 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 (this depends on your distribution)
        charset_type    = utf-8
        min_prefix_len  = 3
        enable_star     = 1
}

searchd
{
        port            = 3312
        log                     = /var/log/sphinxsearch/searchd.log (this depends on your distribution)
        query_log       = /var/log/sphinxsearch/query.log (this depends on your distribution)
        pid_file        = /var/log/sphinxsearch/searchd.pid (this depends on your distribution)
}

This works 100%, did an install today.