diff options
| author | Karl 'vollmerk' Vollmer <vollmer@ampache.org> | 2005-07-09 07:49:59 +0000 |
|---|---|---|
| committer | Karl 'vollmerk' Vollmer <vollmer@ampache.org> | 2005-07-09 07:49:59 +0000 |
| commit | c5d6e04d114d3c4b3f31743ccd0d4a60c9ef9632 (patch) | |
| tree | bc3196cb97d63079013ebfc5b183d2038ee7c9e7 /lib/xmlrpc.php | |
| parent | c9170314af9139abef87629d218c7999bd3c8df3 (diff) | |
| download | ampache-c5d6e04d114d3c4b3f31743ccd0d4a60c9ef9632.tar.gz ampache-c5d6e04d114d3c4b3f31743ccd0d4a60c9ef9632.tar.bz2 ampache-c5d6e04d114d3c4b3f31743ccd0d4a60c9ef9632.zip | |
removed ID field from user table, and everything that goes with that...
Diffstat (limited to 'lib/xmlrpc.php')
| -rw-r--r-- | lib/xmlrpc.php | 2 |
1 files changed, 1 insertions, 1 deletions
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) ) { |