Header Tags SEO

Questo forum è dedicato alle discussioni riguardanti le contribution per osCommerce

Moderatore: mod Generali

Rispondi
Avatar utente
marzioscaglione
membro Regular
membro Regular
Messaggi: 204
Iscritto il: 06/08/2007, 14:15
Località: Prato
Contatta:
Contatta marzioscaglione

Header Tags SEO

Messaggio da marzioscaglione »

Ciao raga, ho provato ad installare Header Tags SEO ma non ci sono riuscito in quanto i file da modificare, quelli che ho sul sito, sono molto diversi , in alcuni passaggi non sò dove proprio modificare !
Per favore, c'è qualcuno che gentilmente può darmi una mano ?

Grazie
http://www.newinformaticworld.com
I gestionali Danea 2009 da noi li trovi a prezzi scontati http://www.newinformaticworld.com/gesti ... _1455.html
Top
hsg26
membro Master
membro Master
Messaggi: 1677
Iscritto il: 07/04/2005, 0:00
Località: Svizzera
Contatta:
Contatta hsg26

Re: Header Tags SEO

Messaggio da hsg26 »

marzioscaglione ha scritto:Ciao raga, ho provato ad installare Header Tags SEO ma non ci sono riuscito in quanto i file da modificare, quelli che ho sul sito, sono molto diversi , in alcuni passaggi non sò dove proprio modificare !
Per favore, c'è qualcuno che gentilmente può darmi una mano ?

Grazie
metti quali sono i passaggi che non riesci a fare con relativi codici... così magari riusciamo ad aiutarti.
La funzione CERCA si trova sotto al logo Oscommerce italia in questa pagina. - I Love Marketing!

I miei preferiti: internet marketing blog - biancheria da letto - prodotti tipici piemonte - vini piemontesi - roero arneis
Top
Avatar utente
marzioscaglione
membro Regular
membro Regular
Messaggi: 204
Iscritto il: 06/08/2007, 14:15
Località: Prato
Contatta:
Contatta marzioscaglione

Messaggio da marzioscaglione »

ciao hsg26,
grazie per la risposta.
Ho modificato il primo file, pensi vada bene ?

Codice: Seleziona tutto

<?php
/*
$Id: index.php,v 1.1 2003/06/11 17:37:59 hpdl Exp $

osCommerce, Open Source E-Commerce Solutions
http://www.oscommerce.com

Copyright (c) 2003 osCommerce

Released under the GNU General Public License
*/

require('includes/application_top.php');

// the following cPath references come from application_top.php
$category_depth = 'top';
if (isset($cPath) && tep_not_null($cPath)) {
	$categories_products_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS_TO_CATEGORIES . " where categories_id = '" . (int)$current_category_id . "'");
	$cateqories_products = tep_db_fetch_array($categories_products_query);
	if ($cateqories_products['total'] > 0) {
		$category_depth = 'products'; // display products
	} else {
		$category_parent_query = tep_db_query("select count(*) as total from " . TABLE_CATEGORIES . " where parent_id = '" . (int)$current_category_id . "'");
		$category_parent = tep_db_fetch_array($category_parent_query);
		if ($category_parent['total'] > 0) {
			$category_depth = 'nested'; // navigate through the categories
		} else {
			$category_depth = 'products'; // category has no products, but display the 'no products' message
		}
	}
}

require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_DEFAULT);
?>
<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">
<html <?php echo HTML_PARAMS; ?>>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>"> 
<title><?php echo TITLE; ?></title>
<base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>">
<link rel="stylesheet" type="text/css" href="stylesheet.css">


</head>
<body>
<!-- header //-->
<?php require(DIR_WS_INCLUDES . 'header.php'); ?>
<!-- header_eof //-->
<!-- body //-->
<table border="0" width="100%" cellspacing="0" cellpadding="0">
  <tr>
    <td width="<?php echo BOX_WIDTH; ?>" valign="top" class="column-left">
<!-- left_navigation //-->
<?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>
<!-- left_navigation_eof //-->
    </td>
<!-- body_text //-->
<?php

    if ($category_depth == 'nested') {
    /*** Begin Header Tags SEO ***/
    $category_query = tep_db_query("select cd.categories_name, c.categories_image, cd.categories_htc_title_tag, cd.categories_htc_description from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.categories_id = '" . (int)$current_category_id . "' and cd.categories_id = '" . (int)$current_category_id . "' and cd.language_id = '" . (int)$languages_id . "'");
    /*** end Header Tags SEO ***/
	$category = tep_db_fetch_array($category_query);
?>

<td width="100%" valign="top" class="column-center"><table border="0" align=center width="100%" cellspacing="0" cellpadding="0">	
<tr><td><?php echo tep_draw_separator('pixel_trans.gif', '8', '11'); ?></td></tr>
<tr>	
<tr>
    <td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">
      <tr>
        <td><table border="0" width="100%" cellspacing="0" cellpadding="3">
          <tr>
            <td class="pageHeadingRedbg"><?php echo $category['categories_htc_title_tag'] . '<br><span class=subheading>' . HEADING_TITLE . '</span>'; ?></td>
            <td class="pageHeadingRedbg" align="right"><?php echo tep_image(DIR_WS_IMAGES . $category['categories_image'], $category['categories_name'], HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td>
          </tr>
		  <?php if (tep_not_null($category['categories_htc_description'])) { ?>
          <tr>
           <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
          </tr>
          <tr>
           <td colspan="2"><h2><?php echo $category['categories_htc_description']; ?></h2></td>
          </tr>
          <?php } 
          /*** End Header Tags SEO ***/ 
          ?>
        </table></td>
      </tr>
      <tr>
        <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
      </tr>
      <tr>
        <td><table border="0" width="100%" cellspacing="0" cellpadding="2">
          <tr>
            <td><table border="0" width="100%" cellspacing="0" cellpadding="2">
              <tr>
<?php
if (isset($cPath) && strpos('_', $cPath)) {
	// check to see if there are deeper categories within the current category
	$category_links = array_reverse($cPath_array);
	for($i=0, $n=sizeof($category_links); $i<$n; $i++) {
		$categories_query = tep_db_query("select count(*) as total from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '" . (int)$category_links[$i] . "' and c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "'");
		$categories = tep_db_fetch_array($categories_query);
		if ($categories['total'] < 1) {
			// do nothing, go through the loop
		} else {
			$categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.categories_image, c.parent_id from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '" . (int)$category_links[$i] . "' and c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "' order by sort_order, cd.categories_name");
			break; // we've found the deepest category the customer is in
		}
	}
} else {
	$categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.categories_image, c.parent_id from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '" . (int)$current_category_id . "' and c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "' order by sort_order, cd.categories_name");
}

$number_of_categories = tep_db_num_rows($categories_query);

$rows = 0;
while ($categories = tep_db_fetch_array($categories_query)) {
	$rows++;
	$cPath_new = tep_get_path($categories['categories_id']);
	$width = (int)(100 / MAX_DISPLAY_CATEGORIES_PER_ROW) . '%';
	echo '<td width="' . $width . '" valign="top"><TABLE width="100%" cellspacing="0" cellpadding="0" border=0>
		<TR>
		<TD width="16">' . tep_image(DIR_WS_IMAGES . '/ddtemplate/subcat_marker.gif') . '</TD>
        <TD><a class="ItemsListCat" href="' . tep_href_link(FILENAME_DEFAULT, $cPath_new) . '">' . $categories['categories_name'] . '</a></td>
	    </TR>
    	</TABLE>';
	if ((($rows / MAX_DISPLAY_CATEGORIES_PER_ROW) == floor($rows / MAX_DISPLAY_CATEGORIES_PER_ROW)) && ($rows != $number_of_categories)) {
		echo '              </tr>' . "\n";
		echo '              <tr>' . "\n";
	}
}

// needed for the new products module shown below
$new_products_category_id = $current_category_id;
?>
              </tr>
            </table></td>
          </tr>
          <tr>
            <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
          </tr>
          <tr>
            <td><?php include(DIR_WS_MODULES . 'new_products.php'); ?></td>
          </tr>
		  <!--- BEGIN Header Tags SEO Social Bookmarks -->
          <?php if (HEADER_TAGS_DISPLAY_SOCIAL_BOOKMARKS == 'true') 
           include(DIR_WS_MODULES . 'header_tags_social_bookmarks.php'); 
          ?>
          <!--- END Header Tags SEO Social Bookmarks --> 
        </table></td>
      </tr>
    </table></td>
</tr>
</table></td>

<?php
} elseif ($category_depth == 'products' || isset($HTTP_GET_VARS['manufacturers_id'])) {

	$category_query = tep_db_query("select categories_name from " . TABLE_CATEGORIES_DESCRIPTION . " where categories_id = '" . (int)$current_category_id . "' and language_id = '" . (int)$languages_id . "'");
	$category = tep_db_fetch_array($category_query);

	if (isset($HTTP_GET_VARS['manufacturers_id'])) {
		$manufacturer_query = tep_db_query("select manufacturers_name from " . TABLE_MANUFACTURERS . " where manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "'");
		$manufacturer = tep_db_fetch_array($manufacturer_query);
	}


	// create column list
	$define_list = array('PRODUCT_LIST_MODEL' => PRODUCT_LIST_MODEL,
	'PRODUCT_LIST_NAME' => PRODUCT_LIST_NAME,
	'PRODUCT_LIST_MANUFACTURER' => PRODUCT_LIST_MANUFACTURER,
	'PRODUCT_LIST_PRICE' => PRODUCT_LIST_PRICE,
	'PRODUCT_LIST_QUANTITY' => PRODUCT_LIST_QUANTITY,
	'PRODUCT_LIST_WEIGHT' => PRODUCT_LIST_WEIGHT,
	'PRODUCT_LIST_IMAGE' => PRODUCT_LIST_IMAGE,
	'PRODUCT_LIST_BUY_NOW' => PRODUCT_LIST_BUY_NOW);

	asort($define_list);

	$column_list = array();
	reset($define_list);
	while (list($key, $value) = each($define_list)) {
		if ($value > 0) $column_list[] = $key;
	}

	$select_column_list = '';

	for ($i=0, $n=sizeof($column_list); $i<$n; $i++) {
		switch ($column_list[$i]) {
			case 'PRODUCT_LIST_MODEL':
			$select_column_list .= 'p.products_model, ';
			break;
			case 'PRODUCT_LIST_NAME':
			$select_column_list .= 'pd.products_name, ';
			break;
			case 'PRODUCT_LIST_MANUFACTURER':
			$select_column_list .= 'm.manufacturers_name, ';
			break;
			case 'PRODUCT_LIST_QUANTITY':
			$select_column_list .= 'p.products_quantity,';
			break;
			case 'PRODUCT_LIST_IMAGE':
			$select_column_list .= 'p.products_image, ';
			break;
			case 'PRODUCT_LIST_WEIGHT':
			$select_column_list .= 'p.products_weight, ';
			break;
		}
	}

	$select_column_list .= 'p.products_date_added, p.products_date_available, p.products_import_module_codes, ';


	//B2BSUITE start
	$customer_group_query = tep_db_query("select customers_group_id from " . TABLE_CUSTOMERS . " where customers_id =  '" . $customer_id . "'");
	$customer_group = tep_db_fetch_array($customer_group_query);
	/*if ($listing_sql['specials_new_products_price'] != "" ){
	$listing_sql .= " and s.customers_group_id = '". (int)$customer_group['customers_group_id'] ."'";
	}		*/
	//B2BSUITE end

	// show the products of a specified manufacturer
	if (isset($HTTP_GET_VARS['manufacturers_id'])) {
		if (isset($HTTP_GET_VARS['filter_id']) && tep_not_null($HTTP_GET_VARS['filter_id'])) {
			// We are asked to show only a specific category
			//B2BSUITE start
			//$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$HTTP_GET_VARS['filter_id'] . "'";
			//$listing_sql = "select DISTINCTROW " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$HTTP_GET_VARS['filter_id'] . "'";
			$listing_sql = "select DISTINCTROW " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id and s.customers_group_id = '". (int)$customer_group['customers_group_id'] . "', " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$HTTP_GET_VARS['filter_id'] . "'";
			//B2BSUITE end
		} else {
			// We show them all
			//B2BSUITE start
			//$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "'";
			//$listing_sql = "select DISTINCTROW " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "'";
			$listing_sql = "select DISTINCTROW " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id and s.customers_group_id = '". (int)$customer_group['customers_group_id'] . "', " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "'";
			//B2BSUITE end
		}
	} else {
		// show the products in a given categorie
		if (isset($HTTP_GET_VARS['filter_id']) && tep_not_null($HTTP_GET_VARS['filter_id'])) {
			// We are asked to show only specific catgeory
			//B2BSUITE start
			//$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['filter_id'] . "' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "'";
			//$listing_sql = "select DISTINCTROW " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['filter_id'] . "' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "'";
			$listing_sql = "select DISTINCTROW " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id and s.customers_group_id = '". (int)$customer_group['customers_group_id'] . "', " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['filter_id'] . "' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "'";
			//B2BSUITE end
		} else {
			// We show them all
			//B2BSUITE start
			//$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "'";
			//$listing_sql = "select DISTINCTROW " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id from " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "'";
			$listing_sql = "select DISTINCTROW " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id from " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id and s.customers_group_id = '". (int)$customer_group['customers_group_id'] . "', " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "'";
			//B2BSUITE end
		}
	}

	if ( (!isset($HTTP_GET_VARS['sort'])) || (!ereg('[1-8][ad]', $HTTP_GET_VARS['sort'])) || (substr($HTTP_GET_VARS['sort'], 0, 1) > sizeof($column_list)) ) {
		for ($i=0, $n=sizeof($column_list); $i<$n; $i++) {
			if ($column_list[$i] == 'PRODUCT_LIST_NAME') {
				$HTTP_GET_VARS['sort'] = $i+1 . 'a';
				$listing_sql .= " order by pd.products_name";
				break;
			}
		}
	} else {
		$sort_col = substr($HTTP_GET_VARS['sort'], 0 , 1);
		$sort_order = substr($HTTP_GET_VARS['sort'], 1);
		$listing_sql .= ' order by ';
		switch ($column_list[$sort_col-1]) {
			case 'PRODUCT_LIST_MODEL':
			$listing_sql .= "p.products_model " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name";
			break;
			case 'PRODUCT_LIST_NAME':
			$listing_sql .= "pd.products_name " . ($sort_order == 'd' ? 'desc' : '');
			break;
			case 'PRODUCT_LIST_MANUFACTURER':
			$listing_sql .= "m.manufacturers_name " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name";
			break;
			case 'PRODUCT_LIST_QUANTITY':
			$listing_sql .= "p.products_quantity " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name";
			break;
			case 'PRODUCT_LIST_IMAGE':
			$listing_sql .= "pd.products_name";
			break;
			case 'PRODUCT_LIST_WEIGHT':
			$listing_sql .= "p.products_weight " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name";
			break;
			case 'PRODUCT_LIST_PRICE':
			//B2BSUITE start
			//$listing_sql .= "final_price " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name";
			$listing_sql .= "products_price " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name";
			//B2BSUITE end
			break;
		}
	}
?>
<td width="100%" valign="top" class="column-center"><table border="0" align=center width="100%" cellspacing="0" cellpadding="0">	

<tr><td><?php echo tep_draw_separator('pixel_trans.gif', '8', '11'); ?></td></tr>

<tr>
<?php /*** Begin Header Tags SEO ***/
    if (isset($HTTP_GET_VARS['manufacturers_id']))
      $db_query = tep_db_query("select manufacturers_htc_title_tag as htc_title, manufacturers_htc_description as htc_description from " . TABLE_MANUFACTURERS_INFO . " where languages_id = '" . (int)$languages_id . "' and manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "'");
    else
      $db_query = tep_db_query("select categories_htc_title_tag as htc_title, categories_htc_description as htc_description from " . TABLE_CATEGORIES_DESCRIPTION . " where categories_id = '" . (int)$current_category_id . "' and language_id = '" . (int)$languages_id . "'");

    $htc = tep_db_fetch_array($db_query);
    ?>
    <td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0">
      <tr>
        <td><table border="0" width="100%" cellspacing="0" cellpadding="0">
          <tr>
            <td><h1><?php echo $htc['htc_title']; ?></h1></td>
    <?php /*** End Header Tags SEO ***/ ?>
<?php
// optional Product List Filter
if (PRODUCT_LIST_FILTER > 0) {
	if (isset($HTTP_GET_VARS['manufacturers_id'])) {
		$filterlist_sql = "select distinct c.categories_id as id, cd.categories_name as name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where p.products_status = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and p2c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "' and p.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "' order by cd.categories_name";
	} else {
		$filterlist_sql= "select distinct m.manufacturers_id as id, m.manufacturers_name as name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_MANUFACTURERS . " m where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and p.products_id = p2c.products_id and p2c.categories_id = '" . (int)$current_category_id . "' order by m.manufacturers_name";
	}
	$filterlist_query = tep_db_query($filterlist_sql);
	if (tep_db_num_rows($filterlist_query) > 1) {
		echo '            <td align="center" class="pageHeadingRedbg">' . tep_draw_form('filter', FILENAME_DEFAULT, 'get') . TEXT_SHOW . ' ';
		if (isset($HTTP_GET_VARS['manufacturers_id'])) {
			echo tep_draw_hidden_field('manufacturers_id', $HTTP_GET_VARS['manufacturers_id']);
			$options = array(array('id' => '', 'text' => TEXT_ALL_CATEGORIES));
		} else {
			echo tep_draw_hidden_field('cPath', $cPath);
			$options = array(array('id' => '', 'text' => TEXT_ALL_MANUFACTURERS));
		}
		echo tep_draw_hidden_field('sort', $HTTP_GET_VARS['sort']);
		while ($filterlist = tep_db_fetch_array($filterlist_query)) {
			$options[] = array('id' => $filterlist['id'], 'text' => $filterlist['name']);
		}
		echo tep_draw_pull_down_menu('filter_id', $options, (isset($HTTP_GET_VARS['filter_id']) ? $HTTP_GET_VARS['filter_id'] : ''), 'onchange="this.form.submit()"');
		echo '</form></td>' . "\n";
	}
}

// Get the right image for the top-right
$image = DIR_WS_IMAGES . 'table_background_list.gif';
if (isset($HTTP_GET_VARS['manufacturers_id'])) {
	$image = tep_db_query("select manufacturers_image from " . TABLE_MANUFACTURERS . " where manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "'");
	$image = tep_db_fetch_array($image);
	$image = $image['manufacturers_image'];
} elseif ($current_category_id) {
	$image = tep_db_query("select categories_image from " . TABLE_CATEGORIES . " where categories_id = '" . (int)$current_category_id . "'");
	$image = tep_db_fetch_array($image);
	$image = $image['categories_image'];
}
?>
		   <?php /*** Begin Header Tags SEO ***/ ?>
            <td class="pageHeadingRedbg" align="right"><?php echo tep_image(DIR_WS_IMAGES . $image, $category['categories_htc_title_tag'], HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td>
          </tr>
          <?php if (tep_not_null($htc['htc_description'])) { ?>
          <tr>
           <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
          </tr>
          <tr>
           <td colspan="2"><h2><?php echo $htc['htc_description']; ?></h2></td>
          </tr>
          <?php } 
          /*** End Header Tags SEO ***/ 
          ?>
        </table></td>
      </tr>
      <tr>
        <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
      </tr>
      <tr>
        <td><?php include(DIR_WS_MODULES . FILENAME_PRODUCT_LISTING); ?></td>
      </tr>
	   <!--- BEGIN Header Tags SEO Social Bookmarks -->
          <?php if (HEADER_TAGS_DISPLAY_SOCIAL_BOOKMARKS == 'true') 
           include(DIR_WS_MODULES . 'header_tags_social_bookmarks.php'); 
          ?>
          <!--- END Header Tags SEO Social Bookmarks -->  
    </table></td>
</tr>
</table></td>

<?php
} else { // default page
?>
<td width="100%" valign="top" class="column-center"><table border="0" align=center width="100%" cellspacing="0" cellpadding="0">	
<tr><td><?php echo tep_draw_separator('pixel_trans.gif', '8', '11'); ?></td></tr>
<tr>
    <td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0">
      <tr>
        <td align="center"><?php echo tep_display_banner('dynamic', 'mainpage'); ?></td>
      </tr>
      <tr>
        <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
      </tr>
      <tr>
        <td><table border="0" width="100%" cellspacing="0" cellpadding="0">
     <tr>
            <td align=left class="pageHeadingHome"><?php echo HEADING_TITLE . '<br><br><span class=main>' 
            . tep_customer_greeting() . '<br></span>'; ?></td>
            <td class="pageHeading" align="right"><?php echo tep_image(DIR_WS_IMAGES . 'ddtemplate/logohome_right.png'); ?></td>
          </tr>
        </table></td>
      </tr>
      <tr>
        <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '1'); ?></td>
      </tr>
      <tr>
        <td><table border="0" width="100%" cellspacing="0" cellpadding="0">

      	  <tr>
        	<td align=center class="main"><?php include(DIR_WS_LANGUAGES . $language . '/includes/home_page.php'); ?></td>
          </tr>
          <tr>
            <td class="main"><?php //echo tep_customer_greeting(); ?></td>
          </tr>
          <tr>
            <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
          </tr>

<?php if(BOX_NEWS_SCROLLER_DISPLAY == 'true')
{
	?>

          <tr>
            <td align=center>

    
    <table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr><td><table cellpadding="0" cellspacing="0" width="100%" border="0" class="customContentInfoBoxHeading">
<tr><td class="customContentInfoBoxHeadingText"><img src="images/ddtemplate/corner_left_1.gif" border="0"></td><td width="100%" class="customContentInfoBoxHeadingText"><b><span class="scrollboxtitle"><?php echo  BOX_NEWS_SCROLLER; ?></span></b></td>
<td class="customContentInfoBoxHeadingText" align=right><img src="images/ddtemplate/corner_right_2.gif" border="0"></td></tr></table></td></tr>

<tr>
    <td width="100%" valign="top"><table border="0" width="100%" cellspacing="2" cellpadding="0" class=product_body>

    	   <tr>
			 <td align=center valign=middle>

			 <iframe width="100%" height="100%" src="<?php echo FILENAME_SCROLLNEWS; ?>" SCROLLING="no" FRAMEBORDER="0" border=0></iframe>

			</td>
          </tr>
          </table></td></tr>

<tr>
<td>
<table border="0" cellpadding="0" cellspacing="0" width="100%">
	<tbody><tr>
		<td class="BoxFooterSide"><img src="images/ddtemplate/corner_left_2.gif" border="0"></td>
		<td class="BoxFooter" valign="bottom" width="100%"></td>
		<td class="BoxFooterSide"><img src="images/ddtemplate/corner_right_1.gif" border="0"></td></tr>
</tbody></table></td>
</tr></table></td>
</tr>

          <tr>
            <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '25'); ?></td>
          </tr>
<?php } ?>
          <tr>
            <td><?php //include(DIR_WS_MODULES . FILENAME_FEATURED); ?></td>
          </tr>
          <tr>
            <td><?php //echo tep_draw_separator('pixel_trans.gif', '100%', '25'); ?></td>
          </tr>
          <tr>
            <td><?php include(DIR_WS_MODULES . 'new_products.php'); ?></td>
          </tr>
<?php
include(DIR_WS_MODULES . FILENAME_UPCOMING_PRODUCTS);
?>
          <tr>
            <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '30'); ?></td>
          </tr>
        </table></td>
      </tr>
    </table></td>
</tr>
</table></td>
<?php
}
?>
<!-- body_text_eof //-->
    <td width="<?php echo BOX_WIDTH; ?>" valign="top" class="column-right"><!-- right_navigation //-->
<?php require(DIR_WS_INCLUDES . 'column_right.php'); ?>
<!-- right_navigation_eof //-->
    </td>
  </tr>
</table>
<!-- body_eof //-->

<!-- footer //-->
<?php require(DIR_WS_INCLUDES . 'footer.php'); ?>
<!-- footer_eof //-->
<br>

</body>
</html>
<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>
http://www.newinformaticworld.com
I gestionali Danea 2009 da noi li trovi a prezzi scontati http://www.newinformaticworld.com/gesti ... _1455.html
Top
Avatar utente
marzioscaglione
membro Regular
membro Regular
Messaggi: 204
Iscritto il: 06/08/2007, 14:15
Località: Prato
Contatta:
Contatta marzioscaglione

Messaggio da marzioscaglione »

per il product_info.php non ci ho capito niente,

le modifiche sono:

Codice: Seleziona tutto

 FIND (around line 33)
   
<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0">

   ADD UNDER IT:

<?php /*** Begin Header Tags SEO ***/ ?>
<a name="<?php echo $header_tags_array['title']; ?>"></a>
<?php /*** End Header Tags SEO ***/ ?>

   =============================================
   FIND (around line 102)
            <td class="pageHeading" valign="top"><?php echo $products_name; ?></td>
            <td class="pageHeading" align="right" valign="top"><?php echo $products_price; ?></td>

   REPLACE with

            <?php /*** Begin Header Tags SEO ***/ ?>
            <td valign="top"><h1><?php echo $products_name; ?></h1></td>
            <td align="right" valign="top"><h1><?php echo $products_price; ?></h1></td>
            <?php /*** End Header Tags SEO ***/ ?>

   NOTE: In any page in which you make the change to the title for Header Tags, 
         you should also locate the line containing HEADING_TITLE, remove the 
         pageHeading class and add the h1 tags as above.

   =============================================
   FIND (around line 222)

                <td class="main"><?php echo '<a href="' . tep_href_link(FILENAME_PRODUCT_REVIEWS, tep_get_all_get_params()) . '">' . tep_image_button('button_reviews.gif', IMAGE_BUTTON_REVIEWS) . '</a>'; ?></td>
                <td class="main" align="right"><?php echo tep_draw_hidden_field('products_id', $product_info['products_id']) . tep_image_submit('button_in_cart.gif', IMAGE_BUTTON_IN_CART); ?></td>
                <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>
              </tr>
            </table></td>
          </tr>
        </table></td>
      </tr>
      <tr>
        <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
      </tr>

   ADD BELOW it:
 
      <!--- BEGIN Header Tags SEO Social Bookmarks -->
      <?php if (HEADER_TAGS_DISPLAY_SOCIAL_BOOKMARKS == 'true')
       include(DIR_WS_MODULES . 'header_tags_social_bookmarks.php');
      ?>
      <!--- END Header Tags SEO Social Bookmarks -->
http://www.newinformaticworld.com
I gestionali Danea 2009 da noi li trovi a prezzi scontati http://www.newinformaticworld.com/gesti ... _1455.html
Top
hsg26
membro Master
membro Master
Messaggi: 1677
Iscritto il: 07/04/2005, 0:00
Località: Svizzera
Contatta:
Contatta hsg26

Messaggio da hsg26 »

ti ho scritto dentro, cosa devi fare, è molto più semplice di quello che credi:
marzioscaglione ha scritto:

Codice: Seleziona tutto

 FIND (around line 33)
   
<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0">

   ADD UNDER IT: METTILO SEMPLICEMENTE SOTTO AL TAG DI APERTURA BODY

<?php /*** Begin Header Tags SEO ***/ ?>
<a name="<?php echo $header_tags_array['title']; ?>"></a>
<?php /*** End Header Tags SEO ***/ ?>

   =============================================
   FIND (around line 102)
            <td class="pageHeading" valign="top"><?php echo $products_name; ?></td>
            <td class="pageHeading" align="right" valign="top"><?php echo $products_price; ?></td>

   REPLACE with IN PRATICA, CERCA questo: <?php echo $products_name; ?> e mettilo in mezzo a due tags h1 (apertura e chiusura)

            <?php /*** Begin Header Tags SEO ***/ ?>
            <td valign="top"><h1><?php echo $products_name; ?></h1></td>
            <td align="right" valign="top"><h1><?php echo $products_price; ?></h1></td>
            <?php /*** End Header Tags SEO ***/ ?>

   NOTE: In any page in which you make the change to the title for Header Tags, 
         you should also locate the line containing HEADING_TITLE, remove the 
         pageHeading class and add the h1 tags as above.

   =============================================
   FIND (around line 222) 

                <td class="main"><?php echo '<a href="' . tep_href_link(FILENAME_PRODUCT_REVIEWS, tep_get_all_get_params()) . '">' . tep_image_button('button_reviews.gif', IMAGE_BUTTON_REVIEWS) . '</a>'; ?></td>
                <td class="main" align="right"><?php echo tep_draw_hidden_field('products_id', $product_info['products_id']) . tep_image_submit('button_in_cart.gif', IMAGE_BUTTON_IN_CART); ?></td>
                <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>
              </tr>
            </table></td>
          </tr>
        </table></td>
      </tr>
      <tr>
        <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
      </tr>

   ADD BELOW it: NON DEVI PER FORZA CERCARE QUESTO PEZZO, SIGNIFICA SOLO CHE IN UN PUNTO DELLA TUA PAGINA (LUI CONSIGLIA IN FONDO), DEVI AGGIUNGERE IL CODICE SOTTO.
 
      <!--- BEGIN Header Tags SEO Social Bookmarks -->
      <?php if (HEADER_TAGS_DISPLAY_SOCIAL_BOOKMARKS == 'true')
       include(DIR_WS_MODULES . 'header_tags_social_bookmarks.php');
      ?>
      <!--- END Header Tags SEO Social Bookmarks -->
La funzione CERCA si trova sotto al logo Oscommerce italia in questa pagina. - I Love Marketing!

I miei preferiti: internet marketing blog - biancheria da letto - prodotti tipici piemonte - vini piemontesi - roero arneis
Top
Avatar utente
marzioscaglione
membro Regular
membro Regular
Messaggi: 204
Iscritto il: 06/08/2007, 14:15
Località: Prato
Contatta:
Contatta marzioscaglione

Messaggio da marzioscaglione »

Grazie per l'aiuto,
provo a fare le modifiche e poi ti faccio sapere.

Ciao
http://www.newinformaticworld.com
I gestionali Danea 2009 da noi li trovi a prezzi scontati http://www.newinformaticworld.com/gesti ... _1455.html
Top
Avatar utente
marzioscaglione
membro Regular
membro Regular
Messaggi: 204
Iscritto il: 06/08/2007, 14:15
Località: Prato
Contatta:
Contatta marzioscaglione

Messaggio da marzioscaglione »

ciao hsg26,
finalmente ho finito per installare la contribuzione, però dal lato admin mi da errore:

Parse error: syntax error, unexpected T_DOUBLE_ARROW in /home/newinsi/public_html/admin/categories.php on line 582

in quel punto ho fatto la modifica trovata nelle istruzioni e cioè:


Per favore riesci a darmi una mano ?

Marzio

Codice: Seleziona tutto

Around line 260, find these lines in admin/categories.php

            $sql_data_array = array('products_name' => tep_db_prepare_input($HTTP_POST_VARS['products_name'][$language_id]),
                                    'products_description' => tep_db_prepare_input($HTTP_POST_VARS['products_description'][$language_id]),
                                    'products_url' => tep_db_prepare_input($HTTP_POST_VARS['products_url'][$language_id]));

REPLACE it with
                                
           /*** Begin Header Tags SEO ***/
            $sql_data_array = array('products_name' => tep_db_prepare_input($HTTP_POST_VARS['products_name'][$language_id]),
                                    'products_description' => tep_db_prepare_input($HTTP_POST_VARS['products_description'][$language_id]),
                                    'products_url' => tep_db_prepare_input($HTTP_POST_VARS['products_url'][$language_id]),
                                    'products_head_title_tag' => ((tep_not_null($HTTP_POST_VARS['products_head_title_tag'][$language_id])) ? tep_db_prepare_input($HTTP_POST_VARS['products_head_title_tag'][$language_id]) : tep_db_prepare_input($HTTP_POST_VARS['products_name'][$language_id])),
                                    'products_head_desc_tag' => ((tep_not_null($HTTP_POST_VARS['products_head_desc_tag'][$language_id])) ? tep_db_prepare_input($HTTP_POST_VARS['products_head_desc_tag'][$language_id]) : tep_db_prepare_input($HTTP_POST_VARS['products_name'][$language_id])),
                                    'products_head_keywords_tag' => ((tep_not_null($HTTP_POST_VARS['products_head_keywords_tag'][$language_id])) ? tep_db_prepare_input($HTTP_POST_VARS['products_head_keywords_tag'][$language_id]) : tep_db_prepare_input($HTTP_POST_VARS['products_name'][$language_id])));                                     
           /*** End Header Tags SEO ***/
Ultima modifica di marzioscaglione il 19/06/2008, 17:22, modificato 1 volta in totale.
http://www.newinformaticworld.com
I gestionali Danea 2009 da noi li trovi a prezzi scontati http://www.newinformaticworld.com/gesti ... _1455.html
Top
hsg26
membro Master
membro Master
Messaggi: 1677
Iscritto il: 07/04/2005, 0:00
Località: Svizzera
Contatta:
Contatta hsg26

Messaggio da hsg26 »

c'è una parentesi di chiusura di troppo. Solo che con il codice cosî mi si incrocia la vista. Metti il codice nei tags code e le indicazioni della linea incriminata.
La funzione CERCA si trova sotto al logo Oscommerce italia in questa pagina. - I Love Marketing!

I miei preferiti: internet marketing blog - biancheria da letto - prodotti tipici piemonte - vini piemontesi - roero arneis
Top
Avatar utente
marzioscaglione
membro Regular
membro Regular
Messaggi: 204
Iscritto il: 06/08/2007, 14:15
Località: Prato
Contatta:
Contatta marzioscaglione

Messaggio da marzioscaglione »

ho trovato l'errore, alla fine della terza riga della modifica c'è una parentesi in più e il punto e virgola invece della virgola.

Adesso mi da un altro errore, cliccando su Categorie / Prodotti lato admin viene:

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' c.on_header from categories c, categories_description cd where c.parent_id = '0' at line 1

select c.categories_id, cd.categories_name, c.categories_image, c.parent_id, c.sort_order, c.date_added, c.last_modified, cd.categories_htc_title_tag, cd.categories_htc_desc_tag, cd.categories_htc_keywords_tag, cd.categories_htc_description from, c.on_header from categories c, categories_description cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id = '4' order by c.sort_order, cd.categories_name

Aiuto !
http://www.newinformaticworld.com
I gestionali Danea 2009 da noi li trovi a prezzi scontati http://www.newinformaticworld.com/gesti ... _1455.html
Top
hsg26
membro Master
membro Master
Messaggi: 1677
Iscritto il: 07/04/2005, 0:00
Località: Svizzera
Contatta:
Contatta hsg26

Messaggio da hsg26 »

ehm... esiste anche la ricerca nel forum... è uno degli errori più comuni.. trattato circa 40 volte al mese :)

viewtopic.php?t=9575&highlight=1064
La funzione CERCA si trova sotto al logo Oscommerce italia in questa pagina. - I Love Marketing!

I miei preferiti: internet marketing blog - biancheria da letto - prodotti tipici piemonte - vini piemontesi - roero arneis
Top
Avatar utente
marzioscaglione
membro Regular
membro Regular
Messaggi: 204
Iscritto il: 06/08/2007, 14:15
Località: Prato
Contatta:
Contatta marzioscaglione

Messaggio da marzioscaglione »

ho fatto la modifica indicata nel link ma l'errore è sempre:

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' c.on_header from categories c, categories_description cd where c.parent_id = '0' at line 1

select c.categories_id, cd.categories_name, c.categories_image, c.parent_id, c.sort_order, c.date_added, c.last_modified, cd.categories_htc_title_tag, cd.categories_htc_desc_tag, cd.categories_htc_keywords_tag, cd.categories_htc_description from, c.on_header from categories c, categories_description cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id = '4' order by c.sort_order, cd.categories_name
http://www.newinformaticworld.com
I gestionali Danea 2009 da noi li trovi a prezzi scontati http://www.newinformaticworld.com/gesti ... _1455.html
Top
hsg26
membro Master
membro Master
Messaggi: 1677
Iscritto il: 07/04/2005, 0:00
Località: Svizzera
Contatta:
Contatta hsg26

Messaggio da hsg26 »

marzioscaglione ha scritto:ho fatto la modifica indicata nel link ma l'errore è sempre:

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' c.on_header from categories c, categories_description cd where c.parent_id = '0' at line 1

select c.categories_id, cd.categories_name, c.categories_image, c.parent_id, c.sort_order, c.date_added, c.last_modified, cd.categories_htc_title_tag, cd.categories_htc_desc_tag, cd.categories_htc_keywords_tag, cd.categories_htc_description from, c.on_header from categories c, categories_description cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id = '4' order by c.sort_order, cd.categories_name
di solito con quella modifica funziona.

Prova a guardare qui: http://forums.oscommerce.com/index.php?showtopic=298099
La funzione CERCA si trova sotto al logo Oscommerce italia in questa pagina. - I Love Marketing!

I miei preferiti: internet marketing blog - biancheria da letto - prodotti tipici piemonte - vini piemontesi - roero arneis
Top
hsg26
membro Master
membro Master
Messaggi: 1677
Iscritto il: 07/04/2005, 0:00
Località: Svizzera
Contatta:
Contatta hsg26

Messaggio da hsg26 »

prova a farla anche lato catalogo.
La funzione CERCA si trova sotto al logo Oscommerce italia in questa pagina. - I Love Marketing!

I miei preferiti: internet marketing blog - biancheria da letto - prodotti tipici piemonte - vini piemontesi - roero arneis
Top
Avatar utente
marzioscaglione
membro Regular
membro Regular
Messaggi: 204
Iscritto il: 06/08/2007, 14:15
Località: Prato
Contatta:
Contatta marzioscaglione

Messaggio da marzioscaglione »

Ti ringrazio per la pazienza che hai,
non mi ero accorto ma il fix era già applicato, sia dal lato admin che catalogo.

Provo a ricontrollare tutti i passaggi della modifica, magari ho sbagliato qualcosa.

Marzio
http://www.newinformaticworld.com
I gestionali Danea 2009 da noi li trovi a prezzi scontati http://www.newinformaticworld.com/gesti ... _1455.html
Top
Rispondi

Torna a “Contributions”