Subversion Repositories Applications.papyrus

Rev

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

Rev 2114 Rev 2115
Line 14... Line 14...
14 
	sql_host		= localhost
 14 
	sql_host		= localhost
15 
	sql_user		= root
 15 
	sql_user		= root
16 
	sql_pass		=
 16 
	sql_pass		=
17 
	sql_db			= raphdb
 17 
	sql_db			= raphdb
18 
	sql_sock		= /var/lib/mysql/mysql.sock
 18 
	sql_sock		= /var/lib/mysql/mysql.sock
- 
 
 19 
 
19 
    #sql_query_pre   = SET NAMES utf8
 20 
    sql_query_pre   = SET NAMES utf8
- 
 
 21 
    sql_query_pre   = SET CHARACTER_SET_RESULTS=utf8
- 
 
 22 
 
20 
    sql_query_pre   = SET NAMES latin1
 23 
    sql_query       = SELECT 1
21 
}
 24 
}
Line 22... Line 25...
22 
 
 25 
 
23 
index i_common
 26 
index i_common
- 
 
 27 
{
- 
 
 28 
    # ces deux directive permettent à la source abstraite d'être valide
24 
{
 29 
    # lors de l'utilisation de sphinx-search sans précision d'index
25 
	# source			=
 30 
	source			= common
26 
	# path			= /var/lib/sphinx/XXX
 31 
	path			= /var/lib/sphinx/void
27 
	docinfo			= extern
 - 
 
28 
	charset_type	= sbcs
 32 
	docinfo			= extern
Line 29... Line 33...
29 
	stopwords		= /etc/sphinx/stopwords.txt
 33 
	stopwords		= /etc/sphinx/stopwords.txt
30 
 
 34 
 
31 
    # http://sphinxsearch.com/docs/2.1.1/conf-morphology.html
 35 
    # http://sphinxsearch.com/docs/2.1.1/conf-morphology.html
Line 42... Line 46...
42 
 
 46 
 
43 
    # http://sphinxsearch.com/wiki/doku.php?id=charset_tables
 47 
    # http://sphinxsearch.com/wiki/doku.php?id=charset_tables
44 
    # mysql raphdb<<<"SELECT p_description FROM projet WHERE p_id = 121"|xxd
 48 
    # mysql raphdb<<<"SELECT p_description FROM projet WHERE p_id = 121"|xxd
45 
    # sphinx-search -q -c sphinx-min.conf -i i_projet "homoge*|homogé"|grep -w hits
 49 
    # sphinx-search -q -c sphinx-min.conf -i i_projet "homoge*|homogé"|grep -w hits
46 
    # SELECT * FROM i_projet WHERE MATCH('homoge*|homogé'); SHOW META;
 50 
    # SELECT * FROM i_projet WHERE MATCH('homoge*|homogé'); SHOW META;
47 
    charset_table		= U+00C8->e, U+00C9->e, U+00CA->e, U+00CB->e, U+00E8->e, U+00E9->e, U+00EA->e, U+00EB->e, U+0112->e, U+0113->e, U+0114->e, U+0115->e, U+0116->e, U+0117->e, U+0118->e, U+0119->e, U+011A->e, U+011B->e, U+018E->e, U+0190->e, U+01DD->e, U+0204->e, U+0205->e, U+0206->e, U+0207->e, U+0228->e, U+0229->e, U+0246->e, U+0247->e, U+0258->e, U+025B->e, U+025C->e, U+025D->e, U+025E->e, U+029A->e, U+1D07->e, U+1D08->e, U+1D31->e, U+1D32->e, U+1D49->e, U+1D4B->e, U+1D4C->e, U+1D92->e, U+1D93->e, U+1D94->e, U+1D9F->e, U+1E14->e, U+1E15->e, U+1E16->e, U+1E17->e, U+1E18->e, U+1E19->e, U+1E1A->e, U+1E1B->e, U+1E1C->e, U+1E1D->e, U+1EB8->e, U+1EB9->e, U+1EBA->e, U+1EBB->e, U+1EBC->e, U+1EBD->e, U+1EBE->e, U+1EBF->e, U+1EC0->e, U+1EC1->e, U+1EC2->e, U+1EC3->e, U+1EC4->e, U+1EC5->e, U+1EC6->e, U+1EC7->e, U+2091->e, \
 51 
	charset_type	= utf-8
48 
    U+00CC->i, U+00CD->i, U+00CE->i, U+00CF->i, U+00EC->i, U+00ED->i, U+00EE->i, U+00EF->i, U+010309->i, U+0128->i, U+0129->i, U+012A->i, U+012B->i, U+012C->i, U+012D->i, U+012E->i, U+012F->i, U+0130->i, U+0131->i, U+0197->i, U+01CF->i, U+01D0->i, U+0208->i, U+0209->i, U+020A->i, U+020B->i, U+0268->i, U+026A->i, U+040D->i, U+0418->i, U+0419->i, U+0438->i, U+0439->i, U+0456->i, U+1D09->i, U+1D35->i, U+1D4E->i, U+1D62->i, U+1D7B->i, U+1D96->i, U+1DA4->i, U+1DA6->i, U+1DA7->i, U+1E2C->i, U+1E2D->i, U+1E2E->i, U+1E2F->i, U+1EC8->i, U+1EC9->i, U+1ECA->i, U+1ECB->i, U+2071->i, U+2111->i, \
 52 
    # valeur par défaut, cf http://sphinxsearch.com/docs/archives/1.10/conf-charset-table.html
- 
 
 53 
    # pour écraser i_common
- 
 
 54 
    charset_table = 0..9, A..Z->a..z, _, a..z, U+410..U+42F->U+430..U+44F, U+430..U+44F, \
- 
 
 55 
	    U+041..U+05a, U+0c6, U+0d0, U+0d8, U+110, U+126, U+132, U+13f, U+141, U+14a, \
- 
 
 56 
		U+152, U+166, U+181, U+186, U+187, U+18a, U+18e..U+190, U+193, U+198, U+19f, U+1a2, \
- 
 
 57 
		U+1b3, U+1c4, U+1c7, U+1ca, U+1e4, U+21c, U+061->U+041, U+0c0->U+041, U+0c1->U+041, \
- 
 
 58 
		U+0c2->U+041, U+0c3->U+041, U+0c4->U+041, U+0c5->U+041, U+0e0->U+041, U+0e1->U+041, \
- 
 
 59 
		U+0e2->U+041, U+0e3->U+041, U+0e4->U+041, U+0e5->U+041, U+100->U+041, U+101->U+041, \
- 
 
 60 
		U+102->U+041, U+103->U+041, U+104->U+041, U+105->U+041, U+1cd->U+041, U+1ce->U+041, \
- 
 
 61 
		U+1de->U+041, U+1df->U+041, U+1e0->U+041, U+1e1->U+041, U+1fa->U+041, U+1fb->U+041, \
- 
 
 62 
		U+200->U+041, U+201->U+041, U+202->U+041, U+203->U+041, U+226->U+041, U+227->U+041, \
- 
 
 63 
		U+1e01->U+041, U+1ea0->U+041, U+1ea1->U+041, U+1ea2->U+041, U+1ea3->U+041, \
- 
 
 64 
		U+1ea4->U+041, U+1ea5->U+041, U+1ea6->U+041, U+1ea7->U+041, U+1ea8->U+041, \
- 
 
 65 
		U+1ea9->U+041, U+1eaa->U+041, U+1eab->U+041, U+1eac->U+041, U+1ead->U+041, \
- 
 
 66 
		U+1eae->U+041, U+1eaf->U+041, U+1eb0->U+041, U+1eb1->U+041, U+1eb2->U+041, \
- 
 
 67 
		U+1eb3->U+041, U+1eb4->U+041, U+1eb5->U+041, U+1eb6->U+041, U+1eb7->U+041, \
- 
 
 68 
		U+062->U+042, U+1e02->U+042, U+1e03->U+042, U+1e04->U+042, U+1e05->U+042, \
- 
 
 69 
		U+1e06->U+042, U+1e07->U+042, U+063->U+043, U+0c7->U+043, U+0e7->U+043, \
- 
 
 70 
		U+106->U+043, U+107->U+043, U+108->U+043, U+109->U+043, U+10a->U+043, U+10b->U+043, \
- 
 
 71 
		U+10c->U+043, U+10d->U+043, U+1e08->U+043, U+1e09->U+043, U+064->U+044, \
- 
 
 72 
		U+10e->U+044, U+10f->U+044, U+1e0a->U+044, U+1e0b->U+044, U+1e0c->U+044, \
- 
 
 73 
		U+1e0d->U+044, U+1e0e->U+044, U+1e0f->U+044, U+1e10->U+044, U+1e11->U+044, \
- 
 
 74 
		U+1e12->U+044, U+1e13->U+044, U+065->U+045, U+0c8->U+045, U+0c9->U+045, \
- 
 
 75 
		U+0ca->U+045, U+0cb->U+045, U+0e8->U+045, U+0e9->U+045, U+0ea->U+045, U+0eb->U+045, \
- 
 
 76 
		U+112->U+045, U+113->U+045, U+114->U+045, U+115->U+045, U+116->U+045, U+117->U+045, \
- 
 
 77 
		U+118->U+045, U+119->U+045, U+11a->U+045, U+11b->U+045, U+204->U+045, U+205->U+045, \
- 
 
 78 
		U+206->U+045, U+207->U+045, U+228->U+045, U+229->U+045, U+1e14->U+045, \
- 
 
 79 
		U+1e15->U+045, U+1e16->U+045, U+1e17->U+045, U+1e18->U+045, U+1e19->U+045, \
- 
 
 80 
		U+1e1a->U+045, U+1e1b->U+045, U+1e1c->U+045, U+1e1d->U+045, U+1eb8->U+045, \
- 
 
 81 
		U+1eb9->U+045, U+1eba->U+045, U+1ebb->U+045, U+1ebc->U+045, U+1ebd->U+045, \
- 
 
 82 
		U+1ebe->U+045, U+1ebf->U+045, U+1ec0->U+045, U+1ec1->U+045, U+1ec2->U+045, \
- 
 
 83 
		U+1ec3->U+045, U+1ec4->U+045, U+1ec5->U+045, U+1ec6->U+045, U+1ec7->U+045, \
- 
 
 84 
		U+066->U+046, U+1e1e->U+046, U+1e1f->U+046, U+067->U+047, U+11c->U+047, \
- 
 
 85 
		U+11d->U+047, U+11e->U+047, U+11f->U+047, U+120->U+047, U+121->U+047, U+122->U+047, \
- 
 
 86 
		U+123->U+047, U+1e6->U+047, U+1e7->U+047, U+1f4->U+047, U+1f5->U+047, \
- 
 
 87 
		U+1e20->U+047, U+1e21->U+047, U+068->U+048, U+124->U+048, U+125->U+048, \
- 
 
 88 
		U+21e->U+048, U+21f->U+048, U+1e22->U+048, U+1e23->U+048, U+1e24->U+048, \
- 
 
 89 
		U+1e25->U+048, U+1e26->U+048, U+1e27->U+048, U+1e28->U+048, U+1e29->U+048, \
- 
 
 90 
		U+1e2a->U+048, U+1e2b->U+048, U+1e96->U+048, U+069->U+049, U+0cc->U+049, \
- 
 
 91 
		U+0cd->U+049, U+0ce->U+049, U+0cf->U+049, U+0ec->U+049, U+0ed->U+049, U+0ee->U+049, \
- 
 
 92 
		U+0ef->U+049, U+128->U+049, U+129->U+049, U+12a->U+049, U+12b->U+049, U+12c->U+049, \
49 
    0..9, A..Z->a..z, _, a..z, \
 93 
		U+12d->U+049, U+12e->U+049, U+12f->U+049, U+130->U+049, U+131->U+049, U+1cf->U+049, \
- 
 
 94 
		U+1d0->U+049, U+208->U+049, U+209->U+049, U+20a->U+049, U+20b->U+049, \
- 
 
 95 
		U+1e2c->U+049, U+1e2d->U+049, U+1e2e->U+049, U+1e2f->U+049, U+1ec8->U+049, \
- 
 
 96 
		U+1ec9->U+049, U+1eca->U+049, U+1ecb->U+049, U+06a->U+04a, U+134->U+04a, \
- 
 
 97 
		U+135->U+04a, U+1f0->U+04a, U+06b->U+04b, U+136->U+04b, U+137->U+04b, U+1e8->U+04b, \
- 
 
 98 
		U+1e9->U+04b, U+1e30->U+04b, U+1e31->U+04b, U+1e32->U+04b, U+1e33->U+04b, \
- 
 
 99 
		U+1e34->U+04b, U+1e35->U+04b, U+06c->U+04c, U+139->U+04c, U+13a->U+04c, \
- 
 
 100 
		U+13b->U+04c, U+13c->U+04c, U+13d->U+04c, U+13e->U+04c, U+1e36->U+04c, \
- 
 
 101 
		U+1e37->U+04c, U+1e38->U+04c, U+1e39->U+04c, U+1e3a->U+04c, U+1e3b->U+04c, \
- 
 
 102 
		U+1e3c->U+04c, U+1e3d->U+04c, U+06d->U+04d, U+1e3e->U+04d, U+1e3f->U+04d, \
- 
 
 103 
		U+1e40->U+04d, U+1e41->U+04d, U+1e42->U+04d, U+1e43->U+04d, U+06e->U+04e, \
- 
 
 104 
		U+0d1->U+04e, U+0f1->U+04e, U+143->U+04e, U+144->U+04e, U+145->U+04e, U+146->U+04e, \
- 
 
 105 
		U+147->U+04e, U+148->U+04e, U+1f8->U+04e, U+1f9->U+04e, U+1e44->U+04e, \
- 
 
 106 
		U+1e45->U+04e, U+1e46->U+04e, U+1e47->U+04e, U+1e48->U+04e, U+1e49->U+04e, \
- 
 
 107 
		U+1e4a->U+04e, U+1e4b->U+04e, U+06f->U+04f, U+0d2->U+04f, U+0d3->U+04f, \
- 
 
 108 
		U+0d4->U+04f, U+0d5->U+04f, U+0d6->U+04f, U+0f2->U+04f, U+0f3->U+04f, U+0f4->U+04f, \
- 
 
 109 
		U+0f5->U+04f, U+0f6->U+04f, U+14c->U+04f, U+14d->U+04f, U+14e->U+04f, U+14f->U+04f, \
- 
 
 110 
		U+150->U+04f, U+151->U+04f, U+1a0->U+04f, U+1a1->U+04f, U+1d1->U+04f, U+1d2->U+04f, \
- 
 
 111 
		U+1ea->U+04f, U+1eb->U+04f, U+1ec->U+04f, U+1ed->U+04f, U+20c->U+04f, U+20d->U+04f, \
- 
 
 112 
		U+20e->U+04f, U+20f->U+04f, U+22a->U+04f, U+22b->U+04f, U+22c->U+04f, U+22d->U+04f, \
- 
 
 113 
		U+22e->U+04f, U+22f->U+04f, U+230->U+04f, U+231->U+04f, U+1e4c->U+04f, \
- 
 
 114 
		U+1e4d->U+04f, U+1e4e->U+04f, U+1e4f->U+04f, U+1e50->U+04f, U+1e51->U+04f, \
- 
 
 115 
		U+1e52->U+04f, U+1e53->U+04f, U+1ecc->U+04f, U+1ecd->U+04f, U+1ece->U+04f, \
- 
 
 116 
		U+1ecf->U+04f, U+1ed0->U+04f, U+1ed1->U+04f, U+1ed2->U+04f, U+1ed3->U+04f, \
- 
 
 117 
		U+1ed4->U+04f, U+1ed5->U+04f, U+1ed6->U+04f, U+1ed7->U+04f, U+1ed8->U+04f, \
- 
 
 118 
		U+1ed9->U+04f, U+1eda->U+04f, U+1edb->U+04f, U+1edc->U+04f, U+1edd->U+04f, \
- 
 
 119 
		U+1ede->U+04f, U+1edf->U+04f, U+1ee0->U+04f, U+1ee1->U+04f, U+1ee2->U+04f, \
- 
 
 120 
		U+1ee3->U+04f, U+070->U+050, U+1e54->U+050, U+1e55->U+050, U+1e56->U+050, \
- 
 
 121 
		U+1e57->U+050, U+071->U+051, U+072->U+052, U+154->U+052, U+155->U+052, \
- 
 
 122 
		U+156->U+052, U+157->U+052, U+158->U+052, U+159->U+052, U+210->U+052, U+211->U+052, \
- 
 
 123 
		U+212->U+052, U+213->U+052, U+1e58->U+052, U+1e59->U+052, U+1e5a->U+052, \
- 
 
 124 
		U+1e5b->U+052, U+1e5c->U+052, U+1e5d->U+052, U+1e5e->U+052, U+1e5f->U+052, \
- 
 
 125 
		U+073->U+053, U+0df->U+053, U+15a->U+053, U+15b->U+053, U+15c->U+053, U+15d->U+053, \
- 
 
 126 
		U+15e->U+053, U+15f->U+053, U+160->U+053, U+161->U+053, U+17f->U+053, U+218->U+053, \
- 
 
 127 
		U+219->U+053, U+1e60->U+053, U+1e61->U+053, U+1e62->U+053, U+1e63->U+053, \
- 
 
 128 
		U+1e64->U+053, U+1e65->U+053, U+1e66->U+053, U+1e67->U+053, U+1e68->U+053, \
- 
 
 129 
		U+1e69->U+053, U+1e9b->U+053, U+074->U+054, U+162->U+054, U+163->U+054, \
- 
 
 130 
		U+164->U+054, U+165->U+054, U+21a->U+054, U+21b->U+054, U+1e6a->U+054, \
- 
 
 131 
		U+1e6b->U+054, U+1e6c->U+054, U+1e6d->U+054, U+1e6e->U+054, U+1e6f->U+054, \
- 
 
 132 
		U+1e70->U+054, U+1e71->U+054, U+1e97->U+054, U+075->U+055, U+0d9->U+055, \
- 
 
 133 
		U+0da->U+055, U+0db->U+055, U+0dc->U+055, U+0f9->U+055, U+0fa->U+055, U+0fb->U+055, \
- 
 
 134 
		U+0fc->U+055, U+168->U+055, U+169->U+055, U+16a->U+055, U+16b->U+055, U+16c->U+055, \
- 
 
 135 
		U+16d->U+055, U+16e->U+055, U+16f->U+055, U+170->U+055, U+171->U+055, U+172->U+055, \
- 
 
 136 
		U+173->U+055, U+1af->U+055, U+1b0->U+055, U+1d3->U+055, U+1d4->U+055, U+1d5->U+055, \
- 
 
 137 
		U+1d6->U+055, U+1d7->U+055, U+1d8->U+055, U+1d9->U+055, U+1da->U+055, U+1db->U+055, \
- 
 
 138 
		U+1dc->U+055, U+214->U+055, U+215->U+055, U+216->U+055, U+217->U+055, \
- 
 
 139 
		U+1e72->U+055, U+1e73->U+055, U+1e74->U+055, U+1e75->U+055, U+1e76->U+055, \
- 
 
 140 
		U+1e77->U+055, U+1e78->U+055, U+1e79->U+055, U+1e7a->U+055, U+1e7b->U+055, \
- 
 
 141 
		U+1ee4->U+055, U+1ee5->U+055, U+1ee6->U+055, U+1ee7->U+055, U+1ee8->U+055, \
- 
 
 142 
		U+1ee9->U+055, U+1eea->U+055, U+1eeb->U+055, U+1eec->U+055, U+1eed->U+055, \
- 
 
 143 
		U+1eee->U+055, U+1eef->U+055, U+1ef0->U+055, U+1ef1->U+055, U+076->U+056, \
- 
 
 144 
		U+1e7c->U+056, U+1e7d->U+056, U+1e7e->U+056, U+1e7f->U+056, U+077->U+057, \
- 
 
 145 
		U+174->U+057, U+175->U+057, U+1e80->U+057, U+1e81->U+057, U+1e82->U+057, \
- 
 
 146 
		U+1e83->U+057, U+1e84->U+057, U+1e85->U+057, U+1e86->U+057, U+1e87->U+057, \
- 
 
 147 
		U+1e88->U+057, U+1e89->U+057, U+1e98->U+057, U+078->U+058, U+1e8a->U+058, \
- 
 
 148 
		U+1e8b->U+058, U+1e8c->U+058, U+1e8d->U+058, U+079->U+059, U+0dd->U+059, \
- 
 
 149 
		U+0fd->U+059, U+0ff->U+059, U+176->U+059, U+177->U+059, U+178->U+059, U+232->U+059, \
- 
 
 150 
		U+233->U+059, U+1e8e->U+059, U+1e8f->U+059, U+1e99->U+059, U+1ef2->U+059, \
- 
 
 151 
		U+1ef3->U+059, U+1ef4->U+059, U+1ef5->U+059, U+1ef6->U+059, U+1ef7->U+059, \
- 
 
 152 
		U+1ef8->U+059, U+1ef9->U+059, U+07a->U+05a, U+179->U+05a, U+17a->U+05a, \
- 
 
 153 
		U+17b->U+05a, U+17c->U+05a, U+17d->U+05a, U+17e->U+05a, U+1e90->U+05a, \
- 
 
 154 
		U+1e91->U+05a, U+1e92->U+05a, U+1e93->U+05a, U+1e94->U+05a, U+1e95->U+05a, \
- 
 
 155 
		U+0e6->U+0c6, U+1e2->U+0c6, U+1e3->U+0c6, U+1fc->U+0c6, U+1fd->U+0c6, U+0f0->U+0d0, \
- 
 
 156 
		U+0f8->U+0d8, U+1fe->U+0d8, U+1ff->U+0d8, U+111->U+110, U+127->U+126, U+133->U+132, \
- 
 
 157 
		U+140->U+13f, U+142->U+141, U+14b->U+14a, U+153->U+152, U+167->U+166, U+253->U+181, \
- 
 
 158 
		U+254->U+186, U+188->U+187, U+257->U+18a, U+1dd->U+18e, U+259->U+18f, U+25b->U+190, \
- 
 
 159 
		U+260->U+193, U+199->U+198, U+275->U+19f, U+1a3->U+1a2, U+1b4->U+1b3, U+1c5->U+1c4, \
- 
 
 160 
		U+1c6->U+1c4, U+1c8->U+1c7, U+1c9->U+1c7, U+1cb->U+1ca, U+1cc->U+1ca, U+1e5->U+1e4, \
- 
 
 161 
		U+1f2->U+1f1, U+1f3->U+1f1, U+21d->U+21c
- 
 
 162 
 
- 
 
 163 
 
Line 50... Line 164...
50 
    U+A8->U+B8, U+B8, U+C0..U+DF->U+E0..U+FF, U+E0..U+FF
 164 
 
51 
 
 165 
 
52 
    # later (2.1.1)
 166 
    # later (2.1.1)
Line 75... Line 189...
75 
	sql_field_string	= group_id      # sql field pour permettre du filtrage @group_id != spip par exemple
 189 
	sql_field_string	= group_id      # sql field pour permettre du filtrage @group_id != spip par exemple
76 
	sql_attr_string		= main_id
 190 
	sql_attr_string		= main_id
Line 77... Line 191...
77 
 
 191 
 
Line 78... Line 192...
78 
	sql_field_string	= titre
 192 
	sql_field_string	= titre
79 
 
 193 
 
Line 80... Line 194...
80 
	sql_query_info		= SELECT * FROM sphinx_doc WHERE id=$id
 194 
	sql_query_info		= SELECT * FROM spip_articles WHERE id_article=$id
81 
}
 195 
}
82 
 
 196 
 
Line 122... Line 236...
122 
               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 123... Line 237...
123 
 
 237 
 
124 
	sql_attr_timestamp	= gm_date_creation
 238 
	sql_attr_timestamp	= gm_date_creation
125 
	sql_field_string	= group_id
 239 
	sql_field_string	= group_id
- 
 
 240 
	sql_attr_string		= main_id
- 
 
 241 
 
126 
	sql_attr_string		= main_id
 242 
	sql_query_info		= SELECT * FROM gen_menu WHERE gm_id_menu=$id
Line 127... Line 243...
127 
}
 243 
}
128 
 
 244 
 
129 
index i_papyrus : i_common {
 245 
index i_papyrus : i_common {
Line 153... Line 269...
153 
        FROM projet
 269 
        FROM projet
Line 154... Line 270...
154 
 
 270 
 
155 
	sql_attr_timestamp	= p_date_creation
 271 
	sql_attr_timestamp	= p_date_creation
156 
	sql_field_string	= group_id
 272 
	sql_field_string	= group_id
- 
 
 273 
	sql_attr_string		= main_id
- 
 
 274 
 
157 
	sql_attr_string		= main_id
 275 
	sql_query_info		= SELECT * FROM projet WHERE p_id=$id
Line 158... Line 276...
158 
}
 276 
}
159 
 
 277 
 
160 
index i_projet : i_common {
 278 
index i_projet : i_common {
Line 175... Line 293...
175 
        FROM bazar_fiche
 293 
        FROM bazar_fiche
Line 176... Line 294...
176 
 
 294 
 
177 
	sql_attr_timestamp	= bf_date_debut_evenement
 295 
	sql_attr_timestamp	= bf_date_debut_evenement
178 
	sql_field_string	= group_id
 296 
	sql_field_string	= group_id
- 
 
 297 
	sql_attr_string		= main_id
- 
 
 298 
 
179 
	sql_attr_string		= main_id
 299 
	sql_query_info		= SELECT * FROM bazar_fiche WHERE bf_id_fiche=$id
Line 180... Line 300...
180 
}
 300 
}
181 
 
 301 
 
182 
index i_bazar : i_common {
 302 
index i_bazar : i_common {
Line 189... Line 309...
189 
 
 309 
 
190 
 
 310 
 
- 
 
 311 
 
- 
 
 312 
# COSTE
191 
 
 313 
source coste : common {
192 
# COSTE
 314 
	sql_db			= tb_eflore
193 
source coste : common {
 315 
 
194 
	sql_query		= \
 316 
	sql_query		= \
195 
        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 \
 317 
        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 \
Line 196... Line 318...
196 
        FROM tb_eflore.coste_v2_00 c \
 318 
        FROM tb_eflore.coste_v2_00 c \
197 
        LEFT JOIN tela_prod_wikini.florecoste_pages dsc ON c.page_wiki_dsc = dsc.tag AND dsc.latest = 'Y' \
 - 
 
198 
        LEFT JOIN tela_prod_wikini.florecoste_pages cle ON c.page_wiki_cle = cle.tag AND cle.latest = 'Y';
 - 
 
Line -... Line 319...
- 
 
 319 
        LEFT JOIN tela_prod_wikini.florecoste_pages dsc ON c.page_wiki_dsc = dsc.tag AND dsc.latest = 'Y' \
199 
 
 320 
        LEFT JOIN tela_prod_wikini.florecoste_pages cle ON c.page_wiki_cle = cle.tag AND cle.latest = 'Y';
Line 200... Line 321...
200 
	sql_field_string	= group_id
 321 
 
201 
    sql_query_pre   = SET NAMES utf8
 322 
	sql_field_string	= group_id
202 
    sql_query_pre   = SET CHARACTER_SET_RESULTS=utf8
 323 
 
Line 203... Line 324...
203 
 
 324 
	sql_query_info	= SELECT * FROM coste_v2_00  WHERE num_nom=$id
204 
}
 - 
 
205 
 
 - 
 
206 
index i_coste : i_common {
 - 
 
207 
	source			= coste
 - 
 
208 
	path			= /var/lib/sphinx/coste
 - 
 
209 
 
 - 
 
210 
    infix_fields    = texte, nom_sci
 - 
 
211 
 
 - 
 
212 
    # override latin1, nécessaire pour les 4 indexes ci-dessus:
 - 
 
213 
	charset_type	= utf-8
 - 
 
214 
    # valeur par défaut, cf http://sphinxsearch.com/docs/archives/1.10/conf-charset-table.html
 - 
 
215 
    # pour écraser i_common
 - 
 
216 
    charset_table = 0..9, A..Z->a..z, _, a..z, U+410..U+42F->U+430..U+44F, U+430..U+44F, \
 - 
 
217 
	    U+041..U+05a, U+0c6, U+0d0, U+0d8, U+110, U+126, U+132, U+13f, U+141, U+14a, \
 - 
 
218 
		U+152, U+166, U+181, U+186, U+187, U+18a, U+18e..U+190, U+193, U+198, U+19f, U+1a2, \
 - 
 
219 
		U+1b3, U+1c4, U+1c7, U+1ca, U+1e4, U+21c, U+061->U+041, U+0c0->U+041, U+0c1->U+041, \
 - 
 
220 
		U+0c2->U+041, U+0c3->U+041, U+0c4->U+041, U+0c5->U+041, U+0e0->U+041, U+0e1->U+041, \
 - 
 
221 
		U+0e2->U+041, U+0e3->U+041, U+0e4->U+041, U+0e5->U+041, U+100->U+041, U+101->U+041, \
 - 
 
222 
		U+102->U+041, U+103->U+041, U+104->U+041, U+105->U+041, U+1cd->U+041, U+1ce->U+041, \
 - 
 
223 
		U+1de->U+041, U+1df->U+041, U+1e0->U+041, U+1e1->U+041, U+1fa->U+041, U+1fb->U+041, \
 - 
 
224 
		U+200->U+041, U+201->U+041, U+202->U+041, U+203->U+041, U+226->U+041, U+227->U+041, \
 - 
 
225 
		U+1e01->U+041, U+1ea0->U+041, U+1ea1->U+041, U+1ea2->U+041, U+1ea3->U+041, \
 - 
 
226 
		U+1ea4->U+041, U+1ea5->U+041, U+1ea6->U+041, U+1ea7->U+041, U+1ea8->U+041, \
 - 
 
227 
		U+1ea9->U+041, U+1eaa->U+041, U+1eab->U+041, U+1eac->U+041, U+1ead->U+041, \
 - 
 
228 
		U+1eae->U+041, U+1eaf->U+041, U+1eb0->U+041, U+1eb1->U+041, U+1eb2->U+041, \
 - 
 
229 
		U+1eb3->U+041, U+1eb4->U+041, U+1eb5->U+041, U+1eb6->U+041, U+1eb7->U+041, \
 - 
 
230 
		U+062->U+042, U+1e02->U+042, U+1e03->U+042, U+1e04->U+042, U+1e05->U+042, \
 - 
 
231 
		U+1e06->U+042, U+1e07->U+042, U+063->U+043, U+0c7->U+043, U+0e7->U+043, \
 - 
 
232 
		U+106->U+043, U+107->U+043, U+108->U+043, U+109->U+043, U+10a->U+043, U+10b->U+043, \
 - 
 
233 
		U+10c->U+043, U+10d->U+043, U+1e08->U+043, U+1e09->U+043, U+064->U+044, \
 - 
 
234 
		U+10e->U+044, U+10f->U+044, U+1e0a->U+044, U+1e0b->U+044, U+1e0c->U+044, \
 - 
 
235 
		U+1e0d->U+044, U+1e0e->U+044, U+1e0f->U+044, U+1e10->U+044, U+1e11->U+044, \
 - 
 
236 
		U+1e12->U+044, U+1e13->U+044, U+065->U+045, U+0c8->U+045, U+0c9->U+045, \
 - 
 
237 
		U+0ca->U+045, U+0cb->U+045, U+0e8->U+045, U+0e9->U+045, U+0ea->U+045, U+0eb->U+045, \
 - 
 
238 
		U+112->U+045, U+113->U+045, U+114->U+045, U+115->U+045, U+116->U+045, U+117->U+045, \
 - 
 
239 
		U+118->U+045, U+119->U+045, U+11a->U+045, U+11b->U+045, U+204->U+045, U+205->U+045, \
 - 
 
240 
		U+206->U+045, U+207->U+045, U+228->U+045, U+229->U+045, U+1e14->U+045, \
 - 
 
241 
		U+1e15->U+045, U+1e16->U+045, U+1e17->U+045, U+1e18->U+045, U+1e19->U+045, \
 - 
 
242 
		U+1e1a->U+045, U+1e1b->U+045, U+1e1c->U+045, U+1e1d->U+045, U+1eb8->U+045, \
 - 
 
243 
		U+1eb9->U+045, U+1eba->U+045, U+1ebb->U+045, U+1ebc->U+045, U+1ebd->U+045, \
 - 
 
244 
		U+1ebe->U+045, U+1ebf->U+045, U+1ec0->U+045, U+1ec1->U+045, U+1ec2->U+045, \
 - 
 
245 
		U+1ec3->U+045, U+1ec4->U+045, U+1ec5->U+045, U+1ec6->U+045, U+1ec7->U+045, \
 - 
 
246 
		U+066->U+046, U+1e1e->U+046, U+1e1f->U+046, U+067->U+047, U+11c->U+047, \
 - 
 
247 
		U+11d->U+047, U+11e->U+047, U+11f->U+047, U+120->U+047, U+121->U+047, U+122->U+047, \
 - 
 
248 
		U+123->U+047, U+1e6->U+047, U+1e7->U+047, U+1f4->U+047, U+1f5->U+047, \
 - 
 
249 
		U+1e20->U+047, U+1e21->U+047, U+068->U+048, U+124->U+048, U+125->U+048, \
 - 
 
250 
		U+21e->U+048, U+21f->U+048, U+1e22->U+048, U+1e23->U+048, U+1e24->U+048, \
 - 
 
251 
		U+1e25->U+048, U+1e26->U+048, U+1e27->U+048, U+1e28->U+048, U+1e29->U+048, \
 - 
 
252 
		U+1e2a->U+048, U+1e2b->U+048, U+1e96->U+048, U+069->U+049, U+0cc->U+049, \
 - 
 
253 
		U+0cd->U+049, U+0ce->U+049, U+0cf->U+049, U+0ec->U+049, U+0ed->U+049, U+0ee->U+049, \
 - 
 
254 
		U+0ef->U+049, U+128->U+049, U+129->U+049, U+12a->U+049, U+12b->U+049, U+12c->U+049, \
 - 
 
255 
		U+12d->U+049, U+12e->U+049, U+12f->U+049, U+130->U+049, U+131->U+049, U+1cf->U+049, \
 - 
 
256 
		U+1d0->U+049, U+208->U+049, U+209->U+049, U+20a->U+049, U+20b->U+049, \
 - 
 
257 
		U+1e2c->U+049, U+1e2d->U+049, U+1e2e->U+049, U+1e2f->U+049, U+1ec8->U+049, \
 - 
 
258 
		U+1ec9->U+049, U+1eca->U+049, U+1ecb->U+049, U+06a->U+04a, U+134->U+04a, \
 - 
 
259 
		U+135->U+04a, U+1f0->U+04a, U+06b->U+04b, U+136->U+04b, U+137->U+04b, U+1e8->U+04b, \
 - 
 
260 
		U+1e9->U+04b, U+1e30->U+04b, U+1e31->U+04b, U+1e32->U+04b, U+1e33->U+04b, \
 - 
 
261 
		U+1e34->U+04b, U+1e35->U+04b, U+06c->U+04c, U+139->U+04c, U+13a->U+04c, \
 - 
 
262 
		U+13b->U+04c, U+13c->U+04c, U+13d->U+04c, U+13e->U+04c, U+1e36->U+04c, \
 - 
 
263 
		U+1e37->U+04c, U+1e38->U+04c, U+1e39->U+04c, U+1e3a->U+04c, U+1e3b->U+04c, \
 - 
 
264 
		U+1e3c->U+04c, U+1e3d->U+04c, U+06d->U+04d, U+1e3e->U+04d, U+1e3f->U+04d, \
 - 
 
265 
		U+1e40->U+04d, U+1e41->U+04d, U+1e42->U+04d, U+1e43->U+04d, U+06e->U+04e, \
 - 
 
266 
		U+0d1->U+04e, U+0f1->U+04e, U+143->U+04e, U+144->U+04e, U+145->U+04e, U+146->U+04e, \
 - 
 
267 
		U+147->U+04e, U+148->U+04e, U+1f8->U+04e, U+1f9->U+04e, U+1e44->U+04e, \
 - 
 
268 
		U+1e45->U+04e, U+1e46->U+04e, U+1e47->U+04e, U+1e48->U+04e, U+1e49->U+04e, \
 - 
 
269 
		U+1e4a->U+04e, U+1e4b->U+04e, U+06f->U+04f, U+0d2->U+04f, U+0d3->U+04f, \
 - 
 
270 
		U+0d4->U+04f, U+0d5->U+04f, U+0d6->U+04f, U+0f2->U+04f, U+0f3->U+04f, U+0f4->U+04f, \
 - 
 
271 
		U+0f5->U+04f, U+0f6->U+04f, U+14c->U+04f, U+14d->U+04f, U+14e->U+04f, U+14f->U+04f, \
 - 
 
272 
		U+150->U+04f, U+151->U+04f, U+1a0->U+04f, U+1a1->U+04f, U+1d1->U+04f, U+1d2->U+04f, \
 - 
 
273 
		U+1ea->U+04f, U+1eb->U+04f, U+1ec->U+04f, U+1ed->U+04f, U+20c->U+04f, U+20d->U+04f, \
 - 
 
274 
		U+20e->U+04f, U+20f->U+04f, U+22a->U+04f, U+22b->U+04f, U+22c->U+04f, U+22d->U+04f, \
 - 
 
275 
		U+22e->U+04f, U+22f->U+04f, U+230->U+04f, U+231->U+04f, U+1e4c->U+04f, \
 - 
 
276 
		U+1e4d->U+04f, U+1e4e->U+04f, U+1e4f->U+04f, U+1e50->U+04f, U+1e51->U+04f, \
 - 
 
277 
		U+1e52->U+04f, U+1e53->U+04f, U+1ecc->U+04f, U+1ecd->U+04f, U+1ece->U+04f, \
 - 
 
278 
		U+1ecf->U+04f, U+1ed0->U+04f, U+1ed1->U+04f, U+1ed2->U+04f, U+1ed3->U+04f, \
 - 
 
279 
		U+1ed4->U+04f, U+1ed5->U+04f, U+1ed6->U+04f, U+1ed7->U+04f, U+1ed8->U+04f, \
 - 
 
280 
		U+1ed9->U+04f, U+1eda->U+04f, U+1edb->U+04f, U+1edc->U+04f, U+1edd->U+04f, \
 - 
 
281 
		U+1ede->U+04f, U+1edf->U+04f, U+1ee0->U+04f, U+1ee1->U+04f, U+1ee2->U+04f, \
 - 
 
282 
		U+1ee3->U+04f, U+070->U+050, U+1e54->U+050, U+1e55->U+050, U+1e56->U+050, \
 - 
 
283 
		U+1e57->U+050, U+071->U+051, U+072->U+052, U+154->U+052, U+155->U+052, \
 - 
 
284 
		U+156->U+052, U+157->U+052, U+158->U+052, U+159->U+052, U+210->U+052, U+211->U+052, \
 - 
 
285 
		U+212->U+052, U+213->U+052, U+1e58->U+052, U+1e59->U+052, U+1e5a->U+052, \
 - 
 
286 
		U+1e5b->U+052, U+1e5c->U+052, U+1e5d->U+052, U+1e5e->U+052, U+1e5f->U+052, \
 - 
 
287 
		U+073->U+053, U+0df->U+053, U+15a->U+053, U+15b->U+053, U+15c->U+053, U+15d->U+053, \
 - 
 
288 
		U+15e->U+053, U+15f->U+053, U+160->U+053, U+161->U+053, U+17f->U+053, U+218->U+053, \
 - 
 
289 
		U+219->U+053, U+1e60->U+053, U+1e61->U+053, U+1e62->U+053, U+1e63->U+053, \
 - 
 
290 
		U+1e64->U+053, U+1e65->U+053, U+1e66->U+053, U+1e67->U+053, U+1e68->U+053, \
 - 
 
291 
		U+1e69->U+053, U+1e9b->U+053, U+074->U+054, U+162->U+054, U+163->U+054, \
 - 
 
292 
		U+164->U+054, U+165->U+054, U+21a->U+054, U+21b->U+054, U+1e6a->U+054, \
 - 
 
293 
		U+1e6b->U+054, U+1e6c->U+054, U+1e6d->U+054, U+1e6e->U+054, U+1e6f->U+054, \
 - 
 
294 
		U+1e70->U+054, U+1e71->U+054, U+1e97->U+054, U+075->U+055, U+0d9->U+055, \
 - 
 
295 
		U+0da->U+055, U+0db->U+055, U+0dc->U+055, U+0f9->U+055, U+0fa->U+055, U+0fb->U+055, \
 - 
 
296 
		U+0fc->U+055, U+168->U+055, U+169->U+055, U+16a->U+055, U+16b->U+055, U+16c->U+055, \
 - 
 
297 
		U+16d->U+055, U+16e->U+055, U+16f->U+055, U+170->U+055, U+171->U+055, U+172->U+055, \
 - 
 
298 
		U+173->U+055, U+1af->U+055, U+1b0->U+055, U+1d3->U+055, U+1d4->U+055, U+1d5->U+055, \
 - 
 
299 
		U+1d6->U+055, U+1d7->U+055, U+1d8->U+055, U+1d9->U+055, U+1da->U+055, U+1db->U+055, \
 - 
 
300 
		U+1dc->U+055, U+214->U+055, U+215->U+055, U+216->U+055, U+217->U+055, \
 - 
 
301 
		U+1e72->U+055, U+1e73->U+055, U+1e74->U+055, U+1e75->U+055, U+1e76->U+055, \
 - 
 
302 
		U+1e77->U+055, U+1e78->U+055, U+1e79->U+055, U+1e7a->U+055, U+1e7b->U+055, \
 - 
 
303 
		U+1ee4->U+055, U+1ee5->U+055, U+1ee6->U+055, U+1ee7->U+055, U+1ee8->U+055, \
 - 
 
304 
		U+1ee9->U+055, U+1eea->U+055, U+1eeb->U+055, U+1eec->U+055, U+1eed->U+055, \
 - 
 
305 
		U+1eee->U+055, U+1eef->U+055, U+1ef0->U+055, U+1ef1->U+055, U+076->U+056, \
 - 
 
306 
		U+1e7c->U+056, U+1e7d->U+056, U+1e7e->U+056, U+1e7f->U+056, U+077->U+057, \
 - 
 
307 
		U+174->U+057, U+175->U+057, U+1e80->U+057, U+1e81->U+057, U+1e82->U+057, \
 - 
 
308 
		U+1e83->U+057, U+1e84->U+057, U+1e85->U+057, U+1e86->U+057, U+1e87->U+057, \
 - 
 
309 
		U+1e88->U+057, U+1e89->U+057, U+1e98->U+057, U+078->U+058, U+1e8a->U+058, \
 - 
 
310 
		U+1e8b->U+058, U+1e8c->U+058, U+1e8d->U+058, U+079->U+059, U+0dd->U+059, \
 - 
 
311 
		U+0fd->U+059, U+0ff->U+059, U+176->U+059, U+177->U+059, U+178->U+059, U+232->U+059, \
 - 
 
312 
		U+233->U+059, U+1e8e->U+059, U+1e8f->U+059, U+1e99->U+059, U+1ef2->U+059, \
 - 
 
313 
		U+1ef3->U+059, U+1ef4->U+059, U+1ef5->U+059, U+1ef6->U+059, U+1ef7->U+059, \
 - 
 
314 
		U+1ef8->U+059, U+1ef9->U+059, U+07a->U+05a, U+179->U+05a, U+17a->U+05a, \
 - 
 
315 
		U+17b->U+05a, U+17c->U+05a, U+17d->U+05a, U+17e->U+05a, U+1e90->U+05a, \
 - 
 
316 
		U+1e91->U+05a, U+1e92->U+05a, U+1e93->U+05a, U+1e94->U+05a, U+1e95->U+05a, \
 - 
 
317 
		U+0e6->U+0c6, U+1e2->U+0c6, U+1e3->U+0c6, U+1fc->U+0c6, U+1fd->U+0c6, U+0f0->U+0d0, \
 325 
}
Line 318... Line 326...
318 
		U+0f8->U+0d8, U+1fe->U+0d8, U+1ff->U+0d8, U+111->U+110, U+127->U+126, U+133->U+132, \
 326 
 
319 
		U+140->U+13f, U+142->U+141, U+14b->U+14a, U+153->U+152, U+167->U+166, U+253->U+181, \
 327 
index i_coste : i_common {