180,7 → 180,7 |
# soustitre = '' partout sauf id = 19 |
# ps = '' partout sauf id = 19 |
sql_query = \ |
SELECT id_article, titre, texte, date, lang, "spip" AS group_id, CONCAT("spip-", id_article) as main_id \ |
SELECT id_article, titre, texte, UNIX_TIMESTAMP(date) AS date, lang, "spip" AS group_id, CONCAT("spip-", id_article) as main_id \ |
FROM spip_articles WHERE statut = "publie" |
|
# sql_attr_uint = id_article |
226,7 → 226,7 |
gmc_contenu AS texte, \ |
gm_mots_cles,gm_source, gm_auteur, gm_contributeur, gm_editeur, gm_categorie, \ |
\ |
gm_date_creation, \ |
UNIX_TIMESTAMP(gm_date_creation) AS date, \ |
"papyrus" AS group_id, \ |
CONCAT("papyrus-", m.gm_id_menu) as main_id \ |
\ |
235,7 → 235,7 |
AND mc.gmc_bool_dernier = 1 \ |
WHERE m.gm_date_fin_validite = '0000-00-00 00:00:00' OR LOWER(m.gm_date_fin_validite) < now() |
|
sql_attr_timestamp = gm_date_creation |
sql_attr_timestamp = date |
sql_field_string = group_id |
sql_attr_string = main_id |
|
263,12 → 263,12 |
sql_query = \ |
SELECT p_id, p_titre AS titre, p_description AS texte, \ |
p_resume, \ |
p_date_creation, \ |
UNIX_TIMESTAMP(p_date_creation) AS date, \ |
"projet" AS group_id, \ |
CONCAT("projet-", p_id) as main_id \ |
FROM projet |
|
sql_attr_timestamp = p_date_creation |
sql_attr_timestamp = date |
sql_field_string = group_id |
sql_attr_string = main_id |
|
288,11 → 288,11 |
# BAZAR |
source bazar : common { |
sql_query = \ |
SELECT bf_id_fiche, bf_description AS texte, bf_titre AS titre, bf_date_debut_evenement, "bazar" AS group_id, \ |
CONCAT("bazar-", bf_id_fiche) as main_id \ |
SELECT bf_id_fiche, bf_description AS texte, bf_titre AS titre, UNIX_TIMESTAMP(bf_date_debut_evenement) AS date, \ |
"bazar" AS group_id, CONCAT("bazar-", bf_id_fiche) as main_id \ |
FROM bazar_fiche |
|
sql_attr_timestamp = bf_date_debut_evenement |
sql_attr_timestamp = date |
sql_field_string = group_id |
sql_attr_string = main_id |
|
333,18 → 333,18 |
|
|
# misc... |
index testrt |
{ |
type = rt |
rt_mem_limit = 32M |
# index testrt |
# { |
# type = rt |
# rt_mem_limit = 32M |
|
path = /var/lib/sphinx/testrt |
charset_type = utf-8 |
# path = /var/lib/sphinx/testrt |
# charset_type = utf-8 |
|
rt_field = title |
rt_field = content |
rt_attr_uint = gid |
} |
# rt_field = title |
# rt_field = content |
# rt_attr_uint = gid |
# } |
|
|
indexer |