X-Cart forums - Top Ten List - a favorites or "fake" bestsellers list

X-Cart forums (https://forum.x-cart.com/index.php)

- Dev Questions (https://forum.x-cart.com/forumdisplay.php?f=20)

- - Top Ten List - a favorites or "fake" bestsellers list - everywhere! (https://forum.x-cart.com/showthread.php?t=24671)

Top Ten List - a favorites or "fake" bestsellers list - everywhere!

Here is a mod that was developed with the help of many forum members. The goal was a side menu box that contained the products of a single category, ranked in the orderby POS established for the category. This menu box appears throughout the store. It is NOT tied to featured poducts or bestsellers (these modules can be disabled if you like).

I can certify this works with 4.1.3 and 4.0.18; there is no reason it won't work with other versions...

1. Define a category, assign products to it. I called mine, "Top Ten List". I added 10 products (duh!).

2. make a file in the xcart_root directory, name it "toptenlist.php"

Code:

<?

$query = "SELECT $sql_tbl[products].productid, $sql_tbl[products].product FROM $sql_tbl[products],$sql_tbl[products_categories] WHERE $sql_tbl[products].forsale='Y' AND $sql_tbl[products].avail > 0 AND $sql_tbl[products].productid = $sql_tbl[products_categories].productid AND $sql_tbl[products_categories].categoryid = 10 ORDER BY $sql_tbl[products_categories].orderby ASC LIMIT 10" ;



$toptenlist = func_query($query);



$smarty->assign("toptenlist",$toptenlist);

?>

// Note: categoryid = 10 is the id for the category you want to query

// change this to the categoryid you are using

3. Open xcart_root/home.php

FIND:

Code:

if ($active_modules["Bestsellers"])

include $xcart_dir."/modules/Bestsellers/bestsellers.php";

ADD:

Code:

include "./toptenlist.php";

4. Create a file called skin1/customer/main/toptenlist.tpl with the following:

Code:

{* $Id: toptenlist.tpl,v 1.00.0.1 2006/09/06 18:08:01 *}



<div id="categories">

{capture name=menu}

{section name=num loop=$toptenlist}

<A href="product.php?productid={$toptenlist[num].productid}&cat=10" class=VertMenuItems><B>{math equation="value+1" value=$smarty.section.num.index}.</B> {$toptenlist[num].product}</A><br />

{/section}

{/capture}

{ include file="menu.tpl" dingbats="dingbats_categorie.gif" menu_title="Top Ten List" menu_content=$smarty.capture.menu }

</div>



{* Again note the cat=10 in this file *}

{* Change menu_title="Top Ten List" to the desired menu title *}

5. in xcart_root/include/categories.php

Find:

Code:

$smarty->assign("cat", $cat);

Add the following underneath:

Code:

require $xcart_dir."/toptenlist.php";

6. in skin1/customer/home.tpl add this wherever you want the menu to display. For example, if you want it on the right menu, under the authentication box, you would put it here:

After these lines

Code:

{if $login eq "" }

{include file="auth.tpl" }

{else}

{include file="authbox.tpl" }

{/if}

...insert

Code:

{if $toptenlist}

<br />

{include file="customer/main/toptenlist.tpl" }

{/if}

DONE!

Thanks to the many forum members who contributed to this.

Jeremy