################################################################################### 
## Hack Title:		Musikliste  
## Hack Version:	1.0.0 
## Hack Author:		Christian_N < N/A > (Christian Nchter) http://www.chantals-fanpage.de
## Hack Description:	Zeigt im Profil die Anzahl der Lieder und ein Link an, der zu eine Seite
##			weiterleitet nach einem klick darauf, wo auf dieser Seite dann alle 
##			Lieder von diesen Benutzer angezeigt werden.
##
##
## Installation Level:	VERY Easy
## Installation Time:	2 min
##
## Files to edit:	3
##			includes/usercp_viewprofile
##			language/lang_english/lang_main.php
##			templates/subSilver/profile_view_body.tpl
##
## Included Files:	
##			music_list.php
##			templates/subSilver/music_list_body.tpl
##
################################################################################ 
## The following site also contain the latest version of this MOD: 
## 
## http://www.amigalink.de/phpbb2/viewtopic.php?t=1276
## 
## No support for this MOD! 
## 
##  
##
################################################################################
## Author Notes:
##
##
## Tested with:
## - phpBB 2.0.22
## - Music Online Hack 2.0.6
## - PHP 5.2.3
## - MySQL 5.0.37 
## 
################################################################################ 
##
##
##   2007-10-13 - Version 1.0.0
##	- First Release
##
##
################################################################################ 
##  This hack is released under the GPL License. 
##  This hack can be freely used, but not distributed, without permission. 
##  Intellectual Property Rights are retained by the hack author(s) 
##  listed above. 
## 
################################################################################ 
## 
##  BEFORE ADDING THIS HACK TO YOUR FORUM, please be sure to backup ALL 
##  affected files. 
## 
#################################################################################
#
#-----[ COPY ]-------------------------------------------------------
#
COPY music_list.php TO the root
COPY temlates/subSilver/music_list_body.tpl TO temlates/subSilver/


#
#-----[ OPEN ]------------------------------------------ 
#  
includes/usercp_viewprofile.php

#
#-----[ FIND ]------------------------------------------
#
$profiledata = get_userdata($HTTP_GET_VARS[POST_USERS_URL]);

#
#-----[ AFTER, ADD ]------------------------------------
# 
// MOM Songs
   $sql = "SELECT song_username FROM " . $table_prefix.'music' . " WHERE song_username='".$profiledata['username']."' AND song_approval = 1"; 
	if ( !($query_result = $db->sql_query($sql)) )
	{
		message_die(GENERAL_ERROR, 'Could not obtain uploaded songs information', '', __LINE__, __FILE__, $sql);
	}
   $user_mom_songs = 0; 
   $user_mom_songs = $db->sql_numrows($query_result);
   if ( $user_mom_songs > 0 )
   {
	   $template->assign_block_vars('switch_uploaded_mom_songs', array());
   }
// MOM Songs


# 
#-----[ FIND ]------------------------------------------
# 
$temp_url = append_sid("search.$phpEx?search_author=" . urlencode($profiledata['username']) . "&amp;showresults=posts");
$search_img = '<a href="' . $temp_url . '"><img src="' . $images['icon_search'] . '" alt="' . sprintf($lang['Search_user_posts'], $profiledata['username']) . '" title="' . sprintf($lang['Search_user_posts'], $profiledata['username']) . '" border="0" /></a>';
$search = '<a href="' . $temp_url . '">' . sprintf($lang['Search_user_posts'], $profiledata['username']) . '</a>';

# 
#-----[ AFTER, ADD ]-------------------------------------
#
$temp_url = append_sid("music_list.$phpEx?user_id=" . $profiledata['user_id']);
$view_all_songs = '<a href="' . $temp_url . '">' . sprintf($lang['View_all_users_songs'], $profiledata['username']) . '</a>';


#
#-----[ FIND ]------------------------------------------
#

	'POSTS' => $profiledata['user_posts'],

#
#-----[ AFTER, ADD ]------------------------------------
#

	'UPLOADED_SONGS' => $user_mom_songs,
	'VIEW_ALL_SONGS' => $view_all_songs,

#
#-----[ FIND ]------------------------------------------
#

	'L_TOTAL_POSTS' => $lang['Total_posts'], 

#
#-----[ AFTER, ADD ]------------------------------------
#

	'L_UPLOADED_SONGS' => $lang['Songs_of_User'],

#
#-----[ OPEN ]------------------------------------------ 
#  
language/lang_english/lang_main.php

# 
#-----[ FIND ]------------------------------------------
# 
?>

# 
#-----[ BEFORE, ADD ]-------------------------------------
#
//
// Music list
//
$lang['Music_list'] = 'Music list';
$lang['View_all_users_songs'] = 'Find all songs by %s';
$lang['Songs_of_User'] = 'Songs';

#
#-----[ OPEN ]------------------------------------------ 
#  
templates/subSilver/profile_view_body.tpl

# 
#-----[ FIND ]------------------------------------------
# 
		<tr> 
		  <td valign="top" align="right" nowrap="nowrap"><span class="gen">{L_TOTAL_POSTS}:&nbsp;</span></td>
		  <td valign="top"><b><span class="gen">{POSTS}</span></b><br /><span class="genmed">[{POST_PERCENT_STATS} / {POST_DAY_STATS}]</span> <br /><span class="genmed"><a href="{U_SEARCH_USER}" class="genmed">{L_SEARCH_USER_POSTS}</a></span></td>
		</tr>

# 
#-----[ BEFORE, ADD ]-------------------------------------
#
		<!-- BEGIN switch_uploaded_mom_songs -->
		<tr> 
		  <td valign="top" align="right" nowrap="nowrap"><span class="gen">{L_UPLOADED_SONGS}:&nbsp;</span></td>
		  <td><b><span class="gen">{UPLOADED_SONGS}</span></b><br />
		  <span class="genmed">{VIEW_ALL_SONGS}</span></td>
		</tr>
		<!-- END switch_uploaded_mom_songs -->

#
#----------[ SAVE AND CLOSE ALL FILES ]-----------------
#
# EoM