Would I be right in assuming that this (config_max_rows) controls the maximum number of products displayed on all pages, such as home (latest products), search, categories etc.?
As such if I need to change this number on any one page I would need to do the following (I'll use home to display 6 of the latest products):
In catalog/controller/home.php change:
Code: Select all
$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 ".$config->get('config_[color=blue]max[/color]_rows'));
Code: Select all
$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 ".$config->get('config_[color=red]home[/color]_rows'));
Code: Select all
INSERT INTO `setting` (`setting_id`, `type`, `group`, `key`, `value`) VALUES (NULL, 'catalog', 'config', 'config_[color=red]home[/color]_rows', '[color=red]6[/color]');