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 '