X-Cart forums

[info@sjidesign.com]

Anyone know how to make the recommended products list in alphabetical order rather than buy products number using the code below?

<?
/************************************************** ***************************\
+-----------------------------------------------------------------------------+
| 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") {
$str = "";
$query_condition = " AND (";
srand((double)microtime()*1000000);
$rnd = rand(0, count($products_id)-1);
$query_condition .= "productid='".$products_id[$rnd][productid]."'";
for($i = 5; $i < $config["Modules"]["number_of_recommends"] - 1; $i++) {
$rnd = rand(5, count($products_id)-1);
if (!ereg("'".$products_id[$rnd][productid]."'", $query_condition)) {
$query_condition .= " OR productid='".$products_id[$rnd][productid]."'";
}
}
$query_condition .= ")";
$query = "SELECT * FROM $sql_tbl[products] WHERE forsale='Y' AND categoryid =" . $cat . " and avail>0".$query_condition;
}
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);
?>

Also can it be set so that there is always x number of products displayed and not jump around e.g. one time there will be 5 products displayed the next time 4 etc. I always want it a constant number.

Thanks in advance

Dan Winchester

[funkydunk]

try:

<? 
/*****************************************************************************\ 
+-----------------------------------------------------------------------------+ 
| 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

[info@sjidesign.com]

Hi Duncan,

Doesn't seem to put them into alphabetical order, just random product numbers by the look of it.

Looks as though it's made the number of products always 10 though, can this be set to the number of products in each category e.g. for wooden toys 21 products, games 10 etc?

[funkydunk]

The number of products is a global setting.

I can make the mod for you to get this working is you want to email me for a quote.

Cheers