Thema: t10: Suchbegriffstatistik - Hilfe

0815 · **Antwort #15 am:** 16. September 2015, 17:46:29

Ich hätte aber auch noch eine Anregung zum Modul.

Beispiel:
1. Ein Kunde startet eine Suchanfrage mit dem Keyword "Schaf".
2. Im Backend möchte ich nun der Suchanfrage "Schaf" weitere Produkte zuweisen und suche nach "Lamm".
3. Mir wird ein Artikel angezeigt, bei dem ich im Titel bereits beide Keywords ("Lamm/Schaf") verwende.

Mir wird also nun angeboten, dem Artikel "Lamm/Schaf" das Keyword Schaf hinzuzufügen.
Dies ist jedoch überflüssig, weil die Shopsuche ja bereits automatisch den Titel durchsucht und diesen Artikel auch so, d.h. ohne zusätzliches Keyword als Suchtreffer ausliefert.

Kann man den Code ggf. ohne größeren Aufwand anpassen, so dass auch alle im Titel eines Artikel verwendeten Worte bei der Produktzuweisung als Keyword erkannt und berücksichtigt werden?

wicki · **Antwort #16 am:** 16. September 2015, 19:08:46

bräuchte bitte bei meiner frage noch hilfe

Zitat von: wicki am 14. September 2015, 20:09:40

shop 106 modified
advance_search_result.php

suchen nach
Code: PHP  [Auswählen]
$_GET['keywords'] = urlencode($keywords);

fügen sie danach
Code: PHP  [Auswählen]
// @t10: Search Stats
// @t10: make sure not to count "searches" originating from backend
if (!isset($_GET['dnt'])) {
require_once(DIR_WS_CLASSES . 't10.searchstats.php');

// num products
$q = xtc_db_query($listing_sql);
$n = xtc_db_num_rows($q);

$t10_stats = new t10_searchstats($keywords, $n);
$t10_stats->save();
}
// @t10: Search Stats END

nur stehe ich bei dem satz an
(Damit der Suchbegriff sowie die gefundenen Produkte gespeichert werden können, fügen Sie die folgenden Zeilen VOR dem Includen des Product Listing und Header ein.)

habe es so gemacht....aber irgendwie ist da was falsch

Code: PHP  [Auswählen]
<?php
/* -----------------------------------------------------------------------------------------
$Id: advanced_search_result.php 3413 2012-08-10 15:53:56Z web28 $

modified eCommerce Shopsoftware
http://www.modified-shop.org

Copyright (c) 2009 - 2013 [www.modified-shop.org]
-----------------------------------------------------------------------------------------
based on:
(c) 2000-2001 The Exchange Project (earlier name of osCommerce)
(c) 2002-2003 osCommerce(advanced_search_result.php,v 1.68 2003/05/14); www.oscommerce.com
(c) 2003 nextcommerce (advanced_search_result.php,v 1.17 2003/08/21); www.nextcommerce.org
(c) 2006 XT-Commerce (advanced_search_result.php 1141 2005-08-10)

Released under the GNU General Public License
---------------------------------------------------------------------------------------*/

include ('includes/application_top.php');

// create smarty elements
$smarty = new Smarty;

// include boxes
require (DIR_FS_CATALOG.'templates/'.CURRENT_TEMPLATE.'/source/boxes.php');

// include needed functions
require_once (DIR_FS_INC.'xtc_parse_search_string.inc.php');
require_once (DIR_FS_INC.'xtc_get_subcategories.inc.php');
require_once (DIR_FS_INC.'xtc_get_currencies_values.inc.php');

// security fix
//set $_GET variables for function xtc_get_all_get_params()
$keywords = $_GET['keywords'] = isset($_GET['keywords']) && !empty($_GET['keywords']) ? stripslashes(trim(urldecode($_GET['keywords']))) : false;
$pfrom = $_GET['pfrom'] = isset($_GET['pfrom']) && !empty($_GET['pfrom']) ? stripslashes($_GET['pfrom']) : false;
$pto = $_GET['pto'] = isset($_GET['pto']) && !empty($_GET['pto']) ? stripslashes($_GET['pto']) : false;
$manufacturers_id = $_GET['manufacturers_id'] = isset($_GET['manufacturers_id']) && xtc_not_null($_GET['manufacturers_id']) ? (int)$_GET['manufacturers_id'] : false;
$categories_id = $_GET['categories_id'] = isset($_GET['categories_id']) && xtc_not_null($_GET['categories_id']) ? (int)$_GET['categories_id'] : false;
$_GET['inc_subcat'] = isset($_GET['inc_subcat']) && xtc_not_null($_GET['inc_subcat']) ? (int)$_GET['inc_subcat'] : null;
// reset error
$errorno = 0;

// error check
if ($keywords && strlen($keywords) < 3 && strlen($keywords) > 0) {
$errorno += 1;
}
if (!$keywords && !$pfrom && !$pto && isset($_GET['x'])) {
$errorno += 1;
}
if ($pfrom && !settype($pfrom, "float")) {
$errorno += 10000;
}
if ($pto && !settype($pto, "float")) {
$errorno += 100000;
}
if ($pfrom && !(($errorno & 10000) == 10000) && $pto && !(($errorno & 100000) == 100000) && $pfrom > $pto) {
$errorno += 1000000;
}
if ($keywords && !xtc_parse_search_string($keywords, $search_keywords)) {
$errorno += 10000000;
}

if ($errorno) {
xtc_redirect(xtc_href_link(FILENAME_ADVANCED_SEARCH, 'errorno='.$errorno.'&'.xtc_get_all_get_params()));

} else {

// build breadcrumb
$breadcrumb->add(NAVBAR_TITLE1_ADVANCED_SEARCH, xtc_href_link(FILENAME_ADVANCED_SEARCH));
$breadcrumb->add(NAVBAR_TITLE2_ADVANCED_SEARCH, xtc_href_link(FILENAME_ADVANCED_SEARCH_RESULT, xtc_get_all_get_params()));

// default values
$subcat_join = '';
$subcat_where = '';
$tax_where = '';
$cats_list = '';
$left_join = '';

// fsk18 lock
$fsk_lock = $_SESSION['customers_status']['customers_fsk18_display'] == '0' ? " AND p.products_fsk18 != '1' " : "";

// group check
$group_check = GROUP_CHECK == 'true' ? " AND p.group_permission_".$_SESSION['customers_status']['customers_status_id']."=1 " : "";

// manufacturers check
$manu_check = $manufacturers_id !== false ? " AND p.manufacturers_id = '".$manufacturers_id."' " : "";

//include subcategories if needed
if ($categories_id !== false) {
if (isset($_GET['inc_subcat']) && $_GET['inc_subcat'] == '1') {
$subcategories_array = array();
xtc_get_subcategories($subcategories_array, $categories_id);
$subcat_join = " LEFT OUTER JOIN ".TABLE_PRODUCTS_TO_CATEGORIES." AS p2c ON (p.products_id = p2c.products_id) ";
$subcat_where = " AND p2c.categories_id IN ('".$categories_id."' ";
foreach ($subcategories_array AS $scat) {
$subcat_where .= ", '".$scat."'";
}
$subcat_where .= ") ";
} else {
$subcat_join = " LEFT OUTER JOIN ".TABLE_PRODUCTS_TO_CATEGORIES." AS p2c ON (p.products_id = p2c.products_id) ";
$subcat_where = " AND p2c.categories_id = '".$categories_id."' ";
}
}

// price by currency
$NeedTax = false;
if ($pfrom || $pto) {
$rate = xtc_get_currencies_values($_SESSION['currency']);
$rate = $rate['value'];
if ($rate && $pfrom) {
$pfrom = $pfrom / $rate;
}
if ($rate && $pto) {
$pto = $pto / $rate;
}
if($_SESSION['customers_status']['customers_status_show_price_tax']) {
$NeedTax = true;
}
}

//price filters
if (($pfrom != '') && (is_numeric($pfrom))) {
if($NeedTax)
$pfrom_check = " AND (IF(s.status = '1' AND p.products_id = s.products_id, s.specials_new_products_price, p.products_price) >= round((".$pfrom."/(1+tax_rate/100)),".PRICE_PRECISION.") ) ";
else
$pfrom_check = " AND (IF(s.status = '1' AND p.products_id = s.products_id, s.specials_new_products_price, p.products_price) >= round(".$pfrom.",".PRICE_PRECISION.") ) ";
} else {
$pfrom_check = '';
}

if (($pto != '') && (is_numeric($pto))) {
if($NeedTax)
$pto_check = " AND (IF(s.status = '1' AND p.products_id = s.products_id, s.specials_new_products_price, p.products_price) <= round((".$pto."/(1+tax_rate/100)),".PRICE_PRECISION.") ) ";
else
$pto_check = " AND (IF(s.status = '1' AND p.products_id = s.products_id, s.specials_new_products_price, p.products_price) <= round(".$pto.",".PRICE_PRECISION.") ) ";
} else {
$pto_check = '';
}

//build query
$add_select = 'p.products_manufacturers_model,';
$select_str = "SELECT distinct
$add_select
p.products_id,
p.products_ean,
p.products_quantity,
p.products_shippingtime,
p.products_model,
p.products_image,
p.products_price,
p.products_weight,
p.products_tax_class_id,
p.products_fsk18,
p.products_vpe,
p.products_vpe_status,
p.products_vpe_value,
pd.products_name,
pd.products_short_description,
pd.products_description ";

$from_str = "FROM ".TABLE_PRODUCTS." AS p LEFT JOIN ".TABLE_PRODUCTS_DESCRIPTION." AS pd ON (p.products_id = pd.products_id) ";
$from_str .= $subcat_join;
$from_str .= SEARCH_IN_ATTR == 'true' ? " LEFT OUTER JOIN ".TABLE_PRODUCTS_ATTRIBUTES." AS pa ON (p.products_id = pa.products_id) LEFT OUTER JOIN ".TABLE_PRODUCTS_OPTIONS_VALUES." AS pov ON (pa.options_values_id = pov.products_options_values_id) " : "";
$from_str .= "LEFT OUTER JOIN ".TABLE_SPECIALS." AS s ON (p.products_id = s.products_id) AND s.status = '1'";

if($NeedTax) {
if (!isset ($_SESSION['customer_country_id'])) {
$_SESSION['customer_country_id'] = STORE_COUNTRY;
$_SESSION['customer_zone_id'] = STORE_ZONE;
}
$from_str .= " LEFT OUTER JOIN ".TABLE_TAX_RATES." tr ON (p.products_tax_class_id = tr.tax_class_id) LEFT OUTER JOIN ".TABLE_ZONES_TO_GEO_ZONES." gz ON (tr.tax_zone_id = gz.geo_zone_id) ";
$tax_where = " AND (gz.zone_country_id IS NULL OR gz.zone_country_id = '0' OR gz.zone_country_id = '".(int) $_SESSION['customer_country_id']."') AND (gz.zone_id is null OR gz.zone_id = '0' OR gz.zone_id = '".(int) $_SESSION['customer_zone_id']."')";
}

//where-string
$where_str = "
WHERE p.products_status = 1
AND pd.language_id = '".$_SESSION['languages_id']."'"
.$subcat_where
.$fsk_lock
.$manu_check
.$group_check
.$tax_where
.$pfrom_check
.$pto_check;

//go for keywords... this is the main search process
if ($keywords) {
if (xtc_parse_search_string($keywords, $search_keywords)) {
$where_str .= " AND ( ";
for ($i = 0, $n = sizeof($search_keywords); $i < $n; $i ++) {
switch ($search_keywords[$i]) {
case '(' :
case ')' :
case 'and' :
case 'or' :
$where_str .= " ".$search_keywords[$i]." ";
break;
default :
$ent_keyword = encode_htmlentities($search_keywords[$i]); // umlauts
$ent_keyword = $ent_keyword != $search_keywords[$i] ? addslashes($ent_keyword) : false;
$keyword = addslashes($search_keywords[$i]);
$where_str .= " ( ";
$where_str .= "pd.products_keywords LIKE ('%".$keyword."%') ";
$where_str .= $ent_keyword ? "OR pd.products_keywords LIKE ('%".$ent_keyword."%') " : '';
if (SEARCH_IN_DESC == 'true') {
$where_str .= "OR pd.products_description LIKE ('%".$keyword."%') ";
$where_str .= $ent_keyword ? "OR pd.products_description LIKE ('%".$ent_keyword."%') " : '';
$where_str .= "OR pd.products_short_description LIKE ('%".$keyword."%') ";
$where_str .= $ent_keyword ? "OR pd.products_short_description LIKE ('%".$ent_keyword."%') " : '';
}
$where_str .= "OR pd.products_name LIKE ('%".$keyword."%') ";
$where_str .= $ent_keyword ? "OR pd.products_name LIKE ('%".$ent_keyword."%') " : '';
$where_str .= "OR p.products_model LIKE ('%".$keyword."%') ";
$where_str .= $ent_keyword ? "OR p.products_model LIKE ('%".$ent_keyword."%') " : '';
$where_str .= "OR p.products_ean LIKE ('%".$keyword."%') ";
$where_str .= $ent_keyword ? "OR p.products_ean LIKE ('%".$ent_keyword."%') " : '';
$where_str .= "OR p.products_manufacturers_model LIKE ('%".$keyword."%') ";
$where_str .= $ent_keyword ? "OR p.products_manufacturers_model LIKE ('%".$ent_keyword."%') " : '';
if (SEARCH_IN_ATTR == 'true') {
$where_str .= "OR pa.attributes_model LIKE ('%".$keyword."%') ";
$where_str .= ($ent_keyword) ? "OR pa.attributes_model LIKE ('%".$ent_keyword."%') " : '';
$where_str .= "OR pa.attributes_ean LIKE ('%".$keyword."%') ";
$where_str .= ($ent_keyword) ? "OR pa.attributes_ean LIKE ('%".$ent_keyword."%') " : '';
$where_str .= "OR (pov.products_options_values_name LIKE ('%".$keyword."%') ";
$where_str .= ($ent_keyword) ? "OR pov.products_options_values_name LIKE ('%".$ent_keyword."%') " : '';
$where_str .= "AND pov.language_id = '".(int) $_SESSION['languages_id']."')";
}
$where_str .= " ) ";
break;
}
}
$where_str .= " ) GROUP BY p.products_id ORDER BY p.products_id ";
}
}

// glue together
$listing_sql = $select_str.$from_str.$where_str;

$_GET['keywords'] = urlencode($keywords);
require (DIR_WS_MODULES.FILENAME_PRODUCT_LISTING);
// @t10: Search Stats
// @t10: make sure not to count "searches" originating from backend
if (!isset($_GET['dnt'])) {
require_once(DIR_WS_CLASSES . 't10.searchstats.php');

// num products
$q = xtc_db_query($listing_sql);
$n = xtc_db_num_rows($q);

$t10_stats = new t10_searchstats($keywords, $n);
$t10_stats->save();
}
// @t10: Search Stats END
require (DIR_WS_INCLUDES.'header.php');
}
$smarty->assign('language', $_SESSION['language']);
if (!defined('RM')) {
$smarty->load_filter('output', 'note');
}
$smarty->display(CURRENT_TEMPLATE.'/index.html');
include ('includes/application_bottom.php');
?>

karsta.de · **Antwort #17 am:** 16. September 2015, 20:09:00

Versuche es mal so (advanced_search_result.php):

Code: PHP [Auswählen]

<?php
/* -----------------------------------------------------------------------------------------
$Id: advanced_search_result.php 3413 2012-08-10 15:53:56Z web28 $

modified eCommerce Shopsoftware
http://www.modified-shop.org

Copyright (c) 2009 - 2013 [www.modified-shop.org]
-----------------------------------------------------------------------------------------
based on:
(c) 2000-2001 The Exchange Project (earlier name of osCommerce)
(c) 2002-2003 osCommerce(advanced_search_result.php,v 1.68 2003/05/14); www.oscommerce.com
(c) 2003 nextcommerce (advanced_search_result.php,v 1.17 2003/08/21); www.nextcommerce.org
(c) 2006 XT-Commerce (advanced_search_result.php 1141 2005-08-10)

Released under the GNU General Public License
---------------------------------------------------------------------------------------*/

include ('includes/application_top.php');

// create smarty elements
$smarty = new Smarty;

// include boxes
require (DIR_FS_CATALOG.'templates/'.CURRENT_TEMPLATE.'/source/boxes.php');

// include needed functions
require_once (DIR_FS_INC.'xtc_parse_search_string.inc.php');
require_once (DIR_FS_INC.'xtc_get_subcategories.inc.php');
require_once (DIR_FS_INC.'xtc_get_currencies_values.inc.php');

// security fix
//set $_GET variables for function xtc_get_all_get_params()
$keywords = $_GET['keywords'] = isset($_GET['keywords']) && !empty($_GET['keywords']) ? stripslashes(trim(urldecode($_GET['keywords']))) : false;
$pfrom = $_GET['pfrom'] = isset($_GET['pfrom']) && !empty($_GET['pfrom']) ? stripslashes($_GET['pfrom']) : false;
$pto = $_GET['pto'] = isset($_GET['pto']) && !empty($_GET['pto']) ? stripslashes($_GET['pto']) : false;
$manufacturers_id = $_GET['manufacturers_id'] = isset($_GET['manufacturers_id']) && xtc_not_null($_GET['manufacturers_id']) ? (int)$_GET['manufacturers_id'] : false;
$categories_id = $_GET['categories_id'] = isset($_GET['categories_id']) && xtc_not_null($_GET['categories_id']) ? (int)$_GET['categories_id'] : false;
$_GET['inc_subcat'] = isset($_GET['inc_subcat']) && xtc_not_null($_GET['inc_subcat']) ? (int)$_GET['inc_subcat'] : null;
// reset error
$errorno = 0;

// error check
if ($keywords && strlen($keywords) < 3 && strlen($keywords) > 0) {
$errorno += 1;
}
if (!$keywords && !$pfrom && !$pto && isset($_GET['x'])) {
$errorno += 1;
}
if ($pfrom && !settype($pfrom, "float")) {
$errorno += 10000;
}
if ($pto && !settype($pto, "float")) {
$errorno += 100000;
}
if ($pfrom && !(($errorno & 10000) == 10000) && $pto && !(($errorno & 100000) == 100000) && $pfrom > $pto) {
$errorno += 1000000;
}
if ($keywords && !xtc_parse_search_string($keywords, $search_keywords)) {
$errorno += 10000000;
}

if ($errorno) {
xtc_redirect(xtc_href_link(FILENAME_ADVANCED_SEARCH, 'errorno='.$errorno.'&'.xtc_get_all_get_params()));

} else {

// build breadcrumb
$breadcrumb->add(NAVBAR_TITLE1_ADVANCED_SEARCH, xtc_href_link(FILENAME_ADVANCED_SEARCH));
$breadcrumb->add(NAVBAR_TITLE2_ADVANCED_SEARCH, xtc_href_link(FILENAME_ADVANCED_SEARCH_RESULT, xtc_get_all_get_params()));

// default values
$subcat_join = '';
$subcat_where = '';
$tax_where = '';
$cats_list = '';
$left_join = '';

// fsk18 lock
$fsk_lock = $_SESSION['customers_status']['customers_fsk18_display'] == '0' ? " AND p.products_fsk18 != '1' " : "";

// group check
$group_check = GROUP_CHECK == 'true' ? " AND p.group_permission_".$_SESSION['customers_status']['customers_status_id']."=1 " : "";

// manufacturers check
$manu_check = $manufacturers_id !== false ? " AND p.manufacturers_id = '".$manufacturers_id."' " : "";

//include subcategories if needed
if ($categories_id !== false) {
if (isset($_GET['inc_subcat']) && $_GET['inc_subcat'] == '1') {
$subcategories_array = array();
xtc_get_subcategories($subcategories_array, $categories_id);
$subcat_join = " LEFT OUTER JOIN ".TABLE_PRODUCTS_TO_CATEGORIES." AS p2c ON (p.products_id = p2c.products_id) ";
$subcat_where = " AND p2c.categories_id IN ('".$categories_id."' ";
foreach ($subcategories_array AS $scat) {
$subcat_where .= ", '".$scat."'";
}
$subcat_where .= ") ";
} else {
$subcat_join = " LEFT OUTER JOIN ".TABLE_PRODUCTS_TO_CATEGORIES." AS p2c ON (p.products_id = p2c.products_id) ";
$subcat_where = " AND p2c.categories_id = '".$categories_id."' ";
}
}

// price by currency
$NeedTax = false;
if ($pfrom || $pto) {
$rate = xtc_get_currencies_values($_SESSION['currency']);
$rate = $rate['value'];
if ($rate && $pfrom) {
$pfrom = $pfrom / $rate;
}
if ($rate && $pto) {
$pto = $pto / $rate;
}
if($_SESSION['customers_status']['customers_status_show_price_tax']) {
$NeedTax = true;
}
}

//price filters
if (($pfrom != '') && (is_numeric($pfrom))) {
if($NeedTax)
$pfrom_check = " AND (IF(s.status = '1' AND p.products_id = s.products_id, s.specials_new_products_price, p.products_price) >= round((".$pfrom."/(1+tax_rate/100)),".PRICE_PRECISION.") ) ";
else
$pfrom_check = " AND (IF(s.status = '1' AND p.products_id = s.products_id, s.specials_new_products_price, p.products_price) >= round(".$pfrom.",".PRICE_PRECISION.") ) ";
} else {
$pfrom_check = '';
}

if (($pto != '') && (is_numeric($pto))) {
if($NeedTax)
$pto_check = " AND (IF(s.status = '1' AND p.products_id = s.products_id, s.specials_new_products_price, p.products_price) <= round((".$pto."/(1+tax_rate/100)),".PRICE_PRECISION.") ) ";
else
$pto_check = " AND (IF(s.status = '1' AND p.products_id = s.products_id, s.specials_new_products_price, p.products_price) <= round(".$pto.",".PRICE_PRECISION.") ) ";
} else {
$pto_check = '';
}

//build query
$add_select = 'p.products_manufacturers_model,';
$select_str = "SELECT distinct
$add_select
p.products_id,
p.products_ean,
p.products_quantity,
p.products_shippingtime,
p.products_model,
p.products_image,
p.products_price,
p.products_weight,
p.products_tax_class_id,
p.products_fsk18,
p.products_vpe,
p.products_vpe_status,
p.products_vpe_value,
pd.products_name,
pd.products_short_description,
pd.products_description ";

$from_str = "FROM ".TABLE_PRODUCTS." AS p LEFT JOIN ".TABLE_PRODUCTS_DESCRIPTION." AS pd ON (p.products_id = pd.products_id) ";
$from_str .= $subcat_join;
$from_str .= SEARCH_IN_ATTR == 'true' ? " LEFT OUTER JOIN ".TABLE_PRODUCTS_ATTRIBUTES." AS pa ON (p.products_id = pa.products_id) LEFT OUTER JOIN ".TABLE_PRODUCTS_OPTIONS_VALUES." AS pov ON (pa.options_values_id = pov.products_options_values_id) " : "";
$from_str .= "LEFT OUTER JOIN ".TABLE_SPECIALS." AS s ON (p.products_id = s.products_id) AND s.status = '1'";

if($NeedTax) {
if (!isset ($_SESSION['customer_country_id'])) {
$_SESSION['customer_country_id'] = STORE_COUNTRY;
$_SESSION['customer_zone_id'] = STORE_ZONE;
}
$from_str .= " LEFT OUTER JOIN ".TABLE_TAX_RATES." tr ON (p.products_tax_class_id = tr.tax_class_id) LEFT OUTER JOIN ".TABLE_ZONES_TO_GEO_ZONES." gz ON (tr.tax_zone_id = gz.geo_zone_id) ";
$tax_where = " AND (gz.zone_country_id IS NULL OR gz.zone_country_id = '0' OR gz.zone_country_id = '".(int) $_SESSION['customer_country_id']."') AND (gz.zone_id is null OR gz.zone_id = '0' OR gz.zone_id = '".(int) $_SESSION['customer_zone_id']."')";
}

//where-string
$where_str = "
WHERE p.products_status = 1
AND pd.language_id = '".$_SESSION['languages_id']."'"
.$subcat_where
.$fsk_lock
.$manu_check
.$group_check
.$tax_where
.$pfrom_check
.$pto_check;

//go for keywords... this is the main search process
if ($keywords) {
if (xtc_parse_search_string($keywords, $search_keywords)) {
$where_str .= " AND ( ";
for ($i = 0, $n = sizeof($search_keywords); $i < $n; $i ++) {
switch ($search_keywords[$i]) {
case '(' :
case ')' :
case 'and' :
case 'or' :
$where_str .= " ".$search_keywords[$i]." ";
break;
default :
$ent_keyword = encode_htmlentities($search_keywords[$i]); // umlauts
$ent_keyword = $ent_keyword != $search_keywords[$i] ? addslashes($ent_keyword) : false;
$keyword = addslashes($search_keywords[$i]);
$where_str .= " ( ";
$where_str .= "pd.products_keywords LIKE ('%".$keyword."%') ";
$where_str .= $ent_keyword ? "OR pd.products_keywords LIKE ('%".$ent_keyword."%') " : '';
if (SEARCH_IN_DESC == 'true') {
$where_str .= "OR pd.products_description LIKE ('%".$keyword."%') ";
$where_str .= $ent_keyword ? "OR pd.products_description LIKE ('%".$ent_keyword."%') " : '';
$where_str .= "OR pd.products_short_description LIKE ('%".$keyword."%') ";
$where_str .= $ent_keyword ? "OR pd.products_short_description LIKE ('%".$ent_keyword."%') " : '';
}
$where_str .= "OR pd.products_name LIKE ('%".$keyword."%') ";
$where_str .= $ent_keyword ? "OR pd.products_name LIKE ('%".$ent_keyword."%') " : '';
$where_str .= "OR p.products_model LIKE ('%".$keyword."%') ";
$where_str .= $ent_keyword ? "OR p.products_model LIKE ('%".$ent_keyword."%') " : '';
$where_str .= "OR p.products_ean LIKE ('%".$keyword."%') ";
$where_str .= $ent_keyword ? "OR p.products_ean LIKE ('%".$ent_keyword."%') " : '';
$where_str .= "OR p.products_manufacturers_model LIKE ('%".$keyword."%') ";
$where_str .= $ent_keyword ? "OR p.products_manufacturers_model LIKE ('%".$ent_keyword."%') " : '';
if (SEARCH_IN_ATTR == 'true') {
$where_str .= "OR pa.attributes_model LIKE ('%".$keyword."%') ";
$where_str .= ($ent_keyword) ? "OR pa.attributes_model LIKE ('%".$ent_keyword."%') " : '';
$where_str .= "OR pa.attributes_ean LIKE ('%".$keyword."%') ";
$where_str .= ($ent_keyword) ? "OR pa.attributes_ean LIKE ('%".$ent_keyword."%') " : '';
$where_str .= "OR (pov.products_options_values_name LIKE ('%".$keyword."%') ";
$where_str .= ($ent_keyword) ? "OR pov.products_options_values_name LIKE ('%".$ent_keyword."%') " : '';
$where_str .= "AND pov.language_id = '".(int) $_SESSION['languages_id']."')";
}
$where_str .= " ) ";
break;
}
}
$where_str .= " ) GROUP BY p.products_id ORDER BY p.products_id ";
}
}

// glue together
$listing_sql = $select_str.$from_str.$where_str;

$_GET['keywords'] = urlencode($keywords);
// @t10: Search Stats
// @t10: make sure not to count "searches" originating from backend
if (!isset($_GET['dnt'])) {
require_once(DIR_WS_CLASSES . 't10.searchstats.php');

// num products
$q = xtc_db_query($listing_sql);
$n = xtc_db_num_rows($q);

$t10_stats = new t10_searchstats($keywords, $n);
$t10_stats->save();
}
// @t10: Search Stats END
require (DIR_WS_MODULES.FILENAME_PRODUCT_LISTING);
require (DIR_WS_INCLUDES.'header.php');
}

$smarty->assign('language', $_SESSION['language']);
if (!defined('RM')) {
$smarty->load_filter('output', 'note');
}
$smarty->display(CURRENT_TEMPLATE.'/index.html');
include ('includes/application_bottom.php');

?>

wicki · **Antwort #18 am:** 16. September 2015, 20:33:48

funktioniert nicht....sobald ich im shop unter suche was eingebe
ist das template weg und nur noch der hintergrund zu sehen

(

0815 · **Antwort #19 am:** 16. September 2015, 20:37:41

error_reporting aktiviert?
Fehlermeldung?

Jürgen · **Antwort #20 am:** 16. September 2015, 20:44:18

Hallo,

versuchs mal mit meiner, bei mir funktioniert alles...

Code: PHP [Auswählen]

<?php
/* -----------------------------------------------------------------------------------------
$Id: advanced_search_result.php 3413 2012-08-10 15:53:56Z web28 $

modified eCommerce Shopsoftware
http://www.modified-shop.org

Copyright (c) 2009 - 2013 [www.modified-shop.org]
-----------------------------------------------------------------------------------------
based on:
(c) 2000-2001 The Exchange Project (earlier name of osCommerce)
(c) 2002-2003 osCommerce(advanced_search_result.php,v 1.68 2003/05/14); www.oscommerce.com
(c) 2003 nextcommerce (advanced_search_result.php,v 1.17 2003/08/21); www.nextcommerce.org
(c) 2006 XT-Commerce (advanced_search_result.php 1141 2005-08-10)

Released under the GNU General Public License
---------------------------------------------------------------------------------------*/

include ('includes/application_top.php');

// create smarty elements
$smarty = new Smarty;

// include boxes
require (DIR_FS_CATALOG.'templates/'.CURRENT_TEMPLATE.'/source/boxes.php');

// include needed functions
require_once (DIR_FS_INC.'xtc_parse_search_string.inc.php');
require_once (DIR_FS_INC.'xtc_get_subcategories.inc.php');
require_once (DIR_FS_INC.'xtc_get_currencies_values.inc.php');

// security fix
//set $_GET variables for function xtc_get_all_get_params()
$keywords = $_GET['keywords'] = isset($_GET['keywords']) && !empty($_GET['keywords']) ? stripslashes(trim(urldecode($_GET['keywords']))) : false;
$pfrom = $_GET['pfrom'] = isset($_GET['pfrom']) && !empty($_GET['pfrom']) ? stripslashes($_GET['pfrom']) : false;
$pto = $_GET['pto'] = isset($_GET['pto']) && !empty($_GET['pto']) ? stripslashes($_GET['pto']) : false;
$manufacturers_id = $_GET['manufacturers_id'] = isset($_GET['manufacturers_id']) && xtc_not_null($_GET['manufacturers_id']) ? (int)$_GET['manufacturers_id'] : false;
$categories_id = $_GET['categories_id'] = isset($_GET['categories_id']) && xtc_not_null($_GET['categories_id']) ? (int)$_GET['categories_id'] : false;
$_GET['inc_subcat'] = isset($_GET['inc_subcat']) && xtc_not_null($_GET['inc_subcat']) ? (int)$_GET['inc_subcat'] : null;
$keywords = str_replace(array('%', '_'), array('\%', '\_'), $keywords);
// reset error
$errorno = 0;

// error check
if ($keywords && strlen($keywords) < 3 && strlen($keywords) > 0) {
$errorno += 1;
}
if (!$keywords && !$pfrom && !$pto && isset($_GET['x'])) {
$errorno += 1;
}
if ($pfrom && !settype($pfrom, "float")) {
$errorno += 10000;
}
if ($pto && !settype($pto, "float")) {
$errorno += 100000;
}
if ($pfrom && !(($errorno & 10000) == 10000) && $pto && !(($errorno & 100000) == 100000) && $pfrom > $pto) {
$errorno += 1000000;
}
if ($keywords && !xtc_parse_search_string($keywords, $search_keywords)) {
$errorno += 10000000;
}

if ($errorno) {
xtc_redirect(xtc_href_link(FILENAME_ADVANCED_SEARCH, 'errorno='.$errorno.'&'.xtc_get_all_get_params()));

} else {

// build breadcrumb
$breadcrumb->add(NAVBAR_TITLE1_ADVANCED_SEARCH, xtc_href_link(FILENAME_ADVANCED_SEARCH));
$breadcrumb->add(NAVBAR_TITLE2_ADVANCED_SEARCH, xtc_href_link(FILENAME_ADVANCED_SEARCH_RESULT, xtc_get_all_get_params()));

// default values
$subcat_join = '';
$subcat_where = '';
$tax_where = '';
$cats_list = '';
$left_join = '';

// fsk18 lock
$fsk_lock = $_SESSION['customers_status']['customers_fsk18_display'] == '0' ? " AND p.products_fsk18 != '1' " : "";

// group check
$group_check = GROUP_CHECK == 'true' ? " AND p.group_permission_".$_SESSION['customers_status']['customers_status_id']."=1 " : "";

// manufacturers check
$manu_check = $manufacturers_id !== false ? " AND p.manufacturers_id = '".$manufacturers_id."' " : "";

//include subcategories if needed
if ($categories_id !== false) {
if (isset($_GET['inc_subcat']) && $_GET['inc_subcat'] == '1') {
$subcategories_array = array();
xtc_get_subcategories($subcategories_array, $categories_id);
$subcat_join = " LEFT OUTER JOIN ".TABLE_PRODUCTS_TO_CATEGORIES." AS p2c ON (p.products_id = p2c.products_id) ";
$subcat_where = " AND p2c.categories_id IN ('".$categories_id."' ";
foreach ($subcategories_array AS $scat) {
$subcat_where .= ", '".$scat."'";
}
$subcat_where .= ") ";
} else {
$subcat_join = " LEFT OUTER JOIN ".TABLE_PRODUCTS_TO_CATEGORIES." AS p2c ON (p.products_id = p2c.products_id) ";
$subcat_where = " AND p2c.categories_id = '".$categories_id."' ";
}
}

// price by currency
$NeedTax = false;
if ($pfrom || $pto) {
$rate = xtc_get_currencies_values($_SESSION['currency']);
$rate = $rate['value'];
if ($rate && $pfrom) {
$pfrom = $pfrom / $rate;
}
if ($rate && $pto) {
$pto = $pto / $rate;
}
if($_SESSION['customers_status']['customers_status_show_price_tax']) {
$NeedTax = true;
}
}

//price filters
if (($pfrom != '') && (is_numeric($pfrom))) {
if($NeedTax)
$pfrom_check = " AND (IF(s.status = '1' AND p.products_id = s.products_id, s.specials_new_products_price, p.products_price) >= round((".$pfrom."/(1+tax_rate/100)),".PRICE_PRECISION.") ) ";
else
$pfrom_check = " AND (IF(s.status = '1' AND p.products_id = s.products_id, s.specials_new_products_price, p.products_price) >= round(".$pfrom.",".PRICE_PRECISION.") ) ";
} else {
$pfrom_check = '';
}

if (($pto != '') && (is_numeric($pto))) {
if($NeedTax)
$pto_check = " AND (IF(s.status = '1' AND p.products_id = s.products_id, s.specials_new_products_price, p.products_price) <= round((".$pto."/(1+tax_rate/100)),".PRICE_PRECISION.") ) ";
else
$pto_check = " AND (IF(s.status = '1' AND p.products_id = s.products_id, s.specials_new_products_price, p.products_price) <= round(".$pto.",".PRICE_PRECISION.") ) ";
} else {
$pto_check = '';
}

if ($xtPrice->cStatus['customers_status_show_price_tax'] == '0')
$priceField = 'price_without_tax';
else
$priceField = 'price_incl_tax';
define('fromSearch', true);

//build query
$add_select = 'p.products_manufacturers_model,
p.manufacturers_id,
pr.' . $priceField . ' AS products_real_price,';
$select_str = "SELECT distinct
$add_select
p.products_id,
p.products_ean,
p.products_quantity,
p.products_shippingtime,
p.products_model,
p.products_image,
p.products_price,
p.products_weight,
p.products_tax_class_id,
p.products_fsk18,
p.products_vpe,
p.products_vpe_status,
p.products_vpe_value,
pd.products_name,
pd.products_short_description,
p.manufacturers_id,
pd.products_description ";

$from_str = "FROM ".TABLE_PRODUCTS." AS p LEFT JOIN ".TABLE_PRODUCTS_DESCRIPTION." AS pd ON (p.products_id = pd.products_id) ";
$from_str .= "JOIN pricing pr ON p.products_id = pr.products_id";
$from_str .= $subcat_join;
$from_str .= SEARCH_IN_ATTR == 'true' ? " LEFT OUTER JOIN ".TABLE_PRODUCTS_ATTRIBUTES." AS pa ON (p.products_id = pa.products_id) LEFT OUTER JOIN ".TABLE_PRODUCTS_OPTIONS_VALUES." AS pov ON (pa.options_values_id = pov.products_options_values_id) " : "";
$from_str .= "LEFT OUTER JOIN ".TABLE_SPECIALS." AS s ON (p.products_id = s.products_id) AND s.status = '1'";

if($NeedTax) {
if (!isset ($_SESSION['customer_country_id'])) {
$_SESSION['customer_country_id'] = STORE_COUNTRY;
$_SESSION['customer_zone_id'] = STORE_ZONE;
}
$from_str .= " LEFT OUTER JOIN ".TABLE_TAX_RATES." tr ON (p.products_tax_class_id = tr.tax_class_id) LEFT OUTER JOIN ".TABLE_ZONES_TO_GEO_ZONES." gz ON (tr.tax_zone_id = gz.geo_zone_id) ";
$tax_where = " AND (gz.zone_country_id IS NULL OR gz.zone_country_id = '0' OR gz.zone_country_id = '".(int) $_SESSION['customer_country_id']."') AND (gz.zone_id is null OR gz.zone_id = '0' OR gz.zone_id = '".(int) $_SESSION['customer_zone_id']."')";
}

//where-string
$where_str = "
WHERE p.products_status = 1
AND pr.customers_status = '" . $xtPrice->actualGroup . "'
-- filter start
".
ProductFilter::buildAttribWhereQuery() .
ProductFilter::buildSliderWhereQuery() .
ProductFilter::buildManufacturersWhereQuery() ."
-- filter specials
" . ProductFilter::buildSpecialsWhereQuery()."
-- filter price
".
ProductFilter::buildPriceWhereQuery(false, $priceField)."
-- filter end
AND pd.language_id = '".$_SESSION['languages_id']."'"
.$subcat_where
.$fsk_lock
.$manu_check
.$group_check
.$tax_where
.$pfrom_check
.$pto_check;

//go for keywords... this is the main search process
if ($keywords) {
if (xtc_parse_search_string($keywords, $search_keywords)) {
$where_str .= " AND ( ";
for ($i = 0, $n = sizeof($search_keywords); $i < $n; $i ++) {
switch ($search_keywords[$i]) {
case '(' :
case ')' :
case 'and' :
case 'or' :
$where_str .= " ".$search_keywords[$i]." ";
break;
default :
$ent_keyword = encode_htmlentities($search_keywords[$i]); // umlauts
$ent_keyword = $ent_keyword != $search_keywords[$i] ? addslashes($ent_keyword) : false;
$keyword = addslashes($search_keywords[$i]);
$where_str .= " ( ";
$where_str .= "pd.products_keywords LIKE ('%".$keyword."%') ";
$where_str .= $ent_keyword ? "OR pd.products_keywords LIKE ('%".$ent_keyword."%') " : '';
if (SEARCH_IN_DESC == 'true') {
$where_str .= "OR pd.products_description LIKE ('%".$keyword."%') ";
$where_str .= $ent_keyword ? "OR pd.products_description LIKE ('%".$ent_keyword."%') " : '';
$where_str .= "OR pd.products_short_description LIKE ('%".$keyword."%') ";
$where_str .= $ent_keyword ? "OR pd.products_short_description LIKE ('%".$ent_keyword."%') " : '';
}
$where_str .= "OR pd.products_name LIKE ('%".$keyword."%') ";
$where_str .= $ent_keyword ? "OR pd.products_name LIKE ('%".$ent_keyword."%') " : '';
$where_str .= "OR p.products_model LIKE ('%".$keyword."%') ";
$where_str .= $ent_keyword ? "OR p.products_model LIKE ('%".$ent_keyword."%') " : '';
$where_str .= "OR p.products_ean LIKE ('%".$keyword."%') ";
$where_str .= $ent_keyword ? "OR p.products_ean LIKE ('%".$ent_keyword."%') " : '';
$where_str .= "OR p.products_manufacturers_model LIKE ('%".$keyword."%') ";
$where_str .= $ent_keyword ? "OR p.products_manufacturers_model LIKE ('%".$ent_keyword."%') " : '';
if (SEARCH_IN_ATTR == 'true') {
$where_str .= "OR pa.attributes_model LIKE ('%".$keyword."%') ";
$where_str .= ($ent_keyword) ? "OR pa.attributes_model LIKE ('%".$ent_keyword."%') " : '';
$where_str .= "OR pa.attributes_ean LIKE ('%".$keyword."%') ";
$where_str .= ($ent_keyword) ? "OR pa.attributes_ean LIKE ('%".$ent_keyword."%') " : '';
$where_str .= "OR (pov.products_options_values_name LIKE ('%".$keyword."%') ";
$where_str .= ($ent_keyword) ? "OR pov.products_options_values_name LIKE ('%".$ent_keyword."%') " : '';
$where_str .= "AND pov.language_id = '".(int) $_SESSION['languages_id']."')";
}
$where_str .= " ) ";
break;
}
}
$where_str .= " ) ". ProductFilter::buildSortQuery('ORDER BY p.products_id ');
}
}

// glue together
$listing_sql = $select_str.$from_str.$where_str;

$_GET['keywords'] = urlencode($keywords);
// @t10: Search Stats
// @t10: make sure not to count "searches" originating from backend
if (!isset($_GET['dnt'])) {
require_once(DIR_WS_CLASSES . 't10.searchstats.php');

// num products
$q = xtc_db_query($listing_sql);
$n = xtc_db_num_rows($q);

$t10_stats = new t10_searchstats($keywords, $n);
$t10_stats->save();
}
// @t10: Search Stats END
require (DIR_WS_MODULES.FILENAME_PRODUCT_SEARCH);
require (DIR_WS_INCLUDES.'header.php');
}

$smarty->assign('language', $_SESSION['language']);
if (!defined('RM')) {
$smarty->load_filter('output', 'note');
}
$smarty->display(CURRENT_TEMPLATE.'/index.html');
include ('includes/application_bottom.php');
?>

Aber ohne Gewähr

Die Zeile

Code: PHP [Auswählen]

require (DIR_WS_MODULES.FILENAME_PRODUCT_LISTING);

gibt es in meiner advanced_search_result.php übrigens nicht....

Gruss

Jürgen

total10 · **Antwort #21 am:** 17. September 2015, 13:45:35

Hey Wicki, melde dich sonst mal unter der mb[at]t10.de direkt bei mir falls es noch immer nicht hinhauen sollte.

0815 : du meinst damit, dass du keine Produkte vorgeschlagen haben willst, die die Suche sowieso schon findet ja ? wird sich wohl machen lassen denke ich, ich sprech mal mit meinem Kollegen drüber.

Mit besten grüßen aus Hamburg

Mario

0815 · **Antwort #22 am:** 17. September 2015, 14:18:27

Hallo Mario,

genau das habe ich gemeint.

Danke

0815 · **Antwort #23 am:** 02. Oktober 2015, 13:42:01

@total10

Hat Dein Kollege sich schon zu dem Thema geäußert?

Unabhängig davon ist mir noch folgender bug aufgefallen:

Sucht man einen Begriff bei dem sehr viele Suchtreffer angezeigt werden und man dadurch im Shop mehrere Seiten angezeigt bekommt, wird beim Blättern der Seiten für jeden Klick auf die die Suchanfarge für das Keyword hochgezählt.

tuvalu · **Antwort #24 am:** 07. Februar 2016, 12:57:12

Würde das Thema gern noch mal aufgreifen, denn das ist schon ein interessanter Zusatz.

Bei mir (Shop 1.06 SP3, php5.6) funktioniert das ganz gut, wenn SSL im Admin ausgeschaltet ist. Mit SSL gelingt die Produktzuodnung nicht. Es passiert einfach nichts. Ohne SSL wird der Suchbegriff bei den Metakeywords eingetragen. Im Vorstellungsfilm auf der t10 Website wird das Ganze in einem SSL-freien Shop gezeigt. Nun ist oder sollte es eigentlich Usus sein den Admin nur verschlüsselt zu benutzen - oder sehe ich das falsch. Kundendaten offen anfordern während das im Frontend verschlüsselt wird?

Weiß jemand wie man die Produktzuweisung auch unter SSL zum Laufen bringt?

Danke

Michael

Buggyboy · **Antwort #25 am:** 13. Januar 2017, 10:59:15

Moin!

Ich habe auch nochmal etwas:
Kann man eigentlich aus der Liste einzelne Suchwörter rauslöschen oder geht nur die komplette Liste zu leeren?
Und wenn man die leert, sind dann die Zuordnungen weg oder bleibt das bestehen?
Den irgendwann ist ja die Liste wahrscheinlich unendlich lang.

Könnte man nicht vor jeden Suchbegriff dann ne Checkbos machen, ob der weg soll oder nicht?

Gibt es jetzt mitlerweile eine angepaßte Version für die V2.01?
Also update sicher einzubauen?

Bis peter...

0815 · **Antwort #26 am:** 13. Januar 2017, 11:13:28

Man kann zurzeit nur alle Einträge löschen, einzeln geht noch nicht.
Gelöscht werden dann nur die Suchanfragen, die alten und die neu zugewiesenen Keywords bleiben bestehen.

Wenn auf 2.0 umgestellt habe, werde ich das Modul noch weiter modifizieren. .... jedenfalls werde ich es versuchen. Das wird aber definitiv noch eine Weile dauern.

karsta.de · **Antwort #27 am:** 14. Januar 2017, 08:01:58

@Buggyboy

Zitat

Gibt es jetzt mitlerweile eine angepaßte Version für die V2.01?
Also update sicher einzubauen?

Ich hatte es dir doch auf Grundlage und deiner privaten Mail-Anfrage auf diesen Beitrag MODUL: Suchbegriff / Keyword Statistik für modified eCommerce Shopsoftware das als updatesichere Version per Mail geschickt.

Was willst du anderes bzw. was stimmt damit nicht?

Vielleicht wendest du dich direkt an den Anbieter dieser Erweiterung. Vielleicht hat er sich das ja inzwischen angesehen.

Zitat von: total10 am 17. November 2016, 12:47:51

Hey, ich schaue mir unser Modul in Kürze noch mal für die 2.0 an

BG kgd

karsta.de · **Antwort #28 am:** 15. Januar 2017, 07:42:11

Danke für die Rückmeldung per Mail Buggyboy. Da bin ich ja froh, dass alles korrekt funktioniert.

BG kgd

P.S. Das hättest du auch hier mitteilen können. Ist ja wohl kein Thema für Geheimhaltung.

Thema: t10: Suchbegriffstatistik - Hilfe

0815

Re: t10: Suchbegriffstatistik - Hilfe

wicki

Re: t10: Suchbegriffstatistik - Hilfe

karsta.de

Re: t10: Suchbegriffstatistik - Hilfe

wicki

Re: t10: Suchbegriffstatistik - Hilfe

0815

Re: t10: Suchbegriffstatistik - Hilfe

Jürgen

Re: t10: Suchbegriffstatistik - Hilfe

total10

Re: t10: Suchbegriffstatistik - Hilfe

0815

Re: t10: Suchbegriffstatistik - Hilfe

0815

Re: t10: Suchbegriffstatistik - Hilfe

tuvalu

Re: t10: Suchbegriffstatistik - Hilfe

Buggyboy

Re: t10: Suchbegriffstatistik - Hilfe

0815

Re: t10: Suchbegriffstatistik - Hilfe

karsta.de

Re: t10: Suchbegriffstatistik - Hilfe

karsta.de

Re: t10: Suchbegriffstatistik - Hilfe

Teile Thema

Ähnliche Themen

MODUL: t10: Suchbegriffstatistik für Shopversion 2.x

total10 Suchbegriffstatistik - kuriose Fehlermeldung

Hilfe bei CSS

HILFE!!!!