Number of Bestsellers is different on index.php

[Voland]

Hello good osC people,

 

I have a confusion. I have just noticed that when on teh homepage there's only one bestseller in the Bestsellers Box (1 is set in the Minimum Bestsellers to diplay in admin), while all other non-category pages (accont, new products, shoppingcart, etc.) display 6 Bestseller enteries (6 is my max Bestsellers in the admin). Is that the intended way? If not how can I fix it?

 

Kind regards,

 

Arkady

[Voland]

... Follow up.

 

Forgot to provide the URL. My site is www.mindphantom.com/shop

[rabbitseffort]

since it is a template from template monster maybe see if they will tell you--seems it isnt correct though--must be some code in index.php making it do that

[Voland]

since it is a template from template monster maybe see if they will tell you--seems it isnt correct though--must be some code in index.php making it do that

Hi Rabbit,

 

Well I ve conciddered that. I am not expereinced with PHP. But as careful as I could I looked through my index.php and didnt find anything out of the ordinary. There arent any references to bestsellers either. Only the usual

require(DIR_WS_INCLUDES . 'column_right.php');

to insert the right column. The column_right.php itself has

if (isset($HTTP_GET_VARS['products_id'])) {
if (basename($PHP_SELF) != FILENAME_TELL_A_FRIEND) include(DIR_WS_BOXES . 'tell_a_friend.php');
 echo '<tr><td height=2></td></tr>';
 } else {
include(DIR_WS_BOXES . 'best_sellers.php');
 echo '<tr><td height=2></td></tr>';
 }

. Which also seems fine to me. and the best_sellers.php itself seems to be the original one

<?php
/*
 $Id: best_sellers.php,v 1.21 2003/06/09 22:07:52 hpdl Exp $

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

 Copyright (c) 2003 osCommerce

 Released under the GNU General Public License
*/

 if (isset($current_category_id) && ($current_category_id > 0)) {
$best_sellers_query = tep_db_query("select distinct p.products_id, pd.products_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and '" . (int)$current_category_id . "' in (c.categories_id, c.parent_id) order by p.products_ordered desc, pd.products_name limit " . MAX_DISPLAY_BESTSELLERS);
 } else {
$best_sellers_query = tep_db_query("select distinct p.products_id, pd.products_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' order by p.products_ordered desc, pd.products_name limit " . MAX_DISPLAY_BESTSELLERS);
 }

 if (tep_db_num_rows($best_sellers_query) >= MIN_DISPLAY_BESTSELLERS) {
?>
<!-- best_sellers //-->
	  <tr>
		<td>
<?php
$info_box_contents = array();
$info_box_contents[] = array('text' => BOX_HEADING_BESTSELLERS);

new infoBoxHeading($info_box_contents, true, true);

$rows = 0;
$bestsellers_list = '<table border="0" width="100%" cellspacing="0" cellpadding="1">';
while ($best_sellers = tep_db_fetch_array($best_sellers_query)) {
  $rows++;
  $bestsellers_list .= '<tr><td class="infoBoxContents" valign="top">' . tep_row_number_format($rows) . '.</td><td class="infoBoxContents"><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $best_sellers['products_id']) . '">' . $best_sellers['products_name'] . '</a></td></tr>';
}
$bestsellers_list .= '</table>';

$info_box_contents = array();
$info_box_contents[] = array('text' => $bestsellers_list);

new infoBox($info_box_contents);
?>
		</td>
	  </tr>
<!-- best_sellers_eof //-->
<?php
 }
?>

accept maybe the

new infoBoxHeading($info_box_contents, true, true);

 

So I am very confused :).

 

Oh and the template was a free sample one. I doubt, they will provide support for it :)

 

Arkady