<?
// 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' );
////Database Parameters
$useDatabase = $params->get( 'useDB' );
$db_user = $params->get( 'db_user' );
$db_password = $params->get( 'db_password' );
$db_name = $params->get( 'db_name' );
$db_path = $params->get( 'db_path' );
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");
$res = mysql_query($query);
$rows = array();
while ($row = mysql_fetch_object( $res )) {
$rows[] = $row;
}
mysql_free_result( $res );
}
echo "<table cellpadding='0' border='0'>";
foreach($rows as $row) {
if(strlen($row->song_name) > $max_words) {
$row->song_name = substr($row->song_name,0,($max_words - 3));
$row->song_name .= "...";
}
if($link_type == 1 || $link_type == 3 || $link_type == 4)
{
$link = $band_url."bands/".$row->band_id."/index.php";
if($link_type == 3 || $link_type == 4) $link2 = $band_url."play.php?band_id=".$row->band_id."&song_id=".$row->song_id."&mode=song_hifi";
if($link_type == 4) $link3 = $band_url."rating.php?mode=rate_song&band_id=".$row->band_id."&song_id=".$row->song_id;
} else {
$link = $band_url."play.php?band_id=".$row->band_id."&song_id=".$row->song_id."&mode=song_hifi";
}
echo "<tr>";
echo "<td><img src='".$bullet_img."' /></td>";
echo "<td><b><a href='".$link."' target='_blank' class='".$main_link_style."'>".$row->song_name."</a></b>";
echo "</td></tr>";
if($link_type == 3 || $link_type == 4){
echo "<tr valign=top><td></td><td><a href='".$link2."' class='".$sub_link_style."'><small>Play It!</small></a>";
if($link_type == 4) echo " || <a href='".$link3."' onclick=\"popwin(this.href,'name','500','500','yes');return false\" class='".$sub_link_style."'><small>Rate It!</small></a>";
echo "</td></tr>";
}
}
echo "</table>";
?>
