| 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 |