Subversion Repositories Applications.papyrus

Rev

Rev 2115 | Rev 2117 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 2115 Rev 2116
Line 178... Line 178...
178 
	# descriptif = '' partout
 178 
	# descriptif = '' partout
179 
	# chapo = '' partout
 179 
	# chapo = '' partout
180 
	# soustitre = '' partout sauf id = 19
 180 
	# soustitre = '' partout sauf id = 19
181 
	# ps = '' partout sauf id = 19
 181 
	# ps = '' partout sauf id = 19
182 
	sql_query		= \
 182 
	sql_query		= \
183 
		SELECT id_article, titre, texte, date, lang, "spip" AS group_id, CONCAT("spip-", id_article) as main_id \
 183 
		SELECT id_article, titre, texte, UNIX_TIMESTAMP(date) AS date, lang, "spip" AS group_id, CONCAT("spip-", id_article) as main_id \
184 
              FROM spip_articles WHERE statut = "publie"
 184 
              FROM spip_articles WHERE statut = "publie"
Line 185... Line 185...
185 
 
 185 
 
186 
#	sql_attr_uint		= id_article
 186 
#	sql_attr_uint		= id_article
187 
	sql_attr_timestamp	= date
 187 
	sql_attr_timestamp	= date
Line 224... Line 224...
224 
        SELECT m.gm_id_menu, \
 224 
        SELECT m.gm_id_menu, \
225 
               IF(gm_nom != '', gm_nom, IF(gm_titre != '', gm_titre, gm_titre_alternatif)) as titre, \
 225 
               IF(gm_nom != '', gm_nom, IF(gm_titre != '', gm_titre, gm_titre_alternatif)) as titre, \
226 
               gmc_contenu AS texte, \
 226 
               gmc_contenu AS texte, \
227 
               gm_mots_cles,gm_source, gm_auteur, gm_contributeur, gm_editeur, gm_categorie, \
 227 
               gm_mots_cles,gm_source, gm_auteur, gm_contributeur, gm_editeur, gm_categorie, \
228 
               \
 228 
               \
229 
               gm_date_creation,        \
 229 
               UNIX_TIMESTAMP(gm_date_creation) AS date,        \
230 
               "papyrus" AS group_id,    \
 230 
               "papyrus" AS group_id,    \
231 
               CONCAT("papyrus-", m.gm_id_menu) as main_id \
 231 
               CONCAT("papyrus-", m.gm_id_menu) as main_id \
232 
               \
 232 
               \
233 
               FROM gen_menu m \
 233 
               FROM gen_menu m \
234 
               LEFT JOIN gen_menu_contenu mc  ON mc.gmc_ce_menu      = m.gm_id_menu \
 234 
               LEFT JOIN gen_menu_contenu mc  ON mc.gmc_ce_menu      = m.gm_id_menu \
235 
                                              AND mc.gmc_bool_dernier = 1 \
 235 
                                              AND mc.gmc_bool_dernier = 1 \
236 
               WHERE m.gm_date_fin_validite = '0000-00-00 00:00:00' OR LOWER(m.gm_date_fin_validite) < now()
 236 
               WHERE m.gm_date_fin_validite = '0000-00-00 00:00:00' OR LOWER(m.gm_date_fin_validite) < now()
Line 237... Line 237...
237 
 
 237 
 
238 
	sql_attr_timestamp	= gm_date_creation
 238 
	sql_attr_timestamp	= date
239 
	sql_field_string	= group_id
 239 
	sql_field_string	= group_id
Line 240... Line 240...
240 
	sql_attr_string		= main_id
 240 
	sql_attr_string		= main_id
241 
 
 241 
 
Line 261... Line 261...
261 
    # pd_nom            # erreur dans more_recherche_projet.class.php
 261 
    # pd_nom            # erreur dans more_recherche_projet.class.php
262 
    # pd_description    # erreur dans more_recherche_projet.class.php
 262 
    # pd_description    # erreur dans more_recherche_projet.class.php
263 
	sql_query		= \
 263 
	sql_query		= \
264 
        SELECT p_id, p_titre AS titre, p_description AS texte, \
 264 
        SELECT p_id, p_titre AS titre, p_description AS texte, \
265 
               p_resume, \
 265 
               p_resume, \
266 
               p_date_creation, \
 266 
               UNIX_TIMESTAMP(p_date_creation) AS date, \
267 
               "projet" AS group_id,    \
 267 
               "projet" AS group_id,    \
268 
               CONCAT("projet-", p_id) as main_id \
 268 
               CONCAT("projet-", p_id) as main_id \
269 
        FROM projet
 269 
        FROM projet
Line 270... Line 270...
270 
 
 270 
 
271 
	sql_attr_timestamp	= p_date_creation
 271 
	sql_attr_timestamp	= date
272 
	sql_field_string	= group_id
 272 
	sql_field_string	= group_id
Line 273... Line 273...
273 
	sql_attr_string		= main_id
 273 
	sql_attr_string		= main_id
274 
 
 274 
 
Line 286... Line 286...
286 
 
 286 
 
287 
 
 287 
 
288 
# BAZAR
 288 
# BAZAR
289 
source bazar : common {
 289 
source bazar : common {
290 
	sql_query		= \
 290 
	sql_query		= \
291 
        SELECT bf_id_fiche, bf_description AS texte, bf_titre AS titre, bf_date_debut_evenement, "bazar" AS group_id, \
 291 
        SELECT bf_id_fiche, bf_description AS texte, bf_titre AS titre, UNIX_TIMESTAMP(bf_date_debut_evenement) AS date, \
Line 292... Line 292...
292 
        CONCAT("bazar-", bf_id_fiche) as main_id \
 292 
        "bazar" AS group_id, CONCAT("bazar-", bf_id_fiche) as main_id \
293 
        FROM bazar_fiche
 293 
        FROM bazar_fiche
294 
 
 294 
 
Line 295... Line 295...
295 
	sql_attr_timestamp	= bf_date_debut_evenement
 295 
	sql_attr_timestamp	= date
296 
	sql_field_string	= group_id
 296 
	sql_field_string	= group_id
Line 331... Line 331...
331 
    infix_fields    = texte, nom_sci
 331 
    infix_fields    = texte, nom_sci
332 
}
 332 
}
Line 333... Line 333...
333 
 
 333 
 
334 
 
 334 
 
335 
# misc...
 335 
# misc...
336 
index testrt
 336 
# index testrt
337 
{
 337 
# {
338 
	type			= rt
 338 
# 	type			= rt
339 
	rt_mem_limit		= 32M
 339 
# 	rt_mem_limit		= 32M
340 
 
 340 
 
341 
	path			= /var/lib/sphinx/testrt
 341 
# 	path			= /var/lib/sphinx/testrt
342 
	charset_type		= utf-8
 342 
# 	charset_type		= utf-8
343 
 
 343 
 
344 
	rt_field		= title
 344 
# 	rt_field		= title
345 
	rt_field		= content
 345 
# 	rt_field		= content
Line 346... Line 346...
346 
	rt_attr_uint		= gid
 346 
# 	rt_attr_uint		= gid
347 
}
 347 
# }
348 
 
 348