API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Dec 1st, 2016
146
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 15.33 KB | None | 0 0
raw download clone embed print report
  1.  
  2. source book24{
  3. # Параметры подключения к БД
  4. type = mysql
  5. sql_host = localhost
  6. sql_user = root
  7. sql_pass =
  8. sql_db = b24
  9. sql_port = 3306
  10.  
  11. # Установим кодировку для работы с БД
  12. sql_query_pre = SET NAMES utf8
  13. sql_query_pre = SET CHARACTER SET utf8
  14.  
  15. # Запрос выборки данных для индексации
  16. sql_query = SELECT \
  17. ELEMENT.ID as ID,\
  18. ELEMENT.ID as ELEMENT_ID,\
  19. ELEMENT.NAME as ELEMENT_NAME,\
  20. (SELECT GROUP_CONCAT(b_iblock_section_element.IBLOCK_SECTION_ID) FROM b_iblock_section_element WHERE b_iblock_section_element.IBLOCK_ELEMENT_ID=ELEMENT.ID) as IBLOCK_SECTION_ID_COMB,\
  21. ELEMENT_SECTION.NAME as ELEMENT_IBLOCK_SECTION_NAME,\
  22. ELEMENT_SECTION.CODE as ELEMENT_IBLOCK_SECTION_CODE,\
  23. ELEMENT.DETAIL_TEXT as ELEMENT_DETAIL_TEXT,\
  24. ELEMENT.PREVIEW_TEXT as ELEMENT_PREVIEW_TEXT,\
  25. ELEMENT.CODE as ELEMENT_CODE,\
  26. ELEMENT.XML_ID as ELEMENT_XML_ID,\
  27. ELEMENT.TAGS as ELEMENT_TAGS,\
  28. ELEMENT_PRICE.PRICE as ELEMENT_PRICE,\
  29. ELEMENT.DETAIL_PICTURE as ELEMENT_DETAIL_PICTURE,\
  30. AUTHOR_TITLE_PROP.VALUE as AUTHOR_TITLE,\
  31. SERIES_PROP_ID.VALUE as SERIES_ID,\
  32. SERIES_ELEMENT.NAME as SERIES_NAME,\
  33. SERIES_ELEMENT.CODE as SERIES_CODE,\
  34. PUBL_PROP_ID.VALUE as PUBL_ID,\
  35. PUBL_ELEMENT.NAME as PUBL_NAME,\
  36. PUBL_ELEMENT.CODE as PUBL_CODE,\
  37. AVAILABLE_PROP.VALUE as AVAILABLE_VALUE_ID,\
  38. PREDZAKAZ_PROP.VALUE as PREDZAKAZ_VALUE_ID,\
  39. FRAGMENT_PROP.VALUE as FRAGMENT_VALUE_ID,\
  40. SELECTIONS.IBLOCK_ELEMENT_ID as SELECTIONS_ELEMENT_ID,\
  41. SELECTIONS_ELEMENT.NAME as SELECTIONS_ELEMENT_NAME,\
  42. NOMCODE.VALUE as NOMCODE,\
  43. SALE_CLOSE_PROP.VALUE as SALE_CLOSE_VALUE,\
  44. SALELEADER_PROP.VALUE as SALELEADER_VALUE_ID,\
  45. SPECIALOFFER_PROP.VALUE as SPECIALOFFER_VALUE_ID,\
  46. AUTOGRAPH_PROP.VALUE as AUTOGRAPH_VALUE_ID,\
  47. CRC32(AGE_LIMIT_PROP.VALUE) as AGE_LIMIT_CRC32,\
  48. AGE_LIMIT_PROP.VALUE as AGE_LIMIT,\
  49. FOR_KIDS_PROP.VALUE as FOR_KIDS_VALUE_ID,\
  50. EXAM_PROP.VALUE as EXAM_VALUE_ID,\
  51. (SELECT GROUP_CONCAT(b_iblock_element_property.VALUE) FROM b_iblock_element_property WHERE b_iblock_element_property.IBLOCK_PROPERTY_ID=24 AND b_iblock_element_property.IBLOCK_ELEMENT_ID=ELEMENT.ID) as AUTHOR_ID_COMB,\
  52. (SELECT GROUP_CONCAT(b_iblock_element_property.VALUE) FROM b_iblock_element_property WHERE b_iblock_element_property.IBLOCK_PROPERTY_ID=61 AND b_iblock_element_property.IBLOCK_ELEMENT_ID=ELEMENT.ID) as GRADE_VALUE_COMB,\
  53. (SELECT GROUP_CONCAT(b_iblock_element_property.VALUE) FROM b_iblock_element_property WHERE b_iblock_element_property.IBLOCK_PROPERTY_ID=62 AND b_iblock_element_property.IBLOCK_ELEMENT_ID=ELEMENT.ID) as SUBJECT_VALUE_COMB,\
  54. MATERIAL_TYPE_PROP.VALUE as MATERIAL_TYPE_VALUE_ID,\
  55. UMK_PROP.VALUE as UMK_VALUE_ID,\
  56. PROD_TEXT_PROP.VALUE as PROD_TEXT_VALUE,\
  57. ISBN_PROP.VALUE as ISBN,\
  58. RAITING_PROP.VALUE as RAITING,\
  59. COVER_PROP.VALUE as COVER \
  60. FROM b_iblock_element as ELEMENT \
  61. LEFT JOIN b_iblock_element_property as AUTHOR_TITLE_PROP ON AUTHOR_TITLE_PROP.IBLOCK_PROPERTY_ID=25 AND AUTHOR_TITLE_PROP.IBLOCK_ELEMENT_ID=ELEMENT.ID \
  62. LEFT JOIN b_iblock_element_property as SALELEADER_PROP ON SALELEADER_PROP.IBLOCK_PROPERTY_ID=10 AND SALELEADER_PROP.IBLOCK_ELEMENT_ID=ELEMENT.ID \
  63. LEFT JOIN b_iblock_element_property as NOMCODE ON NOMCODE.IBLOCK_PROPERTY_ID=4 AND NOMCODE.IBLOCK_ELEMENT_ID=ELEMENT.ID \
  64. LEFT JOIN b_iblock_element_property as SERIES_PROP_ID ON SERIES_PROP_ID.IBLOCK_PROPERTY_ID=182 AND SERIES_PROP_ID.IBLOCK_ELEMENT_ID=ELEMENT.ID \
  65. LEFT JOIN b_iblock_element as SERIES_ELEMENT ON SERIES_ELEMENT.ID=SERIES_PROP_ID.VALUE \
  66. LEFT JOIN b_iblock_element_property as PUBL_PROP_ID ON PUBL_PROP_ID.IBLOCK_PROPERTY_ID=30 AND PUBL_PROP_ID.IBLOCK_ELEMENT_ID=ELEMENT.ID \
  67. LEFT JOIN b_iblock_element as PUBL_ELEMENT ON PUBL_ELEMENT.ID=PUBL_PROP_ID.VALUE \
  68. LEFT JOIN b_iblock_element_property as AVAILABLE_PROP ON AVAILABLE_PROP.IBLOCK_PROPERTY_ID=8 AND AVAILABLE_PROP.IBLOCK_ELEMENT_ID=ELEMENT.ID \
  69. LEFT JOIN b_iblock_element_property as PREDZAKAZ_PROP ON PREDZAKAZ_PROP.IBLOCK_PROPERTY_ID=22 AND PREDZAKAZ_PROP.IBLOCK_ELEMENT_ID=ELEMENT.ID \
  70. LEFT JOIN b_iblock_section as ELEMENT_SECTION ON ELEMENT_SECTION.IBLOCK_ID=1 AND ELEMENT_SECTION.ID=ELEMENT.IBLOCK_SECTION_ID \
  71. LEFT JOIN b_iblock_element_property as FRAGMENT_PROP ON FRAGMENT_PROP.IBLOCK_PROPERTY_ID=178 AND FRAGMENT_PROP.IBLOCK_ELEMENT_ID=ELEMENT.ID \
  72. LEFT JOIN b_catalog_price as ELEMENT_PRICE ON ELEMENT_PRICE.CATALOG_GROUP_ID=1 AND ELEMENT_PRICE.PRODUCT_ID=ELEMENT.ID \
  73. LEFT JOIN b_iblock_element_property as SELECTIONS ON SELECTIONS.IBLOCK_PROPERTY_ID=110 AND SELECTIONS.VALUE=ELEMENT.XML_ID \
  74. LEFT JOIN b_iblock_element as SELECTIONS_ELEMENT ON SELECTIONS_ELEMENT.ID=SELECTIONS.IBLOCK_ELEMENT_ID \
  75. LEFT JOIN b_iblock_element_property as SPECIALOFFER_PROP ON SPECIALOFFER_PROP.IBLOCK_PROPERTY_ID=11 AND SPECIALOFFER_PROP.IBLOCK_ELEMENT_ID=ELEMENT.ID \
  76. LEFT JOIN b_iblock_element_property as AUTOGRAPH_PROP ON AUTOGRAPH_PROP.IBLOCK_PROPERTY_ID=13 AND AUTOGRAPH_PROP.IBLOCK_ELEMENT_ID=ELEMENT.ID \
  77. LEFT JOIN b_iblock_element_property as AGE_LIMIT_PROP ON AGE_LIMIT_PROP.IBLOCK_PROPERTY_ID=19 AND AGE_LIMIT_PROP.IBLOCK_ELEMENT_ID=ELEMENT.ID \
  78. LEFT JOIN b_iblock_element_property as SALE_CLOSE_PROP ON SALE_CLOSE_PROP.IBLOCK_PROPERTY_ID=39 AND SALE_CLOSE_PROP.IBLOCK_ELEMENT_ID=ELEMENT.ID \
  79. LEFT JOIN b_iblock_element_property as FOR_KIDS_PROP ON FOR_KIDS_PROP.IBLOCK_PROPERTY_ID=55 AND FOR_KIDS_PROP.IBLOCK_ELEMENT_ID=ELEMENT.ID \
  80. LEFT JOIN b_iblock_element_property as EXAM_PROP ON EXAM_PROP.IBLOCK_PROPERTY_ID=60 AND EXAM_PROP.IBLOCK_ELEMENT_ID=ELEMENT.ID \
  81. LEFT JOIN b_iblock_element_property as MATERIAL_TYPE_PROP ON MATERIAL_TYPE_PROP.IBLOCK_PROPERTY_ID=63 AND MATERIAL_TYPE_PROP.IBLOCK_ELEMENT_ID=ELEMENT.ID \
  82. LEFT JOIN b_iblock_element_property as UMK_PROP ON UMK_PROP.IBLOCK_PROPERTY_ID=64 AND UMK_PROP.IBLOCK_ELEMENT_ID=ELEMENT.ID \
  83. LEFT JOIN b_iblock_element_property as PROD_TEXT_PROP ON PROD_TEXT_PROP.IBLOCK_PROPERTY_ID=47 AND PROD_TEXT_PROP.IBLOCK_ELEMENT_ID=ELEMENT.ID \
  84. LEFT JOIN b_iblock_element_property as ISBN_PROP ON ISBN_PROP.IBLOCK_PROPERTY_ID=32 AND ISBN_PROP.IBLOCK_ELEMENT_ID=ELEMENT.ID \
  85. LEFT JOIN b_iblock_element_property as RAITING_PROP ON RAITING_PROP.IBLOCK_PROPERTY_ID=67 AND RAITING_PROP.IBLOCK_ELEMENT_ID=ELEMENT.ID \
  86. LEFT JOIN b_iblock_element_property as COVER_PROP ON COVER_PROP.IBLOCK_PROPERTY_ID=41 AND COVER_PROP.IBLOCK_ELEMENT_ID=ELEMENT.ID \
  87. WHERE ELEMENT.IBLOCK_ID = 1
  88.  
  89. sql_attr_uint = ELEMENT_ID
  90. sql_field_string = ELEMENT_NAME
  91. sql_field_string = RAITING
  92. sql_attr_multi = uint IBLOCK_SECTION_ID_COMB from field
  93. sql_attr_multi = uint GRADE_VALUE_COMB from field
  94. sql_attr_multi = uint SUBJECT_VALUE_COMB from field
  95. sql_attr_multi = uint AUTHOR_ID_COMB from field
  96. sql_field_string = ELEMENT_IBLOCK_SECTION_NAME
  97. sql_field_string = ELEMENT_IBLOCK_SECTION_CODE
  98. sql_field_string = ELEMENT_DETAIL_TEXT
  99. sql_field_string = ELEMENT_PREVIEW_TEXT
  100. sql_field_string = ELEMENT_CODE
  101. sql_field_string = ELEMENT_XML_ID
  102. sql_field_string = ELEMENT_TAGS
  103. sql_attr_uint = ELEMENT_PRICE
  104. sql_field_string = AUTHOR_TITLE
  105. sql_attr_uint = SERIES_ID
  106. sql_field_string = SERIES_NAME
  107. sql_field_string = SERIES_CODE
  108. sql_attr_uint = PUBL_ID
  109. sql_field_string = PUBL_NAME
  110. sql_field_string = PUBL_CODE
  111. sql_attr_uint = AVAILABLE_VALUE_ID
  112. sql_attr_uint = PREDZAKAZ_VALUE_ID
  113. sql_attr_uint = FRAGMENT_VALUE_ID
  114. sql_field_string = SELECTIONS_ELEMENT_ID
  115. sql_field_string = SELECTIONS_ELEMENT_NAME
  116. sql_field_string = NOMCODE
  117. sql_field_string = SALE_CLOSE_VALUE
  118. sql_attr_uint = SALELEADER_VALUE_ID
  119. sql_attr_uint = SPECIALOFFER_VALUE_ID
  120. sql_attr_uint = AUTOGRAPH_VALUE_ID
  121. sql_attr_uint = AGE_LIMIT_CRC32
  122. sql_field_string = AGE_LIMIT
  123. sql_attr_uint = FOR_KIDS_VALUE_ID
  124. sql_attr_uint = EXAM_VALUE_ID
  125. sql_attr_uint = MATERIAL_TYPE_VALUE_ID
  126. sql_attr_uint = UMK_VALUE_ID
  127. sql_field_string = PROD_TEXT_VALUE
  128. sql_field_string = ISBN
  129. sql_field_string = COVER
  130. }
  131.  
  132. source author_v2{
  133. # Параметры подключения к БД
  134. type = mysql
  135. sql_host = localhost
  136. sql_user = root
  137. sql_pass =
  138. sql_db = b24
  139. sql_port = 3306
  140.  
  141. # Установим кодировку для работы с БД
  142. sql_query_pre = SET NAMES utf8
  143. sql_query_pre = SET CHARACTER SET utf8
  144.  
  145. sql_query = select ID, NAME, CODE, PREVIEW_TEXT, DETAIL_TEXT, PREVIEW_PICTURE, DETAIL_PICTURE, ID as author_id, NAME as author_name, CODE as author_code, PREVIEW_TEXT as author_preview_text, DETAIL_TEXT as author_detail_text, PREVIEW_PICTURE as author_preview_picture, DETAIL_PICTURE as author_detail_picture, (select GROUP_CONCAT(b_iblock_element_prop_m2.VALUE) from b_iblock_element_prop_m2 where b_iblock_element_prop_m2.IBLOCK_ELEMENT_ID=a.ID) as best_book, (select GROUP_CONCAT(mp1.VALUE) from b_iblock_element_prop_m1 as mp1 where mp1.IBLOCK_PROPERTY_ID = 14 and mp1.IBLOCK_ELEMENT_ID IN (select mp2.IBLOCK_ELEMENT_ID from b_iblock_element_prop_m1 as mp2 where mp2.IBLOCK_PROPERTY_ID = 24 and mp2.VALUE = a.ID)) as quotes, author_prop.PROPERTY_241 as author_anounce from b_iblock_element as a left join b_iblock_element_prop_s2 as author_prop on author_prop.IBLOCK_ELEMENT_ID=a.ID where a.IBLOCK_ID = 2
  146.  
  147. sql_attr_uint = author_id
  148. sql_attr_string = author_name
  149. sql_attr_string = author_code
  150. sql_attr_string = author_anounce
  151. sql_attr_string = author_preview_text
  152. sql_attr_string = author_detail_text
  153. sql_attr_string = author_preview_picture
  154. sql_attr_string = author_detail_picture
  155. sql_attr_multi = uint best_book from field;
  156. sql_attr_multi = uint quotes from field;
  157. }
  158.  
  159. index author_v2
  160. {
  161. source = author_v2
  162. path = f:/sphinx/data/index/author_v2
  163. docinfo = extern
  164. morphology = lemmatize_ru_all, lemmatize_en_all
  165. charset_table = 0..9, A..Z->a..z, _, a..z, U+410..U+42F->U+430..U+44F, U+430..U+44F, U+0401->U+0435, U+0451->U+0435, U+401->U+0435, U+451->U+0435
  166. ignore_chars = U+002E
  167. index_exact_words=1
  168. dict=keywords
  169. min_prefix_len = 3
  170. }
  171.  
  172.  
  173. source serie_v2{
  174. # Параметры подключения к БД
  175. type = mysql
  176. sql_host = localhost
  177. sql_user = root
  178. sql_pass =
  179. sql_db = b24
  180. sql_port = 3306
  181.  
  182. # Установим кодировку для работы с БД
  183. sql_query_pre = SET NAMES utf8
  184. sql_query_pre = SET CHARACTER SET utf8
  185.  
  186. sql_query = select ID, NAME, CODE, PREVIEW_TEXT, DETAIL_TEXT, ID as serie_id, NAME as serie_name, CODE as serie_code from b_iblock_element where IBLOCK_ID = 11
  187. sql_attr_uint = serie_id
  188. sql_attr_string = serie_name
  189. sql_attr_string = serie_code
  190. }
  191.  
  192. index serie_v2
  193. {
  194. source = serie_v2
  195. path = f:/sphinx/data/index/serie_v2
  196. docinfo = extern
  197. morphology = lemmatize_ru_all, lemmatize_en_all
  198. charset_table = 0..9, A..Z->a..z, _, a..z, U+410..U+42F->U+430..U+44F, U+430..U+44F, U+0401->U+0435, U+0451->U+0435, U+401->U+0435, U+451->U+0435
  199. ignore_chars = U+002E
  200. index_exact_words=1
  201. dict=keywords
  202. min_prefix_len = 3
  203. }
  204.  
  205. source publisher_v1{
  206. # Параметры подключения к БД
  207. type = mysql
  208. sql_host = localhost
  209. sql_user = root
  210. sql_pass =
  211. sql_db = b24
  212. sql_port = 3306
  213.  
  214. # Установим кодировку для работы с БД
  215. sql_query_pre = SET NAMES utf8
  216. sql_query_pre = SET CHARACTER SET utf8
  217.  
  218. sql_query = select ID, NAME, CODE, PREVIEW_TEXT, DETAIL_TEXT, PREVIEW_PICTURE, DETAIL_PICTURE, ID as publisher_id, NAME as publisher_name, CODE as publisher_code, PREVIEW_TEXT as publisher_preview_text, DETAIL_TEXT as publisher_detail_text, PREVIEW_PICTURE as publisher_preview_picture, DETAIL_PICTURE as publisher_detail_picture, (select GROUP_CONCAT(mp1.VALUE) from b_iblock_element_prop_m1 as mp1 where mp1.IBLOCK_PROPERTY_ID = 14 and mp1.IBLOCK_ELEMENT_ID IN (select mp2.IBLOCK_ELEMENT_ID from b_iblock_element_prop_s1 as mp2 where mp2.PROPERTY_30 = a.ID)) as quotes from b_iblock_element as a where a.IBLOCK_ID = 8
  219. sql_attr_uint = publisher_id
  220. sql_attr_string = publisher_name
  221. sql_attr_string = publisher_code
  222. sql_attr_string = publisher_preview_text
  223. sql_attr_string = publisher_detail_text
  224. sql_attr_string = publisher_preview_picture
  225. sql_attr_string = publisher_detail_picture
  226. sql_attr_multi = uint quotes from field;
  227. }
  228.  
  229. index publisher_v1
  230. {
  231. source = publisher_v1
  232. path = f:/sphinx/data/index/publisher_v1
  233. docinfo = extern
  234. morphology = lemmatize_ru_all, lemmatize_en_all
  235. charset_table = 0..9, A..Z->a..z, _, a..z, U+410..U+42F->U+430..U+44F, U+430..U+44F, U+0401->U+0435, U+0451->U+0435, U+401->U+0435, U+451->U+0435
  236. ignore_chars = U+002E
  237. index_exact_words=1
  238. dict=keywords
  239. min_prefix_len = 3
  240. }
  241.  
  242. index b24_v20
  243. {
  244. type = rt
  245. path = f:/sphinx/data/index/b24_v25
  246. morphology = lemmatize_ru_all, lemmatize_en_all
  247. wordforms = f:/projects/book24/search/sphinx/data/wordforms/wordforms.txt
  248. charset_table = 0..9, A..Z->a..z, _, a..z, U+410..U+42F->U+430..U+44F, U+430..U+44F, U+0401->U+0435, U+0451->U+0435, U+401->U+0435, U+451->U+0435
  249. ignore_chars = U+002E
  250. index_exact_words=1
  251. dict=keywords
  252. min_prefix_len = 3
  253. rt_mem_limit = 8192M
  254.  
  255. rt_field = name
  256. rt_field = section_name
  257. rt_field = author_name
  258. rt_field = serie_name
  259. rt_field = publisher_name
  260. rt_field = detail_text
  261. rt_field = prod_text
  262. rt_field = seo_text
  263. rt_field = tags
  264. rt_field = author_alias_name
  265. rt_field = material_type
  266. rt_field = naznachenie
  267. rt_field = isbn
  268. rt_attr_string = name
  269. rt_attr_string = author_alias_name
  270. rt_attr_string = section_name
  271. rt_attr_string = author_name
  272. rt_attr_string = serie_name
  273. rt_attr_string = publisher_name
  274. rt_attr_string = brand_name
  275. rt_attr_string = isbn
  276. rt_attr_string = nomcode
  277. rt_attr_string = rdc
  278. rt_attr_string = nom_folder
  279. rt_attr_uint = exam_attr
  280. rt_attr_string = element_code
  281. rt_attr_bool = available_attr
  282. rt_attr_bool = newproduct_attr
  283. rt_attr_bool = saleleader_attr
  284. rt_attr_bool = specialoffer_attr
  285. rt_attr_bool = popular_attr
  286. rt_attr_bool = autograph_attr
  287. rt_attr_bool = ast_predzakaz_attr
  288. rt_attr_bool = predzakaz_attr
  289. rt_attr_bool = gift_attr
  290. rt_attr_bool = free_delivery_attr
  291. rt_attr_bool = gift_exclusive_attr
  292. rt_attr_bool = gift_calendar_attr
  293. rt_attr_bool = book_cover_attr
  294. rt_attr_bool = fragment_attr
  295. rt_attr_uint = umk_attr
  296. rt_attr_uint = date_attr
  297. rt_attr_uint = element_id
  298. rt_attr_uint = serie_id_attr
  299. rt_attr_uint = sort
  300. rt_attr_uint = sort_ast
  301. rt_attr_uint = sort_df
  302. rt_attr_uint = age_limit_attr
  303. rt_attr_uint = publisher_id_attr
  304. rt_attr_uint = brand_id_attr
  305. rt_attr_uint = material_type_attr
  306. rt_attr_uint = naznachenie_attr
  307. rt_attr_uint = literature_age_attr
  308. rt_attr_uint = price
  309. rt_attr_uint = price_group_10
  310. rt_attr_uint = price_group_11
  311. rt_attr_uint = price_group_12
  312. rt_attr_uint = price_group_13
  313. rt_attr_uint = price_discount
  314. rt_attr_multi = gift_collection_attr
  315. rt_attr_multi = grade_attr
  316. rt_attr_multi = subject_attr
  317. rt_attr_multi = gift_present_attr
  318. rt_attr_multi = gift_interest_attr
  319. rt_attr_multi = gift_event_attr
  320. rt_attr_multi = section_id
  321. rt_attr_multi = section_id_attr
  322. rt_attr_multi = author_id_attr
  323. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!