Joomla Templates

Hi

I need a tag cloud module for embedded G2.3 on Joomla 1.5. I couldn't find any, so I try to create one from Joomulus extensions.joomla.org/extensions/6493/details but I am not a very good php programmer :-)

I have developped a new function inside helper.php to populate the tags from g2_Item database
Quote:

function getG2Text() {
$result=null;
$db = new database('localhost','xxx','xxx','gallery2','g2_') ;
$query = "SELECT g_keywords FROM g2_Item where g_keywords!=\"\" or g_keywords!=NULL ORDER BY RAND() limit 0,5";
$db->setQuery($query);
$result = $db->loadObjectList();
return $result;
}

but I have this error when publishing module :
Quote:

Warning: array_values() [function.array-values]: The argument should be an array in /var/www/modules/mod_joomulus/mod_joomulus.php on line 37

Warning: Wrong parameter count for min() in /var/www/modules/mod_joomulus/mod_joomulus.php on line 37

Warning: array_values() [function.array-values]: The argument should be an array in /var/www/modules/mod_joomulus/mod_joomulus.php on line 38

Any help will be appreciated.

Thanks

David

simply, replace $query string in original module like this :

$query = "SELECT g_keywords as `title` FROM g2_Item where g_keywords!="" or g_keywords!=NULL ORDER BY RAND() limit 0,5";

Hi,

So simple...B)
Thank you vey much, and that works!

One more question :
My keywords are too much "cut" in the cloud.
In my db for one record, I would like to use ; character as separation. For instance :

word1 word2 ; word3 ; word4 word5 ;

TAG cloud :
word1 word2
word3
word4 word5
etc

Do you know how to do that?
It seems to have something with clean_content function...
But I can't figure that out.

Have a nice new year's eve anyway and thanks for your help

David

in mod_joomulus.php try to remplace

$cadena_grande = implode(' ',$cadena_grande);
$palabras_array = preg_split("/ /", $cadena_grande);
by
$cadena_grande = implode(';',$cadena_grande);
$palabras_array = preg_split("/;/", $cadena_grande);

but search doesn't works...

Thank you very much, it works fine!

I try to pack this new module for publising it freely and I would like to add some parameters to link to db in xml file. Especially I want to create db parameters to connect to the gallery database.

So in the GetText function I would like to add these variables declared in xml file:

$db = new database($g2_db_host,$g2_db_user,$g2_db_pwd,$g2_db _name,$g2_db_prefix);

I have inserted these new values in xml files but program does not work, it seems that I can't access to these values. I have a class problem or non object error. I know it sounds stupid but do you know how to access to a parameter from a function defined in classe joomulusHelper in helper.php?
Thank you for your appreciated help.

David