Скачиваем сфинкс (берем версию с MySQL и со стеммингом на 15 языков Win32 binaries w/MySQL+PgSQL+libstemmer+id64 support соответствующую битности твоей ОС), распаковываем например в d:\temp\s\
На этом установка sphinx завершена. В дебиане просто делаем sudo apt-get install sphinxsearch.
Создаем таблицы:
CREATE TABLE news
(id INT(10) AUTO_INCREMENT PRIMARY KEY, topic INT(10) NOT NULL, header VARCHAR(200) NOT NULL,
| searchd | |
| { | |
| listen = 9306:mysql41 | |
| listen = /var/run/mysqld/mysqld.sock:mysql41 | |
| listen = 9308:http | |
| log = /var/log/manticore/searchd.log | |
| query_log = /var/log/manticore/query.log | |
| binlog_path = /var/log/manticore | |
| pid_file = /var/run/manticore/searchd.pid | |
| mysql_version_string = 5.0.0 |
| RAL | RGB | HEX | German | English | French | Spanish | Italian | Nederlands | |
|---|---|---|---|---|---|---|---|---|---|
| RAL 1000 | 190-189-127 | #BEBD7F | Grünbeige | Green beige | Beige vert | Beige verdoso | Beige verdastro | Groenbeige | |
| RAL 1001 | 194-176-120 | #C2B078 | Beige | Beige | Beige | Beige | Beige | Beige | |
| RAL 1002 | 198-166-100 | #C6A664 | Sandgelb | Sand yellow | Jaune sable | Amarillo arena | Giallo sabbia | Zandgeel | |
| RAL 1003 | 229-190-001 | #E5BE01 | Signalgelb | Signal yellow | Jaune de sécurité | Amarillo señales | Giallo segnale | Signaalgeel | |
| RAL 1004 | 205-164-052 | #CDA434 | Goldgelb | Golden yellow | Jaune or | Amarillo oro | Giallo oro | Goudgeel | |
| RAL 1005 | 169-131-007 | #A98307 | Honiggelb | Honey yellow | Jaune miel | Amarillo miel | Giallo miele | Honinggeel | |
| RAL 1006 | 228-160-016 | #E4A010 | Maisgelb | Maize yellow | Jaune maïs | Amarillo maiz | Giallo polenta | Maisgeel | |
| RAL 1007 | 220-156-000 | #DC9D00 | Narzissengelb | Daffodil yellow | Jaune narcisse | Amarillo narciso | Giallo narciso | Narcissengeel | |
| RAL 1011 | 138-102-066 | #8A6642 | Braunbeige | Brown beige | Beige brun | Beige pardo | Beige marrone | Bruinbeige |
| { | |
| "RAL 1000" :"Зелено-бежевый", | |
| "RAL 1001" :"Бежевый", | |
| "RAL 1002" :"Песочно-желтый", | |
| "RAL 1003" :"Сигнальный желтый", | |
| "RAL 1004" :"Золотисто-желтый", | |
| "RAL 1005" :"Медово-желтый", | |
| "RAL 1006" :"Кукурузно-желтый", | |
| "RAL 1007" :"Желтый нарцисс", | |
| "RAL 1011" :"Коричнево-бежевый", |
| <?php | |
| $c = $modx->newQuery('modUser'); | |
| $c->InnerJoin('modUserProfile', 'Profile'); | |
| $c->InnerJoin('msOrder', 'msOrder', 'modUser.id = msOrder.user_id'); | |
| $c->InnerJoin('msOrderAddress', 'msOrderAddress','msOrder.address = msOrderAddress.id'); | |
| $c->where(array( | |
| 'modUser.active' => 1, | |
| )); |
| <?php | |
| $step = 1; | |
| if (!isset($_SESSION['Console']['completed'])) { | |
| $_SESSION['console_offset'] = 0; | |
| } | |
| $offset = isset($_SESSION['console_offset']) && $_SESSION['console_offset'] ? $_SESSION['console_offset'] : 0; | |
| $q = $modx->newQuery('modResource'); | |
| $q->where(array( | |
| 'class_key' => 'msProduct', |
| Ext.override(Ext.Component, { | |
| findParentByType: function(type){ | |
| if (Ext.isFunction(type)){ | |
| return this.findParentBy(function(p){ | |
| return p instanceof type; | |
| }); | |
| } else { | |
| return (Ext.isFunction(Ext.ComponentMgr.types[type]))? | |
| this.findParentByType(Ext.ComponentMgr.types[type]): | |
| null; |
| <?php | |
| /** @var modX $modx */ | |
| /** @var array $scriptProperties */ | |
| switch ($modx->event->name) { | |
| // расчет стоимости события | |
| case "UserEventsOnBeforeGetOrderCost": | |
| /** @var UserEventsOrderInterface $orderHandler */ | |
| $orderHandler = $modx->getOption("order", $scriptProperties); |
| <?php | |
| ini_set('display_errors', 1); | |
| ini_set('error_reporting', -1); | |
| define('MODX_API_MODE', true); | |
| $productionConfig = (dirname(dirname(__FILE__))) . '/index.php'; | |
| if (file_exists($productionConfig)) { | |
| /** @noinspection PhpIncludeInspection */ | |
| require_once $productionConfig; |