Verzeichnisstruktur phpBB-3.3.15
- Veröffentlicht
- 28.08.2024
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. |
|
|
(Beispiel Datei-Icons)
|
Auf das Icon klicken um den Quellcode anzuzeigen |
sphinx.sample.conf
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_attr_uint = forum_id
033 sql_attr_uint = topic_id
034 sql_attr_uint = poster_id
035 sql_attr_uint = post_visibility
036 sql_attr_bool = topic_first_post
037 sql_attr_bool = deleted
038 sql_attr_timestamp = post_time
039 sql_attr_timestamp = topic_last_post_time
040 sql_attr_string = post_subject
041 }
042 source source_phpbb_{SPHINX_ID}_delta : source_phpbb_{SPHINX_ID}_main
043 {
044 sql_query_pre = SET NAMES 'utf8'
045 sql_query_range =
046 sql_range_step =
047 sql_query = SELECT \
048 p.post_id AS id, \
049 p.forum_id, \
050 p.topic_id, \
051 p.poster_id, \
052 p.post_visibility, \
053 CASE WHEN p.post_id = t.topic_first_post_id THEN 1 ELSE 0 END as topic_first_post, \
054 p.post_time, \
055 p.post_subject, \
056 p.post_subject as title, \
057 p.post_text as data, \
058 t.topic_last_post_time, \
059 0 as deleted \
060 FROM phpbb_posts p, phpbb_topics t \
061 WHERE \
062 p.topic_id = t.topic_id \
063 AND p.post_id >= ( SELECT max_doc_id FROM phpbb_sphinx WHERE counter_id=1 )
064 sql_query_post_index =
065 }
066 index index_phpbb_{SPHINX_ID}_main
067 {
068 path = {DATA_PATH}/index_phpbb_{SPHINX_ID}_main
069 source = source_phpbb_{SPHINX_ID}_main
070 docinfo = extern
071 morphology = none
072 stopwords =
073 wordforms = # optional, specify path to wordforms file. See ./docs/sphinx_wordforms.txt for example
074 exceptions = # optional, specify path to exceptions file. See ./docs/sphinx_exceptions.txt for example
075 min_word_len = 2
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 ignore_chars = U+0027, U+002C
078 min_prefix_len = 3 # Minimum number of characters for wildcard searches by prefix (min 1). Default is 3. If specified, set min_infix_len to 0
079 min_infix_len = 0 # Minimum number of characters for wildcard searches by infix (min 2). If specified, set min_prefix_len to 0
080 html_strip = 1
081 index_exact_words = 0 # Set to 1 to enable exact search operator. Requires wordforms or morphology
082 blend_chars = U+23, U+24, U+25, U+26, U+40
083 }
084 index index_phpbb_{SPHINX_ID}_delta : index_phpbb_{SPHINX_ID}_main
085 {
086 path = {DATA_PATH}/index_phpbb_{SPHINX_ID}_delta
087 source = source_phpbb_{SPHINX_ID}_delta
088 }
089 indexer
090 {
091 mem_limit = 512M
092 }
093 searchd
094 {
095 listen = localhost:9312
096 log = {DATA_PATH}/log/searchd.log
097 query_log = {DATA_PATH}/log/sphinx-query.log
098 read_timeout = 5
099 max_children = 30
100 pid_file = {DATA_PATH}/searchd.pid
101 binlog_path = {DATA_PATH}
102 }
103