Anyone?
EDIT: catalog/model/catalog/product.php
FIND this function:
INSIDE THAT Function, FIND:
REPLACE WITH:
FIND this function:
Code: Select all
public function getLatestProducts($limit) {Code: Select all
ORDER BY p.date_addedCode: Select all
ORDER BY rand()
Thank you Qphoria for your very informative, exact informational post.
Your time and efforts are GREATLY appreciated.
Thank you again!!!
Your time and efforts are GREATLY appreciated.
Thank you again!!!
perl, php, java, java script, My SQL, html, ASP, Action Script, Web 2.0....
I am wondering if I have forgotten more than I have remembered? Or, did they change it?
http://www.alaskalive.net
thanks
derp i'm stupid.
didn't see this line right below the query that you can simply comment out
didn't see this line right below the query that you can simply comment out
Code: Select all
$this->cache->set('product.latest.' . $this->language->getId() . '.' . $limit, $product);Hi, I opened system/cache and I can only see an index.html file, do I delete this whole file? or shall I delete the whole folder etc?Qphoria wrote:delete the cache files in the system/cache folder, then try
Sorry im new
How do I change this? I went to ftp.oursite.com and it wont let me change it?
-Jason
-Jason
not work for me using OC 1.5.1.3 any idea?Qphoria wrote:EDIT: catalog/model/catalog/product.php
FIND this function:INSIDE THAT Function, FIND:Code: Select all
public function getLatestProducts($limit) {REPLACE WITH:Code: Select all
ORDER BY p.date_addedCode: Select all
ORDER BY rand()
Baju Muslim Baju Pria Baju Anak Baju Korea Sparepart Printer Baju Muslim JNE Surabaya
Seems that
public function getLatestProducts($limit)
is not used any more.
I found catalog/controller/module/latest.php
when you open it, around row 22 you should find:
$data = array(
'sort' => 'p.date_added',
'order' => 'DESC',
'start' => 0,
'limit' => $setting['limit']
);
and you should change it to
$data = array(
'sort' => 'RAND()',
'order' => '',
'start' => 0,
'limit' => $setting['limit']
);
that work perfect for me.
public function getLatestProducts($limit)
is not used any more.
I found catalog/controller/module/latest.php
when you open it, around row 22 you should find:
$data = array(
'sort' => 'p.date_added',
'order' => 'DESC',
'start' => 0,
'limit' => $setting['limit']
);
and you should change it to
$data = array(
'sort' => 'RAND()',
'order' => '',
'start' => 0,
'limit' => $setting['limit']
);
that work perfect for me.
Also, to avoid cashing of random products list, I made another change in catalog/model/catalog/product.php
around line 35 in function
public function getProducts($data = array())
there is a line
$product_data = $this->cache->get('product.' . (int)$this->config->get('config_language_id') . '.' . (int)$this->config->get('config_store_id') . '.' . (int)$customer_group_id . '.' . $cache);
I changed it with
if ($data['sort'] == 'RAND()') {
$product_data = array();
} else {
$product_data = $this->cache->get('product.' . (int)$this->config->get('config_language_id') . '.' . (int)$this->config->get('config_store_id') . '.' . (int)$customer_group_id . '.' . $cache);
}
so, if order is random it will create empty array instead of reading product data from cache.
around line 35 in function
public function getProducts($data = array())
there is a line
$product_data = $this->cache->get('product.' . (int)$this->config->get('config_language_id') . '.' . (int)$this->config->get('config_store_id') . '.' . (int)$customer_group_id . '.' . $cache);
I changed it with
if ($data['sort'] == 'RAND()') {
$product_data = array();
} else {
$product_data = $this->cache->get('product.' . (int)$this->config->get('config_language_id') . '.' . (int)$this->config->get('config_store_id') . '.' . (int)$customer_group_id . '.' . $cache);
}
so, if order is random it will create empty array instead of reading product data from cache.
Who is online
Users browsing this forum: No registered users and 28 guests
