############################################################################### ## indexer settings ############################################################################### indexer { # You can tweak these settings as you like and/or add your own mem_limit = 256M } ############################################################################### ## searchd settings ############################################################################### searchd { listen = localhost:9312 listen = localhost:9306:mysql41 read_timeout = 5 client_timeout = 300 max_children = 30 pid_file = /home/nzb1/public_html/db/sphinxdata/searchd.pid log = /home/nzb1/public_html/db/sphinxdata/searchd.log binlog_path = /home/nzb1/public_html/db/sphinxdata/binlog max_matches = 10000 seamless_rotate = 1 preopen_indexes = 1 unlink_old = 1 workers = threads rt_flush_period = 3600 } ############################################################################### ## source definitions ############################################################################### source base { type = mysql sql_host = localhost sql_user = nzb1_Mark134uk sql_pass = Vanila3215uk!22 sql_db = nzb1_admin } #[---------------------------------------------------------------------------]# #| Don't modify below here unless you know what you are doing |# #[---------------------------------------------------------------------------]# source releases_base : base { ## Full-text fields - these are searchable ## # releases sql_field_string = name sql_field_string = searchname sql_field_string = fromname sql_field_string = tvtitle sql_field_string = season sql_field_string = episode sql_field_string = guid sql_field_string = seriesfull # bookinfo sql_field_string = bookinfo_title sql_field_string = bookinfo_author sql_field_string = bookinfo_publisher sql_field_string = bookinfo_review sql_field_string = bookinfo_asin sql_field_string = bookinfo_url sql_field_string = bookinfo_dewey sql_field_string = bookinfo_ean sql_field_string = bookinfo_isbn # consoleinfo sql_field_string = consoleinfo_title sql_field_string = consoleinfo_publisher sql_field_string = consoleinfo_review sql_field_string = consoleinfo_platform sql_field_string = consoleinfo_esrb sql_field_string = consoleinfo_asin sql_field_string = consoleinfo_url # episodeinfo sql_field_string = episodeinfo_showtitle sql_field_string = episodeinfo_eptitle sql_field_string = episodeinfo_director sql_field_string = episodeinfo_writer sql_field_string = episodeinfo_gueststars sql_field_string = episodeinfo_overview sql_field_string = episodeinfo_fullep # musicinfo sql_field_string = musicinfo_title sql_field_string = musicinfo_review sql_field_string = musicinfo_artist sql_field_string = musicinfo_publisher sql_field_string = musicinfo_tracks sql_field_string = musicinfo_asin sql_field_string = musicinfo_year # movieinfo sql_field_string = movieinfo_title sql_field_string = movieinfo_tagline sql_field_string = movieinfo_plot sql_field_string = movieinfo_director sql_field_string = movieinfo_actors sql_field_string = movieinfo_genre sql_field_string = movieinfo_language # predb sql_field_string = predb_dirname sql_field_string = predb_filename sql_field_string = predb_category sql_field_string = predb_nuketype sql_field_string = predb_nukereason ## Attributes - not searchable but can be used for filtering ## # releases sql_attr_bigint = size sql_attr_uint = groupID sql_attr_uint = categoryID sql_attr_uint = totalpart sql_attr_uint = grabs sql_attr_uint = completion sql_attr_uint = regexID sql_attr_uint = rageID sql_attr_uint = mazeID sql_attr_uint = tvdbID sql_attr_uint = imdbID sql_attr_uint = episodeinfoID sql_attr_uint = musicinfoID sql_attr_uint = consoleinfoID sql_attr_uint = bookinfoID sql_attr_uint = preID sql_attr_uint = anidbID sql_attr_uint = comments sql_attr_uint = passwordstatus sql_attr_uint = rarinnerfilecount sql_attr_uint = haspreview sql_attr_timestamp = postdate sql_attr_timestamp = adddate sql_attr_timestamp = tvairdate # bookinfo sql_attr_uint = bookinfo_genreID sql_attr_uint = bookinfo_pages sql_attr_uint = bookinfo_cover sql_attr_timestamp = bookinfo_publishdate # consoleinfo sql_attr_uint = consoleinfo_salesrank sql_attr_uint = consoleinfo_genreID sql_attr_timestamp = consoleinfo_releasedate sql_attr_uint = consoleinfo_cover # episodeinfo sql_attr_uint = episodeinfo_tvinfoID sql_attr_uint = episodeinfo_tvdbID sql_attr_uint = episodeinfo_epabsolute sql_attr_float = episodeinfo_rating sql_attr_timestamp = episodeinfo_airdate # musicinfo sql_attr_uint = musicinfo_salesrank sql_attr_uint = musicinfo_genreID sql_attr_uint = musicinfo_cover sql_attr_timestamp = musicinfo_releasedate # movieinfo sql_attr_uint = movieinfo_imdbID sql_attr_uint = movieinfo_tmdbID sql_attr_uint = movieinfo_year sql_attr_uint = movieinfo_cover sql_attr_uint = movieinfo_backdrop sql_attr_float = movieinfo_rating # predb sql_attr_uint = predb_ctime sql_attr_uint = predb_nuketime sql_attr_float = predb_filesize sql_attr_uint = predb_filecount } source releases : releases_base { sql_query_pre = UPDATE sphinx \ SET maxID = (SELECT MAX(id) FROM releases), updatedate = NOW() \ WHERE ID = 1 sql_query = SELECT \ releases.ID AS ID, \ releases.name as name, \ releases.searchname as searchname, \ releases.fromname as fromname, \ releases.tvtitle as tvtitle, \ releases.season as season, \ releases.episode as episode, \ bookinfo.title as bookinfo_title, \ bookinfo.author as bookinfo_author, \ bookinfo.publisher as bookinfo_publisher, \ bookinfo.review as bookinfo_review, \ consoleinfo.title as consoleinfo_title, \ consoleinfo.publisher as consoleinfo_publisher, \ consoleinfo.review as consoleinfo_review, \ episodeinfo.showtitle as episodeinfo_showtitle, \ episodeinfo.eptitle as episodeinfo_eptitle, \ episodeinfo.director as episodeinfo_director, \ episodeinfo.writer as episodeinfo_writer, \ episodeinfo.gueststars as episodeinfo_gueststars, \ episodeinfo.overview as episodeinfo_overview, \ musicinfo.title as musicinfo_title, \ musicinfo.review as musicinfo_review, \ musicinfo.artist as musicinfo_artist, \ musicinfo.publisher as musicinfo_publisher, \ musicinfo.tracks as musicinfo_tracks, \ movieinfo.title as movieinfo_title, \ movieinfo.tagline as movieinfo_tagline, \ movieinfo.plot as movieinfo_plot, \ movieinfo.director as movieinfo_director, \ movieinfo.actors as movieinfo_actors, \ movieinfo.genre as movieinfo_genre, \ predb.dirname as predb_dirname, \ predb.filename as predb_filename, \ releases.size as size, \ releases.groupID as groupID, \ releases.categoryID as categoryID, \ releases.totalpart as totalpart, \ releases.grabs as grabs, \ releases.completion as completion, \ releases.regexID as regexID, \ releases.tvinfoID as tvinfoID, \ tvinfo.rageID as rageID, \ tvinfo.mazeID as mazeID, \ tvinfo.tvdbID as tvdbID, \ releases.imdbID as imdbID, \ releases.episodeinfoID as episodeinfoID, \ releases.musicinfoID as musicinfoID, \ releases.consoleinfoID as consoleinfoID, \ releases.bookinfoID as bookinfoID, \ releases.preID as preID, \ releases.anidbID as anidbID, \ releases.comments as comments, \ releases.passwordstatus as passwordstatus, \ releases.rarinnerfilecount as rarinnerfilecount, \ releases.haspreview as haspreview, \ releases.guid as guid, \ releases.seriesfull as seriesfull, \ UNIX_TIMESTAMP(releases.adddate) AS adddate, \ UNIX_TIMESTAMP(releases.postdate) AS postdate, \ UNIX_TIMESTAMP(releases.tvairdate) AS tvairdate, \ bookinfo.genreID as bookinfo_genreID, \ bookinfo.pages as bookinfo_pages, \ bookinfo.cover as bookinfo_cover, \ bookinfo.asin as bookinfo_asin, \ bookinfo.url as bookinfo_url, \ bookinfo.dewey as bookinfo_dewey, \ bookinfo.ean as bookinfo_ean, \ bookinfo.isbn as bookinfo_isbn, \ UNIX_TIMESTAMP(bookinfo.publishdate) as bookinfo_publishdate, \ consoleinfo.asin as consoleinfo_asin, \ consoleinfo.url as consoleinfo_url, \ consoleinfo.salesrank as consoleinfo_salesrank, \ consoleinfo.platform as consoleinfo_platform, \ consoleinfo.genreID as consoleinfo_genreID, \ consoleinfo.esrb as consoleinfo_esrb, \ UNIX_TIMESTAMP(consoleinfo.releasedate) as consoleinfo_releasedate, \ consoleinfo.cover as consoleinfo_cover, \ episodeinfo.tvinfoID as episodeinfo_tvinfoID, \ episodeinfo.tvdbID as episodeinfo_tvdbID, \ episodeinfo.epabsolute as episodeinfo_epabsolute, \ episodeinfo.rating as episodeinfo_rating, \ episodeinfo.fullep as episodeinfo_fullep, \ UNIX_TIMESTAMP(episodeinfo.airdate) as episodeinfo_airdate, \ musicinfo.salesrank as musicinfo_salesrank, \ musicinfo.genreID as musicinfo_genreID, \ musicinfo.cover as musicinfo_cover, \ musicinfo.asin as musicinfo_asin, \ musicinfo.year as musicinfo_year, \ UNIX_TIMESTAMP(musicinfo.releasedate) as musicinfo_releasedate, \ movieinfo.imdbID as movieinfo_imdbID, \ movieinfo.tmdbID as movieinfo_tmdbID, \ movieinfo.year as movieinfo_year, \ movieinfo.cover as movieinfo_cover, \ movieinfo.backdrop as movieinfo_backdrop, \ movieinfo.rating as movieinfo_rating, \ movieinfo.language as movieinfo_language, \ predb.ctime as predb_ctime, \ predb.nuketime as predb_nuketime, \ predb.filesize as predb_filesize, \ predb.filecount as predb_filecount, \ predb.category as predb_category, \ predb.nuketype as predb_nuketype, \ predb.nukereason as predb_nukereason \ FROM releases \ LEFT JOIN tvinfo \ ON releases.tvinfoID = tvinfo.ID \ LEFT JOIN bookinfo \ ON releases.bookinfoID = bookinfo.ID \ LEFT JOIN consoleinfo \ ON releases.consoleinfoID = consoleinfo.ID \ LEFT JOIN episodeinfo \ ON releases.episodeinfoID = episodeinfo.ID \ LEFT JOIN musicinfo \ ON releases.musicinfoID = musicinfo.ID \ LEFT JOIN movieinfo \ ON releases.imdbID = movieinfo.imdbID \ LEFT JOIN predb \ ON releases.preID = predb.ID \ WHERE releases.ID >= $start AND releases.ID <= $end \ GROUP BY releases.ID sql_range_step = 10000 sql_query_range = SELECT MIN(id), MAX(id) FROM releases # Uncomment for debugging with "search" utility #sql_query_info = SELECT * FROM releases WHERE id=$id } source releases_delta : releases_base { sql_query = SELECT \ releases.ID AS ID, \ releases.name as name, \ releases.searchname as searchname, \ releases.fromname as fromname, \ releases.tvtitle as tvtitle, \ releases.season as season, \ releases.episode as episode, \ bookinfo.title as bookinfo_title, \ bookinfo.author as bookinfo_author, \ bookinfo.publisher as bookinfo_publisher, \ bookinfo.review as bookinfo_review, \ consoleinfo.title as consoleinfo_title, \ consoleinfo.publisher as consoleinfo_publisher, \ consoleinfo.review as consoleinfo_review, \ episodeinfo.showtitle as episodeinfo_showtitle, \ episodeinfo.eptitle as episodeinfo_eptitle, \ episodeinfo.director as episodeinfo_director, \ episodeinfo.writer as episodeinfo_writer, \ episodeinfo.gueststars as episodeinfo_gueststars, \ episodeinfo.overview as episodeinfo_overview, \ musicinfo.title as musicinfo_title, \ musicinfo.review as musicinfo_review, \ musicinfo.artist as musicinfo_artist, \ musicinfo.publisher as musicinfo_publisher, \ musicinfo.tracks as musicinfo_tracks, \ movieinfo.title as movieinfo_title, \ movieinfo.tagline as movieinfo_tagline, \ movieinfo.plot as movieinfo_plot, \ movieinfo.director as movieinfo_director, \ movieinfo.actors as movieinfo_actors, \ movieinfo.genre as movieinfo_genre, \ predb.dirname as predb_dirname, \ predb.filename as predb_filename, \ releases.size as size, \ releases.groupID as groupID, \ releases.categoryID as categoryID, \ releases.totalpart as totalpart, \ releases.grabs as grabs, \ releases.completion as completion, \ releases.regexID as regexID, \ releases.tvinfoID as tvinfoID, \ tvinfo.rageID as rageID, \ tvinfo.mazeID as mazeID, \ tvinfo.tvdbID as tvdbID, \ releases.imdbID as imdbID, \ releases.episodeinfoID as episodeinfoID, \ releases.musicinfoID as musicinfoID, \ releases.consoleinfoID as consoleinfoID, \ releases.bookinfoID as bookinfoID, \ releases.preID as preID, \ releases.anidbID as anidbID, \ releases.comments as comments, \ releases.passwordstatus as passwordstatus, \ releases.rarinnerfilecount as rarinnerfilecount, \ releases.haspreview as haspreview, \ releases.guid as guid, \ releases.seriesfull as seriesfull, \ UNIX_TIMESTAMP(releases.adddate) AS adddate, \ UNIX_TIMESTAMP(releases.postdate) AS postdate, \ UNIX_TIMESTAMP(releases.tvairdate) AS tvairdate, \ bookinfo.genreID as bookinfo_genreID, \ bookinfo.pages as bookinfo_pages, \ bookinfo.cover as bookinfo_cover, \ bookinfo.asin as bookinfo_asin, \ bookinfo.url as bookinfo_url, \ bookinfo.dewey as bookinfo_dewey, \ bookinfo.ean as bookinfo_ean, \ bookinfo.isbn as bookinfo_isbn, \ UNIX_TIMESTAMP(bookinfo.publishdate) as bookinfo_publishdate, \ consoleinfo.asin as consoleinfo_asin, \ consoleinfo.url as consoleinfo_url, \ consoleinfo.salesrank as consoleinfo_salesrank, \ consoleinfo.platform as consoleinfo_platform, \ consoleinfo.genreID as consoleinfo_genreID, \ consoleinfo.esrb as consoleinfo_esrb, \ UNIX_TIMESTAMP(consoleinfo.releasedate) as consoleinfo_releasedate, \ consoleinfo.cover as consoleinfo_cover, \ episodeinfo.tvinfoID as episodeinfo_tvinfoID, \ episodeinfo.tvdbID as episodeinfo_tvdbID, \ episodeinfo.epabsolute as episodeinfo_epabsolute, \ episodeinfo.rating as episodeinfo_rating, \ episodeinfo.fullep as episodeinfo_fullep, \ UNIX_TIMESTAMP(episodeinfo.airdate) as episodeinfo_airdate, \ musicinfo.salesrank as musicinfo_salesrank, \ musicinfo.genreID as musicinfo_genreID, \ musicinfo.cover as musicinfo_cover, \ musicinfo.asin as musicinfo_asin, \ musicinfo.year as musicinfo_year, \ UNIX_TIMESTAMP(musicinfo.releasedate) as musicinfo_releasedate, \ movieinfo.imdbID as movieinfo_imdbID, \ movieinfo.tmdbID as movieinfo_tmdbID, \ movieinfo.year as movieinfo_year, \ movieinfo.cover as movieinfo_cover, \ movieinfo.backdrop as movieinfo_backdrop, \ movieinfo.rating as movieinfo_rating, \ movieinfo.language as movieinfo_language, \ predb.ctime as predb_ctime, \ predb.nuketime as predb_nuketime, \ predb.filesize as predb_filesize, \ predb.filecount as predb_filecount, \ predb.category as predb_category, \ predb.nuketype as predb_nuketype, \ predb.nukereason as predb_nukereason \ FROM releases \ LEFT JOIN tvinfo \ ON releases.tvinfoID = tvinfo.ID \ LEFT JOIN bookinfo \ ON releases.bookinfoID = bookinfo.ID \ LEFT JOIN consoleinfo \ ON releases.consoleinfoID = consoleinfo.ID \ LEFT JOIN episodeinfo \ ON releases.episodeinfoID = episodeinfo.ID \ LEFT JOIN musicinfo \ ON releases.musicinfoID = musicinfo.ID \ LEFT JOIN movieinfo \ ON releases.imdbID = movieinfo.imdbID \ LEFT JOIN predb \ ON releases.preID = predb.ID \ WHERE releases.updatedate >= (SELECT lastmergedate \ FROM sphinx WHERE ID = 1) \ GROUP BY releases.ID } source releasefiles : base { # Can't do this index using a "range" because it appears to cause duplicate # documents to be indexed. sql_query_pre = UPDATE sphinx \ SET maxID = (SELECT MAX(id) FROM releasefiles), updatedate = NOW() \ WHERE ID = 2 sql_query = SELECT \ releasefiles.releaseID AS ID, \ GROUP_CONCAT(releasefiles.name) as name, \ UNIX_TIMESTAMP(releases.postdate) AS postdate, \ releases.categoryID, \ releases.size, \ releases.grabs, \ releases.totalpart \ FROM releasefiles \ INNER JOIN releases ON releases.ID = releasefiles.releaseID \ GROUP BY releasefiles.releaseID \ ORDER BY releasefiles.releaseID ASC sql_field_string = name sql_attr_bigint = size sql_attr_uint = grabs sql_attr_timestamp = postdate sql_attr_uint = totalpart sql_attr_uint = categoryID } source releasefiles_delta : base { sql_query = SELECT \ releasefiles.releaseID as ID, \ GROUP_CONCAT(releasefiles.name) as name, \ UNIX_TIMESTAMP(releases.postdate) AS postdate, \ releases.categoryID, \ releases.size, \ releases.grabs, \ releases.totalpart \ FROM releasefiles \ INNER JOIN releases ON releases.ID = releasefiles.releaseID \ WHERE releasefiles.ID > (SELECT maxID \ FROM sphinx WHERE ID = 2) \ GROUP BY releasefiles.releaseID \ ORDER BY releasefiles.releaseID ASC sql_field_string = name sql_attr_bigint = size sql_attr_uint = grabs sql_attr_timestamp = postdate sql_attr_uint = totalpart sql_attr_uint = categoryID } source releasenfo : base { sql_query_pre = UPDATE sphinx \ SET maxID = (SELECT MAX(id) FROM releasenfo), updatedate = NOW() \ WHERE id = 3 sql_query = SELECT \ releaseID as ID, \ UNCOMPRESS(releasenfo.nfo) as nfo, \ releases.name, \ UNIX_TIMESTAMP(releases.postdate) AS postdate, \ releases.categoryID, \ releases.size, \ releases.grabs, \ releases.totalpart \ FROM releasenfo \ INNER JOIN releases ON releases.ID = releasenfo.releaseID \ WHERE releasenfo.id >= $start \ AND releasenfo.id <= $end \ GROUP BY releaseID \ ORDER BY releaseID ASC sql_range_step = 10000 sql_query_range = SELECT MIN(releaseID), MAX(releaseID) FROM releasenfo sql_field_string = nfo sql_field_string = name sql_attr_bigint = size sql_attr_uint = grabs sql_attr_timestamp = postdate sql_attr_uint = totalpart sql_attr_uint = categoryID } source releasenfo_delta : base { sql_query = SELECT \ releaseID as ID, \ UNCOMPRESS(releasenfo.nfo) as nfo, \ releases.name, \ UNIX_TIMESTAMP(releases.postdate) AS postdate, \ releases.categoryID, \ releases.size, \ releases.grabs, \ releases.totalpart \ FROM releasenfo \ INNER JOIN releases ON releases.ID = releasenfo.releaseID \ WHERE releasenfo.id > (SELECT maxID \ FROM sphinx WHERE ID = 3) \ GROUP BY releaseID \ ORDER BY releaseID ASC sql_field_string = nfo sql_field_string = name sql_attr_bigint = size sql_attr_uint = grabs sql_attr_timestamp = postdate sql_attr_uint = totalpart sql_attr_uint = categoryID } source predb : base { sql_query_pre = UPDATE sphinx \ SET maxID = (SELECT MAX(id) FROM predb), updatedate = NOW() \ WHERE id = 4 sql_query = SELECT \ predb.ID AS ID, \ predb.ctime as ctime, \ predb.dirname as dirname, \ predb.category as category, \ predb.nuketype as nuketype, \ predb.nukereason as nukereason, \ predb.filesize as filesize, \ predb.filecount as filecount, \ releases.guid as guid, \ releasenfo.ID as nfoID \ FROM predb \ LEFT JOIN releases \ ON releases.preID = predb.ID \ LEFT JOIN releasenfo \ ON releasenfo.releaseID = releases.ID \ WHERE predb.ID >= $start AND predb.ID <= $end \ GROUP BY predb.ID sql_range_step = 10000 sql_query_range = SELECT MIN(id), MAX(id) FROM predb sql_field_string = dirname sql_field_string = category sql_field_string = nuketype sql_field_string = guid sql_attr_uint = ctime sql_attr_uint = nfoID } source predb_delta : base { sql_query = SELECT \ predb.ID AS ID, \ predb.ctime as ctime, \ predb.dirname as dirname, \ predb.category as category, \ predb.nuketype as nuketype, \ predb.nukereason as nukereason, \ predb.filesize as filesize, \ predb.filecount as filecount, \ releases.guid as guid, \ releasenfo.ID as nfoID \ FROM predb \ LEFT JOIN releases \ ON releases.preID = predb.ID \ LEFT JOIN releasenfo \ ON releasenfo.releaseID = releases.ID \ WHERE predb.updatedate >= (SELECT lastmergedate \ FROM sphinx WHERE ID = 4) \ GROUP BY predb.ID sql_field_string = dirname sql_field_string = category sql_field_string = nuketype sql_field_string = guid sql_attr_uint = ctime sql_attr_uint = nfoID } ############################################################################### ## index definition ############################################################################### index releases { type = plain path = /home/nzb1/public_html/db/sphinxdata/releases source = releases morphology = stem_en blend_chars = -, (, ), [, ], {, }, +, &, U+23, /, \, <, > min_infix_len = 3 infix_fields = name, searchname index_exact_words = 1 } index releases_delta { type = plain path = /home/nzb1/public_html/db/sphinxdata/releases_delta source = releases_delta morphology = stem_en blend_chars = -, (, ), [, ], {, }, +, &, U+23, /, \, <, > min_infix_len = 3 infix_fields = name, searchname index_exact_words = 1 } index releasefiles { type = plain path = /home/nzb1/public_html/db/sphinxdata/releasefiles source = releasefiles morphology = stem_en blend_chars = -, (, ), [, ], {, }, +, &, U+23, /, \, <, > index_exact_words = 1 min_infix_len = 3 } index releasefiles_delta { type = plain path = /home/nzb1/public_html/db/sphinxdata/releasefiles_delta source = releasefiles_delta morphology = stem_en blend_chars = -, (, ), [, ], {, }, +, &, U+23, /, \, <, > index_exact_words = 1 min_infix_len = 3 } index releasenfo { type = plain path = /home/nzb1/public_html/db/sphinxdata/releasenfo source = releasenfo morphology = stem_en blend_chars = -, (, ), [, ], {, }, +, &, U+23, /, \, <, > index_exact_words = 1 #min_infix_len = 3 } index releasenfo_delta { type = plain path = /home/nzb1/public_html/db/sphinxdata/releasenfo_delta source = releasenfo_delta morphology = stem_en blend_chars = -, (, ), [, ], {, }, +, &, U+23, /, \, <, > index_exact_words = 1 #min_infix_len = 3 } index nzbs { type = rt path = /home/nzb1/public_html/db/sphinxdata/nzbs rt_field = file_names rt_attr_uint = file_count rt_mem_limit = 256M # If you really have a death wish: #min_infix_len = 3 } index predb { type = plain path = /home/nzb1/public_html/db/sphinxdata/predb source = predb morphology = stem_en blend_chars = -, (, ), [, ], {, }, +, &, U+23, /, \, <, > index_exact_words = 1 min_infix_len = 3 infix_fields = dirname } index predb_delta { type = plain path = /home/nzb1/public_html/db/sphinxdata/predb_delta source = predb_delta morphology = stem_en blend_chars = -, (, ), [, ], {, }, +, &, U+23, /, \, <, > index_exact_words = 1 min_infix_len = 3 infix_fields = dirname }