SHARE
TWEET

Untitled

a guest Jan 15th, 2015 9 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. FlaggingPlugin->Base_GetAppSettingsMenuItems_Handler(Object:SettingsController, array(5), 'base_getappsettingsmenuitems_handler')0.000829s
  2. select DISTINCT(fl.ForeignID) as `NumFlaggedItems`
  3. from GDN_Flag fl
  4. group by ForeignURL;
  5.  
  6.  
  7. Page completed in 120.7253s
  8. Controller Data
  9. Title: 'Plugins'
  10. Settings:
  11.    SearchOptions:
  12.       Match:
  13.          Any: 'Any'
  14.          All: 'All'
  15.          Extended: 'Extended'
  16.       Order:
  17.          Relevance: 'Relevance'
  18.          MostRecent: 'Most Recent'
  19.          MostViews: 'Most Views'
  20.          MostReplies: 'Most Replies'
  21.       Time:
  22.          All: 'All'
  23.          ThisWeek: 'This Week'
  24.          ThisMonth: 'This Month'
  25.          ThisYear: 'Year'
  26.       ResultFormat:
  27.          Classic: 'Classic'
  28.          Table: 'Table'
  29.          Sleek: 'Sleek'
  30.          Simple: 'Simple'
  31.    Wizard:
  32.       StartWizard: true
  33.       Config: true
  34.       Connection: true
  35.       Detection: false
  36.       Installed: true
  37.       AutoDetected: false
  38.       ManualDetected: false
  39.       Task: 'Idle'
  40.    Install:
  41.       Host: 'localhost'
  42.       Port: '9312'
  43.       Prefix: '****'
  44.       IndexerPath: '/usr/bin/indexer'
  45.       ConfPath: '/etc/sphinx/sphinx.conf'
  46.       ConfText: '####################################################################
  47. # This file is automatically generated by the SphinxSearch Plugin
  48. #
  49. #  WARNING: YOUR DATABASE PASSWORD/USERNAME ARE CONTAINED IN THIS FILE!!!!
  50. #
  51. # -@author mcuhq
  52. ####################################################################
  53.  
  54.  
  55. #create an offset from the `discussion`
  56. #notice this: 0 as title ...this is key to not select dups
  57.  
  58. source main_comment
  59. {
  60.     type            = mysql
  61.     sql_host        = localhost
  62.     sql_user        = ***********
  63.     sql_pass        = ***********
  64.     sql_db          = ***********
  65.     sql_sock = /var/lib/mysql/mysql.sock
  66.     sql_port        = 3306    #optional, default is 3306
  67.  
  68.     sql_query_pre   = SET NAMES utf8
  69.     sql_query_pre   = REPLACE INTO vanilla.GDN_sph_counter SELECT 1, MAX(c.CommentID +1) FROM vanilla.GDN_Comment as c
  70.     sql_query       = SELECT (c.CommentID +1 + (SELECT MAX(d.DiscussionID) FROM vanilla.GDN_Discussion as d)), c.CommentID as docid, 1 as isComment,\\
  71.             c.Body as body, UNIX_TIMESTAMP(c.DateInserted) as docdateinserted,\\
  72. \\
  73.             0 as title, d.CountComments as CountComments, d.CountViews as CountViews,\\
  74. \\
  75.                         cat.CategoryID as catid, cat.PermissionCategoryID as catpermid,\\
  76. \\
  77.             u.Name as user, u.UserID as UserID\\
  78. \\
  79.             FROM vanilla.GDN_Comment as c\\
  80. \\
  81.             INNER JOIN vanilla.GDN_Discussion as d ON c.DiscussionID = d.DiscussionID\\
  82.             INNER JOIN vanilla.GDN_User as u ON c.InsertUserID = u.UserID\\
  83.             INNER JOIN vanilla.GDN_Category as cat ON d.CategoryID = cat.CategoryID\\
  84. \\
  85.             WHERE (c.CommentID +1) <=( SELECT max_doc_id FROM vanilla.GDN_sph_counter WHERE counter_id=1 )\\
  86.  
  87.         sql_field_string = user #don\'t require sql call to get username when filtring by user on the main search page
  88.  
  89.         sql_attr_uint = UserID
  90.         sql_attr_uint = docid
  91.         sql_attr_uint = catid
  92.         sql_attr_bigint = catpermid #so results respect user permissions (must be signed!)
  93.  
  94.         sql_attr_multi = uint TagID from query; SELECT t.DiscussionID, t.TagID FROM vanilla.GDN_TagDiscussion as t
  95.  
  96.         sql_attr_timestamp = docdateinserted
  97.     sql_attr_uint = CountViews
  98.     sql_attr_uint = CountComments
  99.     sql_attr_uint = isComment                           #distinguishes between a discussion/comment
  100.  
  101.  
  102. }
  103.  
  104. source delta_comment : main_comment
  105. {
  106.  
  107.     sql_query_pre = SET NAMES utf8
  108.  
  109.     sql_query   = SELECT  (c.CommentID +1 + (SELECT MAX(d.DiscussionID) FROM vanilla.GDN_Discussion as d)), c.CommentID as docid, 1 as isComment,\\
  110.             c.Body as body, UNIX_TIMESTAMP(c.DateInserted) as docdateinserted,\\
  111. \\
  112.             0 as title, d.CountComments as CountComments, d.CountViews as CountViews,\\
  113. \\
  114.                         cat.CategoryID as catid, cat.PermissionCategoryID as catpermid,\\
  115. \\
  116.             u.Name as user, u.UserID as UserID\\
  117. \\
  118.             FROM vanilla.GDN_Comment as c\\
  119. \\
  120.             INNER JOIN vanilla.GDN_Discussion as d ON c.DiscussionID = d.DiscussionID\\
  121.             INNER JOIN vanilla.GDN_User as u ON c.InsertUserID = u.UserID\\
  122.             INNER JOIN vanilla.GDN_Category as cat ON d.CategoryID = cat.CategoryID\\
  123. \\
  124.             WHERE (c.CommentID +1) > (SELECT max_doc_id FROM vanilla.GDN_sph_counter WHERE counter_id=1)\\
  125.  
  126. }
  127.  
  128. #this source selects the discussion body  and its related info, exactly like the `comments` does.
  129. #the discussion body is refered to as a comment to fit with the rest of the naming scheme
  130. #yes, there are duplicate attributes stored, but the two sources MUST match columns(see MYSQL UNION)
  131.  
  132.  
  133. source main_discussion
  134. {
  135.     type            = mysql
  136.     sql_host        = localhost
  137.     sql_user        = **************
  138.     sql_pass        = **************
  139.     sql_db          = vanilla
  140.     sql_sock = /var/lib/mysql/mysql.sock
  141.     sql_port        = 3306    #optional, default is 3306
  142.  
  143.     sql_query_pre   = SET NAMES utf8
  144.     sql_query_pre   = REPLACE INTO vanilla.GDN_sph_counter SELECT 2, MAX(d.DiscussionID) FROM vanilla.GDN_Discussion as d
  145.     sql_query       = SELECT  d.DiscussionID, d.DiscussionID as docid, 0 as isComment,\\
  146.             d.Body as body, UNIX_TIMESTAMP(d.DateInserted) as docdateinserted,\\
  147. \\
  148.             d.Name as title, d.CountComments as CountComments, d.CountViews as CountViews,\\
  149. \\
  150.                         d.CategoryID as catid, cat.PermissionCategoryID as catpermid,\\
  151. \\
  152.             u.Name as user, u.UserID as UserID\\
  153. \\
  154.             FROM vanilla.GDN_Discussion as d\\
  155. \\
  156.             INNER JOIN vanilla.GDN_Category as cat ON d.CategoryID = cat.CategoryID\\
  157.             INNER  JOIN vanilla.GDN_User as u ON d.InsertUserID = u.UserID \\
  158. \\
  159.             WHERE (d.DiscussionID) <= (SELECT max_doc_id FROM vanilla.GDN_sph_counter WHERE counter_id=2)\\
  160.  
  161.         sql_field_string = user #don\'t require sql call to get username when filtring by user on the main search page
  162.  
  163.         sql_attr_uint = UserID
  164.         sql_attr_uint = docid
  165.         sql_attr_uint = catid
  166.         sql_attr_bigint = catpermid #so results respect user permissions (must be signed!)
  167.  
  168.         sql_attr_multi = uint TagID from query; SELECT t.DiscussionID, t.TagID FROM vanilla.GDN_TagDiscussion as t
  169.  
  170.         sql_attr_timestamp = docdateinserted
  171.     sql_attr_uint = CountViews
  172.     sql_attr_uint = CountComments
  173.     sql_attr_uint = isComment                           #distinguishes between a discussion/comment
  174.  
  175. }
  176.  
  177.  
  178. source delta_discussion : main_discussion
  179. {
  180.     sql_query_pre = SET NAMES utf8
  181.     sql_query = SELECT  d.DiscussionID, d.DiscussionID as docid, 0 as isComment,\\
  182.                          d.Body as body, UNIX_TIMESTAMP(d.DateInserted) as docdateinserted,\\
  183. \\
  184.             d.Name as title, d.CountComments as CountComments, d.CountViews as CountViews,\\
  185. \\
  186.                         d.CategoryID as catid, cat.PermissionCategoryID as catpermid,\\
  187. \\
  188.             u.Name as user, u.UserID as UserID\\
  189. \\
  190.             FROM vanilla.GDN_Discussion as d\\
  191. \\
  192.             INNER JOIN vanilla.GDN_Category as cat ON d.CategoryID = cat.CategoryID\\
  193.             INNER  JOIN vanilla.GDN_User as u ON d.InsertUserID = u.UserID \\
  194. \\
  195.                         WHERE (d.DiscussionID) > (SELECT max_doc_id FROM vanilla.GDN_sph_counter WHERE counter_id=2)\\
  196.  
  197. }
  198.  
  199. index main
  200. {
  201.     source          = main_comment
  202.     source          = main_discussion
  203.     path            = /var/lib/sphinx/data/main
  204.     docinfo         = extern
  205.     charset_type    = utf-8 #For more charsets, for Arabic, Persian, Italian, etc forums, please see: http://sphinxsearch.com/wiki/doku.php?id=charset_tables
  206. }
  207. index delta : main
  208. {
  209.     source          = delta_comment
  210.     source          = delta_discussion
  211.     path            = /var/lib/sphinx/data/delta
  212. }
  213.  
  214. source stats
  215. {
  216.         type        = mysql
  217.     sql_host        = localhost
  218.     sql_user        = ************
  219.     sql_pass        = ************
  220.     sql_db          = vanilla
  221.     sql_sock = /var/lib/mysql/mysql.sock
  222.     sql_port        = 3306    #optional, default is 3306
  223.  
  224.         sql_query_pre   = SET NAMES utf8
  225.         sql_query       =  select id, keywords as keywords, crc32(keywords) as keywords_crc, mode,\\
  226.     UNIX_TIMESTAMP(date_added) as date_added \\
  227.     from vanilla.GDN_sph_stats;
  228.  
  229.     sql_attr_uint               = mode
  230.     sql_attr_uint       = keywords_crc
  231.     sql_attr_timestamp  = date_added
  232. }
  233.  
  234. index stats
  235. {
  236.         source  = stats
  237.         path    = /var/lib/sphinx/data/stats
  238.         docinfo = extern
  239.  
  240.  
  241. }
  242.  
  243. index vanilla
  244. {
  245.     type            =  distributed
  246.     local           =  main
  247.     local           =  delta
  248.  
  249.  
  250.     #index settings
  251.     morphology      = none
  252.     dict            = crc
  253.     min_stemming_len = 1
  254.     min_word_len    = 2
  255.     min_prefix_len  = 0
  256.     min_infix_len   = 0
  257.     enable_star     = 0
  258.     ngram_len       = 0
  259.     html_strip      = 0
  260.     ondisk_dict     = 0
  261.     inplace_enable  = 0
  262.     expand_keywords = 0
  263.     # \'utf-8\' defaults for English and Russian
  264.     charset_table = 0..9, A..Z->a..z, _, a..z, \\
  265.                     U+410..U+42F->U+430..U+44F, U+430..U+44F
  266.  
  267.  
  268. }
  269.  
  270. indexer
  271. {
  272.     #indexer settings
  273.     mem_limit       = 32M
  274.     max_iops        = 0
  275.     max_iosize      = 0
  276.     write_buffer    = 1M
  277.     max_file_field_buffer = 8M
  278. }
  279.  
  280. searchd
  281. {
  282.     port            = 9312
  283.     log             = /var/log/sphinx/searchd.log
  284.     query_log       = /var/log/sphinx/query.log
  285.     pid_file        = /var/run/sphinx/searchd.pid
  286.  
  287.  
  288.     #settings
  289.     read_timeout    = 5
  290.     client_timeout  = 360
  291.     max_children    = 0
  292.     max_matches     = 1000
  293.     read_buffer     = 1M
  294.     workers         = fork
  295.  
  296.     thread_stack    = 64K
  297.     expansion_limit = 0
  298.     prefork_rotation_throttle = 0
  299.  
  300.     compat_sphinxql_magics = 0 # the future is now
  301. }
  302.  
  303. # --eof--'
  304.       LogPath: '/var/log/sphinx/searchd.log'
  305.       QueryPath: '/var/log/sphinx/query.log'
  306.       PIDPath: '/var/run/sphinx/searchd.pid'
  307.       DataPath: '/var/lib/sphinx/data/'
  308.    Status:
  309.       IndexerFound: false
  310.       SearchdFound: false
  311.       ConfFound: false
  312.       SearchdRunning: false
  313.    Admin:
  314.       LimitResultsPage: 30
  315.       MaxMatches: 1000
  316.       MaxQueryTime: 0
  317.       MainHitBoxEnable: true
  318.       LimitRelatedSearches: 20
  319.       LimitTopKeywords: 20
  320.       LimitTopSearches: 20
  321.       LimitRelatedThreadsSidebarDiscussion: 20
  322.       LimitRelatedThreadsMain: 20
  323.       LimitRelatedThreadsPost: 20
  324.       RelatedThreadsPostFormat: 'simple'
  325.       LimitRelatedThreadsBottomDiscussion: 20
  326.       RelatedThreadsBottomDiscussionFormat: 'table'
  327.       MainSearchEnable: true
  328.       StatsEnable: true
  329.       RelatedEnable: true
  330. CssClass: 'Dashboard Settings plugins '
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top