Home Page Products Carousel [Support Thread]

[TheGrimReaper]

Perfect, very nice plugin.
Thank you again!

[TheGrimReaper]

https://www.thercrv.com NOW LIVE

I now have it setup for as custom with images, but wonder how the order for those scrolling images is determined? I've tried to reorganize the display by spacing the product ID apart from each other to prevent aesthetically similar images from showing up next to each other, but that doesn't seem to work. Is it keyed off of categories? And is there a known way to control the order of display?

[balihr]

The plugin is set to order these products by original products' sort order which you set in admin (although kinda useless if you have products from various categories) and then by products' names in alphabetical order.

If you want to change that and have the products show in the exact order as you entered the IDs in your admin, you'll need to make a change to one file - includes/templates/YOUR_TEMPLATE/templates/tpl_index_slider.php.
Find

case 'custom':
            $products_query = "SELECT DISTINCT p.products_id, pd.products_name, p.products_image, p.master_categories_id FROM "  . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd WHERE p.products_id IN (".ZX_CAROUSEL_MOD_CUSTOM.") AND p.products_status = '1' AND p.products_id = pd.products_id AND pd.language_id = " . (int)$_SESSION['languages_id'] ." ORDER BY p.products_sort_order, pd.products_name";
            if ($products_query != '') $products = $db->Execute($products_query, ZX_CAROUSEL_LIMIT);
            break;

and replace with

case 'custom':
            $products_query = "SELECT DISTINCT p.products_id, pd.products_name, p.products_image, p.master_categories_id FROM "  . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd WHERE p.products_id IN (".ZX_CAROUSEL_MOD_CUSTOM.") AND p.products_status = '1' AND p.products_id = pd.products_id AND pd.language_id = " . (int)$_SESSION['languages_id'];
            if ($products_query != '') $products = $db->Execute($products_query, ZX_CAROUSEL_LIMIT);
            break;

[TheGrimReaper]

The plugin is set to order these products by original products' sort order which you set in admin (although kinda useless if you have products from various categories) and then by products' names in alphabetical order.

If you want to change that and have the products show in the exact order as you entered the IDs in your admin, you'll need to make a change to one file - includes/templates/YOUR_TEMPLATE/templates/tpl_index_slider.php.
Find

case 'custom':
            $products_query = "SELECT DISTINCT p.products_id, pd.products_name, p.products_image, p.master_categories_id FROM "  . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd WHERE p.products_id IN (".ZX_CAROUSEL_MOD_CUSTOM.") AND p.products_status = '1' AND p.products_id = pd.products_id AND pd.language_id = " . (int)$_SESSION['languages_id'] ." ORDER BY p.products_sort_order, pd.products_name";
            if ($products_query != '') $products = $db->Execute($products_query, ZX_CAROUSEL_LIMIT);
            break;

and replace with

case 'custom':
            $products_query = "SELECT DISTINCT p.products_id, pd.products_name, p.products_image, p.master_categories_id FROM "  . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd WHERE p.products_id IN (".ZX_CAROUSEL_MOD_CUSTOM.") AND p.products_status = '1' AND p.products_id = pd.products_id AND pd.language_id = " . (int)$_SESSION['languages_id'];
            if ($products_query != '') $products = $db->Execute($products_query, ZX_CAROUSEL_LIMIT);
            break;

Well, that didn't work. The only image it put in the order I entered is the first image, the rest just went back to the same order. Kinda perplexing.

[TheGrimReaper]

Actually in a second look, it didn't even put the first image in order as entered. It displays all the images I entered, just not in the order I entered.

I have the max increased from 10 to 20, running 15

[TheGrimReaper]

Looks like what it did is sorted them numerically from low to high, disregarding the custom order.

What I'm trying to do is get them to display by product ID in an order I specify. I.E. 27,3,12,11,45,9........etc
What I get is 3,9,11,12,27,45....etc

[balihr]

Yeah, sorry about that. Please disregards post #13 and use this:
Find

case 'custom':
            $products_query = "SELECT DISTINCT p.products_id, pd.products_name, p.products_image, p.master_categories_id FROM "  . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd WHERE p.products_id IN (".ZX_CAROUSEL_MOD_CUSTOM.") AND p.products_status = '1' AND p.products_id = pd.products_id AND pd.language_id = " . (int)$_SESSION['languages_id'] ." ORDER BY p.products_sort_order, pd.products_name";
            if ($products_query != '') $products = $db->Execute($products_query, ZX_CAROUSEL_LIMIT);
            break;

Replace with

case 'custom':
            $products_query = "SELECT DISTINCT p.products_id, pd.products_name, p.products_image, p.master_categories_id FROM "  . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd WHERE p.products_id IN (".ZX_CAROUSEL_MOD_CUSTOM.") AND p.products_status = '1' AND p.products_id = pd.products_id AND pd.language_id = " . (int)$_SESSION['languages_id'] ." ORDER BY FIELD(p.products_id, ".ZX_CAROUSEL_MOD_CUSTOM.")";
            if ($products_query != '') $products = $db->Execute($products_query, ZX_CAROUSEL_LIMIT);
            break;

[DrByte]

For increased security, you may want to replace both instances of

ZX_CAROUSEL_MOD_CUSTOM
with
zen_db_input(ZX_CAROUSEL_MOD_CUSTOM)

[TheGrimReaper]

That's the one I was trying to do. Made a great mod even better. Thank you.

[TheGrimReaper]

For increased security, you may want to replace both instances of

ZX_CAROUSEL_MOD_CUSTOM
with
zen_db_input(ZX_CAROUSEL_MOD_CUSTOM)

Excellent thought. Both instances of it?