[mxbb-commits] mx_music/includes music_media_cat.php, NONE, 1.1 music_pic_cat.php, NONE, 1.1 music_cat.php, 1.6, 1.7 music_comment.php, 1.2, 1.3 music_comment_delete.php, 1.2, 1.3 music_comment_edit.php, 1.2, 1.3 music_page.php, 1.5, 1.6 music_rss.php, 1.1, 1.2 music_song.php, 1.3, 1.4 music_upload.php, 1.4, 1.5

[OryNider <ory...@us...>]

Update of /cvsroot/mxbb/mx_music/includes
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv24024/includes

Modified Files:
	music_cat.php music_comment.php music_comment_delete.php 
	music_comment_edit.php music_page.php music_rss.php 
	music_song.php music_upload.php 
Added Files:
	music_media_cat.php music_pic_cat.php 
Log Message:


Index: music_upload.php
===================================================================
RCS file: /cvsroot/mxbb/mx_music/includes/music_upload.php,v
retrieving revision 1.4
retrieving revision 1.5
diff -C2 -d -r1.4 -r1.5
*** music_upload.php	1 Sep 2007 05:38:52 -0000	1.4
--- music_upload.php	5 Sep 2007 23:37:48 -0000	1.5
***************
*** 584,605 ****
  	if( empty($song_url) )
  	{
! 	$ini_val = ( @phpversion() >= '4.0.0' ) ? 'ini_get' : 'get_cfg_var';
  
! 	if ( @$ini_val('open_basedir') != '' )
! 	{
! 		if ( @phpversion() < '4.0.3' )
  		{
! 			mx_message_die(GENERAL_ERROR, 'open_basedir is set and your PHP version does not allow move_uploaded_file<br /><br />Please contact your server admin', '', __LINE__, __FILE__);
  		}
  
! 		$move_file = 'move_uploaded_file';
! 	}
! 	else
! 	{
! 		$move_file = 'copy';
! 	}
! 	$move_file($filetmp, MUSIC_UPLOAD_PATH . $song_filename);
  
! 	@chmod(MUSIC_UPLOAD_PATH . $song_filename, 0777);
  	}
  
--- 584,606 ----
  	if( empty($song_url) )
  	{
! 		$ini_val = ( @phpversion() >= '4.0.0' ) ? 'ini_get' : 'get_cfg_var';
  
! 		if ( @$ini_val('open_basedir') != '' )
  		{
! 			if ( @phpversion() < '4.0.3' )
! 			{
! 				mx_message_die(GENERAL_ERROR, 'open_basedir is set and your PHP version does not allow move_uploaded_file<br /><br />Please contact your server admin', '', __LINE__, __FILE__);
! 			}
! 
! 			$move_file = 'move_uploaded_file';
! 		}
! 		else
! 		{
! 			$move_file = 'copy';
  		}
  
! 		$move_file($filetmp, MUSIC_UPLOAD_PATH . $song_filename);
  
! 		@chmod(MUSIC_UPLOAD_PATH . $song_filename, 0777);
  	}
  

Index: music_comment_edit.php
===================================================================
RCS file: /cvsroot/mxbb/mx_music/includes/music_comment_edit.php,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** music_comment_edit.php	1 Aug 2007 23:33:27 -0000	1.2
--- music_comment_edit.php	5 Sep 2007 23:37:47 -0000	1.3
***************
*** 15,51 ****
  }
  
- //
- // Let's include some stuff...
- //
- $phpEx = substr(strrchr(__FILE__, '.'), 1);
- 
- if ( !defined('TEMPLATE_ROOT_PATH') )
- {
- 	include_once($mx_root_path . 'common.' . $phpEx);
- 
- 	//
- 	// Start session management
- 	//
- 	$mx_user->init($user_ip, PAGE_INDEX); 
- 	//
- 	// End session management
- 	//
- }
- 
- 
- $music_root_path = $module_root_path . 'music_box/';
- 
- //
- // Get general music information
- //
- if ( !$is_block )
- {
- 	include($music_root_path . 'music_common.'.$phpEx);
- }
- else
- {
- 	include_once($music_root_path . 'music_common.'.$phpEx);
- }
- 
  // ------------------------------------
  // Check feature enabled
--- 15,18 ----

--- NEW FILE: music_pic_cat.php ---
<?php
/**
*
* @package mxBB Portal Module - mx_music
* @version $Id: music_pic_cat.php,v 1.1 2007/09/05 23:37:49 orynider Exp $
* @copyright (c) 2003 [ory...@rd..., OryNider] mxBB Development Team
* @license http://opensource.org/licenses/gpl-license.php GNU General Public License v2
*
*/

//mxBB
if ( !defined('IN_PORTAL') )
{
	die("Hacking attempt");
}

// ------------------------------------
// Check the request
// ------------------------------------
if( isset($HTTP_POST_VARS['cat_id']) )
{
	$cat_id = intval($HTTP_POST_VARS['cat_id']);
}
else if( isset($HTTP_GET_VARS['cat_id']) )
{
	$cat_id = intval($HTTP_GET_VARS['cat_id']);
}
else
{
	mx_message_die(GENERAL_ERROR, 'No categories specified');
}
//
// END check request
//

// ------------------------------------
// Get this cat info
// ------------------------------------
$sql = "SELECT c.*, COUNT(s.song_id) AS count
		FROM ". MUSIC_CAT_TABLE ." AS c LEFT JOIN ". MUSIC_TABLE ." AS s ON c.cat_id = s.song_cat_id
		WHERE c.cat_id <> 0
		GROUP BY c.cat_id
		ORDER BY cat_order";
if( !($result = $db->sql_query($sql)) )
{
	mx_message_die(GENERAL_ERROR, 'Could not query category information', '', __LINE__, __FILE__, $sql);
}

$thiscat = array(); // this category
$catrows = array(); // all categories for jumpbox

while( $row = $db->sql_fetchrow($result) )
{
	$music_user_access = music_user_access($row['cat_id'], $row, 1, 0, 0, 0, 0, 0); // VIEW
	if ($music_user_access['view'] == 1)
	{
		$catrows[] = $row;

		if( $row['cat_id'] == $cat_id )
		{
			$thiscat = $row;
			$auth_data = music_user_access($cat_id, $row, 1, 1, 1, 1, 1, 1); // ALL
			$total_songs = $thiscat['count'];
		}
	}

}

if (empty($thiscat))
{
	mx_message_die(GENERAL_MESSAGE, $lang['Category_not_exist']);
}

$cat_parent = $thiscat['cat_parent'];

if ($cat_parent != 0) 
{ 
	$sql = "SELECT cat_id,cat_title 
                FROM ". MUSIC_CAT_TABLE ." 
                WHERE cat_id = $cat_parent"; 
	if ( $result = $db->sql_query($sql) ) 
	{
		$thiscat_parent = array();
		$thiscat_parent = $db->sql_fetchrow($result); 

		$template->assign_vars(array( 
				'U_VIEW_CAT_PARENT' => append_sid(this_mo_mxurl("c=" . $thiscat_parent['cat_id'])),
				'CAT_PARENT_TITLE' => $thiscat_parent['cat_title'],
				'CAT_PARENT' => $thiscat_parent['cat_id']) 
		);
 	} 
} 
//
// END cat info
//

// ------------------------------------
// Check permissions
// ------------------------------------
if( !$auth_data['view'] )
{
	if (!$userdata['session_logged_in'])
	{
		mx_redirect(append_sid($mx_root_path . "login.php?redirect=" . this_mo_loginurl("music_mode=music_pic_cat&amp;cat_id=$cat_id"), true));		
	}
	else
	{
		mx_message_die(GENERAL_ERROR, $lang['Not_Authorised']);
	}
}

if ( $auth_data['upload'] )
{
	$enable_soung_upload_switch = true;
	$template->assign_block_vars('enable_soung_upload', array());
}
//
// END check permissions
//

// ------------------------------------
// Build Auth List
// ------------------------------------
$auth_key = array_keys($auth_data);

$auth_list = '';
for ($i = 0; $i < (count($auth_data) - 1); $i++) // ignore MODERATOR in this loop
{
	//
	// we should skip a loop if RATE and COMMENT is disabled
	//
	if( ( ($music_config['rate'] == 0) and ($auth_key[$i] == 'rate') ) or ( ($music_config['comment'] == 0) and ($auth_key[$i] == 'comment') ) )
	{
		continue;
	}

	$auth_list .= ($auth_data[$auth_key[$i]] == 1) ? $lang['Music_'. $auth_key[$i] .'_can'] : $lang['Music_'. $auth_key[$i] .'_cannot'];
	$auth_list .= '<br />';
}

// add Moderator Control Panel here
if( ($userdata['user_level'] == ADMIN) or ($auth_data['moderator'] == 1) )
{
	$auth_list .= sprintf($lang['Music_moderate_can'], '<a href="'. append_sid(this_mo_mxurl("music_mode=music_modcp&cat_id=$cat_id")) .'">', '</a>');
}
//
// END Auth List
//


// ------------------------------------
// Build Moderators List
// ------------------------------------

$grouprows = array();
$moderators_list = '';

if ($thiscat['cat_moderator_groups'] != '')
{
	// Get the namelist of moderator usergroups
	$sql = "SELECT group_id, group_name, group_type, group_single_user
			FROM " . GROUPS_TABLE . "
			WHERE group_single_user <> 1
				AND group_type <> ". GROUP_HIDDEN ."
				AND group_id IN (". $thiscat['cat_moderator_groups'] .")
			ORDER BY group_name ASC";
	if ( !$result = $db->sql_query($sql) )
	{
		mx_message_die(GENERAL_ERROR, 'Could not get group list', '', __LINE__, __FILE__, $sql);
	}

	while( $row = $db->sql_fetchrow($result) )
	{
		$grouprows[] = $row;
	}

	if( count($grouprows) > 0 )
	{
		for ($j = 0; $j < count($grouprows); $j++)
		{
			$group_link = '<a href="'. append_sid($phpbb_root_path . "groupcp.$phpEx?". POST_GROUPS_URL .'='. $grouprows[$j]['group_id']) .'">'. $grouprows[$j]['group_name'] .'</a>';

			$moderators_list .= ($moderators_list == '') ? $group_link : ', ' . $group_link;
		}
	}
}

if( empty($moderators_list) )
{
	$moderators_list = $lang['None'];
}
//
// END Moderator List
//

// ------------------------------------
// Build the thumbnail page
// ------------------------------------

if( isset($HTTP_GET_VARS['start']) )
{
	$start = intval($HTTP_GET_VARS['start']);
}
else if( isset($HTTP_POST_VARS['start']) )
{
	$start = intval($HTTP_POST_VARS['start']);
}
else
{
	$start = 0;
}

if( isset($HTTP_GET_VARS['sort_method']) )
{
	switch ($HTTP_GET_VARS['sort_method'])
	{
		case 'song_time':
			$sort_method = 'song_time';
			break;
		case 'song_title':
			$sort_method = 'song_title';
			break;
		case 'song_singer':
			$sort_method = 'song_singer';
			break;
		case 'username':
			$sort_method = 'username';
			break;
		case 'song_view_count':
			$sort_method = 'song_view_count';
			break;
		case 'rating':
			$sort_method = 'rating';
			break;
		case 'comments':
			$sort_method = 'comments';
			break;
		case 'new_comment':
			$sort_method = 'new_comment';
			break;
		default:
			$sort_method = $music_config['sort_method'];
	}
}
else if( isset($HTTP_POST_VARS['sort_method']) )
{
	switch ($HTTP_POST_VARS['sort_method'])
	{
		case 'song_time':
			$sort_method = 'song_time';
			break;
		case 'song_title':
			$sort_method = 'song_title';
			break;
		case 'song_singer':
			$sort_method = 'song_singer';
			break;
		case 'username':
			$sort_method = 'username';
			break;
		case 'song_view_count':
			$sort_method = 'song_view_count';
			break;
		case 'rating':
			$sort_method = 'rating';
			break;
		case 'comments':
			$sort_method = 'comments';
			break;
		case 'new_comment':
			$sort_method = 'new_comment';
			break;
		default:
			$sort_method = $music_config['sort_method'];
	}
}
else
{
	$sort_method = $music_config['sort_method'];
}

if( isset($HTTP_GET_VARS['sort_order']) )
{
	switch ($HTTP_GET_VARS['sort_order'])
	{
		case 'ASC':
			$sort_order = 'ASC';
			break;
		case 'DESC':
			$sort_order = 'DESC';
			break;
		default:
			$sort_order = $music_config['sort_order'];
	}
}
else if( isset($HTTP_POST_VARS['sort_order']) )
{
	switch ($HTTP_POST_VARS['sort_order'])
	{
		case 'ASC':
			$sort_order = 'ASC';
			break;
		case 'DESC':
			$sort_order = 'DESC';
			break;
		default:
			$sort_order = $music_config['sort_order'];
	}
}
else
{
	$sort_order = $music_config['sort_order'];
}

$music_config['cols_per_page'] = $music_config['rows_per_page'];

// Added for ministry.ro
//$music_config['rows_per_page'] = '20';
// Added for ministry.ro

$songs_per_page = $music_config['rows_per_page'] * $music_config['cols_per_page'];

if ($total_songs > 0)
{
	$limit_sql = ($start == 0) ? $songs_per_page : $start .','. $songs_per_page;

	$song_approval_sql = 'AND s.song_approval = 1';
	if ($thiscat['cat_approval'] != MUSIC_USER)
	{
		if( ($userdata['user_level'] == ADMIN) or (($auth_data['moderator'] == 1) and ($thiscat['cat_approval'] == MUSIC_MOD)) )
		{
			$song_approval_sql = '';
		}
	}

     // 
     // Update the music view counter 
     // 
	$sql = "UPDATE " . MUSIC_CAT_TABLE . " 
			SET cat_views = cat_views + 1 
			WHERE cat_id = $cat_id"; 
	if ( !$db->sql_query($sql) ) 
	{ 
		mx_message_die(GENERAL_ERROR, "Could not update music views.", '', __LINE__, __FILE__, $sql); 
	} 

	$sql = "SELECT s.song_id, s.song_title, s.song_desc, s.song_singer, s.song_user_id, s.song_user_ip, s.song_username, s.song_time, s.song_cat_id, s.song_view_count, s.song_lock, s.song_approval, u.user_id, u.username, r.rate_song_id, AVG(r.rate_point) AS rating, COUNT(DISTINCT c.comment_id) AS comments, MAX(c.comment_id) as new_comment
			FROM ". MUSIC_TABLE ." AS s
				LEFT JOIN ". USERS_TABLE ." AS u ON s.song_user_id = u.user_id
				LEFT JOIN ". MUSIC_RATE_TABLE ." AS r ON s.song_id = r.rate_song_id
				LEFT JOIN ". MUSIC_COMMENT_TABLE ." AS c ON s.song_id = c.comment_song_id
			WHERE s.song_cat_id = '$cat_id' $song_approval_sql
			GROUP BY s.song_id
			ORDER BY $sort_method $sort_order
			LIMIT $limit_sql";
	if( !($result = $db->sql_query($sql)) )
	{
		mx_message_die(GENERAL_ERROR, 'Could not query songs information', '', __LINE__, __FILE__, $sql);
	}

	$songrow = array();

	while( $row = $db->sql_fetchrow($result) )
	{
		$songrow[] = $row;
	}

	for ($i = 0; $i < count($songrow); $i += $music_config['cols_per_page'])
	{
		$template->assign_block_vars('songrow', array());

		for ($j = $i; $j < ($i + $music_config['cols_per_page']); $j++)
		{
			if( $j >= count($songrow) )
			{
				break;
			}

			if(!$songrow[$j]['rating'])
			{
				$songrow[$j]['rating'] = $lang['Not_rated'];
			}
			else
			{
				$songrow[$j]['rating'] = round($songrow[$j]['rating'], 2);
			}

			$approval_link = '';

			if ($thiscat['cat_approval'] != MUSIC_USER)
			{
				if( ($userdata['user_level'] == ADMIN) or (($auth_data['moderator'] == 1) and ($thiscat['cat_approval'] == MUSIC_MOD)) )
				{
					$approval_mode = ($songrow[$j]['song_approval'] == 0) ? 'approval' : 'unapproval';

					$approval_link .= '<a href="'. append_sid(this_mo_mxurl("music_mode=music_modcp&mode=$approval_mode&amp;song_id=". $songrow[$j]['song_id'])) .'">';

					$approval_link .= ($songrow[$j]['song_approval'] == 0) ? '<b>'. $lang['Approve'] .'</b>' : $lang['Unapprove'];

					$approval_link .= '</a>';
				}
			}

			$template->assign_block_vars('songrow.songcol', array(
				'U_SONG' => append_sid(this_mo_mxurl("music_mode=music_page&song_id=". $songrow[$j]['song_id'])),
				'DESC' => $songrow[$j]['song_desc'],
				'APPROVAL' => $approval_link,
				)
			);

			if( ($songrow[$j]['user_id'] == MUSIC_GUEST) or ($songrow[$j]['username'] == '') )
			{
				$song_poster = ($songrow[$j]['song_username'] == '') ? $lang['Guest'] : $songrow[$j]['song_username'];
			}
			else
			{
				$song_poster = '<a href="'. append_sid($phpbb_root_path . "profile.$phpEx?mode=viewprofile&amp;". POST_USERS_URL .'='. $songrow[$j]['user_id']) .'">'. $songrow[$j]['username'] .'</a>';
			}

			// ------------------------------------
			// Get this song info
			// ------------------------------------

			$song_id = $songrow[$j]['song_id']; 

			$sql = "SELECT s.*, u.user_id, u.username, r.rate_song_id, AVG(r.rate_point) AS rating, COUNT(DISTINCT c.comment_id) AS comments
					FROM ". MUSIC_TABLE ." AS s
						LEFT JOIN ". USERS_TABLE ." AS u ON s.song_user_id = u.user_id
						LEFT JOIN ". MUSIC_RATE_TABLE ." AS r ON s.song_id = r.rate_song_id
						LEFT JOIN ". MUSIC_COMMENT_TABLE ." AS c ON s.song_id = c.comment_song_id
					WHERE song_id = '$song_id'
					GROUP BY s.song_id";
			if( !($result = $db->sql_query($sql)) )
			{
				mx_message_die(GENERAL_ERROR, 'Could not query song information', '', __LINE__, __FILE__, $sql);
			}
			$thissong = $db->sql_fetchrow($result);

			$cat_id = $thissong['song_cat_id'];
			$user_id = $thissong['song_user_id'];

			if ( $thissong['song_url'] == '' )
			{
				$song_filetype = substr($thissong['song_filename'], strlen($thissong['song_filename']) - 3, 3);
				$song_filename = ( !empty($thissong['song_filename']) ? $thissong['song_filename'] : '' );
			}
			else
			{
				$song_filetype = substr($thissong['song_url'], strlen($thissong['song_url']) - 3, 3);
				$song_url = $thissong['song_url'];
			}

			//
			// Media Center
			//
			if ( $song_filetype == 'swf' )
			{
				$template->assign_block_vars('songrow.flash', array());
				$url_download = append_sid(this_mo_mxurl("music_mode=music_download&song_id=$song_id"));
				$url_video = $url_download;
				$row_type = 'flash';
			}
			else if ( $song_filetype == 'ram' )
			{
				$template->assign_block_vars('songrow.ram', array());
				$url_download = append_sid(this_mo_mxurl("music_mode=music_download&song_id=$song_id"));
				$url_video = $url_download;
				$row_type = 'ram';
			}
			else if ( $song_filetype == '.rm' )
			{
				$template->assign_block_vars('songrow.rm', array());
				$url_download = append_sid(this_mo_mxurl("music_mode=music_download&song_id=$song_id"));
				$url_video = $url_download;
				$row_type = 'rm';
			}
			else if ( $song_filetype == '.qt' )
			{
				$template->assign_block_vars('songrow.qt', array());
				$url_download = append_sid(this_mo_mxurl("music_mode=music_download&song_id=$song_id"));
				$url_video = $url_download;
				$row_type = 'qt';
			}
			else if ( ( $song_filetype == '.jpg' ) || ( $song_filetype == '.gif' ) || ( $song_filetype == '.png' ) )
			{
				$url_download = !empty($thissong['song_url']) ? $thissong['song_url'] : append_sid(this_mo_mxurl("music_mode=music_download&song_id=$song_id"));
				$url_video = $url_download;
				$row_type = 'img';

				$template->assign_block_vars('songrow.img', array(
					'VIDEO_URL' => $url_video,
					'SONG_URL' => $url_video
				));
			}
			else if ( ( $song_filetype == 'jpg' ) || ( $song_filetype == 'gif' ) || ( $song_filetype == 'png' ) )
			{
				$url_download = !empty($thissong['song_url']) ? $thissong['song_url'] : append_sid(this_mo_mxurl("music_mode=music_download&song_id=$song_id"));
				$url_video = $url_download;
				$row_type = 'img';

				$template->assign_block_vars('songrow.img', array(
					'VIDEO_URL' => $url_video,
					'SONG_URL' => $url_video
				));
			}
			else if( ($song_filetype == 'pls') && !empty($thissong['song_url']) )
			{
				$template->assign_block_vars('songrow.media', array());
				$url_download = append_sid($module_root_path . 'galerie_media.' . $phpEx . '?music_mode=music_stream&song_id=' . $song_id);
				$lang['Download'] = ( !empty($lang['Listen']) ? $lang['Listen'] : 'Listen URL' );
				$url_video = $url_download;
				$row_type = 'media';
			}
			else if(!empty($thissong['song_url']))
			{
				$host = explode("//", $thissong['song_url']);
				$host = $host[1];
				$host = explode("/", $host);
				$domain = $host[0];
				$counthost = count($host) - 1;
				$docid2 = $host[$counthost];
			
				// $domaintmp = explode(".", $domain, -1); // Php 5 only
				// $sitename = implode(".", $domaintmp);

				if( !function_exists('mx_music_sitename') )
				{
					function mx_music_sitename($domain) {
					  $domaintmp = explode(".", $domain);
							
					  $y = count($domaintmp) - 1;
					  $r = "";
					  for ($a = 0; $y > $a; $a++) {
					  $r .= ".".$domaintmp[$a];
					  }
					  return $r;
					}
				}
			
				$sitename = substr(mx_music_sitename($domain), 1);

				if( !function_exists('mx_music_sitesufix') )
				{
					function mx_music_sitesufix($domain) {
				  	  $domaintmp = explode(".", $domain);
				
				  	  $y = count($domaintmp) - 1;
					  $r = $domaintmp[$y];;
					  return $r;
					}
				}
			
				$sitesufix = mx_music_sitesufix($domain);
			
				if (!empty($sitesufix) )
			 	{
					if ($sitesufix == 'de')
			 		{
						$sitelngprefix = 'de.';
					}
					else
			 		{
						$sitelngprefix = 'en.';
					}
				}
				else
			 	{
					$sitelngprefix = '';
				}
			
				if ($sitename == 'video.google')
				{
					$videoid['song_url'] = explode("-", $thissong['song_url']);
			
					if (empty($videoid['song_url'][1]) )
			 		{
						$docid['song_url'] = explode("?", $thissong['song_url']);
			
						if (empty($docid['song_url'][1]) )
			 			{
							$template->assign_block_vars('songrow.flashvideo', array());
							$url_video = ( !empty($docid['song_url'][1]) ? 'http://' . $domain . '/googleplayer.swf?' . $docid['song_url'][1] : $thissong['song_url'] );
							$url_download = ( !empty($docid['song_url'][1]) ? 'http://' . $domain . '/videoplay?' . $docid['song_url'][1] : $thissong['song_url'] );
							$lang['Download'] = ( !empty($lang['Share']) ? $lang['Share'] : 'Share URL' );
							$row_type = 'flashvideo';
						}
						else
			 			{
							$template->assign_block_vars('songrow.youtube', array());
							$url_video = ( !empty($docid['song_url'][1]) ? 'http://' . $domain . '/googleplayer.swf?' . $docid['song_url'][1] : $thissong['song_url'] );
							$url_download = ( !empty($docid['song_url'][1]) ? 'http://' . $domain . '/videoplay?' . $docid['song_url'][1] : $thissong['song_url'] );
							$lang['Download'] = ( !empty($lang['Share']) ? $lang['Watch'] : 'Watch URL' );
							$row_type = 'youtube';
						}
					}
					else
			 		{
						$template->assign_block_vars('songrow.youtube', array());
						$url_video = ( !empty($videoid['song_url'][1]) ? 'http://' . $domain . '/googleplayer.swf?docId=-' . $videoid['song_url'][1] : $thissong['song_url'] );
						$url_download = ( !empty($videoid['song_url'][1]) ? 'http://' . $domain . '/videoplay?docid=-' . $videoid['song_url'][1] : $thissong['song_url'] );
						$lang['Download'] = ( !empty($lang['Watch']) ? $lang['Watch'] : 'Watch URL' );
						$row_type = 'youtube';
					}	
				}
				else if ( ($sitename == 'www.youtube') || ($sitename == 'youtube') )
				{
					$videoid['song_url'] = explode("=", $thissong['song_url']);
			
					if (empty($videoid['song_url'][1]) )
			 		{
						$template->assign_block_vars('songrow.flashvideo', array());
						$row_type = 'flashvideo';
					}
					else
					{
						$template->assign_block_vars('songrow.youtube', array(
							'VIDEO_URL' => 'http://' . $domain . '/v/' . $videoid['song_url'][1],
							'SONG_URL' => $thissong['song_url']
						));
						$row_type = 'youtube';
					}
			
					$url_download = append_sid($thissong['song_url']);
					$lang['Download'] = ( !empty($lang['Share']) ? $lang['Share'] : 'Share URL' );
					$url_video = ( !empty($videoid['song_url'][1]) ? 'http://' . $domain . '/v/' . $videoid['song_url'][1] : $url_download );
				}
				else if ( ($sitename == 'www.clipfish') || ($sitename == 'clipfish') )
				{
					$thisvid['song_url'] = explode("videoid", $thissong['song_url']);
					$videoid['song_url'] = explode("=", $thisvid['song_url'][1]);
			
					if (empty($videoid['song_url'][1]) )
			 		{
						$template->assign_block_vars('songrow.flashvideo', array());
			
						$url_download = append_sid($thissong['song_url']);
						$lang['Download'] = ( !empty($lang['Direct_url']) ? $lang['Direct_url'] : 'Direct URL' );
						$url_video = $url_download;
						$row_type = 'flashvideo';
					}
					else
					{
						$template->assign_block_vars('songrow.youtube', array());
			
						$url_download = ( !empty($videoid['song_url'][1]) ? 'http://' . $domain . '/player.php?videoid=' . $videoid['song_url'][1] : $thissong['song_url'] );
						$lang['Download'] = ( !empty($lang['Watch']) ? $lang['Watch'] : 'Watch URL' );
						$url_video = ( !empty($videoid['song_url'][1]) ? 'http://' . $domain . '/videoplayer.swf?as=0&videoid=' . $videoid['song_url'][1] : $url_download );
						$row_type = 'youtube';
					}
			
				}
				else if ( ($sitename == 'www.myvideo') || ($sitename == 'myvideo') )
				{
					if (empty($docid2) )
			 		{
						$template->assign_block_vars('songrow.flashvideo', array());
			
						$url_download = append_sid($thissong['song_url']);
						$lang['Download'] = ( !empty($lang['Direct_url']) ? $lang['Direct_url'] : 'Direct URL' );
						$url_video = $url_download;
						$row_type = 'flashvideo';
					}
					else
					{
						$template->assign_block_vars('songrow.youtube', array());
			
						$url_download = ( !empty($docid2) ? 'http://' . $domain . '/watch/' . $docid2 : $thissong['song_url'] );
						$lang['Download'] = ( !empty($lang['Share']) ? $lang['Share'] : 'Share URL' );
						$url_video = ( !empty($docid2) ? 'http://' . $domain . '/movie/' . $docid2 : $url_download ); 
						$row_type = 'youtube';
					}
				}
				else if ( ($sitename == 'de.sevenload') || ($sitename == 'sevenload') || ($sitename == 'page.sevenload') || ($sitename == 'www.sevenload') )
				{
					$videoid['song_url'] = explode("=", $thissong['song_url']);
			
					if (empty($videoid['song_url'][1]) )
			 		{
						if (empty($docid2) )
			 			{
							$template->assign_block_vars('songrow.flashvideo', array());
			
							$url_download = append_sid($thissong['song_url']);
							$lang['Download'] = ( !empty($lang['Direct_url']) ? $lang['Direct_url'] : 'Direct URL' );
							$url_video = $url_download;
							$row_type = 'flashvideo';
						}
						else
			 			{
							$template->assign_block_vars('songrow.youtube', array());
			
							$url_download = ( !empty($docid2) ? 'http://' . $sitelngprefix . 'sevenload.' . 'com' . '/videos/' . $docid2 : $thissong['song_url'] );
							$lang['Download'] = ( !empty($lang['Share']) ? $lang['Share'] : 'Share URL' );
							$url_video = ( !empty($docid2) ? 'http://' . $domain . '/swf/player.swf?id=' . $docid2 : $url_download ); 
							$row_type = 'youtube';
						}
					}
					else
					{
						$template->assign_block_vars('songrow.youtube', array());
			
						$url_download = ( !empty($videoid['song_url'][1]) ? 'http://' . $sitelngprefix . 'sevenload.'. 'com' . '/videos/' . $videoid['song_url'][1] : $thissong['song_url'] );
						$lang['Download'] = ( !empty($lang['Share']) ? $lang['Share'] : 'Share URL' );
						$url_video = ( !empty($videoid['song_url'][1]) ? 'http://' . $domain . '/swf/player.swf?id=' . $videoid['song_url'][1] : $url_download ); 
						$row_type = 'youtube';
					}
			
				}
				else
				{
					$template->assign_block_vars('songrow.media', array());
					$url_download = append_sid($thissong['song_url']);
					$lang['Download'] = ( !empty($lang['Direct_url']) ? $lang['Direct_url'] : 'Direct URL' );
					$url_video = $url_download;
					$row_type = 'media';
				}
			}
			else
			{
				$template->assign_block_vars('songrow.media', array());
				//$url_download = append_sid($module_root_path . 'galerie_media.' . $phpEx . '?music_mode=music_download&song_id=' . $song_id);
				$url_download = append_sid(this_mo_mxurl("music_mode=music_download&song_id=" . $song_id));
				$url_video = $url_download;
				$row_type = 'media';
			}

			switch ($row_type)
			{
				case 'img':
					$switch_row_type = 'img'; 
					break;

				default:
					$switch_row_type = 'media'; 
			}

			$url_song = append_sid(this_mo_mxurl("music_mode=music_song&song_id=" . $song_id, true));

			$template->assign_block_vars('songrow.song_detail', array(
				'TITLE' => '<a href="'. append_sid(this_mo_mxurl("music_mode=music_page&song_id=". $songrow[$j]['song_id'])) . '">' . $songrow[$j]['song_title'] . '</a>',

				'U_SONG' => $url_song,

				'SONG_TITLE' => $thissong['song_title'],

				'SONG_URL' => !empty($thissong['song_url']) ? $thissong['song_url'] : append_sid(this_mo_mxurl("music_mode=music_song&song_id=" . $songrow[$j]['song_id'], true)),

				'SONG_THUMB_URL' => !empty($thissong['song_url']) ? $thissong['song_url'] : append_sid(this_mo_mxurl("music_mode=music_song&song_id=" . $songrow[$j]['song_id'] . "&item_size=114", true)),

				'SONG_FULL_URL' => !empty($thissong['song_url']) ? $thissong['song_url'] : append_sid(this_mo_mxurl("music_mode=music_song&song_id=" . $songrow[$j]['song_id'] . "&item_size=800", true)),

				'VIDEO_URL' => $url_video,

				'SINGER' => $songrow[$j]['song_singer'],

				'POSTER' => $song_poster,

				'WIDTH' => ( !empty($media_width) ? $media_width : '425' ),

				'HEIGHT' => ( !empty($media_height) ? $media_height : '350' ),

				'TIME' => create_date($board_config['default_dateformat'], $songrow[$j]['song_time'], $board_config['board_timezone']),

				'VIEW' => $songrow[$j]['song_view_count'],

				'RATING' => ($music_config['rate'] == 1) ? ( '<a href="'. append_sid(this_mo_mxurl("music_mode=music_rate&song_id=". $songrow[$j]['song_id']) . '">' . $songrow[$j]['rating'] . '</a>')) : '',

				'COMMENTS' => ($music_config['comment'] == 1) ? ( '<a href="'. append_sid(this_mo_mxurl("music_mode=music_comment&song_id=". $songrow[$j]['song_id'])) . '">' . $songrow[$j]['comments'] . '</a>' ) : '',

				'EDIT' => ( ( $auth_data['edit'] and ($songrow[$j]['song_user_id'] == $userdata['user_id']) ) or ($auth_data['moderator'] and ($thiscat['cat_edit_level'] != MUSIC_ADMIN) ) or ($userdata['user_level'] == ADMIN) ) ? '<a href="'. append_sid(this_mo_mxurl("music_mode=music_edit&song_id=". $songrow[$j]['song_id'])) . '">' . $lang['Edit_song'] . '</a>' : '',

				'DELETE' => ( ( $auth_data['delete'] and ($songrow[$j]['song_user_id'] == $userdata['user_id']) ) or ($auth_data['moderator'] and ($thiscat['cat_delete_level'] != MUSIC_ADMIN) ) or ($userdata['user_level'] == ADMIN) ) ? '<a href="'. append_sid(this_mo_mxurl("music_mode=music_delete&song_id=". $songrow[$j]['song_id'])) . '">' . $lang['Delete_song'] . '</a>' : '',

				'MOVE' => ($auth_data['moderator']) ? '<a href="'. append_sid(this_mo_mxurl("music_mode=music_modcp&mode=move&amp;song_id=". $songrow[$j]['song_id'])) .'">'. $lang['Move'] .'</a>' : '',

				'LOCK' => ($auth_data['moderator']) ? '<a href="'. append_sid(this_mo_mxurl("music_mode=music_modcp&mode=". (($songrow[$j]['song_lock'] == 0) ? 'lock' : 'unlock') ."&amp;song_id=". $songrow[$j]['song_id'])) .'">'. (($songrow[$j]['song_lock'] == 0) ? $lang['Lock'] : $lang['Unlock']) .'</a>' : '',

				'IP' => ($userdata['user_level'] == ADMIN) ? $lang['IP_Address'] . ': <a href="http://www.nic.com/cgi-bin/whois.cgi?query=' . decode_ip($songrow[$j]['song_user_ip']) . '" target="_blank">' . decode_ip($songrow[$j]['song_user_ip']) .'</a><br />' : '',

				'S_ROW_TYPE' => $row_type)
			);
		}
	}

	//$total_media = count($switch_row_type == 'media');
	//$total_images = count($switch_row_type == 'img');

	$total_images = $total_songs;

	$template->assign_vars(array(
		'PAGINATION' => generate_pagination(append_sid(this_mo_mxurl("music_mode=music_pic_cat&cat_id=$cat_id&amp;sort_method=$sort_method&amp;sort_order=$sort_order")), $total_images, $songs_per_page, $start),
		'PAGE_NUMBER' => sprintf($lang['Page_of'], ( floor( $start / $songs_per_page ) + 1 ), ceil( $total_images / $songs_per_page ))
		)
	);
}
else
{
	$template->assign_block_vars('no_songs', array());
}
//
// END thumbnails table
//

// ------------------------------------
// Build Jumpbox - based on $catrows which was created at the top of this file
// ------------------------------------
$music_jumpbox = '<form name="jumpbox" action="'. append_sid(this_mo_mxurl("music_mode=music_pic_cat")) .'" method="get">';
$music_jumpbox .= $lang['Jump_to'] . ':&nbsp;<select name="cat_id" onChange="forms[\'jumpbox\'].submit()">';
for ($i = 0; $i < count($catrows); $i++)
{
	$music_jumpbox .= '<option value="'. $catrows[$i]['cat_id'] .'"';
	$music_jumpbox .= ($catrows[$i]['cat_id'] == $cat_id) ? 'selected="selected"' : '';
	$music_jumpbox .= '>' . $catrows[$i]['cat_title'] .'</option>';
}
$music_jumpbox .= '</select>';
$music_jumpbox .= '&nbsp;<input type="submit" class="liteoption" value="'. $lang['Go'] .'" />';
$music_jumpbox .= '<input type="hidden" name="sid" value="'. $userdata['session_id'] .'" />';
$music_jumpbox .= '</form>';
//
// END build jumpbox
//

// ------------------------------------
// additional sorting options
// ------------------------------------

$sort_rating_option = '';
$sort_comments_option = '';
if( $music_config['rate'] == 1 )
{
	$sort_rating_option = '<option value="rating" ';
	$sort_rating_option .= ($sort_method == 'rating') ? 'selected="selected"' : '';
	$sort_rating_option .= '>' . $lang['Rating'] .'</option>';
}
if( $music_config['comment'] == 1 )
{
	$sort_comments_option = '<option value="comments" ';
	$sort_comments_option .= ($sort_method == 'comments') ? 'selected="selected"' : '';
	$sort_comments_option .= '>' . $lang['Comments'] .'</option>';

	$sort_new_comment_option = '<option value="new_comment" ';
	$sort_new_comment_option .= ($sort_method == 'new_comment') ? 'selected="selected"' : '';
	$sort_new_comment_option .= '>' . $lang['New_Comment'] .'</option>';
}

//
// Start output of page
//
$page_title = $lang['Music'];
 if ( !$is_block )
 {
	include($mx_root_path . 'includes/page_header.'.$phpEx);
 }

if(!empty($template->xs_version))
{
	$template->set_filenames(array(
		'body' => 'music_pic_cat_body.tpl')
	);
}
else
{
	mx_message_die(GENERAL_ERROR, 'eXtreme Styles not installed', '', '', '');
}

$template->assign_vars(array(
	'U_VIEW_CAT' => append_sid(this_mo_mxurl("music_mode=music_cat&cat_id=$cat_id")),
	'CAT_TITLE' => $thiscat['cat_title'],

	'U_VIEW_CAT_VIRTUAL' => append_sid(this_mo_mxurl("music_mode=music_pic_cat&cat_id=$cat_id")),
	'CAT_TITLE_VIRTUAL' => $lang['Images'],

	'L_MODERATORS' => $lang['Moderators'],
	'MODERATORS' => $moderators_list,

	'U_UPLOAD_SONG' => append_sid(this_mo_mxurl("music_mode=music_upload&cat_id=$cat_id")),
	'UPLOAD_SONG_IMG' => $mx_images['upload_song'],
	'L_UPLOAD_SONG' => $lang['Upload_Song'],

	'L_CATEGORY' => $lang['Category'],
	'L_ALL_CAT_PICS' => $lang['Category_pics'],

	'L_NO_SONGS' => $lang['No_Songs'],

	'S_COLS' => $music_config['cols_per_page'],
	'S_COL_WIDTH' => (100/$music_config['cols_per_page']) . '%',

	'L_VIEW' => $lang['View'],
	'L_POSTER' => $lang['Poster'],
	'L_POSTED' => $lang['Posted'],
	'L_RATING' => $lang['Rating'],
	'L_COMMENTS' => $lang['Comments'],

	'MUSIC_JUMPBOX' => $music_jumpbox,

	'S_MUSIC_ACTION' => append_sid(this_mo_mxurl("music_mode=music_pic_cat&cat_id=$cat_id")),

	'L_SELECT_SORT_METHOD' => $lang['Select_sort_method'],
	'L_ORDER' => $lang['Order'],
	'L_SORT' => $lang['Sort'],

	'L_TIME' => $lang['Time'],
	'L_SONG_TITLE' => $lang['Song_Title'],
	'L_SINGER' => $lang['Singer'],
	'L_USERNAME' => $lang['Sort_Username'],

	'SORT_TIME' => ($sort_method == 'song_time') ? 'selected="selected"' : '',
	'SORT_SONG_TITLE' => ($sort_method == 'song_title') ? 'selected="selected"' : '',
	'SORT_SINGER' => ($sort_method == 'song_singer') ? 'selected="selected"' : '',
	'SORT_USERNAME' => ($sort_method == 'song_user_id') ? 'selected="selected"' : '',
	'SORT_VIEW' => ($sort_method == 'song_view_count') ? 'selected="selected"' : '',

	'SORT_RATING_OPTION' => $sort_rating_option,
	'SORT_COMMENTS_OPTION' => $sort_comments_option,
	'SORT_NEW_COMMENT_OPTION' => $sort_new_comment_option,

	'L_ASC' => $lang['Sort_Ascending'],
	'L_DESC' => $lang['Sort_Descending'],

	'SORT_ASC' => ($sort_order == 'ASC') ? 'selected="selected"' : '',
	'SORT_DESC' => ($sort_order == 'DESC') ? 'selected="selected"' : '',

	'NAV_SEP' => $lang['Nav_Separator'],
	'NAV_DOT' => '&#8226;',
	'MUSIC_VERSION' => '2' . $music_config['music_version'],
	'L_INDEX' => '<<',
	'U_INDEX' => append_sid($mx_root_path . "index.".$phpEx),
	'L_MUSIC_INDEX' => $lang['Music'],
	'L_MUSIC' => $lang['Music'],
	'U_MUSIC' => append_sid(this_mo_mxurl()),
	'U_MX_MUSIC' => append_sid(this_mo_portalurl()),

	'WIDTH' => ( !empty($media_width) ? $media_width : '228' ),
	'HEIGHT' => ( !empty($media_height) ? $media_height : '300' ),

	'S_AUTH_LIST' => $auth_list)
);

//
// Generate the page
//
$template->pparse('body');

 if ( !$is_block )
 {
	include($mx_root_path . 'includes/page_tail.'.$phpEx);
 }

// +------------------------------------------------------+
// |    Powered by Music Online 2.0 (c) 2003 Cf Manager   |
// +------------------------------------------------------+

//
// That's all Folks!
// --------------------
?>
Index: music_cat.php
===================================================================
RCS file: /cvsroot/mxbb/mx_music/includes/music_cat.php,v
retrieving revision 1.6
retrieving revision 1.7
diff -C2 -d -r1.6 -r1.7
*** music_cat.php	1 Sep 2007 05:38:51 -0000	1.6
--- music_cat.php	5 Sep 2007 23:37:46 -0000	1.7
***************
*** 73,76 ****
--- 73,97 ----
  	mx_message_die(GENERAL_MESSAGE, $lang['Category_not_exist']);
  }
+ 
+ $cat_parent = $thiscat['cat_parent'];
+ 
+ if ($cat_parent != 0) 
+ { 
+ 	$sql = "SELECT cat_id,cat_title 
+                 FROM ". MUSIC_CAT_TABLE ." 
+                 WHERE cat_id = $cat_parent"; 
+ 	if ( $result = $db->sql_query($sql) ) 
+ 	{
+ 		$thiscat_parent = array();
+ 		$thiscat_parent = $db->sql_fetchrow($result); 
+ 
+ 		$template->assign_vars(array( 
+ 				'U_VIEW_CAT_PARENT' => append_sid(this_mo_mxurl("c=" . $thiscat_parent['cat_id'])),
+ 				'U_NAV_CAT_PARENT' => '&nbsp;' . $lang['Nav_Separator'] . '&nbsp; <a class="nav" href="' . append_sid(this_mo_mxurl("c=" . $thiscat_parent['cat_id'])) . '">' . $thiscat_parent['cat_title'] . '</a>',
+ 				'CAT_PARENT_TITLE' => $thiscat_parent['cat_title'],
+ 				'CAT_PARENT' => $thiscat_parent['cat_id']) 
+ 		);
+  	} 
+ } 
  //
  // END cat info
***************
*** 701,705 ****
  			}
  
! 			$url_song = append_sid(this_mo_mxurl("music_mode=music_song&song_id=" . $song_id));
  
  			$template->assign_block_vars('songrow.song_detail', array(
--- 722,726 ----
  			}
  
! 			$url_song = append_sid(this_mo_mxurl("music_mode=music_song&song_id=" . $song_id, true));
  
  			$template->assign_block_vars('songrow.song_detail', array(
***************
*** 710,714 ****
  				'SONG_TITLE' => $thissong['song_title'],
  
! 				'SONG_URL' => !empty($thissong['song_url']) ? $thissong['song_url'] : append_sid(this_mo_mxurl("music_mode=music_song&song_id=" . $song_id)),
  
  				'VIDEO_URL' => $url_video,
--- 731,739 ----
  				'SONG_TITLE' => $thissong['song_title'],
  
! 				'SONG_URL' => !empty($thissong['song_url']) ? $thissong['song_url'] : append_sid(this_mo_mxurl("music_mode=music_song&song_id=" . $songrow[$j]['song_id'], true)),
! 
! 				'SONG_THUMB_URL' => !empty($thissong['song_url']) ? $thissong['song_url'] : append_sid(this_mo_mxurl("music_mode=music_song&song_id=" . $songrow[$j]['song_id'] . "&item_size=425", true)),
! 
! 				'SONG_FULL_URL' => !empty($thissong['song_url']) ? $thissong['song_url'] : append_sid(this_mo_mxurl("music_mode=music_song&song_id=" . $songrow[$j]['song_id'] . "&item_size=800", true)),
  
  				'VIDEO_URL' => $url_video,
***************
*** 718,724 ****
  				'POSTER' => $song_poster,
  
! 				'WIDTH' => ( !empty($media_width) ? $media_width : '228' ),
  
! 				'HEIGHT' => ( !empty($media_height) ? $media_height : '300' ),
  
  				'TIME' => create_date($board_config['default_dateformat'], $songrow[$j]['song_time'], $board_config['board_timezone']),
--- 743,749 ----
  				'POSTER' => $song_poster,
  
! 				'WIDTH' => ( !empty($media_width) ? $media_width : '425' ),
  
! 				'HEIGHT' => ( !empty($media_height) ? $media_height : '350' ),
  
  				'TIME' => create_date($board_config['default_dateformat'], $songrow[$j]['song_time'], $board_config['board_timezone']),

Index: music_comment_delete.php
===================================================================
RCS file: /cvsroot/mxbb/mx_music/includes/music_comment_delete.php,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** music_comment_delete.php	1 Aug 2007 23:33:27 -0000	1.2
--- music_comment_delete.php	5 Sep 2007 23:37:47 -0000	1.3
***************
*** 15,51 ****
  }
  
- //
- // Let's include some stuff...
- //
- $phpEx = substr(strrchr(__FILE__, '.'), 1);
- 
- if ( !defined('TEMPLATE_ROOT_PATH') )
- {
- 	include_once($mx_root_path . 'common.' . $phpEx);
- 
- 	//
- 	// Start session management
- 	//
- 	$mx_user->init($user_ip, PAGE_INDEX); 
- 	//
- 	// End session management
- 	//
- }
- 
- 
- $music_root_path = $module_root_path . 'music_box/';
- 
- //
- // Get general music information
- //
- if ( !$is_block )
- {
- 	include($music_root_path . 'music_common.'.$phpEx);
- }
- else
- {
- 	include_once($music_root_path . 'music_common.'.$phpEx);
- }
- 
  // ------------------------------------
  // Check feature enabled
--- 15,18 ----

Index: music_rss.php
===================================================================
RCS file: /cvsroot/mxbb/mx_music/includes/music_rss.php,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** music_rss.php	2 Sep 2007 07:38:20 -0000	1.1
--- music_rss.php	5 Sep 2007 23:37:47 -0000	1.2
***************
*** 472,475 ****
--- 472,479 ----
  		$url_comment = append_sid(PORTAL_URL . this_mo_rssurl("music_mode=music_comment&amp;" . "song_id=" . $thissong['song_id']));
  
+ 		$url_thumb_song = !empty($thissong['song_url']) ? $thissong['song_url'] : append_sid(this_mo_mxurl("music_mode=music_song&song_id=" . $thissong['song_id'] . "&item_size=425", true));
+ 
+ 		$url_full_song = !empty($thissong['song_url']) ? $thissong['song_url'] : append_sid(this_mo_mxurl("music_mode=music_song&song_id=" . $thissong['song_id'] . "&item_size=800", true));
+ 
  		switch ($row_type)
  		{
***************
*** 500,504 ****
  
  			case 'img':
! 				$html_code = '<a href="' . $url_page . '">' . '<img src="' . $url_song . '" border="1" vspace="2" hspace="2" align="left" width="425" height="350">' . '</a>';
  				$enclosure = 'url="' . $url_song . '" ' . 'type="image/png" length="1024000"';
  				break;
--- 504,508 ----
  
  			case 'img':
! 				$html_code = '<a href="' . $url_page . '">' . '<img src="' . $url_thumb_song . '" border="1" vspace="2" hspace="2" align="left" width="425" height="350">' . '</a>';
  				$enclosure = 'url="' . $url_song . '" ' . 'type="image/png" length="1024000"';
  				break;

--- NEW FILE: music_media_cat.php ---
<?php
/**
*
* @package mxBB Portal Module - mx_music
* @version $Id: music_media_cat.php,v 1.1 2007/09/05 23:37:48 orynider Exp $
* @copyright (c) 2003 [ory...@rd..., OryNider] mxBB Development Team
* @license http://opensource.org/licenses/gpl-license.php GNU General Public License v2
*
*/

//mxBB
if ( !defined('IN_PORTAL') )
{
	die("Hacking attempt");
}

$music_root_path = $module_root_path . 'music_box/';

// ------------------------------------
// Check the request
// ------------------------------------
if( isset($HTTP_POST_VARS['cat_id']) )
{
	$cat_id = intval($HTTP_POST_VARS['cat_id']);
}
else if( isset($HTTP_GET_VARS['cat_id']) )
{
	$cat_id = intval($HTTP_GET_VARS['cat_id']);
}
else
{
	mx_message_die(GENERAL_ERROR, 'No categories specified');
}
//
// END check request
//

// ------------------------------------
// Get this cat info
// ------------------------------------
$sql = "SELECT c.*, COUNT(s.song_id) AS count
		FROM ". MUSIC_CAT_TABLE ." AS c LEFT JOIN ". MUSIC_TABLE ." AS s ON c.cat_id = s.song_cat_id
		WHERE c.cat_id <> 0
		GROUP BY c.cat_id
		ORDER BY cat_order";
if( !($result = $db->sql_query($sql)) )
{
	mx_message_die(GENERAL_ERROR, 'Could not query category information', '', __LINE__, __FILE__, $sql);
}

$thiscat = array(); // this category
$catrows = array(); // all categories for jumpbox

while( $row = $db->sql_fetchrow($result) )
{
	$music_user_access = music_user_access($row['cat_id'], $row, 1, 0, 0, 0, 0, 0); // VIEW
	if ($music_user_access['view'] == 1)
	{
		$catrows[] = $row;

		if( $row['cat_id'] == $cat_id )
		{
			$thiscat = $row;
			$auth_data = music_user_access($cat_id, $row, 1, 1, 1, 1, 1, 1); // ALL
			$total_songs = $thiscat['count'];
		}
	}

}

if (empty($thiscat))
{
	mx_message_die(GENERAL_MESSAGE, $lang['Category_not_exist']);
}

$cat_parent = $thiscat['cat_parent'];

if ($cat_parent != 0) 
{ 
	$sql = "SELECT cat_id,cat_title 
                FROM ". MUSIC_CAT_TABLE ." 
                WHERE cat_id = $cat_parent"; 
	if ( $result = $db->sql_query($sql) ) 
	{
		$thiscat_parent = array();
		$thiscat_parent = $db->sql_fetchrow($result); 

		$template->assign_vars(array( 
				'U_VIEW_CAT_PARENT' => append_sid(this_mo_mxurl("c=" . $thiscat_parent['cat_id'])),
				'CAT_PARENT_TITLE' => $thiscat_parent['cat_title'],
				'CAT_PARENT' => $thiscat_parent['cat_id']) 
		);
 	} 
} 
//
// END cat info
//

// ------------------------------------
// Check permissions
// ------------------------------------
if( !$auth_data['view'] )
{
	if (!$userdata['session_logged_in'])
	{
		mx_redirect(append_sid($mx_root_path . "login.php?redirect=" . this_mo_loginurl("music_mode=music_media_cat&amp;cat_id=$cat_id"), true));		
	}
	else
	{
		mx_message_die(GENERAL_ERROR, $lang['Not_Authorised']);
	}
}

if ( $auth_data['upload'] )
{
	$enable_soung_upload_switch = true;
	$template->assign_block_vars('enable_soung_upload', array());
}
//
// END check permissions
//

// ------------------------------------
// Build Auth List
// ------------------------------------
$auth_key = array_keys($auth_data);

$auth_list = '';
for ($i = 0; $i < (count($auth_data) - 1); $i++) // ignore MODERATOR in this loop
{
	//
	// we should skip a loop if RATE and COMMENT is disabled
	//
	if( ( ($music_config['rate'] == 0) and ($auth_key[$i] == 'rate') ) or ( ($music_config['comment'] == 0) and ($auth_key[$i] == 'comment') ) )
	{
		continue;
	}

	$auth_list .= ($auth_data[$auth_key[$i]] == 1) ? $lang['Music_'. $auth_key[$i] .'_can'] : $lang['Music_'. $auth_key[$i] .'_cannot'];
	$auth_list .= '<br />';
}

// add Moderator Control Panel here
if( ($userdata['user_level'] == ADMIN) or ($auth_data['moderator'] == 1) )
{
	$auth_list .= sprintf($lang['Music_moderate_can'], '<a href="'. append_sid(this_mo_mxurl("music_mode=music_modcp&cat_id=$cat_id")) .'">', '</a>');
}
//
// END Auth List
//


// ------------------------------------
// Build Moderators List
// ------------------------------------

$grouprows = array();
$moderators_list = '';

if ($thiscat['cat_moderator_groups'] != '')
{
	// Get the namelist of moderator usergroups
	$sql = "SELECT group_id, group_name, group_type, group_single_user
			FROM " . GROUPS_TABLE . "
			WHERE group_single_user <> 1
				AND group_type <> ". GROUP_HIDDEN ."
				AND group_id IN (". $thiscat['cat_moderator_groups'] .")
			ORDER BY group_name ASC";
	if ( !$result = $db->sql_query($sql) )
	{
		mx_message_die(GENERAL_ERROR, 'Could not get group list', '', __LINE__, __FILE__, $sql);
	}

	while( $row = $db->sql_fetchrow($result) )
	{
		$grouprows[] = $row;
	}

	if( count($grouprows) > 0 )
	{
		for ($j = 0; $j < count($grouprows); $j++)
		{
			$group_link = '<a href="'. append_sid($phpbb_root_path . "groupcp.$phpEx?". POST_GROUPS_URL .'='. $grouprows[$j]['group_id']) .'">'. $grouprows[$j]['group_name'] .'</a>';

			$moderators_list .= ($moderators_list == '') ? $group_link : ', ' . $group_link;
		}
	}
}

if( empty($moderators_list) )
{
	$moderators_list = $lang['None'];
}
//
// END Moderator List
//

// ------------------------------------
// Build the thumbnail page
// ------------------------------------

if( isset($HTTP_GET_VARS['start']) )
{
	$start = intval($HTTP_GET_VARS['start']);
}
else if( isset($HTTP_POST_VARS['start']) )
{
	$start = intval($HTTP_POST_VARS['start']);
}
else
{
	$start = 0;
}

if( isset($HTTP_GET_VARS['sort_method']) )
{
	switch ($HTTP_GET_VARS['sort_method'])
	{
		case 'song_time':
			$sort_method = 'song_time';
			break;
		case 'song_title':
			$sort_method = 'song_title';
			break;
		case 'song_singer':
			$sort_method = 'song_singer';
			break;
		case 'username':
			$sort_method = 'username';
			break;
		case 'song_view_count':
			$sort_method = 'song_view_count';
			break;
		case 'rating':
			$sort_method = 'rating';
			break;
		case 'comments':
			$sort_method = 'comments';
			break;
		case 'new_comment':
			$sort_method = 'new_comment';
			break;
		default:
			$sort_method = $music_config['sort_method'];
	}
}
else if( isset($HTTP_POST_VARS['sort_method']) )
{
	switch ($HTTP_POST_VARS['sort_method'])
	{
		case 'song_time':
			$sort_method = 'song_time';
			break;
		case 'song_title':
			$sort_method = 'song_title';
			break;
		case 'song_singer':
			$sort_method = 'song_singer';
			break;
		case 'username':
			$sort_method = 'username';
			break;
		case 'song_view_count':
			$sort_method = 'song_view_count';
			break;
		case 'rating':
			$sort_method = 'rating';
			break;
		case 'comments':
			$sort_method = 'comments';
			break;
		case 'new_comment':
			$sort_method = 'new_comment';
			break;
		default:
			$sort_method = $music_config['sort_method'];
	}
}
else
{
	$sort_method = $music_config['sort_method'];
}

if( isset($HTTP_GET_VARS['sort_order']) )
{
	switch ($HTTP_GET_VARS['sort_order'])
	{
		case 'ASC':
			$sort_order = 'ASC';
			break;
		case 'DESC':
			$sort_order = 'DESC';
			break;
		default:
			$sort_order = $music_config['sort_order'];
	}
}
else if( isset($HTTP_POST_VARS['sort_order']) )
{
	switch ($HTTP_POST_VARS['sort_order'])
	{
		case 'ASC':
			$sort_order = 'ASC';
			break;
		case 'DESC':
			$sort_order = 'DESC';
			break;
		default:
			$sort_order = $music_config['sort_order'];
	}
}
else
{
	$sort_order = $music_config['sort_order'];
}

$songs_per_page = $music_config['rows_per_page'] * $music_config['cols_per_page'];

if ($total_songs > 0)
{
	$limit_sql = ($start == 0) ? $songs_per_page : $start .','. $songs_per_page;

	$song_approval_sql = 'AND s.song_approval = 1';
	if ($thiscat['cat_approval'] != MUSIC_USER)
	{
		if( ($userdata['user_level'] == ADMIN) or (($auth_data['moderator'] == 1) and ($thiscat['cat_approval'] == MUSIC_MOD)) )
		{
			$song_approval_sql = '';
		}
	}

	$sql = "SELECT s.song_id, s.song_title, s.song_desc, s.song_singer, s.song_user_id, s.song_user_ip, s.song_username, s.song_time, s.song_cat_id, s.song_view_count, s.song_lock, s.song_approval, u.user_id, u.username, r.rate_song_id, AVG(r.rate_point) AS rating, COUNT(DISTINCT c.comment_id) AS comments, MAX(c.comment_id) as new_comment
			FROM ". MUSIC_TABLE ." AS s
				LEFT JOIN ". USERS_TABLE ." AS u ON s.song_user_id = u.user_id
				LEFT JOIN ". MUSIC_RATE_TABLE ." AS r ON s.song_id = r.rate_song_id
				LEFT JOIN ". MUSIC_COMMENT_TABLE ." AS c ON s.song_id = c.comment_song_id
			WHERE s.song_cat_id = '$cat_id' $song_approval_sql
			GROUP BY s.song_id
			ORDER BY $sort_method $sort_order
			LIMIT $limit_sql";
	if( !($result = $db->sql_query($sql)) )
	{
		mx_message_die(GENERAL_ERROR, 'Could not query songs information', '', __LINE__, __FILE__, $sql);
	}

     // 
     // Update the music view counter 
     // 
           $sql = "UPDATE " . MUSIC_CAT_TABLE . " 
                  SET cat_views = cat_views + 1 
                  WHERE cat_id = $cat_id"; 
           if ( !$db->sql_query($sql) ) 
           { 
              mx_message_die(GENERAL_ERROR, "Could not update music views.", '', __LINE__, __FILE__, $sql); 
           } 

	$songrow = array();

	while( $row = $db->sql_fetchrow($result) )
	{
		$songrow[] = $row;
	}

	for ($i = 0; $i < count($songrow); $i += $music_config['cols_per_page'])
	{
		$template->assign_block_vars('songrow', array());

		for ($j = $i; $j < ($i + $music_config['cols_per_page']); $j++)
		{
			if( $j >= count($songrow) )
			{
				break;
			}

			if(!$songrow[$j]['rating'])
			{
				$songrow[$j]['rating'] = $lang['Not_rated'];
			}
			else
			{
				$songrow[$j]['rating'] = round($songrow[$j]['rating'], 2);
			}

			$approval_link = '';

			if ($thiscat['cat_approval'] != MUSIC_USER)
			{
				if( ($userdata['user_level'] == ADMIN) or (($auth_data['moderator'] == 1) and ($thiscat['cat_approval'] == MUSIC_MOD)) )
				{
					$approval_mode = ($songrow[$j]['song_approval'] == 0) ? 'approval' : 'unapproval';

					$approval_link .= '<a href="'. append_sid(this_mo_mxurl("music_mode=music_modcp&mode=$approval_mode&amp;song_id=". $songrow[$j]['song_id'])) .'">';

					$approval_link .= ($songrow[$j]['song_approval'] == 0) ? '<b>'. $lang['Approve'] .'</b>' : $lang['Unapprove'];

					$approval_link .= '</a>';
				}
			}

			$template->assign_block_vars('songrow.songcol', array(
				'U_SONG' => append_sid(this_mo_mxurl("music_mode=music_page&song_id=". $songrow[$j]['song_id'])),
				'DESC' => $songrow[$j]['song_desc'],
				'APPROVAL' => $approval_link,
				)
			);

			if( ($songrow[$j]['user_id'] == MUSIC_GUEST) or ($songrow[$j]['username'] == '') )
			{
				$song_poster = ($songrow[$j]['song_username'] == '') ? $lang['Guest'] : $songrow[$j]['song_username'];
			}
			else
			{
				$song_poster = '<a href="'. append_sid($phpbb_root_path . "profile.$phpEx?mode=viewprofile&amp;". POST_USERS_URL .'='. $songrow[$j]['user_id']) .'">'. $songrow[$j]['username'] .'</a>';
			}

			// ------------------------------------
			// Get this song info
			// ------------------------------------

			$song_id = $songrow[$j]['song_id']; 

			$sql = "SELECT s.*, u.user_id, u.username, r.rate_song_id, AVG(r.rate_point) AS rating, COUNT(DISTINCT c.comment_id) AS comments
					FROM ". MUSIC_TABLE ." AS s
						LEFT JOIN ". USERS_TABLE ." AS u ON s.song_user_id = u.user_id
						LEFT JOIN ". MUSIC_RATE_TABLE ." AS r ON s.song_id = r.rate_song_id
						LEFT JOIN ". MUSIC_COMMENT_TABLE ." AS c ON s.song_id = c.comment_song_id
					WHERE song_id = '$song_id'
					GROUP BY s.song_id";
			if( !($result = $db->sql_query($sql)) )
			{
				mx_message_die(GENERAL_ERROR, 'Could not query song information', '', __LINE__, __FILE__, $sql);
			}
			$thissong = $db->sql_fetchrow($result);

			$cat_id = $thissong['song_cat_id'];
			$user_id = $thissong['song_user_id'];

			if ( $thissong['song_url'] == '' )
			{
				$song_filetype = substr($thissong['song_filename'], strlen($thissong['song_filename']) - 3, 3);
				$song_filename = ( !empty($thissong['song_filename']) ? $thissong['song_filename'] : '' );
			}
			else
			{
				$song_filetype = substr($thissong['song_url'], strlen($thissong['song_url']) - 3, 3);
				$song_url = $thissong['song_url'];
			}

			//
			// Media Center
			//
			if ( $song_filetype == 'swf' )
			{
				$template->assign_block_vars('songrow.flash', array());
				$url_download = append_sid(this_mo_mxurl("music_mode=music_download&song_id=$song_id"));
				$url_video = $url_download;
				$row_type = 'flash';
			}
			else if ( $song_filetype == 'ram' )
			{
				$template->assign_block_vars('songrow.ram', array());
				$url_download = append_sid(this_mo_mxurl("music_mode=music_download&song_id=$song_id"));
				$url_video = $url_download;
				$row_type = 'ram';
			}
			else if ( $song_filetype == '.rm' )
			{
				$template->assign_block_vars('songrow.rm', array());
				$url_download = append_sid(this_mo_mxurl("music_mode=music_download&song_id=$song_id"));
				$url_video = $url_download;
				$row_type = 'rm';
			}
			else if ( $song_filetype == '.qt' )
			{
				$template->assign_block_vars('songrow.qt', array());
				$url_download = append_sid(this_mo_mxurl("music_mode=music_download&song_id=$song_id"));
				$url_video = $url_download;
				$row_type = 'qt';
			}
			else if ( ( $song_filetype == '.jpg' ) || ( $song_filetype == '.gif' ) || ( $song_filetype == '.png' ) )
			{
				$url_download = !empty($thissong['song_url']) ? $thissong['song_url'] : append_sid(this_mo_mxurl("music_mode=music_download&song_id=$song_id"));
				$url_video = $url_download;
				$row_type = 'img';

				$template->assign_block_vars('songrow.img', array(
					'VIDEO_URL' => $url_video,
					'SONG_URL' => $url_video
				));
			}
			else if ( ( $song_filetype == 'jpg' ) || ( $song_filetype == 'gif' ) || ( $song_filetype == 'png' ) )
			{
				$url_download = !empty($thissong['song_url']) ? $thissong['song_url'] : append_sid(this_mo_mxurl("music_mode=music_download&song_id=$song_id"));
				$url_video = $url_download;
				$row_type = 'img';

				$template->assign_block_vars('songrow.img', array(
					'VIDEO_URL' => $url_video,
					'SONG_URL' => $url_video
				));
			}
			else if( ($song_filetype == 'pls') && !empty($thissong['song_url']) )
			{
				$template->assign_block_vars('songrow.media', array());
				$url_download = append_sid($module_root_path . 'galerie_media.' . $phpEx . '?music_mode=music_stream&song_id=' . $song_id);
				$lang['Download'] = ( !empty($lang['Listen']) ? $lang['Listen'] : 'Listen URL' );
				$url_video = $url_download;
				$row_type = 'media';
			}
			else if(!empty($thissong['song_url']))
			{
				$host = explode("//", $thissong['song_url']);
				$host = $host[1];
				$host = explode("/", $host);
				$domain = $host[0];
				$counthost = count($host) - 1;
				$docid2 = $host[$counthost];
			
				// $domaintmp = explode(".", $domain, -1); // Php 5 only
				// $sitename = implode(".", $domaintmp);

				if( !function_exists('mx_music_sitename') )
				{
					function mx_music_sitename($domain) {
					  $domaintmp = explode(".", $domain);
							
					  $y = count($domaintmp) - 1;
					  $r = "";
					  for ($a = 0; $y > $a; $a++) {
					  $r .= ".".$domaintmp[$a];
					  }
					  return $r;
					}
				}
			
				$sitename = substr(mx_music_sitename($domain), 1);

				if( !function_exists('mx_music_sitesufix') )
				{
					function mx_music_sitesufix($domain) {
				  	  $domaintmp = explode(".", $domain);
				
				  	  $y = count($domaintmp) - 1;
					  $r = $domaintmp[$y];;
					  return $r;
					}
				}
			
				$sitesufix = mx_music_sitesufix($domain);
			
				if (!empty($sitesufix) )
			 	{
					if ($sitesufix == 'de')
			 		{
						$sitelngprefix = 'de.';
					}
					else
			 		{
						$sitelngprefix = 'en.';
					}
				}
				else
			 	{
					$sitelngprefix = '';
				}
			
				if ($sitename == 'video.google')
				{
					$videoid['song_url'] = explode("-", $thissong['song_url']);
			
					if (empty($videoid['song_url'][1]) )
			 		{
						$docid['song_url'] = explode("?", $thissong['song_url']);
			
						if (empty($docid['song_url'][1]) )
			 			{
							$template->assign_block_vars('songrow.flashvideo', array());
							$url_video = ( !empty($docid['song_url'][1]) ? 'http://' . $domain . '/googleplayer.swf?' . $docid['song_url'][1] : $thissong['song_url'] );
							$url_download = ( !empty($docid['song_url'][1]) ? 'http://' . $domain . '/videoplay?' . $docid['song_url'][1] : $thissong['song_url'] );
							$lang['Download'] = ( !empty($lang['Share']) ? $lang['Share'] : 'Share URL' );
							$row_type = 'flashvideo';
						}
						else
			 			{
							$template->assign_block_vars('songrow.youtube', array());
							$url_video = ( !empty($docid['song_url'][1]) ? 'http://' . $domain . '/googleplayer.swf?' . $docid['song_url'][1] : $thissong['song_url'] );
							$url_download = ( !empty($docid['song_url'][1]) ? 'http://' . $domain . '/videoplay?' . $docid['song_url'][1] : $thissong['song_url'] );
							$lang['Download'] = ( !empty($lang['Share']) ? $lang['Watch'] : 'Watch URL' );
							$row_type = 'youtube';
						}
					}
					else
			 		{
						$template->assign_block_vars('songrow.youtube', array());
						$url_video = ( !empty($videoid['song_url'][1]) ? 'http://' . $domain . '/googleplayer.swf?docId=-' . $videoid['song_url'][1] : $thissong['song_url'] );
						$url_download = ( !empty($videoid['song_url'][1]) ? 'http://' . $domain . '/videoplay?docid=-' . $videoid['song_url'][1] : $thissong['song_url'] );
						$lang['Download'] = ( !empty($lang['Watch']) ? $lang['Watch'] : 'Watch URL' );
						$row_type = 'youtube';
					}	
				}
				else if ( ($sitename == 'www.youtube') || ($sitename == 'youtube') )
				{
					$videoid['song_url'] = explode("=", $thissong['song_url']);
			
					if (empty($videoid['song_url'][1]) )
			 		{
						$template->assign_block_vars('songrow.flashvideo', array());
						$row_type = 'flashvideo';
					}
					else
					{
						$template->assign_block_vars('songrow.youtube', array(
							'VIDEO_URL' => 'http://' . $domain . '/v/' . $videoid['song_url'][1],
							'SONG_URL' => $thissong['song_url']
						));
						$row_type = 'youtube';
					}
			
					$url_download = append_sid($thissong['song_url']);
					$lang['Download'] = ( !empty($lang['Share']) ? $lang['Share'] : 'Share URL' );
					$url_video = ( !empty($videoid['song_url'][1]) ? 'http://' . $domain . '/v/' . $videoid['song_url'][1] : $url_download );
				}
				else if ( ($sitename == 'www.clipfish') || ($sitename == 'clipfish') )
				{
					$thisvid['song_url'] = explode("videoid", $thissong['song_url']);
					$videoid['song_url'] = explode("=", $thisvid['song_url'][1]);
			
					if (empty($videoid['song_url'][1]) )
			 		{
						$template->assign_block_vars('songrow.flashvideo', array());
			
						$url_download = append_sid($thissong['song_url']);
						$lang['Download'] = ( !empty($lang['Direct_url']) ? $lang['Direct_url'] : 'Direct URL' );
						$url_video = $url_download;
						$row_type = 'flashvideo';
					}
					else
					{
						$template->assign_block_vars('songrow.youtube', array());
			
						$url_download = ( !empty($videoid['song_url'][1]) ? 'http://' . $domain . '/player.php?videoid=' . $videoid['song_url'][1] : $thissong['song_url'] );
						$lang['Download'] = ( !empty($lang['Watch']) ? $lang['Watch'] : 'Watch URL' );
						$url_video = ( !empty($videoid['song_url'][1]) ? 'http://' . $domain . '/videoplayer.swf?as=0&videoid=' . $videoid['song_url'][1] : $url_download );
						$row_type = 'youtube';
					}
			
				}
				else if ( ($sitename == 'www.myvideo') || ($sitename == 'myvideo') )
				{
					if (empty($docid2) )
			 		{
						$template->assign_block_vars('songrow.flashvideo', array());
			
						$url_download = append_sid($thissong['song_url']);
						$lang['Download'] = ( !empty($lang['Direct_url']) ? $lang['Direct_url'] : 'Direct URL' );
						$url_video = $url_download;
						$row_type = 'flashvideo';
					}
					else
					{
						$template->assign_block_vars('songrow.youtube', array());
			
						$url_download = ( !empty($docid2) ? 'http://' . $domain . '/watch/' . $docid2 : $thissong['song_url'] );
						$lang['Download'] = ( !empty($lang['Share']) ? $lang['Share'] : 'Share URL' );
						$url_video = ( !empty($docid2) ? 'http://' . $domain . '/movie/' . $docid2 : $url_download ); 
						$row_type = 'youtube';
					}
				}
				else if ( ($sitename == 'de.sevenload') || ($sitename == 'sevenload') || ($sitename...
 
[truncated message content]