Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- FlaggingPlugin->Base_GetAppSettingsMenuItems_Handler(Object:SettingsController, array(5), 'base_getappsettingsmenuitems_handler')0.000829s
- select DISTINCT(fl.ForeignID) as `NumFlaggedItems`
- from GDN_Flag fl
- group by ForeignURL;
- Page completed in 120.7253s
- Controller Data
- Title: 'Plugins'
- Settings:
- SearchOptions:
- Match:
- Any: 'Any'
- All: 'All'
- Extended: 'Extended'
- Order:
- Relevance: 'Relevance'
- MostRecent: 'Most Recent'
- MostViews: 'Most Views'
- MostReplies: 'Most Replies'
- Time:
- All: 'All'
- ThisWeek: 'This Week'
- ThisMonth: 'This Month'
- ThisYear: 'Year'
- ResultFormat:
- Classic: 'Classic'
- Table: 'Table'
- Sleek: 'Sleek'
- Simple: 'Simple'
- Wizard:
- StartWizard: true
- Config: true
- Connection: true
- Detection: false
- Installed: true
- AutoDetected: false
- ManualDetected: false
- Task: 'Idle'
- Install:
- Host: 'localhost'
- Port: '9312'
- Prefix: '****'
- IndexerPath: '/usr/bin/indexer'
- ConfPath: '/etc/sphinx/sphinx.conf'
- ConfText: '####################################################################
- # This file is automatically generated by the SphinxSearch Plugin
- #
- # WARNING: YOUR DATABASE PASSWORD/USERNAME ARE CONTAINED IN THIS FILE!!!!
- #
- # -@author mcuhq
- ####################################################################
- #create an offset from the `discussion`
- #notice this: 0 as title ...this is key to not select dups
- source main_comment
- {
- type = mysql
- sql_host = localhost
- sql_user = ***********
- sql_pass = ***********
- sql_db = ***********
- sql_sock = /var/lib/mysql/mysql.sock
- sql_port = 3306 #optional, default is 3306
- sql_query_pre = SET NAMES utf8
- sql_query_pre = REPLACE INTO vanilla.GDN_sph_counter SELECT 1, MAX(c.CommentID +1) FROM vanilla.GDN_Comment as c
- sql_query = SELECT (c.CommentID +1 + (SELECT MAX(d.DiscussionID) FROM vanilla.GDN_Discussion as d)), c.CommentID as docid, 1 as isComment,\\
- c.Body as body, UNIX_TIMESTAMP(c.DateInserted) as docdateinserted,\\
- \\
- 0 as title, d.CountComments as CountComments, d.CountViews as CountViews,\\
- \\
- cat.CategoryID as catid, cat.PermissionCategoryID as catpermid,\\
- \\
- u.Name as user, u.UserID as UserID\\
- \\
- FROM vanilla.GDN_Comment as c\\
- \\
- INNER JOIN vanilla.GDN_Discussion as d ON c.DiscussionID = d.DiscussionID\\
- INNER JOIN vanilla.GDN_User as u ON c.InsertUserID = u.UserID\\
- INNER JOIN vanilla.GDN_Category as cat ON d.CategoryID = cat.CategoryID\\
- \\
- WHERE (c.CommentID +1) <=( SELECT max_doc_id FROM vanilla.GDN_sph_counter WHERE counter_id=1 )\\
- sql_field_string = user #don\'t require sql call to get username when filtring by user on the main search page
- sql_attr_uint = UserID
- sql_attr_uint = docid
- sql_attr_uint = catid
- sql_attr_bigint = catpermid #so results respect user permissions (must be signed!)
- sql_attr_multi = uint TagID from query; SELECT t.DiscussionID, t.TagID FROM vanilla.GDN_TagDiscussion as t
- sql_attr_timestamp = docdateinserted
- sql_attr_uint = CountViews
- sql_attr_uint = CountComments
- sql_attr_uint = isComment #distinguishes between a discussion/comment
- }
- source delta_comment : main_comment
- {
- sql_query_pre = SET NAMES utf8
- sql_query = SELECT (c.CommentID +1 + (SELECT MAX(d.DiscussionID) FROM vanilla.GDN_Discussion as d)), c.CommentID as docid, 1 as isComment,\\
- c.Body as body, UNIX_TIMESTAMP(c.DateInserted) as docdateinserted,\\
- \\
- 0 as title, d.CountComments as CountComments, d.CountViews as CountViews,\\
- \\
- cat.CategoryID as catid, cat.PermissionCategoryID as catpermid,\\
- \\
- u.Name as user, u.UserID as UserID\\
- \\
- FROM vanilla.GDN_Comment as c\\
- \\
- INNER JOIN vanilla.GDN_Discussion as d ON c.DiscussionID = d.DiscussionID\\
- INNER JOIN vanilla.GDN_User as u ON c.InsertUserID = u.UserID\\
- INNER JOIN vanilla.GDN_Category as cat ON d.CategoryID = cat.CategoryID\\
- \\
- WHERE (c.CommentID +1) > (SELECT max_doc_id FROM vanilla.GDN_sph_counter WHERE counter_id=1)\\
- }
- #this source selects the discussion body and its related info, exactly like the `comments` does.
- #the discussion body is refered to as a comment to fit with the rest of the naming scheme
- #yes, there are duplicate attributes stored, but the two sources MUST match columns(see MYSQL UNION)
- source main_discussion
- {
- type = mysql
- sql_host = localhost
- sql_user = **************
- sql_pass = **************
- sql_db = vanilla
- sql_sock = /var/lib/mysql/mysql.sock
- sql_port = 3306 #optional, default is 3306
- sql_query_pre = SET NAMES utf8
- sql_query_pre = REPLACE INTO vanilla.GDN_sph_counter SELECT 2, MAX(d.DiscussionID) FROM vanilla.GDN_Discussion as d
- sql_query = SELECT d.DiscussionID, d.DiscussionID as docid, 0 as isComment,\\
- d.Body as body, UNIX_TIMESTAMP(d.DateInserted) as docdateinserted,\\
- \\
- d.Name as title, d.CountComments as CountComments, d.CountViews as CountViews,\\
- \\
- d.CategoryID as catid, cat.PermissionCategoryID as catpermid,\\
- \\
- u.Name as user, u.UserID as UserID\\
- \\
- FROM vanilla.GDN_Discussion as d\\
- \\
- INNER JOIN vanilla.GDN_Category as cat ON d.CategoryID = cat.CategoryID\\
- INNER JOIN vanilla.GDN_User as u ON d.InsertUserID = u.UserID \\
- \\
- WHERE (d.DiscussionID) <= (SELECT max_doc_id FROM vanilla.GDN_sph_counter WHERE counter_id=2)\\
- sql_field_string = user #don\'t require sql call to get username when filtring by user on the main search page
- sql_attr_uint = UserID
- sql_attr_uint = docid
- sql_attr_uint = catid
- sql_attr_bigint = catpermid #so results respect user permissions (must be signed!)
- sql_attr_multi = uint TagID from query; SELECT t.DiscussionID, t.TagID FROM vanilla.GDN_TagDiscussion as t
- sql_attr_timestamp = docdateinserted
- sql_attr_uint = CountViews
- sql_attr_uint = CountComments
- sql_attr_uint = isComment #distinguishes between a discussion/comment
- }
- source delta_discussion : main_discussion
- {
- sql_query_pre = SET NAMES utf8
- sql_query = SELECT d.DiscussionID, d.DiscussionID as docid, 0 as isComment,\\
- d.Body as body, UNIX_TIMESTAMP(d.DateInserted) as docdateinserted,\\
- \\
- d.Name as title, d.CountComments as CountComments, d.CountViews as CountViews,\\
- \\
- d.CategoryID as catid, cat.PermissionCategoryID as catpermid,\\
- \\
- u.Name as user, u.UserID as UserID\\
- \\
- FROM vanilla.GDN_Discussion as d\\
- \\
- INNER JOIN vanilla.GDN_Category as cat ON d.CategoryID = cat.CategoryID\\
- INNER JOIN vanilla.GDN_User as u ON d.InsertUserID = u.UserID \\
- \\
- WHERE (d.DiscussionID) > (SELECT max_doc_id FROM vanilla.GDN_sph_counter WHERE counter_id=2)\\
- }
- index main
- {
- source = main_comment
- source = main_discussion
- path = /var/lib/sphinx/data/main
- docinfo = extern
- charset_type = utf-8 #For more charsets, for Arabic, Persian, Italian, etc forums, please see: http://sphinxsearch.com/wiki/doku.php?id=charset_tables
- }
- index delta : main
- {
- source = delta_comment
- source = delta_discussion
- path = /var/lib/sphinx/data/delta
- }
- source stats
- {
- type = mysql
- sql_host = localhost
- sql_user = ************
- sql_pass = ************
- sql_db = vanilla
- sql_sock = /var/lib/mysql/mysql.sock
- sql_port = 3306 #optional, default is 3306
- sql_query_pre = SET NAMES utf8
- sql_query = select id, keywords as keywords, crc32(keywords) as keywords_crc, mode,\\
- UNIX_TIMESTAMP(date_added) as date_added \\
- from vanilla.GDN_sph_stats;
- sql_attr_uint = mode
- sql_attr_uint = keywords_crc
- sql_attr_timestamp = date_added
- }
- index stats
- {
- source = stats
- path = /var/lib/sphinx/data/stats
- docinfo = extern
- }
- index vanilla
- {
- type = distributed
- local = main
- local = delta
- #index settings
- morphology = none
- dict = crc
- min_stemming_len = 1
- min_word_len = 2
- min_prefix_len = 0
- min_infix_len = 0
- enable_star = 0
- ngram_len = 0
- html_strip = 0
- ondisk_dict = 0
- inplace_enable = 0
- expand_keywords = 0
- # \'utf-8\' defaults for English and Russian
- charset_table = 0..9, A..Z->a..z, _, a..z, \\
- U+410..U+42F->U+430..U+44F, U+430..U+44F
- }
- indexer
- {
- #indexer settings
- mem_limit = 32M
- max_iops = 0
- max_iosize = 0
- write_buffer = 1M
- max_file_field_buffer = 8M
- }
- searchd
- {
- port = 9312
- log = /var/log/sphinx/searchd.log
- query_log = /var/log/sphinx/query.log
- pid_file = /var/run/sphinx/searchd.pid
- #settings
- read_timeout = 5
- client_timeout = 360
- max_children = 0
- max_matches = 1000
- read_buffer = 1M
- workers = fork
- thread_stack = 64K
- expansion_limit = 0
- prefork_rotation_throttle = 0
- compat_sphinxql_magics = 0 # the future is now
- }
- # --eof--'
- LogPath: '/var/log/sphinx/searchd.log'
- QueryPath: '/var/log/sphinx/query.log'
- PIDPath: '/var/run/sphinx/searchd.pid'
- DataPath: '/var/lib/sphinx/data/'
- Status:
- IndexerFound: false
- SearchdFound: false
- ConfFound: false
- SearchdRunning: false
- Admin:
- LimitResultsPage: 30
- MaxMatches: 1000
- MaxQueryTime: 0
- MainHitBoxEnable: true
- LimitRelatedSearches: 20
- LimitTopKeywords: 20
- LimitTopSearches: 20
- LimitRelatedThreadsSidebarDiscussion: 20
- LimitRelatedThreadsMain: 20
- LimitRelatedThreadsPost: 20
- RelatedThreadsPostFormat: 'simple'
- LimitRelatedThreadsBottomDiscussion: 20
- RelatedThreadsBottomDiscussionFormat: 'table'
- MainSearchEnable: true
- StatsEnable: true
- RelatedEnable: true
- CssClass: 'Dashboard Settings plugins '
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement