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


Recent Events
  • 31/12/2023 New Year SALE

    We are glad to announce New Year SALE. 25% discount for all our extensions. Use NY24 coupon code. Hurry up the discount is valid till 7 January.

  • 21/11/2023 BLACK FRIDAY 23 is coming

    BIG SALE, 35% discount for all our extensions. Use BF23 coupon code. Hurry up the discount is valid till 27 November.


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?

SQL Table plugin don't install
(1 viewing) (1) Guest
Go to bottomPage: 123
TOPIC: SQL Table plugin don't install
#6398
SQL Table plugin don't install 13 Years, 7 Months ago Karma: 0
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
The administrator has disabled public write access.
-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.
Thanks for your time. It's the most valuable think you can give.
 
#6405
Re:SQL Table plugin don't install 13 Years, 7 Months ago Karma: 746
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':

Code:


{arijdatatable}
  {arisqltable}
    {arisqltablequery}
     SELECT *
     FROM #__content
    {/arisqltablequery}
  {/arisqltable}
{/arijdatatable}



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

Regards,
ARI Soft
The administrator has disabled public write access.
 
#6410
Re:SQL Table plugin don't install 13 Years, 7 Months ago Karma: 0
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
The administrator has disabled public write access.
-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.
Thanks for your time. It's the most valuable think you can give.
 
#6412
Re:SQL Table plugin don't install 13 Years, 7 Months ago Karma: 0
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
The administrator has disabled public write access.
-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.
Thanks for your time. It's the most valuable think you can give.
 
#6418
Re:SQL Table plugin don't install 13 Years, 7 Months ago Karma: 746
What problems with CSS formatting you mean?

Regards,
ARI Soft
The administrator has disabled public write access.
 
#6431
Re:SQL Table plugin don't install 13 Years, 7 Months ago Karma: 0
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.
The administrator has disabled public write access.
-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.
Thanks for your time. It's the most valuable think you can give.
 
Go to topPage: 123