| 314,14 → 314,17 |
|---|
| sql_db = tb_eflore |
| |
| sql_query = \ |
| SELECT c.num_nom AS id, CONCAT("bdtfx", ":", c.num_nom) AS group_id, CONCAT(c.nom_sci, dsc.body) AS texte, CONCAT(c.nom_sci, cle.body) AS determination, c.nom_sci AS nom_sci \ |
| SELECT c.flore_bdtfx_nn AS id, c.nom_sci AS titre, dsc.body AS texte, cle.body AS determination, \ |
| "coste" AS group_id, CONCAT("coste-", c.flore_bdtfx_nn) as main_id \ |
| FROM tb_eflore.coste_v2_00 c \ |
| LEFT JOIN tela_prod_wikini.florecoste_pages dsc ON c.page_wiki_dsc = dsc.tag AND dsc.latest = 'Y' \ |
| LEFT JOIN tela_prod_wikini.florecoste_pages cle ON c.page_wiki_cle = cle.tag AND cle.latest = 'Y'; |
| LEFT JOIN tela_prod_wikini.florecoste_pages cle ON c.page_wiki_cle = cle.tag AND cle.latest = 'Y' \ |
| WHERE c.flore_bdtfx_nn != '' |
| |
| sql_field_string = group_id |
| sql_attr_string = main_id |
| |
| sql_query_info = SELECT * FROM coste_v2_00 WHERE num_nom=$id |
| sql_query_info = SELECT * FROM coste_v2_00 WHERE flore_bdtfx_nn=$id |
| } |
| |
| index i_coste : i_common { |
| 328,10 → 331,16 |
|---|
| source = coste |
| path = /var/lib/sphinx/coste |
| |
| infix_fields = texte, nom_sci |
| infix_fields = texte, titre |
| } |
| |
| # notes: |
| # une nouvelle source d'indexation *DOIT*, pour être utilisable par le moteur de recherche papyrus, |
| # définir les attributs *group_id* et *main_id*. |
| # cf: sphinx_search dans moteur_recherche_sphinx.php |
| |
| |
| |
| # misc... |
| # index testrt |
| # { |