how to make "specials" module and "bestsellers" module always display at the left or right side?
when I go to product page,they auto disappear,
how to make "specials" module and "bestsellers" module always display at the left or right side?
when I go to product page,they auto disappear,
focus on the open source for online shoping website.
my site: best shop 24h.com
Specials is designed to turn off when there is a products_id in the URL ...
You can change this with your templates and overrides by copying the:
/includes/modules/sideboxes/specials.php
to your templates and overrides directory:
/includes/modules/sideboxes/your_templates_dir/specials.php
and adding the code in RED:
For the Best Sellers sidebox you can customize it similarly with the code in RED:Code:if (isset($_GET['products_id'])) { $show_specials= false; } else { $show_specials= true; } // bof: force specials to always show $show_specials= true; // eof: force specials to always show if ($show_specials == true) {
Code:} else { $show_best_sellers= true; } // bof: force best_sellers to always show $show_best_sellers= true; // eof: force best_sellers to always show if ($show_best_sellers == true) {
Linda McGrath
If you have to think ... you haven't been zenned ...
Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!
Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
Officially PayPal-Certified! Just click here
Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!
thanks so much for " Ajeh",it works!
focus on the open source for online shoping website.
my site: best shop 24h.com
You are most welcome ... thanks for the update that this worked for you ...
Linda McGrath
If you have to think ... you haven't been zenned ...
Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!
Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
Officially PayPal-Certified! Just click here
Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!
This is awesome and is pretty close to what it was I wanted to do. The best sellers sidebox displays on most pages, and it looks like it displays best seller in the product category I am viewing.. (which is very cool) However, if there are no bestsellers in a particular product category, the best sellers sidebox won't display.. In the case where the category being viewed has no best sellers, how would I modify this so that it displays ALL the store best sellers??
My Site - Zen Cart & WordPress integration specialist
I don't answer support questions via PM. Post add-on support questions in the support thread. The question & the answer will benefit others with similar issues.
The top of the IF is being used when there is a category set based on the value of:
$current_category_id
If that isn't set, then the bottom half of the IF is used ...
What you want to do is after the $sql is run the add this IF below it to test if anything was found, and if not, run a copy of the same select that would be run had there been no $current_category_id defined with:
You should be able to add that just above the:Code:if ($best_sellers->RecordCount () == 0) { $best_sellers_query = "select distinct p.products_id, pd.products_name, p.products_ordered from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '" . (int)$_SESSION['languages_id'] . "' order by p.products_ordered desc, pd.products_name limit " . MAX_DISPLAY_BESTSELLERS; }
see if that gets what you are looking for ...Code:} else {
Linda McGrath
If you have to think ... you haven't been zenned ...
Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!
Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
Officially PayPal-Certified! Just click here
Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!
So this fixed the page I was looking at (product info page), but didn't work here:
http://eitestsite(dot)eyeitalia(dot)...=index&cPath=5
but the three subcategories of this are working as expected:
http://eitestsite(dot)eyeitalia(dot)...dex&cPath=5_10
http://eitestsite(dot)eyeitalia(dot)...dex&cPath=5_12
http://eitestsite(dot)eyeitalia(dot)...dex&cPath=5_13
and just to be clear here's the changes to my best sellers code:
Code:// test if box should display $show_best_sellers= false; if (isset($_GET['products_id'])) { if (isset($_SESSION['customer_id'])) { $check_query = "select count(*) as count from " . TABLE_CUSTOMERS_INFO . " where customers_info_id = '" . (int)$_SESSION['customer_id'] . "' and global_product_notifications = '1'"; $check = $db->Execute($check_query); if ($check->fields['count'] > 0) { $show_best_sellers= true; } } } else { $show_best_sellers= true; } // bof: force best_sellers to always show $show_best_sellers= true; // eof: force best_sellers to always show if ($show_best_sellers == true) { $limit = (trim(MAX_DISPLAY_BESTSELLERS) == "") ? "" : " LIMIT " . (int)MAX_DISPLAY_BESTSELLERS; if (isset($current_category_id) && ($current_category_id > 0)) { $best_sellers_query = "select distinct p.products_id, pd.products_name, p.products_ordered from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '" . (int)$_SESSION['languages_id'] . "' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and '" . (int)$current_category_id . "' in (c.categories_id, c.parent_id) order by p.products_ordered desc, pd.products_name"; $best_sellers_query .= $limit; $best_sellers = $db->Execute($best_sellers_query); if ($best_sellers->RecordCount () == 0) { $best_sellers_query = "select distinct p.products_id, pd.products_name, p.products_ordered from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '" . (int)$_SESSION['languages_id'] . "' order by p.products_ordered desc, pd.products_name limit " . MAX_DISPLAY_BESTSELLERS; } } else { $best_sellers_query = "select distinct p.products_id, pd.products_name, p.products_ordered from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '" . (int)$_SESSION['languages_id'] . "' order by p.products_ordered desc, pd.products_name";
Last edited by DivaVocals; 1 Oct 2013 at 07:49 AM.
My Site - Zen Cart & WordPress integration specialist
I don't answer support questions via PM. Post add-on support questions in the support thread. The question & the answer will benefit others with similar issues.
Sorry ... I forgot a set ...
Immediately, after your new select statement for the $sql in RED it would be a good idea to run that $sql ... so add the line:
Code:$best_sellers = $db->Execute($best_sellers_query);
Linda McGrath
If you have to think ... you haven't been zenned ...
Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!
Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
Officially PayPal-Certified! Just click here
Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!
My Site - Zen Cart & WordPress integration specialist
I don't answer support questions via PM. Post add-on support questions in the support thread. The question & the answer will benefit others with similar issues.
You are most welcome ... took me a minute to figure out why the simple select didn't work ... silly me ...
Linda McGrath
If you have to think ... you haven't been zenned ...
Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!
Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
Officially PayPal-Certified! Just click here
Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!
Bookmarks