Clearence Items Mod

Online Michael · #11 07-23-2005, 07:03 AM

Easy...

Replace this line of code in the clearance.tpl file:

Code:

{include file="dialog.tpl" title= "Clearance Items" content=$smarty.capture.clearance_list extra="width=100%"}

with this:

Code:

{ include file="menu.tpl" menu_title="Clearance Items" menu_content=$smarty.capture.clearance_list }

And don't forget to place this code:

Code:

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

in the home.tpl file so it appears where you want in the menu section.

Hope this helps!

eaglemobiles · #12 07-23-2005, 06:35 PM

Thank you very very much Online Michael

WPOO · #13 09-06-2005, 08:07 AM

Code:


INVALID SQL: 1052 : Column: 'avail' in where clause is ambiguous
SQL QUERY FAILURE: SELECT * FROM xcart_products,xcart_categories,xcart_pricing WHERE forsale='Y' AND avail>0 AND categoryid=82 AND xcart_categories.productid=xcart_products.productid AND xcart_products.productid=xcart_pricing.productid ORDER BY RAND() LIMIT 5

is this because im using a other language

yages · #14 10-13-2005, 07:28 PM

Interested in seeing this mod on a live site.
Can anyone help

yages · #15 10-14-2005, 10:56 PM

Mod work great.
How do you change the template to show the products accross the page
with title above the products and no description and price under the product

komarik · #16 10-18-2005, 12:51 PM

How would i make this to display in 2 or 3 columns instead of 1.
Thanks

yages · #17 10-21-2005, 10:05 PM

List price shows OK but the discounted price does not include tax
Can anyone help fix this problem

Also still waiting on a reply for showing products accross page in columns

pwd88 · #18 11-14-2005, 05:21 PM

I could not get any price by using the above db select statement in 4.0.16, can anyone help?

LikeMike · #19 12-09-2005, 07:26 AM

Hey, just wanted to say that the mod works great, but I am having one problem. I know that the items are supposed to cycle through randomly, but I constantly have duplicate items. I have 23 products in the category that I am using for the clearance items. Shouldn't that be enough to not create duplicates? Here's my site for those who would like to see what I am talking about:

http://www.sarisariboutique.com

Other than that this is a great mod! Thanks in advance for any suggestions.

scottd · #20 03-07-2006, 07:27 AM

I am trying to implement this mod and getting this error:

Fatal error: Call to undefined function: func_query() in /home/path/to/file/clearance.php on line 7