Joined: 10 Aug 2003
Posts: 427
Location: switzerland
Posted: 11/19/05 12:26
hey gutta,
I had trouble running these modules when they were on separate databases, too. even when putting in correct information in the module properties, my data would not display.
after installing mambo and jamroom into the same database I had no more problems.
I re-installed Jamroom and used the same database as my Mambo site and I'm getting the same exact errors as above. NONE of the modules will work and I'm not sure what to do
I seemed to have had that error too, oddly enough my Jamroom configuration changed.. verify your jamroom configuration parameters for the following:
Maximum Results: Default = 1000
(max 99999)
Page Results: Default = 100
Cache Expires = 600
Somehow my config changed to 0 for some of those values, my charts stopped working and therefore so did my spotlight module.. Even my searches retuned no results regardless what parameters I searched, Artist Name etc..!
Hopefully your problem is also as simple to solve!
Good Luck..
Hi
I try to integrate with joomla
but I get a error with the modul Upcoming Events
Fatal error: Call to undefined function: get() in /opt/www/luypaerts/web/www.demoband.be/modules/mod_werkkrewevents_latest.php on line 40
Im I doing something wrong
events calendar is working wright
thanks for any help
greets luppe
Hello, It's my understanding the old werkkrew modules will not work with the new version of jamroom(correct me if I'm wrong). Are there any mods that can be done to the modules to make them work? They seem very helpful!!
Actually I have a couple of the old modules working on my joomla site and they work quite alright. There's a few changes that need to be made but very minimal. The ones I had working at the "Newest Bands" and the Newest Songs. I haven't tried all of them as I didn't need them all but they do work.
This is the code I used for Newest Band. Just replaced your php file with this one: Just a note tho, this displays members and bands so I just called my module "Newest Members".
Code
<?
// WerkkreW Newest Bands//
// Version: 2.0
// Designed for Mambo 4.5.1a
// Author : Bryan Chain
///THIS USES THE MAMBO PARAMETER FOR LIMIT
///Call it using "limit=10" of whatever number you want
///THERE IS A PARAMETER FOR LINK STYLE
///Call it using "link_type=1" or by these numbers
/// 1 : Default : Links link to bands page
/// 2 : Adds a link to rate the band
$link_type = $params->get( 'link_type' ); //1 for link to band site, 2 for link to play the song, 3 for a choice
$limit = $params->get( 'limit' ); //How many items to show in list max
$band_url = $params->get( 'jamroom' );
$bullet_img = $params->get( 'bullet' );
$main_link_style = $params->get( 'mainlink' );
$sub_link_style = $params->get( 'sublink' );
$max_words = $params->get( 'max_words' );
<?
// WerkkreW Newest Songs//
// Version: 2.0
// Designed for Mambo 4.5.1a
// Author : Bryan Chain
///THIS USES THE MAMBO PARAMETER FOR LIMIT
///Call it using "limit=10" of whatever number you want
///THERE IS A PARAMETER FOR LINK STYLE
///Call it using "link_type=1" or by these numbers
/// 1 : Default : Links link to bands page
/// 2 : Links Link to play song
/// 3 : Main link goes to band page, secondary link plays song
/// 4 : Just Like Choice 3, With a Link to Rate the song
$link_type = $params->get( 'link_type' ); //1 for link to band site, 2 for link to play the song, 3 for a choice
$limit = $params->get( 'limit' ); //How many items to show in list max
$band_url = $params->get( 'jamroom' );
$bullet_img = $params->get( 'bullet' );
$main_link_style = $params->get( 'mainlink' );
$sub_link_style = $params->get( 'sublink' );
$max_words = $params->get( 'max_words' );
defined( '_VALID_MOS' ) or die( 'Direct Access to this location is not allowed.' );
$query = "SELECT s.song_id, s.song_time, s.song_name, s.song_album, s.song_label, s.song_genre, s.song_lyrics, s.song_history, i.band_id, i.band_time, i.band_name, i.band_location, i.band_website, h.hifi_size, h.hifi_download, h.hifi_extension, l.lofi_size, l.lofi_download, l.lofi_extension, SUM(c.hifi_scount_total + c.lofi_scount_total) AS total_stream, SUM(c.hifi_dcount_total + c.lofi_dcount_total) AS total_download, SUM((c.hifi_scount_total + c.lofi_scount_total) + (c.hifi_dcount_total + c.lofi_dcount_total)) AS total_count, g.genre_name"
."\nFROM jamroom_song_info AS s"
."\nLEFT JOIN jamroom_band_info AS i ON i.band_id = s.band_id"
."\nLEFT JOIN jamroom_song_hifi AS h ON h.song_id = s.song_id"
."\nLEFT JOIN jamroom_song_lofi AS l ON l.song_id = s.song_id"
."\nLEFT JOIN jamroom_scounter AS c ON c.song_id = s.song_id"
."\nLEFT JOIN jamroom_quota AS q ON q.quota_id = i.band_quota"
."\nLEFT JOIN jamroom_song_genre AS g ON g.genre_id = s.song_genre"
."\nWHERE s.song_show != 'no' AND q.quota_rank = 'yes'"
."\nAND (h.hifi_size > 0 OR l.lofi_size > 0) GROUP BY s.song_id ORDER BY s.song_time DESC LIMIT $limit";
if(!$useDatabase)
{
$database->setQuery( $query );
$rows = $database->loadObjectList();
} else {
$db = mysql_connect($db_path, $db_user, $db_password);
if (!$db) die ("Cannot connect to database");
mysql_select_db($db_name, $db) or die ("Cannot connect to database");
Joined: 20 Aug 2006
Posts: 32
Location: Padova - Italy - Europe
Posted: 02/25/07 22:28
Hi all!
First, many thanks for the support provided, then I have a question (maybe a stupid one) about how the links was created..
I'm working on this on my Joomla 1.0.12 site and Jamroom 3.0.26.
I have installed Jamroom in a subfolder of the Joomla mainsite.
About that New Songs Module (and the Featured Artist too) I noticed that a link like this:
was created but... there isn't a folder called "bands" in my Jamroom... only a "members" one, with both members and artists stored..
Should I have to set the system in jamroom config - File and Directory Settings - Account Directory Name providing the "bands" name of the folder, instead of "members"?
It doesn't affect other functions?
About other modules I'm trying to solve with mod_rewrite, just for now..
I think there's something more to be changed since this modules was written for mambo and Jamroom2.
Any helps to fix that for Joomla and Jamroom3 will be appreciate..
i honestly think the best solution is for jamroom to develop a better news and general content system.
So that you don't rely on artists to add content.
I use both joomla and jamroom for different things..