Latest products

As you may have noticed, the latest products always stays on the the first 6 you entered.

By changing the line in >catalog>plugin>home.php at lline 20

from

$results = $database->rows("select * from product p left join product_description pd on (p.product_id = pd.product_id) left join image i on (p.image_id = i.image_id) where p.status = '1' and pd.language_id = '" . (int)$language->id . "' and p.date_available rows("select * from product p left join product_description pd on (p.product_id = pd.product_id) left join image i on (p.image_id = i.image_id) where p.status = '1' and pd.language_id = '" . (int)$language->id . "' and p.date_available < now() and p.status = '1' order by p.date_added desc limit 6");

this changes the view to the last 6 you entered into your shop.

This still works for v0.7.6.1 however the file structure seems to have changed the file is in catalog\controller\home.php and the line number is 34


$results = $database->getRows("select * from product p left join product_description pd on (p.product_id = pd.product_id) left join image i on (p.image_id = i.image_id) where p.status = '1' and pd.language_id = '" . (int)$language->getId() . "' and p.date_available getRows("select * from product p left join product_description pd on (p.product_id = pd.product_id) left join image i on (p.image_id = i.image_id) where p.status = '1' and pd.language_id = '" . (int)$language->getId() . "' and p.date_available < now() and p.status = '1' order by p.date_added desc limit 6");

Note: Only "desc" is added to the query and if you wanted more than 6 product than change 6 to the number of products displayed.

is this not a bug that should be addressed in the core code rather than a mod we keep synching?

what you have to remember too is that if all your products are just entered  it will have all of them to use..  under a shop that has been running for a length of time ... it will work better.

I understand the concern -- and think a better run at it would be to address it with a random approach to the available products that are new...    also hard coding that limits??  why that can be set in the admin... can it not?  if so it should be..  (not yet looked to confirm that)

-=Luvz2drv=-

Just noticed the bug.

it should be:

$results = $database->getRows("select * from product p left join product_description pd on (p.product_id = pd.product_id) left join image i on (p.image_id = i.image_id) where p.status = '1' and pd.language_id = '" . (int)$language->getId() . "' and p.date_available < now() and p.status = '1' order by p.date_added desc limit 6");

"This topic has not been posted in for at least 120 days."

This doesn't appear to be in the core code yet...

OPEN \catalog\controller\home.php
FIND
$results = $database->getRows("select * from product p left join product_description pd on (p.product_id = pd.product_id) left join image i on (p.image_id = i.image_id) where p.status = '1' and pd.language_id = '" . (int)$language->getId() . "' and p.date_available getRows("select * from product p left join product_description pd on (p.product_id = pd.product_id) left join image i on (p.image_id = i.image_id) where p.status = '1' and pd.language_id = '" . (int)$language->getId() . "' and p.date_available < now() and p.status = '1' order by p.date_added desc limit 6");


You'll notice the difference is the "desc" which reverses the list.

thanks a lot it work fine

i change my code to:

.. and p.date_available <= now()

i put = after <