Home News Contact Us Forum About Us Demos Products F.A.Q.
Shopping Cart
You currently have 0 items in your cart.


Recent Events
  • 25/11/2021 Black Friday Promotion

    BIG SALE, 35% discount for all our extensions. Use BF21 coupon code. Hurry up the discount is valid till 1 December.

  • 30/04/2021 Important information

    We transferred to another hosting so if you are experiencing any problem let us know. We will fix it as soon as possible.


2Checkout.com, Inc. is an authorized retailer of goods and services provided by ARI Soft. 2CheckOut




Follow us on twitter



Welcome, Guest
Please Login or Register.    Lost Password?

ARI Smart Content - Easy Slider with Data source
(1 viewing) (1) Guest
Go to bottomPage: 123
TOPIC: ARI Smart Content - Easy Slider with Data source
#57084
ARI Smart Content - Easy Slider with Data source 6 Years, 9 Months ago Karma: 0
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
Last Edit: 2016/03/03 11:28 By jmgroud.Reason: add topic icon
The administrator has disabled public write access.
Le peu que je sais est occulté par le trop que je ne sais pas...
 
#57085
Re:ARI Smart Content - Easy Slider with Data source 6 Years, 9 Months ago Karma: 737
Hello,

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

Regards,
ARI Soft
The administrator has disabled public write access.
 
#57089
Re:ARI Smart Content - Easy Slider with Data source 6 Years, 9 Months ago Karma: 0
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
The administrator has disabled public write access.
Le peu que je sais est occulté par le trop que je ne sais pas...
 
#57091
Re:ARI Smart Content - Easy Slider with Data source 6 Years, 9 Months ago Karma: 737
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:

Code:


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



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

Regards,
ARI Soft
The administrator has disabled public write access.
 
#57092
Re:ARI Smart Content - Easy Slider with Data source 6 Years, 9 Months ago Karma: 0
OK Thanks I will try this
Thans a lot
Jean-marie
The administrator has disabled public write access.
Le peu que je sais est occulté par le trop que je ne sais pas...
 
#57100
Re:ARI Smart Content - Easy Slider with Data source 6 Years, 9 Months ago Karma: 0
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
The administrator has disabled public write access.
Le peu que je sais est occulté par le trop que je ne sais pas...
 
Go to topPage: 123