X-Cart forums

[jgkiefer]

Originally Posted by funkydunk

Shan,

Yep - Am building a site at the moment with this in a lhs menu.

Limited it to show 3 products though cos of space.

How is this coming along?

[funkydunk]

This has been done.

lhs menu shows a selection of three products that have a discount applied then a link to a special offers page that lists all products with the normal navigation through the pages.

[jgkiefer]

How much is 120L in dollars?

[funkydunk]

120 what?

[jgkiefer]

Your site says that that mod costs 120L.

[funkydunk]

sorry - you lost me then... the L is actually a бё GBP

if you pm me I can confirm details of costings etc.

[enge919]

Does anyone know if this works in 3.5.x?

I need this for a client with 3.5.4 but we want to modify it to just randomly pull 6 items from the database to display without being dependent on the item being marked down. In other word he does not show marked down items but want the home page to always be fresh.

UPDATED: See my fix below to use this with or without discounted products in 3.5.x!

[jeeya]

I am getting this error after I add - specials.php in home.php



INVALID SQL: 1054 : Unknown column 'discount' in 'where clause'
SQL QUERY FAILURE: SELECT * FROM xcart_products,xcart_pricing WHERE forsale='Y' AND avail>0 AND xcart_products.productid=xcart_pricing.productid AND discount > 0 ORDER BY RAND() LIMIT 6


Version 3.4.0

[enge919]

just change the following code in specials.php

<? 

// the database query 
$query = "SELECT * FROM $sql_tbl[products],$sql_tbl[pricing] WHERE forsale='Y' AND avail>0 AND $sql_tbl[products].productid=$sql_tbl[pricing].productid AND discount > 0 ORDER BY RAND() LIMIT 6 "; 

// give the product array to smarty to make it available sitewide. 
$specials = func_query($query); 
$smarty->assign("specials",$specials); 
?> 

to

<? 

// the database query 
$query = "SELECT * FROM $sql_tbl[products],$sql_tbl[pricing] WHERE forsale='Y' AND avail>0 AND $sql_tbl[products].productid=$sql_tbl[pricing].productid ORDER BY RAND() LIMIT 6 "; 

// give the product array to smarty to make it available sitewide. 
$specials = func_query($query); 
$smarty->assign("specials",$specials); 
?> 

This will just randomly pull products from the database regardless of any discounts.

And if you only want to show products you have discounted from the list price use this:

<? 

// the database query 
$query = "SELECT * FROM $sql_tbl[products],$sql_tbl[pricing] WHERE forsale='Y' AND avail>0 AND $sql_tbl[products].productid=$sql_tbl[pricing].productid AND price < list_price ORDER BY RAND() LIMIT 4 "; 

// give the product array to smarty to make it available sitewide. 
$specials = func_query($query); 
$smarty->assign("specials",$specials); 
?> 

Change LIMIT 6 to any number of products you want to show in the specials.tpl

Also be sure to name the specials template specials.tpl. I noticed in the original code it was named special.tpl.

I have tested this in 3.5.4 and works like a charm

hth

[jeeya]

Great Thanks Works Perfect.

Also Is there anyway to modify this to be shown on help section page - like about us page.