В боксе Рекомендуемые несколько товаров - нужно указать три

[DmitriyG 0]

Подскажите плз, где то наше в статьях такое решение, что бы в боксе Рекомендуемы выводить несколько товаров:

<?php

/* -----------------------------------------------------------------------------------------

   $Id: featured.php 1292 2007-02-07 12:30:44 VaM $

   VaM Shop - open source ecommerce solution

   http://vamshop.ru

   http://vamshop.com

   Copyright (c) 2007 VaM Shop

   -----------------------------------------------------------------------------------------

   based on:

   (c) 2000-2001 The Exchange Project  (earlier name of osCommerce)

   (c) 2002-2003 osCommerce(specials.php,v 1.30 2003/02/10); www.oscommerce.com

   (c) 2003  nextcommerce (specials.php,v 1.10 2003/08/17); www.nextcommerce.org

   (c) 2004  xt:Commerce (featured.php,v 1.10 2003/08/13); xt-commerce.com

   Released under the GNU General Public License

   ---------------------------------------------------------------------------------------*/

$box = new vamTemplate;

$box->assign('tpl_path', 'templates/'.CURRENT_TEMPLATE.'/');

$box_content = '';

// include needed functions

require_once (DIR_FS_INC.'vam_random_select.inc.php');

//fsk18 lock

$fsk_lock = '';

if ($_SESSION['customers_status']['customers_fsk18_display'] == '0') {

$fsk_lock = ' and p.products_fsk18!=1';

}

if (GROUP_CHECK == 'true') {

$group_check = " and p.group_permission_".$_SESSION['customers_status']['customers_status_id']."=1 ";

}

$random_product = "select

                                       	p.products_id,

                                       	pd.products_name,

                                       	p.products_price,

                                       	p.products_tax_class_id,

                                       	p.products_image,

                                       	f.expires_date,

                                       	p.products_vpe,

                           	p.products_vpe_status,

                           	p.products_vpe_value

                                       	from ".TABLE_PRODUCTS." p,

                                       	".TABLE_PRODUCTS_DESCRIPTION." pd,

                                       	".TABLE_FEATURED." f where p.products_status = '1'

                                       	and p.products_id = f.products_id

                                       	and pd.products_id = f.products_id

                                       	and pd.language_id = '".$_SESSION['languages_id']."'

                                       	and f.status = '1'

                                       	".$group_check."

                                       	".$fsk_lock."

                                       	order by f.featured_date_added

                                       	desc limit ".MAX_RANDOM_SELECT_FEATURED;

  $module_content = '';

  $products_new = vam_db_query($random_product);

  while ($products_data = vam_db_fetch_array($products_new)) {

   $module_content[] = $product->buildDataArray($products_data);

  }

$box->assign('box_content', $module_content);

$box->assign('FEATURED_LINK', vam_href_link(FILENAME_FEATURED));

$box->assign('language', $_SESSION['language']);

if ($random_product["products_id"] != '') {

// set cache ID

  if (!CacheCheck()) {

  $box->caching = 0;

  $box_featured = $box->fetch(CURRENT_TEMPLATE.'/boxes/box_featured.html');

} else {

  $box->caching = 1;

  $box->cache_lifetime = CACHE_LIFETIME;

  $box->cache_modified_check = CACHE_CHECK;

  $cache_id = $_SESSION['language'].$random_product["products_id"].$_SESSION['customers_status']['customers_status_name'];

  $box_featured = $box->fetch(CURRENT_TEMPLATE.'/boxes/box_featured.html', $cache_id);

}

$vamTemplate->assign('box_FEATURED', $box_featured);

}

?>

[/CODE]

 

Вопрос: подскажите  листинг где и что менять, что бы выводить например только три товара

[support 447]

Вот в faq ответ - http://vamshop.ru/forum/topic/8106-%d0%ba%d0%b0%d0%ba-%d1%81%d0%b1%d0%be%d0%ba%d1%83-%d0%b2-%d0%b1%d0%be%d0%ba%d1%81%d0%b5-%d1%80%d0%b5%d0%ba%d0%be%d0%bc%d0%b5%d0%bd%d0%b4%d1%83%d0%b5%d0%bc%d1%8b%d0%b5-%d0%b2%d1%8b%d0%b2%d0%be%d0%b4%d0%b8%d1%82%d1%8c-%d1%81%d1%80%d0%b0%d0%b7%d1%83/page__hl__box_featured__fromsearch__1