Hello,

I have just purchased, downloaded, and installed Smart Content (Joomla 1.5) and like so many first meeting these products I am a bit lost, so I am hoping you can set me on the right track for success!

The Plugin is installed and enabled, I see that in the plugin manager.

I placed one of the sample code snippets into an article so that I could test and play with the plugin. I have changed the parameters of the following to suit my site but when I preview the article all I see is the raw code as below:

{arisqltable}
{ariconnectionstring dbHost="localhost" dbUser="user" dbPass="pass" dbName="joomla" dbType="mysqli"}
{arisqltablecolumns}
{arisqltablecolumn id="ID" alias="ID" width="20%" className="idg"}
{arisqltablecolumn id="NAME" alias="UserName" headerClassName="head"}
{/arisqltablecolumns}
{arisqltablequery}
SELECT id AS ID,name AS NAME
FROM jos_users
{/arisqltablequery}
{/arisqltable}


It appears that the plugin is not running. Probably because I do not uderstand how to connect this code to the plugin.

My goalis to have various table based reports and graphs about my site available in articles on the site.

Any help much appreciated,
Sid

Hello,

If you use a WYSIWYG editor, switch it to plain text when inserting plugin code because it can add extra HTML code in design (HTML) mode. If it doesn't help, could you provide link to page where we can see this issue and if it is possible temporary access to your Joomla! backend by email that we can investigate this issue?

Regards,
ARI Soft

Many thanks for your very quick reply, I am embarassed to say that I had not licensed the plugin. Now I have done that the code is no longer displayed but the table does not showup. I think this is because I have the wrong database password. I am waiting for my site admin to help with that.

If I continue to have a problem I will be back.

Again, thank you for replying,
Sid.

If you want to show data from default Joomla! database, you can omit {ariconnectionstring} tag. The code will look like:



Regards,
ARI Soft

Yes!!! That produced the list of users.

so the syntax for a table in the Joomla database is to use "#__" in place of the table prefix?

Thanks,
Sid.

Yes, '#_' is replaced with table prefix.

Regards,
ARI Soft