Hi,
I finally changed the ISP Provider to a updated MYSQL one.

Then I installed ARI Smart Content: Data table pack.

Then I'm trying to make a query to a specific table in Database.
I figured out that the only way to do that is throug ARI SQL Table. Then I tried to install the plugin. Open plugins option, Search & Install, select ARI SQL Table, install but nothing happens. I checked the FTP and the folder install/plugins/ isn't there.

So I have these questions:
1. where are the other plugins? (I searched the entire ARI site and couldn't find them to download, pls send me the link)

2. What are the possible ways to open a single table in database and create a query to view it?

3. Is there any dummy-proof tutorial to learn how to use all the power of ARI Smart Content? I'm having some difficult to learn your teachings.

Thanks and best regards.
Lucas
Brazil

Hello,

'ARI SQL Table' plugin installed by default with 'ARI Smart Content: DataTable Pack' like other extension plugins. You can see installed plugins on 'Components -> ARI Smart Content -> Plugins' page or on 'Diagnostics' page. 'ARI SQL Table' plugin can be wrapped with other table plugins, for example with 'ARI JDataTable' plugin. See below sample code which select records from jos_content table and wrap it with 'ARI JDataTable':



Sample of usage of each plugin can be found on plugin settings page and on our demo site.

Regards,
ARI Soft

Ok,
Let's go again.
I checked the DIAGNOSTICS page, PLUGIN tab.

Here it is (translated):

Nome Tipo Status
ARI CSV Table content Instalado
ARI JTruncator content Instalado
ARI JDataTable content Instalado
ARI MooTable content Instalado
ARI JTableSorter content Instalado
ARI JFlexGrid content Instalado
ARI CSS Templates Loader content Instalado
ARI JCSV 2 Table content Instalado
ARI Linkifier content Instalado
ARI SQL Table content Instalado
ARI IE Canvas Loader system Instalado
ARI JQuery UI Loader system Instalado
ARI Mootools Loader system Instalado
ARI JQuery Loader system Instalado
ARI System system Instalado

So the Ari SQL Table is installed inside JData Table?

I just copied and paste your code and didn't worked out.
So the SQL Table plugin is not installed? Or it is not working?

Any hint?

Any other plugin can open a table in the database?
(I used chronoforms extension to creat table jos_chronoforms_cvnovo and need to open this table and browse results).

best regards
Lucas

Hi,
Finally I got it.
I need to insert the code inside the CODE button in the editor (I use JCE).
So now it's working.

I'm just having some difficulties with CSS formatting.
Any help?

Cheers
Lucas

What problems with CSS formatting you mean?

Regards,
ARI Soft

When I open the Component, menu CSS Templates, No Records Found.

When I go to diagnostics / System / Joomla Content Plugin --> Not installed or installed with errors (already tried to fix many times, tried to follow instructions but directory is missing).

Tried with this code:
(worked first time, now isn't working. At the first time, the table has no formatting, was ugly, now it doesn't appear)

{arisqltable}
{arisqltablequery}
{arisqltablecolumns}
{arisqltablecolumn id="Nome" alias="Nome" width="20%" className="idg"}
{arisqltablecolumn id="Endereco" alias="Endereco" headerClassName="head"}
{arisqltablecolumn id="cidade" alias="cidade" headerClassName="head"}
{arisqltablecolumn id="uf" alias="uf" headerClassName="head"}
{arisqltablecolumn id="cep" alias="cep" headerClassName="head"}
{arisqltablecolumn alias="Virtual Column" headerClassName="head" virtual="true" pos="1"}

{coltemplate}{$Nome} - {$Endereco} - {$cidade} - {$uf} - {$cep}{/coltemplate}

{/arisqltablecolumn}
{/arisqltablecolumns}

SELECT Nome, endereco, cidade, uf, cep, fones
FROM jos_chronoforms_cvnovo

{/arisqltablequery}

{/arisqltable}


Then tried the second option and doesn't read table
(see image attached)


{arisqltablequery}

SELECT Nome as Nome, endereco as Endereco, cidade as cidade, uf as uf, cep as cep, fones as fones
FROM jos_chronoforms_cvnovo

{arijtablesorter defaultSorting="1:DESC" zebra="TRUE"}

<table>
<thead>
<tr>
<th>Nome</th>
<th>Endereco</th>
<th>cidade</th>
<th>UF</th>
<th>CEP</th>
</tr>
</thead>
<tbody>
<tr>
<td>Nome</td>
<td>Endereco</td>
<td>cidade</td>
<td>uf</td>
<td>cep</td>
</tr>
</tbody>
</table>

{/arisqltablequery}
{/arijtablesorter}

I realize that I need to open Joomla Editor for Article editing (I'm using JCE 1.5.6), then click on Edit Code, then Select Code then paste the code to try. Is it correct?

Please help me.
Thanks.