try:
Code:
<?
/*****************************************************************************\
+-----------------------------------------------------------------------------+
| X-Cart |
| Copyright (c) 2001-2003 Ruslan R. Fazliev <rrf@rrf.ru> |
| All rights reserved. |
+-----------------------------------------------------------------------------+
| PLEASE READ THE FULL TEXT OF SOFTWARE LICENSE AGREEMENT IN THE "COPYRIGHT" |
| FILE PROVIDED WITH THIS DISTRIBUTION. THE AGREEMENT TEXT IS ALSO AVAILABLE |
| AT THE FOLLOWING URL: http://www.x-cart.com/license.php |
| |
| THIS AGREEMENT EXPRESSES THE TERMS AND CONDITIONS ON WHICH YOU MAY USE |
| THIS SOFTWARE PROGRAM AND ASSOCIATED DOCUMENTATION THAT RUSLAN R. |
| FAZLIEV (hereinafter referred to as "THE AUTHOR") IS FURNISHING OR MAKING |
| AVAILABLE TO YOU WITH THIS AGREEMENT (COLLECTIVELY, THE "SOFTWARE"). |
| PLEASE REVIEW THE TERMS AND CONDITIONS OF THIS LICENSE AGREEMENT |
| CAREFULLY BEFORE INSTALLING OR USING THE SOFTWARE. BY INSTALLING, |
| COPYING OR OTHERWISE USING THE SOFTWARE, YOU AND YOUR COMPANY |
| (COLLECTIVELY, "YOU") ARE ACCEPTING AND AGREEING TO THE TERMS OF THIS |
| LICENSE AGREEMENT. IF YOU ARE NOT WILLING TO BE BOUND BY THIS |
| AGREEMENT, DO NOT INSTALL OR USE THE SOFTWARE. VARIOUS COPYRIGHTS AND |
| OTHER INTELLECTUAL PROPERTY RIGHTS PROTECT THE SOFTWARE. THIS |
| AGREEMENT IS A LICENSE AGREEMENT THAT GIVES YOU LIMITED RIGHTS TO USE |
| THE SOFTWARE AND NOT AN AGREEMENT FOR SALE OR FOR TRANSFER OF TITLE.|
| THE AUTHOR RETAINS ALL RIGHTS NOT EXPRESSLY GRANTED BY THIS AGREEMENT. |
| |
| The Initial Developer of the Original Code is Ruslan R. Fazliev |
| Portions created by Ruslan R. Fazliev are Copyright (C) 2001-2003 |
| Ruslan R. Fazliev. All Rights Reserved. |
+-----------------------------------------------------------------------------+
\*****************************************************************************/
#
# $Id: recommends.php,v 1.7.2.1 2003/06/02 11:57:43 svowl Exp $
#
# Recommends list
#
#
# Get products data for current category and store it into $products array
#
$products_id = func_query("SELECT productid, categoryid FROM $sql_tbl[products] WHERE forsale='Y' AND categoryid =" . $cat . " and avail>0");
if ($config["Modules"]["select_recommends_list_randomly"] == "Y") {
$query = "SELECT * FROM $sql_tbl[products] WHERE forsale='Y' AND categoryid =$cat and avail>0 order by RAND(), product limit ".$config["Modules"]["number_of_recommends"];
}
else
$query = "select distinct sp2.productid, p.* from $sql_tbl[stats_customers_products] as sp1, $sql_tbl[stats_customers_products] as sp2, $sql_tbl[products] as p where sp1.productid='$productid' and sp1.login=sp2.login and sp2.productid!='$productid' and p.productid=sp2.productid and p.forsale='Y' and p.avail>0 ORDER BY p.product LIMIT ".$config["Modules"]["number_of_recommends"];
$recommends = func_query($query);
$smarty->assign("recommends",$recommends);
?>
haven't tested it, but it will be close
