From 344b7f548b2dd0510612478b7e5402a39a368026 Mon Sep 17 00:00:00 2001
From: Robin Appelman <icewind1991@gmail.com>
Date: Tue, 26 Jul 2011 22:21:28 +0200
Subject: [PATCH] only show songs for which the current user has songs indexed

---
 apps/media/ajax/api.php       |  2 ++
 apps/media/lib_collection.php | 23 +++++++++++++----------
 2 files changed, 15 insertions(+), 10 deletions(-)

diff --git a/apps/media/ajax/api.php b/apps/media/ajax/api.php
index bd18bb51b5c..0ccfb63f418 100644
--- a/apps/media/ajax/api.php
+++ b/apps/media/ajax/api.php
@@ -67,10 +67,12 @@ if($arguments['action']){
 			$artists=OC_MEDIA_COLLECTION::getArtists();
 			foreach($artists as &$artist){
 				$artist['albums']=OC_MEDIA_COLLECTION::getAlbums($artist['artist_id']);
+				$artistHasSongs=false;
 				foreach($artist['albums'] as &$album){
 					$album['songs']=OC_MEDIA_COLLECTION::getSongs($artist['artist_id'],$album['album_id']);
 				}
 			}
+			
 			echo json_encode($artists);
 			break;
 		case 'scan':
diff --git a/apps/media/lib_collection.php b/apps/media/lib_collection.php
index 7429379bcb1..6e2011675ad 100644
--- a/apps/media/lib_collection.php
+++ b/apps/media/lib_collection.php
@@ -123,13 +123,14 @@ class OC_MEDIA_COLLECTION{
 		if(!$exact and $search!='%'){
 			$search="%$search%";
 		}
-		$query=OC_DB::prepare("SELECT * FROM *PREFIX*media_artists WHERE artist_name LIKE ?");
-		$artists=$query->execute(array($search))->fetchAll();
-		if(is_array($artists)){
-			return $artists;
-		}else{
-			return array();
+		$query=OC_DB::prepare("SELECT DISTINCT *PREFIX*media_artists.artist_name AS name , *PREFIX*media_artists.artist_id AS id FROM *PREFIX*media_artists
+			INNER JOIN *PREFIX*media_songs ON *PREFIX*media_artists.artist_id=*PREFIX*media_songs.song_artist WHERE artist_name LIKE ? AND *PREFIX*media_songs.song_user=?");
+		$artists=$query->execute(array($search,OC_USER::getUser()))->fetchAll();
+		$result=array();
+		foreach($artists as $artist){
+			$result[$artist['id']]=array('artist_name'=>$artist['name'],'artist_id'=>$artist['id']);
 		}
+		return $result;
 	}
 	
 	/**
@@ -175,11 +176,13 @@ class OC_MEDIA_COLLECTION{
 		}
 		$query=OC_DB::prepare($cmd);
 		$albums=$query->execute($params)->fetchAll();
-		if(is_array($albums)){
-			return $albums;
-		}else{
-			return array();
+		$result=array();
+		foreach($albums as $album){
+			if(count(self::getSongs($album['album_artist'],$album['album_id']))){
+				$result[$album['album_id']]=$album;
+			}
 		}
+		return $result;
 	}
 	
 	/**
-- 
2.39.5