Jamroom Logo Jamroom 5 Core
is now Open Source!
archive home jamroom 4 downloads jamroom 4 support archive forum
You are viewing the Jamroom 4 Archive Site - please join us on the new Jamroom.net!
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: 07/29/04 15:51 
As per my crappy documentation, there is a mambo module parameter.

You define this parameter in mambos admin panel when you look at the module.

I see what I did wrong.

I pasted the wrong release.

where it says

$band_id = 9;

that was a temporary soluction during testing.

If you desire random spotlights delete this line:
$query .= "\nAND i.band_id = $band_id";

Else, if you want to be able to select specific bands

add this line below the $params = ..... line

$band_id = @$params->band_id ? $params->band_id : 'null';

then you can use the parameter "band_id" as per the documentation


SORRY ABOUT THAT, MY BAD!


_________________
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/29/04 17:52 

Quote:
then you can use the parameter "band_id" as per the documentation

I reinstalled the spotlight module so all the code would be right. I did delete the query = $query .= "\nAND i.band_id = $band_id"; = but I still always get the same artist in the spotlight.
Also I can not figure out where I change or use the parameter band_id to select the band in the spotlight.
Sorry I can't figure this one out
Thanks again.
Peace
Back to top
johnypneumo



Joined: 15 Jan 2004
Posts: 954
Location: united kingdom
Posted: 08/03/04 02:27 
Werkkrew , im a little new to mysql databases as ive used Perl for a few years ,.. so sorry to ask,but i dont know how to do this -
Quote:
just connect to the other DB and modify the query.
could anyone explain how please ? Smile oh go on . . Wink
Back to top
buyourweb



Joined: 29 May 2004
Posts: 152
Posted: 08/03/04 12:39 
I used the template files in JamRoom to make a module for the Artist Spotlight Feature. It is picking bands at Random and looks very nice. Thanks for all your help again.
Peace
Back to top
johnypneumo



Joined: 15 Jan 2004
Posts: 954
Location: united kingdom
Posted: 08/05/04 12:04 

johnypneumo:
Werkkrew , im a little new to mysql databases as ive used Perl for a few years ,.. so sorry to ask,but i dont know how to do this -
Quote:
just connect to the other DB and modify the query.
could anyone explain how please ? Smile oh go on . . Wink

please anybody ! lol "connect to the other databse" ? how ? Embarassed
Back to top
werkkrew



Joined: 20 Feb 2004
Posts: 126
Location: Phildadelphia, PA USA
Posted: 08/05/04 13:14 
At the beginning of the file you need to do this in...

Add something like this:


Code

$uername = mysql_username ;
$password = mysql_password;
$server = localhost usually;
$database = jamroom_database;

$con = mysql_connect($server,$username,$password)
  or die("unable to connect to the phpBB2 database server!

          <br>MySQL error:". mysql_errno() .' - '. mysql_error());


# select our database
mysql_select_db($database,$con)
  or die("unable to open the phpBB2 database!
          <br>MySQL error:". mysql_errno() .' - '. mysql_error());





THEN REPLACE THESE TWO LINES IN EACH FILE WITH THESE


Code


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

//replace with

$rv = mysql_query($query);
$rows = mysql_fetch_assoc($rv);



Hope that helps.


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

Back to top
johnypneumo



Joined: 15 Jan 2004
Posts: 954
Location: united kingdom
Posted: 08/05/04 14:40 
Thank you WerkKrew i sincerely appreciate your help. Razz
Back to top
musicmaker



Joined: 30 Jun 2004
Posts: 14
Location: Atlanta, Ga.
Posted: 08/06/04 12:30 
[quote]I reinstalled the spotlight module so all the code would be right. I did delete the query = $query .= "\nAND i.band_id = $band_id"; = but I still always get the same artist in the spotlight.
Also I can not figure out where I change or use the parameter band_id to select the band in the spotlight.
Sorry I can't figure this one out
Thanks again.
Peace

I'm having the same problem.

[quote]I used the template files in JamRoom to make a module for the Artist Spotlight Feature. It is picking bands at Random and looks very nice. Thanks for all your help again.
Peace

How did you make it work Question Any help would be great.

Thanks
Back to top
johnypneumo



Joined: 15 Jan 2004
Posts: 954
Location: united kingdom
Posted: 08/08/04 13:18 
These mods work perfectly Smile i had to re-install mambo due to a corruption i made,but when i did i created jamroom with the same databse as mambo and they work ,
thank you WerkKrew,i am very greatfull.
Darren.
Back to top
werkkrew



Joined: 20 Feb 2004
Posts: 126
Location: Phildadelphia, PA USA
Posted: 08/08/04 22:52 
Thanks, glad to hear you got them working


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

Back to top
johnypneumo



Joined: 15 Jan 2004
Posts: 954
Location: united kingdom
Posted: 08/12/04 11:39 
altho the spotlight feature doesnt change,its weird tho ,..is this best changed manualy when you want the artist changing ? i think this is the way ill try it Smile
Back to top
musicmaker



Joined: 30 Jun 2004
Posts: 14
Location: Atlanta, Ga.
Posted: 08/15/04 08:29 
After modifying the module code as werkrew suggested. I can't get the spotlight module to randomize. I can get spotlight display of the first band in the database but it never changes. Has anyone been able to figure out how to make this work?

Here is my code:

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

//Your jamroom URL: *NO TRAILING SLASH*
$jamroom_url = "http://www.musicmakersnetwork.com/jamroom";

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

$band_id = @$params->band_id  ? $params->band_id : 'null';

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_location, i.band_story, i.band_website, i.band_influence, i.band_soundlike, q.quota_id, q.quota_name, h.hifi_size, h.hifi_download, h.hifi_extension, l.lofi_size, l.lofi_download, l.lofi_extension, s.song_id, s.song_time, s.song_name, s.song_album, s.song_label, s.song_lyrics, s.song_history, SUM( c.hifi_scount_total + 0 ) AS hifi_streams, SUM( c.lofi_scount_total + 0 ) AS lofi_streams, SUM( c.hifi_dcount_total + 0 ) AS hifi_downloads, SUM( c.lofi_dcount_total + 0 ) AS lofi_downloads, 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_band_info AS i"
        ."\nLEFT JOIN jamroom_quota AS q ON q.quota_id = i.band_quota"
        ."\nLEFT JOIN jamroom_band_image AS m ON m.band_id = i.band_id"
        ."\nLEFT JOIN jamroom_song_info AS s ON s.band_id = i.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_song_genre AS g ON g.genre_id = s.song_genre"
        ."\nWHERE i.band_update != 99 AND q.quota_spot = 'yes' AND s.song_show != 'no' AND (h.hifi_size > 0 OR l.lofi_size > 0)"
        ."\nAND m.image_size > 0";
      if (is_numeric($band_id)){

      }
      $query .= "\nGROUP BY s.song_id LIMIT 1";

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

foreach($rows AS $_row)
{
if (!empty($_row->hifi_size) && $_row->hifi_size != 0)
{
$_rep['{SONG_HIFI_PLAY_LINK}'] = $jamroom_url."/play.php?band_id=".$_row->band_id."&song_id=".$_row->song_id."&mode=song_hifi";
$_rep['{SONG_HIFI_PLAY_IMAGE}'] = "<a href=\"".$jamroom_url."/play.php?band_id=".$_row->band_id."&song_id=".$_row->song_id."&mode=song_hifi\"><img src=\"".$jamroom_url."/rank/song/images/play_hifi.gif\" border=0 alt=\"click here to stream &quot;".$_row->song_name."&quot; in HIFI mode\" title=\"click here to stream &quot;".$_row->song_name."&quot; in HIFI mode\"></a>";
if ($_row['hifi_download'] == 'yes')
{
$_rep['{SONG_HIFI_DOWNLOAD_LINK}'] = $jamroom_url."/download.php?band_id=".$_row->band_id."&song_id=".$_row->song_id."&mode=song_hifi";
$_rep['{SONG_HIFI_DOWNLOAD_IMAGE}'] = $jamroom_url."/download.php?band_id=".$_row->band_id."&song_id=".$_row->song_id."&mode=song_hifi\"><img src=\"".$jamroom_url."/rank/song/images/down_hifi.gif\" border=0 alt=\"click here to download a HIFI version of &quot;".$_row->song_name."&quot;\" title=\"click here to download a HIFI version of &quot;".$_row->song_name."&quot;\"></a>";
}
else
{
$_rep['{SONG_HIFI_DOWNLOAD_LINK}'] = '';
$_rep['{SONG_HIFI_DOWNLOAD_IMAGE}'] = '-';
}
}
else
{
$_rep['{SONG_HIFI_PLAY_LINK}'] = '';
$_rep['{SONG_HIFI_PLAY_IMAGE}'] = '-';
$_rep['{SONG_HIFI_DOWNLOAD_LINK}'] = '';
$_rep['{SONG_HIFI_DOWNLOAD_IMAGE}'] = '-';
}
if (!empty($_row->lofi_size) && $_row->lofi_size != 0)
{
$_rep['{SONG_LOFI_PLAY_LINK}'] = $jamroom_url."/play.php?band_id=".$_row->band_id."&song_id=".$_row->song_id."&mode=song_lofi";
$_rep['{SONG_LOFI_PLAY_IMAGE}'] = "<a href=\"".$jamroom_url."/play.php?band_id=".$_row->band_id."&song_id=".$_row->song_id."&mode=song_lofi\"><img src=\"".$jamroom_url."/rank/song/images/play_lofi.gif\" border=0 alt=\"click here to stream &quot;".$_row->song_name."&quot; in LOFI mode\" title=\"click here to stream &quot;".$_row->song_name."&quot; in LOFI mode\"></a>";
if ($_row->lofi_download == 'yes')
{
$_rep['{SONG_LOFI_DOWNLOAD_LINK}'] = $jamroom_url."/download.php?band_id=".$_row->band_id."&song_id=".$_row->song_id."&mode=song_lofi";
$_rep['{SONG_LOFI_DOWNLOAD_IMAGE}'] = "<a href=\"".$jamroom_url."/download.php?band_id=".$_row->band_id."&song_id=".$_row->song_id."&mode=song_lofi\"><img src=\"".$jamroom_url."/rank/song/images/down_lofi.gif\" border=0 alt=\"click here to download a HIFI version of &quot;".$_row->song_name."&quot;\" title=\"click here to download a HIFI version of &quot;".$_row->song_name."&quot;\"></a>";
}
else
{
$_rep['{SONG_LOFI_DOWNLOAD_LINK}'] = '';
$_rep['{SONG_LOFI_DOWNLOAD_IMAGE}'] = '-';
}
}
else
{
$_rep['{SONG_LOFI_PLAY_LINK}'] = '';
$_rep['{SONG_LOFI_PLAY_IMAGE}'] = '-';
$_rep['{SONG_LOFI_DOWNLOAD_LINK}'] = '';
$_rep['{SONG_LOFI_DOWNLOAD_IMAGE}'] = '-';
}

$_rep2 = array(
'{MODE}' => 'spotlight',
'{BAND_ID}' => $_row->band_id,
'{BAND_CREATED}' => $_row->band_time,
'{BAND_NAME}' => $_row->band_name,
'{BAND_INFO}' => $_row->band_story,
'{BAND_LOCATION}' => $_row->band_location,
'{BAND_WEBSITE}' => $_row->band_website,
'{BAND_INFLUENCE}' => $_row->band_influence,
'{BAND_SOUNDLIKE}' => $_row->band_soundlike,
'{BAND_IMAGE}' => $jamroom_url."/image.php?band_id=".$_row->band_id."&mode=band_image",
'{QUOTA_ID}' => $_row->quota_id,
'{QUOTA_NAME}' => $_row->quota_name,
'{SONG_ID}' => $_row->song_id,
'{SONG_CREATED}' => $_row->song_time,
'{SONG_NAME}' => $_row->song_name,
'{SONG_ALBUM}' => $_row->song_album,
'{SONG_LABEL}' => $_row->song_label,
'{SONG_GENRE}' => $_row->genre_name,
'{SONG_GENRE_URL}' => urlencode($_row->genre_name),
'{SONG_IMAGE}' => $jamroom_url."/image.php?band_id=".$_row->band_id."&song_id=".$_row->song_id."&mode=song_image",
'{SONG_HIFI_EXTENSION}' => $_row->hifi_extension,
'{SONG_LOFI_EXTENSION}' => $_row->lofi_extension,
'{SONG_HIFI_SCOUNT}' => $_row->hifi_streams,
'{SONG_LOFI_SCOUNT}' => $_row->lofi_streams,
'{SONG_HIFI_DCOUNT}' => $_row->hifi_downloads,
'{SONG_LOFI_DCOUNT}' => $_row->lofi_downloads,
'{SONG_STREAM_COUNT}' => $_row->total_stream,
'{SONG_DOWNLOAD_COUNT}' => $_row->total_download,
'{SONG_TOTAL_COUNT}' => $_row->total_count
);
}

echo "<center>\n<table cellpadding=0 cellspacing=2>";

echo "<tr>";
echo "<td colspan=5><font size='+1'<a href='".$jamroom_url."/bands/{$_rep2['{BAND_ID}']}/' target=_blank>{$_rep2['{BAND_NAME}']}</a></td>";
echo "</tr>";
echo "<tr>";
echo "<td width=05% colspan=5>";
echo "<table width=50% cellpadding=0 cellspacing=0 border=0><tr>";
echo "<td width=02%><a href='".$jamroom_url."/bands/{$_rep2['{BAND_ID}']}/' target=_blank>";
echo "<img src='{$_rep2['{BAND_IMAGE}']}&width=136&height=78' width=136 height=78 border=0></a></td>";
echo "</tr></table>";
echo "</td>";
echo "</tr>";
echo "<tr bgcolor='#999999'>";
echo "<td width=01%><b>Hi</b></td>
  <td width=01%><b>Lo</b></td>
  <td width=05%><b>Song</b></td>
  <td width=05%><b>Genre</b></td>
</tr>";

echo "
<tr>
  <td width=01%><center>{$_rep['{SONG_HIFI_PLAY_IMAGE}']}</center></td>
  <td width=01%><center>{$_rep['{SONG_LOFI_PLAY_IMAGE}']}</center></td>
  <td width=05%>&quot;{$_rep2['{SONG_NAME}']}&quot;</td>
  <td width=05%>{$_rep2['{SONG_GENRE}']}</td>
</tr>";



echo "</table>";

?>



I'm at a deadend with my coding skills. So if anyone knows what to do we all would be greatful.
Thanks
Harvey
Back to top
werkkrew



Joined: 20 Feb 2004
Posts: 126
Location: Phildadelphia, PA USA
Posted: 08/15/04 08:54 
Try this, off the top of my head...

I will look deeped into later today if this doesnt work.

By the way it looks what I did here should show a random band, unless you use the band_id parameter, then it should show the band you select



Code

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

//Your jamroom URL: *NO TRAILING SLASH*
$jamroom_url = "http://www.musicmakersnetwork.com/jamroom";

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

$band_id = @$params->band_id  ? $params->band_id : 'null';

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_location, i.band_story, i.band_website, i.band_influence, i.band_soundlike, q.quota_id, q.quota_name, h.hifi_size, h.hifi_download, h.hifi_extension, l.lofi_size, l.lofi_download, l.lofi_extension, s.song_id, s.song_time, s.song_name, s.song_album, s.song_label, s.song_lyrics, s.song_history, SUM( c.hifi_scount_total + 0 ) AS hifi_streams, SUM( c.lofi_scount_total + 0 ) AS lofi_streams, SUM( c.hifi_dcount_total + 0 ) AS hifi_downloads, SUM( c.lofi_dcount_total + 0 ) AS lofi_downloads, 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_band_info AS i"
        ."\nLEFT JOIN jamroom_quota AS q ON q.quota_id = i.band_quota"
        ."\nLEFT JOIN jamroom_band_image AS m ON m.band_id = i.band_id"
        ."\nLEFT JOIN jamroom_song_info AS s ON s.band_id = i.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_song_genre AS g ON g.genre_id = s.song_genre"
        ."\nWHERE i.band_update != 99 AND q.quota_spot = 'yes' AND s.song_show != 'no' AND (h.hifi_size > 0 OR l.lofi_size > 0)"
        ."\nAND m.image_size > 0";
      if (is_numeric($band_id)){
         $query .= "\nAND i.band_id = $band_id GROUP BY s.song_id LIMIT 1";
      } else {
         $query .= "\nGROUP BY s.song_id ORDER BY rand() LIMIT 1";
      }

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

foreach($rows AS $_row)
{
if (!empty($_row->hifi_size) && $_row->hifi_size != 0)
{
$_rep['{SONG_HIFI_PLAY_LINK}'] = $jamroom_url."/play.php?band_id=".$_row->band_id."&song_id=".$_row->song_id."&mode=song_hifi";
$_rep['{SONG_HIFI_PLAY_IMAGE}'] = "<a href=\"".$jamroom_url."/play.php?band_id=".$_row->band_id."&song_id=".$_row->song_id."&mode=song_hifi\"><img src=\"".$jamroom_url."/rank/song/images/play_hifi.gif\" border=0 alt=\"click here to stream &quot;".$_row->song_name."&quot; in HIFI mode\" title=\"click here to stream &quot;".$_row->song_name."&quot; in HIFI mode\"></a>";
if ($_row['hifi_download'] == 'yes')
{
$_rep['{SONG_HIFI_DOWNLOAD_LINK}'] = $jamroom_url."/download.php?band_id=".$_row->band_id."&song_id=".$_row->song_id."&mode=song_hifi";
$_rep['{SONG_HIFI_DOWNLOAD_IMAGE}'] = $jamroom_url."/download.php?band_id=".$_row->band_id."&song_id=".$_row->song_id."&mode=song_hifi\"><img src=\"".$jamroom_url."/rank/song/images/down_hifi.gif\" border=0 alt=\"click here to download a HIFI version of &quot;".$_row->song_name."&quot;\" title=\"click here to download a HIFI version of &quot;".$_row->song_name."&quot;\"></a>";
}
else
{
$_rep['{SONG_HIFI_DOWNLOAD_LINK}'] = '';
$_rep['{SONG_HIFI_DOWNLOAD_IMAGE}'] = '-';
}
}
else
{
$_rep['{SONG_HIFI_PLAY_LINK}'] = '';
$_rep['{SONG_HIFI_PLAY_IMAGE}'] = '-';
$_rep['{SONG_HIFI_DOWNLOAD_LINK}'] = '';
$_rep['{SONG_HIFI_DOWNLOAD_IMAGE}'] = '-';
}
if (!empty($_row->lofi_size) && $_row->lofi_size != 0)
{
$_rep['{SONG_LOFI_PLAY_LINK}'] = $jamroom_url."/play.php?band_id=".$_row->band_id."&song_id=".$_row->song_id."&mode=song_lofi";
$_rep['{SONG_LOFI_PLAY_IMAGE}'] = "<a href=\"".$jamroom_url."/play.php?band_id=".$_row->band_id."&song_id=".$_row->song_id."&mode=song_lofi\"><img src=\"".$jamroom_url."/rank/song/images/play_lofi.gif\" border=0 alt=\"click here to stream &quot;".$_row->song_name."&quot; in LOFI mode\" title=\"click here to stream &quot;".$_row->song_name."&quot; in LOFI mode\"></a>";
if ($_row->lofi_download == 'yes')
{
$_rep['{SONG_LOFI_DOWNLOAD_LINK}'] = $jamroom_url."/download.php?band_id=".$_row->band_id."&song_id=".$_row->song_id."&mode=song_lofi";
$_rep['{SONG_LOFI_DOWNLOAD_IMAGE}'] = "<a href=\"".$jamroom_url."/download.php?band_id=".$_row->band_id."&song_id=".$_row->song_id."&mode=song_lofi\"><img src=\"".$jamroom_url."/rank/song/images/down_lofi.gif\" border=0 alt=\"click here to download a HIFI version of &quot;".$_row->song_name."&quot;\" title=\"click here to download a HIFI version of &quot;".$_row->song_name."&quot;\"></a>";
}
else
{
$_rep['{SONG_LOFI_DOWNLOAD_LINK}'] = '';
$_rep['{SONG_LOFI_DOWNLOAD_IMAGE}'] = '-';
}
}
else
{
$_rep['{SONG_LOFI_PLAY_LINK}'] = '';
$_rep['{SONG_LOFI_PLAY_IMAGE}'] = '-';
$_rep['{SONG_LOFI_DOWNLOAD_LINK}'] = '';
$_rep['{SONG_LOFI_DOWNLOAD_IMAGE}'] = '-';
}

$_rep2 = array(
'{MODE}' => 'spotlight',
'{BAND_ID}' => $_row->band_id,
'{BAND_CREATED}' => $_row->band_time,
'{BAND_NAME}' => $_row->band_name,
'{BAND_INFO}' => $_row->band_story,
'{BAND_LOCATION}' => $_row->band_location,
'{BAND_WEBSITE}' => $_row->band_website,
'{BAND_INFLUENCE}' => $_row->band_influence,
'{BAND_SOUNDLIKE}' => $_row->band_soundlike,
'{BAND_IMAGE}' => $jamroom_url."/image.php?band_id=".$_row->band_id."&mode=band_image",
'{QUOTA_ID}' => $_row->quota_id,
'{QUOTA_NAME}' => $_row->quota_name,
'{SONG_ID}' => $_row->song_id,
'{SONG_CREATED}' => $_row->song_time,
'{SONG_NAME}' => $_row->song_name,
'{SONG_ALBUM}' => $_row->song_album,
'{SONG_LABEL}' => $_row->song_label,
'{SONG_GENRE}' => $_row->genre_name,
'{SONG_GENRE_URL}' => urlencode($_row->genre_name),
'{SONG_IMAGE}' => $jamroom_url."/image.php?band_id=".$_row->band_id."&song_id=".$_row->song_id."&mode=song_image",
'{SONG_HIFI_EXTENSION}' => $_row->hifi_extension,
'{SONG_LOFI_EXTENSION}' => $_row->lofi_extension,
'{SONG_HIFI_SCOUNT}' => $_row->hifi_streams,
'{SONG_LOFI_SCOUNT}' => $_row->lofi_streams,
'{SONG_HIFI_DCOUNT}' => $_row->hifi_downloads,
'{SONG_LOFI_DCOUNT}' => $_row->lofi_downloads,
'{SONG_STREAM_COUNT}' => $_row->total_stream,
'{SONG_DOWNLOAD_COUNT}' => $_row->total_download,
'{SONG_TOTAL_COUNT}' => $_row->total_count
);
}

echo "<center>\n<table cellpadding=0 cellspacing=2>";

echo "<tr>";
echo "<td colspan=5><font size='+1'<a href='".$jamroom_url."/bands/{$_rep2['{BAND_ID}']}/' target=_blank>{$_rep2['{BAND_NAME}']}</a></td>";
echo "</tr>";
echo "<tr>";
echo "<td width=05% colspan=5>";
echo "<table width=50% cellpadding=0 cellspacing=0 border=0><tr>";
echo "<td width=02%><a href='".$jamroom_url."/bands/{$_rep2['{BAND_ID}']}/' target=_blank>";
echo "<img src='{$_rep2['{BAND_IMAGE}']}&width=136&height=78' width=136 height=78 border=0></a></td>";
echo "</tr></table>";
echo "</td>";
echo "</tr>";
echo "<tr bgcolor='#999999'>";
echo "<td width=01%><b>Hi</b></td>
  <td width=01%><b>Lo</b></td>
  <td width=05%><b>Song</b></td>
  <td width=05%><b>Genre</b></td>
</tr>";

echo "
<tr>
  <td width=01%><center>{$_rep['{SONG_HIFI_PLAY_IMAGE}']}</center></td>
  <td width=01%><center>{$_rep['{SONG_LOFI_PLAY_IMAGE}']}</center></td>
  <td width=05%>&quot;{$_rep2['{SONG_NAME}']}&quot;</td>
  <td width=05%>{$_rep2['{SONG_GENRE}']}</td>
</tr>";



echo "</table>";

?>



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

Back to top
werkkrew



Joined: 20 Feb 2004
Posts: 126
Location: Phildadelphia, PA USA
Posted: 08/15/04 09:03 
I updated the downloadable module with this fix...sorry it took me so long to address, it only took me 2 minutes to do....let me know if it works.


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

Back to top
musicmaker



Joined: 30 Jun 2004
Posts: 14
Location: Atlanta, Ga.
Posted: 08/15/04 09:51 
Laughing Works perfect.... Thanks for your quick response and thanks again werkrew for the modules.

Peace
Back to top
Display posts from previous:   
User Support Forum Archive (Read Only)
User Documentation and How To's
< Previous12345...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.