Pektsekye Posted June 4, 2009 Share Posted June 4, 2009 The only contributions I have are easy Meta Tags, lightbox, fck editor. In the admin, I have cache turned off. Any other suggestions? I have just installed it with auto installer on my test host have a look the first time i open the site the product link is: microsoft-microsoft-intellimouse-explorer-p-32.html?osCsid=8af7209a1a862fe3176ddc808df115af compare with your: product_info.php?products_id=417?osCsid=26cb1cf3124dfd55982c1b5150af8889 your products urls are not seo show the content of your product_listing.php file here Stanislav Quote Link to comment Share on other sites More sharing options...
night_fire Posted June 4, 2009 Share Posted June 4, 2009 I have just installed it with auto installer on my test hosthave a look the first time i open the site the product link is: microsoft-microsoft-intellimouse-explorer-p-32.html?osCsid=8af7209a1a862fe3176ddc808df115af compare with your: product_info.php?products_id=417?osCsid=26cb1cf3124dfd55982c1b5150af8889 your products urls are not seo show the content of your product_listing.php file here Stanislav That is the way they appear when you first got to site. If you refresh page it changes to the SEO url. Here's my product_listing.php <?php /* $Id: product_listing.php,v 1.44 2003/06/09 22:49:59 hpdl Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2003 osCommerce Released under the GNU General Public License */ $new_products=array(); $new_p_id=array(); ?> <script language="javascript"><!-- function popupWindow(url) { window.open(url,'popupWindow','toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=no,res izable=yes,copyhistory=no,width=290,height=290,screenX=290,screenY=290,top=150,le ft=150'); } //--></script> <table border="0" cellspacing="1" cellpadding="0"> <tr><td style="background-image:url(images/m22.gif);" width="531" height="31"> <span class="tx2"><?=$breadcrumb->trail(' » ')?></span></td></tr> <tr><td height="2"></td></tr> <tr><td width="533"> <table border="0" cellspacing="0" cellpadding="0" width="527" align="center"> <? $listing_split = new splitPageResults($listing_sql, MAX_DISPLAY_SEARCH_RESULTS, 'p.products_id'); if ( ($listing_split->number_of_rows > 0) && ( (PREV_NEXT_BAR_LOCATION == '1') || (PREV_NEXT_BAR_LOCATION == '3') ) ) { ?> <tr><td colspan="5"> <table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td class="smallText"><?php echo $listing_split->display_count(TEXT_DISPLAY_NUMBER_OF_PRODUCTS); ?></td> <td class="smallText" align="right"><?php echo TEXT_RESULT_PAGE . ' ' . $listing_split->display_links(MAX_DISPLAY_PAGE_LINKS, tep_get_all_get_params(array('page', 'info', 'x', 'y'))); ?></td> </tr> </table> </td></tr> <?php } $list_box_contents = array(); for ($col=0, $n=sizeof($column_list); $col<$n; $col++) { switch ($column_list[$col]) { case 'PRODUCT_LIST_MODEL': $lc_text = TABLE_HEADING_MODEL; $lc_align = ''; break; case 'PRODUCT_LIST_NAME': $lc_text = TABLE_HEADING_PRODUCTS; $lc_align = ''; break; case 'PRODUCT_LIST_MANUFACTURER': $lc_text = TABLE_HEADING_MANUFACTURER; $lc_align = ''; break; case 'PRODUCT_LIST_PRICE': $lc_text = TABLE_HEADING_PRICE; $lc_align = 'right'; break; case 'PRODUCT_LIST_QUANTITY': $lc_text = TABLE_HEADING_QUANTITY; $lc_align = 'right'; break; case 'PRODUCT_LIST_WEIGHT': $lc_text = TABLE_HEADING_WEIGHT; $lc_align = 'right'; break; case 'PRODUCT_LIST_IMAGE': $lc_text = TABLE_HEADING_IMAGE; $lc_align = 'center'; break; case 'PRODUCT_LIST_BUY_NOW': $lc_text = TABLE_HEADING_BUY_NOW; $lc_align = 'center'; break; } if ( ($column_list[$col] != 'PRODUCT_LIST_BUY_NOW') && ($column_list[$col] != 'PRODUCT_LIST_IMAGE') ) { $lc_text = tep_create_sort_heading($HTTP_GET_VARS['sort'], $col+1, $lc_text); } $list_box_contents[0][] = array('align' => $lc_align, 'params' => 'class="productListing-heading"', 'text' => ' ' . $lc_text . ' '); } if ($listing_split->number_of_rows > 0) { $rows = 0; $listing_query = tep_db_query($listing_split->sql_query); while ($listing = tep_db_fetch_array($listing_query)) { $rows++; if (($rows/2) == floor($rows/2)) { $list_box_contents[] = array('params' => 'class="productListing-even"'); } else { $list_box_contents[] = array('params' => 'class="productListing-odd"'); } $cur_row = sizeof($list_box_contents) - 1; for ($col=0, $n=sizeof($column_list); $col<$n; $col++) { $lc_align = ''; switch ($column_list[$col]) { case 'PRODUCT_LIST_MODEL': $lc_align = ''; $lc_text = ' ' . $listing['products_model'] . ' '; break; case 'PRODUCT_LIST_NAME': $lc_align = ''; if (isset($HTTP_GET_VARS['manufacturers_id'])) { $lc_text = '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'manufacturers_id=' . $HTTP_GET_VARS['manufacturers_id'] . '&products_id=' . $listing['products_id']) . '">' . $listing['products_name'] . '</a>'; } else { $lc_text = ' <a href="' . tep_href_link(FILENAME_PRODUCT_INFO, ($cPath ? 'cPath=' . $cPath . '&' : '') . 'products_id=' . $listing['products_id']) . '">' . $listing['products_name'] . '</a> '; } break; case 'PRODUCT_LIST_MANUFACTURER': $lc_align = ''; $lc_text = ' <a href="' . tep_href_link(FILENAME_DEFAULT, 'manufacturers_id=' . $listing['manufacturers_id']) . '">' . $listing['manufacturers_name'] . '</a> '; break; case 'PRODUCT_LIST_PRICE': $lc_align = 'right'; if (tep_not_null($listing['specials_new_products_price'])) { $lc_text = '<span>' . $currencies->display_price($listing['specials_new_products_price'], tep_get_tax_rate($listing['products_tax_class_id'])) . '</span> <del style="font-weight:normal;color:#808080;font-size:11px;">' . $currencies->display_price($listing['products_price'], tep_get_tax_rate($listing['products_tax_class_id'])) . '</del>'; } else { $lc_text = '<span>' . $currencies->display_price($listing['products_price'], tep_get_tax_rate($listing['products_tax_class_id'])) . '</span>'; } break; case 'PRODUCT_LIST_QUANTITY': $lc_align = 'right'; $lc_text = ' ' . $listing['products_quantity'] . ' '; break; case 'PRODUCT_LIST_WEIGHT': $lc_align = 'right'; $lc_text = ' ' . $listing['products_weight'] . ' '; break; case 'PRODUCT_LIST_IMAGE': $lc_align = 'center'; if (isset($HTTP_GET_VARS['manufacturers_id'])) { $lc_text = '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'manufacturers_id=' . $HTTP_GET_VARS['manufacturers_id'] . '&products_id=' . $listing['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $listing['products_image'], $listing['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a>'; } else { $lc_text = ' <a href="' . tep_href_link(FILENAME_PRODUCT_INFO, ($cPath ? 'cPath=' . $cPath . '&' : '') . 'products_id=' . $listing['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $listing['products_image'], $listing['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a> '; } break; case 'PRODUCT_LIST_BUY_NOW': $lc_align = 'center'; $lc_text = '<a href="' . tep_href_link(basename($PHP_SELF), tep_get_all_get_params(array('action')) . 'action=buy_now&products_id=' . $listing['products_id']) . '">' . tep_image_button('button_buy_now.gif', IMAGE_BUTTON_BUY_NOW) . '</a> '; break; } $list_box_contents[$cur_row][] = array('align' => $lc_align,'params' => 'class="productListing-data"','text' => $lc_text); $product_contents[] = $lc_text; } $product_query = tep_db_query("select products_description, products_id from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . (int)$listing['products_id'] . "' and language_id = '" . (int)$languages_id . "'"); $product = tep_db_fetch_array($product_query); array_push($new_products,$product['products_description']); array_push($new_p_id,$product['products_id']); } ?> <? $col=0; $row=0; for ($i=1;$i<count($list_box_contents);$i++) { $j=$list_box_contents[$i]; if ($col==0) echo '<tr>'; if ($col!=0) echo '<td width="2"></td>'; ?> <td width="174" valign="top" class="bd"> <table border="0" cellspacing="0" cellpadding="0" width="167" align="center"> <tr><td height="2"></td></tr> <tr><td width="167" height="89" bgcolor="#FFFFFF" align="center"><?=$j[0][text]?></td></tr> <tr><td width="167" height="65" bgcolor="#1A1C1F" class="tx4"><br style="line-height:1px;"><br style="line-height:2px;"><b><?=$j[1][text]?></b><br style="line-height:1px;"><br style="line-height:4px;"></td></tr> <tr><td width="167" height="30" style="padding-left:12px;" class="tx6" align="center"> <?=$j[2][text]?><br style="line-height:1px;"><br style="line-height:10px;"></td></tr> <tr><td><a href="<?=tep_href_link('product_info.php?products_id='.$new_p_id[$i-1])?>"><?=tep_image_button("button_more.gif");?></a><a href="<?= tep_href_link("products_new.php","action=buy_now&products_id=".$new_p_id[$i-1])?>"><?=tep_image_button("button_add_to_cart.gif");?></a></td></tr> <tr><td height="3"></td></tr> </table> </td> <? if ($col==2) { echo '</tr>'; $col=0; } else { $col++; } } if ($col!=0) echo '</tr>'; ?></table><? /* new productListingBox($list_box_contents); */ } else { echo '<tr><td></td></tr></table>'; $list_box_contents = array(); $list_box_contents[0] = array('params' => 'class="productListing-odd"'); $list_box_contents[0][] = array('params' => 'class="productListing-data"'); // new productListingBox($list_box_contents); } if ( ($listing_split->number_of_rows > 0) && ((PREV_NEXT_BAR_LOCATION == '2') || (PREV_NEXT_BAR_LOCATION == '3')) ) { ?> <table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td class="smallText"><?php echo $listing_split->display_count(TEXT_DISPLAY_NUMBER_OF_PRODUCTS); ?></td> <td class="smallText" align="right"><?php echo TEXT_RESULT_PAGE . ' ' . $listing_split->display_links(MAX_DISPLAY_PAGE_LINKS, tep_get_all_get_params(array('page', 'info', 'x', 'y'))); ?></td> </tr> </table> <?php } ?> </td> </tr> </table> Quote Custom PC's, Components, Liquid Cooling, Notebooks and More Link to comment Share on other sites More sharing options...
Pektsekye Posted June 5, 2009 Share Posted June 5, 2009 (edited) That is the way they appear when you first got to site. If you refresh page it changes to the SEO url. They never change to seo on your site Check the source : <td width="174" valign="top" class="bd"> <table border="0" cellspacing="0" cellpadding="0" width="167" align="center"> <tr><td height="2"></td></tr> <tr><td width="167" height="89" bgcolor="#FFFFFF" align="center"><a href="http://www.homebrewpconline.com/product_info.php?products_id=310"><img src="images/Fatality_TOP_700w_b.jpg" border="0" alt="OCZ Fatal1ty Series Power Supply 700W" title=" OCZ Fatal1ty Series Power Supply 700W " width="125" height="125"></a></td></tr> <tr><td width="167" height="65" bgcolor="#1A1C1F" class="tx4"><br style="line-height:1px;"><br style="line-height:2px;"><b><a style="color:#C4DBF2;text-decoration:none;" href="http://www.homebrewpconline.com/product_info.php?products_id=310">OCZ Fatal1ty Series Power Supply 700W</a></b><br style="line-height:1px;"><br style="line-height:4px;"></td></tr> <tr><td width="167" style="padding-left:12px;" class="tx6" align="center"> $132.99<br style="line-height:1px;"><br style="line-height:10px;"></td></tr> <tr><td><a href="http://www.homebrewpconline.com/product_info.php?products_id=310"><img src="includes/languages/english/images/buttons/button_more.gif" border="0" alt="" width="65" height="27"></a><a href="http://www.homebrewpconline.com/products_new.php?action=buy_now&products_id=310"><img src="includes/languages/english/images/buttons/button_add_to_cart.gif" border="0" alt="" width="103" height="27"></a></td></tr> <tr><td height="3"></td></tr> </table> </td> You see the seo product url in the browser address bar because of 301 auto redirects Only the categories links on your site are seo I have just found that the product links are seo on your products_new.php and on this page: power-supplies-800999-watts-c-104_106.html but not here: power-supplies-c-104.html and here: software-c-143.html can you find out why few of the pages have seo products links and few not ? Stanislav Edited June 5, 2009 by Pektsekye Quote Link to comment Share on other sites More sharing options...
Pektsekye Posted June 5, 2009 Share Posted June 5, 2009 I see that the products links in the What's New? block are not seo can you show the code for this block here? Stanislav Quote Link to comment Share on other sites More sharing options...
night_fire Posted June 5, 2009 Share Posted June 5, 2009 I see that the products links in the What's New? block are not seo can you show the code for this block here? Stanislav Sorry, but new to this. What would you like me to post so you can view? Quote Custom PC's, Components, Liquid Cooling, Notebooks and More Link to comment Share on other sites More sharing options...
night_fire Posted June 5, 2009 Share Posted June 5, 2009 Think this is what u wanted. <?php /* $Id: new_products.php,v 1.1.1.1 2006/08/14 09:45:13 User Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2003 osCommerce Released under the GNU General Public License */ ?> <script language="javascript"><!-- function popupWindow(url) { window.open(url,'popupWindow','toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=no,res izable=yes,copyhistory=no,width=290,height=290,screenX=290,screenY=290,top=150,le ft=150'); } //--></script> <!-- new_products //--> <?php $info_box_contents = sprintf(TABLE_HEADING_NEW_PRODUCTS, strftime('%B')); if ( (!isset($new_products_category_id)) || ($new_products_category_id == '0') ) { $new_products_query = tep_db_query("select p.products_id, p.products_image, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where products_status = '1' order by RAND() limit " . MAX_DISPLAY_NEW_PRODUCTS); } else { $new_products_query = tep_db_query("select distinct p.products_id, p.products_image, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '" . (int)$new_products_category_id . "' and p.products_status = '1' order by RAND() limit " . MAX_DISPLAY_NEW_PRODUCTS); } $row = 0; $col = 0; ?> <table border="0" cellspacing="1" cellpadding="0" class="zxc6"> <tr><td width="533"> <table border="0" cellspacing="0" cellpadding="0" width="527" align="center"> <? while ($new_products = tep_db_fetch_array($new_products_query)) { $new_products['products_name'] = tep_get_products_name($new_products['products_id']); $product_query = tep_db_query("select products_description from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . (int)$new_products['products_id'] . "' and language_id = '" . (int)$languages_id . "'"); $product = tep_db_fetch_array($product_query); $new_products['products_description'] = $product['products_description']; if ($col==0) echo '<tr>'; if ($col!=0) echo '<td width="2"></td>'; ?> <td width="174" valign="top" class="bd"> <table border="0" cellspacing="0" cellpadding="0" width="167" align="center"> <tr><td height="2"></td></tr> <tr><td width="167" height="89" bgcolor="#FFFFFF" align="center"><a href="<?=tep_href_link('product_info.php?products_id='.$new_products['products_id'])?>"><?=tep_image(DIR_WS_IMAGES.$new_products['products_image'],$new_products['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT)?></a></td></tr> <tr><td width="167" height="65" bgcolor="#1A1C1F" class="tx4"><br style="line-height:1px;"><br style="line-height:2px;"><b><a style="color:#C4DBF2;text-decoration:none;" href="<?=tep_href_link('product_info.php?products_id='.$new_products['products_id'])?>"><?=$new_products['products_name']?></a></b><br style="line-height:1px;"><br style="line-height:4px;"></td></tr> <tr><td width="167" style="padding-left:12px;" class="tx6" align="center"> <?=$currencies->display_price($new_products['products_price'], tep_get_tax_rate($new_products['products_tax_class_id']))?><br style="line-height:1px;"><br style="line-height:10px;"></td></tr> <tr><td><a href="<?=tep_href_link('product_info.php?products_id='.$new_products['products_id'])?>"><?=tep_image_button("button_more.gif");?></a><a href="<?= tep_href_link("products_new.php","action=buy_now&products_id=".$new_products['products_id'])?>"><?=tep_image_button("button_add_to_cart.gif");?></a></td></tr> <tr><td height="3"></td></tr> </table> </td> <? if ($col==2) { echo '</tr>'; $col=0; } else { $col++; } } if ($col!=0) echo '</tr>'; ?> </table> </td> </tr> </table> Quote Custom PC's, Components, Liquid Cooling, Notebooks and More Link to comment Share on other sites More sharing options...
Pektsekye Posted June 5, 2009 Share Posted June 5, 2009 Try this code: <?php /* $Id: new_products.php,v 1.1.1.1 2006/08/14 09:45:13 User Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2003 osCommerce Released under the GNU General Public License */ ?> <script language="javascript"><!-- function popupWindow(url) { window.open(url,'popupWindow','toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=no,res izable=yes,copyhistory=no,width=290,height=290,screenX=290,screenY=290,top=150,l e ft=150'); } //--></script> <!-- new_products //--> <?php $info_box_contents = sprintf(TABLE_HEADING_NEW_PRODUCTS, strftime('%B')); if ( (!isset($new_products_category_id)) || ($new_products_category_id == '0') ) { $new_products_query = tep_db_query("select p.products_id, p.products_image, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where products_status = '1' order by RAND() limit " . MAX_DISPLAY_NEW_PRODUCTS); } else { $new_products_query = tep_db_query("select distinct p.products_id, p.products_image, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '" . (int)$new_products_category_id . "' and p.products_status = '1' order by RAND() limit " . MAX_DISPLAY_NEW_PRODUCTS); } $row = 0; $col = 0; ?> <table border="0" cellspacing="1" cellpadding="0" class="zxc6"> <tr><td width="533"> <table border="0" cellspacing="0" cellpadding="0" width="527" align="center"> <? while ($new_products = tep_db_fetch_array($new_products_query)) { $new_products['products_name'] = tep_get_products_name($new_products['products_id']); $product_query = tep_db_query("select products_description from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . (int)$new_products['products_id'] . "' and language_id = '" . (int)$languages_id . "'"); $product = tep_db_fetch_array($product_query); $new_products['products_description'] = $product['products_description']; if ($col==0) echo '<tr>'; if ($col!=0) echo '<td width="2"></td>'; ?> <td width="174" valign="top" class="bd"> <table border="0" cellspacing="0" cellpadding="0" width="167" align="center"> <tr><td height="2"></td></tr> <tr><td width="167" height="89" bgcolor="#FFFFFF" align="center"><a href="<?php echo tep_href_link(FILENAME_PRODUCT_INFO, ($cPath ? 'cPath=' . $cPath . '&' : '') . 'products_id=' . $new_products['products_id']); ?>"><?php echo tep_image(DIR_WS_IMAGES.$new_products['products_image'],$new_products['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT); ?></a></td></tr> <tr><td width="167" height="65" bgcolor="#1A1C1F" class="tx4"><br style="line-height:1px;"><br style="line-height:2px;"><b><a style="color:#C4DBF2;text-decoration:none;" href="<?php echo tep_href_link(FILENAME_PRODUCT_INFO, ($cPath ? 'cPath=' . $cPath . '&' : '') . 'products_id=' . $new_products['products_id']); ?>"><?php echo $new_products['products_name']; ?></a></b><br style="line-height:1px;"><br style="line-height:4px;"></td></tr> <tr><td width="167" style="padding-left:12px;" class="tx6" align="center"> <?php echo $currencies->display_price($new_products['products_price'], tep_get_tax_rate($new_products['products_tax_class_id'])); ?><br style="line-height:1px;"><br style="line-height:10px;"></td></tr> <tr><td><a href="<?php echo tep_href_link(FILENAME_PRODUCT_INFO, ($cPath ? 'cPath=' . $cPath . '&' : '') . 'products_id=' . $new_products['products_id']);?>"><?php echo tep_image_button("button_more.gif");?></a><a href="<?php echo tep_href_link(basename($PHP_SELF), tep_get_all_get_params(array('action')) . 'action=buy_now&products_id=' . $new_products['products_id']); ?>"><?php echo tep_image_button("button_add_to_cart.gif"); ?></a></td></tr> <tr><td height="3"></td></tr> </table> </td> <? if ($col==2) { echo '</tr>'; $col=0; } else { $col++; } } if ($col!=0) echo '</tr>'; ?> </table> </td> </tr> </table> Stanislav Quote Link to comment Share on other sites More sharing options...
night_fire Posted June 5, 2009 Share Posted June 5, 2009 Try this code: <?php /* $Id: new_products.php,v 1.1.1.1 2006/08/14 09:45:13 User Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2003 osCommerce Released under the GNU General Public License */ ?> <script language="javascript"><!-- function popupWindow(url) { window.open(url,'popupWindow','toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=no,res izable=yes,copyhistory=no,width=290,height=290,screenX=290,screenY=290,top=150,l e ft=150'); } //--></script> <!-- new_products //--> <?php $info_box_contents = sprintf(TABLE_HEADING_NEW_PRODUCTS, strftime('%B')); if ( (!isset($new_products_category_id)) || ($new_products_category_id == '0') ) { $new_products_query = tep_db_query("select p.products_id, p.products_image, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where products_status = '1' order by RAND() limit " . MAX_DISPLAY_NEW_PRODUCTS); } else { $new_products_query = tep_db_query("select distinct p.products_id, p.products_image, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '" . (int)$new_products_category_id . "' and p.products_status = '1' order by RAND() limit " . MAX_DISPLAY_NEW_PRODUCTS); } $row = 0; $col = 0; ?> <table border="0" cellspacing="1" cellpadding="0" class="zxc6"> <tr><td width="533"> <table border="0" cellspacing="0" cellpadding="0" width="527" align="center"> <? while ($new_products = tep_db_fetch_array($new_products_query)) { $new_products['products_name'] = tep_get_products_name($new_products['products_id']); $product_query = tep_db_query("select products_description from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . (int)$new_products['products_id'] . "' and language_id = '" . (int)$languages_id . "'"); $product = tep_db_fetch_array($product_query); $new_products['products_description'] = $product['products_description']; if ($col==0) echo '<tr>'; if ($col!=0) echo '<td width="2"></td>'; ?> <td width="174" valign="top" class="bd"> <table border="0" cellspacing="0" cellpadding="0" width="167" align="center"> <tr><td height="2"></td></tr> <tr><td width="167" height="89" bgcolor="#FFFFFF" align="center"><a href="<?php echo tep_href_link(FILENAME_PRODUCT_INFO, ($cPath ? 'cPath=' . $cPath . '&' : '') . 'products_id=' . $new_products['products_id']); ?>"><?php echo tep_image(DIR_WS_IMAGES.$new_products['products_image'],$new_products['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT); ?></a></td></tr> <tr><td width="167" height="65" bgcolor="#1A1C1F" class="tx4"><br style="line-height:1px;"><br style="line-height:2px;"><b><a style="color:#C4DBF2;text-decoration:none;" href="<?php echo tep_href_link(FILENAME_PRODUCT_INFO, ($cPath ? 'cPath=' . $cPath . '&' : '') . 'products_id=' . $new_products['products_id']); ?>"><?php echo $new_products['products_name']; ?></a></b><br style="line-height:1px;"><br style="line-height:4px;"></td></tr> <tr><td width="167" style="padding-left:12px;" class="tx6" align="center"> <?php echo $currencies->display_price($new_products['products_price'], tep_get_tax_rate($new_products['products_tax_class_id'])); ?><br style="line-height:1px;"><br style="line-height:10px;"></td></tr> <tr><td><a href="<?php echo tep_href_link(FILENAME_PRODUCT_INFO, ($cPath ? 'cPath=' . $cPath . '&' : '') . 'products_id=' . $new_products['products_id']);?>"><?php echo tep_image_button("button_more.gif");?></a><a href="<?php echo tep_href_link(basename($PHP_SELF), tep_get_all_get_params(array('action')) . 'action=buy_now&products_id=' . $new_products['products_id']); ?>"><?php echo tep_image_button("button_add_to_cart.gif"); ?></a></td></tr> <tr><td height="3"></td></tr> </table> </td> <? if ($col==2) { echo '</tr>'; $col=0; } else { $col++; } } if ($col!=0) echo '</tr>'; ?> </table> </td> </tr> </table> Stanislav First off let me say THANKS!!!!!!!!!!!! That seems like it id it. May I ask what you found that was causing me a headache? I can always use winmerge to see but I wount be home untill late. Thanks again for your help. BTW what would be a good book to start learning php? Quote Custom PC's, Components, Liquid Cooling, Notebooks and More Link to comment Share on other sites More sharing options...
Pektsekye Posted June 5, 2009 Share Posted June 5, 2009 (edited) May I ask what you found that was causing me a headache? I have replaced: tep_href_link('product_info.php?products_id='.$new_products['products_id']) with: tep_href_link(FILENAME_PRODUCT_INFO, ($cPath ? 'cPath=' . $cPath . '&' : '') . 'products_id=' . $new_products['products_id']) few times BTW what would be a good book to start learning php? I cannot suggest any good book. I had a tutor in my city ( $100 one month). Then I have tried many simple examples from Internet. Then php.net and dev.mysql.com/doc/mysql/en for description of exact functions only. Then 100+ freelance simple projects. - You don't need it Then this forum in spare time. - You don't need it Stanislav Edited June 5, 2009 by Pektsekye Quote Link to comment Share on other sites More sharing options...
Stroker396 Posted June 6, 2009 Share Posted June 6, 2009 Sure enough, I uploaded the two files from 2.1d and it works like a charm. something does not match up in the 2.7V Question, I see the new version 5 is is available but is says that it will only work with PHP 5.2? Is there any way that it can be used with version PHP4.1? Quote The Site can be viewed at www.performanceautopartsonline.com The site is live (despite these minor glitches) please respect that and do not sign up etc... maybe a contribution one day when I get this site the way I want it. I don't make spelling mistakes! I have dyslecsic fingers. Link to comment Share on other sites More sharing options...
Pektsekye Posted June 6, 2009 Share Posted June 6, 2009 Question, I see the new version 5 is is available but is says that it will only work with PHP 5.2? Is there any way that it can be used with version PHP4.1? No It's impossible. You should upgrade your host to php5 Stanislav Quote Link to comment Share on other sites More sharing options...
s1lverf0x Posted June 9, 2009 Share Posted June 9, 2009 Which sitemap goes with Ultimate SEO? Hi, I'm on 2.2 with STS4.5.8 & have just installed Ultimate SEO URLs 2.7 - which is looking great - Thank you. I already had Dynamic Sitemap 3.5.10 installed - which I've just run again to try & get my new SEF URLs into my sitemap to send to Google - but it still generates the old style URLs like this: http://mysite.co.uk/product_info.php?products_id=29 and http://www.mysite.co.uk/product_info.php?c...;products_id=71 Also - I've got CMS-Sitemap-osComm installed as I had difficulties in getting any sitemap working originally - is it a bad idea to submit more than 1 sitemap to Google? Currently I have really bad Search Engine ranking which I'm desperately trying to sort out. Many Thanks Jason Quote Link to comment Share on other sites More sharing options...
Pektsekye Posted June 10, 2009 Share Posted June 10, 2009 Which sitemap goes with Ultimate SEO? I think this one Google XML Sitemap SEO support here Stanislav Quote Link to comment Share on other sites More sharing options...
s1lverf0x Posted June 10, 2009 Share Posted June 10, 2009 I think this one Google XML Sitemap SEO support here Stanislav Thanks for that Stanislav - I worked that out late last night & installed it - but it's good to confirm that I installed the right thing. Now I have a few sitemaps installed & don't know whether to leave them as them are or that's a bad idea & just have the 1 sitemap. Google XML Sitemap SEO is working well & now contains all products & categories in the SEF URL format. I also have googleSitemapProducts.php and googleSitemapCategories.php - which I think are from Google XML Sitemap Feed (but not sure - I've been searching the web for the right contribution for days) - so should I leave them in? they have no errors in my Google Webmaster Tools - but they reference everything with the old-style IDs (http://mysite.co.uk/index.php?cPath=22) I also have sitemap.php in my root & referenced in my Webmaster tools - this again is working ok (no errors) but is listing everything using IDs not the SEF URL way, it has: http://mysite.co.uk/product_info.php?cPath...;products_id=29 Don't know whether to clear these other Sitemaps out & just haev the one, will the mix of both types of sitemaps affect my ranking? I seem to have reallyl poor listing on SERPs at the moment. Many Thanks Jason Quote Link to comment Share on other sites More sharing options...
s1lverf0x Posted June 10, 2009 Share Posted June 10, 2009 Thanks for that Stanislav - I worked that out late last night & installed it - but it's good to confirm that I installed the right thing. Now I have a few sitemaps installed & don't know whether to leave them as them are or that's a bad idea & just have the 1 sitemap. Google XML Sitemap SEO is working well & now contains all products & categories in the SEF URL format. I also have googleSitemapProducts.php and googleSitemapCategories.php - which I think are from Google XML Sitemap Feed (but not sure - I've been searching the web for the right contribution for days) - so should I leave them in? they have no errors in my Google Webmaster Tools - but they reference everything with the old-style IDs (http://mysite.co.uk/index.php?cPath=22) I also have sitemap.php in my root & referenced in my Webmaster tools - this again is working ok (no errors) but is listing everything using IDs not the SEF URL way, it has: http://mysite.co.uk/product_info.php?cPath...;products_id=29 Don't know whether to clear these other Sitemaps out & just haev the one, will the mix of both types of sitemaps affect my ranking? I seem to have reallyl poor listing on SERPs at the moment. Many Thanks Jason Just a note to add to this - it's really hard to find my site on google at the moment & what is listed is in the old-style (i.e. pre- Ultimate SEO) ID references instead of the SEO URLs - am I just being impatient (I only installed Ultimate SEO 2 days ago and Google XML Sitemap SEO v1.1 yesterday). Will Google start to index my search engine friendly URLs or is it because I have multiple sitemaps listed in my Google Webmaster Tools (some using IDs & some using SEF URLs) - that Google is only using the IDs - and not picking up the SEO URLs???? I'm going greyer by the day Thanks again J Quote Link to comment Share on other sites More sharing options...
natashome Posted June 10, 2009 Share Posted June 10, 2009 to explain better..when i click on a category i get the show all manufacturers drop-down on the top right side...now if i select any of the available manufacturers it still shows me all of them...is this something wrong on the seo urls thing ? Quote Link to comment Share on other sites More sharing options...
ultras.nick Posted June 14, 2009 Share Posted June 14, 2009 Hello, I have installed this contribution and it looks that for the homepage, I have no Description and no Keywords. Have I did something wrong? or might be a bug? Please note that I have an older version of this contribution. An advice will be highly apreciated :) Regards, Nick Quote Link to comment Share on other sites More sharing options...
ultras.nick Posted June 14, 2009 Share Posted June 14, 2009 Hello, I have installed this contribution and it looks that for the homepage, I have no Description and no Keywords. Have I did something wrong? or might be a bug? Please note that I have an older version of this contribution. An advice will be highly apreciated :) Regards, Nick wrong topic. Sorry. Quote Link to comment Share on other sites More sharing options...
usvi4me Posted June 14, 2009 Share Posted June 14, 2009 Well, I got it sorted - in case anyone else is having this problem.... Open your htaccess file. Find the following lines: RewriteRule ^(.*)-pm-([0-9]+).html$ info_pages.php?pages_id=$2&%{QUERY_STRING} RewriteRule ^(.*)-i-(.*).html$ information.php?info_id=$2&%{QUERY_STRING} and replace them with: RewriteRule ^(.*)-pm-([0-9]+).html$ extra_info_pages.php?pages_id=$2&%{QUERY_STRING} Save and upload to your server and all should be fine. Cheers Kathy Ref: extra pages info box w/admin I've made all the changes as suggested above. I still have the http://mydomainname.com/extra_info_pages.php?pages_id=3 I would like to have this display http://mydomainname.com/membershipinformation.html or something like that. Is this because the server is running php5 ? Or am I missing something somewhere ? Quote Link to comment Share on other sites More sharing options...
kennn Posted June 20, 2009 Share Posted June 20, 2009 First let me say sorry and thank for ultimate seo script. I'm lose english language. I have more question about this script. How I can edit '.htaccess' for format 'index.php' to 'index.html'? I have fix on 'seo.class.php' for change format 'index.php' to 'index.html' already and I try fix '.htaccess' like this. /////////////////////////////////////////////////////////////////// RewriteEngine On RewriteBase /directory/ RewriteRule ^(.*)\.html$ $1.php RewriteCond %{QUERY_STRING} ^options\=(.*)$ RewriteRule ^[^\-]+-p-([^.]+)\.html$ product_info.php?products_id=$1%1 /////////////////////////////////////////////////////////////////// Sorry, I'm new for mod_rewrite. I know this script incorrect. Because if request page like this 'hxxp://www.domain.com/index.html' on display of page is correct and redirect to 'hxxp://www.domain.com/index.php'. But if request page like this 'hxxp://www.domain.com/name-produt-p-99.html' this page can't display. Please, help and reply example fix .htaccess for me. Thank You. Quote Link to comment Share on other sites More sharing options...
zeycoba Posted June 20, 2009 Share Posted June 20, 2009 Ultimate Seo Urls Version 2.7 by faaliyet Once installed, seo url to the page each time someone clicks on infoboxların extent of corruption is in our category and paste the how this problem can be solved infoboxlardaki? thank you Quote Link to comment Share on other sites More sharing options...
Pektsekye Posted June 20, 2009 Share Posted June 20, 2009 (edited) Ultimate Seo Urls Version 2.7 by faaliyet Once installed, seo url to the page each time someone clicks on infoboxların extent of corruption is in our category and paste the how this problem can be solved infoboxlardaki? thank you The seo.class.php in the Ultimate Seo Urls Version 2.7 is not ready to go. You should use the seo.class.php file from one of the latest packages v2.7 with autoinstaller (just get the file from it). OR The seo.class.php file from the version 2.1d Show your site and show the code for "infoboxlardaki" here. Stanislav Edited June 20, 2009 by Pektsekye Quote Link to comment Share on other sites More sharing options...
Guest Posted June 21, 2009 Share Posted June 21, 2009 The seo.class.php in the Ultimate Seo Urls Version 2.7 is not ready to go. You should use the seo.class.php file from one of the latest packages v2.7 with autoinstaller (just get the file from it). OR The seo.class.php file from the version 2.1d Show your site and show the code for "infoboxlardaki" here. Stanislav Hi there, could you help with what site map would be good for this site? http:www.evolutionsystems.co.nz I tried also to use sid killer but didn't work and now need to install an SEO CONTRIB but do not know which one to use, been troling through the foums for 2 days. Any help is HUGELY appreciated. Thanks all Quote Link to comment Share on other sites More sharing options...
Pektsekye Posted June 21, 2009 Share Posted June 21, 2009 Hi there, could you help with what site map would be good for this site?http:www.evolutionsystems.co.nz I tried also to use sid killer but didn't work and now need to install an SEO CONTRIB but do not know which one to use, been troling through the foums for 2 days. Any help is HUGELY appreciated. Thanks all xml site map for google only Google XML Sitemap SEO - - support - site map page for visitors Sitemap SEO - - support - if you have php 5.2.0 ULTIMATE Seo Urls 5 - - support - if you have php 4 Ultimate SEO URLs - - support - download package 2.1d ORIGINAL updated - by FWR Media (7 Nov 2008) and update the seo.class.php file from one of the latest packages v2.7 with autoinstaller Stanislav Quote Link to comment Share on other sites More sharing options...
Clau123 Posted June 22, 2009 Share Posted June 22, 2009 I would love to install this contrib (version 2.1) on my site, but I'm on a Windows Iis 6 server. There is an option to use a httpd.ini file with Isapi rewrite codes. i've been searching on the internet, but haven't found the exact code for the file for version 2.1e (or d) So my question is, Is there someone who can provide the httpd.ini file with the Isapi rewrite code for this contrib, version 2.1d or e? I hope someone can help me out with this. Claudia Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.