= '" . check_to_sql($_GET[price_from]) . "'"; $query_to_url_arr[] = 'price_from=' . $_GET[price_from]; } if ($_GET[price_to]) { $query_to_sql_where_arr[] = "catalogue_goods.price <= '" . check_to_sql($_GET[price_to]) . "'"; $query_to_url_arr[] = 'price_to=' . $_GET[price_to]; } if ($_GET[order_on]) { $query_to_sql_order_string = " ORDER BY catalogue_goods." . check_to_sql($_GET[order_on]) . ""; $query_to_url_arr[] = 'order_on=' . $_GET[order_on]; if ($_GET[order_type] == desc) { $query_to_sql_order_string .= " DESC"; $query_to_url_arr[] = 'order_type=' . $_GET[order_type]; } else $query_to_sql_order_string .= " ASC"; } else $query_to_sql_order_string = " ORDER BY `rank` ASC"; if (!$page_n) $page_n = 1; if ($_GET[q_in_page]) $q_in_page = $_GET[q_in_page]; else $q_in_page = $CONFIG_WSS_ENGINE[q_in_page]; $limit_to = $page_n * $q_in_page; $limit_from = $limit_to - $q_in_page; $query_to_sql_limit_string = " LIMIT " . $limit_from . ", " . $q_in_page . ""; $query_to_url_arr[] = 'q_in_page=' . $_GET[q_in_page]; $query_to_sql_where_string = @implode(' AND ', $query_to_sql_where_arr); if ($query_to_sql_where_string) $query_to_sql_where_string = ' AND ' . $query_to_sql_where_string; $query_to_url_string = implode('&', $query_to_url_arr); if ($query_to_url_string) $query_to_url_string = '?' . $query_to_url_string; $query_to_sql_string = $query_to_sql_where_string . $query_to_sql_order_string; ### Разбор запросов к базе END if (!$query_params[id_goods] AND !$query_params[id_category][0] AND !$query_params[id_brand] AND !$query_params[search]) { @include_once($_SERVER['DOCUMENT_ROOT'] . '/catalogue/case_no_param.php'); } elseif ($query_params[id_goods]) { $content .= view_goods($query_params[id_goods]); } ### Если выбран конкретный товар - END ####################################################################################################### ####################################################################################################### ####################################################################################################### ####################################################################################################### ### Если выбрана категория но не выбран бренд а также $CONFIG_WSS_ENGINE[catalogue][category_view_mode_1] установлено в режиме "сначала выбрать бренд" - START elseif ($query_params[id_category] AND !$query_params[id_brand] AND $CONFIG_WSS_ENGINE[catalogue][category_view_mode_1] == 'brand') { @include_once($_SERVER['DOCUMENT_ROOT'] . '/catalogue/case_no_brand.php'); } ### Если выбрана категория и бренд либо выбрана только категория и $CONFIG_WSS_ENGINE[catalogue][category_view_mode_1] стоит в режиме "выводить все товары данной категории" - START elseif ($query_params[id_brand] AND $query_params[id_category] OR !$query_params[id_brand] AND $query_params[id_category] AND $CONFIG_WSS_ENGINE[catalogue][category_view_mode_1] == 'goods' ) { @include_once($_SERVER['DOCUMENT_ROOT'] . '/catalogue/case_brand_&_category.php'); } ### Если выбран бренд и категория - END ####################################################################################################### ####################################################################################################### ####################################################################################################### ####################################################################################################### ### Если выбран бренд а категория не выбрана - START elseif ($query_params[id_brand] AND !$query_params[id_category]) { @include_once($_SERVER['DOCUMENT_ROOT'] . '/catalogue/case_brand_no_category.php'); } ### Если выбран бренд а категория не выбрана - END ####################################################################################################### ####################################################################################################### ####################################################################################################### ####################################################################################################### ### Поиск - START elseif ($query_params[search]) { if (!$_POST[query]) $content .= '

Поисковый запрос не задан!


'; else if (mb_strlen($_POST[query]) < 3) { $content .= '

Поисковый запрос должен содержать больше 2 символов!


'; } else { $content .= '

Поиск по запросу: ' . $_POST[query] . '

'; ##################################################################### @include_once($_SERVER['DOCUMENT_ROOT'] . '/catalogue/stemmer.php'); $stemmer = new stemmer(); $query = mysql_real_escape_string(strip_tags(trim($_POST[query]))); $query = str_replace(" +", " ", $query); $query = str_replace(" ", " ", $query); $good_words = $stemmer->stem_words($query); $query = "SELECT *, IF( name LIKE '%" . str_replace(" ", "%' and name LIKE '%", $good_words) . "%', " . (substr_count($good_words, " ") + 1) . "*10, 0) + IF( name LIKE '%" . str_replace(" ", "%', 9, 0) + IF( name LIKE '%", $good_words) . "%', 9, 0) AS relevance, IF( description like '%" . str_replace(" ", "%' AND description LIKE '%", $good_words) . "%', " . (substr_count($good_words, " ") + 1) . "*10, 0) + IF(description LIKE '%" . str_replace(" ", "%', 9, 0) + IF( description LIKE '%", $good_words) . "%', 9, 0) AS relevance1re FROM catalogue_goods WHERE name LIKE '%" . str_replace(" ", "%' OR name LIKE '%", $good_words) . "%' or description LIKE '%" . str_replace(" ", "%' OR description LIKE '%", $good_words) . "%' ORDER BY relevance DESC, relevance1re DESC, id_category"; $result = mysql_query($query); if (mysql_num_rows($result)) { $content .= '

Найдено в названиях и описаниях товаров:

'; $f = 1; } @include_once($_SERVER['DOCUMENT_ROOT'] . '/catalogue/template/goods_list_before.php'); while ($row = mysql_fetch_array($result)) { //print_r($row); //$content .= '

' . $row[name] . '

'; $goods_id = $row['id']; $category_id = $row['id_category']; $brand_id = $row['id_brand']; $goods_description_small = $row['description_small']; $goods_price = $row['price']; $goods_name = $row['name']; $goods_article = $row['article']; $query3 = "SELECT * FROM brand_goods WHERE id = '" . $row['id_brand'] . "'"; $result3 = mysql_query($query3); $row3 = mysql_fetch_array($result3); $brand_name = $row3['name']; $query4 = "SELECT * FROM category_goods WHERE id = '" . $row['id_category'] . "'"; $result4 = mysql_query($query4); $row4 = mysql_fetch_array($result4); $category_name = $row4['name']; $row2['price_flag'] = $row['price_flag']; $img_path_small = @image_check($row['img_name_small']); $img_path = @image_check($row['img_name']); $img_path_big = @image_check($row['img_name_big']); $addbasket_link = '/shop/mybasket/addbasket/?id_product=' . $goods_id; @include($_SERVER['DOCUMENT_ROOT'] . '/catalogue/template/goods_list_position.php'); } @include_once($_SERVER['DOCUMENT_ROOT'] . '/catalogue/template/goods_list_after.php'); ##################################################################### $query = "SELECT *, IF( name like '%" . $good_words . "%', " . (substr_count($good_words, " ") + 1) . "*10, 0) + IF( name LIKE '%" . str_replace(" ", "%', 9, 0) + IF( name LIKE '%", $good_words) . "%', 9, 0) AS relevance, IF( description like '%" . $good_words . "%', " . (substr_count($good_words, " ") + 1) . "*10, 0) + IF(description LIKE '%" . str_replace(" ", "%', 9, 0) + IF( description LIKE '%", $good_words) . "%', 9, 0) AS relevance1re FROM category_goods WHERE name LIKE '%" . str_replace(" ", "%' OR name LIKE '%", $good_words) . "%' or description LIKE '%" . str_replace(" ", "%' OR description LIKE '%", $good_words) . "%' ORDER BY relevance DESC, relevance1re DESC"; $result = mysql_query($query); if (mysql_num_rows($result)) { $content .= '

Найдено в названиях и описаниях категорий товаров:

'; $f = 1; } $content .= ' '; ##################################################################### $query = "SELECT *, IF( name like '%" . $good_words . "%', " . (substr_count($good_words, " ") + 1) . "*10, 0) + IF( name LIKE '%" . str_replace(" ", "%', 9, 0) + IF( name LIKE '%", $good_words) . "%', 9, 0) AS relevance, IF( description like '%" . $good_words . "%', " . (substr_count($good_words, " ") + 1) . "*10, 0) + IF(description LIKE '%" . str_replace(" ", "%', 9, 0) + IF( description LIKE '%", $good_words) . "%', 9, 0) AS relevance1re FROM brand_goods WHERE name LIKE '%" . str_replace(" ", "%' OR name LIKE '%", $good_words) . "%' or description LIKE '%" . str_replace(" ", "%' OR description LIKE '%", $good_words) . "%' ORDER BY relevance DESC, relevance1re DESC"; $result = mysql_query($query); if (mysql_num_rows($result)) { $content .= '

Найдено в названиях и описаниях товаров:

'; $f = 1; } $content .= ' '; if (!$f) $content .= '

По Вашему запросу ничего не найдено!

'; $path_page_string_arr[] = 'Поиск'; $path_page_string_arr2[] = 'Поиск'; } } ### Поиск - END ####################################################################################################### ####################################################################################################### ####################################################################################################### ####################################################################################################### ### Формирование PATHPAGE - START if ($CONFIG_WSS_ENGINE[path_page_cat_type] == 1) { if ($GLOBAL_VARIABLES[goods_name_this]) { $path_page_string_arr[] = $GLOBAL_VARIABLES[goods_name_this]; $path_page_string_arr2[] = $GLOBAL_VARIABLES[goods_name_this]; $config_page['name'] = $GLOBAL_VARIABLES[goods_name_this]; } if (!$GLOBAL_VARIABLES[brand_id_this]) $GLOBAL_VARIABLES[brand_id_this] = $query_params[id_brand]; if (!$GLOBAL_VARIABLES[category_id_this]) $GLOBAL_VARIABLES[category_id_this] = $query_params[id_category][0]; $category_id_this = $GLOBAL_VARIABLES[category_id_this]; while ($category_id_this) { $query3 = "SELECT id, name, id_parent FROM category_goods WHERE ( id = '" . $category_id_this . "' )"; $result3 = mysql_query("$query3"); $row3 = mysql_fetch_array($result3); if (!$GLOBAL_VARIABLES[category_name_this]) $GLOBAL_VARIABLES[category_name_this] = $row3[name]; $category_id_this = $row3[id_parent]; if ($row3[name]) { $path_page_string_arr[] = '' . $row3[name] . ''; $path_page_string_arr2[] = $row3[name]; } } if (!$GLOBAL_VARIABLES[brand_name_this]) { $query = "SELECT id, name FROM brand_goods WHERE ( id = '" . $GLOBAL_VARIABLES[brand_id_this] . "' )"; $result = mysql_query($query); $row = mysql_fetch_array($result); $GLOBAL_VARIABLES[brand_name_this] = $row[name]; } if ($GLOBAL_VARIABLES[brand_name_this]) { $path_page_string_arr[] = 'Бренд ' . $GLOBAL_VARIABLES[brand_name_this] . ''; $path_page_string_arr2[] = $GLOBAL_VARIABLES[brand_name_this]; $config_page['name'] = $GLOBAL_VARIABLES[brand_name_this]; } if ($GLOBAL_VARIABLES[category_id_this]) $config_page['name'] .= ' - ' . $GLOBAL_VARIABLES[category_name_this]; } if ($CONFIG_WSS_ENGINE[path_page_cat_type] == 2) { if ($GLOBAL_VARIABLES[goods_name_this]) { $path_page_string_arr[] = $GLOBAL_VARIABLES[goods_name_this]; $path_page_string_arr2[] = $GLOBAL_VARIABLES[goods_name_this]; $config_page['name'] = $GLOBAL_VARIABLES[goods_name_this]; } if (!$GLOBAL_VARIABLES[brand_id_this]) $GLOBAL_VARIABLES[brand_id_this] = $query_params[id_brand]; if (!$GLOBAL_VARIABLES[brand_name_this]) { $query = "SELECT id, name FROM brand_goods WHERE ( id = '" . $GLOBAL_VARIABLES[brand_id_this] . "' )"; $result = mysql_query($query); $row = mysql_fetch_array($result); $GLOBAL_VARIABLES[brand_name_this] = $row[name]; } if ($GLOBAL_VARIABLES[brand_name_this]) { $path_page_string_arr[] = 'Бренд ' . $GLOBAL_VARIABLES[brand_name_this] . ''; $path_page_string_arr2[] = $GLOBAL_VARIABLES[brand_name_this]; $config_page['name'] = $GLOBAL_VARIABLES[brand_name_this]; } if (!$GLOBAL_VARIABLES[category_id_this]) $GLOBAL_VARIABLES[category_id_this] = $query_params[id_category][0]; $category_id_this = $GLOBAL_VARIABLES[category_id_this]; while ($category_id_this) { $query3 = "SELECT id, name, id_parent FROM category_goods WHERE ( id = '" . $category_id_this . "' )"; $result3 = mysql_query("$query3"); $row3 = mysql_fetch_array($result3); if (!$GLOBAL_VARIABLES[category_name_this]) $GLOBAL_VARIABLES[category_name_this] = $row3[name]; $category_id_this = $row3[id_parent]; if ($row3[name]) { $path_page_string_arr[] = '' . $row3[name] . ''; $path_page_string_arr2[] = $row3[name]; } } if ($GLOBAL_VARIABLES[category_id_this]) $config_page['name'] .= ' - ' . $GLOBAL_VARIABLES[category_name_this]; } if ($CONFIG_WSS_ENGINE[path_page_string_name][1]) $path_page_string_arr[] = '' . $CONFIG_WSS_ENGINE[path_page_string_name][1] . ''; if ($CONFIG_WSS_ENGINE[path_page_string_title][1]) $path_page_string_arr2[] = $CONFIG_WSS_ENGINE[path_page_string_title][1]; elseif (!$CONFIG_WSS_ENGINE[path_page_string_title][1] AND count($path_page_string_arr2) < 1) $path_page_string_arr2[] = $CONFIG_WSS_ENGINE[path_page_string_name][1]; if ($CONFIG_WSS_ENGINE[path_page_string_name][0]) $path_page_string_arr[] = '' . $CONFIG_WSS_ENGINE[path_page_string_name][0] . ''; if ($CONFIG_WSS_ENGINE[path_page_string_title][0]) $path_page_string_arr2[] = $CONFIG_WSS_ENGINE[path_page_string_title][0]; $config_page[title] = implode(" / ", array_reverse($path_page_string_arr2)); ### Формирование PATHPAGE - END ####################################################################################################### ####################################################################################################### @include_once($_SERVER['DOCUMENT_ROOT'] . '/wssengine/function/seo/catalogue_url.php'); ####################################################################################################### ####################################################################################################### ### Вывод шаблонов и контента сформированного каталогом продукции - START @include_once($_SERVER['DOCUMENT_ROOT'] . '/wssengine/template/' . $config_page[template] . '/top.php'); echo $content; @include_once($_SERVER['DOCUMENT_ROOT'] . '/wssengine/template/' . $config_page[template] . '/bottom.php'); ### Вывод шаблонов и контента сформированного каталогом продукции - END ####################################################################################################### ####################################################################################################### ####################################################################################################### ### Если используется доступ к БД через функцию - завершаем соединение if (function_exists(wss_mysql_connect)) mysql_close(); ####################################################################################################### ?>