From c5d6e04d114d3c4b3f31743ccd0d4a60c9ef9632 Mon Sep 17 00:00:00 2001
From: Karl 'vollmerk' Vollmer <vollmer@ampache.org>
Date: Sat, 9 Jul 2005 07:49:59 +0000
Subject: removed ID field from user table, and everything that goes with
 that...

---
 lib/xmlrpc.php | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'lib/xmlrpc.php')

diff --git a/lib/xmlrpc.php b/lib/xmlrpc.php
index 63473dc6..a9d71bc7 100644
--- a/lib/xmlrpc.php
+++ b/lib/xmlrpc.php
@@ -41,7 +41,7 @@ function remote_server_query($m) {
         $result = array();
 
         // we only want to send the local entries
-        $sql = "SELECT name FROM catalog WHERE catalog_type='local'";
+        $sql = "SELECT name,COUNT(song.id) FROM catalog LEFT JOIN song ON catalog.id = song.catalog WHERE catalog_type='local' GROUP BY catalog.id";
 	$db_result = mysql_query($sql, dbh());
 
         while ( $i = mysql_fetch_row($db_result) ) {
-- 
cgit