Hi

This module is set to display only specific items.

Above selected items it says: "Drag and drop to re-order items"
Problem is that module doesn't show items in desired order.

What to do so that items in module in frontend are in same order like our items in module settings in backend?

Regards

Dear Hrvoje Znaor,

Please go to administrator -> Module Manager: Module mod_sj_k2_slideshowii -> Source Options:
1. Source -> select : Select specific items
2. Select specific items -> Add items , Drag and drop to re-order items

Thanks!

Hi

It would be nice if module would work as you said, unfortunately it doesn't.

I already set module like you suggested, but:

Item order in module settings:
- GRIDCON transformer certified as the world's first voltage regulated distribution transformer
- A bungalow-sized transformer ends an exceptional journey from South Korea to UK
- Yacyreta power generating unit 8 operates normally after transformer failure
- US power transformer industry likely to shift dramatically
- Giant transformer begins 1,000-mile trip to Sweden

But module displays items in this order:
- Yacyreta power generating unit 8 operates normally after transformer failure
- A bungalow-sized transformer ends an exceptional journey from South Korea to UK
- GRIDCON transformer certified as the world's first voltage regulated distribution transformer
- Giant transformer begins 1,000-mile trip to Sweden
- US power transformer industry likely to shift dramatically

As you can see, module doesn't show items in desired order.
I reordered items in module setting many times, but it's still the same.

I tried to attach 2 jpg images here, but it doesn't work

Regards

Dear Hrvoje Znaor,

Could you please send your site account to us? We will check directly.
For the security reason, please enter your site account in
Require Help
From Staff + Mod/Admin?

Thanks!

Hello

Sorry for late reply, some other tasks on that website were more important and now they want me again to fix this. I've re-checked module settings several times, and so far it seems that:

1. If source is set to "Select specific items",
- mod_sj_k2_slideshowii always sort items by ID ASC,
no matter what's set in "Item ordering"

2. If source is set to "Retrieve items from categories",
- module sorts items correctly, depends what's set in "Item ordering"

I've also checked helper_base.php file and I've found two main queries, one for "Select specific items" mode and one for "Retrieve items from categories" mode.

This function selects which query is executed:
if ($params->get('source') == 'specific')

Query for "Select specific items" mode doesn't have any sorting applied on it:
$db->setQuery($query);
$items = $db->loadObjectList();

Query for "Retrieve items from categories" mode does have sorting:
$query .= " ORDER BY ".$orderby;
$db->setQuery($query, $start, $limit);
$items = $db->loadObjectList();


Conclusion:
Query for "Select specific items" should take items from array constructed from
"Drag and drop to re-order items" setting and use it as ordering.

Btw. My client would like to avoid to give superadmin access to 3rd party.


Joomla 3.2.1
Sj K2 Slideshow II v.2.5 - December 2012

Regards