X-Cart forums - View Single Post - Stopping free product showing up in Recommends list

shan · #2 08-02-2004, 05:31 AM

you could have a look at customer/recommends.php and edit as follows

find

Code:

    $query_condition .= ")";
    $query = "SELECT * FROM $sql_tbl[products] WHERE forsale='Y' AND avail>0".$query_condition;
}
else

adjust to

Code:

    $query_condition .= ")";
    $query = "SELECT * FROM $sql_tbl[products] WHERE forsale='Y' AND price>0 AND avail>0".$query_condition;
}
else