Jamroom Logo Jamroom 5 Core
is now Open Source!
User Support Forum Archive (Read Only)
User Documentation and How To's:
How To: Integrate Jamroom with Mambo CMS : UPDATED 03/19/05
werkkrew



Joined: 20 Feb 2004
Posts: 126
Location: Phildadelphia, PA USA

Posted: 06/30/04 15:01 
Updates!!!

This package is now officially sponsored by the Big Guy!

He has requested I package it into one file, and provided a document with all documentation, so I have.

All documentation is in readme.rtf which can be opened by WordPad or Word
All of my files are contained in this package.

This will soon be added to the jamroom downloads page, and the documentation will be added to the wiki.

Only two major changes in this release:
1) External database integration now works, and has been fully tested
2) Spotlight module now supports multiple bands, and multiple songs per artist with different selection methods.

WerkkreW's Mambo Modules and Integration Files
Download Now!


These have taken a long time to write, and a lot of work has gone into them. Any donations are appreciated, Paypal : chain396@werkkrew.com

Also, I have created a web design business, and hosting.

Check it out: www.werkthweb.com


_________________
My Site:
www.werkkrew.com
Affordable Web Design and Site Hosting:
www.werktheweb.com



Last edited by werkkrew on 03/19/05 22:23; edited 6 times in total
Back to top
ejcdke



Joined: 20 Jun 2004
Posts: 49

Posted: 06/30/04 15:32 
Thank you so much! This is great! I got the wrapper working fine but never knew what to do for the modules.... now that I got the modules I'll be set. I appreciate the help.

Eric

Back to top
musicmaker



Joined: 30 Jun 2004
Posts: 14
Location: Atlanta, Ga.

Posted: 06/30/04 16:50 
I just wanted to say thanks for sharing the Mambo modules. I have created my site http://www.musicmakersnetwork.com using mambo and jamroom. I didn't have the modules but had to improvise using links and the wrapper module. The modules will be great. I hope that I can reciprocate. Jamroom and mambo have been a great discovery. I have literally spent thousands of dollars (and countless hours) creating a custom music portal and only to be disappointed when my programmers could not work out all the bugs and would quit. I decided to scrap the old site and recreate it myself. Now I run my site without the need to hire expensive programmers. I guess this is sort of a testimonial of what a great job Brian has done with developing Jamroom.

peace
musicmaker

Back to top
ejcdke



Joined: 20 Jun 2004
Posts: 49

Posted: 06/30/04 17:17 
Almost there.... I'm getting the same type of problem with all the modules. I haven't tried the spotlight module though.

Parse error: parse error in /home/jukehous/public_html/modules/mod_werkkrewhotband.php on line 14

The line 14 is just
$params = mosParseParams( $module->params );

So I'm confused. This line shouldn't cause a problem...unless 4.5 1.08 stable breaks these modules.

Any ideas?

Back to top
ejcdke



Joined: 20 Jun 2004
Posts: 49

Posted: 06/30/04 19:56 
Wow, ok, I'm blind. the $bullet_img = line doesn't have a semi-colon at the end of it. So I'm playing with HotBands now and after the semi-colon fix, it parses to foreach($rows as $row) { So it's almost at the end.

Back to top
abax



Joined: 10 Mar 2004
Posts: 12

Posted: 07/01/04 05:45 
Big Big Big Thank You for sharing this! Very Happy

Back to top
Brian
Jamroom Team


Joined: 09 Jul 2003
Posts: 37583
Location: Seattle, WA

Posted: 07/01/04 07:06 
werkkrew -

Thank you for the great How To and for postnig your modules! Mambo is a VERY nice CMS (one of the few I would personally use) and it's great you took the time to help others out with this.

- Brian


_________________
Make sure and check out:
* The Jamroom FAQ
* The Jamroom Documentation
Back to top
werkkrew



Joined: 20 Feb 2004
Posts: 126
Location: Phildadelphia, PA USA

Posted: 07/01/04 09:49 
Youre all welcome.

As I said, this how-to isnt all that comprehensive, I guess I should have paid more attention to what I did when I did it...

There is an impending release of Mambo 4.6, which will probably coincide nicely with the release of Jamroom 2.10 final...

At this point I will probably release a set of fully portable modules and a more comprehensive walkthrough.


Too all those that are having trouble with the modules:

I took the scripts off my site, replaced every instance of my site url's with those two variables, nothing else was changed.

I am running Mambo 4.5 1.0.5, I doubt there is anything that might cause an issue with a later release.

I might have made a few silly parse errors when I made the few changes I did before I posted them here but there shouldnt be anything major, if anyone gets them working right, or corrects any errors I may have made, send them to me and I will re-package them.

Thanks all!

Back to top
ejcdke



Joined: 20 Jun 2004
Posts: 49

Posted: 07/01/04 17:36 
Well I don't mind the errors, this is farther then I was before you posted the modules. However, I'm still stuck at foreach($rows as $row) {

This line causes a parse error each time. It's line 33 of the hot band module. I'm getting the same error for the other modules as well. If anyone has it working or could tell me why it's not going that would be great. My code is as follows:


Quote:
<?
//werkkrew_totals//
// Version: 1.0
// Author : Bryan Chain


///THIS USES THE MAMBO PARAMETER FOR LIMIT
///Call it using "limit=10" of whatever number you want

///YOUR URL TO THE BAND SITE HERE
$band_url = "http://www.jukehouse.net/music/bands/";
$bullet_img = "http://www.jukehouse.net/images/bullet.gif";

$params = mosParseParams($module->params);

$limit = @$params->limit ? $params->limit : 5;

defined( '_VALID_MOS' ) or die( 'Direct Access to this location is not allowed.' );

$query = "SELECT i.band_id, i.band_time, i.band_name, i.band_update, i.band_quota, SUM( s.hifi_scount_total + s.lofi_scount_total ) AS total_stream, SUM( s.hifi_dcount_total + s.lofi_dcount_total ) AS total_download, SUM( s.hifi_scount_total + s.lofi_scount_total + s.hifi_dcount_total + s.lofi_dcount_total ) AS total_count, q.quota_id, q.quota_disk"
."\nFROM jamroom_band_info AS i"
."\nLEFT JOIN jamroom_scounter AS s ON s.band_id = i.band_id"
."\nLEFT JOIN jamroom_quota AS q ON q.quota_id = i.band_quota"
."\nWHERE i.band_update != 99 AND q.quota_rank = 'yes'"
."\nGROUP BY i.band_id"
."\nORDER BY total_count DESC"
."\nLIMIT $limit";

$database->setQuery( $query );
$rows = $database->loadObjectList();

echo "<table cellpadding='1' border='0'>";
foreach($rows as $row) {
if(strlen($row->band_name) > 15) {
$row->band_name = substr($row->band_name,0,12);
$row->band_name .= "...";
}

echo "<tr>";
echo "<td><img src='".$bullet_img."' /></td>";
echo "<td><b><a href='".$band_url."".$row->band_id."/' target='_blank'>".$row->band_name."</a></b>";
echo "</td></tr>";
}
echo "</table>";

?>


Thanks,
Eric

Back to top
Intro2Music



Joined: 04 Feb 2004
Posts: 427
Location: UK

Posted: 07/02/04 12:47 
All Mambo users should be aware of serious security vulnarabilities of older versions of Mambo, and keep up to date with new security patches.

werkkrew, the version you are using needs to be upgraded ASAP. I had 2 sites running that version a few months back and a serious hack brought my server down for over a month. It turns out that there is a bit of sloppy coding in one of the Include Files.

It's good to know that there's a few other Mambo/Jamroom users out there!

I've been trying to mambo wrap my chart and rank pages for the past week or so, but I just can't get the Jamroom chart pages to Wrap inside the Main frame of Mambo without having scroll bars. Maybe I need more sleep.

Mick


_________________
www.musical1.com
Back to top
stylehk



Joined: 03 Jul 2004
Posts: 5

Posted: 07/04/04 19:38 
Hey Werkkrew,

I see that in the 'Artist Listing' section of your site, you have implemented rank.php using the wrapper but with several drop down boxes, which enable the user to select how they sort the table. If I wanted to put this functionality into my site, where would I put that JavaScript function and the actual form?

Thanks for your help! Great site! Very Happy

Back to top
ejcdke



Joined: 20 Jun 2004
Posts: 49

Posted: 07/09/04 15:28 
Go to your rank folder. You will tpl files in each of the sub folders for the various functions. each tpl file is a header, footer, and row. The headers are where you will put the code. Note that each number in the file name corresponds the the rank functions. Play around with the band folder first and you'll quickly see what's going on.

Back to top
werkkrew



Joined: 20 Feb 2004
Posts: 126
Location: Phildadelphia, PA USA

Posted: 07/14/04 11:19 
He hit the nail on the head, I just wrote some javascript that acts like links to all the different ways you can sort it using onChange actions.

I edited the header template files for all of the different ways the rank can be shown.


_________________
My Site:
www.werkkrew.com
Affordable Web Design and Site Hosting:
www.werktheweb.com

Back to top
buyourweb



Joined: 29 May 2004
Posts: 152

Posted: 07/15/04 14:39 

Quote:
Well I don't mind the errors, this is farther then I was before you posted the modules. However, I'm still stuck at foreach($rows as $row) {


I have the same problem, has anyone figured out the fix yet?

Thanks in advanced

Peace

Back to top
werkkrew



Joined: 20 Feb 2004
Posts: 126
Location: Phildadelphia, PA USA

Posted: 07/15/04 18:14 
It it just the hot bands module, or all of them??

I just looked at the hottest band module as working on my server...

Here it is:


Code

<?
//werkkrew_totals//
// Version: 1.0
// Author : Bryan Chain

$params = mosParseParams($module->params);

$limit = @$params->limit  ? $params->limit : 5;

defined( '_VALID_MOS' ) or die( 'Direct Access to this location is not allowed.' );

$query = "SELECT i.band_id, i.band_time, i.band_name, i.band_update, i.band_quota, SUM( s.hifi_scount_total + s.lofi_scount_total ) AS total_stream, SUM( s.hifi_dcount_total + s.lofi_dcount_total ) AS total_download, SUM( s.hifi_scount_total + s.lofi_scount_total + s.hifi_dcount_total + s.lofi_dcount_total ) AS total_count, q.quota_id, q.quota_disk"
       ."\nFROM jamroom_band_info AS i"
        ."\nLEFT JOIN jamroom_scounter AS s ON s.band_id = i.band_id"
        ."\nLEFT JOIN jamroom_quota AS q ON q.quota_id = i.band_quota"
        ."\nWHERE i.band_update != 99 AND q.quota_rank = 'yes'"
        ."\nGROUP BY i.band_id"
        ."\nORDER BY total_count DESC"
        ."\nLIMIT $limit";

$database->setQuery( $query );
$rows = $database->loadObjectList();

echo "<table cellpadding='1' border='0'>";
  foreach($rows as $row) {
     if(strlen($row->band_name) > 15) {
      $row->band_name  = substr($row->band_name,0,12);
      $row->band_name .= "...";
    }
 
    echo "<tr>";
    echo "<td><img src='templates/tdwredgrey/images/arrowright.gif' /></td>";
    echo "<td><b><a href='http://www.werkkrew.com/bandsite/bands/".$row->band_id."/' target='_blank'>".$row->band_name."</a></b>";
    echo "</td></tr>";
  }
  echo "</table>";

?>



I cant see anything wrong with what you are posting, maybe a more detailed error would help.

The only thing I can think of is that the $rows array variable might be coming back empty, which would mean there is a problem with the query.


_________________
My Site:
www.werkkrew.com
Affordable Web Design and Site Hosting:
www.werktheweb.com

Back to top
Display posts from previous:   
User Support Forum Archive (Read Only)
User Documentation and How To's

12345...1112131415Next >
 
Solutions
• Social Media Platform
• Social Networking Software
• Musician Website Manager
• Community Builder
Products
• Jamroom Core
• Jamroom Addons
• Jamroom Modules
• Jamroom Marketplace
Support
• Support Forum
• Documentation
• Support Center
• Contact Support
Community
• Community Forum
• Member Sites
• Developers
Company
• About Us
• Contact Us
• Privacy Policy
©2003 - 2010 Talldude Networks, LLC.