Verzeichnisstruktur phpBB-3.1.0


Veröffentlicht
27.10.2014

So funktioniert es


Auf das letzte Element klicken. Dies geht jeweils ein Schritt zurück

Auf das Icon klicken, dies öffnet das Verzeichnis. Nochmal klicken schließt das Verzeichnis.
Auf den Verzeichnisnamen klicken, dies zeigt nur das Verzeichnis mit Inhalt an

(Beispiel Datei-Icons)

Auf das Icon klicken um den Quellcode anzuzeigen

sphinx.sample.conf

Zuletzt modifiziert: 09.10.2024, 12:51 - Dateigröße: 4.45 KiB


001  source source_phpbb_{SPHINX_ID}_main
002  {
003      type = mysql # mysql or pgsql
004      sql_host = localhost # SQL server host sphinx connects to
005      sql_user = username
006      sql_pass = password
007      sql_db = db_name
008      sql_port =  3306 # optional, default is 3306 for mysql and 5432 for pgsql
009      sql_query_pre = SET NAMES 'utf8'
010      sql_query_pre = UPDATE phpbb_sphinx SET max_doc_id = (SELECT MAX(post_id) FROM phpbb_posts) WHERE counter_id = 1
011      sql_query_range = SELECT MIN(post_id), MAX(post_id) FROM phpbb_posts
012      sql_range_step = 5000
013      sql_query = SELECT \
014                              p.post_id AS id, \
015                              p.forum_id, \
016                              p.topic_id, \
017                              p.poster_id, \
018                              p.post_visibility, \
019                              CASE WHEN p.post_id = t.topic_first_post_id THEN 1 ELSE 0 END as topic_first_post, \
020                              p.post_time, \
021                              p.post_subject, \
022                              p.post_subject as title, \
023                              p.post_text as data, \
024                              t.topic_last_post_time, \
025                              0 as deleted\
026                          FROM phpbb_posts p, phpbb_topics t \
027                          WHERE \
028                              p.topic_id = t.topic_id \
029                              AND p.post_id >= $start AND p.post_id <= $end
030      sql_query_post =
031      sql_query_post_index = UPDATE phpbb_sphinx SET max_doc_id = $maxid WHERE counter_id = 1
032      sql_query_info = SELECT * FROM phpbb_posts WHERE post_id = $id
033      sql_attr_uint = forum_id
034      sql_attr_uint = topic_id
035      sql_attr_uint = poster_id
036      sql_attr_uint = post_visibility
037      sql_attr_bool = topic_first_post
038      sql_attr_bool = deleted
039      sql_attr_timestamp = post_time
040      sql_attr_timestamp = topic_last_post_time
041      sql_attr_string = post_subject
042  }
043  source source_phpbb_{SPHINX_ID}_delta : source_phpbb_{SPHINX_ID}_main
044  {
045      sql_query_pre =
046      sql_query_range =
047      sql_range_step =
048      sql_query = SELECT \
049                              p.post_id AS id, \
050                              p.forum_id, \
051                              p.topic_id, \
052                              p.poster_id, \
053                              p.post_visibility, \
054                              CASE WHEN p.post_id = t.topic_first_post_id THEN 1 ELSE 0 END as topic_first_post, \
055                              p.post_time, \
056                              p.post_subject, \
057                              p.post_subject as title, \
058                              p.post_text as data, \
059                              t.topic_last_post_time, \
060                              0 as deleted \
061                          FROM phpbb_posts p, phpbb_topics t \
062                          WHERE \
063                              p.topic_id = t.topic_id \
064                              AND p.post_id >= ( SELECT max_doc_id FROM phpbb_sphinx WHERE counter_id=1 )
065      sql_query_pre =
066  }
067  index index_phpbb_{SPHINX_ID}_main
068  {
069      path = {DATA_PATH}/index_phpbb_{SPHINX_ID}_main
070      source = source_phpbb_{SPHINX_ID}_main
071      docinfo = extern
072      morphology = none
073      stopwords =
074      min_word_len = 2
075      charset_type = utf-8
076      charset_table = U+FF10..U+FF19->0..9, 0..9, U+FF41..U+FF5A->a..z, U+FF21..U+FF3A->a..z, A..Z->a..z, a..z, U+0149, U+017F, U+0138, U+00DF, U+00FF, U+00C0..U+00D6->U+00E0..U+00F6, U+00E0..U+00F6, U+00D8..U+00DE->U+00F8..U+00FE, U+00F8..U+00FE, U+0100->U+0101, U+0101, U+0102->U+0103, U+0103, U+0104->U+0105, U+0105, U+0106->U+0107, U+0107, U+0108->U+0109, U+0109, U+010A->U+010B, U+010B, U+010C->U+010D, U+010D, U+010E->U+010F, U+010F, U+0110->U+0111, U+0111, U+0112->U+0113, U+0113, U+0114->U+0115, U+0115, U+0116->U+0117, U+0117, U+0118->U+0119, U+0119, U+011A->U+011B, U+011B, U+011C->U+011D, U+011D, U+011E->U+011F, U+011F, U+0130->U+0131, U+0131, U+0132->U+0133, U+0133, U+0134->U+0135, U+0135, U+0136->U+0137, U+0137, U+0139->U+013A, U+013A, U+013B->U+013C, U+013C, U+013D->U+013E, U+013E, U+013F->U+0140, U+0140, U+0141->U+0142, U+0142, U+0143->U+0144, U+0144, U+0145->U+0146, U+0146, U+0147->U+0148, U+0148, U+014A->U+014B, U+014B, U+014C->U+014D, U+014D, U+014E->U+014F, U+014F, U+0150->U+0151, U+0151, U+0152->U+0153, U+0153, U+0154->U+0155, U+0155, U+0156->U+0157, U+0157, U+0158->U+0159, U+0159, U+015A->U+015B, U+015B, U+015C->U+015D, U+015D, U+015E->U+015F, U+015F, U+0160->U+0161, U+0161, U+0162->U+0163, U+0163, U+0164->U+0165, U+0165, U+0166->U+0167, U+0167, U+0168->U+0169, U+0169, U+016A->U+016B, U+016B, U+016C->U+016D, U+016D, U+016E->U+016F, U+016F, U+0170->U+0171, U+0171, U+0172->U+0173, U+0173, U+0174->U+0175, U+0175, U+0176->U+0177, U+0177, U+0178->U+00FF, U+00FF, U+0179->U+017A, U+017A, U+017B->U+017C, U+017C, U+017D->U+017E, U+017E, U+0410..U+042F->U+0430..U+044F, U+0430..U+044F, U+4E00..U+9FFF
077      min_prefix_len = 0
078      min_infix_len = 0
079  }
080  index index_phpbb_{SPHINX_ID}_delta : index_phpbb_{SPHINX_ID}_main
081  {
082      path = {DATA_PATH}/index_phpbb_{SPHINX_ID}_delta
083      source = source_phpbb_{SPHINX_ID}_delta
084  }
085  indexer
086  {
087      mem_limit = 512M
088  }
089  searchd
090  {
091      compat_sphinxql_magics = 0
092      listen = localhost:9312
093      log = {DATA_PATH}/log/searchd.log
094      query_log = {DATA_PATH}/log/sphinx-query.log
095      read_timeout = 5
096      max_children = 30
097      pid_file = {DATA_PATH}/searchd.pid
098      max_matches = 20000
099      binlog_path = {DATA_PATH}
100  }
101