Hello

It is possible to create data source with a SQL Query and using the result to user "Easy Slider" ?

For exemple, i would like to have all pictures and name for my Contacts table in Joomla database...

Thanks a lot
Jean-Marie

Hello,

It is possible to use "SQL Query" data source for "ARI Smart Content - Easy Slider" plugin.

Regards,
ARI Soft

Hello

It's really cool

I don't found the link with "SQL QUERY" in "Easy Slider", only data source with "Images - Local Images", "Picasa" and "Flickr" ...
So only link with content of a directory, nor with a "SQL Query" directly...

It is possible to give me an real exemple, for exemple :

To obtain all contatcs (table "(xxx)_contact_detail") in category "Admin" (table "(xxx)_categories") and i want have in the slideshow :

- The image : field "image" in the table "contact_details" (minimum)
- The name : field "name" (for exemple, displayed if possible below the image)
- The fonction : field "con_position" (for exemple, displayed if possible below the image)

Parameters in "SQL Query" ?
Parameters in"Easy Slider" ?

Thanks a lot !
Jean-Marie

It is possible to use "SQL query" data source for "ARI Smart Content - Easy Slider" plugin (not for the module). Data source can be created on "Components -> ARI Smart Content -> Data -> Database data -> SQL queries" page on Joomla! backend. Plugin code for "ARI Smart Content - Easy Slider" plugin looks like:



Documentation for the plugin is available here. Check that the plugin is enabled.

Regards,
ARI Soft

OK Thanks I will try this
Thans a lot
Jean-marie

Hello
I try this solution and it's good !!!!!

I have 2 problems with the image (for exemple image from the contact)

SQL query : SELECT name, image, con_position FROM (xxx)_contact_details
Code :

{easyslider source="5"}
{params}
{param name="itemTemplate"}
{$name} - {$image} - {$con_position}
{/param}
{/params}
{/easyslider}

Problem 1
The result for the image is the path of the image.
Indeed, the image is not stored in the database but only its location on the disk.

To bad...
Is there a solution to display the image and not its path?

- With "ARI Smart Content - Easy Slider" to have a slideshow with images...
- And if possible with "ARI Smart Content - HTML Table" to have grids with images...

Problem 2
I can't see the result with "ARI Smart Content - Easy Slider" because there is only 1 column and this colum is very small. I have places only for 3 characters...

Tout can see this result here : pp.jmgi.fr